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
Время: 0.4 с. Память: 7,095Кб, Запросы к БД: 65. Запросы к КЭШу: 154.
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)

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`, `info`.`id` AS `t3_c0`, `info`.`place_id` AS `t3_c1`, `info`.`state` AS `t3_c2`, `info`.`title` AS `t3_c3`, `info`.`short_title` AS `t3_c4`, `info`.`short_description` AS `t3_c5`, `info`.`alternative_titles` AS `t3_c6`, `info`.`juridical_title` AS `t3_c7`, `info`.`unp` AS `t3_c8`, `info`.`transcription` AS `t3_c9`, `info`.`url` AS `t3_c10`, `info`.`site` AS `t3_c11`, `info`.`displayed_url` AS `t3_c12`, `info`.`logo_filename` AS `t3_c13`, `info`.`catalog_filename` AS `t3_c14`, `info`.`catalog_round_logo_filename` AS `t3_c15`, `info`.`catalog_logo_filename` AS `t3_c16`, `info`.`text_type` AS `t3_c17`, `info`.`close_message` AS `t3_c18`, `info`.`about` AS `t3_c19`, `info`.`date_opened` AS `t3_c20`, `info`.`date_modified` AS `t3_c21`, `info`.`date_paid_started` AS `t3_c22`, `info`.`show_filters_personal_count` AS `t3_c23`, `info`.`is_enable_comments` AS `t3_c24`, `info`.`as_advertising` AS `t3_c25`, `info`.`use_default_rate` AS `t3_c26`, `info`.`hide_right_column` AS `t3_c27`, `info`.`site_in_nofollow` AS `t3_c28`, `info`.`show_button_in_store` AS `t3_c29`, `info`.`last_editor_id` AS `t3_c30`, `info`.`review_conditions` AS `t3_c31`, `info`.`one_c_id` AS `t3_c32`, `info`.`juridical_address` AS `t3_c33`, `info`.`registration_authority` AS `t3_c34`, `info`.`registration_date` AS `t3_c35`, `info`.`registry_type` AS `t3_c36`, `info`.`registration_date_in_registry` AS `t3_c37`, `info`.`number_in_registry` AS `t3_c38`, `info`.`licence_number` AS `t3_c39`, `info`.`shop_name` AS `t3_c40`, `info`.`shop_address` AS `t3_c41`, `sort`.`city_id` AS `t6_c2`, `sort`.`id` AS `t6_c0`, `networksPlaces`.`id` AS `t7_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_place_info` `info` ON (`info`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_places_rubrics` `placesRubrics` ON (`placesRubrics`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_rubric` `rubric` ON (`placesRubrics`.`rubric_id`=`rubric`.`id`)
LEFT OUTER JOIN `re_places_rubrics_sort` `sort` ON (`sort`.`places_rubrics_id`=`placesRubrics`.`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`
WHERE (t.status = '1' AND ( networksPlaces.id IS NULL OR ( network.status = '1' AND cities.is_main = '1' ) )) AND (place.status = '1' AND place.is_deleted = '0') AND (info.state != 'close') AND (placesRubrics.rubric_id = '10327413')) AND (rubric.status = '1')
GROUP BY t.id
ORDER BY IF (t.is_regional = '1', t.sort_order, t.title)
1 0.06054 0.06054 0.06054 0.06054

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 = 10328683 AND templates.id = 10328683 AND product.status = '1') AND (info.state = 'paid')
GROUP BY t.id
ORDER BY info.title ASC
1 0.01799 0.01799 0.01799 0.01799

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

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`)
WHERE (productsRubricsSort.rubric_id = '10327413' AND productsRubricsSort.city_id = '1' AND t.status = '1')
1 0.00278 0.00278 0.00278 0.00278

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 = '10328683' 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.00194 0.00194 0.00194 0.00194

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`, `infoline`.`id` AS `t1_c0`, `infoline`.`place_id` AS `t1_c1`, `infoline`.`description` AS `t1_c2`, `info`.`id` AS `t2_c0`, `info`.`place_id` AS `t2_c1`, `info`.`state` AS `t2_c2`, `info`.`title` AS `t2_c3`, `info`.`short_title` AS `t2_c4`, `info`.`short_description` AS `t2_c5`, `info`.`alternative_titles` AS `t2_c6`, `info`.`juridical_title` AS `t2_c7`, `info`.`unp` AS `t2_c8`, `info`.`transcription` AS `t2_c9`, `info`.`url` AS `t2_c10`, `info`.`site` AS `t2_c11`, `info`.`displayed_url` AS `t2_c12`, `info`.`logo_filename` AS `t2_c13`, `info`.`catalog_filename` AS `t2_c14`, `info`.`catalog_round_logo_filename` AS `t2_c15`, `info`.`catalog_logo_filename` AS `t2_c16`, `info`.`text_type` AS `t2_c17`, `info`.`close_message` AS `t2_c18`, `info`.`about` AS `t2_c19`, `info`.`date_opened` AS `t2_c20`, `info`.`date_modified` AS `t2_c21`, `info`.`date_paid_started` AS `t2_c22`, `info`.`show_filters_personal_count` AS `t2_c23`, `info`.`is_enable_comments` AS `t2_c24`, `info`.`as_advertising` AS `t2_c25`, `info`.`use_default_rate` AS `t2_c26`, `info`.`hide_right_column` AS `t2_c27`, `info`.`site_in_nofollow` AS `t2_c28`, `info`.`show_button_in_store` AS `t2_c29`, `info`.`last_editor_id` AS `t2_c30`, `info`.`review_conditions` AS `t2_c31`, `info`.`one_c_id` AS `t2_c32`, `info`.`juridical_address` AS `t2_c33`, `info`.`registration_authority` AS `t2_c34`, `info`.`registration_date` AS `t2_c35`, `info`.`registry_type` AS `t2_c36`, `info`.`registration_date_in_registry` AS `t2_c37`, `info`.`number_in_registry` AS `t2_c38`, `info`.`licence_number` AS `t2_c39`, `info`.`shop_name` AS `t2_c40`, `info`.`shop_address` AS `t2_c41`, `networksPlaces`.`network_id` AS `t3_c1`, `networksPlaces`.`id` AS `t3_c0`, `network`.`status` AS `t4_c4`, `network`.`logo_filename` AS `t4_c2`, `network`.`title` AS `t4_c1`, `network`.`main_place_id` AS `t4_c5`, `network`.`id` AS `t4_c0`
FROM `re_place` `t`
LEFT OUTER JOIN `re_place_infoline` `infoline` ON (`infoline`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`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`)
WHERE (`t`.`id`=10459963)
3 0.00185 0.00062 0.00058 0.00068

SELECT `t`.`id` AS `t0_c0`, `t`.`rubric_id` AS `t0_c1`, `t`.`city_id` AS `t0_c2`, `t`.`title` AS `t0_c3`, `items`.`id` AS `t1_c0`, `items`.`rubricator_id` AS `t1_c1`, `items`.`parent_id` AS `t1_c2`, `items`.`status` AS `t1_c3`, `items`.`type` AS `t1_c4`, `items`.`title` AS `t1_c5`, `items`.`template_id` AS `t1_c6`, `items`.`sort_order` AS `t1_c7`, `childrenItems`.`id` AS `t2_c0`, `childrenItems`.`rubricator_id` AS `t2_c1`, `childrenItems`.`parent_id` AS `t2_c2`, `childrenItems`.`status` AS `t2_c3`, `childrenItems`.`type` AS `t2_c4`, `childrenItems`.`title` AS `t2_c5`, `childrenItems`.`template_id` AS `t2_c6`, `childrenItems`.`sort_order` AS `t2_c7`, `childTemplate`.`id` AS `t3_c0`, `childTemplate`.`rubric_id` AS `t3_c1`, `childTemplate`.`title` AS `t3_c2`, `childTemplate`.`status` AS `t3_c3`, `childTemplate`.`type` AS `t3_c4`, `childTemplate`.`sellers_title` AS `t3_c5`, `childTemplate`.`show_in_rubricator` AS `t3_c6`, `childTemplate`.`show_robots` AS `t3_c7`, `childTemplate`.`show_cities` AS `t3_c8`, `childTemplate`.`enable_redirect_to_rubric` AS `t3_c9`, `childTemplate`.`sort_order` AS `t3_c10`, `childTemplate`.`is_main` AS `t3_c11`, `childTemplate`.`show_as_catalog_list_tab` AS `t3_c12`, `childTemplate`.`catalog_list_tab_color` AS `t3_c13`, `childTemplate`.`products_list_default_view_type` AS `t3_c14`, `childTemplate`.`show_count_filters` AS `t3_c15`, `childTemplate`.`companies_list_view_type` AS `t3_c16`, `childTemplate`.`default_sort_products` AS `t3_c17`, `childTemplate`.`show_rubric_in_product_title` AS `t3_c18`, `childTemplate`.`page_url_prefix` AS `t3_c19`, `childTemplate`.`page_logic_type` AS `t3_c20`, `childTemplate`.`page_view_type` AS `t3_c21`, `childTemplate`.`page_seo_default_template_type` AS `t3_c22`, `childTemplate`.`show_city_in_sellers_count` AS `t3_c23`, `childTemplate`.`product_alternative_title` AS `t3_c24`, `childTemplate`.`product_alternative_title_nominative` AS `t3_c25`, `childTemplate`.`product_alternative_title_singular_accusative` AS `t3_c26`, `childTemplate`.`product_alternative_title_plural_accusative` AS `t3_c27`, `childTemplate`.`image_filename` AS `t3_c28`, `childTemplate`.`show_products_without_sellers` AS `t3_c29`, `childTemplate`.`noindex_products` AS `t3_c30`, `childTemplate`.`show_compact_image` AS `t3_c31`, `childRubric`.`id` AS `t4_c0`, `childRubric`.`status` AS `t4_c1`, `childRubric`.`title` AS `t4_c2`, `childRubric`.`singular_title` AS `t4_c3`, `childRubric`.`keywords` AS `t4_c4`, `childRubric`.`url` AS `t4_c5`, `childRubric`.`show_rel_noindex` AS `t4_c6`, `childRubric`.`section_redirect` AS `t4_c7`, `childRubric`.`sort_order` AS `t4_c8`, `childRubric`.`show_in_section_menu` AS `t4_c9`, `childRubric`.`show_cities` AS `t4_c10`, `childRubric`.`yandex_alias` AS `t4_c11`, `childRubric`.`date_modified` AS `t4_c12`, `childRubric`.`show_city_in_title` AS `t4_c13`, `childRubric`.`logo_filename` AS `t4_c14`, `childRubric`.`is_new_rubric` AS `t4_c15`, `childRubric`.`is_all_rubric` AS `t4_c16`, `childRubric`.`show_map` AS `t4_c17`, `childRubric`.`price_unit` AS `t4_c18`, `childRubric`.`enable_booking` AS `t4_c19`, `childRubric`.`type` AS `t4_c20`, `childRubric`.`show_product_availability_status` AS `t4_c21`, `childRubric`.`allow_banner_on_catalog` AS `t4_c22`, `template`.`id` AS `t5_c0`, `template`.`rubric_id` AS `t5_c1`, `template`.`title` AS `t5_c2`, `template`.`status` AS `t5_c3`, `template`.`type` AS `t5_c4`, `template`.`sellers_title` AS `t5_c5`, `template`.`show_in_rubricator` AS `t5_c6`, `template`.`show_robots` AS `t5_c7`, `template`.`show_cities` AS `t5_c8`, `template`.`enable_redirect_to_rubric` AS `t5_c9`, `template`.`sort_order` AS `t5_c10`, `template`.`is_main` AS `t5_c11`, `template`.`show_as_catalog_list_tab` AS `t5_c12`, `template`.`catalog_list_tab_color` AS `t5_c13`, `template`.`products_list_default_view_type` AS `t5_c14`, `template`.`show_count_filters` AS `t5_c15`, `template`.`companies_list_view_type` AS `t5_c16`, `template`.`default_sort_products` AS `t5_c17`, `template`.`show_rubric_in_product_title` AS `t5_c18`, `template`.`page_url_prefix` AS `t5_c19`, `template`.`page_logic_type` AS `t5_c20`, `template`.`page_view_type` AS `t5_c21`, `template`.`page_seo_default_template_type` AS `t5_c22`, `template`.`show_city_in_sellers_count` AS `t5_c23`, `template`.`product_alternative_title` AS `t5_c24`, `template`.`product_alternative_title_nominative` AS `t5_c25`, `template`.`product_alternative_title_singular_accusative` AS `t5_c26`, `template`.`product_alternative_title_plural_accusative` AS `t5_c27`, `template`.`image_filename` AS `t5_c28`, `template`.`show_products_without_sellers` AS `t5_c29`, `template`.`noindex_products` AS `t5_c30`, `template`.`show_compact_image` AS `t5_c31`, `rubric`.`id` AS `t6_c0`, `rubric`.`status` AS `t6_c1`, `rubric`.`title` AS `t6_c2`, `rubric`.`singular_title` AS `t6_c3`, `rubric`.`keywords` AS `t6_c4`, `rubric`.`url` AS `t6_c5`, `rubric`.`show_rel_noindex` AS `t6_c6`, `rubric`.`section_redirect` AS `t6_c7`, `rubric`.`sort_order` AS `t6_c8`, `rubric`.`show_in_section_menu` AS `t6_c9`, `rubric`.`show_cities` AS `t6_c10`, `rubric`.`yandex_alias` AS `t6_c11`, `rubric`.`date_modified` AS `t6_c12`, `rubric`.`show_city_in_title` AS `t6_c13`, `rubric`.`logo_filename` AS `t6_c14`, `rubric`.`is_new_rubric` AS `t6_c15`, `rubric`.`is_all_rubric` AS `t6_c16`, `rubric`.`show_map` AS `t6_c17`, `rubric`.`price_unit` AS `t6_c18`, `rubric`.`enable_booking` AS `t6_c19`, `rubric`.`type` AS `t6_c20`, `rubric`.`show_product_availability_status` AS `t6_c21`, `rubric`.`allow_banner_on_catalog` AS `t6_c22`
FROM `re_rubric_rubricator` `t`
LEFT OUTER JOIN `re_rubric_rubricator_item` `items` ON (`items`.`rubricator_id`=`t`.`id`) AND (parent_id IS NULL)
LEFT OUTER JOIN `re_rubric_rubricator_item` `childrenItems` ON (`childrenItems`.`parent_id`=`items`.`id`)
LEFT OUTER JOIN `re_rubric_template` `childTemplate` ON (`childrenItems`.`template_id`=`childTemplate`.`id`)
LEFT OUTER JOIN `re_rubric` `childRubric` ON (`childTemplate`.`rubric_id`=`childRubric`.`id`)
LEFT OUTER JOIN `re_rubric_template` `template` ON (`items`.`template_id`=`template`.`id`)
LEFT OUTER JOIN `re_rubric` `rubric` ON (`template`.`rubric_id`=`rubric`.`id`
WHERE (t.rubric_id = '10327413' AND (t.city_id = '1' OR t.city_id IS NULL) AND items.status = '1') AND (template.id IS NULL OR template.status = '1')) AND (rubric.id IS NULL OR rubric.status = '1')) AND (childrenItems.id IS NULL OR childrenItems.status = '1')) AND (childTemplate.id IS NULL OR childTemplate.status = '1')) AND (childRubric.id IS NULL OR childRubric.status = '1')) )
ORDER BY (t.city_id IS NULL) ASC, items.sort_order ASC, childrenItems.sort_order ASC
1 0.00178 0.00178 0.00178 0.00178

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`='10391013')
6 0.00159 0.00026 0.00022 0.00033

