Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.identifiant AS identifiant_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.email2 AS email2_6,
  t0.email3 AS email3_7,
  t0.has_opt_in_new_partenaire AS has_opt_in_new_partenaire_8,
  t0.has_opt_in_partenaire AS has_opt_in_partenaire_9,
  t0.is_actif AS is_actif_10,
  t0.last_login AS last_login_11,
  t0.reset_token AS reset_token_12,
  t0.profil AS profil_13,
  t0.is_article_specifique AS is_article_specifique_14,
  t0.is_article_favori AS is_article_favori_15,
  t0.montant_min_commande AS montant_min_commande_16,
  t0.is_autonome AS is_autonome_17,
  t0.nom AS nom_18,
  t0.prenom AS prenom_19,
  t0.centre_cout AS centre_cout_20,
  t0.date_inactivite_suppleant AS date_inactivite_suppleant_21,
  t0.imputation_produit AS imputation_produit_22,
  t0.montant_maximum_commande AS montant_maximum_commande_23,
  t0.montant_maximum_ligne_commande AS montant_maximum_ligne_commande_24,
  t0.date_inactivite_suppleant_approbateur AS date_inactivite_suppleant_approbateur_25,
  t0.date_debut_approbateur AS date_debut_approbateur_26,
  t0.date_fin_approbateur AS date_fin_approbateur_27,
  t0.montant_plancher_approbateur AS montant_plancher_approbateur_28,
  t0.is_approbateur_skipped AS is_approbateur_skipped_29,
  t0.is_delete AS is_delete_30,
  t0.date_derniere_commande AS date_derniere_commande_31,
  t0.is_consultant_commandes_service AS is_consultant_commandes_service_32,
  t0.date_signature_cgv AS date_signature_cgv_33,
  t0.client_id AS client_id_34,
  t35.id AS id_36,
  t35.ref_client AS ref_client_37,
  t35.date_limite_activation AS date_limite_activation_38,
  t35.mail AS mail_39,
  t35.tel_fixe AS tel_fixe_40,
  t35.mode_reglement AS mode_reglement_41,
  t35.video AS video_42,
  t35.is_actif AS is_actif_43,
  t35.chorus AS chorus_44,
  t35.societe AS societe_45,
  t35.observation AS observation_46,
  t35.message AS message_47,
  t35.rcs AS rcs_48,
  t35.tel_portable AS tel_portable_49,
  t35.has_affichage_ttc AS has_affichage_ttc_50,
  t35.has_client_export AS has_client_export_51,
  t35.acompte AS acompte_52,
  t35.montant_ht_frais_gestion AS montant_ht_frais_gestion_53,
  t35.is_demo AS is_demo_54,
  t35.budget_annuel AS budget_annuel_55,
  t35.dossier_ftp_commande AS dossier_ftp_commande_56,
  t35.is_brouillon AS is_brouillon_57,
  t35.restrict_bon_plan_access AS restrict_bon_plan_access_58,
  t35.restrict_essentiel_access AS restrict_essentiel_access_59,
  t35.restrict_promotions_access AS restrict_promotions_access_60,
  t35.restrict_destockage_access AS restrict_destockage_access_61,
  t35.reactualisation_automatique_prix_client_compte AS reactualisation_automatique_prix_client_compte_62,
  t35.jours_desactivation_da AS jours_desactivation_da_63,
  t35.created_at AS created_at_64,
  t35.is_client_get_orders_in_xml_format AS is_client_get_orders_in_xml_format_65,
  t35.certibiocide AS certibiocide_66,
  t35.abonnement AS abonnement_67,
  t35.joker AS joker_68,
  t35.devise_id AS devise_id_69,
  t35.site_id AS site_id_70,
  t35.mode_livaison_id AS mode_livaison_id_71,
  t35.frais_port_id AS frais_port_id_72,
  t35.commercial_id AS commercial_id_73,
  t35.profil_id AS profil_id_74,
  t35.client_branche_id AS client_branche_id_75,
  t0.approbateur_id AS approbateur_id_76,
  t0.valideur_id AS valideur_id_77,
  t0.suppleant_id AS suppleant_id_78,
  t0.devis_demande_achat_principal_id AS devis_demande_achat_principal_id_79,
  t0.adresse_livraison_defaut_id AS adresse_livraison_defaut_id_80,
  t0.adresse_facturation_defaut_id AS adresse_facturation_defaut_id_81,
  t0.suppleant_approbateur_id AS suppleant_approbateur_id_82
FROM
  utilisateur t0
  LEFT JOIN client t35 ON t0.client_id = t35.id
