Symfony Profiler

[
  "route" => "app_status"
  "route_parameters" => [
    "_route" => "app_status"
    "_controller" => "App\Controller\AppController::status"
    "_locale" => "fr"
    "placeSlug" => "site-de-grenelle"
  ]
  "request_uri" => "https://dev.boaz-connect.fr/fr/status/site-de-grenelle"
  "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"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "boazdev"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "dev-boazconnect"
    "serverVersion" => "10.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.role AS role_3, u0_.password AS password_4, u0_.firstname AS firstname_5, u0_.lastname AS lastname_6, u0_.position AS position_7, u0_.user AS user_8, u0_.active AS active_9, u0_.phone AS phone_10, u0_.picture AS picture_11, u0_.plain_password AS plain_password_12, u0_.deleted AS deleted_13, u0_.language AS language_14, u0_.type AS type_15, u0_.created_at AS created_at_16, u0_.updated_at AS updated_at_17, u0_.created_by AS created_by_18, u0_.updated_by AS updated_by_19, u0_.function_id AS function_id_20, u0_.company_id AS company_id_21 FROM user u0_ WHERE u0_.email = ? OR u0_.username = ?"
  "params" => [
    1 => "eric@caravanemedia.com"
    2 => "eric@caravanemedia.com"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "provider" => "App\Security\UserProvider"
  "username" => "eric@caravanemedia.com"
]

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

[
  "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" => "Nelmio\CorsBundle\EventListener\CorsListener::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\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" => "App\EventSubscriber\UserLocaleSubscriber::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\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.city AS city_4, t0.country AS country_5, t0.postalcode AS postalcode_6, t0.address AS address_7, t0.active AS active_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.webcam_url AS webcam_url_11, t0.weather_station_id AS weather_station_id_12, t0.water_station_id AS water_station_id_13, t0.opening_hours AS opening_hours_14, t0.max_people AS max_people_15, t0.picture AS picture_16, t0.strymo_station_id AS strymo_station_id_17, t0.jauge_url AS jauge_url_18, t0.preview_code AS preview_code_19, t0.control_code AS control_code_20, t0.link AS link_21, t0.boazcreate AS boazcreate_22, t0.pict3d AS pict3d_23, t0.drive_directory AS drive_directory_24, t0.opening_days AS opening_days_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.created_by AS created_by_28, t0.updated_by AS updated_by_29, t0.client_id AS client_id_30 FROM place t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "site-de-grenelle"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.unit AS unit_4, t0.description AS description_5, t0.category AS category_6, t0.strymo_id AS strymo_id_7, t0.type AS type_8 FROM parameter t0 WHERE t0.slug = ? AND t0.category = ? LIMIT 1"
  "params" => [
    1 => "quality"
    2 => "water"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.description AS description_5, t0.role AS role_6, t0.parent_id AS parent_id_7 FROM taxonomy t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "exploitant"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.value AS value_1, s0_.role AS role_2, s0_.day AS day_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.created_by AS created_by_6, s0_.updated_by AS updated_by_7, s0_.place_id AS place_id_8, s0_.user_id AS user_id_9, s0_.profile_id AS profile_id_10 FROM status s0_ WHERE s0_.updated_at >= ? AND s0_.place_id = ? AND s0_.role = ? ORDER BY s0_.created_at DESC LIMIT 1"
  "params" => [
    1 => "2026-06-17 00:00:00"
    2 => 1
    3 => "ROLE_EXPLOITANT"
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.description AS description_5, t0.role AS role_6, t0.parent_id AS parent_id_7 FROM taxonomy t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "chef-de-bassin"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.value AS value_1, s0_.role AS role_2, s0_.day AS day_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.created_by AS created_by_6, s0_.updated_by AS updated_by_7, s0_.place_id AS place_id_8, s0_.user_id AS user_id_9, s0_.profile_id AS profile_id_10 FROM status s0_ WHERE s0_.updated_at >= ? AND s0_.place_id = ? AND s0_.role = ? ORDER BY s0_.created_at DESC LIMIT 1"
  "params" => [
    1 => "2026-06-17 00:00:00"
    2 => 1
    3 => "ROLE_CHEF_BASSIN"
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.description AS description_5, t0.role AS role_6, t0.parent_id AS parent_id_7 FROM taxonomy t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "client"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.value AS value_1, s0_.role AS role_2, s0_.day AS day_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.created_by AS created_by_6, s0_.updated_by AS updated_by_7, s0_.place_id AS place_id_8, s0_.user_id AS user_id_9, s0_.profile_id AS profile_id_10 FROM status s0_ WHERE s0_.updated_at >= ? AND s0_.place_id = ? AND s0_.role = ? ORDER BY s0_.created_at DESC LIMIT 1"
  "params" => [
    1 => "2026-06-17 00:00:00"
    2 => 1
    3 => "ROLE_CLIENT"
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.value AS value_1, s0_.role AS role_2, s0_.day AS day_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.created_by AS created_by_6, s0_.updated_by AS updated_by_7, s0_.place_id AS place_id_8, s0_.user_id AS user_id_9, s0_.profile_id AS profile_id_10 FROM status s0_ WHERE s0_.updated_at >= ? AND s0_.place_id = ? AND s0_.role = ? ORDER BY s0_.created_at DESC LIMIT 1"
  "params" => [
    1 => "2026-06-17 00:00:00"
    2 => 1
    3 => "ROLE_ADMIN"
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.parameter_id = ? AND m0_.created_at >= ? AND m0_.created_at < ? ORDER BY m0_.updated_at DESC LIMIT 1"
  "params" => [
    1 => 1
    2 => 25
    3 => "2026-06-17 00:00:00"
    4 => "2026-06-18 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.unit AS unit_4, t0.description AS description_5, t0.category AS category_6, t0.strymo_id AS strymo_id_7, t0.type AS type_8 FROM parameter t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "quality"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.parameter_id = ? AND m0_.created_at >= ? AND m0_.created_at < ? ORDER BY m0_.updated_at DESC LIMIT 1"
  "params" => [
    1 => 1
    2 => 25
    3 => "2026-06-17 00:00:00"
    4 => "2026-06-18 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.description AS description_5, t0.role AS role_6, t0.parent_id AS parent_id_7 FROM taxonomy t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "water-quality-report"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.subject AS subject_1, r0_.content AS content_2, r0_.images AS images_3, r0_.date AS date_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.created_by AS created_by_7, r0_.updated_by AS updated_by_8, r0_.event_type_id AS event_type_id_9, r0_.module_id AS module_id_10, r0_.checklist_id AS checklist_id_11 FROM report r0_ INNER JOIN report_place r2_ ON r0_.id = r2_.report_id INNER JOIN place p1_ ON p1_.id = r2_.place_id WHERE p1_.id = ? AND r0_.event_type_id = ? ORDER BY r0_.created_at DESC LIMIT 1"
  "params" => [
    1 => 1
    2 => 27
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.raw AS raw_3, t0.source AS source_4, t0.timestamp AS timestamp_5, t0.forecast AS forecast_6, t0.strymo_id AS strymo_id_7, t0.kind AS kind_8, t0.day AS day_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.place_id AS place_id_12, t0.parameter_id AS parameter_id_13, t0.document_id AS document_id_14, t0.report_id AS report_id_15 FROM metric t0 WHERE t0.report_id = ?"
  "params" => [
    1 => 1014
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.description AS description_5, t0.role AS role_6, t0.parent_id AS parent_id_7 FROM taxonomy t0 INNER JOIN place_taxonomy ON t0.id = place_taxonomy.taxonomy_id WHERE place_taxonomy.place_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo AS logo_4, t0.cover AS cover_5, t0.color AS color_6, t0.active AS active_7, t0.domain AS domain_8, t0.preview_code AS preview_code_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM client t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.role AS role_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.position AS position_8, t0.user AS user_9, t0.active AS active_10, t0.phone AS phone_11, t0.picture AS picture_12, t0.plain_password AS plain_password_13, t0.deleted AS deleted_14, t0.language AS language_15, t0.type AS type_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.created_by AS created_by_19, t0.updated_by AS updated_by_20, t0.function_id AS function_id_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "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" => "Nelmio\CorsBundle\EventListener\CorsListener::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" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]