Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.string_value AS string_value_3,
  t0.text_value AS text_value_4,
  t0.array_value AS array_value_5,
  t0.int_value AS int_value_6,
  t0.float_value AS float_value_7,
  t0.type AS type_8
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.string_value AS string_value_3, t0.text_value AS text_value_4, t0.array_value AS array_value_5, t0.int_value AS int_value_6, t0.float_value AS float_value_7, t0.type AS type_8 FROM configuration t0 WHERE t0.name = 'etl_url' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.string_value AS string_value_3,
  t0.text_value AS text_value_4,
  t0.array_value AS array_value_5,
  t0.int_value AS int_value_6,
  t0.float_value AS float_value_7,
  t0.type AS type_8
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.string_value AS string_value_3, t0.text_value AS text_value_4, t0.array_value AS array_value_5, t0.int_value AS int_value_6, t0.float_value AS float_value_7, t0.type AS type_8 FROM configuration t0 WHERE t0.name = '' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.string_value AS string_value_3,
  t0.text_value AS text_value_4,
  t0.array_value AS array_value_5,
  t0.int_value AS int_value_6,
  t0.float_value AS float_value_7,
  t0.type AS type_8
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.string_value AS string_value_3, t0.text_value AS text_value_4, t0.array_value AS array_value_5, t0.int_value AS int_value_6, t0.float_value AS float_value_7, t0.type AS type_8 FROM configuration t0 WHERE t0.name = 'pimcore_url' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.trigramme AS trigramme_3,
  t0.url AS url_4,
  t0.remote_folder AS remote_folder_5,
  t0.is_m2 AS is_m2_6,
  t0.is_active AS is_active_7,
  t0.is_aws AS is_aws_8,
  t0.is_apple_pay AS is_apple_pay_9,
  t0.is_pimcore AS is_pimcore_10,
  t0.max_variance AS max_variance_11,
  t0.is_order_import_enabled AS is_order_import_enabled_12,
  t0.is_image_import_enabled AS is_image_import_enabled_13,
  t0.is_promo_enable AS is_promo_enable_14,
  t0.mail AS mail_15,
  t0.is_prod AS is_prod_16,
  t0.force_image_import AS force_image_import_17,
  t0.aws_host AS aws_host_18,
  t0.aws_user_bdd AS aws_user_bdd_19,
  t0.aws_db_pass AS aws_db_pass_20,
  t0.updated_at_api AS updated_at_api_21,
  t22.id AS id_23,
  t22.erp_active_products AS erp_active_products_24,
  t22.pim_active_products AS pim_active_products_25,
  t22.website_active_products AS website_active_products_26,
  t22.erp_backorder_products AS erp_backorder_products_27,
  t22.website_backorder_products AS website_backorder_products_28,
  t22.website_id AS website_id_29
FROM
  website t0
  LEFT JOIN website_statistics t22 ON t22.website_id = t0.id
WHERE
  t0.trigramme = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.trigramme AS trigramme_3, t0.url AS url_4, t0.remote_folder AS remote_folder_5, t0.is_m2 AS is_m2_6, t0.is_active AS is_active_7, t0.is_aws AS is_aws_8, t0.is_apple_pay AS is_apple_pay_9, t0.is_pimcore AS is_pimcore_10, t0.max_variance AS max_variance_11, t0.is_order_import_enabled AS is_order_import_enabled_12, t0.is_image_import_enabled AS is_image_import_enabled_13, t0.is_promo_enable AS is_promo_enable_14, t0.mail AS mail_15, t0.is_prod AS is_prod_16, t0.force_image_import AS force_image_import_17, t0.aws_host AS aws_host_18, t0.aws_user_bdd AS aws_user_bdd_19, t0.aws_db_pass AS aws_db_pass_20, t0.updated_at_api AS updated_at_api_21, t22.id AS id_23, t22.erp_active_products AS erp_active_products_24, t22.pim_active_products AS pim_active_products_25, t22.website_active_products AS website_active_products_26, t22.erp_backorder_products AS erp_backorder_products_27, t22.website_backorder_products AS website_backorder_products_28, t22.website_id AS website_id_29 FROM website t0 LEFT JOIN website_statistics t22 ON t22.website_id = t0.id WHERE t0.trigramme = 'EXS' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5 FROM user t0 WHERE t0.username = 'website' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.trigramme AS trigramme_3,
  t0.url AS url_4,
  t0.remote_folder AS remote_folder_5,
  t0.is_m2 AS is_m2_6,
  t0.is_active AS is_active_7,
  t0.is_aws AS is_aws_8,
  t0.is_apple_pay AS is_apple_pay_9,
  t0.is_pimcore AS is_pimcore_10,
  t0.max_variance AS max_variance_11,
  t0.is_order_import_enabled AS is_order_import_enabled_12,
  t0.is_image_import_enabled AS is_image_import_enabled_13,
  t0.is_promo_enable AS is_promo_enable_14,
  t0.mail AS mail_15,
  t0.is_prod AS is_prod_16,
  t0.force_image_import AS force_image_import_17,
  t0.aws_host AS aws_host_18,
  t0.aws_user_bdd AS aws_user_bdd_19,
  t0.aws_db_pass AS aws_db_pass_20,
  t0.updated_at_api AS updated_at_api_21,
  t22.id AS id_23,
  t22.erp_active_products AS erp_active_products_24,
  t22.pim_active_products AS pim_active_products_25,
  t22.website_active_products AS website_active_products_26,
  t22.erp_backorder_products AS erp_backorder_products_27,
  t22.website_backorder_products AS website_backorder_products_28,
  t22.website_id AS website_id_29
