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
Медицинские центры в Минске Сообщить об ошибке

Консультационный центр «Профессор»

НАПИШИТЕ ОТЗЫВ
Укажите адрес места, на которое хотите оставить отзыв
Рекомендую
Отправить комментарий
Нажимая кнопку «Отправить», Вы принимаете Правила размещения комментариев. Отзыв не будет опубликован, если он содержит ненормативную лексику, оскорбления и угрозы
Время: 2.7 с. Память: 6,933Кб, Запросы к БД: 116. Запросы к КЭШу: 457.
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)

SELECT `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_city` `city`
WHERE (`city`.`id`='1')
4 0.01908 0.00477 0.00026 0.01065

SELECT COUNT(*) FROM (
SELECT `t`.`id` AS `t0_c0`, `t`.`place_id` AS `t0_c1`, `t`.`item_id` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`date_created` AS `t0_c4`, `t`.`date_answered` AS `t0_c5`, `t`.`text` AS `t0_c6`, `t`.`answer_author` AS `t0_c7`, `t`.`answer` AS `t0_c8`, `t`.`ip` AS `t0_c9`, `t`.`author` AS `t0_c10`, `t`.`phone` AS `t0_c11`, `t`.`email` AS `t0_c12`, `t`.`type` AS `t0_c13`, `t`.`like` AS `t0_c14`, `t`.`is_deleted` AS `t0_c15`, `t`.`is_send` AS `t0_c16`, `t`.`comment` AS `t0_c17`, `t`.`is_author_notified` AS `t0_c18`, `t`.`user_id` AS `t0_c19`, `t`.`is_answer_email` AS `t0_c20`, `t`.`source` AS `t0_c21`, `t`.`callback` AS `t0_c22`, `t`.`moderator_id` AS `t0_c23`, `t`.`date_status_first_changed` AS `t0_c24`, `t`.`disabled_reason` AS `t0_c25`, `t`.`feedback` AS `t0_c26`
FROM `re_place_review` `t`
LEFT OUTER JOIN `re_gallery` `gallery` ON (`t`.`item_id`=`gallery`.`id`) AND (t.type = 'gallery')
LEFT OUTER JOIN `re_photo` `photo` ON (`t`.`item_id`=`photo`.`id`) AND (t.type = 'photo')
LEFT OUTER JOIN `re_gallery` `photoGallery` ON (`photo`.`gallery_id`=`photoGallery`.`id`)
WHERE (((t.place_id = 10345343 AND t.status = '1' AND t.is_deleted = '0') AND (t.type = 'place' OR (t.type = 'gallery' AND gallery.status = '1' OR (t.type = 'photo' AND photo.status = '1' AND photoGallery.status = '1'))) AND (t.type='place') AND `like` = '1'))
GROUP BY t.id) sq
1 0.00828 0.00828 0.00828 0.00828

SELECT `t`.`id` AS `t0_c0`, `t`.`value` AS `t0_c2`
FROM `re_catalog_filter_option` `t`
LEFT OUTER JOIN `re_catalog_filter_options_places` `catalogFilterOptionsPlaces` ON (`catalogFilterOptionsPlaces`.`option_id`=`t`.`id`)
WHERE (t.filter_id = 249 AND catalogFilterOptionsPlaces.place_id = 10345313)
ORDER BY t.sort_order ASC
14 0.00679 0.00049 0.00041 0.00068

SELECT *
FROM `re_redirect` `t`
WHERE (t.from_url = 'http://professor-bgmy.relax.by/' OR t.from_url = 'http://professor-bgmy.relax.by') AND (type = 'for_all')
LIMIT 1
1 0.00559 0.00559 0.00559 0.00559

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`=10345323)
1 0.00416 0.00416 0.00416 0.00416

SELECT *
FROM `re_place_file` `t`
WHERE t.place_id = '10345313'
ORDER BY t.sort_order
1 0.00364 0.00364 0.00364 0.00364

SELECT `t`.`id` AS `t0_c0`, `t`.`value` AS `t0_c2`
FROM `re_catalog_filter_option` `t`
LEFT OUTER JOIN `re_catalog_filter_options_places` `catalogFilterOptionsPlaces` ON (`catalogFilterOptionsPlaces`.`option_id`=`t`.`id`)
WHERE (t.filter_id = 12 AND catalogFilterOptionsPlaces.place_id = 10345313)
6 0.00276 0.00046 0.00034 0.00060

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)
7 0.00199 0.00028 0.00014 0.00060

SELECT `t`.`id` AS `t0_c0`, `catalogFiltersRubricTemplates`.`id` AS `t2_c0`, `template`.`id` AS `t3_c0`, `template`.`rubric_id` AS `t3_c1`, `template`.`title` AS `t3_c2`, `template`.`status` AS `t3_c3`, `template`.`type` AS `t3_c4`, `template`.`sellers_title` AS `t3_c5`, `template`.`show_in_rubricator` AS `t3_c6`, `template`.`show_robots` AS `t3_c7`, `template`.`show_cities` AS `t3_c8`, `template`.`enable_redirect_to_rubric` AS `t3_c9`, `template`.`sort_order` AS `t3_c10`, `template`.`is_main` AS `t3_c11`, `template`.`show_as_catalog_list_tab` AS `t3_c12`, `template`.`catalog_list_tab_color` AS `t3_c13`, `template`.`products_list_default_view_type` AS `t3_c14`, `template`.`show_count_filters` AS `t3_c15`, `template`.`companies_list_view_type` AS `t3_c16`, `template`.`default_sort_products` AS `t3_c17`, `template`.`show_rubric_in_product_title` AS `t3_c18`, `template`.`page_url_prefix` AS `t3_c19`, `template`.`page_logic_type` AS `t3_c20`, `template`.`page_view_type` AS `t3_c21`, `template`.`page_seo_default_template_type` AS `t3_c22`, `template`.`show_city_in_sellers_count` AS `t3_c23`, `template`.`product_alternative_title` AS `t3_c24`, `template`.`product_alternative_title_nominative` AS `t3_c25`, `template`.`product_alternative_title_singular_accusative` AS `t3_c26`, `template`.`product_alternative_title_plural_accusative` AS `t3_c27`, `template`.`image_filename` AS `t3_c28`, `template`.`show_products_without_sellers` AS `t3_c29`, `template`.`noindex_products` AS `t3_c30`, `template`.`show_compact_image` AS `t3_c31`, `catalogFilterOptionSeos`.`title_in_personal_filter_options_widget` AS `t5_c13`, `catalogFilterOptionSeos`.`id` AS `t5_c0`, `catalogFilterOptionsRubricTemplates`.`url` AS `t6_c3`, `catalogFilterOptionsRubricTemplates`.`id` AS `t6_c0`
FROM `re_catalog_filter_option` `t`
LEFT OUTER JOIN `re_catalog_filter` `filter` ON (`t`.`filter_id`=`filter`.`id`)
LEFT OUTER JOIN `re_catalog_filters_rubric_templates` `catalogFiltersRubricTemplates` ON (`catalogFiltersRubricTemplates`.`filter_id`=`filter`.`id`)
LEFT OUTER JOIN `re_rubric_template` `template` ON (`catalogFiltersRubricTemplates`.`template_id`=`template`.`id`)
LEFT OUTER JOIN `re_catalog_filter_options_places` `catalogFilterOptionsPlaces` ON (`catalogFilterOptionsPlaces`.`option_id`=`t`.`id`)
LEFT OUTER JOIN `re_catalog_filter_option_seo` `catalogFilterOptionSeos` ON (`catalogFilterOptionSeos`.`option_id`=`t`.`id`) AND (catalogFilterOptionSeos.rubric_templates_filters_id = catalogFiltersRubricTemplates.id)
LEFT OUTER JOIN `re_catalog_filter_options_rubric_templates` `catalogFilterOptionsRubricTemplates` ON (`catalogFilterOptionsRubricTemplates`.`option_id`=`t`.`id`) AND (catalogFilterOptionsRubricTemplates.rubric_templates_filters_id = catalogFiltersRubricTemplates.id)
WHERE (filter.status = '1') AND (catalogFiltersRubricTemplates.status = '1') AND (template.rubric_id = '555033') AND (catalogFilterOptionsPlaces.place_id = '10345313') AND (catalogFilterOptionSeos.show_in_personal_filter_options_widget = '1' AND catalogFilterOptionSeos.city_id = '1')
GROUP BY t.id
ORDER BY catalogFiltersRubricTemplates.sort_order, t.sort_order
1 0.00142 0.00142 0.00142 0.00142

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`=10345313)
3 0.00140 0.00047 0.00032 0.00069

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 = 10345313)
ORDER BY t.sort_order
3 0.00137 0.00046 0.00035 0.00062

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`=10345313)
6 0.00135 0.00023 0.00021 0.00025

SELECT COUNT(DISTINCT `t`.`id`)
FROM `re_networks_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`)
WHERE (t.network_id = '100001533' AND info.state = 'paid') AND (place.is_deleted = '0' AND place.status = '1')
2 0.00131 0.00065 0.00052 0.00078

SELECT COUNT(*) FROM (
SELECT `t`.`id` AS `t0_c0`, `t`.`place_id` AS `t0_c1`, `t`.`item_id` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`date_created` AS `t0_c4`, `t`.`date_answered` AS `t0_c5`, `t`.`text` AS `t0_c6`, `t`.`answer_author` AS `t0_c7`, `t`.`answer` AS `t0_c8`, `t`.`ip` AS `t0_c9`, `t`.`author` AS `t0_c10`, `t`.`phone` AS `t0_c11`, `t`.`email` AS `t0_c12`, `t`.`type` AS `t0_c13`, `t`.`like` AS `t0_c14`, `t`.`is_deleted` AS `t0_c15`, `t`.`is_send` AS `t0_c16`, `t`.`comment` AS `t0_c17`, `t`.`is_author_notified` AS `t0_c18`, `t`.`user_id` AS `t0_c19`, `t`.`is_answer_email` AS `t0_c20`, `t`.`source` AS `t0_c21`, `t`.`callback` AS `t0_c22`, `t`.`moderator_id` AS `t0_c23`, `t`.`date_status_first_changed` AS `t0_c24`, `t`.`disabled_reason` AS `t0_c25`, `t`.`feedback` AS `t0_c26`
FROM `re_place_review` `t`
LEFT OUTER JOIN `re_gallery` `gallery` ON (`t`.`item_id`=`gallery`.`id`) AND (t.type = 'gallery')
LEFT OUTER JOIN `re_photo` `photo` ON (`t`.`item_id`=`photo`.`id`) AND (t.type = 'photo')
LEFT OUTER JOIN `re_gallery` `photoGallery` ON (`photo`.`gallery_id`=`photoGallery`.`id`)
WHERE (((t.place_id = 10345323 AND t.status = '1' AND t.is_deleted = '0') AND (t.type = 'place' OR (t.type = 'gallery' AND gallery.status = '1' OR (t.type = 'photo' AND photo.status = '1' AND photoGallery.status = '1'))) AND (t.type='place')))
GROUP BY t.id) sq
1 0.00107 0.00107 0.00107 0.00107

SELECT *
FROM `re_worktime` `t`
WHERE t.place_id = 10345313
ORDER BY t.weekend, t.fulltime, t.start_time, t.end_time
3 0.00104 0.00035 0.00033 0.00038

SELECT *
FROM `re_place_info` `t`
WHERE `t`.`place_id`=10345313
LIMIT 1
3 0.00104 0.00035 0.00022 0.00049

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`=10345313)
3 0.00104 0.00035 0.00027 0.00041

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`, `freePersonalWidgetPaid`.`paid_place_id` AS `t1_c2`, `freePersonalWidgetPaid`.`id` AS `t1_c0`, `address`.`id` AS `t2_c0`, `address`.`place_id` AS `t2_c1`, `address`.`city_id` AS `t2_c2`, `address`.`country_id` AS `t2_c3`, `address`.`address` AS `t2_c4`, `address`.`building` AS `t2_c5`, `address`.`description` AS `t2_c6`, `address`.`metro_station_id` AS `t2_c7`, `address`.`hide_city` AS `t2_c8`, `address`.`handbook_address_id` AS `t2_c9`, `address`.`office` AS `t2_c10`, `address`.`type_of_office` AS `t2_c11`, `address`.`floor` AS `t2_c12`, `driveway`.`id` AS `t3_c0`, `driveway`.`address_id` AS `t3_c1`, `driveway`.`type` AS `t3_c2`, `driveway`.`coord_x` AS `t3_c3`, `driveway`.`coord_y` AS `t3_c4`, `driveway`.`coord_center_x` AS `t3_c5`, `driveway`.`coord_center_y` AS `t3_c6`, `driveway`.`zoom` AS `t3_c7`, `driveway`.`description` AS `t3_c8`, `driveway`.`description_driveway` AS `t3_c9`, `driveway`.`show_map` AS `t3_c10`, `driveway`.`map_image` AS `t3_c11`
FROM `re_place` `t`
LEFT OUTER JOIN `re_free_personal_widget` `freePersonalWidgetPaid` ON (`freePersonalWidgetPaid`.`paid_place_id`=`t`.`id`)
LEFT OUTER JOIN `re_address` `address` ON (`address`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_driveway` `driveway` ON (`driveway`.`address_id`=`address`.`id`)
WHERE (freePersonalWidgetPaid.option_id = '1011' AND freePersonalWidgetPaid.city_id = '1' AND freePersonalWidgetPaid.rubric_id = '555033' AND freePersonalWidgetPaid.free_place_id = '10345313')
1 0.00088 0.00088 0.00088 0.00088

SELECT `t`.`id` AS `t0_c0`, `catalogFilterOptionsPlaces`.`custom_value` AS `t1_c3`, `catalogFilterOptionsPlaces`.`id` AS `t1_c0`
FROM `re_catalog_filter_option` `t`
LEFT OUTER JOIN `re_catalog_filter_options_places` `catalogFilterOptionsPlaces` ON (`catalogFilterOptionsPlaces`.`option_id`=`t`.`id`)
WHERE (t.filter_id = 32 AND catalogFilterOptionsPlaces.place_id = 10345313 AND LENGTH(catalogFilterOptionsPlaces.custom_value) > 0)
2 0.00081 0.00040 0.00036 0.00045

SELECT *
FROM `re_place_contact` `t`
WHERE `t`.`place_id`=10345313
3 0.00080 0.00027 0.00018 0.00042

SELECT *
FROM `re_place` `t`
WHERE `t`.`id`=10345313
LIMIT 1
3 0.00075 0.00025 0.00022 0.00030

SELECT `t`.`date_created` AS `t0_c4`, `t`.`text` AS `t0_c6`, `t`.`answer` AS `t0_c8`, `t`.`author` AS `t0_c10`, `t`.`type` AS `t0_c13`, `t`.`like` AS `t0_c14`, `t`.`id` AS `t0_c0`, `place`.`id` AS `t1_c0`, `place`.`type` AS `t1_c4`, `info`.`url` AS `t2_c10`, `info`.`id` AS `t2_c0`, `address`.`hide_city` AS `t3_c8`, `address`.`address` AS `t3_c4`, `address`.`building` AS `t3_c5`, `address`.`floor` AS `t3_c12`, `address`.`office` AS `t3_c10`, `address`.`type_of_office` AS `t3_c11`, `address`.`id` AS `t3_c0`, `addressHandbook`.`title` AS `t4_c2`, `addressHandbook`.`id` AS `t4_c0`, `city`.`title` AS `t5_c1`, `city`.`type` AS `t5_c11`, `city`.`id` AS `t5_c0`, `gallery`.`id` AS `t6_c0`, `gallery`.`title` AS `t6_c2`, `photo`.`id` AS `t7_c0`, `photo`.`gallery_id` AS `t7_c2`, `photo`.`filename` AS `t7_c4`, `user`.`first_name` AS `t9_c3`, `user`.`last_name` AS `t9_c4`, `user`.`avatar` AS `t9_c9`, `user`.`organization_name` AS `t9_c5`, `user`.`type` AS `t9_c1`, `user`.`id` AS `t9_c0`
FROM `re_place_review` `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_address` `address` ON (`address`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_handbook_address` `addressHandbook` ON (`address`.`handbook_address_id`=`addressHandbook`.`id`)
LEFT OUTER JOIN `re_city` `city` ON (`address`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_gallery` `gallery` ON (`t`.`item_id`=`gallery`.`id`) AND (t.type = 'gallery')
LEFT OUTER JOIN `re_photo` `photo` ON (`t`.`item_id`=`photo`.`id`) AND (t.type = 'photo')
LEFT OUTER JOIN `re_gallery` `photoGallery` ON (`photo`.`gallery_id`=`photoGallery`.`id`)
LEFT OUTER JOIN `re_account_user` `user` ON (`t`.`user_id`=`user`.`id`)
WHERE ((((t.status = '1' AND t.is_deleted = '0') AND (t.place_id IN (10345313, 10345323, 10345343))) AND (t.type = 'place' OR (t.type = 'gallery' AND gallery.status = '1' OR (t.type = 'photo' AND photo.status = '1' AND photoGallery.status = '1'))) AND (t.type='place')))
ORDER BY t.date_created DESC
LIMIT 31
1 0.00075 0.00075 0.00075 0.00075

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`, `city`.`title` AS `t1_c1`, `city`.`id` AS `t1_c0`, `networkPlace`.`place_id` AS `t2_c2`, `networkPlace`.`id` AS `t2_c0`
FROM `re_networks_places_cities` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_networks_places` `networkPlace` ON (`t`.`network_place_id`=`networkPlace`.`id`)
WHERE (networkPlace.place_id IN (10345313, 10345323, 10345343))
ORDER BY city.sort_order, t.sort_order
1 0.00070 0.00070 0.00070 0.00070

SELECT COUNT(*) FROM (
SELECT `t`.`id` AS `t0_c0`, `t`.`place_id` AS `t0_c1`, `t`.`item_id` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`date_created` AS `t0_c4`, `t`.`date_answered` AS `t0_c5`, `t`.`text` AS `t0_c6`, `t`.`answer_author` AS `t0_c7`, `t`.`answer` AS `t0_c8`, `t`.`ip` AS `t0_c9`, `t`.`author` AS `t0_c10`, `t`.`phone` AS `t0_c11`, `t`.`email` AS `t0_c12`, `t`.`type` AS `t0_c13`, `t`.`like` AS `t0_c14`, `t`.`is_deleted` AS `t0_c15`, `t`.`is_send` AS `t0_c16`, `t`.`comment` AS `t0_c17`, `t`.`is_author_notified` AS `t0_c18`, `t`.`user_id` AS `t0_c19`, `t`.`is_answer_email` AS `t0_c20`, `t`.`source` AS `t0_c21`, `t`.`callback` AS `t0_c22`, `t`.`moderator_id` AS `t0_c23`, `t`.`date_status_first_changed` AS `t0_c24`, `t`.`disabled_reason` AS `t0_c25`, `t`.`feedback` AS `t0_c26`
FROM `re_place_review` `t`
LEFT OUTER JOIN `re_gallery` `gallery` ON (`t`.`item_id`=`gallery`.`id`) AND (t.type = 'gallery')
LEFT OUTER JOIN `re_photo` `photo` ON (`t`.`item_id`=`photo`.`id`) AND (t.type = 'photo')
LEFT OUTER JOIN `re_gallery` `photoGallery` ON (`photo`.`gallery_id`=`photoGallery`.`id`)
WHERE (((t.place_id = 10345323 AND t.status = '1' AND t.is_deleted = '0') AND (t.type = 'place' OR (t.type = 'gallery' AND gallery.status = '1' OR (t.type = 'photo' AND photo.status = '1' AND photoGallery.status = '1'))) AND (t.type='place') AND `like` = '1'))
GROUP BY t.id) sq
1 0.00068 0.00068 0.00068 0.00068

SELECT COUNT(*) FROM (
SELECT `t`.`id` AS `t0_c0`, `t`.`place_id` AS `t0_c1`, `t`.`item_id` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`date_created` AS `t0_c4`, `t`.`date_answered` AS `t0_c5`, `t`.`text` AS `t0_c6`, `t`.`answer_author` AS `t0_c7`, `t`.`answer` AS `t0_c8`, `t`.`ip` AS `t0_c9`, `t`.`author` AS `t0_c10`, `t`.`phone` AS `t0_c11`, `t`.`email` AS `t0_c12`, `t`.`type` AS `t0_c13`, `t`.`like` AS `t0_c14`, `t`.`is_deleted` AS `t0_c15`, `t`.`is_send` AS `t0_c16`, `t`.`comment` AS `t0_c17`, `t`.`is_author_notified` AS `t0_c18`, `t`.`user_id` AS `t0_c19`, `t`.`is_answer_email` AS `t0_c20`, `t`.`source` AS `t0_c21`, `t`.`callback` AS `t0_c22`, `t`.`moderator_id` AS `t0_c23`, `t`.`date_status_first_changed` AS `t0_c24`, `t`.`disabled_reason` AS `t0_c25`, `t`.`feedback` AS `t0_c26`
FROM `re_place_review` `t`
LEFT OUTER JOIN `re_gallery` `gallery` ON (`t`.`item_id`=`gallery`.`id`) AND (t.type = 'gallery')
LEFT OUTER JOIN `re_photo` `photo` ON (`t`.`item_id`=`photo`.`id`) AND (t.type = 'photo')
LEFT OUTER JOIN `re_gallery` `photoGallery` ON (`photo`.`gallery_id`=`photoGallery`.`id`)
WHERE (((t.place_id = 10345313 AND t.status = '1' AND t.is_deleted = '0') AND (t.type = 'place' OR (t.type = 'gallery' AND gallery.status = '1' OR (t.type = 'photo' AND photo.status = '1' AND photoGallery.status = '1'))) AND (t.type='place')))
GROUP BY t.id) sq
1 0.00067 0.00067 0.00067 0.00067

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`=10345343)
1 0.00066 0.00066 0.00066 0.00066

SELECT COUNT(*) FROM (
SELECT `t`.`id` AS `t0_c0`, `t`.`place_id` AS `t0_c1`, `t`.`item_id` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`date_created` AS `t0_c4`, `t`.`date_answered` AS `t0_c5`, `t`.`text` AS `t0_c6`, `t`.`answer_author` AS `t0_c7`, `t`.`answer` AS `t0_c8`, `t`.`ip` AS `t0_c9`, `t`.`author` AS `t0_c10`, `t`.`phone` AS `t0_c11`, `t`.`email` AS `t0_c12`, `t`.`type` AS `t0_c13`, `t`.`like` AS `t0_c14`, `t`.`is_deleted` AS `t0_c15`, `t`.`is_send` AS `t0_c16`, `t`.`comment` AS `t0_c17`, `t`.`is_author_notified` AS `t0_c18`, `t`.`user_id` AS `t0_c19`, `t`.`is_answer_email` AS `t0_c20`, `t`.`source` AS `t0_c21`, `t`.`callback` AS `t0_c22`, `t`.`moderator_id` AS `t0_c23`, `t`.`date_status_first_changed` AS `t0_c24`, `t`.`disabled_reason` AS `t0_c25`, `t`.`feedback` AS `t0_c26`
FROM `re_place_review` `t`
LEFT OUTER JOIN `re_gallery` `gallery` ON (`t`.`item_id`=`gallery`.`id`) AND (t.type = 'gallery')
LEFT OUTER JOIN `re_photo` `photo` ON (`t`.`item_id`=`photo`.`id`) AND (t.type = 'photo')
LEFT OUTER JOIN `re_gallery` `photoGallery` ON (`photo`.`gallery_id`=`photoGallery`.`id`)
WHERE (((t.place_id = 10345343 AND t.status = '1' AND t.is_deleted = '0') AND (t.type = 'place' OR (t.type = 'gallery' AND gallery.status = '1' OR (t.type = 'photo' AND photo.status = '1' AND photoGallery.status = '1'))) AND (t.type='place')))
GROUP BY t.id) sq
1 0.00065 0.00065 0.00065 0.00065

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`, `address`.`city_id` AS `t1_c2`, `address`.`address` AS `t1_c4`, `address`.`building` AS `t1_c5`, `address`.`floor` AS `t1_c12`, `address`.`type_of_office` AS `t1_c11`, `address`.`office` AS `t1_c10`, `address`.`id` AS `t1_c0`, `city`.`prepositional_title` AS `t2_c2`, `city`.`id` AS `t2_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`
FROM `re_place` `t`
LEFT OUTER JOIN `re_address` `address` ON (`address`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_city` `city` ON (`address`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`t`.`id`)
WHERE (`t`.`status`='1') AND (info.url = 'professor-bgmy')
1 0.00061 0.00061 0.00061 0.00061

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

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`
FROM `re_place` `t`
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`t`.`id`)
WHERE (`t`.`id`=10345323)
1 0.00060 0.00060 0.00060 0.00060

SELECT COUNT(*) FROM (
SELECT `t`.`id` AS `t0_c0`, `t`.`place_id` AS `t0_c1`, `t`.`item_id` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`date_created` AS `t0_c4`, `t`.`date_answered` AS `t0_c5`, `t`.`text` AS `t0_c6`, `t`.`answer_author` AS `t0_c7`, `t`.`answer` AS `t0_c8`, `t`.`ip` AS `t0_c9`, `t`.`author` AS `t0_c10`, `t`.`phone` AS `t0_c11`, `t`.`email` AS `t0_c12`, `t`.`type` AS `t0_c13`, `t`.`like` AS `t0_c14`, `t`.`is_deleted` AS `t0_c15`, `t`.`is_send` AS `t0_c16`, `t`.`comment` AS `t0_c17`, `t`.`is_author_notified` AS `t0_c18`, `t`.`user_id` AS `t0_c19`, `t`.`is_answer_email` AS `t0_c20`, `t`.`source` AS `t0_c21`, `t`.`callback` AS `t0_c22`, `t`.`moderator_id` AS `t0_c23`, `t`.`date_status_first_changed` AS `t0_c24`, `t`.`disabled_reason` AS `t0_c25`, `t`.`feedback` AS `t0_c26`
FROM `re_place_review` `t`
LEFT OUTER JOIN `re_gallery` `gallery` ON (`t`.`item_id`=`gallery`.`id`) AND (t.type = 'gallery')
LEFT OUTER JOIN `re_photo` `photo` ON (`t`.`item_id`=`photo`.`id`) AND (t.type = 'photo')
LEFT OUTER JOIN `re_gallery` `photoGallery` ON (`photo`.`gallery_id`=`photoGallery`.`id`)
WHERE (((t.place_id = 10345313 AND t.status = '1' AND t.is_deleted = '0') AND (t.type = 'place' OR (t.type = 'gallery' AND gallery.status = '1' OR (t.type = 'photo' AND photo.status = '1' AND photoGallery.status = '1'))) AND (t.type='place') AND `like` = '1'))
GROUP BY t.id) sq
1 0.00059 0.00059 0.00059 0.00059

SELECT `t`.`id` AS `t0_c0`, `t`.`is_main` AS `t0_c1`, `t`.`place_id` AS `t0_c2`, `t`.`rubric_id` AS `t0_c3`, `t`.`personal_place_page_id` AS `t0_c4`, `t`.`sales_description` AS `t0_c5`, `t`.`short_description` AS `t0_c6`, `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_places_rubrics` `t`
LEFT OUTER JOIN `re_rubric` `rubric` ON (`t`.`rubric_id`=`rubric`.`id`)
WHERE (status = '1' AND place_id = '10345313' AND is_main = '1')
1 0.00059 0.00059 0.00059 0.00059

SELECT `t`.`id` AS `t0_c0`, `t`.`is_main` AS `t0_c1`, `t`.`place_id` AS `t0_c2`, `t`.`rubric_id` AS `t0_c3`, `t`.`personal_place_page_id` AS `t0_c4`, `t`.`sales_description` AS `t0_c5`, `t`.`short_description` AS `t0_c6`, `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`, `templates`.`id` AS `t2_c0`, `templates`.`rubric_id` AS `t2_c1`, `templates`.`title` AS `t2_c2`, `templates`.`status` AS `t2_c3`, `templates`.`type` AS `t2_c4`, `templates`.`sellers_title` AS `t2_c5`, `templates`.`show_in_rubricator` AS `t2_c6`, `templates`.`show_robots` AS `t2_c7`, `templates`.`show_cities` AS `t2_c8`, `templates`.`enable_redirect_to_rubric` AS `t2_c9`, `templates`.`sort_order` AS `t2_c10`, `templates`.`is_main` AS `t2_c11`, `templates`.`show_as_catalog_list_tab` AS `t2_c12`, `templates`.`catalog_list_tab_color` AS `t2_c13`, `templates`.`products_list_default_view_type` AS `t2_c14`, `templates`.`show_count_filters` AS `t2_c15`, `templates`.`companies_list_view_type` AS `t2_c16`, `templates`.`default_sort_products` AS `t2_c17`, `templates`.`show_rubric_in_product_title` AS `t2_c18`, `templates`.`page_url_prefix` AS `t2_c19`, `templates`.`page_logic_type` AS `t2_c20`, `templates`.`page_view_type` AS `t2_c21`, `templates`.`page_seo_default_template_type` AS `t2_c22`, `templates`.`show_city_in_sellers_count` AS `t2_c23`, `templates`.`product_alternative_title` AS `t2_c24`, `templates`.`product_alternative_title_nominative` AS `t2_c25`, `templates`.`product_alternative_title_singular_accusative` AS `t2_c26`, `templates`.`product_alternative_title_plural_accusative` AS `t2_c27`, `templates`.`image_filename` AS `t2_c28`, `templates`.`show_products_without_sellers` AS `t2_c29`, `templates`.`noindex_products` AS `t2_c30`, `templates`.`show_compact_image` AS `t2_c31`
FROM `re_places_rubrics` `t`
LEFT OUTER JOIN `re_rubric` `rubric` ON (`t`.`rubric_id`=`rubric`.`id`)
LEFT OUTER JOIN `re_rubric_template` `templates` ON (`templates`.`rubric_id`=`rubric`.`id`)
WHERE (t.place_id = 10345313 AND templates.status = '1')
1 0.00055 0.00055 0.00055 0.00055

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`, `city`.`title` AS `t1_c1`, `city`.`id` AS `t1_c0`, `networkPlace`.`place_id` AS `t2_c2`, `networkPlace`.`id` AS `t2_c0`
FROM `re_networks_places_cities` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_networks_places` `networkPlace` ON (`t`.`network_place_id`=`networkPlace`.`id`)
WHERE (networkPlace.place_id IN (10345313, 10345323, 10345343))
ORDER BY city.sort_order, t.sort_order
1 0.00054 0.00054 0.00054 0.00054

SELECT `t`.`id` AS `t0_c0`, `t`.`title` AS `t0_c1`, `t`.`personal_controller_action_id` AS `t0_c2`, `controllerAction`.`name_id` AS `t1_c1`, `controllerAction`.`page_type` AS `t1_c3`, `controllerAction`.`id` AS `t1_c0`, `controller`.`name_id` AS `t2_c1`, `controller`.`id` AS `t2_c0`
FROM `re_personal_place_page` `t`
LEFT OUTER JOIN `re_personal_controller_action` `controllerAction` ON (`t`.`personal_controller_action_id`=`controllerAction`.`id`)
LEFT OUTER JOIN `re_personal_controller_model` `controller` ON (`controllerAction`.`personal_controller_id`=`controller`.`id`
WHERE ((controllerAction.name_id = 'index' AND controller.name_id = 'about' AND t.status = '1') AND t.place_id = '10345313') AND (t.url IS NULL))
1 0.00054 0.00054 0.00054 0.00054

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`, `templates`.`id` AS `t1_c0`, `templates`.`type` AS `t1_c4`, `templates`.`rubric_id` AS `t1_c1`, `templates`.`page_url_prefix` AS `t1_c19`, `templates`.`page_logic_type` AS `t1_c20`
FROM `re_rubric` `t`
LEFT OUTER JOIN `re_rubric_template` `templates` ON (`templates`.`rubric_id`=`t`.`id`)
WHERE (t.status = '1' AND t.id = '555033' AND templates.status = '1')
ORDER BY (templates.page_logic_type = 'products_list_default') DESC, templates.sort_order ASC
1 0.00054 0.00054 0.00054 0.00054

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`, `city`.`title` AS `t1_c1`, `city`.`id` AS `t1_c0`, `networkPlace`.`place_id` AS `t2_c2`, `networkPlace`.`id` AS `t2_c0`
FROM `re_networks_places_cities` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_networks_places` `networkPlace` ON (`t`.`network_place_id`=`networkPlace`.`id`)
WHERE (networkPlace.place_id IN (10345313, 10345323, 10345343))
ORDER BY city.sort_order, t.sort_order
1 0.00053 0.00053 0.00053 0.00053

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`
FROM `re_place` `t`
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`t`.`id`)
WHERE (`t`.`id`=10345313)
1 0.00053 0.00053 0.00053 0.00053

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`=10345323)
1 0.00052 0.00052 0.00052 0.00052

SELECT `t`.`id` AS `t0_c0`, `t`.`title` AS `t0_c1`, `t`.`place_id` AS `t0_c3`, `t`.`url` AS `t0_c4`, `place`.`id` AS `t1_c0`, `info`.`url` AS `t2_c10`, `info`.`id` AS `t2_c0`, `controllerAction`.`name_id` AS `t3_c1`, `controllerAction`.`page_type` AS `t3_c3`, `controllerAction`.`id` AS `t3_c0`, `controller`.`name_id` AS `t4_c1`, `controller`.`id` AS `t4_c0`
FROM `re_personal_place_page` `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_personal_controller_action` `controllerAction` ON (`t`.`personal_controller_action_id`=`controllerAction`.`id`)
LEFT OUTER JOIN `re_personal_controller_model` `controller` ON (`controllerAction`.`personal_controller_id`=`controller`.`id`)
WHERE (t.status = '1' AND t.place_id = '10345313') AND (controllerAction.page_type IS NOT NULL)
ORDER BY t.sort_order IS NULL, t.sort_order
1 0.00051 0.00051 0.00051 0.00051

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`, `city`.`title` AS `t1_c1`, `city`.`id` AS `t1_c0`, `networkPlace`.`place_id` AS `t2_c2`, `networkPlace`.`id` AS `t2_c0`
FROM `re_networks_places_cities` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_networks_places` `networkPlace` ON (`t`.`network_place_id`=`networkPlace`.`id`)
WHERE (networkPlace.place_id IN (10345313, 10345323, 10345343))
ORDER BY city.sort_order, t.sort_order
1 0.00050 0.00050 0.00050 0.00050

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`, `city`.`title` AS `t1_c1`, `city`.`id` AS `t1_c0`, `networkPlace`.`place_id` AS `t2_c2`, `networkPlace`.`id` AS `t2_c0`
FROM `re_networks_places_cities` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_networks_places` `networkPlace` ON (`t`.`network_place_id`=`networkPlace`.`id`)
WHERE (networkPlace.place_id IN (10345313, 10345323, 10345343))
ORDER BY city.sort_order, t.sort_order
1 0.00049 0.00049 0.00049 0.00049

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`=10345313)
1 0.00049 0.00049 0.00049 0.00049

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`, `city`.`title` AS `t1_c1`, `city`.`id` AS `t1_c0`, `networkPlace`.`place_id` AS `t2_c2`, `networkPlace`.`id` AS `t2_c0`
FROM `re_networks_places_cities` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_networks_places` `networkPlace` ON (`t`.`network_place_id`=`networkPlace`.`id`)
WHERE (networkPlace.place_id IN (10345313, 10345323, 10345343))
ORDER BY city.sort_order, t.sort_order
1 0.00048 0.00048 0.00048 0.00048

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`, `city`.`title` AS `t1_c1`, `city`.`id` AS `t1_c0`, `networkPlace`.`place_id` AS `t2_c2`, `networkPlace`.`id` AS `t2_c0`
FROM `re_networks_places_cities` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_networks_places` `networkPlace` ON (`t`.`network_place_id`=`networkPlace`.`id`)
WHERE (networkPlace.place_id IN (10345313, 10345323, 10345343))
ORDER BY city.sort_order, t.sort_order
1 0.00044 0.00044 0.00044 0.00044

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`, `city`.`title` AS `t1_c1`, `city`.`id` AS `t1_c0`, `networkPlace`.`place_id` AS `t2_c2`, `networkPlace`.`id` AS `t2_c0`
FROM `re_networks_places_cities` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_networks_places` `networkPlace` ON (`t`.`network_place_id`=`networkPlace`.`id`)
WHERE (networkPlace.place_id IN (10345313, 10345323, 10345343))
ORDER BY city.sort_order, t.sort_order
1 0.00044 0.00044 0.00044 0.00044

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`, `city`.`title` AS `t1_c1`, `city`.`id` AS `t1_c0`, `networkPlace`.`place_id` AS `t2_c2`, `networkPlace`.`id` AS `t2_c0`
FROM `re_networks_places_cities` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_networks_places` `networkPlace` ON (`t`.`network_place_id`=`networkPlace`.`id`)
WHERE (networkPlace.place_id IN (10345313, 10345323, 10345343))
ORDER BY city.sort_order, t.sort_order
1 0.00043 0.00043 0.00043 0.00043

