Symfony Profiler

SELECT
  t0.id_usu AS id_usu_1,
  t0.nombre AS nombre_2,
  t0.papellido AS papellido_3,
  t0.sapellido AS sapellido_4,
  t0.correo AS correo_5,
  t0.contrasena AS contrasena_6,
  t0.estatus AS estatus_7,
  t0.unidad AS unidad_8,
  t0.rol AS rol_9
FROM
  usuario t0
WHERE
  t0.id_usu = ?

SELECT t0.id_usu AS id_usu_1, t0.nombre AS nombre_2, t0.papellido AS papellido_3, t0.sapellido AS sapellido_4, t0.correo AS correo_5, t0.contrasena AS contrasena_6, t0.estatus AS estatus_7, t0.unidad AS unidad_8, t0.rol AS rol_9 FROM usuario t0 WHERE t0.id_usu = 57;

SELECT
  COUNT(s0_.id_sol) AS sclr_0,
  IFNULL(
    SUM(
      CASE WHEN s0_.tipo_mantenimiento = 'MP' THEN
        1
      ELSE
        0
      END
    ),
    0
  ) AS sclr_1,
  IFNULL(
    SUM(
      CASE WHEN s0_.tipo_mantenimiento = 'MC' THEN
        1
      ELSE
        0
      END
    ),
    0
  ) AS sclr_2,
  CASE WHEN (
    IFNULL(
      SUM(
        CASE WHEN s0_.tipo_mantenimiento = 'MP' THEN
          1
        ELSE
          0
        END
      ),
      0
    ) + IFNULL(
      SUM(
        CASE WHEN s0_.tipo_mantenimiento = 'MC' THEN
          1
        ELSE
          0
        END
      ),
      0
    )
  ) > 0 THEN
    ROUND(
      IFNULL(
        SUM(
          CASE WHEN s0_.tipo_mantenimiento = 'MP' THEN
            1
          ELSE
            0
          END
        ),
        0
      ) / (
        IFNULL(
          SUM(
            CASE WHEN s0_.tipo_mantenimiento = 'MP' THEN
              1
            ELSE
              0
            END
          ),
          0
        ) + IFNULL(
          SUM(
            CASE WHEN s0_.tipo_mantenimiento = 'MC' THEN
              1
            ELSE
              0
            END
          ),
          0
        )
      ) * 100,
      2
    )
  ELSE
    0
  END AS sclr_3,
  COALESCE(u1_.nombre, '-') AS sclr_4
FROM
  solicitud s0_
  LEFT JOIN unidad u1_ ON s0_.unidad = u1_.id_uni
WHERE
  (
    s0_.fevaluacion BETWEEN ?
    AND DATE_ADD(?, INTERVAL 1 DAY)
  )
  AND s0_.estatus = 4
  AND s0_.unidad = ?

SELECT COUNT(s0_.id_sol) AS sclr_0, IFNULL(SUM(CASE WHEN s0_.tipo_mantenimiento = 'MP' THEN 1 ELSE 0 END), 0) AS sclr_1, IFNULL(SUM(CASE WHEN s0_.tipo_mantenimiento = 'MC' THEN 1 ELSE 0 END), 0) AS sclr_2, CASE WHEN (IFNULL(SUM(CASE WHEN s0_.tipo_mantenimiento = 'MP' THEN 1 ELSE 0 END), 0) + IFNULL(SUM(CASE WHEN s0_.tipo_mantenimiento = 'MC' THEN 1 ELSE 0 END), 0)) > 0 THEN ROUND(IFNULL(SUM(CASE WHEN s0_.tipo_mantenimiento = 'MP' THEN 1 ELSE 0 END), 0) / (IFNULL(SUM(CASE WHEN s0_.tipo_mantenimiento = 'MP' THEN 1 ELSE 0 END), 0) + IFNULL(SUM(CASE WHEN s0_.tipo_mantenimiento = 'MC' THEN 1 ELSE 0 END), 0)) * 100, 2) ELSE 0 END AS sclr_3, COALESCE(u1_.nombre, '-') AS sclr_4 FROM solicitud s0_ LEFT JOIN unidad u1_ ON s0_.unidad = u1_.id_uni WHERE (s0_.fevaluacion BETWEEN '2025-01-01' AND DATE_ADD('2025-10-14', INTERVAL 1 DAY)) AND s0_.estatus = 4 AND s0_.unidad = 3155280;

