Query Metrics
23
Database Queries
15
Different statements
165.33 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.98 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 | 10.56 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 | 16.65 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.39 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 | 8.51 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.50 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 1.20 ms |
UPDATE boutique SET nombre_de_visite = ? WHERE id = ?
Parameters:
[ 18182 1 ] |
| 8 | 40.27 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.29 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.66 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.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.user_id IS NULL AND t0.boutique_id = ? AND t0.valeur_avis = ?
Parameters:
[ 1 3 ] |
| 13 | 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 4 ] |
| 14 | 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 5 ] |
| 15 | 20.70 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 | 17.34 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 | 0.40 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 | 10.53 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 | 4.25 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 | 4.95 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 | 7.37 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"
]
|
| 22 | 6.74 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:
[
491
]
|
| 23 | 3.19 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:
[
493
]
|
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. |