Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 8
• Events
• Routing
• Cache
• Translation 2
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.path AS path_2, t0.uri AS uri_3, t0.date AS date_4, t0.hits AS hits_5, t0.unique_views AS unique_views_6, t0.mime_type AS mime_type_7, t0.language_id AS language_id_8 FROM hit_counter t0 WHERE t0.path = ? AND t0.date = ? AND t0.language_id IS NULL LIMIT 1

[
  "/r/6"
  "2026-03-28"
]

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.uri AS uri_3,
  t0.date AS date_4,
  t0.hits AS hits_5,
  t0.unique_views AS unique_views_6,
  t0.mime_type AS mime_type_7,
  t0.language_id AS language_id_8
FROM
  hit_counter t0
WHERE
  t0.path = ?
  AND t0.date = ?
  AND t0.language_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.path AS path_2, t0.uri AS uri_3, t0.date AS date_4, t0.hits AS hits_5, t0.unique_views AS unique_views_6, t0.mime_type AS mime_type_7, t0.language_id AS language_id_8 FROM hit_counter t0 WHERE t0.path = '/r/6' AND t0.date = '2026-03-28' AND t0.language_id IS NULL LIMIT 1;

SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_

[]

SELECT
  SUM(h0_.hits) AS sclr_0,
  SUM(h0_.unique_views) AS sclr_1
FROM
  hit_counter h0_

SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_;

SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_ WHERE h0_.date = ?

[
  "2026-03-28 00:00:00"
]

SELECT
  SUM(h0_.hits) AS sclr_0,
  SUM(h0_.unique_views) AS sclr_1
FROM
  hit_counter h0_
WHERE
  h0_.date = ?

SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_ WHERE h0_.date = '2026-03-28 00:00:00';

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

[
  6
  "a"
]

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

SELECT COUNT(n0_.id) AS sclr_0 FROM news n0_ WHERE n0_.reporter_id = 6 AND n0_.status = 'a';

UPDATE hit_counter SET uri = ?, hits = ?, unique_views = ? WHERE id = ?

[
  "http://nazranatimes.com/r/6?lang=pa"
  2
  2
  276033
]

UPDATE
  hit_counter
SET
  uri = ?,
  hits = ?,
  unique_views = ?
WHERE
  id = ?

UPDATE hit_counter SET uri = 'http://nazranatimes.com/r/6?lang=pa', hits = 2, unique_views = 2 WHERE id = 276033;

SELECT n0_.id AS id_0, n0_.news_id AS news_id_1, n0_.title AS title_2, n0_.publish_date AS publish_date_3, n0_.created_on AS created_on_4, n0_.old_id AS old_id_5, c1_.name AS name_6, l2_.iso AS iso_7 FROM news n0_ INNER JOIN category c1_ ON n0_.category_id = c1_.id INNER JOIN language l2_ ON n0_.language_id = l2_.id WHERE n0_.reporter_id = ? AND n0_.status = ? ORDER BY n0_.publish_date DESC, n0_.id DESC LIMIT 10

[
  6
  "a"
]

SELECT
  n0_.id AS id_0,
  n0_.news_id AS news_id_1,
  n0_.title AS title_2,
  n0_.publish_date AS publish_date_3,
  n0_.created_on AS created_on_4,
  n0_.old_id AS old_id_5,
  c1_.name AS name_6,
  l2_.iso AS iso_7
FROM
  news n0_
  INNER JOIN category c1_ ON n0_.category_id = c1_.id
  INNER JOIN language l2_ ON n0_.language_id = l2_.id
WHERE
  n0_.reporter_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC,
  n0_.id DESC
LIMIT
  10

SELECT n0_.id AS id_0, n0_.news_id AS news_id_1, n0_.title AS title_2, n0_.publish_date AS publish_date_3, n0_.created_on AS created_on_4, n0_.old_id AS old_id_5, c1_.name AS name_6, l2_.iso AS iso_7 FROM news n0_ INNER JOIN category c1_ ON n0_.category_id = c1_.id INNER JOIN language l2_ ON n0_.language_id = l2_.id WHERE n0_.reporter_id = 6 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC, n0_.id DESC LIMIT 10;

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT COUNT(a.id)
             FROM advertisement a
             WHERE a.location = ?
               AND a.status = ?
               AND a.start_date <= ?
               AND a.end_date >= ?

[
  "header"
  "active"
  "2026-03-28"
  "2026-03-28"
]

SELECT
  COUNT(a.id)
FROM
  advertisement a
WHERE
  a.location = ?
  AND a.status = ?
  AND a.start_date <= ?
  AND a.end_date >= ?

SELECT COUNT(a.id)
             FROM advertisement a
             WHERE a.location = 'header'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-28'
               AND a.end_date >= '2026-03-28';

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.iso AS iso_4, t0.color AS color_5, t0.domain AS domain_6, t0.name_in_language AS name_in_language_7, t0.writing_direction AS writing_direction_8, t0.time_zone AS time_zone_9 FROM language t0 WHERE t0.iso = ? LIMIT 1

