Homes

Preview Mode

This home listing is currently in preview mode. It has not yet been approved for public display. Only users who have permission to edit this home listing can view it.

Warning (2): Invalid argument supplied for foreach() [APP/View/Homes/view.ctp, line 157]

Home Details

View Map of Listings

Search Homes

Cake SQL Log
(default) 30 queries took 880 ms
NrQueryErrorAffectedNum. rowsTook (ms)Code
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `rrhba`.`cake_sessions` AS `Session` WHERE `id` = 'uanfct4nq76gdiqk28qas0jcu3' LIMIT 1001session_start - [internal], line ?? AppController::beforeFilter() - APP/Controller/AppController.php, line 82 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 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 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 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` DESC221AppController::beforeFilter() - APP/Controller/AppController.php, line 101 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 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` = 'Homes') LEFT JOIN `rrhba`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'view' 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` DESC33214AppController::beforeFilter() - APP/Controller/AppController.php, line 101 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 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 (166, 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 ?? [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 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
7SELECT `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 ?? [main] - APP/webroot/index.php, line 92
8SELECT `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 ?? [main] - APP/webroot/index.php, line 92
9SELECT DISTINCT (`Home`.`style`) as style FROM `rrhba`.`homes` AS `Home` WHERE `Home`.`status` >= 1 ORDER BY `style` ASC31311HomesController::locatorData() - APP/Controller/HomesController.php, line 1118 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
10SELECT 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 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
11SELECT `Home`.`user_id` FROM `rrhba`.`homes` AS `Home` WHERE `id` = '4972_wright_road' LIMIT 1000HomesController::view() - APP/Controller/HomesController.php, line 243 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
12SELECT `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`.`users` AS `User` WHERE `User`.`id` IS NULL LIMIT 1000User::companyIdsForUserId() - APP/Model/User.php, line 95 HomesController::view() - APP/Controller/HomesController.php, line 246 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
13SELECT `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::checkActionPermission() - APP/Controller/AppController.php, line 172 HomesController::view() - APP/Controller/HomesController.php, line 248 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
14SELECT `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::checkActionPermission() - APP/Controller/AppController.php, line 174 HomesController::view() - APP/Controller/HomesController.php, line 248 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
15SELECT `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` = 'admin_edit' 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::checkActionPermission() - APP/Controller/AppController.php, line 174 HomesController::view() - APP/Controller/HomesController.php, line 248 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
16SELECT `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 (168, 142, 1) ORDER BY `Aco`.`lft` desc111AppController::checkActionPermission() - APP/Controller/AppController.php, line 174 HomesController::view() - APP/Controller/HomesController.php, line 248 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
17SELECT `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`, `Neighborhood`.`id`, `Neighborhood`.`name`, `Neighborhood`.`show`, `Neighborhood`.`vertices`, `Neighborhood`.`overlay_colour`, `Neighborhood`.`video_url`, `Neighborhood`.`description`, `Neighborhood`.`developer_contact_information`, (IF(`Neighborhood`.`show`,'Yes','No')) AS `Neighborhood__show_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` FROM `rrhba`.`homes` AS `Home` LEFT JOIN `rrhba`.`neighborhoods` AS `Neighborhood` ON (`Home`.`neighborhood_id` = `Neighborhood`.`id`) LEFT JOIN `rrhba`.`companies` AS `Company` ON (`Home`.`company_id` = `Company`.`id`) WHERE ((`Home`.`status` = 1) OR (`Home`.`company_id` IS NULL) OR (`Home`.`user_id` IS NULL)) AND `Home`.`slug` = '4972_wright_road' LIMIT 1001HomesController::view() - APP/Controller/HomesController.php, line 282 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
18SELECT `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::checkActionPermission() - APP/Controller/AppController.php, line 172 HomesController::view() - APP/Controller/HomesController.php, line 285 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
19SELECT `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::checkActionPermission() - APP/Controller/AppController.php, line 174 HomesController::view() - APP/Controller/HomesController.php, line 285 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
20SELECT `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` = 'admin_edit' 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` DESC33215AppController::checkActionPermission() - APP/Controller/AppController.php, line 174 HomesController::view() - APP/Controller/HomesController.php, line 285 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
21SELECT `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 (168, 142, 1) ORDER BY `Aco`.`lft` desc111AppController::checkActionPermission() - APP/Controller/AppController.php, line 174 HomesController::view() - APP/Controller/HomesController.php, line 285 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
22SELECT `HomeRevision`.`id`, `HomeRevision`.`home_id`, `HomeRevision`.`company_id`, `HomeRevision`.`user_id`, `HomeRevision`.`slug`, `HomeRevision`.`status`, `HomeRevision`.`delete`, `HomeRevision`.`show_home_hours`, `HomeRevision`.`summary`, `HomeRevision`.`description`, `HomeRevision`.`price`, `HomeRevision`.`possesion_date`, `HomeRevision`.`size`, `HomeRevision`.`style`, `HomeRevision`.`beds`, `HomeRevision`.`model`, `HomeRevision`.`address`, `HomeRevision`.`city`, `HomeRevision`.`province`, `HomeRevision`.`postal_code`, `HomeRevision`.`neighborhood_id`, `HomeRevision`.`contact_name`, `HomeRevision`.`contact_phone`, `HomeRevision`.`contact_email`, `HomeRevision`.`energystar`, `HomeRevision`.`r2000`, `HomeRevision`.`coordinate_override`, `HomeRevision`.`latitude`, `HomeRevision`.`longitude`, `HomeRevision`.`accuracy`, `HomeRevision`.`tour`, `HomeRevision`.`created`, `HomeRevision`.`modified`, `HomeRevision`.`show_open`, `HomeRevision`.`show_appointment`, `HomeRevision`.`show_open_monday`, `HomeRevision`.`show_open_tuesday`, `HomeRevision`.`show_open_wednesday`, `HomeRevision`.`show_open_thursday`, `HomeRevision`.`show_open_friday`, `HomeRevision`.`show_open_saturday`, `HomeRevision`.`show_open_sunday`, `HomeRevision`.`show_open_monday_start`, `HomeRevision`.`show_open_monday_end`, `HomeRevision`.`show_open_tuesday_start`, `HomeRevision`.`show_open_tuesday_end`, `HomeRevision`.`show_open_wednesday_start`, `HomeRevision`.`show_open_wednesday_end`, `HomeRevision`.`show_open_thursday_start`, `HomeRevision`.`show_open_thursday_end`, `HomeRevision`.`show_open_friday_start`, `HomeRevision`.`show_open_friday_end`, `HomeRevision`.`show_open_saturday_start`, `HomeRevision`.`show_open_saturday_end`, `HomeRevision`.`show_open_sunday_start`, `HomeRevision`.`show_open_sunday_end`, `HomeRevision`.`show_appointment_instructions`, (FORMAT(`HomeRevision`.`price`,0)) AS `HomeRevision__price_nice` FROM `rrhba`.`home_revisions` AS `HomeRevision` WHERE `HomeRevision`.`home_id` IS NULL AND `HomeRevision`.`status` = 0 LIMIT 1001HomesController::view() - APP/Controller/HomesController.php, line 293 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
23SELECT `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 1111AppController::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
24SELECT `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
25SELECT `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` DESC33220AppController::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
26SELECT `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
27SELECT `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
28SELECT `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` DESC48486PostsController::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
29SELECT `PostPhoto`.`id`, `PostPhoto`.`post_id`, `PostPhoto`.`image_path`, `PostPhoto`.`file_name`, `PostPhoto`.`order` FROM `rrhba`.`post_photos` AS `PostPhoto` WHERE `PostPhoto`.`post_id` IN (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 48480PostsController::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
30SELECT `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 (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