Symfony Profiler

[
  "route" => "api_app_index"
  "route_parameters" => [
    "_route" => "api_app_index"
    "_controller" => "App\Controller\Api\AppController::index"
  ]
  "request_uri" => "https://fsmp.pro-soft.fr/api/app"
  "method" => "GET"
]

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

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

[
  "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 {#643
    -user: Symfony\Component\Security\Core\User\InMemoryUser {#653 …}
    -roleNames: [
      "ROLE_API"
    ]
    -attributes: []
    -firewallName: "api"
  }
  "authenticator" => "App\Security\ApiKeyAuthenticator"
]

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

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

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "fsmpsymfony"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "fsmpbdd"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_5, t0.uuid AS uuid_6, t0.id_apl AS id_apl_7, t0.started_at AS started_at_8, t0.updated_at AS updated_at_9, t0.close_at AS close_at_10, t0.status AS status_11, t0.current_step AS current_step_12, t0.title AS title_13, t0.last_name AS last_name_14, t0.first_name AS first_name_15, t0.nationality AS nationality_16, t0.nationality2 AS nationality2_17, t0.birthdate AS birthdate_18, t0.gender AS gender_19, t0.address AS address_20, t0.zipcode AS zipcode_21, t0.city AS city_22, t0.country AS country_23, t0.website AS website_24, t0.synchro AS synchro_25, t0.user_id AS user_id_26, t0.type, t1.knowledge_question AS knowledge_question_27, t1.current_studies AS current_studies_28, t1.current_institut AS current_institut_29, t1.pursuit_studies AS pursuit_studies_30, t1.grades AS grades_31, t1.recommendation_emails AS recommendation_emails_32, t1.master_type_id AS master_type_id_33, t1.master_theme_id AS master_theme_id_34, t1.master_spe1_id AS master_spe1_id_35, t1.master_spe2_id AS master_spe2_id_36, t1.master_spe3_id AS master_spe3_id_37, t1.knownfrom_id AS knownfrom_id_38, t2.project AS project_39, t2.recommendation_emails AS recommendation_emails_40, t2.duration AS duration_41, t2.duration2 AS duration2_42, t2.duration_comment AS duration_comment_43, t2.contact AS contact_44, t2.labo_id AS labo_id_45, t2.mscmain_id AS mscmain_id_46, t2.mscsec1_id AS mscsec1_id_47, t2.mscsec2_id AS mscsec2_id_48, t2.mscsec3_id AS mscsec3_id_49, t3.duration AS duration_50, t3.correspondent AS correspondent_51, t3.project AS project_52, t3.thesis_title AS thesis_title_53, t3.thesis_advisor AS thesis_advisor_54, t3.thesis_date AS thesis_date_55, t3.thesis_institution AS thesis_institution_56, t3.recommendation_emails AS recommendation_emails_57, t3.labo_id AS labo_id_58, t3.mscmain_id AS mscmain_id_59, t3.mscsec1_id AS mscsec1_id_60, t3.mscsec2_id AS mscsec2_id_61, t3.mscsec3_id AS mscsec3_id_62, t3.knownfrom_id AS knownfrom_id_63, t4.request_type AS request_type_64, t4.applicant_research_topic AS applicant_research_topic_65, t4.stay_start_date AS stay_start_date_66, t4.stay_end_date AS stay_end_date_67, t4.stay_period AS stay_period_68, t4.stay_duration AS stay_duration_69, t4.carbon_footprint AS carbon_footprint_70, t4.guest_last_name AS guest_last_name_71, t4.guest_first_name AS guest_first_name_72, t4.guest_university AS guest_university_73, t4.guest_research_topic AS guest_research_topic_74, t4.guest_email AS guest_email_75, t4.thesis_director_last_name AS thesis_director_last_name_76, t4.thesis_director_email AS thesis_director_email_77, t4.host_last_name AS host_last_name_78, t4.host_first_name AS host_first_name_79, t4.host_laboratory AS host_laboratory_80, t4.host_university AS host_university_81, t4.host_country AS host_country_82, t4.host_email AS host_email_83, t4.request_description AS request_description_84, t4.applicant_laboratory_id AS applicant_laboratory_id_85, t4.applicant_university_id AS applicant_university_id_86 FROM application t0 LEFT JOIN application_master t1 ON t0.id = t1.id LEFT JOIN application_chair t2 ON t0.id = t2.id LEFT JOIN application_post_doc t3 ON t0.id = t3.id LEFT JOIN application_funding t4 ON t0.id = t4.id WHERE t0.status = ? AND t0.synchro = ?"
  "params" => [
    1 => "COMPLETED"
    2 => 0
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

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