[
  "pa"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso AS iso_4,
  t0.color AS color_5,
  t0.domain AS domain_6,
  t0.name_in_language AS name_in_language_7,
  t0.writing_direction AS writing_direction_8,
  t0.time_zone AS time_zone_9
FROM
  language t0
WHERE
  t0.iso = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.iso AS iso_4, t0.color AS color_5, t0.domain AS domain_6, t0.name_in_language AS name_in_language_7, t0.writing_direction AS writing_direction_8, t0.time_zone AS time_zone_9 FROM language t0 WHERE t0.iso = 'pa' LIMIT 1;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.slug AS slug_3, c0_.sorting_rank AS sorting_rank_4, c1_.id AS id_5, c1_.name AS name_6, c1_.active AS active_7, c1_.slug AS slug_8, c1_.sorting_rank AS sorting_rank_9, c0_.language_id AS language_id_10, c0_.parent_id AS parent_id_11, c1_.language_id AS language_id_12, c1_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id AND (c1_.active = 1) WHERE c0_.language_id = ? AND c0_.parent_id IS NULL AND c0_.active = 1 ORDER BY c0_.sorting_rank ASC, c1_.sorting_rank ASC, c1_.name ASC

[
  1
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.slug AS slug_3,
  c0_.sorting_rank AS sorting_rank_4,
  c1_.id AS id_5,
  c1_.name AS name_6,
  c1_.active AS active_7,
  c1_.slug AS slug_8,
  c1_.sorting_rank AS sorting_rank_9,
  c0_.language_id AS language_id_10,
  c0_.parent_id AS parent_id_11,
  c1_.language_id AS language_id_12,
  c1_.parent_id AS parent_id_13
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.parent_id
  AND (c1_.active = 1)
WHERE
  c0_.language_id = ?
  AND c0_.parent_id IS NULL
  AND c0_.active = 1
ORDER BY
  c0_.sorting_rank ASC,
  c1_.sorting_rank ASC,
  c1_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.slug AS slug_3, c0_.sorting_rank AS sorting_rank_4, c1_.id AS id_5, c1_.name AS name_6, c1_.active AS active_7, c1_.slug AS slug_8, c1_.sorting_rank AS sorting_rank_9, c0_.language_id AS language_id_10, c0_.parent_id AS parent_id_11, c1_.language_id AS language_id_12, c1_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id AND (c1_.active = 1) WHERE c0_.language_id = 1 AND c0_.parent_id IS NULL AND c0_.active = 1 ORDER BY c0_.sorting_rank ASC, c1_.sorting_rank ASC, c1_.name ASC;

SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.file_name AS file_name_2, b0_.file_type AS file_type_3, l1_.iso AS iso_4 FROM branding_image b0_ LEFT JOIN language l1_ ON b0_.language_id = l1_.id WHERE b0_.type = ? AND l1_.iso = ? ORDER BY b0_.id DESC LIMIT 1

[
  "favIcon"
  "pa"
]

SELECT
  b0_.id AS id_0,
  b0_.type AS type_1,
  b0_.file_name AS file_name_2,
  b0_.file_type AS file_type_3,
  l1_.iso AS iso_4
FROM
  branding_image b0_
  LEFT JOIN language l1_ ON b0_.language_id = l1_.id
WHERE
  b0_.type = ?
  AND l1_.iso = ?
ORDER BY
  b0_.id DESC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.file_name AS file_name_2, b0_.file_type AS file_type_3, l1_.iso AS iso_4 FROM branding_image b0_ LEFT JOIN language l1_ ON b0_.language_id = l1_.id WHERE b0_.type = 'favIcon' AND l1_.iso = 'pa' ORDER BY b0_.id DESC LIMIT 1;

SELECT i0_.news_id AS sclr_0, MAX(i0_.id) AS sclr_1 FROM image_store i0_ WHERE i0_.is_primary = ? AND i0_.news_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY i0_.news_id

[
  1
  41546
  41545
  41537
  41516
  41515
  41514
  41498
  41491
  41454
]

SELECT
  i0_.news_id AS sclr_0,
  MAX(i0_.id) AS sclr_1
FROM
  image_store i0_
WHERE
  i0_.is_primary = ?
  AND i0_.news_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  i0_.news_id

SELECT i0_.news_id AS sclr_0, MAX(i0_.id) AS sclr_1 FROM image_store i0_ WHERE i0_.is_primary = 1 AND i0_.news_id IN (41546, 41545, 41537, 41516, 41515, 41514, 41498, 41491, 41454) GROUP BY i0_.news_id;

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4, t0.options AS options_5, t0.dev AS dev_6 FROM setting t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.type AS type_4,
  t0.options AS options_5,
  t0.dev AS dev_6
FROM
  setting t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4, t0.options AS options_5, t0.dev AS dev_6 FROM setting t0;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.email AS email_2 FROM reporter r0_ WHERE r0_.id = ?

[
  6
]

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.email AS email_2
FROM
  reporter r0_
WHERE
  r0_.id = ?

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.email AS email_2 FROM reporter r0_ WHERE r0_.id = 6;