| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| 1 | DESCRIBE `options` | | 3 | 3 | 132 |
| 2 | SELECT `Option`.`id`, `Option`.`name`, `Option`.`value` FROM `options` AS `Option` WHERE `name` = 'VisitorsCounter' LIMIT 1 | | 1 | 1 | 1 |
| 3 | SELECT `Option`.`id`, `Option`.`name`, `Option`.`value` FROM `options` AS `Option` WHERE `name` = 'VisitorsCounter' LIMIT 1 | | 1 | 1 | 1 |
| 4 | SELECT COUNT(*) AS `count` FROM `options` AS `Option` WHERE `Option`.`id` = 9 | | 1 | 1 | 1 |
| 5 | UPDATE `options` SET `value` = '14045' WHERE `options`.`id` = 9 | | 1 | | 1277 |
| 6 | DESCRIBE `users` | | 16 | 16 | 2 |
| 7 | DESCRIBE `agencies` | | 8 | 8 | 1 |
| 8 | DESCRIBE `properties` | | 23 | 23 | 2 |
| 9 | DESCRIBE `countries` | | 3 | 3 | 1 |
| 10 | DESCRIBE `states` | | 3 | 3 | 1 |
| 11 | DESCRIBE `cities` | | 4 | 4 | 1 |
| 12 | DESCRIBE `property_images` | | 5 | 5 | 1 |
| 13 | 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`.`highlight` = 1 AND `Property`.`status` IN ('active', 'sold', 'rented', 'removed') AND `Property`.`expires` >= '2010-09-04' ORDER BY `Property`.`created` desc LIMIT 1 | | 0 | 0 | 19 |
| 14 | 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`.`status` IN ('active', 'sold', 'rented', 'removed') AND `Property`.`expires` >= '2010-09-04' ORDER BY `Property`.`created` desc LIMIT 1 | | 1 | 1 | 31 |
| 15 | SELECT `PropertyImage`.`id`, `PropertyImage`.`property_id`, `PropertyImage`.`image`, `PropertyImage`.`description`, `PropertyImage`.`principal` FROM `property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = (46) | | 1 | 1 | 1 |
| 16 | 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`.`status` IN ('active', 'sold', 'rented', 'removed') AND `Property`.`expires` >= '2010-09-04' AND NOT (`Property`.`id` = 46) ORDER BY `Property`.`created` desc LIMIT 6 | | 3 | 3 | 3 |
| 17 | SELECT `PropertyImage`.`id`, `PropertyImage`.`property_id`, `PropertyImage`.`image`, `PropertyImage`.`description`, `PropertyImage`.`principal` FROM `property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` IN (47, 48, 49) | | 3 | 3 | 1 |
