Symfony Profiler

[
  "route" => "app_public_screen"
  "route_parameters" => [
    "_route" => "app_public_screen"
    "_controller" => "App\Controller\Dashboard\ScreenController::publicScreen"
    "code_activity" => "tac-tic-room"
  ]
  "request_uri" => "https://interface-chalon.1055.fr/ecran/tac-tic-room"
  "method" => "GET"
]

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

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

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

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

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

[
  "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\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" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::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\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerXT3FCHx\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "adminresa_prod"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "resa_1055_chalon_prod"
    "serverVersion" => "10.1.48-MariaDB"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.mention_anniversaire AS mention_anniversaire_4, t0.url_activity AS url_activity_5, t0.temps_limite_resa AS temps_limite_resa_6, t0.jauge_mini AS jauge_mini_7, t0.mention AS mention_8, t0.jauge_maxi AS jauge_maxi_9, t0.temps_activite AS temps_activite_10, t0.presence_avant AS presence_avant_11, t0.espaces_jeu AS espaces_jeu_12, t0.is_creneau_activity AS is_creneau_activity_13, t0.is_tarification_multiple AS is_tarification_multiple_14, t0.heure_ouverture_creneau AS heure_ouverture_creneau_15, t0.heure_fermeture_creneau AS heure_fermeture_creneau_16, t0.temps_creneau AS temps_creneau_17, t0.creneau_obligatoire AS creneau_obligatoire_18, t0.block_room AS block_room_19, t0.is_draft AS is_draft_20, t0.billboard_type AS billboard_type_21, t0.waiting_time AS waiting_time_22, t0.espaces_jeu_reel AS espaces_jeu_reel_23, t0.jauge_maxi_reel AS jauge_maxi_reel_24, t0.temps_creneau_reel AS temps_creneau_reel_25, t0.ignored_creneau AS ignored_creneau_26, t0.temps_activite_joueur AS temps_activite_joueur_27 FROM `activity` t0 WHERE t0.code = ? LIMIT 1"
  "params" => [
    1 => "tac-tic-room"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.from_date AS from_date_3, c0_.to_date AS to_date_4, c0_.priority AS priority_5, c0_.activity_closed AS activity_closed_6 FROM `calendar` c0_ WHERE ((c0_.from_date <= ? AND c0_.to_date >= ?) OR (c0_.from_date <= ? AND c0_.to_date >= ?) OR (c0_.from_date <= ? AND c0_.to_date >= ?) OR (c0_.from_date >= ? AND c0_.to_date <= ?)) AND c0_.type <> ? AND c0_.type <> ? AND c0_.type <> ? AND c0_.activity_closed IS NULL"
  "params" => [
    1 => "2025-09-06 00:00:00"
    2 => "2025-09-06 00:00:00"
    3 => "2025-09-06 23:59:00"
    4 => "2025-09-06 23:59:00"
    5 => "2025-09-06 00:00:00"
    6 => "2025-09-06 23:59:00"
    7 => "2025-09-06 00:00:00"
    8 => "2025-09-06 23:59:00"
    9 => "vacances"
    10 => "veille"
    11 => "feries"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.from_date AS from_date_3, c0_.to_date AS to_date_4, c0_.priority AS priority_5, c0_.activity_closed AS activity_closed_6 FROM `calendar` c0_ WHERE ((c0_.from_date <= ? AND c0_.to_date >= ?) OR (c0_.from_date <= ? AND c0_.to_date >= ?) OR (c0_.from_date <= ? AND c0_.to_date >= ?) OR (c0_.from_date >= ? AND c0_.to_date <= ?)) AND c0_.activity_closed = ?"
  "params" => [
    1 => "2025-09-06 00:00:00"
    2 => "2025-09-06 00:00:00"
    3 => "2025-09-06 23:59:00"
    4 => "2025-09-06 23:59:00"
    5 => "2025-09-06 00:00:00"
    6 => "2025-09-06 23:59:00"
    7 => "2025-09-06 00:00:00"
    8 => "2025-09-06 23:59:00"
    9 => "tac-tic-room"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.designation AS designation_1, b0_.forfait AS forfait_2, b0_.formule AS formule_3, b0_.code_activity AS code_activity_4, b0_.date AS date_5, b0_.creneau AS creneau_6, b0_.nbre_parties AS nbre_parties_7, b0_.quantity AS quantity_8, b0_.pu_ttc AS pu_ttc_9, b0_.taux_TVA AS taux_TVA_10, b0_.total_ht AS total_ht_11, b0_.montant_tva AS montant_tva_12, b0_.total_ttc AS total_ttc_13, b0_.reservation_id AS reservation_id_14 FROM `booked_activity` b0_ INNER JOIN `reservation` r1_ ON (b0_.reservation_id = r1_.id) WHERE r1_.active = 1 AND b0_.date = ? AND b0_.code_activity = ?"
  "params" => [
    1 => "2025-09-06 00:00:00"
    2 => "tac-tic-room"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2, t0.code_activity AS code_activity_3, t0.date AS date_4, t0.creneau AS creneau_5, t0.quantity AS quantity_6, t0.nbre_parties AS nbre_parties_7, t0.id_customer AS id_customer_8, t0.shortname AS shortname_9, t0.deleted AS deleted_10, t0.is_unavailable AS is_unavailable_11 FROM `operator_booking` t0 WHERE t0.code_activity = ? AND t0.date = ? AND t0.deleted IS NULL ORDER BY t0.id ASC"
  "params" => [
    1 => "tac-tic-room"
    2 => "2025-09-06"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::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"
]