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

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;

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 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20) 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 = 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 = 1 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 = 2 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 = 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 = 3 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 = 4 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 = 5 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 = 6 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 = 7 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 = 8 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 = 9 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 = 10 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 = 11 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 = 12 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 = 13 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 = 14 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 = 15 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 = 16 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 = 17 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 = 18 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 = 19 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 = 20 ORDER BY t0.published_at DESC;