Query Metrics
7
Database Queries
6
Different statements
5.82 ms
Query time
2
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.96 ms (33.64%) |
1 |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.updated_at AS updated_at_3 FROM nodosTor t0 WHERE t0.ip = ? LIMIT 1
Parameters:
[
"172.18.0.2"
]
|
|
1.58 ms (27.12%) |
1 |
SELECT t0.id AS id_1, t0.activo AS activo_2 FROM mantenimiento t0 LIMIT 1
Parameters:
[] |
|
0.85 ms (14.53%) |
2 |
SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.roles LIKE ?
Parameters:
[
"%ROLE_SUPER_ADMIN%"
]
|
|
0.52 ms (9.02%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.orden AS orden_4, t0.route AS route_5, t0.icon AS icon_6, t0.icon_color AS icon_color_7, t0.text_color AS text_color_8, t0.ruta_trans AS ruta_trans_9, t0.menu_visible AS menu_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.parent_id AS parent_id_14 FROM modulos t0 WHERE t0.route = ? LIMIT 1
Parameters:
[
"app_recover_new_password"
]
|
|
0.50 ms (8.64%) |
1 |
SELECT t0.id AS id_1, t0.nombre_archivo AS nombre_archivo_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5 FROM logo t0 WHERE t0.deleted_at IS NULL ORDER BY t0.updated_at DESC LIMIT 1
Parameters:
[] |
|
0.41 ms (7.06%) |
1 |
SELECT t0.token AS token_1, t0.code AS code_2, t0.created_time AS created_time_3, t0.is_verified AS is_verified_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM password_resets t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
"019aba69-2731-7431-abc5-78a1ea38d9a7"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| serprovit_prod | doctrine.dbal.serprovit_prod_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.