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 = 'journal/stud' 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 = 'studmagazine' 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 (696545, 696546, 697955, 697956, 698028, 698029);

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 (3194, 3195, 3219, 3220, 3221, 3222);

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 = 'studmagazine' 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

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

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 = 'studmagazine' AND e0_.date_end < '2026-03-16' AND e0_.status = 1 AND e0_.id IN (3193, 3192, 3186, 3185, 3184, 3183, 3158, 3157, 3156, 3137, 3136, 3135, 3134, 3090, 3089, 3088, 3087, 3064, 3063, 3062, 3061, 3056, 3055, 3054, 3053, 3029, 3028, 3027, 3026, 3000) 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 (696544, 696543, 694460, 694433, 694432, 694431, 689073, 689072, 689071, 686005, 686003, 686002, 685948, 684190, 684189, 684163, 684162, 683140, 683139, 683138, 683137, 682108, 682107, 682106, 682105, 680882, 680881, 680880, 680879, 676638);

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 (3193, 3192, 3186, 3185, 3184, 3183, 3158, 3157, 3156, 3137, 3136, 3135, 3134, 3090, 3089, 3088, 3087, 3064, 3063, 3062, 3061, 3056, 3055, 3054, 3053, 3029, 3028, 3027, 3026, 3000);