| 0.0003 |
SELECT * FROM (`Url`) WHERE `GenericType` = 'category' AND `GenericID` = '3561'
|
| 0.0149 |
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 = 3561
|
| 0.0004 |
select * from Attribute where GenericType = 'category' and GenericID = 3561
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 21
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 22
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 23
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 115
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 25
|
| 0.0001 |
select * from Private where GenericType = 'category' and GenericID = 45
|
| 0.0004 |
select * from Private where GenericType = 'category' and GenericID = 3561
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' AND `Removed` = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0001 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = 0
|
| 0.0003 |
SELECT * FROM (`Private`) WHERE `GenericType` = 'Category' AND `Removed` = 0
|
| 0.0032 |
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` = '3561' AND `Removed` = 0 ORDER BY `Name` asc
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 3561
|
| 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.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.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` = '3561' AND `GenericType` = 'category' ORDER BY `ImageID` DESC
|
| 0.0002 |
SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
|
| 0.0002 |
SELECT CategoryID FROM `Category` WHERE ParentID = 3561 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.0183 |
SELECT * FROM (`Collectible`) WHERE `Removed` = 0 AND `CategoryID` IN ('3561') 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.0005 |
SELECT * FROM (`Collectible`) WHERE `Removed` = 0 AND `CategoryID` IN ('3561') ORDER BY `CollectibleID` desc
|
| 0.8343 |
SELECT DISTINCT cs.* FROM `Collectible` AS cs, `Attribute` AS at, `Attribute_Value` AS atv WHERE cs.CategoryID IN ( 3561 ) 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` = '3561' LIMIT 1
|
| 0.0003 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14640' 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 = 14640 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 = 3561
|
| 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.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.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` = '14640' AND `GenericType` = 'collectible'
|
| 0.0044 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14640' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14640' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0009 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14640'
|
| 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 = 14640 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '13801' 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 = 13801 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 = 3561
|
| 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.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` = '13801' AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '13801' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '13801' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0008 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '13801'
|
| 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 = 13801 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14637' 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 = 14637 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 = 3561
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 45
|
| 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.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` = '14637' AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14637' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14637' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14637'
|
| 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 = 14637 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14636' 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 = 14636 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 = 3561
|
| 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.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.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14636' AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14636' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14636' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0006 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14636'
|
| 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 = 14636 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14651' 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 = 14651 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 = 3561
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 45
|
| 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` = '14651' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14651' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14651' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14651'
|
| 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 = 14651 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14648' 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 = 14648 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 = 3561
|
| 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.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` = '14648' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14648' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14648' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0008 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14648'
|
| 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 = 14648 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14654' 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 = 14654 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 = 3561
|
| 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.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.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` = '14654' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14654' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14654' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0008 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14654'
|
| 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 = 14654 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14635' 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 = 14635 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 = 3561
|
| 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.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` = '14635' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14635' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14635' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0008 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14635'
|
| 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 = 14635 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14644' 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 = 14644 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 = 3561
|
| 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.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.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14644' AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14644' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14644' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14644'
|
| 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 = 14644 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14643' 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 = 14643 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 = 3561
|
| 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.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` = '14643' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14643' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14643' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14643'
|
| 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 = 14643 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14634' 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 = 14634 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 = 3561
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 45
|
| 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.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14634' AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14634' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14634' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14634'
|
| 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 = 14634 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14645' 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 = 14645 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 = 3561
|
| 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.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` = '14645' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14645' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14645' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14645'
|
| 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 = 14645 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14646' 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 = 14646 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 = 3561
|
| 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.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.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14646' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14646' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14646' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0008 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14646'
|
| 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 = 14646 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14650' 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 = 14650 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 = 3561
|
| 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.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` = '14650' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14650' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0033 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14650' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14650'
|
| 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 = 14650 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14652' 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 = 14652 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 = 3561
|
| 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.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` = '14652' AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14652' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14652' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0008 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14652'
|
| 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 = 14652 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14647' 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 = 14647 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 = 3561
|
| 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.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.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` = '14647' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14647' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14647' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0008 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14647'
|
| 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 = 14647 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14638' 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 = 14638 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 = 3561
|
| 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.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` = '14638' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14638' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14638' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14638'
|
| 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 = 14638 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14642' 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 = 14642 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 = 3561
|
| 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.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` = '14642' AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14642' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14642' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14642'
|
| 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 = 14642 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14656' 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 = 14656 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 = 3561
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 45
|
| 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` = '14656' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14656' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14656' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0008 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14656'
|
| 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 = 14656 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14653' 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 = 14653 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 = 3561
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 45
|
| 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` = '14653' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14653' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0033 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14653' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14653'
|
| 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 = 14653 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14641' 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 = 14641 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 = 3561
|
| 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.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.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14641' AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14641' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14641' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14641'
|
| 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 = 14641 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0003 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0004 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14655' 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 = 14655 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 = 3561
|
| 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.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.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14655' AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14655' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14655' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0008 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14655'
|
| 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 = 14655 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0001 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14649' 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 = 14649 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 = 3561
|
| 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.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.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` = '14649' AND `GenericType` = 'collectible'
|
| 0.0041 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14649' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14649' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14649'
|
| 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 = 14649 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT * FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0002 |
SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '3561' LIMIT 1
|
| 0.0003 |
SELECT * FROM (`Image`) WHERE `GenericID` = '14639' 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 = 14639 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 = 3561
|
| 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.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` = '14639' AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT * FROM (`Review`) WHERE `GenericID` = '14639' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '14639' AND `GenericType` = 'collectible' AND `Removed` = 0
|
| 0.0007 |
SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '14639'
|
| 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 = 14639 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.1490 |
select Tag, count(TagID) as nrTags from Tag where GenericType = 'collectible' AND GenericID IN ( 3561, 0 ) and Tag != '' and Removed = 0 GROUP BY Tag ORDER BY nrTags DESC LIMIT 50
|
| 0.0005 |
SELECT * FROM (`Attribute`) WHERE `Removed` = 0 AND `GenericType` = 'category' AND `GenericID` = '3561'
|
| 0.0002 |
SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
|
| 0.0002 |
SELECT * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
|
| 0.0002 |
select * from Notification_Filter
|
| 0.0002 |
select * from Notification
|
| 0.0002 |
select * from Notification
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|
| 0.0002 |
select * from Zone
|