Query Metrics
204
Database Queries
25
Different statements
240.51 ms
Query time
0
Invalid entities
4390
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
83.81 ms (34.85%) |
1 |
SELECT l0_.id AS id_0, l0_.titre AS titre_1, l0_.sous_titre AS sous_titre_2, l0_.date_ajout AS date_ajout_3, l0_.nb_page AS nb_page_4, l0_.prix AS prix_5, l0_.traducteur AS traducteur_6, l0_.ean AS ean_7, l0_.collection AS collection_8, l0_.date_parution AS date_parution_9, l0_.video AS video_10, l0_.audio AS audio_11, l0_.poche AS poche_12, l0_.url_feuilletage AS url_feuilletage_13, l0_.premier_roman AS premier_roman_14, l0_.update_at AS update_at_15, l0_.old_id AS old_id_16, l0_.slug AS slug_17, l0_.is_web_only AS is_web_only_18, l0_.has_couv AS has_couv_19, l0_.reco_text AS reco_text_20, l0_.info_techis_valid AS info_techis_valid_21, l0_.mediasis_valid AS mediasis_valid_22, l0_.chroniqueis_valid AS chroniqueis_valid_23, l0_.maquette_ftis_valid AS maquette_ftis_valid_24, l0_.maquette_mediais_valid AS maquette_mediais_valid_25, l0_.maquette_chroniqueis_valid AS maquette_chroniqueis_valid_26, l0_.reco_is_valid AS reco_is_valid_27, l0_.maquette_reco_is_valid AS maquette_reco_is_valid_28, l0_.niveau_libraire AS niveau_libraire_29, l0_.jpro_video AS jpro_video_30, l0_.has_thumb AS has_thumb_31, l0_.image_interieur AS image_interieur_32, l0_.url_interieur AS url_interieur_33, g1_.id AS id_34, g1_.nom AS nom_35, g1_.nom_electre AS nom_electre_36, g1_.couleur AS couleur_37, g1_.ordre AS ordre_38, g1_.slug AS slug_39, g1_.old_id AS old_id_40, g1_.color1 AS color1_41, g1_.color2 AS color2_42, c2_.id AS id_43, c2_.nom AS nom_44, c2_.infois_ok AS infois_ok_45, c2_.visuel_ok AS visuel_ok_46, c2_.recos_ok AS recos_ok_47, c2_.textes_ok AS textes_ok_48, c2_.date_creation AS date_creation_49, c2_.update_at AS update_at_50, c2_.signature AS signature_51, c2_.old_id AS old_id_52, c2_.reco_selectionne AS reco_selectionne_53, c2_.type AS type_54, c2_.exergue AS exergue_55, l0_.genre_id AS genre_id_56, l0_.type_id AS type_id_57, l0_.niveau_id AS niveau_id_58, l0_.distributeur_id AS distributeur_id_59, l0_.ecrivain_voyageur_id AS ecrivain_voyageur_id_60, l0_.jplecture_id AS jplecture_id_61, l0_.j_pro_editeur_id AS j_pro_editeur_id_62, l0_.categorie_id AS categorie_id_63, l0_.interieur_ext_id AS interieur_ext_id_64, g1_.parent_id AS parent_id_65, c2_.texte_original_id AS texte_original_id_66, c2_.texte_relu_id AS texte_relu_id_67, c2_.texte_final_id AS texte_final_id_68, c2_.revue_id AS revue_id_69, c2_.auteur_id AS auteur_id_70, c2_.contact_id AS contact_id_71, c2_.genre_id AS genre_id_72 FROM livre l0_ LEFT JOIN genre g1_ ON l0_.genre_id = g1_.id LEFT JOIN livre_revue l4_ ON l0_.id = l4_.livre_id LEFT JOIN revue r3_ ON r3_.id = l4_.revue_id LEFT JOIN chronique_livre c5_ ON l0_.id = c5_.livre_id LEFT JOIN chronique c2_ ON c2_.id = c5_.chronique_id WHERE r3_.date_publication < ? AND l0_.date_parution <= ? AND l0_.poche = 1 AND c2_.id IS NOT NULL ORDER BY l0_.date_parution DESC, c2_.type DESC, c2_.id DESC LIMIT 20
Parameters:
[ "2026-06-02 19:56:04" "2026-06-02 19:56:04" ] |
|
70.72 ms (29.40%) |
1 |
SELECT l0_.id AS id_0, l0_.titre AS titre_1, l0_.sous_titre AS sous_titre_2, l0_.date_ajout AS date_ajout_3, l0_.nb_page AS nb_page_4, l0_.prix AS prix_5, l0_.traducteur AS traducteur_6, l0_.ean AS ean_7, l0_.collection AS collection_8, l0_.date_parution AS date_parution_9, l0_.video AS video_10, l0_.audio AS audio_11, l0_.poche AS poche_12, l0_.url_feuilletage AS url_feuilletage_13, l0_.premier_roman AS premier_roman_14, l0_.update_at AS update_at_15, l0_.old_id AS old_id_16, l0_.slug AS slug_17, l0_.is_web_only AS is_web_only_18, l0_.has_couv AS has_couv_19, l0_.reco_text AS reco_text_20, l0_.info_techis_valid AS info_techis_valid_21, l0_.mediasis_valid AS mediasis_valid_22, l0_.chroniqueis_valid AS chroniqueis_valid_23, l0_.maquette_ftis_valid AS maquette_ftis_valid_24, l0_.maquette_mediais_valid AS maquette_mediais_valid_25, l0_.maquette_chroniqueis_valid AS maquette_chroniqueis_valid_26, l0_.reco_is_valid AS reco_is_valid_27, l0_.maquette_reco_is_valid AS maquette_reco_is_valid_28, l0_.niveau_libraire AS niveau_libraire_29, l0_.jpro_video AS jpro_video_30, l0_.has_thumb AS has_thumb_31, l0_.image_interieur AS image_interieur_32, l0_.url_interieur AS url_interieur_33, g1_.id AS id_34, g1_.nom AS nom_35, g1_.nom_electre AS nom_electre_36, g1_.couleur AS couleur_37, g1_.ordre AS ordre_38, g1_.slug AS slug_39, g1_.old_id AS old_id_40, g1_.color1 AS color1_41, g1_.color2 AS color2_42, c2_.id AS id_43, c2_.nom AS nom_44, c2_.infois_ok AS infois_ok_45, c2_.visuel_ok AS visuel_ok_46, c2_.recos_ok AS recos_ok_47, c2_.textes_ok AS textes_ok_48, c2_.date_creation AS date_creation_49, c2_.update_at AS update_at_50, c2_.signature AS signature_51, c2_.old_id AS old_id_52, c2_.reco_selectionne AS reco_selectionne_53, c2_.type AS type_54, c2_.exergue AS exergue_55, l0_.genre_id AS genre_id_56, l0_.type_id AS type_id_57, l0_.niveau_id AS niveau_id_58, l0_.distributeur_id AS distributeur_id_59, l0_.ecrivain_voyageur_id AS ecrivain_voyageur_id_60, l0_.jplecture_id AS jplecture_id_61, l0_.j_pro_editeur_id AS j_pro_editeur_id_62, l0_.categorie_id AS categorie_id_63, l0_.interieur_ext_id AS interieur_ext_id_64, g1_.parent_id AS parent_id_65, c2_.texte_original_id AS texte_original_id_66, c2_.texte_relu_id AS texte_relu_id_67, c2_.texte_final_id AS texte_final_id_68, c2_.revue_id AS revue_id_69, c2_.auteur_id AS auteur_id_70, c2_.contact_id AS contact_id_71, c2_.genre_id AS genre_id_72 FROM livre l0_ LEFT JOIN genre g1_ ON l0_.genre_id = g1_.id LEFT JOIN livre_revue l4_ ON l0_.id = l4_.livre_id LEFT JOIN revue r3_ ON r3_.id = l4_.revue_id LEFT JOIN chronique_livre c5_ ON l0_.id = c5_.livre_id LEFT JOIN chronique c2_ ON c2_.id = c5_.chronique_id WHERE r3_.date_publication < ? AND l0_.date_parution <= ? AND l0_.premier_roman = 1 AND c2_.id IS NOT NULL ORDER BY l0_.date_parution DESC, c2_.type DESC, c2_.id DESC LIMIT 20
Parameters:
[ "2026-06-02 19:56:03" "2026-06-02 19:56:03" ] |
|
27.45 ms (11.41%) |
1 |
SELECT l0_.id AS id_0, l0_.titre AS titre_1, l0_.sous_titre AS sous_titre_2, l0_.date_ajout AS date_ajout_3, l0_.nb_page AS nb_page_4, l0_.prix AS prix_5, l0_.traducteur AS traducteur_6, l0_.ean AS ean_7, l0_.collection AS collection_8, l0_.date_parution AS date_parution_9, l0_.video AS video_10, l0_.audio AS audio_11, l0_.poche AS poche_12, l0_.url_feuilletage AS url_feuilletage_13, l0_.premier_roman AS premier_roman_14, l0_.update_at AS update_at_15, l0_.old_id AS old_id_16, l0_.slug AS slug_17, l0_.is_web_only AS is_web_only_18, l0_.has_couv AS has_couv_19, l0_.reco_text AS reco_text_20, l0_.info_techis_valid AS info_techis_valid_21, l0_.mediasis_valid AS mediasis_valid_22, l0_.chroniqueis_valid AS chroniqueis_valid_23, l0_.maquette_ftis_valid AS maquette_ftis_valid_24, l0_.maquette_mediais_valid AS maquette_mediais_valid_25, l0_.maquette_chroniqueis_valid AS maquette_chroniqueis_valid_26, l0_.reco_is_valid AS reco_is_valid_27, l0_.maquette_reco_is_valid AS maquette_reco_is_valid_28, l0_.niveau_libraire AS niveau_libraire_29, l0_.jpro_video AS jpro_video_30, l0_.has_thumb AS has_thumb_31, l0_.image_interieur AS image_interieur_32, l0_.url_interieur AS url_interieur_33, l0_.genre_id AS genre_id_34, l0_.type_id AS type_id_35, l0_.niveau_id AS niveau_id_36, l0_.distributeur_id AS distributeur_id_37, l0_.ecrivain_voyageur_id AS ecrivain_voyageur_id_38, l0_.jplecture_id AS jplecture_id_39, l0_.j_pro_editeur_id AS j_pro_editeur_id_40, l0_.categorie_id AS categorie_id_41, l0_.interieur_ext_id AS interieur_ext_id_42 FROM livre l0_ LEFT JOIN livre_contact l2_ ON l0_.id = l2_.livre_id LEFT JOIN contact c1_ ON c1_.id = l2_.contact_id LEFT JOIN genre g3_ ON l0_.genre_id = g3_.id LEFT JOIN livre_revue l5_ ON l0_.id = l5_.livre_id LEFT JOIN revue r4_ ON r4_.id = l5_.revue_id WHERE l0_.date_parution < ? AND l0_.date_parution > ? AND r4_.date_publication < ? AND g3_.id = ? AND l0_.poche = 0 GROUP BY l0_.id ORDER BY COUNT(c1_.id) DESC LIMIT 20
Parameters:
[ "2026-06-02 19:56:03" "2025-12-02 19:56:03" "2026-06-02 19:56:03" 7 ] |
|
15.77 ms (6.56%) |
64 |
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
]
|
|
14.81 ms (6.16%) |
63 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.old_id AS old_id_3, t0.slug AS slug_4, t0.date_creation AS date_creation_5, t0.udpate_at AS udpate_at_6, t0.alias_electre AS alias_electre_7, t0.id_electre AS id_electre_8 FROM editeur t0 INNER JOIN livre_editeur ON t0.id = livre_editeur.editeur_id WHERE livre_editeur.livre_id = ?
Parameters:
[
24727
]
|
|
10.37 ms (4.31%) |
2 |
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"
]
|
|
4.22 ms (1.75%) |
21 |
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
]
|
|
3.02 ms (1.26%) |
11 |
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
]
|
|
2.34 ms (0.97%) |
10 |
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
]
|
|
0.84 ms (0.35%) |
3 |
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 INNER JOIN chronique_livre ON t0.id = chronique_livre.livre_id WHERE chronique_livre.chronique_id = ?
Parameters:
[
18199
]
|
|
0.81 ms (0.34%) |
3 |
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 WHERE t0.id = ?
Parameters:
[
"18199"
]
|
|
0.68 ms (0.28%) |
2 |
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
]
|
|
0.66 ms (0.28%) |
2 |
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 ] |
|
0.63 ms (0.26%) |
1 |
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"
]
|
|
0.63 ms (0.26%) |
3 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.chapeau AS chapeau_3, t0.contenu AS contenu_4, t0.is_valide AS is_valide_5 FROM chronique_texte t0 WHERE t0.id = ?
Parameters:
[
35055
]
|
|
0.54 ms (0.22%) |
2 |
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:
[] |
|
0.49 ms (0.20%) |
2 |
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 WHERE t0.id = ?
Parameters:
[
16352
]
|
|
0.45 ms (0.19%) |
2 |
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:
[
3989
]
|
|
0.43 ms (0.18%) |
2 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.telephone AS telephone_4, t0.code_abomarque AS code_abomarque_5, t0.commentaire AS commentaire_6, t0.facebook AS facebook_7, t0.twitter AS twitter_8, t0.email AS email_9, t0.old_id AS old_id_10, t0.civilite AS civilite_11, t0.old_userid AS old_userid_12, t0.actif AS actif_13, t0.bio AS bio_14, t0.has_photo AS has_photo_15, t0.is_referent AS is_referent_16, t0.date_creation AS date_creation_17, t0.receive_nmardi AS receive_nmardi_18, t0.receive_nvendredi AS receive_nvendredi_19, t0.receive_ireseau AS receive_ireseau_20, t0.structure_id AS structure_id_21, t0.adresse_id AS adresse_id_22, t0.utilisateur_id AS utilisateur_id_23, t0.news_contact_id AS news_contact_id_24 FROM contact t0 WHERE t0.id = ?
Parameters:
[
2422
]
|
|
0.41 ms (0.17%) |
2 |
SELECT t0.id AS id_1, t0.ligne1 AS ligne1_2, t0.ligne2 AS ligne2_3, t0.ligne3 AS ligne3_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.etat AS etat_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.pays AS pays_10, t0.label AS label_11, t0.principale AS principale_12, t0.structure_id AS structure_id_13 FROM adresse t0 WHERE t0.structure_id = ? ORDER BY t0.principale DESC
Parameters:
[
3989
]
|
|
0.38 ms (0.16%) |
2 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.hexa AS hexa_3, t0.text_color AS text_color_4 FROM front_color t0 WHERE t0.id = ?
Parameters:
[
15
]
|
|
0.37 ms (0.15%) |
1 |
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 INNER JOIN livre_auteur ON t0.id = livre_auteur.livre_id WHERE livre_auteur.auteur_id = ? ORDER BY t0.date_parution DESC
Parameters:
[
336
]
|
|
0.29 ms (0.12%) |
1 |
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
]
|
|
0.27 ms (0.11%) |
1 |
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"
]
|
|
0.14 ms (0.06%) |
1 |
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
]
|
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\Timeline | 3592 |
| App\Entity\Page | 227 |
| App\Entity\ChroniqueTexte | 183 |
| App\Entity\Livre | 73 |
| App\Entity\Chronique | 61 |
| App\Entity\Auteur | 61 |
| App\Entity\Contact | 46 |
| App\Entity\Editeur | 35 |
| App\Entity\PhotoExtended | 22 |
| App\Entity\JProEditeur | 19 |
| App\Entity\FrontModule | 15 |
| App\Entity\TypeFrontModule | 12 |
| App\Entity\Genre | 8 |
| App\Entity\Distributeur | 7 |
| App\Entity\Revue | 3 |
| App\Entity\NiveauLivre | 3 |
| App\Entity\FrontColor | 2 |
| App\Entity\Structure | 2 |
| App\Entity\User | 2 |
| App\Entity\NewsContact | 2 |
| App\Entity\Departement | 2 |
| App\Entity\Region | 2 |
| App\Entity\ClientCleEnMain | 2 |
| App\Entity\Adresse | 2 |
| App\Entity\JourneePro | 2 |
| App\Entity\Categorie | 2 |
| App\Entity\FrontPage | 1 |
| App\Entity\TypeStructure | 1 |
| App\Entity\EspacePro\TypeEspacePro | 1 |