Please enter your username and password

Forgot your password?

(default) 72 queries took 66 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `User`.`id`, `User`.`firstname`, `User`.`lastname`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`email_signature`, `User`.`repost_user`, `User`.`repost_password`, `User`.`gmail_username`, `User`.`gmail_password`, `User`.`permission_group_id`, `User`.`team_id`, `User`.`sales_team_id`, `User`.`manage_own_splits`, `User`.`phone`, `User`.`position`, `User`.`profile_link`, `User`.`status`, `User`.`default_period`, `User`.`custom_period`, `User`.`comments`, `User`.`unique_id`, `User`.`agent_group`, `User`.`sales_agent_group`, `User`.`thumbnail`, `User`.`created`, `User`.`updated`, `User`.`allow_referral`, (CONCAT(`User`.`firstname`, " ", `User`.`lastname`)) AS `User__name` FROM `intranet_bohemia`.`users` AS `User` WHERE `User`.`id` IS NULL ORDER BY (CONCAT(`User`.`firstname`, " ", `User`.`lastname`)) asc LIMIT 1000
2SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'role_tech_admin') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC331
3SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
4SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
5SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'role_tech_admin') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC331
6SELECT `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 `intranet_bohemia`.`aros_acos` AS `Permission` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `intranet_bohemia`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 22 AND `Permission`.`aco_id` IN (382, 380, 1) ORDER BY `Aco`.`lft` desc110
7SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'role_super_admin') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC001
8SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
9SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'agent_login_as') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC331
10SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
11SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
12SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'agent_login_as') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC331
13SELECT `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 `intranet_bohemia`.`aros_acos` AS `Permission` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `intranet_bohemia`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 22 AND `Permission`.`aco_id` IN (63, 17, 1) ORDER BY `Aco`.`lft` desc110
14SELECT `User`.`id`, (CONCAT(`User`.`firstname`, " ", `User`.`lastname`)) AS `User__name` FROM `intranet_bohemia`.`users` AS `User` WHERE 1 = 1 ORDER BY (CONCAT(`User`.`firstname`, " ", `User`.`lastname`)) asc146614663
15SELECT `Landlord`.`id`, `Landlord`.`name` FROM `intranet_bohemia`.`landlords` AS `Landlord` WHERE `Landlord`.`external_id` IS NULL ORDER BY `Landlord`.`name` asc2079207910
16SELECT `Neighborhood`.`id`, `Neighborhood`.`name` FROM `intranet_bohemia`.`neighborhoods` AS `Neighborhood` WHERE 1 = 11141140
17SELECT `Config`.`id`, `Config`.`name`, `Config`.`identifier`, `Config`.`value`, `Config`.`created`, `Config`.`updated` FROM `intranet_bohemia`.`configs` AS `Config` WHERE `identifier` = 'ticker_time' LIMIT 1110
18SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'agent_admin') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC331
19SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
20SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
21SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'agent_admin') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC331
22SELECT `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 `intranet_bohemia`.`aros_acos` AS `Permission` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `intranet_bohemia`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 22 AND `Permission`.`aco_id` IN (55, 17, 1) ORDER BY `Aco`.`lft` desc110
23SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'role_admins') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC331
24SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
25SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
26SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'role_admins') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC331
27SELECT `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 `intranet_bohemia`.`aros_acos` AS `Permission` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `intranet_bohemia`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 22 AND `Permission`.`aco_id` IN (384, 380, 1) ORDER BY `Aco`.`lft` desc110
28SELECT `Quote`.`id`, `Quote`.`user_id`, `Quote`.`author`, `Quote`.`body`, `Quote`.`publishing_option`, `Quote`.`created`, `Quote`.`updated` FROM `intranet_bohemia`.`quotes` AS `Quote` WHERE `Quote`.`publishing_option` = '1' ORDER BY RAND() ASC LIMIT 10000
29SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'BuildingType'11111
30SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'FloorType'32321
31SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'LayoutType'23231
32SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'FirePlaceType'441
33SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'FirePlaceType'441
34SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'BuildingFeaturesType'45451
35SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description`, `Lookuptable`.`LookupType` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'BuildingFeaturesType'45451
36SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'BuildingFeaturesFeeType'661
37SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'WasherDryerType'331
38SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'KitchenType'31311
39SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'KitchenType'31311
40SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'OutDoorType'12121
41SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'OwnershipType'13131
42SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'PetPolicyType'551
43SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'SalesStatusType'15151
44SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'AgeType'221
45SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'DoormanType'22221
46SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'ClosetType'661
47SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'ClosetType'661
48SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'LightingType'661
49SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'WasherDryerType'331
50SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'WasherDryerType'331
51SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'AccessType'551
52SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'RoomsType'23231
53SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'LightingType'661
54SELECT `PermissionGroup`.`id`, `PermissionGroup`.`name` FROM `intranet_bohemia`.`permission_groups` AS `PermissionGroup` WHERE 1 = 1990
55SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'role_tech_admin') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC331
56SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
57SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
58SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'role_tech_admin') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC331
59SELECT `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 `intranet_bohemia`.`aros_acos` AS `Permission` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `intranet_bohemia`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 22 AND `Permission`.`aco_id` IN (382, 380, 1) ORDER BY `Aco`.`lft` desc110
60SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'role_super_admin') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC001
61SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
62SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'role_admins') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC331
63SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
64SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `intranet_bohemia`.`aros` AS `Aro` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Agents') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC221
65SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `intranet_bohemia`.`acos` AS `Aco` LEFT JOIN `intranet_bohemia`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'role_admins') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC331
66SELECT `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 `intranet_bohemia`.`aros_acos` AS `Permission` LEFT JOIN `intranet_bohemia`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `intranet_bohemia`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 22 AND `Permission`.`aco_id` IN (384, 380, 1) ORDER BY `Aco`.`lft` desc110
67SELECT `TeamLeader`.`id`, `TeamLeader`.`team_id`, `TeamLeader`.`user_id`, `TeamLeader`.`primary_leader`, `Team`.`id`, `Team`.`team_type`, `Team`.`name`, `Team`.`description`, `Team`.`created`, `Team`.`updated`, `User`.`id`, `User`.`firstname`, `User`.`lastname`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`email_signature`, `User`.`repost_user`, `User`.`repost_password`, `User`.`gmail_username`, `User`.`gmail_password`, `User`.`permission_group_id`, `User`.`team_id`, `User`.`sales_team_id`, `User`.`manage_own_splits`, `User`.`phone`, `User`.`position`, `User`.`profile_link`, `User`.`status`, `User`.`default_period`, `User`.`custom_period`, `User`.`comments`, `User`.`unique_id`, `User`.`agent_group`, `User`.`sales_agent_group`, `User`.`thumbnail`, `User`.`created`, `User`.`updated`, `User`.`allow_referral`, (CONCAT(`User`.`firstname`, " ", `User`.`lastname`)) AS `User__name` FROM `intranet_bohemia`.`team_leaders` AS `TeamLeader` LEFT JOIN `intranet_bohemia`.`teams` AS `Team` ON (`TeamLeader`.`team_id` = `Team`.`id`) LEFT JOIN `intranet_bohemia`.`users` AS `User` ON (`TeamLeader`.`user_id` = `User`.`id`) WHERE `user_id` IS NULL LIMIT 1000
68SELECT `TeamLeader`.`id`, `TeamLeader`.`team_id`, `TeamLeader`.`user_id`, `TeamLeader`.`primary_leader`, `Team`.`id`, `Team`.`team_type`, `Team`.`name`, `Team`.`description`, `Team`.`created`, `Team`.`updated`, `User`.`id`, `User`.`firstname`, `User`.`lastname`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`email_signature`, `User`.`repost_user`, `User`.`repost_password`, `User`.`gmail_username`, `User`.`gmail_password`, `User`.`permission_group_id`, `User`.`team_id`, `User`.`sales_team_id`, `User`.`manage_own_splits`, `User`.`phone`, `User`.`position`, `User`.`profile_link`, `User`.`status`, `User`.`default_period`, `User`.`custom_period`, `User`.`comments`, `User`.`unique_id`, `User`.`agent_group`, `User`.`sales_agent_group`, `User`.`thumbnail`, `User`.`created`, `User`.`updated`, `User`.`allow_referral`, (CONCAT(`User`.`firstname`, " ", `User`.`lastname`)) AS `User__name` FROM `intranet_bohemia`.`team_leaders` AS `TeamLeader` LEFT JOIN `intranet_bohemia`.`teams` AS `Team` ON (`TeamLeader`.`team_id` = `Team`.`id`) LEFT JOIN `intranet_bohemia`.`users` AS `User` ON (`TeamLeader`.`user_id` = `User`.`id`) WHERE `user_id` IS NULL LIMIT 1000
69SELECT `TeamLeader`.`id`, `TeamLeader`.`team_id`, `TeamLeader`.`user_id`, `TeamLeader`.`primary_leader`, `Team`.`id`, `Team`.`team_type`, `Team`.`name`, `Team`.`description`, `Team`.`created`, `Team`.`updated`, `User`.`id`, `User`.`firstname`, `User`.`lastname`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`email_signature`, `User`.`repost_user`, `User`.`repost_password`, `User`.`gmail_username`, `User`.`gmail_password`, `User`.`permission_group_id`, `User`.`team_id`, `User`.`sales_team_id`, `User`.`manage_own_splits`, `User`.`phone`, `User`.`position`, `User`.`profile_link`, `User`.`status`, `User`.`default_period`, `User`.`custom_period`, `User`.`comments`, `User`.`unique_id`, `User`.`agent_group`, `User`.`sales_agent_group`, `User`.`thumbnail`, `User`.`created`, `User`.`updated`, `User`.`allow_referral`, (CONCAT(`User`.`firstname`, " ", `User`.`lastname`)) AS `User__name` FROM `intranet_bohemia`.`team_leaders` AS `TeamLeader` LEFT JOIN `intranet_bohemia`.`teams` AS `Team` ON (`TeamLeader`.`team_id` = `Team`.`id`) LEFT JOIN `intranet_bohemia`.`users` AS `User` ON (`TeamLeader`.`user_id` = `User`.`id`) WHERE `user_id` IS NULL LIMIT 1000
70SELECT `TeamLeader`.`id`, `TeamLeader`.`team_id`, `TeamLeader`.`user_id`, `TeamLeader`.`primary_leader`, `Team`.`id`, `Team`.`team_type`, `Team`.`name`, `Team`.`description`, `Team`.`created`, `Team`.`updated`, `User`.`id`, `User`.`firstname`, `User`.`lastname`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`email_signature`, `User`.`repost_user`, `User`.`repost_password`, `User`.`gmail_username`, `User`.`gmail_password`, `User`.`permission_group_id`, `User`.`team_id`, `User`.`sales_team_id`, `User`.`manage_own_splits`, `User`.`phone`, `User`.`position`, `User`.`profile_link`, `User`.`status`, `User`.`default_period`, `User`.`custom_period`, `User`.`comments`, `User`.`unique_id`, `User`.`agent_group`, `User`.`sales_agent_group`, `User`.`thumbnail`, `User`.`created`, `User`.`updated`, `User`.`allow_referral`, (CONCAT(`User`.`firstname`, " ", `User`.`lastname`)) AS `User__name` FROM `intranet_bohemia`.`team_leaders` AS `TeamLeader` LEFT JOIN `intranet_bohemia`.`teams` AS `Team` ON (`TeamLeader`.`team_id` = `Team`.`id`) LEFT JOIN `intranet_bohemia`.`users` AS `User` ON (`TeamLeader`.`user_id` = `User`.`id`) WHERE `user_id` IS NULL LIMIT 1000
71SELECT `TeamLeader`.`id`, `TeamLeader`.`team_id`, `TeamLeader`.`user_id`, `TeamLeader`.`primary_leader`, `Team`.`id`, `Team`.`team_type`, `Team`.`name`, `Team`.`description`, `Team`.`created`, `Team`.`updated`, `User`.`id`, `User`.`firstname`, `User`.`lastname`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`email_signature`, `User`.`repost_user`, `User`.`repost_password`, `User`.`gmail_username`, `User`.`gmail_password`, `User`.`permission_group_id`, `User`.`team_id`, `User`.`sales_team_id`, `User`.`manage_own_splits`, `User`.`phone`, `User`.`position`, `User`.`profile_link`, `User`.`status`, `User`.`default_period`, `User`.`custom_period`, `User`.`comments`, `User`.`unique_id`, `User`.`agent_group`, `User`.`sales_agent_group`, `User`.`thumbnail`, `User`.`created`, `User`.`updated`, `User`.`allow_referral`, (CONCAT(`User`.`firstname`, " ", `User`.`lastname`)) AS `User__name` FROM `intranet_bohemia`.`team_leaders` AS `TeamLeader` LEFT JOIN `intranet_bohemia`.`teams` AS `Team` ON (`TeamLeader`.`team_id` = `Team`.`id`) LEFT JOIN `intranet_bohemia`.`users` AS `User` ON (`TeamLeader`.`user_id` = `User`.`id`) WHERE `user_id` IS NULL LIMIT 1000
72SELECT `TeamLeader`.`id`, `TeamLeader`.`team_id`, `TeamLeader`.`user_id`, `TeamLeader`.`primary_leader`, `Team`.`id`, `Team`.`team_type`, `Team`.`name`, `Team`.`description`, `Team`.`created`, `Team`.`updated`, `User`.`id`, `User`.`firstname`, `User`.`lastname`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`email_signature`, `User`.`repost_user`, `User`.`repost_password`, `User`.`gmail_username`, `User`.`gmail_password`, `User`.`permission_group_id`, `User`.`team_id`, `User`.`sales_team_id`, `User`.`manage_own_splits`, `User`.`phone`, `User`.`position`, `User`.`profile_link`, `User`.`status`, `User`.`default_period`, `User`.`custom_period`, `User`.`comments`, `User`.`unique_id`, `User`.`agent_group`, `User`.`sales_agent_group`, `User`.`thumbnail`, `User`.`created`, `User`.`updated`, `User`.`allow_referral`, (CONCAT(`User`.`firstname`, " ", `User`.`lastname`)) AS `User__name` FROM `intranet_bohemia`.`team_leaders` AS `TeamLeader` LEFT JOIN `intranet_bohemia`.`teams` AS `Team` ON (`TeamLeader`.`team_id` = `Team`.`id`) LEFT JOIN `intranet_bohemia`.`users` AS `User` ON (`TeamLeader`.`user_id` = `User`.`id`) WHERE `user_id` IS NULL LIMIT 1000
(default) 72 queries took 66 ms
NrQueryErrorAffectedNum. rowsTook (ms)