SELECT city_id
FROM `re_places_cities` `t`
WHERE `t`.`place_id`='10391013'
6 0.00147 0.00024 0.00021 0.00031

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 = 431295 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.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`.`displayed_url` AS `t9_c12`, `info`.`show_button_in_store` AS `t9_c29`, `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 = '10327413')
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 = '10327413' 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 = '431295')) AND (product.status = '1')
GROUP BY IF (networksPlaces.network_id IS NULL, t.id, networksPlaces.network_id)
ORDER BY sort.sort_order IS NULL, sort.sort_order, info.title
1 0.00118 0.00118 0.00118 0.00118

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`, `info`.`id` AS `t1_c0`, `info`.`place_id` AS `t1_c1`, `info`.`state` AS `t1_c2`, `info`.`title` AS `t1_c3`, `info`.`short_title` AS `t1_c4`, `info`.`short_description` AS `t1_c5`, `info`.`alternative_titles` AS `t1_c6`, `info`.`juridical_title` AS `t1_c7`, `info`.`unp` AS `t1_c8`, `info`.`transcription` AS `t1_c9`, `info`.`url` AS `t1_c10`, `info`.`site` AS `t1_c11`, `info`.`displayed_url` AS `t1_c12`, `info`.`logo_filename` AS `t1_c13`, `info`.`catalog_filename` AS `t1_c14`, `info`.`catalog_round_logo_filename` AS `t1_c15`, `info`.`catalog_logo_filename` AS `t1_c16`, `info`.`text_type` AS `t1_c17`, `info`.`close_message` AS `t1_c18`, `info`.`about` AS `t1_c19`, `info`.`date_opened` AS `t1_c20`, `info`.`date_modified` AS `t1_c21`, `info`.`date_paid_started` AS `t1_c22`, `info`.`show_filters_personal_count` AS `t1_c23`, `info`.`is_enable_comments` AS `t1_c24`, `info`.`as_advertising` AS `t1_c25`, `info`.`use_default_rate` AS `t1_c26`, `info`.`hide_right_column` AS `t1_c27`, `info`.`site_in_nofollow` AS `t1_c28`, `info`.`show_button_in_store` AS `t1_c29`, `info`.`last_editor_id` AS `t1_c30`, `info`.`review_conditions` AS `t1_c31`, `info`.`one_c_id` AS `t1_c32`, `info`.`juridical_address` AS `t1_c33`, `info`.`registration_authority` AS `t1_c34`, `info`.`registration_date` AS `t1_c35`, `info`.`registry_type` AS `t1_c36`, `info`.`registration_date_in_registry` AS `t1_c37`, `info`.`number_in_registry` AS `t1_c38`, `info`.`licence_number` AS `t1_c39`, `info`.`shop_name` AS `t1_c40`, `info`.`shop_address` AS `t1_c41`, `infoline`.`id` AS `t2_c0`, `infoline`.`place_id` AS `t2_c1`, `infoline`.`description` AS `t2_c2`
FROM `re_place` `t`
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_place_infoline` `infoline` ON (`infoline`.`place_id`=`t`.`id`)
WHERE (`t`.`id`=10459963)
1 0.00108 0.00108 0.00108 0.00108

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 = 'bookstores' 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.00105 0.00105 0.00105 0.00105

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`
FROM `re_city` `t`
LEFT OUTER JOIN `re_catalog_products_rubrics_sort` `productsRubricsSort` ON (`productsRubricsSort`.`city_id`=`t`.`id`)
WHERE (t.status = '1' AND productsRubricsSort.rubric_id = '10327413')
GROUP BY t.id
ORDER BY IF (t.is_regional = '1', t.sort_order, t.title)
1 0.00092 0.00092 0.00092 0.00092

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 = '431295' 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.00083 0.00083 0.00083 0.00083

SELECT `t`.`place_id` AS `t0_c1`, `t`.`title` AS `t0_c3`, `t`.`short_title` AS `t0_c4`, `t`.`url` AS `t0_c10`, `t`.`show_button_in_store` AS `t0_c29`, `t`.`displayed_url` AS `t0_c12`, `t`.`id` AS `t0_c0`, `address`.`id` AS `t1_c0`, `city`.`title` AS `t2_c1`, `city`.`id` AS `t2_c0`, `place`.`id` AS `t3_c0`
FROM `re_place_info` `t`
LEFT OUTER JOIN `re_address` `address` ON (`address`.`place_id`=`t`.`place_id`)
LEFT OUTER JOIN `re_city` `city` ON (`address`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_place` `place` ON (`t`.`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_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_products_rubrics` `productsRubrics` ON (`productsRubrics`.`product_id`=`product`.`id`)
LEFT OUTER JOIN `re_places_rubrics` `placesRubrics` ON (`placesRubrics`.`place_id`=`place`.`id`)
WHERE ((t.state = 'paid' AND placesCities.city_id = '1') AND (productsPlaces.product_id = '431295')) AND (place.status = '1' AND place.is_deleted = '0') AND (networksPlaces.id IS NULL OR (network.status = '1' AND cities.is_main = '1')) AND (productsRubrics.rubric_id = placesRubrics.rubric_id)
GROUP BY IF (networksPlaces.network_id IS NULL, t.place_id, networksPlaces.network_id)
1 0.00080 0.00080 0.00080 0.00080

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`.`template_id` AS `t1_c4`, `catalogProductFiltersRubricTemplates`.`title_rubric` AS `t1_c5`, `catalogProductFiltersRubricTemplates`.`note_description` AS `t1_c14`, `catalogProductFiltersRubricTemplates`.`show_in_rubric` AS `t1_c8`, `measureUnit`.`title` AS `t2_c1`, `measureUnit`.`id` AS `t2_c0`
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`)
LEFT OUTER JOIN `re_catalog_product_filter_option` `options` ON (`options`.`filter_id`=`t`.`id`
WHERE (catalogProductFiltersRubricTemplates.template_id = 10328683 AND t.status = '1' AND catalogProductFiltersRubricTemplates.status = '1' AND catalogProductFiltersRubricTemplates.show_in_description = '1'))
ORDER BY catalogProductFiltersRubricTemplates.sort_order ASC
1 0.00078 0.00078 0.00078 0.00078

