Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 1638
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.data AS data_2, n0_.created_at AS created_at_3, n0_.published_at AS published_at_4, n0_.pinned AS pinned_5, n0_.status AS status_6, n0_.source AS source_7, n0_.vk_owner_id AS vk_owner_id_8, n0_.vk_post_id AS vk_post_id_9, n0_.vk_post_url AS vk_post_url_10, n0_.vk_auto_sync_enabled AS vk_auto_sync_enabled_11, n0_.vk_last_synced_at AS vk_last_synced_at_12, n0_.vk_unavailable_at AS vk_unavailable_at_13, CASE WHEN n0_.published_at IS NULL THEN 1 ELSE 0 END AS sclr_14, n0_.image_id AS image_id_15 FROM news n0_ WHERE n0_.pinned = true AND n0_.status = ? ORDER BY sclr_14 ASC, n0_.published_at DESC, n0_.created_at DESC, n0_.id DESC LIMIT 2

[
  "PUBLISHED"
]

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.data AS data_2,
  n0_.created_at AS created_at_3,
  n0_.published_at AS published_at_4,
  n0_.pinned AS pinned_5,
  n0_.status AS status_6,
  n0_.source AS source_7,
  n0_.vk_owner_id AS vk_owner_id_8,
  n0_.vk_post_id AS vk_post_id_9,
  n0_.vk_post_url AS vk_post_url_10,
  n0_.vk_auto_sync_enabled AS vk_auto_sync_enabled_11,
  n0_.vk_last_synced_at AS vk_last_synced_at_12,
  n0_.vk_unavailable_at AS vk_unavailable_at_13,
  CASE WHEN n0_.published_at IS NULL THEN
    1
  ELSE
    0
  END AS sclr_14,
  n0_.image_id AS image_id_15
FROM
  news n0_
WHERE
  n0_.pinned = true
  AND n0_.status = ?
ORDER BY
  sclr_14 ASC,
  n0_.published_at DESC,
  n0_.created_at DESC,
  n0_.id DESC
LIMIT
  2

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.data AS data_2, n0_.created_at AS created_at_3, n0_.published_at AS published_at_4, n0_.pinned AS pinned_5, n0_.status AS status_6, n0_.source AS source_7, n0_.vk_owner_id AS vk_owner_id_8, n0_.vk_post_id AS vk_post_id_9, n0_.vk_post_url AS vk_post_url_10, n0_.vk_auto_sync_enabled AS vk_auto_sync_enabled_11, n0_.vk_last_synced_at AS vk_last_synced_at_12, n0_.vk_unavailable_at AS vk_unavailable_at_13, CASE WHEN n0_.published_at IS NULL THEN 1 ELSE 0 END AS sclr_14, n0_.image_id AS image_id_15 FROM news n0_ WHERE n0_.pinned = true AND n0_.status = 'PUBLISHED' ORDER BY sclr_14 ASC, n0_.published_at DESC, n0_.created_at DESC, n0_.id DESC LIMIT 2;

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM news n0_ WHERE n0_.pinned = true AND n0_.status = ?

[
  "PUBLISHED"
]

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  news n0_
WHERE
  n0_.pinned = true
  AND n0_.status = ?

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM news n0_ WHERE n0_.pinned = true AND n0_.status = 'PUBLISHED';

SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?

[
  "c563eeb9-f21c-45d3-b915-30982849ea38"
]

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.filename AS filename_3,
  t0.s3_filename AS s3_filename_4,
  t0.extension AS extension_5,
  t0.size AS size_6,
  t0.created_at AS created_at_7
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = 'c563eeb9-f21c-45d3-b915-30982849ea38';

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.news_id AS news_id_3, t0.file_id AS file_id_4 FROM news_slider_photo t0 WHERE t0.news_id = ? ORDER BY t0.created_at ASC

[
  "d2ccc8b3-d8d1-4be7-ad56-494890097f7c"
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.news_id AS news_id_3,
  t0.file_id AS file_id_4
FROM
  news_slider_photo t0
WHERE
  t0.news_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.news_id AS news_id_3, t0.file_id AS file_id_4 FROM news_slider_photo t0 WHERE t0.news_id = 'd2ccc8b3-d8d1-4be7-ad56-494890097f7c' ORDER BY t0.created_at ASC;

SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?

[
  "6b29288c-afc9-4a94-91eb-c4fb9da3a451"
]

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.filename AS filename_3,
  t0.s3_filename AS s3_filename_4,
  t0.extension AS extension_5,
  t0.size AS size_6,
  t0.created_at AS created_at_7
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = '6b29288c-afc9-4a94-91eb-c4fb9da3a451';

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC

[
  "news"
  Symfony\Component\Uid\UuidV4 {#1257
    __toString(): "d2ccc8b3-d8d1-4be7-ad56-494890097f7c"
  }
]

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.color AS color_2,
  t0_.url AS url_3,
  t0_.created_at AS created_at_4
FROM
  tag t0_
  INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id)
WHERE
  t1_.target_type = ?
  AND t1_.target_id = ?
ORDER BY
  t0_.title ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'news' AND t1_.target_id = 'd2ccc8b3-d8d1-4be7-ad56-494890097f7c' ORDER BY t0_.title ASC;

SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?

[
  "e094a250-aa2e-4167-9822-3c13e1026ece"
]

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.filename AS filename_3,
  t0.s3_filename AS s3_filename_4,
  t0.extension AS extension_5,
  t0.size AS size_6,
  t0.created_at AS created_at_7
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = 'e094a250-aa2e-4167-9822-3c13e1026ece';

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.news_id AS news_id_3, t0.file_id AS file_id_4 FROM news_slider_photo t0 WHERE t0.news_id = ? ORDER BY t0.created_at ASC

[
  "4b9c165f-e397-476d-864c-ae88c1d0625e"
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.news_id AS news_id_3,
  t0.file_id AS file_id_4
FROM
  news_slider_photo t0
WHERE
  t0.news_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.news_id AS news_id_3, t0.file_id AS file_id_4 FROM news_slider_photo t0 WHERE t0.news_id = '4b9c165f-e397-476d-864c-ae88c1d0625e' ORDER BY t0.created_at ASC;

SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?

[
  "de6272ba-8f87-4c43-bf67-e385569dace2"
]

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.filename AS filename_3,
  t0.s3_filename AS s3_filename_4,
  t0.extension AS extension_5,
  t0.size AS size_6,
  t0.created_at AS created_at_7
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = 'de6272ba-8f87-4c43-bf67-e385569dace2';

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC

[
  "news"
  Symfony\Component\Uid\UuidV4 {#1210
    __toString(): "4b9c165f-e397-476d-864c-ae88c1d0625e"
  }
]

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.color AS color_2,
  t0_.url AS url_3,
  t0_.created_at AS created_at_4
FROM
  tag t0_
  INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id)
WHERE
  t1_.target_type = ?
  AND t1_.target_id = ?
ORDER BY
  t0_.title ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'news' AND t1_.target_id = '4b9c165f-e397-476d-864c-ae88c1d0625e' ORDER BY t0_.title ASC;