Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.code_produit AS code_produit_2,
  t0.nom AS nom_3,
  t0.amm_pcp AS amm_pcp_4,
  t0.detail_conditionnement_usage_produit AS detail_conditionnement_usage_produit_5,
  t0.conditionnement_usage_produit AS conditionnement_usage_produit_6,
  t0.delai_reentree_locaux AS delai_reentree_locaux_7,
  t0.delai_reentree_plein_champ AS delai_reentree_plein_champ_8,
  t0.traitement_semence AS traitement_semence_9,
  t0.produit_bio AS produit_bio_10,
  t0.toxicite AS toxicite_11,
  t0.indice_environnemental AS indice_environnemental_12,
  t0.date_fin_utilisation AS date_fin_utilisation_13,
  t0.date_fin_commercialisation AS date_fin_commercialisation_14,
  t0.date_retrait_amm AS date_retrait_amm_15,
  t0.pays AS pays_16,
  t0.type_commercial AS type_commercial_17,
  t0.code_produit_referent AS code_produit_referent_18,
  t0.mention_jardin AS mention_jardin_19,
  t0.cmr AS cmr_20,
  t0.mention_avertissement AS mention_avertissement_21,
  t0.produit_bio_controle AS produit_bio_controle_22,
  t0.date_premier_enregistrement_phyto AS date_premier_enregistrement_phyto_23,
  t0.gamme_produit AS gamme_produit_24,
  t0.code_ufi AS code_ufi_25,
  t0.code_ufi_non_concerne AS code_ufi_non_concerne_26,
  t0.date_decommercialisation_firme AS date_decommercialisation_firme_27,
  t0.puuid AS puuid_28,
  t0.type_phyto_id AS type_phyto_id_29,
  t0.formulation_id AS formulation_id_30,
  t0.fournisseur_id AS fournisseur_id_31,
  t0.detenteur_id AS detenteur_id_32,
  t0.precurseur_id AS precurseur_id_33
FROM
  basagri_phyto t0
