| 0.0004 |
SELECT *
FROM (`Url`)
WHERE `GenericType` = 'category'
AND `GenericID` = '83'
|
| 0.0057 |
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 = 83
|
| 0.0003 |
select * from Attribute where GenericType = 'category' and GenericID = 83
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 1
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 2
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 83
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '83'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '83'
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.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` = '83'
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 = 83
|
| 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.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '83'
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 = 83 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 84 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 85 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 87 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 136 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1376 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1582 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 141 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1331 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 163 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 165 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 192 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 220 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1325 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1330 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1351 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1387 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1352 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1764 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1383 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 142 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 221 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 222 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 223 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 224 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 225 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 226 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 227 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 228 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1380 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1381 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1382 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1426 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1427 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1428 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1584 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1441 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1593 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1595 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1597 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1596 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1598 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2495 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1445 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2494 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 88 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3400 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3401 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3402 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3403 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3404 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3405 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3406 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3407 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3410 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3582 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3584 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3585 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3700 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3701 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3819 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3983 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3984 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3985 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3986 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3988 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 4000 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 205 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 86 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3521 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3522 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3523 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3524 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3525 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3526 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3527 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3528 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3586 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 360 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 503 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 505 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2482 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2699 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2741 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3721 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3782 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3783 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3802 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 504 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3397 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 361 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 362 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3398 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 518 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2196 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2197 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2198 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2195 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2200 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2201 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3443 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2202 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2203 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2204 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2211 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2210 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2221 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2220 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2313 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2314 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2315 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 519 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1876 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1884 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1877 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1899 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1897 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1915 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1898 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1909 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1916 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1910 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2381 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3732 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3733 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2216 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2217 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2215 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3961 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3962 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3963 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 520 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 560 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2199 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 561 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 572 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 575 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 577 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 578 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 579 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 580 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 581 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 582 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 583 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 584 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 585 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2283 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2282 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3685 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3678 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3683 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 530 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 794 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 795 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 798 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 800 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 833 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1837 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1838 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1847 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1848 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1849 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 799 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 796 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1839 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1860 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1840 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1841 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2181 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2182 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2183 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2191 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2192 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2193 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2194 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2223 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2224 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2222 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 532 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2206 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2218 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2207 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2208 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2205 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2212 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2213 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2219 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3758 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3759 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3760 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`)
|
| 2.8621 | |
| 0.0088 |
SELECT *
FROM (`Collectible`)
WHERE `Removed` = 0
AND `CategoryID` IN ('84', '85', '87', '136', '1376', '1582', '141', '1331', '163', '165', '192', '220', '1325', '1330', '1351', '1387', '1352', '1764', '1383', '142', '221', '222', '223', '224', '225', '226', '227', '228', '1380', '1381', '1382', '1426', '1427', '1428', '1584', '1441', '1593', '1595', '1597', '1596', '1598', '2495', '1445', '2494', '88', '3400', '3401', '3402', '3403', '3404', '3405', '3406', '3407', '3410', '3582', '3584', '3585', '3700', '3701', '3819', '3983', '3984', '3985', '3986', '3988', '4000', '205', '86', '3521', '3522', '3523', '3524', '3525', '3526', '3527', '3528', '3586', '360', '503', '505', '2482', '2699', '2741', '3721', '3782', '3783', '3802', '504', '3397', '361', '362', '3398', '518', '2196', '2197', '2198', '2195', '2200', '2201', '3443', '2202', '2203', '2204', '2211', '2210', '2221', '2220', '2313', '2314', '2315', '519', '1876', '1884', '1877', '1899', '1897', '1915', '1898', '1909', '1916', '1910', '2381', '3732', '3733', '2216', '2217', '2215', '3961', '3962', '3963', '520', '560', '2199', '561', '572', '575', '577', '578', '579', '580', '581', '582', '583', '584', '585', '2283', '2282', '3685', '3678', '3683', '530', '794', '795', '798', '800', '833', '1837', '1838', '1847', '1848', '1849', '799', '796', '1839', '1860', '1840', '1841', '2181', '2182', '2183', '2191', '2192', '2193', '2194', '2223', '2224', '2222', '532', '2206', '2218', '2207', '2208', '2205', '2212', '2213', '2219', '3758', '3759', '3760', '83')
ORDER BY `CollectibleID` desc
|
| 0.8119 |
SELECT DISTINCT cs.*
FROM `Collectible` AS cs, `Attribute` AS at, `Attribute_Value` AS atv
WHERE cs.CategoryID IN ( 84,85,87,136,1376,1582,141,1331,163,165,192,220,1325,1330,1351,1387,1352,1764,1383,142,221,222,223,224,225,226,227,228,1380,1381,1382,1426,1427,1428,1584,1441,1593,1595,1597,1596,1598,2495,1445,2494,88,3400,3401,3402,3403,3404,3405,3406,3407,3410,3582,3584,3585,3700,3701,3819,3983,3984,3985,3986,3988,4000,205,86,3521,3522,3523,3524,3525,3526,3527,3528,3586,360,503,505,2482,2699,2741,3721,3782,3783,3802,504,3397,361,362,3398,518,2196,2197,2198,2195,2200,2201,3443,2202,2203,2204,2211,2210,2221,2220,2313,2314,2315,519,1876,1884,1877,1899,1897,1915,1898,1909,1916,1910,2381,3732,3733,2216,2217,2215,3961,3962,3963,520,560,2199,561,572,575,577,578,579,580,581,582,583,584,585,2283,2282,3685,3678,3683,530,794,795,798,800,833,1837,1838,1847,1848,1849,799,796,1839,1860,1840,1841,2181,2182,2183,2191,2192,2193,2194,2223,2224,2222,532,2206,2218,2207,2208,2205,2212,2213,2219,3758,3759,3760,83 )
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.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '796'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '796'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '4726'
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 = 4726 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 = 796
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 799
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 795
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 794
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 530
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '4726'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '4726'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '4726'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '4726'
|
| 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 = 4726 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '796'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '796'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '6872'
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 = 6872 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 = 796
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 799
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 795
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 794
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 530
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '6872'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '6872'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '6872'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '6872'
|
| 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 = 6872 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0004 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3400'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3400'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '16967'
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 = 16967 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '37'
LIMIT 1
|
| 0.0004 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3400
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 88
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 85
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '16967'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '16967'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '16967'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '16967'
|
| 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 = 16967 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0004 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3410'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3410'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '17205'
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 = 17205 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 = 3410
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 88
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 85
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '17205'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '17205'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '17205'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '17205'
|
| 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 = 17205 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3402'
LIMIT 1
|
| 0.0004 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3402'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '17255'
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 = 17255 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 = 3402
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 88
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 85
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '17255'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '17255'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '17255'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '17255'
|
| 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 = 17255 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3988'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3988'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '17216'
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 = 17216 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
SELECT *
FROM (`User`)
WHERE `UserID` = '37'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3988
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 88
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 85
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '17216'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '17216'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '17216'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '17216'
|
| 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 = 17216 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3683'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3683'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '15071'
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 = 15071 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 = 3683
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3678
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2199
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 560
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 520
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '15071'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15071'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '15071'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '15071'
|
| 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 = 15071 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1764'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1764'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '6037'
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 = 6037 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 = 1764
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1352
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 87
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 85
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '6037'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '6037'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '6037'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '6037'
|
| 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 = 6037 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '796'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '796'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '6583'
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 = 6583 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '57'
LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 796
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 799
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 795
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 794
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 530
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '6583'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '6583'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '6583'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '6583'
|
| 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 = 6583 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1764'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1764'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '6057'
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 = 6057 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 = 1764
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1352
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 87
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 85
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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.0040 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '6057'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '6057'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '6057'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '6057'
|
| 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 = 6057 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3524'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3524'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13867'
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 = 13867 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 = 3524
|
| 0.0004 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3521
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 86
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '13867'
AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13867'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13867'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13867'
|
| 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 = 13867 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1898'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1898'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '5273'
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 = 5273 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 = 1898
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1915
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1897
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1899
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 519
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '5273'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '5273'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '5273'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '5273'
|
| 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 = 5273 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1898'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1898'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '5347'
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 = 5347 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 = 1898
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1915
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1897
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1899
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 519
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '5347'
AND `GenericType` = 'collectible'
|
| 0.0044 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '5347'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '5347'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '5347'
|
| 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 = 5347 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1898'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1898'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '5285'
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 = 5285 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 = 1898
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1915
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1897
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1899
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 519
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '5285'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '5285'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '5285'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '5285'
|
| 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 = 5285 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '2195'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '2195'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '12947'
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 = 12947 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 = 2195
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2198
|
| 0.0004 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2197
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2196
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 518
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12947'
AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12947'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '12947'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '12947'
|
| 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 = 12947 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '2195'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '2195'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '12946'
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 = 12946 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
SELECT *
FROM (`User`)
WHERE `UserID` = '37'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2195
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2198
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2197
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2196
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 518
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '12946'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12946'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '12946'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '12946'
|
| 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 = 12946 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1764'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1764'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '6026'
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 = 6026 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 = 1764
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1352
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 87
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 85
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '6026'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '6026'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '6026'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '6026'
|
| 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 = 6026 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3528'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3528'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13569'
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 = 13569 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 = 3528
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3521
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 86
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '13569'
AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13569'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13569'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13569'
|
| 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 = 13569 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1764'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1764'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '6049'
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 = 6049 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 = 1764
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1352
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 87
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 85
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '6049'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '6049'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '6049'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '6049'
|
| 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 = 6049 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3398'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3398'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '12546'
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 = 12546 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 = 3398
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3397
|
| 0.0004 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 504
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 360
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '12546'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '12546'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '12546'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '12546'
|
| 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 = 12546 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1764'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1764'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '4605'
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 = 4605 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 = 1764
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1352
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 87
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 85
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '4605'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '4605'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '4605'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '4605'
|
| 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 = 4605 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3700'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3700'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '15123'
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 = 15123 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 = 3700
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 88
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 85
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15123'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15123'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '15123'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '15123'
|
| 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 = 15123 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3983'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3983'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '16974'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0012 |
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 = 16974 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 = 3983
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 88
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 85
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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` = '16974'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '16974'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '16974'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '16974'
|
| 0.0008 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 16974 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '362'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '362'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '8582'
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 = 8582 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 = 362
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 361
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3397
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 504
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 360
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 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.0040 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '8582'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '8582'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '8582'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '8582'
|
| 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 = 8582 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3700'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3700'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '15117'
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 = 15117 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
SELECT *
FROM (`User`)
WHERE `UserID` = '37'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3700
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 88
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 85
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 84
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 83
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15117'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15117'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '15117'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '15117'
|
| 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 = 15117 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.1546 |
select Tag, count(TagID) as nrTags from Tag where GenericType = 'collectible' AND GenericID IN ( 84, 85, 87, 136, 1376, 1582, 141, 1331, 163, 165, 192, 220, 1325, 1330, 1351, 1387, 1352, 1764, 1383, 142, 221, 222, 223, 224, 225, 226, 227, 228, 1380, 1381, 1382, 1426, 1427, 1428, 1584, 1441, 1593, 1595, 1597, 1596, 1598, 2495, 1445, 2494, 88, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3410, 3582, 3584, 3585, 3700, 3701, 3819, 3983, 3984, 3985, 3986, 3988, 4000, 205, 86, 3521, 3522, 3523, 3524, 3525, 3526, 3527, 3528, 3586, 360, 503, 505, 2482, 2699, 2741, 3721, 3782, 3783, 3802, 504, 3397, 361, 362, 3398, 518, 2196, 2197, 2198, 2195, 2200, 2201, 3443, 2202, 2203, 2204, 2211, 2210, 2221, 2220, 2313, 2314, 2315, 519, 1876, 1884, 1877, 1899, 1897, 1915, 1898, 1909, 1916, 1910, 2381, 3732, 3733, 2216, 2217, 2215, 3961, 3962, 3963, 520, 560, 2199, 561, 572, 575, 577, 578, 579, 580, 581, 582, 583, 584, 585, 2283, 2282, 3685, 3678, 3683, 530, 794, 795, 798, 800, 833, 1837, 1838, 1847, 1848, 1849, 799, 796, 1839, 1860, 1840, 1841, 2181, 2182, 2183, 2191, 2192, 2193, 2194, 2223, 2224, 2222, 532, 2206, 2218, 2207, 2208, 2205, 2212, 2213, 2219, 3758, 3759, 3760, 83, 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` = '83'
|
| 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.0002 |
select * from Notification_Filter
|
| 0.0002 |
select * from Notification
|
| 0.0002 |
select * from Notification
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 520 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 518 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 519 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2206 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 530 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 360 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 532 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3758 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 84 AND Removed = 0
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0001 |
select * from Zone
|
