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

Отдых на Кипре от «TravelHouse»

Товара нет в продаже
Страна: Кипр Тур: Пляжный отдых Курорт: Лимассол Месяц: Июнь Количество ночей: 7 Транспорт: Авиа Откуда: Москва Проживание: Tsanotel Размещение: 5* Номер: STD
Все характеристики
Где купить
На данный момент предложения от продавцов по этому товару отсутствуют.
Предлагаем посмотреть другие туры бренда TravelHouse
Характеристики
Страна:
Курорт:
Лимассол
Месяц:
Июнь
Количество ночей:
7
Транспорт:
Авиа
Откуда:
Москва
Проживание:
Tsanotel
Размещение:
5*
Номер:
STD
Питание:
HB (завтрак+ужин)
Визовая поддержка:
Есть
Медицинское страхование:
Есть

Скачать

Реализация товара TravelHouse Отдых на Кипре осуществляется только в стационарном торговом объекте по указанному адресу продавца. Информация о товарах и услугах на портале Relax.by носит справочный характер и не является публичной офертой.

Указанная цена на TravelHouse Отдых на Кипре может отличаться от фактической. Если в описании или цене вы заметили неточность или ошибку, пожалуйста, сообщите нам на почту support@relax.by.
Время: 0.1 с. Память: 6,125Кб, Запросы к БД: 46. Запросы к КЭШу: 123.
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)

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 = '841320' AND (networksPlaces.id IS NULL OR network.status = '1')) AND (t.brand_id = '7443')) 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.02496 0.02496 0.02496 0.02496

SELECT *
FROM `re_redirect` `t`
WHERE (t.from_url = 'http://www.relax.by/sellers/turagentstva/travel-house/otdyh-na-kipre/minsk/' OR t.from_url = 'http://www.relax.by/sellers/turagentstva/travel-house/otdyh-na-kipre/minsk') AND (type = 'for_all')
LIMIT 1
1 0.00576 0.00576 0.00576 0.00576

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 = '1273' AND catalogProductFilterOptionsProducts.product_id = 164683 )
GROUP BY t.id
ORDER BY t.sort_order
8 0.00367 0.00046 0.00036 0.00056

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 = 7353 AND (catalogProductFilterOptionSeo.show_on_product_page = '1' AND catalogProductFilterOptionSeo.city_id = '1' AND catalogProductFilterOptionSeo.rubric_templates_filters_id = rubricTemplatesProductFilters.id) AND (rubricTemplatesProductFilters.template_id = '10326893' AND rubricTemplatesProductFilters.filter_id = option.filter_id) AND (template.status = '1'))
9 0.00315 0.00035 0.00029 0.00045

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 = '2733' AND catalogProductFilterOptionsProducts.product_id = 164683 AND LENGTH(catalogProductFilterOptionsProducts.custom_value) > 0)
GROUP BY t.id
5 0.00252 0.00050 0.00045 0.00060

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 = 'otdyh-na-kipre' AND t.status = '1') AND (productsRubrics.is_main = '1') AND (rubric.url = 'turagentstva' 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 = 'travel-house' AND brand.status = '1') OR t.type = 'product_from_feed_item')
ORDER BY (t.type = 'product_from_feed_item') ASC
1 0.00145 0.00145 0.00145 0.00145

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 = 1333 AND catalogProductFilterOptionsProducts.product_id = 164683 )
GROUP BY t.id
4 0.00127 0.00032 0.00029 0.00034

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 = '841320')
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 = '841320' 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 = '841320') AND (networksPlaces.id IS NULL OR cities.city_id = '1') AND ((info.date_opened <= 1487844000.0) AND (info.state = 'paid')) AND (productsPlaces.product_id = '164683') 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.00119 0.00119 0.00119 0.00119

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 = '841320')
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 = '841320' 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 <= 1487844000.0) AND (info.state = 'paid')) AND (productsPlaces.product_id = '164683')) AND (product.status = '1')
GROUP BY IF (networksPlaces.network_id IS NULL, t.id, networksPlaces.network_id)) sq
1 0.00118 0.00118 0.00118 0.00118

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 = '164683') 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.00085 0.00085 0.00085 0.00085

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 = 164683 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.00074 0.00074 0.00074 0.00074

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 = '164683' 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.00074 0.00074 0.00074 0.00074

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 <= 1487843580 AND date_end >= 1487843580) AND ((section_id = '913304' OR section_id IS NULL) AND (rubric_id = '841320' 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.00067 0.00067 0.00067 0.00067

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 = 1203 AND catalogProductFilterOptionsProducts.product_id = 164683)
GROUP BY t.id
ORDER BY t.sort_order
1 0.00065 0.00065 0.00065 0.00065

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

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 = '164683')
1 0.00036 0.00036 0.00036 0.00036

SELECT *
FROM `re_file` `t`
WHERE (links_count > 0) AND (hash='873eb79ff39d2d6869b8713248814b88')
1 0.00034 0.00034 0.00034 0.00034

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`='164683')
1 0.00033 0.00033 0.00033 0.00033

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`='841320')
1 0.00028 0.00028 0.00028 0.00028

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`='841320')
1 0.00026 0.00026 0.00026 0.00026

SELECT t.value
FROM `re_catalog_product_filter_option_range` `t`
WHERE t.filter_id = 1253 AND t.product_id = 164683
GROUP BY t.id
LIMIT 1
1 0.00026 0.00026 0.00026 0.00026

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 = '164683')
1 0.00026 0.00026 0.00026 0.00026

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

SELECT *
FROM `re_catalog_product_material` `t`
WHERE product_id = '164683'
LIMIT 1
1 0.00019 0.00019 0.00019 0.00019