Query Metrics

21 Database Queries
15 Different statements
90.11 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.99 ms
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.push_notification_token AS push_notification_token_5, t0.adresse3_words AS adresse3_words_6, t0.solde AS solde_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.est_pro AS est_pro_10, t0.est_bloque AS est_bloque_11, t0.date_premium AS date_premium_12, t0.horaire_douverture AS horaire_douverture_13, t0.adresse_gpslat AS adresse_gpslat_14, t0.adresse_gpslong AS adresse_gpslong_15, t0.la_date AS la_date_16, t0.nombre_avis AS nombre_avis_17, t0.moyenne_avis AS moyenne_avis_18, t0.nom AS nom_19, t0.moyenne_note AS moyenne_note_20, t0.nombre_de_visite AS nombre_de_visite_21, t0.est_certifie AS est_certifie_22, t0.est_supprime AS est_supprime_23, t0.sigle AS sigle_24, t0.email AS email_25, t0.phone AS phone_26, t0.code_postal AS code_postal_27, t0.ville AS ville_28, t0.site_web AS site_web_29, t0.description AS description_30, t0.fax AS fax_31, t0.statut_juridique AS statut_juridique_32, t0.capital AS capital_33, t0.matricule AS matricule_34, t0.siret AS siret_35, t0.ape AS ape_36, t0.cc AS cc_37, t0.facture_tva AS facture_tva_38, t0.mention_legal AS mention_legal_39, t0.banque AS banque_40, t0.rib AS rib_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.annee AS annee_44, t0.mois AS mois_45, t0.qualification AS qualification_46, t0.disponibilite AS disponibilite_47, t0.gamme_de_prix AS gamme_de_prix_48, t0.main_d_oeuvre AS main_d_oeuvre_49, t0.zone_d_intervention AS zone_d_intervention_50, t0.user_id AS user_id_51, t0.categorie_entreprise_id AS categorie_entreprise_id_52, t0.logo_id AS logo_id_53, t0.video_presentation_id AS video_presentation_id_54, t0.cover_photo_id AS cover_photo_id_55, t0.settings_id AS settings_id_56, t0.pays_id AS pays_id_57 FROM boutique t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "fast-depannage"
]
2 0.46 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:
[
  1
]
3 6.19 ms
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.push_notification_token AS push_notification_token_5, t0.adresse3_words AS adresse3_words_6, t0.solde AS solde_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.est_pro AS est_pro_10, t0.est_bloque AS est_bloque_11, t0.date_premium AS date_premium_12, t0.horaire_douverture AS horaire_douverture_13, t0.adresse_gpslat AS adresse_gpslat_14, t0.adresse_gpslong AS adresse_gpslong_15, t0.la_date AS la_date_16, t0.nombre_avis AS nombre_avis_17, t0.moyenne_avis AS moyenne_avis_18, t0.nom AS nom_19, t0.moyenne_note AS moyenne_note_20, t0.nombre_de_visite AS nombre_de_visite_21, t0.est_certifie AS est_certifie_22, t0.est_supprime AS est_supprime_23, t0.sigle AS sigle_24, t0.email AS email_25, t0.phone AS phone_26, t0.code_postal AS code_postal_27, t0.ville AS ville_28, t0.site_web AS site_web_29, t0.description AS description_30, t0.fax AS fax_31, t0.statut_juridique AS statut_juridique_32, t0.capital AS capital_33, t0.matricule AS matricule_34, t0.siret AS siret_35, t0.ape AS ape_36, t0.cc AS cc_37, t0.facture_tva AS facture_tva_38, t0.mention_legal AS mention_legal_39, t0.banque AS banque_40, t0.rib AS rib_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.annee AS annee_44, t0.mois AS mois_45, t0.qualification AS qualification_46, t0.disponibilite AS disponibilite_47, t0.gamme_de_prix AS gamme_de_prix_48, t0.main_d_oeuvre AS main_d_oeuvre_49, t0.zone_d_intervention AS zone_d_intervention_50, t0.user_id AS user_id_51, t0.categorie_entreprise_id AS categorie_entreprise_id_52, t0.logo_id AS logo_id_53, t0.video_presentation_id AS video_presentation_id_54, t0.cover_photo_id AS cover_photo_id_55, t0.settings_id AS settings_id_56, t0.pays_id AS pays_id_57 FROM boutique t0 WHERE t0.est_bloque = ?
Parameters:
[
  0
]
4 9.35 ms
SELECT t0.slug_username AS slug_username_1, t0.id AS id_2, t0.email AS email_3, t0.mon_propre_code_promo AS mon_propre_code_promo_4, t0.code_promo_utilise AS code_promo_utilise_5, t0.push_notification_token AS push_notification_token_6, t0.email_token AS email_token_7, t0.token_expire_at AS token_expire_at_8, t0.casier_judiciaire AS casier_judiciaire_9, t0.piece_didentite_recto AS piece_didentite_recto_10, t0.piece_didentite_verso AS piece_didentite_verso_11, t0.username AS username_12, t0.roles AS roles_13, t0.password AS password_14, t0.nom AS nom_15, t0.prenom AS prenom_16, t0.code AS code_17, t0.sexe AS sexe_18, t0.est_supprime AS est_supprime_19, t0.telephone AS telephone_20, t0.adresse AS adresse_21, t0.type_compte AS type_compte_22, t0.nom_complet AS nom_complet_23, t0.mois AS mois_24, t0.annee AS annee_25, t0.nombre_avis AS nombre_avis_26, t0.created_at AS created_at_27, t0.qualification AS qualification_28, t0.description AS description_29, t0.disponibilite AS disponibilite_30, t0.enabled AS enabled_31, t0.gamme_de_prix AS gamme_de_prix_32, t0.main_d_oeuvre AS main_d_oeuvre_33, t0.zone_d_intervention AS zone_d_intervention_34, t0.domaine_d_activite AS domaine_d_activite_35, t0.est_embassadeur AS est_embassadeur_36, t0.avatar_id AS avatar_id_37 FROM app_user t0
Parameters:
[]
5 18.57 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:
[
  1
]
6 0.13 ms
"START TRANSACTION"
Parameters:
[]
7 0.27 ms
UPDATE boutique SET nombre_de_visite = ? WHERE id = ?
Parameters:
[
  18160
  1
]
8 18.53 ms
"COMMIT"
Parameters:
[]
9 0.24 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:
[
  1
]
10 0.27 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:
[
  1
  1
]
11 0.18 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:
[
  1
  2
]
12 0.18 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:
[
  1
  3
]
13 0.17 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:
[
  1
  4
]
14 0.17 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:
[
  1
  5
]
15 0.39 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.full_url AS full_url_3, t0.alt AS alt_4, t0.date_ajout AS date_ajout_5, t0.est_valide AS est_valide_6 FROM photo t0 WHERE t0.id = ?
Parameters:
[
  5
]
16 0.54 ms
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.push_notification_token AS push_notification_token_5, t0.adresse3_words AS adresse3_words_6, t0.solde AS solde_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.est_pro AS est_pro_10, t0.est_bloque AS est_bloque_11, t0.date_premium AS date_premium_12, t0.horaire_douverture AS horaire_douverture_13, t0.adresse_gpslat AS adresse_gpslat_14, t0.adresse_gpslong AS adresse_gpslong_15, t0.la_date AS la_date_16, t0.nombre_avis AS nombre_avis_17, t0.moyenne_avis AS moyenne_avis_18, t0.nom AS nom_19, t0.moyenne_note AS moyenne_note_20, t0.nombre_de_visite AS nombre_de_visite_21, t0.est_certifie AS est_certifie_22, t0.est_supprime AS est_supprime_23, t0.sigle AS sigle_24, t0.email AS email_25, t0.phone AS phone_26, t0.code_postal AS code_postal_27, t0.ville AS ville_28, t0.site_web AS site_web_29, t0.description AS description_30, t0.fax AS fax_31, t0.statut_juridique AS statut_juridique_32, t0.capital AS capital_33, t0.matricule AS matricule_34, t0.siret AS siret_35, t0.ape AS ape_36, t0.cc AS cc_37, t0.facture_tva AS facture_tva_38, t0.mention_legal AS mention_legal_39, t0.banque AS banque_40, t0.rib AS rib_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.annee AS annee_44, t0.mois AS mois_45, t0.qualification AS qualification_46, t0.disponibilite AS disponibilite_47, t0.gamme_de_prix AS gamme_de_prix_48, t0.main_d_oeuvre AS main_d_oeuvre_49, t0.zone_d_intervention AS zone_d_intervention_50, t0.user_id AS user_id_51, t0.categorie_entreprise_id AS categorie_entreprise_id_52, t0.logo_id AS logo_id_53, t0.video_presentation_id AS video_presentation_id_54, t0.cover_photo_id AS cover_photo_id_55, t0.settings_id AS settings_id_56, t0.pays_id AS pays_id_57 FROM boutique t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
17 17.70 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:
[
  2
]
18 0.46 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:
[]
19 6.55 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.full_url AS full_url_3, t0.alt AS alt_4, t0.date_ajout AS date_ajout_5, t0.est_valide AS est_valide_6, t0.produit_id AS produit_id_7 FROM product_photo t0 WHERE t0.id = ?
Parameters:
[
  19
]
20 2.62 ms
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.push_notification_token AS push_notification_token_5, t0.adresse3_words AS adresse3_words_6, t0.solde AS solde_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.est_pro AS est_pro_10, t0.est_bloque AS est_bloque_11, t0.date_premium AS date_premium_12, t0.horaire_douverture AS horaire_douverture_13, t0.adresse_gpslat AS adresse_gpslat_14, t0.adresse_gpslong AS adresse_gpslong_15, t0.la_date AS la_date_16, t0.nombre_avis AS nombre_avis_17, t0.moyenne_avis AS moyenne_avis_18, t0.nom AS nom_19, t0.moyenne_note AS moyenne_note_20, t0.nombre_de_visite AS nombre_de_visite_21, t0.est_certifie AS est_certifie_22, t0.est_supprime AS est_supprime_23, t0.sigle AS sigle_24, t0.email AS email_25, t0.phone AS phone_26, t0.code_postal AS code_postal_27, t0.ville AS ville_28, t0.site_web AS site_web_29, t0.description AS description_30, t0.fax AS fax_31, t0.statut_juridique AS statut_juridique_32, t0.capital AS capital_33, t0.matricule AS matricule_34, t0.siret AS siret_35, t0.ape AS ape_36, t0.cc AS cc_37, t0.facture_tva AS facture_tva_38, t0.mention_legal AS mention_legal_39, t0.banque AS banque_40, t0.rib AS rib_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.annee AS annee_44, t0.mois AS mois_45, t0.qualification AS qualification_46, t0.disponibilite AS disponibilite_47, t0.gamme_de_prix AS gamme_de_prix_48, t0.main_d_oeuvre AS main_d_oeuvre_49, t0.zone_d_intervention AS zone_d_intervention_50, t0.user_id AS user_id_51, t0.categorie_entreprise_id AS categorie_entreprise_id_52, t0.logo_id AS logo_id_53, t0.video_presentation_id AS video_presentation_id_54, t0.cover_photo_id AS cover_photo_id_55, t0.settings_id AS settings_id_56, t0.pays_id AS pays_id_57 FROM boutique t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "fast-depannage"
]
21 6.14 ms
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.push_notification_token AS push_notification_token_5, t0.adresse3_words AS adresse3_words_6, t0.solde AS solde_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.est_pro AS est_pro_10, t0.est_bloque AS est_bloque_11, t0.date_premium AS date_premium_12, t0.horaire_douverture AS horaire_douverture_13, t0.adresse_gpslat AS adresse_gpslat_14, t0.adresse_gpslong AS adresse_gpslong_15, t0.la_date AS la_date_16, t0.nombre_avis AS nombre_avis_17, t0.moyenne_avis AS moyenne_avis_18, t0.nom AS nom_19, t0.moyenne_note AS moyenne_note_20, t0.nombre_de_visite AS nombre_de_visite_21, t0.est_certifie AS est_certifie_22, t0.est_supprime AS est_supprime_23, t0.sigle AS sigle_24, t0.email AS email_25, t0.phone AS phone_26, t0.code_postal AS code_postal_27, t0.ville AS ville_28, t0.site_web AS site_web_29, t0.description AS description_30, t0.fax AS fax_31, t0.statut_juridique AS statut_juridique_32, t0.capital AS capital_33, t0.matricule AS matricule_34, t0.siret AS siret_35, t0.ape AS ape_36, t0.cc AS cc_37, t0.facture_tva AS facture_tva_38, t0.mention_legal AS mention_legal_39, t0.banque AS banque_40, t0.rib AS rib_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.annee AS annee_44, t0.mois AS mois_45, t0.qualification AS qualification_46, t0.disponibilite AS disponibilite_47, t0.gamme_de_prix AS gamme_de_prix_48, t0.main_d_oeuvre AS main_d_oeuvre_49, t0.zone_d_intervention AS zone_d_intervention_50, t0.user_id AS user_id_51, t0.categorie_entreprise_id AS categorie_entreprise_id_52, t0.logo_id AS logo_id_53, t0.video_presentation_id AS video_presentation_id_54, t0.cover_photo_id AS cover_photo_id_55, t0.settings_id AS settings_id_56, t0.pays_id AS pays_id_57 FROM boutique t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "fast-depannage"
]

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.
App\Entity\Message No errors.
App\Entity\Conversation No errors.