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 = 'OSB' 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 = 'dsi' LIMIT 1;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.id AS id_1
FROM
  product p0_
  INNER JOIN product_website p2_ ON p0_.id = p2_.product_id
  INNER JOIN website w1_ ON w1_.id = p2_.website_id
WHERE
  p0_.id IN (
    SELECT
      p3_.id
    FROM
      product p3_
      INNER JOIN product_website p5_ ON p3_.id = p5_.product_id
      INNER JOIN website w4_ ON w4_.id = p5_.website_id
    WHERE
      w4_.trigramme = ?
  )
ORDER BY
  p0_.id ASC
LIMIT
  500 OFFSET 61000

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ INNER JOIN product_website p2_ ON p0_.id = p2_.product_id INNER JOIN website w1_ ON w1_.id = p2_.website_id WHERE p0_.id IN (SELECT p3_.id FROM product p3_ INNER JOIN product_website p5_ ON p3_.id = p5_.product_id INNER JOIN website w4_ ON w4_.id = p5_.website_id WHERE w4_.trigramme = 'OSB') ORDER BY p0_.id ASC LIMIT 500 OFFSET 61000;

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_
  INNER JOIN product_website p2_ ON p0_.id = p2_.product_id
  INNER JOIN website w1_ ON w1_.id = p2_.website_id
WHERE
  p0_.id IN (
    SELECT
      p3_.id
    FROM
      product p3_
      INNER JOIN product_website p5_ ON p3_.id = p5_.product_id
      INNER JOIN website w4_ ON w4_.id = p5_.website_id
    WHERE
      w4_.trigramme = ?
  )
  AND p0_.id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
