https://mantenimiento.gestion-miralejos.com.ar/pedido/reparacion/

Query Metrics

7 Database Queries
7 Different statements
15.95 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
10.16 ms
(63.68%)
1
SELECT m0_.id AS id_0, m0_.fecha_carga AS fecha_carga_1, m0_.fecha_diagrama AS fecha_diagrama_2, m0_.detalle AS detalle_3, m0_.diagramada AS diagramada_4, m0_.realizada AS realizada_5, m0_.eliminada AS eliminada_6, m0_.nombre_archivo_imagen AS nombre_archivo_imagen_7, m0_.id_sector AS id_sector_8, m0_.id_tipo AS id_tipo_9, m0_.id_equipo AS id_equipo_10, m0_.id_user_alta AS id_user_alta_11, m0_.id_solicitante AS id_solicitante_12, m0_.id_tarea_plan AS id_tarea_plan_13, m0_.id_depto AS id_depto_14 FROM mant_pedido_reparacion m0_ INNER JOIN mant_sector_planta m1_ ON m0_.id_sector = m1_.id INNER JOIN mant_departamento m2_ ON m0_.id_depto = m2_.id WHERE m0_.eliminada = ? AND m2_.id IN (?, ?, ?, ?) AND m1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND DATE(m0_.fecha_carga) >= ? AND DATE(m0_.fecha_carga) <= ?
Parameters:
[
  0
  1
  2
  3
  4
  57
  58
  59
  60
  49
  18
  23
  24
  32
  33
  8
  30
  53
  17
  36
  48
  13
  6
  12
  5
  9
  7
  11
  16
  47
  55
  28
  27
  29
  35
  4
  10
  72
  2
  54
  20
  19
  52
  39
  40
  41
  42
  43
  44
  46
  37
  38
  45
  3
  69
  31
  56
  15
  14
  51
  34
  68
  1
  65
  26
  21
  22
  25
  61
  62
  63
  64
  50
  "2026-11-05"
  "2026-11-06"
]
2.78 ms
(17.42%)
1
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.codigo AS codigo_2, m0_.activo AS activo_3, m0_.id_sector AS id_sector_4 FROM mant_maquinarias m0_ INNER JOIN mant_sector_planta m1_ ON m0_.id_sector = m1_.id WHERE m0_.activo = 1 AND m1_.active = 1 ORDER BY m1_.nombre ASC, m0_.nombre ASC
Parameters:
[]
0.88 ms
(5.52%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.active AS active_3 FROM mant_sector_planta t0 INNER JOIN users_sectores_system ON t0.id = users_sectores_system.id_sector WHERE users_sectores_system.id_user = ? ORDER BY t0.nombre ASC
Parameters:
[
  7
]
0.81 ms
(5.07%)
1
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.activo AS activo_2 FROM mant_solicitante_pedido_reparacion m0_ WHERE m0_.activo = 1 ORDER BY m0_.nombre ASC
Parameters:
[]
0.57 ms
(3.59%)
1
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
]
0.41 ms
(2.54%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.active AS active_3 FROM mant_sector_planta t0 WHERE t0.id = ?
Parameters:
[
  66
]
0.35 ms
(2.18%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3 FROM mant_departamento t0 INNER JOIN users_departamentos_system ON t0.id = users_departamentos_system.id_departamento WHERE users_departamentos_system.id_user = ?
Parameters:
[
  7
]

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\Equipos\Maquinaria No errors.
App\Entity\Mantenimiento\SolicitantePedidoReparacion No errors.
App\Entity\Mantenimiento\PedidoReparacion No errors.
App\Entity\Mantenimiento\TipoReparacion No errors.
App\Entity\Mantenimiento\Preventivo\TareaPlanDiagramada No errors.
App\Entity\Mantenimiento\PedidoReparacionDiagramado 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.