FROM
  website t0
  LEFT JOIN website_statistics t22 ON t22.website_id = t0.id
WHERE
  t0.trigramme = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.trigramme AS trigramme_3, t0.url AS url_4, t0.remote_folder AS remote_folder_5, t0.is_m2 AS is_m2_6, t0.is_active AS is_active_7, t0.is_aws AS is_aws_8, t0.is_apple_pay AS is_apple_pay_9, t0.is_pimcore AS is_pimcore_10, t0.max_variance AS max_variance_11, t0.is_order_import_enabled AS is_order_import_enabled_12, t0.is_image_import_enabled AS is_image_import_enabled_13, t0.is_promo_enable AS is_promo_enable_14, t0.mail AS mail_15, t0.is_prod AS is_prod_16, t0.force_image_import AS force_image_import_17, t0.aws_host AS aws_host_18, t0.aws_user_bdd AS aws_user_bdd_19, t0.aws_db_pass AS aws_db_pass_20, t0.updated_at_api AS updated_at_api_21, t22.id AS id_23, t22.erp_active_products AS erp_active_products_24, t22.pim_active_products AS pim_active_products_25, t22.website_active_products AS website_active_products_26, t22.erp_backorder_products AS erp_backorder_products_27, t22.website_backorder_products AS website_backorder_products_28, t22.website_id AS website_id_29 FROM website t0 LEFT JOIN website_statistics t22 ON t22.website_id = t0.id WHERE t0.trigramme = 'EXS' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code_article AS code_article_2,
  t0.reference_parent AS reference_parent_3,
  t0.invisible_ecommerce AS invisible_ecommerce_4,
  t0.categorie_web AS categorie_web_5,
  t0.univers AS univers_6,
  t0.attribute_set AS attribute_set_7,
  t0.super_attributes AS super_attributes_8,
  t0.localizedfields AS localizedfields_9,
  t0.affectation_desc_complem AS affectation_desc_complem_10,
  t0.image_principale AS image_principale_11,
  t0.images_secondaires AS images_secondaires_12,
  t0.image_personnalisation AS image_personnalisation_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.children AS children_16,
  t0.attributes AS attributes_17,
  t0.type_de_produit AS type_de_produit_18,
  t0.attribute_option_ids AS attribute_option_ids_19,
  t0.main_img_hash AS main_img_hash_20,
  t0.additional_img_hash AS additional_img_hash_21,
  t0.stock_tag AS stock_tag_22,
  t0.status AS status_23,
  t0.updated_at_api AS updated_at_api_24,
  t25.id AS id_26,
  t25.sku AS sku_27,
  t25.ref_parent AS ref_parent_28,
  t25.ref_fournisseur AS ref_fournisseur_29,
  t25.libelle AS libelle_30,
  t25.activites AS activites_31,
  t25.activites_label AS activites_label_32,
  t25.univers_famille AS univers_famille_33,
  t25.univers_famille_label AS univers_famille_label_34,
  t25.famille AS famille_35,
  t25.famille_label AS famille_label_36,
  t25.sous_famille1 AS sous_famille1_37,
  t25.sous_famille1_label AS sous_famille1_label_38,
  t25.sous_famille2 AS sous_famille2_39,
  t25.sous_famille2_label AS sous_famille2_label_40,
  t25.boutique AS boutique_41,
  t25.marque AS marque_42,
  t25.marque_label AS marque_label_43,
  t25.couleur AS couleur_44,
  t25.couleur_label AS couleur_label_45,
  t25.taille AS taille_46,
  t25.taille_label AS taille_label_47,
  t25.collection AS collection_48,
  t25.pvht AS pvht_49,
  t25.prix_achat AS prix_achat_50,
  t25.tva AS tva_51,
  t25.poids AS poids_52,
  t25.volume AS volume_53,
  t25.methode_appro AS methode_appro_54,
  t25.methode_appro_label AS methode_appro_label_55,
  t25.invisible_web AS invisible_web_56,
  t25.epuise_cegid AS epuise_cegid_57,
  t25.ean AS ean_58,
  t25.min_commande_vente AS min_commande_vente_59,
  t25.delai_appro AS delai_appro_60,
  t25.delai_appro_constate AS delai_appro_constate_61,
  t25.created_at AS created_at_62,
  t25.updated_at AS updated_at_63,
  t25.date_modif_stock AS date_modif_stock_64,
  t25.quantite AS quantite_65,
  t25.hors_gabarit AS hors_gabarit_66,
  t25.famille_logistique AS famille_logistique_67,
  t25.dpav AS dpav_68,
  t25.soumis3ds AS soumis3ds_69,
  t25.depot_principal AS depot_principal_70,
  t25.type_article AS type_article_71,
  t25.famille_tarif AS famille_tarif_72,
  t25.marketplace AS marketplace_73,
  t25.ferme_cegid AS ferme_cegid_74,
  t25.ferme_web AS ferme_web_75,
  t25.epuise_frn AS epuise_frn_76,
  t25.epuise_tmp AS epuise_tmp_77,
  t25.coefmarge AS coefmarge_78,
  t25.statut_cegid AS statut_cegid_79,
  t25.stock_fournisseur AS stock_fournisseur_80,
  t25.vendu_par_multiple AS vendu_par_multiple_81,
  t25.valeur_marge AS valeur_marge_82,
  t25.backorder_magento AS backorder_magento_83,
  t25.code_fournisseur AS code_fournisseur_84,
  t25.updated_at_api AS updated_at_api_85,
  t25.pimcore_product_id AS pimcore_product_id_86
