G.I. Joe: Retaliation (4)

HASBRO is proud to unveil the official movie action figure and toy line for the new “G.I. JOE: Retaliation” movie starring Dwayne Johnson & Bruce Willis! The new line reflects the movie magic, including the epic battle between the G.I. JOE team and arch-nemesis COBRA, which, led by COBRA COMMANDER, is once again intent on taking over the world.

Added by CollectionStation

Ghost Hawk II
Category: Toys › Action Figures › Military › G.I. Joe › Hasbro › Modern (1997 - Now) › G.I. Joe: Retaliation › Delta Vehicles
- Some accessibility text
- 0/5
0 (0 reviews)
Value: Sign In to view
Selling: 0 (0 friends 0 others)

Have

Want

Cataloged

Ninja Speedcycle with Snakeyes
Category: Toys › Action Figures › Military › G.I. Joe › Hasbro › Modern (1997 - Now) › G.I. Joe: Retaliation › Alpha Vehicles
- Some accessibility text
- 0/5
0 (0 reviews)
Value: Sign In to view
Selling: 0 (0 friends 0 others)

Have

Want

Cataloged

Roadblock
Category: Toys › Action Figures › Military › G.I. Joe › Hasbro › Modern (1997 - Now) › G.I. Joe: Retaliation › Basic 3 3/4" Figures
- Some accessibility text
- 0/5
0 (0 reviews)
Value: Sign In to view
Selling: 0 (0 friends 0 others)

Have

Want

Cataloged

Storm Shadow Mask
Category: Toys › Action Figures › Military › G.I. Joe › Hasbro › Modern (1997 - Now) › G.I. Joe: Retaliation › Role Play
- 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.0082
Controller Execution Time ( Categories / Category By Name )	1.2316
Total Execution Time	1.2399

