| 0.0004 |
SELECT *
FROM (`Url`)
WHERE `GenericType` = 'category'
AND `GenericID` = '1672'
|
| 0.0178 |
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 = 1672
|
| 0.0003 |
select * from Attribute where GenericType = 'category' and GenericID = 1672
|
| 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 = 104
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 613
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 1665
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 1666
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 1667
|
| 0.0002 |
select * from Private where GenericType = 'category' and GenericID = 1672
|
| 0.0003 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
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.0037 |
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` = '1672'
AND `Removed` = 0
ORDER BY `Name` asc
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1672
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 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.0003 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '1672'
AND `GenericType` = 'category'
ORDER BY `ImageID` DESC
|
| 0.0002 |
SELECT *
FROM (`User`)
WHERE `UserID` = '37'
LIMIT 1
|
| 0.0001 |
SELECT CategoryID
FROM `Category`
WHERE ParentID = 1672 AND Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Role_Group_User`)
WHERE `RoleGroupID` IN (1, 2, 5)
AND `UserID` = -1
|
| 0.0006 |
SELECT *
FROM (`Collectible_Variation`)
|
| 0.0200 |
SELECT *
FROM (`Collectible`)
WHERE `Removed` = 0
AND `CategoryID` IN ('1672')
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.0012 |
SELECT *
FROM (`Collectible`)
WHERE `Removed` = 0
AND `CategoryID` IN ('1672')
ORDER BY `CollectibleID` desc
|
| 0.7986 |
SELECT DISTINCT cs.*
FROM `Collectible` AS cs, `Attribute` AS at, `Attribute_Value` AS atv
WHERE cs.CategoryID IN ( 1672 )
AND cs.Removed = 0
AND atv.Removed = 0
AND cs.CollectibleID = atv.GenericID
AND (at.Name = 'Name' OR at.Name = 'Title')
AND atv.AttributeID = at.AttributeID
ORDER BY atv.Value asc LIMIT 25
|
| 0.0002 |
SELECT GenericID FROM `Private` WHERE GenericType = "category" AND Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13151'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13151 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 = 1672
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13151'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13151'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13151'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13151'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13151 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13079'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13079 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 = 1672
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13079'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13079'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13079'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13079'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13079 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13080'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0003 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13080 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 = 1672
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13080'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13080'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13080'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13080'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13080 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13133'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13133 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 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.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13133'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13133'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13133'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13133'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13133 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13132'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13132 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 = 1672
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13132'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13132'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13132'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13132'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13132 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13078'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13078 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 = 1672
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13078'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13078'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13078'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13078'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13078 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13036'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13036 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13036'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13036'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13036'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13036'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13036 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13062'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13062 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 = 1672
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13062'
AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13062'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13062'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13062'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13062 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13145'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13145 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 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.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13145'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13145'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13145'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13145'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13145 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13097'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13097 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 = 1672
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 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.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13097'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13097'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13097'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13097'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13097 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13096'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13096 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13096'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13096'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13096'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13096'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13096 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13077'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13077 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0001 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13077'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13077'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13077'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13077'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13077 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13076'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13076 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13076'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13076'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13076'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13076'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13076 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13107'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0003 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13107 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 = 1672
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13107'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13107'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13107'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13107'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13107 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13053'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13053 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13053'
AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13053'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13053'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13053'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13053 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13052'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13052 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13052'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13052'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13052'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13052'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13052 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13144'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13144 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13144'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13144'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13144'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13144'
|
| 0.0001 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13144 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13143'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13143 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13143'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13143'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13143'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13143'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13143 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13106'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13106 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13106'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13106'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13106'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13106'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13106 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13084'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13084 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13084'
AND `GenericType` = 'collectible'
|
| 0.0001 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13084'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13084'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13084'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13084 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0001 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13059'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13059 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 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.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13059'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13059'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13059'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13059'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13059 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13051'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13051 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 = 1672
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13051'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13051'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13051'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13051'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13051 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13035'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13035 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13035'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13035'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13035'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13035'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13035 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13034'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0003 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13034 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 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.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13034'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13034'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13034'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13034'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13034 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.0002 |
SELECT *
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0001 |
SELECT `Name`
FROM (`Category`)
WHERE `CategoryID` = '1672'
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`Image`)
WHERE `GenericID` = '13061'
AND `GenericType` = 'collectible'
AND `MainImage` = 1
ORDER BY `ImageID` DESC
|
| 0.0002 |
select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 13061 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 = 1672
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1667
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1666
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1665
|
| 0.0002 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 613
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 104
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 2
|
| 0.0001 |
SELECT CP.CategoryID, CP.Name
FROM `Category` CP
INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID
WHERE CC.CategoryID = 1
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13061'
AND `GenericType` = 'collectible'
|
| 0.0002 |
SELECT *
FROM (`Review`)
WHERE `GenericID` = '13061'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0001 |
SELECT AVG(`Rating`) AS Rating
FROM (`Review`)
WHERE `GenericID` = '13061'
AND `GenericType` = 'collectible'
AND `Removed` = 0
|
| 0.0002 |
SELECT *
FROM (`Collectible_Variation`)
WHERE `Removed` = 0
AND `CollectibleID` = '13061'
|
| 0.0002 |
SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 13061 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
|
| 0.1472 |
select Tag, count(TagID) as nrTags from Tag where GenericType = 'collectible' AND GenericID IN ( 1672, 0 )
and Tag != '' and Removed = 0 GROUP BY Tag
ORDER BY nrTags DESC LIMIT 50
|
| 0.0006 |
SELECT *
FROM (`Attribute`)
WHERE `Removed` = 0
AND `GenericType` = 'category'
AND `GenericID` = '1672'
|
| 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
|
