More Than Just Home Builders Benefit When The City Is Growing

More Than Just Home Builders Benefit When The City Is Growing

  • More Than Just Home Builders Benefit When The City Is GrowingRead More

    More Than Just Home Builders Benefit When The City Is Growing

  • Governments Have The Power To Make Housing More Affordable Read More

    Governments Have The Power To Make Housing More Affordable

  • More Must Be Done To Make Home Ownership Affordable Read More

    More Must Be Done To Make Home Ownership Affordable

  • New Homes Are Working To Help The EnvironmentRead More

    New Homes Are Working To Help The Environment

  • Do Homework Before Doing Work On Your HomeRead More

    Do Homework Before Doing Work On Your Home

Community Developments

Learn more about a new community.
Select one here and find everything from descriptions to maps, homes and even builders.

New Home Locator

Looking for a new home?
Our New Home Locator is here to help!

Upcoming Events

View All Events

Member Finder

Search our Online Member Directory by entering a name below.

Browse our Online Member Directory by category. Just click the button below.

Browse by Category
Cake SQL Log
(default) 48 queries took 1068 ms
NrQueryErrorAffectedNum. rowsTook (ms)Code
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `rrhba`.`cake_sessions` AS `Session` WHERE `id` = '01100mvmg46iho3idro27n4ck1' LIMIT 1000session_start - [internal], line ?? AppController::beforeFilter() - APP/Controller/AppController.php, line 82 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
2SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `rrhba`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1110AppController::beforeFilter() - APP/Controller/AppController.php, line 98 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
3SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `rrhba`.`aros` AS `Aro` LEFT JOIN `rrhba`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'Role' AND `Aro0`.`foreign_key` = 3 ORDER BY `Aro`.`lft` DESC220AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
4SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `rrhba`.`acos` AS `Aco` LEFT JOIN `rrhba`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Pages') LEFT JOIN `rrhba`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'home' AND `Aco0`.`id` = `Aco1`.`parent_id`) WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco1`.`lft` AND `Aco`.`rght` >= `Aco1`.`rght`)) ORDER BY `Aco`.`lft` DESC33210AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
5SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `rrhba`.`aros_acos` AS `Permission` LEFT JOIN `rrhba`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `rrhba`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 3 AND `Permission`.`aco_id` IN (59, 2, 1) ORDER BY `Aco`.`lft` desc111AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
6SELECT `Resource`.`id` FROM `rrhba`.`resources` AS `Resource` LEFT JOIN `rrhba`.`users` AS `User` ON (`Resource`.`user_id` = `User`.`id`) WHERE 1 = 1000AppModel::fetchAllPermissions() - APP/Model/AppModel.php, line 150 AppController::cacheObjectPermissionsForView() - APP/Controller/AppController.php, line 211 AppController::beforeFilter() - APP/Controller/AppController.php, line 127 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
7SELECT `Page`.`id`, `Page`.`title`, `Page`.`slug`, `Page`.`summary`, `Page`.`content`, `Page`.`created`, `Page`.`modified`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`path`, `Page`.`status`, `Page`.`hide_subpages` FROM `rrhba`.`pages` AS `Page` WHERE `parent_id` IS NULL ORDER BY `lft` ASC771PagesController::home() - APP/Controller/PagesController.php, line 10 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
8SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `rrhba`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1110AppController::beforeFilter() - APP/Controller/AppController.php, line 98 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 21 [main] - APP/webroot/index.php, line 92
9SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `rrhba`.`aros` AS `Aro` LEFT JOIN `rrhba`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'Role' AND `Aro0`.`foreign_key` = 3 ORDER BY `Aro`.`lft` DESC220AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 21 [main] - APP/webroot/index.php, line 92
10SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `rrhba`.`acos` AS `Aco` LEFT JOIN `rrhba`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Posts') LEFT JOIN `rrhba`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'featured' AND `Aco0`.`id` = `Aco1`.`parent_id`) WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco1`.`lft` AND `Aco`.`rght` >= `Aco1`.`rght`)) ORDER BY `Aco`.`lft` DESC33209AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 21 [main] - APP/webroot/index.php, line 92
11SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `rrhba`.`aros_acos` AS `Permission` LEFT JOIN `rrhba`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `rrhba`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 3 AND `Permission`.`aco_id` IN (219, 213, 1) ORDER BY `Aco`.`lft` desc111AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 21 [main] - APP/webroot/index.php, line 92
12SELECT `Resource`.`id` FROM `rrhba`.`resources` AS `Resource` LEFT JOIN `rrhba`.`users` AS `User` ON (`Resource`.`user_id` = `User`.`id`) WHERE 1 = 1000AppModel::fetchAllPermissions() - APP/Model/AppModel.php, line 150 AppController::cacheObjectPermissionsForView() - APP/Controller/AppController.php, line 211 AppController::beforeFilter() - APP/Controller/AppController.php, line 127 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 21 [main] - APP/webroot/index.php, line 92
13SELECT `Post`.`id`, `Post`.`title`, `Post`.`date`, `Post`.`summary`, `Post`.`post`, `Post`.`created`, `Post`.`updated`, `Post`.`status`, `Post`.`user_id`, `Post`.`featured`, `Post`.`post_category_id`, `User`.`id`, `User`.`role_id`, `User`.`name`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`created`, `User`.`modified`, `User`.`status`, `User`.`activate_key`, `User`.`reset_key`, `User`.`company`, `PostCategory`.`id`, `PostCategory`.`name`, `PostCategory`.`index_action` FROM `rrhba`.`posts` AS `Post` LEFT JOIN `rrhba`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `rrhba`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `Post`.`status` = '1' AND `Post`.`featured` = '1' ORDER BY `Post`.`date` DESC661PostsController::featured() - APP/Controller/PostsController.php, line 74 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 21 [main] - APP/webroot/index.php, line 92
14SELECT `PostPhoto`.`id`, `PostPhoto`.`post_id`, `PostPhoto`.`image_path`, `PostPhoto`.`file_name`, `PostPhoto`.`order` FROM `rrhba`.`post_photos` AS `PostPhoto` WHERE `PostPhoto`.`post_id` IN (68, 66, 63, 59, 53, 32) ORDER BY `order` ASC 660PostsController::featured() - APP/Controller/PostsController.php, line 74 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 21 [main] - APP/webroot/index.php, line 92
15SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`created`, `ObjectsTag`.`id`, `ObjectsTag`.`tag_id`, `ObjectsTag`.`model`, `ObjectsTag`.`foreign_key`, `ObjectsTag`.`created` FROM `rrhba`.`tags` AS `Tag` JOIN `rrhba`.`objects_tags` AS `ObjectsTag` ON (`ObjectsTag`.`foreign_key` IN (68, 66, 63, 59, 53, 32) AND `ObjectsTag`.`tag_id` = `Tag`.`id`) WHERE `ObjectsTag`.`model` = 'Post' 000PostsController::featured() - APP/Controller/PostsController.php, line 74 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 21 [main] - APP/webroot/index.php, line 92
16SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `rrhba`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1110AppController::beforeFilter() - APP/Controller/AppController.php, line 98 call_user_func - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
17SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `rrhba`.`aros` AS `Aro` LEFT JOIN `rrhba`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'Role' AND `Aro0`.`foreign_key` = 3 ORDER BY `Aro`.`lft` DESC220AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
18SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `rrhba`.`acos` AS `Aco` LEFT JOIN `rrhba`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Users') LEFT JOIN `rrhba`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'dashboardInfo' AND `Aco0`.`id` = `Aco1`.`parent_id`) WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco1`.`lft` AND `Aco`.`rght` >= `Aco1`.`rght`)) ORDER BY `Aco`.`lft` DESC33207AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
19SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `rrhba`.`aros_acos` AS `Permission` LEFT JOIN `rrhba`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `rrhba`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 3 AND `Permission`.`aco_id` IN (696, 5, 1) ORDER BY `Aco`.`lft` desc111AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
20SELECT `Resource`.`id` FROM `rrhba`.`resources` AS `Resource` LEFT JOIN `rrhba`.`users` AS `User` ON (`Resource`.`user_id` = `User`.`id`) WHERE 1 = 1000AppModel::fetchAllPermissions() - APP/Model/AppModel.php, line 150 AppController::cacheObjectPermissionsForView() - APP/Controller/AppController.php, line 211 AppController::beforeFilter() - APP/Controller/AppController.php, line 127 call_user_func - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
21SELECT `Event`.`id`, `Event`.`user_id`, `Event`.`home_id`, `Event`.`date`, `Event`.`start_time`, `Event`.`end_time`, `Event`.`location`, `Event`.`title`, `Event`.`description`, `Event`.`visible`, `Event`.`series_id`, `Event`.`short_description`, `Event`.`company_id`, `Event`.`event_category_id`, `Event`.`rsvp_requested`, `User`.`id`, `User`.`role_id`, `User`.`name`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`created`, `User`.`modified`, `User`.`status`, `User`.`activate_key`, `User`.`reset_key`, `User`.`company`, `Series`.`id`, `Series`.`name`, `Series`.`user_id`, `Home`.`id`, `Home`.`company_id`, `Home`.`user_id`, `Home`.`slug`, `Home`.`status`, `Home`.`delete`, `Home`.`show_home_hours`, `Home`.`summary`, `Home`.`description`, `Home`.`price`, `Home`.`possesion_date`, `Home`.`size`, `Home`.`style`, `Home`.`beds`, `Home`.`model`, `Home`.`address`, `Home`.`city`, `Home`.`province`, `Home`.`postal_code`, `Home`.`neighborhood_id`, `Home`.`contact_name`, `Home`.`contact_phone`, `Home`.`contact_email`, `Home`.`energystar`, `Home`.`r2000`, `Home`.`coordinate_override`, `Home`.`latitude`, `Home`.`longitude`, `Home`.`accuracy`, `Home`.`tour`, `Home`.`show_open`, `Home`.`show_appointment`, `Home`.`show_open_monday`, `Home`.`show_open_tuesday`, `Home`.`show_open_wednesday`, `Home`.`show_open_thursday`, `Home`.`show_open_friday`, `Home`.`show_open_saturday`, `Home`.`show_open_sunday`, `Home`.`show_open_monday_start`, `Home`.`show_open_monday_end`, `Home`.`show_open_tuesday_start`, `Home`.`show_open_tuesday_end`, `Home`.`show_open_wednesday_start`, `Home`.`show_open_wednesday_end`, `Home`.`show_open_thursday_start`, `Home`.`show_open_thursday_end`, `Home`.`show_open_friday_start`, `Home`.`show_open_friday_end`, `Home`.`show_open_saturday_start`, `Home`.`show_open_saturday_end`, `Home`.`show_open_sunday_start`, `Home`.`show_open_sunday_end`, `Home`.`show_appointment_instructions`, (FORMAT(`Home`.`price`,0)) AS `Home__price_nice`, `Company`.`id`, `Company`.`name`, `Company`.`slug`, `Company`.`builder`, `Company`.`phone_number`, `Company`.`fax_number`, `Company`.`toll_free_number`, `Company`.`email_address`, `Company`.`website`, `Company`.`street_name`, `Company`.`city`, `Company`.`province`, `Company`.`postal_code`, `Company`.`coordinate_override`, `Company`.`latitude`, `Company`.`longitude`, `Company`.`renomark`, `Company`.`national`, `Company`.`nhw`, `Company`.`progressive`, `Company`.`cphbp`, `Company`.`created`, `Company`.`modified`, `Company`.`featured`, `Company`.`visible`, `Company`.`Logo`, `EventCategory`.`id`, `EventCategory`.`name`, `EventCategory`.`calendar-icon`, `EventCategory`.`list-icon`, `EventCategory`.`rsvp` FROM `rrhba`.`events` AS `Event` LEFT JOIN `rrhba`.`users` AS `User` ON (`Event`.`user_id` = `User`.`id`) LEFT JOIN `rrhba`.`series` AS `Series` ON (`Event`.`series_id` = `Series`.`id`) LEFT JOIN `rrhba`.`homes` AS `Home` ON (`Event`.`home_id` = `Home`.`id`) LEFT JOIN `rrhba`.`companies` AS `Company` ON (`Event`.`company_id` = `Company`.`id`) LEFT JOIN `rrhba`.`event_categories` AS `EventCategory` ON (`Event`.`event_category_id` = `EventCategory`.`id`) WHERE `Event`.`event_category_id` = 1 AND `Event`.`visible` = '1' AND `Event`.`date` > '2016-09-29' ORDER BY `Event`.`date` ASC LIMIT 5221UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 96 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
22SELECT `Rsvp`.`id`, `Rsvp`.`event_id`, `Rsvp`.`user_id`, `Rsvp`.`attending`, `Rsvp`.`extras`, `Rsvp`.`company`, `Rsvp`.`name`, `Rsvp`.`note`, `Rsvp`.`created`, `Rsvp`.`modified` FROM `rrhba`.`rsvps` AS `Rsvp` WHERE `Rsvp`.`event_id` IN (3832, 3831) 001UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 96 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
23SELECT `Post`.`id`, `Post`.`title`, `Post`.`date`, `Post`.`summary`, `Post`.`post`, `Post`.`created`, `Post`.`updated`, `Post`.`status`, `Post`.`user_id`, `Post`.`featured`, `Post`.`post_category_id`, `User`.`id`, `User`.`role_id`, `User`.`name`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`created`, `User`.`modified`, `User`.`status`, `User`.`activate_key`, `User`.`reset_key`, `User`.`company`, `PostCategory`.`id`, `PostCategory`.`name`, `PostCategory`.`index_action` FROM `rrhba`.`posts` AS `Post` LEFT JOIN `rrhba`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `rrhba`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `Post`.`post_category_id` = 1 AND `Post`.`status` = '1' ORDER BY `Post`.`date` DESC LIMIT 5551UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 97 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
24SELECT `PostPhoto`.`id`, `PostPhoto`.`post_id`, `PostPhoto`.`image_path`, `PostPhoto`.`file_name`, `PostPhoto`.`order` FROM `rrhba`.`post_photos` AS `PostPhoto` WHERE `PostPhoto`.`post_id` IN (68, 67, 66, 63, 61) ORDER BY `order` ASC 550UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 97 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
25SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`created`, `ObjectsTag`.`id`, `ObjectsTag`.`tag_id`, `ObjectsTag`.`model`, `ObjectsTag`.`foreign_key`, `ObjectsTag`.`created` FROM `rrhba`.`tags` AS `Tag` JOIN `rrhba`.`objects_tags` AS `ObjectsTag` ON (`ObjectsTag`.`foreign_key` IN (68, 67, 66, 63, 61) AND `ObjectsTag`.`tag_id` = `Tag`.`id`) WHERE `ObjectsTag`.`model` = 'Post' 000UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 97 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
26SELECT `Resource`.`id`, `Resource`.`status`, `Resource`.`created`, `Resource`.`updated`, `Resource`.`user_id`, `Resource`.`parent_id`, `Resource`.`lft`, `Resource`.`rght`, `Resource`.`type`, `Resource`.`mime`, `Resource`.`title`, `Resource`.`filename`, `Resource`.`description`, `Resource`.`size`, `Resource`.`extension`, `User`.`id`, `User`.`role_id`, `User`.`name`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`created`, `User`.`modified`, `User`.`status`, `User`.`activate_key`, `User`.`reset_key`, `User`.`company` FROM `rrhba`.`resources` AS `Resource` LEFT JOIN `rrhba`.`users` AS `User` ON (`Resource`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY `Resource`.`lft` ASC000UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 98 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
27SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `rrhba`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1110AppController::beforeFilter() - APP/Controller/AppController.php, line 98 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
28SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `rrhba`.`aros` AS `Aro` LEFT JOIN `rrhba`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'Role' AND `Aro0`.`foreign_key` = 3 ORDER BY `Aro`.`lft` DESC220AppController::beforeFilter() - APP/Controller/AppController.php, line 101 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
29SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `rrhba`.`acos` AS `Aco` LEFT JOIN `rrhba`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Homes') LEFT JOIN `rrhba`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'locatorData' AND `Aco0`.`id` = `Aco1`.`parent_id`) WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco1`.`lft` AND `Aco`.`rght` >= `Aco1`.`rght`)) ORDER BY `Aco`.`lft` DESC33211AppController::beforeFilter() - APP/Controller/AppController.php, line 101 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
30SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `rrhba`.`aros_acos` AS `Permission` LEFT JOIN `rrhba`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `rrhba`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 3 AND `Permission`.`aco_id` IN (570, 142, 1) ORDER BY `Aco`.`lft` desc111AppController::beforeFilter() - APP/Controller/AppController.php, line 101 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
31SELECT `Resource`.`id` FROM `rrhba`.`resources` AS `Resource` LEFT JOIN `rrhba`.`users` AS `User` ON (`Resource`.`user_id` = `User`.`id`) WHERE 1 = 1000AppModel::fetchAllPermissions() - APP/Model/AppModel.php, line 150 AppController::cacheObjectPermissionsForView() - APP/Controller/AppController.php, line 211 AppController::beforeFilter() - APP/Controller/AppController.php, line 127 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
32SELECT `Company`.`id`, `Company`.`name` FROM `rrhba`.`companies` AS `Company` WHERE EXISTS (SELECT 1 FROM companies_company_roles FindJoinTable LEFT JOIN company_roles FindRole ON `FindJoinTable`.`company_role_id` = `FindRole`.`id` WHERE `FindJoinTable`.`company_id` = `Company`.`id` AND `FindRole`.`name` = 'Builder') ORDER BY `name` ASC51511Company::findByRole() - APP/Model/Company.php, line 139 HomesController::locatorData() - APP/Controller/HomesController.php, line 1108 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
33SELECT `Neighborhood`.`id`, `Neighborhood`.`name` FROM `rrhba`.`neighborhoods` AS `Neighborhood` WHERE 1 = 1 ORDER BY `name` ASC42420HomesController::locatorData() - APP/Controller/HomesController.php, line 1113 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
34SELECT DISTINCT (`Home`.`style`) as style FROM `rrhba`.`homes` AS `Home` WHERE `Home`.`status` >= 1 ORDER BY `style` ASC32321HomesController::locatorData() - APP/Controller/HomesController.php, line 1118 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
35SELECT DISTINCT (`Home`.`city`) as city FROM `rrhba`.`homes` AS `Home` WHERE `Home`.`status` >= 1 ORDER BY `style` ASC550HomesController::locatorData() - APP/Controller/HomesController.php, line 1140 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
36SELECT `Company`.`id`, `Company`.`name` FROM `rrhba`.`companies` AS `Company` WHERE EXISTS (SELECT 1 FROM companies_company_roles FindJoinTable LEFT JOIN company_roles FindRole ON `FindJoinTable`.`company_role_id` = `FindRole`.`id` WHERE `FindJoinTable`.`company_id` = `Company`.`id` AND `FindRole`.`name` = 'Builder') ORDER BY `name` ASC51511Company::findByRole() - APP/Model/Company.php, line 139 HomesController::locatorData() - APP/Controller/HomesController.php, line 1108 ReflectionMethod::invokeArgs() - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
37SELECT `Neighborhood`.`id`, `Neighborhood`.`name` FROM `rrhba`.`neighborhoods` AS `Neighborhood` WHERE 1 = 1 ORDER BY `name` ASC42420HomesController::locatorData() - APP/Controller/HomesController.php, line 1113 ReflectionMethod::invokeArgs() - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
38SELECT DISTINCT (`Home`.`style`) as style FROM `rrhba`.`homes` AS `Home` WHERE `Home`.`status` >= 1 ORDER BY `style` ASC32321HomesController::locatorData() - APP/Controller/HomesController.php, line 1118 ReflectionMethod::invokeArgs() - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
39SELECT DISTINCT (`Home`.`city`) as city FROM `rrhba`.`homes` AS `Home` WHERE `Home`.`status` >= 1 ORDER BY `style` ASC551HomesController::locatorData() - APP/Controller/HomesController.php, line 1140 ReflectionMethod::invokeArgs() - [internal], line ?? UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 99 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
40SELECT `Neighborhood`.`id`, `Neighborhood`.`name` FROM `rrhba`.`neighborhoods` AS `Neighborhood` WHERE `Neighborhood`.`show` = '1' ORDER BY `Neighborhood`.`name` asc23230UsersController::dashboardInfo() - APP/Controller/UsersController.php, line 102 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Elements/home-dashboard.ctp, line 1 include - APP/View/Themed/Rrhba/Layouts/home.ctp, line 102 [main] - APP/webroot/index.php, line 92
41SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `rrhba`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1110AppController::beforeFilter() - APP/Controller/AppController.php, line 98 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
42SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `rrhba`.`aros` AS `Aro` LEFT JOIN `rrhba`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'Role' AND `Aro0`.`foreign_key` = 3 ORDER BY `Aro`.`lft` DESC221AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
43SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `rrhba`.`acos` AS `Aco` LEFT JOIN `rrhba`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Posts') LEFT JOIN `rrhba`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'index' AND `Aco0`.`id` = `Aco1`.`parent_id`) WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco1`.`lft` AND `Aco`.`rght` >= `Aco1`.`rght`)) ORDER BY `Aco`.`lft` DESC33213AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
44SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `rrhba`.`aros_acos` AS `Permission` LEFT JOIN `rrhba`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `rrhba`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 3 AND `Permission`.`aco_id` IN (218, 213, 1) ORDER BY `Aco`.`lft` desc111AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
45SELECT `Resource`.`id` FROM `rrhba`.`resources` AS `Resource` LEFT JOIN `rrhba`.`users` AS `User` ON (`Resource`.`user_id` = `User`.`id`) WHERE 1 = 1000AppModel::fetchAllPermissions() - APP/Model/AppModel.php, line 150 AppController::cacheObjectPermissionsForView() - APP/Controller/AppController.php, line 211 AppController::beforeFilter() - APP/Controller/AppController.php, line 127 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
46SELECT `Post`.`id`, `Post`.`title`, `Post`.`date`, `Post`.`summary`, `Post`.`post`, `Post`.`created`, `Post`.`updated`, `Post`.`status`, `Post`.`user_id`, `Post`.`featured`, `Post`.`post_category_id`, `User`.`id`, `User`.`name`, `User`.`username`, `User`.`email` FROM `rrhba`.`posts` AS `Post` LEFT JOIN `rrhba`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`status` = '1' AND `Post`.`post_category_id` = 1 ORDER BY `Post`.`date` DESC49492PostsController::index() - APP/Controller/PostsController.php, line 32 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
47SELECT `PostPhoto`.`id`, `PostPhoto`.`post_id`, `PostPhoto`.`image_path`, `PostPhoto`.`file_name`, `PostPhoto`.`order` FROM `rrhba`.`post_photos` AS `PostPhoto` WHERE `PostPhoto`.`post_id` IN (68, 67, 66, 63, 61, 62, 60, 59, 58, 57, 56, 55, 54, 53, 50, 49, 48, 47, 46, 45, 42, 44, 43, 41, 40, 38, 39, 36, 37, 35, 34, 29, 28, 30, 31, 32, 9, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20) ORDER BY `order` ASC 49490PostsController::index() - APP/Controller/PostsController.php, line 32 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
48SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`created`, `ObjectsTag`.`id`, `ObjectsTag`.`tag_id`, `ObjectsTag`.`model`, `ObjectsTag`.`foreign_key`, `ObjectsTag`.`created` FROM `rrhba`.`tags` AS `Tag` JOIN `rrhba`.`objects_tags` AS `ObjectsTag` ON (`ObjectsTag`.`foreign_key` IN (68, 67, 66, 63, 61, 62, 60, 59, 58, 57, 56, 55, 54, 53, 50, 49, 48, 47, 46, 45, 42, 44, 43, 41, 40, 38, 39, 36, 37, 35, 34, 29, 28, 30, 31, 32, 9, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20) AND `ObjectsTag`.`tag_id` = `Tag`.`id`) WHERE `ObjectsTag`.`model` = 'Post' 000PostsController::index() - APP/Controller/PostsController.php, line 32 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92