


To view Cookies, add CookieComponent to Controller
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `properties` | 23 | 23 | 2 | |
| 2 | DESCRIBE `users` | 16 | 16 | 2 | |
| 3 | DESCRIBE `agencies` | 8 | 8 | 2 | |
| 4 | DESCRIBE `countries` | 3 | 3 | 1 | |
| 5 | DESCRIBE `states` | 3 | 3 | 1 | |
| 6 | DESCRIBE `cities` | 4 | 4 | 1 | |
| 7 | DESCRIBE `property_images` | 5 | 5 | 1 | |
| 8 | DESCRIBE `options` | 3 | 3 | 1 | |
| 9 | SELECT `Option`.`id`, `Option`.`name`, `Option`.`value` FROM `options` AS `Option` WHERE `name` = 'VisitorsCounter' LIMIT 1 | 1 | 1 | 2 | |
| 10 | SELECT `Property`.`id`, `Property`.`user_id`, `Property`.`created`, `Property`.`code`, `Property`.`title`, `Property`.`description`, `Property`.`price`, `Property`.`beds`, `Property`.`type`, `Property`.`built_area`, `Property`.`total_area`, `Property`.`constructed_year`, `Property`.`country_id`, `Property`.`state_id`, `Property`.`city_id`, `Property`.`state`, `Property`.`city`, `Property`.`zone`, `Property`.`sections`, `Property`.`highlight`, `Property`.`status`, `Property`.`status_description`, `Property`.`expires`, `User`.`id`, `User`.`password`, `User`.`created`, `User`.`lastlogin`, `User`.`updated`, `User`.`firstname`, `User`.`surname`, `User`.`address`, `User`.`email`, `User`.`telephone`, `User`.`mobile`, `User`.`fax`, `User`.`url`, `User`.`status`, `User`.`planchoice`, `User`.`role`, `Country`.`ccode`, `Country`.`name_en`, `Country`.`id`, `State`.`id`, `State`.`name_en`, `State`.`country_id`, `City`.`id`, `City`.`name_en`, `City`.`state_id`, `City`.`country_id` FROM `properties` AS `Property` LEFT JOIN `users` AS `User` ON (`Property`.`user_id` = `User`.`id`) LEFT JOIN `countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Property`.`state_id` = `State`.`id`) LEFT JOIN `cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) WHERE `Property`.`id` = 49 LIMIT 1 | 1 | 1 | 6 | |
| 11 | SELECT `PropertyImage`.`id`, `PropertyImage`.`property_id`, `PropertyImage`.`image`, `PropertyImage`.`description`, `PropertyImage`.`principal` FROM `property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = (49) | 1 | 1 | 1 |
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | query |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Option | ref | name | name | 194 | const | 1 | Using where | SELECT `Option`.`id`, `Option`.`name`, `Option`.`value` FROM `options` AS `Option` WHERE `name` = 'VisitorsCounter' LIMIT 1 |
| 1 | SIMPLE | Property | const | PRIMARY | PRIMARY | 4 | const | 1 | SELECT `Property`.`id`, `Property`.`user_id`, `Property`.`created`, `Property`.`code`, `Property`.`title`, `Property`.`description`, `Property`.`price`, `Property`.`beds`, `Property`.`type`, `Property`.`built_area`, `Property`.`total_area`, `Property`.`constructed_year`, `Property`.`country_id`, `Property`.`state_id`, `Property`.`city_id`, `Property`.`state`, `Property`.`city`, `Property`.`zone`, `Property`.`sections`, `Property`.`highlight`, `Property`.`status`, `Property`.`status_description`, `Property`.`expires`, `User`.`id`, `User`.`password`, `User`.`created`, `User`.`lastlogin`, `User`.`updated`, `User`.`firstname`, `User`.`surname`, `User`.`address`, `User`.`email`, `User`.`telephone`, `User`.`mobile`, `User`.`fax`, `User`.`url`, `User`.`status`, `User`.`planchoice`, `User`.`role`, `Country`.`ccode`, `Country`.`name_en`, `Country`.`id`, `State`.`id`, `State`.`name_en`, `State`.`country_id`, `City`.`id`, `City`.`name_en`, `City`.`state_id`, `City`.`country_id` FROM `properties` AS `Property` LEFT JOIN `users` AS `User` ON (`Property`.`user_id` = `User`.`id`) LEFT JOIN `countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Property`.`state_id` = `State`.`id`) LEFT JOIN `cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) WHERE `Property`.`id` = 49 LIMIT 1 |
Current Memory Use 8.11 MB
Peak Memory Use 18.65 MB
Total Request Time: 2.448336 (seconds)
| Message | Time in seconds | Graph |
|---|---|---|
| Component initialization and startup | 0.006690 | |
| Controller Action | 0.037760 | |
| Render Controller Action | 0.158210 | |
| Rendering View | 0.157480 | |
| Rendering APP/views/properties/detail.ctp | 0.067700 | |
| Rendering APP/views/elements/properties/images.ctp | 0.014500 | |
| Rendering APP/views/layouts/property.ctp | 0.088430 | |
| Rendering APP/views/elements/metatags.ctp | 0.000200 | |
| Rendering APP/views/elements/languages.ctp | 0.001430 | |
| Rendering APP/views/elements/menu.ctp | 0.002410 | |
| Rendering APP/views/elements/how_to_advertise.ctp | 0.002340 | |
| Rendering APP/views/elements/tabs.ctp | 0.004150 | |
| Rendering APP/views/elements/registrations/revista_small.ctp | 0.000840 | |
| Rendering APP/views/elements/properties/sidebar_detail.ctp | 0.017020 | |
| Rendering APP/views/elements/middle_banner.ctp | 0.000230 | |
| Rendering APP/views/elements/search.ctp | 0.014160 | |
| Rendering APP/views/elements/highlight/right_highlight.ctp | 0.016020 | |
| Rendering APP/views/elements/form_send_to_friend.ctp | 0.010940 | |
| Rendering APP/views/elements/properties/gallery_overlay.ctp | 0.001160 | |
| Rendering APP/views/elements/tracking_code.ctp | 0.000200 |
There were no log entries made this request
There were no log entries made this request