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 62500

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

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 (84332, 84333, 84334, 84335, 84336, 84338, 84339, 84340, 84341, 84342, 84343, 84344, 84345, 84346, 84347, 84348, 84349, 84350, 84351, 84352, 84353, 84354, 84355, 84356, 84357, 84358, 84359, 84360, 84361, 84362, 84363, 84364, 84365, 84366, 84367, 84368, 84369, 84370, 84371, 84372, 84373, 84374, 84375, 84376, 84377, 84378, 84379, 84380, 84381, 84382, 84383, 84384, 84385, 84386, 84387, 84388, 84389, 84390, 84391, 84392, 84393, 84394, 84395, 84396, 84397, 84398, 84399, 84400, 84401, 84402, 84403, 84404, 84405, 84406, 84407, 84408, 84409, 84410, 84411, 84412, 84413, 84414, 84415, 84416, 84417, 84418, 84419, 84420, 84421, 84422, 84423, 84424, 84425, 84426, 84427, 84428, 84429, 84430, 84431, 84432, 84433, 84434, 84435, 84436, 84437, 84438, 84439, 84440, 84441, 84442, 84443, 84444, 84445, 84446, 84447, 84448, 84449, 84450, 84451, 84452, 84453, 84454, 84455, 84456, 84457, 84458, 84459, 84460, 84461, 84462, 84463, 84464, 84465, 84466, 84467, 84468, 84469, 84470, 84471, 84472, 84473, 84474, 84475, 84476, 84477, 84478, 84479, 84480, 84481, 84482, 84483, 84484, 84485, 84486, 84487, 84488, 84489, 84490, 84491, 84492, 84493, 84494, 84495, 84496, 84497, 84498, 84499, 84500, 84501, 84502, 84503, 84504, 84505, 84506, 84507, 84508, 84509, 84510, 84511, 84512, 84513, 84514, 84515, 84516, 84517, 84518, 84519, 84520, 84521, 84522, 84523, 84524, 84525, 84526, 84527, 84528, 84529, 84530, 84531, 84532, 84533, 84534, 84535, 84536, 84537, 84538, 84539, 84540, 84541, 84542, 84543, 84544, 84545, 84546, 84547, 84548, 84549, 84550, 84551, 84552, 84553, 84554, 84555, 84556, 84557, 84558, 84559, 84560, 84561, 84562, 84563, 84564, 84565, 84566, 84567, 84568, 84569, 84570, 84571, 84572, 84573, 84574, 84575, 84576, 84577, 84578, 84579, 84580, 84581, 84582, 84583, 84584, 84585, 84586, 84587, 84588, 84589, 84590, 84591, 84592, 84593, 84594, 84595, 84596, 84597, 84598, 84599, 84600, 84601, 84602, 84603, 84604, 84605, 84606, 84607, 84608, 84609, 84610, 84611, 84612, 84613, 84614, 84615, 84616, 84617, 84618, 84619, 84620, 84621, 84622, 84623, 84624, 84625, 84626, 84627, 84628, 84629, 84630, 84631, 84632, 84633, 84634, 84635, 84636, 84637, 84638, 84639, 84640, 84641, 84642, 84643, 84644, 84645, 84646, 84647, 84648, 84649, 84650, 84651, 84652, 84653, 84654, 84655, 84656, 84657, 84658, 84659, 84660, 84661, 84662, 84663, 84664, 84665, 84666, 84667, 84668, 84669, 84670, 84671, 84672, 84673, 84674, 84675, 84676, 84677, 84678, 84679, 84680, 84681, 84682, 84683, 84684, 84685, 84686, 84687, 84688, 84689, 84690, 84691, 84692, 84693, 84694, 84695, 84697, 84698, 84699, 84703, 84704, 84705, 84706, 84707, 84708, 84709, 84710, 84711, 84712, 84713, 84714, 84715, 84716, 84717, 84718, 84719, 84720, 84721, 84750, 84751, 84752, 84753, 84754, 84755, 84756, 84757, 84758, 84759, 84760, 84761, 84762, 84763, 84764, 84765, 84766, 84767, 84768, 84769, 84770, 84771, 84772, 84773, 84774, 84775, 84776, 84777, 84778, 84779, 84780, 84781, 84782, 84783, 84784, 84785, 84786, 84787, 84788, 84789, 84790, 84791, 84792, 84793, 84794, 84795, 84796, 84797, 84798, 84799, 84800, 84801, 84802, 84803, 84804, 84805, 84806, 84807, 84808, 84809, 84810, 84811, 84812, 84813, 84814, 84815, 84816, 84817, 84818, 84819, 84820, 84821, 84822, 84823, 84824, 84825, 84826, 84827, 84828, 84829, 84830, 84831, 84832, 84833, 84834, 84835, 84836, 84837, 84838, 84839, 84840, 84841, 84842, 84843, 84844, 84845, 84846, 84847, 84848, 84849, 84850, 84851, 84852, 84853, 84854, 84855, 84856, 84857, 84858, 84859, 84860, 84861, 84862, 84863, 84864) 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 ('MAKGT5COBRA', 'MAKGT5HEMERA', 'MAKGT5NEO', 'MAKGT5OMEGA', 'MAKGT5RAIDEN', 'MAKMAG10HCOBRA', 'MAKMAG10HHEMERA', 'MAKMAG10HNEO', 'MAKMAG10HOMEGA', 'MAKMAG10HRAIDEN', '8OR00RB_DEMILUNE', 'KTM23_PAH_SWE', 'KTM23_SSH_TEA', 'MAKVENCACID', 'MAKVENCEAGLE', 'MAKVENCTONIC', 'MAKVENCVOL', 'MAKVENCXENA', 'SAT23_PLH_TEA', '8301019_4-100', 'ALP23_VSF_CUIB', 'ALP23_VSF_CUIN', 'ALP23_VSF_CUIO', '3723_COSSES', 'K_FILTRECONIQUE', '616LL461101_50', '8AL2711521', '8AL2712022', '8AL2715024', '8AL33550201241', '8AL3356024132', '8AL3356024155', '8AL3550224', '8AL3551524', '8AL3551724', '8AL3551824', '8AL3552024');

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