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 62000

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 62000;

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 (83807, 83808, 83809, 83810, 83811, 83812, 83813, 83814, 83815, 83816, 83817, 83818, 83819, 83820, 83821, 83822, 83823, 83824, 83825, 83826, 83827, 83828, 83829, 83830, 83831, 83832, 83833, 83834, 83835, 83836, 83837, 83838, 83839, 83840, 83841, 83842, 83843, 83844, 83845, 83846, 83847, 83848, 83849, 83850, 83851, 83852, 83853, 83854, 83855, 83856, 83857, 83858, 83859, 83860, 83861, 83862, 83863, 83864, 83865, 83866, 83867, 83868, 83869, 83870, 83871, 83872, 83873, 83874, 83875, 83876, 83877, 83878, 83879, 83880, 83881, 83882, 83883, 83884, 83885, 83886, 83887, 83888, 83889, 83890, 83891, 83892, 83893, 83894, 83895, 83896, 83897, 83898, 83899, 83900, 83901, 83902, 83903, 83904, 83905, 83906, 83907, 83908, 83909, 83910, 83911, 83912, 83913, 83914, 83915, 83916, 83917, 83918, 83919, 83920, 83921, 83922, 83923, 83924, 83925, 83926, 83927, 83928, 83929, 83930, 83931, 83932, 83933, 83934, 83935, 83936, 83937, 83938, 83939, 83940, 83941, 83942, 83943, 83944, 83945, 83946, 83947, 83948, 83949, 83950, 83951, 83952, 83953, 83954, 83955, 83956, 83957, 83958, 83959, 83960, 83961, 83962, 83963, 83964, 83965, 83966, 83967, 83968, 83969, 83970, 83971, 83972, 83973, 83974, 83975, 83976, 83977, 83978, 83979, 83980, 83981, 83982, 83983, 83984, 83985, 83986, 83987, 83988, 83989, 83990, 83991, 83992, 83993, 83994, 83995, 83996, 83997, 83998, 83999, 84000, 84001, 84002, 84003, 84004, 84005, 84006, 84007, 84008, 84009, 84010, 84011, 84012, 84013, 84014, 84015, 84016, 84017, 84018, 84019, 84020, 84021, 84022, 84023, 84024, 84025, 84026, 84027, 84028, 84029, 84030, 84031, 84032, 84033, 84034, 84035, 84036, 84037, 84038, 84039, 84040, 84041, 84042, 84043, 84044, 84045, 84046, 84047, 84048, 84049, 84050, 84051, 84052, 84053, 84054, 84055, 84056, 84057, 84058, 84059, 84060, 84061, 84062, 84063, 84064, 84065, 84066, 84067, 84068, 84069, 84070, 84071, 84072, 84073, 84074, 84075, 84076, 84077, 84078, 84079, 84080, 84081, 84082, 84083, 84084, 84085, 84086, 84087, 84088, 84089, 84090, 84091, 84092, 84093, 84094, 84095, 84096, 84097, 84098, 84099, 84100, 84101, 84102, 84103, 84104, 84105, 84106, 84107, 84108, 84109, 84110, 84111, 84115, 84116, 84117, 84118, 84119, 84120, 84121, 84122, 84123, 84124, 84125, 84126, 84127, 84128, 84129, 84130, 84131, 84132, 84133, 84134, 84135, 84136, 84137, 84138, 84139, 84140, 84141, 84142, 84143, 84144, 84145, 84146, 84147, 84148, 84149, 84150, 84151, 84152, 84153, 84154, 84155, 84156, 84157, 84158, 84159, 84160, 84161, 84162, 84163, 84164, 84165, 84166, 84167, 84168, 84169, 84170, 84171, 84172, 84173, 84174, 84175, 84176, 84177, 84178, 84179, 84180, 84181, 84182, 84183, 84184, 84185, 84186, 84187, 84188, 84189, 84190, 84191, 84192, 84193, 84194, 84195, 84196, 84197, 84198, 84199, 84200, 84201, 84202, 84204, 84205, 84206, 84207, 84208, 84209, 84210, 84211, 84212, 84213, 84215, 84216, 84217, 84218, 84219, 84220, 84221, 84222, 84223, 84224, 84225, 84226, 84227, 84228, 84229, 84230, 84231, 84232, 84233, 84234, 84235, 84236, 84237, 84238, 84239, 84240, 84241, 84242, 84243, 84244, 84245, 84246, 84247, 84248, 84249, 84250, 84251, 84252, 84253, 84254, 84261, 84266, 84274, 84275, 84276, 84277, 84278, 84279, 84280, 84281, 84282, 84283, 84284, 84285, 84286, 84287, 84288, 84289, 84290, 84291, 84292, 84293, 84294, 84295, 84296, 84297, 84298, 84299, 84300, 84301, 84302, 84303, 84304, 84305, 84306, 84307, 84308, 84309, 84313, 84314, 84315, 84316, 84317, 84318, 84319, 84320, 84321, 84322, 84323, 84324, 84325, 84326, 84327, 84328, 84329, 84330, 84331) 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 ('6REAERO300', '8AL3355014', 'GUL17_CHH_RSB', 'JC62', 'CP8600A008 ', 'GUL182_CHH_COR', 'YAM23_PLH_TEA', 'YAM23_TSH_TEA', '8OMPKK02744E', '861135_COUDE135', '861RD_REDUCTEUR', '24H232_TSH_LEG', '607AA0611AH4I', 'ALP23_SWH_FLOB', 'ALP23_SWH_FLON', 'ALP23_VSH_COB', 'ALP23_VSH_EOB', 'GUL13_CHH_LAG', 'GUL17_CHH_TOR', 'GR_FILTRE_CYLIN', '5HF');

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