WHERE
  t0.code_produit = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code_produit AS code_produit_2, t0.nom AS nom_3, t0.amm_pcp AS amm_pcp_4, t0.detail_conditionnement_usage_produit AS detail_conditionnement_usage_produit_5, t0.conditionnement_usage_produit AS conditionnement_usage_produit_6, t0.delai_reentree_locaux AS delai_reentree_locaux_7, t0.delai_reentree_plein_champ AS delai_reentree_plein_champ_8, t0.traitement_semence AS traitement_semence_9, t0.produit_bio AS produit_bio_10, t0.toxicite AS toxicite_11, t0.indice_environnemental AS indice_environnemental_12, t0.date_fin_utilisation AS date_fin_utilisation_13, t0.date_fin_commercialisation AS date_fin_commercialisation_14, t0.date_retrait_amm AS date_retrait_amm_15, t0.pays AS pays_16, t0.type_commercial AS type_commercial_17, t0.code_produit_referent AS code_produit_referent_18, t0.mention_jardin AS mention_jardin_19, t0.cmr AS cmr_20, t0.mention_avertissement AS mention_avertissement_21, t0.produit_bio_controle AS produit_bio_controle_22, t0.date_premier_enregistrement_phyto AS date_premier_enregistrement_phyto_23, t0.gamme_produit AS gamme_produit_24, t0.code_ufi AS code_ufi_25, t0.code_ufi_non_concerne AS code_ufi_non_concerne_26, t0.date_decommercialisation_firme AS date_decommercialisation_firme_27, t0.puuid AS puuid_28, t0.type_phyto_id AS type_phyto_id_29, t0.formulation_id AS formulation_id_30, t0.fournisseur_id AS fournisseur_id_31, t0.detenteur_id AS detenteur_id_32, t0.precurseur_id AS precurseur_id_33 FROM basagri_phyto t0 WHERE t0.code_produit = 'P1818' 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.volume_bouillie_minimal AS volume_bouillie_minimal_52,
  t0.volume_bouillie_maximal AS volume_bouillie_maximal_53,
  t0.code_produit_id AS code_produit_id_54,
  t0.culture_id AS culture_id_55,
  t0.cible_id AS cible_id_56,
  t0.traitement_id AS traitement_id_57,
  t0.unite_dose_max_homol_id AS unite_dose_max_homol_id_58,
  t0.stade_limite_bbch_id AS stade_limite_bbch_id_59,
  t0.stade_bbch_debut_application_id AS stade_bbch_debut_application_id_60,
  t0.stade_bbch_fin_application_id AS stade_bbch_fin_application_id_61,
  t0.etalon_dose_recommandee_id AS etalon_dose_recommandee_id_62,
  t0.zone_vegetalisee_id AS zone_vegetalisee_id_63,
  t0.fractionnement_unite_dose_maximale_id AS fractionnement_unite_dose_maximale_id_64,
  t0.id_usage_ministere_id AS id_usage_ministere_id_65,
  t0.unite_dose_mini_homol_id AS unite_dose_mini_homol_id_66,
  t0.periode_application_id AS periode_application_id_67,
  t0.distance_securite_riverain_id AS distance_securite_riverain_id_68,
  t0.culture_attractive_id AS culture_attractive_id_69,
  t0.unite_surface_maximale_id AS unite_surface_maximale_id_70,
  t0.unite_dose_restrictive_id AS unite_dose_restrictive_id_71,
  t0.unite_reduction_derive_id AS unite_reduction_derive_id_72,
  t0.unite_volume_bouillie_minimal_id AS unite_volume_bouillie_minimal_id_73,
  t0.unite_volume_bouillie_maximal_id AS unite_volume_bouillie_maximal_id_74
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.volume_bouillie_minimal AS volume_bouillie_minimal_52, t0.volume_bouillie_maximal AS volume_bouillie_maximal_53, t0.code_produit_id AS code_produit_id_54, t0.culture_id AS culture_id_55, t0.cible_id AS cible_id_56, t0.traitement_id AS traitement_id_57, t0.unite_dose_max_homol_id AS unite_dose_max_homol_id_58, t0.stade_limite_bbch_id AS stade_limite_bbch_id_59, t0.stade_bbch_debut_application_id AS stade_bbch_debut_application_id_60, t0.stade_bbch_fin_application_id AS stade_bbch_fin_application_id_61, t0.etalon_dose_recommandee_id AS etalon_dose_recommandee_id_62, t0.zone_vegetalisee_id AS zone_vegetalisee_id_63, t0.fractionnement_unite_dose_maximale_id AS fractionnement_unite_dose_maximale_id_64, t0.id_usage_ministere_id AS id_usage_ministere_id_65, t0.unite_dose_mini_homol_id AS unite_dose_mini_homol_id_66, t0.periode_application_id AS periode_application_id_67, t0.distance_securite_riverain_id AS distance_securite_riverain_id_68, t0.culture_attractive_id AS culture_attractive_id_69, t0.unite_surface_maximale_id AS unite_surface_maximale_id_70, t0.unite_dose_restrictive_id AS unite_dose_restrictive_id_71, t0.unite_reduction_derive_id AS unite_reduction_derive_id_72, t0.unite_volume_bouillie_minimal_id AS unite_volume_bouillie_minimal_id_73, t0.unite_volume_bouillie_maximal_id AS unite_volume_bouillie_maximal_id_74 FROM basagri_usage t0 WHERE t0.uuid = '16ddb182-9c72-4b9d-9827-57d98f48f7c8' LIMIT 1;

SELECT
  b0_.nom AS nom_0,
  GROUP_CONCAT(DISTINCT m1_.specialite1) AS sclr_1
FROM
  basagri_phyto b0_
  LEFT JOIN basagri_clp_phyto b2_ ON (b2_.code_produit_id = b0_.id)
  LEFT JOIN basagri_clp b3_ ON (b3_.id = b2_.code_id)
  LEFT JOIN mapping_interdictions m1_ ON (m1_.specialite1 = b3_.code)
WHERE
  m1_.specialite1 IS NOT NULL
  AND b0_.id = ?
GROUP BY
  b0_.nom
ORDER BY
  m1_.specialite1 ASC

SELECT b0_.nom AS nom_0, GROUP_CONCAT(DISTINCT m1_.specialite1) AS sclr_1 FROM basagri_phyto b0_ LEFT JOIN basagri_clp_phyto b2_ ON (b2_.code_produit_id = b0_.id) LEFT JOIN basagri_clp b3_ ON (b3_.id = b2_.code_id) LEFT JOIN mapping_interdictions m1_ ON (m1_.specialite1 = b3_.code) WHERE m1_.specialite1 IS NOT NULL AND b0_.id = 3563 GROUP BY b0_.nom ORDER BY m1_.specialite1 ASC;

SELECT
  b0_.id AS id_0,
  b0_.dosage AS dosage_1,
  b0_.code_produit_id AS code_produit_id_2,
  b0_.code_substance_id AS code_substance_id_3,
  b0_.unite_dosage_id AS unite_dosage_id_4
FROM
  basagri_composition b0_
  LEFT JOIN basagri_unite_substance b1_ ON (b1_.id = b0_.unite_dosage_id)
  LEFT JOIN basagri_substance b2_ ON (b2_.id = b0_.code_substance_id)
WHERE
  b0_.code_produit_id = ?
ORDER BY
  b2_.libelle ASC

SELECT b0_.id AS id_0, b0_.dosage AS dosage_1, b0_.code_produit_id AS code_produit_id_2, b0_.code_substance_id AS code_substance_id_3, b0_.unite_dosage_id AS unite_dosage_id_4 FROM basagri_composition b0_ LEFT JOIN basagri_unite_substance b1_ ON (b1_.id = b0_.unite_dosage_id) LEFT JOIN basagri_substance b2_ ON (b2_.id = b0_.code_substance_id) WHERE b0_.code_produit_id = 3563 ORDER BY b2_.libelle ASC;

SELECT
  t0.id AS id_1,
  t0.stade AS stade_2,
  t0.libelle AS libelle_3,
  t0.display_order AS display_order_4,
  t0.bbch AS bbch_5,
  t0.bbch_img AS bbch_img_6,
  t0.baggiolini AS baggiolini_7,
  t0.baggiolini_img AS baggiolini_img_8,
  t0.updated_at AS updated_at_9,
  t0.is_active AS is_active_10,
  t0.is_shown AS is_shown_11,
  t0.title AS title_12,
  t0.stade_parent_id AS stade_parent_id_13
FROM
  stade_culture t0
WHERE
  t0.bbch = ?

SELECT t0.id AS id_1, t0.stade AS stade_2, t0.libelle AS libelle_3, t0.display_order AS display_order_4, t0.bbch AS bbch_5, t0.bbch_img AS bbch_img_6, t0.baggiolini AS baggiolini_7, t0.baggiolini_img AS baggiolini_img_8, t0.updated_at AS updated_at_9, t0.is_active AS is_active_10, t0.is_shown AS is_shown_11, t0.title AS title_12, t0.stade_parent_id AS stade_parent_id_13 FROM stade_culture t0 WHERE t0.bbch = 'BBCH 13';

SELECT
  b0_.code AS code_0,
  b0_.libelle AS libelle_1,
  GROUP_CONCAT(
    DISTINCT CONCAT(b1_.amm_pcp, ' - ', b1_.nom)
    ORDER BY
      b1_.nom ASC SEPARATOR '<br/>'
  ) AS sclr_2
FROM
  basagri_clp_phyto b2_
  LEFT JOIN basagri_phyto b1_ ON (b2_.code_produit_id = b1_.id)
  LEFT JOIN basagri_clp b0_ ON (b2_.code_id = b0_.id)
  INNER JOIN mapping_interdictions m3_ ON (m3_.specialite1 = b0_.code)
  INNER JOIN preconisation p4_ ON (
    b1_.code_produit = p4_.basagri_product_code
  )
  INNER JOIN calendrier c5_ ON (p4_.calendar_id = c5_.id)
