Please enter your username and password

Forgot your password?

(default) 78 queries took 68 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` DESC331
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 `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
10SELECT `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` DESC331
11SELECT `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 (383, 380, 1) ORDER BY `Aco`.`lft` desc110
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 `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
14SELECT `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
15SELECT `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
16SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `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
17SELECT `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`)) asc139113912
18SELECT `Landlord`.`id`, `Landlord`.`name` FROM `intranet_bohemia`.`landlords` AS `Landlord` WHERE `Landlord`.`external_id` IS NULL ORDER BY `Landlord`.`name` asc205620569
19SELECT `Neighborhood`.`id`, `Neighborhood`.`name` FROM `intranet_bohemia`.`neighborhoods` AS `Neighborhood` WHERE 1 = 11141140
20SELECT `Config`.`id`, `Config`.`name`, `Config`.`identifier`, `Config`.`value`, `Config`.`created`, `Config`.`updated` FROM `intranet_bohemia`.`configs` AS `Config` WHERE `identifier` = 'ticker_time' LIMIT 1110
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 `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
23SELECT `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
24SELECT `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
25SELECT `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
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 `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
28SELECT `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
29SELECT `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
30SELECT `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
31SELECT `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
32SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'BuildingType'11111
33SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'FloorType'32321
34SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'LayoutType'23231
35SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'FirePlaceType'441
36SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'FirePlaceType'441
37SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'BuildingFeaturesType'45451
38SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description`, `Lookuptable`.`LookupType` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'BuildingFeaturesType'45451
39SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'BuildingFeaturesFeeType'661
40SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'WasherDryerType'331
41SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'KitchenType'31311
42SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'KitchenType'31311
43SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'OutDoorType'12121
44SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'OwnershipType'13131
45SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'PetPolicyType'551
46SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'SalesStatusType'15151
47SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'AgeType'221
48SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'DoormanType'22221
49SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'ClosetType'661
50SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'ClosetType'661
51SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'LightingType'661
52SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'WasherDryerType'331
53SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'WasherDryerType'331
54SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'AccessType'551
55SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'RoomsType'23231
56SELECT `Lookuptable`.`LookupCode`, `Lookuptable`.`Description` FROM `intranet_bohemia`.`lookuptables` AS `Lookuptable` WHERE `LookupType` = 'LightingType'661
57SELECT `PermissionGroup`.`id`, `PermissionGroup`.`name` FROM `intranet_bohemia`.`permission_groups` AS `PermissionGroup` WHERE 1 = 1880
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 `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
60SELECT `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
61SELECT `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
62SELECT `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
63SELECT `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` DESC331
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 `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
66SELECT `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` DESC331
67SELECT `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 (383, 380, 1) ORDER BY `Aco`.`lft` desc110
68SELECT `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
69SELECT `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
70SELECT `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
71SELECT `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
72SELECT `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
73SELECT `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
74SELECT `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
75SELECT `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
76SELECT `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
77SELECT `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
78SELECT `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) 78 queries took 68 ms
NrQueryErrorAffectedNum. rowsTook (ms)