Я ищу в на

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

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

Общий отчет (Время: 0.13461с, Память: 12,176Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
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.00292 0.00097 0.00082 0.00107
system.db.CDbCommand.query(SELECT * FROM `tbl_city` `t` WHERE count_hotels > 0) 1 0.00210 0.00210 0.00210 0.00210
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_hotels`) 1 0.00141 0.00141 0.00141 0.00141
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_city`) 1 0.00121 0.00121 0.00121 0.00121
system.db.CDbCommand.query(SELECT * FROM `tbl_city` `t` WHERE count_hotels > 0 ORDER BY city_name) 1 0.00115 0.00115 0.00115 0.00115
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_users`) 1 0.00094 0.00094 0.00094 0.00094
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_hoteltypes`) 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_options`) 1 0.00085 0.00085 0.00085 0.00085
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.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_map`) 1 0.00070 0.00070 0.00070 0.00070
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_sights`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_nature`) 1 0.00068 0.00068 0.00068 0.00068
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.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_naturetypes`) 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_sighttypes`) 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 3 LIMIT 1) 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 5 LIMIT 1) 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 2 LIMIT 1) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 7 LIMIT 1) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SELECT * FROM `tbl_map` `t` WHERE owner_name = 'Hotels' AND owner_id = 6 LIMIT 1) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_city`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `tbl_hotels` `t`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT * FROM `tbl_options` `t`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_users`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_naturetypes`) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_hotels`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_nature`) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_sights`) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_hoteltypes`) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_options`) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_map`) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_sighttypes`) 1 0.00016 0.00016 0.00016 0.00016