Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.entity_id AS entity_id_2,
  t0.entity_type AS entity_type_3,
  t0.path AS path_4
FROM
  path t0
WHERE
  t0.path = ?
ORDER BY
  t0.entity_type DESC

SELECT t0.id AS id_1, t0.entity_id AS entity_id_2, t0.entity_type AS entity_type_3, t0.path AS path_4 FROM path t0 WHERE t0.path = 'monograph' ORDER BY t0.entity_type DESC;

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.direction AS direction_2,
  e0_.date_end AS date_end_3,
  e0_.date_publ AS date_publ_4,
  e0_.cover AS cover_5,
  e0_.number AS number_6,
  e0_.link_elibrary AS link_elibrary_7,
  e0_.created AS created_8,
  e0_.body AS body_9,
  e0_.nid AS nid_10,
  e0_.exit_data AS exit_data_11,
  e0_.link_rinc AS link_rinc_12,
  e0_.updated AS updated_13,
  e0_.file AS file_14,
  e0_.email_subscribe AS email_subscribe_15,
  e0_.status AS status_16,
  e0_.send_email_pdf AS send_email_pdf_17,
  e0_.date_send_elibrary AS date_send_elibrary_18,
  e0_.date_send_date AS date_send_date_19,
  e0_.date_send_postal AS date_send_postal_20,
  e0_.price AS price_21,
  e0_.path_id AS path_id_22,
  e0_.user_id AS user_id_23
FROM
  edition e0_
WHERE
  e0_.direction = ?
  AND e0_.date_end >= ?
  AND e0_.status = 1
ORDER BY
  e0_.date_end ASC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.direction AS direction_2, e0_.date_end AS date_end_3, e0_.date_publ AS date_publ_4, e0_.cover AS cover_5, e0_.number AS number_6, e0_.link_elibrary AS link_elibrary_7, e0_.created AS created_8, e0_.body AS body_9, e0_.nid AS nid_10, e0_.exit_data AS exit_data_11, e0_.link_rinc AS link_rinc_12, e0_.updated AS updated_13, e0_.file AS file_14, e0_.email_subscribe AS email_subscribe_15, e0_.status AS status_16, e0_.send_email_pdf AS send_email_pdf_17, e0_.date_send_elibrary AS date_send_elibrary_18, e0_.date_send_date AS date_send_date_19, e0_.date_send_postal AS date_send_postal_20, e0_.price AS price_21, e0_.path_id AS path_id_22, e0_.user_id AS user_id_23 FROM edition e0_ WHERE e0_.direction = 'mono' AND e0_.date_end >= '2026-03-16' AND e0_.status = 1 ORDER BY e0_.date_end ASC;

SELECT
  t0.id AS id_1,
  t0.entity_id AS entity_id_2,
  t0.entity_type AS entity_type_3,
  t0.path AS path_4
FROM
  path t0
WHERE
  t0.id IN (?, ?)

SELECT t0.id AS id_1, t0.entity_id AS entity_id_2, t0.entity_type AS entity_type_3, t0.path AS path_4 FROM path t0 WHERE t0.id IN (696992, 698474);

SELECT
  t0.id AS id_1,
  t0.pages AS pages_2,
  t0.filepath AS filepath_3,
  t0.entity_id AS entity_id_4
FROM
  edition_pages t0
WHERE
  t0.entity_id IN (?, ?)

SELECT t0.id AS id_1, t0.pages AS pages_2, t0.filepath AS filepath_3, t0.entity_id AS entity_id_4 FROM edition_pages t0 WHERE t0.entity_id IN (3214, 3240);

SELECT
  COUNT(DISTINCT e0_.id) AS sclr_0
FROM
  edition e0_
WHERE
  e0_.direction = ?
  AND e0_.date_end < ?
  AND e0_.status = 1

SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM edition e0_ WHERE e0_.direction = 'mono' AND e0_.date_end < '2026-03-16' AND e0_.status = 1;

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.date_end AS date_end_1
FROM
  edition e0_
