| 0.0043 |
select * from Url where data = 'plasticfetish' and GenericType = 'user'
|
| 0.0003 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0003 |
select * from User where UserID = 54 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 75 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 93 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 53 LIMIT 1
|
| 0.0059 |
select uf.*, uf.FeedID, uft.Description as TypeDescription, uft.Title as TypeTitle, uft.Template, uft.Icon from User_Feed uf inner join User_Feed_Type uft on uft.TypeID = uf.TypeID where datediff(now(), from_unixtime(uf.Date)) <= 7
|
| 0.0454 |
select * from Image where UserID = 50 and GenericType = 'album' and Removed = 0
|
| 0.0018 |
select * from Blog where UserID = 50 and Removed = 0
|
| 0.0059 |
select CollectionID from Collection where UserID = 50 and Removed = 0
|
| 0.0004 |
select CI.*, C.Name as CollectionName from Collection_Item as CI inner join Collection as C on CI.CollectionID = C.CollectionID where C.CollectionID = 30
|
| 0.0003 |
select CI.*, C.Name as CollectionName from Collection_Item as CI inner join Collection as C on CI.CollectionID = C.CollectionID where C.CollectionID = 38
|
| 0.0005 |
select CI.*, C.Name as CollectionName from Collection_Item as CI inner join Collection as C on CI.CollectionID = C.CollectionID where C.CollectionID = 1153
|
| 0.0002 |
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 * from User where UserID = 57 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 58 LIMIT 1
|
| 0.0003 |
select * from User where UserID = 87 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 38 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 86 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 81 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 36 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 49 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 64 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 80 LIMIT 1
|
| 0.0003 |
select * from User where UserID = 51 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 73 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 61 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 76 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 92 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 213 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 96 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 109 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 53 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 93 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 75 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 54 LIMIT 1
|
| 0.0020 |
select CollectionID from Collection where UserID = 50 group by CollectionID
|
| 0.0001 |
select CI.*, C.Name as CollectionName from Collection_Item as CI inner join Collection as C on CI.CollectionID = C.CollectionID where C.CollectionID = 30
|
| 0.0002 |
select CI.*, C.Name as CollectionName from Collection_Item as CI inner join Collection as C on CI.CollectionID = C.CollectionID where C.CollectionID = 38
|
| 0.0002 |
select CI.*, C.Name as CollectionName from Collection_Item as CI inner join Collection as C on CI.CollectionID = C.CollectionID where C.CollectionID = 1153
|
| 0.0007 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 1117 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0199 |
select c.*, (IsCategoryPrivate(CategoryID) = 1) as Private, (select count(CollectibleID) from Collectible where CategoryID = c.CategoryID and Removed = 0) as CollectibleCount from Category c where c.CategoryID = 130
|
| 0.0003 |
select * from Attribute where GenericType = 'category' and GenericID = 130
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 1
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 98
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 3
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 66
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 5
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 116
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 129
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 130
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 1083 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0195 |
select c.*, (IsCategoryPrivate(CategoryID) = 1) as Private, (select count(CollectibleID) from Collectible where CategoryID = c.CategoryID and Removed = 0) as CollectibleCount from Category c where c.CategoryID = 130
|
| 0.0002 |
select * from Attribute where GenericType = 'category' and GenericID = 130
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 1
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 98
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 3
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 66
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 5
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 116
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 129
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 130
|
| 0.0451 |
select * from Image where GenericType='album' and UserID =50 and Removed = 0
|
| 0.0028 |
select C.*, (select count(CollectionID) from Collection where ParentID = C.CollectionID and Removed = 0) as HasChildren, (select count(CollectionItemID) from Collection_Item where CollectionID = C.CollectionID) as HasCollectionItems, (select count(AttributeID) from Attribute where (GenericType = 'collection:have' or GenericType = 'collection:want') and GenericID = C.CollectionID) as AttributeCount from Collection as C
|
| 0.0002 |
select * from User_Listing
|
| 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 User where UserID = -1 LIMIT 1
|
| 0.0002 |
select * from Image where GenericType = 'user' and GenericID = 50 order by ImageID DESC
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Image where GenericType = 'user' and GenericID = 50 order by ImageID DESC
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0004 |
select * from Url where GenericType = 'collection' and GenericID = 1153
|
| 0.0002 |
select * from Url where GenericType = 'collection' and GenericID = 1153
|
| 0.0003 |
select * from Image where GenericType = 'collection' and GenericID = 1153 order by ImageID DESC
|
| 0.0001 |
select * from Url where GenericType = 'collection' and GenericID = 1153
|
| 0.0003 |
select * from Url where GenericType = 'collection' and GenericID = 30
|
| 0.0003 |
select * from Image where GenericType = 'collection' and GenericID = 30 order by ImageID DESC
|
| 0.0002 |
select * from Url where GenericType = 'collection' and GenericID = 30
|
| 0.0003 |
select * from Url where GenericType = 'collection' and GenericID = 38
|
| 0.0003 |
select * from Image where GenericType = 'collection' and GenericID = 38 order by ImageID DESC
|
| 0.0002 |
select * from Url where GenericType = 'collection' and GenericID = 38
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0006 |
select * from Image where GenericType = 'collectible' and GenericID = 1117 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 1083 order by ImageID DESC
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0003 |
select * from Url where GenericType = 'album' and GenericID = 10
|
| 0.0003 |
select * from Image where GenericType = 'album' and GenericID = 10 order by ImageID DESC
|
| 0.0002 |
select * from Url where GenericType = 'album' and GenericID = 10
|
| 0.0002 |
select * from Url where GenericType = 'album' and GenericID = 10
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Image where GenericType = 'user' and GenericID = 50 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0001 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0002 |
select * from Image where GenericType = 'user' and GenericID = 53 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 53 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 53 LIMIT 1
|
| 0.0002 |
select * from Image where GenericType = 'user' and GenericID = 50 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0001 |
select * from Image where GenericType = 'user' and GenericID = 93 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 93 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 93 LIMIT 1
|
| 0.0002 |
select * from Image where GenericType = 'user' and GenericID = 50 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0002 |
select * from Image where GenericType = 'user' and GenericID = 50 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 50 LIMIT 1
|
| 0.0002 |
select * from Image where GenericType = 'user' and GenericID = 75 order by ImageID DESC
|
| 0.0002 |
select * from User where UserID = 75 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 75 LIMIT 1
|
| 0.0002 |
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 Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|