Deluxe Class (4)

Bulk Add

Add

Added by CollectionStation

Dinobot
Category: Toys › Action Figures › Robots › TRANSFORMERS › Hasbro › TRANSFORMERS Universe (2008-?) › Deluxe Class
- Some accessibility text
- 0/5
0 (0 reviews)
Value: Sign In to view
Selling: 0 (0 friends 0 others)

Have

Want

Cataloged

Megatron
Category: Toys › Action Figures › Robots › TRANSFORMERS › Hasbro › TRANSFORMERS Universe (2008-?) › Deluxe Class
- Some accessibility text
- 0/5
0 (0 reviews)
Value: Sign In to view
Selling: 0 (0 friends 0 others)

Have

Want

Cataloged

Optimus Prime
Category: Toys › Action Figures › Robots › TRANSFORMERS › Hasbro › TRANSFORMERS Universe (2008-?) › Deluxe Class
- Some accessibility text
- 0/5
0 (0 reviews)
Value: Sign In to view
Selling: 0 (0 friends 0 others)

Have

Want

Cataloged

Smokescreen
Category: Toys › Action Figures › Robots › TRANSFORMERS › Hasbro › TRANSFORMERS Universe (2008-?) › Deluxe Class
- Some accessibility text
- 0/5
0 (0 reviews)
Value: Sign In to view
Selling: 0 (0 friends 0 others)

Have

Want

Cataloged

1 to 4 of 4

Loading Time: Base Classes	0.0200
Controller Execution Time ( Categories / Category By Name )	1.1634
Total Execution Time	1.1834

0.0004	SELECT * FROM (`Url`) WHERE `GenericType` = 'category' AND `GenericID` = '2435'
0.0149	`select c.*, (IsCategoryPrivate(CategoryID) = 1) as Private, (select count(CollectibleID) from Collectible where CategoryID = c.CategoryID and Removed = 0) as CollectibleCount from Category c where c.CategoryID = 2435`
0.0006	`select * from Attribute where GenericType = 'category' and GenericID = 2435`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 1`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 2`
0.0001	`select * from Private where GenericType = 'category' and GenericID = 92`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 93`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 94`
0.0005	`select * from Private where GenericType = 'category' and GenericID = 1613`
0.0004	`select * from Private where GenericType = 'category' and GenericID = 2435`
0.0003	SELECT * FROM (`Category`) WHERE `CategoryID` = '2435' AND `Removed` = 0
0.0003	SELECT * FROM (`Category`) WHERE `CategoryID` = '2435' 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.0031	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` = '2435' 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 = 2435
0.0003	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1613
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 94
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 93
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 92
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.0003	SELECT * FROM (`Image`) WHERE `GenericID` = '2435' AND `GenericType` = 'category' ORDER BY `ImageID` DESC
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT CategoryID FROM `Category` WHERE ParentID = 2435 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.0186	SELECT * FROM (`Collectible`) WHERE `Removed` = 0 AND `CategoryID` IN ('2435') 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 ('2435') ORDER BY `CollectibleID` desc
0.8114	SELECT DISTINCT cs.* FROM `Collectible` AS cs, `Attribute` AS at, `Attribute_Value` AS atv WHERE cs.CategoryID IN ( 2435 ) 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.0001	SELECT * FROM (`Category`) WHERE `CategoryID` = '2435' LIMIT 1
0.0003	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2435' LIMIT 1
0.0004	SELECT * FROM (`Image`) WHERE `GenericID` = '7597' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
0.0009	`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 = 7597 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 = 2435
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1613
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 94
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 93
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 92
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.0043	SELECT * FROM (`Review`) WHERE `GenericID` = '7597' AND `GenericType` = 'collectible'
0.0042	SELECT * FROM (`Review`) WHERE `GenericID` = '7597' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0032	SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '7597' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0007	SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '7597'
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 = 7597 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
0.0001	SELECT * FROM (`Category`) WHERE `CategoryID` = '2435' LIMIT 1
0.0001	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2435' LIMIT 1
0.0003	SELECT * FROM (`Image`) WHERE `GenericID` = '7602' 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 = 7602 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 = 2435
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1613
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 94
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 93
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 92
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.0042	SELECT * FROM (`Review`) WHERE `GenericID` = '7602' AND `GenericType` = 'collectible'
0.0043	SELECT * FROM (`Review`) WHERE `GenericID` = '7602' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0031	SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '7602' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0007	SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '7602'
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 = 7602 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
0.0001	SELECT * FROM (`Category`) WHERE `CategoryID` = '2435' LIMIT 1
0.0001	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2435' LIMIT 1
0.0003	SELECT * FROM (`Image`) WHERE `GenericID` = '7601' 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 = 7601 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 = 2435
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1613
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 94
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 93
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 92
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.0042	SELECT * FROM (`Review`) WHERE `GenericID` = '7601' AND `GenericType` = 'collectible'
0.0043	SELECT * FROM (`Review`) WHERE `GenericID` = '7601' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0032	SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '7601' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0007	SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '7601'
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 = 7601 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
0.0002	SELECT * FROM (`Category`) WHERE `CategoryID` = '2435' LIMIT 1
0.0003	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2435' LIMIT 1
0.0004	SELECT * FROM (`Image`) WHERE `GenericID` = '7596' 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 = 7596 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 = 2435
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1613
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 94
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 93
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 92
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.0042	SELECT * FROM (`Review`) WHERE `GenericID` = '7596' AND `GenericType` = 'collectible'
0.0043	SELECT * FROM (`Review`) WHERE `GenericID` = '7596' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0032	SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '7596' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0008	SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '7596'
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 = 7596 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
0.1489	`select Tag, count(TagID) as nrTags from Tag where GenericType = 'collectible' AND GenericID IN ( 2435, 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` = '2435'
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
0.0002	`select * from Notification_Filter`
0.0001	`select * from Notification`
0.0001	`select * from Notification`
0.0001	`select * from Zone`
0.0001	`select * from Zone`
0.0001	`select * from Zone`
0.0001	`select * from Zone`

HTTP_ACCEPT	text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,/;q=0.5
HTTP_USER_AGENT	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_CONNECTION	close
SERVER_PORT	80
SERVER_NAME	as.collectionstation.com
REMOTE_ADDR	38.107.179.233
SERVER_SOFTWARE	Apache/2
HTTP_ACCEPT_LANGUAGE	en-us,en;q=0.5
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.1
QUERY_STRING
HTTP_ACCEPT_ENCODING	gzip
HTTP_X_FORWARDED_FOR

session_id	5d1056e2018f342443d89677fbd7c357
ip_address	38.107.179.230
user_agent	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
last_activity	1337743440
category_id	2435

base_url	http://www.collectionstation.com/
index_page
uri_protocol	AUTO
url_suffix
language	english
charset	UTF-8
enable_hooks
subclass_prefix	MY_
permitted_uri_chars
enable_query_strings
directory_trigger	d
controller_trigger	c
function_trigger	m
log_threshold	0
log_path
log_date_format	Y-m-d H:i:s
cache_path
encryption_key	0BA565C0218E95F2FDE363571E4568262E6AE87002118329AD6CD62F802741AE
sess_cookie_name	cs_session
sess_expiration	86400
sess_encrypt_cookie	1
sess_use_database
sess_table_name	Session
sess_match_ip
sess_match_useragent
sess_time_to_update	300
cookie_prefix
cookie_domain
cookie_path	/
global_xss_filtering
compress_output
time_reference	local
rewrite_short_tags
Upload_AllowedTypes	Array ( [image/pjpeg] => jpg [image/jpeg] => jpg [image/gif] => gif [image/bmp] => bmp [image/x-png] => png [image/png] => png [image/zip] => zip [image/x-zip-compressed] => zip [application/pdf] => pdf )
Upload_MaxFileSize	52428800
Support	Array ( [Server] => mail.collectionstation.com [Port] => 110 [Email] => help@collectionstation.com [Username] => help@collectionstation.com [Password] => 28412ssg )
Email_DefaultSender	Array ( [Email] => no-reply@collectionstation.com [Name] => CollectionStation.com )
Emails	Array ( [Report] => Array ( [Collectible] => support@collectionstation.com [Blog] => support@collectionstation.com [Comment] => support@collectionstation.com ) [Collectible] => Array ( [CSV] => support@collectionstation.com ) )
Months	Array ( [0] => Array ( [0] => 1 [1] => Jan [2] => January ) [1] => Array ( [0] => 2 [1] => Feb [2] => February ) [2] => Array ( [0] => 3 [1] => Mar [2] => March ) [3] => Array ( [0] => 4 [1] => Apr [2] => April ) [4] => Array ( [0] => 5 [1] => May [2] => May ) [5] => Array ( [0] => 6 [1] => Jun [2] => June ) [6] => Array ( [0] => 7 [1] => Jul [2] => July ) [7] => Array ( [0] => 8 [1] => Aug [2] => August ) [8] => Array ( [0] => 9 [1] => Sep [2] => September ) [9] => Array ( [0] => 10 [1] => Oct [2] => October ) [10] => Array ( [0] => 11 [1] => Nov [2] => November ) [11] => Array ( [0] => 12 [1] => Dec [2] => December ) )
invalid_usernames	Array ( [0] => admin [1] => staff [2] => hasbro [3] => mattel [4] => neca [5] => star_wars [6] => starwars [7] => wwe [8] => sideshow [9] => sideshow_collectibles [10] => gentle_giant [11] => gentlegiant )
WatermarkImage	/home/stevecs/domains/collectionstation.com/git/githome/trunk/assets/images/watermark.png
signup_minimumage	13
captchaKeyPublic	6LcktQAAAAAAAKVsuDvlOPjFyoxpapzxqDkvnjoT
captchaKeyPrivate	6LcktQAAAAAAALaEVNO9bxWkHXS92Q4GcOsosPxR
CronPath	/home/stevecs/domains/collectionstation.com/git/githome/trunk/assets/_private/cron/
ReviewEditTimeout	3600
AllowCSVUpload
Pagination	Array ( [my] => Array ( [feeds] => 50 [messages] => Array ( [inbox] => 25 [sent] => 25 [trash] => 25 ) [friends] => Array ( [index] => 15 [requests] => 15 [pending] => 15 [suggestions] => 5 ) [groups] => Array ( [index] => 15 [created] => 15 [invites] => 15 ) [selling] => 20 [reviews] => 20 [collections] => Array ( [view] => 20 ) ) [profile] => Array ( [friends] => 25 [groups] => 25 [articles] => 25 [reviews] => 25 [favorites] => 25 [collectionitems] => 25 [photos] => 25 [collections] => 25 [selling] => 25 ) [groups] => Array ( [viewall] => 8 [threads] => 10 [discussions] => 10 [members] => 24 [latestthreads] => 10 ) [tags] => Array ( [search] => 10 ) [blog] => Array ( [articles] => 10 [latestarticles] => 10 [article] => Array ( [comments] => 10 ) ) [collectibles] => Array ( [index] => Array ( [categories] => Array ( [random] => 5 [newest] => 5 [right] => 15 ) [collectibles] => Array ( [random] => 5 [newest] => 5 [popular] => 5 [comments] => 5 ) [collectors] => Array ( [reviews] => 5 ) [view] => 20 ) [view] => Array ( [comments] => 50 [reviews] => 5 ) ) [category] => Array ( [view] => Array ( [collectibles] => 24 [right] => 15 ) ) [collections] => Array ( [index] => 20 ) [search] => Array ( [collectibles] => 20 [categories] => 20 [collections] => 20 [groups] => 20 [blogs] => 20 ) )
Ebay	Array ( [Mode] => Sandbox [Urls] => Array ( [ItemUrl] => http://rover.ebay.com/rover/1/711-53200-19255-0/1?type=2&campid=5335816071&toolid=10001&customid=&ext=%s&item=%s ) [Sandbox] => Array ( [Affiliation] => Array ( [TrackingID] => 5335816071 [TrackingPartnerCode] => 9 ) [Keys] => Array ( [App] => Collecti-6abf-4222-994a-f29b91034597 [Cert] => 2311c370-0c7d-4890-8c7e-86eb0caf9d70 [Dev] => 87e00c2e-beee-4d5f-8dcd-608966f590ed ) [Login] => Array ( [Username] => TESTUSER_csuser1 [Password] => amanda ) [RUName] => CollectionStati-Collecti-f256-4-lbbiez [SiteID] => 0 [Token] => AgAAAAAQAAAAaAAAAALFRiSQnY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wFk4CoDJKApgudj6x9nY+seQGe4AAAAAMAAAA35sPpDzizBTO7Ahi85dzdrrHHtJE5jovqcOjbcasSka02//i9Tsa0d1e9AJ3KCLcqOpB88xahaDpeRV4rH2SYlxN+XEsuKfWfUt9kRk5hZ3YQ590mNnkYno3ooTwxwr2d/d6qbP+PAsu891U3Ic+xKZ1z5rzMSv2oDBl0g8AcbG+MleSVFQa4YadFPQUS6Y7jJtCbY6mt1sclU+TH97bEwHIT9Ub/Qnub868hBk1CDVLJ+5N+kKLik+zpDCyP4OBsMx1CpWMbb/+/D5ktmnXD7y2Dk+OFTWzd6FbQbw5gEqL5ORmUr9RMjBJF//gUdgXfsdP+BzSDVB4OQowrfzF7NW9tsyRGsm++jdz6bMD1KYOXTDnr1gGS2MQgdNUeJBrOCQHgxWCmnLQkAF8cHqrNzCPHWnYagHiIUVbwYHeRruTJOhD7HgvsD7g2CkVLlHIIkTyKR/uBbgc3EuTaoIegoG4wCrbPDX3PbxK4tt/SHQ85dFelJQHYsYn5DhlRLNMVJbUwD/sar4TVbItCIMeoOpCBJTRUVjQZ4k/TwoLI8ozP/hUzU9N+GSK4fl0XXd5zv4Uexgn9fSIG1tS3SPeUZAMaiASJLJYMiiGfQMomu4TobRkc3Oy3JSc0Te1v5/9573V4T6+0Z7Z6SlNsQ65MAVmcCsQOFzYaCEeDS1KJxwpuN3jLX/y2Ln1j8ifrtWo1q1drBvU0AHAIZLCaniT3ENnRHWFExkbgbe+Jbumr0vqmF2OReF0woW1ObQhuM0 [TokenExpiry] => 1277836844 [Urls] => Array ( [Trading] => https://api.sandbox.ebay.com/ws/api.dll [Shopping] => http://open.api.sandbox.ebay.com/shopping [Login] => https://signin.sandbox.ebay.com/ws/eBayISAPI.dll?SignIn ) ) [Production] => Array ( [Affiliation] => Array ( [TrackingID] => 5335816071 [TrackingPartnerCode] => 9 ) [Keys] => Array ( [App] => Collecti-f256-4970-964b-45a0e5e42da4 [Cert] => e3bea769-4a3e-4862-8391-eae1168fc4d4 [Dev] => 87e00c2e-beee-4d5f-8dcd-608966f590ed ) [Login] => Array ( [Username] => collectionstation [Password] => 28412cs123 ) [RUName] => CollectionStati-Collecti-f256-4-lbbiez [SiteID] => 0 [Token] => AgAAAAAQAAAAaAAAAASS3ZSAnY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wDlIOgDpiFoAudj6x9nY+seQgWkAAAAAMAAAy9A44mmIUjsJVs/BKJFHZmyYA6vfKdYpVshki9s4n1qkR6KrDs+igww0sw5Z/vtME3+TYlTZ/R/0w9okIgPqJiXrOveXKAgqk/U1HOngaAUkzjsoAOpjgpbQ7aBOJdLGafdlYjJo4Y1p6KuB3eptVnz96mTqXE8Uiq/KJnQlxdUGl8V3/aENG5LyNVVkr460gEXiHsBhGZMUcNY3Cj4g5ScpRnNhs4fm7IIjehzdsxy2zp/Q1LeiNQp44n1H5xjQ+/GJWbTCFfaacoMg6TlldgvS+6pZoXde0wOXYXAeBirxefYFbor3Cfb9OjFTomBoU36PDs8pecvNXEm6tUsH95xRgnA8xhQc8oVqGfKIhbAIaRuf63JQ4ESiEQo2ftnRjc1reWZRUu6CxCmaMBU+A/DL+Gp+m6/I14/0pfNeVYR6AUBWq1LlLWTlvYpaTpFUU/8koYI9gQHrrvEbebYAbtckuJC8agRCHTKiBnYLOUUNnYuv7wKlcubueQVqb8oGRb61rE948e+xCoISgSWmVJxkKCUSkXGxFmjIJ9/giDxQz7SX0pEnmZ+2zMNiGfLF1c2V9qDJK6+VnrsoM6R1qq/KyK0rmvv+B3Doefk7XDhZJspnEJukS6gdqVB6ysLsmPvhfquqe5YVyk/ibX6EQfc93yk8RzxOPSv6Y2n1T79bsysO4zp2xz7kpeDegQX1vDpSI1LpIwIb6YMow4BnfA/g+n6VlvDZs4NiKyJjBgxnntpLjOCpcFVIDKAPoKFI [TokenExpiry] => 1277836844 [Urls] => Array ( [Trading] => https://api.ebay.com/ws/api.dll [Shopping] => http://open.api.ebay.com/shopping [Login] => https://signin.ebay.com/ws/eBayISAPI.dll?SignIn ) ) )
Amazon	Array ( [WSDL] => https://webservices.amazon.com/AWSECommerceService/AWSECommerceService.wsdl [Key] => 01NSVJN3ZJDBJ0CKB082 [SecretKey] => QQj24a5D5xHpJ8vMNuzF5adS02ddxUZJ2axFnbzU [Tag] => collectioncom-20 [CertPath] => /home/stevecs/domains/collectionstation.com/git/githome/trunk/assets//_private/cert-XLJLFUMSMJO27XFNSFYWA73DRIYQV5AX.pem )
CommissionJunction	Array ( [WSDL] => https://pubcommission.api.cj.com/wsdl/version2/publisherCommissionServiceV2.wsdl [Key] => 00adcd6482b3e6b7b46f10f8cbadec5bb32c3a124dfb0657aa5c9ee8ab27cfffc688ebfe6aef86384ded52c84d29b951584944e8184d7a19baaffd79e4b00de88d/7126d6380dbdb87dfd0d349d0e3762200d3c256ca57024a4e23606ce5f56187367e8022feed3c6e433488ad908defdb9ab32b92431a7173b5d15a71e55984e81 )
DataUnison	Array ( [Mode] => Sandbox [Sandbox] => Array ( [Keys] => Array ( [User] => 68df413c6cd87412016fb9195bbe67 [Dev] => collectionstation_steve_comenzo ) [SiteID] => 0 [Token] => d16bda03700aac097dd79e20e110ee [Urls] => http://api.dataunison.com/ ) [Production] => Array ( [Keys] => Array ( [User] => 68df413c6cd87412016fb9195bbe67 [Dev] => collectionstation_steve_comenzo ) [SiteID] => 0 [Token] => d16bda03700aac097dd79e20e110ee [Urls] => http://api.dataunison.com/ ) )
Cache	Array ( [Servers] => Array ( [0] => Array ( [Host] => localhost [Port] => 11211 ) ) )

CATEGORY

FILTER BY

RECENTLY VIEWED

Category Managers

SPONSORED

Deluxe Class (4)