Symfony Profiler

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.id AS id_1
FROM
  erp_product e0_
  LEFT JOIN erp_product_website e2_ ON e0_.id = e2_.erp_product_id
  LEFT JOIN website w1_ ON w1_.id = e2_.website_id
WHERE
  w1_.id IN (?)
ORDER BY
  e0_.id DESC
LIMIT
  20

SELECT DISTINCT e0_.id AS id_0, e0_.id AS id_1 FROM erp_product e0_ LEFT JOIN erp_product_website e2_ ON e0_.id = e2_.erp_product_id LEFT JOIN website w1_ ON w1_.id = e2_.website_id WHERE w1_.id IN (16835) ORDER BY e0_.id DESC LIMIT 20;

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  erp_product e0_
  LEFT JOIN erp_product_website e2_ ON e0_.id = e2_.erp_product_id
  LEFT JOIN website w1_ ON w1_.id = e2_.website_id
WHERE
  w1_.id IN (?)

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM erp_product e0_ LEFT JOIN erp_product_website e2_ ON e0_.id = e2_.erp_product_id LEFT JOIN website w1_ ON w1_.id = e2_.website_id WHERE w1_.id IN (16835);

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_active AS is_active_6,
  t0.is_aws AS is_aws_7,
  t0.is_apple_pay AS is_apple_pay_8,
  t0.is_pimcore AS is_pimcore_9,
  t0.max_variance AS max_variance_10,
  t0.is_order_import_enabled AS is_order_import_enabled_11,
  t0.is_image_import_enabled AS is_image_import_enabled_12,
  t0.is_promo_enable AS is_promo_enable_13,
  t0.mail AS mail_14,
  t0.is_prod AS is_prod_15,
  t0.force_image_import AS force_image_import_16,
  t0.aws_host AS aws_host_17,
  t0.aws_user_bdd AS aws_user_bdd_18,
  t0.aws_db_pass AS aws_db_pass_19,
  t0.has_personalization AS has_personalization_20,
  t0.platform AS platform_21,
  t0.updated_at_api AS updated_at_api_22,
  t0.created_at_api AS created_at_api_23
FROM
  website t0
  INNER JOIN erp_product_website ON t0.id = erp_product_website.website_id
WHERE
  erp_product_website.erp_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_active AS is_active_6, t0.is_aws AS is_aws_7, t0.is_apple_pay AS is_apple_pay_8, t0.is_pimcore AS is_pimcore_9, t0.max_variance AS max_variance_10, t0.is_order_import_enabled AS is_order_import_enabled_11, t0.is_image_import_enabled AS is_image_import_enabled_12, t0.is_promo_enable AS is_promo_enable_13, t0.mail AS mail_14, t0.is_prod AS is_prod_15, t0.force_image_import AS force_image_import_16, t0.aws_host AS aws_host_17, t0.aws_user_bdd AS aws_user_bdd_18, t0.aws_db_pass AS aws_db_pass_19, t0.has_personalization AS has_personalization_20, t0.platform AS platform_21, t0.updated_at_api AS updated_at_api_22, t0.created_at_api AS created_at_api_23 FROM website t0 INNER JOIN erp_product_website ON t0.id = erp_product_website.website_id WHERE erp_product_website.erp_product_id = 92887;

SELECT
  e0_.id AS id_0,
  e0_.sku AS sku_1,
  e0_.parent_reference AS parent_reference_2,
  e0_.supplier_reference AS supplier_reference_3,
  e0_.product_name AS product_name_4,
  e0_.activity AS activity_5,
  e0_.activity_label AS activity_label_6,
  e0_.universe AS universe_7,
  e0_.universe_label AS universe_label_8,
  e0_.product_family AS product_family_9,
  e0_.product_family_label AS product_family_label_10,
  e0_.sub_family1 AS sub_family1_11,
  e0_.sub_family1_label AS sub_family1_label_12,
  e0_.brand AS brand_13,
  e0_.brand_label AS brand_label_14,
  e0_.selling_price_excl_tax AS selling_price_excl_tax_15,
  e0_.purchase_price AS purchase_price_16,
  e0_.vat_rate AS vat_rate_17,
  e0_.weight AS weight_18,
  e0_.volume AS volume_19,
  e0_.supply_method AS supply_method_20,
  e0_.supply_method_label AS supply_method_label_21,
  e0_.out_of_stock_erp AS out_of_stock_erp_22,
  e0_.ean AS ean_23,
  e0_.min_order_qty AS min_order_qty_24,
  e0_.lead_time AS lead_time_25,
  e0_.created_at AS created_at_26,
  e0_.updated_at AS updated_at_27,
  e0_.quantity AS quantity_28,
  e0_.oversized AS oversized_29,
  e0_.logistics_category AS logistics_category_30,
  e0_.main_warehouse AS main_warehouse_31,
  e0_.pricing_category AS pricing_category_32,
  e0_.erp_closed AS erp_closed_33,
  e0_.temp_out_of_stock AS temp_out_of_stock_34,
  e0_.margin_coefficient AS margin_coefficient_35,
  e0_.margin_value AS margin_value_36,
  e0_.supplier_stock AS supplier_stock_37,
  e0_.sold_in_multiples AS sold_in_multiples_38,
  e0_.allow_backorder AS allow_backorder_39,
  e0_.supplier_code AS supplier_code_40,
  e0_.erp_status AS erp_status_41,
  e0_.hot_data_updated_at AS hot_data_updated_at_42,
  e0_.updated_at_api AS updated_at_api_43,
  e0_.created_at_api AS created_at_api_44,
  e0_.pimcore_product_id AS pimcore_product_id_45
FROM
  erp_product e0_
  LEFT JOIN erp_product_website e2_ ON e0_.id = e2_.erp_product_id
  LEFT JOIN website w1_ ON w1_.id = e2_.website_id
WHERE
  w1_.id IN (?)
  AND e0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  e0_.id DESC

SELECT e0_.id AS id_0, e0_.sku AS sku_1, e0_.parent_reference AS parent_reference_2, e0_.supplier_reference AS supplier_reference_3, e0_.product_name AS product_name_4, e0_.activity AS activity_5, e0_.activity_label AS activity_label_6, e0_.universe AS universe_7, e0_.universe_label AS universe_label_8, e0_.product_family AS product_family_9, e0_.product_family_label AS product_family_label_10, e0_.sub_family1 AS sub_family1_11, e0_.sub_family1_label AS sub_family1_label_12, e0_.brand AS brand_13, e0_.brand_label AS brand_label_14, e0_.selling_price_excl_tax AS selling_price_excl_tax_15, e0_.purchase_price AS purchase_price_16, e0_.vat_rate AS vat_rate_17, e0_.weight AS weight_18, e0_.volume AS volume_19, e0_.supply_method AS supply_method_20, e0_.supply_method_label AS supply_method_label_21, e0_.out_of_stock_erp AS out_of_stock_erp_22, e0_.ean AS ean_23, e0_.min_order_qty AS min_order_qty_24, e0_.lead_time AS lead_time_25, e0_.created_at AS created_at_26, e0_.updated_at AS updated_at_27, e0_.quantity AS quantity_28, e0_.oversized AS oversized_29, e0_.logistics_category AS logistics_category_30, e0_.main_warehouse AS main_warehouse_31, e0_.pricing_category AS pricing_category_32, e0_.erp_closed AS erp_closed_33, e0_.temp_out_of_stock AS temp_out_of_stock_34, e0_.margin_coefficient AS margin_coefficient_35, e0_.margin_value AS margin_value_36, e0_.supplier_stock AS supplier_stock_37, e0_.sold_in_multiples AS sold_in_multiples_38, e0_.allow_backorder AS allow_backorder_39, e0_.supplier_code AS supplier_code_40, e0_.erp_status AS erp_status_41, e0_.hot_data_updated_at AS hot_data_updated_at_42, e0_.updated_at_api AS updated_at_api_43, e0_.created_at_api AS created_at_api_44, e0_.pimcore_product_id AS pimcore_product_id_45 FROM erp_product e0_ LEFT JOIN erp_product_website e2_ ON e0_.id = e2_.erp_product_id LEFT JOIN website w1_ ON w1_.id = e2_.website_id WHERE w1_.id IN (16835) AND e0_.id IN (92887, 92886, 92885, 92884, 92883, 92882, 92881, 92880, 92879, 92878, 92877, 92876, 92875, 92874, 92873, 92872, 92871, 92870, 92869, 92868) ORDER BY e0_.id DESC;

