| 0.0003 |
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 = 22
|
| 0.0006 |
select * from Private where GenericType = 'group' and GenericID = 22
|
| 0.0008 |
select * from Tag where GenericID = 22 and GenericType = 'group'
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from Group_Moderator
|
| 0.0002 |
select * from Tag where GenericID = 22 and GenericType = 'group'
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0003 |
select * from User where UserID = 1304 LIMIT 1
|
| 0.0004 |
select * from User where UserID = 1283 LIMIT 1
|
| 0.0002 |
select * from User where UserID = -1 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0003 |
select * from Url where GenericType = 'discussion' and GenericID = 102
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0003 |
select * from Url where GenericType = 'discussion' and GenericID = 101
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from Url where GenericType = 'discussion' and GenericID = 100
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0003 |
select * from Url where GenericType = 'discussion' and GenericID = 99
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0003 |
select * from Url where GenericType = 'discussion' and GenericID = 98
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0003 |
select * from Url where GenericType = 'discussion' and GenericID = 97
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from Url where GenericType = 'discussion' and GenericID = 96
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 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.0001 |
select * from Notification
|
| 0.0007 |
select * from Group_Member where GroupID = 22 and UserID = -1
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Group_Member where GroupID = 22 and UserID = -1
|
| 0.0002 |
select * from Image where GenericType = 'group' and GenericID = 22 order by ImageID DESC
|
| 0.0001 |
select * from Image where GenericType = 'user' and GenericID = 37 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0003 |
select * from Url where GenericType = 'user' and GenericID = 1304
|
| 0.0003 |
select * from Image where GenericType = 'user' and GenericID = 1304 order by ImageID DESC
|
| 0.0002 |
select * from Url where GenericType = 'user' and GenericID = 1304
|
| 0.0002 |
select * from User where UserID = 1304 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 1304 LIMIT 1
|
| 0.0003 |
select * from Image where GenericType = 'user' and GenericID = 1283 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 1283 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 1283 LIMIT 1
|
| 0.0002 |
select * from Url where GenericType = 'user' and GenericID = -1
|
| 0.0002 |
select * from Image where GenericType = 'user' and GenericID = -1 order by ImageID DESC
|
| 0.0001 |
select * from Url where GenericType = 'user' and GenericID = -1
|
| 0.0002 |
select * from User where UserID = -1 LIMIT 1
|
| 0.0002 |
select * from User where UserID = -1 LIMIT 1
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
