Symfony Profiler

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_.content AS content_4,
  n0_.old_id AS old_id_5
FROM
  news n0_
  LEFT JOIN news_additional_categories n2_ ON n0_.id = n2_.news_id
  LEFT JOIN category c1_ ON c1_.id = n2_.category_id
WHERE
  (
    (
      n0_.category_id = ?
      OR c1_.id = ?
    )
  )
  AND n0_.language_id = ?
  AND n0_.status = ?
GROUP BY
  n0_.id,
  n0_.news_id,
  n0_.title,
  n0_.publish_date,
  n0_.content,
  n0_.old_id
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_.content AS content_4, n0_.old_id AS old_id_5 FROM news n0_ LEFT JOIN news_additional_categories n2_ ON n0_.id = n2_.news_id LEFT JOIN category c1_ ON c1_.id = n2_.category_id WHERE ((n0_.category_id = 1041 OR c1_.id = 1041)) AND n0_.language_id = 1 AND n0_.status = 'a' GROUP BY n0_.id, n0_.news_id, n0_.title, n0_.publish_date, n0_.content, n0_.old_id ORDER BY n0_.publish_date DESC, n0_.id DESC LIMIT 10;

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 = ?
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 = '/pa/category/1041/taikanoloji' AND t0.date = '2026-03-26' AND t0.language_id = 1 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_
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-26 00:00:00';

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  news n0_
  LEFT JOIN news_additional_categories n2_ ON n0_.id = n2_.news_id
  LEFT JOIN category c1_ ON c1_.id = n2_.category_id
WHERE
  (
    (
      n0_.category_id = ?
      OR c1_.id = ?
    )
  )
  AND n0_.language_id = ?
  AND n0_.status = ?

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM news n0_ LEFT JOIN news_additional_categories n2_ ON n0_.id = n2_.news_id LEFT JOIN category c1_ ON c1_.id = n2_.category_id WHERE ((n0_.category_id = 1041 OR c1_.id = 1041)) AND n0_.language_id = 1 AND n0_.status = 'a';

"COMMIT"

"COMMIT";

SELECT
  a.id,
  a.location,
  a.banner_size,
  a.url
FROM
  advertisement a
WHERE
  a.location = ?
  AND a.status = ?
  AND a.start_date <= ?
  AND a.end_date >= ?
ORDER BY
  a.id ASC
LIMIT
  1
OFFSET
  ?

SELECT a.id, a.location, a.banner_size, a.url
             FROM advertisement a
             WHERE a.location = 'sidebar'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-26'
               AND a.end_date >= '2026-03-26'
             ORDER BY a.id ASC
             LIMIT 1 OFFSET 0;

SELECT
  COUNT(*)
FROM
  category t0
WHERE
  t0.slug = ?

SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'dharamika-rajaniti';

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 (45028, 45025, 45019, 44985, 44968, 44967, 44965, 44927, 44900, 44896) GROUP BY i0_.news_id;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.url AS url_2,
  e0_.target AS target_3,
  e0_.is_active AS is_active_4,
  e0_.location AS location_5,
  e0_.icon AS icon_6,
  e0_.sorting_order AS sorting_order_7,
  e1_.id AS id_8,
  e1_.name AS name_9,
  e1_.url AS url_10,
  e1_.target AS target_11,
  e1_.is_active AS is_active_12,
  e1_.location AS location_13,
  e1_.icon AS icon_14,
  e1_.sorting_order AS sorting_order_15,
  e0_.parent_id AS parent_id_16,
  e1_.parent_id AS parent_id_17
FROM
  extra_nav e0_
  LEFT JOIN extra_nav e1_ ON e0_.parent_id = e1_.id
WHERE
  e0_.location = ?
  AND e0_.is_active = ?
ORDER BY
  e0_.sorting_order ASC,
  e0_.id ASC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.url AS url_2, e0_.target AS target_3, e0_.is_active AS is_active_4, e0_.location AS location_5, e0_.icon AS icon_6, e0_.sorting_order AS sorting_order_7, e1_.id AS id_8, e1_.name AS name_9, e1_.url AS url_10, e1_.target AS target_11, e1_.is_active AS is_active_12, e1_.location AS location_13, e1_.icon AS icon_14, e1_.sorting_order AS sorting_order_15, e0_.parent_id AS parent_id_16, e1_.parent_id AS parent_id_17 FROM extra_nav e0_ LEFT JOIN extra_nav e1_ ON e0_.parent_id = e1_.id WHERE e0_.location = 'bottom' AND e0_.is_active = 1 ORDER BY e0_.sorting_order ASC, e0_.id ASC;

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 = 'sidebar'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-26'
               AND a.end_date >= '2026-03-26';

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
  i0_.text_value AS text_value_0
FROM
  includs_in_web i0_
WHERE
  i0_.location = ?
  AND i0_.active = ?
ORDER BY
  i0_.sorting_rank ASC,
  i0_.id DESC

SELECT i0_.text_value AS text_value_0 FROM includs_in_web i0_ WHERE i0_.location = 'inHead' AND i0_.active = 1 ORDER BY i0_.sorting_rank ASC, i0_.id DESC;

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
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.slug AS slug_2,
  w0_.url AS url_3,
  w0_.location AS location_4,
  w0_.sorting_rank AS sorting_rank_5,
  w0_.is_home AS is_home_6
FROM
  web_page w0_
WHERE
  w0_.is_published = ?
ORDER BY
  w0_.sorting_rank ASC

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.url AS url_3, w0_.location AS location_4, w0_.sorting_rank AS sorting_rank_5, w0_.is_home AS is_home_6 FROM web_page w0_ WHERE w0_.is_published = 1 ORDER BY w0_.sorting_rank 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 = ?
  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
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2
FROM
  category c0_
WHERE
  c0_.id = ?
  AND c0_.language_id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM category c0_ WHERE c0_.id = 1041 AND c0_.language_id = 1;

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

UPDATE hit_counter SET uri = 'http://nazranatimes.com/public/pa/category/1041/taikanoloji', hits = 3, unique_views = 3, mime_type = '*/*' WHERE id = 267416;

SELECT
  l0_.name AS name_0,
  l0_.value AS value_1
FROM
  layout_setting l0_

SELECT l0_.name AS name_0, l0_.value AS value_1 FROM layout_setting l0_;