GET http://nazranatimes.com/public/hi/category/2073/rajaniti

Query Metrics

21 Database Queries
9 Different statements
459.65 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.78 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:
[
  "hi"
]
2 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:
[
  "hi"
]
3 3.06 ms
SELECT COUNT(a.id)
             FROM advertisement a
             WHERE a.location = ?
               AND a.status = ?
               AND a.start_date <= ?
               AND a.end_date >= ?
Parameters:
[
  "sidebar"
  "active"
  "2026-03-24"
  "2026-03-24"
]
4 0.38 ms
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 ?
Parameters:
[
  "sidebar"
  "active"
  "2026-03-24"
  "2026-03-24"
  0
]
5 0.65 ms
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 = ?
Parameters:
[
  2073
  3
]
6 3.18 ms
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 = ?
Parameters:
[
  2073
  2073
  3
  "a"
]
7 0.91 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:
[
  "hi"
]
8 0.62 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:
[
  3
]
9 0.37 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"
]
10 0.35 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "teknolaji"
]
11 0.31 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kavita"
]
12 0.31 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "dharmika-rajaniti"
]
13 0.31 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "durghatana"
]
14 0.32 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "rajaniti"
]
15 0.32 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kanuna-kra-ima"
]
16 0.32 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "dharmika"
]
17 0.32 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "samajika"
]
18 0.31 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "intaranesanala"
]
19 441.85 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, 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
Parameters:
[
  2073
  2073
  3
  "a"
]
20 0.80 ms
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
Parameters:
[
  1
  45092
  45087
  45084
  45081
  45078
  45031
  45027
  45024
  45018
  45014
]
21 0.73 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"
]

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

Class Mapping errors
App\Entity\Language No errors.
App\Entity\Category No errors.
App\Entity\News No errors.
App\Entity\BrandingImage No errors.
App\Entity\Advertisement No errors.
App\Entity\ImageStore No errors.
App\Entity\Comment No errors.
App\Entity\Reporter No errors.
App\Entity\ImageNewsMapper No errors.
App\Entity\Author No errors.
App\Entity\AdditionalImage No errors.
App\Entity\NewsStat No errors.