Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 WHERE t0.slug = 'marketing' LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.created_at AS created_at_3,
  b0_.updated_at AS updated_at_4,
  b0_.poster AS poster_5,
  b0_.published AS published_6,
  b0_.description AS description_7,
  b0_.short_description AS short_description_8,
  b0_.button_text AS button_text_9,
  b0_.button_link AS button_link_10,
  b0_.page_title AS page_title_11,
  b0_.meta_description AS meta_description_12,
  b0_.meta_keywords AS meta_keywords_13
FROM
  blog_post b0_
WHERE
  b0_.published = 1
ORDER BY
  b0_.updated_at DESC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.poster AS poster_5, b0_.published AS published_6, b0_.description AS description_7, b0_.short_description AS short_description_8, b0_.button_text AS button_text_9, b0_.button_link AS button_link_10, b0_.page_title AS page_title_11, b0_.meta_description AS meta_description_12, b0_.meta_keywords AS meta_keywords_13 FROM blog_post b0_ WHERE b0_.published = 1 ORDER BY b0_.updated_at DESC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2
FROM
  blog_tag b0_
  INNER JOIN blog_post_blog_tag b2_ ON b0_.id = b2_.blog_tag_id
  INNER JOIN blog_post b1_ ON b1_.id = b2_.blog_post_id
  AND (b1_.published = 1)

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2 FROM blog_tag b0_ INNER JOIN blog_post_blog_tag b2_ ON b0_.id = b2_.blog_tag_id INNER JOIN blog_post b1_ ON b1_.id = b2_.blog_post_id AND (b1_.published = 1);

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.created_at AS created_at_3,
  b0_.updated_at AS updated_at_4,
  b0_.poster AS poster_5,
  b0_.published AS published_6,
  b0_.description AS description_7,
  b0_.short_description AS short_description_8,
  b0_.button_text AS button_text_9,
  b0_.button_link AS button_link_10,
  b0_.page_title AS page_title_11,
  b0_.meta_description AS meta_description_12,
  b0_.meta_keywords AS meta_keywords_13
FROM
  blog_post b0_
  INNER JOIN blog_post_blog_tag b2_ ON b0_.id = b2_.blog_post_id
  INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id
WHERE
  b0_.published = 1
  AND b1_.id = ?
ORDER BY
  b0_.created_at DESC
LIMIT
  100

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.poster AS poster_5, b0_.published AS published_6, b0_.description AS description_7, b0_.short_description AS short_description_8, b0_.button_text AS button_text_9, b0_.button_link AS button_link_10, b0_.page_title AS page_title_11, b0_.meta_description AS meta_description_12, b0_.meta_keywords AS meta_keywords_13 FROM blog_post b0_ INNER JOIN blog_post_blog_tag b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id WHERE b0_.published = 1 AND b1_.id = 2 ORDER BY b0_.created_at DESC LIMIT 100;

SELECT
  count(b0_.id) AS sclr_0
FROM
  blog_post b0_
  INNER JOIN blog_post_blog_tag b2_ ON b0_.id = b2_.blog_post_id
  INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id
WHERE
  b0_.published = 1
  AND b1_.id = ?
ORDER BY
  b0_.created_at DESC

SELECT count(b0_.id) AS sclr_0 FROM blog_post b0_ INNER JOIN blog_post_blog_tag b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id WHERE b0_.published = 1 AND b1_.id = 2 ORDER BY b0_.created_at DESC;

SELECT
  m0_.id AS id_0,
  m0_.slug AS slug_1,
  m0_.title AS title_2
FROM
  module_page m0_
WHERE
  m0_.active = 1
ORDER BY
  m0_.pos ASC,
  m0_.id ASC

SELECT m0_.id AS id_0, m0_.slug AS slug_1, m0_.title AS title_2 FROM module_page m0_ WHERE m0_.active = 1 ORDER BY m0_.pos ASC, m0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN blog_post_blog_tag ON t0.id = blog_post_blog_tag.blog_tag_id
WHERE
  blog_post_blog_tag.blog_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_blog_tag ON t0.id = blog_post_blog_tag.blog_tag_id WHERE blog_post_blog_tag.blog_post_id = 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN blog_post_blog_tag ON t0.id = blog_post_blog_tag.blog_tag_id
WHERE
  blog_post_blog_tag.blog_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_blog_tag ON t0.id = blog_post_blog_tag.blog_tag_id WHERE blog_post_blog_tag.blog_post_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN blog_post_blog_tag ON t0.id = blog_post_blog_tag.blog_tag_id
WHERE
  blog_post_blog_tag.blog_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_blog_tag ON t0.id = blog_post_blog_tag.blog_tag_id WHERE blog_post_blog_tag.blog_post_id = 7;

SELECT
  m0_.id AS id_0,
  m0_.slug AS slug_1,
  m0_.title AS title_2
FROM
  module_page m0_
WHERE
  m0_.active = 1
ORDER BY
  m0_.pos ASC,
  m0_.id ASC

SELECT m0_.id AS id_0, m0_.slug AS slug_1, m0_.title AS title_2 FROM module_page m0_ WHERE m0_.active = 1 ORDER BY m0_.pos ASC, m0_.id ASC;

SELECT
  m0_.id AS id_0,
  m0_.slug AS slug_1,
  m0_.title AS title_2
FROM
  module_page m0_
WHERE
  m0_.active = 1
ORDER BY
  m0_.pos ASC,
  m0_.id ASC

SELECT m0_.id AS id_0, m0_.slug AS slug_1, m0_.title AS title_2 FROM module_page m0_ WHERE m0_.active = 1 ORDER BY m0_.pos ASC, m0_.id ASC;