Symfony Profiler

[
  "route" => "_api_/observations{._format}_get_collection"
  "route_parameters" => [
    "_route" => "_api_/observations{._format}_get_collection"
    "_controller" => "api_platform.symfony.main_controller"
    "_format" => null
    "_stateless" => true
    "_api_resource_class" => "App\Entity\Observations\Observation"
    "_api_operation_name" => "_api_/observations{._format}_get_collection"
  ]
  "request_uri" => "https://proviter.fr/api/observations?lastSyncDate=2025-07-02T17%3A01%3A34.358Z&page=23&user=1"
  "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 o0_.id) AS sclr_0 FROM observation o0_ INNER JOIN property p1_ ON o0_.property_id = p1_.id LEFT JOIN visite v2_ ON o0_.visite_id = v2_.id LEFT JOIN preconisation_actualisee_observation p4_ ON o0_.id = p4_.observation_id LEFT JOIN preconisation_actualisee p3_ ON p3_.id = p4_.preconisation_actualisee_id WHERE o0_.last_update > ? AND o0_.property_id IN (SELECT p5_.id FROM property p5_ INNER JOIN user_property u7_ ON p5_.id = u7_.property_id INNER JOIN `user` u6_ ON u6_.id = u7_.user_id WHERE u6_.id = ?)"
  "params" => [
    1 => "2025-06-22 17:01:34"
    2 => "1"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT o0_.id AS id_0, o0_.last_update AS last_update_1 FROM observation o0_ INNER JOIN property p1_ ON o0_.property_id = p1_.id LEFT JOIN visite v2_ ON o0_.visite_id = v2_.id LEFT JOIN preconisation_actualisee_observation p4_ ON o0_.id = p4_.observation_id LEFT JOIN preconisation_actualisee p3_ ON p3_.id = p4_.preconisation_actualisee_id WHERE o0_.last_update > ? AND o0_.property_id IN (SELECT p5_.id FROM property p5_ INNER JOIN user_property u7_ ON p5_.id = u7_.property_id INNER JOIN `user` u6_ ON u6_.id = u7_.user_id WHERE u6_.id = ?) ORDER BY o0_.last_update DESC LIMIT 30 OFFSET 660"
  "params" => [
    1 => "2025-06-22 17:01:34"
    2 => "1"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.secteur AS secteur_1, o0_.ilot AS ilot_2, o0_.parcelle AS parcelle_3, o0_.stade_r_1 AS stade_r_1_4, o0_.stade_r_2 AS stade_r_2_5, o0_.mi_f AS mi_f_6, o0_.mi_g AS mi_g_7, o0_.br_f AS br_f_8, o0_.br_g AS br_g_9, o0_.oi_f AS oi_f_10, o0_.oi_g AS oi_g_11, o0_.pg_f AS pg_f_12, o0_.pg_g AS pg_g_13, o0_.maladie_bois AS maladie_bois_14, o0_.note_mdb AS note_mdb_15, o0_.cic_v AS cic_v_16, o0_.cic_fd AS cic_fd_17, o0_.vdg_glom AS vdg_glom_18, o0_.vdg_perfos AS vdg_perfos_19, o0_.carences AS carences_20, o0_.note_carence AS note_carence_21, o0_.commentaire AS commentaire_22, o0_.notation AS notation_23, o0_.created_by AS created_by_24, o0_.last_update AS last_update_25, o0_.last_updater AS last_updater_26, o0_.vdg_ponte AS vdg_ponte_27, o0_.uuid AS uuid_28, o0_.client_uuid AS client_uuid_29, p1_.id AS id_30, p1_.property_name AS property_name_31, p1_.commune AS commune_32, p1_.surface_totale AS surface_totale_33, p1_.contract_name AS contract_name_34, p1_.adresse_1 AS adresse_1_35, p1_.adresse_2 AS adresse_2_36, p1_.code_postal AS code_postal_37, v2_.id AS id_38, v2_.date_visite AS date_visite_39, v2_.uuid AS uuid_40, v2_.client_uuid AS client_uuid_41, v2_.commentaire AS commentaire_42, p3_.id AS id_43, p3_.date_preco AS date_preco_44, p3_.num_trt AS num_trt_45, p3_.type_traitement AS type_traitement_46, p3_.categorie_surface AS categorie_surface_47, p3_.stade_pheno AS stade_pheno_48, p3_.contexte_sanitaire AS contexte_sanitaire_49, p3_.complement_information AS complement_information_50, p3_.surface AS surface_51, p3_.operation_culturale AS operation_culturale_52, p3_.delai AS delai_53, p3_.uuid AS uuid_54, p3_.client_uuid AS client_uuid_55, p3_.created_by AS created_by_56, p3_.last_update AS last_update_57, p3_.last_updater AS last_updater_58, p3_.mail_body AS mail_body_59, o0_.property_id AS property_id_60, o0_.visite_id AS visite_id_61, p1_.departement_id AS departement_id_62, v2_.property_id AS property_id_63, p3_.preco_rapide_id AS preco_rapide_id_64, p3_.property_id AS property_id_65, p3_.regroupement_propriete_id AS regroupement_propriete_id_66, p3_.preconisation_saison_id AS preconisation_saison_id_67, p3_.visite_id AS visite_id_68 FROM observation o0_ INNER JOIN property p1_ ON o0_.property_id = p1_.id LEFT JOIN visite v2_ ON o0_.visite_id = v2_.id LEFT JOIN preconisation_actualisee_observation p4_ ON o0_.id = p4_.observation_id LEFT JOIN preconisation_actualisee p3_ ON p3_.id = p4_.preconisation_actualisee_id WHERE o0_.last_update > ? AND o0_.property_id IN (SELECT p5_.id FROM property p5_ INNER JOIN user_property u7_ ON p5_.id = u7_.property_id INNER JOIN `user` u6_ ON u6_.id = u7_.user_id WHERE u6_.id = ?) AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.last_update DESC"
  "params" => [
    1 => "2025-06-22 17:01:34"
    2 => "1"
    3 => 69425
    4 => 69163
    5 => 69179
    6 => 69410
    7 => 69488
    8 => 69255
    9 => 69199
    10 => 69215
    11 => 69231
    12 => 69497
    13 => 69426
    14 => 69164
    15 => 69180
    16 => 69411
    17 => 69489
    18 => 69257
    19 => 69200
    20 => 69216
    21 => 69232
    22 => 69498
    23 => 69427
    24 => 69165
    25 => 69181
    26 => 69412
    27 => 69490
    28 => 69259
    29 => 69201
    30 => 69217
    31 => 69233
    32 => 69499
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
    26 => 1
    27 => 1
    28 => 1
    29 => 1
    30 => 1
    31 => 1
    32 => 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"
]