Symfony Profiler

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 = 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 = ?
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 = '33204199-b3be-44bc-ab63-0e186a18093f' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.dose_maximale_homologuee AS dose_maximale_homologuee_2,
  t0.znt_aquatique AS znt_aquatique_3,
  t0.znt_aquatique_infos AS znt_aquatique_infos_4,
  t0.znt_terrestre_cultivee AS znt_terrestre_cultivee_5,
  t0.znt_terrestre_non_cultivee AS znt_terrestre_non_cultivee_6,
  t0.nombre_application AS nombre_application_7,
  t0.nombre_applications_infos AS nombre_applications_infos_8,
  t0.information_avant_dar AS information_avant_dar_9,
  t0.dar AS dar_10,
  t0.information_apres_dar AS information_apres_dar_11,
  t0.specification_usage AS specification_usage_12,
  t0.date_debut_utilisation_usage AS date_debut_utilisation_usage_13,
  t0.date_fin_utilisation_usage AS date_fin_utilisation_usage_14,
  t0.mention_abeille AS mention_abeille_15,
  t0.dre_animaux AS dre_animaux_16,
  t0.commentaire_dre_animaux AS commentaire_dre_animaux_17,
  t0.dose_recommandee_firme AS dose_recommandee_firme_18,
  t0.commentaire_dose_recommandee AS commentaire_dose_recommandee_19,
  t0.fractionnement AS fractionnement_20,
  t0.commentaire_fractionnement AS commentaire_fractionnement_21,
  t0.intervalle_application AS intervalle_application_22,
  t0.commentaire_intervalle AS commentaire_intervalle_23,
  t0.commentaire_znt_terrestre AS commentaire_znt_terrestre_24,
  t0.fractionnement_dose_maximale AS fractionnement_dose_maximale_25,
  t0.fractionnement_nombre_application_minimal AS fractionnement_nombre_application_minimal_26,
  t0.fractionnement_nombre_application_maximal AS fractionnement_nombre_application_maximal_27,
  t0.code_cible_ministere AS code_cible_ministere_28,
  t0.uuid AS uuid_29,
  t0.dose_minimale_homologuee AS dose_minimale_homologuee_30,
  t0.delai_reentree_local AS delai_reentree_local_31,
  t0.delai_reentree_plein_champ AS delai_reentree_plein_champ_32,
  t0.date_debut_delai_grace AS date_debut_delai_grace_33,
  t0.date_fin_delai_grace AS date_fin_delai_grace_34,
  t0.date_debut_periode_application AS date_debut_periode_application_35,
  t0.date_fin_periode_application AS date_fin_periode_application_36,
  t0.date_fin_commercialisation AS date_fin_commercialisation_37,
  t0.discriminant AS discriminant_38,
  t0.usage_duplique AS usage_duplique_39,
  t0.uuid_usage_duplique AS uuid_usage_duplique_40,
  t0.utilisation_materiel_attenuation_derive AS utilisation_materiel_attenuation_derive_41,
  t0.commentaire_distance_securite_riverain AS commentaire_distance_securite_riverain_42,
  t0.valeur_znt_terrestre_cultivee AS valeur_znt_terrestre_cultivee_43,
  t0.valeur_znt_terrestre_non_cultivee AS valeur_znt_terrestre_non_cultivee_44,
  t0.intervalle_application_fractionnement AS intervalle_application_fractionnement_45,
  t0.surface_maximale AS surface_maximale_46,
  t0.dose_restrictive AS dose_restrictive_47,
  t0.commentaire_dose_restrictive AS commentaire_dose_restrictive_48,
  t0.reduction_derive AS reduction_derive_49,
  t0.usage_derogatoire AS usage_derogatoire_50,
  t0.duree_usage_derogatoire AS duree_usage_derogatoire_51,
  t0.code_produit_id AS code_produit_id_52,
  t0.culture_id AS culture_id_53,
  t0.cible_id AS cible_id_54,
  t0.traitement_id AS traitement_id_55,
  t0.unite_dose_max_homol_id AS unite_dose_max_homol_id_56,
  t0.stade_limite_bbch_id AS stade_limite_bbch_id_57,
  t0.stade_bbch_debut_application_id AS stade_bbch_debut_application_id_58,
  t0.stade_bbch_fin_application_id AS stade_bbch_fin_application_id_59,
  t0.etalon_dose_recommandee_id AS etalon_dose_recommandee_id_60,
  t0.zone_vegetalisee_id AS zone_vegetalisee_id_61,
  t0.fractionnement_unite_dose_maximale_id AS fractionnement_unite_dose_maximale_id_62,
  t0.id_usage_ministere_id AS id_usage_ministere_id_63,
  t0.unite_dose_mini_homol_id AS unite_dose_mini_homol_id_64,
  t0.periode_application_id AS periode_application_id_65,
  t0.distance_securite_riverain_id AS distance_securite_riverain_id_66,
  t0.culture_attractive_id AS culture_attractive_id_67,
  t0.unite_surface_maximale_id AS unite_surface_maximale_id_68,
  t0.unite_dose_restrictive_id AS unite_dose_restrictive_id_69,
  t0.unite_reduction_derive_id AS unite_reduction_derive_id_70
