Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.host AS host_2,
  t0.puerto AS puerto_3,
  t0.seguridad AS seguridad_4,
  t0.email AS email_5,
  t0.password AS password_6
FROM
  smtp t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.host AS host_2, t0.puerto AS puerto_3, t0.seguridad AS seguridad_4, t0.email AS email_5, t0.password AS password_6 FROM smtp t0 WHERE t0.id = 1;

SELECT
  e0_.id AS id_0,
  e0_.deleted_at AS deleted_at_1,
  e0_.created_at AS created_at_2,
  e0_.nombre AS nombre_3,
  e0_.slug AS slug_4,
  e0_.codigo_postal AS codigo_postal_5,
  e0_.direccion AS direccion_6,
  e0_.latitud AS latitud_7,
  e0_.longitud AS longitud_8,
  e0_.descripcion_min AS descripcion_min_9,
  e0_.descripcion AS descripcion_10,
  e0_.path AS path_11,
  e0_.codigo_ine AS codigo_ine_12,
  e0_.habitantes AS habitantes_13,
  e0_.auto_evaluar_datos AS auto_evaluar_datos_14,
  e0_.mostrar_parte_publica AS mostrar_parte_publica_15,
  e0_.path_portada_ivl AS path_portada_ivl_16,
  e0_.path_fondo_ivl AS path_fondo_ivl_17,
  e0_.path_contraportada_ivl AS path_contraportada_ivl_18,
  e0_.optimizado_portada_ivl AS optimizado_portada_ivl_19,
  e0_.optimizado_fondo_ivl AS optimizado_fondo_ivl_20,
  e0_.optimizado_contraportada_ivl AS optimizado_contraportada_ivl_21,
  e0_.color_titulos_ivl AS color_titulos_ivl_22,
  e0_.color_subtitulos_ivl AS color_subtitulos_ivl_23,
  e0_.color_textos_ivl AS color_textos_ivl_24,
  e0_.color_corporativo AS color_corporativo_25,
  e0_.color_fondo AS color_fondo_26,
  e0_.comunidad_id AS comunidad_id_27,
  e0_.provincia_id AS provincia_id_28,
  e0_.poblacion_id AS poblacion_id_29
FROM
  entidad_local e0_
WHERE
  e0_.slug = ?
  AND e0_.deleted_at IS NULL

SELECT e0_.id AS id_0, e0_.deleted_at AS deleted_at_1, e0_.created_at AS created_at_2, e0_.nombre AS nombre_3, e0_.slug AS slug_4, e0_.codigo_postal AS codigo_postal_5, e0_.direccion AS direccion_6, e0_.latitud AS latitud_7, e0_.longitud AS longitud_8, e0_.descripcion_min AS descripcion_min_9, e0_.descripcion AS descripcion_10, e0_.path AS path_11, e0_.codigo_ine AS codigo_ine_12, e0_.habitantes AS habitantes_13, e0_.auto_evaluar_datos AS auto_evaluar_datos_14, e0_.mostrar_parte_publica AS mostrar_parte_publica_15, e0_.path_portada_ivl AS path_portada_ivl_16, e0_.path_fondo_ivl AS path_fondo_ivl_17, e0_.path_contraportada_ivl AS path_contraportada_ivl_18, e0_.optimizado_portada_ivl AS optimizado_portada_ivl_19, e0_.optimizado_fondo_ivl AS optimizado_fondo_ivl_20, e0_.optimizado_contraportada_ivl AS optimizado_contraportada_ivl_21, e0_.color_titulos_ivl AS color_titulos_ivl_22, e0_.color_subtitulos_ivl AS color_subtitulos_ivl_23, e0_.color_textos_ivl AS color_textos_ivl_24, e0_.color_corporativo AS color_corporativo_25, e0_.color_fondo AS color_fondo_26, e0_.comunidad_id AS comunidad_id_27, e0_.provincia_id AS provincia_id_28, e0_.poblacion_id AS poblacion_id_29 FROM entidad_local e0_ WHERE e0_.slug = 'AYUNTAMIENTO-DE-BENETUSSER' AND e0_.deleted_at IS NULL;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.color AS color_6,
  t0.path_ivl AS path_ivl_7
