Symfony Profiler

SELECT
  s0_.name AS name_0,
  s0_.email AS email_1,
  s0_.url AS url_2,
  s0_.country AS country_3,
  s0_.locale AS locale_4,
  s0_.currency AS currency_5,
  s0_.order_base_number AS order_base_number_6,
  s0_.order_email AS order_email_7,
  s0_.id AS id_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10
FROM
  store s0_
ORDER BY
  s0_.id ASC

SELECT s0_.name AS name_0, s0_.email AS email_1, s0_.url AS url_2, s0_.country AS country_3, s0_.locale AS locale_4, s0_.currency AS currency_5, s0_.order_base_number AS order_base_number_6, s0_.order_email AS order_email_7, s0_.id AS id_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM store s0_ ORDER BY s0_.id ASC;

SELECT
  s0_.id AS id_0,
  s0_.content_id AS content_id_1,
  s0_.locale AS locale_2,
  s0_.slug AS slug_3,
  s0_.type AS type_4,
  s0_.previous_slug AS previous_slug_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7
FROM
  slug s0_
WHERE
  s0_.slug = ?
  AND s0_.locale IN (?)

SELECT s0_.id AS id_0, s0_.content_id AS content_id_1, s0_.locale AS locale_2, s0_.slug AS slug_3, s0_.type AS type_4, s0_.previous_slug AS previous_slug_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM slug s0_ WHERE s0_.slug = 'systemair-tst-315-difuzor' AND s0_.locale IN ('sk');

SELECT
  t0.type AS type_1,
  t0.warranty_years AS warranty_years_2,
  t0.new AS new_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.principal_category_id AS principal_category_id_7,
  t0.principal_image_id AS principal_image_id_8,
  t0.manufacturer_id AS manufacturer_id_9,
  t0.product_class_id AS product_class_id_10,
  t0.stock_id AS stock_id_11,
  t12.sku AS sku_13,
  t12.quantity AS quantity_14,
  t12.quantity_unit AS quantity_unit_15,
  t12.ean_code AS ean_code_16,
  t12.availability AS availability_17,
  t12.`condition` AS condition_18,
  t12.importable AS importable_19,
  t12.tax_transferable AS tax_transferable_20,
  t12.sale_count AS sale_count_21,
  t12.disabled_at AS disabled_at_22,
  t12.id AS id_23,
  t12.created_at AS created_at_24,
  t12.updated_at AS updated_at_25,
  t12.enabled AS enabled_26,
  t12.group_id AS group_id_27
FROM
  product t0
  LEFT JOIN stock t12 ON t0.stock_id = t12.id
WHERE
  t0.id = ?

SELECT t0.type AS type_1, t0.warranty_years AS warranty_years_2, t0.new AS new_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.principal_category_id AS principal_category_id_7, t0.principal_image_id AS principal_image_id_8, t0.manufacturer_id AS manufacturer_id_9, t0.product_class_id AS product_class_id_10, t0.stock_id AS stock_id_11, t12.sku AS sku_13, t12.quantity AS quantity_14, t12.quantity_unit AS quantity_unit_15, t12.ean_code AS ean_code_16, t12.availability AS availability_17, t12.`condition` AS condition_18, t12.importable AS importable_19, t12.tax_transferable AS tax_transferable_20, t12.sale_count AS sale_count_21, t12.disabled_at AS disabled_at_22, t12.id AS id_23, t12.created_at AS created_at_24, t12.updated_at AS updated_at_25, t12.enabled AS enabled_26, t12.group_id AS group_id_27 FROM product t0 LEFT JOIN stock t12 ON t0.stock_id = t12.id WHERE t0.id = 1543;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.principal_image_id AS principal_image_id_5,
  t0.product_id AS product_id_6,
  t0.stock_id AS stock_id_7,
  t8.sku AS sku_9,
  t8.quantity AS quantity_10,
  t8.quantity_unit AS quantity_unit_11,
  t8.ean_code AS ean_code_12,
  t8.availability AS availability_13,
  t8.`condition` AS condition_14,
  t8.importable AS importable_15,
  t8.tax_transferable AS tax_transferable_16,
  t8.sale_count AS sale_count_17,
  t8.disabled_at AS disabled_at_18,
  t8.id AS id_19,
  t8.created_at AS created_at_20,
  t8.updated_at AS updated_at_21,
  t8.enabled AS enabled_22,
  t8.group_id AS group_id_23
