Symfony Profiler

[
  "route" => "_club"
  "route_parameters" => [
    "_route" => "_club"
    "publi" => 0
    "_controller" => "App\Controller\Frontend\ClubController::showClub"
    "id" => "CP06"
  ]
  "request_uri" => "https://test01.nextcaddy.com/club/CP06"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "charset" => "utf8"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "devtestnx"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "5.6"
    "defaultTableOptions" => []
    "dbname" => "test_nextcaddy_01"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "CP06"
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "Canarias"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "CP06"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                SELECT a.id, a.nombre, a.fecha_inicio, a.fecha_fin\n
                FROM agrupacion a\n
                WHERE a.fecha_inicio >= ? and a.cliente_id = ?\n
                GROUP BY a.id\n
            
    """
  "params" => [
    1 => "2025-12-11"
    2 => 3
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    \n
                SELECT a.id, a.nombre, a.fecha_inicio, a.fecha_fin\n
                FROM agrupacion a\n
                WHERE a.fecha_inicio <= ? and a.cliente_id = ?\n
                GROUP BY a.id\n
            
    """
  "params" => [
    1 => "2025-12-11"
    2 => 3
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    \n
                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\n
                FROM Competicion c\n
                INNER JOIN Calculo calc on calc.id = c.Calculo_id\n
                WHERE c.Club_id = ? AND c.fecha >= now()\n
                AND c.estado <> 'fecha indeterminada' AND c.visible = 1 AND c.Modo_id <> 4 AND c.rfc = 0\n
                AND c.id not in (select ca.competicion_id FROM competicion_agrupacion ca)\n
                AND c.deleted_at is null\n
                ORDER BY c.fecha ASC\n
                LIMIT 48
    """
  "params" => [
    1 => "CP06"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    \n
                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\n
                FROM Competicion c\n
                INNER JOIN Calculo calc on calc.id = c.Calculo_id\n
                WHERE c.Club_id = ? AND c.fecha <= now()\n
                AND c.estado <> 'fecha indeterminada' AND c.visible = 1 AND c.Modo_id <> 4 AND c.rfc = 0\n
                AND c.id not in (select ca.competicion_id FROM competicion_agrupacion ca)\n
                AND c.deleted_at is null\n
                ORDER BY c.fecha DESC\n
                LIMIT 48
    """
  "params" => [
    1 => "CP06"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "CP06"
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 4106
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?"
  "params" => [
    1 => 38
  ]
  "types" => [
    1 => 1
  ]
]