Symfony Profiler

SELECT
  DISTINCT r0_.id AS id_0,
  r0_.sub_section_id AS sclr_1
FROM
  resource_assignment r0_
  LEFT JOIN resource_sub_section r1_ ON r0_.sub_section_id = r1_.id
ORDER BY
  r0_.sub_section_id DESC
LIMIT
  20

SELECT DISTINCT r0_.id AS id_0, r0_.sub_section_id AS sclr_1 FROM resource_assignment r0_ LEFT JOIN resource_sub_section r1_ ON r0_.sub_section_id = r1_.id ORDER BY r0_.sub_section_id DESC LIMIT 20;

SELECT
  r0_.id AS id_0,
  r0_.resource_id AS resource_id_1,
  r0_.sub_section_id AS sub_section_id_2
FROM
  resource_assignment r0_
  LEFT JOIN resource_sub_section r1_ ON r0_.sub_section_id = r1_.id
WHERE
  r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  r0_.sub_section_id DESC

SELECT r0_.id AS id_0, r0_.resource_id AS resource_id_1, r0_.sub_section_id AS sub_section_id_2 FROM resource_assignment r0_ LEFT JOIN resource_sub_section r1_ ON r0_.sub_section_id = r1_.id WHERE r0_.id IN (3, 2, 1, 9, 8, 7, 6, 5, 4) ORDER BY r0_.sub_section_id DESC;

SELECT
  t0.id AS id_3,
  t0.title AS title_4,
  t0.resource_type,
  t1.author AS author_5,
  t1.file_path AS file_path_6,
  t2.url AS url_7
FROM
  resource t0
  LEFT JOIN resource_documents t1 ON t0.id = t1.id
  LEFT JOIN resource_web t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = 2;

SELECT
  t0.id AS id_3,
  t0.title AS title_4,
  t0.resource_type,
  t1.author AS author_5,
  t1.file_path AS file_path_6,
  t2.url AS url_7
FROM
  resource t0
  LEFT JOIN resource_documents t1 ON t0.id = t1.id
  LEFT JOIN resource_web t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = 3;

SELECT
  t0.id AS id_3,
  t0.title AS title_4,
  t0.resource_type,
  t1.author AS author_5,
  t1.file_path AS file_path_6,
  t2.url AS url_7
FROM
  resource t0
  LEFT JOIN resource_documents t1 ON t0.id = t1.id
  LEFT JOIN resource_web t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = 1;

SELECT
  t0.id AS id_3,
  t0.title AS title_4,
  t0.resource_type,
  t1.author AS author_5,
  t1.file_path AS file_path_6,
  t2.url AS url_7
FROM
  resource t0
  LEFT JOIN resource_documents t1 ON t0.id = t1.id
  LEFT JOIN resource_web t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = 46;

SELECT
  t0.id AS id_3,
  t0.title AS title_4,
  t0.resource_type,
  t1.author AS author_5,
  t1.file_path AS file_path_6,
  t2.url AS url_7
FROM
  resource t0
  LEFT JOIN resource_documents t1 ON t0.id = t1.id
  LEFT JOIN resource_web t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = 48;

SELECT
  t0.id AS id_3,
  t0.title AS title_4,
  t0.resource_type,
  t1.author AS author_5,
  t1.file_path AS file_path_6,
  t2.url AS url_7
FROM
  resource t0
  LEFT JOIN resource_documents t1 ON t0.id = t1.id
  LEFT JOIN resource_web t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = 49;

SELECT
  t0.id AS id_3,
  t0.title AS title_4,
  t0.resource_type,
  t1.author AS author_5,
  t1.file_path AS file_path_6,
  t2.url AS url_7
FROM
  resource t0
  LEFT JOIN resource_documents t1 ON t0.id = t1.id
  LEFT JOIN resource_web t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = 50;

SELECT
  t0.id AS id_3,
  t0.title AS title_4,
  t0.resource_type,
  t1.author AS author_5,
  t1.file_path AS file_path_6,
  t2.url AS url_7
FROM
  resource t0
  LEFT JOIN resource_documents t1 ON t0.id = t1.id
  LEFT JOIN resource_web t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = 51;

SELECT
  t0.id AS id_3,
  t0.title AS title_4,
  t0.resource_type,
  t1.author AS author_5,
  t1.file_path AS file_path_6,
  t2.url AS url_7
FROM
  resource t0
  LEFT JOIN resource_documents t1 ON t0.id = t1.id
  LEFT JOIN resource_web t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = 52;

SELECT
  count(DISTINCT r0_.id) AS sclr_0
FROM
  resource_assignment r0_
  LEFT JOIN resource_sub_section r1_ ON r0_.sub_section_id = r1_.id

SELECT count(DISTINCT r0_.id) AS sclr_0 FROM resource_assignment r0_ LEFT JOIN resource_sub_section r1_ ON r0_.sub_section_id = r1_.id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.section_id AS section_id_3
FROM
  resource_sub_section t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.section_id AS section_id_3 FROM resource_sub_section t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.part_id AS part_id_3
FROM
  resource_section t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.part_id AS part_id_3 FROM resource_section t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  resource_part t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM resource_part t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.section_id AS section_id_3
FROM
  resource_sub_section t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.section_id AS section_id_3 FROM resource_sub_section t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.part_id AS part_id_3
FROM
  resource_section t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.part_id AS part_id_3 FROM resource_section t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  resource_part t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM resource_part t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.section_id AS section_id_3
FROM
  resource_sub_section t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.section_id AS section_id_3 FROM resource_sub_section t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.part_id AS part_id_3
FROM
  resource_section t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.part_id AS part_id_3 FROM resource_section t0 WHERE t0.id = 1;