GET http://nazranatimes.com/public/pa/index/categories

Query Metrics

59 Database Queries
14 Different statements
751.48 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.62 ms
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
Parameters:
[
  "pa"
]
2 444.43 ms
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
Parameters:
[
  "/pa/index/categories"
  "2026-03-24"
  1
]
3 0.27 ms
"START TRANSACTION"
Parameters:
[]
4 0.81 ms
UPDATE hit_counter SET uri = ?, hits = ?, unique_views = ?, mime_type = ? WHERE id = ?
Parameters:
[
  "http://nazranatimes.com/public/pa/index/categories"
  2
  2
  "*/*"
  258715
]
5 0.99 ms
"COMMIT"
Parameters:
[]
6 0.49 ms
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
Parameters:
[]
7 0.45 ms
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
Parameters:
[
  "pa"
]
8 0.56 ms
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
Parameters:
[
  1
  1
]
9 2.87 ms
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
Parameters:
[
  2075
  1
  "a"
]
10 3.69 ms
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
Parameters:
[
  1042
  1
  "a"
]
11 2.77 ms
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
Parameters:
[
  1045
  1
  "a"
]
12 1.79 ms
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
Parameters:
[
  1043
  1
  "a"
]
13 0.46 ms
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
Parameters:
[
  2077
  1
  "a"
]
14 1.22 ms
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
Parameters:
[
  1040
  1
  "a"
]
15 0.71 ms
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
Parameters:
[
  1179
  1
  "a"
]
16 1.31 ms
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
Parameters:
[
  1132
  1
  "a"
]
17 0.70 ms
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
Parameters:
[
  2076
  1
  "a"
]
18 0.67 ms
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
Parameters:
[
  2096
  1
  "a"
]
19 0.52 ms
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
Parameters:
[
  1210
  1
  "a"
]
20 0.78 ms
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
Parameters:
[
  1197
  1
  "a"
]
21 0.56 ms
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
Parameters:
[
  2074
  1
  "a"
]
22 0.70 ms
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
Parameters:
[
  1039
  1
  "a"
]
23 1.15 ms
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
Parameters:
[
  1037
  1
  "a"
]
24 0.56 ms
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
Parameters:
[
  2089
  1
  "a"
]
25 0.54 ms
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
Parameters:
[
  1104
  1
  "a"
]
26 0.53 ms
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
Parameters:
[
  1041
  1
  "a"
]
27 2.03 ms
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
Parameters:
[
  1038
  1
  "a"
]
28 0.56 ms
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
Parameters:
[
  1275
  1
  "a"
]
29 2.37 ms
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
Parameters:
[
  1044
  1
  "a"
]
30 0.65 ms
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
Parameters:
[
  1295
  1
  "a"
]
31 0.40 ms
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
Parameters:
[
  "pa"
]
32 1.07 ms
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
Parameters:
[
  1
]
33 0.58 ms
SELECT COUNT(a.id)
             FROM advertisement a
             WHERE a.location = ?
               AND a.status = ?
               AND a.start_date <= ?
               AND a.end_date >= ?
Parameters:
[
  "header"
  "active"
  "2026-03-24"
  "2026-03-24"
]
34 0.49 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "dharamika-rajaniti"
]
35 0.48 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "atararasatari"
]
36 0.49 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "gurabani-itihasa"
]
37 0.46 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "archived"
]
38 0.46 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "religeus"
]
39 0.47 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "aparadha"
]
40 0.45 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "sapadaki"
]
41 0.47 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "samaja-seva"
]
42 0.46 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "sikhi-a-vigi-ana"
]
43 0.45 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "soga-dukha-da-pragatava"
]
44 0.45 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kahani"
]
45 0.44 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kanuna"
]
46 0.45 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kavita"
]
47 0.46 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "karobara"
]
48 0.45 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kheda"
]
49 0.45 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "conam"
]
50 0.44 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "jivana-saili"
]
51 0.47 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "taikanoloji"
]
52 0.48 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "rasatari"
]
53 0.49 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "manorajana"
]
54 0.46 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "rajaniti"
]
55 0.46 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "vana-suvana"
]
56 0.56 ms
SELECT COUNT(a.id)
             FROM advertisement a
             WHERE a.location = ?
               AND a.status = ?
               AND a.start_date <= ?
               AND a.end_date >= ?
Parameters:
[
  "mega_footer"
  "active"
  "2026-03-24"
  "2026-03-24"
]
57 0.60 ms
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
Parameters:
[]
58 162.08 ms
SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_
Parameters:
[]
59 100.26 ms
SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_ WHERE h0_.date = ?
Parameters:
[
  "2026-03-24 00:00:00"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping