Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.name AS name_1,
          b0_.name_en AS name_en_2,
          b0_.client AS client_3,
          b0_.client_en AS client_en_4,
          b0_.description AS description_5,
          b0_.description_en AS description_en_6,
          b0_.created_at AS created_at_7,
          b0_.updated_at AS updated_at_8
        FROM
          blog b0_
        ORDER BY
          b0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.name_en AS name_en_2, b0_.client AS client_3, b0_.client_en AS client_en_4, b0_.description AS description_5, b0_.description_en AS description_en_6, b0_.created_at AS created_at_7, b0_.updated_at AS updated_at_8 FROM blog b0_ ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_7
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.name AS name_1,
          b0_.name_en AS name_en_2,
          b0_.client AS client_3,
          b0_.client_en AS client_en_4,
          b0_.description AS description_5,
          b0_.description_en AS description_en_6,
          b0_.created_at AS created_at_7,
          b0_.updated_at AS updated_at_8
        FROM
          blog b0_
      ) dctrn_result_inner
    ORDER BY
      created_at_7 DESC
  ) dctrn_result
LIMIT
  18

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_7 FROM (SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.name_en AS name_en_2, b0_.client AS client_3, b0_.client_en AS client_en_4, b0_.description AS description_5, b0_.description_en AS description_en_6, b0_.created_at AS created_at_7, b0_.updated_at AS updated_at_8 FROM blog b0_) dctrn_result_inner ORDER BY created_at_7 DESC) dctrn_result LIMIT 18;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.name_en AS name_en_2,
  b0_.client AS client_3,
  b0_.client_en AS client_en_4,
  b0_.description AS description_5,
  b0_.description_en AS description_en_6,
  b0_.created_at AS created_at_7,
  b0_.updated_at AS updated_at_8
FROM
  blog b0_
WHERE
  b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
ORDER BY
  b0_.created_at DESC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.name_en AS name_en_2, b0_.client AS client_3, b0_.client_en AS client_en_4, b0_.description AS description_5, b0_.description_en AS description_en_6, b0_.created_at AS created_at_7, b0_.updated_at AS updated_at_8 FROM blog b0_ WHERE b0_.id IN (1, 29, 28, 27, 26, 25, 24, 23, 22, 30, 31, 39, 38, 37, 36, 35, 34, 33) ORDER BY b0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 1;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 22;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 23;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 24;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 25;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 26;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 27;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 28;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 29;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 30;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 31;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 33;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 34;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 35;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 36;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 37;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 38;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.blog_id AS blog_id_5
FROM
  blog_photo t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.blog_id AS blog_id_5 FROM blog_photo t0 WHERE t0.blog_id = 39;