Symfony Profiler

Query Metrics

60 Database Queries

17 Different statements

6.93 ms Query time

0 Invalid entities

Queries


SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.code AS code_3, t0.promo_code AS promo_code_4, t0.checkout_data AS checkout_data_5, t0.date_updated AS date_updated_6 FROM sf_cart t0 WHERE t0.id = ? LIMIT 1
SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id WHERE p0_.deleted = 0 AND p2_.url_code <> '' AND p0_.product_id = ? LIMIT 1
SELECT t0.cart_id AS cart_id_1, t0.product_id AS product_id_2, t0.quantity AS quantity_3, t0.price AS price_4, t0.currency_id AS currency_id_5, t0.property AS property_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8, t0.currency_id AS currency_id_9 FROM sf_cart_product t0 WHERE t0.cart_id = ? AND t0.product_id = ? AND t0.property = ? LIMIT 1
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.code AS code_3, t0.promo_code AS promo_code_4, t0.checkout_data AS checkout_data_5, t0.date_updated AS date_updated_6 FROM sf_cart t0 WHERE t0.code = ? LIMIT 1
"START TRANSACTION"
UPDATE sf_cart SET date_updated = ? WHERE id = ?
"COMMIT"
SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0
SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0
SELECT t0.cart_id AS cart_id_1, t0.product_id AS product_id_2, t0.quantity AS quantity_3, t0.price AS price_4, t0.currency_id AS currency_id_5, t0.property AS property_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8, t0.currency_id AS currency_id_9 FROM sf_cart_product t0 WHERE t0.cart_id = ?
SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = ?
SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = ?
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1
SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1
SELECT t0.stock_products_id AS stock_products_id_1, t0.discount AS discount_2, t0.type_discount AS type_discount_3, t0.is_gift AS is_gift_4, t0.stock_id AS stock_id_5, t0.product_id AS product_id_6 FROM stock_products t0 WHERE t0.stock_id = ?
SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1
SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id = ? AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1
SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id = ? AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1
SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1
SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1
SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id = ? AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1
SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id = ? AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1
SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1
SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1
SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1
SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1
SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.active AS active_3, k0_.default AS default_4 FROM kk_language k0_ WHERE k0_.code = ? LIMIT 1
SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = ?
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1
SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = ?
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = ?
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id = ? AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = ?
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id = ? AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1