WHERE
  e0_.direction = ?
  AND e0_.date_end < ?
  AND e0_.status = 1
ORDER BY
  e0_.date_end DESC
LIMIT
  30 OFFSET 90

SELECT DISTINCT e0_.id AS id_0, e0_.date_end AS date_end_1 FROM edition e0_ WHERE e0_.direction = 'mono' AND e0_.date_end < '2026-03-16' AND e0_.status = 1 ORDER BY e0_.date_end DESC LIMIT 30 OFFSET 90;

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.direction AS direction_2,
  e0_.date_end AS date_end_3,
  e0_.date_publ AS date_publ_4,
  e0_.cover AS cover_5,
  e0_.number AS number_6,
  e0_.link_elibrary AS link_elibrary_7,
  e0_.created AS created_8,
  e0_.body AS body_9,
  e0_.nid AS nid_10,
  e0_.exit_data AS exit_data_11,
  e0_.link_rinc AS link_rinc_12,
  e0_.updated AS updated_13,
  e0_.file AS file_14,
  e0_.email_subscribe AS email_subscribe_15,
  e0_.status AS status_16,
  e0_.send_email_pdf AS send_email_pdf_17,
  e0_.date_send_elibrary AS date_send_elibrary_18,
  e0_.date_send_date AS date_send_date_19,
  e0_.date_send_postal AS date_send_postal_20,
  e0_.price AS price_21,
  e0_.path_id AS path_id_22,
  e0_.user_id AS user_id_23
FROM
  edition e0_
WHERE
  e0_.direction = ?
  AND e0_.date_end < ?
  AND e0_.status = 1
  AND e0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )
ORDER BY
  e0_.date_end DESC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.direction AS direction_2, e0_.date_end AS date_end_3, e0_.date_publ AS date_publ_4, e0_.cover AS cover_5, e0_.number AS number_6, e0_.link_elibrary AS link_elibrary_7, e0_.created AS created_8, e0_.body AS body_9, e0_.nid AS nid_10, e0_.exit_data AS exit_data_11, e0_.link_rinc AS link_rinc_12, e0_.updated AS updated_13, e0_.file AS file_14, e0_.email_subscribe AS email_subscribe_15, e0_.status AS status_16, e0_.send_email_pdf AS send_email_pdf_17, e0_.date_send_elibrary AS date_send_elibrary_18, e0_.date_send_date AS date_send_date_19, e0_.date_send_postal AS date_send_postal_20, e0_.price AS price_21, e0_.path_id AS path_id_22, e0_.user_id AS user_id_23 FROM edition e0_ WHERE e0_.direction = 'mono' AND e0_.date_end < '2026-03-16' AND e0_.status = 1 AND e0_.id IN (644, 606, 583, 569, 554, 536, 510, 505, 493, 482, 471, 459, 449, 425, 448, 424, 437, 399, 398, 385, 401) ORDER BY e0_.date_end DESC;

SELECT
  t0.id AS id_1,
  t0.entity_id AS entity_id_2,
  t0.entity_type AS entity_type_3,
  t0.path AS path_4
FROM
  path t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.entity_id AS entity_id_2, t0.entity_type AS entity_type_3, t0.path AS path_4 FROM path t0 WHERE t0.id IN (828, 790, 767, 753, 738, 720, 694, 689, 677, 666, 655, 643, 633, 632, 609, 621, 608, 583, 582, 569, 585);

SELECT
  t0.id AS id_1,
  t0.pages AS pages_2,
  t0.filepath AS filepath_3,
  t0.entity_id AS entity_id_4
FROM
  edition_pages t0
WHERE
  t0.entity_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.pages AS pages_2, t0.filepath AS filepath_3, t0.entity_id AS entity_id_4 FROM edition_pages t0 WHERE t0.entity_id IN (644, 606, 583, 569, 554, 536, 510, 505, 493, 482, 471, 459, 449, 448, 425, 437, 424, 399, 398, 385, 401);