Query Metrics
3
Database Queries
3
Different statements
123.92 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 56.80 ms |
SELECT COUNT(DISTINCT b0_.id) AS sclr_0 FROM basagri_usage b0_ LEFT JOIN basagri_culture b1_ ON b0_.culture_id = b1_.id INNER JOIN basagri_phyto b2_ ON b0_.code_produit_id = b2_.id INNER JOIN basagri_cible b3_ ON b0_.cible_id = b3_.id INNER JOIN basagri_traitement b4_ ON b0_.traitement_id = b4_.id INNER JOIN basagri_unite_usage b5_ ON b0_.unite_dose_max_homol_id = b5_.id LEFT JOIN basagri_stade b6_ ON b0_.stade_limite_bbch_id = b6_.id LEFT JOIN basagri_stade b7_ ON b0_.stade_bbch_debut_application_id = b7_.id LEFT JOIN basagri_stade b8_ ON b0_.stade_bbch_fin_application_id = b8_.id LEFT JOIN basagri_unite_usage b9_ ON b0_.etalon_dose_recommandee_id = b9_.id LEFT JOIN basagri_zone_vegetalisee b10_ ON b0_.zone_vegetalisee_id = b10_.id LEFT JOIN basagri_unite_usage b11_ ON b0_.fractionnement_unite_dose_maximale_id = b11_.id INNER JOIN basagri_usage_ministere b12_ ON b0_.id_usage_ministere_id = b12_.id LEFT JOIN basagri_unite_usage b13_ ON b0_.unite_dose_mini_homol_id = b13_.id LEFT JOIN basagri_periode_application b14_ ON b0_.periode_application_id = b14_.id LEFT JOIN basagri_distance_securite_riverain b15_ ON b0_.distance_securite_riverain_id = b15_.id LEFT JOIN basagri_culture_attractive b16_ ON b0_.culture_attractive_id = b16_.id LEFT JOIN basagri_class_usage b17_ ON b0_.id = b17_.uuid_id WHERE b0_.id IN (SELECT b18_.id FROM basagri_usage b18_ LEFT JOIN basagri_culture b19_ ON b18_.culture_id = b19_.id WHERE b19_.code IN (?, ?))
Parameters:
[ "606" "211" ] |
| 2 | 55.50 ms |
SELECT DISTINCT b0_.id AS id_0, b0_.id AS id_1 FROM basagri_usage b0_ LEFT JOIN basagri_culture b1_ ON b0_.culture_id = b1_.id INNER JOIN basagri_phyto b2_ ON b0_.code_produit_id = b2_.id INNER JOIN basagri_cible b3_ ON b0_.cible_id = b3_.id INNER JOIN basagri_traitement b4_ ON b0_.traitement_id = b4_.id INNER JOIN basagri_unite_usage b5_ ON b0_.unite_dose_max_homol_id = b5_.id LEFT JOIN basagri_stade b6_ ON b0_.stade_limite_bbch_id = b6_.id LEFT JOIN basagri_stade b7_ ON b0_.stade_bbch_debut_application_id = b7_.id LEFT JOIN basagri_stade b8_ ON b0_.stade_bbch_fin_application_id = b8_.id LEFT JOIN basagri_unite_usage b9_ ON b0_.etalon_dose_recommandee_id = b9_.id LEFT JOIN basagri_zone_vegetalisee b10_ ON b0_.zone_vegetalisee_id = b10_.id LEFT JOIN basagri_unite_usage b11_ ON b0_.fractionnement_unite_dose_maximale_id = b11_.id INNER JOIN basagri_usage_ministere b12_ ON b0_.id_usage_ministere_id = b12_.id LEFT JOIN basagri_unite_usage b13_ ON b0_.unite_dose_mini_homol_id = b13_.id LEFT JOIN basagri_periode_application b14_ ON b0_.periode_application_id = b14_.id LEFT JOIN basagri_distance_securite_riverain b15_ ON b0_.distance_securite_riverain_id = b15_.id LEFT JOIN basagri_culture_attractive b16_ ON b0_.culture_attractive_id = b16_.id LEFT JOIN basagri_class_usage b17_ ON b0_.id = b17_.uuid_id WHERE b0_.id IN (SELECT b18_.id FROM basagri_usage b18_ LEFT JOIN basagri_culture b19_ ON b18_.culture_id = b19_.id WHERE b19_.code IN (?, ?)) ORDER BY b0_.id ASC LIMIT 30 OFFSET 1740
Parameters:
[ "606" "211" ] |
| 3 | 11.63 ms |
SELECT b0_.id AS id_0, b0_.dose_maximale_homologuee AS dose_maximale_homologuee_1, b0_.znt_aquatique AS znt_aquatique_2, b0_.znt_aquatique_infos AS znt_aquatique_infos_3, b0_.znt_terrestre_cultivee AS znt_terrestre_cultivee_4, b0_.znt_terrestre_non_cultivee AS znt_terrestre_non_cultivee_5, b0_.nombre_application AS nombre_application_6, b0_.nombre_applications_infos AS nombre_applications_infos_7, b0_.information_avant_dar AS information_avant_dar_8, b0_.dar AS dar_9, b0_.information_apres_dar AS information_apres_dar_10, b0_.specification_usage AS specification_usage_11, b0_.date_debut_utilisation_usage AS date_debut_utilisation_usage_12, b0_.date_fin_utilisation_usage AS date_fin_utilisation_usage_13, b0_.mention_abeille AS mention_abeille_14, b0_.dre_animaux AS dre_animaux_15, b0_.commentaire_dre_animaux AS commentaire_dre_animaux_16, b0_.dose_recommandee_firme AS dose_recommandee_firme_17, b0_.commentaire_dose_recommandee AS commentaire_dose_recommandee_18, b0_.fractionnement AS fractionnement_19, b0_.commentaire_fractionnement AS commentaire_fractionnement_20, b0_.intervalle_application AS intervalle_application_21, b0_.commentaire_intervalle AS commentaire_intervalle_22, b0_.commentaire_znt_terrestre AS commentaire_znt_terrestre_23, b0_.fractionnement_dose_maximale AS fractionnement_dose_maximale_24, b0_.fractionnement_nombre_application_minimal AS fractionnement_nombre_application_minimal_25, b0_.fractionnement_nombre_application_maximal AS fractionnement_nombre_application_maximal_26, b0_.code_cible_ministere AS code_cible_ministere_27, b0_.uuid AS uuid_28, b0_.dose_minimale_homologuee AS dose_minimale_homologuee_29, b0_.delai_reentree_local AS delai_reentree_local_30, b0_.delai_reentree_plein_champ AS delai_reentree_plein_champ_31, b0_.date_debut_delai_grace AS date_debut_delai_grace_32, b0_.date_fin_delai_grace AS date_fin_delai_grace_33, b0_.date_debut_periode_application AS date_debut_periode_application_34, b0_.date_fin_periode_application AS date_fin_periode_application_35, b0_.date_fin_commercialisation AS date_fin_commercialisation_36, b0_.discriminant AS discriminant_37, b0_.usage_duplique AS usage_duplique_38, b0_.uuid_usage_duplique AS uuid_usage_duplique_39, b0_.utilisation_materiel_attenuation_derive AS utilisation_materiel_attenuation_derive_40, b0_.commentaire_distance_securite_riverain AS commentaire_distance_securite_riverain_41, b0_.valeur_znt_terrestre_cultivee AS valeur_znt_terrestre_cultivee_42, b0_.valeur_znt_terrestre_non_cultivee AS valeur_znt_terrestre_non_cultivee_43, b0_.intervalle_application_fractionnement AS intervalle_application_fractionnement_44, b0_.surface_maximale AS surface_maximale_45, b0_.dose_restrictive AS dose_restrictive_46, b0_.commentaire_dose_restrictive AS commentaire_dose_restrictive_47, b0_.reduction_derive AS reduction_derive_48, b0_.usage_derogatoire AS usage_derogatoire_49, b0_.duree_usage_derogatoire AS duree_usage_derogatoire_50, b1_.id AS id_51, b1_.code AS code_52, b1_.libelle AS libelle_53, b1_.code_ministere AS code_ministere_54, b2_.id AS id_55, b2_.code_produit AS code_produit_56, b2_.nom AS nom_57, b2_.amm_pcp AS amm_pcp_58, b2_.detail_conditionnement_usage_produit AS detail_conditionnement_usage_produit_59, b2_.conditionnement_usage_produit AS conditionnement_usage_produit_60, b2_.delai_reentree_locaux AS delai_reentree_locaux_61, b2_.delai_reentree_plein_champ AS delai_reentree_plein_champ_62, b2_.traitement_semence AS traitement_semence_63, b2_.produit_bio AS produit_bio_64, b2_.toxicite AS toxicite_65, b2_.indice_environnemental AS indice_environnemental_66, b2_.date_fin_utilisation AS date_fin_utilisation_67, b2_.date_fin_commercialisation AS date_fin_commercialisation_68, b2_.date_retrait_amm AS date_retrait_amm_69, b2_.pays AS pays_70, b2_.type_commercial AS type_commercial_71, b2_.code_produit_referent AS code_produit_referent_72, b2_.mention_jardin AS mention_jardin_73, b2_.cmr AS cmr_74, b2_.mention_avertissement AS mention_avertissement_75, b2_.produit_bio_controle AS produit_bio_controle_76, b2_.date_premier_enregistrement_phyto AS date_premier_enregistrement_phyto_77, b2_.gamme_produit AS gamme_produit_78, b2_.code_ufi AS code_ufi_79, b2_.code_ufi_non_concerne AS code_ufi_non_concerne_80, b2_.date_decommercialisation_firme AS date_decommercialisation_firme_81, b3_.id AS id_82, b3_.code AS code_83, b3_.libelle AS libelle_84, b4_.id AS id_85, b4_.code AS code_86, b4_.libelle AS libelle_87, b5_.id AS id_88, b5_.code AS code_89, b5_.libelle AS libelle_90, b6_.id AS id_91, b6_.code_agroedi AS code_agroedi_92, b6_.stade_bbch AS stade_bbch_93, b6_.libelle AS libelle_94, b6_.libelle_simplifie AS libelle_simplifie_95, b7_.id AS id_96, b7_.code_agroedi AS code_agroedi_97, b7_.stade_bbch AS stade_bbch_98, b7_.libelle AS libelle_99, b7_.libelle_simplifie AS libelle_simplifie_100, b8_.id AS id_101, b8_.code_agroedi AS code_agroedi_102, b8_.stade_bbch AS stade_bbch_103, b8_.libelle AS libelle_104, b8_.libelle_simplifie AS libelle_simplifie_105, b9_.id AS id_106, b9_.code AS code_107, b9_.libelle AS libelle_108, b10_.id AS id_109, b10_.code AS code_110, b10_.libelle AS libelle_111, b10_.valeur AS valeur_112, b11_.id AS id_113, b11_.code AS code_114, b11_.libelle AS libelle_115, b12_.id AS id_116, b12_.id_usage_ministere AS id_usage_ministere_117, b12_.code_usage_ministere AS code_usage_ministere_118, b12_.libelle_usage_ministere AS libelle_usage_ministere_119, b12_.code_cible_ministere AS code_cible_ministere_120, b12_.libelle_cible_ministere AS libelle_cible_ministere_121, b12_.classification AS classification_122, b13_.id AS id_123, b13_.code AS code_124, b13_.libelle AS libelle_125, b14_.id AS id_126, b14_.code AS code_127, b14_.libelle AS libelle_128, b15_.id AS id_129, b15_.code AS code_130, b15_.libelle AS libelle_131, b15_.valeur AS valeur_132, b16_.id AS id_133, b16_.code AS code_134, b16_.libelle AS libelle_135, b17_.id AS id_136, b0_.code_produit_id AS code_produit_id_137, b0_.culture_id AS culture_id_138, b0_.cible_id AS cible_id_139, b0_.traitement_id AS traitement_id_140, b0_.unite_dose_max_homol_id AS unite_dose_max_homol_id_141, b0_.stade_limite_bbch_id AS stade_limite_bbch_id_142, b0_.stade_bbch_debut_application_id AS stade_bbch_debut_application_id_143, b0_.stade_bbch_fin_application_id AS stade_bbch_fin_application_id_144, b0_.etalon_dose_recommandee_id AS etalon_dose_recommandee_id_145, b0_.zone_vegetalisee_id AS zone_vegetalisee_id_146, b0_.fractionnement_unite_dose_maximale_id AS fractionnement_unite_dose_maximale_id_147, b0_.id_usage_ministere_id AS id_usage_ministere_id_148, b0_.unite_dose_mini_homol_id AS unite_dose_mini_homol_id_149, b0_.periode_application_id AS periode_application_id_150, b0_.distance_securite_riverain_id AS distance_securite_riverain_id_151, b0_.culture_attractive_id AS culture_attractive_id_152, b0_.unite_surface_maximale_id AS unite_surface_maximale_id_153, b0_.unite_dose_restrictive_id AS unite_dose_restrictive_id_154, b0_.unite_reduction_derive_id AS unite_reduction_derive_id_155, b1_.code_profil_vegetatif_id AS code_profil_vegetatif_id_156, b2_.type_phyto_id AS type_phyto_id_157, b2_.formulation_id AS formulation_id_158, b2_.fournisseur_id AS fournisseur_id_159, b2_.detenteur_id AS detenteur_id_160, b2_.precurseur_id AS precurseur_id_161, b3_.code_type_cible_id AS code_type_cible_id_162, b3_.regroupement_cibles_id AS regroupement_cibles_id_163, b17_.code_produit_id AS code_produit_id_164, b17_.culture_id AS culture_id_165, b17_.cible_id AS cible_id_166, b17_.traitement_id AS traitement_id_167, b17_.code_phrase_classification_id AS code_phrase_classification_id_168, b17_.uuid_id AS uuid_id_169 FROM basagri_usage b0_ LEFT JOIN basagri_culture b1_ ON b0_.culture_id = b1_.id INNER JOIN basagri_phyto b2_ ON b0_.code_produit_id = b2_.id INNER JOIN basagri_cible b3_ ON b0_.cible_id = b3_.id INNER JOIN basagri_traitement b4_ ON b0_.traitement_id = b4_.id INNER JOIN basagri_unite_usage b5_ ON b0_.unite_dose_max_homol_id = b5_.id LEFT JOIN basagri_stade b6_ ON b0_.stade_limite_bbch_id = b6_.id LEFT JOIN basagri_stade b7_ ON b0_.stade_bbch_debut_application_id = b7_.id LEFT JOIN basagri_stade b8_ ON b0_.stade_bbch_fin_application_id = b8_.id LEFT JOIN basagri_unite_usage b9_ ON b0_.etalon_dose_recommandee_id = b9_.id LEFT JOIN basagri_zone_vegetalisee b10_ ON b0_.zone_vegetalisee_id = b10_.id LEFT JOIN basagri_unite_usage b11_ ON b0_.fractionnement_unite_dose_maximale_id = b11_.id INNER JOIN basagri_usage_ministere b12_ ON b0_.id_usage_ministere_id = b12_.id LEFT JOIN basagri_unite_usage b13_ ON b0_.unite_dose_mini_homol_id = b13_.id LEFT JOIN basagri_periode_application b14_ ON b0_.periode_application_id = b14_.id LEFT JOIN basagri_distance_securite_riverain b15_ ON b0_.distance_securite_riverain_id = b15_.id LEFT JOIN basagri_culture_attractive b16_ ON b0_.culture_attractive_id = b16_.id LEFT JOIN basagri_class_usage b17_ ON b0_.id = b17_.uuid_id WHERE b0_.id IN (SELECT b18_.id FROM basagri_usage b18_ LEFT JOIN basagri_culture b19_ ON b18_.culture_id = b19_.id WHERE b19_.code IN (?, ?)) AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.id ASC
Parameters:
[ "606" "211" 77805 77806 77826 78435 78446 78533 78534 78700 78702 78703 78812 78813 78991 78992 78993 79005 79019 79121 79122 79154 79155 79222 79274 79275 79276 79277 79278 79279 79434 79517 ] |
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.