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 926 ms
NrQueryErrorAffectedNum. rowsTook (ms)Code
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `rrhba`.`cake_sessions` AS `Session` WHERE `id` = 'v73410kmbvcj7jkp4pqbtnh9k0' LIMIT 1002session_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 1112AppController::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` DESC222AppController::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` DESC33211AppController::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` desc112AppController::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 = 1002AppModel::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` ASC51512Company::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` ASC42422HomesController::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` ASC32322HomesController::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` ASC552HomesController::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` = '4715_glass_street' LIMIT 1002HomesController::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 1001User::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 1112AppController::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` DESC222AppController::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` DESC33221AppController::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` desc112AppController::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` = '4715_glass_street' LIMIT 1002HomesController::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 1112AppController::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` DESC222AppController::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` DESC33212AppController::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` desc112AppController::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 1002HomesController::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 1112AppController::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` DESC222AppController::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` DESC33211AppController::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` desc112AppController::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 = 1002AppModel::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` DESC494922PostsController::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 (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 49492PostsController::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 (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' 002PostsController::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