Session<\/h2>\n

• Config<\/strong>
  • userAgent<\/strong><\/li>
  • time<\/strong>1328572210<\/li>
  • timeout<\/strong>10<\/li><\/ul><\/li>
  • referer<\/strong>\/<\/li>
  • counted<\/strong>(true)<\/li>
  • Search<\/strong>
    • Property.expires >=<\/strong>2012-02-06<\/li><\/ul><\/li><\/ul>","request":"

      Request<\/h2>\n

      Cake Params<\/h4>\n

      • pass<\/strong>(empty)<\/li>
      • named<\/strong>(empty)<\/li>
      • language<\/strong>robots.txt<\/li>
      • section<\/strong>international<\/li>
      • plugin<\/strong>(null)<\/li>
      • controller<\/strong>properties<\/li>
      • action<\/strong>show<\/li>
      • url<\/strong>
        • ext<\/strong>html<\/li>
        • url<\/strong>robots.txt\/properties\/show\/international<\/li><\/ul><\/li>
        • form<\/strong>(empty)<\/li>
        • isAjax<\/strong>(false)<\/li><\/ul>\n

          $_GET<\/h4>\n

          • url<\/strong>robots.txt\/properties\/show\/international<\/li><\/ul>\n

            Cookie<\/h4>\n\t

            To view Cookies, add CookieComponent to Controller<\/p>\n\n

            Current Route<\/h4>\n

            • 0<\/strong>\/:language\/properties\/show\/:section<\/li>
            • 1<\/strong>#^(?:\/([^\\\/]+))?\/properties\/show(?:\/(new-developments|commercial|international|agency|classifieds))[\\\/]*$#<\/li>
            • 2<\/strong>
              • 0<\/strong>language<\/li>
              • 1<\/strong>section<\/li><\/ul><\/li>
              • 3<\/strong>
                • plugin<\/strong>(null)<\/li>
                • controller<\/strong>properties<\/li>
                • action<\/strong>show<\/li><\/ul><\/li>
                • 4<\/strong>
                  • section<\/strong>new-developments|commercial|international|agency|classifieds<\/li><\/ul><\/li><\/ul>","sql_log":"

                    Sql Logs<\/h2>\n\t\t

                    \n\t\t

                    default<\/h4>\n\t\t

                    Nr<\/th>	Query<\/th>	Error<\/th>	Affected<\/th>	Num. rows<\/th>	Took (ms)<\/th><\/tr>
                    1<\/td>	DESCRIBE `properties`<\/td>	<\/td>	23<\/td>	23<\/td>	2<\/td><\/tr>\n
                    2<\/td>	DESCRIBE `users`<\/td>	<\/td>	16<\/td>	16<\/td>	2<\/td><\/tr>\n
                    3<\/td>	DESCRIBE `agencies`<\/td>	<\/td>	8<\/td>	8<\/td>	1<\/td><\/tr>\n
                    4<\/td>	DESCRIBE `countries`<\/td>	<\/td>	3<\/td>	3<\/td>	1<\/td><\/tr>\n
                    5<\/td>	DESCRIBE `states`<\/td>	<\/td>	3<\/td>	3<\/td>	1<\/td><\/tr>\n
                    6<\/td>	DESCRIBE `cities`<\/td>	<\/td>	4<\/td>	4<\/td>	1<\/td><\/tr>\n
                    7<\/td>	DESCRIBE `property_images`<\/td>	<\/td>	5<\/td>	5<\/td>	2<\/td><\/tr>\n
                    8<\/td>	DESCRIBE `options`<\/td>	<\/td>	3<\/td>	3<\/td>	2<\/td><\/tr>\n
                    9<\/td>	SELECT `Option`.`id`, `Option`.`name`, `Option`.`value` FROM `options` AS `Option` WHERE `name` = 'VisitorsCounter' LIMIT 1<\/td>	<\/td>	1<\/td>	1<\/td>	4<\/td><\/tr>\n
                    10<\/td>	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` = '3' 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<\/td>	<\/td>	0<\/td>	0<\/td>	3<\/td><\/tr>\n
                    11<\/td>	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` = '3' 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<\/td>	<\/td>	0<\/td>	0<\/td>	1<\/td><\/tr>\n
                    12<\/td>	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` = '3' 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<\/td>	<\/td>	0<\/td>	0<\/td>	1<\/td><\/tr><\/table>toggle (4) query explains for default<\/a> id<\/th> select_type<\/th> table<\/th> type<\/th> possible_keys<\/th> key<\/th> key_len<\/th> ref<\/th> rows<\/th> Extra<\/th> query<\/th><\/tr> 1<\/td> SIMPLE<\/td> Option<\/td> ref<\/td> name<\/td> name<\/td> 194<\/td> const<\/td> 1<\/td> Using where<\/td> SELECT `Option`.`id`, `Option`.`name`, `Option`.`value` FROM `options` AS `Option` WHERE `name` = 'VisitorsCounter' LIMIT 1<\/td><\/tr>\n 1<\/td> SIMPLE<\/td> Property<\/td> ALL<\/td> <\/td> <\/td> <\/td> <\/td> 3<\/td> Using where; Using filesort<\/td> 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` = '3' 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<\/td><\/tr>\n 1<\/td> SIMPLE<\/td> Property<\/td> ALL<\/td> <\/td> <\/td> <\/td> <\/td> 3<\/td> Using where; Using filesort<\/td> 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` = '3' 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<\/td><\/tr>\n 1<\/td> SIMPLE<\/td> Property<\/td> ALL<\/td> <\/td> <\/td> <\/td> <\/td> 3<\/td> Using where; Using filesort<\/td> 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` = '3' 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<\/td><\/tr><\/table><\/div>\t<\/div>\n\t\n