Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short AS short_3,
  t0.public AS public_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.type AS type_8,
  t0.lft AS lft_9,
  t0.lvl AS lvl_10,
  t0.rgt AS rgt_11,
  t0.position AS position_12,
  t0.show_in_footer AS show_in_footer_13,
  t0.author_id AS author_id_14,
  t0.tree_root AS tree_root_15,
  t0.parent_id AS parent_id_16,
  t0.image_id AS image_id_17
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.short AS short_3, t0.public AS public_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type AS type_8, t0.lft AS lft_9, t0.lvl AS lvl_10, t0.rgt AS rgt_11, t0.position AS position_12, t0.show_in_footer AS show_in_footer_13, t0.author_id AS author_id_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17 FROM category t0 WHERE t0.parent_id = 221 ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short AS short_3,
  t0.text AS text_4,
  t0.public AS public_5,
  t0.slug AS slug_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.type AS type_9,
  t0.position AS position_10,
  t0.author_id AS author_id_11,
  t0.image_id AS image_id_12
FROM
  content t0
  INNER JOIN content_category ON t0.id = content_category.content_id
WHERE
  content_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short AS short_3, t0.text AS text_4, t0.public AS public_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.type AS type_9, t0.position AS position_10, t0.author_id AS author_id_11, t0.image_id AS image_id_12 FROM content t0 INNER JOIN content_category ON t0.id = content_category.content_id WHERE content_category.category_id = 13;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short AS short_3,
  t0.public AS public_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.type AS type_8,
  t0.lft AS lft_9,
  t0.lvl AS lvl_10,
  t0.rgt AS rgt_11,
  t0.position AS position_12,
  t0.show_in_footer AS show_in_footer_13,
  t0.author_id AS author_id_14,
  t0.tree_root AS tree_root_15,
  t0.parent_id AS parent_id_16,
  t0.image_id AS image_id_17
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short AS short_3, t0.public AS public_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type AS type_8, t0.lft AS lft_9, t0.lvl AS lvl_10, t0.rgt AS rgt_11, t0.position AS position_12, t0.show_in_footer AS show_in_footer_13, t0.author_id AS author_id_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17 FROM category t0 WHERE t0.id = 221;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.short AS short_2,
  c0_.public AS public_3,
  c0_.slug AS slug_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c0_.type AS type_7,
  c0_.lft AS lft_8,
  c0_.lvl AS lvl_9,
  c0_.rgt AS rgt_10,
  c0_.position AS position_11,
  c0_.show_in_footer AS show_in_footer_12,
  c0_.author_id AS author_id_13,
  c0_.tree_root AS tree_root_14,
  c0_.parent_id AS parent_id_15,
  c0_.image_id AS image_id_16
FROM
  category c0_
WHERE
  c0_.public = ?
  AND c0_.show_in_footer = ?
ORDER BY
  c0_.id ASC
LIMIT
  500

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short AS short_2, c0_.public AS public_3, c0_.slug AS slug_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.type AS type_7, c0_.lft AS lft_8, c0_.lvl AS lvl_9, c0_.rgt AS rgt_10, c0_.position AS position_11, c0_.show_in_footer AS show_in_footer_12, c0_.author_id AS author_id_13, c0_.tree_root AS tree_root_14, c0_.parent_id AS parent_id_15, c0_.image_id AS image_id_16 FROM category c0_ WHERE c0_.public = 1 AND c0_.show_in_footer = 1 ORDER BY c0_.id ASC LIMIT 500;

SELECT
  count(c0_.id) AS sclr_0
FROM
  category c0_
WHERE
  c0_.public = ?
  AND c0_.show_in_footer = ?

SELECT count(c0_.id) AS sclr_0 FROM category c0_ WHERE c0_.public = 1 AND c0_.show_in_footer = 1;