Symfony Profiler

[
  "route" => "_api_/preconisation_dosagess{._format}_get_collection"
  "route_parameters" => [
    "_route" => "_api_/preconisation_dosagess{._format}_get_collection"
    "_controller" => "api_platform.symfony.main_controller"
    "_format" => null
    "_stateless" => true
    "_api_resource_class" => "App\Entity\PreconisationActualisee\PreconisationDosages"
    "_api_operation_name" => "_api_/preconisation_dosagess{._format}_get_collection"
  ]
  "request_uri" => "https://proviter.fr/api/preconisation_dosagess?preconisation=77cd386c-6bab-4768-a6d0-ca6edd5c422d"
  "method" => "GET"
]

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\PropertySubscriber::adjustPropertyQuery"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener::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" => "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurity"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurityPostDenormalize"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\Bundle\EventListener\SwaggerUiListener::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\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "f78pd.myd.infomaniak.com"
    "port" => 3306
    "user" => "f78pd_pdktr_22"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "f78pd_pdktr_23_preprod"
    "serverVersion" => "5.7.40"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT count(DISTINCT p0_.id) AS sclr_0 FROM preconisation_dosages p0_ INNER JOIN preconisation_actualisee p1_ ON p0_.preco_flash_id = p1_.id LEFT JOIN preconisation_realisee p2_ ON p0_.id = p2_.preconisation_id WHERE p0_.preco_flash_id IN (SELECT p3_.id FROM preconisation_actualisee p3_ WHERE p3_.client_uuid = ?)"
  "params" => [
    1 => "77cd386c-6bab-4768-a6d0-ca6edd5c422d"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM preconisation_dosages p0_ INNER JOIN preconisation_actualisee p1_ ON p0_.preco_flash_id = p1_.id LEFT JOIN preconisation_realisee p2_ ON p0_.id = p2_.preconisation_id WHERE p0_.preco_flash_id IN (SELECT p3_.id FROM preconisation_actualisee p3_ WHERE p3_.client_uuid = ?) ORDER BY p0_.id ASC LIMIT 30"
  "params" => [
    1 => "77cd386c-6bab-4768-a6d0-ca6edd5c422d"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.dose_preco AS dose_preco_1, p0_.usage_id AS usage_id_2, p0_.uuid AS uuid_3, p0_.client_uuid AS client_uuid_4, p1_.id AS id_5, p1_.date_preco AS date_preco_6, p1_.num_trt AS num_trt_7, p1_.type_traitement AS type_traitement_8, p1_.categorie_surface AS categorie_surface_9, p1_.stade_pheno AS stade_pheno_10, p1_.contexte_sanitaire AS contexte_sanitaire_11, p1_.complement_information AS complement_information_12, p1_.surface AS surface_13, p1_.operation_culturale AS operation_culturale_14, p1_.delai AS delai_15, p1_.uuid AS uuid_16, p1_.client_uuid AS client_uuid_17, p1_.created_by AS created_by_18, p1_.last_update AS last_update_19, p1_.last_updater AS last_updater_20, p1_.mail_body AS mail_body_21, p2_.id AS id_22, p2_.date_realise AS date_realise_23, p2_.usage_produit_reference AS usage_produit_reference_24, p2_.produit_different AS produit_different_25, p2_.produit_different_nom AS produit_different_nom_26, p2_.quantite AS quantite_27, p2_.lot AS lot_28, p2_.parcelles_selection AS parcelles_selection_29, p2_.critere_parcelle AS critere_parcelle_30, p2_.commentaire AS commentaire_31, p2_.surface_traitee AS surface_traitee_32, p0_.preco_flash_id AS preco_flash_id_33, p1_.preco_rapide_id AS preco_rapide_id_34, p1_.property_id AS property_id_35, p1_.regroupement_propriete_id AS regroupement_propriete_id_36, p1_.preconisation_saison_id AS preconisation_saison_id_37, p1_.visite_id AS visite_id_38, p2_.preconisation_id AS preconisation_id_39 FROM preconisation_dosages p0_ INNER JOIN preconisation_actualisee p1_ ON p0_.preco_flash_id = p1_.id LEFT JOIN preconisation_realisee p2_ ON p0_.id = p2_.preconisation_id WHERE p0_.preco_flash_id IN (SELECT p3_.id FROM preconisation_actualisee p3_ WHERE p3_.client_uuid = ?) AND p0_.id IN (?, ?, ?) ORDER BY p0_.id ASC"
  "params" => [
    1 => "77cd386c-6bab-4768-a6d0-ca6edd5c422d"
    2 => 15254
    3 => 15255
    4 => 15272
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
    4 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "ApiPlatform\Hydra\EventListener\AddLinkHeaderListener::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" => "ApiPlatform\HttpCache\EventListener\AddHeadersListener::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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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