Symfony Profiler

[
  "route" => "app_dashboard"
  "route_parameters" => [
    "_route" => "app_dashboard"
    "_controller" => "App\Controller\Admin\AdminController::index"
  ]
  "request_uri" => "http://lcformation.vizualee.fr/"
  "method" => "GET"
]

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

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

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

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

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

[
  "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\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\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Container4nswY9l\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "host" => "yg5u7.ftp.infomaniak.com"
    "port" => 3306
    "user" => "yg5u7_lcforma"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "yg5u7_lcformation"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0_.training_name AS training_name_0, SUM(i1_.effective) AS sclr_1 FROM training t0_ LEFT JOIN intern_training i2_ ON t0_.id = i2_.training_id LEFT JOIN intern i1_ ON i1_.id = i2_.intern_id GROUP BY t0_.id"
]

[
  "sql" => "SELECT f0_.origin_of_financing AS origin_of_financing_0, SUM(i1_.effective) AS sclr_1 FROM funding f0_ LEFT JOIN intern_funding i2_ ON f0_.id = i2_.funding_id LEFT JOIN intern i1_ ON i1_.id = i2_.intern_id GROUP BY f0_.id"
]

[
  "sql" => "SELECT l0_.education_level AS education_level_0, SUM(i1_.effective) AS sclr_1 FROM levels_education l0_ LEFT JOIN intern i1_ ON l0_.id = i1_.education_level_id GROUP BY l0_.id"
]

[
  "sql" => "SELECT p0_.qualification AS qualification_0, SUM(i1_.effective) AS sclr_1 FROM professional_qualification p0_ LEFT JOIN intern_professional_qualification i2_ ON p0_.id = i2_.professional_qualification_id LEFT JOIN intern i1_ ON i1_.id = i2_.intern_id GROUP BY p0_.id"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.city AS city_5, t0.zip_code AS zip_code_6, t0.phone AS phone_7, t0.mail AS mail_8, t0.family_situation AS family_situation_9, t0.last_employed AS last_employed_10, t0.seniority AS seniority_11, t0.sector_of_employment AS sector_of_employment_12, t0.mission AS mission_13, t0.strong_point_skill AS strong_point_skill_14, t0.other_job_held AS other_job_held_15, t0.cost_of_training AS cost_of_training_16, t0.commentary AS commentary_17, t0.created_at AS created_at_18, t0.effective AS effective_19, t0.time_formation AS time_formation_20, t0.last_degree AS last_degree_21, t0.type_of_intern AS type_of_intern_22, t0.general_objectif_of_the_services AS general_objectif_of_the_services_23, t0.contracted_activity_of_the_organization AS contracted_activity_of_the_organization_24, t0.started_at AS started_at_25, t0.level_certification AS level_certification_26, t0.education_level_id AS education_level_id_27, t0.training_site_id AS training_site_id_28 FROM intern t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.turnover_of_month AS turnover_of_month_2, t0.current_turnover AS current_turnover_3, t0.turnover_year_nminus_one AS turnover_year_nminus_one_4, t0.average_year AS average_year_5, t0.achievment_nminus_one_percentage AS achievment_nminus_one_percentage_6 FROM economic_balance_sheet t0"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::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"
]