Symfony Profiler

[
  "route" => "app_notification_unread"
  "route_parameters" => [
    "_route" => "app_notification_unread"
    "_controller" => "App\Controller\NotificationController::unread"
  ]
  "request_uri" => "https://app.lokapro.pro/notifications/unread?limit=5"
  "method" => "GET"
]

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

[
  "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\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "lokaprhdatabase.mysql.db"
    "port" => 3306
    "user" => "lokaprhdatabase"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "lokaprhdatabase"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.mobile_phone AS mobile_phone_8, t0.address AS address_9, t0.city AS city_10, t0.postal_code AS postal_code_11, t0.birth_date AS birth_date_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.last_login_at AS last_login_at_15, t0.last_inactivity_alert_sent_at AS last_inactivity_alert_sent_at_16, t0.first_login_token AS first_login_token_17, t0.first_login_token_expires_at AS first_login_token_expires_at_18, t0.reset_password_code AS reset_password_code_19, t0.reset_password_code_expires_at AS reset_password_code_expires_at_20, t0.consents AS consents_21, t0.organization_id AS organization_id_22, t0.company_id AS company_id_23, t24.id AS id_25, t24.first_name AS first_name_26, t24.last_name AS last_name_27, t24.email AS email_28, t24.phone AS phone_29, t24.birth_date AS birth_date_30, t24.address AS address_31, t24.city AS city_32, t24.postal_code AS postal_code_33, t24.profession AS profession_34, t24.monthly_income AS monthly_income_35, t24.emergency_contact_name AS emergency_contact_name_36, t24.emergency_contact_phone AS emergency_contact_phone_37, t24.notes AS notes_38, t24.created_at AS created_at_39, t24.updated_at AS updated_at_40, t24.is_demo AS is_demo_41, t24.status AS status_42, t24.organization_id AS organization_id_43, t24.company_id AS company_id_44, t24.user_id AS user_id_45, t46.id AS id_47, t46.first_name AS first_name_48, t46.last_name AS last_name_49, t46.email AS email_50, t46.phone AS phone_51, t46.address AS address_52, t46.city AS city_53, t46.postal_code AS postal_code_54, t46.owner_type AS owner_type_55, t46.siret AS siret_56, t46.bank_account AS bank_account_57, t46.commission_rate AS commission_rate_58, t46.notes AS notes_59, t46.created_at AS created_at_60, t46.updated_at AS updated_at_61, t46.organization_id AS organization_id_62, t46.company_id AS company_id_63, t46.user_id AS user_id_64, t65.id AS id_66, t65.first_name AS first_name_67, t65.last_name AS last_name_68, t65.email AS email_69, t65.phone AS phone_70, t65.address AS address_71, t65.city AS city_72, t65.postal_code AS postal_code_73, t65.commune AS commune_74, t65.neighborhood AS neighborhood_75, t65.lot_number AS lot_number_76, t65.ownership_percentage AS ownership_percentage_77, t65.e_releve_enabled AS e_releve_enabled_78, t65.e_reco_enabled AS e_reco_enabled_79, t65.auto_debit_enabled AS auto_debit_enabled_80, t65.iban AS iban_81, t65.bic AS bic_82, t65.notes AS notes_83, t65.created_at AS created_at_84, t65.updated_at AS updated_at_85, t65.is_demo AS is_demo_86, t65.status AS status_87, t65.departure_date AS departure_date_88, t65.is_administrator AS is_administrator_89, t65.organization_id AS organization_id_90, t65.company_id AS company_id_91, t65.syndic_id AS syndic_id_92, t65.user_id AS user_id_93 FROM `user` t0 LEFT JOIN tenant t24 ON t24.user_id = t0.id LEFT JOIN owner t46 ON t46.user_id = t0.id LEFT JOIN co_owner t65 ON t65.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 60
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "kouamepaularnaud@icloud.fr"
]

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

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

[
  "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\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" => "App\EventListener\FeatureAccessListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\DemoEnvironmentListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\EnvironmentListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\OrganizationFilterSubscriber::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" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "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" => "ContainerU9Jn1Ws\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.message AS message_2, n0_.type AS type_3, n0_.icon AS icon_4, n0_.is_read AS is_read_5, n0_.read_at AS read_at_6, n0_.route AS route_7, n0_.route_params AS route_params_8, n0_.data AS data_9, n0_.created_at AS created_at_10, n0_.user_id AS user_id_11, n0_.organization_id AS organization_id_12, n0_.company_id AS company_id_13 FROM notification n0_ WHERE n0_.user_id = ? AND n0_.is_read = ? ORDER BY n0_.created_at DESC LIMIT 5"
  "params" => [
    1 => 60
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 5
  ]
]

[
  "sql" => "SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.user_id = ? AND n0_.is_read = ?"
  "params" => [
    1 => 60
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 5
  ]
]

[
  "key" => "_security_main"
]

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

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