Symfony Profiler

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  t0.id_uni AS id_uni_1,
  t0.nombre AS nombre_2,
  t0.consecutivo AS consecutivo_3,
  t0.activa AS activa_4,
  t0.matricula AS matricula_5,
  t0.mat_ti AS mat_ti_6,
  t0.director AS director_7,
  t0.sexo AS sexo_8,
  t0.telefono AS telefono_9,
  t0.correo AS correo_10,
  t0.calle AS calle_11,
  t0.colonia AS colonia_12,
  t0.municipio AS municipio_13,
  t0.cp AS cp_14
FROM
  unidad t0
WHERE
  t0.id_uni = ?
LIMIT
  1

SELECT t0.id_uni AS id_uni_1, t0.nombre AS nombre_2, t0.consecutivo AS consecutivo_3, t0.activa AS activa_4, t0.matricula AS matricula_5, t0.mat_ti AS mat_ti_6, t0.director AS director_7, t0.sexo AS sexo_8, t0.telefono AS telefono_9, t0.correo AS correo_10, t0.calle AS calle_11, t0.colonia AS colonia_12, t0.municipio AS municipio_13, t0.cp AS cp_14 FROM unidad t0 WHERE t0.id_uni = 3155280 LIMIT 1;

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
  s.id_sol,
  s.tipo_equipo,
  s.id_equipo,
  s.periodo,
  s.tipo_mantenimiento,
  s.falla,
  s.fregistro,
  s.fatencion,
  s.ffin,
  s.fevaluacion,
  s.refacciones,
  s.estatus,
  CONCAT_WS(
    '', u.nombre, ' ', u.papellido, ' ',
    u.sapellido
  ) AS usuario,
  s.ubicacion,
  CONCAT_WS(
    '', g.nombre, ' ', g.papellido, ' ',
    g.sapellido
  ) AS gestor,
  s.unidad,
  CASE WHEN s.tipo_equipo = 'Equipo' THEN (
    SELECT
      e.marbete
    FROM
      equipo e
    WHERE
      e.id_equ = s.id_equipo
  ) WHEN s.tipo_equipo = 'Impresora' THEN (
    SELECT
      i.marbete
    FROM
      impresora i
    WHERE
      i.id_imp = s.id_equipo
  ) WHEN s.tipo_equipo = 'Red' THEN (
    SELECT
      r.marbete
    FROM
      red r
    WHERE
      r.id_red = s.id_equipo
  ) WHEN s.tipo_equipo = 'Otro' THEN (
    SELECT
      o.marbete
    FROM
      otro o
    WHERE
      o.id_otro = s.id_equipo
  ) ELSE 0 END AS marbete,
  CASE WHEN s.tipo_equipo = 'Equipo' THEN 'Cómputo' WHEN s.tipo_equipo = 'Impresora' THEN 'Impresora' WHEN s.tipo_equipo = 'Red' THEN 'Red' WHEN s.tipo_equipo = 'Otro' THEN 'Otro' ELSE 0 END AS tipo_equipo,
  CASE WHEN s.tipo_equipo = 'Equipo' THEN (
    SELECT
      e.emhv
    FROM
      equipo e
    WHERE
      e.id_equ = s.id_equipo
  ) ELSE 2 END AS emhv
FROM
  solicitud s
  LEFT JOIN usuario u ON s.usuario = u.id_usu
  LEFT JOIN usuario g ON s.gestor = g.id_usu
WHERE
  YEAR(s.fatencion) = '2022'
  AND (
    s.tipo_mantenimiento = 'MP'
    OR s.tipo_mantenimiento = 'MC'
  )
  AND s.unidad = '3155280'

