Symfony Profiler

[
  "route" => "app_replay_index"
  "route_parameters" => [
    "_route" => "app_replay_index"
    "_controller" => "App\Controller\replay\ReplayController::index"
    "_locale" => "fr"
  ]
  "request_uri" => "http://street-fighter-6.anagraph.org/fr/replay/index?search=2026"
  "method" => "GET"
]

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

[
  "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" => "Nelmio\CorsBundle\EventListener\CorsListener::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" => "App\Listener\LocaleSubscriber::checkLocale"
]

[
  "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" => "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" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelController"
]

[
  "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\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" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

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

[
  "class" => "App\Query\replay\GetReplays"
  "handler" => "App\QueryHandler\replay\GetReplaysHandler::__invoke"
]

[
  "params" => [
    "driver" => "pdo_sqlite"
    "path" => "/app/system/database/SF6-anagraph.db"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => null
    "user" => "root"
    "password" => null
    "driverOptions" => []
    "defaultTableOptions" => []
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT r0_.video_platform AS video_platform_0, r0_.video_id AS video_id_1, r0_.video_timestamp AS video_timestamp_2, r0_.is_valid AS is_valid_3, r0_.description AS description_4, r0_.id AS id_5, r0_.created_at AS created_at_6, r0_.updated_at AS updated_at_7, m1_.character1 AS character1_8, m1_.variation1 AS variation1_9, m1_.winner AS winner_10, m1_.character2 AS character2_11, m1_.variation2 AS variation2_12, m1_.played_at AS played_at_13, m1_.version AS version_14, m1_.first_to AS first_to_15, m1_.connection AS connection_16, m1_.context AS context_17, m1_.event AS event_18, m1_.id AS id_19, m1_.created_at AS created_at_20, m1_.updated_at AS updated_at_21, p2_.name AS name_22, p2_.short_name AS short_name_23, p2_.original_name AS original_name_24, p2_.country AS country_25, p2_.main_character AS main_character_26, p2_.cfn_alias AS cfn_alias_27, p2_.discord_alias AS discord_alias_28, p2_.challonge_alias AS challonge_alias_29, p2_.start_ggid AS start_ggid_30, p2_.tonamel_id AS tonamel_id_31, p2_.esport_earnings_id AS esport_earnings_id_32, p2_.twitter_id AS twitter_id_33, p2_.twitch_channel AS twitch_channel_34, p2_.id AS id_35, p3_.name AS name_36, p3_.short_name AS short_name_37, p3_.original_name AS original_name_38, p3_.country AS country_39, p3_.main_character AS main_character_40, p3_.cfn_alias AS cfn_alias_41, p3_.discord_alias AS discord_alias_42, p3_.challonge_alias AS challonge_alias_43, p3_.start_ggid AS start_ggid_44, p3_.tonamel_id AS tonamel_id_45, p3_.esport_earnings_id AS esport_earnings_id_46, p3_.twitter_id AS twitter_id_47, p3_.twitch_channel AS twitch_channel_48, p3_.id AS id_49, r0_.sender_id AS sender_id_50, r0_.matching_id AS matching_id_51, m1_.player1_id AS player1_id_52, m1_.player2_id AS player2_id_53 FROM replay r0_ LEFT JOIN matching m1_ ON r0_.matching_id = m1_.id LEFT JOIN player p2_ ON m1_.player1_id = p2_.id LEFT JOIN player p3_ ON m1_.player2_id = p3_.id WHERE (LOWER(p2_.name) LIKE LOWER(?) OR LOWER(p2_.short_name) LIKE LOWER(?) OR LOWER(p2_.original_name) LIKE LOWER(?) OR LOWER(p3_.name) LIKE LOWER(?) OR LOWER(p3_.short_name) LIKE LOWER(?) OR LOWER(p3_.original_name) LIKE LOWER(?) OR LOWER(m1_.character1) LIKE LOWER(?) OR LOWER(m1_.character2) LIKE LOWER(?) OR LOWER(m1_.event) LIKE LOWER(?)) AND r0_.is_valid = 1 ORDER BY m1_.played_at DESC LIMIT 50"
  "params" => [
    1 => "%2026%"
    2 => "%2026%"
    3 => "%2026%"
    4 => "%2026%"
    5 => "%2026%"
    6 => "%2026%"
    7 => "%2026%"
    8 => "%2026%"
    9 => "%2026%"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1056
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1056}
    3 => Doctrine\DBAL\ParameterType {#1056}
    4 => Doctrine\DBAL\ParameterType {#1056}
    5 => Doctrine\DBAL\ParameterType {#1056}
    6 => Doctrine\DBAL\ParameterType {#1056}
    7 => Doctrine\DBAL\ParameterType {#1056}
    8 => Doctrine\DBAL\ParameterType {#1056}
    9 => Doctrine\DBAL\ParameterType {#1056}
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (SELECT r0_.video_platform AS video_platform_0, r0_.video_id AS video_id_1, r0_.video_timestamp AS video_timestamp_2, r0_.is_valid AS is_valid_3, r0_.description AS description_4, r0_.id AS id_5, r0_.created_at AS created_at_6, r0_.updated_at AS updated_at_7, m1_.character1 AS character1_8, m1_.variation1 AS variation1_9, m1_.winner AS winner_10, m1_.character2 AS character2_11, m1_.variation2 AS variation2_12, m1_.played_at AS played_at_13, m1_.version AS version_14, m1_.first_to AS first_to_15, m1_.connection AS connection_16, m1_.context AS context_17, m1_.event AS event_18, m1_.id AS id_19, m1_.created_at AS created_at_20, m1_.updated_at AS updated_at_21, p2_.name AS name_22, p2_.short_name AS short_name_23, p2_.original_name AS original_name_24, p2_.country AS country_25, p2_.main_character AS main_character_26, p2_.cfn_alias AS cfn_alias_27, p2_.discord_alias AS discord_alias_28, p2_.challonge_alias AS challonge_alias_29, p2_.start_ggid AS start_ggid_30, p2_.tonamel_id AS tonamel_id_31, p2_.esport_earnings_id AS esport_earnings_id_32, p2_.twitter_id AS twitter_id_33, p2_.twitch_channel AS twitch_channel_34, p2_.id AS id_35, p3_.name AS name_36, p3_.short_name AS short_name_37, p3_.original_name AS original_name_38, p3_.country AS country_39, p3_.main_character AS main_character_40, p3_.cfn_alias AS cfn_alias_41, p3_.discord_alias AS discord_alias_42, p3_.challonge_alias AS challonge_alias_43, p3_.start_ggid AS start_ggid_44, p3_.tonamel_id AS tonamel_id_45, p3_.esport_earnings_id AS esport_earnings_id_46, p3_.twitter_id AS twitter_id_47, p3_.twitch_channel AS twitch_channel_48, p3_.id AS id_49 FROM replay r0_ LEFT JOIN matching m1_ ON r0_.matching_id = m1_.id LEFT JOIN player p2_ ON m1_.player1_id = p2_.id LEFT JOIN player p3_ ON m1_.player2_id = p3_.id WHERE (LOWER(p2_.name) LIKE LOWER(?) OR LOWER(p2_.short_name) LIKE LOWER(?) OR LOWER(p2_.original_name) LIKE LOWER(?) OR LOWER(p3_.name) LIKE LOWER(?) OR LOWER(p3_.short_name) LIKE LOWER(?) OR LOWER(p3_.original_name) LIKE LOWER(?) OR LOWER(m1_.character1) LIKE LOWER(?) OR LOWER(m1_.character2) LIKE LOWER(?) OR LOWER(m1_.event) LIKE LOWER(?)) AND r0_.is_valid = 1 ORDER BY m1_.played_at DESC) dctrn_result) dctrn_table"
  "params" => [
    1 => "%2026%"
    2 => "%2026%"
    3 => "%2026%"
    4 => "%2026%"
    5 => "%2026%"
    6 => "%2026%"
    7 => "%2026%"
    8 => "%2026%"
    9 => "%2026%"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1056
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1056}
    3 => Doctrine\DBAL\ParameterType {#1056}
    4 => Doctrine\DBAL\ParameterType {#1056}
    5 => Doctrine\DBAL\ParameterType {#1056}
    6 => Doctrine\DBAL\ParameterType {#1056}
    7 => Doctrine\DBAL\ParameterType {#1056}
    8 => Doctrine\DBAL\ParameterType {#1056}
    9 => Doctrine\DBAL\ParameterType {#1056}
  ]
]

[
  "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" => "Symfony\UX\TwigComponent\Event\PreCreateForRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\InterceptChildComponentRenderSubscriber::preComponentCreated"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreMountEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\DataModelPropsSubscriber::onPreMount"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostMountEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\QueryStringInitializeSubscriber::onPostMount"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostMountEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\DeferLiveComponentSubscriber::onPostMount"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\AddLiveAttributesSubscriber::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\DeferLiveComponentSubscriber::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\ResetDeterministicIdSubscriber::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreCreateForRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\InterceptChildComponentRenderSubscriber::preComponentCreated"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreMountEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\DataModelPropsSubscriber::onPreMount"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostMountEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\QueryStringInitializeSubscriber::onPostMount"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostMountEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\DeferLiveComponentSubscriber::onPostMount"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\AddLiveAttributesSubscriber::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\DeferLiveComponentSubscriber::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\ResetDeterministicIdSubscriber::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

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

[
  "event" => "Symfony\UX\TwigComponent\Event\PreCreateForRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\InterceptChildComponentRenderSubscriber::preComponentCreated"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreMountEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\DataModelPropsSubscriber::onPreMount"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostMountEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\QueryStringInitializeSubscriber::onPostMount"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostMountEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\DeferLiveComponentSubscriber::onPostMount"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\AddLiveAttributesSubscriber::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\DeferLiveComponentSubscriber::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\ResetDeterministicIdSubscriber::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

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

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

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "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"
]