| 0.0004 |
SELECT *
FROM (`Url`)
WHERE `GenericType` = 'category'
AND `GenericID` = '413'
|
| 0.0191 |
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 = 413
|
| 0.0006 |
select * from Attribute where GenericType = 'category' and GenericID = 413
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 1
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 2
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 98
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 3
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 66
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 5
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 116
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 366
|
| 0.0005 |
select * from Private where GenericType = 'category' and GenericID = 413
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '413'
AND `Removed` = 0
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Role_Group_User`)
WHERE `RoleGroupID` IN (1, 2, 5)
AND `UserID` = 0
|
| 0.0003 |
SELECT *
FROM (`Private`)
WHERE `GenericType` = 'Category'
AND `Removed` = 0
|
| 0.0033 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` NOT IN ('746', '2144', '1131', '987', '991', '993', '994', '1055', '1079', '1088', '1090', '1094', '1149', '1150', '1246', '1299', '1305', '1308', '1309', '1311', '1464', '1473', '1493', '1494', '1518', '1519', '1520', '1530', '1531', '1761', '1721', '1729', '1733', '1735', '1736', '1765', '1766', '1767', '1768', '1769', '1770', '1771', '1772', '1773', '1774', '1776', '1777', '1778', '1779', '1780', '1781', '1782', '1783', '1784', '1786', '1803', '1810', '1815', '1816', '1817', '1818', '1819', '1820', '1821', '1822', '1823', '1824', '1825', '1826', '1827', '1828', '1829', '1830', '1831', '1832', '1833', '1834', '1835', '1861', '2011', '2012', '2013', '2014', '2016', '2017', '2018', '2022', '2069', '2080', '2082', '2083', '2084', '2085', '2086', '2087', '2088', '2089', '2090', '2091', '2092', '2093', '2094', '2095', '2096', '2097', '2098', '2099', '2100', '2101', '2102', '2103', '2112', '2113', '2114', '2115', '2116', '2117', '2118', '2119', '2120', '2121', '2122', '2123', '2124', '2125', '2133', '2128', '2129', '2130', '2131', '2132', '2134', '2135', '2136', '2137', '2233', '2234', '2373', '2390', '2653', '2950', '3006', '3374', '3823', '3824', '3825', '3826', '3827', '3828', '3829', '3830', '3831', '3832', '3833', '3834', '3835', '3836', '3837', '3838', '3839', '3840', '3841', '3842', '3843', '3844', '3845', '3846', '3847', '3848', '3849', '3850', '3932', '3934', '3935', '3936', '3937', '3938', '3939', '3940', '3941', '3942', '3943', '3944', '3953', '3954', '3955', '3956', '3957', '3958', '3959', '3999', '4026', '4029', '4030', '4045', '4045', '4045', '4046')
AND `ParentID` = '413'
AND `Removed` = 0
ORDER BY `Name` asc
|
| 0.0004 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 413
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 366
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 116
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 5
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 66
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 98
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '413'
AND `GenericType` = 'category'
ORDER BY `ImageID` DESC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '37'
LIMIT 1
|
| 0.0003 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 413 AND Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Role_Group_User`)
WHERE `RoleGroupID` IN (1, 2, 5)
AND `UserID` = -1
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
|
| 0.0184 |
SELECT *
FROM (`Collectible`)
WHERE `Removed` = 0
AND `CategoryID` IN ('413')
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.0004 |
SELECT *
FROM (`Collectible`)
WHERE `Removed` = 0
AND `CategoryID` IN ('413')
ORDER BY `CollectibleID` desc
|
| 0.7959 |
SELECT DISTINCT cs.*
FROM `Collectible` AS cs, `Attribute` AS at, `Attribute_Value` AS atv
WHERE cs.CategoryID IN ( 413 )
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` = '413'
LIMIT 1
|
| 0.0003 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '9253'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0008 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 9253 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
SELECT *
FROM (`User`)
WHERE `UserID` = '93'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 413
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 366
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 116
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 5
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 66
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 98
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9253'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9253'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '9253'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '9253'
|
| 0.0008 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 9253 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '9252'
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 = 9252 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0003 |
SELECT *
FROM (`User`)
WHERE `UserID` = '93'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 413
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 366
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 116
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 5
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 66
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 98
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9252'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9252'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '9252'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '9252'
|
| 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 = 9252 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '9251'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0008 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 9251 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '93'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 413
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 366
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 116
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 5
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 66
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 98
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9251'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9251'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '9251'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '9251'
|
| 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 = 9251 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '9250'
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 = 9250 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '93'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 413
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 366
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 116
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 5
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 66
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 98
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9250'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9250'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '9250'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '9250'
|
| 0.0007 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 9250 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '9249'
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 = 9249 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '93'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 413
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 366
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 116
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 5
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 66
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 98
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9249'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9249'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0032 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '9249'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '9249'
|
| 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 = 9249 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '9248'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0008 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 9248 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '93'
LIMIT 1
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 413
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 366
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 116
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 5
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 66
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 98
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9248'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9248'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '9248'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '9248'
|
| 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 = 9248 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '9247'
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 = 9247 ORDER BY a.Position, a.AttributeID ASC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '93'
LIMIT 1
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 413
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 366
|
| 0.0003 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 116
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 5
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 66
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 98
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9247'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9247'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0030 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '9247'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0008 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '9247'
|
| 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 = 9247 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '9168'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0008 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 9168 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 = 413
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 366
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 116
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 5
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 66
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 98
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9168'
AND `GenericType` = 'collectible'
|
| 0.0042 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9168'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '9168'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '9168'
|
| 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 = 9168 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '413'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '9167'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0008 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 9167 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 = 413
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 366
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 116
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 5
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 66
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 3
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 98
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0041 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9167'
AND `GenericType` = 'collectible'
|
| 0.0043 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '9167'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0031 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '9167'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0007 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '9167'
|
| 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 = 9167 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.1606 |
select Tag, count(TagID) as nrTags from Tag where GenericType = 'collectible' AND GenericID IN ( 413, 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` = '413'
|
| 0.0001 |
SELECT *
FROM (`Role_Group_User`)
WHERE `RoleGroupID` IN (1, 2, 5)
AND `UserID` = -1
|
| 0.0002 |
SELECT * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
|
| 0.0001 |
select * from Notification_Filter
|
| 0.0001 |
select * from Notification
|
| 0.0001 |
select * from Notification
|
| 0.0002 |
select * from Zone
|
| 0.0001 |
select * from Zone
|
| 0.0001 |
select * from Zone
|
| 0.0001 |
select * from Zone
|
