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

Query Metrics

9 Database Queries
9 Different statements
4.69 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.07 ms
(22.88%)
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.82 ms
(17.53%)
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.47 ms
(10.07%)
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"
]
0.44 ms
(9.45%)
1
SELECT t0.id AS id_1, t0.activo AS activo_2 FROM mantenimiento t0 LIMIT 1
Parameters:
[]
0.42 ms
(8.92%)
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
(8.65%)
1
SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%ROLE_SUPER_ADMIN%"
]
0.38 ms
(8.00%)
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.36 ms
(7.62%)
1
DELETE FROM cola_notificaciones WHERE categoria = ?
Parameters:
[
  "espacio-disco"
]
0.32 ms
(6.87%)
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:
[]

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\Modulo 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.