SELECT
                    s.id_sol,
                    s.tipo_equipo,
                    s.id_equipo,
                    s.periodo,
                    s.tipo_mantenimiento,
                    s.falla,
                    s.fregistro,
                    s.fatencion,
                    s.ffin,
                    s.fevaluacion,
                    s.refacciones,
                    s.estatus,
                    CONCAT_WS('', u.nombre, ' ', u.papellido, ' ', u.sapellido) AS usuario,
                    s.ubicacion,
                    CONCAT_WS('', g.nombre, ' ', g.papellido, ' ', g.sapellido) AS gestor,
                    s.unidad,
                    CASE
                        WHEN s.tipo_equipo = 'Equipo' THEN (SELECT e.marbete FROM equipo e WHERE e.id_equ = s.id_equipo)
                        WHEN s.tipo_equipo = 'Impresora' THEN (SELECT i.marbete FROM impresora i WHERE i.id_imp = s.id_equipo)
                        WHEN s.tipo_equipo = 'Red' THEN (SELECT r.marbete FROM red r WHERE r.id_red = s.id_equipo)
                        WHEN s.tipo_equipo = 'Otro' THEN (SELECT o.marbete FROM otro o WHERE o.id_otro = s.id_equipo)
                        ELSE 0
                    END AS marbete,
                    CASE
                        WHEN s.tipo_equipo = 'Equipo' THEN 'Cómputo'
                        WHEN s.tipo_equipo = 'Impresora' THEN 'Impresora'
                        WHEN s.tipo_equipo = 'Red' THEN 'Red'
                        WHEN s.tipo_equipo = 'Otro' THEN 'Otro'
                        ELSE 0
                    END AS tipo_equipo,
                    CASE
                        WHEN s.tipo_equipo = 'Equipo' THEN (SELECT e.emhv FROM equipo e WHERE e.id_equ = s.id_equipo)
                        ELSE 2
                    END AS emhv
                FROM
                    solicitud s
                LEFT JOIN usuario u ON s.usuario = u.id_usu
                LEFT JOIN usuario g ON s.gestor = g.id_usu
                WHERE
                    YEAR(s.fatencion) = '2022'             
                    AND (s.tipo_mantenimiento = 'MP' OR s.tipo_mantenimiento = 'MC') AND s.unidad = '3155280';

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  eq.total AS equipo,
  IFNULL(eq.emhv, 0) AS emhv,
  FLOOR(
    IFNULL(eq.emhv, 0) / eq.total * 100
  ) as indice,
  im.total AS impresora,
  re.total as red,
  ot.total as otro
FROM
  (
    SELECT
      COUNT(e.id_equ) AS total,
      SUM(e.emhv) as emhv
    FROM
      equipo e
    WHERE
      e.unidad = '3155280'
      AND e.estatus = 1
  ) eq
  JOIN (
    SELECT
      COUNT(i.id_imp) AS total
    FROM
      impresora i
    WHERE
      i.unidad = '3155280'
      AND i.estatus = 1
  ) im
  JOIN (
    SELECT
      COUNT(r.id_red) AS total
    FROM
      red r
    WHERE
      r.unidad = '3155280'
      AND r.estatus = 1
  ) re
  JOIN (
    SELECT
      COUNT(o.id_otro) AS total
    FROM
      otro o
    WHERE
      o.unidad = '3155280'
      AND o.estatus = 1
  ) ot

SELECT eq.total AS equipo, IFNULL(eq.emhv, 0) AS emhv, FLOOR(IFNULL(eq.emhv, 0) / eq.total * 100) as indice, im.total AS impresora, re.total as red, ot.total as otro
                FROM
                    (SELECT COUNT(e.id_equ) AS total, SUM(e.emhv) as emhv FROM equipo e WHERE e.unidad = '3155280' AND e.estatus = 1) eq
                JOIN
                    (SELECT COUNT(i.id_imp) AS total FROM impresora i WHERE i.unidad = '3155280'AND i.estatus = 1) im
                JOIN
                    (SELECT COUNT(r.id_red) AS total FROM red r WHERE r.unidad = '3155280'AND r.estatus = 1) re
                JOIN
                    (SELECT COUNT(o.id_otro) AS total FROM otro o WHERE o.unidad = '3155280' AND o.estatus = 1) ot;

SELECT
  t0.id_rol AS id_rol_1,
  t0.nombre AS nombre_2
FROM
  role t0
WHERE
  t0.id_rol = ?

SELECT t0.id_rol AS id_rol_1, t0.nombre AS nombre_2 FROM role t0 WHERE t0.id_rol = 3;