Symfony Profiler

[
  "route" => "app_boardgame_index"
  "route_parameters" => [
    "_route" => "app_boardgame_index"
    "_controller" => "App\Controller\Boardgame\BoardgameController::index"
  ]
  "request_uri" => "https://jeux.sifflote.fr/boardgame?search_form%5Billustrators%5D%5B0%5D=4"
  "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_.name AS name_1 FROM bgg_illustrator b0_ WHERE b0_.id IN (?)"
  "params" => [
    1 => "4"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1 FROM bgg_illustrator b0_ WHERE b0_.id IN (?)"
  "params" => [
    1 => "4"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_2 FROM (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_.name AS name_58, b5_.id AS id_59, b5_.name AS name_60, b6_.id AS id_61, b6_.name AS name_62 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_boardgame_creator b8_ ON b0_.id = b8_.boardgame_id LEFT JOIN bgg_creator b4_ ON b4_.id = b8_.creator_id LEFT JOIN bgg_boardgame_illustrator b9_ ON b0_.id = b9_.boardgame_id LEFT JOIN bgg_illustrator b5_ ON b5_.id = b9_.illustrator_id LEFT JOIN bgg_boardgame_publisher b10_ ON b0_.id = b10_.boardgame_id LEFT JOIN bgg_publisher b6_ ON b6_.id = b10_.publisher_id WHERE b5_.id IN (?)) dctrn_result_inner ORDER BY created_at_2 DESC) dctrn_result LIMIT 20"
  "params" => [
    1 => 4
  ]
  "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, 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_.name AS name_58, b5_.id AS id_59, b5_.name AS name_60, b6_.id AS id_61, b6_.name AS name_62, b0_.author_id AS author_id_63, b0_.base_game_id AS base_game_id_64, b0_.main_edition_id AS main_edition_id_65, b2_.category_id AS category_id_66, b2_.main_tag_id AS main_tag_id_67 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_boardgame_creator b8_ ON b0_.id = b8_.boardgame_id LEFT JOIN bgg_creator b4_ ON b4_.id = b8_.creator_id LEFT JOIN bgg_boardgame_illustrator b9_ ON b0_.id = b9_.boardgame_id LEFT JOIN bgg_illustrator b5_ ON b5_.id = b9_.illustrator_id LEFT JOIN bgg_boardgame_publisher b10_ ON b0_.id = b10_.boardgame_id LEFT JOIN bgg_publisher b6_ ON b6_.id = b10_.publisher_id WHERE b5_.id IN (?) AND b0_.id IN (?) ORDER BY b0_.created_at DESC"
  "params" => [
    1 => 4
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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_.name AS name_58, b5_.id AS id_59, b5_.name AS name_60, b6_.id AS id_61, b6_.name AS name_62 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_boardgame_creator b8_ ON b0_.id = b8_.boardgame_id LEFT JOIN bgg_creator b4_ ON b4_.id = b8_.creator_id LEFT JOIN bgg_boardgame_illustrator b9_ ON b0_.id = b9_.boardgame_id LEFT JOIN bgg_illustrator b5_ ON b5_.id = b9_.illustrator_id LEFT JOIN bgg_boardgame_publisher b10_ ON b0_.id = b10_.boardgame_id LEFT JOIN bgg_publisher b6_ ON b6_.id = b10_.publisher_id WHERE b5_.id IN (?) ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1 FROM bgg_creator b0_"
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1 FROM bgg_illustrator b0_"
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1 FROM bgg_publisher b0_"
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.category_id AS category_id_2, b0_.main_tag_id AS main_tag_id_3 FROM bgg_tag b0_"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.boardgame_id AS boardgame_id_6, t0.author_id AS author_id_7 FROM bgg_review t0 WHERE t0.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"
]