SELECT `t`.`id` AS `t0_c0`, `t`.`type` AS `t0_c2`, `catalogProductFiltersRubricTemplates`.`id` AS `t1_c0`, `catalogProductFilterBrandSeo`.`brand_id` AS `t2_c1`, `catalogProductFilterBrandSeo`.`title_tape` AS `t2_c9`, `catalogProductFilterBrandSeo`.`id` AS `t2_c0`, `brand`.`url` AS `t3_c4`, `brand`.`id` AS `t3_c0`, `catalogProductFilterOptionSeo`.`option_id` AS `t4_c1`, `catalogProductFilterOptionSeo`.`title_tape` AS `t4_c9`, `catalogProductFilterOptionSeo`.`id` AS `t4_c0`, `option`.`id` AS `t5_c0`, `catalogProductFilterOptionsRubricTemplates`.`url` AS `t6_c4`, `catalogProductFilterOptionsRubricTemplates`.`id` AS `t6_c0`
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_catalog_product_filter_brand_seo` `catalogProductFilterBrandSeo` ON (`catalogProductFilterBrandSeo`.`rubric_templates_filters_id`=`catalogProductFiltersRubricTemplates`.`id`)
LEFT OUTER JOIN `re_catalog_brand` `brand` ON (`catalogProductFilterBrandSeo`.`brand_id`=`brand`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter_option_seo` `catalogProductFilterOptionSeo` ON (`catalogProductFilterOptionSeo`.`rubric_templates_filters_id`=`catalogProductFiltersRubricTemplates`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter_option` `option` ON (`catalogProductFilterOptionSeo`.`option_id`=`option`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter_options_rubric_templates` `catalogProductFilterOptionsRubricTemplates` ON (`catalogProductFilterOptionsRubricTemplates`.`option_id`=`option`.`id`) AND (catalogProductFilterOptionsRubricTemplates.rubric_templates_filters_id = catalogProductFilterOptionSeo.rubric_templates_filters_id
WHERE ( (catalogProductFilterOptionSeo.show_in_tape = '1' OR catalogProductFilterBrandSeo.show_in_tape = '1') AND (catalogProductFilterOptionSeo.city_id = '1' OR catalogProductFilterBrandSeo.city_id = '1') AND catalogProductFiltersRubricTemplates.template_id = '10328683' AND catalogProductFiltersRubricTemplates.status = '1') AND t.status = '1') AND (catalogProductFilterOptionsRubricTemplates.url != "" OR brand.url != ""))
ORDER BY catalogProductFiltersRubricTemplates.sort_order, option.sort_order
1 0.00070 0.00070 0.00070 0.00070

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 = '2773' AND catalogProductFilterOptionsProducts.product_id = 431295 )
GROUP BY t.id
ORDER BY t.sort_order
1 0.00064 0.00064 0.00064 0.00064

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 = '10327413' AND productsRubricsSort.city_id = '1' AND t.status = '1') AND (brand.id = 27245))
1 0.00064 0.00064 0.00064 0.00064