WHERE
  c5_.id = 2015
GROUP BY
  b0_.code
ORDER BY
  b0_.code ASC

SELECT b0_.code AS code_0, b0_.libelle AS libelle_1, GROUP_CONCAT(DISTINCT CONCAT(b1_.amm_pcp, ' - ', b1_.nom)  ORDER BY b1_.nom ASC SEPARATOR '<br/>') AS sclr_2 FROM basagri_clp_phyto b2_ LEFT JOIN basagri_phyto b1_ ON (b2_.code_produit_id = b1_.id) LEFT JOIN basagri_clp b0_ ON (b2_.code_id = b0_.id) INNER JOIN mapping_interdictions m3_ ON (m3_.specialite1 = b0_.code) INNER JOIN preconisation p4_ ON (b1_.code_produit = p4_.basagri_product_code) INNER JOIN calendrier c5_ ON (p4_.calendar_id = c5_.id) WHERE c5_.id = 2015 GROUP BY b0_.code ORDER BY b0_.code ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.type_substance AS type_substance_4,
  t0.numero_cas AS numero_cas_5,
  t0.code_famille_id AS code_famille_id_6
FROM
  basagri_substance t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.type_substance AS type_substance_4, t0.numero_cas AS numero_cas_5, t0.code_famille_id AS code_famille_id_6 FROM basagri_substance t0 WHERE t0.id = 140;

SELECT
  p0_.id AS id_0,
  p0_.date_debut AS date_debut_1,
  p0_.date_fin AS date_fin_2,
  p0_.localisation AS localisation_3,
  p0_.surface_traitee AS surface_traitee_4,
  p0_.surface_totale AS surface_totale_5,
  p0_.observations AS observations_6,
  p0_.position AS position_7,
  p0_.cible AS cible_8,
  p0_.dose_unite AS dose_unite_9,
  p0_.dose_homol_val AS dose_homol_val_10,
  p0_.dose_max_val AS dose_max_val_11,
  p0_.dose_preco AS dose_preco_12,
  p0_.created_by AS created_by_13,
  p0_.last_modified_by AS last_modified_by_14,
  p0_.basagri_product_code AS basagri_product_code_15,
  p0_.basagri_product_name AS basagri_product_name_16,
  p0_.basagri_usage AS basagri_usage_17,
  p0_.stade AS stade_18,
  p0_.calendar_id AS calendar_id_19
FROM
  preconisation p0_
  LEFT JOIN stade_culture s1_ ON (s1_.bbch = p0_.stade)
WHERE
  p0_.calendar_id = ?
  AND p0_.basagri_usage IS NOT NULL
ORDER BY
  s1_.stade_parent_id ASC,
  s1_.display_order ASC,
  p0_.date_debut ASC,
  p0_.date_fin ASC

SELECT p0_.id AS id_0, p0_.date_debut AS date_debut_1, p0_.date_fin AS date_fin_2, p0_.localisation AS localisation_3, p0_.surface_traitee AS surface_traitee_4, p0_.surface_totale AS surface_totale_5, p0_.observations AS observations_6, p0_.position AS position_7, p0_.cible AS cible_8, p0_.dose_unite AS dose_unite_9, p0_.dose_homol_val AS dose_homol_val_10, p0_.dose_max_val AS dose_max_val_11, p0_.dose_preco AS dose_preco_12, p0_.created_by AS created_by_13, p0_.last_modified_by AS last_modified_by_14, p0_.basagri_product_code AS basagri_product_code_15, p0_.basagri_product_name AS basagri_product_name_16, p0_.basagri_usage AS basagri_usage_17, p0_.stade AS stade_18, p0_.calendar_id AS calendar_id_19 FROM preconisation p0_ LEFT JOIN stade_culture s1_ ON (s1_.bbch = p0_.stade) WHERE p0_.calendar_id = 2015 AND p0_.basagri_usage IS NOT NULL ORDER BY s1_.stade_parent_id ASC, s1_.display_order ASC, p0_.date_debut ASC, p0_.date_fin ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.valeur AS valeur_4,
  t0.categorie AS categorie_5
