| 0.0002 |
select R.*, RG.RoleGroupID from Role_Group_Link as RGL inner join Role_Group as RG on RG.RoleGroupID = RGL.RoleGroupID inner join Role as R on R.RoleID = RGL.RoleID inner join Role_Group_User as RGU on RGU.RoleGroupID = RGL.RoleGroupID where RGU.UserID = -1 union select R.*, null from Role as R inner join Role_Group_User as RGU on RGU.RoleID = R.RoleID where RGU.UserID = -1
|
| 0.0003 |
select * from Group_Moderator where UserID = -1 and GroupID = 6
|
| 0.0005 |
select * from Private where GenericType = 'group' and GenericID = 6
|
| 0.0006 |
select * from Tag where GenericID = 6 and GenericType = 'group'
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0001 |
select * from Group_Moderator
|
| 0.0001 |
select * from Tag where GenericID = 6 and GenericType = 'group'
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 109 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 146 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = -1 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0001 |
SELECT * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
|
| 0.0001 |
select * from Notification_Filter
|
| 0.0012 |
select * from Notification
|
| 0.0001 |
select * from Notification
|
| 0.0007 |
select * from Group_Member where GroupID = 6 and UserID = -1
|
| 0.0011 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0001 |
select * from Group_Member where GroupID = 6 and UserID = -1
|
| 0.0002 |
select * from Image where GenericType = 'group' and GenericID = 6 order by ImageID DESC
|
| 0.0003 |
select * from Image where GenericType = 'user' and GenericID = 37 order by ImageID DESC
|
| 0.0003 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0004 |
select * from Image where GenericType = 'user' and GenericID = 109 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 109 LIMIT 1
|
| 0.0003 |
select * from User where UserID = 109 LIMIT 1
|
| 0.0003 |
select * from Image where GenericType = 'user' and GenericID = 146 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 146 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 146 LIMIT 1
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
