Symfony Profiler

[
  "route" => "app_hebergements_index"
  "route_parameters" => [
    "_route" => "app_hebergements_index"
    "page" => "8"
    "nbre" => "100"
    "_controller" => "App\Controller\HebergementsController::index"
  ]
  "request_uri" => "https://bestmarketbusiness.com/hebergements/home/8"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\UsersAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\UsersAuthenticator"
]

[
  "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\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.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\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "bestmarketbusiness"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.page AS page_2, t0.element AS element_3, t0.visitor_identity AS visitor_identity_4, t0.id_element AS id_element_5, t0.id_session AS id_session_6, t0.created_at AS created_at_7, t0.users_id AS users_id_8 FROM statistiques t0 WHERE t0.page = ?"
  "params" => [
    1 => "DETAIL_HEBERGEMENT"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "INSERT INTO statistiques (page, element, visitor_identity, id_element, id_session, created_at, users_id) VALUES (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "ACCUEIL_HEBERGEMENTS"
    2 => "PAGE_HEBERGEMENTS_INDEX"
    3 => "INCONNU"
    4 => null
    5 => null
    6 => "2025-06-21 11:29:06"
    7 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.page AS page_2, t0.element AS element_3, t0.visitor_identity AS visitor_identity_4, t0.id_element AS id_element_5, t0.id_session AS id_session_6, t0.created_at AS created_at_7, t0.users_id AS users_id_8 FROM statistiques t0 WHERE t0.page = ?"
  "params" => [
    1 => "DETAIL_HEBERGEMENT"
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.city AS city_4, t0.country AS country_5, t0.slug AS slug_6, t0.image_file_name AS image_file_name_7, t0.image_file_others AS image_file_others_8, t0.banner_autorisation AS banner_autorisation_9, t0.home_autorisation AS home_autorisation_10, t0.publicity_autorisation AS publicity_autorisation_11, t0.site_web AS site_web_12, t0.media_social1 AS media_social1_13, t0.media_social2 AS media_social2_14, t0.media_social3 AS media_social3_15, t0.media_social4 AS media_social4_16, t0.media_social5 AS media_social5_17, t0.created_at AS created_at_18, t0.users_id AS users_id_19, t0.categorieshebergements_id AS categorieshebergements_id_20 FROM hebergements t0 ORDER BY t0.created_at DESC LIMIT 100 OFFSET 700"
]

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