| 0.0004 |
SELECT *
FROM (`Url`)
WHERE `GenericType` = 'category'
AND `GenericID` = '21'
|
| 0.0010 |
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 = 21
|
| 0.0004 |
select * from Attribute where GenericType = 'category' and GenericID = 21
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 21
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '21'
AND `Removed` = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '21'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`Role_Group_User`)
WHERE `RoleGroupID` IN (1, 2, 5)
AND `UserID` = 0
|
| 0.0005 |
SELECT *
FROM (`Private`)
WHERE `GenericType` = 'Category'
AND `Removed` = 0
|
| 0.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` = '21'
AND `Removed` = 0
ORDER BY `Name` asc
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '21'
AND `GenericType` = 'category'
ORDER BY `ImageID` DESC
|
| 0.0003 |
SELECT *
FROM (`User`)
WHERE `UserID` = '37'
LIMIT 1
|
| 0.0004 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 21 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 22 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 23 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 115 AND Removed = 0
|
| 0.0004 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 24 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3632 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 27 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3637 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3633 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 30 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3634 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 28 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3635 AND Removed = 0
|
| 0.0004 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 29 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3638 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3636 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3639 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3650 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3640 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3651 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3641 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3652 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3642 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3653 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3643 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3654 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3644 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3655 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3645 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3656 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3646 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3657 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3647 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3658 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3648 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3659 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 25 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 44 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3569 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3570 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3571 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3573 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 45 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3558 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3559 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3561 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3562 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3563 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3564 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 46 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3553 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3554 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3555 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3556 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3557 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3629 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 47 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3547 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3549 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3550 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3551 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3552 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 48 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3546 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3565 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3566 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3567 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3568 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3536 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3535 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3538 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3539 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3540 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3541 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3542 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3543 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3537 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3574 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3575 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3576 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3630 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3544 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3545 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3738 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3739 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3740 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3741 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3742 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3743 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3744 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3745 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 4003 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 4004 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 4005 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 4006 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 4035 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 4034 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 350 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1271 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1272 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1273 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1275 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1276 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1895 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1896 AND Removed = 0
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1274 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2177 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2079 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2081 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2078 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2080 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2128 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2125 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2133 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2134 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2135 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2102 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2103 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2129 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2131 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2132 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2130 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2136 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2137 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3374 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2082 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2112 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2113 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2114 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2115 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2116 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2117 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2118 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2119 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2120 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2121 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2122 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2083 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2099 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2100 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2101 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2084 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2085 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2086 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2087 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2088 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2089 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2090 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2091 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2092 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2093 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2094 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2095 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2096 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2097 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2098 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2123 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2124 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3855 AND Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Role_Group_User`)
WHERE `RoleGroupID` IN (1, 2, 5)
AND `UserID` = -1
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
|
| 2.5434 | |
| 0.0091 |
SELECT *
FROM (`Collectible`)
WHERE `Removed` = 0
AND `CategoryID` IN ('22', '23', '115', '24', '3632', '27', '3637', '3633', '30', '3634', '28', '3635', '29', '3638', '3636', '3639', '3650', '3640', '3651', '3641', '3652', '3642', '3653', '3643', '3654', '3644', '3655', '3645', '3656', '3646', '3657', '3647', '3658', '3648', '3659', '25', '44', '3569', '3570', '3571', '3573', '45', '3558', '3559', '3561', '3562', '3563', '3564', '46', '3553', '3554', '3555', '3556', '3557', '3629', '47', '3547', '3549', '3550', '3551', '3552', '48', '3546', '3565', '3566', '3567', '3568', '3536', '3535', '3538', '3539', '3540', '3541', '3542', '3543', '3537', '3574', '3575', '3576', '3630', '3544', '3545', '3738', '3739', '3740', '3741', '3742', '3743', '3744', '3745', '4003', '4004', '4005', '4006', '4035', '4034', '350', '1271', '1272', '1273', '1275', '1276', '1895', '1896', '1274', '2177', '2079', '2081', '2078', '2080', '2128', '2125', '2133', '2134', '2135', '2102', '2103', '2129', '2131', '2132', '2130', '2136', '2137', '3374', '2082', '2112', '2113', '2114', '2115', '2116', '2117', '2118', '2119', '2120', '2121', '2122', '2083', '2099', '2100', '2101', '2084', '2085', '2086', '2087', '2088', '2089', '2090', '2091', '2092', '2093', '2094', '2095', '2096', '2097', '2098', '2123', '2124', '3855', '21')
ORDER BY `CollectibleID` desc
|
| 0.8182 |
SELECT DISTINCT cs.*
FROM `Collectible` AS cs, `Attribute` AS at, `Attribute_Value` AS atv
WHERE cs.CategoryID IN ( 22,23,115,24,3632,27,3637,3633,30,3634,28,3635,29,3638,3636,3639,3650,3640,3651,3641,3652,3642,3653,3643,3654,3644,3655,3645,3656,3646,3657,3647,3658,3648,3659,25,44,3569,3570,3571,3573,45,3558,3559,3561,3562,3563,3564,46,3553,3554,3555,3556,3557,3629,47,3547,3549,3550,3551,3552,48,3546,3565,3566,3567,3568,3536,3535,3538,3539,3540,3541,3542,3543,3537,3574,3575,3576,3630,3544,3545,3738,3739,3740,3741,3742,3743,3744,3745,4003,4004,4005,4006,4035,4034,350,1271,1272,1273,1275,1276,1895,1896,1274,2177,2079,2081,2078,2080,2128,2125,2133,2134,2135,2102,2103,2129,2131,2132,2130,2136,2137,3374,2082,2112,2113,2114,2115,2116,2117,2118,2119,2120,2121,2122,2083,2099,2100,2101,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2095,2096,2097,2098,2123,2124,3855,21 )
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.0002 |
SELECT GenericID FROM `Private` WHERE GenericType = "category" AND Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3576'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3576'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13817'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 13817 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 = 3576
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3537
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13817'
AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13817'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13817'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13817'
|
| 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 = 13817 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3740'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3740'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '16142'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 16142 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 = 3740
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3544
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '16142'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '16142'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '16142'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '16142'
|
| 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 = 16142 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3738'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3738'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '15686'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 15686 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 = 3738
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3544
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15686'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15686'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '15686'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '15686'
|
| 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 = 15686 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3545'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3545'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '15506'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 15506 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 = 3545
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3544
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15506'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15506'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '15506'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '15506'
|
| 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 = 15506 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3557'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3557'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '14876'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 14876 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 = 3557
|
| 0.0004 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 46
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14876'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14876'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '14876'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '14876'
|
| 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 = 14876 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3556'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3556'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '14901'
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 = 14901 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 = 3556
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 46
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14901'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14901'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '14901'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '14901'
|
| 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 = 14901 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3539'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3539'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13755'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 13755 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 = 3539
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3536
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13755'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13755'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13755'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13755'
|
| 0.0004 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13755 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3739'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3739'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '15983'
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 = 15983 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 = 3739
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3544
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15983'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15983'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '15983'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '15983'
|
| 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 = 15983 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3741'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3741'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '15527'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 15527 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 = 3741
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3544
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15527'
AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15527'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '15527'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '15527'
|
| 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 = 15527 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3553'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3553'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '14360'
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 = 14360 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 = 3553
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 46
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14360'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14360'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '14360'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '14360'
|
| 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 = 14360 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3741'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3741'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '15552'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 15552 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 = 3741
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3544
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15552'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15552'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '15552'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '15552'
|
| 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 = 15552 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3575'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3575'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '14731'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 14731 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 = 3575
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3537
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14731'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14731'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '14731'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '14731'
|
| 0.0004 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 14731 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3576'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3576'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '14391'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 14391 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 = 3576
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3537
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14391'
AND `GenericType` = 'collectible'
|
| 0.0044 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14391'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '14391'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '14391'
|
| 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 = 14391 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3740'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3740'
LIMIT 1
|
| 0.0005 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '16029'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 16029 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 = 3740
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3544
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '16029'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '16029'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '16029'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '16029'
|
| 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 = 16029 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3575'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3575'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '14732'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 14732 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 = 3575
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3537
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0044 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14732'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14732'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '14732'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '14732'
|
| 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 = 14732 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3545'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3545'
LIMIT 1
|
| 0.0005 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '15393'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 15393 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 = 3545
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3544
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15393'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15393'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '15393'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '15393'
|
| 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 = 15393 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3739'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3739'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '15870'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 15870 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '37'
LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3739
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3544
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15870'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15870'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '15870'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '15870'
|
| 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 = 15870 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3575'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3575'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '14733'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 14733 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 = 3575
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3537
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14733'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14733'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '14733'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '14733'
|
| 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 = 14733 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3738'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3738'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '15711'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 15711 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 = 3738
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3544
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15711'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '15711'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '15711'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '15711'
|
| 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 = 15711 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3563'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3563'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '14586'
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 = 14586 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 = 3563
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 45
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14586'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14586'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '14586'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '14586'
|
| 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 = 14586 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3574'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3574'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13934'
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 = 13934 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 = 3574
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3537
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13934'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13934'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13934'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13934'
|
| 0.0004 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13934 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3535'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3535'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13690'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 13690 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 = 3535
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3536
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13690'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13690'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13690'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13690'
|
| 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 = 13690 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3551'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3551'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13792'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 13792 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 = 3551
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 47
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13792'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13792'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13792'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13792'
|
| 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 = 13792 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3563'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3563'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '14590'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0005 |
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 = 14590 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 = 3563
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 45
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14590'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14590'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '14590'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '14590'
|
| 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 = 14590 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0004 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '3568'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '3568'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '14931'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0006 |
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 = 14931 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 = 3568
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 48
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 25
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 115
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 23
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 22
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 21
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14931'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '14931'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '14931'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '14931'
|
| 0.0004 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 14931 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.1587 |
select Tag, count(TagID) as nrTags from Tag where GenericType = 'collectible' AND GenericID IN ( 22, 23, 115, 24, 3632, 27, 3637, 3633, 30, 3634, 28, 3635, 29, 3638, 3636, 3639, 3650, 3640, 3651, 3641, 3652, 3642, 3653, 3643, 3654, 3644, 3655, 3645, 3656, 3646, 3657, 3647, 3658, 3648, 3659, 25, 44, 3569, 3570, 3571, 3573, 45, 3558, 3559, 3561, 3562, 3563, 3564, 46, 3553, 3554, 3555, 3556, 3557, 3629, 47, 3547, 3549, 3550, 3551, 3552, 48, 3546, 3565, 3566, 3567, 3568, 3536, 3535, 3538, 3539, 3540, 3541, 3542, 3543, 3537, 3574, 3575, 3576, 3630, 3544, 3545, 3738, 3739, 3740, 3741, 3742, 3743, 3744, 3745, 4003, 4004, 4005, 4006, 4035, 4034, 350, 1271, 1272, 1273, 1275, 1276, 1895, 1896, 1274, 2177, 2079, 2081, 2078, 2080, 2128, 2125, 2133, 2134, 2135, 2102, 2103, 2129, 2131, 2132, 2130, 2136, 2137, 3374, 2082, 2112, 2113, 2114, 2115, 2116, 2117, 2118, 2119, 2120, 2121, 2122, 2083, 2099, 2100, 2101, 2084, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2098, 2123, 2124, 3855, 21, 0 )
and Tag != '' and Removed = 0 GROUP BY Tag
ORDER BY nrTags DESC LIMIT 50
|
| 0.0003 |
SELECT *
FROM (`Attribute`)
WHERE `Removed` = 0
AND `GenericType` = 'category'
AND `GenericID` = '21'
|
| 0.0001 |
SELECT *
FROM (`Role_Group_User`)
WHERE `RoleGroupID` IN (1, 2, 5)
AND `UserID` = -1
|
| 0.0002 |
SELECT * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
|
| 0.0001 |
select * from Notification_Filter
|
| 0.0001 |
select * from Notification
|
| 0.0001 |
select * from Notification
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1271 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 22 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1272 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1274 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 3855 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1273 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 2177 AND Removed = 0
|
| 0.0001 |
select * from Zone
|
| 0.0001 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