FROM
  variant t0
  LEFT JOIN stock t8 ON t0.stock_id = t8.id
WHERE
  t0.stock_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.principal_image_id AS principal_image_id_5, t0.product_id AS product_id_6, t0.stock_id AS stock_id_7, t8.sku AS sku_9, t8.quantity AS quantity_10, t8.quantity_unit AS quantity_unit_11, t8.ean_code AS ean_code_12, t8.availability AS availability_13, t8.`condition` AS condition_14, t8.importable AS importable_15, t8.tax_transferable AS tax_transferable_16, t8.sale_count AS sale_count_17, t8.disabled_at AS disabled_at_18, t8.id AS id_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.enabled AS enabled_22, t8.group_id AS group_id_23 FROM variant t0 LEFT JOIN stock t8 ON t0.stock_id = t8.id WHERE t0.stock_id = 1547;

SELECT
  p0_.id AS id_0,
  p1_.title AS title_1,
  p1_.h1 AS h1_2,
  p1_.perex AS perex_3,
  p1_.description AS description_4,
  p1_.text AS text_5,
  p1_.meta_title AS meta_title_6,
  p1_.meta_description AS meta_description_7,
  p1_.meta_keywords AS meta_keywords_8,
  p1_.slug AS slug_9,
  p1_.locale AS locale_10,
  p1_.id AS id_11,
  m2_.name AS name_12,
  m2_.slug AS slug_13,
  m2_.displayable AS displayable_14,
  m2_.id AS id_15,
  m2_.created_at AS created_at_16,
  m2_.updated_at AS updated_at_17,
  s3_.sku AS sku_18,
  s3_.quantity AS quantity_19,
  s3_.quantity_unit AS quantity_unit_20,
  s3_.ean_code AS ean_code_21,
  s3_.availability AS availability_22,
  s3_.`condition` AS condition_23,
  s3_.importable AS importable_24,
  s3_.tax_transferable AS tax_transferable_25,
  s3_.sale_count AS sale_count_26,
  s3_.disabled_at AS disabled_at_27,
  s3_.id AS id_28,
  s3_.created_at AS created_at_29,
  s3_.updated_at AS updated_at_30,
  s3_.enabled AS enabled_31,
  v4_.id AS id_32,
  v4_.position AS position_33,
  v4_.created_at AS created_at_34,
  v4_.updated_at AS updated_at_35,
  s5_.amount AS amount_36,
  s5_.tax_amount AS tax_amount_37,
  s5_.previous_amount AS previous_amount_38,
  s5_.previous_tax_amount AS previous_tax_amount_39,
  s5_.id AS id_40,
  s5_.created_at AS created_at_41,
  s5_.updated_at AS updated_at_42,
  p6_.id AS id_43,
  p6_.position AS position_44,
  p6_.created_at AS created_at_45,
  p6_.updated_at AS updated_at_46,
  p6_.enabled AS enabled_47,
  p7_.slug AS slug_48,
  p7_.title AS title_49,
  p7_.h1 AS h1_50,
  p7_.perex AS perex_51,
  p7_.description AS description_52,
  p7_.meta_title AS meta_title_53,
  p7_.meta_description AS meta_description_54,
  p7_.meta_keywords AS meta_keywords_55,
  p7_.locale AS locale_56,
  p7_.id AS id_57,
  p0_.principal_category_id AS principal_category_id_58,
  p0_.principal_image_id AS principal_image_id_59,
  p0_.manufacturer_id AS manufacturer_id_60,
  p0_.product_class_id AS product_class_id_61,
  p0_.stock_id AS stock_id_62,
  p1_.translatable_id AS translatable_id_63,
  m2_.principal_image_id AS principal_image_id_64,
  s3_.group_id AS group_id_65,
  v4_.principal_image_id AS principal_image_id_66,
  v4_.product_id AS product_id_67,
  v4_.stock_id AS stock_id_68,
  s5_.stock_id AS stock_id_69,
  s5_.store_id AS store_id_70,
  s5_.user_id AS user_id_71,
  s5_.tax_rate_id AS tax_rate_id_72,
  s5_.previous_tax_rate_id AS previous_tax_rate_id_73,
  p6_.principal_category_id AS principal_category_id_74,
  p6_.principal_image_id AS principal_image_id_75,
  p6_.manufacturer_id AS manufacturer_id_76,
  p6_.parent_id AS parent_id_77,
  p7_.translatable_id AS translatable_id_78
