Symfony Profiler

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 = 'hi' 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 = ?
  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 = '/hi/index/categories' AND t0.date = '2026-03-24' AND t0.language_id = 3 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE hit_counter SET uri = 'http://nazranatimes.com/public/hi/index/categories', hits = 2, unique_views = 2 WHERE id = 259175;

"COMMIT"

"COMMIT";

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.active AS active_2,
  l0_.iso AS iso_3,
  l0_.color AS color_4,
  l0_.domain AS domain_5,
  l0_.name_in_language AS name_in_language_6,
  l0_.writing_direction AS writing_direction_7,
  l0_.time_zone AS time_zone_8
FROM
  language l0_
ORDER BY
  l0_.name ASC

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.active AS active_2, l0_.iso AS iso_3, l0_.color AS color_4, l0_.domain AS domain_5, l0_.name_in_language AS name_in_language_6, l0_.writing_direction AS writing_direction_7, l0_.time_zone AS time_zone_8 FROM language l0_ ORDER BY l0_.name ASC;

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 = 'hi' 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,
  c0_.language_id AS language_id_5,
  c0_.parent_id AS parent_id_6
FROM
  category c0_
WHERE
  c0_.language_id = ?
  AND c0_.active = ?
ORDER BY
  c0_.sorting_rank ASC,
  c0_.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, c0_.language_id AS language_id_5, c0_.parent_id AS parent_id_6 FROM category c0_ WHERE c0_.language_id = 3 AND c0_.active = 1 ORDER BY c0_.sorting_rank ASC, c0_.name ASC;

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
FROM
  news n0_
WHERE
  n0_.category_id = ?
  AND n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  5

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 FROM news n0_ WHERE n0_.category_id = 2081 AND n0_.language_id = 3 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 5;

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
FROM
  news n0_
WHERE
  n0_.category_id = ?
  AND n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  5

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 FROM news n0_ WHERE n0_.category_id = 2083 AND n0_.language_id = 3 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 5;

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
FROM
  news n0_
WHERE
  n0_.category_id = ?
  AND n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  5

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 FROM news n0_ WHERE n0_.category_id = 2094 AND n0_.language_id = 3 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 5;

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
FROM
  news n0_
WHERE
  n0_.category_id = ?
  AND n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  5

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 FROM news n0_ WHERE n0_.category_id = 2082 AND n0_.language_id = 3 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 5;

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
FROM
  news n0_
WHERE
  n0_.category_id = ?
  AND n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  5

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 FROM news n0_ WHERE n0_.category_id = 2093 AND n0_.language_id = 3 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 5;

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
FROM
  news n0_
WHERE
  n0_.category_id = ?
  AND n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  5

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 FROM news n0_ WHERE n0_.category_id = 2079 AND n0_.language_id = 3 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 5;

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
FROM
  news n0_
WHERE
  n0_.category_id = ?
  AND n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  5

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 FROM news n0_ WHERE n0_.category_id = 2084 AND n0_.language_id = 3 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 5;

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
FROM
  news n0_
WHERE
  n0_.category_id = ?
  AND n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  5

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 FROM news n0_ WHERE n0_.category_id = 2073 AND n0_.language_id = 3 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 5;

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
FROM
  news n0_
WHERE
  n0_.category_id = ?
  AND n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  5

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 FROM news n0_ WHERE n0_.category_id = 2080 AND n0_.language_id = 3 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 5;

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 = 'hi' 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

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 = 3 AND c0_.parent_id IS NULL AND c0_.active = 1 ORDER BY c0_.sorting_rank ASC, c1_.sorting_rank ASC, c1_.name 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 = 'header'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-24'
               AND a.end_date >= '2026-03-24';

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

SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'teknolaji';

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

SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'kavita';

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

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

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

SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'durghatana';

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

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