Symfony Profiler

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.published_at AS published_at_1
FROM
  symfony_demo_post s0_
ORDER BY
  s0_.published_at DESC
LIMIT
  20 OFFSET 20

SELECT DISTINCT s0_.id AS id_0, s0_.published_at AS published_at_1 FROM symfony_demo_post s0_ ORDER BY s0_.published_at DESC LIMIT 20 OFFSET 20;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.slug AS slug_2,
  s0_.summary AS summary_3,
  s0_.content AS content_4,
  s0_.published_at AS published_at_5,
  s0_.author_id AS author_id_6
FROM
  symfony_demo_post s0_
WHERE
  s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  s0_.published_at DESC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.summary AS summary_3, s0_.content AS content_4, s0_.published_at AS published_at_5, s0_.author_id AS author_id_6 FROM symfony_demo_post s0_ WHERE s0_.id IN (21, 22, 23, 24, 25, 26, 27, 28, 29, 30) ORDER BY s0_.published_at DESC;

SELECT
  count(s0_.id) AS sclr_0
FROM
  symfony_demo_post s0_

SELECT count(s0_.id) AS sclr_0 FROM symfony_demo_post s0_;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6
FROM
  symfony_demo_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6 FROM symfony_demo_user t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.published_at AS published_at_3,
  t0.post_id AS post_id_4,
  t0.author_id AS author_id_5
FROM
  symfony_demo_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.post_id = 21 ORDER BY t0.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.published_at AS published_at_3,
  t0.post_id AS post_id_4,
  t0.author_id AS author_id_5
FROM
  symfony_demo_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.post_id = 22 ORDER BY t0.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.published_at AS published_at_3,
  t0.post_id AS post_id_4,
  t0.author_id AS author_id_5
FROM
  symfony_demo_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.post_id = 23 ORDER BY t0.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.published_at AS published_at_3,
  t0.post_id AS post_id_4,
  t0.author_id AS author_id_5
FROM
  symfony_demo_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.post_id = 24 ORDER BY t0.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.published_at AS published_at_3,
  t0.post_id AS post_id_4,
  t0.author_id AS author_id_5
FROM
  symfony_demo_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.post_id = 25 ORDER BY t0.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6
FROM
  symfony_demo_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6 FROM symfony_demo_user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.published_at AS published_at_3,
  t0.post_id AS post_id_4,
  t0.author_id AS author_id_5
FROM
  symfony_demo_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.post_id = 26 ORDER BY t0.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.published_at AS published_at_3,
  t0.post_id AS post_id_4,
  t0.author_id AS author_id_5
FROM
  symfony_demo_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.post_id = 27 ORDER BY t0.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.published_at AS published_at_3,
  t0.post_id AS post_id_4,
  t0.author_id AS author_id_5
FROM
  symfony_demo_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.post_id = 28 ORDER BY t0.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.published_at AS published_at_3,
  t0.post_id AS post_id_4,
  t0.author_id AS author_id_5
FROM
  symfony_demo_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.post_id = 29 ORDER BY t0.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.published_at AS published_at_3,
  t0.post_id AS post_id_4,
  t0.author_id AS author_id_5
FROM
  symfony_demo_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.post_id = 30 ORDER BY t0.published_at DESC;