WHERE
  t0.identifiant = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.email2 AS email2_6, t0.email3 AS email3_7, t0.has_opt_in_new_partenaire AS has_opt_in_new_partenaire_8, t0.has_opt_in_partenaire AS has_opt_in_partenaire_9, t0.is_actif AS is_actif_10, t0.last_login AS last_login_11, t0.reset_token AS reset_token_12, t0.profil AS profil_13, t0.is_article_specifique AS is_article_specifique_14, t0.is_article_favori AS is_article_favori_15, t0.montant_min_commande AS montant_min_commande_16, t0.is_autonome AS is_autonome_17, t0.nom AS nom_18, t0.prenom AS prenom_19, t0.centre_cout AS centre_cout_20, t0.date_inactivite_suppleant AS date_inactivite_suppleant_21, t0.imputation_produit AS imputation_produit_22, t0.montant_maximum_commande AS montant_maximum_commande_23, t0.montant_maximum_ligne_commande AS montant_maximum_ligne_commande_24, t0.date_inactivite_suppleant_approbateur AS date_inactivite_suppleant_approbateur_25, t0.date_debut_approbateur AS date_debut_approbateur_26, t0.date_fin_approbateur AS date_fin_approbateur_27, t0.montant_plancher_approbateur AS montant_plancher_approbateur_28, t0.is_approbateur_skipped AS is_approbateur_skipped_29, t0.is_delete AS is_delete_30, t0.date_derniere_commande AS date_derniere_commande_31, t0.is_consultant_commandes_service AS is_consultant_commandes_service_32, t0.date_signature_cgv AS date_signature_cgv_33, t0.client_id AS client_id_34, t35.id AS id_36, t35.ref_client AS ref_client_37, t35.date_limite_activation AS date_limite_activation_38, t35.mail AS mail_39, t35.tel_fixe AS tel_fixe_40, t35.mode_reglement AS mode_reglement_41, t35.video AS video_42, t35.is_actif AS is_actif_43, t35.chorus AS chorus_44, t35.societe AS societe_45, t35.observation AS observation_46, t35.message AS message_47, t35.rcs AS rcs_48, t35.tel_portable AS tel_portable_49, t35.has_affichage_ttc AS has_affichage_ttc_50, t35.has_client_export AS has_client_export_51, t35.acompte AS acompte_52, t35.montant_ht_frais_gestion AS montant_ht_frais_gestion_53, t35.is_demo AS is_demo_54, t35.budget_annuel AS budget_annuel_55, t35.dossier_ftp_commande AS dossier_ftp_commande_56, t35.is_brouillon AS is_brouillon_57, t35.restrict_bon_plan_access AS restrict_bon_plan_access_58, t35.restrict_essentiel_access AS restrict_essentiel_access_59, t35.restrict_promotions_access AS restrict_promotions_access_60, t35.restrict_destockage_access AS restrict_destockage_access_61, t35.reactualisation_automatique_prix_client_compte AS reactualisation_automatique_prix_client_compte_62, t35.jours_desactivation_da AS jours_desactivation_da_63, t35.created_at AS created_at_64, t35.is_client_get_orders_in_xml_format AS is_client_get_orders_in_xml_format_65, t35.certibiocide AS certibiocide_66, t35.abonnement AS abonnement_67, t35.joker AS joker_68, t35.devise_id AS devise_id_69, t35.site_id AS site_id_70, t35.mode_livaison_id AS mode_livaison_id_71, t35.frais_port_id AS frais_port_id_72, t35.commercial_id AS commercial_id_73, t35.profil_id AS profil_id_74, t35.client_branche_id AS client_branche_id_75, t0.approbateur_id AS approbateur_id_76, t0.valideur_id AS valideur_id_77, t0.suppleant_id AS suppleant_id_78, t0.devis_demande_achat_principal_id AS devis_demande_achat_principal_id_79, t0.adresse_livraison_defaut_id AS adresse_livraison_defaut_id_80, t0.adresse_facturation_defaut_id AS adresse_facturation_defaut_id_81, t0.suppleant_approbateur_id AS suppleant_approbateur_id_82 FROM utilisateur t0 LEFT JOIN client t35 ON t0.client_id = t35.id WHERE t0.identifiant = 'contact@verfilco.fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code_article AS code_article_2,
  t0.code_produit AS code_produit_3,
  t0.designation AS designation_4,
  t0.descriptif AS descriptif_5,
  t0.caracteristique AS caracteristique_6,
  t0.reference_reach AS reference_reach_7,
  t0.num_cas AS num_cas_8,
  t0.formule_chimique_brute AS formule_chimique_brute_9,
  t0.formule_chimique_developpee AS formule_chimique_developpee_10,
  t0.certificat_analyse AS certificat_analyse_11,
  t0.classe_transport AS classe_transport_12,
  t0.ft AS ft_13,
  t0.fds AS fds_14,
  t0.densite AS densite_15,
  t0.quantite_stock_lyon AS quantite_stock_lyon_16,
  t0.quantite_stock_bordeaux AS quantite_stock_bordeaux_17,
  t0.unite_vente AS unite_vente_18,
  t0.information_technique AS information_technique_19,
  t0.fiche_technique_fabricant AS fiche_technique_fabricant_20,
  t0.image AS image_21,
  t0.date_ajout AS date_ajout_22,
  t0.date_modification AS date_modification_23,
  t0.ordre AS ordre_24,
  t0.is_actif AS is_actif_25,
  t0.is_multilabo AS is_multilabo_26,
  t0.is_chimique AS is_chimique_27,
  t0.recherche_synonyme AS recherche_synonyme_28,
  t0.is_recherche_selection_revol AS is_recherche_selection_revol_29,
  t0.code_article_pivot AS code_article_pivot_30,
  t0.code_onu AS code_onu_31,
  t0.groupe_emballage AS groupe_emballage_32,
  t0.temperature_transport AS temperature_transport_33,
  t0.code_nacres AS code_nacres_34,
  t0.quantite_limitee AS quantite_limitee_35,
  t0.nom_declaration AS nom_declaration_36,
  t0.purete AS purete_37,
  t0.article_type AS article_type_38,
  t0.code_fournisseur_article_pivot AS code_fournisseur_article_pivot_39,
  t0.code_produit_pivot AS code_produit_pivot_40,
  t0.prix_achat_ht_final_code_produit AS prix_achat_ht_final_code_produit_41,
  t0.poids AS poids_42,
  t0.coefficient AS coefficient_43,
  t0.date_limite_valid_prix AS date_limite_valid_prix_44,
  t0.eccn AS eccn_45,
  t0.temperature_de_stockage AS temperature_de_stockage_46,
  t0.point_eclair AS point_eclair_47,
  t0.echa AS echa_48,
  t0.contenant AS contenant_49,
  t0.alcool_pourcentage AS alcool_pourcentage_50,
  t0.code_article_remplacement AS code_article_remplacement_51,
  t0.frais_port AS frais_port_52,
  t0.frais_mini_commande AS frais_mini_commande_53,
  t0.frais_gestion AS frais_gestion_54,
  t0.groupe_drogue AS groupe_drogue_55,
  t0.precurseur_drogue AS precurseur_drogue_56,
  t0.ancien_code_article AS ancien_code_article_57,
  t0.code_article_remplacement2 AS code_article_remplacement2_58,
  t0.code_article_remplacement3 AS code_article_remplacement3_59,
  t0.cee_code_pays AS cee_code_pays_60,
  t0.cee_code_produit AS cee_code_produit_61,
  t0.date_modification_manuelle_prix_vente_article AS date_modification_manuelle_prix_vente_article_62,
  t0.date_modification_manuelle_prix_achat AS date_modification_manuelle_prix_achat_63,
  t0.date_reactualisation_import_prix_vente_article AS date_reactualisation_import_prix_vente_article_64,
  t0.date_reactualisation_import_prix_achat AS date_reactualisation_import_prix_achat_65,
  t0.prix_public_ht_produit AS prix_public_ht_produit_66,
  t0.remise_prix_public_ht_produit AS remise_prix_public_ht_produit_67,
  t0.prix_achat_net_ht_code_produit AS prix_achat_net_ht_code_produit_68,
  t0.prix_vente_unitaire_ht_code_article AS prix_vente_unitaire_ht_code_article_69,
  t0.prix_vente_ht_final_code_article AS prix_vente_ht_final_code_article_70,
  t0.code_produit_derniere_maj AS code_produit_derniere_maj_71,
  t0.composant_nomenclature AS composant_nomenclature_72,
  t0.quantite_composant_nomenclature AS quantite_composant_nomenclature_73,
  t0.sous_famille AS sous_famille_74,
  t0.categorie AS categorie_75,
  t0.classe AS classe_76,
  t0.nature AS nature_77,
  t0.collection AS collection_78,
  t0.is_stock_visible_front_office AS is_stock_visible_front_office_79,
  t0.quantite_stock_paris AS quantite_stock_paris_80,
  t0.ancien_code_produit AS ancien_code_produit_81,
  t0.code_article_fabricant AS code_article_fabricant_82,
  t0.is_article_specifique_creation AS is_article_specifique_creation_83,
  t0.is_mail_fournisseur_acreer_sent AS is_mail_fournisseur_acreer_sent_84,
  t0.is_delete AS is_delete_85,
  t0.prix_public_conseille AS prix_public_conseille_86,
  t0.explication_ppp AS explication_ppp_87,
  t0.commentaire_interne AS commentaire_interne_88,
  t0.is_marqueur_erp_bdx AS is_marqueur_erp_bdx_89,
  t0.is_marqueur_erp_lyon AS is_marqueur_erp_lyon_90,
  t0.num_contrat_fournisseur_adl AS num_contrat_fournisseur_adl_91,
  t0.num_contrat_fournisseur_revol AS num_contrat_fournisseur_revol_92,
  t0.prix_achat_devis_adl AS prix_achat_devis_adl_93,
  t0.prix_achat_devis_revol AS prix_achat_devis_revol_94,
  t0.date_fin_validite_devis_fournisseur_adl AS date_fin_validite_devis_fournisseur_adl_95,
  t0.date_fin_validite_devis_fournisseur_revol AS date_fin_validite_devis_fournisseur_revol_96,
  t0.date_modification_prix_achat_devis AS date_modification_prix_achat_devis_97,
  t0.precedent_prix_achat_net_ht AS precedent_prix_achat_net_ht_98,
  t0.precedent_prix_vente_net_ht AS precedent_prix_vente_net_ht_99,
  t0.unspsc AS unspsc_100,
  t0.date_mise_en_inactif AS date_mise_en_inactif_101,
  t0.taux_tva_id AS taux_tva_id_102,
  t0.site_id AS site_id_103,
  t0.fournisseur_id AS fournisseur_id_104,
  t0.qualite_produit_chimique_id AS qualite_produit_chimique_id_105,
  t0.famille_id AS famille_id_106,
  t0.article_pivot_id AS article_pivot_id_107,
  t0.famille_produit_id AS famille_produit_id_108,
  t0.conditionnement_id AS conditionnement_id_109,
  t110.id AS id_111,
  t110.suffixe_reference AS suffixe_reference_112,
  t110.lot_quantite AS lot_quantite_113,
  t110.lot_prix_ht AS lot_prix_ht_114,
  t110.lot_pourcentage_remise AS lot_pourcentage_remise_115,
  t110.is_actif AS is_actif_116,
  t110.is_delete AS is_delete_117,
  t110.produit_id AS produit_id_118,
  t0.marque_id AS marque_id_119,
  t120.id AS id_121,
  t120.designation AS designation_122,
  t120.produit_id AS produit_id_123,
  t120.pays_id AS pays_id_124,
  t0.createur_id AS createur_id_125
