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) 28 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)Code
1SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `reginaho_rrhba_live`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1110AppController::beforeFilter() - APP/Controller/AppController.php, line 97 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
2SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `reginaho_rrhba_live`.`aros` AS `Aro` LEFT JOIN `reginaho_rrhba_live`.`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 100 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
3SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `reginaho_rrhba_live`.`acos` AS `Aco` LEFT JOIN `reginaho_rrhba_live`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Homes') LEFT JOIN `reginaho_rrhba_live`.`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` DESC330AppController::beforeFilter() - APP/Controller/AppController.php, line 100 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
4SELECT `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 `reginaho_rrhba_live`.`aros_acos` AS `Permission` LEFT JOIN `reginaho_rrhba_live`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `reginaho_rrhba_live`.`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` desc110AppController::beforeFilter() - APP/Controller/AppController.php, line 100 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
5SELECT `Resource`.`id` FROM `reginaho_rrhba_live`.`resources` AS `Resource` LEFT JOIN `reginaho_rrhba_live`.`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 210 AppController::beforeFilter() - APP/Controller/AppController.php, line 126 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
6SELECT `Company`.`id`, `Company`.`name` FROM `reginaho_rrhba_live`.`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` ASC49490Company::findByRole() - APP/Model/Company.php, line 139 HomesController::locatorData() - APP/Controller/HomesController.php, line 1018 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
7SELECT `Neighborhood`.`id`, `Neighborhood`.`name` FROM `reginaho_rrhba_live`.`neighborhoods` AS `Neighborhood` WHERE 1 = 1 ORDER BY `name` ASC38380HomesController::locatorData() - APP/Controller/HomesController.php, line 1023 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
8SELECT DISTINCT (`Home`.`style`) as style FROM `reginaho_rrhba_live`.`homes` AS `Home` WHERE `Home`.`status` >= 1 ORDER BY `style` ASC22220HomesController::locatorData() - APP/Controller/HomesController.php, line 1028 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
9SELECT DISTINCT (`Home`.`city`) as city FROM `reginaho_rrhba_live`.`homes` AS `Home` WHERE `Home`.`status` >= 1 ORDER BY `style` ASC770HomesController::locatorData() - APP/Controller/HomesController.php, line 1050 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
10SELECT `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 `reginaho_rrhba_live`.`users` AS `User` WHERE `User`.`id` IS NULL LIMIT 1000User::companyIdsForUserId() - APP/Model/User.php, line 95 HomesController::view() - APP/Controller/HomesController.php, line 211 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
11SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `reginaho_rrhba_live`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1110AppController::checkActionPermission() - APP/Controller/AppController.php, line 171 HomesController::view() - APP/Controller/HomesController.php, line 213 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
12SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `reginaho_rrhba_live`.`aros` AS `Aro` LEFT JOIN `reginaho_rrhba_live`.`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::checkActionPermission() - APP/Controller/AppController.php, line 173 HomesController::view() - APP/Controller/HomesController.php, line 213 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
13SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `reginaho_rrhba_live`.`acos` AS `Aco` LEFT JOIN `reginaho_rrhba_live`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Homes') LEFT JOIN `reginaho_rrhba_live`.`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` DESC330AppController::checkActionPermission() - APP/Controller/AppController.php, line 173 HomesController::view() - APP/Controller/HomesController.php, line 213 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
14SELECT `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 `reginaho_rrhba_live`.`aros_acos` AS `Permission` LEFT JOIN `reginaho_rrhba_live`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `reginaho_rrhba_live`.`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` desc110AppController::checkActionPermission() - APP/Controller/AppController.php, line 173 HomesController::view() - APP/Controller/HomesController.php, line 213 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
15SELECT `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`, (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`.`created`, `Company`.`modified`, `Company`.`featured`, `Company`.`visible` FROM `reginaho_rrhba_live`.`homes` AS `Home` LEFT JOIN `reginaho_rrhba_live`.`neighborhoods` AS `Neighborhood` ON (`Home`.`neighborhood_id` = `Neighborhood`.`id`) LEFT JOIN `reginaho_rrhba_live`.`companies` AS `Company` ON (`Home`.`company_id` = `Company`.`id`) WHERE ((`Home`.`status` = 1) OR (`Home`.`company_id` IS NULL)) AND `Home`.`slug` = 'spruce_creek_estates' LIMIT 1001HomesController::view() - APP/Controller/HomesController.php, line 246 ReflectionMethod::invokeArgs() - [internal], line ?? [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 `reginaho_rrhba_live`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1110AppController::checkActionPermission() - APP/Controller/AppController.php, line 171 HomesController::view() - APP/Controller/HomesController.php, line 249 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
17SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `reginaho_rrhba_live`.`aros` AS `Aro` LEFT JOIN `reginaho_rrhba_live`.`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::checkActionPermission() - APP/Controller/AppController.php, line 173 HomesController::view() - APP/Controller/HomesController.php, line 249 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
18SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `reginaho_rrhba_live`.`acos` AS `Aco` LEFT JOIN `reginaho_rrhba_live`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Homes') LEFT JOIN `reginaho_rrhba_live`.`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` DESC330AppController::checkActionPermission() - APP/Controller/AppController.php, line 173 HomesController::view() - APP/Controller/HomesController.php, line 249 ReflectionMethod::invokeArgs() - [internal], line ?? [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 `reginaho_rrhba_live`.`aros_acos` AS `Permission` LEFT JOIN `reginaho_rrhba_live`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `reginaho_rrhba_live`.`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` desc110AppController::checkActionPermission() - APP/Controller/AppController.php, line 173 HomesController::view() - APP/Controller/HomesController.php, line 249 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
20SELECT `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`, (FORMAT(`HomeRevision`.`price`,0)) AS `HomeRevision__price_nice` FROM `reginaho_rrhba_live`.`home_revisions` AS `HomeRevision` WHERE `HomeRevision`.`home_id` IS NULL AND `HomeRevision`.`status` = 0 LIMIT 1000HomesController::view() - APP/Controller/HomesController.php, line 257 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
21SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `reginaho_rrhba_live`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1110AppController::beforeFilter() - APP/Controller/AppController.php, line 97 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
22SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `reginaho_rrhba_live`.`aros` AS `Aro` LEFT JOIN `reginaho_rrhba_live`.`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 100 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
23SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `reginaho_rrhba_live`.`acos` AS `Aco` LEFT JOIN `reginaho_rrhba_live`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Posts') LEFT JOIN `reginaho_rrhba_live`.`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` DESC330AppController::beforeFilter() - APP/Controller/AppController.php, line 100 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
24SELECT `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 `reginaho_rrhba_live`.`aros_acos` AS `Permission` LEFT JOIN `reginaho_rrhba_live`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `reginaho_rrhba_live`.`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` desc110AppController::beforeFilter() - APP/Controller/AppController.php, line 100 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
25SELECT `Resource`.`id` FROM `reginaho_rrhba_live`.`resources` AS `Resource` LEFT JOIN `reginaho_rrhba_live`.`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 210 AppController::beforeFilter() - APP/Controller/AppController.php, line 126 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
26SELECT `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 `reginaho_rrhba_live`.`posts` AS `Post` LEFT JOIN `reginaho_rrhba_live`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`status` = '1' AND `Post`.`post_category_id` = 1 ORDER BY `Post`.`date` DESC37370PostsController::index() - APP/Controller/PostsController.php, line 31 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
27SELECT `PostPhoto`.`id`, `PostPhoto`.`post_id`, `PostPhoto`.`image_path`, `PostPhoto`.`file_name`, `PostPhoto`.`order` FROM `reginaho_rrhba_live`.`post_photos` AS `PostPhoto` WHERE `PostPhoto`.`post_id` IN (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 37370PostsController::index() - APP/Controller/PostsController.php, line 31 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
28SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`created`, `ObjectsTag`.`id`, `ObjectsTag`.`tag_id`, `ObjectsTag`.`model`, `ObjectsTag`.`foreign_key`, `ObjectsTag`.`created` FROM `reginaho_rrhba_live`.`tags` AS `Tag` JOIN `reginaho_rrhba_live`.`objects_tags` AS `ObjectsTag` ON (`ObjectsTag`.`foreign_key` IN (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 31 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92