SELECT `t`.`name` AS `t0_c4`, `t`.`image` AS `t0_c13`, `t`.`url` AS `t0_c11`, `t`.`id` AS `t0_c0`
FROM `re_feed_item` `t`
LEFT OUTER JOIN `re_feed_items_products_places` `feedItemsProductsPlaces` ON (`feedItemsProductsPlaces`.`feed_item_id`=`t`.`id`)
LEFT OUTER JOIN `re_catalog_products_places` `productsPlaces` ON (`feedItemsProductsPlaces`.`products_places_id`=`productsPlaces`.`id`)
WHERE (productsPlaces.product_id = '431295' AND productsPlaces.place_id = '10459963')
GROUP BY t.id
1 0.00064 0.00064 0.00064 0.00064

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`, `infoline`.`id` AS `t1_c0`, `infoline`.`place_id` AS `t1_c1`, `infoline`.`description` AS `t1_c2`, `info`.`id` AS `t2_c0`, `info`.`place_id` AS `t2_c1`, `info`.`state` AS `t2_c2`, `info`.`title` AS `t2_c3`, `info`.`short_title` AS `t2_c4`, `info`.`short_description` AS `t2_c5`, `info`.`alternative_titles` AS `t2_c6`, `info`.`juridical_title` AS `t2_c7`, `info`.`unp` AS `t2_c8`, `info`.`transcription` AS `t2_c9`, `info`.`url` AS `t2_c10`, `info`.`site` AS `t2_c11`, `info`.`displayed_url` AS `t2_c12`, `info`.`logo_filename` AS `t2_c13`, `info`.`catalog_filename` AS `t2_c14`, `info`.`catalog_round_logo_filename` AS `t2_c15`, `info`.`catalog_logo_filename` AS `t2_c16`, `info`.`text_type` AS `t2_c17`, `info`.`close_message` AS `t2_c18`, `info`.`about` AS `t2_c19`, `info`.`date_opened` AS `t2_c20`, `info`.`date_modified` AS `t2_c21`, `info`.`date_paid_started` AS `t2_c22`, `info`.`show_filters_personal_count` AS `t2_c23`, `info`.`is_enable_comments` AS `t2_c24`, `info`.`as_advertising` AS `t2_c25`, `info`.`use_default_rate` AS `t2_c26`, `info`.`hide_right_column` AS `t2_c27`, `info`.`site_in_nofollow` AS `t2_c28`, `info`.`show_button_in_store` AS `t2_c29`, `info`.`last_editor_id` AS `t2_c30`, `info`.`review_conditions` AS `t2_c31`, `info`.`one_c_id` AS `t2_c32`, `info`.`juridical_address` AS `t2_c33`, `info`.`registration_authority` AS `t2_c34`, `info`.`registration_date` AS `t2_c35`, `info`.`registry_type` AS `t2_c36`, `info`.`registration_date_in_registry` AS `t2_c37`, `info`.`number_in_registry` AS `t2_c38`, `info`.`licence_number` AS `t2_c39`, `info`.`shop_name` AS `t2_c40`, `info`.`shop_address` AS `t2_c41`, `networksPlaces`.`network_id` AS `t3_c1`, `networksPlaces`.`id` AS `t3_c0`, `network`.`status` AS `t4_c4`, `network`.`logo_filename` AS `t4_c2`, `network`.`title` AS `t4_c1`, `network`.`main_place_id` AS `t4_c5`, `network`.`id` AS `t4_c0`
FROM `re_place` `t`
LEFT OUTER JOIN `re_place_infoline` `infoline` ON (`infoline`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`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`)
WHERE (`t`.`id`=10415903)
1 0.00064 0.00064 0.00064 0.00064

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 <= 1487843640 AND date_end >= 1487843640) AND ((section_id = '19628' OR section_id IS NULL) AND (rubric_id = '10327413' 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.00064 0.00064 0.00064 0.00064

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 = '10327413' AND productsRubricsSort.city_id = '1' AND t.status = '1') AND (brand.id = 27245))
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.00058 0.00058 0.00058 0.00058

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 <= 1487843640 AND date_end >= 1487843640) AND ((section_id = '19628' OR section_id IS NULL) AND (rubric_id = '10327413' 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.00058 0.00058 0.00058 0.00058

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`, `infoline`.`id` AS `t1_c0`, `infoline`.`place_id` AS `t1_c1`, `infoline`.`description` AS `t1_c2`, `info`.`id` AS `t2_c0`, `info`.`place_id` AS `t2_c1`, `info`.`state` AS `t2_c2`, `info`.`title` AS `t2_c3`, `info`.`short_title` AS `t2_c4`, `info`.`short_description` AS `t2_c5`, `info`.`alternative_titles` AS `t2_c6`, `info`.`juridical_title` AS `t2_c7`, `info`.`unp` AS `t2_c8`, `info`.`transcription` AS `t2_c9`, `info`.`url` AS `t2_c10`, `info`.`site` AS `t2_c11`, `info`.`displayed_url` AS `t2_c12`, `info`.`logo_filename` AS `t2_c13`, `info`.`catalog_filename` AS `t2_c14`, `info`.`catalog_round_logo_filename` AS `t2_c15`, `info`.`catalog_logo_filename` AS `t2_c16`, `info`.`text_type` AS `t2_c17`, `info`.`close_message` AS `t2_c18`, `info`.`about` AS `t2_c19`, `info`.`date_opened` AS `t2_c20`, `info`.`date_modified` AS `t2_c21`, `info`.`date_paid_started` AS `t2_c22`, `info`.`show_filters_personal_count` AS `t2_c23`, `info`.`is_enable_comments` AS `t2_c24`, `info`.`as_advertising` AS `t2_c25`, `info`.`use_default_rate` AS `t2_c26`, `info`.`hide_right_column` AS `t2_c27`, `info`.`site_in_nofollow` AS `t2_c28`, `info`.`show_button_in_store` AS `t2_c29`, `info`.`last_editor_id` AS `t2_c30`, `info`.`review_conditions` AS `t2_c31`, `info`.`one_c_id` AS `t2_c32`, `info`.`juridical_address` AS `t2_c33`, `info`.`registration_authority` AS `t2_c34`, `info`.`registration_date` AS `t2_c35`, `info`.`registry_type` AS `t2_c36`, `info`.`registration_date_in_registry` AS `t2_c37`, `info`.`number_in_registry` AS `t2_c38`, `info`.`licence_number` AS `t2_c39`, `info`.`shop_name` AS `t2_c40`, `info`.`shop_address` AS `t2_c41`, `networksPlaces`.`network_id` AS `t3_c1`, `networksPlaces`.`id` AS `t3_c0`, `network`.`status` AS `t4_c4`, `network`.`logo_filename` AS `t4_c2`, `network`.`title` AS `t4_c1`, `network`.`main_place_id` AS `t4_c5`, `network`.`id` AS `t4_c0`
FROM `re_place` `t`
LEFT OUTER JOIN `re_place_infoline` `infoline` ON (`infoline`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`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`)
WHERE (`t`.`id`=10575825)
1 0.00056 0.00056 0.00056 0.00056

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`, `infoline`.`id` AS `t1_c0`, `infoline`.`place_id` AS `t1_c1`, `infoline`.`description` AS `t1_c2`, `info`.`id` AS `t2_c0`, `info`.`place_id` AS `t2_c1`, `info`.`state` AS `t2_c2`, `info`.`title` AS `t2_c3`, `info`.`short_title` AS `t2_c4`, `info`.`short_description` AS `t2_c5`, `info`.`alternative_titles` AS `t2_c6`, `info`.`juridical_title` AS `t2_c7`, `info`.`unp` AS `t2_c8`, `info`.`transcription` AS `t2_c9`, `info`.`url` AS `t2_c10`, `info`.`site` AS `t2_c11`, `info`.`displayed_url` AS `t2_c12`, `info`.`logo_filename` AS `t2_c13`, `info`.`catalog_filename` AS `t2_c14`, `info`.`catalog_round_logo_filename` AS `t2_c15`, `info`.`catalog_logo_filename` AS `t2_c16`, `info`.`text_type` AS `t2_c17`, `info`.`close_message` AS `t2_c18`, `info`.`about` AS `t2_c19`, `info`.`date_opened` AS `t2_c20`, `info`.`date_modified` AS `t2_c21`, `info`.`date_paid_started` AS `t2_c22`, `info`.`show_filters_personal_count` AS `t2_c23`, `info`.`is_enable_comments` AS `t2_c24`, `info`.`as_advertising` AS `t2_c25`, `info`.`use_default_rate` AS `t2_c26`, `info`.`hide_right_column` AS `t2_c27`, `info`.`site_in_nofollow` AS `t2_c28`, `info`.`show_button_in_store` AS `t2_c29`, `info`.`last_editor_id` AS `t2_c30`, `info`.`review_conditions` AS `t2_c31`, `info`.`one_c_id` AS `t2_c32`, `info`.`juridical_address` AS `t2_c33`, `info`.`registration_authority` AS `t2_c34`, `info`.`registration_date` AS `t2_c35`, `info`.`registry_type` AS `t2_c36`, `info`.`registration_date_in_registry` AS `t2_c37`, `info`.`number_in_registry` AS `t2_c38`, `info`.`licence_number` AS `t2_c39`, `info`.`shop_name` AS `t2_c40`, `info`.`shop_address` AS `t2_c41`, `networksPlaces`.`network_id` AS `t3_c1`, `networksPlaces`.`id` AS `t3_c0`, `network`.`status` AS `t4_c4`, `network`.`logo_filename` AS `t4_c2`, `network`.`title` AS `t4_c1`, `network`.`main_place_id` AS `t4_c5`, `network`.`id` AS `t4_c0`
FROM `re_place` `t`
LEFT OUTER JOIN `re_place_infoline` `infoline` ON (`infoline`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`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`)
WHERE (`t`.`id`=10391013)
1 0.00056 0.00056 0.00056 0.00056

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`, `infoline`.`id` AS `t1_c0`, `infoline`.`place_id` AS `t1_c1`, `infoline`.`description` AS `t1_c2`, `info`.`id` AS `t2_c0`, `info`.`place_id` AS `t2_c1`, `info`.`state` AS `t2_c2`, `info`.`title` AS `t2_c3`, `info`.`short_title` AS `t2_c4`, `info`.`short_description` AS `t2_c5`, `info`.`alternative_titles` AS `t2_c6`, `info`.`juridical_title` AS `t2_c7`, `info`.`unp` AS `t2_c8`, `info`.`transcription` AS `t2_c9`, `info`.`url` AS `t2_c10`, `info`.`site` AS `t2_c11`, `info`.`displayed_url` AS `t2_c12`, `info`.`logo_filename` AS `t2_c13`, `info`.`catalog_filename` AS `t2_c14`, `info`.`catalog_round_logo_filename` AS `t2_c15`, `info`.`catalog_logo_filename` AS `t2_c16`, `info`.`text_type` AS `t2_c17`, `info`.`close_message` AS `t2_c18`, `info`.`about` AS `t2_c19`, `info`.`date_opened` AS `t2_c20`, `info`.`date_modified` AS `t2_c21`, `info`.`date_paid_started` AS `t2_c22`, `info`.`show_filters_personal_count` AS `t2_c23`, `info`.`is_enable_comments` AS `t2_c24`, `info`.`as_advertising` AS `t2_c25`, `info`.`use_default_rate` AS `t2_c26`, `info`.`hide_right_column` AS `t2_c27`, `info`.`site_in_nofollow` AS `t2_c28`, `info`.`show_button_in_store` AS `t2_c29`, `info`.`last_editor_id` AS `t2_c30`, `info`.`review_conditions` AS `t2_c31`, `info`.`one_c_id` AS `t2_c32`, `info`.`juridical_address` AS `t2_c33`, `info`.`registration_authority` AS `t2_c34`, `info`.`registration_date` AS `t2_c35`, `info`.`registry_type` AS `t2_c36`, `info`.`registration_date_in_registry` AS `t2_c37`, `info`.`number_in_registry` AS `t2_c38`, `info`.`licence_number` AS `t2_c39`, `info`.`shop_name` AS `t2_c40`, `info`.`shop_address` AS `t2_c41`, `networksPlaces`.`network_id` AS `t3_c1`, `networksPlaces`.`id` AS `t3_c0`, `network`.`status` AS `t4_c4`, `network`.`logo_filename` AS `t4_c2`, `network`.`title` AS `t4_c1`, `network`.`main_place_id` AS `t4_c5`, `network`.`id` AS `t4_c0`
FROM `re_place` `t`
LEFT OUTER JOIN `re_place_infoline` `infoline` ON (`infoline`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`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`)
WHERE (`t`.`id`=10576595)
1 0.00053 0.00053 0.00053 0.00053

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 = '10328683' AND t.seo_title != "" AND t.url != "") AND (catalogProductFilterOptionsRubricTemplates.url != "") AND (catalogProductFilterOptionSeo.city_id = '1') AND (filterSeo.city_id = '1')
1 0.00052 0.00052 0.00052 0.00052

SELECT `t`.`id` AS `t0_c0`, `t`.`title` AS `t0_c1`, `t`.`form_id` AS `t0_c2`, `t`.`rubric_id` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`form_template_field_id` AS `t0_c5`, `formTemplateField`.`id` AS `t1_c0`, `formTemplateField`.`title` AS `t1_c1`, `formTemplateField`.`field_type_label` AS `t1_c2`, `formTemplateField`.`field_comment` AS `t1_c3`, `formTemplateField`.`type` AS `t1_c4`, `formTemplateField`.`default_text` AS `t1_c5`, `formTemplateField`.`order` AS `t1_c6`, `formTemplateField`.`form_template_id` AS `t1_c7`, `formTemplateField`.`is_necessarily` AS `t1_c8`
FROM `re_form_field_label` `t`
LEFT OUTER JOIN `re_form_template_field` `formTemplateField` ON (`t`.`form_template_field_id`=`formTemplateField`.`id`)
WHERE (t.form_id = '815' AND (t.rubric_id = '10327413' OR t.rubric_id IS NULL))
ORDER BY t.rubric_id ASC
1 0.00051 0.00051 0.00051 0.00051

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`, `infoline`.`id` AS `t1_c0`, `infoline`.`place_id` AS `t1_c1`, `infoline`.`description` AS `t1_c2`, `info`.`id` AS `t2_c0`, `info`.`place_id` AS `t2_c1`, `info`.`state` AS `t2_c2`, `info`.`title` AS `t2_c3`, `info`.`short_title` AS `t2_c4`, `info`.`short_description` AS `t2_c5`, `info`.`alternative_titles` AS `t2_c6`, `info`.`juridical_title` AS `t2_c7`, `info`.`unp` AS `t2_c8`, `info`.`transcription` AS `t2_c9`, `info`.`url` AS `t2_c10`, `info`.`site` AS `t2_c11`, `info`.`displayed_url` AS `t2_c12`, `info`.`logo_filename` AS `t2_c13`, `info`.`catalog_filename` AS `t2_c14`, `info`.`catalog_round_logo_filename` AS `t2_c15`, `info`.`catalog_logo_filename` AS `t2_c16`, `info`.`text_type` AS `t2_c17`, `info`.`close_message` AS `t2_c18`, `info`.`about` AS `t2_c19`, `info`.`date_opened` AS `t2_c20`, `info`.`date_modified` AS `t2_c21`, `info`.`date_paid_started` AS `t2_c22`, `info`.`show_filters_personal_count` AS `t2_c23`, `info`.`is_enable_comments` AS `t2_c24`, `info`.`as_advertising` AS `t2_c25`, `info`.`use_default_rate` AS `t2_c26`, `info`.`hide_right_column` AS `t2_c27`, `info`.`site_in_nofollow` AS `t2_c28`, `info`.`show_button_in_store` AS `t2_c29`, `info`.`last_editor_id` AS `t2_c30`, `info`.`review_conditions` AS `t2_c31`, `info`.`one_c_id` AS `t2_c32`, `info`.`juridical_address` AS `t2_c33`, `info`.`registration_authority` AS `t2_c34`, `info`.`registration_date` AS `t2_c35`, `info`.`registry_type` AS `t2_c36`, `info`.`registration_date_in_registry` AS `t2_c37`, `info`.`number_in_registry` AS `t2_c38`, `info`.`licence_number` AS `t2_c39`, `info`.`shop_name` AS `t2_c40`, `info`.`shop_address` AS `t2_c41`, `networksPlaces`.`network_id` AS `t3_c1`, `networksPlaces`.`id` AS `t3_c0`, `network`.`status` AS `t4_c4`, `network`.`logo_filename` AS `t4_c2`, `network`.`title` AS `t4_c1`, `network`.`main_place_id` AS `t4_c5`, `network`.`id` AS `t4_c0`
FROM `re_place` `t`
LEFT OUTER JOIN `re_place_infoline` `infoline` ON (`infoline`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`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`)
WHERE (`t`.`id`=10415383)
1 0.00046 0.00046 0.00046 0.00046

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 = '27245') AND (rubricTemplatesFilters.template_id = '10328683') AND (filter.type = 'brand')
1 0.00045 0.00045 0.00045 0.00045

SELECT `t`.`id` AS `t0_c0`, `t`.`place_id` AS `t0_c1`, `t`.`city_id` AS `t0_c2`, `t`.`country_id` AS `t0_c3`, `t`.`address` AS `t0_c4`, `t`.`building` AS `t0_c5`, `t`.`description` AS `t0_c6`, `t`.`metro_station_id` AS `t0_c7`, `t`.`hide_city` AS `t0_c8`, `t`.`handbook_address_id` AS `t0_c9`, `t`.`office` AS `t0_c10`, `t`.`type_of_office` AS `t0_c11`, `t`.`floor` AS `t0_c12`, `driveway`.`id` AS `t1_c0`, `driveway`.`address_id` AS `t1_c1`, `driveway`.`type` AS `t1_c2`, `driveway`.`coord_x` AS `t1_c3`, `driveway`.`coord_y` AS `t1_c4`, `driveway`.`coord_center_x` AS `t1_c5`, `driveway`.`coord_center_y` AS `t1_c6`, `driveway`.`zoom` AS `t1_c7`, `driveway`.`description` AS `t1_c8`, `driveway`.`description_driveway` AS `t1_c9`, `driveway`.`show_map` AS `t1_c10`, `driveway`.`map_image` AS `t1_c11`
FROM `re_address` `t`
LEFT OUTER JOIN `re_driveway` `driveway` ON (`driveway`.`address_id`=`t`.`id`)
WHERE (`t`.`place_id`='10459963')
1 0.00045 0.00045 0.00045 0.00045

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 = 2823 AND catalogProductFilterOptionsProducts.product_id = 431295)
GROUP BY t.id
ORDER BY t.sort_order
1 0.00041 0.00041 0.00041 0.00041

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 = '100015105') AND (place.type != 'without_ps')
1 0.00040 0.00040 0.00040 0.00040

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 = '431295')
1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(
SELECT *
FROM `re_rubric_template` `t`
WHERE t.rubric_id = '10327413' AND t.status = '1' AND t.show_as_catalog_list_tab = '1')
ORDER BY t.sort_order, t.id
1 0.00038 0.00038 0.00038 0.00038

SELECT `t`.`id` AS `t0_c0`, `t`.`sort_order` AS `t0_c1`, `t`.`country_id` AS `t0_c2`, `t`.`phone_code` AS `t0_c3`, `t`.`phone` AS `t0_c4`, `t`.`place_id` AS `t0_c5`, `t`.`description` AS `t0_c6`, `country`.`phone_code` AS `t1_c2`, `country`.`id` AS `t1_c0`
FROM `re_place_phone` `t`
LEFT OUTER JOIN `re_country` `country` ON (`t`.`country_id`=`country`.`id`)
WHERE (t.place_id = '10459963')
ORDER BY t.sort_order
1 0.00037 0.00037 0.00037 0.00037

SELECT *
FROM `re_place_currency_rate` `t`
WHERE `t`.`place_id`='10459963'
1 0.00036 0.00036 0.00036 0.00036

SELECT *
FROM `re_place_info` `t`
WHERE `t`.`place_id`='10459963'
LIMIT 1
1 0.00035 0.00035 0.00035 0.00035

SELECT *
FROM `re_place_contact` `t`
WHERE `t`.`place_id`='10459963'
1 0.00034 0.00034 0.00034 0.00034

SELECT `t`.`id` AS `t0_c0`, `t`.`rubric_templates_filters_id` AS `t0_c1`, `t`.`template_id` AS `t0_c2`, `t`.`h1` AS `t0_c3`, `t`.`title` AS `t0_c4`, `t`.`description` AS `t0_c5`, `t`.`keywords` AS `t0_c6`, `t`.`text` AS `t0_c7`
FROM `re_catalog_product_filter_rubric_template_seo_template` `t`
LEFT OUTER JOIN `re_catalog_product_filters_rubric_templates` `filterRubricTemplates` ON (`t`.`rubric_templates_filters_id`=`filterRubricTemplates`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter` `filter` ON (`filterRubricTemplates`.`filter_id`=`filter`.`id`)
WHERE ((t.rubric_templates_filters_id is null OR filter.type = 'brand') AND t.template_id = '10328683')
1 0.00032 0.00032 0.00032 0.00032

SELECT `t`.`id` AS `t0_c0`, `t`.`place_id` AS `t0_c1`, `t`.`city_id` AS `t0_c2`, `t`.`country_id` AS `t0_c3`, `t`.`address` AS `t0_c4`, `t`.`building` AS `t0_c5`, `t`.`description` AS `t0_c6`, `t`.`metro_station_id` AS `t0_c7`, `t`.`hide_city` AS `t0_c8`, `t`.`handbook_address_id` AS `t0_c9`, `t`.`office` AS `t0_c10`, `t`.`type_of_office` AS `t0_c11`, `t`.`floor` AS `t0_c12`, `city`.`id` AS `t1_c0`, `city`.`title` AS `t1_c1`, `city`.`prepositional_title` AS `t1_c2`, `city`.`transcription` AS `t1_c3`, `city`.`country_id` AS `t1_c4`, `city`.`phone_code` AS `t1_c5`, `city`.`status` AS `t1_c6`, `city`.`status_mobile` AS `t1_c7`, `city`.`sort_order` AS `t1_c8`, `city`.`latitude` AS `t1_c9`, `city`.`longitude` AS `t1_c10`, `city`.`type` AS `t1_c11`, `city`.`is_regional` AS `t1_c12`, `city`.`zoom` AS `t1_c13`, `city`.`show_in_select` AS `t1_c14`
FROM `re_address` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
WHERE (`t`.`place_id`='10459963')
1 0.00032 0.00032 0.00032 0.00032

SELECT `t`.`url` AS `t0_c12`, `t`.`seo_title` AS `t0_c11`, `t`.`filter_id` AS `t0_c3`, `t`.`template_id` AS `t0_c4`, `t`.`id` AS `t0_c0`, `template`.`rubric_id` AS `t1_c1`, `template`.`page_url_prefix` AS `t1_c19`, `template`.`id` AS `t1_c0`
FROM `re_catalog_product_filters_rubric_templates` `t`
LEFT OUTER JOIN `re_rubric_template` `template` ON (`t`.`template_id`=`template`.`id`)
LEFT OUTER JOIN `re_catalog_product_filter` `filter` ON (`t`.`filter_id`=`filter`.`id`)
WHERE (t.template_id = '10328683' AND t.seo_title != "" AND t.url != "") AND (filter.type = 'brand')
1 0.00031 0.00031 0.00031 0.00031

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 = '10328683' AND catalogProductFiltersRubricTemplates.status = '1' AND (t.type = 'brand'))
1 0.00031 0.00031 0.00031 0.00031

SELECT *
FROM `re_worktime` `t`
WHERE t.place_id = '10459963'
ORDER BY t.weekend, t.fulltime, t.start_time, t.end_time
1 0.00029 0.00029 0.00029 0.00029

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`, `brand`.`id` AS `t1_c0`, `brand`.`status` AS `t1_c1`, `brand`.`title` AS `t1_c2`, `brand`.`keywords` AS `t1_c3`, `brand`.`url` AS `t1_c4`, `brand`.`logo_filename` AS `t1_c5`, `brand`.`description` AS `t1_c6`
FROM `re_catalog_product` `t`
LEFT OUTER JOIN `re_catalog_brand` `brand` ON (`t`.`brand_id`=`brand`.`id`)
WHERE (t.id = '431295' AND t.status = '1')
1 0.00027 0.00027 0.00027 0.00027

SELECT *
FROM `re_catalog_related_rubric` `t`
WHERE `t`.`status`='1' AND `t`.`rubric_id`='10327413' AND `t`.`city_id`='1'
ORDER BY sort_order
1 0.00026 0.00026 0.00026 0.00026

SELECT id, title
FROM `re_catalog_brand` `t`
WHERE `t`.`url`='aleksandr-izedinov' AND `t`.`status`='1'
LIMIT 1
1 0.00024 0.00024 0.00024 0.00024

SELECT id
FROM `re_catalog_brand` `t`
WHERE `t`.`url`='aleksandr-izedinov' AND `t`.`status`='1'
LIMIT 1
1 0.00023 0.00023 0.00023 0.00023

SELECT `t`.`title` AS `t0_c2`, `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 = '10328683')
1 0.00022 0.00022 0.00022 0.00022

SELECT t.title
FROM `re_catalog_brand` `t`
WHERE `t`.`id`=27245
LIMIT 1
1 0.00014 0.00014 0.00014 0.00014

SELECT `addressHandbook`.`id` AS `t1_c0`, `addressHandbook`.`city_id` AS `t1_c1`, `addressHandbook`.`title` AS `t1_c2`, `addressHandbook`.`street` AS `t1_c3`, `addressHandbook`.`house` AS `t1_c4`
FROM `re_handbook_address` `addressHandbook`
WHERE (`addressHandbook`.`id`=NULL)
1 0.00014 0.00014 0.00014 0.00014