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

Увлажняющий кондиционер для волос Hidrotex-9 Natural, 200 мл Zimberland в Минске

Товара нет в продаже
Бренд: Zimberland Пол: Унисекс Тип волос: Сухие Назначение: Питание, Восстановление Категория: Кондиционеры Объем: 200 мл Активные компоненты: Aminopropyl Phenyl Trimethicone, Hydrolized keratin, Dimethicone, Argan oil, Caviar extract
Все характеристики
Где купить
На данный момент предложения от продавцов по этому товару отсутствуют.
Предлагаем посмотреть другие товары бренда Zimberland
Характеристики
Бренд:
Zimberland
Пол:
Унисекс
Тип волос:
Сухие
Назначение:
Питание, Восстановление
Категория:
Кондиционеры
Объем:
200 мл
Активные компоненты:
Aminopropyl Phenyl Trimethicone, Hydrolized keratin, Dimethicone, Argan oil, Caviar extract
Описание

Кондиционер для волос, обеспечивает интенсивное увлажнение, придает здоровый блеск волосам. Восстанавливает слабые, сухие и поврежденные волосы, улучшает их качество, облегчает расчесывание.

Реализация товара Zimberland Увлажняющий кондиционер для волос Hidrotex-9 Natural, 200 мл осуществляется только в стационарном торговом объекте по указанному адресу продавца. Информация о товарах и услугах на портале Relax.by носит справочный характер и не является публичной офертой.

Указанная цена на Zimberland Увлажняющий кондиционер для волос Hidrotex-9 Natural, 200 мл может отличаться от фактической. Если в описании или цене вы заметили неточность или ошибку, пожалуйста, сообщите нам на почту support@relax.by.
Время: 1.0 с. Память: 5,830Кб, Запросы к БД: 31. Запросы к КЭШу: 92.
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)

SELECT `t`.`id` AS `t0_c0`, `catalogProductFilterOptionsProducts`.`custom_value` AS `t1_c3`, `catalogProductFilterOptionsProducts`.`id` AS `t1_c0`
FROM `re_catalog_product_filter_option` `t`
LEFT OUTER JOIN `re_catalog_product_filter_options_products` `catalogProductFilterOptionsProducts` ON (`catalogProductFilterOptionsProducts`.`option_id`=`t`.`id`)
WHERE (t.filter_id = '2193' AND catalogProductFilterOptionsProducts.product_id = 86343 AND LENGTH(catalogProductFilterOptionsProducts.custom_value) > 0)
GROUP BY t.id
1 0.03417 0.03417 0.03417 0.03417

SELECT *
FROM `re_redirect` `t`
WHERE (t.from_url = 'http://www.relax.by/sellers/hair/zimberland/uvlazhnyajushhij-kondicioner-hidrotex-9-natural/minsk/' OR t.from_url = 'http://www.relax.by/sellers/hair/zimberland/uvlazhnyajushhij-kondicioner-hidrotex-9-natural/minsk') AND (type = 'for_all')
LIMIT 1
1 0.00737 0.00737 0.00737 0.00737