SELECT
  COUNT(e0_.id_equ) AS sclr_0,
  SUM(e0_.emhv) AS sclr_1,
  ROUND(
    FLOOR(
      IFNULL(
        SUM(e0_.emhv),
        0
      )
    ) / COUNT(e0_.id_equ) * 100,
    2
  ) AS sclr_2,
  u1_.nombre AS nombre_3
FROM
  equipo e0_
  LEFT JOIN unidad u1_ ON e0_.unidad = u1_.id_uni
WHERE
  e0_.estatus <> 5
  AND e0_.unidad = ?

SELECT COUNT(e0_.id_equ) AS sclr_0, SUM(e0_.emhv) AS sclr_1, ROUND(FLOOR(IFNULL(SUM(e0_.emhv), 0)) / COUNT(e0_.id_equ) * 100, 2) AS sclr_2, u1_.nombre AS nombre_3 FROM equipo e0_ LEFT JOIN unidad u1_ ON e0_.unidad = u1_.id_uni WHERE e0_.estatus <> 5 AND e0_.unidad = 3155280;

SELECT
  COALESCE(u0_.nombre, '-') AS sclr_0,
  IFNULL(
    COUNT(e1_.solicitud),
    0
  ) AS sclr_1,
  IFNULL(
    FLOOR(
      SUM(e1_.evalua1) * 100 / NULLIF(
        COUNT(e1_.solicitud),
        0
      )
    ),
    0
  ) AS sclr_2,
  IFNULL(
    FLOOR(
      SUM(e1_.evalua2) * 100 / NULLIF(
        COUNT(e1_.solicitud) * 5,
        0
      )
    ),
    0
  ) AS sclr_3,
  IFNULL(
    FLOOR(
      SUM(e1_.evalua3) * 100 / NULLIF(
        COUNT(e1_.solicitud) * 5,
        0
      )
    ),
    0
  ) AS sclr_4,
  IFNULL(
    FLOOR(
      SUM(e1_.evalua4) * 100 / NULLIF(
        COUNT(e1_.solicitud) * 5,
        0
      )
    ),
    0
  ) AS sclr_5
FROM
  evaluacion e1_
  INNER JOIN solicitud s2_ ON e1_.solicitud = s2_.id_sol
  LEFT JOIN unidad u0_ ON s2_.unidad = u0_.id_uni
WHERE
  (
    s2_.fevaluacion BETWEEN ?
    AND DATE_ADD(?, INTERVAL 1 DAY)
  )
  AND s2_.unidad = ?
ORDER BY
  u0_.nombre ASC

SELECT COALESCE(u0_.nombre, '-') AS sclr_0, IFNULL(COUNT(e1_.solicitud), 0) AS sclr_1, IFNULL(FLOOR(SUM(e1_.evalua1) * 100 / NULLIF(COUNT(e1_.solicitud), 0)), 0) AS sclr_2, IFNULL(FLOOR(SUM(e1_.evalua2) * 100 / NULLIF(COUNT(e1_.solicitud) * 5, 0)), 0) AS sclr_3, IFNULL(FLOOR(SUM(e1_.evalua3) * 100 / NULLIF(COUNT(e1_.solicitud) * 5, 0)), 0) AS sclr_4, IFNULL(FLOOR(SUM(e1_.evalua4) * 100 / NULLIF(COUNT(e1_.solicitud) * 5, 0)), 0) AS sclr_5 FROM evaluacion e1_ INNER JOIN solicitud s2_ ON e1_.solicitud = s2_.id_sol LEFT JOIN unidad u0_ ON s2_.unidad = u0_.id_uni WHERE (s2_.fevaluacion BETWEEN '2025-01-01' AND DATE_ADD('2025-10-14', INTERVAL 1 DAY)) AND s2_.unidad = 3155280 ORDER BY u0_.nombre ASC;