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 = 1794;

SELECT
  t0.id_equ AS id_equ_1,
  t0.marbete AS marbete_2,
  t0.descripcion AS descripcion_3,
  t0.modelo AS modelo_4,
  t0.serie AS serie_5,
  t0.procesador AS procesador_6,
  t0.nucleos AS nucleos_7,
  t0.cpu_velocidad AS cpu_velocidad_8,
  t0.ram AS ram_9,
  t0.hhd AS hhd_10,
  t0.ssd AS ssd_11,
  t0.mac AS mac_12,
  t0.ip AS ip_13,
  t0.monitor_marbete AS monitor_marbete_14,
  t0.monitor_modelo AS monitor_modelo_15,
  t0.monitor_serie AS monitor_serie_16,
  t0.monitor_tipo AS monitor_tipo_17,
  t0.monitor_pulgadas AS monitor_pulgadas_18,
  t0.teclado_modelo AS teclado_modelo_19,
  t0.teclado_serie AS teclado_serie_20,
  t0.mouse_modelo AS mouse_modelo_21,
  t0.mouse_serie AS mouse_serie_22,
  t0.uso AS uso_23,
  t0.funcion AS funcion_24,
  t0.funcion_descripcion AS funcion_descripcion_25,
  t0.estatus AS estatus_26,
  t0.falta AS falta_27,
  t0.factualizacion AS factualizacion_28,
  t0.emhv AS emhv_29,
  t0.mantenimiento_count AS mantenimiento_count_30,
  t0.allinone AS allinone_31,
  t0.color AS color_32,
  t0.piso AS piso_33,
  t0.seccion_aula AS seccion_aula_34,
  t0.num_puerta_cubi AS num_puerta_cubi_35,
  t0.usuario AS usuario_36,
  t0.ubicacion AS ubicacion_37,
  t0.unidad AS unidad_38,
  t0.id_material AS id_material_39,
  t0.id_uso AS id_uso_40,
  t0.id_marca AS id_marca_41,
  t0.monitor_marca AS monitor_marca_42,
  t0.teclado_marca AS teclado_marca_43,
  t0.mouse_marca AS mouse_marca_44
FROM
  equipo t0
WHERE
  t0.usuario = ?

SELECT t0.id_equ AS id_equ_1, t0.marbete AS marbete_2, t0.descripcion AS descripcion_3, t0.modelo AS modelo_4, t0.serie AS serie_5, t0.procesador AS procesador_6, t0.nucleos AS nucleos_7, t0.cpu_velocidad AS cpu_velocidad_8, t0.ram AS ram_9, t0.hhd AS hhd_10, t0.ssd AS ssd_11, t0.mac AS mac_12, t0.ip AS ip_13, t0.monitor_marbete AS monitor_marbete_14, t0.monitor_modelo AS monitor_modelo_15, t0.monitor_serie AS monitor_serie_16, t0.monitor_tipo AS monitor_tipo_17, t0.monitor_pulgadas AS monitor_pulgadas_18, t0.teclado_modelo AS teclado_modelo_19, t0.teclado_serie AS teclado_serie_20, t0.mouse_modelo AS mouse_modelo_21, t0.mouse_serie AS mouse_serie_22, t0.uso AS uso_23, t0.funcion AS funcion_24, t0.funcion_descripcion AS funcion_descripcion_25, t0.estatus AS estatus_26, t0.falta AS falta_27, t0.factualizacion AS factualizacion_28, t0.emhv AS emhv_29, t0.mantenimiento_count AS mantenimiento_count_30, t0.allinone AS allinone_31, t0.color AS color_32, t0.piso AS piso_33, t0.seccion_aula AS seccion_aula_34, t0.num_puerta_cubi AS num_puerta_cubi_35, t0.usuario AS usuario_36, t0.ubicacion AS ubicacion_37, t0.unidad AS unidad_38, t0.id_material AS id_material_39, t0.id_uso AS id_uso_40, t0.id_marca AS id_marca_41, t0.monitor_marca AS monitor_marca_42, t0.teclado_marca AS teclado_marca_43, t0.mouse_marca AS mouse_marca_44 FROM equipo t0 WHERE t0.usuario = 1794;

SELECT
  t0.id_imp AS id_imp_1,
  t0.marbete AS marbete_2,
  t0.descripcion AS descripcion_3,
  t0.marca AS marca_4,
  t0.modelo AS modelo_5,
  t0.serie AS serie_6,
  t0.tipo AS tipo_7,
  t0.uso AS uso_8,
  t0.mac AS mac_9,
  t0.ip AS ip_10,
  t0.estatus AS estatus_11,
  t0.falta AS falta_12,
  t0.factualizacion AS factualizacion_13,
  t0.mantenimiento_count AS mantenimiento_count_14,
  t0.ubicacion AS ubicacion_15,
  t0.usuario AS usuario_16,
  t0.unidad AS unidad_17
FROM
  impresora t0
WHERE
  t0.usuario = ?

