| 1 |
0.93 ms |
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;
|
| 2 |
0.48 ms |
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 (?)
Parameters: [
"terma-vivo-1150x500-vodny-elektricky-radiator-white-matt-zs"
"sk"
]
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 = 'terma-vivo-1150x500-vodny-elektricky-radiator-white-matt-zs' AND s0_.locale IN ('sk');
|
| 3 |
0.63 ms |
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 = 5952;
|
| 4 |
0.52 ms |
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 = 8948;
|
| 5 |
1.46 ms |
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 = ?
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 = 5952;
|
| 6 |
5.17 ms |
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 = ?
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 = 5952 ORDER BY p1_.position ASC;
|
| 7 |
0.89 ms |
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 = 5952 ORDER BY p1_.position ASC;
|
| 8 |
1.59 ms |
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 = ?
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 = 5952 ORDER BY p1_.position ASC;
|
| 9 |
1.15 ms |
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, p2_.amount AS amount_6, p2_.tax_amount AS tax_amount_7, p2_.previous_amount AS previous_amount_8, p2_.previous_tax_amount AS previous_tax_amount_9, p2_.id AS id_10, p2_.created_at AS created_at_11, p2_.updated_at AS updated_at_12, i3_.name AS name_13, i3_.original_name AS original_name_14, i3_.mime_type AS mime_type_15, i3_.size AS size_16, i3_.width AS width_17, i3_.height AS height_18, i3_.id AS id_19, i3_.created_at AS created_at_20, i3_.updated_at AS updated_at_21, i4_.title AS title_22, i4_.keywords AS keywords_23, i4_.locale AS locale_24, i4_.id AS id_25, p0_.principal_category_id AS principal_category_id_26, p0_.principal_image_id AS principal_image_id_27, p0_.manufacturer_id AS manufacturer_id_28, p0_.product_class_id AS product_class_id_29, p0_.stock_id AS stock_id_30, p1_.product_id AS product_id_31, p1_.attribute_id AS attribute_id_32, p1_.attribute_option_id AS attribute_option_id_33, p1_.principal_image_id AS principal_image_id_34, p2_.product_attribute_id AS product_attribute_id_35, p2_.store_id AS store_id_36, p2_.user_id AS user_id_37, p2_.tax_rate_id AS tax_rate_id_38, p2_.previous_tax_rate_id AS previous_tax_rate_id_39, i4_.translatable_id AS translatable_id_40 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_attribute_price p2_ ON p1_.id = p2_.product_attribute_id LEFT JOIN image i3_ ON p1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.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,
p2_.amount AS amount_6,
p2_.tax_amount AS tax_amount_7,
p2_.previous_amount AS previous_amount_8,
p2_.previous_tax_amount AS previous_tax_amount_9,
p2_.id AS id_10,
p2_.created_at AS created_at_11,
p2_.updated_at AS updated_at_12,
i3_.name AS name_13,
i3_.original_name AS original_name_14,
i3_.mime_type AS mime_type_15,
i3_.size AS size_16,
i3_.width AS width_17,
i3_.height AS height_18,
i3_.id AS id_19,
i3_.created_at AS created_at_20,
i3_.updated_at AS updated_at_21,
i4_.title AS title_22,
i4_.keywords AS keywords_23,
i4_.locale AS locale_24,
i4_.id AS id_25,
p0_.principal_category_id AS principal_category_id_26,
p0_.principal_image_id AS principal_image_id_27,
p0_.manufacturer_id AS manufacturer_id_28,
p0_.product_class_id AS product_class_id_29,
p0_.stock_id AS stock_id_30,
p1_.product_id AS product_id_31,
p1_.attribute_id AS attribute_id_32,
p1_.attribute_option_id AS attribute_option_id_33,
p1_.principal_image_id AS principal_image_id_34,
p2_.product_attribute_id AS product_attribute_id_35,
p2_.store_id AS store_id_36,
p2_.user_id AS user_id_37,
p2_.tax_rate_id AS tax_rate_id_38,
p2_.previous_tax_rate_id AS previous_tax_rate_id_39,
i4_.translatable_id AS translatable_id_40
FROM
product p0_
LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id
LEFT JOIN product_attribute_price p2_ ON p1_.id = p2_.product_attribute_id
LEFT JOIN image i3_ ON p1_.principal_image_id = i3_.id
LEFT JOIN image_translation i4_ ON i3_.id = i4_.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, p2_.amount AS amount_6, p2_.tax_amount AS tax_amount_7, p2_.previous_amount AS previous_amount_8, p2_.previous_tax_amount AS previous_tax_amount_9, p2_.id AS id_10, p2_.created_at AS created_at_11, p2_.updated_at AS updated_at_12, i3_.name AS name_13, i3_.original_name AS original_name_14, i3_.mime_type AS mime_type_15, i3_.size AS size_16, i3_.width AS width_17, i3_.height AS height_18, i3_.id AS id_19, i3_.created_at AS created_at_20, i3_.updated_at AS updated_at_21, i4_.title AS title_22, i4_.keywords AS keywords_23, i4_.locale AS locale_24, i4_.id AS id_25, p0_.principal_category_id AS principal_category_id_26, p0_.principal_image_id AS principal_image_id_27, p0_.manufacturer_id AS manufacturer_id_28, p0_.product_class_id AS product_class_id_29, p0_.stock_id AS stock_id_30, p1_.product_id AS product_id_31, p1_.attribute_id AS attribute_id_32, p1_.attribute_option_id AS attribute_option_id_33, p1_.principal_image_id AS principal_image_id_34, p2_.product_attribute_id AS product_attribute_id_35, p2_.store_id AS store_id_36, p2_.user_id AS user_id_37, p2_.tax_rate_id AS tax_rate_id_38, p2_.previous_tax_rate_id AS previous_tax_rate_id_39, i4_.translatable_id AS translatable_id_40 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_attribute_price p2_ ON p1_.id = p2_.product_attribute_id LEFT JOIN image i3_ ON p1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id WHERE p0_.id = 5952 ORDER BY p1_.position ASC;
|
| 10 |
1.73 ms |
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_.id AS id_6, a2_.position AS position_7, a2_.created_at AS created_at_8, a2_.updated_at AS updated_at_9, a3_.title AS title_10, a3_.description AS description_11, a3_.slug AS slug_12, a3_.locale AS locale_13, a3_.id AS id_14, i4_.name AS name_15, i4_.original_name AS original_name_16, i4_.mime_type AS mime_type_17, i4_.size AS size_18, i4_.width AS width_19, i4_.height AS height_20, i4_.id AS id_21, i4_.created_at AS created_at_22, i4_.updated_at AS updated_at_23, i5_.title AS title_24, i5_.keywords AS keywords_25, i5_.locale AS locale_26, i5_.id AS id_27, p0_.principal_category_id AS principal_category_id_28, p0_.principal_image_id AS principal_image_id_29, p0_.manufacturer_id AS manufacturer_id_30, p0_.product_class_id AS product_class_id_31, p0_.stock_id AS stock_id_32, p1_.product_id AS product_id_33, p1_.attribute_id AS attribute_id_34, p1_.attribute_option_id AS attribute_option_id_35, p1_.principal_image_id AS principal_image_id_36, a2_.attribute_id AS attribute_id_37, a2_.principal_image_id AS principal_image_id_38, a3_.translatable_id AS translatable_id_39, i5_.translatable_id AS translatable_id_40 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN attribute_option a2_ ON p1_.attribute_option_id = a2_.id LEFT JOIN attribute_option_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN image i4_ ON a2_.principal_image_id = i4_.id LEFT JOIN image_translation i5_ ON i4_.id = i5_.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_.id AS id_6,
a2_.position AS position_7,
a2_.created_at AS created_at_8,
a2_.updated_at AS updated_at_9,
a3_.title AS title_10,
a3_.description AS description_11,
a3_.slug AS slug_12,
a3_.locale AS locale_13,
a3_.id AS id_14,
i4_.name AS name_15,
i4_.original_name AS original_name_16,
i4_.mime_type AS mime_type_17,
i4_.size AS size_18,
i4_.width AS width_19,
i4_.height AS height_20,
i4_.id AS id_21,
i4_.created_at AS created_at_22,
i4_.updated_at AS updated_at_23,
i5_.title AS title_24,
i5_.keywords AS keywords_25,
i5_.locale AS locale_26,
i5_.id AS id_27,
p0_.principal_category_id AS principal_category_id_28,
p0_.principal_image_id AS principal_image_id_29,
p0_.manufacturer_id AS manufacturer_id_30,
p0_.product_class_id AS product_class_id_31,
p0_.stock_id AS stock_id_32,
p1_.product_id AS product_id_33,
p1_.attribute_id AS attribute_id_34,
p1_.attribute_option_id AS attribute_option_id_35,
p1_.principal_image_id AS principal_image_id_36,
a2_.attribute_id AS attribute_id_37,
a2_.principal_image_id AS principal_image_id_38,
a3_.translatable_id AS translatable_id_39,
i5_.translatable_id AS translatable_id_40
FROM
product p0_
LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id
LEFT JOIN attribute_option a2_ ON p1_.attribute_option_id = a2_.id
LEFT JOIN attribute_option_translation a3_ ON a2_.id = a3_.translatable_id
LEFT JOIN image i4_ ON a2_.principal_image_id = i4_.id
LEFT JOIN image_translation i5_ ON i4_.id = i5_.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_.id AS id_6, a2_.position AS position_7, a2_.created_at AS created_at_8, a2_.updated_at AS updated_at_9, a3_.title AS title_10, a3_.description AS description_11, a3_.slug AS slug_12, a3_.locale AS locale_13, a3_.id AS id_14, i4_.name AS name_15, i4_.original_name AS original_name_16, i4_.mime_type AS mime_type_17, i4_.size AS size_18, i4_.width AS width_19, i4_.height AS height_20, i4_.id AS id_21, i4_.created_at AS created_at_22, i4_.updated_at AS updated_at_23, i5_.title AS title_24, i5_.keywords AS keywords_25, i5_.locale AS locale_26, i5_.id AS id_27, p0_.principal_category_id AS principal_category_id_28, p0_.principal_image_id AS principal_image_id_29, p0_.manufacturer_id AS manufacturer_id_30, p0_.product_class_id AS product_class_id_31, p0_.stock_id AS stock_id_32, p1_.product_id AS product_id_33, p1_.attribute_id AS attribute_id_34, p1_.attribute_option_id AS attribute_option_id_35, p1_.principal_image_id AS principal_image_id_36, a2_.attribute_id AS attribute_id_37, a2_.principal_image_id AS principal_image_id_38, a3_.translatable_id AS translatable_id_39, i5_.translatable_id AS translatable_id_40 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN attribute_option a2_ ON p1_.attribute_option_id = a2_.id LEFT JOIN attribute_option_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN image i4_ ON a2_.principal_image_id = i4_.id LEFT JOIN image_translation i5_ ON i4_.id = i5_.translatable_id WHERE p0_.id = 5952 ORDER BY p1_.position ASC;
|
| 11 |
1.06 ms |
SELECT p0_.id AS id_0, v1_.id AS id_1, v1_.position AS position_2, v1_.created_at AS created_at_3, v1_.updated_at AS updated_at_4, s2_.sku AS sku_5, s2_.quantity AS quantity_6, s2_.quantity_unit AS quantity_unit_7, s2_.ean_code AS ean_code_8, s2_.availability AS availability_9, s2_.`condition` AS condition_10, s2_.importable AS importable_11, s2_.tax_transferable AS tax_transferable_12, s2_.sale_count AS sale_count_13, s2_.disabled_at AS disabled_at_14, s2_.id AS id_15, s2_.created_at AS created_at_16, s2_.updated_at AS updated_at_17, s2_.enabled AS enabled_18, p3_.type AS type_19, p3_.warranty_years AS warranty_years_20, p3_.new AS new_21, p3_.id AS id_22, p3_.created_at AS created_at_23, p3_.updated_at AS updated_at_24, s4_.amount AS amount_25, s4_.tax_amount AS tax_amount_26, s4_.previous_amount AS previous_amount_27, s4_.previous_tax_amount AS previous_tax_amount_28, s4_.id AS id_29, s4_.created_at AS created_at_30, s4_.updated_at AS updated_at_31, v5_.position AS position_32, a6_.id AS id_33, a6_.position AS position_34, a6_.created_at AS created_at_35, a6_.updated_at AS updated_at_36, a7_.title AS title_37, a7_.description AS description_38, a7_.slug AS slug_39, a7_.locale AS locale_40, a7_.id AS id_41, p0_.principal_category_id AS principal_category_id_42, p0_.principal_image_id AS principal_image_id_43, p0_.manufacturer_id AS manufacturer_id_44, p0_.product_class_id AS product_class_id_45, p0_.stock_id AS stock_id_46, v1_.principal_image_id AS principal_image_id_47, v1_.product_id AS product_id_48, v1_.stock_id AS stock_id_49, s2_.group_id AS group_id_50, p3_.principal_category_id AS principal_category_id_51, p3_.principal_image_id AS principal_image_id_52, p3_.manufacturer_id AS manufacturer_id_53, p3_.product_class_id AS product_class_id_54, p3_.stock_id AS stock_id_55, s4_.stock_id AS stock_id_56, s4_.store_id AS store_id_57, s4_.user_id AS user_id_58, s4_.tax_rate_id AS tax_rate_id_59, s4_.previous_tax_rate_id AS previous_tax_rate_id_60, v5_.variant_id AS variant_id_61, v5_.attribute_option_id AS attribute_option_id_62, a6_.attribute_id AS attribute_id_63, a6_.principal_image_id AS principal_image_id_64, a7_.translatable_id AS translatable_id_65 FROM product p0_ LEFT JOIN variant v1_ ON p0_.id = v1_.product_id LEFT JOIN stock s2_ ON v1_.stock_id = s2_.id LEFT JOIN product p3_ ON s2_.id = p3_.stock_id LEFT JOIN stock_price s4_ ON s2_.id = s4_.stock_id LEFT JOIN variant_attribute v5_ ON v1_.id = v5_.variant_id LEFT JOIN attribute_option a6_ ON v5_.attribute_option_id = a6_.id LEFT JOIN attribute_option_translation a7_ ON a6_.id = a7_.translatable_id WHERE p0_.id = ? ORDER BY v1_.position ASC, v5_.position ASC
SELECT
p0_.id AS id_0,
v1_.id AS id_1,
v1_.position AS position_2,
v1_.created_at AS created_at_3,
v1_.updated_at AS updated_at_4,
s2_.sku AS sku_5,
s2_.quantity AS quantity_6,
s2_.quantity_unit AS quantity_unit_7,
s2_.ean_code AS ean_code_8,
s2_.availability AS availability_9,
s2_.`condition` AS condition_10,
s2_.importable AS importable_11,
s2_.tax_transferable AS tax_transferable_12,
s2_.sale_count AS sale_count_13,
s2_.disabled_at AS disabled_at_14,
s2_.id AS id_15,
s2_.created_at AS created_at_16,
s2_.updated_at AS updated_at_17,
s2_.enabled AS enabled_18,
p3_.type AS type_19,
p3_.warranty_years AS warranty_years_20,
p3_.new AS new_21,
p3_.id AS id_22,
p3_.created_at AS created_at_23,
p3_.updated_at AS updated_at_24,
s4_.amount AS amount_25,
s4_.tax_amount AS tax_amount_26,
s4_.previous_amount AS previous_amount_27,
s4_.previous_tax_amount AS previous_tax_amount_28,
s4_.id AS id_29,
s4_.created_at AS created_at_30,
s4_.updated_at AS updated_at_31,
v5_.position AS position_32,
a6_.id AS id_33,
a6_.position AS position_34,
a6_.created_at AS created_at_35,
a6_.updated_at AS updated_at_36,
a7_.title AS title_37,
a7_.description AS description_38,
a7_.slug AS slug_39,
a7_.locale AS locale_40,
a7_.id AS id_41,
p0_.principal_category_id AS principal_category_id_42,
p0_.principal_image_id AS principal_image_id_43,
p0_.manufacturer_id AS manufacturer_id_44,
p0_.product_class_id AS product_class_id_45,
p0_.stock_id AS stock_id_46,
v1_.principal_image_id AS principal_image_id_47,
v1_.product_id AS product_id_48,
v1_.stock_id AS stock_id_49,
s2_.group_id AS group_id_50,
p3_.principal_category_id AS principal_category_id_51,
p3_.principal_image_id AS principal_image_id_52,
p3_.manufacturer_id AS manufacturer_id_53,
p3_.product_class_id AS product_class_id_54,
p3_.stock_id AS stock_id_55,
s4_.stock_id AS stock_id_56,
s4_.store_id AS store_id_57,
s4_.user_id AS user_id_58,
s4_.tax_rate_id AS tax_rate_id_59,
s4_.previous_tax_rate_id AS previous_tax_rate_id_60,
v5_.variant_id AS variant_id_61,
v5_.attribute_option_id AS attribute_option_id_62,
a6_.attribute_id AS attribute_id_63,
a6_.principal_image_id AS principal_image_id_64,
a7_.translatable_id AS translatable_id_65
FROM
product p0_
LEFT JOIN variant v1_ ON p0_.id = v1_.product_id
LEFT JOIN stock s2_ ON v1_.stock_id = s2_.id
LEFT JOIN product p3_ ON s2_.id = p3_.stock_id
LEFT JOIN stock_price s4_ ON s2_.id = s4_.stock_id
LEFT JOIN variant_attribute v5_ ON v1_.id = v5_.variant_id
LEFT JOIN attribute_option a6_ ON v5_.attribute_option_id = a6_.id
LEFT JOIN attribute_option_translation a7_ ON a6_.id = a7_.translatable_id
WHERE
p0_.id = ?
ORDER BY
v1_.position ASC,
v5_.position ASC
SELECT p0_.id AS id_0, v1_.id AS id_1, v1_.position AS position_2, v1_.created_at AS created_at_3, v1_.updated_at AS updated_at_4, s2_.sku AS sku_5, s2_.quantity AS quantity_6, s2_.quantity_unit AS quantity_unit_7, s2_.ean_code AS ean_code_8, s2_.availability AS availability_9, s2_.`condition` AS condition_10, s2_.importable AS importable_11, s2_.tax_transferable AS tax_transferable_12, s2_.sale_count AS sale_count_13, s2_.disabled_at AS disabled_at_14, s2_.id AS id_15, s2_.created_at AS created_at_16, s2_.updated_at AS updated_at_17, s2_.enabled AS enabled_18, p3_.type AS type_19, p3_.warranty_years AS warranty_years_20, p3_.new AS new_21, p3_.id AS id_22, p3_.created_at AS created_at_23, p3_.updated_at AS updated_at_24, s4_.amount AS amount_25, s4_.tax_amount AS tax_amount_26, s4_.previous_amount AS previous_amount_27, s4_.previous_tax_amount AS previous_tax_amount_28, s4_.id AS id_29, s4_.created_at AS created_at_30, s4_.updated_at AS updated_at_31, v5_.position AS position_32, a6_.id AS id_33, a6_.position AS position_34, a6_.created_at AS created_at_35, a6_.updated_at AS updated_at_36, a7_.title AS title_37, a7_.description AS description_38, a7_.slug AS slug_39, a7_.locale AS locale_40, a7_.id AS id_41, p0_.principal_category_id AS principal_category_id_42, p0_.principal_image_id AS principal_image_id_43, p0_.manufacturer_id AS manufacturer_id_44, p0_.product_class_id AS product_class_id_45, p0_.stock_id AS stock_id_46, v1_.principal_image_id AS principal_image_id_47, v1_.product_id AS product_id_48, v1_.stock_id AS stock_id_49, s2_.group_id AS group_id_50, p3_.principal_category_id AS principal_category_id_51, p3_.principal_image_id AS principal_image_id_52, p3_.manufacturer_id AS manufacturer_id_53, p3_.product_class_id AS product_class_id_54, p3_.stock_id AS stock_id_55, s4_.stock_id AS stock_id_56, s4_.store_id AS store_id_57, s4_.user_id AS user_id_58, s4_.tax_rate_id AS tax_rate_id_59, s4_.previous_tax_rate_id AS previous_tax_rate_id_60, v5_.variant_id AS variant_id_61, v5_.attribute_option_id AS attribute_option_id_62, a6_.attribute_id AS attribute_id_63, a6_.principal_image_id AS principal_image_id_64, a7_.translatable_id AS translatable_id_65 FROM product p0_ LEFT JOIN variant v1_ ON p0_.id = v1_.product_id LEFT JOIN stock s2_ ON v1_.stock_id = s2_.id LEFT JOIN product p3_ ON s2_.id = p3_.stock_id LEFT JOIN stock_price s4_ ON s2_.id = s4_.stock_id LEFT JOIN variant_attribute v5_ ON v1_.id = v5_.variant_id LEFT JOIN attribute_option a6_ ON v5_.attribute_option_id = a6_.id LEFT JOIN attribute_option_translation a7_ ON a6_.id = a7_.translatable_id WHERE p0_.id = 5952 ORDER BY v1_.position ASC, v5_.position ASC;
|
| 12 |
0.76 ms |
SELECT p0_.id AS id_0, c1_.main_template AS main_template_1, c1_.product_template AS product_template_2, c1_.filterable AS filterable_3, c1_.id AS id_4, c1_.created_at AS created_at_5, c1_.updated_at AS updated_at_6, c2_.slug AS slug_7, c2_.title AS title_8, c2_.h1 AS h1_9, c2_.perex AS perex_10, c2_.description AS description_11, c2_.meta_title AS meta_title_12, c2_.meta_description AS meta_description_13, c2_.meta_keywords AS meta_keywords_14, c2_.locale AS locale_15, c2_.id AS id_16, p0_.principal_category_id AS principal_category_id_17, p0_.principal_image_id AS principal_image_id_18, p0_.manufacturer_id AS manufacturer_id_19, p0_.product_class_id AS product_class_id_20, p0_.stock_id AS stock_id_21, c1_.principal_image_id AS principal_image_id_22, c2_.translatable_id AS translatable_id_23 FROM product p0_ LEFT JOIN recommended_product_category r3_ ON p0_.id = r3_.product_id LEFT JOIN category c1_ ON c1_.id = r3_.category_id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id WHERE p0_.id = ?
SELECT p0_.id AS id_0, c1_.main_template AS main_template_1, c1_.product_template AS product_template_2, c1_.filterable AS filterable_3, c1_.id AS id_4, c1_.created_at AS created_at_5, c1_.updated_at AS updated_at_6, c2_.slug AS slug_7, c2_.title AS title_8, c2_.h1 AS h1_9, c2_.perex AS perex_10, c2_.description AS description_11, c2_.meta_title AS meta_title_12, c2_.meta_description AS meta_description_13, c2_.meta_keywords AS meta_keywords_14, c2_.locale AS locale_15, c2_.id AS id_16, p0_.principal_category_id AS principal_category_id_17, p0_.principal_image_id AS principal_image_id_18, p0_.manufacturer_id AS manufacturer_id_19, p0_.product_class_id AS product_class_id_20, p0_.stock_id AS stock_id_21, c1_.principal_image_id AS principal_image_id_22, c2_.translatable_id AS translatable_id_23 FROM product p0_ LEFT JOIN recommended_product_category r3_ ON p0_.id = r3_.product_id LEFT JOIN category c1_ ON c1_.id = r3_.category_id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id WHERE p0_.id = 5952;
|
| 13 |
0.71 ms |
SELECT p0_.id AS id_0, p1_.position AS position_1, c2_.main_template AS main_template_2, c2_.product_template AS product_template_3, c2_.filterable AS filterable_4, c2_.id AS id_5, c2_.created_at AS created_at_6, c2_.updated_at AS updated_at_7, c3_.slug AS slug_8, c3_.title AS title_9, c3_.h1 AS h1_10, c3_.perex AS perex_11, c3_.description AS description_12, c3_.meta_title AS meta_title_13, c3_.meta_description AS meta_description_14, c3_.meta_keywords AS meta_keywords_15, c3_.locale AS locale_16, c3_.id AS id_17, p0_.principal_category_id AS principal_category_id_18, p0_.principal_image_id AS principal_image_id_19, p0_.manufacturer_id AS manufacturer_id_20, p0_.product_class_id AS product_class_id_21, p0_.stock_id AS stock_id_22, p1_.category_id AS category_id_23, p1_.product_id AS product_id_24, c2_.principal_image_id AS principal_image_id_25, c3_.translatable_id AS translatable_id_26 FROM product p0_ LEFT JOIN product_category p1_ ON p0_.id = p1_.product_id LEFT JOIN category c2_ ON p1_.category_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id WHERE p0_.id = ?
SELECT p0_.id AS id_0, p1_.position AS position_1, c2_.main_template AS main_template_2, c2_.product_template AS product_template_3, c2_.filterable AS filterable_4, c2_.id AS id_5, c2_.created_at AS created_at_6, c2_.updated_at AS updated_at_7, c3_.slug AS slug_8, c3_.title AS title_9, c3_.h1 AS h1_10, c3_.perex AS perex_11, c3_.description AS description_12, c3_.meta_title AS meta_title_13, c3_.meta_description AS meta_description_14, c3_.meta_keywords AS meta_keywords_15, c3_.locale AS locale_16, c3_.id AS id_17, p0_.principal_category_id AS principal_category_id_18, p0_.principal_image_id AS principal_image_id_19, p0_.manufacturer_id AS manufacturer_id_20, p0_.product_class_id AS product_class_id_21, p0_.stock_id AS stock_id_22, p1_.category_id AS category_id_23, p1_.product_id AS product_id_24, c2_.principal_image_id AS principal_image_id_25, c3_.translatable_id AS translatable_id_26 FROM product p0_ LEFT JOIN product_category p1_ ON p0_.id = p1_.product_id LEFT JOIN category c2_ ON p1_.category_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id WHERE p0_.id = 5952;
|
| 14 |
1.03 ms |
SELECT p0_.id AS id_0, p1_.position AS position_1, d2_.name AS name_2, d2_.original_name AS original_name_3, d2_.mime_type AS mime_type_4, d2_.size AS size_5, d2_.id AS id_6, d2_.created_at AS created_at_7, d2_.updated_at AS updated_at_8, d3_.title AS title_9, d3_.description AS description_10, d3_.keywords AS keywords_11, d3_.locale AS locale_12, d3_.id AS id_13, p0_.principal_category_id AS principal_category_id_14, p0_.principal_image_id AS principal_image_id_15, p0_.manufacturer_id AS manufacturer_id_16, p0_.product_class_id AS product_class_id_17, p0_.stock_id AS stock_id_18, p1_.product_id AS product_id_19, p1_.document_id AS document_id_20, d3_.translatable_id AS translatable_id_21 FROM product p0_ LEFT JOIN product_document p1_ ON p0_.id = p1_.product_id LEFT JOIN document d2_ ON p1_.document_id = d2_.id LEFT JOIN document_translation d3_ ON d2_.id = d3_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC
SELECT p0_.id AS id_0, p1_.position AS position_1, d2_.name AS name_2, d2_.original_name AS original_name_3, d2_.mime_type AS mime_type_4, d2_.size AS size_5, d2_.id AS id_6, d2_.created_at AS created_at_7, d2_.updated_at AS updated_at_8, d3_.title AS title_9, d3_.description AS description_10, d3_.keywords AS keywords_11, d3_.locale AS locale_12, d3_.id AS id_13, p0_.principal_category_id AS principal_category_id_14, p0_.principal_image_id AS principal_image_id_15, p0_.manufacturer_id AS manufacturer_id_16, p0_.product_class_id AS product_class_id_17, p0_.stock_id AS stock_id_18, p1_.product_id AS product_id_19, p1_.document_id AS document_id_20, d3_.translatable_id AS translatable_id_21 FROM product p0_ LEFT JOIN product_document p1_ ON p0_.id = p1_.product_id LEFT JOIN document d2_ ON p1_.document_id = d2_.id LEFT JOIN document_translation d3_ ON d2_.id = d3_.translatable_id WHERE p0_.id = 5952 ORDER BY p1_.position ASC;
|
| 15 |
1.22 ms |
SELECT p0_.id AS id_0, p1_.position AS position_1, i2_.name AS name_2, i2_.original_name AS original_name_3, i2_.mime_type AS mime_type_4, i2_.size AS size_5, i2_.width AS width_6, i2_.height AS height_7, i2_.id AS id_8, i2_.created_at AS created_at_9, i2_.updated_at AS updated_at_10, i3_.title AS title_11, i3_.keywords AS keywords_12, i3_.locale AS locale_13, i3_.id AS id_14, p0_.principal_category_id AS principal_category_id_15, p0_.principal_image_id AS principal_image_id_16, p0_.manufacturer_id AS manufacturer_id_17, p0_.product_class_id AS product_class_id_18, p0_.stock_id AS stock_id_19, p1_.product_id AS product_id_20, p1_.image_id AS image_id_21, i3_.translatable_id AS translatable_id_22 FROM product p0_ LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id LEFT JOIN image i2_ ON p1_.image_id = i2_.id LEFT JOIN image_translation i3_ ON i2_.id = i3_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC
SELECT p0_.id AS id_0, p1_.position AS position_1, i2_.name AS name_2, i2_.original_name AS original_name_3, i2_.mime_type AS mime_type_4, i2_.size AS size_5, i2_.width AS width_6, i2_.height AS height_7, i2_.id AS id_8, i2_.created_at AS created_at_9, i2_.updated_at AS updated_at_10, i3_.title AS title_11, i3_.keywords AS keywords_12, i3_.locale AS locale_13, i3_.id AS id_14, p0_.principal_category_id AS principal_category_id_15, p0_.principal_image_id AS principal_image_id_16, p0_.manufacturer_id AS manufacturer_id_17, p0_.product_class_id AS product_class_id_18, p0_.stock_id AS stock_id_19, p1_.product_id AS product_id_20, p1_.image_id AS image_id_21, i3_.translatable_id AS translatable_id_22 FROM product p0_ LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id LEFT JOIN image i2_ ON p1_.image_id = i2_.id LEFT JOIN image_translation i3_ ON i2_.id = i3_.translatable_id WHERE p0_.id = 5952 ORDER BY p1_.position ASC;
|
| 16 |
0.67 ms |
SELECT p0_.id AS id_0, v1_.provider AS provider_1, v1_.id AS id_2, v1_.created_at AS created_at_3, v1_.updated_at AS updated_at_4, v2_.url AS url_5, v2_.title AS title_6, v2_.embed_code AS embed_code_7, v2_.locale AS locale_8, v2_.id AS id_9, p0_.principal_category_id AS principal_category_id_10, p0_.principal_image_id AS principal_image_id_11, p0_.manufacturer_id AS manufacturer_id_12, p0_.product_class_id AS product_class_id_13, p0_.stock_id AS stock_id_14, v2_.translatable_id AS translatable_id_15 FROM product p0_ LEFT JOIN product_video p3_ ON p0_.id = p3_.product_id LEFT JOIN video v1_ ON v1_.id = p3_.video_id LEFT JOIN video_translation v2_ ON v1_.id = v2_.translatable_id WHERE p0_.id = ?
SELECT p0_.id AS id_0, v1_.provider AS provider_1, v1_.id AS id_2, v1_.created_at AS created_at_3, v1_.updated_at AS updated_at_4, v2_.url AS url_5, v2_.title AS title_6, v2_.embed_code AS embed_code_7, v2_.locale AS locale_8, v2_.id AS id_9, p0_.principal_category_id AS principal_category_id_10, p0_.principal_image_id AS principal_image_id_11, p0_.manufacturer_id AS manufacturer_id_12, p0_.product_class_id AS product_class_id_13, p0_.stock_id AS stock_id_14, v2_.translatable_id AS translatable_id_15 FROM product p0_ LEFT JOIN product_video p3_ ON p0_.id = p3_.product_id LEFT JOIN video v1_ ON v1_.id = p3_.video_id LEFT JOIN video_translation v2_ ON v1_.id = v2_.translatable_id WHERE p0_.id = 5952;
|
| 17 |
0.32 ms |
SELECT t0.rate AS rate_1, t0.`precision` AS precision_2, t0.id AS id_3, t0.store_id AS store_id_4 FROM tax_rate t0 WHERE t0.id = ?
SELECT t0.rate AS rate_1, t0.`precision` AS precision_2, t0.id AS id_3, t0.store_id AS store_id_4 FROM tax_rate t0 WHERE t0.id = 5;
|
| 18 |
16.75 ms |
SELECT m0_.alias AS alias_0, m0_.lft AS lft_1, m0_.rgt AS rgt_2, m0_.lvl AS lvl_3, m0_.root AS root_4, m0_.id AS id_5, c1_.main_template AS main_template_6, c1_.product_template AS product_template_7, c1_.filterable AS filterable_8, c1_.id AS id_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c2_.slug AS slug_12, c2_.title AS title_13, c2_.h1 AS h1_14, c2_.perex AS perex_15, c2_.description AS description_16, c2_.meta_title AS meta_title_17, c2_.meta_description AS meta_description_18, c2_.meta_keywords AS meta_keywords_19, c2_.locale AS locale_20, c2_.id AS id_21, i3_.name AS name_22, i3_.original_name AS original_name_23, i3_.mime_type AS mime_type_24, i3_.size AS size_25, i3_.width AS width_26, i3_.height AS height_27, i3_.id AS id_28, i3_.created_at AS created_at_29, i3_.updated_at AS updated_at_30, i4_.title AS title_31, i4_.keywords AS keywords_32, i4_.locale AS locale_33, i4_.id AS id_34, m0_.category_id AS category_id_35, m0_.parent_id AS parent_id_36, c1_.principal_image_id AS principal_image_id_37, c2_.translatable_id AS translatable_id_38, i4_.translatable_id AS translatable_id_39 FROM menu_sk m0_ LEFT JOIN category c1_ ON m0_.category_id = c1_.id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale IN (?)) LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id AND (i4_.locale IN (?)) ORDER BY m0_.lft ASC
Parameters: [
"sk"
"sk"
]
SELECT m0_.alias AS alias_0, m0_.lft AS lft_1, m0_.rgt AS rgt_2, m0_.lvl AS lvl_3, m0_.root AS root_4, m0_.id AS id_5, c1_.main_template AS main_template_6, c1_.product_template AS product_template_7, c1_.filterable AS filterable_8, c1_.id AS id_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c2_.slug AS slug_12, c2_.title AS title_13, c2_.h1 AS h1_14, c2_.perex AS perex_15, c2_.description AS description_16, c2_.meta_title AS meta_title_17, c2_.meta_description AS meta_description_18, c2_.meta_keywords AS meta_keywords_19, c2_.locale AS locale_20, c2_.id AS id_21, i3_.name AS name_22, i3_.original_name AS original_name_23, i3_.mime_type AS mime_type_24, i3_.size AS size_25, i3_.width AS width_26, i3_.height AS height_27, i3_.id AS id_28, i3_.created_at AS created_at_29, i3_.updated_at AS updated_at_30, i4_.title AS title_31, i4_.keywords AS keywords_32, i4_.locale AS locale_33, i4_.id AS id_34, m0_.category_id AS category_id_35, m0_.parent_id AS parent_id_36, c1_.principal_image_id AS principal_image_id_37, c2_.translatable_id AS translatable_id_38, i4_.translatable_id AS translatable_id_39 FROM menu_sk m0_ LEFT JOIN category c1_ ON m0_.category_id = c1_.id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale IN ('sk')) LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id AND (i4_.locale IN ('sk')) ORDER BY m0_.lft ASC;
|
| 19 |
0.57 ms |
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 (?)
Parameters: [
"terma-vivo-1150x500-vodny-elektricky-radiator-white-matt-zs"
"sk"
]
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 = 'terma-vivo-1150x500-vodny-elektricky-radiator-white-matt-zs' AND s0_.locale IN ('sk');
|
| 20 |
0.49 ms |
SELECT t0.code AS code_1, t0.title AS title_2, t0.description AS description_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM stock_group t0 WHERE t0.id = ?
SELECT t0.code AS code_1, t0.title AS title_2, t0.description AS description_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM stock_group t0 WHERE t0.id = 23;
|
| 21 |
0.35 ms |
SELECT t0.rate AS rate_1, t0.`precision` AS precision_2, t0.id AS id_3, t0.store_id AS store_id_4 FROM tax_rate t0 WHERE t0.id = ?
SELECT t0.rate AS rate_1, t0.`precision` AS precision_2, t0.id AS id_3, t0.store_id AS store_id_4 FROM tax_rate t0 WHERE t0.id = 1;
|
| 22 |
0.55 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 4895 ORDER BY t0.position ASC;
|
| 23 |
0.36 ms |
SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.width AS width_5, t0.height AS height_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM image t0 WHERE t0.id = ?
SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.width AS width_5, t0.height AS height_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM image t0 WHERE t0.id = 13960;
|
| 24 |
0.38 ms |
SELECT t0.title AS title_1, t0.keywords AS keywords_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM image_translation t0 WHERE t0.translatable_id = ?
SELECT t0.title AS title_1, t0.keywords AS keywords_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM image_translation t0 WHERE t0.translatable_id = 13960;
|
| 25 |
0.51 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 4900 ORDER BY t0.position ASC;
|
| 26 |
0.36 ms |
SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.width AS width_5, t0.height AS height_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM image t0 WHERE t0.id = ?
SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.width AS width_5, t0.height AS height_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM image t0 WHERE t0.id = 13925;
|
| 27 |
0.38 ms |
SELECT t0.title AS title_1, t0.keywords AS keywords_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM image_translation t0 WHERE t0.translatable_id = ?
SELECT t0.title AS title_1, t0.keywords AS keywords_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM image_translation t0 WHERE t0.translatable_id = 13925;
|
| 28 |
0.46 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 4896 ORDER BY t0.position ASC;
|
| 29 |
0.48 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 4902 ORDER BY t0.position ASC;
|
| 30 |
0.49 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 4906 ORDER BY t0.position ASC;
|
| 31 |
0.32 ms |
SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.width AS width_5, t0.height AS height_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM image t0 WHERE t0.id = ?
SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.width AS width_5, t0.height AS height_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM image t0 WHERE t0.id = 14655;
|
| 32 |
0.37 ms |
SELECT t0.title AS title_1, t0.keywords AS keywords_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM image_translation t0 WHERE t0.translatable_id = ?
SELECT t0.title AS title_1, t0.keywords AS keywords_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM image_translation t0 WHERE t0.translatable_id = 14655;
|
| 33 |
36.49 ms |
SELECT RAND() AS sclr_0, p0_.type AS type_1, p0_.warranty_years AS warranty_years_2, p0_.new AS new_3, p0_.id AS id_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, s1_.sku AS sku_7, s1_.quantity AS quantity_8, s1_.quantity_unit AS quantity_unit_9, s1_.ean_code AS ean_code_10, s1_.availability AS availability_11, s1_.`condition` AS condition_12, s1_.importable AS importable_13, s1_.tax_transferable AS tax_transferable_14, s1_.sale_count AS sale_count_15, s1_.disabled_at AS disabled_at_16, s1_.id AS id_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s1_.enabled AS enabled_20, v2_.id AS id_21, v2_.position AS position_22, v2_.created_at AS created_at_23, v2_.updated_at AS updated_at_24, s3_.amount AS amount_25, s3_.tax_amount AS tax_amount_26, s3_.previous_amount AS previous_amount_27, s3_.previous_tax_amount AS previous_tax_amount_28, s3_.id AS id_29, s3_.created_at AS created_at_30, s3_.updated_at AS updated_at_31, t4_.rate AS rate_32, t4_.`precision` AS precision_33, t4_.id AS id_34, p5_.title AS title_35, p5_.h1 AS h1_36, p5_.perex AS perex_37, p5_.description AS description_38, p5_.text AS text_39, p5_.meta_title AS meta_title_40, p5_.meta_description AS meta_description_41, p5_.meta_keywords AS meta_keywords_42, p5_.slug AS slug_43, p5_.locale AS locale_44, p5_.id AS id_45, i6_.name AS name_46, i6_.original_name AS original_name_47, i6_.mime_type AS mime_type_48, i6_.size AS size_49, i6_.width AS width_50, i6_.height AS height_51, i6_.id AS id_52, i6_.created_at AS created_at_53, i6_.updated_at AS updated_at_54, i7_.title AS title_55, i7_.keywords AS keywords_56, i7_.locale AS locale_57, i7_.id AS id_58, p0_.principal_category_id AS principal_category_id_59, p0_.principal_image_id AS principal_image_id_60, p0_.manufacturer_id AS manufacturer_id_61, p0_.product_class_id AS product_class_id_62, p0_.stock_id AS stock_id_63, s1_.group_id AS group_id_64, v2_.principal_image_id AS principal_image_id_65, v2_.product_id AS product_id_66, v2_.stock_id AS stock_id_67, s3_.stock_id AS stock_id_68, s3_.store_id AS store_id_69, s3_.user_id AS user_id_70, s3_.tax_rate_id AS tax_rate_id_71, s3_.previous_tax_rate_id AS previous_tax_rate_id_72, t4_.store_id AS store_id_73, p5_.translatable_id AS translatable_id_74, i7_.translatable_id AS translatable_id_75 FROM product p0_ INNER JOIN stock s1_ ON p0_.stock_id = s1_.id LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id AND (s3_.store_id = ?) INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id AND (p5_.locale IN (?)) LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id AND (i7_.locale IN (?)) INNER JOIN product_category p8_ ON p0_.id = p8_.product_id INNER JOIN category c9_ ON p8_.category_id = c9_.id INNER JOIN recommended_product_category r11_ ON c9_.id = r11_.category_id INNER JOIN product p10_ ON p10_.id = r11_.product_id AND (p10_.id IN (?)) WHERE s1_.enabled = 1 AND p0_.id NOT IN (?) GROUP BY s1_.id ORDER BY sclr_0 ASC LIMIT 12
Parameters: [
1
"sk"
"sk"
5952
5952
]
SELECT
RAND() AS sclr_0,
p0_.type AS type_1,
p0_.warranty_years AS warranty_years_2,
p0_.new AS new_3,
p0_.id AS id_4,
p0_.created_at AS created_at_5,
p0_.updated_at AS updated_at_6,
s1_.sku AS sku_7,
s1_.quantity AS quantity_8,
s1_.quantity_unit AS quantity_unit_9,
s1_.ean_code AS ean_code_10,
s1_.availability AS availability_11,
s1_.`condition` AS condition_12,
s1_.importable AS importable_13,
s1_.tax_transferable AS tax_transferable_14,
s1_.sale_count AS sale_count_15,
s1_.disabled_at AS disabled_at_16,
s1_.id AS id_17,
s1_.created_at AS created_at_18,
s1_.updated_at AS updated_at_19,
s1_.enabled AS enabled_20,
v2_.id AS id_21,
v2_.position AS position_22,
v2_.created_at AS created_at_23,
v2_.updated_at AS updated_at_24,
s3_.amount AS amount_25,
s3_.tax_amount AS tax_amount_26,
s3_.previous_amount AS previous_amount_27,
s3_.previous_tax_amount AS previous_tax_amount_28,
s3_.id AS id_29,
s3_.created_at AS created_at_30,
s3_.updated_at AS updated_at_31,
t4_.rate AS rate_32,
t4_.`precision` AS precision_33,
t4_.id AS id_34,
p5_.title AS title_35,
p5_.h1 AS h1_36,
p5_.perex AS perex_37,
p5_.description AS description_38,
p5_.text AS text_39,
p5_.meta_title AS meta_title_40,
p5_.meta_description AS meta_description_41,
p5_.meta_keywords AS meta_keywords_42,
p5_.slug AS slug_43,
p5_.locale AS locale_44,
p5_.id AS id_45,
i6_.name AS name_46,
i6_.original_name AS original_name_47,
i6_.mime_type AS mime_type_48,
i6_.size AS size_49,
i6_.width AS width_50,
i6_.height AS height_51,
i6_.id AS id_52,
i6_.created_at AS created_at_53,
i6_.updated_at AS updated_at_54,
i7_.title AS title_55,
i7_.keywords AS keywords_56,
i7_.locale AS locale_57,
i7_.id AS id_58,
p0_.principal_category_id AS principal_category_id_59,
p0_.principal_image_id AS principal_image_id_60,
p0_.manufacturer_id AS manufacturer_id_61,
p0_.product_class_id AS product_class_id_62,
p0_.stock_id AS stock_id_63,
s1_.group_id AS group_id_64,
v2_.principal_image_id AS principal_image_id_65,
v2_.product_id AS product_id_66,
v2_.stock_id AS stock_id_67,
s3_.stock_id AS stock_id_68,
s3_.store_id AS store_id_69,
s3_.user_id AS user_id_70,
s3_.tax_rate_id AS tax_rate_id_71,
s3_.previous_tax_rate_id AS previous_tax_rate_id_72,
t4_.store_id AS store_id_73,
p5_.translatable_id AS translatable_id_74,
i7_.translatable_id AS translatable_id_75
FROM
product p0_
INNER JOIN stock s1_ ON p0_.stock_id = s1_.id
LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id
INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id
AND (s3_.store_id = ?)
INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id
INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id
AND (
p5_.locale IN (?)
)
LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id
LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id
AND (
i7_.locale IN (?)
)
INNER JOIN product_category p8_ ON p0_.id = p8_.product_id
INNER JOIN category c9_ ON p8_.category_id = c9_.id
INNER JOIN recommended_product_category r11_ ON c9_.id = r11_.category_id
INNER JOIN product p10_ ON p10_.id = r11_.product_id
AND (
p10_.id IN (?)
)
WHERE
s1_.enabled = 1
AND p0_.id NOT IN (?)
GROUP BY
s1_.id
ORDER BY
sclr_0 ASC
LIMIT
12
SELECT RAND() AS sclr_0, p0_.type AS type_1, p0_.warranty_years AS warranty_years_2, p0_.new AS new_3, p0_.id AS id_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, s1_.sku AS sku_7, s1_.quantity AS quantity_8, s1_.quantity_unit AS quantity_unit_9, s1_.ean_code AS ean_code_10, s1_.availability AS availability_11, s1_.`condition` AS condition_12, s1_.importable AS importable_13, s1_.tax_transferable AS tax_transferable_14, s1_.sale_count AS sale_count_15, s1_.disabled_at AS disabled_at_16, s1_.id AS id_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s1_.enabled AS enabled_20, v2_.id AS id_21, v2_.position AS position_22, v2_.created_at AS created_at_23, v2_.updated_at AS updated_at_24, s3_.amount AS amount_25, s3_.tax_amount AS tax_amount_26, s3_.previous_amount AS previous_amount_27, s3_.previous_tax_amount AS previous_tax_amount_28, s3_.id AS id_29, s3_.created_at AS created_at_30, s3_.updated_at AS updated_at_31, t4_.rate AS rate_32, t4_.`precision` AS precision_33, t4_.id AS id_34, p5_.title AS title_35, p5_.h1 AS h1_36, p5_.perex AS perex_37, p5_.description AS description_38, p5_.text AS text_39, p5_.meta_title AS meta_title_40, p5_.meta_description AS meta_description_41, p5_.meta_keywords AS meta_keywords_42, p5_.slug AS slug_43, p5_.locale AS locale_44, p5_.id AS id_45, i6_.name AS name_46, i6_.original_name AS original_name_47, i6_.mime_type AS mime_type_48, i6_.size AS size_49, i6_.width AS width_50, i6_.height AS height_51, i6_.id AS id_52, i6_.created_at AS created_at_53, i6_.updated_at AS updated_at_54, i7_.title AS title_55, i7_.keywords AS keywords_56, i7_.locale AS locale_57, i7_.id AS id_58, p0_.principal_category_id AS principal_category_id_59, p0_.principal_image_id AS principal_image_id_60, p0_.manufacturer_id AS manufacturer_id_61, p0_.product_class_id AS product_class_id_62, p0_.stock_id AS stock_id_63, s1_.group_id AS group_id_64, v2_.principal_image_id AS principal_image_id_65, v2_.product_id AS product_id_66, v2_.stock_id AS stock_id_67, s3_.stock_id AS stock_id_68, s3_.store_id AS store_id_69, s3_.user_id AS user_id_70, s3_.tax_rate_id AS tax_rate_id_71, s3_.previous_tax_rate_id AS previous_tax_rate_id_72, t4_.store_id AS store_id_73, p5_.translatable_id AS translatable_id_74, i7_.translatable_id AS translatable_id_75 FROM product p0_ INNER JOIN stock s1_ ON p0_.stock_id = s1_.id LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id AND (s3_.store_id = 1) INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id AND (p5_.locale IN ('sk')) LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id AND (i7_.locale IN ('sk')) INNER JOIN product_category p8_ ON p0_.id = p8_.product_id INNER JOIN category c9_ ON p8_.category_id = c9_.id INNER JOIN recommended_product_category r11_ ON c9_.id = r11_.category_id INNER JOIN product p10_ ON p10_.id = r11_.product_id AND (p10_.id IN (5952)) WHERE s1_.enabled = 1 AND p0_.id NOT IN (5952) GROUP BY s1_.id ORDER BY sclr_0 ASC LIMIT 12;
|
| 34 |
0.43 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 7239 ORDER BY t0.position ASC;
|
| 35 |
0.44 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 6849 ORDER BY t0.position ASC;
|
| 36 |
0.47 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 6836 ORDER BY t0.position ASC;
|
| 37 |
0.49 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 5266 ORDER BY t0.position ASC;
|
| 38 |
0.51 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 5920 ORDER BY t0.position ASC;
|
| 39 |
0.42 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 6797 ORDER BY t0.position ASC;
|
| 40 |
0.44 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 6599 ORDER BY t0.position ASC;
|
| 41 |
0.40 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 4839 ORDER BY t0.position ASC;
|
| 42 |
0.42 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 5949 ORDER BY t0.position ASC;
|
| 43 |
0.43 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 5368 ORDER BY t0.position ASC;
|
| 44 |
0.48 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 5280 ORDER BY t0.position ASC;
|
| 45 |
0.47 ms |
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.product_id = ? ORDER BY t0.position ASC
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.product_id = 5504 ORDER BY t0.position ASC;
|