Symfony Profiler

SELECT
  (
    SELECT
      MIN(s0_.price) AS sclr_1
    FROM
      sf_product_index s1_
      INNER JOIN sf_product_price_index s0_ ON (
        s1_.product_id = s0_.product_id
        AND s0_.price_type = 'price_retail'
      )
    WHERE
      s1_.catalog_product_id = s2_.catalog_product_id
      AND s1_.presence > 0
      AND s0_.price > 0
  ) AS sclr_0,
  p3_.product_id AS product_id_2,
  p3_.product AS product_3,
  p3_.pn AS pn_4,
  p3_.description AS description_5,
  p3_.detail_description AS detail_description_6,
  p3_.deleted AS deleted_7,
  p3_.pic AS pic_8,
  p3_.warranty AS warranty_9,
  p3_.cost_min AS cost_min_10,
  p3_.create_time AS create_time_11,
  s2_.product_id AS product_id_12,
  s2_.group_id AS group_id_13,
  s2_.product_type AS product_type_14,
  s2_.is_show_in_catalog AS is_show_in_catalog_15,
  s2_.presence AS presence_16,
  s2_.presence_str AS presence_str_17,
  s2_.rating AS rating_18,
  p4_.product_id AS product_id_19,
  p4_.url_code AS url_code_20,
  p4_.rating AS rating_21,
  p4_.seo_title AS seo_title_22,
  p4_.seo_description AS seo_description_23,
  p4_.seo_keyword AS seo_keyword_24,
  p5_.id AS id_25,
  p5_.default AS default_26,
  p5_.change_data AS change_data_27,
  p5_.show_img AS show_img_28,
  p5_.show_price AS show_price_29,
  p5_.show_presence AS show_presence_30,
  p5_.features_sharing AS features_sharing_31,
  p5_.manual_sharing AS manual_sharing_32,
  p5_.features AS features_33,
  p3_.category_id AS category_id_34,
  s2_.category_id AS category_id_35,
  s2_.catalog_product_id AS catalog_product_id_36,
  s2_.product_id AS product_id_37,
  p4_.product_id AS product_id_38,
  p5_.product_id AS product_id_39
FROM
  Products p3_
  INNER JOIN sf_product_index s2_ ON p3_.product_id = s2_.product_id
  INNER JOIN Products_Data p4_ ON p3_.product_id = p4_.product_id
  LEFT JOIN products_groups p5_ ON p3_.product_id = p5_.product_id
  INNER JOIN Products_Categoryes p7_ ON p3_.product_id = p7_.product_id
  INNER JOIN Categories c6_ ON c6_.category_id = p7_.category_id
WHERE
  p3_.deleted = 0
  AND p4_.url_code <> ''
  AND c6_.category_left >= ?
  AND c6_.category_right <= ?
  AND s2_.is_show_in_catalog = ?
  AND s2_.presence >= ?
  AND (
    p3_.product_id IN (
      SELECT
        DISTINCT s8_.catalog_product_id AS sclr_40
      FROM
        sf_product_index s8_
      WHERE
        s8_.catalog_product_id IN (?, ?, ?)
        OR s8_.product_id IN (?, ?, ?)
    )
  )
ORDER BY
  IF(s2_.presence = 0, 1, 0) ASC,
  sclr_0 ASC
LIMIT
  30

