Symfony Profiler

SELECT
  c0_.category_id AS category_id_0,
  c0_.category_left AS category_left_1,
  c0_.category_right AS category_right_2,
  c0_.active AS active_3
FROM
  Categories c0_
WHERE
  c0_.active = ?
ORDER BY
  c0_.category_left ASC

SELECT c0_.category_id AS category_id_0, c0_.category_left AS category_left_1, c0_.category_right AS category_right_2, c0_.active AS active_3 FROM Categories c0_ WHERE c0_.active = 0 ORDER BY c0_.category_left ASC;

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_.code = ?
ORDER BY
  c0_.category_id ASC
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_.code = 'yashchiki-dlya-nstrumentv' ORDER BY c0_.category_id ASC 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 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;

SELECT
  t0.id AS id_1,
  t0.ln_id AS ln_id_2,
  t0.category_name AS category_name_3,
  t0.category_description AS category_description_4,
  t0.short_desc AS short_desc_5,
  t0.meta_title AS meta_title_6,
  t0.meta_keywords AS meta_keywords_7,
  t0.meta_description AS meta_description_8,
  t0.category_id AS category_id_9
FROM
  kk_categories_ln t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = 293;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.as_default AS as_default_2,
  s0_.product AS product_3,
  s0_.static AS static_4,
  s0_.news AS news_5,
  s0_.category AS category_6,
  s0_.subcategory AS subcategory_7,
  s0_.main AS main_8,
  s0_.catalog AS catalog_9
FROM
  seo_templates s0_
WHERE
  s0_.as_default = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.as_default AS as_default_2, s0_.product AS product_3, s0_.static AS static_4, s0_.news AS news_5, s0_.category AS category_6, s0_.subcategory AS subcategory_7, s0_.main AS main_8, s0_.catalog AS catalog_9 FROM seo_templates s0_ WHERE s0_.as_default = 1 LIMIT 1;

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
  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_left < ?
  AND c0_.category_right > ?
  AND c0_.category_id > 0
  AND c0_.category_level = ?
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_left < 27 AND c0_.category_right > 28 AND c0_.category_id > 0 AND c0_.category_level = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.ln_id AS ln_id_2,
  t0.category_name AS category_name_3,
  t0.category_description AS category_description_4,
  t0.short_desc AS short_desc_5,
  t0.meta_title AS meta_title_6,
  t0.meta_keywords AS meta_keywords_7,
  t0.meta_description AS meta_description_8,
  t0.category_id AS category_id_9
FROM
  kk_categories_ln t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = 309;

SELECT
  t0.data_id AS data_id_1,
  t0.ln_id AS ln_id_2,
  t0.product AS product_3,
  t0.static AS static_4,
  t0.news AS news_5,
  t0.category AS category_6,
  t0.subcategory AS subcategory_7,
  t0.main AS main_8,
  t0.catalog AS catalog_9,
  t0.data_id AS data_id_10
FROM
  kk_seo_templates_ln t0
WHERE
  t0.data_id = ?

SELECT t0.data_id AS data_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.static AS static_4, t0.news AS news_5, t0.category AS category_6, t0.subcategory AS subcategory_7, t0.main AS main_8, t0.catalog AS catalog_9, t0.data_id AS data_id_10 FROM kk_seo_templates_ln t0 WHERE t0.data_id = 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_left < ?
  AND c0_.category_right > ?
  AND c0_.category_id > 0
ORDER BY
  c0_.category_left ASC

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_left < 27 AND c0_.category_right > 28 AND c0_.category_id > 0 ORDER BY c0_.category_left ASC;

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 = 293 LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.feature_id AS feature_id_1,
  f0_.category_id AS category_id_2,
  f0_.code AS code_3,
  f0_.is_slider AS is_slider_4,
  f0_.view_settings AS view_settings_5,
  f0_.logic AS logic_6,
  f1_.id AS id_7,
  f1_.code AS code_8,
  f1_.name AS name_9,
  f1_.weight AS weight_10,
  f1_.category_id AS category_id_11,
  f1_.active AS active_12,
  f1_.auto_settings AS auto_settings_13,
  f1_.logic AS logic_14,
  f1_.feature_id AS feature_id_15,
  f2_.id AS id_16,
  f2_.feature_id AS feature_id_17,
  f2_.value_id AS value_id_18,
  f2_.code AS code_19,
  f2_.img AS img_20,
  f2_.value AS value_21,
  f2_.description AS description_22,
  f2_.json_path AS json_path_23,
  f2_.facet_size AS facet_size_24,
  f0_.filter_id AS filter_id_25,
  f2_.filter_id AS filter_id_26
FROM
  filters_list_index f0_
  LEFT JOIN filters f1_ ON f0_.filter_id = f1_.id
  LEFT JOIN filters_value_index f2_ ON f1_.id = f2_.filter_id
  AND (
    f0_.feature_id > 0
    AND f0_.is_slider = 1
  )
WHERE
  f0_.category_id = ?
ORDER BY
  f0_.id ASC

SELECT f0_.id AS id_0, f0_.feature_id AS feature_id_1, f0_.category_id AS category_id_2, f0_.code AS code_3, f0_.is_slider AS is_slider_4, f0_.view_settings AS view_settings_5, f0_.logic AS logic_6, f1_.id AS id_7, f1_.code AS code_8, f1_.name AS name_9, f1_.weight AS weight_10, f1_.category_id AS category_id_11, f1_.active AS active_12, f1_.auto_settings AS auto_settings_13, f1_.logic AS logic_14, f1_.feature_id AS feature_id_15, f2_.id AS id_16, f2_.feature_id AS feature_id_17, f2_.value_id AS value_id_18, f2_.code AS code_19, f2_.img AS img_20, f2_.value AS value_21, f2_.description AS description_22, f2_.json_path AS json_path_23, f2_.facet_size AS facet_size_24, f0_.filter_id AS filter_id_25, f2_.filter_id AS filter_id_26 FROM filters_list_index f0_ LEFT JOIN filters f1_ ON f0_.filter_id = f1_.id LEFT JOIN filters_value_index f2_ ON f1_.id = f2_.filter_id AND (f0_.feature_id > 0 AND f0_.is_slider = 1) WHERE f0_.category_id = 293 ORDER BY f0_.id ASC;

