Symfony Profiler

[
  "route" => "app_boardgame_show"
  "route_parameters" => [
    "_route" => "app_boardgame_show"
    "_controller" => "App\Controller\Boardgame\BoardgameController::showBoardgame"
    "slug" => "skyjo-action"
  ]
  "request_uri" => "https://jeux.sifflote.fr/boardgame/g/skyjo-action"
  "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 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, u1_.id AS id_35, u1_.registered_at AS registered_at_36, u1_.last_login_at AS last_login_at_37, u1_.nickname AS nickname_38, u1_.roles AS roles_39, u1_.password AS password_40, u1_.email AS email_41, u1_.is_verified AS is_verified_42, u1_.google_id AS google_id_43, u1_.first_name AS first_name_44, u1_.last_name AS last_name_45, u1_.date_of_birth AS date_of_birth_46, u1_.avatar_filename AS avatar_filename_47, u1_.updated_at AS updated_at_48, u1_.notification_settings AS notification_settings_49, u1_.is_profile_private AS is_profile_private_50, b2_.id AS id_51, b2_.name AS name_52, b3_.id AS id_53, b3_.name AS name_54, b3_.color AS color_55, b3_.text_color AS text_color_56, b4_.id AS id_57, b4_.rating AS rating_58, b4_.comment AS comment_59, b4_.created_at AS created_at_60, b4_.updated_at AS updated_at_61, b5_.id AS id_62, b5_.filename AS filename_63, b5_.original_filename AS original_filename_64, b5_.size AS size_65, b5_.mime_type AS mime_type_66, b5_.title AS title_67, b5_.updated_at AS updated_at_68, b5_.description AS description_69, b5_.uploaded_at AS uploaded_at_70, b6_.id AS id_71, b6_.played_at AS played_at_72, b6_.guest_players AS guest_players_73, b6_.winner_name AS winner_name_74, b6_.results AS results_75, b6_.location AS location_76, b6_.notes AS notes_77, b6_.created_at AS created_at_78, b6_.is_public AS is_public_79, b0_.author_id AS author_id_80, b0_.base_game_id AS base_game_id_81, b0_.main_edition_id AS main_edition_id_82, b2_.category_id AS category_id_83, b2_.main_tag_id AS main_tag_id_84, b4_.boardgame_id AS boardgame_id_85, b4_.author_id AS author_id_86, b5_.boardgame_id AS boardgame_id_87, b5_.uploaded_by_id AS uploaded_by_id_88, b6_.boardgame_id AS boardgame_id_89, b6_.user_id AS user_id_90, b6_.tournament_id AS tournament_id_91 FROM bgg_boardgame b0_ LEFT JOIN users u1_ ON b0_.author_id = u1_.id LEFT JOIN bgg_boardgame_tag b7_ ON b0_.id = b7_.boardgame_id LEFT JOIN bgg_tag b2_ ON b2_.id = b7_.tag_id LEFT JOIN bgg_tag_category b3_ ON b2_.category_id = b3_.id LEFT JOIN bgg_review b4_ ON b0_.id = b4_.boardgame_id LEFT JOIN boardgame_file b5_ ON b0_.id = b5_.boardgame_id LEFT JOIN bgg_play_session b6_ ON b0_.id = b6_.boardgame_id WHERE b0_.slug = ?"
  "params" => [
    1 => "skyjo-action"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(b0_.id) AS sclr_0 FROM bgg_forum_thread b0_ INNER JOIN bgg_boardgame b1_ ON b0_.boardgame_id = b1_.id WHERE b1_.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.game_name AS game_name_5, t0.min_players AS min_players_6, t0.max_players AS max_players_7, t0.play_time AS play_time_8, t0.min_age AS min_age_9, t0.difficulty AS difficulty_10, t0.cover_image_filename AS cover_image_filename_11, t0.release_date AS release_date_12, t0.language AS language_13, t0.slug AS slug_14, t0.score AS score_15, t0.average_rating AS average_rating_16, t0.mise_en_place AS mise_en_place_17, t0.rejouabilite AS rejouabilite_18, t0.interactivite AS interactivite_19, t0.prise_en_main AS prise_en_main_20, t0.thematique AS thematique_21, t0.materiel AS materiel_22, t0.difficulte_description AS difficulte_description_23, t0.mise_en_place_description AS mise_en_place_description_24, t0.rejouabilite_description AS rejouabilite_description_25, t0.interactivite_description AS interactivite_description_26, t0.prise_en_main_description AS prise_en_main_description_27, t0.thematique_description AS thematique_description_28, t0.materiel_description AS materiel_description_29, t0.author_rating AS author_rating_30, t0.author_comment AS author_comment_31, t0.is_standalone_extension AS is_standalone_extension_32, t0.edition_name AS edition_name_33, t0.bgg_id AS bgg_id_34, t0.bgg_rank AS bgg_rank_35, t0.author_id AS author_id_36, t0.base_game_id AS base_game_id_37, t0.main_edition_id AS main_edition_id_38 FROM bgg_boardgame t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "skyjo-action"
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.game_name AS game_name_5, t0.min_players AS min_players_6, t0.max_players AS max_players_7, t0.play_time AS play_time_8, t0.min_age AS min_age_9, t0.difficulty AS difficulty_10, t0.cover_image_filename AS cover_image_filename_11, t0.release_date AS release_date_12, t0.language AS language_13, t0.slug AS slug_14, t0.score AS score_15, t0.average_rating AS average_rating_16, t0.mise_en_place AS mise_en_place_17, t0.rejouabilite AS rejouabilite_18, t0.interactivite AS interactivite_19, t0.prise_en_main AS prise_en_main_20, t0.thematique AS thematique_21, t0.materiel AS materiel_22, t0.difficulte_description AS difficulte_description_23, t0.mise_en_place_description AS mise_en_place_description_24, t0.rejouabilite_description AS rejouabilite_description_25, t0.interactivite_description AS interactivite_description_26, t0.prise_en_main_description AS prise_en_main_description_27, t0.thematique_description AS thematique_description_28, t0.materiel_description AS materiel_description_29, t0.author_rating AS author_rating_30, t0.author_comment AS author_comment_31, t0.is_standalone_extension AS is_standalone_extension_32, t0.edition_name AS edition_name_33, t0.bgg_id AS bgg_id_34, t0.bgg_rank AS bgg_rank_35, t0.author_id AS author_id_36, t0.base_game_id AS base_game_id_37, t0.main_edition_id AS main_edition_id_38 FROM bgg_boardgame t0 WHERE t0.main_edition_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.game_name AS game_name_5, t0.min_players AS min_players_6, t0.max_players AS max_players_7, t0.play_time AS play_time_8, t0.min_age AS min_age_9, t0.difficulty AS difficulty_10, t0.cover_image_filename AS cover_image_filename_11, t0.release_date AS release_date_12, t0.language AS language_13, t0.slug AS slug_14, t0.score AS score_15, t0.average_rating AS average_rating_16, t0.mise_en_place AS mise_en_place_17, t0.rejouabilite AS rejouabilite_18, t0.interactivite AS interactivite_19, t0.prise_en_main AS prise_en_main_20, t0.thematique AS thematique_21, t0.materiel AS materiel_22, t0.difficulte_description AS difficulte_description_23, t0.mise_en_place_description AS mise_en_place_description_24, t0.rejouabilite_description AS rejouabilite_description_25, t0.interactivite_description AS interactivite_description_26, t0.prise_en_main_description AS prise_en_main_description_27, t0.thematique_description AS thematique_description_28, t0.materiel_description AS materiel_description_29, t0.author_rating AS author_rating_30, t0.author_comment AS author_comment_31, t0.is_standalone_extension AS is_standalone_extension_32, t0.edition_name AS edition_name_33, t0.bgg_id AS bgg_id_34, t0.bgg_rank AS bgg_rank_35, t0.author_id AS author_id_36, t0.base_game_id AS base_game_id_37, t0.main_edition_id AS main_edition_id_38 FROM bgg_boardgame t0 WHERE t0.base_game_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.title AS title_4, t0.description AS description_5, t0.uploaded_at AS uploaded_at_6, t0.updated_at AS updated_at_7, t0.boardgame_id AS boardgame_id_8, t0.uploaded_by_id AS uploaded_by_id_9 FROM bgg_boardgame_image t0 WHERE t0.boardgame_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2 FROM bgg_creator t0 INNER JOIN bgg_boardgame_creator ON t0.id = bgg_boardgame_creator.creator_id WHERE bgg_boardgame_creator.boardgame_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2 FROM bgg_illustrator t0 INNER JOIN bgg_boardgame_illustrator ON t0.id = bgg_boardgame_illustrator.illustrator_id WHERE bgg_boardgame_illustrator.boardgame_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2 FROM bgg_publisher t0 INNER JOIN bgg_boardgame_publisher ON t0.id = bgg_boardgame_publisher.publisher_id WHERE bgg_boardgame_publisher.boardgame_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

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