Symfony Profiler

SELECT
  DISTINCT c0_.poblacion AS poblacion_0
FROM
  convocatorias c0_
WHERE
  c0_.eliminado = 0
  AND c0_.indcerradaabierta = 1
  AND (
    (
      c0_.fechacierreiml >= '2026-07-03 02:55:50'
      OR (
        c0_.lateEntry1Permitido = 1
        AND c0_.fechacierreiml < '2026-07-03 02:55:50'
        AND c0_.lateEntry1Fecha >= '2026-07-03 02:55:50'
      )
      OR (
        c0_.lateEntry2Permitido = 1
        AND c0_.lateEntry1Fecha < '2026-07-03 02:55:50'
        AND c0_.lateEntry2Fecha >= '2026-07-03 02:55:50'
      )
      OR (
        c0_.lateEntry3Permitido = 1
        AND c0_.lateEntry2Fecha < '2026-07-03 02:55:50'
        AND c0_.lateEntry3Fecha >= '2026-07-03 02:55:50'
      )
    )
  )

SELECT DISTINCT c0_.poblacion AS poblacion_0 FROM convocatorias c0_ WHERE c0_.eliminado = 0 AND c0_.indcerradaabierta = 1 AND ((c0_.fechacierreiml >= '2026-07-03 02:55:50' OR (c0_.lateEntry1Permitido = 1 AND c0_.fechacierreiml < '2026-07-03 02:55:50' AND c0_.lateEntry1Fecha >= '2026-07-03 02:55:50') OR (c0_.lateEntry2Permitido = 1 AND c0_.lateEntry1Fecha < '2026-07-03 02:55:50' AND c0_.lateEntry2Fecha >= '2026-07-03 02:55:50') OR (c0_.lateEntry3Permitido = 1 AND c0_.lateEntry2Fecha < '2026-07-03 02:55:50' AND c0_.lateEntry3Fecha >= '2026-07-03 02:55:50')));

SELECT
  t0.id AS id_1,
  t0.poblacion AS poblacion_2,
  t0.slug AS slug_3,
  t0.texto AS texto_4,
  t0.eliminada AS eliminada_5
FROM
  convocatoriapoblacion t0
WHERE
  t0.poblacion = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.poblacion AS poblacion_2, t0.slug AS slug_3, t0.texto AS texto_4, t0.eliminada AS eliminada_5 FROM convocatoriapoblacion t0 WHERE t0.poblacion = 'Granada' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.poblacion AS poblacion_2,
  t0.slug AS slug_3,
  t0.texto AS texto_4,
  t0.eliminada AS eliminada_5
FROM
  convocatoriapoblacion t0
WHERE
  t0.poblacion = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.poblacion AS poblacion_2, t0.slug AS slug_3, t0.texto AS texto_4, t0.eliminada AS eliminada_5 FROM convocatoriapoblacion t0 WHERE t0.poblacion = 'Almería' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.poblacion AS poblacion_2,
  t0.slug AS slug_3,
  t0.texto AS texto_4,
  t0.eliminada AS eliminada_5
FROM
  convocatoriapoblacion t0
WHERE
  t0.poblacion = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.poblacion AS poblacion_2, t0.slug AS slug_3, t0.texto AS texto_4, t0.eliminada AS eliminada_5 FROM convocatoriapoblacion t0 WHERE t0.poblacion = 'Málaga' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.poblacion AS poblacion_2,
  t0.slug AS slug_3,
  t0.texto AS texto_4,
  t0.eliminada AS eliminada_5
FROM
  convocatoriapoblacion t0
WHERE
  t0.poblacion = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.poblacion AS poblacion_2, t0.slug AS slug_3, t0.texto AS texto_4, t0.eliminada AS eliminada_5 FROM convocatoriapoblacion t0 WHERE t0.poblacion = 'Marbella' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.poblacion AS poblacion_2,
  t0.slug AS slug_3,
  t0.texto AS texto_4,
  t0.eliminada AS eliminada_5
FROM
  convocatoriapoblacion t0
WHERE
  t0.poblacion = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.poblacion AS poblacion_2, t0.slug AS slug_3, t0.texto AS texto_4, t0.eliminada AS eliminada_5 FROM convocatoriapoblacion t0 WHERE t0.poblacion = 'Sevilla' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.poblacion AS poblacion_2,
  t0.slug AS slug_3,
  t0.texto AS texto_4,
  t0.eliminada AS eliminada_5
FROM
  convocatoriapoblacion t0
WHERE
  t0.poblacion = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.poblacion AS poblacion_2, t0.slug AS slug_3, t0.texto AS texto_4, t0.eliminada AS eliminada_5 FROM convocatoriapoblacion t0 WHERE t0.poblacion = 'Almuñécar' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.poblacion AS poblacion_2,
  t0.slug AS slug_3,
  t0.texto AS texto_4,
  t0.eliminada AS eliminada_5
FROM
  convocatoriapoblacion t0
WHERE
  t0.poblacion = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.poblacion AS poblacion_2, t0.slug AS slug_3, t0.texto AS texto_4, t0.eliminada AS eliminada_5 FROM convocatoriapoblacion t0 WHERE t0.poblacion = 'Huércal de Almería' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.poblacion AS poblacion_2,
  t0.slug AS slug_3,
  t0.texto AS texto_4,
  t0.eliminada AS eliminada_5
FROM
  convocatoriapoblacion t0
WHERE
  t0.poblacion = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.poblacion AS poblacion_2, t0.slug AS slug_3, t0.texto AS texto_4, t0.eliminada AS eliminada_5 FROM convocatoriapoblacion t0 WHERE t0.poblacion = 'El Ejido' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.poblacion AS poblacion_2,
  t0.slug AS slug_3,
  t0.texto AS texto_4,
  t0.eliminada AS eliminada_5
FROM
  convocatoriapoblacion t0
WHERE
  t0.poblacion = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.poblacion AS poblacion_2, t0.slug AS slug_3, t0.texto AS texto_4, t0.eliminada AS eliminada_5 FROM convocatoriapoblacion t0 WHERE t0.poblacion = 'Úbeda' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.poblacion AS poblacion_2,
  t0.slug AS slug_3,
  t0.texto AS texto_4,
  t0.eliminada AS eliminada_5
FROM
  convocatoriapoblacion t0
WHERE
  t0.poblacion = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.poblacion AS poblacion_2, t0.slug AS slug_3, t0.texto AS texto_4, t0.eliminada AS eliminada_5 FROM convocatoriapoblacion t0 WHERE t0.poblacion = 'Vera' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1
FROM
  academias a1_
  INNER JOIN usuarios u2_ ON a1_.id = u2_.id
  INNER JOIN provincias p0_ ON u2_.idprovincia_id = p0_.id
WHERE
  u2_.idprovincia_id IS NOT NULL
  AND u2_.activo = 1
  AND a1_.ispublic = 1
GROUP BY
  p0_.id,
  p0_.nombre
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1 FROM academias a1_ INNER JOIN usuarios u2_ ON a1_.id = u2_.id INNER JOIN provincias p0_ ON u2_.idprovincia_id = p0_.id WHERE u2_.idprovincia_id IS NOT NULL AND u2_.activo = 1 AND a1_.ispublic = 1 GROUP BY p0_.id, p0_.nombre ORDER BY p0_.nombre ASC;