FROM
  produit t0
  LEFT JOIN produit_lot t110 ON t110.produit_id = t0.id
  LEFT JOIN produit_designation_langue t120 ON t120.produit_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code_article AS code_article_2, t0.code_produit AS code_produit_3, t0.designation AS designation_4, t0.descriptif AS descriptif_5, t0.caracteristique AS caracteristique_6, t0.reference_reach AS reference_reach_7, t0.num_cas AS num_cas_8, t0.formule_chimique_brute AS formule_chimique_brute_9, t0.formule_chimique_developpee AS formule_chimique_developpee_10, t0.certificat_analyse AS certificat_analyse_11, t0.classe_transport AS classe_transport_12, t0.ft AS ft_13, t0.fds AS fds_14, t0.densite AS densite_15, t0.quantite_stock_lyon AS quantite_stock_lyon_16, t0.quantite_stock_bordeaux AS quantite_stock_bordeaux_17, t0.unite_vente AS unite_vente_18, t0.information_technique AS information_technique_19, t0.fiche_technique_fabricant AS fiche_technique_fabricant_20, t0.image AS image_21, t0.date_ajout AS date_ajout_22, t0.date_modification AS date_modification_23, t0.ordre AS ordre_24, t0.is_actif AS is_actif_25, t0.is_multilabo AS is_multilabo_26, t0.is_chimique AS is_chimique_27, t0.recherche_synonyme AS recherche_synonyme_28, t0.is_recherche_selection_revol AS is_recherche_selection_revol_29, t0.code_article_pivot AS code_article_pivot_30, t0.code_onu AS code_onu_31, t0.groupe_emballage AS groupe_emballage_32, t0.temperature_transport AS temperature_transport_33, t0.code_nacres AS code_nacres_34, t0.quantite_limitee AS quantite_limitee_35, t0.nom_declaration AS nom_declaration_36, t0.purete AS purete_37, t0.article_type AS article_type_38, t0.code_fournisseur_article_pivot AS code_fournisseur_article_pivot_39, t0.code_produit_pivot AS code_produit_pivot_40, t0.prix_achat_ht_final_code_produit AS prix_achat_ht_final_code_produit_41, t0.poids AS poids_42, t0.coefficient AS coefficient_43, t0.date_limite_valid_prix AS date_limite_valid_prix_44, t0.eccn AS eccn_45, t0.temperature_de_stockage AS temperature_de_stockage_46, t0.point_eclair AS point_eclair_47, t0.echa AS echa_48, t0.contenant AS contenant_49, t0.alcool_pourcentage AS alcool_pourcentage_50, t0.code_article_remplacement AS code_article_remplacement_51, t0.frais_port AS frais_port_52, t0.frais_mini_commande AS frais_mini_commande_53, t0.frais_gestion AS frais_gestion_54, t0.groupe_drogue AS groupe_drogue_55, t0.precurseur_drogue AS precurseur_drogue_56, t0.ancien_code_article AS ancien_code_article_57, t0.code_article_remplacement2 AS code_article_remplacement2_58, t0.code_article_remplacement3 AS code_article_remplacement3_59, t0.cee_code_pays AS cee_code_pays_60, t0.cee_code_produit AS cee_code_produit_61, t0.date_modification_manuelle_prix_vente_article AS date_modification_manuelle_prix_vente_article_62, t0.date_modification_manuelle_prix_achat AS date_modification_manuelle_prix_achat_63, t0.date_reactualisation_import_prix_vente_article AS date_reactualisation_import_prix_vente_article_64, t0.date_reactualisation_import_prix_achat AS date_reactualisation_import_prix_achat_65, t0.prix_public_ht_produit AS prix_public_ht_produit_66, t0.remise_prix_public_ht_produit AS remise_prix_public_ht_produit_67, t0.prix_achat_net_ht_code_produit AS prix_achat_net_ht_code_produit_68, t0.prix_vente_unitaire_ht_code_article AS prix_vente_unitaire_ht_code_article_69, t0.prix_vente_ht_final_code_article AS prix_vente_ht_final_code_article_70, t0.code_produit_derniere_maj AS code_produit_derniere_maj_71, t0.composant_nomenclature AS composant_nomenclature_72, t0.quantite_composant_nomenclature AS quantite_composant_nomenclature_73, t0.sous_famille AS sous_famille_74, t0.categorie AS categorie_75, t0.classe AS classe_76, t0.nature AS nature_77, t0.collection AS collection_78, t0.is_stock_visible_front_office AS is_stock_visible_front_office_79, t0.quantite_stock_paris AS quantite_stock_paris_80, t0.ancien_code_produit AS ancien_code_produit_81, t0.code_article_fabricant AS code_article_fabricant_82, t0.is_article_specifique_creation AS is_article_specifique_creation_83, t0.is_mail_fournisseur_acreer_sent AS is_mail_fournisseur_acreer_sent_84, t0.is_delete AS is_delete_85, t0.prix_public_conseille AS prix_public_conseille_86, t0.explication_ppp AS explication_ppp_87, t0.commentaire_interne AS commentaire_interne_88, t0.is_marqueur_erp_bdx AS is_marqueur_erp_bdx_89, t0.is_marqueur_erp_lyon AS is_marqueur_erp_lyon_90, t0.num_contrat_fournisseur_adl AS num_contrat_fournisseur_adl_91, t0.num_contrat_fournisseur_revol AS num_contrat_fournisseur_revol_92, t0.prix_achat_devis_adl AS prix_achat_devis_adl_93, t0.prix_achat_devis_revol AS prix_achat_devis_revol_94, t0.date_fin_validite_devis_fournisseur_adl AS date_fin_validite_devis_fournisseur_adl_95, t0.date_fin_validite_devis_fournisseur_revol AS date_fin_validite_devis_fournisseur_revol_96, t0.date_modification_prix_achat_devis AS date_modification_prix_achat_devis_97, t0.precedent_prix_achat_net_ht AS precedent_prix_achat_net_ht_98, t0.precedent_prix_vente_net_ht AS precedent_prix_vente_net_ht_99, t0.unspsc AS unspsc_100, t0.date_mise_en_inactif AS date_mise_en_inactif_101, t0.taux_tva_id AS taux_tva_id_102, t0.site_id AS site_id_103, t0.fournisseur_id AS fournisseur_id_104, t0.qualite_produit_chimique_id AS qualite_produit_chimique_id_105, t0.famille_id AS famille_id_106, t0.article_pivot_id AS article_pivot_id_107, t0.famille_produit_id AS famille_produit_id_108, t0.conditionnement_id AS conditionnement_id_109, t110.id AS id_111, t110.suffixe_reference AS suffixe_reference_112, t110.lot_quantite AS lot_quantite_113, t110.lot_prix_ht AS lot_prix_ht_114, t110.lot_pourcentage_remise AS lot_pourcentage_remise_115, t110.is_actif AS is_actif_116, t110.is_delete AS is_delete_117, t110.produit_id AS produit_id_118, t0.marque_id AS marque_id_119, t120.id AS id_121, t120.designation AS designation_122, t120.produit_id AS produit_id_123, t120.pays_id AS pays_id_124, t0.createur_id AS createur_id_125 FROM produit t0 LEFT JOIN produit_lot t110 ON t110.produit_id = t0.id LEFT JOIN produit_designation_langue t120 ON t120.produit_id = t0.id WHERE t0.id = '3275';

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.contenu_html AS contenu_html_3,
  t0.image AS image_4,
  t0.fichier_pdf AS fichier_pdf_5,
  t0.fichier_html AS fichier_html_6,
  t0.is_actif AS is_actif_7,
  t0.lft AS lft_8,
  t0.lvl AS lvl_9,
  t0.rgt AS rgt_10,
  t0.date_modification AS date_modification_11,
  t0.icone AS icone_12,
  t0.is_stock_visible_fo AS is_stock_visible_fo_13,
  t0.icone_rose AS icone_rose_14,
  t0.parent_id AS parent_id_15,
  t0.famille_erp_id AS famille_erp_id_16
FROM
  famille_article t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.contenu_html AS contenu_html_3, t0.image AS image_4, t0.fichier_pdf AS fichier_pdf_5, t0.fichier_html AS fichier_html_6, t0.is_actif AS is_actif_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.date_modification AS date_modification_11, t0.icone AS icone_12, t0.is_stock_visible_fo AS is_stock_visible_fo_13, t0.icone_rose AS icone_rose_14, t0.parent_id AS parent_id_15, t0.famille_erp_id AS famille_erp_id_16 FROM famille_article t0 WHERE t0.id = 162;

SELECT
  c0_.id AS id_0
FROM
  client_catalogue_exclu c0_
  LEFT JOIN famille_article f1_ ON c0_.famille_id = f1_.id
WHERE
  (
    f1_.lft <= ?
    AND f1_.rgt >= ?
  )
  AND c0_.client_id = ?

SELECT c0_.id AS id_0 FROM client_catalogue_exclu c0_ LEFT JOIN famille_article f1_ ON c0_.famille_id = f1_.id WHERE (f1_.lft <= 1368 AND f1_.rgt >= 1369) AND c0_.client_id = 3112;

SELECT
  t0.id AS id_1,
  t0.client_id AS client_id_2,
  t0.fournisseur_id AS fournisseur_id_3,
  t4.id AS id_5,
  t4.libelle AS libelle_6,
  t4.code_fournisseur AS code_fournisseur_7,
  t4.pourcentage_remise AS pourcentage_remise_8,
  t4.is_fabriquant AS is_fabriquant_9,
  t4.is_marque AS is_marque_10,
  t4.is_actif AS is_actif_11,
  t4.is_catalogue AS is_catalogue_12,
  t4.reference_catalogue AS reference_catalogue_13,
  t4.fichier AS fichier_14,
  t4.image AS image_15,
  t4.ordre AS ordre_16,
  t4.date_modification AS date_modification_17,
  t4.is_visible_catalogue_fournisseur AS is_visible_catalogue_fournisseur_18,
  t4.contenu_html AS contenu_html_19,
  t4.adresse AS adresse_20,
  t4.complement_adresse AS complement_adresse_21,
  t4.code_postal AS code_postal_22,
  t4.ville AS ville_23,
  t4.telephone AS telephone_24,
  t4.mail AS mail_25,
  t4.frais_port AS frais_port_26,
  t4.minimum_commande_fournisseur AS minimum_commande_fournisseur_27,
  t4.has_produit_recherche_revol AS has_produit_recherche_revol_28,
  t4.pays_id AS pays_id_29