FROM
  pimcore_product t0
  LEFT JOIN product t25 ON t25.pimcore_product_id = t0.id
WHERE
  t0.code_article = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code_article AS code_article_2, t0.reference_parent AS reference_parent_3, t0.invisible_ecommerce AS invisible_ecommerce_4, t0.categorie_web AS categorie_web_5, t0.univers AS univers_6, t0.attribute_set AS attribute_set_7, t0.super_attributes AS super_attributes_8, t0.localizedfields AS localizedfields_9, t0.affectation_desc_complem AS affectation_desc_complem_10, t0.image_principale AS image_principale_11, t0.images_secondaires AS images_secondaires_12, t0.image_personnalisation AS image_personnalisation_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.children AS children_16, t0.attributes AS attributes_17, t0.type_de_produit AS type_de_produit_18, t0.attribute_option_ids AS attribute_option_ids_19, t0.main_img_hash AS main_img_hash_20, t0.additional_img_hash AS additional_img_hash_21, t0.stock_tag AS stock_tag_22, t0.status AS status_23, t0.updated_at_api AS updated_at_api_24, t25.id AS id_26, t25.sku AS sku_27, t25.ref_parent AS ref_parent_28, t25.ref_fournisseur AS ref_fournisseur_29, t25.libelle AS libelle_30, t25.activites AS activites_31, t25.activites_label AS activites_label_32, t25.univers_famille AS univers_famille_33, t25.univers_famille_label AS univers_famille_label_34, t25.famille AS famille_35, t25.famille_label AS famille_label_36, t25.sous_famille1 AS sous_famille1_37, t25.sous_famille1_label AS sous_famille1_label_38, t25.sous_famille2 AS sous_famille2_39, t25.sous_famille2_label AS sous_famille2_label_40, t25.boutique AS boutique_41, t25.marque AS marque_42, t25.marque_label AS marque_label_43, t25.couleur AS couleur_44, t25.couleur_label AS couleur_label_45, t25.taille AS taille_46, t25.taille_label AS taille_label_47, t25.collection AS collection_48, t25.pvht AS pvht_49, t25.prix_achat AS prix_achat_50, t25.tva AS tva_51, t25.poids AS poids_52, t25.volume AS volume_53, t25.methode_appro AS methode_appro_54, t25.methode_appro_label AS methode_appro_label_55, t25.invisible_web AS invisible_web_56, t25.epuise_cegid AS epuise_cegid_57, t25.ean AS ean_58, t25.min_commande_vente AS min_commande_vente_59, t25.delai_appro AS delai_appro_60, t25.delai_appro_constate AS delai_appro_constate_61, t25.created_at AS created_at_62, t25.updated_at AS updated_at_63, t25.date_modif_stock AS date_modif_stock_64, t25.quantite AS quantite_65, t25.hors_gabarit AS hors_gabarit_66, t25.famille_logistique AS famille_logistique_67, t25.dpav AS dpav_68, t25.soumis3ds AS soumis3ds_69, t25.depot_principal AS depot_principal_70, t25.type_article AS type_article_71, t25.famille_tarif AS famille_tarif_72, t25.marketplace AS marketplace_73, t25.ferme_cegid AS ferme_cegid_74, t25.ferme_web AS ferme_web_75, t25.epuise_frn AS epuise_frn_76, t25.epuise_tmp AS epuise_tmp_77, t25.coefmarge AS coefmarge_78, t25.statut_cegid AS statut_cegid_79, t25.stock_fournisseur AS stock_fournisseur_80, t25.vendu_par_multiple AS vendu_par_multiple_81, t25.valeur_marge AS valeur_marge_82, t25.backorder_magento AS backorder_magento_83, t25.code_fournisseur AS code_fournisseur_84, t25.updated_at_api AS updated_at_api_85, t25.pimcore_product_id AS pimcore_product_id_86 FROM pimcore_product t0 LEFT JOIN product t25 ON t25.pimcore_product_id = t0.id WHERE t0.code_article = '545PFF50211' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.trigramme AS trigramme_3,
  t0.url AS url_4,
  t0.remote_folder AS remote_folder_5,
  t0.is_m2 AS is_m2_6,
  t0.is_active AS is_active_7,
  t0.is_aws AS is_aws_8,
  t0.is_apple_pay AS is_apple_pay_9,
  t0.is_pimcore AS is_pimcore_10,
  t0.max_variance AS max_variance_11,
  t0.is_order_import_enabled AS is_order_import_enabled_12,
  t0.is_image_import_enabled AS is_image_import_enabled_13,
  t0.is_promo_enable AS is_promo_enable_14,
  t0.mail AS mail_15,
  t0.is_prod AS is_prod_16,
  t0.force_image_import AS force_image_import_17,
  t0.aws_host AS aws_host_18,
  t0.aws_user_bdd AS aws_user_bdd_19,
  t0.aws_db_pass AS aws_db_pass_20,
  t0.updated_at_api AS updated_at_api_21,
  t22.id AS id_23,
  t22.erp_active_products AS erp_active_products_24,
  t22.pim_active_products AS pim_active_products_25,
  t22.website_active_products AS website_active_products_26,
  t22.erp_backorder_products AS erp_backorder_products_27,
  t22.website_backorder_products AS website_backorder_products_28,
  t22.website_id AS website_id_29
