Symfony Profiler

[
  "route" => "app_stats_index"
  "route_parameters" => [
    "_route" => "app_stats_index"
    "_controller" => "App\Controller\StatsController::index"
  ]
  "request_uri" => "https://jeux.sifflote.fr/stats/"
  "method" => "GET"
]

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

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

[
  "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\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "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" => "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" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::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"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "b81vv.myd.infomaniak.com"
    "port" => 3306
    "user" => "b81vv_site"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "b81vv_jeux"
    "serverVersion" => "10.6.22-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.registered_at AS registered_at_1, u0_.last_login_at AS last_login_at_2, u0_.nickname AS nickname_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.email AS email_6, u0_.is_verified AS is_verified_7, u0_.google_id AS google_id_8, u0_.first_name AS first_name_9, u0_.last_name AS last_name_10, u0_.date_of_birth AS date_of_birth_11, u0_.avatar_filename AS avatar_filename_12, u0_.updated_at AS updated_at_13, u0_.notification_settings AS notification_settings_14, u0_.is_profile_private AS is_profile_private_15, (COUNT(DISTINCT b1_.id) + COUNT(DISTINCT b2_.id)) AS sclr_16 FROM users u0_ LEFT JOIN bgg_play_session b1_ ON u0_.id = b1_.user_id LEFT JOIN bgg_play_session_registered_player b3_ ON u0_.id = b3_.users_id LEFT JOIN bgg_play_session b2_ ON b2_.id = b3_.play_session_id GROUP BY u0_.id ORDER BY sclr_16 DESC LIMIT 10"
]

[
  "sql" => "SELECT COUNT(*) FROM bgg_boardgame t0"
]

[
  "sql" => "SELECT COUNT(*) FROM bgg_forum_thread t0"
]

[
  "sql" => "SELECT COUNT(*) FROM bgg_forum_post t0"
]

