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

[
  158
]

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

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

[
  "e4b9adb4-3c9a-457b-901c-d44112665cad"
]

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 = 'e4b9adb4-3c9a-457b-901c-d44112665cad' LIMIT 1;

SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.ilot AS ilot_3, t0.parcelle AS parcelle_4, t0.stade_r_1 AS stade_r_1_5, t0.stade_r_2 AS stade_r_2_6, t0.mi_f AS mi_f_7, t0.mi_g AS mi_g_8, t0.br_f AS br_f_9, t0.br_g AS br_g_10, t0.oi_f AS oi_f_11, t0.oi_g AS oi_g_12, t0.pg_f AS pg_f_13, t0.pg_g AS pg_g_14, t0.maladie_bois AS maladie_bois_15, t0.note_mdb AS note_mdb_16, t0.cic_v AS cic_v_17, t0.cic_fd AS cic_fd_18, t0.vdg_glom AS vdg_glom_19, t0.vdg_perfos AS vdg_perfos_20, t0.carences AS carences_21, t0.note_carence AS note_carence_22, t0.commentaire AS commentaire_23, t0.notation AS notation_24, t0.created_by AS created_by_25, t0.last_update AS last_update_26, t0.last_updater AS last_updater_27, t0.vdg_ponte AS vdg_ponte_28, t0.uuid AS uuid_29, t0.client_uuid AS client_uuid_30, t0.property_id AS property_id_31, t0.visite_id AS visite_id_32 FROM observation t0 WHERE t0.client_uuid = ? AND t0.visite_id = ? AND t0.property_id = ? LIMIT 1

[
  "6dc26387-bcf7-4899-bef2-96199089059c"
  7977
  158
]

SELECT
  t0.id AS id_1,
  t0.secteur AS secteur_2,
  t0.ilot AS ilot_3,
  t0.parcelle AS parcelle_4,
  t0.stade_r_1 AS stade_r_1_5,
  t0.stade_r_2 AS stade_r_2_6,
  t0.mi_f AS mi_f_7,
  t0.mi_g AS mi_g_8,
  t0.br_f AS br_f_9,
  t0.br_g AS br_g_10,
  t0.oi_f AS oi_f_11,
  t0.oi_g AS oi_g_12,
  t0.pg_f AS pg_f_13,
  t0.pg_g AS pg_g_14,
  t0.maladie_bois AS maladie_bois_15,
  t0.note_mdb AS note_mdb_16,
  t0.cic_v AS cic_v_17,
  t0.cic_fd AS cic_fd_18,
  t0.vdg_glom AS vdg_glom_19,
  t0.vdg_perfos AS vdg_perfos_20,
  t0.carences AS carences_21,
  t0.note_carence AS note_carence_22,
  t0.commentaire AS commentaire_23,
  t0.notation AS notation_24,
  t0.created_by AS created_by_25,
  t0.last_update AS last_update_26,
  t0.last_updater AS last_updater_27,
  t0.vdg_ponte AS vdg_ponte_28,
  t0.uuid AS uuid_29,
  t0.client_uuid AS client_uuid_30,
  t0.property_id AS property_id_31,
  t0.visite_id AS visite_id_32
FROM
  observation t0
WHERE
  t0.client_uuid = ?
  AND t0.visite_id = ?
  AND t0.property_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.ilot AS ilot_3, t0.parcelle AS parcelle_4, t0.stade_r_1 AS stade_r_1_5, t0.stade_r_2 AS stade_r_2_6, t0.mi_f AS mi_f_7, t0.mi_g AS mi_g_8, t0.br_f AS br_f_9, t0.br_g AS br_g_10, t0.oi_f AS oi_f_11, t0.oi_g AS oi_g_12, t0.pg_f AS pg_f_13, t0.pg_g AS pg_g_14, t0.maladie_bois AS maladie_bois_15, t0.note_mdb AS note_mdb_16, t0.cic_v AS cic_v_17, t0.cic_fd AS cic_fd_18, t0.vdg_glom AS vdg_glom_19, t0.vdg_perfos AS vdg_perfos_20, t0.carences AS carences_21, t0.note_carence AS note_carence_22, t0.commentaire AS commentaire_23, t0.notation AS notation_24, t0.created_by AS created_by_25, t0.last_update AS last_update_26, t0.last_updater AS last_updater_27, t0.vdg_ponte AS vdg_ponte_28, t0.uuid AS uuid_29, t0.client_uuid AS client_uuid_30, t0.property_id AS property_id_31, t0.visite_id AS visite_id_32 FROM observation t0 WHERE t0.client_uuid = '6dc26387-bcf7-4899-bef2-96199089059c' AND t0.visite_id = 7977 AND t0.property_id = 158 LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO observation (secteur, ilot, parcelle, stade_r_1, stade_r_2, mi_f, mi_g, br_f, br_g, oi_f, oi_g, pg_f, pg_g, maladie_bois, note_mdb, cic_v, cic_fd, vdg_glom, vdg_perfos, carences, note_carence, commentaire, notation, created_by, last_update, last_updater, vdg_ponte, uuid, client_uuid, property_id, visite_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  "A définir"
  ""
  "16"
  "C - Pointe verte"
  "E - Deux feuilles étalées"
  "0 Abs"
  "0 Abs"
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  "Léo DELMARRE"
  "2026-04-01"
  "Léo DELMARRE"
  ""
  "d6d63a74-f484-4107-9e6e-5c078c450f18"
  "6dc26387-bcf7-4899-bef2-96199089059c"
  158
  7977
]

INSERT INTO observation (
  secteur, ilot, parcelle, stade_r_1,
  stade_r_2, mi_f, mi_g, br_f, br_g,
  oi_f, oi_g, pg_f, pg_g, maladie_bois,
  note_mdb, cic_v, cic_fd, vdg_glom,
  vdg_perfos, carences, note_carence,
  commentaire, notation, created_by,
  last_update, last_updater, vdg_ponte,
  uuid, client_uuid, property_id, visite_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO observation (secteur, ilot, parcelle, stade_r_1, stade_r_2, mi_f, mi_g, br_f, br_g, oi_f, oi_g, pg_f, pg_g, maladie_bois, note_mdb, cic_v, cic_fd, vdg_glom, vdg_perfos, carences, note_carence, commentaire, notation, created_by, last_update, last_updater, vdg_ponte, uuid, client_uuid, property_id, visite_id) VALUES ('A définir', '', '16', 'C - Pointe verte', 'E - Deux feuilles étalées', '0 Abs', '0 Abs', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Léo DELMARRE', '2026-04-01', 'Léo DELMARRE', '', 'd6d63a74-f484-4107-9e6e-5c078c450f18', '6dc26387-bcf7-4899-bef2-96199089059c', 158, 7977);

"COMMIT"

[]

"COMMIT"

"COMMIT";