SELECT t0.id_imp AS id_imp_1, t0.marbete AS marbete_2, t0.descripcion AS descripcion_3, t0.marca AS marca_4, t0.modelo AS modelo_5, t0.serie AS serie_6, t0.tipo AS tipo_7, t0.uso AS uso_8, t0.mac AS mac_9, t0.ip AS ip_10, t0.estatus AS estatus_11, t0.falta AS falta_12, t0.factualizacion AS factualizacion_13, t0.mantenimiento_count AS mantenimiento_count_14, t0.ubicacion AS ubicacion_15, t0.usuario AS usuario_16, t0.unidad AS unidad_17 FROM impresora t0 WHERE t0.usuario = 1794;

SELECT
  t0.id_red AS id_red_1,
  t0.marbete AS marbete_2,
  t0.descripcion AS descripcion_3,
  t0.marca AS marca_4,
  t0.modelo AS modelo_5,
  t0.serie AS serie_6,
  t0.velocidad AS velocidad_7,
  t0.puertos AS puertos_8,
  t0.uso AS uso_9,
  t0.mac AS mac_10,
  t0.ip AS ip_11,
  t0.estatus AS estatus_12,
  t0.falta AS falta_13,
  t0.factualizacion AS factualizacion_14,
  t0.mantenimiento_count AS mantenimiento_count_15,
  t0.ubicacion AS ubicacion_16,
  t0.usuario AS usuario_17,
  t0.unidad AS unidad_18
FROM
  red t0
WHERE
  t0.usuario = ?

SELECT t0.id_red AS id_red_1, t0.marbete AS marbete_2, t0.descripcion AS descripcion_3, t0.marca AS marca_4, t0.modelo AS modelo_5, t0.serie AS serie_6, t0.velocidad AS velocidad_7, t0.puertos AS puertos_8, t0.uso AS uso_9, t0.mac AS mac_10, t0.ip AS ip_11, t0.estatus AS estatus_12, t0.falta AS falta_13, t0.factualizacion AS factualizacion_14, t0.mantenimiento_count AS mantenimiento_count_15, t0.ubicacion AS ubicacion_16, t0.usuario AS usuario_17, t0.unidad AS unidad_18 FROM red t0 WHERE t0.usuario = 1794;

SELECT
  t0.id_otro AS id_otro_1,
  t0.marbete AS marbete_2,
  t0.descripcion AS descripcion_3,
  t0.marca AS marca_4,
  t0.modelo AS modelo_5,
  t0.serie AS serie_6,
  t0.uso AS uso_7,
  t0.mac AS mac_8,
  t0.ip AS ip_9,
  t0.estatus AS estatus_10,
  t0.falta AS falta_11,
  t0.factualizacion AS factualizacion_12,
  t0.mantenimiento_count AS mantenimiento_count_13,
  t0.ubicacion AS ubicacion_14,
  t0.usuario AS usuario_15,
  t0.unidad AS unidad_16
FROM
  otro t0
WHERE
  t0.usuario = ?

SELECT t0.id_otro AS id_otro_1, t0.marbete AS marbete_2, t0.descripcion AS descripcion_3, t0.marca AS marca_4, t0.modelo AS modelo_5, t0.serie AS serie_6, t0.uso AS uso_7, t0.mac AS mac_8, t0.ip AS ip_9, t0.estatus AS estatus_10, t0.falta AS falta_11, t0.factualizacion AS factualizacion_12, t0.mantenimiento_count AS mantenimiento_count_13, t0.ubicacion AS ubicacion_14, t0.usuario AS usuario_15, t0.unidad AS unidad_16 FROM otro t0 WHERE t0.usuario = 1794;

SELECT
  s.*,
  (
    CASE WHEN s.tipo_equipo = 'Equipo' THEN
      e.marbete
    WHEN s.tipo_equipo = 'Impresora' THEN
      i.marbete
    WHEN s.tipo_equipo = 'Red' THEN
      r.marbete
    WHEN s.tipo_equipo = 'Otro' THEN
      o.marbete
    ELSE
      ''
    END
  ) AS marbete,
  (
    CASE WHEN s.tipo_equipo = 'Equipo' THEN
      e.descripcion
    WHEN s.tipo_equipo = 'Impresora' THEN
      i.descripcion
    WHEN s.tipo_equipo = 'Red' THEN
      r.descripcion
    WHEN s.tipo_equipo = 'Otro' THEN
      o.descripcion
    ELSE
      ''
    END
  ) AS descripcion,
  (
    CASE WHEN s.tipo_equipo = 'Equipo' THEN
      cm.marca
    WHEN s.tipo_equipo = 'Impresora' THEN
      i.marca
    WHEN s.tipo_equipo = 'Red' THEN
      r.marca
    WHEN s.tipo_equipo = 'Otro' THEN
      o.marca
    ELSE
      ''
    END
  ) AS marca,
  (
    CASE WHEN s.tipo_equipo = 'Equipo' THEN
      e.modelo
    WHEN s.tipo_equipo = 'Impresora' THEN
      i.modelo
    WHEN s.tipo_equipo = 'Red' THEN
      r.modelo
    WHEN s.tipo_equipo = 'Otro' THEN
      o.modelo
    ELSE
      ''
    END
  ) AS modelo,
  (
    CASE WHEN s.tipo_equipo = 'Equipo' THEN
      e.serie
    WHEN s.tipo_equipo = 'Impresora' THEN
      i.serie
    WHEN s.tipo_equipo = 'Red' THEN
      r.serie
    WHEN s.tipo_equipo = 'Otro' THEN
      o.serie
    ELSE
      ''
    END
  ) AS serie
