Symfony Profiler

[
  "route" => "portada"
  "route_parameters" => [
    "_route" => "portada"
    "_controller" => "App\Controller\Frontend\IndexController::index"
  ]
  "request_uri" => "https://test01.nextcaddy.com/"
  "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 MAX(c0_.id) AS sclr_0 FROM Competicion c0_ WHERE (c0_.deleted_at IS NULL)"
]

[
  "sql" => "SELECT CAST(MAX(id) - 496781 AS SIGNED) AS resultado FROM Inscrito"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c1_.nombre AS nombre_2, DATE_FORMAT(c0_.fecha, '%Y-%m-%dT%H:%i:%s') AS sclr_3, DATE_FORMAT(c0_.fin, '%Y-%m-%dT%H:%i:%s') AS sclr_4, c0_.plazas AS plazas_5, c0_.lista_espera AS lista_espera_6 FROM Competicion c0_ INNER JOIN Club c2_ ON (c2_.id = c0_.Organizador_id) INNER JOIN Club c1_ ON (c1_.id = c0_.Club_id) INNER JOIN Modo m3_ ON (m3_.id = c0_.Modo_id) WHERE (c0_.estado = 'abierta' AND m3_.codigo = 'ONL' AND c0_.visible = 1 AND c0_.fin >= ? AND c2_.id LIKE '%00') AND (c0_.deleted_at IS NULL) ORDER BY c0_.fin ASC LIMIT 12"
  "params" => [
    1 => "25-12-09"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.equipo AS equipo_1, i0_.pareja AS pareja_2, i0_.participa AS participa_3, i0_.estado AS estado_4, i0_.hcp AS hcp_5, i0_.nombre_equipo AS nombre_equipo_6, i0_.observaciones AS observaciones_7, i0_.tipo_inscripcion AS tipo_inscripcion_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.hcp_sms AS hcp_sms_11, i0_.hcp_juego AS hcp_juego_12, i0_.num_competiciones AS num_competiciones_13, i0_.turno AS turno_14, i0_.agrupacion AS agrupacion_15, i0_.valido AS valido_16, i0_.invitado AS invitado_17, i0_.covid_modif AS covid_modif_18, i0_.order_waiting_list AS order_waiting_list_19, i0_.token AS token_20, i0_.Competicion_id AS Competicion_id_21, i0_.Jugador_id AS Jugador_id_22, i0_.Nivel_id AS Nivel_id_23, i0_.Especial_id AS Especial_id_24, i0_.Pedido_id AS Pedido_id_25, i0_.Categoria_id AS Categoria_id_26, i0_.CatCondicion_id AS CatCondicion_id_27, i0_.equipo_entidad AS equipo_entidad_28, i0_.tarifa AS tarifa_29 FROM Inscrito i0_ INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id WHERE i0_.Competicion_id = ? AND i0_.participa IN (?) AND i0_.estado = 'pagado' ORDER BY i0_.participa DESC"
  "params" => [
    1 => 60419
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.equipo AS equipo_1, i0_.pareja AS pareja_2, i0_.participa AS participa_3, i0_.estado AS estado_4, i0_.hcp AS hcp_5, i0_.nombre_equipo AS nombre_equipo_6, i0_.observaciones AS observaciones_7, i0_.tipo_inscripcion AS tipo_inscripcion_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.hcp_sms AS hcp_sms_11, i0_.hcp_juego AS hcp_juego_12, i0_.num_competiciones AS num_competiciones_13, i0_.turno AS turno_14, i0_.agrupacion AS agrupacion_15, i0_.valido AS valido_16, i0_.invitado AS invitado_17, i0_.covid_modif AS covid_modif_18, i0_.order_waiting_list AS order_waiting_list_19, i0_.token AS token_20, i0_.Competicion_id AS Competicion_id_21, i0_.Jugador_id AS Jugador_id_22, i0_.Nivel_id AS Nivel_id_23, i0_.Especial_id AS Especial_id_24, i0_.Pedido_id AS Pedido_id_25, i0_.Categoria_id AS Categoria_id_26, i0_.CatCondicion_id AS CatCondicion_id_27, i0_.equipo_entidad AS equipo_entidad_28, i0_.tarifa AS tarifa_29 FROM Inscrito i0_ INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id WHERE i0_.Competicion_id = ? AND i0_.participa IN (?) AND i0_.estado = 'pagado' ORDER BY i0_.participa DESC"
  "params" => [
    1 => 59549
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.equipo AS equipo_1, i0_.pareja AS pareja_2, i0_.participa AS participa_3, i0_.estado AS estado_4, i0_.hcp AS hcp_5, i0_.nombre_equipo AS nombre_equipo_6, i0_.observaciones AS observaciones_7, i0_.tipo_inscripcion AS tipo_inscripcion_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.hcp_sms AS hcp_sms_11, i0_.hcp_juego AS hcp_juego_12, i0_.num_competiciones AS num_competiciones_13, i0_.turno AS turno_14, i0_.agrupacion AS agrupacion_15, i0_.valido AS valido_16, i0_.invitado AS invitado_17, i0_.covid_modif AS covid_modif_18, i0_.order_waiting_list AS order_waiting_list_19, i0_.token AS token_20, i0_.Competicion_id AS Competicion_id_21, i0_.Jugador_id AS Jugador_id_22, i0_.Nivel_id AS Nivel_id_23, i0_.Especial_id AS Especial_id_24, i0_.Pedido_id AS Pedido_id_25, i0_.Categoria_id AS Categoria_id_26, i0_.CatCondicion_id AS CatCondicion_id_27, i0_.equipo_entidad AS equipo_entidad_28, i0_.tarifa AS tarifa_29 FROM Inscrito i0_ INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id WHERE i0_.Competicion_id = ? AND i0_.participa IN (?) AND i0_.estado = 'pagado' ORDER BY i0_.participa DESC"
  "params" => [
    1 => 60294
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.equipo AS equipo_1, i0_.pareja AS pareja_2, i0_.participa AS participa_3, i0_.estado AS estado_4, i0_.hcp AS hcp_5, i0_.nombre_equipo AS nombre_equipo_6, i0_.observaciones AS observaciones_7, i0_.tipo_inscripcion AS tipo_inscripcion_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.hcp_sms AS hcp_sms_11, i0_.hcp_juego AS hcp_juego_12, i0_.num_competiciones AS num_competiciones_13, i0_.turno AS turno_14, i0_.agrupacion AS agrupacion_15, i0_.valido AS valido_16, i0_.invitado AS invitado_17, i0_.covid_modif AS covid_modif_18, i0_.order_waiting_list AS order_waiting_list_19, i0_.token AS token_20, i0_.Competicion_id AS Competicion_id_21, i0_.Jugador_id AS Jugador_id_22, i0_.Nivel_id AS Nivel_id_23, i0_.Especial_id AS Especial_id_24, i0_.Pedido_id AS Pedido_id_25, i0_.Categoria_id AS Categoria_id_26, i0_.CatCondicion_id AS CatCondicion_id_27, i0_.equipo_entidad AS equipo_entidad_28, i0_.tarifa AS tarifa_29 FROM Inscrito i0_ INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id WHERE i0_.Competicion_id = ? AND i0_.participa IN (?) AND i0_.estado = 'pagado' ORDER BY i0_.participa DESC"
  "params" => [
    1 => 60426
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.equipo AS equipo_1, i0_.pareja AS pareja_2, i0_.participa AS participa_3, i0_.estado AS estado_4, i0_.hcp AS hcp_5, i0_.nombre_equipo AS nombre_equipo_6, i0_.observaciones AS observaciones_7, i0_.tipo_inscripcion AS tipo_inscripcion_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.hcp_sms AS hcp_sms_11, i0_.hcp_juego AS hcp_juego_12, i0_.num_competiciones AS num_competiciones_13, i0_.turno AS turno_14, i0_.agrupacion AS agrupacion_15, i0_.valido AS valido_16, i0_.invitado AS invitado_17, i0_.covid_modif AS covid_modif_18, i0_.order_waiting_list AS order_waiting_list_19, i0_.token AS token_20, i0_.Competicion_id AS Competicion_id_21, i0_.Jugador_id AS Jugador_id_22, i0_.Nivel_id AS Nivel_id_23, i0_.Especial_id AS Especial_id_24, i0_.Pedido_id AS Pedido_id_25, i0_.Categoria_id AS Categoria_id_26, i0_.CatCondicion_id AS CatCondicion_id_27, i0_.equipo_entidad AS equipo_entidad_28, i0_.tarifa AS tarifa_29 FROM Inscrito i0_ INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id WHERE i0_.Competicion_id = ? AND i0_.participa IN (?) AND i0_.estado = 'pagado' ORDER BY i0_.participa DESC"
  "params" => [
    1 => 61317
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]