FROM
  ods t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.color AS color_6, t0.path_ivl AS path_ivl_7 FROM ods t0 WHERE t0.id = 16;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.nombre AS nombre_4,
  t0.slug AS slug_5,
  t0.codigo_postal AS codigo_postal_6,
  t0.direccion AS direccion_7,
  t0.latitud AS latitud_8,
  t0.longitud AS longitud_9,
  t0.descripcion_min AS descripcion_min_10,
  t0.descripcion AS descripcion_11,
  t0.path AS path_12,
  t0.codigo_ine AS codigo_ine_13,
  t0.habitantes AS habitantes_14,
  t0.auto_evaluar_datos AS auto_evaluar_datos_15,
  t0.mostrar_parte_publica AS mostrar_parte_publica_16,
  t0.path_portada_ivl AS path_portada_ivl_17,
  t0.path_fondo_ivl AS path_fondo_ivl_18,
  t0.path_contraportada_ivl AS path_contraportada_ivl_19,
  t0.optimizado_portada_ivl AS optimizado_portada_ivl_20,
  t0.optimizado_fondo_ivl AS optimizado_fondo_ivl_21,
  t0.optimizado_contraportada_ivl AS optimizado_contraportada_ivl_22,
  t0.color_titulos_ivl AS color_titulos_ivl_23,
  t0.color_subtitulos_ivl AS color_subtitulos_ivl_24,
  t0.color_textos_ivl AS color_textos_ivl_25,
  t0.color_corporativo AS color_corporativo_26,
  t0.color_fondo AS color_fondo_27,
  t0.comunidad_id AS comunidad_id_28,
  t0.provincia_id AS provincia_id_29,
  t0.poblacion_id AS poblacion_id_30
FROM
  entidad_local t0
WHERE
  t0.deleted_at IS NULL

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.nombre AS nombre_4, t0.slug AS slug_5, t0.codigo_postal AS codigo_postal_6, t0.direccion AS direccion_7, t0.latitud AS latitud_8, t0.longitud AS longitud_9, t0.descripcion_min AS descripcion_min_10, t0.descripcion AS descripcion_11, t0.path AS path_12, t0.codigo_ine AS codigo_ine_13, t0.habitantes AS habitantes_14, t0.auto_evaluar_datos AS auto_evaluar_datos_15, t0.mostrar_parte_publica AS mostrar_parte_publica_16, t0.path_portada_ivl AS path_portada_ivl_17, t0.path_fondo_ivl AS path_fondo_ivl_18, t0.path_contraportada_ivl AS path_contraportada_ivl_19, t0.optimizado_portada_ivl AS optimizado_portada_ivl_20, t0.optimizado_fondo_ivl AS optimizado_fondo_ivl_21, t0.optimizado_contraportada_ivl AS optimizado_contraportada_ivl_22, t0.color_titulos_ivl AS color_titulos_ivl_23, t0.color_subtitulos_ivl AS color_subtitulos_ivl_24, t0.color_textos_ivl AS color_textos_ivl_25, t0.color_corporativo AS color_corporativo_26, t0.color_fondo AS color_fondo_27, t0.comunidad_id AS comunidad_id_28, t0.provincia_id AS provincia_id_29, t0.poblacion_id AS poblacion_id_30 FROM entidad_local t0 WHERE t0.deleted_at IS NULL;

SELECT
  o0_.id AS id_0,
  o0_.deleted_at AS deleted_at_1,
  o0_.created_at AS created_at_2,
  o0_.orden AS orden_3,
  o0_.nombre AS nombre_4,
  o0_.color AS color_5,
  o0_.path_ivl AS path_ivl_6
FROM
  ods o0_
WHERE
  o0_.deleted_at IS NULL
ORDER BY
  o0_.orden ASC

SELECT o0_.id AS id_0, o0_.deleted_at AS deleted_at_1, o0_.created_at AS created_at_2, o0_.orden AS orden_3, o0_.nombre AS nombre_4, o0_.color AS color_5, o0_.path_ivl AS path_ivl_6 FROM ods o0_ WHERE o0_.deleted_at IS NULL ORDER BY o0_.orden ASC;

SELECT
  a0_.id AS id_0,
  a0_.deleted_at AS deleted_at_1,
  a0_.created_at AS created_at_2,
  a0_.anio AS anio_3,
  a0_.estado AS estado_4,
  a0_.entidad_local_id AS entidad_local_id_5
