Symfony Profiler

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.published_at AS published_at_1
FROM
  symfony_demo_post s0_
  INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id
  LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id
  LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id
WHERE
  s0_.published_at <= ?
ORDER BY
  s0_.published_at DESC
LIMIT
  10 OFFSET 20

SELECT DISTINCT s0_.id AS id_0, s0_.published_at AS published_at_1 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= '2024-11-21 12:08:02' ORDER BY s0_.published_at DESC LIMIT 10 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,
  s1_.id AS id_6,
  s1_.full_name AS full_name_7,
  s1_.username AS username_8,
  s1_.email AS email_9,
  s1_.password AS password_10,
  s1_.roles AS roles_11,
  s2_.id AS id_12,
  s2_.name AS name_13,
  s0_.author_id AS author_id_14
FROM
  symfony_demo_post s0_
  INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id
  LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id
  LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id
WHERE
  s0_.published_at <= ?
  AND s0_.id IN (?)
ORDER BY
  s0_.published_at DESC,
  s2_.name ASC

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, s1_.id AS id_6, s1_.full_name AS full_name_7, s1_.username AS username_8, s1_.email AS email_9, s1_.password AS password_10, s1_.roles AS roles_11, s2_.id AS id_12, s2_.name AS name_13, s0_.author_id AS author_id_14 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= '2024-11-21 12:08:02' AND s0_.id IN (20, 21, 22, 23, 24, 25, 26, 27, 28, 29) ORDER BY s0_.published_at DESC, s2_.name ASC;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  symfony_demo_post s0_
  INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id
  LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id
  LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id
WHERE
  s0_.published_at <= ?

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= '2024-11-21 12:08:02';

SELECT
  DATABASE()

SELECT DATABASE();