| 0.0003 |
select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
|
| 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 = 1
|
| 0.0002 |
select * from Private where GenericType = 'group' and GenericID = 1
|
| 0.0002 |
select * from Group_Moderator
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from Tag where GenericID = 1 and GenericType = 'group'
|
| 0.0003 |
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 = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 54 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 165 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 213 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 213 LIMIT 1
|
| 0.0001 |
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.0002 |
select * from Notification
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Group_Member where GroupID = 1 and UserID = -1
|
| 0.0002 |
select * from Group_Moderator where UserID = -1 and GroupID = 1
|
| 0.0002 |
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.0002 |
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.0002 |
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.0001 |
select * from Image where GenericType = 'user' and GenericID = 54 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 54 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 54 LIMIT 1
|
| 0.0002 |
select * from Image where GenericType = 'user' and GenericID = 165 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 165 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 165 LIMIT 1
|
| 0.0002 |
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.0002 |
select * from Image where GenericType = 'user' and GenericID = 213 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 213 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 213 LIMIT 1
|
| 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.0002 |
select * from Image where GenericType = 'user' and GenericID = 213 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 213 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 213 LIMIT 1
|
| 0.0002 |
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.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|