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

Query Metrics

8 Database Queries
7 Different statements
12.41 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.41 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:
[
  10
]
2 0.88 ms
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:
[
  10
]
3 0.45 ms
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:
[
  10
]
4 6.91 ms
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
  2
  54
  20
  19
  52
  39
  40
  41
  42
  43
  44
  46
  37
  38
  45
  3
  31
  56
  15
  14
  51
  34
  68
  1
  65
  26
  21
  22
  25
  61
  62
  63
  64
  50
  "2026-08-17"
  "2026-08-18"
]
5 2.54 ms
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:
[]
6 0.56 ms
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
]
7 0.28 ms
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:
[
  72
]
8 0.39 ms
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:
[]

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.