| 0.0004 |
SELECT * FROM (`Url`) WHERE `GenericType` = 'category' AND `GenericID` = '104'
|
| 0.0058 |
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 = 104
|
| 0.0004 |
select * from Attribute where GenericType = 'category' and GenericID = 104
|
| 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 = 104
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '104' AND `Removed` = 0
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '104' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = 0
|
| 0.0004 |
SELECT * FROM (`Private`) WHERE `GenericType` = 'Category' AND `Removed` = 0
|
| 0.0033 |
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` = '104' 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 = 104
|
| 0.0002 |
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.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '104' AND `GenericType` = 'category' ORDER BY `ImageID` DESC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 104 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 613 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1665 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1666 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1667 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1672 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2636 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2665 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2666 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2668 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 4028 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2669 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2673 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2674 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2680 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2681 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3977 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3978 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2663 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2664 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3454 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3456 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3390 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3391 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3392 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3393 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3394 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3452 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3453 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3455 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3624 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3625 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3734 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3735 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 4001 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1704 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1705 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1706 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 615 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1028 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1029 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1046 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1030 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1037 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1038 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1096 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1162 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2496 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2788 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3322 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3462 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1032 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1124 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1033 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1113 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1047 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1049 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2454 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2457 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3664 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3665 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1056 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1057 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2624 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2686 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2745 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3714 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1065 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3715 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1061 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1062 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2528 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2529 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2535 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3483 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3499 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1076 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1077 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1136 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2346 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2347 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2348 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3494 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2842 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2843 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3495 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3496 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3457 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3458 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3459 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3577 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3622 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3479 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3480 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3481 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3482 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3493 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3497 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3498 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2415 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2419 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2513 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2575 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2787 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2416 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2380 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2579 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1675 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1677 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1678 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1679 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1680 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2316 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2580 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2581 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2596 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3441 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3442 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3478 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3666 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3667 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3686 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3707 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3708 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3736 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3746 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3379 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3502 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3380 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3506 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3503 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3501 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3504 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3505 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3507 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3508 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3509 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3510 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3511 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3512 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3513 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3514 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3515 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 4047 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 4048 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1059 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1060 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3381 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3382 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3383 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3384 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1755 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2168 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2169 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2841 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2840 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2794 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2795 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2278 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2279 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2277 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2280 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2786 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2844 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2845 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2846 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`)
|
| 2.4336 | |
| 0.0070 |
SELECT * FROM (`Collectible`) WHERE `Removed` = 0 AND `CategoryID` IN ('613', '1665', '1666', '1667', '1672', '2636', '2665', '2666', '2668', '4028', '2669', '2673', '2674', '2680', '2681', '3977', '3978', '2663', '2664', '3454', '3456', '3390', '3391', '3392', '3393', '3394', '3452', '3453', '3455', '3624', '3625', '3734', '3735', '4001', '1704', '1705', '1706', '615', '1028', '1029', '1046', '1030', '1037', '1038', '1096', '1162', '2496', '2788', '3322', '3462', '1032', '1124', '1033', '1113', '1047', '1049', '2454', '2457', '3664', '3665', '1056', '1057', '2624', '2686', '2745', '3714', '1065', '3715', '1061', '1062', '2528', '2529', '2535', '3483', '3499', '1076', '1077', '1136', '2346', '2347', '2348', '3494', '2842', '2843', '3495', '3496', '3457', '3458', '3459', '3577', '3622', '3479', '3480', '3481', '3482', '3493', '3497', '3498', '2415', '2419', '2513', '2575', '2787', '2416', '2380', '2579', '1675', '1677', '1678', '1679', '1680', '2316', '2580', '2581', '2596', '3441', '3442', '3478', '3666', '3667', '3686', '3707', '3708', '3736', '3746', '3379', '3502', '3380', '3506', '3503', '3501', '3504', '3505', '3507', '3508', '3509', '3510', '3511', '3512', '3513', '3514', '3515', '4047', '4048', '1059', '1060', '3381', '3382', '3383', '3384', '1755', '2168', '2169', '2841', '2840', '2794', '2795', '2278', '2279', '2277', '2280', '2786', '2844', '2845', '2846', '104') ORDER BY `CollectibleID` desc
|
| 0.8291 |
SELECT DISTINCT cs.* FROM `Collectible` AS cs, `Attribute` AS at, `Attribute_Value` AS atv WHERE cs.CategoryID IN ( 613,1665,1666,1667,1672,2636,2665,2666,2668,4028,2669,2673,2674,2680,2681,3977,3978,2663,2664,3454,3456,3390,3391,3392,3393,3394,3452,3453,3455,3624,3625,3734,3735,4001,1704,1705,1706,615,1028,1029,1046,1030,1037,1038,1096,1162,2496,2788,3322,3462,1032,1124,1033,1113,1047,1049,2454,2457,3664,3665,1056,1057,2624,2686,2745,3714,1065,3715,1061,1062,2528,2529,2535,3483,3499,1076,1077,1136,2346,2347,2348,3494,2842,2843,3495,3496,3457,3458,3459,3577,3622,3479,3480,3481,3482,3493,3497,3498,2415,2419,2513,2575,2787,2416,2380,2579,1675,1677,1678,1679,1680,2316,2580,2581,2596,3441,3442,3478,3666,3667,3686,3707,3708,3736,3746,3379,3502,3380,3506,3503,3501,3504,3505,3507,3508,3509,3510,3511,3512,3513,3514,3515,4047,4048,1059,1060,3381,3382,3383,3384,1755,2168,2169,2841,2840,2794,2795,2278,2279,2277,2280,2786,2844,2845,2846,104 ) 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` = '3383' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '12520' 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 = 12520 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 = 3383
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1060
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1059
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12520' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12520' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '12520' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '12520'
|
| 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 = 12520 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '12404' 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 = 12404 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 = 3383
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1060
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1059
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0002 |
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.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12404' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12404' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '12404' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '12404'
|
| 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 = 12404 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '12406' 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 = 12406 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 = 3383
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1060
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1059
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12406' AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12406' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '12406' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '12406'
|
| 0.0009 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 12406 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '12405' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
|
| 0.0038 |
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 = 12405 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0004 |
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 = 3383
|
| 0.0004 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1060
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1059
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0002 |
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.0049 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12405' AND `GenericType` = 'collectible'
|
| 0.0044 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12405' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '12405' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '12405'
|
| 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 = 12405 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '1038' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '1038' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '1970' 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 = 1970 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '92' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1038
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1030
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1046
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1029
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0002 |
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 (`Review`) WHERE `GenericID` = '1970' AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '1970' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '1970' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '1970'
|
| 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 = 1970 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '1672' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '1672' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '13061' 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 = 13061 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1666
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1665
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 613
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0002 |
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.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '13061' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '13061' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '13061' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '13061'
|
| 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 = 13061 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '12517' 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 = 12517 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 = 3383
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1060
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1059
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12517' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12517' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '12517' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0006 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '12517'
|
| 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 = 12517 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '12518' 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 = 12518 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 = 3383
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1060
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1059
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12518' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12518' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '12518' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0006 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '12518'
|
| 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 = 12518 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '12519' 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 = 12519 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 = 3383
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1060
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1059
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12519' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12519' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '12519' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0006 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '12519'
|
| 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 = 12519 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2624' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2624' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '13898' 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 = 13898 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 = 2624
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1056
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1029
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '13898' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '13898' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '13898' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '13898'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13898 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '1062' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '1062' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6628' 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 = 6628 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 = 1062
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1061
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1029
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6628' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6628' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6628' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6628'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 6628 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '12470' 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 = 12470 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 = 3383
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1060
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1059
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12470' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12470' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '12470' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0006 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '12470'
|
| 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 = 12470 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3383' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '12471' 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 = 12471 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 = 3383
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1060
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1059
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0040 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12471' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12471' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '12471' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '12471'
|
| 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 = 12471 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '1038' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '1038' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '13787' 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 = 13787 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 = 1038
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1030
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1046
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1029
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '13787' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '13787' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '13787' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '13787'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13787 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '1124' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '1124' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '2153' 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 = 2153 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0001 |
SELECT * FROM (`User`) WHERE `UserID` = '92' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1124
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1032
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1046
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1029
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '2153' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '2153' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '2153' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '2153'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 2153 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2841' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2841' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '11865' 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 = 11865 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 = 2841
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2169
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2168
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '11865' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '11865' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '11865' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0006 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '11865'
|
| 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 = 11865 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2529' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2529' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '5454' 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 = 5454 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 = 2529
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1061
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1029
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '5454' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '5454' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '5454' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '5454'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 5454 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '1057' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '1057' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '15360' 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 = 15360 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 = 1057
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1056
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1029
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '15360' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '15360' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '15360' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '15360'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 15360 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2745' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2745' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '11286' 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 = 11286 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 = 2745
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1056
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1029
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '11286' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '11286' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '11286' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '11286'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 11286 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2496' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2496' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '8238' 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 = 8238 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 = 2496
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1030
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1046
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1029
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '8238' AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '8238' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '8238' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '8238'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 8238 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3478' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3478' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '13233' 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 = 13233 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 = 3478
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 3441
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2579
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1029
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '13233' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '13233' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '13233' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '13233'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13233 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2529' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2529' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '12639' 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 = 12639 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 = 2529
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1061
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1029
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12639' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12639' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '12639' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '12639'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 12639 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '4028' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '4028' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '17198' 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 = 17198 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 = 4028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '17198' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '17198' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '17198' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '17198'
|
| 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 = 17198 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3382' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3382' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '12269' 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 = 12269 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 = 3382
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1060
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1059
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12269' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12269' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '12269' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '12269'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 12269 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3382' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3382' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Image`) WHERE `GenericID` = '12268' 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 = 12268 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0001 |
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 = 3382
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1060
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1059
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1028
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12268' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '12268' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '12268' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '12268'
|
| 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 = 12268 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.1549 |
select Tag, count(TagID) as nrTags from Tag where GenericType = 'collectible' AND GenericID IN ( 613, 1665, 1666, 1667, 1672, 2636, 2665, 2666, 2668, 4028, 2669, 2673, 2674, 2680, 2681, 3977, 3978, 2663, 2664, 3454, 3456, 3390, 3391, 3392, 3393, 3394, 3452, 3453, 3455, 3624, 3625, 3734, 3735, 4001, 1704, 1705, 1706, 615, 1028, 1029, 1046, 1030, 1037, 1038, 1096, 1162, 2496, 2788, 3322, 3462, 1032, 1124, 1033, 1113, 1047, 1049, 2454, 2457, 3664, 3665, 1056, 1057, 2624, 2686, 2745, 3714, 1065, 3715, 1061, 1062, 2528, 2529, 2535, 3483, 3499, 1076, 1077, 1136, 2346, 2347, 2348, 3494, 2842, 2843, 3495, 3496, 3457, 3458, 3459, 3577, 3622, 3479, 3480, 3481, 3482, 3493, 3497, 3498, 2415, 2419, 2513, 2575, 2787, 2416, 2380, 2579, 1675, 1677, 1678, 1679, 1680, 2316, 2580, 2581, 2596, 3441, 3442, 3478, 3666, 3667, 3686, 3707, 3708, 3736, 3746, 3379, 3502, 3380, 3506, 3503, 3501, 3504, 3505, 3507, 3508, 3509, 3510, 3511, 3512, 3513, 3514, 3515, 4047, 4048, 1059, 1060, 3381, 3382, 3383, 3384, 1755, 2168, 2169, 2841, 2840, 2794, 2795, 2278, 2279, 2277, 2280, 2786, 2844, 2845, 2846, 104, 0 ) and Tag != '' and Removed = 0 GROUP BY Tag ORDER BY nrTags DESC LIMIT 50
|
| 0.0005 |
SELECT * FROM (`Attribute`) WHERE `Removed` = 0 AND `GenericType` = 'category' AND `GenericID` = '104'
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0002 |
SELECT * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
|
| 0.0001 |
select * from Notification_Filter
|
| 0.0001 |
select * from Notification
|
| 0.0001 |
select * from Notification
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 613 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2278 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 1028 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2844 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 615 AND Removed = 0
|
| 0.0001 |
select * from Zone
|
| 0.0001 |
select * from Zone
|
| 0.0001 |
select * from Zone
|
| 0.0001 |
select * from Zone
|