FROM
  client_fournisseur_exclu t0
  LEFT JOIN fournisseur t4 ON t0.fournisseur_id = t4.id
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.client_id AS client_id_2, t0.fournisseur_id AS fournisseur_id_3, t4.id AS id_5, t4.libelle AS libelle_6, t4.code_fournisseur AS code_fournisseur_7, t4.pourcentage_remise AS pourcentage_remise_8, t4.is_fabriquant AS is_fabriquant_9, t4.is_marque AS is_marque_10, t4.is_actif AS is_actif_11, t4.is_catalogue AS is_catalogue_12, t4.reference_catalogue AS reference_catalogue_13, t4.fichier AS fichier_14, t4.image AS image_15, t4.ordre AS ordre_16, t4.date_modification AS date_modification_17, t4.is_visible_catalogue_fournisseur AS is_visible_catalogue_fournisseur_18, t4.contenu_html AS contenu_html_19, t4.adresse AS adresse_20, t4.complement_adresse AS complement_adresse_21, t4.code_postal AS code_postal_22, t4.ville AS ville_23, t4.telephone AS telephone_24, t4.mail AS mail_25, t4.frais_port AS frais_port_26, t4.minimum_commande_fournisseur AS minimum_commande_fournisseur_27, t4.has_produit_recherche_revol AS has_produit_recherche_revol_28, t4.pays_id AS pays_id_29 FROM client_fournisseur_exclu t0 LEFT JOIN fournisseur t4 ON t0.fournisseur_id = t4.id WHERE t0.client_id = 3112;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code_fournisseur AS code_fournisseur_3,
  t0.pourcentage_remise AS pourcentage_remise_4,
  t0.is_fabriquant AS is_fabriquant_5,
  t0.is_marque AS is_marque_6,
  t0.is_actif AS is_actif_7,
  t0.is_catalogue AS is_catalogue_8,
  t0.reference_catalogue AS reference_catalogue_9,
  t0.fichier AS fichier_10,
  t0.image AS image_11,
  t0.ordre AS ordre_12,
  t0.date_modification AS date_modification_13,
  t0.is_visible_catalogue_fournisseur AS is_visible_catalogue_fournisseur_14,
  t0.contenu_html AS contenu_html_15,
  t0.adresse AS adresse_16,
  t0.complement_adresse AS complement_adresse_17,
  t0.code_postal AS code_postal_18,
  t0.ville AS ville_19,
  t0.telephone AS telephone_20,
  t0.mail AS mail_21,
  t0.frais_port AS frais_port_22,
  t0.minimum_commande_fournisseur AS minimum_commande_fournisseur_23,
  t0.has_produit_recherche_revol AS has_produit_recherche_revol_24,
  t0.pays_id AS pays_id_25