FROM
  website t0
  LEFT JOIN website_statistics t22 ON t22.website_id = t0.id
WHERE
  t0.trigramme = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.trigramme AS trigramme_3, t0.url AS url_4, t0.remote_folder AS remote_folder_5, t0.is_m2 AS is_m2_6, t0.is_active AS is_active_7, t0.is_aws AS is_aws_8, t0.is_apple_pay AS is_apple_pay_9, t0.is_pimcore AS is_pimcore_10, t0.max_variance AS max_variance_11, t0.is_order_import_enabled AS is_order_import_enabled_12, t0.is_image_import_enabled AS is_image_import_enabled_13, t0.is_promo_enable AS is_promo_enable_14, t0.mail AS mail_15, t0.is_prod AS is_prod_16, t0.force_image_import AS force_image_import_17, t0.aws_host AS aws_host_18, t0.aws_user_bdd AS aws_user_bdd_19, t0.aws_db_pass AS aws_db_pass_20, t0.updated_at_api AS updated_at_api_21, t22.id AS id_23, t22.erp_active_products AS erp_active_products_24, t22.pim_active_products AS pim_active_products_25, t22.website_active_products AS website_active_products_26, t22.erp_backorder_products AS erp_backorder_products_27, t22.website_backorder_products AS website_backorder_products_28, t22.website_id AS website_id_29 FROM website t0 LEFT JOIN website_statistics t22 ON t22.website_id = t0.id WHERE t0.trigramme = 'EXS' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.sku AS sku_1,
  p0_.ref_parent AS ref_parent_2,
  p0_.ref_fournisseur AS ref_fournisseur_3,
  p0_.libelle AS libelle_4,
  p0_.activites AS activites_5,
  p0_.activites_label AS activites_label_6,
  p0_.univers_famille AS univers_famille_7,
  p0_.univers_famille_label AS univers_famille_label_8,
  p0_.famille AS famille_9,
  p0_.famille_label AS famille_label_10,
  p0_.sous_famille1 AS sous_famille1_11,
  p0_.sous_famille1_label AS sous_famille1_label_12,
  p0_.sous_famille2 AS sous_famille2_13,
  p0_.sous_famille2_label AS sous_famille2_label_14,
  p0_.boutique AS boutique_15,
  p0_.marque AS marque_16,
  p0_.marque_label AS marque_label_17,
  p0_.couleur AS couleur_18,
  p0_.couleur_label AS couleur_label_19,
  p0_.taille AS taille_20,
  p0_.taille_label AS taille_label_21,
  p0_.collection AS collection_22,
  p0_.pvht AS pvht_23,
  p0_.prix_achat AS prix_achat_24,
  p0_.tva AS tva_25,
  p0_.poids AS poids_26,
  p0_.volume AS volume_27,
  p0_.methode_appro AS methode_appro_28,
  p0_.methode_appro_label AS methode_appro_label_29,
  p0_.invisible_web AS invisible_web_30,
  p0_.epuise_cegid AS epuise_cegid_31,
  p0_.ean AS ean_32,
  p0_.min_commande_vente AS min_commande_vente_33,
  p0_.delai_appro AS delai_appro_34,
  p0_.delai_appro_constate AS delai_appro_constate_35,
  p0_.created_at AS created_at_36,
  p0_.updated_at AS updated_at_37,
  p0_.date_modif_stock AS date_modif_stock_38,
  p0_.quantite AS quantite_39,
  p0_.hors_gabarit AS hors_gabarit_40,
  p0_.famille_logistique AS famille_logistique_41,
  p0_.dpav AS dpav_42,
  p0_.soumis3ds AS soumis3ds_43,
  p0_.depot_principal AS depot_principal_44,
  p0_.type_article AS type_article_45,
  p0_.famille_tarif AS famille_tarif_46,
  p0_.marketplace AS marketplace_47,
  p0_.ferme_cegid AS ferme_cegid_48,
  p0_.ferme_web AS ferme_web_49,
  p0_.epuise_frn AS epuise_frn_50,
  p0_.epuise_tmp AS epuise_tmp_51,
  p0_.coefmarge AS coefmarge_52,
  p0_.statut_cegid AS statut_cegid_53,
  p0_.stock_fournisseur AS stock_fournisseur_54,
  p0_.vendu_par_multiple AS vendu_par_multiple_55,
  p0_.valeur_marge AS valeur_marge_56,
  p0_.backorder_magento AS backorder_magento_57,
  p0_.code_fournisseur AS code_fournisseur_58,
  p0_.updated_at_api AS updated_at_api_59,
  p0_.pimcore_product_id AS pimcore_product_id_60
