Symfony Profiler

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  edition e0_
  INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id
  INNER JOIN school s2_ ON m1_.school_id = s2_.id

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM edition e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN school s2_ ON m1_.school_id = s2_.id;

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.created_at AS created_at_1
FROM
  edition e0_
  INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id
  INNER JOIN school s2_ ON m1_.school_id = s2_.id
ORDER BY
  e0_.created_at DESC
LIMIT
  12
OFFSET
  84

SELECT DISTINCT e0_.id AS id_0, e0_.created_at AS created_at_1 FROM edition e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN school s2_ ON m1_.school_id = s2_.id ORDER BY e0_.created_at DESC LIMIT 12 OFFSET 84;

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.description AS description_2,
  e0_.edition AS edition_3,
  e0_.period AS period_4,
  e0_.uuid AS uuid_5,
  e0_.convert_status AS convert_status_6,
  e0_.page_count AS page_count_7,
  e0_.width AS width_8,
  e0_.height AS height_9,
  e0_.image AS image_10,
  e0_.pdf AS pdf_11,
  e0_.created_at AS created_at_12,
  e0_.updated_at AS updated_at_13,
  e0_.magazine_id AS magazine_id_14
FROM
  edition e0_
  INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id
  INNER JOIN school s2_ ON m1_.school_id = s2_.id
WHERE
  e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  e0_.created_at DESC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.edition AS edition_3, e0_.period AS period_4, e0_.uuid AS uuid_5, e0_.convert_status AS convert_status_6, e0_.page_count AS page_count_7, e0_.width AS width_8, e0_.height AS height_9, e0_.image AS image_10, e0_.pdf AS pdf_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13, e0_.magazine_id AS magazine_id_14 FROM edition e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN school s2_ ON m1_.school_id = s2_.id WHERE e0_.id IN (15, 14, 13, 12, 11, 10, 9, 8, 7, 6, 5, 4) ORDER BY e0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.is_private AS is_private_4,
  t0.domain AS domain_5,
  t0.description AS description_6,
  t0.image AS image_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.school_id AS school_id_10
FROM
  magazine t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.city_id AS city_id_7
FROM
  school t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.is_private AS is_private_4,
  t0.domain AS domain_5,
  t0.description AS description_6,
  t0.image AS image_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.school_id AS school_id_10
FROM
  magazine t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.city_id AS city_id_7
FROM
  school t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = 15;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.is_private AS is_private_4,
  t0.domain AS domain_5,
  t0.description AS description_6,
  t0.image AS image_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.school_id AS school_id_10
FROM
  magazine t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.city_id AS city_id_7
FROM
  school t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.is_private AS is_private_4,
  t0.domain AS domain_5,
  t0.description AS description_6,
  t0.image AS image_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.school_id AS school_id_10
FROM
  magazine t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.city_id AS city_id_7
FROM
  school t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.is_private AS is_private_4,
  t0.domain AS domain_5,
  t0.description AS description_6,
  t0.image AS image_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.school_id AS school_id_10
FROM
  magazine t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.city_id AS city_id_7
FROM
  school t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.is_private AS is_private_4,
  t0.domain AS domain_5,
  t0.description AS description_6,
  t0.image AS image_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.school_id AS school_id_10
FROM
  magazine t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.city_id AS city_id_7
FROM
  school t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.is_private AS is_private_4,
  t0.domain AS domain_5,
  t0.description AS description_6,
  t0.image AS image_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.school_id AS school_id_10
FROM
  magazine t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.city_id AS city_id_7
FROM
  school t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.is_private AS is_private_4,
  t0.domain AS domain_5,
  t0.description AS description_6,
  t0.image AS image_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.school_id AS school_id_10
FROM
  magazine t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.city_id AS city_id_7
FROM
  school t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = 2;