Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.48 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 0.53 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 0.51 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.45 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 5.54 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:
[
  1295
  1
]
6 32.85 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:
[
  1295
  1295
  1
  "a"
]
7 8.23 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 3.45 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 4.67 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 7.74 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "dharamika-rajaniti"
]
11 0.46 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "atararasatari"
]
12 0.42 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "gurabani-itihasa"
]
13 0.40 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "archived"
]
14 0.40 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "religeus"
]
15 0.40 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "aparadha"
]
16 8.87 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "sapadaki"
]
17 0.39 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "samaja-seva"
]
18 0.44 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "sikhi-a-vigi-ana"
]
19 0.35 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "soga-dukha-da-pragatava"
]
20 0.37 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kahani"
]
21 0.37 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kanuna"
]
22 0.35 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kavita"
]
23 0.35 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "karobara"
]
24 0.36 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kheda"
]
25 0.36 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "conam"
]
26 5.17 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "jivana-saili"
]
27 2.77 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "taikanoloji"
]
28 0.38 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "rasatari"
]
29 0.38 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "manorajana"
]
30 0.35 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "rajaniti"
]
31 0.37 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.