Query Metrics

18 Database Queries
14 Different statements
47.97 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.11 ms
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.adresse AS adresse_3, t0.adresse3_words AS adresse3_words_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.est_pro AS est_pro_7, t0.est_bloque AS est_bloque_8, t0.date_premium AS date_premium_9, t0.horaire_douverture AS horaire_douverture_10, t0.adresse_gpslat AS adresse_gpslat_11, t0.adresse_gpslong AS adresse_gpslong_12, t0.la_date AS la_date_13, t0.nombre_avis AS nombre_avis_14, t0.moyenne_avis AS moyenne_avis_15, t0.nom AS nom_16, t0.moyenne_note AS moyenne_note_17, t0.nombre_de_visite AS nombre_de_visite_18, t0.est_certifie AS est_certifie_19, t0.est_supprime AS est_supprime_20, t0.sigle AS sigle_21, t0.email AS email_22, t0.phone AS phone_23, t0.code_postal AS code_postal_24, t0.ville AS ville_25, t0.site_web AS site_web_26, t0.description AS description_27, t0.fax AS fax_28, t0.statut_juridique AS statut_juridique_29, t0.capital AS capital_30, t0.matricule AS matricule_31, t0.siret AS siret_32, t0.ape AS ape_33, t0.cc AS cc_34, t0.facture_tva AS facture_tva_35, t0.mention_legal AS mention_legal_36, t0.banque AS banque_37, t0.rib AS rib_38, t0.iban AS iban_39, t0.bic AS bic_40, t0.annee AS annee_41, t0.mois AS mois_42, t0.qualification AS qualification_43, t0.disponibilite AS disponibilite_44, t0.gamme_de_prix AS gamme_de_prix_45, t0.main_d_oeuvre AS main_d_oeuvre_46, t0.zone_d_intervention AS zone_d_intervention_47, t0.user_id AS user_id_48, t0.categorie_entreprise_id AS categorie_entreprise_id_49, t0.logo_id AS logo_id_50, t0.video_presentation_id AS video_presentation_id_51, t0.cover_photo_id AS cover_photo_id_52, t0.settings_id AS settings_id_53, t0.pays_id AS pays_id_54 FROM boutique t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "perfect-infographie-2"
]
2 0.40 ms
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.name AS name_3, t0.petite_info AS petite_info_4, t0.prix AS prix_5, t0.ancien_prix AS ancien_prix_6, t0.description AS description_7, t0.stock_disponible AS stock_disponible_8, t0.stock_minimum AS stock_minimum_9, t0.stock_de_securite AS stock_de_securite_10, t0.stock_dalerte AS stock_dalerte_11, t0.stock_outil AS stock_outil_12, t0.stock_maximum AS stock_maximum_13, t0.cout_de_stockage AS cout_de_stockage_14, t0.boutique_id AS boutique_id_15, t0.image_principale_id AS image_principale_id_16 FROM produit t0 WHERE t0.boutique_id = ?
Parameters:
[
  2
]
3 0.97 ms
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.adresse AS adresse_3, t0.adresse3_words AS adresse3_words_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.est_pro AS est_pro_7, t0.est_bloque AS est_bloque_8, t0.date_premium AS date_premium_9, t0.horaire_douverture AS horaire_douverture_10, t0.adresse_gpslat AS adresse_gpslat_11, t0.adresse_gpslong AS adresse_gpslong_12, t0.la_date AS la_date_13, t0.nombre_avis AS nombre_avis_14, t0.moyenne_avis AS moyenne_avis_15, t0.nom AS nom_16, t0.moyenne_note AS moyenne_note_17, t0.nombre_de_visite AS nombre_de_visite_18, t0.est_certifie AS est_certifie_19, t0.est_supprime AS est_supprime_20, t0.sigle AS sigle_21, t0.email AS email_22, t0.phone AS phone_23, t0.code_postal AS code_postal_24, t0.ville AS ville_25, t0.site_web AS site_web_26, t0.description AS description_27, t0.fax AS fax_28, t0.statut_juridique AS statut_juridique_29, t0.capital AS capital_30, t0.matricule AS matricule_31, t0.siret AS siret_32, t0.ape AS ape_33, t0.cc AS cc_34, t0.facture_tva AS facture_tva_35, t0.mention_legal AS mention_legal_36, t0.banque AS banque_37, t0.rib AS rib_38, t0.iban AS iban_39, t0.bic AS bic_40, t0.annee AS annee_41, t0.mois AS mois_42, t0.qualification AS qualification_43, t0.disponibilite AS disponibilite_44, t0.gamme_de_prix AS gamme_de_prix_45, t0.main_d_oeuvre AS main_d_oeuvre_46, t0.zone_d_intervention AS zone_d_intervention_47, t0.user_id AS user_id_48, t0.categorie_entreprise_id AS categorie_entreprise_id_49, t0.logo_id AS logo_id_50, t0.video_presentation_id AS video_presentation_id_51, t0.cover_photo_id AS cover_photo_id_52, t0.settings_id AS settings_id_53, t0.pays_id AS pays_id_54 FROM boutique t0 WHERE t0.est_bloque = ?
Parameters:
[
  0
]
4 0.96 ms
SELECT t0.slug_username AS slug_username_1, t0.id AS id_2, t0.email AS email_3, t0.email_token AS email_token_4, t0.username AS username_5, t0.roles AS roles_6, t0.password AS password_7, t0.nom AS nom_8, t0.code AS code_9, t0.nom_pere AS nom_pere_10, t0.nom_mere AS nom_mere_11, t0.lieu_de_naissance AS lieu_de_naissance_12, t0.date_naissance AS date_naissance_13, t0.inscrit_le AS inscrit_le_14, t0.date_fin_scolarite AS date_fin_scolarite_15, t0.numero_jugement_suppletif AS numero_jugement_suppletif_16, t0.date_jugement_suppletif AS date_jugement_suppletif_17, t0.numero_extrait AS numero_extrait_18, t0.date_extrait AS date_extrait_19, t0.prenom AS prenom_20, t0.sexe AS sexe_21, t0.nationalite AS nationalite_22, t0.matricule_national AS matricule_national_23, t0.est_etudiant AS est_etudiant_24, t0.matriculeInterne AS matriculeInterne_25, t0.est_supprime AS est_supprime_26, t0.telephone AS telephone_27, t0.adresse AS adresse_28, t0.type_compte AS type_compte_29, t0.nom_complet AS nom_complet_30, t0.mois AS mois_31, t0.annee AS annee_32, t0.nombre_avis AS nombre_avis_33, t0.created_at AS created_at_34, t0.qualification AS qualification_35, t0.description AS description_36, t0.disponibilite AS disponibilite_37, t0.enabled AS enabled_38, t0.gamme_de_prix AS gamme_de_prix_39, t0.main_d_oeuvre AS main_d_oeuvre_40, t0.zone_d_intervention AS zone_d_intervention_41, t0.domaine_d_activite AS domaine_d_activite_42, t0.est_embassadeur AS est_embassadeur_43, t0.avatar_id AS avatar_id_44 FROM app_user t0
Parameters:
[]
5 0.28 ms
SELECT t0.id AS id_1, t0.la_date AS la_date_2, t0.valeur_avis AS valeur_avis_3, t0.avis_utile AS avis_utile_4, t0.avis_inutile AS avis_inutile_5, t0.signaler_avis AS signaler_avis_6, t0.contenu AS contenu_7, t0.reponse_avis AS reponse_avis_8, t0.boutique_id AS boutique_id_9, t0.user_id AS user_id_10 FROM avis_utilisateur t0 WHERE t0.boutique_id = ?
Parameters:
[
  2
]
6 0.11 ms
"START TRANSACTION"
Parameters:
[]
7 0.25 ms
UPDATE boutique SET nombre_de_visite = ? WHERE id = ?
Parameters:
[
  310
  2
]
8 39.74 ms
"COMMIT"
Parameters:
[]
9 0.29 ms
SELECT t0.role AS role_1, t0.accepte AS accepte_2, t0.boutique_id AS boutique_id_3, t0.user_id AS user_id_4 FROM user_boutique t0 WHERE t0.boutique_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters:
[
  2
]
10 0.43 ms
SELECT t0.id AS id_1, t0.la_date AS la_date_2, t0.valeur_avis AS valeur_avis_3, t0.avis_utile AS avis_utile_4, t0.avis_inutile AS avis_inutile_5, t0.signaler_avis AS signaler_avis_6, t0.contenu AS contenu_7, t0.reponse_avis AS reponse_avis_8, t0.boutique_id AS boutique_id_9, t0.user_id AS user_id_10 FROM avis_utilisateur t0 WHERE t0.user_id IS NULL AND t0.boutique_id = ? AND t0.valeur_avis = ?
Parameters:
[
  2
  1
]
11 0.41 ms
SELECT t0.id AS id_1, t0.la_date AS la_date_2, t0.valeur_avis AS valeur_avis_3, t0.avis_utile AS avis_utile_4, t0.avis_inutile AS avis_inutile_5, t0.signaler_avis AS signaler_avis_6, t0.contenu AS contenu_7, t0.reponse_avis AS reponse_avis_8, t0.boutique_id AS boutique_id_9, t0.user_id AS user_id_10 FROM avis_utilisateur t0 WHERE t0.user_id IS NULL AND t0.boutique_id = ? AND t0.valeur_avis = ?
Parameters:
[
  2
  2
]
12 0.40 ms
SELECT t0.id AS id_1, t0.la_date AS la_date_2, t0.valeur_avis AS valeur_avis_3, t0.avis_utile AS avis_utile_4, t0.avis_inutile AS avis_inutile_5, t0.signaler_avis AS signaler_avis_6, t0.contenu AS contenu_7, t0.reponse_avis AS reponse_avis_8, t0.boutique_id AS boutique_id_9, t0.user_id AS user_id_10 FROM avis_utilisateur t0 WHERE t0.user_id IS NULL AND t0.boutique_id = ? AND t0.valeur_avis = ?
Parameters:
[
  2
  3
]
13 0.42 ms
SELECT t0.id AS id_1, t0.la_date AS la_date_2, t0.valeur_avis AS valeur_avis_3, t0.avis_utile AS avis_utile_4, t0.avis_inutile AS avis_inutile_5, t0.signaler_avis AS signaler_avis_6, t0.contenu AS contenu_7, t0.reponse_avis AS reponse_avis_8, t0.boutique_id AS boutique_id_9, t0.user_id AS user_id_10 FROM avis_utilisateur t0 WHERE t0.user_id IS NULL AND t0.boutique_id = ? AND t0.valeur_avis = ?
Parameters:
[
  2
  4
]
14 0.40 ms
SELECT t0.id AS id_1, t0.la_date AS la_date_2, t0.valeur_avis AS valeur_avis_3, t0.avis_utile AS avis_utile_4, t0.avis_inutile AS avis_inutile_5, t0.signaler_avis AS signaler_avis_6, t0.contenu AS contenu_7, t0.reponse_avis AS reponse_avis_8, t0.boutique_id AS boutique_id_9, t0.user_id AS user_id_10 FROM avis_utilisateur t0 WHERE t0.user_id IS NULL AND t0.boutique_id = ? AND t0.valeur_avis = ?
Parameters:
[
  2
  5
]
15 0.37 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.date_ajout AS date_ajout_4, t0.est_valide AS est_valide_5 FROM photo t0 WHERE t0.id = ?
Parameters:
[
  7
]
16 0.59 ms
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.adresse AS adresse_3, t0.adresse3_words AS adresse3_words_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.est_pro AS est_pro_7, t0.est_bloque AS est_bloque_8, t0.date_premium AS date_premium_9, t0.horaire_douverture AS horaire_douverture_10, t0.adresse_gpslat AS adresse_gpslat_11, t0.adresse_gpslong AS adresse_gpslong_12, t0.la_date AS la_date_13, t0.nombre_avis AS nombre_avis_14, t0.moyenne_avis AS moyenne_avis_15, t0.nom AS nom_16, t0.moyenne_note AS moyenne_note_17, t0.nombre_de_visite AS nombre_de_visite_18, t0.est_certifie AS est_certifie_19, t0.est_supprime AS est_supprime_20, t0.sigle AS sigle_21, t0.email AS email_22, t0.phone AS phone_23, t0.code_postal AS code_postal_24, t0.ville AS ville_25, t0.site_web AS site_web_26, t0.description AS description_27, t0.fax AS fax_28, t0.statut_juridique AS statut_juridique_29, t0.capital AS capital_30, t0.matricule AS matricule_31, t0.siret AS siret_32, t0.ape AS ape_33, t0.cc AS cc_34, t0.facture_tva AS facture_tva_35, t0.mention_legal AS mention_legal_36, t0.banque AS banque_37, t0.rib AS rib_38, t0.iban AS iban_39, t0.bic AS bic_40, t0.annee AS annee_41, t0.mois AS mois_42, t0.qualification AS qualification_43, t0.disponibilite AS disponibilite_44, t0.gamme_de_prix AS gamme_de_prix_45, t0.main_d_oeuvre AS main_d_oeuvre_46, t0.zone_d_intervention AS zone_d_intervention_47, t0.user_id AS user_id_48, t0.categorie_entreprise_id AS categorie_entreprise_id_49, t0.logo_id AS logo_id_50, t0.video_presentation_id AS video_presentation_id_51, t0.cover_photo_id AS cover_photo_id_52, t0.settings_id AS settings_id_53, t0.pays_id AS pays_id_54 FROM boutique t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  2
]
17 0.47 ms
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.nom AS nom_3, t0.nombre_element AS nombre_element_4, t0.description AS description_5, t0.phrase_d_appel AS phrase_d_appel_6, t0.est_supprime AS est_supprime_7, t0.image_id AS image_id_8 FROM categorie_entreprise t0 WHERE t0.id = ?
Parameters:
[
  1
]
18 0.37 ms
SELECT c0_.slug AS slug_0, c0_.id AS id_1, c0_.nom AS nom_2, c0_.nombre_element AS nombre_element_3, c0_.description AS description_4, c0_.phrase_d_appel AS phrase_d_appel_5, c0_.est_supprime AS est_supprime_6, c0_.image_id AS image_id_7 FROM categorie_entreprise c0_
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Boutique No errors.
App\Entity\AppUser No errors.
App\Entity\CategorieEntreprise No errors.
App\Entity\Photo No errors.
App\Entity\Settings No errors.
App\Entity\Pays No errors.
App\Entity\Produit No errors.
App\Entity\ProductPhoto No errors.
App\Entity\AvisUtilisateur No errors.
App\Entity\ImageArticleBlog No errors.
App\Entity\UserBoutique No errors.
App\Entity\Devis No errors.