0.0004	SELECT * FROM (`Url`) WHERE `GenericType` = 'category' AND `GenericID` = '4015'
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 = 4015`
0.0004	`select * from Attribute where GenericType = 'category' and GenericID = 4015`
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 = 89`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 90`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 2358`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 91`
0.0005	`select * from Private where GenericType = 'category' and GenericID = 4015`
0.0003	SELECT * FROM (`Category`) WHERE `CategoryID` = '4015' AND `Removed` = 0
0.0003	SELECT * FROM (`Category`) WHERE `CategoryID` = '4015' LIMIT 1
0.0002	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = 0
0.0004	SELECT * FROM (`Private`) WHERE `GenericType` = 'Category' AND `Removed` = 0
0.0038	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` = '4015' AND `Removed` = 0 ORDER BY `Name` asc
0.0003	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 4015
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 91
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2358
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 90
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 89
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.0004	SELECT * FROM (`Image`) WHERE `GenericID` = '4015' AND `GenericType` = 'category' ORDER BY `ImageID` DESC
0.0003	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0003	SELECT CategoryID FROM `Category` WHERE ParentID = 4015 AND Removed = 0
0.0003	SELECT CategoryID FROM `Category` WHERE ParentID = 4017 AND Removed = 0
0.0003	SELECT CategoryID FROM `Category` WHERE ParentID = 4018 AND Removed = 0
0.0003	SELECT CategoryID FROM `Category` WHERE ParentID = 4019 AND Removed = 0
0.0003	SELECT CategoryID FROM `Category` WHERE ParentID = 4020 AND Removed = 0
0.0002	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0007	SELECT * FROM (`Collectible_Variation`)
0.0732	SELECT * FROM (`Collectible`) WHERE `Removed` = 0 AND `CategoryID` IN ('4017', '4018', '4019', '4020', '4015') AND `CollectibleID` IN ('234', '235', '236', '237', '239', '243', '245', '246', '247', '388', '251', '521', '634', '701', '788', '784', '1035', '1036', '1228', '1310', '1311', '1312', '1313', '1314', '1639', '1640', '1641', '1670', '1671', '1672', '1772', '1773', '1780', '1866', '2177', '2178', '2179', '2544', '2545', '2546', '2547', '2548', '2549', '2667', '2673', '2677', '2678', '2679', '2680', '2681', '2682', '2730', '2748', '2749', '2750', '2751', '2778', '2882', '2900', '2901', '2902', '2911', '2953', '2977', '2985', '2986', '2988', '2995', '3045', '3046', '3236', '3377', '3378', '3391', '3392', '3405', '3406', '3407', '3408', '3416', '3418', '3420', '3429', '3430', '3431', '3437', '3443', '3450', '3461', '3473', '3520', '3722', '3779', '3780', '3852', '3671', '4485', '4486', '4490', '4542', '4884', '4885', '4886', '4887', '4888', '4889', '4890', '4891', '4920', '4921', '4922', '4923', '4945', '4948', '4956', '4958', '4963', '4966', '5059', '5063', '5069', '5072', '5073', '5136', '5226', '5228', '5259', '5262', '5264', '5266', '5372', '5374', '5377', '5382', '5384', '5386', '5388', '5414', '5437', '11805', '11803', '5446', '5453', '5697', '5698', '5700', '5706', '5707', '5791', '5792', '5793', '5794', '5795', '5796', '5797', '5798', '5799', '5800', '5801', '5802', '5803', '5804', '5805', '5806', '5807', '5808', '5809', '5810', '5811', '5812', '5813', '5814', '5815', '5816', '5817', '5818', '5819', '5820', '5821', '5822', '5823', '5824', '5825', '5826', '5827', '5828', '5829', '5830', '5831', '5832', '5833', '5834', '5835', '5836', '5837', '5838', '5839', '5840', '5841', '5842', '5843', '5844', '5845', '5846', '5847', '5848', '5849', '5850', '5851', '5852', '5853', '5854', '5855', '5856', '5857', '5858', '5859', '5860', '5861', '5862', '5863', '5864', '5865', '5866', '5867', '5868', '5869', '5870', '5871', '5872', '5873', '5874', '5875', '5876', '5877', '5878', '5879', '5880', '5881', '5882', '5883', '5884', '5885', '5886', '5887', '5888', '5889', '5890', '5891', '5892', '5896', '5903', '5897', '5909', '5910', '5911', '5912', '5913', '5914', '5915', '5916', '5917', '5918', '5919', '5920', '5921', '5922', '5923', '5924', '5925', '6193', '6424', '6425', '6426', '6427', '6678', '6679', '6680', '6681', '6682', '6683', '6684', '6685', '6686', '6687', '6688', '6689', '6690', '6691', '6692', '6693', '6694', '6695', '6696', '6699', '6701', '6702', '6703', '6704', '6705', '6706', '6707', '6710', '6711', '6722', '6723', '6724', '6725', '13462', '13420', '13417', '6805', '7346', '7345', '7344', '7343', '7578', '7579', '7580', '7581', '7582', '7583', '7584', '7585', '7586', '7736', '7773', '7958', '7957', '7955', '7956', '7908', '8021', '8046', '8108', '8109', '8110', '8111', '8175', '8157', '8156', '8520', '8408', '8522', '8531', '8529', '8513', '8537', '8503', '8501', '8535', '8479', '8533', '8473', '8474', '8454', '8515', '8516', '8524', '8525', '8526', '8581', '8634', '8676', '8654', '8657', '8659', '8661', '8663', '8668', '8666', '8787', '8786', '8875', '8824', '8840', '8865', '8826', '8897', '8921', '8922', '8926', '8927', '8928', '8929', '8931', '8932', '8934', '8938', '8939', '4404', '8950', '8951', '8952', '8953', '8981', '8982', '8993', '9045', '9046', '9047', '9048', '9049', '9050', '9051', '9052', '9053', '9054', '9055', '9056', '9057', '9058', '9059', '9060', '9061', '9062', '9063', '9064', '9065', '9066', '9067', '9068', '9069', '9070', '9071', '9072', '9073', '9074', '9075', '9076', '9077', '9078', '9079', '9080', '9081', '9082', '9083', '9084', '9085', '9086', '9087', '9088', '9089', '9090', '9091', '9092', '9093', '9094', '9095', '9096', '9120', '9121', '8999', '9051', '9052', '8997', '9053', '9054', '8998', '9055', '9056', '9124', '9165', '9168', '9170', '9158', '9151', '9126', '9136', '9147', '9148', '9149', '9129', '9143', '9145', '9153', '9134', '9186', '9188', '9191', '9193', '9195', '9197', '9198', '9203', '9207', '9209', '9210', '9214', '9216', '9220', '9226', '9228', '9236', '9253', '9251', '9249', '9247', '9247', '9257', '9259', '9260', '9261', '9263', '9265', '9269', '9271', '9272', '9277', '9288', '9304', '9305', '9306', '9307', '9308', '9309', '9310', '9313', '9314', '9316', '9415', '9419', '9420', '9420', '9422', '9434', '9439', '9399', '9331', '9336', '9342', '9379', '9340', '9382', '9385', '9407', '9408', '9409', '9351', '9346', '9347', '9348', '9359', '9356', '9391', '9369', '9371', '9455', '9510', '9820', '9963', '9964', '9964', '9969', '9970', '9971', '9972', '10108', '10109', '10474', '10475', '10476', '10477', '10589', '10590', '10711', '10532', '10533', '10534', '10468', '10469', '10470', '10471', '10472', '10446', '10447', '10448', '10449', '10621', '10609', '10610', '10601', '10602', '10603', '10604', '10501', '10502', '10503', '10504', '10505', '10697', '10695', '10696', '10698', '10699', '10700', '10701', '10702', '10669', '10688', '10443', '10444', '10708', '10716', '10717', '10536', '10537', '10719', '10720', '10412', '10721', '10722', '10723', '10724', '10413', '10571', '10573', '10575', '10539', '10540', '10541', '10542', '10555', '10556', '10557', '10592', '10593', '10594', '10595', '10633', '10634', '10451', '10452', '10453', '10454', '10455', '10705', '10544', '10545', '10641', '10415', '10416', '10417', '10686', '10419', '10420', '10422', '10423', '10424', '10425', '10426', '10427', '10428', '10493', '10494', '10495', '10496', '10559', '10560', '10561', '10606', '10607', '10612', '10613', '10628', '10629', '10615', '10578', '10579', '10581', '10582', '10583', '10498', '10499', '10563', '10564', '10565', '10566', '10479', '10480', '10481', '10482', '10483', '10484', '10485', '10430', '10431', '10432', '10547', '10548', '10549', '10550', '10507', '10508', '10509', '10510', '10677', '10678', '10679', '10680', '10681', '10682', '10683', '10487', '10488', '10725', '10631', '10457', '10568', '10569', '10623', '10624', '10625', '10626', '10464', '10465', '10466', '10552', '10553', '10512', '10513', '10514', '10515', '10516', '10517', '10459', '10460', '10461', '10434', '10435', '10617', '10519', '10520', '10619', '10585', '10586', '10587', '10597', '10598', '10599', '10636', '10437', '10438', '10439', '10440', '10441', '10648', '10522', '10525', '10526', '10523', '10524', '10527', '10528', '10529', '10530', '10489', '10490', '10491', '10738', '10747', '11038', '11080', '11185', '11097', '11638', '9567', '11186', '11209', '11208', '11211', '11187', '11243', '11242', '9570', '9564', '11241', '11099', '11315', '11359', '11360', '11361', '11362', '11380', '7435', '11428', '11632', '10987', '8643', '8646', '8647', '7445', '8737', '8645', '7447', '11098', '11674', '11682', '2888', '2889', '11675', '8417', '3921', '8728', '3918', '11679', '11680', '11683', '11684', '11685', '11746', '11741', '11740', '11709', '11464', '11716', '11748', '11747', '11800', '11948', '11954', '11987', '11986', '11999', '12002', '12004', '12005', '12006', '12007', '12008', '12018', '12019', '12020', '12026', '12027', '12035', '12040', '12043', '12044', '12052', '12086', '12128', '12136', '12146', '12152', '12154', '12280', '12547', '12548', '12549', '12550', '12551', '12552', '12553', '12554', '12555', '12556', '12557', '12601', '12652', '12699', '12728', '12984', '12985', '13254', '13253', '16245', '16246', '13926', '13928', '13557', '13941', '14022', '14024', '14044', '13933', '13953', '13957', '13961', '14052', '14015', '14017', '13990', '14007', '13979', '14675', '14676', '14678', '14679', '14681', '14682', '14684', '14685', '14687', '14688', '14690', '14691', '14693', '14694', '14696', '14697', '14699', '14700', '14702', '14703', '14705', '14706', '14708', '14709', '14711', '14712', '14714', '14715', '14717', '14718', '14720', '14721', '14723', '14724', '14726', '14727', '14735', '14736', '14738', '14739', '14741', '14742', '14744', '14745', '14747', '14748', '14750', '14751', '14753', '14754', '14756', '14757', '14759', '14760', '14762', '14763', '14765', '14766', '14768', '14769', '14771', '14772', '14774', '14775', '14777', '14778', '14780', '14781', '14783', '14784', '14786', '14787', '14819', '14820', '14822', '14823', '14795', '14796', '14798', '14799', '14801', '14802', '14804', '14805', '14807', '14808', '14810', '14811', '14813', '14814', '14816', '14817', '14789', '14790', '14792', '14793', '14729', '14730', '14732', '14733', '14976', '14977', '14983', '15030', '15029', '15025', '15031', '15039', '15061', '15062', '15063', '15064', '15065', '15066', '15067', '15068', '15069', '15070', '15309', '15351', '15353', '16211', '16228', '16229', '16230', '16231', '16232', '16234', '16238', '16239', '16240', '16241', '16242', '16243', '16244', '13252', '6545', '16290', '16289', '16297', '16296', '16338', '16335', '16547', '16546', '16734', '1', '17032', '17034', '17035', '17036', '17037', '16804', '17328', '17330', '13884', '15342', '17339', '17339', '17262', '17341', '17342', '17343', '17346')
0.0005	SELECT * FROM (`Collectible`) WHERE `Removed` = 0 AND `CategoryID` IN ('4017', '4018', '4019', '4020', '4015') ORDER BY `CollectibleID` desc
0.7968	SELECT DISTINCT cs.* FROM `Collectible` AS cs, `Attribute` AS at, `Attribute_Value` AS atv WHERE cs.CategoryID IN ( 4017,4018,4019,4020,4015 ) AND cs.Removed = 0 AND atv.Removed = 0 AND cs.CollectibleID = atv.GenericID AND (at.Name = 'Name' OR at.Name = 'Title') AND atv.AttributeID = at.AttributeID ORDER BY atv.Value asc LIMIT 25
0.0003	SELECT GenericID FROM `Private` WHERE GenericType = "category" AND Removed = 0
0.0003	SELECT * FROM (`Category`) WHERE `CategoryID` = '4020' LIMIT 1
0.0002	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '4020' LIMIT 1
0.0004	SELECT * FROM (`Image`) WHERE `GenericID` = '17154' 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 = 17154 ORDER BY a.Position, a.AttributeID ASC`
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0004	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 4020
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 4015
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 91
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2358
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 90
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 89
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
0.0041	SELECT * FROM (`Review`) WHERE `GenericID` = '17154' AND `GenericType` = 'collectible'
0.0041	SELECT * FROM (`Review`) WHERE `GenericID` = '17154' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0032	SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '17154' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0008	SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '17154'
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 = 17154 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
0.0003	SELECT * FROM (`Category`) WHERE `CategoryID` = '4017' LIMIT 1
0.0002	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '4017' LIMIT 1
0.0003	SELECT * FROM (`Image`) WHERE `GenericID` = '17151' 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 = 17151 ORDER BY a.Position, a.AttributeID ASC`
0.0003	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0003	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 4017
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 4015
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 91
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2358
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 90
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 89
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
0.0041	SELECT * FROM (`Review`) WHERE `GenericID` = '17151' AND `GenericType` = 'collectible'
0.0043	SELECT * FROM (`Review`) WHERE `GenericID` = '17151' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0030	SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '17151' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0007	SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '17151'
0.0005	SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 17151 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
0.0003	SELECT * FROM (`Category`) WHERE `CategoryID` = '4018' LIMIT 1
0.0003	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '4018' LIMIT 1
0.0004	SELECT * FROM (`Image`) WHERE `GenericID` = '17152' 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 = 17152 ORDER BY a.Position, a.AttributeID ASC`
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0003	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 4018
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 4015
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 91
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2358
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 90
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 89
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
0.0041	SELECT * FROM (`Review`) WHERE `GenericID` = '17152' AND `GenericType` = 'collectible'
0.0042	SELECT * FROM (`Review`) WHERE `GenericID` = '17152' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0031	SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '17152' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0008	SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '17152'
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 = 17152 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
0.0003	SELECT * FROM (`Category`) WHERE `CategoryID` = '4019' LIMIT 1
0.0003	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '4019' LIMIT 1
0.0003	SELECT * FROM (`Image`) WHERE `GenericID` = '17153' 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 = 17153 ORDER BY a.Position, a.AttributeID ASC`
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0004	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 4019
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 4015
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 91
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2358
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 90
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 89
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
0.0041	SELECT * FROM (`Review`) WHERE `GenericID` = '17153' AND `GenericType` = 'collectible'
0.0042	SELECT * FROM (`Review`) WHERE `GenericID` = '17153' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0031	SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '17153' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0007	SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '17153'
0.0005	SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 17153 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
0.1511	`select Tag, count(TagID) as nrTags from Tag where GenericType = 'collectible' AND GenericID IN ( 4017, 4018, 4019, 4020, 4015, 0 ) and Tag != '' and Removed = 0 GROUP BY Tag ORDER BY nrTags DESC LIMIT 50`
0.0004	SELECT * FROM (`Attribute`) WHERE `Removed` = 0 AND `GenericType` = 'category' AND `GenericID` = '4015'
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.0001	SELECT CategoryID FROM `Category` WHERE ParentID = 4018 AND Removed = 0
0.0002	SELECT CategoryID FROM `Category` WHERE ParentID = 4017 AND Removed = 0
0.0002	SELECT CategoryID FROM `Category` WHERE ParentID = 4019 AND Removed = 0
0.0001	SELECT CategoryID FROM `Category` WHERE ParentID = 4020 AND Removed = 0
0.0002	`select * from Zone`
0.0002	`select * from Zone`
0.0003	`select * from Url where GenericType = 'collectible' and GenericID = 17153`
0.0002	`select * from Url where GenericType = 'collectible' and GenericID = 17153`
0.0001	`select * from Url where GenericType = 'collectible' and GenericID = 17153`
0.0001	`select * from Url where GenericType = 'collectible' and GenericID = 17153`
0.0003	`select * from Url where GenericType = 'collectible' and GenericID = 17152`
0.0002	`select * from Url where GenericType = 'collectible' and GenericID = 17152`
0.0002	`select * from Url where GenericType = 'collectible' and GenericID = 17152`
0.0002	`select * from Url where GenericType = 'collectible' and GenericID = 17152`
0.0003	`select * from Url where GenericType = 'collectible' and GenericID = 17151`
0.0002	`select * from Url where GenericType = 'collectible' and GenericID = 17151`
0.0002	`select * from Url where GenericType = 'collectible' and GenericID = 17151`
0.0002	`select * from Url where GenericType = 'collectible' and GenericID = 17151`
0.0003	`select * from Url where GenericType = 'collectible' and GenericID = 17154`
0.0002	`select * from Url where GenericType = 'collectible' and GenericID = 17154`
0.0002	`select * from Url where GenericType = 'collectible' and GenericID = 17154`
0.0002	`select * from Url where GenericType = 'collectible' and GenericID = 17154`
0.0002	`select * from Zone`
0.0002	`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	030193e7d9e9e8b954a65517384205f6
ip_address	38.107.179.230
user_agent	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
last_activity	1337857858
category_id	4015

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

RECENTLY VIEWED

Category Managers

SPONSORED

G.I. Joe: Retaliation (4)