POST https://proviter.fr/api/sync_preconisation

Query Metrics

7 Database Queries
7 Different statements
17.04 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.05 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.reset_token AS reset_token_5, t0.is_active AS is_active_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.function AS function_9, t0.type_certiphyto AS type_certiphyto_10, t0.validite_certiphyto AS validite_certiphyto_11, t0.mobile AS mobile_12, t0.phone AS phone_13, t0.num_certiphyto AS num_certiphyto_14, t0.stades_pheno AS stades_pheno_15, t0.p_tordeuses AS p_tordeuses_16, t0.movida AS movida_17, t0.grp_30k AS grp_30k_18, t0.is_admin AS is_admin_19 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5
]
2 0.70 ms
SELECT t0.id AS id_1, t0.property_name AS property_name_2, t0.commune AS commune_3, t0.surface_totale AS surface_totale_4, t0.contract_name AS contract_name_5, t0.adresse_1 AS adresse_1_6, t0.adresse_2 AS adresse_2_7, t0.code_postal AS code_postal_8, t0.departement_id AS departement_id_9, t0.main_consultant_id AS main_consultant_id_10 FROM property t0 WHERE t0.id = ?
Parameters:
[
  281
]
3 13.07 ms
SELECT t0.id AS id_1, t0.date_visite AS date_visite_2, t0.uuid AS uuid_3, t0.client_uuid AS client_uuid_4, t0.commentaire AS commentaire_5, t0.main_consultant AS main_consultant_6, t0.property_id AS property_id_7 FROM visite t0 WHERE t0.client_uuid = ? LIMIT 1
Parameters:
[
  "8d88a3fe-0825-4a9f-aee1-f463f846d7b5"
]
4 0.79 ms
SELECT t0.id AS id_1, t0.date_preco AS date_preco_2, t0.num_trt AS num_trt_3, t0.type_traitement AS type_traitement_4, t0.categorie_surface AS categorie_surface_5, t0.stade_pheno AS stade_pheno_6, t0.contexte_sanitaire AS contexte_sanitaire_7, t0.complement_information AS complement_information_8, t0.surface AS surface_9, t0.operation_culturale AS operation_culturale_10, t0.delai AS delai_11, t0.uuid AS uuid_12, t0.client_uuid AS client_uuid_13, t0.created_by AS created_by_14, t0.last_update AS last_update_15, t0.last_updater AS last_updater_16, t0.mail_body AS mail_body_17, t0.preco_rapide_id AS preco_rapide_id_18, t0.property_id AS property_id_19, t0.regroupement_propriete_id AS regroupement_propriete_id_20, t0.preconisation_saison_id AS preconisation_saison_id_21, t0.visite_id AS visite_id_22 FROM preconisation_actualisee t0 WHERE t0.client_uuid = ? AND t0.visite_id = ? AND t0.property_id = ? LIMIT 1
Parameters:
[
  "80bc37dc-d7db-4393-be73-3ee2a8a256eb"
  9855
  281
]
5 0.28 ms
"START TRANSACTION"
Parameters:
[]
6 0.56 ms
UPDATE preconisation_actualisee SET complement_information = ?, last_update = ? WHERE id = ?
Parameters:
[
  "La fermeture de grappe est atteinte sur la majorité des parcelles.<div>On remarque quelques traces d'échaudage, mais sans gravité pour le moment.</div><div>Le vignoble reste dans un état sanitaire de très haut niveau, de rares perforations de tordeuses sont observées.</div><div><br></div><div>Il faudra prévoir un renouvellement de la couverture phytosanitaire avant des pluies significatives annoncées (sup. à 10 mm) ou des périodes d'humectations prolongées, avec une spécialité cuprique sur la base de 400g cu métal/ha).</div>"
  "2026-07-01"
  8352
]
7 0.58 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.