FROM
  basagri_distance_securite_riverain t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.valeur AS valeur_4, t0.categorie AS categorie_5 FROM basagri_distance_securite_riverain t0 WHERE t0.id = 16;

SELECT
  CONCAT(b0_.amm_pcp, ' - ', b0_.nom) AS sclr_0,
  COUNT(b0_.id) AS sclr_1,
  b1_.znt_aquatique_infos AS znt_aquatique_infos_2
FROM
  basagri_usage b1_
  LEFT JOIN basagri_phyto b0_ ON (b1_.code_produit_id = b0_.id)
  INNER JOIN preconisation p2_ ON (
    b0_.code_produit = p2_.basagri_product_code
    AND b1_.uuid = p2_.basagri_usage
  )
  INNER JOIN calendrier c3_ ON (p2_.calendar_id = c3_.id)
WHERE
  c3_.id = 2015
  AND b1_.znt_aquatique_infos NOT LIKE ''
GROUP BY
  b0_.id
ORDER BY
  b0_.nom ASC

SELECT CONCAT(b0_.amm_pcp, ' - ', b0_.nom) AS sclr_0, COUNT(b0_.id) AS sclr_1, b1_.znt_aquatique_infos AS znt_aquatique_infos_2 FROM basagri_usage b1_ LEFT JOIN basagri_phyto b0_ ON (b1_.code_produit_id = b0_.id) INNER JOIN preconisation p2_ ON (b0_.code_produit = p2_.basagri_product_code AND b1_.uuid = p2_.basagri_usage) INNER JOIN calendrier c3_ ON (p2_.calendar_id = c3_.id) WHERE c3_.id = 2015 AND b1_.znt_aquatique_infos NOT LIKE '' GROUP BY b0_.id ORDER BY b0_.nom ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3
FROM
  basagri_unite_substance t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM basagri_unite_substance t0 WHERE t0.id = 1;

SELECT
  CONCAT(b0_.amm_pcp, ' - ', b0_.nom) AS sclr_0,
  CONCAT(
    TRIM(
      TRAILING '.'
      FROM
        TRIM(
          TRAILING '0'
          FROM
            ROUND(b1_.montant, 5)
        )
    ),
    ' ',
    b2_.libelle
  ) AS sclr_1,
  b1_.action_duree AS action_duree_2,
  DATE_FORMAT(b1_.action_debut, '%d/%m/%Y') AS sclr_3,
  DATE_FORMAT(b1_.action_fin, '%d/%m/%Y') AS sclr_4
FROM
  basagri_phyto b0_
  INNER JOIN basagri_cepp_phyto b1_ ON (b1_.code_produit_id = b0_.id)
  LEFT JOIN basagri_unite_cepp b2_ ON (b1_.code_unite_cepp_id = b2_.id)
WHERE
  b0_.code_produit IN (
    'P23061', 'P23308', 'P26228', 'P26001',
    'P22477', 'P1818', 'P0805', 'P1818',
    'P0805', 'P24093', 'P0805', 'P23308',
    'P0805', 'P20990', 'P26228', 'P24524',
    'P19896', 'P-WHITE', 'P-WHITE', 'P-WHITE',
    'P23874', 'P23308', 'P0805', 'P1563',
    'P20558', 'P20558', 'p-BOVA', 'p-BOVA',
    'p-BOVA', 'p-BOVA', 'p-BOVA', 'P24524',
    'P0994', 'P24093', 'P23766', 'P22751'
  )
ORDER BY
  b0_.nom ASC

