Query Metrics

31 Database Queries
7 Different statements
171.38 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.96 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 10.15 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"
]
3 2.24 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.70 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 1.83 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:
[
  1037
  1
]
6 126.63 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:
[
  1037
  1037
  1
  "a"
]
7 1.24 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 1.46 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
]
9 0.85 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.80 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "dharamika-rajaniti"
]
11 0.80 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "atararasatari"
]
12 1.01 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "gurabani-itihasa"
]
13 0.82 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "archived"
]
14 0.80 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "religeus"
]
15 0.96 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "aparadha"
]
16 0.97 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "sapadaki"
]
17 0.86 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "samaja-seva"
]
18 0.82 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "sikhi-a-vigi-ana"
]
19 0.85 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "soga-dukha-da-pragatava"
]
20 1.51 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kahani"
]
21 0.78 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kanuna"
]
22 1.11 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kavita"
]
23 1.19 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "karobara"
]
24 1.35 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kheda"
]
25 6.98 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "conam"
]
26 0.62 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "jivana-saili"
]
27 0.61 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "taikanoloji"
]
28 0.59 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "rasatari"
]
29 0.61 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "manorajana"
]
30 0.72 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "rajaniti"
]
31 0.55 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "vana-suvana"
]

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.