| 0.0003 |
SELECT * FROM (`Url`) WHERE `GenericType` = 'category' AND `GenericID` = '102'
|
| 0.0012 |
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 = 102
|
| 0.0002 |
select * from Attribute where GenericType = 'category' and GenericID = 102
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 102
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '102' AND `Removed` = 0
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '102' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = 0
|
| 0.0005 |
SELECT * FROM (`Private`) WHERE `GenericType` = 'Category' AND `Removed` = 0
|
| 0.0038 |
SELECT * FROM (`Category`) WHERE `CategoryID` NOT IN ('746', '2144', '1131', '987', '991', '993', '994', '1055', '1079', '1088', '1090', '1094', '1149', '1150', '1246', '1299', '1305', '1308', '1309', '1311', '1464', '1473', '1493', '1494', '1518', '1519', '1520', '1530', '1531', '1761', '1721', '1729', '1733', '1735', '1736', '1765', '1766', '1767', '1768', '1769', '1770', '1771', '1772', '1773', '1774', '1776', '1777', '1778', '1779', '1780', '1781', '1782', '1783', '1784', '1786', '1803', '1810', '1815', '1816', '1817', '1818', '1819', '1820', '1821', '1822', '1823', '1824', '1825', '1826', '1827', '1828', '1829', '1830', '1831', '1832', '1833', '1834', '1835', '1861', '2011', '2012', '2013', '2014', '2016', '2017', '2018', '2022', '2069', '2080', '2082', '2083', '2084', '2085', '2086', '2087', '2088', '2089', '2090', '2091', '2092', '2093', '2094', '2095', '2096', '2097', '2098', '2099', '2100', '2101', '2102', '2103', '2112', '2113', '2114', '2115', '2116', '2117', '2118', '2119', '2120', '2121', '2122', '2123', '2124', '2125', '2133', '2128', '2129', '2130', '2131', '2132', '2134', '2135', '2136', '2137', '2233', '2234', '2373', '2390', '2653', '2950', '3006', '3374', '3823', '3824', '3825', '3826', '3827', '3828', '3829', '3830', '3831', '3832', '3833', '3834', '3835', '3836', '3837', '3838', '3839', '3840', '3841', '3842', '3843', '3844', '3845', '3846', '3847', '3848', '3849', '3850', '3932', '3934', '3935', '3936', '3937', '3938', '3939', '3940', '3941', '3942', '3943', '3944', '3953', '3954', '3955', '3956', '3957', '3958', '3959', '3999', '4026', '4029', '4030', '4045', '4045', '4045', '4046') AND `ParentID` = '102' AND `Removed` = 0 ORDER BY `Name` asc
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '102' AND `GenericType` = 'category' ORDER BY `ImageID` DESC
|
| 0.0003 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0004 |
SELECT CategoryID FROM `Category` WHERE ParentID = 102 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 109 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 110 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 111 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 496 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 497 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 501 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 732 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2356 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2570 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 499 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 500 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 502 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 731 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 730 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 733 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2227 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2349 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2357 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 306 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 305 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 736 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1169 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1524 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2385 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2777 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3945 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 4050 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 337 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 773 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 780 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1050 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 881 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 494 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 882 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1527 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 4027 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 774 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 495 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2462 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2463 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2466 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2468 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 723 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 724 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 726 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2165 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 725 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 728 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2762 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2763 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2764 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3696 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3697 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 320 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 321 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 322 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 325 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 326 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 323 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2325 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2326 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2328 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2327 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 327 AND Removed = 0
|
| 0.0006 |
SELECT CategoryID FROM `Category` WHERE ParentID = 328 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 334 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 335 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 336 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 345 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 346 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 589 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 590 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 591 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 592 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 593 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2407 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2408 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2409 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2410 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 516 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 690 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2479 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2478 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 696 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2243 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2246 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2284 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2242 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2285 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3469 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2781 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2783 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2784 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2785 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2789 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3818 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2582 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2583 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2584 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2585 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2587 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2446 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2447 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2448 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2449 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2531 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2532 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2533 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2534 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2530 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2797 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2799 AND Removed = 0
|
| 0.0004 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2800 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2801 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2803 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2814 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2812 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2894 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2895 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2896 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2898 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3777 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3778 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3779 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3780 AND Removed = 0
|
| 0.0002 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`)
|
| 1.7719 | |
| 0.0044 |
SELECT * FROM (`Collectible`) WHERE `Removed` = 0 AND `CategoryID` IN ('109', '110', '111', '496', '497', '501', '732', '2356', '2570', '499', '500', '502', '731', '730', '733', '2227', '2349', '2357', '306', '305', '736', '1169', '1524', '2385', '2777', '3945', '4050', '337', '773', '780', '1050', '881', '494', '882', '1527', '4027', '774', '495', '2462', '2463', '2466', '2468', '723', '724', '726', '2165', '725', '728', '2762', '2763', '2764', '3696', '3697', '320', '321', '322', '325', '326', '323', '2325', '2326', '2328', '2327', '327', '328', '334', '335', '336', '345', '346', '589', '590', '591', '592', '593', '2407', '2408', '2409', '2410', '516', '690', '2479', '2478', '696', '2243', '2246', '2284', '2242', '2285', '3469', '2781', '2783', '2784', '2785', '2789', '3818', '2582', '2583', '2584', '2585', '2587', '2446', '2447', '2448', '2449', '2531', '2532', '2533', '2534', '2530', '2797', '2799', '2800', '2801', '2803', '2814', '2812', '2894', '2895', '2896', '2898', '3777', '3778', '3779', '3780', '102') ORDER BY `CollectibleID` desc
|
| 0.8082 |
SELECT DISTINCT cs.* FROM `Collectible` AS cs, `Attribute` AS at, `Attribute_Value` AS atv WHERE cs.CategoryID IN ( 109,110,111,496,497,501,732,2356,2570,499,500,502,731,730,733,2227,2349,2357,306,305,736,1169,1524,2385,2777,3945,4050,337,773,780,1050,881,494,882,1527,4027,774,495,2462,2463,2466,2468,723,724,726,2165,725,728,2762,2763,2764,3696,3697,320,321,322,325,326,323,2325,2326,2328,2327,327,328,334,335,336,345,346,589,590,591,592,593,2407,2408,2409,2410,516,690,2479,2478,696,2243,2246,2284,2242,2285,3469,2781,2783,2784,2785,2789,3818,2582,2583,2584,2585,2587,2446,2447,2448,2449,2531,2532,2533,2534,2530,2797,2799,2800,2801,2803,2814,2812,2894,2895,2896,2898,3777,3778,3779,3780,102 ) AND cs.Removed = 0 AND atv.Removed = 0 AND cs.CollectibleID = atv.GenericID AND (at.Name = 'Name' OR at.Name = 'Title') AND atv.AttributeID = at.AttributeID ORDER BY atv.Value asc LIMIT 25
|
| 0.0003 |
SELECT GenericID FROM `Private` WHERE GenericType = "category" AND Removed = 0
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2356' LIMIT 1
|
| 0.0003 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2356' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6845' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 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 = 6845 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2356
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 497
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 111
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6845' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6845' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6845' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0008 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6845'
|
| 0.0008 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 6845 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0004 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '1527' LIMIT 1
|
| 0.0003 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '1527' LIMIT 1
|
| 0.0005 |
SELECT * FROM (`Image`) WHERE `GenericID` = '1674' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 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 = 1674 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0004 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1527
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 882
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 773
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 337
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '1674' AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '1674' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '1674' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '1674'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 1674 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '732' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '732' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6834' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0008 |
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 = 6834 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 732
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 497
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 111
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6834' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6834' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6834' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0008 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6834'
|
| 0.0005 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 6834 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '305' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '305' LIMIT 1
|
| 0.0005 |
SELECT * FROM (`Image`) WHERE `GenericID` = '7542' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0009 |
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 = 7542 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 305
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 306
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '7542' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '7542' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '7542' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0008 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '7542'
|
| 0.0007 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 7542 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '494' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '494' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '1162' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 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 = 1162 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 494
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 881
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 773
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 337
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '1162' AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '1162' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '1162' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '1162'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 1162 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '1524' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '1524' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '7836' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 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 = 7836 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1524
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 306
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '7836' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '7836' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '7836' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '7836'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 7836 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '1524' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '1524' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '3562' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0008 |
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 = 3562 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1524
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 306
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '3562' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '3562' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '3562' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '3562'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 3562 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '500' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '500' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '2770' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 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 = 2770 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 500
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 111
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '2770' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '2770' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '2770' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '2770'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 2770 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '500' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '500' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '16490' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0007 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 16490 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 500
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 111
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0040 |
SELECT * FROM (`Review`) WHERE `GenericID` = '16490' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '16490' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0029 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '16490' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '16490'
|
| 0.0005 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 16490 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '1527' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '1527' LIMIT 1
|
| 0.0005 |
SELECT * FROM (`Image`) WHERE `GenericID` = '1841' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0008 |
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 = 1841 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1527
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 882
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 773
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 337
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '1841' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '1841' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '1841' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '1841'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 1841 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '500' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '500' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6446' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0008 |
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 = 6446 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 500
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 111
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6446' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6446' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6446' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6446'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 6446 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2385' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2385' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '8155' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0007 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 8155 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2385
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 306
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '8155' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '8155' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '8155' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '8155'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 8155 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2784' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2784' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '11485' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0008 |
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 = 11485 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2784
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2781
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 696
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 516
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '11485' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '11485' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '11485' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '11485'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 11485 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2784' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2784' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '11499' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0009 |
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 = 11499 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2784
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2781
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 696
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 516
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '11499' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '11499' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '11499' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '11499'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 11499 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '305' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '305' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '17148' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0009 |
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 = 17148 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 305
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 306
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '17148' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '17148' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '17148' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '17148'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 17148 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '500' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '500' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6449' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0007 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 6449 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 500
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 111
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6449' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6449' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6449' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0006 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6449'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 6449 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '500' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '500' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '7588' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0007 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 7588 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 500
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 111
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '7588' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '7588' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '7588' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0006 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '7588'
|
| 0.0005 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 7588 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '494' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '494' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '1170' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 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 = 1170 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 494
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 881
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 773
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 337
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '1170' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '1170' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '1170' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '1170'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 1170 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '730' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '730' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6648' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0008 |
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 = 6648 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 730
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 731
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 111
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6648' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6648' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6648' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0006 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6648'
|
| 0.0005 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 6648 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '1524' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '1524' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '16415' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0008 |
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 = 16415 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1524
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 306
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '16415' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '16415' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '16415' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '16415'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 16415 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '1524' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '1524' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '16414' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 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 = 16414 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1524
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 306
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '16414' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '16414' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '16414' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '16414'
|
| 0.0005 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 16414 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2785' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2785' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '16370' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0009 |
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 = 16370 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2785
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2781
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 696
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 516
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '16370' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '16370' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '16370' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '16370'
|
| 0.0007 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 16370 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2785' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2785' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '16369' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0007 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 16369 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2785
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2781
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 696
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 516
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0040 |
SELECT * FROM (`Review`) WHERE `GenericID` = '16369' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '16369' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '16369' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '16369'
|
| 0.0007 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 16369 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2783' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2783' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '11591' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 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 = 11591 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2783
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2781
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 696
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 516
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '11591' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '11591' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '11591' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '11591'
|
| 0.0007 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 11591 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2356' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2356' LIMIT 1
|
| 0.0005 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6844' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0007 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 6844 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '93' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2356
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 497
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 111
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 110
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 109
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 102
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6844' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6844' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6844' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6844'
|
| 0.0006 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 6844 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.1551 |
select Tag, count(TagID) as nrTags from Tag where GenericType = 'collectible' AND GenericID IN ( 109, 110, 111, 496, 497, 501, 732, 2356, 2570, 499, 500, 502, 731, 730, 733, 2227, 2349, 2357, 306, 305, 736, 1169, 1524, 2385, 2777, 3945, 4050, 337, 773, 780, 1050, 881, 494, 882, 1527, 4027, 774, 495, 2462, 2463, 2466, 2468, 723, 724, 726, 2165, 725, 728, 2762, 2763, 2764, 3696, 3697, 320, 321, 322, 325, 326, 323, 2325, 2326, 2328, 2327, 327, 328, 334, 335, 336, 345, 346, 589, 590, 591, 592, 593, 2407, 2408, 2409, 2410, 516, 690, 2479, 2478, 696, 2243, 2246, 2284, 2242, 2285, 3469, 2781, 2783, 2784, 2785, 2789, 3818, 2582, 2583, 2584, 2585, 2587, 2446, 2447, 2448, 2449, 2531, 2532, 2533, 2534, 2530, 2797, 2799, 2800, 2801, 2803, 2814, 2812, 2894, 2895, 2896, 2898, 3777, 3778, 3779, 3780, 102, 0 ) and Tag != '' and Removed = 0 GROUP BY Tag ORDER BY nrTags DESC LIMIT 50
|
| 0.0004 |
SELECT * FROM (`Attribute`) WHERE `Removed` = 0 AND `GenericType` = 'category' AND `GenericID` = '102'
|
| 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 CategoryID FROM `Category` WHERE ParentID = 320 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2797 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2894 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3777 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2446 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 109 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 516 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2531 AND Removed = 0
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0001 |
select * from Zone
|
| 0.0001 |
select * from Zone
|