FROM
  solicitud s
  JOIN usuario u on s.usuario = u.id_usu
  LEFT JOIN equipo e ON s.id_equipo = e.id_equ
  LEFT JOIN impresora i on s.id_equipo = i.id_imp
  LEFT JOIN red r on s.id_equipo = r.id_red
  LEFT JOIN otro o on s.id_equipo = o.id_otro
  LEFT JOIN c_marcas cm ON e.id_marca = cm.id_marca
WHERE
  (
    u.id_usu = 1794
    AND s.estatus != 4
    AND s.tipo_mantenimiento IN ('MC', 'ST')
    and s.fregistro >= concat(
      year(
        now()
      ),
      '-01-01'
    )
  )
  OR (
    u.id_usu = 1794
    AND s.estatus != 4
    AND s.tipo_mantenimiento = 'MP'
    AND s.fatencion BETWEEN concat(
      year(
        now()
      ),
      '-01-01'
    )
    AND date_add(
      current_date(),
      INTERVAL 30 DAY
    )
  )
GROUP BY
  s.id_sol

SELECT s.*, (CASE 
                    WHEN s.tipo_equipo = 'Equipo' THEN e.marbete
                    WHEN s.tipo_equipo = 'Impresora' THEN i.marbete
                    WHEN s.tipo_equipo = 'Red' THEN r.marbete
                    WHEN s.tipo_equipo = 'Otro' THEN o.marbete
                    ELSE ''
                END) AS marbete,
                (CASE 
                    WHEN s.tipo_equipo = 'Equipo' THEN e.descripcion
                    WHEN s.tipo_equipo = 'Impresora' THEN i.descripcion
                    WHEN s.tipo_equipo = 'Red' THEN r.descripcion
                    WHEN s.tipo_equipo = 'Otro' THEN o.descripcion
                    ELSE ''
                END) AS descripcion,
                (CASE 
                    WHEN s.tipo_equipo = 'Equipo' THEN cm.marca
                    WHEN s.tipo_equipo = 'Impresora' THEN i.marca
                    WHEN s.tipo_equipo = 'Red' THEN r.marca
                    WHEN s.tipo_equipo = 'Otro' THEN o.marca
                    ELSE ''
                END) AS marca,
                (CASE 
                    WHEN s.tipo_equipo = 'Equipo' THEN e.modelo
                    WHEN s.tipo_equipo = 'Impresora' THEN i.modelo
                    WHEN s.tipo_equipo = 'Red' THEN r.modelo
                    WHEN s.tipo_equipo = 'Otro' THEN o.modelo
                    ELSE ''
                END) AS modelo,
                (CASE 
                    WHEN s.tipo_equipo = 'Equipo' THEN e.serie
                    WHEN s.tipo_equipo = 'Impresora' THEN i.serie
                    WHEN s.tipo_equipo = 'Red' THEN r.serie
                    WHEN s.tipo_equipo = 'Otro' THEN o.serie
                    ELSE ''
                END) AS serie
                FROM solicitud s
                    JOIN usuario u on s.usuario = u.id_usu
                    LEFT JOIN equipo e ON s.id_equipo = e.id_equ
                    LEFT JOIN impresora i on s.id_equipo = i.id_imp
                    LEFT JOIN red r on s.id_equipo = r.id_red
                    LEFT JOIN otro o on s.id_equipo = o.id_otro
                    LEFT JOIN c_marcas cm ON e.id_marca = cm.id_marca
                    WHERE (u.id_usu = 1794 AND s.estatus != 4 AND s.tipo_mantenimiento IN ('MC', 'ST') and s.fregistro >= concat(year(now()),'-01-01'))
                OR (u.id_usu = 1794 AND s.estatus != 4 AND s.tipo_mantenimiento = 'MP' AND s.fatencion BETWEEN concat(year(now()),'-01-01') AND date_add(current_date() , INTERVAL 30 DAY))
                GROUP BY s.id_sol;

SELECT
  t0.id_ubi AS id_ubi_1,
  t0.area AS area_2,
  t0.activo AS activo_3,
  t0.unidad AS unidad_4
FROM
  ubicacion t0
WHERE
  t0.id_ubi = ?

SELECT t0.id_ubi AS id_ubi_1, t0.area AS area_2, t0.activo AS activo_3, t0.unidad AS unidad_4 FROM ubicacion t0 WHERE t0.id_ubi = 486;

SELECT
  t0.id_marca AS id_marca_1,
  t0.marca AS marca_2
FROM
  c_marcas t0
WHERE
  t0.id_marca = ?

SELECT t0.id_marca AS id_marca_1, t0.marca AS marca_2 FROM c_marcas t0 WHERE t0.id_marca = 242;