Consumers

Cake SQL Log
(default) 22 queries took 607 ms
NrQueryErrorAffectedNum. rowsTook (ms)Code
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `rrhba`.`cake_sessions` AS `Session` WHERE `id` = 'qqiag1nkvbi3fa8qan8dlh1431' LIMIT 1001session_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` DESC221AppController::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` = '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` DESC33378AppController::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 (45, 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 `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::checkObjectPermission() - APP/Controller/AppController.php, line 195 PagesController::view() - APP/Controller/PagesController.php, line 41 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
8SELECT `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::checkObjectPermission() - APP/Controller/AppController.php, line 197 PagesController::view() - APP/Controller/PagesController.php, line 41 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
9SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `rrhba`.`acos` AS `Aco` LEFT JOIN `rrhba`.`acos` AS `Aco0` ON (`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) WHERE `Aco0`.`model` = 'Page' AND `Aco0`.`foreign_key` = 24 ORDER BY `Aco`.`lft` DESC221AppController::checkObjectPermission() - APP/Controller/AppController.php, line 197 PagesController::view() - APP/Controller/PagesController.php, line 41 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
10SELECT `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 (181, 41) ORDER BY `Aco`.`lft` desc221AppController::checkObjectPermission() - APP/Controller/AppController.php, line 197 PagesController::view() - APP/Controller/PagesController.php, line 41 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
11SELECT `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 `Page`.`id` = 24 LIMIT 1110PagesController::view() - APP/Controller/PagesController.php, line 53 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
12SELECT `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 1 = 1 AND `Page`.`parent_id` = 24 ORDER BY `Page`.`lft` asc881Page::children() - APP/Controller/PagesController.php, line 58 PagesController::view() - APP/Controller/PagesController.php, line 58 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
13SELECT `Page`.`lft`, `Page`.`rght` FROM `rrhba`.`pages` AS `Page` WHERE `Page`.`id` = 24 LIMIT 1110Page::getPath() - APP/Controller/PagesController.php, line 59 PagesController::view() - APP/Controller/PagesController.php, line 59 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
14SELECT `Page`.`id`, `Page`.`title` FROM `rrhba`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`lft` <= 1 AND `Page`.`rght` >= 134 ORDER BY `Page`.`lft` asc111Page::getPath() - APP/Controller/PagesController.php, line 59 PagesController::view() - APP/Controller/PagesController.php, line 59 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
15SELECT `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
16SELECT `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
17SELECT `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
18SELECT `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
19SELECT `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
20SELECT `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` DESC49495PostsController::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
21SELECT `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 49491PostsController::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
22SELECT `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' 001PostsController::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