Symfony Profiler

SELECT
  count(DISTINCT l0_.id) AS sclr_0
FROM
  livre l0_
  LEFT JOIN genre g1_ ON l0_.genre_id = g1_.id
  LEFT JOIN livre_revue l3_ ON l0_.id = l3_.livre_id
  LEFT JOIN revue r2_ ON r2_.id = l3_.revue_id
  LEFT JOIN chronique_livre c5_ ON l0_.id = c5_.livre_id
  LEFT JOIN chronique c4_ ON c4_.id = c5_.chronique_id
WHERE
  r2_.date_publication < ?
  AND l0_.date_parution <= ?
  AND g1_.id = ?
  AND c4_.id IS NOT NULL

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM livre l0_ LEFT JOIN genre g1_ ON l0_.genre_id = g1_.id LEFT JOIN livre_revue l3_ ON l0_.id = l3_.livre_id LEFT JOIN revue r2_ ON r2_.id = l3_.revue_id LEFT JOIN chronique_livre c5_ ON l0_.id = c5_.livre_id LEFT JOIN chronique c4_ ON c4_.id = c5_.chronique_id WHERE r2_.date_publication < '2026-06-02 18:20:04' AND l0_.date_parution <= '2026-06-02 18:20:04' AND g1_.id = 8 AND c4_.id IS NOT NULL;

SELECT
  DISTINCT l0_.id AS id_0,
  l0_.date_parution AS date_parution_1
FROM
  livre l0_
  LEFT JOIN genre g1_ ON l0_.genre_id = g1_.id
  LEFT JOIN livre_revue l3_ ON l0_.id = l3_.livre_id
  LEFT JOIN revue r2_ ON r2_.id = l3_.revue_id
  LEFT JOIN chronique_livre c5_ ON l0_.id = c5_.livre_id
  LEFT JOIN chronique c4_ ON c4_.id = c5_.chronique_id
WHERE
  r2_.date_publication < ?
  AND l0_.date_parution <= ?
  AND g1_.id = ?
  AND c4_.id IS NOT NULL
ORDER BY
  l0_.date_parution DESC
LIMIT
  16

SELECT DISTINCT l0_.id AS id_0, l0_.date_parution AS date_parution_1 FROM livre l0_ LEFT JOIN genre g1_ ON l0_.genre_id = g1_.id LEFT JOIN livre_revue l3_ ON l0_.id = l3_.livre_id LEFT JOIN revue r2_ ON r2_.id = l3_.revue_id LEFT JOIN chronique_livre c5_ ON l0_.id = c5_.livre_id LEFT JOIN chronique c4_ ON c4_.id = c5_.chronique_id WHERE r2_.date_publication < '2026-06-02 18:20:04' AND l0_.date_parution <= '2026-06-02 18:20:04' AND g1_.id = 8 AND c4_.id IS NOT NULL ORDER BY l0_.date_parution DESC LIMIT 16;

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 = ?

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 = 'front';

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,
  c1_.id AS id_34,
  c1_.nom AS nom_35,
  c1_.infois_ok AS infois_ok_36,
  c1_.visuel_ok AS visuel_ok_37,
  c1_.recos_ok AS recos_ok_38,
  c1_.textes_ok AS textes_ok_39,
  c1_.date_creation AS date_creation_40,
  c1_.update_at AS update_at_41,
  c1_.signature AS signature_42,
  c1_.old_id AS old_id_43,
  c1_.reco_selectionne AS reco_selectionne_44,
  c1_.type AS type_45,
  c1_.exergue AS exergue_46,
  l0_.genre_id AS genre_id_47,
  l0_.type_id AS type_id_48,
  l0_.niveau_id AS niveau_id_49,
  l0_.distributeur_id AS distributeur_id_50,
  l0_.ecrivain_voyageur_id AS ecrivain_voyageur_id_51,
  l0_.jplecture_id AS jplecture_id_52,
  l0_.j_pro_editeur_id AS j_pro_editeur_id_53,
  l0_.categorie_id AS categorie_id_54,
  l0_.interieur_ext_id AS interieur_ext_id_55,
  c1_.texte_original_id AS texte_original_id_56,
  c1_.texte_relu_id AS texte_relu_id_57,
  c1_.texte_final_id AS texte_final_id_58,
  c1_.revue_id AS revue_id_59,
  c1_.auteur_id AS auteur_id_60,
  c1_.contact_id AS contact_id_61,
  c1_.genre_id AS genre_id_62
FROM
  livre l0_
  LEFT JOIN genre g2_ ON l0_.genre_id = g2_.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 c1_ ON c1_.id = c5_.chronique_id
WHERE
  r3_.date_publication < ?
  AND l0_.date_parution <= ?
  AND g2_.id = ?
  AND c1_.id IS NOT NULL
  AND l0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  l0_.date_parution DESC,
  c1_.type DESC,
  c1_.id DESC

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, c1_.id AS id_34, c1_.nom AS nom_35, c1_.infois_ok AS infois_ok_36, c1_.visuel_ok AS visuel_ok_37, c1_.recos_ok AS recos_ok_38, c1_.textes_ok AS textes_ok_39, c1_.date_creation AS date_creation_40, c1_.update_at AS update_at_41, c1_.signature AS signature_42, c1_.old_id AS old_id_43, c1_.reco_selectionne AS reco_selectionne_44, c1_.type AS type_45, c1_.exergue AS exergue_46, l0_.genre_id AS genre_id_47, l0_.type_id AS type_id_48, l0_.niveau_id AS niveau_id_49, l0_.distributeur_id AS distributeur_id_50, l0_.ecrivain_voyageur_id AS ecrivain_voyageur_id_51, l0_.jplecture_id AS jplecture_id_52, l0_.j_pro_editeur_id AS j_pro_editeur_id_53, l0_.categorie_id AS categorie_id_54, l0_.interieur_ext_id AS interieur_ext_id_55, c1_.texte_original_id AS texte_original_id_56, c1_.texte_relu_id AS texte_relu_id_57, c1_.texte_final_id AS texte_final_id_58, c1_.revue_id AS revue_id_59, c1_.auteur_id AS auteur_id_60, c1_.contact_id AS contact_id_61, c1_.genre_id AS genre_id_62 FROM livre l0_ LEFT JOIN genre g2_ ON l0_.genre_id = g2_.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 c1_ ON c1_.id = c5_.chronique_id WHERE r3_.date_publication < '2026-06-02 18:20:04' AND l0_.date_parution <= '2026-06-02 18:20:04' AND g2_.id = 8 AND c1_.id IS NOT NULL AND l0_.id IN (24986, 24987, 25005, 25021, 25028, 25198, 25033, 25034, 25043, 25055, 25051, 25066, 25103, 25077, 25089, 25080) ORDER BY l0_.date_parution DESC, c1_.type DESC, c1_.id DESC;

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 = ?

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 = 24987;

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 = ?

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 = 24987;

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 = ?

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 = 'front_metier' AND t0.is_actif = 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

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 = 'genre' LIMIT 1;

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

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;

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 = ?

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 = 5;

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

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 = 11 ORDER BY t0.ordre ASC;

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
WHERE
  t0.slug = ?
LIMIT
  1

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 WHERE t0.slug = 'polar' LIMIT 1;