| 0.0004 |
SELECT * FROM (`Url`) WHERE `GenericType` = 'category' AND `GenericID` = '2232'
|
| 0.0059 |
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 = 2232
|
| 0.0003 |
select * from Attribute where GenericType = 'category' and GenericID = 2232
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 1354
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 1355
|
| 0.0005 |
select * from Private where GenericType = 'category' and GenericID = 2232
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2232' AND `Removed` = 0
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2232' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = 0
|
| 0.0004 |
SELECT * FROM (`Private`) WHERE `GenericType` = 'Category' AND `Removed` = 0
|
| 0.0033 |
SELECT * FROM (`Category`) WHERE `CategoryID` NOT IN ('746', '2144', '1131', '987', '991', '993', '994', '1055', '1079', '1088', '1090', '1094', '1149', '1150', '1246', '1299', '1305', '1308', '1309', '1311', '1464', '1473', '1493', '1494', '1518', '1519', '1520', '1530', '1531', '1761', '1721', '1729', '1733', '1735', '1736', '1765', '1766', '1767', '1768', '1769', '1770', '1771', '1772', '1773', '1774', '1776', '1777', '1778', '1779', '1780', '1781', '1782', '1783', '1784', '1786', '1803', '1810', '1815', '1816', '1817', '1818', '1819', '1820', '1821', '1822', '1823', '1824', '1825', '1826', '1827', '1828', '1829', '1830', '1831', '1832', '1833', '1834', '1835', '1861', '2011', '2012', '2013', '2014', '2016', '2017', '2018', '2022', '2069', '2080', '2082', '2083', '2084', '2085', '2086', '2087', '2088', '2089', '2090', '2091', '2092', '2093', '2094', '2095', '2096', '2097', '2098', '2099', '2100', '2101', '2102', '2103', '2112', '2113', '2114', '2115', '2116', '2117', '2118', '2119', '2120', '2121', '2122', '2123', '2124', '2125', '2133', '2128', '2129', '2130', '2131', '2132', '2134', '2135', '2136', '2137', '2233', '2234', '2373', '2390', '2653', '2950', '3006', '3374', '3823', '3824', '3825', '3826', '3827', '3828', '3829', '3830', '3831', '3832', '3833', '3834', '3835', '3836', '3837', '3838', '3839', '3840', '3841', '3842', '3843', '3844', '3845', '3846', '3847', '3848', '3849', '3850', '3932', '3934', '3935', '3936', '3937', '3938', '3939', '3940', '3941', '3942', '3943', '3944', '3953', '3954', '3955', '3956', '3957', '3958', '3959', '3999', '4026', '4029', '4030', '4045', '4045', '4045', '4046') AND `ParentID` = '2232' 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 = 2232
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1355
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1354
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '2232' AND `GenericType` = 'category' ORDER BY `ImageID` DESC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '213' LIMIT 1
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2232 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2233 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2234 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2287 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2288 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2290 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2289 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2292 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2488 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2293 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2487 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2489 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2294 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`)
|
| 0.1977 |
SELECT * FROM (`Collectible`) WHERE `Removed` = 0 AND `CategoryID` IN ('2233', '2234', '2287', '2288', '2290', '2289', '2292', '2488', '2293', '2487', '2489', '2294', '2232') AND `CollectibleID` IN ('234', '235', '236', '237', '239', '243', '245', '246', '247', '388', '251', '521', '634', '701', '788', '784', '1035', '1036', '1228', '1310', '1311', '1312', '1313', '1314', '1639', '1640', '1641', '1670', '1671', '1672', '1772', '1773', '1780', '1866', '2177', '2178', '2179', '2544', '2545', '2546', '2547', '2548', '2549', '2667', '2673', '2677', '2678', '2679', '2680', '2681', '2682', '2730', '2748', '2749', '2750', '2751', '2778', '2882', '2900', '2901', '2902', '2911', '2953', '2977', '2985', '2986', '2988', '2995', '3045', '3046', '3236', '3377', '3378', '3391', '3392', '3405', '3406', '3407', '3408', '3416', '3418', '3420', '3429', '3430', '3431', '3437', '3443', '3450', '3461', '3473', '3520', '3722', '3779', '3780', '3852', '3671', '4485', '4486', '4490', '4542', '4884', '4885', '4886', '4887', '4888', '4889', '4890', '4891', '4920', '4921', '4922', '4923', '4945', '4948', '4956', '4958', '4963', '4966', '5059', '5063', '5069', '5072', '5073', '5136', '5226', '5228', '5259', '5262', '5264', '5266', '5372', '5374', '5377', '5382', '5384', '5386', '5388', '5414', '5437', '11805', '11803', '5446', '5453', '5697', '5698', '5700', '5706', '5707', '5791', '5792', '5793', '5794', '5795', '5796', '5797', '5798', '5799', '5800', '5801', '5802', '5803', '5804', '5805', '5806', '5807', '5808', '5809', '5810', '5811', '5812', '5813', '5814', '5815', '5816', '5817', '5818', '5819', '5820', '5821', '5822', '5823', '5824', '5825', '5826', '5827', '5828', '5829', '5830', '5831', '5832', '5833', '5834', '5835', '5836', '5837', '5838', '5839', '5840', '5841', '5842', '5843', '5844', '5845', '5846', '5847', '5848', '5849', '5850', '5851', '5852', '5853', '5854', '5855', '5856', '5857', '5858', '5859', '5860', '5861', '5862', '5863', '5864', '5865', '5866', '5867', '5868', '5869', '5870', '5871', '5872', '5873', '5874', '5875', '5876', '5877', '5878', '5879', '5880', '5881', '5882', '5883', '5884', '5885', '5886', '5887', '5888', '5889', '5890', '5891', '5892', '5896', '5903', '5897', '5909', '5910', '5911', '5912', '5913', '5914', '5915', '5916', '5917', '5918', '5919', '5920', '5921', '5922', '5923', '5924', '5925', '6193', '6424', '6425', '6426', '6427', '6678', '6679', '6680', '6681', '6682', '6683', '6684', '6685', '6686', '6687', '6688', '6689', '6690', '6691', '6692', '6693', '6694', '6695', '6696', '6699', '6701', '6702', '6703', '6704', '6705', '6706', '6707', '6710', '6711', '6722', '6723', '6724', '6725', '13462', '13420', '13417', '6805', '7346', '7345', '7344', '7343', '7578', '7579', '7580', '7581', '7582', '7583', '7584', '7585', '7586', '7736', '7773', '7958', '7957', '7955', '7956', '7908', '8021', '8046', '8108', '8109', '8110', '8111', '8175', '8157', '8156', '8520', '8408', '8522', '8531', '8529', '8513', '8537', '8503', '8501', '8535', '8479', '8533', '8473', '8474', '8454', '8515', '8516', '8524', '8525', '8526', '8581', '8634', '8676', '8654', '8657', '8659', '8661', '8663', '8668', '8666', '8787', '8786', '8875', '8824', '8840', '8865', '8826', '8897', '8921', '8922', '8926', '8927', '8928', '8929', '8931', '8932', '8934', '8938', '8939', '4404', '8950', '8951', '8952', '8953', '8981', '8982', '8993', '9045', '9046', '9047', '9048', '9049', '9050', '9051', '9052', '9053', '9054', '9055', '9056', '9057', '9058', '9059', '9060', '9061', '9062', '9063', '9064', '9065', '9066', '9067', '9068', '9069', '9070', '9071', '9072', '9073', '9074', '9075', '9076', '9077', '9078', '9079', '9080', '9081', '9082', '9083', '9084', '9085', '9086', '9087', '9088', '9089', '9090', '9091', '9092', '9093', '9094', '9095', '9096', '9120', '9121', '8999', '9051', '9052', '8997', '9053', '9054', '8998', '9055', '9056', '9124', '9165', '9168', '9170', '9158', '9151', '9126', '9136', '9147', '9148', '9149', '9129', '9143', '9145', '9153', '9134', '9186', '9188', '9191', '9193', '9195', '9197', '9198', '9203', '9207', '9209', '9210', '9214', '9216', '9220', '9226', '9228', '9236', '9253', '9251', '9249', '9247', '9247', '9257', '9259', '9260', '9261', '9263', '9265', '9269', '9271', '9272', '9277', '9288', '9304', '9305', '9306', '9307', '9308', '9309', '9310', '9313', '9314', '9316', '9415', '9419', '9420', '9420', '9422', '9434', '9439', '9399', '9331', '9336', '9342', '9379', '9340', '9382', '9385', '9407', '9408', '9409', '9351', '9346', '9347', '9348', '9359', '9356', '9391', '9369', '9371', '9455', '9510', '9820', '9963', '9964', '9964', '9969', '9970', '9971', '9972', '10108', '10109', '10474', '10475', '10476', '10477', '10589', '10590', '10711', '10532', '10533', '10534', '10468', '10469', '10470', '10471', '10472', '10446', '10447', '10448', '10449', '10621', '10609', '10610', '10601', '10602', '10603', '10604', '10501', '10502', '10503', '10504', '10505', '10697', '10695', '10696', '10698', '10699', '10700', '10701', '10702', '10669', '10688', '10443', '10444', '10708', '10716', '10717', '10536', '10537', '10719', '10720', '10412', '10721', '10722', '10723', '10724', '10413', '10571', '10573', '10575', '10539', '10540', '10541', '10542', '10555', '10556', '10557', '10592', '10593', '10594', '10595', '10633', '10634', '10451', '10452', '10453', '10454', '10455', '10705', '10544', '10545', '10641', '10415', '10416', '10417', '10686', '10419', '10420', '10422', '10423', '10424', '10425', '10426', '10427', '10428', '10493', '10494', '10495', '10496', '10559', '10560', '10561', '10606', '10607', '10612', '10613', '10628', '10629', '10615', '10578', '10579', '10581', '10582', '10583', '10498', '10499', '10563', '10564', '10565', '10566', '10479', '10480', '10481', '10482', '10483', '10484', '10485', '10430', '10431', '10432', '10547', '10548', '10549', '10550', '10507', '10508', '10509', '10510', '10677', '10678', '10679', '10680', '10681', '10682', '10683', '10487', '10488', '10725', '10631', '10457', '10568', '10569', '10623', '10624', '10625', '10626', '10464', '10465', '10466', '10552', '10553', '10512', '10513', '10514', '10515', '10516', '10517', '10459', '10460', '10461', '10434', '10435', '10617', '10519', '10520', '10619', '10585', '10586', '10587', '10597', '10598', '10599', '10636', '10437', '10438', '10439', '10440', '10441', '10648', '10522', '10525', '10526', '10523', '10524', '10527', '10528', '10529', '10530', '10489', '10490', '10491', '10738', '10747', '11038', '11080', '11185', '11097', '11638', '9567', '11186', '11209', '11208', '11211', '11187', '11243', '11242', '9570', '9564', '11241', '11099', '11315', '11359', '11360', '11361', '11362', '11380', '7435', '11428', '11632', '10987', '8643', '8646', '8647', '7445', '8737', '8645', '7447', '11098', '11674', '11682', '2888', '2889', '11675', '8417', '3921', '8728', '3918', '11679', '11680', '11683', '11684', '11685', '11746', '11741', '11740', '11709', '11464', '11716', '11748', '11747', '11800', '11948', '11954', '11987', '11986', '11999', '12002', '12004', '12005', '12006', '12007', '12008', '12018', '12019', '12020', '12026', '12027', '12035', '12040', '12043', '12044', '12052', '12086', '12128', '12136', '12146', '12152', '12154', '12280', '12547', '12548', '12549', '12550', '12551', '12552', '12553', '12554', '12555', '12556', '12557', '12601', '12652', '12699', '12728', '12984', '12985', '13254', '13253', '16245', '16246', '13926', '13928', '13557', '13941', '14022', '14024', '14044', '13933', '13953', '13957', '13961', '14052', '14015', '14017', '13990', '14007', '13979', '14675', '14676', '14678', '14679', '14681', '14682', '14684', '14685', '14687', '14688', '14690', '14691', '14693', '14694', '14696', '14697', '14699', '14700', '14702', '14703', '14705', '14706', '14708', '14709', '14711', '14712', '14714', '14715', '14717', '14718', '14720', '14721', '14723', '14724', '14726', '14727', '14735', '14736', '14738', '14739', '14741', '14742', '14744', '14745', '14747', '14748', '14750', '14751', '14753', '14754', '14756', '14757', '14759', '14760', '14762', '14763', '14765', '14766', '14768', '14769', '14771', '14772', '14774', '14775', '14777', '14778', '14780', '14781', '14783', '14784', '14786', '14787', '14819', '14820', '14822', '14823', '14795', '14796', '14798', '14799', '14801', '14802', '14804', '14805', '14807', '14808', '14810', '14811', '14813', '14814', '14816', '14817', '14789', '14790', '14792', '14793', '14729', '14730', '14732', '14733', '14976', '14977', '14983', '15030', '15029', '15025', '15031', '15039', '15061', '15062', '15063', '15064', '15065', '15066', '15067', '15068', '15069', '15070', '15309', '15351', '15353', '16211', '16228', '16229', '16230', '16231', '16232', '16234', '16238', '16239', '16240', '16241', '16242', '16243', '16244', '13252', '6545', '16290', '16289', '16297', '16296', '16338', '16335', '16547', '16546', '16734', '1', '17032', '17034', '17035', '17036', '17037', '16804', '17328', '17330', '13884', '15342', '17339', '17339', '17262', '17341', '17342', '17343', '17346')
|
| 0.0009 |
SELECT * FROM (`Collectible`) WHERE `Removed` = 0 AND `CategoryID` IN ('2233', '2234', '2287', '2288', '2290', '2289', '2292', '2488', '2293', '2487', '2489', '2294', '2232') ORDER BY `CollectibleID` desc
|
| 0.7979 |
SELECT DISTINCT cs.* FROM `Collectible` AS cs, `Attribute` AS at, `Attribute_Value` AS atv WHERE cs.CategoryID IN ( 2233,2234,2287,2288,2290,2289,2292,2488,2293,2487,2489,2294,2232 ) 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` = '2294' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2294' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6401' 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 = 6401 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
SELECT * FROM (`User`) WHERE `UserID` = '213' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2294
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2489
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2487
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2232
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1355
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1354
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6401' AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6401' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6401' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6401'
|
| 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 = 6401 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2293' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2293' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6400' 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 = 6400 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '213' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2293
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2488
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2292
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2232
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1355
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1354
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6400' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6400' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6400' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6400'
|
| 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 = 6400 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2234' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2234' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6287' 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 = 6287 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '213' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2234
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2233
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2232
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1355
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1354
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6287' AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6287' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6287' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6287'
|
| 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 = 6287 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2290' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2290' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6398' 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 = 6398 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 = 2290
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2288
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2287
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2232
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1355
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1354
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6398' AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6398' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6398' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6398'
|
| 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 = 6398 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2290' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2290' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6397' 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 = 6397 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 = 2290
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2288
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2287
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2232
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1355
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1354
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6397' AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6397' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6397' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6397'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 6397 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2290' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2290' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6395' 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 = 6395 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 = 2290
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2288
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2287
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2232
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1355
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1354
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6395' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6395' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6395' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6395'
|
| 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 = 6395 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2290' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2290' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '10778' 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 = 10778 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '213' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2290
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2288
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2287
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2232
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1355
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1354
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '10778' AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '10778' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '10778' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '10778'
|
| 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 = 10778 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2290' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2290' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6396' 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 = 6396 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 = 2290
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2288
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2287
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2232
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1355
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1354
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6396' AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6396' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6396' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6396'
|
| 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 = 6396 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2234' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2234' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6284' 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 = 6284 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '213' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2234
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2233
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2232
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1355
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1354
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6284' AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6284' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6284' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6284'
|
| 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 = 6284 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2234' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2234' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6285' 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 = 6285 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '213' LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2234
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2233
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2232
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1355
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1354
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6285' AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6285' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6285' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6285'
|
| 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 = 6285 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '2234' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2234' LIMIT 1
|
| 0.0002 |
SELECT * FROM (`Image`) WHERE `GenericID` = '6286' 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 = 6286 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '213' LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2234
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2233
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2232
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1355
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1354
|
| 0.0002 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6286' AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT * FROM (`Review`) WHERE `GenericID` = '6286' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '6286' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '6286'
|
| 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 = 6286 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.1592 |
select Tag, count(TagID) as nrTags from Tag where GenericType = 'collectible' AND GenericID IN ( 2233, 2234, 2287, 2288, 2290, 2289, 2292, 2488, 2293, 2487, 2489, 2294, 2232, 0 ) and Tag != '' and Removed = 0 GROUP BY Tag ORDER BY nrTags DESC LIMIT 50
|
| 0.0006 |
SELECT * FROM (`Attribute`) WHERE `Removed` = 0 AND `GenericType` = 'category' AND `GenericID` = '2232'
|
| 0.0002 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0002 |
SELECT * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
|
| 0.0001 |
select * from Notification_Filter
|
| 0.0002 |
select * from Notification
|
| 0.0001 |
select * from Notification
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2292 AND Removed = 0
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2287 AND Removed = 0
|
| 0.0001 |
SELECT CategoryID FROM `Category` WHERE ParentID = 2487 AND Removed = 0
|
| 0.0001 |
select * from Zone
|
| 0.0001 |
select * from Zone
|
| 0.0001 |
select * from Zone
|
| 0.0002 |
select * from Zone
|