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 = 'stelazh' 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 = 290;

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 < 24 AND c0_.category_right > 25 AND c0_.category_id > 0 AND c0_.category_level = 2 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 = 308;

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 < 24 AND c0_.category_right > 25 AND c0_.category_id > 0 ORDER BY c0_.category_left ASC;

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

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 = 290 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 = 290 ORDER BY f0_.id 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 < ?
  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 < 24 AND c0_.category_right > 25 AND c0_.category_id > 0 AND c0_.category_level = 2 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 = 290 LIMIT 1;

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_id = ?
  AND s2_.is_show_in_catalog = ?
  AND s2_.presence >= ?
ORDER BY
  IF(s2_.presence = 0, 1, 0) ASC,
  sclr_0 ASC
LIMIT
  48

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_id = 290 AND s2_.is_show_in_catalog = 1 AND s2_.presence >= 1 ORDER BY IF(s2_.presence = 0, 1, 0) ASC, sclr_0 ASC LIMIT 48;

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_id = ?
  AND s1_.is_show_in_catalog = ?
  AND s1_.presence >= ?
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_id = 290 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY p0_.product_id ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.lft AS lft_2,
  s0_.level AS level_3,
  s0_.rgt AS rgt_4,
  s0_.is_published AS is_published_5,
  s0_.is_active AS is_active_6,
  s0_.is_menu_item AS is_menu_item_7,
  s0_.is_hot_filter AS is_hot_filter_8,
  s0_.img AS img_9,
  s0_.filters AS filters_10,
  s0_.category_id AS category_id_11
FROM
  site_menu s0_
WHERE
  s0_.is_active = 1
  AND s0_.is_menu_item = 1
  AND s0_.category_id = ?
  AND s0_.filters IS NULL
ORDER BY
  s0_.level DESC,
  s0_.lft ASC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, s0_.category_id AS category_id_11 FROM site_menu s0_ WHERE s0_.is_active = 1 AND s0_.is_menu_item = 1 AND s0_.category_id = 290 AND s0_.filters IS NULL ORDER BY s0_.level DESC, s0_.lft ASC LIMIT 1;

SELECT
  s0_.setting_id AS setting_id_0,
  s0_.type AS type_1,
  s0_.setting_name AS setting_name_2,
  s0_.setting_value AS setting_value_3,
  s0_.description AS description_4
FROM
  store_settings s0_
  LEFT JOIN kk_settings_ln k1_ ON s0_.setting_id = k1_.setting_id
WHERE
  s0_.type = 'site'
  AND s0_.setting_name IN (?, ?, ?)
LIMIT
  3

SELECT s0_.setting_id AS setting_id_0, s0_.type AS type_1, s0_.setting_name AS setting_name_2, s0_.setting_value AS setting_value_3, s0_.description AS description_4 FROM store_settings s0_ LEFT JOIN kk_settings_ln k1_ ON s0_.setting_id = k1_.setting_id WHERE s0_.type = 'site' AND s0_.setting_name IN ('notify_top', 'datepicker', 'notify_url') LIMIT 3;