FROM
  product p0_
WHERE
  p0_.sku = ?

SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.ref_parent AS ref_parent_2, p0_.ref_fournisseur AS ref_fournisseur_3, p0_.libelle AS libelle_4, p0_.activites AS activites_5, p0_.activites_label AS activites_label_6, p0_.univers_famille AS univers_famille_7, p0_.univers_famille_label AS univers_famille_label_8, p0_.famille AS famille_9, p0_.famille_label AS famille_label_10, p0_.sous_famille1 AS sous_famille1_11, p0_.sous_famille1_label AS sous_famille1_label_12, p0_.sous_famille2 AS sous_famille2_13, p0_.sous_famille2_label AS sous_famille2_label_14, p0_.boutique AS boutique_15, p0_.marque AS marque_16, p0_.marque_label AS marque_label_17, p0_.couleur AS couleur_18, p0_.couleur_label AS couleur_label_19, p0_.taille AS taille_20, p0_.taille_label AS taille_label_21, p0_.collection AS collection_22, p0_.pvht AS pvht_23, p0_.prix_achat AS prix_achat_24, p0_.tva AS tva_25, p0_.poids AS poids_26, p0_.volume AS volume_27, p0_.methode_appro AS methode_appro_28, p0_.methode_appro_label AS methode_appro_label_29, p0_.invisible_web AS invisible_web_30, p0_.epuise_cegid AS epuise_cegid_31, p0_.ean AS ean_32, p0_.min_commande_vente AS min_commande_vente_33, p0_.delai_appro AS delai_appro_34, p0_.delai_appro_constate AS delai_appro_constate_35, p0_.created_at AS created_at_36, p0_.updated_at AS updated_at_37, p0_.date_modif_stock AS date_modif_stock_38, p0_.quantite AS quantite_39, p0_.hors_gabarit AS hors_gabarit_40, p0_.famille_logistique AS famille_logistique_41, p0_.dpav AS dpav_42, p0_.soumis3ds AS soumis3ds_43, p0_.depot_principal AS depot_principal_44, p0_.type_article AS type_article_45, p0_.famille_tarif AS famille_tarif_46, p0_.marketplace AS marketplace_47, p0_.ferme_cegid AS ferme_cegid_48, p0_.ferme_web AS ferme_web_49, p0_.epuise_frn AS epuise_frn_50, p0_.epuise_tmp AS epuise_tmp_51, p0_.coefmarge AS coefmarge_52, p0_.statut_cegid AS statut_cegid_53, p0_.stock_fournisseur AS stock_fournisseur_54, p0_.vendu_par_multiple AS vendu_par_multiple_55, p0_.valeur_marge AS valeur_marge_56, p0_.backorder_magento AS backorder_magento_57, p0_.code_fournisseur AS code_fournisseur_58, p0_.updated_at_api AS updated_at_api_59, p0_.pimcore_product_id AS pimcore_product_id_60 FROM product p0_ WHERE p0_.sku = '545PFF50211';

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.trigramme AS trigramme_3,
  t0.url AS url_4,
  t0.remote_folder AS remote_folder_5,
  t0.is_m2 AS is_m2_6,
  t0.is_active AS is_active_7,
  t0.is_aws AS is_aws_8,
  t0.is_apple_pay AS is_apple_pay_9,
  t0.is_pimcore AS is_pimcore_10,
  t0.max_variance AS max_variance_11,
  t0.is_order_import_enabled AS is_order_import_enabled_12,
  t0.is_image_import_enabled AS is_image_import_enabled_13,
  t0.is_promo_enable AS is_promo_enable_14,
  t0.mail AS mail_15,
  t0.is_prod AS is_prod_16,
  t0.force_image_import AS force_image_import_17,
  t0.aws_host AS aws_host_18,
  t0.aws_user_bdd AS aws_user_bdd_19,
  t0.aws_db_pass AS aws_db_pass_20,
  t0.updated_at_api AS updated_at_api_21,
  t22.id AS id_23,
  t22.erp_active_products AS erp_active_products_24,
  t22.pim_active_products AS pim_active_products_25,
  t22.website_active_products AS website_active_products_26,
  t22.erp_backorder_products AS erp_backorder_products_27,
  t22.website_backorder_products AS website_backorder_products_28,
  t22.website_id AS website_id_29
