Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.grup AS grup_3,
  t0.categoria AS categoria_4,
  t0.url_fcf AS url_fcf_5,
  t0.url_clasificacion AS url_clasificacion_6,
  t0.raw_calendario AS raw_calendario_7,
  t0.raw_clasificacion AS raw_clasificacion_8,
  t0.time_updated AS time_updated_9
FROM
  competicion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.grup AS grup_3, t0.categoria AS categoria_4, t0.url_fcf AS url_fcf_5, t0.url_clasificacion AS url_clasificacion_6, t0.raw_calendario AS raw_calendario_7, t0.raw_clasificacion AS raw_clasificacion_8, t0.time_updated AS time_updated_9 FROM competicion t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.categoria AS categoria_3,
  t0.url_fcf AS url_fcf_4,
  t0.url_escudo AS url_escudo_5,
  t0.slug_fcf AS slug_fcf_6,
  t0.url_equipo AS url_equipo_7,
  t0.url_calendario AS url_calendario_8,
  t0.time_updated AS time_updated_9,
  t0.raw_detalles AS raw_detalles_10,
  t0.club_id AS club_id_11
FROM
  equipo t0
WHERE
  t0.club_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.club_id = 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.categoria AS categoria_3,
  t0.url_fcf AS url_fcf_4,
  t0.url_escudo AS url_escudo_5,
  t0.slug_fcf AS slug_fcf_6,
  t0.url_equipo AS url_equipo_7,
  t0.url_calendario AS url_calendario_8,
  t0.time_updated AS time_updated_9,
  t0.raw_detalles AS raw_detalles_10,
  t0.club_id AS club_id_11
FROM
  equipo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = 126;

SELECT
  p0_.id AS id_0,
  p0_.jornada AS jornada_1,
  p0_.fecha AS fecha_2,
  p0_.fecha_date AS fecha_date_3,
  p0_.fecha_time AS fecha_time_4,
  p0_.goles_local AS goles_local_5,
  p0_.goles_visitante AS goles_visitante_6,
  p0_.url_acta AS url_acta_7,
  p0_.jugado AS jugado_8,
  p0_.acta_descargada AS acta_descargada_9,
  p0_.time_updated AS time_updated_10,
  p0_.competicion_id AS competicion_id_11,
  p0_.equipo_local_id AS equipo_local_id_12,
  p0_.equipo_visitante_id AS equipo_visitante_id_13
FROM
  partido p0_
WHERE
  (
    p0_.equipo_local_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
    OR p0_.equipo_visitante_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  AND p0_.jugado = 1
  AND p0_.fecha_date >= ?
  AND p0_.fecha_date <= ?
ORDER BY
  p0_.fecha_date DESC

SELECT p0_.id AS id_0, p0_.jornada AS jornada_1, p0_.fecha AS fecha_2, p0_.fecha_date AS fecha_date_3, p0_.fecha_time AS fecha_time_4, p0_.goles_local AS goles_local_5, p0_.goles_visitante AS goles_visitante_6, p0_.url_acta AS url_acta_7, p0_.jugado AS jugado_8, p0_.acta_descargada AS acta_descargada_9, p0_.time_updated AS time_updated_10, p0_.competicion_id AS competicion_id_11, p0_.equipo_local_id AS equipo_local_id_12, p0_.equipo_visitante_id AS equipo_visitante_id_13 FROM partido p0_ WHERE (p0_.equipo_local_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43) OR p0_.equipo_visitante_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43)) AND p0_.jugado = 1 AND p0_.fecha_date >= '2026-04-20 00:00:00' AND p0_.fecha_date <= '2026-04-26 00:00:00' ORDER BY p0_.fecha_date DESC;

SELECT
  MAX(p0_.fecha_date) AS sclr_0
FROM
  partido p0_