FROM
  product p0_
  LEFT JOIN product_translation p1_ ON p0_.id = p1_.translatable_id
  LEFT JOIN manufacturer m2_ ON p0_.manufacturer_id = m2_.id
  LEFT JOIN stock s3_ ON p0_.stock_id = s3_.id
  LEFT JOIN variant v4_ ON s3_.id = v4_.stock_id
  LEFT JOIN stock_price s5_ ON s3_.id = s5_.stock_id
  LEFT JOIN product_class p6_ ON p0_.product_class_id = p6_.id
  LEFT JOIN product_class_translation p7_ ON p6_.id = p7_.translatable_id
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p1_.title AS title_1, p1_.h1 AS h1_2, p1_.perex AS perex_3, p1_.description AS description_4, p1_.text AS text_5, p1_.meta_title AS meta_title_6, p1_.meta_description AS meta_description_7, p1_.meta_keywords AS meta_keywords_8, p1_.slug AS slug_9, p1_.locale AS locale_10, p1_.id AS id_11, m2_.name AS name_12, m2_.slug AS slug_13, m2_.displayable AS displayable_14, m2_.id AS id_15, m2_.created_at AS created_at_16, m2_.updated_at AS updated_at_17, s3_.sku AS sku_18, s3_.quantity AS quantity_19, s3_.quantity_unit AS quantity_unit_20, s3_.ean_code AS ean_code_21, s3_.availability AS availability_22, s3_.`condition` AS condition_23, s3_.importable AS importable_24, s3_.tax_transferable AS tax_transferable_25, s3_.sale_count AS sale_count_26, s3_.disabled_at AS disabled_at_27, s3_.id AS id_28, s3_.created_at AS created_at_29, s3_.updated_at AS updated_at_30, s3_.enabled AS enabled_31, v4_.id AS id_32, v4_.position AS position_33, v4_.created_at AS created_at_34, v4_.updated_at AS updated_at_35, s5_.amount AS amount_36, s5_.tax_amount AS tax_amount_37, s5_.previous_amount AS previous_amount_38, s5_.previous_tax_amount AS previous_tax_amount_39, s5_.id AS id_40, s5_.created_at AS created_at_41, s5_.updated_at AS updated_at_42, p6_.id AS id_43, p6_.position AS position_44, p6_.created_at AS created_at_45, p6_.updated_at AS updated_at_46, p6_.enabled AS enabled_47, p7_.slug AS slug_48, p7_.title AS title_49, p7_.h1 AS h1_50, p7_.perex AS perex_51, p7_.description AS description_52, p7_.meta_title AS meta_title_53, p7_.meta_description AS meta_description_54, p7_.meta_keywords AS meta_keywords_55, p7_.locale AS locale_56, p7_.id AS id_57, p0_.principal_category_id AS principal_category_id_58, p0_.principal_image_id AS principal_image_id_59, p0_.manufacturer_id AS manufacturer_id_60, p0_.product_class_id AS product_class_id_61, p0_.stock_id AS stock_id_62, p1_.translatable_id AS translatable_id_63, m2_.principal_image_id AS principal_image_id_64, s3_.group_id AS group_id_65, v4_.principal_image_id AS principal_image_id_66, v4_.product_id AS product_id_67, v4_.stock_id AS stock_id_68, s5_.stock_id AS stock_id_69, s5_.store_id AS store_id_70, s5_.user_id AS user_id_71, s5_.tax_rate_id AS tax_rate_id_72, s5_.previous_tax_rate_id AS previous_tax_rate_id_73, p6_.principal_category_id AS principal_category_id_74, p6_.principal_image_id AS principal_image_id_75, p6_.manufacturer_id AS manufacturer_id_76, p6_.parent_id AS parent_id_77, p7_.translatable_id AS translatable_id_78 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN manufacturer m2_ ON p0_.manufacturer_id = m2_.id LEFT JOIN stock s3_ ON p0_.stock_id = s3_.id LEFT JOIN variant v4_ ON s3_.id = v4_.stock_id LEFT JOIN stock_price s5_ ON s3_.id = s5_.stock_id LEFT JOIN product_class p6_ ON p0_.product_class_id = p6_.id LEFT JOIN product_class_translation p7_ ON p6_.id = p7_.translatable_id WHERE p0_.id = 1543;

SELECT
  p0_.id AS id_0,
  p1_.`group` AS group_1,
  p1_.position AS position_2,
  p2_.type AS type_3,
  p2_.warranty_years AS warranty_years_4,
  p2_.new AS new_5,
  p2_.id AS id_6,
  p2_.created_at AS created_at_7,
  p2_.updated_at AS updated_at_8,
  p3_.title AS title_9,
  p3_.h1 AS h1_10,
  p3_.perex AS perex_11,
  p3_.description AS description_12,
  p3_.text AS text_13,
  p3_.meta_title AS meta_title_14,
  p3_.meta_description AS meta_description_15,
  p3_.meta_keywords AS meta_keywords_16,
  p3_.slug AS slug_17,
  p3_.locale AS locale_18,
  p3_.id AS id_19,
  s4_.sku AS sku_20,
  s4_.quantity AS quantity_21,
  s4_.quantity_unit AS quantity_unit_22,
  s4_.ean_code AS ean_code_23,
  s4_.availability AS availability_24,
  s4_.`condition` AS condition_25,
  s4_.importable AS importable_26,
  s4_.tax_transferable AS tax_transferable_27,
  s4_.sale_count AS sale_count_28,
  s4_.disabled_at AS disabled_at_29,
  s4_.id AS id_30,
  s4_.created_at AS created_at_31,
  s4_.updated_at AS updated_at_32,
  s4_.enabled AS enabled_33,
  v5_.id AS id_34,
  v5_.position AS position_35,
  v5_.created_at AS created_at_36,
  v5_.updated_at AS updated_at_37,
  s6_.amount AS amount_38,
  s6_.tax_amount AS tax_amount_39,
  s6_.previous_amount AS previous_amount_40,
  s6_.previous_tax_amount AS previous_tax_amount_41,
  s6_.id AS id_42,
  s6_.created_at AS created_at_43,
  s6_.updated_at AS updated_at_44,
  p0_.principal_category_id AS principal_category_id_45,
  p0_.principal_image_id AS principal_image_id_46,
  p0_.manufacturer_id AS manufacturer_id_47,
  p0_.product_class_id AS product_class_id_48,
  p0_.stock_id AS stock_id_49,
  p1_.parent_id AS parent_id_50,
  p1_.item_id AS item_id_51,
  p2_.principal_category_id AS principal_category_id_52,
  p2_.principal_image_id AS principal_image_id_53,
  p2_.manufacturer_id AS manufacturer_id_54,
  p2_.product_class_id AS product_class_id_55,
  p2_.stock_id AS stock_id_56,
  p3_.translatable_id AS translatable_id_57,
  s4_.group_id AS group_id_58,
  v5_.principal_image_id AS principal_image_id_59,
  v5_.product_id AS product_id_60,
  v5_.stock_id AS stock_id_61,
  s6_.stock_id AS stock_id_62,
  s6_.store_id AS store_id_63,
  s6_.user_id AS user_id_64,
  s6_.tax_rate_id AS tax_rate_id_65,
  s6_.previous_tax_rate_id AS previous_tax_rate_id_66