SELECT (SELECT MIN(s0_.price) AS sclr_1 FROM sf_product_index s1_ INNER JOIN sf_product_price_index s0_ ON (s1_.product_id = s0_.product_id AND s0_.price_type = 'price_retail') WHERE s1_.catalog_product_id = s2_.catalog_product_id AND s1_.presence > 0 AND s0_.price > 0) AS sclr_0, p3_.product_id AS product_id_2, p3_.product AS product_3, p3_.pn AS pn_4, p3_.description AS description_5, p3_.detail_description AS detail_description_6, p3_.deleted AS deleted_7, p3_.pic AS pic_8, p3_.warranty AS warranty_9, p3_.cost_min AS cost_min_10, p3_.create_time AS create_time_11, s2_.product_id AS product_id_12, s2_.group_id AS group_id_13, s2_.product_type AS product_type_14, s2_.is_show_in_catalog AS is_show_in_catalog_15, s2_.presence AS presence_16, s2_.presence_str AS presence_str_17, s2_.rating AS rating_18, p4_.product_id AS product_id_19, p4_.url_code AS url_code_20, p4_.rating AS rating_21, p4_.seo_title AS seo_title_22, p4_.seo_description AS seo_description_23, p4_.seo_keyword AS seo_keyword_24, p5_.id AS id_25, p5_.default AS default_26, p5_.change_data AS change_data_27, p5_.show_img AS show_img_28, p5_.show_price AS show_price_29, p5_.show_presence AS show_presence_30, p5_.features_sharing AS features_sharing_31, p5_.manual_sharing AS manual_sharing_32, p5_.features AS features_33, p3_.category_id AS category_id_34, s2_.category_id AS category_id_35, s2_.catalog_product_id AS catalog_product_id_36, s2_.product_id AS product_id_37, p4_.product_id AS product_id_38, p5_.product_id AS product_id_39 FROM Products p3_ INNER JOIN sf_product_index s2_ ON p3_.product_id = s2_.product_id INNER JOIN Products_Data p4_ ON p3_.product_id = p4_.product_id LEFT JOIN products_groups p5_ ON p3_.product_id = p5_.product_id INNER JOIN Products_Categoryes p7_ ON p3_.product_id = p7_.product_id INNER JOIN Categories c6_ ON c6_.category_id = p7_.category_id WHERE p3_.deleted = 0 AND p4_.url_code <> '' AND c6_.category_left >= 2 AND c6_.category_right <= 37 AND s2_.is_show_in_catalog = 1 AND s2_.presence >= 0 AND (p3_.product_id IN (SELECT DISTINCT s8_.catalog_product_id AS sclr_40 FROM sf_product_index s8_ WHERE s8_.catalog_product_id IN (1000, 1001, 0) OR s8_.product_id IN (1000, 1001, 0))) ORDER BY IF(s2_.presence = 0, 1, 0) ASC, sclr_0 ASC LIMIT 30;

SELECT
  COUNT(DISTINCT p0_.product_id) AS sclr_0
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
  INNER JOIN Products_Categoryes p5_ ON p0_.product_id = p5_.product_id
  INNER JOIN Categories c4_ ON c4_.category_id = p5_.category_id
WHERE
  p0_.deleted = 0
  AND p2_.url_code <> ''
  AND c4_.category_left >= ?
  AND c4_.category_right <= ?
  AND s1_.is_show_in_catalog = ?
  AND s1_.presence >= ?
  AND (
    p0_.product_id IN (
      SELECT
        DISTINCT s6_.catalog_product_id AS sclr_1
      FROM
        sf_product_index s6_
      WHERE
        s6_.catalog_product_id IN (?, ?, ?)
        OR s6_.product_id IN (?, ?, ?)
    )
  )
ORDER BY
  p0_.product_id ASC

SELECT COUNT(DISTINCT p0_.product_id) AS sclr_0 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 INNER JOIN Products_Categoryes p5_ ON p0_.product_id = p5_.product_id INNER JOIN Categories c4_ ON c4_.category_id = p5_.category_id WHERE p0_.deleted = 0 AND p2_.url_code <> '' AND c4_.category_left >= 2 AND c4_.category_right <= 37 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 0 AND (p0_.product_id IN (SELECT DISTINCT s6_.catalog_product_id AS sclr_1 FROM sf_product_index s6_ WHERE s6_.catalog_product_id IN (1000, 1001, 0) OR s6_.product_id IN (1000, 1001, 0))) ORDER BY p0_.product_id ASC;

SELECT
  GROUP_CONCAT(f0_.product_id) AS sclr_0,
  f1_.value AS value_1,
  f1_.id AS id_2,
  f1_.code AS code_3,
  f2_.feature_id AS feature_id_4,
  f2_.value_id AS value_id_5,
  f2_.weight AS weight_6,
  f2_.img AS img_7,
  f2_.url AS url_8,
  f2_.description AS description_9,
  f2_.color AS color_10,
  k3_.value_id AS value_id_11,
  k3_.feature_id AS feature_id_12,
  k3_.ln_id AS ln_id_13,
  k3_.value AS value_14,
  k3_.url AS url_15,
  k3_.description AS description_16,
  f1_.id AS id_17,
  f1_.feature_id AS feature_id_18,
  f1_.feature_id AS feature_id_19,
  k3_.value_id AS value_id_20,
  k3_.feature_id AS feature_id_21
FROM
  Feature_Values_string f1_
  INNER JOIN Feature_Value_Settings f2_ ON f1_.id = f2_.value_id
  AND f1_.feature_id = f2_.feature_id
  LEFT JOIN kk_features_values_ln k3_ ON f2_.value_id = k3_.value_id
  AND f2_.feature_id = k3_.feature_id
  INNER JOIN Feature_Product_Values f0_ ON (
    f1_.id = f0_.value_id
    AND f1_.feature_id = f0_.feature_id
  )
WHERE
  f1_.feature_id = ?
  AND f1_.value <> ''
  AND f0_.product_id IN (?)
GROUP BY
  f1_.id
ORDER BY
  f2_.weight ASC

