Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.nombre_canonical AS nombre_canonical_3,
  t0.created_at AS created_at_4,
  t0.nombre_corto AS nombre_corto_5,
  t0.direccion AS direccion_6,
  t0.telefono AS telefono_7,
  t0.web AS web_8,
  t0.rfeg_id AS rfeg_id_9,
  t0.intervalo_facturacion AS intervalo_facturacion_10,
  t0.minimo_factura AS minimo_factura_11,
  t0.latitud AS latitud_12,
  t0.longitud AS longitud_13,
  t0.habilitado AS habilitado_14,
  t0.graphql_enabled AS graphql_enabled_15,
  t0.graphql_key AS graphql_key_16,
  t0.graphql_signature AS graphql_signature_17,
  t0.visible AS visible_18,
  t0.allowTpv AS allowTpv_19,
  t0.externalId AS externalId_20,
  t0.rfc_seguro AS rfc_seguro_21,
  t0.flickr_gallery AS flickr_gallery_22,
  t0.livescoring_policy AS livescoring_policy_23,
  t0.localidad_id AS localidad_id_24,
  t0.User_id AS User_id_25,
  t0.Cliente_id AS Cliente_id_26,
  t0.timezone_id AS timezone_id_27
FROM
  Club t0
WHERE
  t0.id = ?
  AND t0.habilitado = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_canonical AS nombre_canonical_3, t0.created_at AS created_at_4, t0.nombre_corto AS nombre_corto_5, t0.direccion AS direccion_6, t0.telefono AS telefono_7, t0.web AS web_8, t0.rfeg_id AS rfeg_id_9, t0.intervalo_facturacion AS intervalo_facturacion_10, t0.minimo_factura AS minimo_factura_11, t0.latitud AS latitud_12, t0.longitud AS longitud_13, t0.habilitado AS habilitado_14, t0.graphql_enabled AS graphql_enabled_15, t0.graphql_key AS graphql_key_16, t0.graphql_signature AS graphql_signature_17, t0.visible AS visible_18, t0.allowTpv AS allowTpv_19, t0.externalId AS externalId_20, t0.rfc_seguro AS rfc_seguro_21, t0.flickr_gallery AS flickr_gallery_22, t0.livescoring_policy AS livescoring_policy_23, t0.localidad_id AS localidad_id_24, t0.User_id AS User_id_25, t0.Cliente_id AS Cliente_id_26, t0.timezone_id AS timezone_id_27 FROM Club t0 WHERE t0.id = 'AMH5' AND t0.habilitado = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.default_logo AS default_logo_3
FROM
  Comunidad t0
WHERE
  t0.nombre = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.default_logo AS default_logo_3 FROM Comunidad t0 WHERE t0.nombre = 'Andalucia' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.Cliente_id AS Cliente_id_3,
  t0.Region_id AS Region_id_4
FROM
  Federacion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.Cliente_id AS Cliente_id_3, t0.Region_id AS Region_id_4 FROM Federacion t0 WHERE t0.id = 'AMH5';

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.nombre_corto AS nombre_corto_3,
  t0.url_privacidad AS url_privacidad_4,
  t0.cif AS cif_5,
  t0.prioridad AS prioridad_6,
  t0.iban AS iban_7,
  t0.comision AS comision_8,
  t0.minimo_competicion AS minimo_competicion_9,
  t0.minimo_inscripcion AS minimo_inscripcion_10,
  t0.comision_devolucion AS comision_devolucion_11,
  t0.comision_cancelacion AS comision_cancelacion_12,
  t0.comision_sustitucion AS comision_sustitucion_13,
  t0.letra_facturacion AS letra_facturacion_14,
  t0.habilitado_contabilidad AS habilitado_contabilidad_15,
  t0.comision_devolucion_alternativa AS comision_devolucion_alternativa_16,
  t0.limite_devoluciones AS limite_devoluciones_17,
  t0.cod_cliente AS cod_cliente_18,
  t0.razon_social AS razon_social_19,
  t0.direccion_facturacion AS direccion_facturacion_20,
  t0.politica_entrega AS politica_entrega_21,
  t0.politica_inicio AS politica_inicio_22,
  t0.tipo AS tipo_23,
  t24.id AS id_25,
  t24.nombre AS nombre_26,
  t24.Cliente_id AS Cliente_id_27,
  t24.Region_id AS Region_id_28
