Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

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 = ?

[
  118
]

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 = ?

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 = 118;

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 = ?

[
  248
]

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 = ?

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 = 248;

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

[
  "69853e7a-9b60-4b8a-af1a-bdd0ae1c8072"
]

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

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 = '69853e7a-9b60-4b8a-af1a-bdd0ae1c8072' LIMIT 1;

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

[
  "630f602b-a71e-4a7e-8a4e-3b77360432e8"
  9700
  248
]

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

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 = '630f602b-a71e-4a7e-8a4e-3b77360432e8' AND t0.visite_id = 9700 AND t0.property_id = 248 LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO preconisation_actualisee (date_preco, num_trt, type_traitement, categorie_surface, stade_pheno, contexte_sanitaire, complement_information, surface, operation_culturale, delai, uuid, client_uuid, created_by, last_update, last_updater, mail_body, preco_rapide_id, property_id, regroupement_propriete_id, preconisation_saison_id, visite_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  null
  null
  ""
  ""
  ""
  ""
  ""
  null
  null
  null
  "26d1888e-1a6a-4901-88d1-dcc8d144b200"
  "630f602b-a71e-4a7e-8a4e-3b77360432e8"
  "Léo DELMARRE"
  "2026-06-24"
  "Léo DELMARRE"
  null
  null
  248
  null
  null
  9700
]

INSERT INTO preconisation_actualisee (
  date_preco, num_trt, type_traitement,
  categorie_surface, stade_pheno,
  contexte_sanitaire, complement_information,
  surface, operation_culturale, delai,
  uuid, client_uuid, created_by, last_update,
  last_updater, mail_body, preco_rapide_id,
  property_id, regroupement_propriete_id,
  preconisation_saison_id, visite_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

INSERT INTO preconisation_actualisee (date_preco, num_trt, type_traitement, categorie_surface, stade_pheno, contexte_sanitaire, complement_information, surface, operation_culturale, delai, uuid, client_uuid, created_by, last_update, last_updater, mail_body, preco_rapide_id, property_id, regroupement_propriete_id, preconisation_saison_id, visite_id) VALUES (NULL, NULL, '', '', '', '', '', NULL, NULL, NULL, '26d1888e-1a6a-4901-88d1-dcc8d144b200', '630f602b-a71e-4a7e-8a4e-3b77360432e8', 'Léo DELMARRE', '2026-06-24', 'Léo DELMARRE', NULL, NULL, 248, NULL, NULL, 9700);

"COMMIT"

[]

"COMMIT"

"COMMIT";