SELECT GROUP_CONCAT(f0_.product_id) AS sclr_0, f1_.value AS value_1, f1_.id AS id_2, f1_.code AS code_3, f2_.feature_id AS feature_id_4, f2_.value_id AS value_id_5, f2_.weight AS weight_6, f2_.img AS img_7, f2_.url AS url_8, f2_.description AS description_9, f2_.color AS color_10, k3_.value_id AS value_id_11, k3_.feature_id AS feature_id_12, k3_.ln_id AS ln_id_13, k3_.value AS value_14, k3_.url AS url_15, k3_.description AS description_16, f1_.id AS id_17, f1_.feature_id AS feature_id_18, f1_.feature_id AS feature_id_19, k3_.value_id AS value_id_20, k3_.feature_id AS feature_id_21 FROM Feature_Values_string f1_ INNER JOIN Feature_Value_Settings f2_ ON f1_.id = f2_.value_id AND f1_.feature_id = f2_.feature_id LEFT JOIN kk_features_values_ln k3_ ON f2_.value_id = k3_.value_id AND f2_.feature_id = k3_.feature_id INNER JOIN Feature_Product_Values f0_ ON (f1_.id = f0_.value_id AND f1_.feature_id = f0_.feature_id) WHERE f1_.feature_id = 1 AND f1_.value <> '' AND f0_.product_id IN (1000) GROUP BY f1_.id ORDER BY f2_.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_.in_short_list = ?
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 (1000, 1001) AND f1_.in_short_list = 1 ORDER BY f3_.weight ASC, f1_.weight ASC;

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 s1_.product_id IN (?, ?)
  AND s1_.product_type <> ?
ORDER BY
  FIELD(p0_.product_id, ?, ?) ASC
LIMIT
  100

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 s1_.product_id IN ('1000', '1001') AND s1_.product_type <> 'group' ORDER BY FIELD(p0_.product_id, '1000', '1001') ASC LIMIT 100;

SELECT
  f0_.product_id AS sclr_0,
  f0_.catalog_product_id AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_left >= ?
  AND c2_.category_right <= ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_category.j_test_cat'
  ) IS NOT NULL

SELECT f0_.product_id AS sclr_0, f0_.catalog_product_id AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_left >= 2 AND c2_.category_right <= 37 AND JSON_EXTRACT(f0_.features, '$.j_category.j_test_cat') IS NOT NULL;

SELECT
  a0_.id AS id_0,
  a0_.access_token AS access_token_1,
  a0_.created_at AS created_at_2,
  a0_.customer_id AS customer_id_3
FROM
  access_token a0_
  INNER JOIN Contragents c1_ ON a0_.customer_id = c1_.contragent_id
WHERE
  a0_.access_token = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.access_token AS access_token_1, a0_.created_at AS created_at_2, a0_.customer_id AS customer_id_3 FROM access_token a0_ INNER JOIN Contragents c1_ ON a0_.customer_id = c1_.contragent_id WHERE a0_.access_token = 'EX0JYSKlC-_W0Yjq5bmsbBcLyrW7-X14nAg6t6L4uFA' LIMIT 1;

SELECT
  c0_.contragent_id AS contragent_id_0,
  c0_.contragent_type AS contragent_type_1,
  c0_.currency_id AS currency_id_2,
  c0_.first_name AS first_name_3,
  c0_.last_name AS last_name_4,
  c0_.middle_name AS middle_name_5,
  c0_.sex AS sex_6,
  c0_.birthday AS birthday_7,
  c0_.enterprise_form AS enterprise_form_8,
  c0_.short_name AS short_name_9,
  c0_.full_name AS full_name_10,
  c0_.price_sold AS price_sold_11,
  c0_.password AS password_12,
  c0_.restore_password_code AS restore_password_code_13,
  c0_.restore_date AS restore_date_14,
  c0_.email AS email_15,
  c0_.phone AS phone_16,
  c0_.address AS address_17,
  c0_.delivery_address AS delivery_address_18,
  c0_.contragent_logo AS contragent_logo_19,
  c0_.nick AS nick_20,
  c0_.ishop_contragent_id AS ishop_contragent_id_21,
  c0_.inn AS inn_22,
  c0_.comments AS comments_23,
  c0_.as_default AS as_default_24,
  c0_.is_active AS is_active_25
FROM
  Contragents c0_
WHERE
  c0_.contragent_id = ?
LIMIT
  1

