| 0.0003 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2389' AND `Removed` = 0
|
| 0.0003 |
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.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2387' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2387'
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '302' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '2387'
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2388' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2388'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '302' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '2388'
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2389' AND `Removed` = 0
|
| 0.0003 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '2389'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '302' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '2389'
|
| 0.0010 |
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 = 2389 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0148 |
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.0001 |
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.0001 |
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.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 302
|
| 0.0002 |
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.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 3
|
| 0.0002 |
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.0045 |
SELECT * FROM (`Review`) WHERE `GenericID` = '2389' AND `GenericType` = 'collectible' AND `Removed` = 0 ORDER BY `Date` DESC
|
| 0.0033 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '2389' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '2389' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0006 |
SELECT RatingID, Rating FROM Rating WHERE `GenericID` = 2389 AND `Removed` = 0 Order BY Rating DESC LIMIT 1
|
| 0.0013 |
SELECT * FROM (`Review`) WHERE `RatingID` IS NULL
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37'
|
| 0.0001 |
SELECT `CollectorType` FROM (`User`) WHERE `UserID` = '37'
|
| 0.0006 |
SELECT RatingID, Rating FROM Rating WHERE `GenericID` = 2389 AND `Removed` = 0 Order BY Rating ASC LIMIT 1
|
| 0.0013 |
SELECT * FROM (`Review`) WHERE `RatingID` IS NULL
|
| 0.0003 |
SELECT * FROM (`User`) WHERE `UserID` = '37'
|
| 0.0002 |
SELECT `CollectorType` FROM (`User`) WHERE `UserID` = '37'
|
| 0.0044 |
SELECT * FROM (`Review`) WHERE `GenericID` = '2389' AND `GenericType` = 'collectible' AND `Removed` = 0 AND `Recommend` = 'yes'
|
| 0.0033 |
SELECT Rating, count( * ) as nrVotes FROM `Review` WHERE GenericID = 2389 AND GenericType = 'collectible' GROUP BY Rating
|
| 0.0007 |
select * from Image where GenericType = 'collectible' and GenericID = 2389 order by ImageID DESC
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3532'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3531'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3530'
|
| 0.0003 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3529'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3528'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3527'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3526'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3525'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3524'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3523'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3522'
|
| 0.0003 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3521'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '182' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `ImageID` = '3520'
|
| 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.0002 |
select * from Value
|
| 0.0001 |
select CollectibleID from Collectible where CategoryID = 2389
|
| 0.0001 |
select CategoryID from Category where ParentID = '2389'
|
| 0.0148 |
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 = 2391
|
| 0.0002 |
select * from Attribute where GenericType = 'category' and GenericID = 2391
|
| 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 = 107
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2387
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2388
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2389
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2391
|
| 0.0147 |
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 = 2392
|
| 0.0003 |
select * from Attribute where GenericType = 'category' and GenericID = 2392
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 1
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 2
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 107
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2387
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2388
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2389
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2392
|
| 0.0002 |
select CollectibleID from Collectible where CategoryID = 2391
|
| 0.0002 |
select * from Tag where GenericID = 7452 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 = 7452 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 = '2391'
|
| 0.0001 |
select CollectibleID from Collectible where CategoryID = 2392
|
| 0.0002 |
select * from Tag where GenericID = 7453 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 = 7453 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 = '2392'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2391
|
| 0.0001 |
select CategoryID from Category where ParentID = '2391'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2392
|
| 0.0001 |
select CategoryID from Category where ParentID = '2392'
|
| 0.0002 |
select * from User where UserID = 182 LIMIT 1
|
| 0.1446 |
select * from Tag where GenericID = 2389 and GenericType = 'collectible'
|
| 0.0003 |
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 = 2389 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0006 |
select * from Collectible_Variation where CollectibleID = 2389
|
| 0.0035 |
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 = 2389
|
| 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 = 2389 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 = 2389 ORDER BY a.Position, a.AttributeID ASC
|
| 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 = 37 LIMIT 1
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 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 = 37 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 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.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 (`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.0002 |
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.0002 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0002 |
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.0002 |
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.0002 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0002 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0002 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0002 |
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.0005 |
select c.*, u.Username from Comment c inner join User u on u.UserID = c.UserID where c.GenericType = 'collectible' and c.GenericID = 2389
|
| 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 = 2389
|
| 0.0002 |
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.0002 |
select *, (Max - Used) as Remaining from User_Value_Allowance
|
| 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 = 2389
|
| 0.0002 |
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.0002 |
select * from Notification_Filter
|
| 0.0002 |
select * from Notification
|
| 0.0002 |
select * from Notification
|
| 0.0002 |
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.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 2387 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 2388 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 2389 order by ImageID DESC
|
| 0.0002 |
select * from Zone
|
| 0.0001 |
select * from Zone
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0034 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0034 |
select * from User
|
| 0.0003 |
select * from Zone
|
| 0.0002 |
select * from Zone
|