WHERE
  (
    p0_.equipo_local_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
    OR p0_.equipo_visitante_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  AND p0_.jugado = 1

SELECT MAX(p0_.fecha_date) AS sclr_0 FROM partido p0_ WHERE (p0_.equipo_local_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43) OR p0_.equipo_visitante_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43)) AND p0_.jugado = 1;

SELECT
  p0_.nombre AS nombre_0,
  p0_.apellidos AS apellidos_1,
  c1_.categoria AS categoria_2,
  count(e2_.id) AS sclr_3
FROM
  evento_partido e2_
  INNER JOIN partido p3_ ON e2_.partido_id = p3_.id
  INNER JOIN persona p0_ ON e2_.persona_id = p0_.id
  INNER JOIN competicion c1_ ON p3_.competicion_id = c1_.id
  INNER JOIN equipo e4_ ON e2_.equipo_id = e4_.id
WHERE
  e4_.club_id = ?
  AND e2_.tipo IN (?, ?)
  AND p3_.fecha_date >= ?
  AND p3_.fecha_date <= ?
GROUP BY
  p0_.id,
  c1_.categoria
ORDER BY
  sclr_3 DESC

SELECT p0_.nombre AS nombre_0, p0_.apellidos AS apellidos_1, c1_.categoria AS categoria_2, count(e2_.id) AS sclr_3 FROM evento_partido e2_ INNER JOIN partido p3_ ON e2_.partido_id = p3_.id INNER JOIN persona p0_ ON e2_.persona_id = p0_.id INNER JOIN competicion c1_ ON p3_.competicion_id = c1_.id INNER JOIN equipo e4_ ON e2_.equipo_id = e4_.id WHERE e4_.club_id = 1 AND e2_.tipo IN ('GOL_NORMAL', 'GOL_PENALTI') AND p3_.fecha_date >= '2026-04-20 00:00:00' AND p3_.fecha_date <= '2026-04-26 00:00:00' GROUP BY p0_.id, c1_.categoria ORDER BY sclr_3 DESC;

SELECT
  t0.id AS id_1,
  t0.estado AS estado_2,
  t0.nombre AS nombre_3,
  t0.url_escudo AS url_escudo_4,
  t0.slug_fcf AS slug_fcf_5,
  t0.localizacion AS localizacion_6,
  t0.url_fcf AS url_fcf_7,
  t0.raw_equipos AS raw_equipos_8,
  t0.time_updated AS time_updated_9
FROM
  club t0
WHERE
  t0.slug_fcf = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.estado AS estado_2, t0.nombre AS nombre_3, t0.url_escudo AS url_escudo_4, t0.slug_fcf AS slug_fcf_5, t0.localizacion AS localizacion_6, t0.url_fcf AS url_fcf_7, t0.raw_equipos AS raw_equipos_8, t0.time_updated AS time_updated_9 FROM club t0 WHERE t0.slug_fcf = 'sant-ignasi-ce' LIMIT 1;

SELECT
  SUM(r0_.ganados) AS sclr_0,
  SUM(r0_.perdidos) AS sclr_1,
  SUM(r0_.goles_favor) AS sclr_2
FROM
  resultado r0_
  INNER JOIN equipo e1_ ON r0_.equipo_id = e1_.id
WHERE
  e1_.club_id = ?

SELECT SUM(r0_.ganados) AS sclr_0, SUM(r0_.perdidos) AS sclr_1, SUM(r0_.goles_favor) AS sclr_2 FROM resultado r0_ INNER JOIN equipo e1_ ON r0_.equipo_id = e1_.id WHERE e1_.club_id = 1;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  evento_partido e0_
  INNER JOIN equipo e1_ ON e0_.equipo_id = e1_.id
WHERE
  e1_.club_id = ?
  AND e0_.tipo IN (?, ?)

SELECT COUNT(e0_.id) AS sclr_0 FROM evento_partido e0_ INNER JOIN equipo e1_ ON e0_.equipo_id = e1_.id WHERE e1_.club_id = 1 AND e0_.tipo IN ('TARJETA_AMARILLA', 'TARJETA_ROJA');