SELECT CONCAT(b0_.amm_pcp, ' - ', b0_.nom) AS sclr_0, CONCAT(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM ROUND(b1_.montant, 5))), ' ', b2_.libelle) AS sclr_1, b1_.action_duree AS action_duree_2, DATE_FORMAT(b1_.action_debut,'%d/%m/%Y') AS sclr_3, DATE_FORMAT(b1_.action_fin,'%d/%m/%Y') AS sclr_4 FROM basagri_phyto b0_ INNER JOIN basagri_cepp_phyto b1_ ON (b1_.code_produit_id = b0_.id) LEFT JOIN basagri_unite_cepp b2_ ON (b1_.code_unite_cepp_id = b2_.id) WHERE b0_.code_produit IN ('P23061', 'P23308', 'P26228', 'P26001', 'P22477', 'P1818', 'P0805', 'P1818', 'P0805', 'P24093', 'P0805', 'P23308', 'P0805', 'P20990', 'P26228', 'P24524', 'P19896', 'P-WHITE', 'P-WHITE', 'P-WHITE', 'P23874', 'P23308', 'P0805', 'P1563', 'P20558', 'P20558', 'p-BOVA', 'p-BOVA', 'p-BOVA', 'p-BOVA', 'p-BOVA', 'P24524', 'P0994', 'P24093', 'P23766', 'P22751') ORDER BY b0_.nom ASC;

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

SELECT
  t0.id AS id_1,
  t0.date_debut AS date_debut_2,
  t0.date_fin AS date_fin_3,
  t0.localisation AS localisation_4,
  t0.surface_traitee AS surface_traitee_5,
  t0.surface_totale AS surface_totale_6,
  t0.observations AS observations_7,
  t0.position AS position_8,
  t0.cible AS cible_9,
  t0.dose_unite AS dose_unite_10,
  t0.dose_homol_val AS dose_homol_val_11,
  t0.dose_max_val AS dose_max_val_12,
  t0.dose_preco AS dose_preco_13,
  t0.created_by AS created_by_14,
  t0.last_modified_by AS last_modified_by_15,
  t0.basagri_product_code AS basagri_product_code_16,
  t0.basagri_product_name AS basagri_product_name_17,
  t0.basagri_usage AS basagri_usage_18,
  t0.stade AS stade_19,
  t0.calendar_id AS calendar_id_20
FROM
  preconisation t0
WHERE
  t0.calendar_id = ?

SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.localisation AS localisation_4, t0.surface_traitee AS surface_traitee_5, t0.surface_totale AS surface_totale_6, t0.observations AS observations_7, t0.position AS position_8, t0.cible AS cible_9, t0.dose_unite AS dose_unite_10, t0.dose_homol_val AS dose_homol_val_11, t0.dose_max_val AS dose_max_val_12, t0.dose_preco AS dose_preco_13, t0.created_by AS created_by_14, t0.last_modified_by AS last_modified_by_15, t0.basagri_product_code AS basagri_product_code_16, t0.basagri_product_name AS basagri_product_name_17, t0.basagri_usage AS basagri_usage_18, t0.stade AS stade_19, t0.calendar_id AS calendar_id_20 FROM preconisation t0 WHERE t0.calendar_id = 2015;

SELECT
  t0.id AS id_1,
  t0.itinerary AS itinerary_2,
  t0.surface AS surface_3,
  t0.year AS year_4,
  t0.property_id AS property_id_5,
  t0.copied_from_id AS copied_from_id_6
FROM
  calendrier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.itinerary AS itinerary_2, t0.surface AS surface_3, t0.year AS year_4, t0.property_id AS property_id_5, t0.copied_from_id AS copied_from_id_6 FROM calendrier t0 WHERE t0.id = '2015';

SELECT
  t0.id AS id_1,
  t0.mention AS mention_2,
  t0.annee AS annee_3,
  t0.dpt_id AS dpt_id_4
FROM
  dpt_spec t0
WHERE
  t0.dpt_id = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.mention AS mention_2, t0.annee AS annee_3, t0.dpt_id AS dpt_id_4 FROM dpt_spec t0 WHERE t0.dpt_id = 34 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.mention AS mention_2,
  t0.annee AS annee_3,
  t0.dpt_id AS dpt_id_4
FROM
  dpt_spec t0
WHERE
  t0.annee = ?
  AND t0.dpt_id = ?
LIMIT
  1