SELECT `t`.`id` AS `t0_c0`, `t`.`brand_id` AS `t0_c1`, `t`.`title` AS `t0_c2`, `t`.`cleaned_title` AS `t0_c3`, `t`.`status` AS `t0_c4`, `t`.`type` AS `t0_c5`, `t`.`logo_filename` AS `t0_c6`, `t`.`keywords` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`description` AS `t0_c9`, `t`.`date_created` AS `t0_c10`, `t`.`date_modified` AS `t0_c11`, `t`.`two_weeks_views` AS `t0_c12`, `t`.`taken_from` AS `t0_c13`, `t`.`last_editor_id` AS `t0_c14`, `t`.`date_modified_editor` AS `t0_c15`, `t`.`is_deleted` AS `t0_c16`, `productsRubrics`.`id` AS `t1_c0`, `rubric`.`id` AS `t2_c0`, `rubric`.`status` AS `t2_c1`, `rubric`.`title` AS `t2_c2`, `rubric`.`singular_title` AS `t2_c3`, `rubric`.`keywords` AS `t2_c4`, `rubric`.`url` AS `t2_c5`, `rubric`.`show_rel_noindex` AS `t2_c6`, `rubric`.`section_redirect` AS `t2_c7`, `rubric`.`sort_order` AS `t2_c8`, `rubric`.`show_in_section_menu` AS `t2_c9`, `rubric`.`show_cities` AS `t2_c10`, `rubric`.`yandex_alias` AS `t2_c11`, `rubric`.`date_modified` AS `t2_c12`, `rubric`.`show_city_in_title` AS `t2_c13`, `rubric`.`logo_filename` AS `t2_c14`, `rubric`.`is_new_rubric` AS `t2_c15`, `rubric`.`is_all_rubric` AS `t2_c16`, `rubric`.`show_map` AS `t2_c17`, `rubric`.`price_unit` AS `t2_c18`, `rubric`.`enable_booking` AS `t2_c19`, `rubric`.`type` AS `t2_c20`, `rubric`.`show_product_availability_status` AS `t2_c21`, `rubric`.`allow_banner_on_catalog` AS `t2_c22`, `templates`.`id` AS `t3_c0`, `templates`.`rubric_id` AS `t3_c1`, `templates`.`title` AS `t3_c2`, `templates`.`status` AS `t3_c3`, `templates`.`type` AS `t3_c4`, `templates`.`sellers_title` AS `t3_c5`, `templates`.`show_in_rubricator` AS `t3_c6`, `templates`.`show_robots` AS `t3_c7`, `templates`.`show_cities` AS `t3_c8`, `templates`.`enable_redirect_to_rubric` AS `t3_c9`, `templates`.`sort_order` AS `t3_c10`, `templates`.`is_main` AS `t3_c11`, `templates`.`show_as_catalog_list_tab` AS `t3_c12`, `templates`.`catalog_list_tab_color` AS `t3_c13`, `templates`.`products_list_default_view_type` AS `t3_c14`, `templates`.`show_count_filters` AS `t3_c15`, `templates`.`companies_list_view_type` AS `t3_c16`, `templates`.`default_sort_products` AS `t3_c17`, `templates`.`show_rubric_in_product_title` AS `t3_c18`, `templates`.`page_url_prefix` AS `t3_c19`, `templates`.`page_logic_type` AS `t3_c20`, `templates`.`page_view_type` AS `t3_c21`, `templates`.`page_seo_default_template_type` AS `t3_c22`, `templates`.`show_city_in_sellers_count` AS `t3_c23`, `templates`.`product_alternative_title` AS `t3_c24`, `templates`.`product_alternative_title_nominative` AS `t3_c25`, `templates`.`product_alternative_title_singular_accusative` AS `t3_c26`, `templates`.`product_alternative_title_plural_accusative` AS `t3_c27`, `templates`.`image_filename` AS `t3_c28`, `templates`.`show_products_without_sellers` AS `t3_c29`, `templates`.`noindex_products` AS `t3_c30`, `templates`.`show_compact_image` AS `t3_c31`, `sectionsRubrics`.`id` AS `t4_c0`, `section`.`id` AS `t5_c0`, `section`.`title` AS `t5_c1`, `section`.`keywords` AS `t5_c2`, `section`.`url` AS `t5_c3`, `section`.`status` AS `t5_c4`, `section`.`has_top_banner` AS `t5_c5`, `section`.`sort_order` AS `t5_c6`, `section`.`singular_title` AS `t5_c7`, `section`.`is_show_page_section` AS `t5_c8`, `brand`.`id` AS `t6_c0`, `brand`.`status` AS `t6_c1`, `brand`.`title` AS `t6_c2`, `brand`.`keywords` AS `t6_c3`, `brand`.`url` AS `t6_c4`, `brand`.`logo_filename` AS `t6_c5`, `brand`.`description` AS `t6_c6`
FROM `re_catalog_product` `t`
LEFT OUTER JOIN `re_catalog_products_rubrics` `productsRubrics` ON (`productsRubrics`.`product_id`=`t`.`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_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_catalog_brand` `brand` ON (`t`.`brand_id`=`brand`.`id`)
LEFT OUTER JOIN `re_catalog_product_photo` `photos` ON (`photos`.`product_id`=`t`.`id`)
WHERE (t.url = 'uvlazhnyajushhij-kondicioner-hidrotex-9-natural' AND t.status = '1') AND (productsRubrics.is_main = '1') AND (rubric.url = 'hair' AND rubric.status = '1') AND (templates.page_logic_type = 'products_list_default' AND templates.status = '1') AND (sectionsRubrics.is_main = '1') AND (section.status = '1') AND ((brand.url = 'zimberland' AND brand.status = '1') OR t.type = 'product_from_feed_item')
ORDER BY (t.type = 'product_from_feed_item') ASC
1 0.00291 0.00291 0.00291 0.00291

SELECT `t`.`id` AS `t0_c0`, `t`.`value` AS `t0_c2`
FROM `re_catalog_product_filter_option` `t`
LEFT OUTER JOIN `re_catalog_product_filter_options_products` `catalogProductFilterOptionsProducts` ON (`catalogProductFilterOptionsProducts`.`option_id`=`t`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter_options_rubric_templates` `catalogProductFilterOptionsRubricTemplates` ON (`catalogProductFilterOptionsRubricTemplates`.`option_id`=`t`.`id`)
WHERE (t.filter_id = '3695' AND catalogProductFilterOptionsProducts.product_id = 86343 )
GROUP BY t.id
ORDER BY t.sort_order
3 0.00198 0.00066 0.00041 0.00116

SELECT COUNT(*) FROM (
SELECT `t`.`id` AS `t0_c0`, `placesRubrics`.`id` AS `t1_c0`, `placesRubrics`.`rubric_id` AS `t1_c3`, `placesRubrics`.`sales_description` AS `t1_c5`, `placesRubrics`.`short_description` AS `t1_c6`, `placesRubrics`.`personal_place_page_id` AS `t1_c4`, `sort`.`id` AS `t2_c0`, `sort`.`places_rubrics_id` AS `t2_c1`, `sort`.`city_id` AS `t2_c2`, `sort`.`sort_order` AS `t2_c3`, `sort`.`date_added` AS `t2_c4`, `sort`.`comment` AS `t2_c5`, `sort`.`place_view_id` AS `t2_c6`, `sort`.`rotation` AS `t2_c7`, `sort`.`has_first_block_products` AS `t2_c8`, `placeView`.`type` AS `t3_c1`, `placeView`.`id` AS `t3_c0`, `placesCities`.`city_id` AS `t4_c2`, `placesCities`.`id` AS `t4_c0`, `networksPlaces`.`network_id` AS `t5_c1`, `networksPlaces`.`id` AS `t5_c0`, `network`.`status` AS `t6_c4`, `network`.`logo_filename` AS `t6_c2`, `network`.`id` AS `t6_c0`, `cities`.`city_id` AS `t7_c2`, `cities`.`id` AS `t7_c0`, `placeLogos`.`logo_filename` AS `t8_c4`, `placeLogos`.`description` AS `t8_c6`, `placeLogos`.`id` AS `t8_c0`, `info`.`state` AS `t9_c2`, `info`.`catalog_filename` AS `t9_c14`, `info`.`id` AS `t9_c0`
FROM `re_place` `t`
LEFT OUTER JOIN `re_places_rubrics` `placesRubrics` ON (`placesRubrics`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_places_rubrics_sort` `sort` ON (`sort`.`places_rubrics_id`=`placesRubrics`.`id`)
LEFT OUTER JOIN `re_place_view` `placeView` ON (`sort`.`place_view_id`=`placeView`.`id`)
LEFT OUTER JOIN `re_places_cities` `placesCities` ON (`placesCities`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_networks_places` `networksPlaces` ON (`networksPlaces`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_network` `network` ON (`networksPlaces`.`network_id`=`network`.`id`)
LEFT OUTER JOIN `re_networks_places_cities` `cities` ON (`cities`.`network_place_id`=`networksPlaces`.`id`)
LEFT OUTER JOIN `re_place_logo` `placeLogos` ON (`placeLogos`.`place_id`=`t`.`id`) AND (placeLogos.place_view_id = placeView.id AND placeLogos.rubric_id = '10327073')
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`t`.`id`)
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_brand` `brand` ON (`product`.`brand_id`=`brand`.`id`
WHERE ((t.is_deleted = '0' AND placesRubrics.rubric_id = '10327073' AND t.status = '1' AND info.state != 'close' AND t.type = 'default' AND placesCities.city_id = '1' AND sort.city_id = '1' AND ( networksPlaces.id IS NULL OR ( network.status = '1' /* AND cities.is_main = '1'*/ ) ) AND IF (cities.city_id = '1', cities.is_main = '1', 1)) AND ((brand.status = '1' OR product.type = 'product_from_feed_item') AND networksPlaces.id IS NULL OR (network.status = '1' AND cities.is_main = '1'))) AND (networksPlaces.id IS NULL OR cities.city_id = '1') AND ((info.date_opened <= 1487843000.0) AND (info.state = 'paid')) AND (productsPlaces.product_id = '86343')) AND (product.status = '1')
GROUP BY IF (networksPlaces.network_id IS NULL, t.id, networksPlaces.network_id)) sq
1 0.00160 0.00160 0.00160 0.00160

SELECT `t`.`url` AS `t0_c4`, `t`.`id` AS `t0_c0`, `rubricTemplatesProductFilters`.`id` AS `t3_c0`, `template`.`rubric_id` AS `t4_c1`, `template`.`page_url_prefix` AS `t4_c19`, `template`.`id` AS `t4_c0`
FROM `re_catalog_product_filter_options_rubric_templates` `t`
LEFT OUTER JOIN `re_catalog_product_filter_option` `option` ON (`t`.`option_id`=`option`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter_option_seo` `catalogProductFilterOptionSeo` ON (`catalogProductFilterOptionSeo`.`option_id`=`option`.`id`)
LEFT OUTER JOIN `re_catalog_product_filters_rubric_templates` `rubricTemplatesProductFilters` ON (`t`.`rubric_templates_filters_id`=`rubricTemplatesProductFilters`.`id`)
LEFT OUTER JOIN `re_rubric_template` `template` ON (`rubricTemplatesProductFilters`.`template_id`=`template`.`id`)
WHERE (t.url != "") AND (option.id = 194 AND (catalogProductFilterOptionSeo.show_on_product_page = '1' AND catalogProductFilterOptionSeo.city_id = '1' AND catalogProductFilterOptionSeo.rubric_templates_filters_id = rubricTemplatesProductFilters.id) AND (rubricTemplatesProductFilters.template_id = '10327713' AND rubricTemplatesProductFilters.filter_id = option.filter_id) AND (template.status = '1'))
3 0.00128 0.00043 0.00040 0.00045

SELECT `t`.`id` AS `t0_c0`, `brand`.`title` AS `t8_c2`, `brand`.`url` AS `t8_c4`, `brand`.`id` AS `t8_c0`
FROM `re_catalog_product` `t`
LEFT OUTER JOIN `re_catalog_products_places` `productsPlaces` ON (`productsPlaces`.`product_id`=`t`.`id`)
LEFT OUTER JOIN `re_place` `place` ON (`productsPlaces`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_networks_places` `networksPlaces` ON (`networksPlaces`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_network` `network` ON (`networksPlaces`.`network_id`=`network`.`id`)
LEFT OUTER JOIN `re_networks_places_cities` `cities` ON (`cities`.`network_place_id`=`networksPlaces`.`id`)
INNER JOIN `re_places_cities` `placesCities` ON (`placesCities`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_catalog_brand` `brand` ON (`t`.`brand_id`=`brand`.`id`)
LEFT OUTER JOIN `re_catalog_products_rubrics` `productsRubrics` ON (`productsRubrics`.`product_id`=`t`.`id`)
WHERE ((t.type != 'product_from_feed_item' AND brand.status = '1' AND t.status = '1' AND info.state = 'paid' AND place.status = '1' AND placesCities.city_id = '1' AND productsRubrics.rubric_id = '10327073' AND (networksPlaces.id IS NULL OR network.status = '1')) AND (t.brand_id = '5783')) AND (place.status = '1' AND place.is_deleted = '0') AND (networksPlaces.id IS NULL OR (network.status = '1' AND cities.is_main = '1'))
GROUP BY t.id
1 0.00124 0.00124 0.00124 0.00124

SELECT `t`.`id` AS `t0_c0`, `placesRubrics`.`id` AS `t1_c0`, `placesRubrics`.`rubric_id` AS `t1_c3`, `placesRubrics`.`sales_description` AS `t1_c5`, `placesRubrics`.`short_description` AS `t1_c6`, `placesRubrics`.`personal_place_page_id` AS `t1_c4`, `sort`.`id` AS `t2_c0`, `sort`.`places_rubrics_id` AS `t2_c1`, `sort`.`city_id` AS `t2_c2`, `sort`.`sort_order` AS `t2_c3`, `sort`.`date_added` AS `t2_c4`, `sort`.`comment` AS `t2_c5`, `sort`.`place_view_id` AS `t2_c6`, `sort`.`rotation` AS `t2_c7`, `sort`.`has_first_block_products` AS `t2_c8`, `placeView`.`type` AS `t3_c1`, `placeView`.`id` AS `t3_c0`, `placesCities`.`city_id` AS `t4_c2`, `placesCities`.`id` AS `t4_c0`, `networksPlaces`.`network_id` AS `t5_c1`, `networksPlaces`.`id` AS `t5_c0`, `network`.`status` AS `t6_c4`, `network`.`logo_filename` AS `t6_c2`, `network`.`id` AS `t6_c0`, `cities`.`city_id` AS `t7_c2`, `cities`.`id` AS `t7_c0`, `placeLogos`.`logo_filename` AS `t8_c4`, `placeLogos`.`description` AS `t8_c6`, `placeLogos`.`id` AS `t8_c0`, `info`.`state` AS `t9_c2`, `info`.`catalog_filename` AS `t9_c14`, `info`.`id` AS `t9_c0`, `productsPlaces`.`value` AS `t10_c6`, `productsPlaces`.`value_opt` AS `t10_c7`, `productsPlaces`.`id` AS `t10_c0`, `placeCurrencyRates`.`id` AS `t13_c0`, `placeCurrencyRates`.`place_id` AS `t13_c1`, `placeCurrencyRates`.`from_currency_id` AS `t13_c2`, `placeCurrencyRates`.`to_currency_id` AS `t13_c3`, `placeCurrencyRates`.`value` AS `t13_c4`
FROM `re_place` `t`
LEFT OUTER JOIN `re_places_rubrics` `placesRubrics` ON (`placesRubrics`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_places_rubrics_sort` `sort` ON (`sort`.`places_rubrics_id`=`placesRubrics`.`id`)
LEFT OUTER JOIN `re_place_view` `placeView` ON (`sort`.`place_view_id`=`placeView`.`id`)
LEFT OUTER JOIN `re_places_cities` `placesCities` ON (`placesCities`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_networks_places` `networksPlaces` ON (`networksPlaces`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_network` `network` ON (`networksPlaces`.`network_id`=`network`.`id`)
LEFT OUTER JOIN `re_networks_places_cities` `cities` ON (`cities`.`network_place_id`=`networksPlaces`.`id`)
LEFT OUTER JOIN `re_place_logo` `placeLogos` ON (`placeLogos`.`place_id`=`t`.`id`) AND (placeLogos.place_view_id = placeView.id AND placeLogos.rubric_id = '10327073')
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`t`.`id`)
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_brand` `brand` ON (`product`.`brand_id`=`brand`.`id`)
LEFT OUTER JOIN `re_place_currency_rate` `placeCurrencyRates` ON (`placeCurrencyRates`.`place_id`=`t`.`id`
WHERE ((t.is_deleted = '0' AND placesRubrics.rubric_id = '10327073' AND t.status = '1' AND info.state != 'close' AND t.type = 'default' AND placesCities.city_id = '1' AND sort.city_id = '1' AND ( networksPlaces.id IS NULL OR ( network.status = '1' /* AND cities.is_main = '1'*/ ) ) AND IF (cities.city_id = '1', cities.is_main = '1', 1)) AND ((brand.status = '1' OR product.type = 'product_from_feed_item') AND networksPlaces.id IS NULL OR (network.status = '1' AND cities.is_main = '1'))) AND (placesRubrics.rubric_id = '10327073') AND (networksPlaces.id IS NULL OR cities.city_id = '1') AND ((info.date_opened <= 1487843000.0) AND (info.state = 'paid')) AND (productsPlaces.product_id = '86343') AND (product.status = '1') AND (placeCurrencyRates.from_currency_id = productsPlaces.currency_id AND placeCurrencyRates.to_currency_id = 4))
GROUP BY IF (networksPlaces.network_id IS NULL, t.id, networksPlaces.network_id)
ORDER BY sort.sort_order IS NULL, sort.sort_order, sort.sort_order IS NULL, sort.sort_order, info.title
LIMIT 25
1 0.00124 0.00124 0.00124 0.00124

SELECT `t`.`id` AS `t0_c0`, `t`.`value` AS `t0_c2`
FROM `re_catalog_product_filter_option` `t`
LEFT OUTER JOIN `re_catalog_product_filter_options_products` `catalogProductFilterOptionsProducts` ON (`catalogProductFilterOptionsProducts`.`option_id`=`t`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter_options_rubric_templates` `catalogProductFilterOptionsRubricTemplates` ON (`catalogProductFilterOptionsRubricTemplates`.`option_id`=`t`.`id`)
WHERE (t.filter_id = 46 AND catalogProductFilterOptionsProducts.product_id = 86343)
GROUP BY t.id
ORDER BY t.sort_order
2 0.00098 0.00049 0.00043 0.00055

SELECT `t`.`id` AS `t0_c0`, `t`.`title` AS `t0_c1`, `t`.`prepositional_title` AS `t0_c2`, `t`.`transcription` AS `t0_c3`, `t`.`country_id` AS `t0_c4`, `t`.`phone_code` AS `t0_c5`, `t`.`status` AS `t0_c6`, `t`.`status_mobile` AS `t0_c7`, `t`.`sort_order` AS `t0_c8`, `t`.`latitude` AS `t0_c9`, `t`.`longitude` AS `t0_c10`, `t`.`type` AS `t0_c11`, `t`.`is_regional` AS `t0_c12`, `t`.`zoom` AS `t0_c13`, `t`.`show_in_select` AS `t0_c14`, `placesCities`.`city_id` AS `t1_c2`, `placesCities`.`id` AS `t1_c0`, `place`.`id` AS `t2_c0`, `productsPlaces`.`id` AS `t7_c0`, `product`.`id` AS `t8_c0`
FROM `re_city` `t`
LEFT OUTER JOIN `re_places_cities` `placesCities` ON (`placesCities`.`city_id`=`t`.`id`)
LEFT OUTER JOIN `re_place` `place` ON (`placesCities`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_networks_places` `networksPlaces` ON (`networksPlaces`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_network` `network` ON (`networksPlaces`.`network_id`=`network`.`id`)
LEFT OUTER JOIN `re_networks_places_cities` `cities` ON (`cities`.`network_place_id`=`networksPlaces`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_catalog_products_places` `productsPlaces` ON (`productsPlaces`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_catalog_product` `product` ON (`productsPlaces`.`product_id`=`product`.`id`)
LEFT OUTER JOIN `re_catalog_brand` `brand` ON (`product`.`brand_id`=`brand`.`id`)
LEFT OUTER JOIN `re_catalog_products_rubrics` `productsRubrics` ON (`productsRubrics`.`product_id`=`product`.`id`)
LEFT OUTER JOIN `re_places_rubrics` `placesRubrics` ON (`placesRubrics`.`place_id`=`place`.`id`)
WHERE ((network.id IS NULL OR network.status = '1') AND (t.status = '1')) AND (place.status = '1' AND place.is_deleted = '0') AND (networksPlaces.id IS NULL OR (cities.city_id = t.id AND cities.is_main = '1')) AND (info.state = 'paid') AND (productsPlaces.product_id = '86343') AND (product.status = '1') AND (brand.status = '1') AND (productsRubrics.is_main = '1') AND (placesRubrics.rubric_id = productsRubrics.rubric_id)
ORDER BY t.sort_order
1 0.00092 0.00092 0.00092 0.00092

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 <= 1487843220 AND date_end >= 1487843220) AND ((section_id = '10251423' OR section_id IS NULL) AND (rubric_id = '10327073' 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.00091 0.00091 0.00091 0.00091

SELECT COUNT(*) FROM (
SELECT `t`.`id` AS `t0_c0`
FROM `re_catalog_products_places` `t`
LEFT OUTER JOIN `re_place` `place` ON (`t`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_networks_places` `networksPlaces` ON (`networksPlaces`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_network` `network` ON (`networksPlaces`.`network_id`=`network`.`id`)
LEFT OUTER JOIN `re_networks_places_cities` `cities` ON (`cities`.`network_place_id`=`networksPlaces`.`id`)
INNER JOIN `re_places_cities` `placesCities` ON (`placesCities`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_places_rubrics` `placesRubrics` ON (`placesRubrics`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_catalog_product` `product` ON (`t`.`product_id`=`product`.`id`)
LEFT OUTER JOIN `re_catalog_products_rubrics` `productsRubrics` ON (`productsRubrics`.`product_id`=`product`.`id`)
WHERE (t.product_id = 86343 AND (networksPlaces.id IS NULL OR network.status = '1')) AND (place.status = '1' AND place.is_deleted = '0') AND (info.state = 'paid') AND (networksPlaces.id IS NULL OR (network.status = '1' AND cities.is_main = '1')) AND (placesCities.city_id = '1') AND (placesRubrics.rubric_id = productsRubrics.rubric_id)
GROUP BY IF (networksPlaces.network_id IS NULL, t.place_id, networksPlaces.network_id)) sq
1 0.00085 0.00085 0.00085 0.00085

SELECT `t`.`place_id` AS `t0_c2`, `t`.`value` AS `t0_c6`, `t`.`value_opt` AS `t0_c7`, `t`.`is_from_label_value` AS `t0_c10`, `t`.`is_from_label_value_opt` AS `t0_c11`, `t`.`currency_id` AS `t0_c8`, `t`.`id` AS `t0_c0`, `place`.`id` AS `t1_c0`, `placesCities`.`city_id` AS `t3_c2`, `placesCities`.`id` AS `t3_c0`, `networksPlaces`.`network_id` AS `t4_c1`, `networksPlaces`.`id` AS `t4_c0`, `network`.`status` AS `t5_c4`, `network`.`logo_filename` AS `t5_c2`, `network`.`id` AS `t5_c0`, `cities`.`city_id` AS `t6_c2`, `cities`.`id` AS `t6_c0`
FROM `re_catalog_products_places` `t`
LEFT OUTER JOIN `re_place` `place` ON (`t`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`place`.`id`)
INNER JOIN `re_places_cities` `placesCities` ON (`placesCities`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_networks_places` `networksPlaces` ON (`networksPlaces`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_network` `network` ON (`networksPlaces`.`network_id`=`network`.`id`)
LEFT OUTER JOIN `re_networks_places_cities` `cities` ON (`cities`.`network_place_id`=`networksPlaces`.`id`)
LEFT OUTER JOIN `re_places_rubrics` `placesRubrics` ON (`placesRubrics`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_catalog_product` `product` ON (`t`.`product_id`=`product`.`id`)
LEFT OUTER JOIN `re_catalog_products_rubrics` `productsRubrics` ON (`productsRubrics`.`product_id`=`product`.`id`
WHERE (t.product_id = '86343' AND place.status = '1' AND info.state = 'paid') AND ( networksPlaces.id IS NULL OR ( network.status = '1' AND cities.is_main = '1' ) )) AND (productsRubrics.rubric_id = placesRubrics.rubric_id)
1 0.00075 0.00075 0.00075 0.00075

SELECT `t`.`id` AS `t0_c0`, `t`.`status` AS `t0_c1`, `t`.`title` AS `t0_c2`, `t`.`singular_title` AS `t0_c3`, `t`.`keywords` AS `t0_c4`, `t`.`url` AS `t0_c5`, `t`.`show_rel_noindex` AS `t0_c6`, `t`.`section_redirect` AS `t0_c7`, `t`.`sort_order` AS `t0_c8`, `t`.`show_in_section_menu` AS `t0_c9`, `t`.`show_cities` AS `t0_c10`, `t`.`yandex_alias` AS `t0_c11`, `t`.`date_modified` AS `t0_c12`, `t`.`show_city_in_title` AS `t0_c13`, `t`.`logo_filename` AS `t0_c14`, `t`.`is_new_rubric` AS `t0_c15`, `t`.`is_all_rubric` AS `t0_c16`, `t`.`show_map` AS `t0_c17`, `t`.`price_unit` AS `t0_c18`, `t`.`enable_booking` AS `t0_c19`, `t`.`type` AS `t0_c20`, `t`.`show_product_availability_status` AS `t0_c21`, `t`.`allow_banner_on_catalog` AS `t0_c22`
FROM `re_rubric` `t`
LEFT OUTER JOIN `re_catalog_products_rubrics` `productsRubrics` ON (`productsRubrics`.`rubric_id`=`t`.`id`)
WHERE (productsRubrics.is_main = '1' AND productsRubrics.product_id = '86343')
1 0.00051 0.00051 0.00051 0.00051

SELECT *
FROM `re_catalog_product_photo` `t`
WHERE `t`.`product_id`='86343' AND `t`.`status`='1' AND `t`.`is_deleted`='0'
ORDER BY sort_order
1 0.00046 0.00046 0.00046 0.00046

SELECT `t`.`id` AS `t0_c0`, `filtersTemplates`.`id` AS `t1_c0`, `catalogProductFilterBrandSeo`.`id` AS `t2_c0`, `catalogProductFilterBrandSeo`.`show_on_product_page` AS `t2_c12`, `brand`.`url` AS `t3_c4`, `brand`.`id` AS `t3_c0`, `rubric`.`url` AS `t4_c5`, `rubric`.`id` AS `t4_c0`
FROM `re_rubric_template` `t`
LEFT OUTER JOIN `re_catalog_product_filters_rubric_templates` `filtersTemplates` ON (`filtersTemplates`.`template_id`=`t`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter_brand_seo` `catalogProductFilterBrandSeo` ON (`catalogProductFilterBrandSeo`.`rubric_templates_filters_id`=`filtersTemplates`.`id`)
LEFT OUTER JOIN `re_catalog_brand` `brand` ON (`catalogProductFilterBrandSeo`.`brand_id`=`brand`.`id`)
LEFT OUTER JOIN `re_rubric` `rubric` ON (`t`.`rubric_id`=`rubric`.`id`)
WHERE (`t`.`id`=10327713) AND (catalogProductFilterBrandSeo.brand_id = 5783 AND catalogProductFilterBrandSeo.city_id = '1')
1 0.00040 0.00040 0.00040 0.00040

SELECT t.value
FROM `re_catalog_product_filter_option_range` `t`
WHERE t.filter_id = 183 AND t.product_id = 86343
GROUP BY t.id
LIMIT 1
1 0.00028 0.00028 0.00028 0.00028

SELECT `t`.`singular_title` AS `t0_c3`, `t`.`id` AS `t0_c0`
FROM `re_rubric` `t`
LEFT OUTER JOIN `re_catalog_products_rubrics` `productsRubrics` ON (`productsRubrics`.`rubric_id`=`t`.`id`)
WHERE (t.singular_title != "") AND (productsRubrics.is_main = '1' AND productsRubrics.product_id = '86343')
1 0.00026 0.00026 0.00026 0.00026

SELECT `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`
FROM `re_rubric` `rubric`
WHERE (`rubric`.`id`='10327073')
1 0.00025 0.00025 0.00025 0.00025

SELECT *
FROM `re_product_page_seo` `t`
WHERE `t`.`product_id`='86343' AND `t`.`page_type`='sellers'
LIMIT 1
1 0.00024 0.00024 0.00024 0.00024

SELECT `t`.`id` AS `t0_c0`, `t`.`title` AS `t0_c2`
FROM `re_catalog_brand` `t`
LEFT OUTER JOIN `re_catalog_product` `products` ON (`products`.`brand_id`=`t`.`id`)
WHERE (products.id = '86343')
1 0.00024 0.00024 0.00024 0.00024

SELECT `sectionsRubrics`.`id` AS `t1_c0`, `sectionsRubrics`.`section_id` AS `t1_c1`, `sectionsRubrics`.`rubric_id` AS `t1_c2`, `sectionsRubrics`.`is_main` AS `t1_c3`
FROM `re_sections_rubrics` `sectionsRubrics`
WHERE (`sectionsRubrics`.`rubric_id`='10327073')
1 0.00023 0.00023 0.00023 0.00023

SELECT `files`.`id` AS `t1_c0`, `files`.`product_id` AS `t1_c1`, `files`.`file_hash` AS `t1_c2`
FROM `re_catalog_product_file` `files`
WHERE (`files`.`product_id`='86343')
1 0.00023 0.00023 0.00023 0.00023

SELECT *
FROM `re_catalog_product_material` `t`
WHERE product_id = '86343'
LIMIT 1
1 0.00021 0.00021 0.00021 0.00021

SELECT `t`.`url` AS `t0_c5`, `t`.`id` AS `t0_c0`
FROM `re_rubric` `t`
LEFT OUTER JOIN `re_rubric_template` `templates` ON (`templates`.`rubric_id`=`t`.`id`)
WHERE (templates.id = '10327713')
1 0.00018 0.00018 0.00018 0.00018

SELECT url
FROM `re_catalog_brand` `t`
WHERE `t`.`id`=5783
LIMIT 1
1 0.00014 0.00014 0.00014 0.00014