3d 6 arrow-left arrow-right arrow attach attention balloon-active balloon-hover balloon booking camera car chain close-thin close contacts-fail contacts-success credit-cart edit ellipsis email exit eye-open facebook full-screen google_oauth instagram list-alt login mailru mobile-phone more odnoklassniki phone point settings skype twitter viber vkontakte yandex_oauth
a a a a a a a
показать еще 48 товаров
Время: 0.3 с. Память: 7,066Кб, Запросы к БД: 19. Запросы к КЭШу: 1,108.
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)

SELECT COUNT(DISTINCT `t`.`id`)
FROM `re_catalog_product` `t`
LEFT OUTER JOIN `re_catalog_products_rubrics_sort` `productsRubricsSort` ON (`productsRubricsSort`.`product_id`=`t`.`id`)
LEFT OUTER JOIN `re_catalog_brand` `brand` ON (`t`.`brand_id`=`brand`.`id`)
WHERE ((productsRubricsSort.rubric_id = '10327053' AND productsRubricsSort.city_id = '1' AND t.status = '1') AND (brand.id = 24785))
1 0.02003 0.02003 0.02003 0.02003

SELECT `t`.`id` AS `t0_c0`, `productsRubricsSort`.`is_top` AS `t1_c5`, `productsRubricsSort`.`place_id` AS `t1_c7`, `productsRubricsSort`.`id` AS `t1_c0`
FROM `re_catalog_product` `t`
LEFT OUTER JOIN `re_catalog_products_rubrics_sort` `productsRubricsSort` ON (`productsRubricsSort`.`product_id`=`t`.`id`)
LEFT OUTER JOIN `re_catalog_brand` `brand` ON (`t`.`brand_id`=`brand`.`id`)
WHERE ((productsRubricsSort.rubric_id = '10327053' AND productsRubricsSort.city_id = '1' AND t.status = '1') AND (brand.id = 24785))
GROUP BY t.id
ORDER BY productsRubricsSort.have_sellers DESC, t.type = 'product_from_feed_item' ASC, (productsRubricsSort.price IS NOT NULL) DESC, t.two_weeks_views DESC
LIMIT 48
1 0.01513 0.01513 0.01513 0.01513