SELECT
  w0_.id AS id_0,
  w0_.label AS label_1,
  w0_.trigramme AS trigramme_2,
  w0_.url AS url_3,
  w0_.remote_folder AS remote_folder_4,
  w0_.is_active AS is_active_5,
  w0_.is_aws AS is_aws_6,
  w0_.is_apple_pay AS is_apple_pay_7,
  w0_.is_pimcore AS is_pimcore_8,
  w0_.max_variance AS max_variance_9,
  w0_.is_order_import_enabled AS is_order_import_enabled_10,
  w0_.is_image_import_enabled AS is_image_import_enabled_11,
  w0_.is_promo_enable AS is_promo_enable_12,
  w0_.mail AS mail_13,
  w0_.is_prod AS is_prod_14,
  w0_.force_image_import AS force_image_import_15,
  w0_.aws_host AS aws_host_16,
  w0_.aws_user_bdd AS aws_user_bdd_17,
  w0_.aws_db_pass AS aws_db_pass_18,
  w0_.has_personalization AS has_personalization_19,
  w0_.platform AS platform_20,
  w0_.updated_at_api AS updated_at_api_21,
  w0_.created_at_api AS created_at_api_22
FROM
  website w0_
WHERE
  w0_.id IN (?)

SELECT w0_.id AS id_0, w0_.label AS label_1, w0_.trigramme AS trigramme_2, w0_.url AS url_3, w0_.remote_folder AS remote_folder_4, w0_.is_active AS is_active_5, w0_.is_aws AS is_aws_6, w0_.is_apple_pay AS is_apple_pay_7, w0_.is_pimcore AS is_pimcore_8, w0_.max_variance AS max_variance_9, w0_.is_order_import_enabled AS is_order_import_enabled_10, w0_.is_image_import_enabled AS is_image_import_enabled_11, w0_.is_promo_enable AS is_promo_enable_12, w0_.mail AS mail_13, w0_.is_prod AS is_prod_14, w0_.force_image_import AS force_image_import_15, w0_.aws_host AS aws_host_16, w0_.aws_user_bdd AS aws_user_bdd_17, w0_.aws_db_pass AS aws_db_pass_18, w0_.has_personalization AS has_personalization_19, w0_.platform AS platform_20, w0_.updated_at_api AS updated_at_api_21, w0_.created_at_api AS created_at_api_22 FROM website w0_ WHERE w0_.id IN ('16835');

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_active AS is_active_6,
  t0.is_aws AS is_aws_7,
  t0.is_apple_pay AS is_apple_pay_8,
  t0.is_pimcore AS is_pimcore_9,
  t0.max_variance AS max_variance_10,
  t0.is_order_import_enabled AS is_order_import_enabled_11,
  t0.is_image_import_enabled AS is_image_import_enabled_12,
  t0.is_promo_enable AS is_promo_enable_13,
  t0.mail AS mail_14,
  t0.is_prod AS is_prod_15,
  t0.force_image_import AS force_image_import_16,
  t0.aws_host AS aws_host_17,
  t0.aws_user_bdd AS aws_user_bdd_18,
  t0.aws_db_pass AS aws_db_pass_19,
  t0.has_personalization AS has_personalization_20,
  t0.platform AS platform_21,
  t0.updated_at_api AS updated_at_api_22,
  t0.created_at_api AS created_at_api_23
FROM
  website t0
WHERE
  t0.trigramme = ?
LIMIT
  2

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_active AS is_active_6, t0.is_aws AS is_aws_7, t0.is_apple_pay AS is_apple_pay_8, t0.is_pimcore AS is_pimcore_9, t0.max_variance AS max_variance_10, t0.is_order_import_enabled AS is_order_import_enabled_11, t0.is_image_import_enabled AS is_image_import_enabled_12, t0.is_promo_enable AS is_promo_enable_13, t0.mail AS mail_14, t0.is_prod AS is_prod_15, t0.force_image_import AS force_image_import_16, t0.aws_host AS aws_host_17, t0.aws_user_bdd AS aws_user_bdd_18, t0.aws_db_pass AS aws_db_pass_19, t0.has_personalization AS has_personalization_20, t0.platform AS platform_21, t0.updated_at_api AS updated_at_api_22, t0.created_at_api AS created_at_api_23 FROM website t0 WHERE t0.trigramme = 'MIS' LIMIT 2;

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.id = ?

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.id = 6;