SELECT c0_.contragent_id AS contragent_id_0, c0_.contragent_type AS contragent_type_1, c0_.currency_id AS currency_id_2, c0_.first_name AS first_name_3, c0_.last_name AS last_name_4, c0_.middle_name AS middle_name_5, c0_.sex AS sex_6, c0_.birthday AS birthday_7, c0_.enterprise_form AS enterprise_form_8, c0_.short_name AS short_name_9, c0_.full_name AS full_name_10, c0_.price_sold AS price_sold_11, c0_.password AS password_12, c0_.restore_password_code AS restore_password_code_13, c0_.restore_date AS restore_date_14, c0_.email AS email_15, c0_.phone AS phone_16, c0_.address AS address_17, c0_.delivery_address AS delivery_address_18, c0_.contragent_logo AS contragent_logo_19, c0_.nick AS nick_20, c0_.ishop_contragent_id AS ishop_contragent_id_21, c0_.inn AS inn_22, c0_.comments AS comments_23, c0_.as_default AS as_default_24, c0_.is_active AS is_active_25 FROM Contragents c0_ WHERE c0_.contragent_id = 9 LIMIT 1;

SELECT
  s0_.product_id AS sclr_0
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 IN (?, ?)
  AND s1_.active = 1
  AND (
    s0_.date_start IS NULL
    OR s0_.date_start <= ?
  )
  AND (
    s0_.date_end IS NULL
    OR s0_.date_end >= ?
  )
GROUP BY
  s0_.product_id
ORDER BY
  IF(s0_.date_end IS NULL, 1, 0) ASC,
  s0_.date_end ASC

SELECT s0_.product_id AS sclr_0 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 IN (1000, 1001) AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= '2026-01-15 17:45:55') AND (s0_.date_end IS NULL OR s0_.date_end >= '2026-01-15 17:45:55') GROUP BY s0_.product_id ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.position AS position_2,
  l0_.description AS description_3,
  l0_.active AS active_4,
  l0_.offset AS offset_5,
  l0_.img AS img_6,
  p1_.product_id AS product_id_7
FROM
  labels l0_
  INNER JOIN labels_products l2_ ON l0_.id = l2_.label_id
  INNER JOIN Products p1_ ON p1_.product_id = l2_.product_id
WHERE
  p1_.product_id IN (?, ?)
  AND l0_.active = ?

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.position AS position_2, l0_.description AS description_3, l0_.active AS active_4, l0_.offset AS offset_5, l0_.img AS img_6, p1_.product_id AS product_id_7 FROM labels l0_ INNER JOIN labels_products l2_ ON l0_.id = l2_.label_id INNER JOIN Products p1_ ON p1_.product_id = l2_.product_id WHERE p1_.product_id IN (1000, 1001) AND l0_.active = 1;

SELECT
  c0_.category_id AS category_id_0,
  c0_.category_name AS category_name_1,
  c0_.category_left AS category_left_2,
  c0_.category_level AS category_level_3,
  c0_.category_right AS category_right_4,
  c0_.description AS description_5,
  c0_.short_desc AS short_desc_6,
  c0_.code AS code_7,
  c0_.img AS img_8,
  c0_.meta_title AS meta_title_9,
  c0_.meta_keywords AS meta_keywords_10,
  c0_.meta_description AS meta_description_11,
  c0_.active AS active_12,
  c0_.is_empty AS is_empty_13,
  c0_.category_top AS category_top_14
FROM
  Categories c0_
WHERE
  c0_.active = 1
  AND c0_.category_id = ?
LIMIT
  1

SELECT c0_.category_id AS category_id_0, c0_.category_name AS category_name_1, c0_.category_left AS category_left_2, c0_.category_level AS category_level_3, c0_.category_right AS category_right_4, c0_.description AS description_5, c0_.short_desc AS short_desc_6, c0_.code AS code_7, c0_.img AS img_8, c0_.meta_title AS meta_title_9, c0_.meta_keywords AS meta_keywords_10, c0_.meta_description AS meta_description_11, c0_.active AS active_12, c0_.is_empty AS is_empty_13, c0_.category_top AS category_top_14 FROM Categories c0_ WHERE c0_.active = 1 AND c0_.category_id = 1018 LIMIT 1;

SELECT
  AVG(c0_.assessment) AS sclr_0,
  c0_.id_article AS id_article_1
FROM
  COMMENT c0_
WHERE
  c0_.type_comment = ?
  AND c0_.id_article IN (?, ?)
  AND c0_.status = ?
  AND (
    c0_.parent_id IS NULL
    OR c0_.parent_id = 0
  )
  AND c0_.assessment <> 0
GROUP BY
  c0_.id_article

SELECT AVG(c0_.assessment) AS sclr_0, c0_.id_article AS id_article_1 FROM COMMENT c0_ WHERE c0_.type_comment = 'product' AND c0_.id_article IN (1000, 1001) AND c0_.status = 1 AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.assessment <> 0 GROUP BY c0_.id_article;

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 (1000, 1001) AND c0_.term > 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 (1000) AND f1_.use_as = 'unit' ORDER BY f3_.weight ASC, f1_.weight ASC;