Symfony Profiler

Query Metrics

34 Database Queries

11 Different statements

13.07 ms Query time

0 Invalid entities

Queries


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_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 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 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 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 < ? 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, k1_.id AS id_15, k1_.ln_id AS ln_id_16, k1_.category_name AS category_name_17, k1_.category_description AS category_description_18, k1_.short_desc AS short_desc_19, k1_.meta_title AS meta_title_20, k1_.meta_keywords AS meta_keywords_21, k1_.meta_description AS meta_description_22, k1_.category_id AS category_id_23 FROM Categories c0_ LEFT JOIN kk_categories_ln k1_ ON c0_.category_id = k1_.category_id WHERE c0_.active = 1 AND c0_.category_left > ? AND c0_.category_right < ? AND c0_.category_level = ? AND c0_.category_id > 0 AND c0_.is_empty = 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 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_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6
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 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_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6
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 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_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6
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 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_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6
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 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_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6
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 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_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6
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 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_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6
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 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_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6
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 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_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6
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 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_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6
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 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_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6
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 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_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6
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

#▲	Time	Info
1	0.18 ms	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 Parameters: [`0`] View formatted query View runnable query Explain query 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;
2	0.49 ms	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 Parameters: [`"tehnka-elektronka"`] View formatted query View runnable query Explain query 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 = 'tehnka-elektronka' ORDER BY c0_.category_id ASC LIMIT 1;
3	0.08 ms	SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.active AS active_3, k0_.default AS default_4 FROM kk_language k0_ WHERE k0_.code = ? LIMIT 1 Parameters: [`"ru"`] View formatted query View runnable query Explain query SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.active AS active_3, k0_.default AS default_4 FROM kk_language k0_ WHERE k0_.code = ? LIMIT 1 SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.active AS active_3, k0_.default AS default_4 FROM kk_language k0_ WHERE k0_.code = 'ru' LIMIT 1;
4	0.07 ms	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 Parameters: [`1`] View formatted query View runnable query Explain query 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;
5	0.07 ms	SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0 SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0;
6	0.05 ms	SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0 SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0;
7	0.44 ms	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 Parameters: [`47 72 1`] View formatted query View runnable query Explain query 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 < 47 AND c0_.category_right > 72 AND c0_.category_id > 0 AND c0_.category_level = 1 LIMIT 1;
8	0.42 ms	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 Parameters: [`47 72`] View formatted query View runnable query Explain query 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 < 47 AND c0_.category_right > 72 AND c0_.category_id > 0 ORDER BY c0_.category_left ASC;
9	0.76 ms	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, k1_.id AS id_15, k1_.ln_id AS ln_id_16, k1_.category_name AS category_name_17, k1_.category_description AS category_description_18, k1_.short_desc AS short_desc_19, k1_.meta_title AS meta_title_20, k1_.meta_keywords AS meta_keywords_21, k1_.meta_description AS meta_description_22, k1_.category_id AS category_id_23 FROM Categories c0_ LEFT JOIN kk_categories_ln k1_ ON c0_.category_id = k1_.category_id WHERE c0_.active = 1 AND c0_.category_left > ? AND c0_.category_right < ? AND c0_.category_level = ? AND c0_.category_id > 0 AND c0_.is_empty = 0 ORDER BY c0_.category_left ASC Parameters: [`47 72 3`] View formatted query View runnable query Explain query 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, k1_.id AS id_15, k1_.ln_id AS ln_id_16, k1_.category_name AS category_name_17, k1_.category_description AS category_description_18, k1_.short_desc AS short_desc_19, k1_.meta_title AS meta_title_20, k1_.meta_keywords AS meta_keywords_21, k1_.meta_description AS meta_description_22, k1_.category_id AS category_id_23 FROM Categories c0_ LEFT JOIN kk_categories_ln k1_ ON c0_.category_id = k1_.category_id WHERE c0_.active = 1 AND c0_.category_left > ? AND c0_.category_right < ? AND c0_.category_level = ? AND c0_.category_id > 0 AND c0_.is_empty = 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, k1_.id AS id_15, k1_.ln_id AS ln_id_16, k1_.category_name AS category_name_17, k1_.category_description AS category_description_18, k1_.short_desc AS short_desc_19, k1_.meta_title AS meta_title_20, k1_.meta_keywords AS meta_keywords_21, k1_.meta_description AS meta_description_22, k1_.category_id AS category_id_23 FROM Categories c0_ LEFT JOIN kk_categories_ln k1_ ON c0_.category_id = k1_.category_id WHERE c0_.active = 1 AND c0_.category_left > 47 AND c0_.category_right < 72 AND c0_.category_level = 3 AND c0_.category_id > 0 AND c0_.is_empty = 0 ORDER BY c0_.category_left ASC;
10	0.40 ms	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 Parameters: [`300`] View formatted query View runnable query Explain query 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 = 300 LIMIT 1;
11	0.80 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 Parameters: [`48 49 1 1`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 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_left >= 48 AND c4_.category_right <= 49 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6;
12	0.28 ms	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 Parameters: [`345`] View formatted query View runnable query Explain query 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 = 345 LIMIT 1;
13	0.53 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 Parameters: [`50 51 1 1`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 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_left >= 50 AND c4_.category_right <= 51 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6;
14	0.12 ms	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 Parameters: [`301`] View formatted query View runnable query Explain query 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 = 301 LIMIT 1;
15	0.60 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 Parameters: [`52 53 1 1`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 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_left >= 52 AND c4_.category_right <= 53 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6;
16	0.28 ms	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 Parameters: [`302`] View formatted query View runnable query Explain query 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 = 302 LIMIT 1;
17	0.54 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 Parameters: [`54 55 1 1`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 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_left >= 54 AND c4_.category_right <= 55 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6;
18	0.28 ms	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 Parameters: [`306`] View formatted query View runnable query Explain query 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 = 306 LIMIT 1;
19	0.62 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 Parameters: [`56 57 1 1`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 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_left >= 56 AND c4_.category_right <= 57 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6;
20	0.27 ms	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 Parameters: [`335`] View formatted query View runnable query Explain query 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 = 335 LIMIT 1;
21	0.54 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 Parameters: [`58 59 1 1`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 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_left >= 58 AND c4_.category_right <= 59 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6;
22	0.27 ms	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 Parameters: [`336`] View formatted query View runnable query Explain query 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 = 336 LIMIT 1;
23	0.50 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 Parameters: [`60 61 1 1`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 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_left >= 60 AND c4_.category_right <= 61 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6;
24	0.27 ms	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 Parameters: [`338`] View formatted query View runnable query Explain query 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 = 338 LIMIT 1;
25	0.50 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 Parameters: [`62 63 1 1`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 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_left >= 62 AND c4_.category_right <= 63 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6;
26	0.42 ms	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 Parameters: [`340`] View formatted query View runnable query Explain query 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 = 340 LIMIT 1;
27	0.57 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 Parameters: [`64 65 1 1`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 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_left >= 64 AND c4_.category_right <= 65 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6;
28	0.32 ms	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 Parameters: [`339`] View formatted query View runnable query Explain query 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 = 339 LIMIT 1;
29	0.51 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 Parameters: [`66 67 1 1`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 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_left >= 66 AND c4_.category_right <= 67 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6;
30	0.34 ms	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 Parameters: [`343`] View formatted query View runnable query Explain query 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 = 343 LIMIT 1;
31	0.54 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 Parameters: [`68 69 1 1`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 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_left >= 68 AND c4_.category_right <= 69 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6;
32	0.27 ms	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 Parameters: [`344`] View formatted query View runnable query Explain query 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 = 344 LIMIT 1;
33	0.50 ms	SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 Parameters: [`70 71 1 1`] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id 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 >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6 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_left >= 70 AND c4_.category_right <= 71 AND s1_.is_show_in_catalog = 1 AND s1_.presence >= 1 ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 6;
34	0.24 ms	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 Parameters: [`"notify_top" "datepicker" "notify_url"`] View formatted query View runnable query Explain query 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;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
SoftUa\CategoryBundle\Entity\Category	No errors.
SoftUa\CategoryBundle\Entity\CategoryTranslation	No errors.
SoftUa\CoreBundle\Entity\DataLanguage	No errors.
SoftUa\SeoBundle\Entity\SeoTemplate	No errors.
SoftUa\SeoBundle\Entity\SeoTemplateTranslation	No errors.
SoftUa\CurrencyBundle\Entity\Currency	No errors.
SoftUa\ProductBundle\Entity\Product	No errors.
SoftUa\ProductBundle\Entity\ProductIndex	No errors.
SoftUa\ProductBundle\Entity\ProductData	No errors.
SoftUa\ProductBundle\Entity\GroupSettings	No errors.
SoftUa\HeaderNotificationBundle\Entity\StoreSettings	No errors.
SoftUa\HeaderNotificationBundle\Entity\StoreSettingsTranslation	No errors.

Symfony Profiler

GET https://b2c-leobro.url.org.ua/_fragment?_path=_format%3Dhtml%26_locale%3Dru%26_controller%3DApp%255CController%255CRegistrationController%253A%253AregistrationF…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping