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

Фейерверки «Эйфория»

(29) 5663985 - фирма закрылась, человек, который занимался этим куда-то уехал

Время: 1.2 с. Память: 5,513Кб, Запросы к БД: 21. Запросы к КЭШу: 92.
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)

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

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 = '10137022' AND is_main = '1')
1 0.00110 0.00110 0.00110 0.00110

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 = 'eforija')
1 0.00096 0.00096 0.00096 0.00096

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 = '10137022') AND (t.url IS NULL))
1 0.00091 0.00091 0.00091 0.00091

SELECT `t`.`title_in_personal_footer` AS `t0_c16`, `t`.`option_id` AS `t0_c1`, `t`.`id` AS `t0_c0`, `rubricTemplatesFilters`.`id` AS `t1_c0`, `catalogFilterOptionsRubricTemplates`.`url` AS `t3_c3`, `catalogFilterOptionsRubricTemplates`.`option_id` AS `t3_c2`, `catalogFilterOptionsRubricTemplates`.`id` AS `t3_c0`
FROM `re_catalog_filter_option_seo` `t`
LEFT OUTER JOIN `re_catalog_filters_rubric_templates` `rubricTemplatesFilters` ON (`t`.`rubric_templates_filters_id`=`rubricTemplatesFilters`.`id`)
LEFT OUTER JOIN `re_catalog_filter` `filter` ON (`rubricTemplatesFilters`.`filter_id`=`filter`.`id`)
LEFT OUTER JOIN `re_catalog_filter_options_rubric_templates` `catalogFilterOptionsRubricTemplates` ON (`catalogFilterOptionsRubricTemplates`.`rubric_templates_filters_id`=`rubricTemplatesFilters`.`id` AND catalogFilterOptionsRubricTemplates.option_id = t.option_id
WHERE ( city_id = '1' AND rubricTemplatesFilters.template_id = '51050' AND rubricTemplatesFilters.status = '1' AND filter.status = '1' AND catalogFilterOptionsRubricTemplates.url != "" AND t.show_in_personal_footer = '1') )
1 0.00086 0.00086 0.00086 0.00086

SELECT `t`.`id` AS `t0_c0`, `t`.`type` AS `t0_c2`, `catalogProductFiltersRubricTemplates`.`id` AS `t1_c0`, `catalogProductFilterBrandSeo`.`brand_id` AS `t2_c1`, `catalogProductFilterBrandSeo`.`title_in_personal_footer` AS `t2_c15`, `catalogProductFilterBrandSeo`.`id` AS `t2_c0`, `brand`.`url` AS `t3_c4`, `brand`.`id` AS `t3_c0`, `catalogProductFilterOptionSeo`.`option_id` AS `t4_c1`, `catalogProductFilterOptionSeo`.`title_in_personal_footer` AS `t4_c17`, `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.city_id = '1' OR catalogProductFilterBrandSeo.city_id = '1') AND catalogProductFiltersRubricTemplates.template_id = '10329225' AND catalogProductFiltersRubricTemplates.status = '1' AND t.status = '1' AND (catalogProductFilterOptionsRubricTemplates.url != "" OR brand.url != "") AND catalogProductFilterOptionSeo.show_in_personal_footer = '1') )
ORDER BY catalogProductFiltersRubricTemplates.sort_order, option.sort_order
1 0.00080 0.00080 0.00080 0.00080

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 = '51050' AND templates.status = '1')
ORDER BY (templates.page_logic_type = 'products_list_default') DESC, templates.sort_order ASC
1 0.00056 0.00056 0.00056 0.00056

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 (t.show_in_select = '1') AND productsRubricsSort.rubric_id = '51050')
GROUP BY t.id
ORDER BY IF (t.is_regional = '1', t.sort_order, t.title)
1 0.00055 0.00055 0.00055 0.00055

SELECT *
FROM `re_rubric_template` `t`
WHERE `t`.`status`='1' AND `t`.`rubric_id`='51050' AND `t`.`is_main`='1'
LIMIT 1
1 0.00044 0.00044 0.00044 0.00044

SELECT `t`.`id` AS `t0_c0`, `t`.`section_id` AS `t0_c1`, `t`.`rubric_id` AS `t0_c2`, `t`.`is_main` AS `t0_c3`, `section`.`id` AS `t1_c0`, `section`.`title` AS `t1_c1`, `section`.`keywords` AS `t1_c2`, `section`.`url` AS `t1_c3`, `section`.`status` AS `t1_c4`, `section`.`has_top_banner` AS `t1_c5`, `section`.`sort_order` AS `t1_c6`, `section`.`singular_title` AS `t1_c7`, `section`.`is_show_page_section` AS `t1_c8`
FROM `re_sections_rubrics` `t`
LEFT OUTER JOIN `re_section` `section` ON (`t`.`section_id`=`section`.`id`)
WHERE (status = '1' AND rubric_id = '51050' AND is_main = '1')
1 0.00039 0.00039 0.00039 0.00039

SELECT *
FROM `re_personal_place_page_seo` `t`
WHERE `t`.`personal_place_page_id`='70832'
LIMIT 1
2 0.00038 0.00019 0.00016 0.00021

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

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`=10137022)
1 0.00032 0.00032 0.00032 0.00032

SELECT *
FROM `re_rubric_place_page_seo_template` `t`
WHERE `t`.`rubric_id`='51050' AND `t`.`personal_controller_action_id`='1'
LIMIT 1
1 0.00029 0.00029 0.00029 0.00029

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 = '10137022' AND show_map = '1')
1 0.00027 0.00027 0.00027 0.00027

SELECT *
FROM `re_rubric_review_options` `t`
WHERE `t`.`rubric_id`='51050'
LIMIT 1
1 0.00025 0.00025 0.00025 0.00025

SELECT *
FROM `re_personal_controller_action` `t`
WHERE `t`.`id`=1
LIMIT 1
1 0.00024 0.00024 0.00024 0.00024

SELECT *
FROM `re_rubric_personal_footer_settings` `t`
WHERE `t`.`rubric_id`='51050'
LIMIT 1
1 0.00023 0.00023 0.00023 0.00023

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`='70832')
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`='70832')
1 0.00018 0.00018 0.00018 0.00018