FROM
  product p0_
  LEFT JOIN product_accessory p1_ ON p0_.id = p1_.parent_id
  LEFT JOIN product p2_ ON p1_.item_id = p2_.id
  LEFT JOIN product_translation p3_ ON p2_.id = p3_.translatable_id
  LEFT JOIN stock s4_ ON p2_.stock_id = s4_.id
  LEFT JOIN variant v5_ ON s4_.id = v5_.stock_id
  LEFT JOIN stock_price s6_ ON s4_.id = s6_.stock_id
WHERE
  p0_.id = ?
ORDER BY
  p1_.position ASC

SELECT p0_.id AS id_0, p1_.`group` AS group_1, p1_.position AS position_2, p2_.type AS type_3, p2_.warranty_years AS warranty_years_4, p2_.new AS new_5, p2_.id AS id_6, p2_.created_at AS created_at_7, p2_.updated_at AS updated_at_8, p3_.title AS title_9, p3_.h1 AS h1_10, p3_.perex AS perex_11, p3_.description AS description_12, p3_.text AS text_13, p3_.meta_title AS meta_title_14, p3_.meta_description AS meta_description_15, p3_.meta_keywords AS meta_keywords_16, p3_.slug AS slug_17, p3_.locale AS locale_18, p3_.id AS id_19, s4_.sku AS sku_20, s4_.quantity AS quantity_21, s4_.quantity_unit AS quantity_unit_22, s4_.ean_code AS ean_code_23, s4_.availability AS availability_24, s4_.`condition` AS condition_25, s4_.importable AS importable_26, s4_.tax_transferable AS tax_transferable_27, s4_.sale_count AS sale_count_28, s4_.disabled_at AS disabled_at_29, s4_.id AS id_30, s4_.created_at AS created_at_31, s4_.updated_at AS updated_at_32, s4_.enabled AS enabled_33, v5_.id AS id_34, v5_.position AS position_35, v5_.created_at AS created_at_36, v5_.updated_at AS updated_at_37, s6_.amount AS amount_38, s6_.tax_amount AS tax_amount_39, s6_.previous_amount AS previous_amount_40, s6_.previous_tax_amount AS previous_tax_amount_41, s6_.id AS id_42, s6_.created_at AS created_at_43, s6_.updated_at AS updated_at_44, p0_.principal_category_id AS principal_category_id_45, p0_.principal_image_id AS principal_image_id_46, p0_.manufacturer_id AS manufacturer_id_47, p0_.product_class_id AS product_class_id_48, p0_.stock_id AS stock_id_49, p1_.parent_id AS parent_id_50, p1_.item_id AS item_id_51, p2_.principal_category_id AS principal_category_id_52, p2_.principal_image_id AS principal_image_id_53, p2_.manufacturer_id AS manufacturer_id_54, p2_.product_class_id AS product_class_id_55, p2_.stock_id AS stock_id_56, p3_.translatable_id AS translatable_id_57, s4_.group_id AS group_id_58, v5_.principal_image_id AS principal_image_id_59, v5_.product_id AS product_id_60, v5_.stock_id AS stock_id_61, s6_.stock_id AS stock_id_62, s6_.store_id AS store_id_63, s6_.user_id AS user_id_64, s6_.tax_rate_id AS tax_rate_id_65, s6_.previous_tax_rate_id AS previous_tax_rate_id_66 FROM product p0_ LEFT JOIN product_accessory p1_ ON p0_.id = p1_.parent_id LEFT JOIN product p2_ ON p1_.item_id = p2_.id LEFT JOIN product_translation p3_ ON p2_.id = p3_.translatable_id LEFT JOIN stock s4_ ON p2_.stock_id = s4_.id LEFT JOIN variant v5_ ON s4_.id = v5_.stock_id LEFT JOIN stock_price s6_ ON s4_.id = s6_.stock_id WHERE p0_.id = 1543 ORDER BY p1_.position ASC;

