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:35:03' AND l0_.date_parution <= '2026-06-02 18:35:03' AND g1_.id = 6 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
OFFSET
  3072

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:35:03' AND l0_.date_parution <= '2026-06-02 18:35:03' AND g1_.id = 6 AND c4_.id IS NOT NULL ORDER BY l0_.date_parution DESC LIMIT 16 OFFSET 3072;

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:35:03' AND l0_.date_parution <= '2026-06-02 18:35:03' AND g2_.id = 6 AND c1_.id IS NOT NULL AND l0_.id IN (2642, 2527, 2561, 2530, 2649, 2547, 2582, 2566, 2583, 2551, 2584, 2656, 2552, 2585, 4050, 2537) ORDER BY l0_.date_parution DESC, c1_.type DESC, c1_.id DESC;

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.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 = 'litterature-etrangere' LIMIT 1;