GET http://nazranatimes.com/public/r/1?lang=en

Query Metrics

12 Database Queries
10 Different statements
416.48 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
189.62 ms
(45.53%)
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 IS NULL LIMIT 1
Parameters:
[
  "/r/1"
  "2026-03-24"
]
133.72 ms
(32.11%)
1
SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_
Parameters:
[]
87.68 ms
(21.05%)
1
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"
]
1.64 ms
(0.39%)
2
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"
]
1.11 ms
(0.27%)
2
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:
[
  "en"
]
0.73 ms
(0.17%)
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
Parameters:
[
  2
]
0.72 ms
(0.17%)
1
UPDATE hit_counter SET uri = ?, hits = ?, unique_views = ?, mime_type = ? WHERE id = ?
Parameters:
[
  "http://nazranatimes.com/public/r/1?lang=en"
  15
  15
  "*/*"
  257833
]
0.57 ms
(0.14%)
1
"COMMIT"
Parameters:
[]
0.47 ms
(0.11%)
1
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:
[]
0.22 ms
(0.05%)
1
"START TRANSACTION"
Parameters:
[]

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