#▲	Time	Info
1	0.55 ms	SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.code AS code_3, t0.promo_code AS promo_code_4, t0.checkout_data AS checkout_data_5, t0.date_updated AS date_updated_6 FROM sf_cart t0 WHERE t0.id = ? LIMIT 1 Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.code AS code_3, t0.promo_code AS promo_code_4, t0.checkout_data AS checkout_data_5, t0.date_updated AS date_updated_6 FROM sf_cart t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.code AS code_3, t0.promo_code AS promo_code_4, t0.checkout_data AS checkout_data_5, t0.date_updated AS date_updated_6 FROM sf_cart t0 WHERE t0.id = 3 LIMIT 1;
2	0.14 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id WHERE p0_.deleted = 0 AND p2_.url_code <> '' AND p0_.product_id = ? LIMIT 1 Parameters: [`140465`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id WHERE p0_.deleted = 0 AND p2_.url_code <> '' AND p0_.product_id = ? LIMIT 1 SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id WHERE p0_.deleted = 0 AND p2_.url_code <> '' AND p0_.product_id = 140465 LIMIT 1;
3	0.43 ms	SELECT t0.cart_id AS cart_id_1, t0.product_id AS product_id_2, t0.quantity AS quantity_3, t0.price AS price_4, t0.currency_id AS currency_id_5, t0.property AS property_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8, t0.currency_id AS currency_id_9 FROM sf_cart_product t0 WHERE t0.cart_id = ? AND t0.product_id = ? AND t0.property = ? LIMIT 1 Parameters: [`3 140465 ""`] View formatted query View runnable query Explain query SELECT t0.cart_id AS cart_id_1, t0.product_id AS product_id_2, t0.quantity AS quantity_3, t0.price AS price_4, t0.currency_id AS currency_id_5, t0.property AS property_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8, t0.currency_id AS currency_id_9 FROM sf_cart_product t0 WHERE t0.cart_id = ? AND t0.product_id = ? AND t0.property = ? LIMIT 1 SELECT t0.cart_id AS cart_id_1, t0.product_id AS product_id_2, t0.quantity AS quantity_3, t0.price AS price_4, t0.currency_id AS currency_id_5, t0.property AS property_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8, t0.currency_id AS currency_id_9 FROM sf_cart_product t0 WHERE t0.cart_id = 3 AND t0.product_id = 140465 AND t0.property = '' LIMIT 1;
4	0.18 ms	SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.code AS code_3, t0.promo_code AS promo_code_4, t0.checkout_data AS checkout_data_5, t0.date_updated AS date_updated_6 FROM sf_cart t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"2ddc6f07"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.code AS code_3, t0.promo_code AS promo_code_4, t0.checkout_data AS checkout_data_5, t0.date_updated AS date_updated_6 FROM sf_cart t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.code AS code_3, t0.promo_code AS promo_code_4, t0.checkout_data AS checkout_data_5, t0.date_updated AS date_updated_6 FROM sf_cart t0 WHERE t0.code = '2ddc6f07' LIMIT 1;
5	0.09 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
6	0.35 ms	UPDATE sf_cart SET date_updated = ? WHERE id = ? Parameters: [`"2026-03-21 17:39:29" 3`] View formatted query View runnable query Explain query UPDATE sf_cart SET date_updated = ? WHERE id = ? UPDATE sf_cart SET date_updated = '2026-03-21 17:39:29' WHERE id = 3;
7	0.14 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
8	0.13 ms	SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0 SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0;
9	0.09 ms	SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0 SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0;
10	0.08 ms	SELECT t0.cart_id AS cart_id_1, t0.product_id AS product_id_2, t0.quantity AS quantity_3, t0.price AS price_4, t0.currency_id AS currency_id_5, t0.property AS property_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8, t0.currency_id AS currency_id_9 FROM sf_cart_product t0 WHERE t0.cart_id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.cart_id AS cart_id_1, t0.product_id AS product_id_2, t0.quantity AS quantity_3, t0.price AS price_4, t0.currency_id AS currency_id_5, t0.property AS property_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8, t0.currency_id AS currency_id_9 FROM sf_cart_product t0 WHERE t0.cart_id = ? SELECT t0.cart_id AS cart_id_1, t0.product_id AS product_id_2, t0.quantity AS quantity_3, t0.price AS price_4, t0.currency_id AS currency_id_5, t0.property AS property_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8, t0.currency_id AS currency_id_9 FROM sf_cart_product t0 WHERE t0.cart_id = 3;
11	0.17 ms	SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = ? Parameters: [`140674`] View formatted query View runnable query Explain query SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = ? SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = 140674;
12	0.10 ms	SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = ? Parameters: [`140729`] View formatted query View runnable query Explain query SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = ? SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = 140729;
13	0.16 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140465 "weight"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140465) AND f1_.use_as = 'weight' ORDER BY f3_.weight ASC, f1_.weight ASC;
14	0.11 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140674 "weight"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140674) AND f1_.use_as = 'weight' ORDER BY f3_.weight ASC, f1_.weight ASC;
15	0.09 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140729 "weight"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140729) AND f1_.use_as = 'weight' ORDER BY f3_.weight ASC, f1_.weight ASC;
16	0.13 ms	SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 Parameters: [`"cl140465_6674044080572"`] View formatted query View runnable query Explain query SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = 'cl140465_6674044080572' LIMIT 1;
17	0.08 ms	SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 Parameters: [`"cl140465_6674044080572"`] View formatted query View runnable query Explain query SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = 'cl140465_6674044080572' LIMIT 1;
18	0.07 ms	SELECT t0.stock_products_id AS stock_products_id_1, t0.discount AS discount_2, t0.type_discount AS type_discount_3, t0.is_gift AS is_gift_4, t0.stock_id AS stock_id_5, t0.product_id AS product_id_6 FROM stock_products t0 WHERE t0.stock_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.stock_products_id AS stock_products_id_1, t0.discount AS discount_2, t0.type_discount AS type_discount_3, t0.is_gift AS is_gift_4, t0.stock_id AS stock_id_5, t0.product_id AS product_id_6 FROM stock_products t0 WHERE t0.stock_id = ? SELECT t0.stock_products_id AS stock_products_id_1, t0.discount AS discount_2, t0.type_discount AS type_discount_3, t0.is_gift AS is_gift_4, t0.stock_id AS stock_id_5, t0.product_id AS product_id_6 FROM stock_products t0 WHERE t0.stock_id = 1;
19	0.10 ms	SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = ? Parameters: [`140124`] View formatted query View runnable query Explain query SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = ? SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = 140124;
20	0.07 ms	SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ? Parameters: [`140124`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = 140124;
21	0.08 ms	SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ? Parameters: [`140674`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = 140674;
22	0.07 ms	SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ? Parameters: [`140465`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = 140465;
23	0.07 ms	SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 Parameters: [`"cl140465_6674044080572"`] View formatted query View runnable query Explain query SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = 'cl140465_6674044080572' LIMIT 1;
24	0.11 ms	SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id = ? AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1 Parameters: [`"g" "group" 140674 "2026-03-21 17:39:29" "2026-03-21 17:39:29"`] View formatted query View runnable query Explain query SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND ( s3_.presence > 0 AND s3_.product_type <> ? ) WHERE s0_.product_id = ? AND s1_.active = 1 AND ( s0_.date_start IS NULL OR s0_.date_start <= ? ) AND ( s0_.date_end IS NULL OR s0_.date_end >= ? ) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1 SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = 'g') INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> 'group') WHERE s0_.product_id = 140674 AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= '2026-03-21 17:39:29') AND (s0_.date_end IS NULL OR s0_.date_end >= '2026-03-21 17:39:29') ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1;
25	0.10 ms	SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id = ? AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1 Parameters: [`"g" "group" 140729 "2026-03-21 17:39:29" "2026-03-21 17:39:29"`] View formatted query View runnable query Explain query SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND ( s3_.presence > 0 AND s3_.product_type <> ? ) WHERE s0_.product_id = ? AND s1_.active = 1 AND ( s0_.date_start IS NULL OR s0_.date_start <= ? ) AND ( s0_.date_end IS NULL OR s0_.date_end >= ? ) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1 SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = 'g') INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> 'group') WHERE s0_.product_id = 140729 AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= '2026-03-21 17:39:29') AND (s0_.date_end IS NULL OR s0_.date_end >= '2026-03-21 17:39:29') ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1;
26	0.06 ms	SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ? Parameters: [`140729`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = 140729;
27	0.07 ms	SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 Parameters: [`"cl140465_6674044080572"`] View formatted query View runnable query Explain query SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = 'cl140465_6674044080572' LIMIT 1;
28	0.06 ms	SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 Parameters: [`"cl140465_6674044080572"`] View formatted query View runnable query Explain query SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = 'cl140465_6674044080572' LIMIT 1;
29	0.06 ms	SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 Parameters: [`"cl140465_6674044080572"`] View formatted query View runnable query Explain query SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = 'cl140465_6674044080572' LIMIT 1;
30	0.10 ms	SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id = ? AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1 Parameters: [`"g" "group" 140674 "2026-03-21 17:39:29" "2026-03-21 17:39:29"`] View formatted query View runnable query Explain query SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND ( s3_.presence > 0 AND s3_.product_type <> ? ) WHERE s0_.product_id = ? AND s1_.active = 1 AND ( s0_.date_start IS NULL OR s0_.date_start <= ? ) AND ( s0_.date_end IS NULL OR s0_.date_end >= ? ) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1 SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = 'g') INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> 'group') WHERE s0_.product_id = 140674 AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= '2026-03-21 17:39:29') AND (s0_.date_end IS NULL OR s0_.date_end >= '2026-03-21 17:39:29') ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1;
31	0.09 ms	SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id = ? AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1 Parameters: [`"g" "group" 140729 "2026-03-21 17:39:29" "2026-03-21 17:39:29"`] View formatted query View runnable query Explain query SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND ( s3_.presence > 0 AND s3_.product_type <> ? ) WHERE s0_.product_id = ? AND s1_.active = 1 AND ( s0_.date_start IS NULL OR s0_.date_start <= ? ) AND ( s0_.date_end IS NULL OR s0_.date_end >= ? ) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1 SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = 'g') INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> 'group') WHERE s0_.product_id = 140729 AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= '2026-03-21 17:39:29') AND (s0_.date_end IS NULL OR s0_.date_end >= '2026-03-21 17:39:29') ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1;
32	0.07 ms	SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 Parameters: [`"cl140465_6674044080572"`] View formatted query View runnable query Explain query SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = 'cl140465_6674044080572' LIMIT 1;
33	0.07 ms	SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 Parameters: [`"cl140465_6674044080572"`] View formatted query View runnable query Explain query SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = 'cl140465_6674044080572' LIMIT 1;
34	0.10 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140465 "weight"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140465) AND f1_.use_as = 'weight' ORDER BY f3_.weight ASC, f1_.weight ASC;
35	0.09 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140465 "weight"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140465) AND f1_.use_as = 'weight' ORDER BY f3_.weight ASC, f1_.weight ASC;
36	0.07 ms	SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 Parameters: [`"cl140465_6674044080572"`] View formatted query View runnable query Explain query SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = 'cl140465_6674044080572' LIMIT 1;
37	0.07 ms	SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 Parameters: [`"cl140465_6674044080572"`] View formatted query View runnable query Explain query SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = 'cl140465_6674044080572' LIMIT 1;
38	0.07 ms	SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 Parameters: [`"cl140465_6674044080572"`] View formatted query View runnable query Explain query SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = 'cl140465_6674044080572' LIMIT 1;
39	0.07 ms	SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.active AS active_3, k0_.default AS default_4 FROM kk_language k0_ WHERE k0_.code = ? LIMIT 1 Parameters: [`"uk"`] View formatted query View runnable query Explain query SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.active AS active_3, k0_.default AS default_4 FROM kk_language k0_ WHERE k0_.code = ? LIMIT 1 SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.active AS active_3, k0_.default AS default_4 FROM kk_language k0_ WHERE k0_.code = 'uk' LIMIT 1;
40	0.07 ms	SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = ? Parameters: [`140465`] View formatted query View runnable query Explain query SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = ? SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = 140465;
41	0.11 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140465 "quantity_of_sale"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140465) AND f1_.use_as = 'quantity_of_sale' ORDER BY f3_.weight ASC, f1_.weight ASC;
42	0.10 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140465 "unit"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140465) AND f1_.use_as = 'unit' ORDER BY f3_.weight ASC, f1_.weight ASC;
43	0.13 ms	SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 Parameters: [`"cl140465_6674044080572"`] View formatted query View runnable query Explain query SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = ? LIMIT 1 SELECT t0.stock_id AS stock_id_1, t0.stock_code AS stock_code_2, t0.is_free_delivery AS is_free_delivery_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.stock_code = 'cl140465_6674044080572' LIMIT 1;
44	0.08 ms	SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = ? Parameters: [`140124`] View formatted query View runnable query Explain query SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = ? SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = 140124;
45	0.10 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140124 "quantity_of_sale"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140124) AND f1_.use_as = 'quantity_of_sale' ORDER BY f3_.weight ASC, f1_.weight ASC;
46	0.10 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140124 "unit"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140124) AND f1_.use_as = 'unit' ORDER BY f3_.weight ASC, f1_.weight ASC;
47	0.08 ms	SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = ? Parameters: [`140674`] View formatted query View runnable query Explain query SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = ? SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = 140674;
48	0.10 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140674 "quantity_of_sale"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140674) AND f1_.use_as = 'quantity_of_sale' ORDER BY f3_.weight ASC, f1_.weight ASC;
49	0.10 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140674 "unit"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140674) AND f1_.use_as = 'unit' ORDER BY f3_.weight ASC, f1_.weight ASC;
50	0.16 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140674 "weight"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140674) AND f1_.use_as = 'weight' ORDER BY f3_.weight ASC, f1_.weight ASC;
51	0.11 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140674 "weight"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140674) AND f1_.use_as = 'weight' ORDER BY f3_.weight ASC, f1_.weight ASC;
52	0.16 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140674 "quantity_of_sale"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140674) AND f1_.use_as = 'quantity_of_sale' ORDER BY f3_.weight ASC, f1_.weight ASC;
53	0.12 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140674 "unit"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140674) AND f1_.use_as = 'unit' ORDER BY f3_.weight ASC, f1_.weight ASC;
54	0.11 ms	SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id = ? AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1 Parameters: [`"g" "group" 140674 "2026-03-21 17:39:29" "2026-03-21 17:39:29"`] View formatted query View runnable query Explain query SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND ( s3_.presence > 0 AND s3_.product_type <> ? ) WHERE s0_.product_id = ? AND s1_.active = 1 AND ( s0_.date_start IS NULL OR s0_.date_start <= ? ) AND ( s0_.date_end IS NULL OR s0_.date_end >= ? ) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1 SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = 'g') INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> 'group') WHERE s0_.product_id = 140674 AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= '2026-03-21 17:39:29') AND (s0_.date_end IS NULL OR s0_.date_end >= '2026-03-21 17:39:29') ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1;
55	0.09 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140729 "weight"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140729) AND f1_.use_as = 'weight' ORDER BY f3_.weight ASC, f1_.weight ASC;
56	0.09 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140729 "weight"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140729) AND f1_.use_as = 'weight' ORDER BY f3_.weight ASC, f1_.weight ASC;
57	0.10 ms	SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = ? Parameters: [`140729`] View formatted query View runnable query Explain query SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = ? SELECT t0.product_id AS product_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keyword AS seo_keyword_8, t0.product_id AS product_id_9 FROM kk_products_ln t0 WHERE t0.product_id = 140729;
58	0.10 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140729 "quantity_of_sale"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140729) AND f1_.use_as = 'quantity_of_sale' ORDER BY f3_.weight ASC, f1_.weight ASC;
59	0.10 ms	SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC Parameters: [`140729 "unit"`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (140729) AND f1_.use_as = 'unit' ORDER BY f3_.weight ASC, f1_.weight ASC;
60	0.11 ms	SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id = ? AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1 Parameters: [`"g" "group" 140729 "2026-03-21 17:39:29" "2026-03-21 17:39:29"`] View formatted query View runnable query Explain query SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND ( s3_.presence > 0 AND s3_.product_type <> ? ) WHERE s0_.product_id = ? AND s1_.active = 1 AND ( s0_.date_start IS NULL OR s0_.date_start <= ? ) AND ( s0_.date_end IS NULL OR s0_.date_end >= ? ) ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1 SELECT s0_.stock_id AS stock_id_0, s0_.date_start AS date_start_1, s0_.date_end AS date_end_2, s1_.stock_products_id AS stock_products_id_3, s1_.discount AS discount_4, s1_.type_discount AS type_discount_5, s1_.description AS description_6, s1_.active AS active_7, s1_.is_product_of_day AS is_product_of_day_8, s1_.is_free_delivery AS is_free_delivery_9, p2_.product_id AS product_id_10, p2_.product AS product_11, p2_.pn AS pn_12, p2_.description AS description_13, p2_.detail_description AS detail_description_14, p2_.deleted AS deleted_15, p2_.pic AS pic_16, p2_.warranty AS warranty_17, p2_.cost_min AS cost_min_18, p2_.create_time AS create_time_19, s3_.product_id AS product_id_20, s3_.group_id AS group_id_21, s3_.product_type AS product_type_22, s3_.is_show_in_catalog AS is_show_in_catalog_23, s3_.presence AS presence_24, s3_.presence_str AS presence_str_25, s3_.rating AS rating_26, s0_.product_id AS product_id_27, s1_.product_id AS product_id_28, s1_.stock_id AS stock_id_29, p2_.category_id AS category_id_30, s3_.category_id AS category_id_31, s3_.catalog_product_id AS catalog_product_id_32, s3_.product_id AS product_id_33 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = 'g') INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> 'group') WHERE s0_.product_id = 140729 AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= '2026-03-21 17:39:29') AND (s0_.date_end IS NULL OR s0_.date_end >= '2026-03-21 17:39:29') ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
SoftUa\CartBundle\Entity\Cart	No errors.
SoftUa\CartBundle\Entity\CartProduct	No errors.
SoftUa\ProductBundle\Entity\Product	No errors.
SoftUa\ProductBundle\Entity\ProductIndex	No errors.
SoftUa\ProductBundle\Entity\ProductData	No errors.
SoftUa\ProductBundle\Entity\GroupSettings	No errors.
SoftUa\CategoryBundle\Entity\Category	No errors.
SoftUa\ProductBundle\Entity\ProductTranslation	No errors.
SoftUa\ProductBundle\Entity\ProductPriceIndex	No errors.
SoftUa\CurrencyBundle\Entity\Currency	No errors.
SoftUa\ProductSpecificationsBundle\Entity\ProductSpecificationValue	No errors.
SoftUa\SpecificationsBundle\Entity\Specification	No errors.
SoftUa\SpecificationsBundle\Entity\SpecificationTranslation	No errors.
SoftUa\SpecificationsBundle\Entity\SpecificationSection	No errors.
SoftUa\SpecificationsBundle\Entity\SpecificationSectionTranslation	No errors.
SoftUa\ProductKitsBundle\Entity\ProductKit	No errors.
SoftUa\ProductKitsBundle\Entity\ProductKitItem	No errors.
SoftUa\ActionBundle\Entity\Action	No errors.
SoftUa\ActionBundle\Entity\ActionData	No errors.
SoftUa\CoreBundle\Entity\DataLanguage	No errors.

Symfony Profiler

POST https://b2c-leobro.url.org.ua/cart/api/remove

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping