Query Metrics

7 Database Queries
7 Different statements
12.55 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.67 ms
SELECT a0_.id AS id_0, a0_.token AS token_1, a0_.created_at AS created_at_2, a0_.expires_at AS expires_at_3, a0_.is_active AS is_active_4, a0_.user_id AS user_id_5 FROM api_token a0_ INNER JOIN `user` u1_ ON a0_.user_id = u1_.id WHERE a0_.token = ? AND a0_.expires_at > ? AND u1_.is_active = 1 AND a0_.is_active = 1
Parameters:
[
  "ea039e67cd123696b175fa56080aeafb4860142fbe51ff7cc8de96bfe37da955"
  "2026-03-20 14:29:30"
]
2 0.19 ms
"START TRANSACTION"
Parameters:
[]
3 0.37 ms
UPDATE api_token SET expires_at = ? WHERE id = ?
Parameters:
[
  "2026-07-20 14:29:30"
  4
]
4 0.13 ms
"COMMIT"
Parameters:
[]
5 0.46 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.name AS name_3, t0.description AS description_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_active AS is_active_7 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  4
]
6 2.52 ms
SELECT COUNT(m0_.webhook_id) AS sclr_0 FROM meraki_webhook m0_ WHERE m0_.is_processed = ? AND m0_.device_name = ?
Parameters:
[
  0
  "dse_rou_dse03909mx1"
]
7 8.20 ms
SELECT m0_.webhook_id AS webhook_id_0, m0_.alert_id AS alert_id_1, m0_.alert_data AS alert_data_2, m0_.alert_type AS alert_type_3, m0_.alert_level AS alert_level_4, m0_.alert_type_id AS alert_type_id_5, m0_.sent_at AS sent_at_6, m0_.occurred_at AS occurred_at_7, m0_.organization_id AS organization_id_8, m0_.organization_url AS organization_url_9, m0_.organization_name AS organization_name_10, m0_.network_name AS network_name_11, m0_.network_url AS network_url_12, m0_.network_tags AS network_tags_13, m0_.network_id AS network_id_14, m0_.device_name AS device_name_15, m0_.device_tags AS device_tags_16, m0_.device_mac AS device_mac_17, m0_.device_url AS device_url_18, m0_.device_model AS device_model_19, m0_.device_serial AS device_serial_20, m0_.version AS version_21, m0_.is_processed AS is_processed_22 FROM meraki_webhook m0_ WHERE m0_.is_processed = ? AND m0_.device_name = ? ORDER BY m0_.sent_at ASC LIMIT 1
Parameters:
[
  0
  "dse_rou_dse03909mx1"
]

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\MerakiWebhook No errors.
App\Entity\ApiToken No errors.
App\Entity\User No errors.