FROM
  website t0
  LEFT JOIN website_statistics t22 ON t22.website_id = t0.id
WHERE
  t0.trigramme = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.trigramme AS trigramme_3, t0.url AS url_4, t0.remote_folder AS remote_folder_5, t0.is_m2 AS is_m2_6, t0.is_active AS is_active_7, t0.is_aws AS is_aws_8, t0.is_apple_pay AS is_apple_pay_9, t0.is_pimcore AS is_pimcore_10, t0.max_variance AS max_variance_11, t0.is_order_import_enabled AS is_order_import_enabled_12, t0.is_image_import_enabled AS is_image_import_enabled_13, t0.is_promo_enable AS is_promo_enable_14, t0.mail AS mail_15, t0.is_prod AS is_prod_16, t0.force_image_import AS force_image_import_17, t0.aws_host AS aws_host_18, t0.aws_user_bdd AS aws_user_bdd_19, t0.aws_db_pass AS aws_db_pass_20, t0.updated_at_api AS updated_at_api_21, t22.id AS id_23, t22.erp_active_products AS erp_active_products_24, t22.pim_active_products AS pim_active_products_25, t22.website_active_products AS website_active_products_26, t22.erp_backorder_products AS erp_backorder_products_27, t22.website_backorder_products AS website_backorder_products_28, t22.website_id AS website_id_29 FROM website t0 LEFT JOIN website_statistics t22 ON t22.website_id = t0.id WHERE t0.trigramme = 'EXS' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.trigramme AS trigramme_3,
  t0.url AS url_4,
  t0.remote_folder AS remote_folder_5,
  t0.is_m2 AS is_m2_6,
  t0.is_active AS is_active_7,
  t0.is_aws AS is_aws_8,
  t0.is_apple_pay AS is_apple_pay_9,
  t0.is_pimcore AS is_pimcore_10,
  t0.max_variance AS max_variance_11,
  t0.is_order_import_enabled AS is_order_import_enabled_12,
  t0.is_image_import_enabled AS is_image_import_enabled_13,
  t0.is_promo_enable AS is_promo_enable_14,
  t0.mail AS mail_15,
  t0.is_prod AS is_prod_16,
  t0.force_image_import AS force_image_import_17,
  t0.aws_host AS aws_host_18,
  t0.aws_user_bdd AS aws_user_bdd_19,
  t0.aws_db_pass AS aws_db_pass_20,
  t0.updated_at_api AS updated_at_api_21,
  t22.id AS id_23,
  t22.erp_active_products AS erp_active_products_24,
  t22.pim_active_products AS pim_active_products_25,
  t22.website_active_products AS website_active_products_26,
  t22.erp_backorder_products AS erp_backorder_products_27,
  t22.website_backorder_products AS website_backorder_products_28,
  t22.website_id AS website_id_29
