Symfony Profiler

SELECT
  DISTINCT m.id as msg_id,
  m.title,
  u.id as created_by_id,
  u.nombre as created_by,
  me.id as msg_entry_id,
  me.text,
  mkv2.value as start,
  mc.id categoryId,
  mc.category as category,
  1 as is_new
FROM
  msg AS m
  INNER JOIN msg_entry AS me ON me.id_msg_id = m.id
  LEFT JOIN msg_kv AS mkv ON mkv.id_msg_id = m.id
  LEFT JOIN msg_kv AS mkv2 ON mkv2.id_msg_id = m.id
  LEFT JOIN msg_kv AS mkv3 ON mkv3.id_msg_id = m.id
  LEFT JOIN msg_kv AS mkv4 ON mkv4.id_msg_id = m.id
  LEFT JOIN msg_kv AS mkv5 ON mkv5.id_msg_id = m.id
  LEFT JOIN msg_kv AS mkv6 ON mkv6.id_msg_id = m.id
  LEFT JOIN usuario AS u ON u.id = m.created_by_id
  LEFT JOIN msg_category AS mc ON mc.id = mkv5.value
WHERE
  m.type = 0
  AND (
    (
      mkv.field LIKE "user"
      AND mkv.value = 32752
    )
    OR (
      mkv.field LIKE "curso"
      AND mkv.value IN ("2745")
    )
  )
  AND mkv2.field LIKE "inicio"
  AND STR_TO_DATE(mkv2.value, "%d-%m-%Y") <= CURRENT_DATE
  AND mkv3.field LIKE "habilitado"
  AND mkv3.value = "1"
  AND mkv4.field LIKE "visualizar"
  AND mkv4.value = "1"
  AND mkv5.field LIKE "category"
  AND mkv6.field LIKE "fin"
  AND (
    mkv6.value IS NULL
    OR STR_TO_DATE(mkv6.value, "%d-%m-%Y") > CURRENT_DATE
  )
  AND me.id NOT IN (
    SELECT
      mr.id_msg_entry_id
    FROM
      msg_read mr
    WHERE
      mr.created_by_id = 32752
  )
UNION
SELECT
  DISTINCT m.id as msg_id,
  m.title,
  u.id as created_by_id,
  u.nombre as created_by,
  me.id as msg_entry_id,
  me.text,
  mkv2.value as start,
  mc.id categoryId,
  mc.category as category,
  0 as is_new
FROM
  msg AS m
  INNER JOIN msg_entry AS me ON me.id_msg_id = m.id
  LEFT JOIN msg_kv AS mkv ON mkv.id_msg_id = m.id
  LEFT JOIN msg_kv AS mkv2 ON mkv2.id_msg_id = m.id
  LEFT JOIN msg_kv AS mkv3 ON mkv3.id_msg_id = m.id
  LEFT JOIN msg_kv AS mkv4 ON mkv4.id_msg_id = m.id
  LEFT JOIN msg_kv AS mkv5 ON mkv5.id_msg_id = m.id
  LEFT JOIN msg_kv AS mkv6 ON mkv6.id_msg_id = m.id
  LEFT JOIN usuario AS u ON u.id = m.created_by_id
  LEFT JOIN msg_category AS mc ON mc.id = mkv5.value
WHERE
  m.type = 0
  AND (
    (
      mkv.field LIKE "user"
      AND mkv.value = 32752
    )
    OR (
      mkv.field LIKE "curso"
      AND mkv.value IN ("2745")
    )
  )
  AND mkv2.field LIKE "inicio"
  AND STR_TO_DATE(mkv2.value, "%d-%m-%Y") <= CURRENT_DATE
  AND mkv3.field LIKE "habilitado"
  AND mkv3.value = "1"
  AND mkv4.field LIKE "visualizar"
  AND mkv4.value = "1"
  AND mkv5.field LIKE "category"
  AND mkv6.field LIKE "fin"
  AND (
    mkv6.value IS NULL
    OR STR_TO_DATE(mkv6.value, "%d-%m-%Y") > CURRENT_DATE
  )
  AND me.id IN (
    SELECT
      mr.id_msg_entry_id
    FROM
      msg_read mr
    WHERE
      mr.created_by_id = 32752
  )
ORDER BY
  STR_TO_DATE(start, "%d-%m-%Y") DESC,
  msg_id DESC

SELECT DISTINCT m.id as msg_id, m.title, u.id as created_by_id, u.nombre as created_by, me.id as msg_entry_id
                            , me.text, mkv2.value as start, mc.id categoryId, mc.category as category, 1 as is_new
                FROM msg AS m
                    INNER JOIN msg_entry AS me ON me.id_msg_id = m.id
                    LEFT JOIN msg_kv AS mkv ON mkv.id_msg_id = m.id 
                    LEFT JOIN msg_kv AS mkv2 ON mkv2.id_msg_id = m.id
                    LEFT JOIN msg_kv AS mkv3 ON mkv3.id_msg_id = m.id
                    LEFT JOIN msg_kv AS mkv4 ON mkv4.id_msg_id = m.id
                    LEFT JOIN msg_kv AS mkv5 ON mkv5.id_msg_id = m.id
                    LEFT JOIN msg_kv AS mkv6 ON mkv6.id_msg_id = m.id
                    LEFT JOIN usuario AS u ON u.id = m.created_by_id
                    LEFT JOIN msg_category AS mc ON mc.id = mkv5.value
                WHERE m.type = 0
                    AND ((mkv.field LIKE "user" AND mkv.value = 32752) OR (mkv.field LIKE "curso" AND mkv.value IN ("2745"))) 
                    AND mkv2.field LIKE "inicio" AND STR_TO_DATE(mkv2.value, "%d-%m-%Y") <= CURRENT_DATE
                    AND mkv3.field LIKE "habilitado" AND mkv3.value = "1"
                    AND mkv4.field LIKE "visualizar" AND mkv4.value = "1"
                    AND mkv5.field LIKE "category"
                    AND mkv6.field LIKE "fin" AND (mkv6.value IS NULL OR STR_TO_DATE(mkv6.value, "%d-%m-%Y") > CURRENT_DATE)
                    AND me.id NOT IN (
                        SELECT mr.id_msg_entry_id
                        FROM msg_read mr
                        WHERE mr.created_by_id = 32752
                    )
                UNION
                SELECT DISTINCT m.id as msg_id, m.title, u.id as created_by_id, u.nombre as created_by, me.id as msg_entry_id
                            , me.text, mkv2.value as start, mc.id categoryId, mc.category as category, 0 as is_new
                FROM msg AS m
                    INNER JOIN msg_entry AS me ON me.id_msg_id = m.id
                    LEFT JOIN msg_kv AS mkv ON mkv.id_msg_id = m.id 
                    LEFT JOIN msg_kv AS mkv2 ON mkv2.id_msg_id = m.id
                    LEFT JOIN msg_kv AS mkv3 ON mkv3.id_msg_id = m.id
                    LEFT JOIN msg_kv AS mkv4 ON mkv4.id_msg_id = m.id
                    LEFT JOIN msg_kv AS mkv5 ON mkv5.id_msg_id = m.id
                    LEFT JOIN msg_kv AS mkv6 ON mkv6.id_msg_id = m.id
                    LEFT JOIN usuario AS u ON u.id = m.created_by_id
                    LEFT JOIN msg_category AS mc ON mc.id = mkv5.value
                WHERE m.type = 0
                    AND ((mkv.field LIKE "user" AND mkv.value = 32752) OR (mkv.field LIKE "curso" AND mkv.value IN ("2745"))) 
                    AND mkv2.field LIKE "inicio" AND STR_TO_DATE(mkv2.value, "%d-%m-%Y") <= CURRENT_DATE
                    AND mkv3.field LIKE "habilitado" AND mkv3.value = "1"
                    AND mkv4.field LIKE "visualizar" AND mkv4.value = "1"
                    AND mkv5.field LIKE "category"
                    AND mkv6.field LIKE "fin" AND (mkv6.value IS NULL OR STR_TO_DATE(mkv6.value, "%d-%m-%Y") > CURRENT_DATE)
                    AND me.id IN (
                        SELECT mr.id_msg_entry_id
                        FROM msg_read mr
                        WHERE mr.created_by_id = 32752
                    )
                ORDER BY STR_TO_DATE(start, "%d-%m-%Y") DESC, msg_id DESC;

