Symfony Profiler

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "careconceptn2a_adm"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "careconceptn2a_db"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?"
  "params" => [
    1 => "maintenance_mode"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?"
  "params" => [
    1 => "maintenance_resume_at"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "route" => "my_prospections"
  "route_parameters" => [
    "_route" => "my_prospections"
    "_controller" => "App\Controller\ProspectionController::myProspections"
  ]
  "request_uri" => "https://careconcept-n2a.myn2a.online/mes-prospections"
  "method" => "GET"
]

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

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

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

[
  "sql" => "SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.uuid = ?"
  "params" => [
    1 => "b3e2a1b1-0824-4ce3-a1f1-12f7ae0a81dd"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "r_dossou@n2a.online"
]

[
  "sql" => "SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.email = ? LIMIT 1"
  "params" => [
    1 => "r_dossou@n2a.online"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CsrfProtectionListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::preCheckCredentials"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "event" => "security.authentication.success"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::postCheckCredentials"
]

[
  "token" => Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken {#1155
    -user: App\Entity\Users {#1145 …}
    -roleNames: [
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "main"
  }
  "authenticator" => "App\Security\MagmaAuthenticator"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\SessionStrategyListener::onSuccessfulLogin"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\PasswordMigratingListener::onLoginSuccess"
]

[
  "authenticator" => "App\Security\MagmaAuthenticator"
]

[
  "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" => "App\EventSubscriber\MaintenanceSubscriber::onKernelRequest"
]

[
  "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" => "App\EventSubscriber\DoctrineEnseigneSubscriber::onKernelRequest"
]

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

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

[
  "http_code" => 200
  "url" => "https://business-n2a.myn2a.online/api/user/534/collaborations/all"
  "total_time" => 0.383357
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.type_tiers AS type_tiers_1, p0_.enseigne_prospect AS enseigne_prospect_2, p0_.nom AS nom_3, p0_.prenom AS prenom_4, p0_.email AS email_5, p0_.phone AS phone_6, p0_.created_at AS created_at_7, p0_.status AS status_8, p0_.score AS score_9, p0_.pipeline_status AS pipeline_status_10, AsBinary(p0_.location) AS location_11, p0_.latitude AS latitude_12, p0_.longitude AS longitude_13, p0_.adresse_prospect AS adresse_prospect_14, p0_.code_enseigne AS code_enseigne_15, p0_.code_agent AS code_agent_16, p0_.ifu_prospect AS ifu_prospect_17, p0_.civilite_prospect AS civilite_prospect_18, p0_.agent_nom AS agent_nom_19, p0_.agent_prenom AS agent_prenom_20, p0_.agent_photo AS agent_photo_21, p0_.tva_assuj AS tva_assuj_22, p0_.code_prospect AS code_prospect_23, p0_.barcode AS barcode_24, p0_.selected_pack_id AS selected_pack_id_25, p0_.estimated_revenue AS estimated_revenue_26, p0_.note_publique AS note_publique_27, p0_.note_privee AS note_privee_28, p0_.is_converted AS is_converted_29, p0_.conversion_pack_id AS conversion_pack_id_30, p0_.converted_at AS converted_at_31, p0_.agent_uuid AS agent_uuid_32, p0_.enseigne_id AS enseigne_id_33, p0_.campaign_id AS campaign_id_34, p0_.temperature_id AS temperature_id_35, p0_.converted_by_id AS converted_by_id_36 FROM prospections p0_ WHERE (p0_.agent_uuid = ?) AND (p0_.code_enseigne = 'YLWE') ORDER BY p0_.created_at DESC"
  "params" => [
    1 => "b3e2a1b1-0824-4ce3-a1f1-12f7ae0a81dd"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.score_total AS score_total_1, p0_.created_at AS created_at_2, p0_.prospection_id AS prospection_id_3, p0_.questionnaire_id AS questionnaire_id_4, p0_.commercial_uuid AS commercial_uuid_5 FROM prospect_discovery p0_ INNER JOIN prospections p1_ ON p0_.prospection_id = p1_.id AND (p1_.code_enseigne = 'YLWE') WHERE p1_.agent_uuid = ? ORDER BY p0_.created_at DESC"
  "params" => [
    1 => "b3e2a1b1-0824-4ce3-a1f1-12f7ae0a81dd"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "http_code" => 200
  "url" => "https://business-n2a.myn2a.online/api/packs"
  "total_time" => 0.303461
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.weight AS weight_3, t0.color AS color_4, t0.description AS description_5 FROM temperature t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.weight AS weight_3, t0.color AS color_4, t0.description AS description_5 FROM temperature t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.weight AS weight_3, t0.color AS color_4, t0.description AS description_5 FROM temperature t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.weight AS weight_3, t0.color AS color_4, t0.description AS description_5 FROM temperature t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

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