1 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 154 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
2 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 168 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
3 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 114 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
4 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 115 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
5 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 122 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
6 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 124 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
7 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 127 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
8 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 136 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
9 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 138 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
10 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 139 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
11 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 159 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
12 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 161 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
13 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 165 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
14 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 175 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
15 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 113 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
16 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 129 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
17 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 157 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
18 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 120 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
19 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 160 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
20 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 162 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
21 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 137 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
22 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 150 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
23 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 152 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
24 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 149 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
25 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 121 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
26 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 140 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
27 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 151 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
28 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 153 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
29 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 128 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
30 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 135 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
31 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 111 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
32 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`parent_id` = 112 AND `Branch`.`menuorder` <> '0' ORDER BY `Branch`.`menuorder` ASC | | 0 | 0 | 0 |
33 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 633 | | 25 | 25 | 0 |
34 | SELECT `Guest`.`id`, `Guest`.`expires`, `Guest`.`tracking`, `Guest`.`created`, `Guest`.`modified` FROM `SWPM_public`.`guests` AS `Guest` WHERE `Guest`.`id` = 1932574 LIMIT 1 | | 1 | 1 | 0 |
35 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmcm') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'clients') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'homepage') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
36 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
37 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmcm') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'clients') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'homepage') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
38 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (51, 44, 43, 3, 1) ORDER BY `Aco`.`lft` desc | | 2 | 2 | 0 |
39 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 212 | | 26 | 26 | 0 |
40 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 237 | | 0 | 0 | 0 |
41 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'messages') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'index') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 0 | 0 | 0 |
42 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'messages') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` ORDER BY `Aco`.`lft` DESC | | 3 | 3 | 0 |
43 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
44 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'messages') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` ORDER BY `Aco`.`lft` DESC | | 3 | 3 | 0 |
45 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (82, 3, 1) ORDER BY `Aco`.`lft` desc | | 1 | 1 | 0 |
46 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 658 | | 26 | 26 | 0 |
47 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 683 | | 0 | 0 | 0 |
48 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'notifications') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'index') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 0 | 0 | 0 |
49 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'notifications') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` ORDER BY `Aco`.`lft` DESC | | 3 | 3 | 0 |
50 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
51 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'notifications') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` ORDER BY `Aco`.`lft` DESC | | 3 | 3 | 0 |
52 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (98, 3, 1) ORDER BY `Aco`.`lft` desc | | 1 | 1 | 0 |
53 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 280 | | 25 | 25 | 0 |
54 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'retail') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'orders') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'myorders') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
55 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
56 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'retail') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'orders') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'myorders') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
57 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (80, 79, 72, 3, 1) ORDER BY `Aco`.`lft` desc | | 2 | 2 | 0 |
58 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 608 | | 25 | 25 | 0 |
59 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmfd') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'downloads') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'guide') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
60 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
61 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmfd') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'downloads') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'guide') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
62 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (97, 58, 57, 3, 1) ORDER BY `Aco`.`lft` desc | | 2 | 2 | 0 |
63 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 1 | | 26 | 26 | 0 |
64 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 26 | | 1 | 1 | 0 |
65 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 27 | | 1 | 1 | 0 |
66 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 28 LIMIT 1 | | 1 | 1 | 0 |
67 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'contents') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'view') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 0 | 0 | 0 |
68 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'contents') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` ORDER BY `Aco`.`lft` DESC | | 3 | 3 | 0 |
69 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
70 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'contents') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` ORDER BY `Aco`.`lft` DESC | | 3 | 3 | 0 |
71 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (10, 3, 1) ORDER BY `Aco`.`lft` desc | | 1 | 1 | 0 |
72 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 407 | | 25 | 25 | 0 |
73 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmap') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'albums') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'calculator') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 0 | 0 | 0 |
74 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmap') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'albums') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
75 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
76 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmap') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'albums') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
77 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (39, 30, 3, 1) ORDER BY `Aco`.`lft` desc | | 2 | 2 | 0 |
78 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 482 | | 25 | 25 | 0 |
79 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmfu') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'uploads') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'uploader') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
80 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
81 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmfu') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'uploads') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'uploader') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
82 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (35, 34, 27, 3, 1) ORDER BY `Aco`.`lft` desc | | 2 | 2 | 0 |
83 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 532 | | 25 | 25 | 0 |
84 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmpp') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'ptogs') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'view') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 0 | 0 | 0 |
85 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmpp') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'ptogs') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
86 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
87 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmpp') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'ptogs') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
88 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (69, 68, 3, 1) ORDER BY `Aco`.`lft` desc | | 1 | 1 | 0 |
89 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 457 | | 25 | 25 | 0 |
90 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmfd') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'downloads') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'view') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
91 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
92 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmfd') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'downloads') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'view') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
93 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (59, 58, 57, 3, 1) ORDER BY `Aco`.`lft` desc | | 2 | 2 | 0 |
94 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 238 | | 26 | 26 | 0 |
95 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 263 | | 2 | 2 | 0 |
96 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 264 AND `ContentPrototype`.`name` = 'mode' LIMIT 1 | | 1 | 1 | 0 |
97 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 264 AND `ContentPrototype`.`name` = 'url' LIMIT 1 | | 1 | 1 | 0 |
98 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 264 AND `ContentPrototype`.`name` = 'name' LIMIT 1 | | 1 | 1 | 0 |
99 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 264 AND `ContentPrototype`.`name` = 'plugin' LIMIT 1 | | 1 | 1 | 0 |
100 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 264 AND `ContentPrototype`.`name` = 'controller' LIMIT 1 | | 1 | 1 | 0 |
101 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 264 AND `ContentPrototype`.`name` = 'action' LIMIT 1 | | 1 | 1 | 0 |
102 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 264 AND `ContentPrototype`.`name` = 'variable' LIMIT 1 | | 1 | 1 | 0 |
103 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 272 AND `ContentPrototype`.`name` = 'mode' LIMIT 1 | | 1 | 1 | 0 |
104 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 272 AND `ContentPrototype`.`name` = 'url' LIMIT 1 | | 1 | 1 | 0 |
105 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 272 AND `ContentPrototype`.`name` = 'name' LIMIT 1 | | 1 | 1 | 0 |
106 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 272 AND `ContentPrototype`.`name` = 'plugin' LIMIT 1 | | 1 | 1 | 0 |
107 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 272 AND `ContentPrototype`.`name` = 'controller' LIMIT 1 | | 1 | 1 | 0 |
108 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 272 AND `ContentPrototype`.`name` = 'action' LIMIT 1 | | 1 | 1 | 0 |
109 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 272 AND `ContentPrototype`.`name` = 'variable' LIMIT 1 | | 1 | 1 | 0 |
110 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'retail') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'admin') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'overview') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 0 | 0 | 0 |
111 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'retail') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'admin') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 0 | 0 | 0 |
112 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'retail') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` ORDER BY `Aco`.`lft` DESC | | 3 | 3 | 0 |
113 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
114 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'retail') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` ORDER BY `Aco`.`lft` DESC | | 3 | 3 | 0 |
115 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (72, 3, 1) ORDER BY `Aco`.`lft` desc | | 1 | 1 | 0 |
116 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 432 | | 25 | 25 | 0 |
117 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmap') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'albums') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'admin') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
118 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
119 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmap') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'albums') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'admin') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
120 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (41, 39, 30, 3, 1) ORDER BY `Aco`.`lft` desc | | 3 | 3 | 0 |
121 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 507 | | 25 | 25 | 0 |
122 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmfu') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'uploads') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'admin') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 0 | 0 | 0 |
123 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmfu') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'uploads') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
124 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
125 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmfu') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'uploads') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
126 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (34, 27, 3, 1) ORDER BY `Aco`.`lft` desc | | 1 | 1 | 0 |
127 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 557 | | 25 | 25 | 0 |
128 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmet') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'events') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'admin') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 0 | 0 | 0 |
129 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmet') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'events') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
130 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
131 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmet') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'events') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
132 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (37, 28, 3, 1) ORDER BY `Aco`.`lft` desc | | 1 | 1 | 0 |
133 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 348 | | 25 | 25 | 0 |
134 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmcm') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'clients') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'admin') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 0 | 0 | 0 |
135 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmcm') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'clients') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
136 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
137 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmcm') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'clients') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
138 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (44, 43, 3, 1) ORDER BY `Aco`.`lft` desc | | 1 | 1 | 0 |
139 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 373 | | 26 | 26 | 0 |
140 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 398 | | 1 | 1 | 0 |
141 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 399 AND `ContentPrototype`.`name` = 'mode' LIMIT 1 | | 1 | 1 | 0 |
142 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 399 AND `ContentPrototype`.`name` = 'url' LIMIT 1 | | 1 | 1 | 0 |
143 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 399 AND `ContentPrototype`.`name` = 'name' LIMIT 1 | | 1 | 1 | 0 |
144 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 399 AND `ContentPrototype`.`name` = 'plugin' LIMIT 1 | | 1 | 1 | 0 |
145 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 399 AND `ContentPrototype`.`name` = 'controller' LIMIT 1 | | 1 | 1 | 0 |
146 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 399 AND `ContentPrototype`.`name` = 'action' LIMIT 1 | | 1 | 1 | 0 |
147 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 399 AND `ContentPrototype`.`name` = 'variable' LIMIT 1 | | 1 | 1 | 0 |
148 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmcm') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'leads') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'enquiry') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
149 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
150 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmcm') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'leads') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'enquiry') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 5 | 5 | 0 |
151 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (76, 75, 43, 3, 1) ORDER BY `Aco`.`lft` desc | | 1 | 1 | 0 |
152 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 82 | | 28 | 28 | 0 |
153 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 107 | | 0 | 0 | 0 |
154 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 108 | | 1 | 1 | 0 |
155 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 109 AND `ContentPrototype`.`name` = 'mode' LIMIT 1 | | 1 | 1 | 0 |
156 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 109 AND `ContentPrototype`.`name` = 'url' LIMIT 1 | | 1 | 1 | 0 |
157 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 109 AND `ContentPrototype`.`name` = 'name' LIMIT 1 | | 1 | 1 | 0 |
158 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 109 AND `ContentPrototype`.`name` = 'plugin' LIMIT 1 | | 1 | 1 | 0 |
159 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 109 AND `ContentPrototype`.`name` = 'controller' LIMIT 1 | | 1 | 1 | 0 |
160 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 109 AND `ContentPrototype`.`name` = 'action' LIMIT 1 | | 1 | 1 | 0 |
161 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 109 AND `ContentPrototype`.`name` = 'variable' LIMIT 1 | | 1 | 1 | 0 |
162 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 117 | | 2 | 2 | 0 |
163 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 118 AND `ContentPrototype`.`name` = 'mode' LIMIT 1 | | 1 | 1 | 0 |
164 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 118 AND `ContentPrototype`.`name` = 'url' LIMIT 1 | | 1 | 1 | 0 |
165 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 118 AND `ContentPrototype`.`name` = 'name' LIMIT 1 | | 1 | 1 | 0 |
166 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 118 AND `ContentPrototype`.`name` = 'plugin' LIMIT 1 | | 1 | 1 | 0 |
167 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 118 AND `ContentPrototype`.`name` = 'controller' LIMIT 1 | | 1 | 1 | 0 |
168 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 118 AND `ContentPrototype`.`name` = 'action' LIMIT 1 | | 1 | 1 | 0 |
169 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 118 AND `ContentPrototype`.`name` = 'variable' LIMIT 1 | | 1 | 1 | 0 |
170 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 126 AND `ContentPrototype`.`name` = 'mode' LIMIT 1 | | 1 | 1 | 0 |
171 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 126 AND `ContentPrototype`.`name` = 'url' LIMIT 1 | | 1 | 1 | 0 |
172 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 126 AND `ContentPrototype`.`name` = 'name' LIMIT 1 | | 1 | 1 | 0 |
173 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 126 AND `ContentPrototype`.`name` = 'plugin' LIMIT 1 | | 1 | 1 | 0 |
174 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 126 AND `ContentPrototype`.`name` = 'controller' LIMIT 1 | | 1 | 1 | 0 |
175 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 126 AND `ContentPrototype`.`name` = 'action' LIMIT 1 | | 1 | 1 | 0 |
176 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 126 AND `ContentPrototype`.`name` = 'variable' LIMIT 1 | | 1 | 1 | 0 |
177 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmcm') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'swpmcmusers') INNER JOIN `SWPM_public`.`acos` AS `Aco4` ON (`Aco4`.`alias` = 'details') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco4`.`lft` AND `Aco`.`rght` >= `Aco4`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` AND `Aco3`.`id` = `Aco4`.`parent_id` AND `Aco4`.`rght` < `Aco3`.`rght` AND `Aco4`.`lft` > `Aco3`.`lft` ORDER BY `Aco`.`lft` DESC | | 0 | 0 | 0 |
178 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmcm') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'swpmcmusers') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
179 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
180 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'swpmcm') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'swpmcmusers') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
181 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (46, 43, 3, 1) ORDER BY `Aco`.`lft` desc | | 1 | 1 | 0 |
182 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 134 | | 26 | 26 | 0 |
183 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 159 | | 0 | 0 | 0 |
184 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'users') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'management') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
185 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
186 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'users') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'management') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
187 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (22, 6, 3, 1) ORDER BY `Aco`.`lft` desc | | 2 | 2 | 0 |
188 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 160 | | 26 | 26 | 0 |
189 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 185 | | 0 | 0 | 0 |
190 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'branches') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'view') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
191 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
192 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'branches') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'view') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
193 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (24, 5, 3, 1) ORDER BY `Aco`.`lft` desc | | 2 | 2 | 0 |
194 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 186 | | 26 | 26 | 0 |
195 | SELECT `ContentPrototype`.`id`, `ContentPrototype`.`parent_id`, `ContentPrototype`.`name`, `ContentPrototype`.`value`, `ContentPrototype`.`created`, `ContentPrototype`.`modified` FROM `SWPM_public`.`contentPrototypes` AS `ContentPrototype` WHERE `ContentPrototype`.`parent_id` = 211 | | 0 | 0 | 0 |
196 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'branches') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'config') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
197 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `SWPM_public`.`aros` AS `Aro` INNER JOIN `SWPM_public`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND `Aro0`.`foreign_key` = 0 ORDER BY `Aro`.`lft` DESC | | 1 | 1 | 0 |
198 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `SWPM_public`.`acos` AS `Aco` INNER JOIN `SWPM_public`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') INNER JOIN `SWPM_public`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'controllers') INNER JOIN `SWPM_public`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'branches') INNER JOIN `SWPM_public`.`acos` AS `Aco3` ON (`Aco3`.`alias` = 'config') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco3`.`lft` AND `Aco`.`rght` >= `Aco3`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`id` = `Aco3`.`parent_id` AND `Aco3`.`rght` < `Aco2`.`rght` AND `Aco3`.`lft` > `Aco2`.`lft` ORDER BY `Aco`.`lft` DESC | | 4 | 4 | 0 |
199 | SELECT `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 `SWPM_public`.`aros_acos` AS `Permission` LEFT JOIN `SWPM_public`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `SWPM_public`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 9624 AND `Permission`.`aco_id` IN (25, 5, 3, 1) ORDER BY `Aco`.`lft` desc | | 2 | 2 | 0 |
200 | SELECT `Branch`.`id`, `Branch`.`parent_id`, `Branch`.`url`, `Branch`.`type`, `Branch`.`menuorder`, `Branch`.`pagename`, `Branch`.`prototype`, `Branch`.`variable`, `Branch`.`mode`, `Branch`.`login`, `Branch`.`layout`, `Branch`.`domain_id`, `Branch`.`created`, `Branch`.`modified` FROM `SWPM_public`.`branches` AS `Branch` WHERE `Branch`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |