Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nombre_es AS nombre_es_2,
  t0.nombre_eu AS nombre_eu_3,
  t0.funcion_id AS funcion_id_4
FROM
  actividad t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.nombre_es AS nombre_es_2, t0.nombre_eu AS nombre_eu_3, t0.funcion_id AS funcion_id_4 FROM actividad t0 WHERE t0.id IN (182);

SELECT
  DISTINCT t0_.id AS id_0,
  a1_.id AS id_1,
  a2_.tipo AS tipo_2
FROM
  titulacion t0_
  LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id
  LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id
WHERE
  a1_.id IN (?)

SELECT DISTINCT t0_.id AS id_0, a1_.id AS id_1, a2_.tipo AS tipo_2 FROM titulacion t0_ LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id WHERE a1_.id IN (182);

SELECT
  DISTINCT t0_.id AS id_0,
  a1_.id AS id_1,
  a2_.tipo AS tipo_2
FROM
  titulacion t0_
  LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id
  LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id
WHERE
  a1_.id = 182
  AND a2_.nivel >= 4

SELECT DISTINCT t0_.id AS id_0, a1_.id AS id_1, a2_.tipo AS tipo_2 FROM titulacion t0_ LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id WHERE a1_.id = 182 AND a2_.nivel >= 4;

SELECT
  max(a0_.nivel) AS sclr_0
FROM
  actividad_titulacion a0_
  LEFT JOIN actividad a1_ ON a0_.actividad_id = a1_.id
  LEFT JOIN titulacion t2_ ON a0_.titulacion_id = t2_.id
WHERE
  a1_.id = ?

SELECT max(a0_.nivel) AS sclr_0 FROM actividad_titulacion a0_ LEFT JOIN actividad a1_ ON a0_.actividad_id = a1_.id LEFT JOIN titulacion t2_ ON a0_.titulacion_id = t2_.id WHERE a1_.id = 182;

SELECT
  t0_.id AS id_0,
  t0_.nombre_eu AS nombre_eu_1,
  t0_.tipopractica_eu AS tipopractica_eu_2
FROM
  titulacion t0_

SELECT t0_.id AS id_0, t0_.nombre_eu AS nombre_eu_1, t0_.tipopractica_eu AS tipopractica_eu_2 FROM titulacion t0_;

SELECT
  DISTINCT t0_.id AS id_0,
  a1_.id AS id_1,
  a2_.tipo AS tipo_2
FROM
  titulacion t0_
  LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id
  LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id
WHERE
  a1_.id IN (?)

SELECT DISTINCT t0_.id AS id_0, a1_.id AS id_1, a2_.tipo AS tipo_2 FROM titulacion t0_ LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id WHERE a1_.id IN (182);

SELECT
  DISTINCT t0_.id AS id_0,
  a1_.id AS id_1,
  a2_.tipo AS tipo_2
FROM
  titulacion t0_
  LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id
  LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id
WHERE
  a1_.id = 182
  AND a2_.nivel >= 4

SELECT DISTINCT t0_.id AS id_0, a1_.id AS id_1, a2_.tipo AS tipo_2 FROM titulacion t0_ LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id WHERE a1_.id = 182 AND a2_.nivel >= 4;

SELECT
  t0.id AS id_1,
  t0.nombre_es AS nombre_es_2,
  t0.codigo AS codigo_3,
  t0.label AS label_4,
  t0.modalidad AS modalidad_5,
  t0.tipo AS tipo_6,
  t0.tipopractica_es AS tipopractica_es_7,
  t0.nombre_eu AS nombre_eu_8,
  t0.tipopractica_eu AS tipopractica_eu_9,
  t0.nivel AS nivel_10,
  t11.id AS id_12,
  t11.descripcion_eu AS descripcion_eu_13,
  t11.descripcion_es AS descripcion_es_14,
  t11.titulacion_id AS titulacion_id_15
FROM
  titulacion t0
  LEFT JOIN perfil_competencial t11 ON t11.titulacion_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre_es AS nombre_es_2, t0.codigo AS codigo_3, t0.label AS label_4, t0.modalidad AS modalidad_5, t0.tipo AS tipo_6, t0.tipopractica_es AS tipopractica_es_7, t0.nombre_eu AS nombre_eu_8, t0.tipopractica_eu AS tipopractica_eu_9, t0.nivel AS nivel_10, t11.id AS id_12, t11.descripcion_eu AS descripcion_eu_13, t11.descripcion_es AS descripcion_es_14, t11.titulacion_id AS titulacion_id_15 FROM titulacion t0 LEFT JOIN perfil_competencial t11 ON t11.titulacion_id = t0.id WHERE t0.id = 1;

SELECT
  a0_.id AS id_0,
  a0_.nombre_eu AS nombre_eu_1,
  a1_.tipo AS tipo_2,
  a1_.nivel AS nivel_3
FROM
  actividad a0_
  LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id
  LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id
WHERE
  t2_.id = ?
  AND a0_.id IN (?)
ORDER BY
  a0_.nombre_eu ASC

SELECT a0_.id AS id_0, a0_.nombre_eu AS nombre_eu_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = 1 AND a0_.id IN (182) ORDER BY a0_.nombre_eu ASC;

SELECT
  t0.id AS id_1,
  t0.nivel AS nivel_2,
  t0.tipo AS tipo_3,
  t0.titulacion_id AS titulacion_id_4,
  t0.actividad_id AS actividad_id_5
FROM
  actividad_titulacion t0
WHERE
  t0.titulacion_id = ?

SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = 1;

SELECT
  t0.id AS id_1,
  t0.nombre_es AS nombre_es_2,
  t0.codigo AS codigo_3,
  t0.label AS label_4,
  t0.modalidad AS modalidad_5,
  t0.tipo AS tipo_6,
  t0.tipopractica_es AS tipopractica_es_7,
  t0.nombre_eu AS nombre_eu_8,
  t0.tipopractica_eu AS tipopractica_eu_9,
  t0.nivel AS nivel_10,
  t11.id AS id_12,
  t11.descripcion_eu AS descripcion_eu_13,
  t11.descripcion_es AS descripcion_es_14,
  t11.titulacion_id AS titulacion_id_15
FROM
  titulacion t0
  LEFT JOIN perfil_competencial t11 ON t11.titulacion_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre_es AS nombre_es_2, t0.codigo AS codigo_3, t0.label AS label_4, t0.modalidad AS modalidad_5, t0.tipo AS tipo_6, t0.tipopractica_es AS tipopractica_es_7, t0.nombre_eu AS nombre_eu_8, t0.tipopractica_eu AS tipopractica_eu_9, t0.nivel AS nivel_10, t11.id AS id_12, t11.descripcion_eu AS descripcion_eu_13, t11.descripcion_es AS descripcion_es_14, t11.titulacion_id AS titulacion_id_15 FROM titulacion t0 LEFT JOIN perfil_competencial t11 ON t11.titulacion_id = t0.id WHERE t0.id = 2;

SELECT
  a0_.id AS id_0,
  a0_.nombre_eu AS nombre_eu_1,
  a1_.tipo AS tipo_2,
  a1_.nivel AS nivel_3
FROM
  actividad a0_
  LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id
  LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id
WHERE
  t2_.id = ?
  AND a0_.id IN (?)
ORDER BY
  a0_.nombre_eu ASC

SELECT a0_.id AS id_0, a0_.nombre_eu AS nombre_eu_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = 2 AND a0_.id IN (182) ORDER BY a0_.nombre_eu ASC;

SELECT
  t0.id AS id_1,
  t0.nivel AS nivel_2,
  t0.tipo AS tipo_3,
  t0.titulacion_id AS titulacion_id_4,
  t0.actividad_id AS actividad_id_5
FROM
  actividad_titulacion t0
WHERE
  t0.titulacion_id = ?

SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = 2;

SELECT
  t0.id AS id_1,
  t0.nombre_es AS nombre_es_2,
  t0.codigo AS codigo_3,
  t0.label AS label_4,
  t0.modalidad AS modalidad_5,
  t0.tipo AS tipo_6,
  t0.tipopractica_es AS tipopractica_es_7,
  t0.nombre_eu AS nombre_eu_8,
  t0.tipopractica_eu AS tipopractica_eu_9,
  t0.nivel AS nivel_10,
  t11.id AS id_12,
  t11.descripcion_eu AS descripcion_eu_13,
  t11.descripcion_es AS descripcion_es_14,
  t11.titulacion_id AS titulacion_id_15
FROM
  titulacion t0
  LEFT JOIN perfil_competencial t11 ON t11.titulacion_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre_es AS nombre_es_2, t0.codigo AS codigo_3, t0.label AS label_4, t0.modalidad AS modalidad_5, t0.tipo AS tipo_6, t0.tipopractica_es AS tipopractica_es_7, t0.nombre_eu AS nombre_eu_8, t0.tipopractica_eu AS tipopractica_eu_9, t0.nivel AS nivel_10, t11.id AS id_12, t11.descripcion_eu AS descripcion_eu_13, t11.descripcion_es AS descripcion_es_14, t11.titulacion_id AS titulacion_id_15 FROM titulacion t0 LEFT JOIN perfil_competencial t11 ON t11.titulacion_id = t0.id WHERE t0.id = 3;

SELECT
  a0_.id AS id_0,
  a0_.nombre_eu AS nombre_eu_1,
  a1_.tipo AS tipo_2,
  a1_.nivel AS nivel_3
FROM
  actividad a0_
  LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id
  LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id
WHERE
  t2_.id = ?
  AND a0_.id IN (?)
ORDER BY
  a0_.nombre_eu ASC

SELECT a0_.id AS id_0, a0_.nombre_eu AS nombre_eu_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = 3 AND a0_.id IN (182) ORDER BY a0_.nombre_eu ASC;