Symfony Profiler

[
  "route" => "rankings.index"
  "route_parameters" => [
    "_route" => "rankings.index"
    "_controller" => "App\Controller\RankingController::index"
    "_locale" => "en"
  ]
  "request_uri" => "http://uller-dev.swissarchery.org/en/rankings"
  "method" => "GET"
]

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\LocaleListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\Api\ApiRateLimitSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerROfGsWM\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "2v80dw.myd.infomaniak.com"
    "port" => 3306
    "user" => "2v80dw_uller"
    "password" => "<redacted>"
    "driverOptions" => [
      "LoginTimeout" => 5
    ]
    "defaultTableOptions" => []
    "dbname" => "2v80dw_dev"
    "serverVersion" => "mariadb-10.6.22"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.referee_label AS referee_label_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM rule_book t0"
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.start_at AS start_at_2, s0_.end_at AS end_at_3, s0_.ranking_tournament_count AS ranking_tournament_count_4, s0_.rule_book_id AS rule_book_id_5 FROM season s0_ WHERE s0_.rule_book_id = ? ORDER BY s0_.start_at DESC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.start_at AS start_at_2, s0_.end_at AS end_at_3, s0_.ranking_tournament_count AS ranking_tournament_count_4, s0_.rule_book_id AS rule_book_id_5 FROM season s0_ WHERE s0_.start_at <= ? AND s0_.end_at >= ? AND s0_.rule_book_id = ? LIMIT 1"
  "params" => [
    1 => "2026-09-11 06:10:07"
    2 => "2026-09-11 06:10:07"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.state AS state_1, s0_.result AS result_2, s0_.is_guest AS is_guest_3, s0_.correspondence_language AS correspondence_language_4, s0_.first_name AS first_name_5, s0_.last_name AS last_name_6, s0_.email AS email_7, s0_.phone AS phone_8, s0_.address AS address_9, s0_.zip AS zip_10, s0_.city AS city_11, s0_.birth_date AS birth_date_12, s0_.license_number AS license_number_13, s0_.country AS country_14, s0_.token AS token_15, s0_.club_name AS club_name_16, s0_.is_wheelchair_user AS is_wheelchair_user_17, s0_.created_at AS created_at_18, s0_.updated_at AS updated_at_19, s0_.created_by AS created_by_20, s0_.updated_by AS updated_by_21, s0_.id AS id_22, s0_.state AS state_23, s0_.result AS result_24, s0_.is_guest AS is_guest_25, s0_.correspondence_language AS correspondence_language_26, s0_.first_name AS first_name_27, s0_.last_name AS last_name_28, s0_.email AS email_29, s0_.phone AS phone_30, s0_.address AS address_31, s0_.zip AS zip_32, s0_.city AS city_33, s0_.birth_date AS birth_date_34, s0_.license_number AS license_number_35, s0_.country AS country_36, s0_.token AS token_37, s0_.club_name AS club_name_38, s0_.is_wheelchair_user AS is_wheelchair_user_39, s0_.created_at AS created_at_40, s0_.updated_at AS updated_at_41, s0_.created_by AS created_by_42, s0_.updated_by AS updated_by_43, t1_.id AS id_44, t1_.fee AS fee_45, t1_.currency AS currency_46, t1_.created_at AS created_at_47, t1_.updated_at AS updated_at_48, t1_.created_by AS created_by_49, t1_.updated_by AS updated_by_50, t2_.id AS id_51, t2_.name AS name_52, t2_.register_start_at AS register_start_at_53, t2_.register_end_at AS register_end_at_54, t2_.inspection_start_at AS inspection_start_at_55, t2_.training_start_at AS training_start_at_56, t2_.shooting_start_at AS shooting_start_at_57, t2_.max_competitors AS max_competitors_58, t2_.is_final AS is_final_59, t2_.session_category AS session_category_60, t2_.is_inter_club AS is_inter_club_61, t2_.is_inter_gender AS is_inter_gender_62, t2_.team_members_number AS team_members_number_63, t2_.created_at AS created_at_64, t2_.updated_at AS updated_at_65, t2_.created_by AS created_by_66, t2_.updated_by AS updated_by_67, t3_.id AS id_68, t3_.name AS name_69, t3_.start_at AS start_at_70, t3_.end_at AS end_at_71, t3_.registration_start_at AS registration_start_at_72, t3_.registration_end_at AS registration_end_at_73, t3_.ianseo_link AS ianseo_link_74, t3_.description AS description_75, t3_.auto_accept_registrations AS auto_accept_registrations_76, t3_.url AS url_77, t3_.state AS state_78, t3_.token AS token_79, t3_.slug AS slug_80, t3_.created_at AS created_at_81, t3_.updated_at AS updated_at_82, t3_.created_by AS created_by_83, t3_.updated_by AS updated_by_84, u4_.id AS id_85, u4_.roles AS roles_86, u4_.email AS email_87, u4_.password AS password_88, u4_.username AS username_89, u4_.locale AS locale_90, u4_.last_login_at AS last_login_at_91, u4_.created_by AS created_by_92, u4_.updated_by AS updated_by_93, u4_.created_at AS created_at_94, u4_.updated_at AS updated_at_95, a5_.id AS id_96, a5_.name AS name_97, a5_.gender AS gender_98, a5_.state AS state_99, a5_.age_min AS age_min_100, a5_.age_max AS age_max_101, a5_.abbreviation AS abbreviation_102, a5_.created_at AS created_at_103, a5_.updated_at AS updated_at_104, a5_.created_by AS created_by_105, a5_.updated_by AS updated_by_106, d6_.id AS id_107, d6_.name AS name_108, d6_.abbreviation AS abbreviation_109, d6_.state AS state_110, d6_.created_at AS created_at_111, d6_.updated_at AS updated_at_112, d6_.created_by AS created_by_113, d6_.updated_by AS updated_by_114, t7_.id AS id_115, t7_.type AS type_116, t7_.name AS name_117, t7_.state AS state_118, t7_.round_count_max AS round_count_max_119, t7_.created_at AS created_at_120, t7_.updated_at AS updated_at_121, t7_.created_by AS created_by_122, t7_.updated_by AS updated_by_123, s0_.user_id AS user_id_124, s0_.tournament_session_id AS tournament_session_id_125, s0_.division_id AS division_id_126, s0_.tournament_age_class_id AS tournament_age_class_id_127, s0_.team_id AS team_id_128, t1_.age_class_id AS age_class_id_129, t1_.tournament_id AS tournament_id_130, t2_.tournament_id AS tournament_id_131, t3_.tournament_category_id AS tournament_category_id_132, t3_.tournament_format_id AS tournament_format_id_133, t3_.place_id AS place_id_134, t3_.user_organizer_id AS user_organizer_id_135, t3_.club_organizer_id AS club_organizer_id_136, t3_.rule_book_id AS rule_book_id_137, t3_.banner_file_id AS banner_file_id_138, u4_.person_id AS person_id_139, u4_.federation_id AS federation_id_140, a5_.rule_book_id AS rule_book_id_141, d6_.rule_book_id AS rule_book_id_142, t7_.rule_book_id AS rule_book_id_143 FROM session_registration s0_ INNER JOIN tournament_age_class t1_ ON s0_.tournament_age_class_id = t1_.id INNER JOIN tournament_session t2_ ON s0_.tournament_session_id = t2_.id INNER JOIN tournament t3_ ON t2_.tournament_id = t3_.id INNER JOIN user u4_ ON s0_.user_id = u4_.id INNER JOIN age_class a5_ ON t1_.age_class_id = a5_.id INNER JOIN division d6_ ON s0_.division_id = d6_.id INNER JOIN tournament_format t7_ ON t3_.tournament_format_id = t7_.id WHERE t3_.rule_book_id = ? AND t3_.start_at >= ? AND t3_.end_at <= ? AND s0_.result IS NOT NULL AND t2_.session_category <> ? ORDER BY t2_.shooting_start_at ASC LIMIT 1"
  "params" => [
    1 => 1
    2 => "2026-03-01 00:00:00"
    3 => "2026-09-30 00:00:00"
    4 => 20
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
    4 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.gender AS gender_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.phone AS phone_6, t0.address AS address_7, t0.npa AS npa_8, t0.city AS city_9, t0.birth_date AS birth_date_10, t0.decease_date AS decease_date_11, t0.retire_date AS retire_date_12, t0.printedAt AS printedAt_13, t0.lastPrintedAt AS lastPrintedAt_14, t0.numberPrinted AS numberPrinted_15, t0.note AS note_16, t0.language AS language_17, t0.membership_date AS membership_date_18, t0.membership_type AS membership_type_19, t0.deletedAt AS deletedAt_20, t0.locked AS locked_21, t0.licenseNumber AS licenseNumber_22, t0.hash AS hash_23, t0.birth_city_country AS birth_city_country_24, t0.height AS height_25, t0.spouse_children AS spouse_children_26, t0.former_name AS former_name_27, t0.residence_city_country AS residence_city_country_28, t0.education_city_country AS education_city_country_29, t0.occupation AS occupation_30, t0.website AS website_31, t0.twitter AS twitter_32, t0.facebook AS facebook_33, t0.instagram AS instagram_34, t0.snapchat AS snapchat_35, t0.discr AS discr_36, t0.created_by AS created_by_37, t0.updated_by AS updated_by_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.federation_id AS federation_id_41, t42.id AS id_43, t42.name AS name_44, t42.shortName AS shortName_45, t42.code AS code_46, t42.correspondenceLanguage AS correspondenceLanguage_47, t42.country AS country_48, t42.visible AS visible_49, t42.address AS address_50, t42.npa AS npa_51, t42.city AS city_52, t42.cantonCode AS cantonCode_53, t42.phone AS phone_54, t42.phone2 AS phone2_55, t42.mobile AS mobile_56, t42.fax AS fax_57, t42.fax2 AS fax2_58, t42.correspondanceCountry AS correspondanceCountry_59, t42.affiliated_year AS affiliated_year_60, t42.contactName AS contactName_61, t42.emailAddress AS emailAddress_62, t42.url AS url_63, t42.isMember AS isMember_64, t42.sendTo AS sendTo_65, t42.member_until_date AS member_until_date_66, t42.comment AS comment_67, t0.previous_federation_id AS previous_federation_id_68, t69.id AS id_70, t69.name AS name_71, t69.shortName AS shortName_72, t69.code AS code_73, t69.correspondenceLanguage AS correspondenceLanguage_74, t69.country AS country_75, t69.visible AS visible_76, t69.address AS address_77, t69.npa AS npa_78, t69.city AS city_79, t69.cantonCode AS cantonCode_80, t69.phone AS phone_81, t69.phone2 AS phone2_82, t69.mobile AS mobile_83, t69.fax AS fax_84, t69.fax2 AS fax2_85, t69.correspondanceCountry AS correspondanceCountry_86, t69.affiliated_year AS affiliated_year_87, t69.contactName AS contactName_88, t69.emailAddress AS emailAddress_89, t69.url AS url_90, t69.isMember AS isMember_91, t69.sendTo AS sendTo_92, t69.member_until_date AS member_until_date_93, t69.comment AS comment_94, t95.id AS id_96, t95.roles AS roles_97, t95.email AS email_98, t95.password AS password_99, t95.username AS username_100, t95.locale AS locale_101, t95.last_login_at AS last_login_at_102, t95.created_by AS created_by_103, t95.updated_by AS updated_by_104, t95.created_at AS created_at_105, t95.updated_at AS updated_at_106, t95.person_id AS person_id_107, t95.federation_id AS federation_id_108 FROM person t0 LEFT JOIN federation t42 ON t0.federation_id = t42.id LEFT JOIN federation t69 ON t0.previous_federation_id = t69.id LEFT JOIN user t95 ON t95.person_id = t0.id WHERE t0.id IN (?)"
  "params" => [
    1 => "44269aa4-18b2-11"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.abbreviation AS abbreviation_2, r0_.referee_label AS referee_label_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5, r0_.created_by AS created_by_6, r0_.updated_by AS updated_by_7 FROM rule_book r0_ WHERE (SELECT COUNT(*) FROM season s1_ WHERE s1_.rule_book_id = r0_.id) > 0"
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.name AS name_2, t0_.state AS state_3, t0_.round_count_max AS round_count_max_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t0_.created_by AS created_by_7, t0_.updated_by AS updated_by_8, t0_.rule_book_id AS rule_book_id_9 FROM tournament_format t0_ WHERE t0_.rule_book_id = ? AND t0_.state = ? ORDER BY t0_.name ASC"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.abbreviation AS abbreviation_2, d0_.state AS state_3, d0_.created_at AS created_at_4, d0_.updated_at AS updated_at_5, d0_.created_by AS created_by_6, d0_.updated_by AS updated_by_7, d0_.rule_book_id AS rule_book_id_8 FROM division d0_ WHERE d0_.rule_book_id = ? AND d0_.state = ? ORDER BY d0_.name ASC"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.gender AS gender_2, a0_.state AS state_3, a0_.age_min AS age_min_4, a0_.age_max AS age_max_5, a0_.abbreviation AS abbreviation_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.created_by AS created_by_9, a0_.updated_by AS updated_by_10, a0_.rule_book_id AS rule_book_id_11 FROM age_class a0_ WHERE a0_.rule_book_id = ? AND a0_.state = ? ORDER BY a0_.age_min ASC"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]