FROM
  anio a0_
WHERE
  a0_.entidad_local_id = ?
  AND a0_.deleted_at IS NULL
  AND a0_.estado = 3
ORDER BY
  a0_.anio DESC

SELECT a0_.id AS id_0, a0_.deleted_at AS deleted_at_1, a0_.created_at AS created_at_2, a0_.anio AS anio_3, a0_.estado AS estado_4, a0_.entidad_local_id AS entidad_local_id_5 FROM anio a0_ WHERE a0_.entidad_local_id = 6 AND a0_.deleted_at IS NULL AND a0_.estado = 3 ORDER BY a0_.anio DESC;

SELECT
  o0_.id AS id_0,
  o0_.nombre AS nombre_1,
  o0_.color AS color_2,
  o0_.orden AS orden_3,
  AVG(r1_.valor_homogenizado) AS sclr_4,
  COUNT(r1_.id) AS sclr_5
FROM
  resultado r1_
  INNER JOIN indicador i2_ ON r1_.indicador_id = i2_.id
  INNER JOIN meta m3_ ON i2_.meta_id = m3_.id
  INNER JOIN ods o0_ ON m3_.ods_id = o0_.id
WHERE
  r1_.anio = ?
  AND r1_.entidad_local_id = ?
  AND r1_.deleted_at IS NULL
  AND r1_.valor_homogenizado IS NOT NULL
  AND i2_.deleted_at IS NULL
  AND m3_.deleted_at IS NULL
  AND o0_.deleted_at IS NULL
  AND r1_.estado = 3
GROUP BY
  o0_.id
ORDER BY
  o0_.orden ASC

SELECT o0_.id AS id_0, o0_.nombre AS nombre_1, o0_.color AS color_2, o0_.orden AS orden_3, AVG(r1_.valor_homogenizado) AS sclr_4, COUNT(r1_.id) AS sclr_5 FROM resultado r1_ INNER JOIN indicador i2_ ON r1_.indicador_id = i2_.id INNER JOIN meta m3_ ON i2_.meta_id = m3_.id INNER JOIN ods o0_ ON m3_.ods_id = o0_.id WHERE r1_.anio = 2024 AND r1_.entidad_local_id = 6 AND r1_.deleted_at IS NULL AND r1_.valor_homogenizado IS NOT NULL AND i2_.deleted_at IS NULL AND m3_.deleted_at IS NULL AND o0_.deleted_at IS NULL AND r1_.estado = 3 GROUP BY o0_.id ORDER BY o0_.orden ASC;

SELECT
  o0_.id AS id_0,
  AVG(r1_.valor_homogenizado) AS sclr_1,
  COUNT(r1_.id) AS sclr_2
FROM
  resultado r1_
  INNER JOIN indicador i2_ ON r1_.indicador_id = i2_.id
  INNER JOIN meta m3_ ON i2_.meta_id = m3_.id
  INNER JOIN ods o0_ ON m3_.ods_id = o0_.id
WHERE
  r1_.anio = ?
  AND r1_.deleted_at IS NULL
  AND r1_.valor_homogenizado IS NOT NULL
  AND i2_.deleted_at IS NULL
  AND m3_.deleted_at IS NULL
  AND o0_.deleted_at IS NULL
  AND r1_.estado = 3
GROUP BY
  o0_.id
ORDER BY
  o0_.orden ASC

SELECT o0_.id AS id_0, AVG(r1_.valor_homogenizado) AS sclr_1, COUNT(r1_.id) AS sclr_2 FROM resultado r1_ INNER JOIN indicador i2_ ON r1_.indicador_id = i2_.id INNER JOIN meta m3_ ON i2_.meta_id = m3_.id INNER JOIN ods o0_ ON m3_.ods_id = o0_.id WHERE r1_.anio = 2024 AND r1_.deleted_at IS NULL AND r1_.valor_homogenizado IS NOT NULL AND i2_.deleted_at IS NULL AND m3_.deleted_at IS NULL AND o0_.deleted_at IS NULL AND r1_.estado = 3 GROUP BY o0_.id ORDER BY o0_.orden ASC;

SELECT
  r0_.anio AS anio_0,
  AVG(r0_.valor_homogenizado) AS sclr_1
FROM
  resultado r0_
  INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id
  INNER JOIN meta m2_ ON i1_.meta_id = m2_.id
