Symfony Profiler

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;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  sf_cart
SET
  date_updated = ?
WHERE
  id = ?

UPDATE sf_cart SET date_updated = '2026-03-21 14:17:57' WHERE id = 3;

"COMMIT"

"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.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.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;

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;

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;

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;

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;

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 14:17:57') AND (s0_.date_end IS NULL OR s0_.date_end >= '2026-03-21 14:17:57') 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.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;

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 14:17:57') AND (s0_.date_end IS NULL OR s0_.date_end >= '2026-03-21 14:17:57') 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.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;

SELECT
  c0_.id AS id_0,
  c0_.term AS term_1,
  c0_.is_no_commission AS is_no_commission_2,
  c0_.credit_rule_id AS credit_rule_id_3,
  b1_.id AS id_4,
  b1_.name AS name_5,
  b1_.is_active AS is_active_6,
  b1_.handler AS handler_7,
  b1_.logo AS logo_8,
  b1_.created_at AS created_at_9,
  b1_.updated_at AS updated_at_10,
  c0_.product_id AS product_id_11,
  c0_.bank_id AS bank_id_12
FROM
  credits_index c0_
  INNER JOIN banks b1_ ON c0_.bank_id = b1_.id
WHERE
  b1_.is_active = ?
  AND c0_.product_id IN (?, ?)
  AND c0_.term > ?

SELECT c0_.id AS id_0, c0_.term AS term_1, c0_.is_no_commission AS is_no_commission_2, c0_.credit_rule_id AS credit_rule_id_3, b1_.id AS id_4, b1_.name AS name_5, b1_.is_active AS is_active_6, b1_.handler AS handler_7, b1_.logo AS logo_8, b1_.created_at AS created_at_9, b1_.updated_at AS updated_at_10, c0_.product_id AS product_id_11, c0_.bank_id AS bank_id_12 FROM credits_index c0_ INNER JOIN banks b1_ ON c0_.bank_id = b1_.id WHERE b1_.is_active = 1 AND c0_.product_id IN (140674, 140729) AND c0_.term > 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 = '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 14:17:57') AND (s0_.date_end IS NULL OR s0_.date_end >= '2026-03-21 14:17:57') ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC LIMIT 1;