FROM
  Cliente t0
  LEFT JOIN Federacion t24 ON t24.Cliente_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_corto AS nombre_corto_3, t0.url_privacidad AS url_privacidad_4, t0.cif AS cif_5, t0.prioridad AS prioridad_6, t0.iban AS iban_7, t0.comision AS comision_8, t0.minimo_competicion AS minimo_competicion_9, t0.minimo_inscripcion AS minimo_inscripcion_10, t0.comision_devolucion AS comision_devolucion_11, t0.comision_cancelacion AS comision_cancelacion_12, t0.comision_sustitucion AS comision_sustitucion_13, t0.letra_facturacion AS letra_facturacion_14, t0.habilitado_contabilidad AS habilitado_contabilidad_15, t0.comision_devolucion_alternativa AS comision_devolucion_alternativa_16, t0.limite_devoluciones AS limite_devoluciones_17, t0.cod_cliente AS cod_cliente_18, t0.razon_social AS razon_social_19, t0.direccion_facturacion AS direccion_facturacion_20, t0.politica_entrega AS politica_entrega_21, t0.politica_inicio AS politica_inicio_22, t0.tipo AS tipo_23, t24.id AS id_25, t24.nombre AS nombre_26, t24.Cliente_id AS Cliente_id_27, t24.Region_id AS Region_id_28 FROM Cliente t0 LEFT JOIN Federacion t24 ON t24.Cliente_id = t0.id WHERE t0.id = 1;

SELECT
  a.id,
  a.nombre,
  a.fecha_inicio,
  a.fecha_fin
FROM
  agrupacion a
WHERE
  a.fecha_inicio >= ?
  AND a.cliente_id = ?
GROUP BY
  a.id

SELECT a.id, a.nombre, a.fecha_inicio, a.fecha_fin
            FROM agrupacion a
            WHERE a.fecha_inicio >= '2025-12-11' AND a.cliente_id = 1
            GROUP BY a.id
        ;

SELECT
  a.id,
  a.nombre,
  a.fecha_inicio,
  a.fecha_fin
FROM
  agrupacion a
WHERE
  a.fecha_inicio <= ?
  AND a.cliente_id = ?
GROUP BY
  a.id

SELECT a.id, a.nombre, a.fecha_inicio, a.fecha_fin
            FROM agrupacion a
            WHERE a.fecha_inicio <= '2025-12-11' AND a.cliente_id = 1
            GROUP BY a.id
        ;

SELECT
  c.id,
  c.nombre,
  c.estado,
  c.Organizador_id AS organizer,
  c.Club_id AS club,
  c.wagr,
  calc.nombre AS calculationName,
  c.show_live_scoring AS livescoring,
  calc.id AS calculationId,
  c.jugadores,
  c.Modo_id AS MODE,
  c.plazas,
  c.fecha,
  c.Formula_id AS formula
FROM
  Competicion c
  INNER JOIN Calculo calc ON calc.id = c.Calculo_id
WHERE
  c.Club_id = ?
  AND c.fecha >= NOW()
  AND c.estado <> 'fecha indeterminada'
  AND c.visible = 1
  AND c.Modo_id <> 4
  AND c.rfc = 0
  AND c.id NOT IN (
    SELECT
      ca.competicion_id
    FROM
      competicion_agrupacion ca
  )
  AND c.deleted_at IS NULL
ORDER BY
  c.fecha ASC
LIMIT
  48

