Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.section AS section_4,
  t0.type AS type_5
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = 'number_of_article_per_page' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.photo AS photo_4,
  t0.description AS description_5,
  t0.parent_id AS parent_id_6
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.photo AS photo_4, t0.description AS description_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.slug = 'school' LIMIT 1;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  post p0_
  INNER JOIN post_category p2_ ON p0_.id = p2_.post_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
WHERE
  c1_.id = ?
  AND p0_.published = 1
GROUP BY
  p0_.id

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM post p0_ INNER JOIN post_category p2_ ON p0_.id = p2_.post_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id = 4 AND p0_.published = 1 GROUP BY p0_.id;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m1_.id AS id_2,
  m1_.name AS name_3,
  m1_.position AS position_4,
  m1_.url AS url_5,
  m2_.id AS id_6,
  m2_.name AS name_7,
  m2_.position AS position_8,
  m2_.url AS url_9,
  p3_.id AS id_10,
  p3_.title AS title_11,
  p3_.thumbnail AS thumbnail_12,
  p3_.seo_title AS seo_title_13,
  p3_.slug AS slug_14,
  p3_.brief AS brief_15,
  p3_.content AS content_16,
  p3_.created_at AS created_at_17,
  p3_.updated_at AS updated_at_18,
  p4_.id AS id_19,
  p4_.title AS title_20,
  p4_.thumbnail AS thumbnail_21,
  p4_.seo_title AS seo_title_22,
  p4_.slug AS slug_23,
  p4_.brief AS brief_24,
  p4_.content AS content_25,
  p4_.created_at AS created_at_26,
  p4_.updated_at AS updated_at_27,
  m1_.menu_id AS menu_id_28,
  m1_.parent_id AS parent_id_29,
  m1_.page_id AS page_id_30,
  m2_.menu_id AS menu_id_31,
  m2_.parent_id AS parent_id_32,
  m2_.page_id AS page_id_33
FROM
  menu m0_
  LEFT JOIN menu_item m1_ ON m0_.id = m1_.menu_id
  LEFT JOIN menu_item m2_ ON m1_.id = m2_.parent_id
  LEFT JOIN page p3_ ON m1_.page_id = p3_.id
  LEFT JOIN page p4_ ON m2_.page_id = p4_.id
WHERE
  m0_.name = ?
ORDER BY
  m1_.position ASC,
  m2_.position ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m1_.id AS id_2, m1_.name AS name_3, m1_.position AS position_4, m1_.url AS url_5, m2_.id AS id_6, m2_.name AS name_7, m2_.position AS position_8, m2_.url AS url_9, p3_.id AS id_10, p3_.title AS title_11, p3_.thumbnail AS thumbnail_12, p3_.seo_title AS seo_title_13, p3_.slug AS slug_14, p3_.brief AS brief_15, p3_.content AS content_16, p3_.created_at AS created_at_17, p3_.updated_at AS updated_at_18, p4_.id AS id_19, p4_.title AS title_20, p4_.thumbnail AS thumbnail_21, p4_.seo_title AS seo_title_22, p4_.slug AS slug_23, p4_.brief AS brief_24, p4_.content AS content_25, p4_.created_at AS created_at_26, p4_.updated_at AS updated_at_27, m1_.menu_id AS menu_id_28, m1_.parent_id AS parent_id_29, m1_.page_id AS page_id_30, m2_.menu_id AS menu_id_31, m2_.parent_id AS parent_id_32, m2_.page_id AS page_id_33 FROM menu m0_ LEFT JOIN menu_item m1_ ON m0_.id = m1_.menu_id LEFT JOIN menu_item m2_ ON m1_.id = m2_.parent_id LEFT JOIN page p3_ ON m1_.page_id = p3_.id LEFT JOIN page p4_ ON m2_.page_id = p4_.id WHERE m0_.name = 'Header' ORDER BY m1_.position ASC, m2_.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.brief AS brief_3,
  p0_.content AS content_4,
  p0_.source AS source_5,
  p0_.photo AS photo_6,
  p0_.seo_title AS seo_title_7,
  p0_.seo_desc AS seo_desc_8,
  p0_.published AS published_9,
  p0_.deleted_at AS deleted_at_10,
  p0_.created_at AS created_at_11,
  p0_.updated_at AS updated_at_12,
  c1_.id AS id_13,
  c1_.name AS name_14,
  c1_.slug AS slug_15,
  c1_.photo AS photo_16,
  c1_.description AS description_17,
  p0_.created_by_id AS created_by_id_18,
  c1_.parent_id AS parent_id_19
FROM
  post p0_
  INNER JOIN post_category p2_ ON p0_.id = p2_.post_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
WHERE
  c1_.id = ?
  AND p0_.published = 1
  AND p0_.id IN (?, ?, ?)
GROUP BY
  p0_.id
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c1_.photo AS photo_16, c1_.description AS description_17, p0_.created_by_id AS created_by_id_18, c1_.parent_id AS parent_id_19 FROM post p0_ INNER JOIN post_category p2_ ON p0_.id = p2_.post_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id = 4 AND p0_.published = 1 AND p0_.id IN (4, 3, 2) GROUP BY p0_.id ORDER BY p0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.gender AS gender_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.gender AS gender_6 FROM user t0 WHERE t0.id = 1;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.created_at AS created_at_1
FROM
  post p0_
  INNER JOIN post_category p2_ ON p0_.id = p2_.post_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
WHERE
  c1_.id = ?
  AND p0_.published = 1
GROUP BY
  p0_.id
ORDER BY
  p0_.created_at DESC
LIMIT
  5

SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1 FROM post p0_ INNER JOIN post_category p2_ ON p0_.id = p2_.post_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id = 4 AND p0_.published = 1 GROUP BY p0_.id ORDER BY p0_.created_at DESC LIMIT 5;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.brief AS brief_3,
  p0_.content AS content_4,
  p0_.source AS source_5,
  p0_.photo AS photo_6,
  p0_.seo_title AS seo_title_7,
  p0_.seo_desc AS seo_desc_8,
  p0_.published AS published_9,
  p0_.deleted_at AS deleted_at_10,
  p0_.created_at AS created_at_11,
  p0_.updated_at AS updated_at_12,
  p0_.created_by_id AS created_by_id_13
FROM
  post p0_
WHERE
  p0_.published = 1
ORDER BY
  p0_.updated_at DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.published = 1 ORDER BY p0_.updated_at DESC LIMIT 5;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.photo AS photo_3,
  c0_.description AS description_4,
  c0_.parent_id AS parent_id_5
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.photo AS photo_3, c0_.description AS description_4, c0_.parent_id AS parent_id_5 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC;