| 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 = 18
|
| 0.0005 |
select * from Private where GenericType = 'group' and GenericID = 18
|
| 0.0007 |
select * from Tag where GenericID = 18 and GenericType = 'group'
|
| 0.0002 |
select * from User where UserID = 87 LIMIT 1
|
| 0.0002 |
select * from Group_Moderator
|
| 0.0002 |
select * from Tag where GenericID = 18 and GenericType = 'group'
|
| 0.0004 |
select * from User where UserID = 700 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 229 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 213 LIMIT 1
|
| 0.0004 |
select * from User where UserID = 475 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 284 LIMIT 1
|
| 0.0002 |
SELECT * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
|
| 0.0002 |
select * from Notification_Filter
|
| 0.0002 |
select * from Notification
|
| 0.0002 |
select * from Notification
|
| 0.0007 |
select * from Group_Member where GroupID = 18 and UserID = -1
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Group_Member where GroupID = 18 and UserID = -1
|
| 0.0002 |
select * from Image where GenericType = 'group' and GenericID = 18 order by ImageID DESC
|
| 0.0003 |
select * from Image where GenericType = 'user' and GenericID = 700 order by ImageID DESC
|
| 0.0003 |
select * from User where UserID = 700 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 700 LIMIT 1
|
| 0.0004 |
select * from Image where GenericType = 'user' and GenericID = 229 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 229 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 229 LIMIT 1
|
| 0.0001 |
select * from Image where GenericType = 'user' and GenericID = 213 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 213 LIMIT 1
|
| 0.0001 |
select * from User where UserID = 213 LIMIT 1
|
| 0.0002 |
select * from Image where GenericType = 'user' and GenericID = 475 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 475 LIMIT 1
|
| 0.0001 |
select * from User where UserID = 475 LIMIT 1
|
| 0.0001 |
select * from Image where GenericType = 'user' and GenericID = 284 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 284 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 284 LIMIT 1
|
| 0.0001 |
select * from Zone
|
| 0.0001 |
select * from Zone
|