| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '722' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '4205' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '4205'
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '4205'
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '5511' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '5511'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '5511'
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '5512' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '5512'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '5512'
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '707' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '707'
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '302' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '707'
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '722' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '722'
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '722'
|
| 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 = 722 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0153 |
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.0002 |
select * from Private where GenericType = 'category' and GenericID = 2
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 98
|
| 0.0001 |
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.0001 |
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.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.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` = '722' AND `GenericType` = 'collectible' AND `Removed` = 0 ORDER BY `Date` DESC
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '722' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '722' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT RatingID, Rating FROM Rating WHERE `GenericID` = 722 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.0001 |
SELECT `CollectorType` FROM (`User`) WHERE `UserID` = '37'
|
| 0.0001 |
SELECT RatingID, Rating FROM Rating WHERE `GenericID` = 722 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.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '722' AND `GenericType` = 'collectible' AND `Removed` = 0 AND `Recommend` = 'yes'
|
| 0.0001 |
SELECT Rating, count( * ) as nrVotes FROM `Review` WHERE GenericID = 722 AND GenericType = 'collectible' GROUP BY Rating
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 722 order by ImageID DESC
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '1229'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '1228'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '1227'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `ImageID` = '1226'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `ImageID` = '1225'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '1224'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '1223'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '1222'
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `ImageID` = '1221'
|
| 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 = 722
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 107
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 619
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 620
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 631
|
| 0.0001 |
select * from Tag where GenericID = 662 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 = 662 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 663 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 = 663 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 664 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 = 664 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 665 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 = 665 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 666 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 = 666 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 667 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 = 667 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 668 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 = 668 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 669 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 = 669 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 670 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 = 670 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 672 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 = 672 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 673 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 = 673 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 674 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 = 674 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 675 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 = 675 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 676 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 = 676 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 677 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 = 677 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 678 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 = 678 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 679 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 = 679 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 680 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 = 680 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 682 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 = 682 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 = 683 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 = 683 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 684 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 = 684 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 685 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 = 685 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 = 686 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 = 686 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 = 687 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 = 687 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 = 688 and GenericType = 'collectible'
|
| 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 = 688 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 2718 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 = 2718 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 = 2719 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 = 2719 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 = 2720 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 = 2720 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 2721 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 = 2721 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 2722 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 = 2722 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 = 2723 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 = 2723 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 2724 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 = 2724 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 = 2725 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 = 2725 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 = 2726 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 = 2726 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 2727 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 = 2727 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 = 2801 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 = 2801 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 2802 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 = 2802 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 = 2803 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 = 2803 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 = 2804 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 = 2804 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 2805 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 = 2805 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 2806 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 = 2806 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 12111 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 = 12111 and (av.Removed = 0 or av.Removed is null) and (a.Removed is null or a.Removed = 0)
|
| 0.0002 |
select * from Tag where GenericID = 12114 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 = 12114 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 = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0002 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 722
|
| 0.0001 |
select CategoryID from Category where ParentID = '722'
|
| 0.0002 |
select * from User where UserID = 37 LIMIT 1
|
| 0.0002 |
select * from Tag where GenericID = 722 and GenericType = 'collectible'
|
| 0.0002 |
SELECT * FROM Attribute WHERE Removed = 0 AND `GenericType` = 'category' AND `GenericID` = 304 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 = 722 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
select * from Collectible_Variation where CollectibleID = 722
|
| 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 = 722
|
| 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 = 722 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 = 722 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.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.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.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 * 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 c.*, u.Username from Comment c inner join User u on u.UserID = c.UserID where c.GenericType = 'collectible' and c.GenericID = 722
|
| 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 = 722
|
| 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.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 = 722
|
| 0.0001 |
select * from User_Listing
|
| 0.0001 |
select * from User_Listing
|
| 0.0002 |
select * from User_Listing
|
| 0.0002 |
select * from User_Listing
|
| 0.0001 |
select * from User_Listing
|
| 0.0002 |
select * from User_Listing
|
| 0.0002 |
select * from User_Listing
|
| 0.0002 |
select * from User_Listing
|
| 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 = 4205 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 5511 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 5512 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 707 order by ImageID DESC
|
| 0.0002 |
select * from Image where GenericType = 'collectible' and GenericID = 722 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.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.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.0032 |
select * from User
|
| 0.0032 |
select * from User
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|