Я ищу в на

Список типов объектов размещения

Список городов

Общий отчет (Время: 0.31300с, Память: 12,175Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_map`) 1 0.00726 0.00726 0.00726 0.00726
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`altname` AS `t0_c2`, `t`.`description` AS `t0_c3`, `t`.`level` AS `t0_c4`, `t`.`ownTerritory` AS `t0_c5`, `t`.`severalBuildings` AS `t0_c6`, `t`.`severalRooms` AS `t0_c7`, `Hotels`.`id` AS `t1_c0`, `Hotels`.`user_id` AS `t1_c1`, `Hotels`.`title` AS `t1_c2`, `Hotels`.`url` AS `t1_c3`, `Hotels`.`anons` AS `t1_c4`, `Hotels`.`text` AS `t1_c5`, `Hotels`.`create_time` AS `t1_c6`, `Hotels`.`update_time` AS `t1_c7`, `Hotels`.`status` AS `t1_c8`, `Hotels`.`city_id` AS `t1_c9`, `Hotels`.`street` AS `t1_c10`, `Hotels`.`count_views` AS `t1_c11`, `Hotels`.`count_rooms` AS `t1_c12`, `Hotels`.`hoteltype_id` AS `t1_c13` FROM `tbl_hoteltypes` `t` RIGHT JOIN `tbl_hotels` `Hotels` ON (`Hotels`.`hoteltype_id`=`t`.`id`) ORDER BY level) 3 0.00528 0.00176 0.00139 0.00236
system.db.CDbCommand.query(SELECT * FROM `tbl_city` `t` WHERE count_hotels > 0) 1 0.00360 0.00360 0.00360 0.00360
system.db.CDbCommand.query(SELECT * FROM `tbl_city` `t` WHERE count_hotels > 0 ORDER BY city_name) 1 0.00297 0.00297 0.00297 0.00297
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_sighttypes`) 1 0.00290 0.00290 0.00290 0.00290
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_city`) 1 0.00271 0.00271 0.00271 0.00271
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_users`) 1 0.00242 0.00242 0.00242 0.00242
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_hotels`) 1 0.00177 0.00177 0.00177 0.00177
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_nature`) 1 0.00156 0.00156 0.00156 0.00156
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_sights`) 1 0.00150 0.00150 0.00150 0.00150
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`level` AS `t0_c2`, `Sights`.`id` AS `t1_c0`, `Sights`.`user_id` AS `t1_c1`, `Sights`.`title` AS `t1_c2`, `Sights`.`url` AS `t1_c3`, `Sights`.`anons` AS `t1_c4`, `Sights`.`text` AS `t1_c5`, `Sights`.`create_time` AS `t1_c6`, `Sights`.`update_time` AS `t1_c7`, `Sights`.`status` AS `t1_c8`, `Sights`.`city_id` AS `t1_c9`, `Sights`.`street` AS `t1_c10`, `Sights`.`count_views` AS `t1_c11`, `Sights`.`sighttype_id` AS `t1_c12` FROM `tbl_sighttypes` `t` RIGHT JOIN `tbl_sights` `Sights` ON (`Sights`.`sighttype_id`=`t`.`id`) ORDER BY level) 1 0.00138 0.00138 0.00138 0.00138
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_hoteltypes`) 1 0.00137 0.00137 0.00137 0.00137
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`level` AS `t0_c2`, `Nature`.`id` AS `t1_c0`, `Nature`.`user_id` AS `t1_c1`, `Nature`.`title` AS `t1_c2`, `Nature`.`url` AS `t1_c3`, `Nature`.`anons` AS `t1_c4`, `Nature`.`text` AS `t1_c5`, `Nature`.`create_time` AS `t1_c6`, `Nature`.`update_time` AS `t1_c7`, `Nature`.`status` AS `t1_c8`, `Nature`.`city_id` AS `t1_c9`, `Nature`.`street` AS `t1_c10`, `Nature`.`count_views` AS `t1_c11`, `Nature`.`naturetype_id` AS `t1_c12` FROM `tbl_naturetypes` `t` RIGHT JOIN `tbl_nature` `Nature` ON (`Nature`.`naturetype_id`=`t`.`id`) ORDER BY level) 1 0.00122 0.00122 0.00122 0.00122
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_options`) 1 0.00114 0.00114 0.00114 0.00114
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_naturetypes`) 1 0.00114 0.00114 0.00114 0.00114
system.db.CDbCommand.query(SELECT * FROM `tbl_hotels` `t`) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_users`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 2 LIMIT 1) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 3 LIMIT 1) 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_city`) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_hotels`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 7 LIMIT 1) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_sights`) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_nature`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_sighttypes`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 6 LIMIT 1) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_hoteltypes`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_map`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM `tbl_options` `t`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 5 LIMIT 1) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_naturetypes`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_options`) 1 0.00020 0.00020 0.00020 0.00020