FROM
  basagri_usage t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.dose_maximale_homologuee AS dose_maximale_homologuee_2, t0.znt_aquatique AS znt_aquatique_3, t0.znt_aquatique_infos AS znt_aquatique_infos_4, t0.znt_terrestre_cultivee AS znt_terrestre_cultivee_5, t0.znt_terrestre_non_cultivee AS znt_terrestre_non_cultivee_6, t0.nombre_application AS nombre_application_7, t0.nombre_applications_infos AS nombre_applications_infos_8, t0.information_avant_dar AS information_avant_dar_9, t0.dar AS dar_10, t0.information_apres_dar AS information_apres_dar_11, t0.specification_usage AS specification_usage_12, t0.date_debut_utilisation_usage AS date_debut_utilisation_usage_13, t0.date_fin_utilisation_usage AS date_fin_utilisation_usage_14, t0.mention_abeille AS mention_abeille_15, t0.dre_animaux AS dre_animaux_16, t0.commentaire_dre_animaux AS commentaire_dre_animaux_17, t0.dose_recommandee_firme AS dose_recommandee_firme_18, t0.commentaire_dose_recommandee AS commentaire_dose_recommandee_19, t0.fractionnement AS fractionnement_20, t0.commentaire_fractionnement AS commentaire_fractionnement_21, t0.intervalle_application AS intervalle_application_22, t0.commentaire_intervalle AS commentaire_intervalle_23, t0.commentaire_znt_terrestre AS commentaire_znt_terrestre_24, t0.fractionnement_dose_maximale AS fractionnement_dose_maximale_25, t0.fractionnement_nombre_application_minimal AS fractionnement_nombre_application_minimal_26, t0.fractionnement_nombre_application_maximal AS fractionnement_nombre_application_maximal_27, t0.code_cible_ministere AS code_cible_ministere_28, t0.uuid AS uuid_29, t0.dose_minimale_homologuee AS dose_minimale_homologuee_30, t0.delai_reentree_local AS delai_reentree_local_31, t0.delai_reentree_plein_champ AS delai_reentree_plein_champ_32, t0.date_debut_delai_grace AS date_debut_delai_grace_33, t0.date_fin_delai_grace AS date_fin_delai_grace_34, t0.date_debut_periode_application AS date_debut_periode_application_35, t0.date_fin_periode_application AS date_fin_periode_application_36, t0.date_fin_commercialisation AS date_fin_commercialisation_37, t0.discriminant AS discriminant_38, t0.usage_duplique AS usage_duplique_39, t0.uuid_usage_duplique AS uuid_usage_duplique_40, t0.utilisation_materiel_attenuation_derive AS utilisation_materiel_attenuation_derive_41, t0.commentaire_distance_securite_riverain AS commentaire_distance_securite_riverain_42, t0.valeur_znt_terrestre_cultivee AS valeur_znt_terrestre_cultivee_43, t0.valeur_znt_terrestre_non_cultivee AS valeur_znt_terrestre_non_cultivee_44, t0.intervalle_application_fractionnement AS intervalle_application_fractionnement_45, t0.surface_maximale AS surface_maximale_46, t0.dose_restrictive AS dose_restrictive_47, t0.commentaire_dose_restrictive AS commentaire_dose_restrictive_48, t0.reduction_derive AS reduction_derive_49, t0.usage_derogatoire AS usage_derogatoire_50, t0.duree_usage_derogatoire AS duree_usage_derogatoire_51, t0.code_produit_id AS code_produit_id_52, t0.culture_id AS culture_id_53, t0.cible_id AS cible_id_54, t0.traitement_id AS traitement_id_55, t0.unite_dose_max_homol_id AS unite_dose_max_homol_id_56, t0.stade_limite_bbch_id AS stade_limite_bbch_id_57, t0.stade_bbch_debut_application_id AS stade_bbch_debut_application_id_58, t0.stade_bbch_fin_application_id AS stade_bbch_fin_application_id_59, t0.etalon_dose_recommandee_id AS etalon_dose_recommandee_id_60, t0.zone_vegetalisee_id AS zone_vegetalisee_id_61, t0.fractionnement_unite_dose_maximale_id AS fractionnement_unite_dose_maximale_id_62, t0.id_usage_ministere_id AS id_usage_ministere_id_63, t0.unite_dose_mini_homol_id AS unite_dose_mini_homol_id_64, t0.periode_application_id AS periode_application_id_65, t0.distance_securite_riverain_id AS distance_securite_riverain_id_66, t0.culture_attractive_id AS culture_attractive_id_67, t0.unite_surface_maximale_id AS unite_surface_maximale_id_68, t0.unite_dose_restrictive_id AS unite_dose_restrictive_id_69, t0.unite_reduction_derive_id AS unite_reduction_derive_id_70 FROM basagri_usage t0 WHERE t0.uuid = '483aea71-9db9-46dc-a277-788e96c9af63' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.dose_preco AS dose_preco_2,
  t0.usage_id AS usage_id_3,
  t0.uuid AS uuid_4,
  t0.client_uuid AS client_uuid_5,
  t0.preco_flash_id AS preco_flash_id_6
FROM
  preconisation_dosages t0
WHERE
  t0.client_uuid = ?
  AND t0.preco_flash_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.dose_preco AS dose_preco_2, t0.usage_id AS usage_id_3, t0.uuid AS uuid_4, t0.client_uuid AS client_uuid_5, t0.preco_flash_id AS preco_flash_id_6 FROM preconisation_dosages t0 WHERE t0.client_uuid = '96e1fdab-7d73-4b82-a23b-31366958bc79' AND t0.preco_flash_id = 6201 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  preconisation_dosages
SET
  dose_preco = ?
WHERE
  id = ?

UPDATE preconisation_dosages SET dose_preco = '1.25' WHERE id = 16470;

"COMMIT"

"COMMIT";