SELECT
  p0_.id AS id_0,
  p1_.position AS position_1,
  a2_.class AS class_2,
  a2_.icon AS icon_3,
  a2_.id AS id_4,
  a2_.position AS position_5,
  a2_.created_at AS created_at_6,
  a2_.updated_at AS updated_at_7,
  a3_.title AS title_8,
  a3_.description AS description_9,
  a3_.locale AS locale_10,
  a3_.id AS id_11,
  a4_.class AS class_12,
  a4_.id AS id_13,
  a4_.position AS position_14,
  a4_.created_at AS created_at_15,
  a4_.updated_at AS updated_at_16,
  a5_.title AS title_17,
  a5_.description AS description_18,
  a5_.locale AS locale_19,
  a5_.id AS id_20,
  p0_.principal_category_id AS principal_category_id_21,
  p0_.principal_image_id AS principal_image_id_22,
  p0_.manufacturer_id AS manufacturer_id_23,
  p0_.product_class_id AS product_class_id_24,
  p0_.stock_id AS stock_id_25,
  p1_.product_id AS product_id_26,
  p1_.advantage_id AS advantage_id_27,
  a2_.group_id AS group_id_28,
  a3_.translatable_id AS translatable_id_29,
  a4_.parent_id AS parent_id_30,
  a5_.translatable_id AS translatable_id_31
FROM
  product p0_
  LEFT JOIN product_advantage p1_ ON p0_.id = p1_.product_id
  LEFT JOIN advantage a2_ ON p1_.advantage_id = a2_.id
  LEFT JOIN advantage_translation a3_ ON a2_.id = a3_.translatable_id
  LEFT JOIN advantage_group a4_ ON a2_.group_id = a4_.id
  LEFT JOIN advantage_group_translation a5_ ON a4_.id = a5_.translatable_id
WHERE
  p0_.id = ?
ORDER BY
  p1_.position ASC

SELECT p0_.id AS id_0, p1_.position AS position_1, a2_.class AS class_2, a2_.icon AS icon_3, a2_.id AS id_4, a2_.position AS position_5, a2_.created_at AS created_at_6, a2_.updated_at AS updated_at_7, a3_.title AS title_8, a3_.description AS description_9, a3_.locale AS locale_10, a3_.id AS id_11, a4_.class AS class_12, a4_.id AS id_13, a4_.position AS position_14, a4_.created_at AS created_at_15, a4_.updated_at AS updated_at_16, a5_.title AS title_17, a5_.description AS description_18, a5_.locale AS locale_19, a5_.id AS id_20, p0_.principal_category_id AS principal_category_id_21, p0_.principal_image_id AS principal_image_id_22, p0_.manufacturer_id AS manufacturer_id_23, p0_.product_class_id AS product_class_id_24, p0_.stock_id AS stock_id_25, p1_.product_id AS product_id_26, p1_.advantage_id AS advantage_id_27, a2_.group_id AS group_id_28, a3_.translatable_id AS translatable_id_29, a4_.parent_id AS parent_id_30, a5_.translatable_id AS translatable_id_31 FROM product p0_ LEFT JOIN product_advantage p1_ ON p0_.id = p1_.product_id LEFT JOIN advantage a2_ ON p1_.advantage_id = a2_.id LEFT JOIN advantage_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN advantage_group a4_ ON a2_.group_id = a4_.id LEFT JOIN advantage_group_translation a5_ ON a4_.id = a5_.translatable_id WHERE p0_.id = 1543 ORDER BY p1_.position ASC;