[
  "sql" => "SELECT COUNT(*) FROM boardgame_file t0"
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.content AS content_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3, b0_.game_name AS game_name_4, b0_.min_players AS min_players_5, b0_.max_players AS max_players_6, b0_.play_time AS play_time_7, b0_.min_age AS min_age_8, b0_.difficulty AS difficulty_9, b0_.cover_image_filename AS cover_image_filename_10, b0_.release_date AS release_date_11, b0_.language AS language_12, b0_.slug AS slug_13, b0_.score AS score_14, b0_.average_rating AS average_rating_15, b0_.mise_en_place AS mise_en_place_16, b0_.rejouabilite AS rejouabilite_17, b0_.interactivite AS interactivite_18, b0_.prise_en_main AS prise_en_main_19, b0_.thematique AS thematique_20, b0_.materiel AS materiel_21, b0_.difficulte_description AS difficulte_description_22, b0_.mise_en_place_description AS mise_en_place_description_23, b0_.rejouabilite_description AS rejouabilite_description_24, b0_.interactivite_description AS interactivite_description_25, b0_.prise_en_main_description AS prise_en_main_description_26, b0_.thematique_description AS thematique_description_27, b0_.materiel_description AS materiel_description_28, b0_.author_rating AS author_rating_29, b0_.author_comment AS author_comment_30, b0_.is_standalone_extension AS is_standalone_extension_31, b0_.edition_name AS edition_name_32, b0_.bgg_id AS bgg_id_33, b0_.bgg_rank AS bgg_rank_34, COUNT(u1_.id) AS sclr_35, b0_.author_id AS author_id_36, b0_.base_game_id AS base_game_id_37, b0_.main_edition_id AS main_edition_id_38 FROM bgg_boardgame b0_ INNER JOIN user_ludotheque_games u2_ ON b0_.id = u2_.boardgame_id INNER JOIN users u1_ ON u1_.id = u2_.users_id GROUP BY b0_.id ORDER BY sclr_35 DESC LIMIT 10"
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.content AS content_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3, b0_.game_name AS game_name_4, b0_.min_players AS min_players_5, b0_.max_players AS max_players_6, b0_.play_time AS play_time_7, b0_.min_age AS min_age_8, b0_.difficulty AS difficulty_9, b0_.cover_image_filename AS cover_image_filename_10, b0_.release_date AS release_date_11, b0_.language AS language_12, b0_.slug AS slug_13, b0_.score AS score_14, b0_.average_rating AS average_rating_15, b0_.mise_en_place AS mise_en_place_16, b0_.rejouabilite AS rejouabilite_17, b0_.interactivite AS interactivite_18, b0_.prise_en_main AS prise_en_main_19, b0_.thematique AS thematique_20, b0_.materiel AS materiel_21, b0_.difficulte_description AS difficulte_description_22, b0_.mise_en_place_description AS mise_en_place_description_23, b0_.rejouabilite_description AS rejouabilite_description_24, b0_.interactivite_description AS interactivite_description_25, b0_.prise_en_main_description AS prise_en_main_description_26, b0_.thematique_description AS thematique_description_27, b0_.materiel_description AS materiel_description_28, b0_.author_rating AS author_rating_29, b0_.author_comment AS author_comment_30, b0_.is_standalone_extension AS is_standalone_extension_31, b0_.edition_name AS edition_name_32, b0_.bgg_id AS bgg_id_33, b0_.bgg_rank AS bgg_rank_34, COUNT(u1_.id) AS sclr_35, b0_.author_id AS author_id_36, b0_.base_game_id AS base_game_id_37, b0_.main_edition_id AS main_edition_id_38 FROM bgg_boardgame b0_ INNER JOIN user_wishlist_games u2_ ON b0_.id = u2_.boardgame_id INNER JOIN users u1_ ON u1_.id = u2_.users_id GROUP BY b0_.id ORDER BY sclr_35 DESC LIMIT 10"
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.content AS content_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3, b0_.game_name AS game_name_4, b0_.min_players AS min_players_5, b0_.max_players AS max_players_6, b0_.play_time AS play_time_7, b0_.min_age AS min_age_8, b0_.difficulty AS difficulty_9, b0_.cover_image_filename AS cover_image_filename_10, b0_.release_date AS release_date_11, b0_.language AS language_12, b0_.slug AS slug_13, b0_.score AS score_14, b0_.average_rating AS average_rating_15, b0_.mise_en_place AS mise_en_place_16, b0_.rejouabilite AS rejouabilite_17, b0_.interactivite AS interactivite_18, b0_.prise_en_main AS prise_en_main_19, b0_.thematique AS thematique_20, b0_.materiel AS materiel_21, b0_.difficulte_description AS difficulte_description_22, b0_.mise_en_place_description AS mise_en_place_description_23, b0_.rejouabilite_description AS rejouabilite_description_24, b0_.interactivite_description AS interactivite_description_25, b0_.prise_en_main_description AS prise_en_main_description_26, b0_.thematique_description AS thematique_description_27, b0_.materiel_description AS materiel_description_28, b0_.author_rating AS author_rating_29, b0_.author_comment AS author_comment_30, b0_.is_standalone_extension AS is_standalone_extension_31, b0_.edition_name AS edition_name_32, b0_.bgg_id AS bgg_id_33, b0_.bgg_rank AS bgg_rank_34, b0_.author_id AS author_id_35, b0_.base_game_id AS base_game_id_36, b0_.main_edition_id AS main_edition_id_37 FROM bgg_boardgame b0_ WHERE (SELECT COUNT(*) FROM bgg_review b1_ WHERE b1_.boardgame_id = b0_.id) >= ? ORDER BY b0_.average_rating DESC, (SELECT COUNT(*) FROM bgg_review b1_ WHERE b1_.boardgame_id = b0_.id) DESC LIMIT 10"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.content AS content_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3, b0_.game_name AS game_name_4, b0_.min_players AS min_players_5, b0_.max_players AS max_players_6, b0_.play_time AS play_time_7, b0_.min_age AS min_age_8, b0_.difficulty AS difficulty_9, b0_.cover_image_filename AS cover_image_filename_10, b0_.release_date AS release_date_11, b0_.language AS language_12, b0_.slug AS slug_13, b0_.score AS score_14, b0_.average_rating AS average_rating_15, b0_.mise_en_place AS mise_en_place_16, b0_.rejouabilite AS rejouabilite_17, b0_.interactivite AS interactivite_18, b0_.prise_en_main AS prise_en_main_19, b0_.thematique AS thematique_20, b0_.materiel AS materiel_21, b0_.difficulte_description AS difficulte_description_22, b0_.mise_en_place_description AS mise_en_place_description_23, b0_.rejouabilite_description AS rejouabilite_description_24, b0_.interactivite_description AS interactivite_description_25, b0_.prise_en_main_description AS prise_en_main_description_26, b0_.thematique_description AS thematique_description_27, b0_.materiel_description AS materiel_description_28, b0_.author_rating AS author_rating_29, b0_.author_comment AS author_comment_30, b0_.is_standalone_extension AS is_standalone_extension_31, b0_.edition_name AS edition_name_32, b0_.bgg_id AS bgg_id_33, b0_.bgg_rank AS bgg_rank_34, COUNT(b1_.id) AS sclr_35, b0_.author_id AS author_id_36, b0_.base_game_id AS base_game_id_37, b0_.main_edition_id AS main_edition_id_38 FROM bgg_boardgame b0_ INNER JOIN bgg_play_session b1_ ON b0_.id = b1_.boardgame_id GROUP BY b0_.id ORDER BY sclr_35 DESC LIMIT 10"
]

[
  "sql" => "SELECT SUBSTRING(b0_.created_at FROM 1 FOR 7) AS sclr_0, COUNT(b0_.id) AS sclr_1 FROM bgg_boardgame b0_ GROUP BY sclr_0 ORDER BY sclr_0 ASC"
]

[
  "sql" => "SELECT b0_.difficulty AS difficulty_0, COUNT(b0_.id) AS sclr_1 FROM bgg_boardgame b0_ WHERE b0_.difficulty IS NOT NULL GROUP BY b0_.difficulty ORDER BY b0_.difficulty ASC"
]

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