SELECT `t`.`id` AS `t0_c0`, `t`.`is_deleted` AS `t0_c1`, `t`.`status` AS `t0_c2`, `t`.`date_created` AS `t0_c3`, `t`.`type` AS `t0_c4`, `productsRubrics`.`id` AS `t3_c0`, `productsRubrics`.`product_id` AS `t3_c1`, `productsRubrics`.`rubric_id` AS `t3_c2`, `productsRubrics`.`is_main` AS `t3_c3`, `info`.`title` AS `t9_c3`, `info`.`id` AS `t9_c0`
FROM `re_place` `t`
LEFT OUTER JOIN `re_catalog_products_places` `productsPlaces` ON (`productsPlaces`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_catalog_product` `product` ON (`productsPlaces`.`product_id`=`product`.`id`)
LEFT OUTER JOIN `re_catalog_products_rubrics` `productsRubrics` ON (`productsRubrics`.`product_id`=`product`.`id`)
LEFT OUTER JOIN `re_rubric` `rubric` ON (`productsRubrics`.`rubric_id`=`rubric`.`id`)
LEFT OUTER JOIN `re_rubric_template` `templates` ON (`templates`.`rubric_id`=`rubric`.`id`)
LEFT OUTER JOIN `re_places_rubrics` `placesRubrics` ON (`placesRubrics`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_rubric` `rubricPlace` ON (`placesRubrics`.`rubric_id`=`rubricPlace`.`id`)
LEFT OUTER JOIN `re_rubric_template` `placeTemplates` ON (`placeTemplates`.`rubric_id`=`rubricPlace`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`t`.`id`)
WHERE (t.status = '1' AND placeTemplates.id = 10327673 AND templates.id = 10327673 AND product.status = '1') AND (info.state = 'paid')
GROUP BY t.id
ORDER BY info.title ASC
1 0.00928 0.00928 0.00928 0.00928

SELECT *
FROM `re_redirect` `t`
WHERE (t.from_url = 'http://www.relax.by/gds/face/brand-tiande/minsk/' OR t.from_url = 'http://www.relax.by/gds/face/brand-tiande/minsk') AND (type = 'for_all')
LIMIT 1
1 0.00615 0.00615 0.00615 0.00615

SELECT `t`.`id` AS `t0_c0`, `t`.`status` AS `t0_c1`, `t`.`type` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`title_personal` AS `t0_c4`, `t`.`icon` AS `t0_c5`, `t`.`note_description` AS `t0_c6`, `catalogProductFiltersRubricTemplates`.`id` AS `t1_c0`, `catalogProductFiltersRubricTemplates`.`status` AS `t1_c1`, `catalogProductFiltersRubricTemplates`.`sort_order` AS `t1_c2`, `catalogProductFiltersRubricTemplates`.`filter_id` AS `t1_c3`, `catalogProductFiltersRubricTemplates`.`template_id` AS `t1_c4`, `catalogProductFiltersRubricTemplates`.`title_rubric` AS `t1_c5`, `catalogProductFiltersRubricTemplates`.`show_count_option` AS `t1_c6`, `catalogProductFiltersRubricTemplates`.`show_in_description` AS `t1_c7`, `catalogProductFiltersRubricTemplates`.`show_in_rubric` AS `t1_c8`, `catalogProductFiltersRubricTemplates`.`show_in_personal` AS `t1_c9`, `catalogProductFiltersRubricTemplates`.`measure_unit_id` AS `t1_c10`, `catalogProductFiltersRubricTemplates`.`seo_title` AS `t1_c11`, `catalogProductFiltersRubricTemplates`.`url` AS `t1_c12`, `catalogProductFiltersRubricTemplates`.`is_required_in_rubric` AS `t1_c13`, `catalogProductFiltersRubricTemplates`.`note_description` AS `t1_c14`, `catalogProductFiltersRubricTemplates`.`note_title` AS `t1_c15`, `catalogProductFiltersRubricTemplates`.`show_note_in_source` AS `t1_c16`, `measureUnit`.`id` AS `t2_c0`, `measureUnit`.`title` AS `t2_c1`, `options`.`id` AS `t3_c0`, `options`.`filter_id` AS `t3_c1`, `options`.`value` AS `t3_c2`, `options`.`icon` AS `t3_c3`, `options`.`icon_title` AS `t3_c4`, `options`.`title_in_api` AS `t3_c5`, `options`.`sort_order` AS `t3_c6`
FROM `re_catalog_product_filter` `t`
LEFT OUTER JOIN `re_catalog_product_filters_rubric_templates` `catalogProductFiltersRubricTemplates` ON (`catalogProductFiltersRubricTemplates`.`filter_id`=`t`.`id`)
LEFT OUTER JOIN `re_measure_unit` `measureUnit` ON (`catalogProductFiltersRubricTemplates`.`measure_unit_id`=`measureUnit`.`id`) AND (measureUnit.status = '1')
LEFT OUTER JOIN `re_catalog_product_filter_option` `options` ON (`options`.`filter_id`=`t`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter_options_rubric_templates` `catalogProductFilterOptionsRubricTemplates` ON (`catalogProductFilterOptionsRubricTemplates`.`option_id`=`options`.`id`) AND (catalogProductFilterOptionsRubricTemplates.rubric_templates_filters_id = catalogProductFiltersRubricTemplates.id
WHERE ( catalogProductFiltersRubricTemplates.template_id = '10327673' AND t.status = '1' AND catalogProductFiltersRubricTemplates.status = '1' AND catalogProductFiltersRubricTemplates.show_in_rubric = '1') AND (catalogProductFilterOptionsRubricTemplates.show_rubric = '1') OR catalogProductFilterOptionsRubricTemplates.show_rubric IS NULL)
ORDER BY catalogProductFiltersRubricTemplates.sort_order, options.sort_order ASC
1 0.00355 0.00355 0.00355 0.00355

SELECT `t`.`id` AS `t0_c0`, `t`.`status` AS `t0_c1`, `t`.`title` AS `t0_c2`, `t`.`keywords` AS `t0_c3`, `t`.`url` AS `t0_c4`, `t`.`logo_filename` AS `t0_c5`, `t`.`description` AS `t0_c6`
FROM `re_catalog_brand` `t`
LEFT OUTER JOIN `re_catalog_brands_rubrics` `brandsRubrics` ON (`brandsRubrics`.`brand_id`=`t`.`id`)
LEFT OUTER JOIN `re_rubric` `rubricBrand` ON (`brandsRubrics`.`rubric_id`=`rubricBrand`.`id`)
LEFT OUTER JOIN `re_rubric_template` `brandTemplates` ON (`brandTemplates`.`rubric_id`=`rubricBrand`.`id`)
WHERE (t.status = '1' AND brandTemplates.id = 10327673 AND brandsRubrics.status = '1')
GROUP BY t.id
ORDER BY brandsRubrics.sort_order
1 0.00211 0.00211 0.00211 0.00211

SELECT `t`.`id` AS `t0_c0`, `t`.`rubric_id` AS `t0_c1`, `t`.`title` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`sellers_title` AS `t0_c5`, `t`.`show_in_rubricator` AS `t0_c6`, `t`.`show_robots` AS `t0_c7`, `t`.`show_cities` AS `t0_c8`, `t`.`enable_redirect_to_rubric` AS `t0_c9`, `t`.`sort_order` AS `t0_c10`, `t`.`is_main` AS `t0_c11`, `t`.`show_as_catalog_list_tab` AS `t0_c12`, `t`.`catalog_list_tab_color` AS `t0_c13`, `t`.`products_list_default_view_type` AS `t0_c14`, `t`.`show_count_filters` AS `t0_c15`, `t`.`companies_list_view_type` AS `t0_c16`, `t`.`default_sort_products` AS `t0_c17`, `t`.`show_rubric_in_product_title` AS `t0_c18`, `t`.`page_url_prefix` AS `t0_c19`, `t`.`page_logic_type` AS `t0_c20`, `t`.`page_view_type` AS `t0_c21`, `t`.`page_seo_default_template_type` AS `t0_c22`, `t`.`show_city_in_sellers_count` AS `t0_c23`, `t`.`product_alternative_title` AS `t0_c24`, `t`.`product_alternative_title_nominative` AS `t0_c25`, `t`.`product_alternative_title_singular_accusative` AS `t0_c26`, `t`.`product_alternative_title_plural_accusative` AS `t0_c27`, `t`.`image_filename` AS `t0_c28`, `t`.`show_products_without_sellers` AS `t0_c29`, `t`.`noindex_products` AS `t0_c30`, `t`.`show_compact_image` AS `t0_c31`, `rubric`.`id` AS `t1_c0`, `rubric`.`status` AS `t1_c1`, `rubric`.`title` AS `t1_c2`, `rubric`.`singular_title` AS `t1_c3`, `rubric`.`keywords` AS `t1_c4`, `rubric`.`url` AS `t1_c5`, `rubric`.`show_rel_noindex` AS `t1_c6`, `rubric`.`section_redirect` AS `t1_c7`, `rubric`.`sort_order` AS `t1_c8`, `rubric`.`show_in_section_menu` AS `t1_c9`, `rubric`.`show_cities` AS `t1_c10`, `rubric`.`yandex_alias` AS `t1_c11`, `rubric`.`date_modified` AS `t1_c12`, `rubric`.`show_city_in_title` AS `t1_c13`, `rubric`.`logo_filename` AS `t1_c14`, `rubric`.`is_new_rubric` AS `t1_c15`, `rubric`.`is_all_rubric` AS `t1_c16`, `rubric`.`show_map` AS `t1_c17`, `rubric`.`price_unit` AS `t1_c18`, `rubric`.`enable_booking` AS `t1_c19`, `rubric`.`type` AS `t1_c20`, `rubric`.`show_product_availability_status` AS `t1_c21`, `rubric`.`allow_banner_on_catalog` AS `t1_c22`, `sectionsRubrics`.`id` AS `t2_c0`, `sectionsRubrics`.`section_id` AS `t2_c1`, `sectionsRubrics`.`rubric_id` AS `t2_c2`, `sectionsRubrics`.`is_main` AS `t2_c3`, `section`.`id` AS `t3_c0`, `section`.`title` AS `t3_c1`, `section`.`keywords` AS `t3_c2`, `section`.`url` AS `t3_c3`, `section`.`status` AS `t3_c4`, `section`.`has_top_banner` AS `t3_c5`, `section`.`sort_order` AS `t3_c6`, `section`.`singular_title` AS `t3_c7`, `section`.`is_show_page_section` AS `t3_c8`, `seos`.`id` AS `t4_c0`, `seos`.`template_id` AS `t4_c1`, `seos`.`city_id` AS `t4_c2`, `seos`.`h1` AS `t4_c3`, `seos`.`title` AS `t4_c4`, `seos`.`keywords` AS `t4_c5`, `seos`.`description` AS `t4_c6`, `seos`.`top_text` AS `t4_c7`, `seos`.`text` AS `t4_c8`
FROM `re_rubric_template` `t`
LEFT OUTER JOIN `re_rubric` `rubric` ON (`t`.`rubric_id`=`rubric`.`id`)
LEFT OUTER JOIN `re_sections_rubrics` `sectionsRubrics` ON (`sectionsRubrics`.`rubric_id`=`rubric`.`id`)
LEFT OUTER JOIN `re_section` `section` ON (`sectionsRubrics`.`section_id`=`section`.`id`)
LEFT OUTER JOIN `re_rubric_template_seo` `seos` ON (`seos`.`template_id`=`t`.`id`) AND (city_id = '1')
WHERE (rubric.url = 'face' AND rubric.status = '1' AND section.status = '1' AND t.status = '1' AND t.page_url_prefix = 'gds') AND (sectionsRubrics.is_main = '1')
1 0.00090 0.00090 0.00090 0.00090

SELECT `t`.`id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`url` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`image_top` AS `t0_c4`, `t`.`image_bottom` AS `t0_c5`, `t`.`image_background` AS `t0_c6`, `t`.`padding_top` AS `t0_c7`, `t`.`padding_bottom` AS `t0_c8`
FROM `re_branding_background` `t`
LEFT OUTER JOIN `re_branding_background_date` `brandingDates` ON (`brandingDates`.`branding_id`=`t`.`id`)
WHERE (status = '1' AND date_start <= 1487769600 AND date_end >= 1487769600) AND ((section_id = '10251423' OR section_id IS NULL) AND (rubric_id = '10327053' OR rubric_id IS NULL) AND (city_id = '1' OR city_id IS NULL))
ORDER BY section_id DESC, rubric_id DESC, city_id DESC
1 0.00090 0.00090 0.00090 0.00090

SELECT `t`.`id` AS `t0_c0`, `t`.`network_id` AS `t0_c1`, `t`.`place_id` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`is_deleted` AS `t0_c4`, `network`.`id` AS `t1_c0`, `network`.`title` AS `t1_c1`, `network`.`logo_filename` AS `t1_c2`, `network`.`logo2_filename` AS `t1_c3`, `network`.`status` AS `t1_c4`, `network`.`main_place_id` AS `t1_c5`, `network`.`is_deleted` AS `t1_c6`
FROM `re_networks_places` `t`
LEFT OUTER JOIN `re_network` `network` ON (`t`.`network_id`=`network`.`id`)
WHERE (`t`.`place_id`='10461263')
4 0.00086 0.00021 0.00018 0.00024

SELECT `t`.`url` AS `t0_c12`, `t`.`seo_title` AS `t0_c11`, `t`.`id` AS `t0_c0`, `template`.`rubric_id` AS `t5_c1`, `template`.`page_url_prefix` AS `t5_c19`, `template`.`id` AS `t5_c0`
FROM `re_catalog_product_filters_rubric_templates` `t`
LEFT OUTER JOIN `re_catalog_product_filter_options_rubric_templates` `catalogProductFilterOptionsRubricTemplates` ON (`catalogProductFilterOptionsRubricTemplates`.`rubric_templates_filters_id`=`t`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter_option` `option` ON (`catalogProductFilterOptionsRubricTemplates`.`option_id`=`option`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter_option_seo` `catalogProductFilterOptionSeo` ON (`catalogProductFilterOptionSeo`.`option_id`=`option`.`id`) AND (catalogProductFilterOptionSeo.rubric_templates_filters_id = t.id)
LEFT OUTER JOIN `re_catalog_product_filter_rubric_template_seo` `filterSeo` ON (`filterSeo`.`rubric_templates_filters_id`=`t`.`id`)
LEFT OUTER JOIN `re_rubric_template` `template` ON (`t`.`template_id`=`template`.`id`)
WHERE (t.template_id = '10327673' AND t.seo_title != "" AND t.url != "") AND (catalogProductFilterOptionsRubricTemplates.url != "") AND (catalogProductFilterOptionSeo.city_id = '1') AND (filterSeo.city_id = '1')
1 0.00072 0.00072 0.00072 0.00072

SELECT `t`.`id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`url` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`image` AS `t0_c5`, `t`.`image_align` AS `t0_c6`, `t`.`html` AS `t0_c7`, `t`.`noindex` AS `t0_c8`
FROM `re_branding_search` `t`
LEFT OUTER JOIN `re_branding_search_date` `brandingDates` ON (`brandingDates`.`branding_id`=`t`.`id`)
LEFT OUTER JOIN `re_branding_search_template` `brandingTemplates` ON (`brandingTemplates`.`branding_id`=`t`.`id`)
WHERE (status = '1' AND date_start <= 1487769600 AND date_end >= 1487769600) AND ((section_id = '10251423' OR section_id IS NULL) AND (rubric_id = '10327053' OR rubric_id IS NULL) AND (city_id = '1' OR city_id IS NULL)) AND (page_logic_type = 'products_list_default')
ORDER BY section_id DESC, rubric_id DESC, city_id DESC
1 0.00061 0.00061 0.00061 0.00061

SELECT `t`.`id` AS `t0_c0`, `t`.`type` AS `t0_c2`, `t`.`title` AS `t0_c3`
FROM `re_catalog_product_filter` `t`
LEFT OUTER JOIN `re_catalog_product_filters_rubric_templates` `catalogProductFiltersRubricTemplates` ON (`catalogProductFiltersRubricTemplates`.`filter_id`=`t`.`id`)
WHERE (t.status = '1' AND catalogProductFiltersRubricTemplates.template_id = '10327673' AND catalogProductFiltersRubricTemplates.status = '1' AND (t.type = 'brand'))
1 0.00050 0.00050 0.00050 0.00050

SELECT `t`.`id` AS `t0_c0`, `t`.`brand_id` AS `t0_c1`, `t`.`rubric_templates_filters_id` AS `t0_c2`, `t`.`city_id` AS `t0_c3`, `t`.`h1` AS `t0_c4`, `t`.`title` AS `t0_c5`, `t`.`description` AS `t0_c6`, `t`.`keywords` AS `t0_c7`, `t`.`text` AS `t0_c8`, `t`.`title_tape` AS `t0_c9`, `t`.`count_tape` AS `t0_c10`, `t`.`show_in_tape` AS `t0_c11`, `t`.`show_on_product_page` AS `t0_c12`, `t`.`show_in_section` AS `t0_c13`, `t`.`show_in_personal_footer` AS `t0_c14`, `t`.`title_in_personal_footer` AS `t0_c15`
FROM `re_catalog_product_filter_brand_seo` `t`
LEFT OUTER JOIN `re_catalog_product_filters_rubric_templates` `rubricTemplatesFilters` ON (`t`.`rubric_templates_filters_id`=`rubricTemplatesFilters`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter` `filter` ON (`rubricTemplatesFilters`.`filter_id`=`filter`.`id`)
WHERE (t.city_id = '1' AND t.brand_id = '24785') AND (rubricTemplatesFilters.template_id = '10327673') AND (filter.type = 'brand')
1 0.00043 0.00043 0.00043 0.00043

SELECT `t`.`id` AS `t0_c0`, `t`.`network_place_id` AS `t0_c1`, `t`.`city_id` AS `t0_c2`, `t`.`sort_order` AS `t0_c3`, `t`.`is_main` AS `t0_c4`, `networkPlace`.`id` AS `t1_c0`, `networkPlace`.`network_id` AS `t1_c1`, `networkPlace`.`place_id` AS `t1_c2`, `networkPlace`.`title` AS `t1_c3`, `networkPlace`.`is_deleted` AS `t1_c4`, `place`.`id` AS `t2_c0`, `place`.`is_deleted` AS `t2_c1`, `place`.`status` AS `t2_c2`, `place`.`date_created` AS `t2_c3`, `place`.`type` AS `t2_c4`
FROM `re_networks_places_cities` `t`
LEFT OUTER JOIN `re_networks_places` `networkPlace` ON (`t`.`network_place_id`=`networkPlace`.`id`)
LEFT OUTER JOIN `re_place` `place` ON (`networkPlace`.`place_id`=`place`.`id`)
WHERE (t.city_id = '1' AND t.is_main = '1') AND (networkPlace.network_id = '100012965') AND (place.type != 'without_ps')
1 0.00043 0.00043 0.00043 0.00043

SELECT id, title
FROM `re_catalog_brand` `t`
WHERE `t`.`url`='tiande' AND `t`.`status`='1'
LIMIT 1
1 0.00026 0.00026 0.00026 0.00026

SELECT id
FROM `re_catalog_brand` `t`
WHERE `t`.`url`='tiande' AND `t`.`status`='1'
LIMIT 1
1 0.00019 0.00019 0.00019 0.00019