SELECT
  p0_.id AS id_0,
  p1_.value AS value_1,
  p1_.on_listing AS on_listing_2,
  p1_.configurable AS configurable_3,
  p1_.id AS id_4,
  p1_.position AS position_5,
  a2_.alias AS alias_6,
  a2_.class AS class_7,
  a2_.icon AS icon_8,
  a2_.on_detail AS on_detail_9,
  a2_.on_listing AS on_listing_10,
  a2_.expanded AS expanded_11,
  a2_.id AS id_12,
  a2_.position AS position_13,
  a2_.created_at AS created_at_14,
  a2_.updated_at AS updated_at_15,
  a3_.title AS title_16,
  a3_.description AS description_17,
  a3_.unit AS unit_18,
  a3_.locale AS locale_19,
  a3_.id AS id_20,
  a4_.class AS class_21,
  a4_.id AS id_22,
  a4_.position AS position_23,
  a4_.created_at AS created_at_24,
  a4_.updated_at AS updated_at_25,
  a5_.title AS title_26,
  a5_.description AS description_27,
  a5_.locale AS locale_28,
  a5_.id AS id_29,
  p0_.principal_category_id AS principal_category_id_30,
  p0_.principal_image_id AS principal_image_id_31,
  p0_.manufacturer_id AS manufacturer_id_32,
  p0_.product_class_id AS product_class_id_33,
  p0_.stock_id AS stock_id_34,
  p1_.product_id AS product_id_35,
  p1_.attribute_id AS attribute_id_36,
  p1_.attribute_option_id AS attribute_option_id_37,
  p1_.principal_image_id AS principal_image_id_38,
  a2_.group_id AS group_id_39,
  a3_.translatable_id AS translatable_id_40,
  a4_.parent_id AS parent_id_41,
  a5_.translatable_id AS translatable_id_42
FROM
  product p0_
  LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id
  LEFT JOIN attribute a2_ ON p1_.attribute_id = a2_.id
  LEFT JOIN attribute_translation a3_ ON a2_.id = a3_.translatable_id
  LEFT JOIN attribute_group a4_ ON a2_.group_id = a4_.id
  LEFT JOIN attribute_group_translation a5_ ON a4_.id = a5_.translatable_id
WHERE
  p0_.id = ?
ORDER BY
  p1_.position ASC

SELECT p0_.id AS id_0, p1_.value AS value_1, p1_.on_listing AS on_listing_2, p1_.configurable AS configurable_3, p1_.id AS id_4, p1_.position AS position_5, a2_.alias AS alias_6, a2_.class AS class_7, a2_.icon AS icon_8, a2_.on_detail AS on_detail_9, a2_.on_listing AS on_listing_10, a2_.expanded AS expanded_11, a2_.id AS id_12, a2_.position AS position_13, a2_.created_at AS created_at_14, a2_.updated_at AS updated_at_15, a3_.title AS title_16, a3_.description AS description_17, a3_.unit AS unit_18, a3_.locale AS locale_19, a3_.id AS id_20, a4_.class AS class_21, a4_.id AS id_22, a4_.position AS position_23, a4_.created_at AS created_at_24, a4_.updated_at AS updated_at_25, a5_.title AS title_26, a5_.description AS description_27, a5_.locale AS locale_28, a5_.id AS id_29, p0_.principal_category_id AS principal_category_id_30, p0_.principal_image_id AS principal_image_id_31, p0_.manufacturer_id AS manufacturer_id_32, p0_.product_class_id AS product_class_id_33, p0_.stock_id AS stock_id_34, p1_.product_id AS product_id_35, p1_.attribute_id AS attribute_id_36, p1_.attribute_option_id AS attribute_option_id_37, p1_.principal_image_id AS principal_image_id_38, a2_.group_id AS group_id_39, a3_.translatable_id AS translatable_id_40, a4_.parent_id AS parent_id_41, a5_.translatable_id AS translatable_id_42 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN attribute a2_ ON p1_.attribute_id = a2_.id LEFT JOIN attribute_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN attribute_group a4_ ON a2_.group_id = a4_.id LEFT JOIN attribute_group_translation a5_ ON a4_.id = a5_.translatable_id WHERE p0_.id = 1543 ORDER BY p1_.position ASC;