SELECT `t`.`id` AS `t0_c0`, `t`.`network_place_id` AS `t0_c1`, `t`.`city_id` AS `t0_c2`, `t`.`sort_order` AS `t0_c3`, `t`.`is_main` AS `t0_c4`, `city`.`title` AS `t1_c1`, `city`.`id` AS `t1_c0`, `networkPlace`.`place_id` AS `t2_c2`, `networkPlace`.`id` AS `t2_c0`
FROM `re_networks_places_cities` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_networks_places` `networkPlace` ON (`t`.`network_place_id`=`networkPlace`.`id`)
WHERE (networkPlace.place_id IN (10345313, 10345323, 10345343))
ORDER BY city.sort_order, t.sort_order
1 0.00043 0.00043 0.00043 0.00043

SELECT *
FROM `re_personal_place_page_seo` `t`
WHERE `t`.`personal_place_page_id`='198913'
LIMIT 1
2 0.00041 0.00020 0.00017 0.00023

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`=10345343)
1 0.00041 0.00041 0.00041 0.00041

SELECT *
FROM `re_place_button` `t`
WHERE t.status = '1' AND t.place_id = '10345313'
ORDER BY t.sort_order
1 0.00040 0.00040 0.00040 0.00040

SELECT `t`.`address` AS `t0_c4`, `t`.`type_of_office` AS `t0_c11`, `t`.`office` AS `t0_c10`, `t`.`building` AS `t0_c5`, `t`.`floor` AS `t0_c12`, `t`.`hide_city` AS `t0_c8`, `t`.`id` AS `t0_c0`, `driveway`.`type` AS `t1_c2`, `driveway`.`show_map` AS `t1_c10`, `driveway`.`map_image` AS `t1_c11`, `driveway`.`coord_x` AS `t1_c3`, `driveway`.`coord_y` AS `t1_c4`, `driveway`.`id` AS `t1_c0`, `city`.`title` AS `t2_c1`, `city`.`type` AS `t2_c11`, `city`.`id` AS `t2_c0`, `addressHandbook`.`title` AS `t3_c2`, `addressHandbook`.`id` AS `t3_c0`
FROM `re_address` `t`
LEFT OUTER JOIN `re_driveway` `driveway` ON (`driveway`.`address_id`=`t`.`id`)
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_handbook_address` `addressHandbook` ON (`t`.`handbook_address_id`=`addressHandbook`.`id`)
WHERE (t.place_id = 10345313)
GROUP BY t.id
1 0.00040 0.00040 0.00040 0.00040

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`=10345313)
1 0.00038 0.00038 0.00038 0.00038

SELECT `t`.`city_id` AS `t0_c2`, `t`.`id` AS `t0_c0`, `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_places_cities` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
WHERE (`t`.`place_id`='10345313')
1 0.00037 0.00037 0.00037 0.00037

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`
FROM `re_place` `t`
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`t`.`id`)
WHERE (`t`.`id`=10345343)
1 0.00033 0.00033 0.00033 0.00033

SELECT COUNT(*)
FROM `re_rubric_template` `t`
1 0.00033 0.00033 0.00033 0.00033

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`, `addressHandbook`.`id` AS `t2_c0`, `addressHandbook`.`city_id` AS `t2_c1`, `addressHandbook`.`title` AS `t2_c2`, `addressHandbook`.`street` AS `t2_c3`, `addressHandbook`.`house` AS `t2_c4`
FROM `re_address` `t`
LEFT OUTER JOIN `re_city` `city` ON (`t`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_handbook_address` `addressHandbook` ON (`t`.`handbook_address_id`=`addressHandbook`.`id`)
WHERE (`t`.`place_id`='10345313')
1 0.00031 0.00031 0.00031 0.00031

SELECT `t`.`place_id` AS `t0_c2`, `t`.`id` AS `t0_c0`
FROM `re_networks_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`)
WHERE (t.network_id = '100001533') AND (place.is_deleted = '0' AND place.status = '1') AND (info.state != 'close')
1 0.00030 0.00030 0.00030 0.00030

SELECT `t`.`phone_code` AS `t0_c3`, `t`.`phone` AS `t0_c4`, `t`.`id` AS `t0_c0`, `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 = 10345313)
ORDER BY t.sort_order
1 0.00030 0.00030 0.00030 0.00030

SELECT `t`.`id` AS `t0_c0`, `info`.`title` AS `t1_c3`, `info`.`text_type` AS `t1_c17`, `info`.`id` AS `t1_c0`, `address`.`id` AS `t2_c0`, `address`.`address` AS `t2_c4`, `address`.`building` AS `t2_c5`, `city`.`title` AS `t3_c1`, `city`.`prepositional_title` AS `t3_c2`, `city`.`id` AS `t3_c0`
FROM `re_place` `t`
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_address` `address` ON (`address`.`place_id`=`t`.`id`)
LEFT OUTER JOIN `re_city` `city` ON (`address`.`city_id`=`city`.`id`)
WHERE (`t`.`id`=10345313)
1 0.00029 0.00029 0.00029 0.00029

SELECT t.value
FROM `re_catalog_filter_option_range` `t`
WHERE t.filter_id = 1123 AND t.place_id = 10345313
GROUP BY t.id
LIMIT 1
1 0.00027 0.00027 0.00027 0.00027

SELECT `t`.`id` AS `t0_c0`, `controllerAction`.`page_type` AS `t1_c3`, `controllerAction`.`id` AS `t1_c0`
FROM `re_personal_place_page` `t`
LEFT OUTER JOIN `re_personal_controller_action` `controllerAction` ON (`t`.`personal_controller_action_id`=`controllerAction`.`id`)
WHERE (`t`.`id`=838143)
1 0.00023 0.00023 0.00023 0.00023

SELECT *
FROM `re_worktime` `t`
WHERE place_id = 10345313
1 0.00022 0.00022 0.00022 0.00022

SELECT `personalPlacePage`.`id` AS `t1_c0`, `personalPlacePage`.`title` AS `t1_c1`, `personalPlacePage`.`personal_controller_action_id` AS `t1_c2`, `personalPlacePage`.`place_id` AS `t1_c3`, `personalPlacePage`.`url` AS `t1_c4`, `personalPlacePage`.`status` AS `t1_c5`, `personalPlacePage`.`sort_order` AS `t1_c6`
FROM `re_personal_place_page` `personalPlacePage`
WHERE (`personalPlacePage`.`id`='198913')
1 0.00021 0.00021 0.00021 0.00021

SELECT `settingsAbout`.`id` AS `t1_c0`, `settingsAbout`.`page_id` AS `t1_c1`, `settingsAbout`.`article_noindex` AS `t1_c2`, `settingsAbout`.`red_style_tab` AS `t1_c3`
FROM `re_personal_place_about_page_settings` `settingsAbout`
WHERE (`settingsAbout`.`page_id`='198913')
1 0.00020 0.00020 0.00020 0.00020

SELECT t.site, t.site_in_nofollow
FROM `re_place_info` `t`
WHERE t.place_id = 10345313 AND t.state = 'paid'
LIMIT 1
1 0.00018 0.00018 0.00018 0.00018

SELECT `settingsContacts`.`id` AS `t1_c0`, `settingsContacts`.`page_id` AS `t1_c1`, `settingsContacts`.`red_style_tab` AS `t1_c2`
FROM `re_personal_place_contacts_page_settings` `settingsContacts`
WHERE (`settingsContacts`.`page_id`='838143')
1 0.00018 0.00018 0.00018 0.00018