SELECT
  MIN(f0_.price_selling) AS sclr_0,
  MAX(f0_.price_selling) 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_id = ?
  AND f0_.price_selling > 0

SELECT MIN(f0_.price_selling) AS sclr_0, MAX(f0_.price_selling) 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_id = 293 AND f0_.price_selling > 0;

SELECT
  f0_.id AS id_0,
  f0_.feature_id AS feature_id_1,
  f0_.value_id AS value_id_2,
  f0_.code AS code_3,
  f0_.img AS img_4,
  f0_.value AS value_5,
  f0_.description AS description_6,
  f0_.json_path AS json_path_7,
  f0_.facet_size AS facet_size_8,
  f0_.filter_id AS filter_id_9
FROM
  filters_value_index f0_
  LEFT JOIN filters f1_ ON f0_.filter_id = f1_.id
  LEFT JOIN filters_list_index f2_ ON f1_.id = f2_.filter_id
  AND (
    f2_.feature_id > 0
    AND f2_.is_slider = 1
  )
WHERE
  f2_.id IS NULL
  AND f0_.filter_id IN (?, ?, ?)
ORDER BY
  f0_.id ASC

SELECT f0_.id AS id_0, f0_.feature_id AS feature_id_1, f0_.value_id AS value_id_2, f0_.code AS code_3, f0_.img AS img_4, f0_.value AS value_5, f0_.description AS description_6, f0_.json_path AS json_path_7, f0_.facet_size AS facet_size_8, f0_.filter_id AS filter_id_9 FROM filters_value_index f0_ LEFT JOIN filters f1_ ON f0_.filter_id = f1_.id LEFT JOIN filters_list_index f2_ ON f1_.id = f2_.filter_id AND (f2_.feature_id > 0 AND f2_.is_slider = 1) WHERE f2_.id IS NULL AND f0_.filter_id IN (12, 11, 23) ORDER BY f0_.id ASC;

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_seriya.j_pro'
      ) IS NOT NULL
    ) THEN 'pro' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_seriya.j_one'
      ) IS NOT NULL
    ) THEN 'one' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_seriya.j_longer_trolley'
      ) IS NOT NULL
    ) THEN 'longer-trolley' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_seriya.j_prime'
      ) IS NOT NULL
    ) THEN 'prime' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_seriya.j_prime_red_ultra_hd'
      ) IS NOT NULL
    ) THEN 'prime-red-ultra-hd' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_seriya.j_two'
      ) IS NOT NULL
    ) THEN 'two' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_seriya.j_pro_red_ultra_hd'
      ) IS NOT NULL
    ) THEN 'pro-red-ultra-hd' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_seriya.j_one_red_ultra_hd'
      ) IS NOT NULL
    ) THEN 'one-red-ultra-hd' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_seriya.j_accessories'
      ) IS NOT NULL
    ) THEN 'accessories' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_seriya.j_r_box'
      ) IS NOT NULL
    ) THEN 'r-box' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.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_id = ?
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_seriya.j_pro') IS NOT NULL) THEN 'pro' WHEN (JSON_EXTRACT(f0_.features, '$.j_seriya.j_one') IS NOT NULL) THEN 'one' WHEN (JSON_EXTRACT(f0_.features, '$.j_seriya.j_longer_trolley') IS NOT NULL) THEN 'longer-trolley' WHEN (JSON_EXTRACT(f0_.features, '$.j_seriya.j_prime') IS NOT NULL) THEN 'prime' WHEN (JSON_EXTRACT(f0_.features, '$.j_seriya.j_prime_red_ultra_hd') IS NOT NULL) THEN 'prime-red-ultra-hd' WHEN (JSON_EXTRACT(f0_.features, '$.j_seriya.j_two') IS NOT NULL) THEN 'two' WHEN (JSON_EXTRACT(f0_.features, '$.j_seriya.j_pro_red_ultra_hd') IS NOT NULL) THEN 'pro-red-ultra-hd' WHEN (JSON_EXTRACT(f0_.features, '$.j_seriya.j_one_red_ultra_hd') IS NOT NULL) THEN 'one-red-ultra-hd' WHEN (JSON_EXTRACT(f0_.features, '$.j_seriya.j_accessories') IS NOT NULL) THEN 'accessories' WHEN (JSON_EXTRACT(f0_.features, '$.j_seriya.j_r_box') IS NOT NULL) THEN 'r-box' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.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_id = 293 GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_proizvoditel.j_qbrick'
      ) IS NOT NULL
    ) THEN 'qbrick' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.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_id = ?
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_proizvoditel.j_qbrick') IS NOT NULL) THEN 'qbrick' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.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_id = 293 GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

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_left < ?
  AND c0_.category_right > ?
  AND c0_.category_id > 0
  AND c0_.category_level = ?
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_left < 27 AND c0_.category_right > 28 AND c0_.category_id > 0 AND c0_.category_level = 1 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 = ?
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 = 293 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
  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_id = ?
  AND s1_.is_show_in_catalog = ?
  AND s1_.presence >= ?
ORDER BY
  IF(s1_.presence = 0, 1, 0) ASC,
  s1_.rating DESC
LIMIT
  48 OFFSET 96

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 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_id = 293 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 48 OFFSET 96;

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 = 140150;

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