Я ищу в на

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

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

Общий отчет (Время: 0.15979с, Память: 12,175Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
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.00366 0.00122 0.00097 0.00144
system.db.CDbCommand.query(SELECT * FROM `tbl_city` `t` WHERE count_hotels > 0) 1 0.00236 0.00236 0.00236 0.00236
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_hotels`) 1 0.00135 0.00135 0.00135 0.00135
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_map`) 1 0.00133 0.00133 0.00133 0.00133
system.db.CDbCommand.query(SELECT * FROM `tbl_city` `t` WHERE count_hotels > 0 ORDER BY city_name) 1 0.00125 0.00125 0.00125 0.00125
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_hoteltypes`) 1 0.00121 0.00121 0.00121 0.00121
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_nature`) 1 0.00111 0.00111 0.00111 0.00111
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_users`) 1 0.00111 0.00111 0.00111 0.00111
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_city`) 1 0.00108 0.00108 0.00108 0.00108
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.00104 0.00104 0.00104 0.00104
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_options`) 1 0.00098 0.00098 0.00098 0.00098
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_sights`) 1 0.00097 0.00097 0.00097 0.00097
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_naturetypes`) 1 0.00092 0.00092 0.00092 0.00092
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_sighttypes`) 1 0.00088 0.00088 0.00088 0.00088
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.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 3 LIMIT 1) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 5 LIMIT 1) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SELECT * FROM `tbl_hotels` `t`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 2 LIMIT 1) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 6 LIMIT 1) 1 0.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 7 LIMIT 1) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_hotels`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SELECT * FROM `tbl_options` `t`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_users`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_hoteltypes`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_naturetypes`) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_options`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_city`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_sights`) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_nature`) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_map`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_sighttypes`) 1 0.00018 0.00018 0.00018 0.00018