ORDER BY
  p0_.id ASC

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_ INNER JOIN product_website p2_ ON p0_.id = p2_.product_id INNER JOIN website w1_ ON w1_.id = p2_.website_id WHERE p0_.id IN (SELECT p3_.id FROM product p3_ INNER JOIN product_website p5_ ON p3_.id = p5_.product_id INNER JOIN website w4_ ON w4_.id = p5_.website_id WHERE w4_.trigramme = 'OSB') AND p0_.id IN (82769, 82770, 82771, 82772, 82773, 82774, 82775, 82776, 82777, 82778, 82779, 82780, 82781, 82782, 82783, 82784, 82785, 82786, 82787, 82788, 82789, 82790, 82791, 82792, 82793, 82794, 82795, 82796, 82797, 82798, 82799, 82800, 82801, 82802, 82803, 82804, 82805, 82806, 82808, 82809, 82810, 82811, 82812, 82813, 82814, 82815, 82816, 82817, 82818, 82819, 82820, 82821, 82822, 82823, 82824, 82825, 82826, 82827, 82828, 82829, 82830, 82831, 82832, 82833, 82834, 82835, 82836, 82837, 82838, 82839, 82840, 82841, 82842, 82843, 82844, 82845, 82880, 82881, 82882, 82883, 82884, 82885, 82886, 82887, 82888, 82889, 82890, 82891, 82892, 82893, 82894, 82895, 82896, 82897, 82898, 82899, 82900, 82901, 82902, 82903, 82904, 82905, 82906, 82909, 82910, 82911, 82912, 82913, 82914, 82915, 82916, 82917, 82918, 82919, 82920, 82921, 82922, 82923, 82924, 82925, 82927, 82928, 82929, 82930, 82931, 82932, 82933, 82934, 82935, 82936, 82937, 82938, 82939, 82940, 82941, 82942, 82943, 82944, 82945, 82946, 82947, 82948, 82949, 82950, 82951, 82952, 82953, 82954, 82955, 82956, 82957, 82958, 82959, 82960, 82961, 82962, 82963, 82964, 82965, 82966, 82967, 82968, 82969, 82970, 82971, 82972, 82973, 82974, 82975, 82976, 82977, 82978, 82979, 82980, 82981, 82982, 82983, 82984, 82985, 82986, 82987, 82988, 82989, 82990, 82991, 82992, 82993, 82994, 82995, 82996, 82997, 82998, 82999, 83000, 83001, 83002, 83003, 83004, 83005, 83006, 83007, 83008, 83009, 83010, 83011, 83012, 83013, 83014, 83015, 83016, 83017, 83018, 83019, 83020, 83021, 83022, 83023, 83024, 83025, 83026, 83027, 83028, 83029, 83030, 83031, 83032, 83033, 83034, 83035, 83036, 83037, 83038, 83039, 83040, 83041, 83042, 83043, 83044, 83045, 83046, 83047, 83048, 83049, 83050, 83051, 83052, 83053, 83054, 83055, 83056, 83057, 83058, 83059, 83060, 83061, 83062, 83063, 83064, 83065, 83066, 83067, 83068, 83069, 83070, 83071, 83072, 83073, 83074, 83075, 83076, 83077, 83078, 83079, 83080, 83081, 83082, 83083, 83084, 83085, 83086, 83087, 83088, 83089, 83090, 83091, 83092, 83093, 83094, 83095, 83096, 83097, 83098, 83099, 83100, 83101, 83102, 83103, 83104, 83105, 83106, 83107, 83108, 83109, 83110, 83111, 83112, 83113, 83114, 83115, 83116, 83117, 83118, 83119, 83120, 83121, 83122, 83123, 83124, 83125, 83126, 83127, 83128, 83129, 83130, 83131, 83132, 83133, 83134, 83135, 83136, 83137, 83138, 83139, 83140, 83141, 83142, 83143, 83144, 83145, 83146, 83147, 83148, 83149, 83150, 83151, 83152, 83153, 83154, 83155, 83156, 83157, 83158, 83159, 83160, 83161, 83162, 83163, 83164, 83165, 83166, 83167, 83168, 83169, 83170, 83171, 83172, 83173, 83174, 83175, 83176, 83177, 83178, 83179, 83180, 83181, 83182, 83183, 83184, 83185, 83186, 83187, 83188, 83189, 83190, 83191, 83192, 83193, 83194, 83195, 83196, 83197, 83198, 83199, 83200, 83201, 83202, 83203, 83204, 83205, 83206, 83207, 83208, 83209, 83210, 83211, 83212, 83213, 83214, 83215, 83216, 83217, 83218, 83219, 83220, 83221, 83222, 83223, 83224, 83225, 83226, 83227, 83228, 83229, 83230, 83231, 83232, 83233, 83234, 83235, 83236, 83237, 83238, 83239, 83240, 83241, 83242, 83243, 83244, 83245, 83246, 83247, 83248, 83249, 83250, 83251, 83252, 83253, 83254, 83255, 83256, 83257, 83258, 83259, 83260, 83261, 83262, 83263, 83264, 83265, 83266, 83267, 83268, 83269, 83270, 83271, 83272, 83273, 83274, 83275, 83276, 83277, 83278, 83279, 83280, 83281, 83282, 83283, 83284, 83285, 83286, 83287, 83288, 83289, 83290, 83291, 83292, 83293, 83294, 83295, 83296, 83297, 83298, 83299, 83300, 83301, 83302, 83303, 83304, 83305, 83306) ORDER BY p0_.id ASC;

SELECT
  p0_.stock_tag AS stock_tag_0,
  p0_.code_article AS code_article_1,
  p0_.status AS status_2
FROM
  pimcore_product p0_
WHERE
  p0_.code_article IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT p0_.stock_tag AS stock_tag_0, p0_.code_article AS code_article_1, p0_.status AS status_2 FROM pimcore_product p0_ WHERE p0_.code_article IN ('EMBRAYAGES_4X4', '607TO012V', '8TOGTMEXGTN', 'ABWT_ROTULES', 'ART_ROTULES', '8301017_4-100', '8TOFS727N', 'CPR23_BOD_TED', 'CPR23_PYJ_TED', 'GUL17_CHH_RSB', 'GUL18_SWH_SMB', 'SPH_COUPLEURRAPIDE', 'ALP23_TSH_GPEG', 'ALP23_TSH_GPEO', '8SP002329_ENFANT', 'VENT_COMEX_SLIM', 'VENT_COMEX_VHP', 'VENT_COMEX_HP', 'SMQ23_TSH_Q20', 'MAKGP3COBRA', 'MAKGP3HEMERA', 'MAKGP3NEO', 'MAKGP3OMEGA', 'MAKGP3RAIDEN', 'MAKKC7COBRA', 'MAKKC7HEMERA', 'MAKKC7NEO', 'MAKKC7OMEGA', 'MAKKC7RAIDEN', 'MAKMAG10COBRA', 'MAKMAG10HEMERA', 'MAKMAG10NEO', 'MAKMAG10OMEGA', 'MAKMAG10RAIDEN', 'MAKRS7COBRA');

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