FROM
  website t0
  LEFT JOIN website_statistics t22 ON t22.website_id = t0.id
WHERE
  t0.trigramme = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.trigramme AS trigramme_3, t0.url AS url_4, t0.remote_folder AS remote_folder_5, t0.is_m2 AS is_m2_6, t0.is_active AS is_active_7, t0.is_aws AS is_aws_8, t0.is_apple_pay AS is_apple_pay_9, t0.is_pimcore AS is_pimcore_10, t0.max_variance AS max_variance_11, t0.is_order_import_enabled AS is_order_import_enabled_12, t0.is_image_import_enabled AS is_image_import_enabled_13, t0.is_promo_enable AS is_promo_enable_14, t0.mail AS mail_15, t0.is_prod AS is_prod_16, t0.force_image_import AS force_image_import_17, t0.aws_host AS aws_host_18, t0.aws_user_bdd AS aws_user_bdd_19, t0.aws_db_pass AS aws_db_pass_20, t0.updated_at_api AS updated_at_api_21, t22.id AS id_23, t22.erp_active_products AS erp_active_products_24, t22.pim_active_products AS pim_active_products_25, t22.website_active_products AS website_active_products_26, t22.erp_backorder_products AS erp_backorder_products_27, t22.website_backorder_products AS website_backorder_products_28, t22.website_id AS website_id_29 FROM website t0 LEFT JOIN website_statistics t22 ON t22.website_id = t0.id WHERE t0.trigramme = 'OSV3' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.trigramme AS trigramme_3,
  t0.url AS url_4,
  t0.remote_folder AS remote_folder_5,
  t0.is_m2 AS is_m2_6,
  t0.is_active AS is_active_7,
  t0.is_aws AS is_aws_8,
  t0.is_apple_pay AS is_apple_pay_9,
  t0.is_pimcore AS is_pimcore_10,
  t0.max_variance AS max_variance_11,
  t0.is_order_import_enabled AS is_order_import_enabled_12,
  t0.is_image_import_enabled AS is_image_import_enabled_13,
  t0.is_promo_enable AS is_promo_enable_14,
  t0.mail AS mail_15,
  t0.is_prod AS is_prod_16,
  t0.force_image_import AS force_image_import_17,
  t0.aws_host AS aws_host_18,
  t0.aws_user_bdd AS aws_user_bdd_19,
  t0.aws_db_pass AS aws_db_pass_20,
  t0.updated_at_api AS updated_at_api_21,
  t22.id AS id_23,
  t22.erp_active_products AS erp_active_products_24,
  t22.pim_active_products AS pim_active_products_25,
  t22.website_active_products AS website_active_products_26,
  t22.erp_backorder_products AS erp_backorder_products_27,
  t22.website_backorder_products AS website_backorder_products_28,
  t22.website_id AS website_id_29
