Symfony Profiler

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

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 <= ?
  AND EXISTS (
    SELECT
      1
    FROM
      symfony_demo_post_tag s4_
    WHERE
      s4_.post_id = s0_.id
      AND s4_.tag_id IN (?)
  )
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 <= '2026-03-04 23:46:21' AND EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (3)) ORDER BY s0_.published_at DESC LIMIT 10 OFFSET 20;

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 <= ?
  AND EXISTS (
    SELECT
      1
    FROM
      symfony_demo_post_tag s4_
    WHERE
      s4_.post_id = s0_.id
      AND s4_.tag_id IN (?)
  )

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 <= '2026-03-04 23:46:21' AND EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (3));

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  symfony_demo_tag t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM symfony_demo_tag t0 WHERE t0.name = 'consectetur' LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();