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 9000

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

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 (10183, 10184, 10185, 10186, 10187, 10188, 10189, 10190, 10191, 10192, 10193, 10194, 10195, 10196, 10197, 10198, 10199, 10200, 10201, 10202, 10203, 10204, 10205, 10206, 10207, 10208, 10209, 10210, 10211, 10212, 10213, 10214, 10215, 10216, 10217, 10218, 10219, 10220, 10221, 10222, 10223, 10224, 10225, 10226, 10227, 10228, 10229, 10230, 10231, 10232, 10233, 10234, 10235, 10236, 10237, 10238, 10239, 10240, 10241, 10242, 10243, 10244, 10245, 10246, 10247, 10248, 10249, 10250, 10251, 10252, 10253, 10254, 10255, 10256, 10257, 10258, 10259, 10260, 10261, 10262, 10263, 10264, 10265, 10266, 10267, 10268, 10269, 10270, 10271, 10272, 10273, 10274, 10275, 10276, 10277, 10278, 10279, 10280, 10281, 10282, 10283, 10284, 10285, 10286, 10287, 10288, 10289, 10290, 10291, 10292, 10293, 10294, 10295, 10296, 10297, 10298, 10299, 10300, 10301, 10302, 10303, 10304, 10305, 10306, 10307, 10308, 10309, 10310, 10311, 10312, 10313, 10314, 10315, 10316, 10317, 10318, 10319, 10320, 10321, 10322, 10323, 10324, 10325, 10326, 10327, 10328, 10329, 10330, 10331, 10332, 10333, 10334, 10335, 10336, 10337, 10338, 10339, 10340, 10341, 10342, 10343, 10344, 10345, 10346, 10347, 10348, 10349, 10350, 10351, 10352, 10353, 10354, 10355, 10356, 10357, 10358, 10359, 10360, 10361, 10362, 10363, 10364, 10365, 10366, 10367, 10368, 10369, 10370, 10371, 10372, 10373, 10374, 10375, 10376, 10377, 10378, 10379, 10380, 10381, 10382, 10383, 10384, 10385, 10386, 10387, 10388, 10389, 10390, 10391, 10392, 10393, 10394, 10395, 10396, 10397, 10398, 10399, 10400, 10401, 10402, 10403, 10404, 10405, 10406, 10407, 10408, 10409, 10410, 10411, 10412, 10413, 10414, 10415, 10416, 10417, 10418, 10419, 10420, 10421, 10422, 10423, 10424, 10425, 10426, 10427, 10428, 10429, 10430, 10431, 10432, 10433, 10434, 10435, 10436, 10437, 10438, 10439, 10440, 10441, 10442, 10443, 10444, 10445, 10446, 10447, 10448, 10449, 10450, 10451, 10452, 10453, 10454, 10455, 10456, 10457, 10458, 10459, 10460, 10461, 10462, 10463, 10464, 10465, 10466, 10467, 10468, 10469, 10470, 10471, 10472, 10473, 10474, 10475, 10476, 10477, 10478, 10479, 10480, 10481, 10482, 10483, 10484, 10485, 10486, 10487, 10488, 10489, 10490, 10491, 10492, 10493, 10494, 10495, 10496, 10497, 10498, 10499, 10500, 10501, 10502, 10503, 10504, 10505, 10506, 10507, 10508, 10509, 10510, 10511, 10512, 10513, 10514, 10515, 10516, 10517, 10518, 10519, 10520, 10521, 10522, 10523, 10524, 10525, 10526, 10527, 10528, 10529, 10530, 10531, 10532, 10533, 10534, 10535, 10536, 10537, 10538, 10539, 10540, 10541, 10542, 10543, 10544, 10545, 10546, 10547, 10548, 10549, 10550, 10551, 10552, 10553, 10554, 10555, 10556, 10557, 10558, 10559, 10560, 10561, 10562, 10563, 10564, 10565, 10566, 10567, 10568, 10569, 10570, 10571, 10572, 10573, 10574, 10575, 10576, 10577, 10578, 10579, 10580, 10581, 10582, 10583, 10584, 10585, 10586, 10587, 10588, 10589, 10590, 10591, 10592, 10593, 10594, 10595, 10596, 10597, 10598, 10599, 10600, 10601, 10602, 10603, 10604, 10605, 10606, 10607, 10608, 10609, 10610, 10611, 10612, 10613, 10614, 10615, 10616, 10617, 10618, 10619, 10620, 10621, 10622, 10623, 10624, 10625, 10626, 10627, 10657, 10658, 10659, 10660, 10661, 10662, 10663, 10664, 10665, 10666, 10667, 10668, 10669, 10670, 10671, 10674, 10675, 10676, 10677, 10678, 10679, 10680, 10681, 10682, 10683, 10684, 10685, 10686, 10687, 10688, 10689, 10690, 10691, 10692, 10693, 10694, 10696, 10697, 10698, 10699, 10700, 10701, 10702, 10703, 10704, 10705, 10706, 10707, 10708, 10709, 10710, 10711, 10712, 10713, 10714) 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 ('30612_ALU', 'TS102', 'GR_FILTRE_CYLIN', '451TW_LG205', '451TW_LG300', '6075040_4KIT', '66260_CONNECTEURY', '861AR_REDUCTEUR', '861HA_UNF', '861HI', '8AL2710019', '8AL2710022', '8AL2712022', '8AL2712118', '8AL2715020', '8AL33520221128', '8AL33520229122', '8AL335272210', '8AL33527221436', '8AL3356221132', '8AL33600221232', '8AL3551720', '8AL3553022', '8AL4704321', '8AL4755020_N', '8AL4755520_N', '8SP001295', '8SP001295SP', '8SP003355', '8SP07516', '8SP07518', 'ARAB54', 'ARAB65', 'ARAB80', 'JC100_B', 'JC100_S_B', 'JC55', 'JC55_S', 'RSP_RFTUSPEC065');

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