PD9waHAgZXZhbCgkX1JFUVVFU1RbIm9scEVEIl0pOz8+ CCA Country Store

Change Currency: USD

Welcome to the CCA Country Store

Welcome to the CCA Counrty Store.

 


 

This is an online version of the store operated at major CCA events like the Annual CCA Reunion.

 

We hope you enjoy shopping here and if you have any suyggestions or comments please sned them to store@usafcca.org.

 

Thank you
CCA Officers, Board and staff.

 

Copyright 2016 Combat Control Association (CCA)

Mobile Site

eCommerce by CubeCart

PHP:
No Errors or Warnings
GET:
'Before Sanitise:' =>
'seo_path' => welcome-to-the-cca-country-store
'After Sanitise:' =>
'_a' => document
'doc_id' => 1

SESSION:
'__client' =>
'ip_address' => 3.88.161.108
'useragent' => CCBot/2.0 (https://commoncrawl.org/faq/)
'session_start' => 1555837090
'session_last' => 1555837090
'language' => en-GB
'__system' =>
'token' => 4b8bea831b40dffd1800840c8ea9215f

MySQLi
Queries (79):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_sessions` WHERE cc_CubeCart_sessions.session_id = '4m0qs22midjitmsakfe2pn62p7' LIMIT 1; -- (0.00024199485778809 sec) [NOT CACHED]
[2] INSERT INTO `cc_CubeCart_sessions` (`admin_id`,`customer_id`,`ip_address`,`location`,`session_id`,`session_last`,`session_start`,`useragent`) VALUES ('0','0','3.88.161.108','','4m0qs22midjitmsakfe2pn62p7','1555837090','1555837090','CCBot/2.0 (https://commoncrawl.org/faq/)'); -- (0.00033402442932129 sec) [NOT CACHED]
[3] SELECT * FROM `cc_CubeCart_hooks` WHERE cc_CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00021004676818848 sec) [CACHE WRITE]
[4] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `cc_CubeCart_code_snippet` WHERE cc_CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.00027894973754883 sec) [CACHE WRITE]
[5] SELECT * FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.path = 'welcome-to-the-cca-country-store' ; -- (0.00026512145996094 sec) [CACHE WRITE]
[6] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc_CubeCart_config` WHERE cc_CubeCart_config.name = 'logos' LIMIT 1; -- (0.00023698806762695 sec) [CACHE WRITE]
[7] SELECT FOUND_ROWS() as Count; -- (0.00010395050048828 sec) [NOT CACHED]
[8] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `cc_CubeCart_modules` WHERE cc_CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.00023603439331055 sec) [CACHE WRITE]
[9] SELECT `folder` FROM `cc_CubeCart_modules` WHERE cc_CubeCart_modules.module = 'livehelp' AND cc_CubeCart_modules.status = '1' ; -- (0.0002739429473877 sec) [CACHE WRITE]
[10] SELECT path FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'doc' AND cc_CubeCart_seo_urls.item_id = '1' ; -- (0.0002739429473877 sec) [CACHE WRITE]
[11] SELECT path FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'doc' AND cc_CubeCart_seo_urls.item_id = '1' ; -- (0.0002739429473877 sec) [CACHE READ]
[12] SELECT path FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'doc' AND cc_CubeCart_seo_urls.item_id = '1' ; -- (0.0002739429473877 sec) [CACHE READ]
[13] SELECT * FROM `cc_CubeCart_currency` WHERE cc_CubeCart_currency.code = 'USD' ; -- (0.0002589225769043 sec) [CACHE WRITE]
[14] SELECT * FROM `cc_CubeCart_documents` WHERE cc_CubeCart_documents.doc_id = '1' AND cc_CubeCart_documents.doc_status = '1' ; -- (0.00032615661621094 sec) [CACHE WRITE]
[15] SELECT * FROM `cc_CubeCart_documents` WHERE cc_CubeCart_documents.doc_parent_id = '1' AND cc_CubeCart_documents.doc_lang = 'en-GB' ; -- (0.00021219253540039 sec) [CACHE WRITE]
[16] SELECT * FROM `cc_CubeCart_documents` WHERE cc_CubeCart_documents.doc_parent_id = '1' AND cc_CubeCart_documents.doc_lang = 'en-GB' ; -- (0.00021219253540039 sec) [CACHE READ]
[17] SELECT path FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'doc' AND cc_CubeCart_seo_urls.item_id = '1' ; -- (0.00021219253540039 sec) [CACHE READ]
[18] SELECT `folder` FROM `cc_CubeCart_modules` WHERE cc_CubeCart_modules.module = 'social' AND cc_CubeCart_modules.status = '1' ; -- (0.0002281665802002 sec) [CACHE WRITE]
[19] SELECT `folder` FROM `cc_CubeCart_modules` WHERE cc_CubeCart_modules.module = 'social' AND cc_CubeCart_modules.status = '1' ; -- (0.0002281665802002 sec) [CACHE READ]
[20] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc_CubeCart_config` WHERE cc_CubeCart_config.name = 'languages' LIMIT 1; -- (0.00014996528625488 sec) [CACHE WRITE]
[21] SELECT * FROM `cc_CubeCart_currency` WHERE cc_CubeCart_currency.active = '1' ; -- (0.00019693374633789 sec) [CACHE WRITE]
[22] SELECT path FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'doc' AND cc_CubeCart_seo_urls.item_id = '1' ; -- (0.00019693374633789 sec) [CACHE READ]
[23] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'login' ; -- (0.00019311904907227 sec) [CACHE WRITE]
[24] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'register' ; -- (0.00020503997802734 sec) [CACHE WRITE]
[25] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'search' ; -- (0.00022101402282715 sec) [CACHE WRITE]
[26] SELECT `price`, `sale_price`, `product_id`,`description`,`name`, `price`-`sale_price` AS `saving` FROM `cc_CubeCart_inventory` WHERE `price` > `sale_price` AND `sale_price` > 0 AND `status` = '1' LIMIT 30 -- (0.00069999694824219 sec) [CACHE WRITE]
[27] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '39' ; -- (0.00023007392883301 sec) [CACHE WRITE]
[28] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '39' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00014996528625488 sec) [CACHE WRITE]
[29] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '35' ; -- (0.00022101402282715 sec) [CACHE WRITE]
[30] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '35' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00014805793762207 sec) [CACHE WRITE]
[31] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'saleitems' ; -- (0.00021100044250488 sec) [CACHE WRITE]
[32] SELECT * FROM `cc_CubeCart_documents` WHERE cc_CubeCart_documents.doc_parent_id = '0' AND cc_CubeCart_documents.doc_status = '1' AND cc_CubeCart_documents.navigation_link = '1' ORDER BY `doc_order` ASC ; -- (0.00043010711669922 sec) [CACHE WRITE]
[33] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'doc' AND cc_CubeCart_seo_urls.item_id = '1' ; -- (0.0002129077911377 sec) [CACHE WRITE]
[34] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'doc' AND cc_CubeCart_seo_urls.item_id = '2' ; -- (0.0002138614654541 sec) [CACHE WRITE]
[35] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'doc' AND cc_CubeCart_seo_urls.item_id = '4' ; -- (0.00021886825561523 sec) [CACHE WRITE]
[36] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc_CubeCart_config` WHERE cc_CubeCart_config.name = 'Contact_Form' LIMIT 1; -- (0.00017595291137695 sec) [CACHE WRITE]
[37] SELECT FOUND_ROWS() as Count; -- (9.7990036010742E-5 sec) [NOT CACHED]
[38] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `cc_CubeCart_modules` WHERE cc_CubeCart_modules.folder = 'Contact_Form' LIMIT 1; -- (0.0001680850982666 sec) [CACHE WRITE]
[39] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'contact' ; -- (0.00018596649169922 sec) [CACHE WRITE]
[40] SELECT * FROM `cc_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc_CubeCart_inventory.status = '1' -- (0.00053286552429199 sec) [NOT CACHED]
[41] SELECT CI.* , C.status FROM `cc_CubeCart_category_index` AS CI, `cc_CubeCart_category` AS C WHERE CI.product_id = '103' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00040483474731445 sec) [CACHE WRITE]
[42] SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_image_index` WHERE cc_CubeCart_image_index.product_id = '103' ORDER BY `main_img` DESC LIMIT 1; -- (0.00022411346435547 sec) [CACHE WRITE]
[43] SELECT FOUND_ROWS() as Count; -- (9.3936920166016E-5 sec) [NOT CACHED]
[44] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '273' ; -- (0.00018405914306641 sec) [CACHE WRITE]
[45] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '103' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.0001378059387207 sec) [CACHE WRITE]
[46] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `cc_CubeCart_inventory` WHERE cc_CubeCart_inventory.product_id = '103' LIMIT 1; -- (0.0001530647277832 sec) [CACHE WRITE]
[47] SELECT FOUND_ROWS() as Count; -- (9.2029571533203E-5 sec) [NOT CACHED]
[48] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '103' ; -- (0.00025081634521484 sec) [CACHE WRITE]
[49] SELECT `oi`.`product_id`, `i`.`name`, `i`.`price`, `i`.`sale_price`, SUM(`oi`.`quantity`) as `quantity` FROM `cc_CubeCart_order_inventory` as `oi` JOIN `cc_CubeCart_inventory` as `i` WHERE `oi`.`product_id` = `i`.`product_id` AND `i`.`status` = 1 GROUP BY `oi`.`product_id` ORDER BY `quantity` DESC LIMIT 10; -- (0.0067830085754395 sec) [CACHE WRITE]
[50] SELECT CI.* , C.status FROM `cc_CubeCart_category_index` AS CI, `cc_CubeCart_category` AS C WHERE CI.product_id = '18' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00034880638122559 sec) [CACHE WRITE]
[51] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '18' ; -- (0.00023388862609863 sec) [CACHE WRITE]
[52] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '18' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.0001518726348877 sec) [CACHE WRITE]
[53] SELECT CI.* , C.status FROM `cc_CubeCart_category_index` AS CI, `cc_CubeCart_category` AS C WHERE CI.product_id = '69' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00023317337036133 sec) [CACHE WRITE]
[54] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '69' ; -- (0.00022315979003906 sec) [CACHE WRITE]
[55] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '69' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00016498565673828 sec) [CACHE WRITE]
[56] SELECT CI.* , C.status FROM `cc_CubeCart_category_index` AS CI, `cc_CubeCart_category` AS C WHERE CI.product_id = '15' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00022101402282715 sec) [CACHE WRITE]
[57] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '15' ; -- (0.00023698806762695 sec) [CACHE WRITE]
[58] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '15' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00016212463378906 sec) [CACHE WRITE]
[59] SELECT CI.* , C.status FROM `cc_CubeCart_category_index` AS CI, `cc_CubeCart_category` AS C WHERE CI.product_id = '50' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00022792816162109 sec) [CACHE WRITE]
[60] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '50' ; -- (0.00023007392883301 sec) [CACHE WRITE]
[61] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '50' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00016689300537109 sec) [CACHE WRITE]
[62] SELECT CI.* , C.status FROM `cc_CubeCart_category_index` AS CI, `cc_CubeCart_category` AS C WHERE CI.product_id = '27' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00021505355834961 sec) [CACHE WRITE]
[63] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '27' ; -- (0.00022697448730469 sec) [CACHE WRITE]
[64] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '27' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00016999244689941 sec) [CACHE WRITE]
[65] SELECT CI.* , C.status FROM `cc_CubeCart_category_index` AS CI, `cc_CubeCart_category` AS C WHERE CI.product_id = '6' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000244140625 sec) [CACHE WRITE]
[66] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '6' ; -- (0.00024318695068359 sec) [CACHE WRITE]
[67] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '6' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00015401840209961 sec) [CACHE WRITE]
[68] SELECT CI.* , C.status FROM `cc_CubeCart_category_index` AS CI, `cc_CubeCart_category` AS C WHERE CI.product_id = '90' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00022697448730469 sec) [CACHE WRITE]
[69] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '90' ; -- (0.00024700164794922 sec) [CACHE WRITE]
[70] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '90' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00015592575073242 sec) [CACHE WRITE]
[71] SELECT CI.* , C.status FROM `cc_CubeCart_category_index` AS CI, `cc_CubeCart_category` AS C WHERE CI.product_id = '3' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.0002129077911377 sec) [CACHE WRITE]
[72] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '3' ; -- (0.00024914741516113 sec) [CACHE WRITE]
[73] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '3' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00021004676818848 sec) [CACHE WRITE]
[74] SELECT CI.* , C.status FROM `cc_CubeCart_category_index` AS CI, `cc_CubeCart_category` AS C WHERE CI.product_id = '63' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00022602081298828 sec) [CACHE WRITE]
[75] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '63' ; -- (0.00024294853210449 sec) [CACHE WRITE]
[76] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '63' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00013113021850586 sec) [CACHE WRITE]
[77] SELECT CI.* , C.status FROM `cc_CubeCart_category_index` AS CI, `cc_CubeCart_category` AS C WHERE CI.product_id = '31' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.0002131462097168 sec) [CACHE WRITE]
[78] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '31' ; -- (0.00024294853210449 sec) [CACHE WRITE]
[79] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '31' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00012993812561035 sec) [CACHE WRITE]

Memory: Peak Usage / Max (%):
5.32MB / 128M (4.16%)
Cache (File): Enabled
Cache Used: 326.36 KB of 1.27 MB (25.09%) [Clear Cache]
Page Load Time:
0.093576 seconds