FROM
  fournisseur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code_fournisseur AS code_fournisseur_3, t0.pourcentage_remise AS pourcentage_remise_4, t0.is_fabriquant AS is_fabriquant_5, t0.is_marque AS is_marque_6, t0.is_actif AS is_actif_7, t0.is_catalogue AS is_catalogue_8, t0.reference_catalogue AS reference_catalogue_9, t0.fichier AS fichier_10, t0.image AS image_11, t0.ordre AS ordre_12, t0.date_modification AS date_modification_13, t0.is_visible_catalogue_fournisseur AS is_visible_catalogue_fournisseur_14, t0.contenu_html AS contenu_html_15, t0.adresse AS adresse_16, t0.complement_adresse AS complement_adresse_17, t0.code_postal AS code_postal_18, t0.ville AS ville_19, t0.telephone AS telephone_20, t0.mail AS mail_21, t0.frais_port AS frais_port_22, t0.minimum_commande_fournisseur AS minimum_commande_fournisseur_23, t0.has_produit_recherche_revol AS has_produit_recherche_revol_24, t0.pays_id AS pays_id_25 FROM fournisseur t0 WHERE t0.id = 12;

SELECT
  c0_.id AS id_0
FROM
  client_catalogue_exclu c0_
  LEFT JOIN famille_article f1_ ON c0_.famille_id = f1_.id
WHERE
  (
    f1_.lft <= ?
    AND f1_.rgt >= ?
  )
  AND c0_.client_id = ?

SELECT c0_.id AS id_0 FROM client_catalogue_exclu c0_ LEFT JOIN famille_article f1_ ON c0_.famille_id = f1_.id WHERE (f1_.lft <= 1368 AND f1_.rgt >= 1369) AND c0_.client_id = 3112;

SELECT
  t0.id AS id_1,
  t0.ordre AS ordre_2,
  t0.produit_parent_id AS produit_parent_id_3,
  t0.produit_enfant_id AS produit_enfant_id_4
FROM
  produit_association t0
WHERE
  t0.produit_parent_id = ?

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_parent_id AS produit_parent_id_3, t0.produit_enfant_id AS produit_enfant_id_4 FROM produit_association t0 WHERE t0.produit_parent_id = 3275;

SELECT
  t0.id AS id_1,
  t0.date_debut_affichage AS date_debut_affichage_2,
  t0.date_fin_affichage AS date_fin_affichage_3,
  t0.pourcentage_remise AS pourcentage_remise_4,
  t0.ordre AS ordre_5,
  t0.affichage_remises AS affichage_remises_6,
  t0.evenement_id AS evenement_id_7,
  t8.id AS id_9,
  t8.code AS code_10,
  t8.libelle AS libelle_11,
  t8.contenu_html AS contenu_html_12,
  t8.date_creation AS date_creation_13,
  t8.date_debut_affichage AS date_debut_affichage_14,
  t8.date_fin_affichage AS date_fin_affichage_15,
  t8.ordre AS ordre_16,
  t8.is_actif AS is_actif_17,
  t8.image AS image_18,
  t8.date_modification AS date_modification_19,
  t8.type AS type_20,
  t8.is_stock_visible_fo AS is_stock_visible_fo_21,
  t8.has_produit_recherche_revol AS has_produit_recherche_revol_22,
  t8.document AS document_23,
  t8.affichage_remises AS affichage_remises_24,
  t8.site_id AS site_id_25,
  t0.produit_id AS produit_id_26,
  t0.famille_evenement_id AS famille_evenement_id_27
FROM
  evenement_produit t0
  INNER JOIN evenement t8 ON t0.evenement_id = t8.id
WHERE
  t0.produit_id = ?

SELECT t0.id AS id_1, t0.date_debut_affichage AS date_debut_affichage_2, t0.date_fin_affichage AS date_fin_affichage_3, t0.pourcentage_remise AS pourcentage_remise_4, t0.ordre AS ordre_5, t0.affichage_remises AS affichage_remises_6, t0.evenement_id AS evenement_id_7, t8.id AS id_9, t8.code AS code_10, t8.libelle AS libelle_11, t8.contenu_html AS contenu_html_12, t8.date_creation AS date_creation_13, t8.date_debut_affichage AS date_debut_affichage_14, t8.date_fin_affichage AS date_fin_affichage_15, t8.ordre AS ordre_16, t8.is_actif AS is_actif_17, t8.image AS image_18, t8.date_modification AS date_modification_19, t8.type AS type_20, t8.is_stock_visible_fo AS is_stock_visible_fo_21, t8.has_produit_recherche_revol AS has_produit_recherche_revol_22, t8.document AS document_23, t8.affichage_remises AS affichage_remises_24, t8.site_id AS site_id_25, t0.produit_id AS produit_id_26, t0.famille_evenement_id AS famille_evenement_id_27 FROM evenement_produit t0 INNER JOIN evenement t8 ON t0.evenement_id = t8.id WHERE t0.produit_id = 3275;

