| 0.0001 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2386' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17120' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17120'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '17120'
|
| 0.0002 |
SELECT `AttributeID` FROM `Attribute` WHERE GenericID = 304 AND Name = 'Name'
|
| 0.0001 |
SELECT `Value` FROM `Attribute_Value` WHERE `AttributeID` = 1421 LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17195' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17195'
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '17195'
|
| 0.0001 |
SELECT `AttributeID` FROM `Attribute` WHERE GenericID = 304 AND Name = 'Name'
|
| 0.0002 |
SELECT `Value` FROM `Attribute_Value` WHERE `AttributeID` = 1421 LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2335' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2335'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '2335'
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2337' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2337'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '2337'
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2386' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2386'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '302' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '2386'
|
| 0.0004 |
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 = 2386 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0181 |
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 = 302
|
| 0.0004 |
select * from Attribute where GenericType = 'category' and GenericID = 302
|
| 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 = 70
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 298
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 302
|
| 0.0002 |
select CategoryID from Category where ParentID = '302'
|
| 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.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 302
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 298
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 70
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 3
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 98
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 302
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '2386' AND `GenericType` = 'collectible' AND `Removed` = 0 ORDER BY `Date` DESC
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '2386' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '2386' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT RatingID, Rating FROM Rating WHERE `GenericID` = 2386 AND `Removed` = 0 Order BY Rating DESC LIMIT 1
|
| 0.0014 |
SELECT * FROM (`Review`) WHERE `RatingID` IS NULL
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37'
|
| 0.0002 |
SELECT `CollectorType` FROM (`User`) WHERE `UserID` = '37'
|
| 0.0002 |
SELECT RatingID, Rating FROM Rating WHERE `GenericID` = 2386 AND `Removed` = 0 Order BY Rating ASC LIMIT 1
|
| 0.0014 |
SELECT * FROM (`Review`) WHERE `RatingID` IS NULL
|
| 0.0003 |
SELECT * FROM (`User`) WHERE `UserID` = '37'
|
| 0.0001 |
SELECT `CollectorType` FROM (`User`) WHERE `UserID` = '37'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '2386' AND `GenericType` = 'collectible' AND `Removed` = 0 AND `Recommend` = 'yes'
|
| 0.0002 |
SELECT Rating, count( * ) as nrVotes FROM `Review` WHERE GenericID = 2386 AND GenericType = 'collectible' GROUP BY Rating
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 2386 order by ImageID DESC
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3491'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3490'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3489'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3488'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3487'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3486'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3485'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3484'
|
| 0.0003 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3483'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3482'
|
| 0.0001 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3481'
|
| 0.0001 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3480'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3479'
|
| 0.0001 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3478'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0002 |
select * from User where UserID = -1 LIMIT 1
|
| 0.0002 |
select * from Value
|
| 0.0001 |
select * from Value
|
| 0.0001 |
select CollectibleID from Collectible where CategoryID = 2386
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 107
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 2361
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 2362
|
| 0.0001 |
select * from Tag where GenericID = 7350 and GenericType = 'collectible'
|
| 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 = 7350 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0001 |
select * from Tag where GenericID = 7351 and GenericType = 'collectible'
|
| 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 = 7351 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0001 |
select * from Tag where GenericID = 7352 and GenericType = 'collectible'
|
| 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 = 7352 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0001 |
select CategoryID from Category where ParentID = '2386'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 2386
|
| 0.0001 |
select CategoryID from Category where ParentID = '2386'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 2386
|
| 0.0002 |
select CategoryID from Category where ParentID = '2386'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 2386
|
| 0.0001 |
select CategoryID from Category where ParentID = '2386'
|
| 0.0002 |
select * from User where UserID = 182 LIMIT 1
|
| 0.0001 |
select * from Tag where GenericID = 2386 and GenericType = 'collectible'
|
| 0.0002 |
SELECT * FROM Attribute WHERE Removed = 0 AND `GenericType` = 'category' AND `GenericID` = 302 ORDER BY `Position`, `AttributeID` ASC
|
| 0.0003 |
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 = 2386 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0001 |
select * from Collectible_Variation where CollectibleID = 2386
|
| 0.0002 |
select C.*, Cat.Name, Cat.TitleTemplate, (select count(ReviewID) from Review where GenericType = 'collectible' and GenericID = C.CollectibleID and Removed = 0) as ReviewCount, (select count(CommentID) from Comment where GenericType = 'collectible' and GenericID = C.CollectibleID and Removed = 0) as CommentCount, C.CollectibleID as Private from Collectible as C inner join Category as Cat on C.CategoryID = Cat.CategoryID where C.CollectibleID = 2386
|
| 0.0003 |
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 = 2386 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
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 = 2386 ORDER BY a.Position, a.AttributeID ASC
|
| 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 = 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 = 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 = 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 = 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 = 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 = 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 = 37 LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0001 |
select c.*, u.Username from Comment c inner join User u on u.UserID = c.UserID where c.GenericType = 'collectible' and c.GenericID = 2386
|
| 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 = 2386
|
| 0.0001 |
select GenericType, GenericID, (select Date from View_History where GenericID = vh.GenericID and GenericType = vh.GenericType order by Date desc limit 0,1) as LastDate, count(ViewHistoryID) as ViewCount from View_History vh group by GenericType, GenericID
|
| 0.0001 |
select *, (Max - Used) as Remaining from User_Value_Allowance
|
| 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 = 2386
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0002 |
SELECT * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
|
| 0.0001 |
select * from Notification_Filter
|
| 0.0001 |
select * from Notification
|
| 0.0001 |
select * from Notification
|
| 0.0001 |
select * from Image where GenericType = 'collectible' and GenericID = 17120 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 17195 order by ImageID DESC
|
| 0.0001 |
select * from Image where GenericType = 'collectible' and GenericID = 2335 order by ImageID DESC
|
| 0.0001 |
select * from Image where GenericType = 'collectible' and GenericID = 2337 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 2386 order by ImageID DESC
|
| 0.0001 |
select * from Zone
|
| 0.0001 |
select * from Zone
|
| 0.0032 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0035 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0034 |
select * from User
|
| 0.0034 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0034 |
select * from User
|
| 0.0034 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0034 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0002 |
select * from Zone
|
| 0.0001 |
select * from Zone
|