Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.author AS author_1,
  p0_.link AS link_2,
  p0_.file_details_name AS file_details_name_3,
  p0_.date AS date_4,
  p0_.image_name AS image_name_5,
  p0_.title AS title_6,
  p0_.description AS description_7,
  p0_.created_at AS created_at_8,
  c1_.name AS name_9,
  c1_.name_eng AS name_eng_10
FROM
  post p0_
  INNER JOIN category c1_ ON p0_.category_id = c1_.id
WHERE
  p0_.id IN (?)
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.author AS author_1, p0_.link AS link_2, p0_.file_details_name AS file_details_name_3, p0_.date AS date_4, p0_.image_name AS image_name_5, p0_.title AS title_6, p0_.description AS description_7, p0_.created_at AS created_at_8, c1_.name AS name_9, c1_.name_eng AS name_eng_10 FROM post p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.id IN (31, 30, 29) ORDER BY p0_.created_at DESC;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  post p0_
  INNER JOIN category c1_ ON p0_.category_id = c1_.id

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM post p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id;

SELECT
  t0.id AS id_1,
  t0.author AS author_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.date AS date_5,
  t0.link AS link_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.image_name AS image_name_9,
  t0.image_original_name AS image_original_name_10,
  t0.image_mime_type AS image_mime_type_11,
  t0.image_size AS image_size_12,
  t0.image_dimensions AS image_dimensions_13,
  t0.author_image_name AS author_image_name_14,
  t0.author_image_original_name AS author_image_original_name_15,
  t0.author_image_mime_type AS author_image_mime_type_16,
  t0.author_image_size AS author_image_size_17,
  t0.author_image_dimensions AS author_image_dimensions_18,
  t0.file_details_name AS file_details_name_19,
  t0.file_details_original_name AS file_details_original_name_20,
  t0.file_details_mime_type AS file_details_mime_type_21,
  t0.file_details_size AS file_details_size_22,
  t0.file_details_dimensions AS file_details_dimensions_23,
  t0.user_id AS user_id_24,
  t0.category_id AS category_id_25
FROM
  post t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.author_image_name AS author_image_name_14, t0.author_image_original_name AS author_image_original_name_15, t0.author_image_mime_type AS author_image_mime_type_16, t0.author_image_size AS author_image_size_17, t0.author_image_dimensions AS author_image_dimensions_18, t0.file_details_name AS file_details_name_19, t0.file_details_original_name AS file_details_original_name_20, t0.file_details_mime_type AS file_details_mime_type_21, t0.file_details_size AS file_details_size_22, t0.file_details_dimensions AS file_details_dimensions_23, t0.user_id AS user_id_24, t0.category_id AS category_id_25 FROM post t0 WHERE t0.category_id = 1;

SELECT
  p0_.id AS id_0,
  p0_.author AS author_1,
  p0_.title AS title_2,
  p0_.description AS description_3,
  p0_.date AS date_4,
  p0_.link AS link_5,
  p0_.created_at AS created_at_6,
  p0_.updated_at AS updated_at_7,
  p0_.image_name AS image_name_8,
  p0_.image_original_name AS image_original_name_9,
  p0_.image_mime_type AS image_mime_type_10,
  p0_.image_size AS image_size_11,
  p0_.image_dimensions AS image_dimensions_12,
  p0_.author_image_name AS author_image_name_13,
  p0_.author_image_original_name AS author_image_original_name_14,
  p0_.author_image_mime_type AS author_image_mime_type_15,
  p0_.author_image_size AS author_image_size_16,
  p0_.author_image_dimensions AS author_image_dimensions_17,
  p0_.file_details_name AS file_details_name_18,
  p0_.file_details_original_name AS file_details_original_name_19,
  p0_.file_details_mime_type AS file_details_mime_type_20,
  p0_.file_details_size AS file_details_size_21,
  p0_.file_details_dimensions AS file_details_dimensions_22,
  p0_.user_id AS user_id_23,
  p0_.category_id AS category_id_24
FROM
  post p0_
ORDER BY
  p0_.created_at DESC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.author AS author_1, p0_.title AS title_2, p0_.description AS description_3, p0_.date AS date_4, p0_.link AS link_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.image_name AS image_name_8, p0_.image_original_name AS image_original_name_9, p0_.image_mime_type AS image_mime_type_10, p0_.image_size AS image_size_11, p0_.image_dimensions AS image_dimensions_12, p0_.author_image_name AS author_image_name_13, p0_.author_image_original_name AS author_image_original_name_14, p0_.author_image_mime_type AS author_image_mime_type_15, p0_.author_image_size AS author_image_size_16, p0_.author_image_dimensions AS author_image_dimensions_17, p0_.file_details_name AS file_details_name_18, p0_.file_details_original_name AS file_details_original_name_19, p0_.file_details_mime_type AS file_details_mime_type_20, p0_.file_details_size AS file_details_size_21, p0_.file_details_dimensions AS file_details_dimensions_22, p0_.user_id AS user_id_23, p0_.category_id AS category_id_24 FROM post p0_ ORDER BY p0_.created_at DESC LIMIT 10;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.created_at AS created_at_1
FROM
  post p0_
  INNER JOIN category c1_ ON p0_.category_id = c1_.id
ORDER BY
  p0_.created_at DESC
LIMIT
  3

SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1 FROM post p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id ORDER BY p0_.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.name_eng AS name_eng_6
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.name_eng AS name_eng_6 FROM category t0;