UPDATE
  session
SET
  last_connection = 1731482019
WHERE
  user_id = 32752

UPDATE session SET last_connection = 1731482019 WHERE user_id =  32752  ;

SELECT
  entidad_id as id,
  valor as role
FROM
  custom_values
WHERE
  entidad LIKE "USER"
  AND entidad_id IN (32752)
  AND clave LIKE "id_roles"

SELECT entidad_id as id, valor as role
                FROM custom_values 
                WHERE entidad LIKE "USER" AND entidad_id IN (32752) AND clave LIKE "id_roles"
                ;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.create_at AS create_at_3,
  t0.updated_at AS updated_at_4,
  t0.email AS email_5,
  t0.password AS password_6,
  t0.dni AS dni_7,
  t0.roles AS roles_8,
  t0.estado AS estado_9
FROM
  usuario t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.create_at AS create_at_3, t0.updated_at AS updated_at_4, t0.email AS email_5, t0.password AS password_6, t0.dni AS dni_7, t0.roles AS roles_8, t0.estado AS estado_9 FROM usuario t0 WHERE t0.email = 'alumno_2745@jurispol.com' LIMIT 1;

SELECT
  id
FROM
  cursos
WHERE
  start_date <= CURRENT_DATE
  AND estado = 1
  AND CURRENT_DATE <= end_date
  AND id IN ("2745")

SELECT id FROM cursos WHERE start_date <= CURRENT_DATE AND estado = 1 AND CURRENT_DATE <= end_date AND id IN ("2745");

SELECT
  entidad_id as id,
  valor as sede
FROM
  custom_values
WHERE
  entidad LIKE "USER"
  AND entidad_id IN (32752)
  AND clave LIKE "sede"

SELECT entidad_id as id, valor as sede
                FROM custom_values 
                WHERE entidad LIKE "USER" AND entidad_id IN (32752) AND clave LIKE "sede"
                ;

SELECT
  cv.entidad_id as id,
  cv2.valor as sede
FROM
  custom_values cv
  LEFT JOIN custom_values cv2 ON cv2.entidad_id = cv.valor
WHERE
  cv.entidad LIKE "USER"
  AND cv.entidad_id IN (32752)
  AND cv.clave LIKE "curso"
  AND cv2.entidad LIKE "CURSO"
  AND cv2.clave LIKE "sede"

SELECT cv.entidad_id as id, cv2.valor as sede
                FROM custom_values cv
                    LEFT JOIN custom_values cv2 ON cv2.entidad_id = cv.valor
                WHERE cv.entidad LIKE "USER" AND cv.entidad_id IN (32752) AND cv.clave LIKE "curso"
                    AND cv2.entidad LIKE "CURSO" AND cv2.clave LIKE "sede"
                ;

SELECT
  DISTINCT conv.super_promocion
FROM
  cursos c
  LEFT JOIN convocatoria conv ON conv.id = c.convocatoria
WHERE
  c.id IN ("")

SELECT DISTINCT conv.super_promocion
                FROM cursos c
                    LEFT JOIN convocatoria conv ON conv.id = c.convocatoria 
                WHERE c.id IN ("");