https://mantenimiento.gestion-miralejos.com.ar/mantenimiento/preventivo/plan/diagramado/pendientes/realizar

Query Metrics

37 Database Queries
4 Different statements
9.28 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.44 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.id_default AS id_default_5 FROM users_system t0 WHERE t0.id = ?
Parameters:
[
  7
]
2 0.81 ms
SELECT p0_.id AS id_0, p0_.fecha_diagrama AS fecha_diagrama_1, p0_.fecha_realizacion AS fecha_realizacion_2, p0_.fecha_proxima_realizacion AS fecha_proxima_realizacion_3, p0_.realizado AS realizado_4, p0_.id_departamento AS id_departamento_5, p0_.id_plan AS id_plan_6, p0_.id_equipo AS id_equipo_7 FROM plan_mantenimiento_diagramado p0_ WHERE p0_.realizado = ?
Parameters:
[
  0
]
3 0.44 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  21
]
4 0.32 ms
SELECT t0.id AS id_1, t0.periodicidad AS periodicidad_2, t0.nombre AS nombre_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_prev_planes_mant t0 WHERE t0.id = ?
Parameters:
[
  29
]
5 0.24 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  9
]
6 0.21 ms
SELECT t0.id AS id_1, t0.periodicidad AS periodicidad_2, t0.nombre AS nombre_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_prev_planes_mant t0 WHERE t0.id = ?
Parameters:
[
  11
]
7 0.23 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  11
]
8 0.25 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  46
]
9 0.27 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  13
]
10 0.22 ms
SELECT t0.id AS id_1, t0.periodicidad AS periodicidad_2, t0.nombre AS nombre_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_prev_planes_mant t0 WHERE t0.id = ?
Parameters:
[
  15
]
11 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  14
]
12 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  15
]
13 0.23 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  48
]
14 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  52
]
15 0.26 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  55
]
16 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  57
]
17 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  61
]
18 0.21 ms
SELECT t0.id AS id_1, t0.periodicidad AS periodicidad_2, t0.nombre AS nombre_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_prev_planes_mant t0 WHERE t0.id = ?
Parameters:
[
  26
]
19 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  62
]
20 0.21 ms
SELECT t0.id AS id_1, t0.periodicidad AS periodicidad_2, t0.nombre AS nombre_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_prev_planes_mant t0 WHERE t0.id = ?
Parameters:
[
  32
]
21 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  65
]
22 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  36
]
23 0.21 ms
SELECT t0.id AS id_1, t0.periodicidad AS periodicidad_2, t0.nombre AS nombre_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_prev_planes_mant t0 WHERE t0.id = ?
Parameters:
[
  37
]
24 0.23 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  37
]
25 0.21 ms
SELECT t0.id AS id_1, t0.periodicidad AS periodicidad_2, t0.nombre AS nombre_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_prev_planes_mant t0 WHERE t0.id = ?
Parameters:
[
  8
]
26 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  39
]
27 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  41
]
28 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  42
]
29 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  241
]
30 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  16
]
31 0.21 ms
SELECT t0.id AS id_1, t0.periodicidad AS periodicidad_2, t0.nombre AS nombre_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_prev_planes_mant t0 WHERE t0.id = ?
Parameters:
[
  16
]
32 0.26 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  18
]
33 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  53
]
34 0.23 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  56
]
35 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  20
]
36 0.24 ms
SELECT t0.id AS id_1, t0.periodicidad AS periodicidad_2, t0.nombre AS nombre_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_prev_planes_mant t0 WHERE t0.id = ?
Parameters:
[
  24
]
37 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.id = ?
Parameters:
[
  38
]

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\User No errors.
App\Entity\Almacen\Deposito No errors.
App\Entity\Mantenimiento\SectorPlanta No errors.
App\Entity\Mantenimiento\Departamento No errors.
App\Entity\Almacen\AplicacionArticulo No errors.
App\Entity\Mantenimiento\Preventivo\PlanMantenimientoDiagramado No errors.
App\Entity\Mantenimiento\Preventivo\PlanMantenimiento No errors.
App\Entity\Equipos\Maquinaria No errors.
App\Entity\Mantenimiento\Preventivo\TareaPlanDiagramada No errors.
App\Entity\Almacen\Articulo
  • The field App\Entity\Almacen\Articulo#articulosDeposito is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Almacen\ArticuloDeposito#articulo does not contain the required 'inversedBy="articulosDeposito"' attribute.
App\Entity\Mantenimiento\Preventivo\TareaPlan No errors.