GET https://dev.serprovitv2.pigdata.es/login

Query Metrics

8 Database Queries
8 Different statements
5.56 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.10 ms
SELECT t0.id AS id_1, t0.activo AS activo_2 FROM mantenimiento t0 LIMIT 1
Parameters:
[]
2 1.54 ms
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"
]
3 0.57 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%ROLE_SUPER_ADMIN%"
]
4 0.48 ms
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:
[]
5 0.49 ms
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:
[]
6 0.63 ms
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:
[]
7 0.36 ms
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:
[]
8 0.40 ms
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.