FROM
  website t0
  LEFT JOIN website_statistics t22 ON t22.website_id = t0.id
WHERE
  t0.trigramme = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.trigramme AS trigramme_3, t0.url AS url_4, t0.remote_folder AS remote_folder_5, t0.is_m2 AS is_m2_6, t0.is_active AS is_active_7, t0.is_aws AS is_aws_8, t0.is_apple_pay AS is_apple_pay_9, t0.is_pimcore AS is_pimcore_10, t0.max_variance AS max_variance_11, t0.is_order_import_enabled AS is_order_import_enabled_12, t0.is_image_import_enabled AS is_image_import_enabled_13, t0.is_promo_enable AS is_promo_enable_14, t0.mail AS mail_15, t0.is_prod AS is_prod_16, t0.force_image_import AS force_image_import_17, t0.aws_host AS aws_host_18, t0.aws_user_bdd AS aws_user_bdd_19, t0.aws_db_pass AS aws_db_pass_20, t0.updated_at_api AS updated_at_api_21, t22.id AS id_23, t22.erp_active_products AS erp_active_products_24, t22.pim_active_products AS pim_active_products_25, t22.website_active_products AS website_active_products_26, t22.erp_backorder_products AS erp_backorder_products_27, t22.website_backorder_products AS website_backorder_products_28, t22.website_id AS website_id_29 FROM website t0 LEFT JOIN website_statistics t22 ON t22.website_id = t0.id WHERE t0.trigramme = 'OSB' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.trigramme AS trigramme_3,
  t0.url AS url_4,
  t0.remote_folder AS remote_folder_5,
  t0.is_m2 AS is_m2_6,
  t0.is_active AS is_active_7,
  t0.is_aws AS is_aws_8,
  t0.is_apple_pay AS is_apple_pay_9,
  t0.is_pimcore AS is_pimcore_10,
  t0.max_variance AS max_variance_11,
  t0.is_order_import_enabled AS is_order_import_enabled_12,
  t0.is_image_import_enabled AS is_image_import_enabled_13,
  t0.is_promo_enable AS is_promo_enable_14,
  t0.mail AS mail_15,
  t0.is_prod AS is_prod_16,
  t0.force_image_import AS force_image_import_17,
  t0.aws_host AS aws_host_18,
  t0.aws_user_bdd AS aws_user_bdd_19,
  t0.aws_db_pass AS aws_db_pass_20,
  t0.updated_at_api AS updated_at_api_21,
  t22.id AS id_23,
  t22.erp_active_products AS erp_active_products_24,
  t22.pim_active_products AS pim_active_products_25,
  t22.website_active_products AS website_active_products_26,
  t22.erp_backorder_products AS erp_backorder_products_27,
  t22.website_backorder_products AS website_backorder_products_28,
  t22.website_id AS website_id_29
FROM
  website t0
  LEFT JOIN website_statistics t22 ON t22.website_id = t0.id
  INNER JOIN product_website ON t0.id = product_website.website_id
WHERE
  product_website.product_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.trigramme AS trigramme_3, t0.url AS url_4, t0.remote_folder AS remote_folder_5, t0.is_m2 AS is_m2_6, t0.is_active AS is_active_7, t0.is_aws AS is_aws_8, t0.is_apple_pay AS is_apple_pay_9, t0.is_pimcore AS is_pimcore_10, t0.max_variance AS max_variance_11, t0.is_order_import_enabled AS is_order_import_enabled_12, t0.is_image_import_enabled AS is_image_import_enabled_13, t0.is_promo_enable AS is_promo_enable_14, t0.mail AS mail_15, t0.is_prod AS is_prod_16, t0.force_image_import AS force_image_import_17, t0.aws_host AS aws_host_18, t0.aws_user_bdd AS aws_user_bdd_19, t0.aws_db_pass AS aws_db_pass_20, t0.updated_at_api AS updated_at_api_21, t22.id AS id_23, t22.erp_active_products AS erp_active_products_24, t22.pim_active_products AS pim_active_products_25, t22.website_active_products AS website_active_products_26, t22.erp_backorder_products AS erp_backorder_products_27, t22.website_backorder_products AS website_backorder_products_28, t22.website_id AS website_id_29 FROM website t0 LEFT JOIN website_statistics t22 ON t22.website_id = t0.id INNER JOIN product_website ON t0.id = product_website.website_id WHERE product_website.product_id = 70594;