WHERE
  r0_.entidad_local_id = ?
  AND r0_.deleted_at IS NULL
  AND r0_.valor_homogenizado IS NOT NULL
  AND i1_.deleted_at IS NULL
  AND m2_.deleted_at IS NULL
  AND r0_.estado = 3
GROUP BY
  r0_.anio
ORDER BY
  r0_.anio ASC

SELECT r0_.anio AS anio_0, AVG(r0_.valor_homogenizado) AS sclr_1 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id INNER JOIN meta m2_ ON i1_.meta_id = m2_.id WHERE r0_.entidad_local_id = 6 AND r0_.deleted_at IS NULL AND r0_.valor_homogenizado IS NOT NULL AND i1_.deleted_at IS NULL AND m2_.deleted_at IS NULL AND r0_.estado = 3 GROUP BY r0_.anio ORDER BY r0_.anio ASC;

SELECT
  r0_.id AS id_0,
  r0_.deleted_at AS deleted_at_1,
  r0_.created_at AS created_at_2,
  r0_.valor_tras_formula AS valor_tras_formula_3,
  r0_.valor_real_alcanzado AS valor_real_alcanzado_4,
  r0_.valor_objetivo AS valor_objetivo_5,
  r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6,
  r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7,
  r0_.valor_homogenizado AS valor_homogenizado_8,
  r0_.semaforizacion AS semaforizacion_9,
  r0_.informacion_adicional AS informacion_adicional_10,
  r0_.observaciones AS observaciones_11,
  r0_.observaciones_validador AS observaciones_validador_12,
  r0_.texto_ivl AS texto_ivl_13,
  r0_.mostrar_ivl AS mostrar_ivl_14,
  r0_.fecha_validado AS fecha_validado_15,
  r0_.estado AS estado_16,
  r0_.anio AS anio_17,
  r0_.path AS path_18,
  r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19,
  r0_.entidad_local_id AS entidad_local_id_20,
  r0_.indicador_id AS indicador_id_21,
  r0_.usuario_id AS usuario_id_22
FROM
  resultado r0_
  INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id
  INNER JOIN meta m2_ ON i1_.meta_id = m2_.id
  INNER JOIN ods o3_ ON m2_.ods_id = o3_.id
  INNER JOIN entidad_local e4_ ON r0_.entidad_local_id = e4_.id
WHERE
  r0_.deleted_at IS NULL
  AND r0_.valor_homogenizado IS NOT NULL
  AND i1_.deleted_at IS NULL
  AND m2_.deleted_at IS NULL
  AND o3_.deleted_at IS NULL
  AND r0_.anio = ?
  AND e4_.id = ?
  AND o3_.id = ?

SELECT r0_.id AS id_0, r0_.deleted_at AS deleted_at_1, r0_.created_at AS created_at_2, r0_.valor_tras_formula AS valor_tras_formula_3, r0_.valor_real_alcanzado AS valor_real_alcanzado_4, r0_.valor_objetivo AS valor_objetivo_5, r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6, r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7, r0_.valor_homogenizado AS valor_homogenizado_8, r0_.semaforizacion AS semaforizacion_9, r0_.informacion_adicional AS informacion_adicional_10, r0_.observaciones AS observaciones_11, r0_.observaciones_validador AS observaciones_validador_12, r0_.texto_ivl AS texto_ivl_13, r0_.mostrar_ivl AS mostrar_ivl_14, r0_.fecha_validado AS fecha_validado_15, r0_.estado AS estado_16, r0_.anio AS anio_17, r0_.path AS path_18, r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19, r0_.entidad_local_id AS entidad_local_id_20, r0_.indicador_id AS indicador_id_21, r0_.usuario_id AS usuario_id_22 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id INNER JOIN meta m2_ ON i1_.meta_id = m2_.id INNER JOIN ods o3_ ON m2_.ods_id = o3_.id INNER JOIN entidad_local e4_ ON r0_.entidad_local_id = e4_.id WHERE r0_.deleted_at IS NULL AND r0_.valor_homogenizado IS NOT NULL AND i1_.deleted_at IS NULL AND m2_.deleted_at IS NULL AND o3_.deleted_at IS NULL AND r0_.anio = 2024 AND e4_.id = 6 AND o3_.id = 16;