SELECT c.id, c.nombre, c.estado, c.Organizador_id AS organizer, c.Club_id AS club, c.wagr, calc.nombre AS calculationName, c.show_live_scoring AS livescoring, calc.id AS calculationId, c.jugadores, c.Modo_id AS MODE, c.plazas, c.fecha, c.Formula_id AS formula
            FROM Competicion c
            INNER JOIN Calculo calc ON calc.id = c.Calculo_id
            WHERE c.Club_id = 'AMH5' AND c.fecha >= NOW()
            AND c.estado <> 'fecha indeterminada' AND c.visible = 1 AND c.Modo_id <> 4 AND c.rfc = 0
            AND c.id NOT IN (SELECT ca.competicion_id FROM competicion_agrupacion ca)
            AND c.deleted_at IS NULL
            ORDER BY c.fecha ASC
            LIMIT 48;

SELECT
  c.id,
  c.nombre,
  c.estado,
  c.Organizador_id AS organizer,
  c.Club_id AS club,
  c.wagr,
  calc.nombre AS calculationName,
  calc.id AS calculationId,
  c.show_live_scoring AS livescoring,
  c.jugadores,
  c.Modo_id AS MODE,
  c.plazas,
  c.fecha,
  c.Formula_id AS formula
FROM
  Competicion c
  INNER JOIN Calculo calc ON calc.id = c.Calculo_id
WHERE
  c.Club_id = ?
  AND c.fecha <= NOW()
  AND c.estado <> 'fecha indeterminada'
  AND c.visible = 1
  AND c.Modo_id <> 4
  AND c.rfc = 0
  AND c.id NOT IN (
    SELECT
      ca.competicion_id
    FROM
      competicion_agrupacion ca
  )
  AND c.deleted_at IS NULL
ORDER BY
  c.fecha DESC
LIMIT
  48

SELECT c.id, c.nombre, c.estado, c.Organizador_id AS organizer, c.Club_id AS club, c.wagr, calc.nombre AS calculationName, calc.id AS calculationId, c.show_live_scoring AS livescoring, c.jugadores, c.Modo_id AS MODE, c.plazas, c.fecha, c.Formula_id AS formula
            FROM Competicion c
            INNER JOIN Calculo calc ON calc.id = c.Calculo_id
            WHERE c.Club_id = 'AMH5' AND c.fecha <= NOW()
            AND c.estado <> 'fecha indeterminada' AND c.visible = 1 AND c.Modo_id <> 4 AND c.rfc = 0
            AND c.id NOT IN (SELECT ca.competicion_id FROM competicion_agrupacion ca)
            AND c.deleted_at IS NULL
            ORDER BY c.fecha DESC
            LIMIT 48;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.nombre AS nombre_3,
  t0.valoracion AS valoracion_4,
  t0.created_at AS created_at_5,
  t0.medicion AS medicion_6,
  t0.campo_corto AS campo_corto_7,
  t0.activo AS activo_8,
  t0.prioridad AS prioridad_9,
  t0.available AS available_10,
  t0.latitude AS latitude_11,
  t0.longitude AS longitude_12,
  t0.Club_id AS Club_id_13
FROM
  Trazado t0
WHERE
  t0.Club_id = ?
  AND t0.activo = ?
ORDER BY
  t0.prioridad DESC,
  t0.numero ASC

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.nombre AS nombre_3, t0.valoracion AS valoracion_4, t0.created_at AS created_at_5, t0.medicion AS medicion_6, t0.campo_corto AS campo_corto_7, t0.activo AS activo_8, t0.prioridad AS prioridad_9, t0.available AS available_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.Club_id AS Club_id_13 FROM Trazado t0 WHERE t0.Club_id = 'AMH5' AND t0.activo = 1 ORDER BY t0.prioridad DESC, t0.numero ASC;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.id_aemet AS id_aemet_3,
  t0.provincia_id AS provincia_id_4
FROM
  Localidad t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = 267;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.comunidad_id AS comunidad_id_3
FROM
  Provincia t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = 18;