Query Metrics
8
Database Queries
8
Different statements
3.23 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
0.96 ms (29.85%) |
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"
]
|
|
0.46 ms (14.11%) |
1 |
SELECT t0.id AS id_1, t0.activo AS activo_2 FROM mantenimiento t0 LIMIT 1
Parameters:
[] |
|
0.35 ms (10.86%) |
1 |
SELECT p0_.id AS id_0, p0_.kg_tope AS kg_tope_1, p0_.kg_minimo AS kg_minimo_2, p0_.espacio AS espacio_3, p0_.tiempo_inactividad AS tiempo_inactividad_4, p0_.activo_inactividad AS activo_inactividad_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.deleted_at AS deleted_at_8 FROM parameters p0_ WHERE p0_.tiempo_inactividad IS NOT NULL ORDER BY p0_.id DESC LIMIT 1
Parameters:
[] |
|
0.35 ms (10.77%) |
1 |
SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.roles LIKE ?
Parameters:
[
"%ROLE_SUPER_ADMIN%"
]
|
|
0.34 ms (10.68%) |
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.27 ms (8.38%) |
1 |
SELECT t0.id AS id_1, t0.src_imagen_logo AS src_imagen_logo_2, t0.src_imagen_logo_mini AS src_imagen_logo_mini_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.contacto_id AS contacto_id_7, t0.direccion_id AS direccion_id_8, t0.medicamentos_almacenes_id AS medicamentos_almacenes_id_9 FROM integradoras t0
Parameters:
[] |
|
0.27 ms (8.38%) |
1 |
SELECT p0_.id AS id_0, p0_.kg_tope AS kg_tope_1, p0_.kg_minimo AS kg_minimo_2, p0_.espacio AS espacio_3, p0_.tiempo_inactividad AS tiempo_inactividad_4, p0_.activo_inactividad AS activo_inactividad_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.deleted_at AS deleted_at_8 FROM parameters p0_ WHERE p0_.espacio IS NOT NULL ORDER BY p0_.id DESC LIMIT 1
Parameters:
[] |
|
0.22 ms (6.96%) |
1 |
DELETE FROM cola_notificaciones WHERE categoria = ?
Parameters:
[
"espacio-disco"
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Mantenimiento | No errors. |
| App\Entity\NodoTor | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Logo | No errors. |
| App\Entity\Parametros | No errors. |
| App\Entity\Intervalo | No errors. |
| App\Entity\Integradora | No errors. |
| App\Entity\Contacto | No errors. |
| App\Entity\Direccion | No errors. |
| App\Entity\AlmacenVeterinario | No errors. |
| App\Entity\Animal | No errors. |
| App\Entity\NotificationQueue | No errors. |