| 0.0004 |
SELECT *
FROM (`Url`)
WHERE `GenericType` = 'category'
AND `GenericID` = '1787'
|
| 0.0011 |
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 = 1787
|
| 0.0003 |
select * from Attribute where GenericType = 'category' and GenericID = 1787
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 1787
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1787'
AND `Removed` = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1787'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`Role_Group_User`)
WHERE `RoleGroupID` IN (1, 2, 5)
AND `UserID` = 0
|
| 0.0003 |
SELECT *
FROM (`Private`)
WHERE `GenericType` = 'Category'
AND `Removed` = 0
|
| 0.0035 |
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` = '1787'
AND `Removed` = 0
ORDER BY `Name` asc
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '1787'
AND `GenericType` = 'category'
ORDER BY `ImageID` DESC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '37'
LIMIT 1
|
| 0.0005 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1787 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1788 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1944 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1947 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1948 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1950 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1954 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1955 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1956 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1959 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1961 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1964 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1965 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1966 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1967 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1968 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1969 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1970 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2867 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2868 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2869 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2870 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1790 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2011 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2012 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2013 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2014 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2015 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2016 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2017 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2018 AND Removed = 0
|
| 0.0004 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1794 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3324 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3325 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3326 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3327 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3328 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3329 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3330 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3331 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3332 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3333 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3334 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3335 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3336 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3337 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3338 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3339 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3340 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3341 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3342 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3343 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3344 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3345 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3346 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3347 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3348 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1797 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1803 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1810 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1815 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1816 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1817 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1818 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1819 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1820 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1821 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1822 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1823 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1824 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1825 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1826 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1827 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1828 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1829 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1830 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1831 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1832 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1833 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1834 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1835 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2863 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1789 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2864 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2866 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2922 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2923 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2924 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2925 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2926 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2927 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2928 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2929 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2930 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2931 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2932 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2933 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2934 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2935 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2936 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2937 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2938 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2939 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2940 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2941 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2942 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2943 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2944 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2945 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2871 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1793 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2872 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2891 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2899 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2900 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2901 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2902 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2903 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2904 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2905 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2906 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2907 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2908 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2909 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2910 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2911 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2912 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2913 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2914 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2915 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2916 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2917 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2918 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2919 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2920 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2921 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2873 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1811 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2874 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1792 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3262 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3263 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3264 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3265 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3266 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3267 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3268 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3269 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3270 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3271 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3272 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3273 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3274 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3275 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3276 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3277 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3278 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3279 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3280 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3281 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3282 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3283 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3284 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3285 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2875 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1791 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3415 AND Removed = 0
|
| 0.0004 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2876 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1798 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2044 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2045 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2046 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2047 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2048 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2049 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2050 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2051 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2052 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2053 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2054 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2055 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2056 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2057 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2058 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2059 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2060 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2061 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2062 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2064 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2065 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2066 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2067 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2068 AND Removed = 0
|
| 0.0004 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2877 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1795 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2755 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3293 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3294 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3295 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3296 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3297 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3298 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3299 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3300 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3301 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3302 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3303 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3304 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3305 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3306 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3307 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3308 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3309 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3310 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3311 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3312 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3313 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3314 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3315 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3316 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3317 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2878 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1808 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3772 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3773 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2879 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1807 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3770 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2880 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1813 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3768 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2881 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1814 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3769 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2882 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1812 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3767 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2883 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1836 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2946 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1809 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3318 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1804 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3319 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1806 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3320 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1805 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3806 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3809 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3807 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3938 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3939 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3940 AND Removed = 0
|
| 0.0001 |
SELECT *
FROM (`Role_Group_User`)
WHERE `RoleGroupID` IN (1, 2, 5)
AND `UserID` = -1
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
|
| 3.7986 | |
| 0.0052 |
SELECT *
FROM (`Collectible`)
WHERE `Removed` = 0
AND `CategoryID` IN ('1788', '1944', '1947', '1948', '1950', '1954', '1955', '1956', '1959', '1961', '1964', '1965', '1966', '1967', '1968', '1969', '1970', '2867', '2868', '2869', '2870', '1790', '2011', '2012', '2013', '2014', '2015', '2016', '2017', '2018', '1794', '3324', '3325', '3326', '3327', '3328', '3329', '3330', '3331', '3332', '3333', '3334', '3335', '3336', '3337', '3338', '3339', '3340', '3341', '3342', '3343', '3344', '3345', '3346', '3347', '3348', '1797', '1803', '1810', '1815', '1816', '1817', '1818', '1819', '1820', '1821', '1822', '1823', '1824', '1825', '1826', '1827', '1828', '1829', '1830', '1831', '1832', '1833', '1834', '1835', '2863', '1789', '2864', '2866', '2922', '2923', '2924', '2925', '2926', '2927', '2928', '2929', '2930', '2931', '2932', '2933', '2934', '2935', '2936', '2937', '2938', '2939', '2940', '2941', '2942', '2943', '2944', '2945', '2871', '1793', '2872', '2891', '2899', '2900', '2901', '2902', '2903', '2904', '2905', '2906', '2907', '2908', '2909', '2910', '2911', '2912', '2913', '2914', '2915', '2916', '2917', '2918', '2919', '2920', '2921', '2873', '1811', '2874', '1792', '3262', '3263', '3264', '3265', '3266', '3267', '3268', '3269', '3270', '3271', '3272', '3273', '3274', '3275', '3276', '3277', '3278', '3279', '3280', '3281', '3282', '3283', '3284', '3285', '2875', '1791', '3415', '2876', '1798', '2044', '2045', '2046', '2047', '2048', '2049', '2050', '2051', '2052', '2053', '2054', '2055', '2056', '2057', '2058', '2059', '2060', '2061', '2062', '2064', '2065', '2066', '2067', '2068', '2877', '1795', '2755', '3293', '3294', '3295', '3296', '3297', '3298', '3299', '3300', '3301', '3302', '3303', '3304', '3305', '3306', '3307', '3308', '3309', '3310', '3311', '3312', '3313', '3314', '3315', '3316', '3317', '2878', '1808', '3772', '3773', '2879', '1807', '3770', '2880', '1813', '3768', '2881', '1814', '3769', '2882', '1812', '3767', '2883', '1836', '2946', '1809', '3318', '1804', '3319', '1806', '3320', '1805', '3806', '3809', '3807', '3938', '3939', '3940', '1787')
ORDER BY `CollectibleID` desc
|
| 0.8061 |
SELECT DISTINCT cs.*
FROM `Collectible` AS cs, `Attribute` AS at, `Attribute_Value` AS atv
WHERE cs.CategoryID IN ( 1788,1944,1947,1948,1950,1954,1955,1956,1959,1961,1964,1965,1966,1967,1968,1969,1970,2867,2868,2869,2870,1790,2011,2012,2013,2014,2015,2016,2017,2018,1794,3324,3325,3326,3327,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3339,3340,3341,3342,3343,3344,3345,3346,3347,3348,1797,1803,1810,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,2863,1789,2864,2866,2922,2923,2924,2925,2926,2927,2928,2929,2930,2931,2932,2933,2934,2935,2936,2937,2938,2939,2940,2941,2942,2943,2944,2945,2871,1793,2872,2891,2899,2900,2901,2902,2903,2904,2905,2906,2907,2908,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2920,2921,2873,1811,2874,1792,3262,3263,3264,3265,3266,3267,3268,3269,3270,3271,3272,3273,3274,3275,3276,3277,3278,3279,3280,3281,3282,3283,3284,3285,2875,1791,3415,2876,1798,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2064,2065,2066,2067,2068,2877,1795,2755,3293,3294,3295,3296,3297,3298,3299,3300,3301,3302,3303,3304,3305,3306,3307,3308,3309,3310,3311,3312,3313,3314,3315,3316,3317,2878,1808,3772,3773,2879,1807,3770,2880,1813,3768,2881,1814,3769,2882,1812,3767,2883,1836,2946,1809,3318,1804,3319,1806,3320,1805,3806,3809,3807,3938,3939,3940,1787 )
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.0004 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1791'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1791'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '9578'
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 = 9578 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
SELECT *
FROM (`User`)
WHERE `UserID` = '57'
LIMIT 1
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1791
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2875
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9578'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9578'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '9578'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0006 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '9578'
|
| 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 = 9578 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0004 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3297'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3297'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '12051'
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 = 12051 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 = 3297
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2877
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12051'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12051'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '12051'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '12051'
|
| 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 = 12051 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1791'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1791'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '9576'
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 = 9576 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
SELECT *
FROM (`User`)
WHERE `UserID` = '57'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1791
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2875
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9576'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9576'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '9576'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '9576'
|
| 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 = 9576 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0004 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3326'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3326'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '12095'
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 = 12095 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 = 3326
|
| 0.0004 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1794
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12095'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12095'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '12095'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '12095'
|
| 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 = 12095 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '2866'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '2866'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '11793'
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 = 11793 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '37'
LIMIT 1
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2866
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2863
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11793'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11793'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '11793'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '11793'
|
| 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 = 11793 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '2867'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '2867'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '11794'
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 = 11794 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
SELECT *
FROM (`User`)
WHERE `UserID` = '37'
LIMIT 1
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2867
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1788
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11794'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11794'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '11794'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '11794'
|
| 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 = 11794 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0004 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '2900'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '2900'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '11856'
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 = 11856 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 = 2900
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2871
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11856'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11856'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '11856'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '11856'
|
| 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 = 11856 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3415'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3415'
LIMIT 1
|
| 0.0005 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13221'
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 = 13221 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '57'
LIMIT 1
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3415
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2875
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13221'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13221'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13221'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13221'
|
| 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 = 13221 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3264'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3264'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '12013'
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 = 12013 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 = 3264
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2874
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12013'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12013'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '12013'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '12013'
|
| 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 = 12013 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1791'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1791'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13001'
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 = 13001 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '57'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1791
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2875
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13001'
AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13001'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13001'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13001'
|
| 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 = 13001 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1809'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1809'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '5416'
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 = 5416 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 = 1809
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2946
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '5416'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '5416'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '5416'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '5416'
|
| 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 = 5416 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '2922'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '2922'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '11948'
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 = 11948 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 = 2922
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2863
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11948'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11948'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '11948'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '11948'
|
| 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 = 11948 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '2922'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '2922'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '11947'
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 = 11947 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
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 = 2922
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2863
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11947'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11947'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '11947'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '11947'
|
| 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 = 11947 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3299'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3299'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '12055'
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 = 12055 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 = 3299
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2877
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12055'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12055'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '12055'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '12055'
|
| 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 = 12055 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0004 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '2899'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '2899'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '6290'
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 = 6290 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '57'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2899
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2871
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '6290'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '6290'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '6290'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '6290'
|
| 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 = 6290 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1807'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1807'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '5259'
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 = 5259 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 = 1807
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2879
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '5259'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '5259'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '5259'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '5259'
|
| 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 = 5259 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1807'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1807'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '5251'
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 = 5251 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '57'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1807
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2879
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '5251'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '5251'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '5251'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '5251'
|
| 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 = 5251 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3263'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3263'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '12012'
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 = 12012 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 = 3263
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2874
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12012'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12012'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '12012'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '12012'
|
| 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 = 12012 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '2899'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '2899'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '11852'
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 = 11852 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 = 2899
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2871
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11852'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11852'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '11852'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '11852'
|
| 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 = 11852 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3325'
LIMIT 1
|
| 0.0004 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3325'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '12094'
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 = 12094 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '93'
LIMIT 1
|
| 0.0004 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3325
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1794
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12094'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12094'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '12094'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '12094'
|
| 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 = 12094 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3324'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3324'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '12093'
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 = 12093 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 = 3324
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1794
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12093'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12093'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '12093'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '12093'
|
| 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 = 12093 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3262'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3262'
LIMIT 1
|
| 0.0005 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '12011'
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 = 12011 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 = 3262
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2874
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12011'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12011'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '12011'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '12011'
|
| 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 = 12011 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '2927'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '2927'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '11980'
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 = 11980 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 = 2927
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2863
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11980'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '11980'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '11980'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '11980'
|
| 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 = 11980 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3298'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3298'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '16436'
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 = 16436 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 = 3298
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2877
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '16436'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '16436'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '16436'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '16436'
|
| 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 = 16436 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3298'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3298'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '12054'
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 = 12054 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 = 3298
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2877
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1787
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12054'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12054'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '12054'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '12054'
|
| 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 = 12054 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.1512 |
select Tag, count(TagID) as nrTags from Tag where GenericType = 'collectible' AND GenericID IN ( 1788, 1944, 1947, 1948, 1950, 1954, 1955, 1956, 1959, 1961, 1964, 1965, 1966, 1967, 1968, 1969, 1970, 2867, 2868, 2869, 2870, 1790, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 1794, 3324, 3325, 3326, 3327, 3328, 3329, 3330, 3331, 3332, 3333, 3334, 3335, 3336, 3337, 3338, 3339, 3340, 3341, 3342, 3343, 3344, 3345, 3346, 3347, 3348, 1797, 1803, 1810, 1815, 1816, 1817, 1818, 1819, 1820, 1821, 1822, 1823, 1824, 1825, 1826, 1827, 1828, 1829, 1830, 1831, 1832, 1833, 1834, 1835, 2863, 1789, 2864, 2866, 2922, 2923, 2924, 2925, 2926, 2927, 2928, 2929, 2930, 2931, 2932, 2933, 2934, 2935, 2936, 2937, 2938, 2939, 2940, 2941, 2942, 2943, 2944, 2945, 2871, 1793, 2872, 2891, 2899, 2900, 2901, 2902, 2903, 2904, 2905, 2906, 2907, 2908, 2909, 2910, 2911, 2912, 2913, 2914, 2915, 2916, 2917, 2918, 2919, 2920, 2921, 2873, 1811, 2874, 1792, 3262, 3263, 3264, 3265, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3279, 3280, 3281, 3282, 3283, 3284, 3285, 2875, 1791, 3415, 2876, 1798, 2044, 2045, 2046, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2061, 2062, 2064, 2065, 2066, 2067, 2068, 2877, 1795, 2755, 3293, 3294, 3295, 3296, 3297, 3298, 3299, 3300, 3301, 3302, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3310, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 2878, 1808, 3772, 3773, 2879, 1807, 3770, 2880, 1813, 3768, 2881, 1814, 3769, 2882, 1812, 3767, 2883, 1836, 2946, 1809, 3318, 1804, 3319, 1806, 3320, 1805, 3806, 3809, 3807, 3938, 3939, 3940, 1787, 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` = '1787'
|
| 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 = 3318 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3320 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3319 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2883 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2882 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2881 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2880 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2879 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1797 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3807 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2878 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2877 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3806 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2946 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2876 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1790 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2875 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2874 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1794 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2873 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2871 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1788 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2863 AND Removed = 0
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
