Query Metrics
23
Database Queries
17
Different statements
19.69 ms
Query time
0
Invalid entities
284
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.70 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.code AS code_4, t0.est_publie AS est_publie_5, t0.est_metier AS est_metier_6 FROM front_page t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"home"
]
|
| 2 | 0.31 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_electre AS nom_electre_3, t0.couleur AS couleur_4, t0.ordre AS ordre_5, t0.slug AS slug_6, t0.old_id AS old_id_7, t0.color1 AS color1_8, t0.color2 AS color2_9, t0.parent_id AS parent_id_10 FROM genre t0 ORDER BY t0.ordre ASC
Parameters:
[] |
| 3 | 1.11 ms |
SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.roles AS roles_3, t0.email AS email_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.password AS password_9, t0.enabled AS enabled_10, t0.date_creation AS date_creation_11, t0.token_api AS token_api_12, t13.id AS id_14, t13.nom AS nom_15, t13.prenom AS prenom_16, t13.telephone AS telephone_17, t13.code_abomarque AS code_abomarque_18, t13.commentaire AS commentaire_19, t13.facebook AS facebook_20, t13.twitter AS twitter_21, t13.email AS email_22, t13.old_id AS old_id_23, t13.civilite AS civilite_24, t13.old_userid AS old_userid_25, t13.actif AS actif_26, t13.bio AS bio_27, t13.has_photo AS has_photo_28, t13.is_referent AS is_referent_29, t13.date_creation AS date_creation_30, t13.receive_nmardi AS receive_nmardi_31, t13.receive_nvendredi AS receive_nvendredi_32, t13.receive_ireseau AS receive_ireseau_33, t13.structure_id AS structure_id_34, t13.adresse_id AS adresse_id_35, t13.utilisateur_id AS utilisateur_id_36, t13.news_contact_id AS news_contact_id_37, t0.client_id AS client_id_38 FROM user t0 LEFT JOIN contact t13 ON t13.utilisateur_id = t0.id WHERE t0.id = ?
Parameters:
[
7819
]
|
| 4 | 0.94 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.email AS email_4, t0.code_abomarque AS code_abomarque_5, t0.compte_cegid AS compte_cegid_6, t0.tvaintra AS tvaintra_7, t0.exonere_tva AS exonere_tva_8, t0.facebook AS facebook_9, t0.twitter AS twitter_10, t0.site_web AS site_web_11, t0.logo_accueil AS logo_accueil_12, t0.editeur_poche AS editeur_poche_13, t0.alias_electre AS alias_electre_14, t0.sarch_id AS sarch_id_15, t0.type_actif AS type_actif_16, t0.logo AS logo_17, t0.is_referent AS is_referent_18, t0.est_abonne AS est_abonne_19, t0.date_creation AS date_creation_20, t0.siret AS siret_21, t0.zone_geo AS zone_geo_22, t0.type_id AS type_id_23, t0.departement_id AS departement_id_24, t0.region_id AS region_id_25, t26.id AS id_27, t26.sujet AS sujet_28, t26.nom_exp AS nom_exp_29, t26.email_exp AS email_exp_30, t26.nom_retour AS nom_retour_31, t26.email_retour AS email_retour_32, t26.structure_id AS structure_id_33 FROM structure t0 LEFT JOIN client_cle_en_main t26 ON t26.structure_id = t0.id WHERE t0.id = ?
Parameters:
[
5730
]
|
| 5 | 0.28 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.old_id AS old_id_3, t0.type_espace_pro_id AS type_espace_pro_id_4 FROM type_structure t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 6 | 0.58 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3 FROM type_espace_pro t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 7 | 0.36 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.is_actif AS is_actif_6, t0.nom AS nom_7, t0.slug AS slug_8, t0.categorie AS categorie_9, t10.id AS id_11, t10.titre AS titre_12, t10.texte_explicatif AS texte_explicatif_13, t10.actif AS actif_14, t10.date AS date_15, t10.slug AS slug_16, t10.lieu AS lieu_17, t10.repartition_pro AS repartition_pro_18, t10.nb_max_peronnes AS nb_max_peronnes_19, t10.critere_inscrit AS critere_inscrit_20, t10.lib_contenu AS lib_contenu_21, t10.bib_abonnee AS bib_abonnee_22, t10.lib_dif AS lib_dif_23, t10.type_jp AS type_jp_24, t10.heure_debut AS heure_debut_25, t10.heure_fin AS heure_fin_26, t10.image_badge AS image_badge_27, t10.display_corner_editeur AS display_corner_editeur_28, t10.illustration AS illustration_29, t10.video AS video_30, t10.programme AS programme_31, t10.livret AS livret_32, t10.active_chapitrage AS active_chapitrage_33, t10.chapitrage_category AS chapitrage_category_34, t10.date_badge AS date_badge_35, t10.page_id AS page_id_36 FROM page t0 LEFT JOIN journee_pro t10 ON t10.page_id = t0.id WHERE t0.type = ? AND t0.is_actif = ?
Parameters:
[ "front_metier" 1 ] |
| 8 | 5.30 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.is_actif AS is_actif_6, t0.nom AS nom_7, t0.slug AS slug_8, t0.categorie AS categorie_9, t10.id AS id_11, t10.titre AS titre_12, t10.texte_explicatif AS texte_explicatif_13, t10.actif AS actif_14, t10.date AS date_15, t10.slug AS slug_16, t10.lieu AS lieu_17, t10.repartition_pro AS repartition_pro_18, t10.nb_max_peronnes AS nb_max_peronnes_19, t10.critere_inscrit AS critere_inscrit_20, t10.lib_contenu AS lib_contenu_21, t10.bib_abonnee AS bib_abonnee_22, t10.lib_dif AS lib_dif_23, t10.type_jp AS type_jp_24, t10.heure_debut AS heure_debut_25, t10.heure_fin AS heure_fin_26, t10.image_badge AS image_badge_27, t10.display_corner_editeur AS display_corner_editeur_28, t10.illustration AS illustration_29, t10.video AS video_30, t10.programme AS programme_31, t10.livret AS livret_32, t10.active_chapitrage AS active_chapitrage_33, t10.chapitrage_category AS chapitrage_category_34, t10.date_badge AS date_badge_35, t10.page_id AS page_id_36 FROM page t0 LEFT JOIN journee_pro t10 ON t10.page_id = t0.id WHERE t0.type = ?
Parameters:
[
"front"
]
|
| 9 | 0.35 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.is_actif AS is_actif_6, t0.nom AS nom_7, t0.slug AS slug_8, t0.categorie AS categorie_9, t10.id AS id_11, t10.titre AS titre_12, t10.texte_explicatif AS texte_explicatif_13, t10.actif AS actif_14, t10.date AS date_15, t10.slug AS slug_16, t10.lieu AS lieu_17, t10.repartition_pro AS repartition_pro_18, t10.nb_max_peronnes AS nb_max_peronnes_19, t10.critere_inscrit AS critere_inscrit_20, t10.lib_contenu AS lib_contenu_21, t10.bib_abonnee AS bib_abonnee_22, t10.lib_dif AS lib_dif_23, t10.type_jp AS type_jp_24, t10.heure_debut AS heure_debut_25, t10.heure_fin AS heure_fin_26, t10.image_badge AS image_badge_27, t10.display_corner_editeur AS display_corner_editeur_28, t10.illustration AS illustration_29, t10.video AS video_30, t10.programme AS programme_31, t10.livret AS livret_32, t10.active_chapitrage AS active_chapitrage_33, t10.chapitrage_category AS chapitrage_category_34, t10.date_badge AS date_badge_35, t10.page_id AS page_id_36 FROM page t0 LEFT JOIN journee_pro t10 ON t10.page_id = t0.id WHERE t0.type = ? AND t0.is_actif = ?
Parameters:
[ "front_metier" 1 ] |
| 10 | 5.15 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.is_actif AS is_actif_6, t0.nom AS nom_7, t0.slug AS slug_8, t0.categorie AS categorie_9, t10.id AS id_11, t10.titre AS titre_12, t10.texte_explicatif AS texte_explicatif_13, t10.actif AS actif_14, t10.date AS date_15, t10.slug AS slug_16, t10.lieu AS lieu_17, t10.repartition_pro AS repartition_pro_18, t10.nb_max_peronnes AS nb_max_peronnes_19, t10.critere_inscrit AS critere_inscrit_20, t10.lib_contenu AS lib_contenu_21, t10.bib_abonnee AS bib_abonnee_22, t10.lib_dif AS lib_dif_23, t10.type_jp AS type_jp_24, t10.heure_debut AS heure_debut_25, t10.heure_fin AS heure_fin_26, t10.image_badge AS image_badge_27, t10.display_corner_editeur AS display_corner_editeur_28, t10.illustration AS illustration_29, t10.video AS video_30, t10.programme AS programme_31, t10.livret AS livret_32, t10.active_chapitrage AS active_chapitrage_33, t10.chapitrage_category AS chapitrage_category_34, t10.date_badge AS date_badge_35, t10.page_id AS page_id_36 FROM page t0 LEFT JOIN journee_pro t10 ON t10.page_id = t0.id WHERE t0.type = ?
Parameters:
[
"front"
]
|
| 11 | 1.19 ms |
SELECT n0_.id AS id_0, n0_.titre AS titre_1, n0_.texte_court AS texte_court_2, n0_.date_publication AS date_publication_3, n0_.date_fin AS date_fin_4, n0_.type_notification AS type_notification_5, n0_.declencheur AS declencheur_6, n0_.bouton_texte AS bouton_texte_7, n0_.bouton_route AS bouton_route_8, n0_.bouton_url AS bouton_url_9, n0_.bouton_style AS bouton_style_10, n0_.actif AS actif_11, n0_.date_creation AS date_creation_12, n0_.date_modification AS date_modification_13, n0_.cree_par AS cree_par_14, n0_.modifie_par AS modifie_par_15 FROM notification n0_ LEFT JOIN notification_type_structure n2_ ON n0_.id = n2_.notification_id LEFT JOIN type_structure t1_ ON t1_.id = n2_.type_structure_id WHERE n0_.actif = ? AND n0_.date_publication <= ? AND (n0_.date_fin IS NULL OR n0_.date_fin >= ?) AND (t1_.id IS NULL OR t1_.id = ?) ORDER BY n0_.date_publication DESC
Parameters:
[ 1 "2026-06-02 19:04:56" "2026-06-02 19:04:56" 1 ] |
| 12 | 0.55 ms |
SELECT t0.id AS id_1, t0.statut_activation AS statut_activation_2, t0.date_activation AS date_activation_3, t0.prochaine_date AS prochaine_date_4, t0.nom AS nom_5, t0.adresse AS adresse_6, t0.message_personnalise AS message_personnalise_7, t0.date_creation AS date_creation_8, t0.date_modification AS date_modification_9, t0.structure_id AS structure_id_10 FROM newsletter_librairie t0 WHERE t0.structure_id = ? LIMIT 1
Parameters:
[
5730
]
|
| 13 | 0.27 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_electre AS nom_electre_3, t0.couleur AS couleur_4, t0.ordre AS ordre_5, t0.slug AS slug_6, t0.old_id AS old_id_7, t0.color1 AS color1_8, t0.color2 AS color2_9, t0.parent_id AS parent_id_10 FROM genre t0 ORDER BY t0.ordre ASC
Parameters:
[] |
| 14 | 0.27 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.date_creation AS date_creation_3, t0.is_permanent AS is_permanent_4, t0.date_debut_pub AS date_debut_pub_5, t0.date_fin_pub AS date_fin_pub_6, t0.ordre AS ordre_7, t0.image AS image_8, t0.texte AS texte_9, t0.image_position AS image_position_10, t0.parameters AS parameters_11, t0.couleur_fond_id AS couleur_fond_id_12, t0.type_id AS type_id_13, t0.front_page_id AS front_page_id_14 FROM front_module t0 WHERE t0.front_page_id = ? ORDER BY t0.ordre ASC
Parameters:
[
1
]
|
| 15 | 0.25 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.descriptif AS descriptif_4 FROM type_front_module t0 WHERE t0.id = ?
Parameters:
[
19
]
|
| 16 | 0.23 ms |
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.parameters AS parameters_4, t0.front_module_id AS front_module_id_5 FROM timeline t0 WHERE t0.front_module_id = ? ORDER BY t0.date_debut ASC
Parameters:
[
220
]
|
| 17 | 0.23 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.descriptif AS descriptif_4 FROM type_front_module t0 WHERE t0.id = ?
Parameters:
[
22
]
|
| 18 | 0.23 ms |
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.parameters AS parameters_4, t0.front_module_id AS front_module_id_5 FROM timeline t0 WHERE t0.front_module_id = ? ORDER BY t0.date_debut ASC
Parameters:
[
181
]
|
| 19 | 0.28 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_titre AS sous_titre_3, t0.date_ajout AS date_ajout_4, t0.nb_page AS nb_page_5, t0.prix AS prix_6, t0.traducteur AS traducteur_7, t0.ean AS ean_8, t0.collection AS collection_9, t0.date_parution AS date_parution_10, t0.video AS video_11, t0.audio AS audio_12, t0.poche AS poche_13, t0.url_feuilletage AS url_feuilletage_14, t0.premier_roman AS premier_roman_15, t0.update_at AS update_at_16, t0.old_id AS old_id_17, t0.slug AS slug_18, t0.is_web_only AS is_web_only_19, t0.has_couv AS has_couv_20, t0.reco_text AS reco_text_21, t0.info_techis_valid AS info_techis_valid_22, t0.mediasis_valid AS mediasis_valid_23, t0.chroniqueis_valid AS chroniqueis_valid_24, t0.maquette_ftis_valid AS maquette_ftis_valid_25, t0.maquette_mediais_valid AS maquette_mediais_valid_26, t0.maquette_chroniqueis_valid AS maquette_chroniqueis_valid_27, t0.reco_is_valid AS reco_is_valid_28, t0.maquette_reco_is_valid AS maquette_reco_is_valid_29, t0.niveau_libraire AS niveau_libraire_30, t0.jpro_video AS jpro_video_31, t0.has_thumb AS has_thumb_32, t0.image_interieur AS image_interieur_33, t0.url_interieur AS url_interieur_34, t0.genre_id AS genre_id_35, t0.type_id AS type_id_36, t0.niveau_id AS niveau_id_37, t0.distributeur_id AS distributeur_id_38, t0.ecrivain_voyageur_id AS ecrivain_voyageur_id_39, t0.jplecture_id AS jplecture_id_40, t0.j_pro_editeur_id AS j_pro_editeur_id_41, t0.categorie_id AS categorie_id_42, t0.interieur_ext_id AS interieur_ext_id_43 FROM livre t0 WHERE t0.id = ?
Parameters:
[
"24954"
]
|
| 20 | 0.26 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.infois_ok AS infois_ok_3, t0.visuel_ok AS visuel_ok_4, t0.recos_ok AS recos_ok_5, t0.textes_ok AS textes_ok_6, t0.date_creation AS date_creation_7, t0.update_at AS update_at_8, t0.signature AS signature_9, t0.old_id AS old_id_10, t0.reco_selectionne AS reco_selectionne_11, t0.type AS type_12, t0.exergue AS exergue_13, t0.texte_original_id AS texte_original_id_14, t0.texte_relu_id AS texte_relu_id_15, t0.texte_final_id AS texte_final_id_16, t0.revue_id AS revue_id_17, t0.auteur_id AS auteur_id_18, t0.contact_id AS contact_id_19, t0.genre_id AS genre_id_20 FROM chronique t0 INNER JOIN chronique_livre ON t0.id = chronique_livre.chronique_id WHERE chronique_livre.livre_id = ? ORDER BY t0.type DESC, t0.id DESC
Parameters:
[
24954
]
|
| 21 | 0.27 ms |
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.biographie AS biographie_4, t0.bibliographie AS bibliographie_5, t0.date_creation AS date_creation_6, t0.update_at AS update_at_7, t0.is_ecrivain AS is_ecrivain_8, t0.is_illustrateur AS is_illustrateur_9, t0.old_id AS old_id_10, t0.portrait AS portrait_11, t0.id_electre AS id_electre_12, t0.photo_ext_id AS photo_ext_id_13 FROM auteur t0 INNER JOIN livre_auteur ON t0.id = livre_auteur.auteur_id WHERE livre_auteur.livre_id = ?
Parameters:
[
24954
]
|
| 22 | 0.32 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.copyright AS copyright_3, t0.alternative_text AS alternative_text_4, t5.id AS id_6, t5.prenom AS prenom_7, t5.nom AS nom_8, t5.biographie AS biographie_9, t5.bibliographie AS bibliographie_10, t5.date_creation AS date_creation_11, t5.update_at AS update_at_12, t5.is_ecrivain AS is_ecrivain_13, t5.is_illustrateur AS is_illustrateur_14, t5.old_id AS old_id_15, t5.portrait AS portrait_16, t5.id_electre AS id_electre_17, t5.photo_ext_id AS photo_ext_id_18, t19.id AS id_20, t19.titre AS titre_21, t19.sous_titre AS sous_titre_22, t19.date_ajout AS date_ajout_23, t19.nb_page AS nb_page_24, t19.prix AS prix_25, t19.traducteur AS traducteur_26, t19.ean AS ean_27, t19.collection AS collection_28, t19.date_parution AS date_parution_29, t19.video AS video_30, t19.audio AS audio_31, t19.poche AS poche_32, t19.url_feuilletage AS url_feuilletage_33, t19.premier_roman AS premier_roman_34, t19.update_at AS update_at_35, t19.old_id AS old_id_36, t19.slug AS slug_37, t19.is_web_only AS is_web_only_38, t19.has_couv AS has_couv_39, t19.reco_text AS reco_text_40, t19.info_techis_valid AS info_techis_valid_41, t19.mediasis_valid AS mediasis_valid_42, t19.chroniqueis_valid AS chroniqueis_valid_43, t19.maquette_ftis_valid AS maquette_ftis_valid_44, t19.maquette_mediais_valid AS maquette_mediais_valid_45, t19.maquette_chroniqueis_valid AS maquette_chroniqueis_valid_46, t19.reco_is_valid AS reco_is_valid_47, t19.maquette_reco_is_valid AS maquette_reco_is_valid_48, t19.niveau_libraire AS niveau_libraire_49, t19.jpro_video AS jpro_video_50, t19.has_thumb AS has_thumb_51, t19.image_interieur AS image_interieur_52, t19.url_interieur AS url_interieur_53, t19.genre_id AS genre_id_54, t19.type_id AS type_id_55, t19.niveau_id AS niveau_id_56, t19.distributeur_id AS distributeur_id_57, t19.ecrivain_voyageur_id AS ecrivain_voyageur_id_58, t19.jplecture_id AS jplecture_id_59, t19.j_pro_editeur_id AS j_pro_editeur_id_60, t19.categorie_id AS categorie_id_61, t19.interieur_ext_id AS interieur_ext_id_62 FROM photo_extended t0 LEFT JOIN auteur t5 ON t5.photo_ext_id = t0.id LEFT JOIN livre t19 ON t19.interieur_ext_id = t0.id WHERE t0.id = ?
Parameters:
[
860
]
|
| 23 | 0.24 ms |
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.parameters AS parameters_4, t0.front_module_id AS front_module_id_5 FROM timeline t0 WHERE t0.front_module_id = ? ORDER BY t0.date_debut ASC
Parameters:
[
182
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Page | 227 |
| App\Entity\FrontModule | 15 |
| App\Entity\TypeFrontModule | 12 |
| App\Entity\Genre | 8 |
| App\Entity\ChroniqueTexte | 3 |
| App\Entity\Contact | 2 |
| App\Entity\Notification\Notification | 2 |
| App\Entity\FrontColor | 2 |
| App\Entity\FrontPage | 1 |
| App\Entity\User | 1 |
| App\Entity\Client | 1 |
| App\Entity\Structure | 1 |
| App\Entity\NewsContact | 1 |
| App\Entity\TypeStructure | 1 |
| App\Entity\EspacePro\TypeEspacePro | 1 |
| App\Entity\Livre | 1 |
| App\Entity\Distributeur | 1 |
| App\Entity\PhotoExtended | 1 |
| App\Entity\Chronique | 1 |
| App\Entity\Revue | 1 |
| App\Entity\Auteur | 1 |