GET https://statskenya.co.ke/public/at-stats-kenya/category/Banking%2520and%2520Finance/8/

Query Metrics

14 Database Queries
7 Different statements
279.37 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 91.36 ms
SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.post_id AS post_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM post_view_stats t0 WHERE t0.post_id = ? AND t0.start_day_time = ? LIMIT 1
Parameters:
[
  3
  "2026-04-15"
]
2 87.52 ms
"START TRANSACTION"
Parameters:
[]
3 0.93 ms
UPDATE post_view_stats SET hit_count = ?, updated_at = ? WHERE id = ?
Parameters:
[
  27
  "2026-04-15 03:37:52"
  59960
]
4 0.52 ms
SAVEPOINT DOCTRINE_2
Parameters:
[]
5 0.86 ms
INSERT INTO audit_log (action, entity, entity_id, user, log_time, action_description, value_object) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "post-update"
  "App\Entity\PostViewStats"
  "59960"
  null
  "2026-04-15 03:37:53"
  "No user"
  ""[]""
]
6 0.41 ms
RELEASE SAVEPOINT DOCTRINE_2
Parameters:
[]
7 0.44 ms
"COMMIT"
Parameters:
[]
8 38.94 ms
SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.post_id AS post_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM post_view_stats t0 WHERE t0.post_id = ? AND t0.start_day_time = ? LIMIT 1
Parameters:
[
  4
  "2026-04-15"
]
9 0.29 ms
"START TRANSACTION"
Parameters:
[]
10 0.41 ms
UPDATE post_view_stats SET hit_count = ?, updated_at = ? WHERE id = ?
Parameters:
[
  33753
  "2026-04-15 03:37:54"
  59953
]
11 56.34 ms
SAVEPOINT DOCTRINE_2
Parameters:
[]
12 0.69 ms
INSERT INTO audit_log (action, entity, entity_id, user, log_time, action_description, value_object) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "post-update"
  "App\Entity\PostViewStats"
  "59953"
  null
  "2026-04-15 03:37:54"
  "No user"
  ""[]""
]
13 0.31 ms
RELEASE SAVEPOINT DOCTRINE_2
Parameters:
[]
14 0.32 ms
"COMMIT"
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

Class Mapping errors
App\Entity\PostViewStats No errors.
App\Entity\AuditLog No errors.