Symfony Profiler

[
  "route" => "_tournament"
  "route_parameters" => [
    "_route" => "_tournament"
    "publi" => 0
    "_controller" => "App\Controller\Frontend\TournamentController::tournament"
    "id" => "57875"
  ]
  "request_uri" => "https://test01.nextcaddy.com/tour/57875"
  "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.codigo AS codigo_2, t0.codigo_contable AS codigo_contable_3, t0.nombre AS nombre_4, t0.fecha AS fecha_5, t0.inicio AS inicio_6, t0.fin AS fin_7, t0.plazas AS plazas_8, t0.jugadores AS jugadores_9, t0.observaciones AS observaciones_10, t0.observaciones_planificacion AS observaciones_planificacion_11, t0.aviso AS aviso_12, t0.informacion AS informacion_13, t0.rfeg_id AS rfeg_id_14, t0.cartel AS cartel_15, t0.horario AS horario_16, t0.fichero_inscritos AS fichero_inscritos_17, t0.fichero_clasificaciones AS fichero_clasificaciones_18, t0.fichero_localeRulePdf AS fichero_localeRulePdf_19, t0.fichero_banner_schedule AS fichero_banner_schedule_20, t0.fichero_reglas AS fichero_reglas_21, t0.fichero_varios_nombre AS fichero_varios_nombre_22, t0.fichero_varios AS fichero_varios_23, t0.circular AS circular_24, t0.nombre_observaciones AS nombre_observaciones_25, t0.hash AS hash_26, t0.estado AS estado_27, t0.estado_corte AS estado_corte_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.tarifa_reglamento AS tarifa_reglamento_31, t0.redireccion AS redireccion_32, t0.wagr AS wagr_33, t0.subvencion_junta AS subvencion_junta_34, t0.galeria AS galeria_35, t0.informacion_popup AS informacion_popup_36, t0.reglas AS reglas_37, t0.num_competiciones AS num_competiciones_38, t0.tag_color AS tag_color_39, t0.show_live_scoring AS show_live_scoring_40, t0.rfc AS rfc_41, t0.estricto AS estricto_42, t0.hcp_estricto AS hcp_estricto_43, t0.hcp_inscrito_masculino AS hcp_inscrito_masculino_44, t0.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_45, t0.hcp_inscrito_femenino AS hcp_inscrito_femenino_46, t0.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_47, t0.hcp_juego_masculino AS hcp_juego_masculino_48, t0.hcp_juego_femenino AS hcp_juego_femenino_49, t0.hcp_juego_pareja AS hcp_juego_pareja_50, t0.hcp_juego_equipo AS hcp_juego_equipo_51, t0.premios AS premios_52, t0.arbitrable AS arbitrable_53, t0.direccion_torneos AS direccion_torneos_54, t0.asistencia_presidente AS asistencia_presidente_55, t0.institucional AS institucional_56, t0.voluntarios AS voluntarios_57, t0.flyer AS flyer_58, t0.permitir AS permitir_59, t0.social AS social_60, t0.visible AS visible_61, t0.seguimiento AS seguimiento_62, t0.popup_inscripcion AS popup_inscripcion_63, t0.popup_inscripcion_texto AS popup_inscripcion_texto_64, t0.mostrar_sorteo AS mostrar_sorteo_65, t0.malaga2020 AS malaga2020_66, t0.lista_espera AS lista_espera_67, t0.restringir_licencia AS restringir_licencia_68, t0.seleccion_tarifas AS seleccion_tarifas_69, t0.permitir_extranjeros AS permitir_extranjeros_70, t0.plazas_manana AS plazas_manana_71, t0.plazas_tarde AS plazas_tarde_72, t0.tarjeta_electronica AS tarjeta_electronica_73, t0.auto_assign_marker AS auto_assign_marker_74, t0.livescoring_comunidad AS livescoring_comunidad_75, t0.plazas_lista_espera AS plazas_lista_espera_76, t0.deleted_at AS deleted_at_77, t0.contacto AS contacto_78, t0.benefico AS benefico_79, t0.flickr_gallery AS flickr_gallery_80, t0.barra_salida AS barra_salida_81, t0.observaciones_frontend AS observaciones_frontend_82, t0.mostrar_plazas AS mostrar_plazas_83, t0.politica_inicio AS politica_inicio_84, t0.politica_entrega AS politica_entrega_85, t0.short_url AS short_url_86, t0.privada AS privada_87, t0.camera_url AS camera_url_88, t0.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_89, t0.liquidation_date AS liquidation_date_90, t0.collection_date AS collection_date_91, t0.livescoring_policy AS livescoring_policy_92, t0.livescoring_formula AS livescoring_formula_93, t0.show_events AS show_events_94, t0.destacada AS destacada_95, t0.Formula_id AS Formula_id_96, t0.Modo_id AS Modo_id_97, t0.Calculo_id AS Calculo_id_98, t0.Club_id AS Club_id_99, t0.Organizador_id AS Organizador_id_100, t0.Criterio_id AS Criterio_id_101, t0.Criterio2_id AS Criterio2_id_102, t103.id AS id_104, t103.created_at AS created_at_105, t103.updated_at AS updated_at_106, t103.jugador_id AS jugador_id_107, t103.competicion_id AS competicion_id_108 FROM Competicion t0 LEFT JOIN marcador_rfc t103 ON t103.competicion_id = t0.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "57875"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.social AS social_1, t0_.desde AS desde_2, t0_.hasta AS hasta_3, t0_.importe AS importe_4, t0_.nombre AS nombre_5, t0_.tipo_socio AS tipo_socio_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8, t0_.inicio AS inicio_9, t0_.fin AS fin_10, t0_.Competicion_id AS Competicion_id_11, t0_.TipoSocio_id AS TipoSocio_id_12 FROM Tarifa t0_ INNER JOIN Competicion c1_ ON (c1_.id = t0_.Competicion_id) AND (c1_.deleted_at IS NULL) INNER JOIN Club c2_ ON (c1_.Club_id = c2_.id) INNER JOIN timezone t3_ ON (t3_.id = c2_.timezone_id) WHERE t0_.Competicion_id = ? AND (t0_.inicio IS NULL OR CONVERT_TZ(t0_.inicio, t3_.nombre, 'Europe/Madrid') <= ?) AND (t0_.fin IS NULL OR CONVERT_TZ(t0_.fin, t3_.nombre, 'Europe/Madrid') >= ?)"
  "params" => [
    1 => 57875
    2 => "2025-12-11 16:14:51"
    3 => "2025-12-11 16:14:51"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.plazas AS plazas_3, t0.Competicion_id AS Competicion_id_4, t0.Criterio_id AS Criterio_id_5, t0.Criterio2_id AS Criterio2_id_6, t0.Nivel_id AS Nivel_id_7, t0.Condicion_id AS Condicion_id_8 FROM Categoria t0 WHERE t0.Competicion_id = ?"
  "params" => [
    1 => 57875
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                select csh.*, cs.dom_id as cs_dom_id from competition_section_hidden csh inner join competition_section cs on cs.id = csh.competition_section_tab_id where csh.competition_id = :competitionId\n
            
    """
  "params" => [
    "competitionId" => 57875
  ]
  "types" => []
]

[
  "sql" => "SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ LEFT JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id WHERE i0_.Competicion_id = ? AND i0_.estado IN (?)"
  "params" => [
    1 => 57875
    2 => "pagado"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT COUNT(h0_.id) AS sclr_0 FROM Horario h0_ INNER JOIN Jornada j1_ ON h0_.Jornada_id = j1_.id WHERE j1_.Competicion_id = ?"
  "params" => [
    1 => 57875
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(c0_.id) AS sclr_0 FROM Clasificacion c0_ WHERE c0_.Competicion_id = 57875 AND c0_.publicada = 1"
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM Estadisticas e0_ WHERE e0_.Competicion_id = ?"
  "params" => [
    1 => 57875
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.nombre AS nombre_1, r0_.edad_minima AS edad_minima_2, r0_.edad_maxima AS edad_maxima_3, r0_.sexo AS sexo_4, r0_.hcp_min AS hcp_min_5, r0_.hcp_max AS hcp_max_6, r0_.fecha_inicio AS fecha_inicio_7, r0_.fecha_fin AS fecha_fin_8, r0_.minimo_pruebas AS minimo_pruebas_9, r0_.pruebas_puntuables AS pruebas_puntuables_10, r0_.mejores_pruebas AS mejores_pruebas_11, r0_.puntos_extra_participacion AS puntos_extra_participacion_12, r0_.desempate AS desempate_13, r0_.desempate2 AS desempate2_14, r0_.activo AS activo_15, r0_.parejas AS parejas_16, r0_.federadosRegionales AS federadosRegionales_17, r0_.modalidad AS modalidad_18, r0_.titulo_competicion AS titulo_competicion_19, r0_.generated_at AS generated_at_20, r0_.tipo_final AS tipo_final_21, r0_.excluir_final AS excluir_final_22, r0_.observations AS observations_23, r0_.ranking_type AS ranking_type_24, r0_.include_special_tee AS include_special_tee_25, r0_.agrupation AS agrupation_26, r0_.only_club_players AS only_club_players_27, r0_.Nivel_id AS Nivel_id_28, r0_.Cliente_id AS Cliente_id_29, r0_.Competicion_id AS Competicion_id_30, r0_.club_id AS club_id_31, r0_.ranking_point_position_template_id AS ranking_point_position_template_id_32 FROM Ranking r0_ LEFT JOIN CompeticionRanking c1_ ON r0_.id = c1_.Ranking_id LEFT JOIN Competicion c2_ ON c1_.Competicion_id = c2_.id AND (c2_.deleted_at IS NULL) WHERE c2_.id = ? AND r0_.activo = 1"
  "params" => [
    1 => 57875
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.orden AS orden_3, t0.created_at AS created_at_4, t0.procesada AS procesada_5, t0.sms_hcp AS sms_hcp_6, t0.asc_valor AS asc_valor_7, t0.clima AS clima_8, t0.zona_bandera AS zona_bandera_9, t0.sensibilidad AS sensibilidad_10, t0.bloqueo AS bloqueo_11, t0.team_livescoring AS team_livescoring_12, t0.scramble_estricto AS scramble_estricto_13, t0.Competicion_id AS Competicion_id_14, t0.Modalidad_id AS Modalidad_id_15, t0.Trazado_id AS Trazado_id_16, t17.id AS id_18, t17.value AS value_19, t17.created_at AS created_at_20, t17.updated_at AS updated_at_21, t17.jornada_id AS jornada_id_22, t17.ranking_id AS ranking_id_23 FROM Jornada t0 LEFT JOIN asc_ranking t17 ON t17.jornada_id = t0.id WHERE t0.Competicion_id = ? AND t0.fecha = ? LIMIT 1"
  "params" => [
    1 => 57875
    2 => "2025-12-11"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.orden AS orden_3, t0.created_at AS created_at_4, t0.procesada AS procesada_5, t0.sms_hcp AS sms_hcp_6, t0.asc_valor AS asc_valor_7, t0.clima AS clima_8, t0.zona_bandera AS zona_bandera_9, t0.sensibilidad AS sensibilidad_10, t0.bloqueo AS bloqueo_11, t0.team_livescoring AS team_livescoring_12, t0.scramble_estricto AS scramble_estricto_13, t0.Competicion_id AS Competicion_id_14, t0.Modalidad_id AS Modalidad_id_15, t0.Trazado_id AS Trazado_id_16, t17.id AS id_18, t17.value AS value_19, t17.created_at AS created_at_20, t17.updated_at AS updated_at_21, t17.jornada_id AS jornada_id_22, t17.ranking_id AS ranking_id_23 FROM Jornada t0 LEFT JOIN asc_ranking t17 ON t17.jornada_id = t0.id WHERE t0.Competicion_id = ? AND t0.fecha = ? LIMIT 1"
  "params" => [
    1 => 57875
    2 => "2025-12-12"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT p0_.version AS version_0 FROM PublicacionPrograma p0_ WHERE p0_.Competicion_id = ? ORDER BY p0_.fecha DESC LIMIT 1"
  "params" => [
    1 => 57875
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.equipo AS equipo_1, e0_.nombre AS nombre_2, e0_.color AS color_3, e0_.Competicion_id AS Competicion_id_4, e0_.profesional AS profesional_5 FROM Equipo e0_ INNER JOIN Inscrito i1_ ON (e0_.id = i1_.equipo_entidad) WHERE e0_.Competicion_id = ? AND i1_.participa = 1 AND i1_.valido = 1 AND i1_.estado = 'pagado' GROUP BY e0_.id"
  "params" => [
    1 => 57875
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.orden AS orden_3, t0.created_at AS created_at_4, t0.procesada AS procesada_5, t0.sms_hcp AS sms_hcp_6, t0.asc_valor AS asc_valor_7, t0.clima AS clima_8, t0.zona_bandera AS zona_bandera_9, t0.sensibilidad AS sensibilidad_10, t0.bloqueo AS bloqueo_11, t0.team_livescoring AS team_livescoring_12, t0.scramble_estricto AS scramble_estricto_13, t0.Competicion_id AS Competicion_id_14, t0.Modalidad_id AS Modalidad_id_15, t0.Trazado_id AS Trazado_id_16, t17.id AS id_18, t17.value AS value_19, t17.created_at AS created_at_20, t17.updated_at AS updated_at_21, t17.jornada_id AS jornada_id_22, t17.ranking_id AS ranking_id_23 FROM Jornada t0 LEFT JOIN asc_ranking t17 ON t17.jornada_id = t0.id WHERE t0.Competicion_id = ? ORDER BY t0.orden ASC"
  "params" => [
    1 => 57875
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM Formula t0 WHERE t0.id = ?"
  "params" => [
    1 => "S"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM Calculo t0 WHERE t0.id = ?"
  "params" => [
    1 => "H"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.cartel AS cartel_3, t0.fecha_inicio AS fecha_inicio_4, t0.fecha_fin AS fecha_fin_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.destacada AS destacada_8, t0.Cliente_id AS Cliente_id_9 FROM Circuito t0 INNER JOIN Circuito_Competicion ON t0.id = Circuito_Competicion.circuito_id WHERE Circuito_Competicion.competicion_id = ? ORDER BY t0.Cliente_id ASC, t0.fecha_inicio ASC, t0.fecha_fin ASC, t0.nombre ASC"
  "params" => [
    1 => 57875
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_corto AS nombre_corto_3, t0.activo AS activo_4, t0.slug AS slug_5, t0.rfga_id AS rfga_id_6, t0.url AS url_7, t0.tipo AS tipo_8, t0.active_federation AS active_federation_9, t0.Cliente_id AS Cliente_id_10 FROM Comite t0 INNER JOIN Comite_Competicion ON t0.id = Comite_Competicion.Comite_id WHERE Comite_Competicion.competicion_id = ? ORDER BY t0.Cliente_id ASC, t0.activo DESC, t0.nombre ASC"
  "params" => [
    1 => 57875
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 370
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.valor AS valor_3 FROM timezone t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]