| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17050' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '16545' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '16545'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '16545'
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17046' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17046'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '17046'
|
| 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.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17048' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17048'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '302' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '17048'
|
| 0.0001 |
SELECT `AttributeID` FROM `Attribute` WHERE GenericID = 302 AND Name = 'Name'
|
| 0.0001 |
SELECT `Value` FROM `Attribute_Value` WHERE `AttributeID` = 1339 LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17049' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17049'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '17049'
|
| 0.0001 |
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` = '17050' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17050'
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '17050'
|
| 0.0002 |
SELECT `AttributeID` FROM `Attribute` WHERE GenericID = 304 AND Name = 'Name'
|
| 0.0002 |
SELECT `Value` FROM `Attribute_Value` WHERE `AttributeID` = 1421 LIMIT 1
|
| 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 = 17050 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0151 |
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 = 304
|
| 0.0003 |
select * from Attribute where GenericType = 'category' and GenericID = 304
|
| 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 = 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 = 304
|
| 0.0002 |
select CategoryID from Category where ParentID = '304'
|
| 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 = 304
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 298
|
| 0.0001 |
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.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0002 |
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 = 304
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '17050' AND `GenericType` = 'collectible' AND `Removed` = 0 ORDER BY `Date` DESC
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '17050' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '17050' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT RatingID, Rating FROM Rating WHERE `GenericID` = 17050 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.0003 |
SELECT `CollectorType` FROM (`User`) WHERE `UserID` = '37'
|
| 0.0001 |
SELECT RatingID, Rating FROM Rating WHERE `GenericID` = 17050 AND `Removed` = 0 Order BY Rating ASC LIMIT 1
|
| 0.0014 |
SELECT * FROM (`Review`) WHERE `RatingID` IS NULL
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37'
|
| 0.0003 |
SELECT `CollectorType` FROM (`User`) WHERE `UserID` = '37'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '17050' AND `GenericType` = 'collectible' AND `Removed` = 0 AND `Recommend` = 'yes'
|
| 0.0002 |
SELECT Rating, count( * ) as nrVotes FROM `Review` WHERE GenericID = 17050 AND GenericType = 'collectible' GROUP BY Rating
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 17050 order by ImageID DESC
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25673'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25672'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25671'
|
| 0.0003 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25670'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25669'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25668'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25667'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25666'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25665'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25664'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25663'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25662'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25661'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25660'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25659'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25658'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25657'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25656'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25655'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25654'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25653'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25652'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25651'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25650'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25649'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25648'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `ImageID` = '25647'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' 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 = 17050
|
| 0.0001 |
select CategoryID from Category where ParentID = '17050'
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0001 |
select * from Tag where GenericID = 17050 and GenericType = 'collectible'
|
| 0.0002 |
SELECT * FROM Attribute WHERE Removed = 0 AND `GenericType` = 'category' AND `GenericID` = 304 ORDER BY `Position`, `AttributeID` ASC
|
| 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 = 17050 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0001 |
select * from Collectible_Variation where CollectibleID = 17050
|
| 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 = 17050
|
| 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 = 17050 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 = 17050 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.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.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.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.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.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.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0002 |
select c.*, u.Username from Comment c inner join User u on u.UserID = c.UserID where c.GenericType = 'collectible' and c.GenericID = 17050
|
| 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 = 17050
|
| 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 = 17050
|
| 0.0002 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0003 |
SELECT * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
|
| 0.0001 |
select * from Notification_Filter
|
| 0.0002 |
select * from Notification
|
| 0.0001 |
select * from Notification
|
| 0.0001 |
select * from Image where GenericType = 'collectible' and GenericID = 16545 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 17046 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 17048 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 17049 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 17050 order by ImageID DESC
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0033 |
select * from User
|
| 0.0034 |
select * from User
|
| 0.0034 |
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.0033 |
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.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|