SELECT
  t0.id AS id_1,
  t0.client_id AS client_id_2,
  t0.famille_id AS famille_id_3,
  t4.id AS id_5,
  t4.libelle AS libelle_6,
  t4.contenu_html AS contenu_html_7,
  t4.image AS image_8,
  t4.fichier_pdf AS fichier_pdf_9,
  t4.fichier_html AS fichier_html_10,
  t4.is_actif AS is_actif_11,
  t4.lft AS lft_12,
  t4.lvl AS lvl_13,
  t4.rgt AS rgt_14,
  t4.date_modification AS date_modification_15,
  t4.icone AS icone_16,
  t4.is_stock_visible_fo AS is_stock_visible_fo_17,
  t4.icone_rose AS icone_rose_18,
  t4.parent_id AS parent_id_19,
  t4.famille_erp_id AS famille_erp_id_20
FROM
  client_catalogue_exclu t0
  LEFT JOIN famille_article t4 ON t0.famille_id = t4.id
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.client_id AS client_id_2, t0.famille_id AS famille_id_3, t4.id AS id_5, t4.libelle AS libelle_6, t4.contenu_html AS contenu_html_7, t4.image AS image_8, t4.fichier_pdf AS fichier_pdf_9, t4.fichier_html AS fichier_html_10, t4.is_actif AS is_actif_11, t4.lft AS lft_12, t4.lvl AS lvl_13, t4.rgt AS rgt_14, t4.date_modification AS date_modification_15, t4.icone AS icone_16, t4.is_stock_visible_fo AS is_stock_visible_fo_17, t4.icone_rose AS icone_rose_18, t4.parent_id AS parent_id_19, t4.famille_erp_id AS famille_erp_id_20 FROM client_catalogue_exclu t0 LEFT JOIN famille_article t4 ON t0.famille_id = t4.id WHERE t0.client_id = 3112;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.code_article AS code_article_1,
  p0_.code_produit AS code_produit_2,
  p0_.designation AS designation_3,
  p0_.descriptif AS descriptif_4,
  p0_.caracteristique AS caracteristique_5,
  p0_.reference_reach AS reference_reach_6,
  p0_.num_cas AS num_cas_7,
  p0_.formule_chimique_brute AS formule_chimique_brute_8,
  p0_.formule_chimique_developpee AS formule_chimique_developpee_9,
  p0_.certificat_analyse AS certificat_analyse_10,
  p0_.classe_transport AS classe_transport_11,
  p0_.ft AS ft_12,
  p0_.fds AS fds_13,
  p0_.densite AS densite_14,
  p0_.quantite_stock_lyon AS quantite_stock_lyon_15,
  p0_.quantite_stock_bordeaux AS quantite_stock_bordeaux_16,
  p0_.unite_vente AS unite_vente_17,
  p0_.information_technique AS information_technique_18,
  p0_.fiche_technique_fabricant AS fiche_technique_fabricant_19,
  p0_.image AS image_20,
  p0_.date_ajout AS date_ajout_21,
  p0_.date_modification AS date_modification_22,
  p0_.ordre AS ordre_23,
  p0_.is_actif AS is_actif_24,
  p0_.is_multilabo AS is_multilabo_25,
  p0_.is_chimique AS is_chimique_26,
  p0_.recherche_synonyme AS recherche_synonyme_27,
  p0_.is_recherche_selection_revol AS is_recherche_selection_revol_28,
  p0_.code_article_pivot AS code_article_pivot_29,
  p0_.code_onu AS code_onu_30,
  p0_.groupe_emballage AS groupe_emballage_31,
  p0_.temperature_transport AS temperature_transport_32,
  p0_.code_nacres AS code_nacres_33,
  p0_.quantite_limitee AS quantite_limitee_34,
  p0_.nom_declaration AS nom_declaration_35,
  p0_.purete AS purete_36,
  p0_.article_type AS article_type_37,
  p0_.code_fournisseur_article_pivot AS code_fournisseur_article_pivot_38,
  p0_.code_produit_pivot AS code_produit_pivot_39,
  p0_.prix_achat_ht_final_code_produit AS prix_achat_ht_final_code_produit_40,
  p0_.poids AS poids_41,
  p0_.coefficient AS coefficient_42,
  p0_.date_limite_valid_prix AS date_limite_valid_prix_43,
  p0_.eccn AS eccn_44,
  p0_.temperature_de_stockage AS temperature_de_stockage_45,
  p0_.point_eclair AS point_eclair_46,
  p0_.echa AS echa_47,
  p0_.contenant AS contenant_48,
  p0_.alcool_pourcentage AS alcool_pourcentage_49,
  p0_.code_article_remplacement AS code_article_remplacement_50,
  p0_.frais_port AS frais_port_51,
  p0_.frais_mini_commande AS frais_mini_commande_52,
  p0_.frais_gestion AS frais_gestion_53,
  p0_.groupe_drogue AS groupe_drogue_54,
  p0_.precurseur_drogue AS precurseur_drogue_55,
  p0_.ancien_code_article AS ancien_code_article_56,
  p0_.code_article_remplacement2 AS code_article_remplacement2_57,
  p0_.code_article_remplacement3 AS code_article_remplacement3_58,
  p0_.cee_code_pays AS cee_code_pays_59,
  p0_.cee_code_produit AS cee_code_produit_60,
  p0_.date_modification_manuelle_prix_vente_article AS date_modification_manuelle_prix_vente_article_61,
  p0_.date_modification_manuelle_prix_achat AS date_modification_manuelle_prix_achat_62,
  p0_.date_reactualisation_import_prix_vente_article AS date_reactualisation_import_prix_vente_article_63,
  p0_.date_reactualisation_import_prix_achat AS date_reactualisation_import_prix_achat_64,
  p0_.prix_public_ht_produit AS prix_public_ht_produit_65,
  p0_.remise_prix_public_ht_produit AS remise_prix_public_ht_produit_66,
  p0_.prix_achat_net_ht_code_produit AS prix_achat_net_ht_code_produit_67,
  p0_.prix_vente_unitaire_ht_code_article AS prix_vente_unitaire_ht_code_article_68,
  p0_.prix_vente_ht_final_code_article AS prix_vente_ht_final_code_article_69,
  p0_.code_produit_derniere_maj AS code_produit_derniere_maj_70,
  p0_.composant_nomenclature AS composant_nomenclature_71,
  p0_.quantite_composant_nomenclature AS quantite_composant_nomenclature_72,
  p0_.sous_famille AS sous_famille_73,
  p0_.categorie AS categorie_74,
  p0_.classe AS classe_75,
  p0_.nature AS nature_76,
  p0_.collection AS collection_77,
  p0_.is_stock_visible_front_office AS is_stock_visible_front_office_78,
  p0_.quantite_stock_paris AS quantite_stock_paris_79,
  p0_.ancien_code_produit AS ancien_code_produit_80,
  p0_.code_article_fabricant AS code_article_fabricant_81,
  p0_.is_article_specifique_creation AS is_article_specifique_creation_82,
  p0_.is_mail_fournisseur_acreer_sent AS is_mail_fournisseur_acreer_sent_83,
  p0_.is_delete AS is_delete_84,
  p0_.prix_public_conseille AS prix_public_conseille_85,
  p0_.explication_ppp AS explication_ppp_86,
  p0_.commentaire_interne AS commentaire_interne_87,
  p0_.is_marqueur_erp_bdx AS is_marqueur_erp_bdx_88,
  p0_.is_marqueur_erp_lyon AS is_marqueur_erp_lyon_89,
  p0_.num_contrat_fournisseur_adl AS num_contrat_fournisseur_adl_90,
  p0_.num_contrat_fournisseur_revol AS num_contrat_fournisseur_revol_91,
  p0_.prix_achat_devis_adl AS prix_achat_devis_adl_92,
  p0_.prix_achat_devis_revol AS prix_achat_devis_revol_93,
  p0_.date_fin_validite_devis_fournisseur_adl AS date_fin_validite_devis_fournisseur_adl_94,
  p0_.date_fin_validite_devis_fournisseur_revol AS date_fin_validite_devis_fournisseur_revol_95,
  p0_.date_modification_prix_achat_devis AS date_modification_prix_achat_devis_96,
  p0_.precedent_prix_achat_net_ht AS precedent_prix_achat_net_ht_97,
  p0_.precedent_prix_vente_net_ht AS precedent_prix_vente_net_ht_98,
  p0_.unspsc AS unspsc_99,
  p0_.date_mise_en_inactif AS date_mise_en_inactif_100,
  f1_.id AS id_101,
  f1_.libelle AS libelle_102,
  f1_.contenu_html AS contenu_html_103,
  f1_.image AS image_104,
  f1_.fichier_pdf AS fichier_pdf_105,
  f1_.fichier_html AS fichier_html_106,
  f1_.is_actif AS is_actif_107,
  f1_.lft AS lft_108,
  f1_.lvl AS lvl_109,
  f1_.rgt AS rgt_110,
  f1_.date_modification AS date_modification_111,
  f1_.icone AS icone_112,
  f1_.is_stock_visible_fo AS is_stock_visible_fo_113,
  f1_.icone_rose AS icone_rose_114,
  p2_.id AS id_115,
  p2_.suffixe_reference AS suffixe_reference_116,
  p2_.lot_quantite AS lot_quantite_117,
  p2_.lot_prix_ht AS lot_prix_ht_118,
  p2_.lot_pourcentage_remise AS lot_pourcentage_remise_119,
  p2_.is_actif AS is_actif_120,
  p2_.is_delete AS is_delete_121,
  p3_.id AS id_122,
  p3_.image AS image_123,
  p3_.ordre AS ordre_124,
  p3_.date_modification AS date_modification_125,
  p0_.taux_tva_id AS taux_tva_id_126,
  p0_.site_id AS site_id_127,
  p0_.fournisseur_id AS fournisseur_id_128,
  p0_.qualite_produit_chimique_id AS qualite_produit_chimique_id_129,
  p0_.famille_id AS famille_id_130,
  p0_.article_pivot_id AS article_pivot_id_131,
  p0_.famille_produit_id AS famille_produit_id_132,
  p0_.conditionnement_id AS conditionnement_id_133,
  p0_.marque_id AS marque_id_134,
  p0_.createur_id AS createur_id_135,
  f1_.parent_id AS parent_id_136,
  f1_.famille_erp_id AS famille_erp_id_137,
  p2_.produit_id AS produit_id_138,
  p3_.produit_id AS produit_id_139
FROM
  produit p0_
  LEFT JOIN fournisseur f4_ ON p0_.fournisseur_id = f4_.id
  LEFT JOIN famille_article f1_ ON p0_.famille_id = f1_.id
  LEFT JOIN produit_lot p2_ ON p0_.id = p2_.produit_id
  LEFT JOIN produit_image p3_ ON p0_.id = p3_.produit_id
WHERE
  p0_.id <> ?
  AND p0_.num_cas = ?
  AND p0_.is_actif = 1
  AND f1_.is_actif = 1
  AND p0_.is_actif = 1
  AND f4_.is_actif = 1
LIMIT
  4