Properties :: VIVO Angola, o lugar ideal para vender, alugar ou encontrar a sua propriedade em Angola!

HOME

COMO FUNCIONA

SOBRE NÓS

CONTACTOS

PARA VENDA

ARRENDAMENTO

NOVOS DESENVOLVIMENTOS

Revista VIVO

/properties/Veja mais aqui

Para receber novidades sobre a nossa revista ou informações sobre como subscrever:

Notícias

Procurar imóvel

Como anunciar

Enviar a um amigo

Adicionar aos favoritos

anterior seguinte

History
Request History
4 previous requests available
Session
Session
- Config
  - userAgent
  - time1328572243
  - timeout10
- referer/
- counted(true)
- Search
  - Property.expires >=2012-02-06
Request
Request

Cake Params
- pass(empty)
- named(empty)
- languagerobots.txt
- sectionnew-developments
- plugin(null)
- controllerproperties
- actionshow
- url
  - exthtml
  - urlrobots.txt/properties/show/new-developments
- form(empty)
- isAjax(false)
$_GET
- urlrobots.txt/properties/show/new-developments
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- 0/:language/properties/show/:section
- 1#^(?:/([^\/]+))?/properties/show(?:/(new-developments|commercial|international|agency|classifieds))[\/]*$#
- 2
  - 0language
  - 1section
- 3
  - plugin(null)
  - controllerproperties
  - actionshow
- 4
  - sectionnew-developments|commercial|international|agency|classifieds

Sql Log

Sql Logs

default

Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `properties`	23	23	6
2	DESCRIBE `users`	16	16	8
3	DESCRIBE `agencies`	8	8	10
4	DESCRIBE `countries`	3	3	14
5	DESCRIBE `states`	3	3	7
6	DESCRIBE `cities`	4	4	3
7	DESCRIBE `property_images`	5	5	3
8	DESCRIBE `options`	3	3	210
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`.`sections` = '1' AND `Property`.`highlight` = 1 AND `Property`.`status` IN ('active', 'sold', 'rented', 'removed') AND `Property`.`expires` >= '2012-02-06' AND `User`.`status` = 'active' ORDER BY `Property`.`created` desc LIMIT 1	0	0	4
11	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`.`sections` = '1' AND `Property`.`status` IN ('active', 'sold', 'rented', 'removed') AND `Property`.`expires` >= '2012-02-06' AND `User`.`status` = 'active' ORDER BY `Property`.`created` desc LIMIT 1	0	0	3
12	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`.`sections` = '1' AND `Property`.`status` IN ('active', 'sold', 'rented', 'removed') AND `Property`.`expires` >= '2012-02-06' AND `User`.`status` = 'active' ORDER BY `Property`.`created` desc LIMIT 6	0	0	3

toggle (4) query explains for default

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	ALL					3	Using where; Using filesort	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`.`sections` = '1' AND `Property`.`highlight` = 1 AND `Property`.`status` IN ('active', 'sold', 'rented', 'removed') AND `Property`.`expires` >= '2012-02-06' AND `User`.`status` = 'active' ORDER BY `Property`.`created` desc LIMIT 1
1	SIMPLE	Property	ALL					3	Using where; Using filesort	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`.`sections` = '1' AND `Property`.`status` IN ('active', 'sold', 'rented', 'removed') AND `Property`.`expires` >= '2012-02-06' AND `User`.`status` = 'active' ORDER BY `Property`.`created` desc LIMIT 1
1	SIMPLE	Property	ALL					3	Using where; Using filesort	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`.`sections` = '1' AND `Property`.`status` IN ('active', 'sold', 'rented', 'removed') AND `Property`.`expires` >= '2012-02-06' AND `User`.`status` = 'active' ORDER BY `Property`.`created` desc LIMIT 6

Timer

Memory

Current Memory Use 8.16 MB

Peak Memory Use 18.69 MB

Timers

Total Request Time: 2.971342 (seconds)

Message	Time in seconds	Graph
Component initialization and startup	0.006650
Controller Action	0.098430
Render Controller Action	0.122970
Rendering View	0.122240
Rendering APP/views/properties/index.ctp	0.037930
Rendering APP/views/elements/properties/highlight.ctp	0.000280
Rendering APP/views/layouts/default.ctp	0.082820
Rendering APP/views/elements/languages.ctp	0.001610
Rendering APP/views/elements/menu.ctp	0.002580
Rendering APP/views/elements/how_to_advertise.ctp	0.002330
Rendering APP/views/elements/tabs.ctp	0.004110
Rendering APP/views/elements/registrations/revista.ctp	0.020160
Rendering APP/views/elements/news/news.ctp	0.011100
Rendering APP/views/elements/visitors_counter.ctp	0.000220
Rendering APP/views/elements/middle_banner.ctp	0.000230
Rendering APP/views/elements/search.ctp	0.014180
Rendering APP/views/elements/highlight/right_highlight.ctp	0.005480
Rendering APP/views/elements/form_send_to_friend.ctp	0.011730
Rendering APP/views/elements/properties/gallery_overlay.ctp	0.001310
Rendering APP/views/elements/tracking_code.ctp	0.000220

Log

Logs

error.log

There were no log entries made this request

debug.log

There were no log entries made this request
Variables
View Variables
- visitorsCounter61213
- currentLanguagerobots.txt
- highlightProperty(false)
- propertiesList(empty)
- $this->data(null)
- $this->validationErrors(empty)

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Memory

Timers

Logs

error.log

debug.log

View Variables