Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Configuration

Query Metrics

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

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 DISTINCT c0_.poblacion AS poblacion_0 FROM convocatorias c0_ WHERE c0_.eliminado = 0 AND c0_.indcerradaabierta = 1 AND ((c0_.fechacierreiml >= '2026-07-03 01:39:48' OR (c0_.lateEntry1Permitido = 1 AND c0_.fechacierreiml < '2026-07-03 01:39:48' AND c0_.lateEntry1Fecha >= '2026-07-03 01:39:48') OR (c0_.lateEntry2Permitido = 1 AND c0_.lateEntry1Fecha < '2026-07-03 01:39:48' AND c0_.lateEntry2Fecha >= '2026-07-03 01:39:48') OR (c0_.lateEntry3Permitido = 1 AND c0_.lateEntry2Fecha < '2026-07-03 01:39:48' AND c0_.lateEntry3Fecha >= '2026-07-03 01:39:48')))

[]

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

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

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

[
  "Granada"
]

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;