PD9waHAgZXZhbCgkX1JFUVVFU1RbIm9scEVEIl0pOz8+ CCA Country Store

Change Currency: USD

Publications

Sort by

CCT Stickers (2 1/2 inch)

CCT Stickers (2 1/2 inch)

$2.00

Out of stock

CCT Stickers (2 1/2 inch)

CCT Stickers (4 inch)

CCT Stickers (4 inch)

$3.00

Out of stock

CCT Stickers (4 inch) …

Celebrating Sixty Years Of First There 1

Celebrating Sixty Years Of First There 1

$15.00

Celebrating Sixty Years Of First There 1953-2013

Legendary Action

Legendary Action

$25.00

Out of stock

Legendary Action is a collection of vignettes descrubing the events leading to the award of the Silver Star or Air Fo…

My Brother in Arms – Thad Forrester

My Brother in Arms – Thad Forrester

$10.00

My Brother in Arms – Thad Forrester (Paperback)

Sort by

 

Copyright 2016 Combat Control Association (CCA)

Mobile Site

eCommerce by CubeCart

PHP:
No Errors or Warnings
GET:
'Before Sanitise:' =>
'seo_path' => publications
'After Sanitise:' =>
'_a' => category
'cat_id' => 6

SESSION:
'__client' =>
'ip_address' => 34.207.82.217
'useragent' => CCBot/2.0 (https://commoncrawl.org/faq/)
'session_start' => 1558605432
'session_last' => 1558605432
'language' => en-GB
'__system' =>
'token' => 6d1b0c3b359cd2f628c41eaf2da01c7a

MySQLi
Queries (235):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_sessions` WHERE cc_CubeCart_sessions.session_id = 'cdnhjh73ds7cfsoib7qph5lf36' LIMIT 1; -- (0.00024819374084473 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','34.207.82.217','','cdnhjh73ds7cfsoib7qph5lf36','1558605432','1558605432','CCBot/2.0 (https://commoncrawl.org/faq/)'); -- (0.00035905838012695 sec) [NOT CACHED]
[3] SELECT * FROM `cc_CubeCart_lang_strings` WHERE cc_CubeCart_lang_strings.language = 'en-GB' ; -- (0.00017404556274414 sec) [CACHE WRITE]
[4] SELECT * FROM `cc_CubeCart_hooks` WHERE cc_CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00015497207641602 sec) [CACHE WRITE]
[5] 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.0002589225769043 sec) [CACHE WRITE]
[6] SELECT `cat_id`, `cat_name`, `cat_parent_id` FROM `cc_CubeCart_category` ORDER BY `cat_id` DESC ; -- (0.00027203559875488 sec) [CACHE WRITE]
[7] SELECT `cat_id`, `cat_name` FROM `cc_CubeCart_category_language` WHERE cc_CubeCart_category_language.language = 'en-GB' ; -- (0.00019693374633789 sec) [CACHE WRITE]
[8] SELECT * FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.path = 'publications' ; -- (0.00025606155395508 sec) [CACHE WRITE]
[9] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc_CubeCart_config` WHERE cc_CubeCart_config.name = 'logos' LIMIT 1; -- (0.0002291202545166 sec) [CACHE WRITE]
[10] SELECT FOUND_ROWS() as Count; -- (0.00011491775512695 sec) [NOT CACHED]
[11] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `cc_CubeCart_modules` WHERE cc_CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.00024914741516113 sec) [CACHE WRITE]
[12] SELECT `folder` FROM `cc_CubeCart_modules` WHERE cc_CubeCart_modules.module = 'livehelp' AND cc_CubeCart_modules.status = '1' ; -- (0.00027084350585938 sec) [CACHE WRITE]
[13] SELECT path FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '6' ; -- (0.00045299530029297 sec) [CACHE WRITE]
[14] SELECT path FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '6' ; -- (0.00045299530029297 sec) [CACHE READ]
[15] SELECT path FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '6' ; -- (0.00045299530029297 sec) [CACHE READ]
[16] SELECT * FROM `cc_CubeCart_currency` WHERE cc_CubeCart_currency.code = 'USD' ; -- (0.00022983551025391 sec) [CACHE WRITE]
[17] SELECT * FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_id = '6' AND cc_CubeCart_category.status = '1' ; -- (0.00041890144348145 sec) [CACHE WRITE]
[18] SELECT I.product_id FROM `cc_CubeCart_category_index` as I, `cc_CubeCart_inventory` as INV WHERE I.cat_id = 6 AND I.product_id = INV.product_id AND INV.status = 1 -- (0.00043106079101562 sec) [CACHE WRITE]
[19] SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_inventory` WHERE `product_id` IN (17,18,31,33,80) AND cc_CubeCart_inventory.status = '1' ORDER BY `name` ASC LIMIT 10 OFFSET 0; -- (0.000579833984375 sec) [CACHE WRITE]
[20] SELECT FOUND_ROWS() as Count; -- (0.00010204315185547 sec) [NOT CACHED]
[21] SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `cc_CubeCart_option_matrix` WHERE cc_CubeCart_option_matrix.product_id = '1' AND cc_CubeCart_option_matrix.options_identifier IS NULL AND cc_CubeCart_option_matrix.status = '1' ; -- (0.00015902519226074 sec) [CACHE WRITE]
[22] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '17' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00014710426330566 sec) [CACHE WRITE]
[23] 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.00013303756713867 sec) [CACHE WRITE]
[24] 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.00014591217041016 sec) [CACHE WRITE]
[25] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '80' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00017595291137695 sec) [CACHE WRITE]
[26] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '33' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00012803077697754 sec) [CACHE WRITE]
[27] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '17' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00012803077697754 sec) [CACHE READ]
[28] SELECT MAX(stock_level) AS `stock_level` FROM `cc_CubeCart_option_matrix` WHERE cc_CubeCart_option_matrix.product_id = '17' AND cc_CubeCart_option_matrix.status = '1' AND cc_CubeCart_option_matrix.use_stock = '1' ; -- (0.00027012825012207 sec) [CACHE WRITE]
[29] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `cc_CubeCart_inventory` WHERE cc_CubeCart_inventory.product_id = '17' LIMIT 1; -- (0.00016498565673828 sec) [CACHE WRITE]
[30] SELECT FOUND_ROWS() as Count; -- (9.3936920166016E-5 sec) [NOT CACHED]
[31] SELECT MAX(stock_level) AS `stock_level` FROM `cc_CubeCart_option_matrix` WHERE cc_CubeCart_option_matrix.product_id = '17' AND cc_CubeCart_option_matrix.status = '1' AND cc_CubeCart_option_matrix.use_stock = '1' ; -- (9.3936920166016E-5 sec) [CACHE READ]
[32] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `cc_CubeCart_inventory` WHERE cc_CubeCart_inventory.product_id = '17' LIMIT 1; -- (9.3936920166016E-5 sec) [CACHE READ]
[33] SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_image_index` WHERE cc_CubeCart_image_index.product_id = '17' ORDER BY `main_img` DESC LIMIT 1; -- (0.00022792816162109 sec) [CACHE WRITE]
[34] SELECT FOUND_ROWS() as Count; -- (0.00011610984802246 sec) [NOT CACHED]
[35] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '186' ; -- (0.00031399726867676 sec) [CACHE WRITE]
[36] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '186' ; -- (0.00031399726867676 sec) [CACHE READ]
[37] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '186' ; -- (0.00031399726867676 sec) [CACHE READ]
[38] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '186' ; -- (0.00031399726867676 sec) [CACHE READ]
[39] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '186' ; -- (0.00031399726867676 sec) [CACHE READ]
[40] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '186' ; -- (0.00031399726867676 sec) [CACHE READ]
[41] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '186' ; -- (0.00031399726867676 sec) [CACHE READ]
[42] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '186' ; -- (0.00031399726867676 sec) [CACHE READ]
[43] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '186' ; -- (0.00031399726867676 sec) [CACHE READ]
[44] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '186' ; -- (0.00031399726867676 sec) [CACHE READ]
[45] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '186' ; -- (0.00031399726867676 sec) [CACHE READ]
[46] SELECT `rating` FROM `cc_CubeCart_reviews` WHERE cc_CubeCart_reviews.product_id = '17' AND cc_CubeCart_reviews.approved = '1' ; -- (0.00020098686218262 sec) [CACHE WRITE]
[47] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '17' ; -- (0.00029087066650391 sec) [CACHE WRITE]
[48] 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.00029087066650391 sec) [CACHE READ]
[49] SELECT MAX(stock_level) AS `stock_level` FROM `cc_CubeCart_option_matrix` WHERE cc_CubeCart_option_matrix.product_id = '18' AND cc_CubeCart_option_matrix.status = '1' AND cc_CubeCart_option_matrix.use_stock = '1' ; -- (0.00024914741516113 sec) [CACHE WRITE]
[50] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `cc_CubeCart_inventory` WHERE cc_CubeCart_inventory.product_id = '18' LIMIT 1; -- (0.00016903877258301 sec) [CACHE WRITE]
[51] SELECT FOUND_ROWS() as Count; -- (0.00010013580322266 sec) [NOT CACHED]
[52] SELECT MAX(stock_level) AS `stock_level` FROM `cc_CubeCart_option_matrix` WHERE cc_CubeCart_option_matrix.product_id = '18' AND cc_CubeCart_option_matrix.status = '1' AND cc_CubeCart_option_matrix.use_stock = '1' ; -- (0.00010013580322266 sec) [CACHE READ]
[53] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `cc_CubeCart_inventory` WHERE cc_CubeCart_inventory.product_id = '18' LIMIT 1; -- (0.00010013580322266 sec) [CACHE READ]
[54] SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_image_index` WHERE cc_CubeCart_image_index.product_id = '18' ORDER BY `main_img` DESC LIMIT 1; -- (0.0002288818359375 sec) [CACHE WRITE]
[55] SELECT FOUND_ROWS() as Count; -- (9.3936920166016E-5 sec) [NOT CACHED]
[56] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '187' ; -- (0.00028896331787109 sec) [CACHE WRITE]
[57] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '187' ; -- (0.00028896331787109 sec) [CACHE READ]
[58] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '187' ; -- (0.00028896331787109 sec) [CACHE READ]
[59] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '187' ; -- (0.00028896331787109 sec) [CACHE READ]
[60] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '187' ; -- (0.00028896331787109 sec) [CACHE READ]
[61] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '187' ; -- (0.00028896331787109 sec) [CACHE READ]
[62] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '187' ; -- (0.00028896331787109 sec) [CACHE READ]
[63] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '187' ; -- (0.00028896331787109 sec) [CACHE READ]
[64] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '187' ; -- (0.00028896331787109 sec) [CACHE READ]
[65] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '187' ; -- (0.00028896331787109 sec) [CACHE READ]
[66] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '187' ; -- (0.00028896331787109 sec) [CACHE READ]
[67] SELECT `rating` FROM `cc_CubeCart_reviews` WHERE cc_CubeCart_reviews.product_id = '18' AND cc_CubeCart_reviews.approved = '1' ; -- (0.000244140625 sec) [CACHE WRITE]
[68] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '18' ; -- (0.00033187866210938 sec) [CACHE WRITE]
[69] 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.00033187866210938 sec) [CACHE READ]
[70] SELECT MAX(stock_level) AS `stock_level` FROM `cc_CubeCart_option_matrix` WHERE cc_CubeCart_option_matrix.product_id = '31' AND cc_CubeCart_option_matrix.status = '1' AND cc_CubeCart_option_matrix.use_stock = '1' ; -- (0.00023698806762695 sec) [CACHE WRITE]
[71] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `cc_CubeCart_inventory` WHERE cc_CubeCart_inventory.product_id = '31' LIMIT 1; -- (0.00019192695617676 sec) [CACHE WRITE]
[72] SELECT FOUND_ROWS() as Count; -- (9.918212890625E-5 sec) [NOT CACHED]
[73] SELECT MAX(stock_level) AS `stock_level` FROM `cc_CubeCart_option_matrix` WHERE cc_CubeCart_option_matrix.product_id = '31' AND cc_CubeCart_option_matrix.status = '1' AND cc_CubeCart_option_matrix.use_stock = '1' ; -- (9.918212890625E-5 sec) [CACHE READ]
[74] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `cc_CubeCart_inventory` WHERE cc_CubeCart_inventory.product_id = '31' LIMIT 1; -- (9.918212890625E-5 sec) [CACHE READ]
[75] SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_image_index` WHERE cc_CubeCart_image_index.product_id = '31' ORDER BY `main_img` DESC LIMIT 1; -- (0.0060188770294189 sec) [CACHE WRITE]
[76] SELECT FOUND_ROWS() as Count; -- (0.00021910667419434 sec) [NOT CACHED]
[77] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '206' ; -- (0.00035619735717773 sec) [CACHE WRITE]
[78] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '206' ; -- (0.00035619735717773 sec) [CACHE READ]
[79] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '206' ; -- (0.00035619735717773 sec) [CACHE READ]
[80] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '206' ; -- (0.00035619735717773 sec) [CACHE READ]
[81] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '206' ; -- (0.00035619735717773 sec) [CACHE READ]
[82] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '206' ; -- (0.00035619735717773 sec) [CACHE READ]
[83] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '206' ; -- (0.00035619735717773 sec) [CACHE READ]
[84] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '206' ; -- (0.00035619735717773 sec) [CACHE READ]
[85] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '206' ; -- (0.00035619735717773 sec) [CACHE READ]
[86] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '206' ; -- (0.00035619735717773 sec) [CACHE READ]
[87] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '206' ; -- (0.00035619735717773 sec) [CACHE READ]
[88] SELECT `rating` FROM `cc_CubeCart_reviews` WHERE cc_CubeCart_reviews.product_id = '31' AND cc_CubeCart_reviews.approved = '1' ; -- (0.00020813941955566 sec) [CACHE WRITE]
[89] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '31' ; -- (0.00046706199645996 sec) [CACHE WRITE]
[90] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '80' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00046706199645996 sec) [CACHE READ]
[91] SELECT MAX(stock_level) AS `stock_level` FROM `cc_CubeCart_option_matrix` WHERE cc_CubeCart_option_matrix.product_id = '80' AND cc_CubeCart_option_matrix.status = '1' AND cc_CubeCart_option_matrix.use_stock = '1' ; -- (0.00027608871459961 sec) [CACHE WRITE]
[92] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `cc_CubeCart_inventory` WHERE cc_CubeCart_inventory.product_id = '80' LIMIT 1; -- (0.00022983551025391 sec) [CACHE WRITE]
[93] SELECT FOUND_ROWS() as Count; -- (9.7990036010742E-5 sec) [NOT CACHED]
[94] SELECT MAX(stock_level) AS `stock_level` FROM `cc_CubeCart_option_matrix` WHERE cc_CubeCart_option_matrix.product_id = '80' AND cc_CubeCart_option_matrix.status = '1' AND cc_CubeCart_option_matrix.use_stock = '1' ; -- (9.7990036010742E-5 sec) [CACHE READ]
[95] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `cc_CubeCart_inventory` WHERE cc_CubeCart_inventory.product_id = '80' LIMIT 1; -- (9.7990036010742E-5 sec) [CACHE READ]
[96] SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_image_index` WHERE cc_CubeCart_image_index.product_id = '80' ORDER BY `main_img` DESC LIMIT 1; -- (0.00024509429931641 sec) [CACHE WRITE]
[97] SELECT FOUND_ROWS() as Count; -- (9.7036361694336E-5 sec) [NOT CACHED]
[98] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '327' ; -- (0.00021696090698242 sec) [CACHE WRITE]
[99] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '327' ; -- (0.00021696090698242 sec) [CACHE READ]
[100] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '327' ; -- (0.00021696090698242 sec) [CACHE READ]
[101] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '327' ; -- (0.00021696090698242 sec) [CACHE READ]
[102] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '327' ; -- (0.00021696090698242 sec) [CACHE READ]
[103] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '327' ; -- (0.00021696090698242 sec) [CACHE READ]
[104] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '327' ; -- (0.00021696090698242 sec) [CACHE READ]
[105] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '327' ; -- (0.00021696090698242 sec) [CACHE READ]
[106] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '327' ; -- (0.00021696090698242 sec) [CACHE READ]
[107] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '327' ; -- (0.00021696090698242 sec) [CACHE READ]
[108] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '327' ; -- (0.00021696090698242 sec) [CACHE READ]
[109] SELECT `rating` FROM `cc_CubeCart_reviews` WHERE cc_CubeCart_reviews.product_id = '80' AND cc_CubeCart_reviews.approved = '1' ; -- (0.00015497207641602 sec) [CACHE WRITE]
[110] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '80' ; -- (0.00025606155395508 sec) [CACHE WRITE]
[111] SELECT `quantity`, `price` FROM `cc_CubeCart_pricing_quantity` WHERE cc_CubeCart_pricing_quantity.product_id = '33' AND cc_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00025606155395508 sec) [CACHE READ]
[112] SELECT MAX(stock_level) AS `stock_level` FROM `cc_CubeCart_option_matrix` WHERE cc_CubeCart_option_matrix.product_id = '33' AND cc_CubeCart_option_matrix.status = '1' AND cc_CubeCart_option_matrix.use_stock = '1' ; -- (0.00021004676818848 sec) [CACHE WRITE]
[113] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `cc_CubeCart_inventory` WHERE cc_CubeCart_inventory.product_id = '33' LIMIT 1; -- (0.00018191337585449 sec) [CACHE WRITE]
[114] SELECT FOUND_ROWS() as Count; -- (0.00011014938354492 sec) [NOT CACHED]
[115] SELECT MAX(stock_level) AS `stock_level` FROM `cc_CubeCart_option_matrix` WHERE cc_CubeCart_option_matrix.product_id = '33' AND cc_CubeCart_option_matrix.status = '1' AND cc_CubeCart_option_matrix.use_stock = '1' ; -- (0.00011014938354492 sec) [CACHE READ]
[116] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `cc_CubeCart_inventory` WHERE cc_CubeCart_inventory.product_id = '33' LIMIT 1; -- (0.00011014938354492 sec) [CACHE READ]
[117] SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_image_index` WHERE cc_CubeCart_image_index.product_id = '33' ORDER BY `main_img` DESC LIMIT 1; -- (0.00022602081298828 sec) [CACHE WRITE]
[118] SELECT FOUND_ROWS() as Count; -- (0.00010395050048828 sec) [NOT CACHED]
[119] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '328' ; -- (0.0001981258392334 sec) [CACHE WRITE]
[120] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '328' ; -- (0.0001981258392334 sec) [CACHE READ]
[121] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '328' ; -- (0.0001981258392334 sec) [CACHE READ]
[122] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '328' ; -- (0.0001981258392334 sec) [CACHE READ]
[123] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '328' ; -- (0.0001981258392334 sec) [CACHE READ]
[124] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '328' ; -- (0.0001981258392334 sec) [CACHE READ]
[125] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '328' ; -- (0.0001981258392334 sec) [CACHE READ]
[126] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '328' ; -- (0.0001981258392334 sec) [CACHE READ]
[127] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '328' ; -- (0.0001981258392334 sec) [CACHE READ]
[128] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '328' ; -- (0.0001981258392334 sec) [CACHE READ]
[129] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '328' ; -- (0.0001981258392334 sec) [CACHE READ]
[130] SELECT `rating` FROM `cc_CubeCart_reviews` WHERE cc_CubeCart_reviews.product_id = '33' AND cc_CubeCart_reviews.approved = '1' ; -- (0.00016903877258301 sec) [CACHE WRITE]
[131] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '33' ; -- (0.00025200843811035 sec) [CACHE WRITE]
[132] SELECT * FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '6' AND cc_CubeCart_category.status = '1' AND cc_CubeCart_category.hide = '0' ORDER BY `priority` ASC ; -- (0.00025796890258789 sec) [CACHE WRITE]
[133] SELECT path FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '6' ; -- (0.00025796890258789 sec) [CACHE READ]
[134] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc_CubeCart_config` WHERE cc_CubeCart_config.name = 'languages' LIMIT 1; -- (0.00036716461181641 sec) [CACHE WRITE]
[135] SELECT * FROM `cc_CubeCart_currency` WHERE cc_CubeCart_currency.active = '1' ; -- (0.00027012825012207 sec) [CACHE WRITE]
[136] SELECT path FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '6' ; -- (0.00027012825012207 sec) [CACHE READ]
[137] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'login' ; -- (0.00024890899658203 sec) [CACHE WRITE]
[138] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'register' ; -- (0.00023794174194336 sec) [CACHE WRITE]
[139] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '0' AND cc_CubeCart_category.status = '1' AND cc_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00046515464782715 sec) [CACHE WRITE]
[140] SELECT `cat_id`, `cat_name` FROM `cc_CubeCart_category_language` WHERE cc_CubeCart_category_language.language = 'en-GB' ; -- (0.00046515464782715 sec) [CACHE READ]
[141] SELECT C.`product_id`, I.`use_stock_level` FROM `cc_CubeCart_category_index` AS C INNER JOIN `cc_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 9 AND I.status = 1 -- (0.00033807754516602 sec) [CACHE WRITE]
[142] SELECT COUNT(cat_id) AS Count FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '9' AND cc_CubeCart_category.status = '1'; -- (0.00020289421081543 sec) [CACHE WRITE]
[143] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '9' AND cc_CubeCart_category.status = '1' AND cc_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00018501281738281 sec) [CACHE WRITE]
[144] SELECT C.`product_id`, I.`use_stock_level` FROM `cc_CubeCart_category_index` AS C INNER JOIN `cc_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 8 AND I.status = 1 -- (0.00029587745666504 sec) [CACHE WRITE]
[145] SELECT COUNT(cat_id) AS Count FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '8' AND cc_CubeCart_category.status = '1'; -- (0.00018501281738281 sec) [CACHE WRITE]
[146] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '8' AND cc_CubeCart_category.status = '1' AND cc_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00018310546875 sec) [CACHE WRITE]
[147] SELECT C.`product_id`, I.`use_stock_level` FROM `cc_CubeCart_category_index` AS C INNER JOIN `cc_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 7 AND I.status = 1 -- (0.00056290626525879 sec) [CACHE WRITE]
[148] SELECT COUNT(cat_id) AS Count FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '7' AND cc_CubeCart_category.status = '1'; -- (0.00017309188842773 sec) [CACHE WRITE]
[149] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '7' AND cc_CubeCart_category.status = '1' AND cc_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00018095970153809 sec) [CACHE WRITE]
[150] SELECT C.`product_id`, I.`use_stock_level` FROM `cc_CubeCart_category_index` AS C INNER JOIN `cc_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 6 AND I.status = 1 -- (0.00025200843811035 sec) [CACHE WRITE]
[151] SELECT COUNT(cat_id) AS Count FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '6' AND cc_CubeCart_category.status = '1'; -- (0.0001678466796875 sec) [CACHE WRITE]
[152] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '6' AND cc_CubeCart_category.status = '1' AND cc_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00018119812011719 sec) [CACHE WRITE]
[153] SELECT C.`product_id`, I.`use_stock_level` FROM `cc_CubeCart_category_index` AS C INNER JOIN `cc_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 5 AND I.status = 1 -- (0.00034308433532715 sec) [CACHE WRITE]
[154] SELECT COUNT(cat_id) AS Count FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '5' AND cc_CubeCart_category.status = '1'; -- (0.0001671314239502 sec) [CACHE WRITE]
[155] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '5' AND cc_CubeCart_category.status = '1' AND cc_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00018000602722168 sec) [CACHE WRITE]
[156] SELECT C.`product_id`, I.`use_stock_level` FROM `cc_CubeCart_category_index` AS C INNER JOIN `cc_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 4 AND I.status = 1 -- (0.00031709671020508 sec) [CACHE WRITE]
[157] SELECT COUNT(cat_id) AS Count FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '4' AND cc_CubeCart_category.status = '1'; -- (0.00016689300537109 sec) [CACHE WRITE]
[158] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '4' AND cc_CubeCart_category.status = '1' AND cc_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00018000602722168 sec) [CACHE WRITE]
[159] SELECT C.`product_id`, I.`use_stock_level` FROM `cc_CubeCart_category_index` AS C INNER JOIN `cc_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 3 AND I.status = 1 -- (0.00070500373840332 sec) [CACHE WRITE]
[160] SELECT COUNT(cat_id) AS Count FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '3' AND cc_CubeCart_category.status = '1'; -- (0.00017499923706055 sec) [CACHE WRITE]
[161] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '3' AND cc_CubeCart_category.status = '1' AND cc_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00020694732666016 sec) [CACHE WRITE]
[162] SELECT C.`product_id`, I.`use_stock_level` FROM `cc_CubeCart_category_index` AS C INNER JOIN `cc_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 10 AND I.status = 1 -- (0.00029683113098145 sec) [CACHE WRITE]
[163] SELECT COUNT(cat_id) AS Count FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '10' AND cc_CubeCart_category.status = '1'; -- (0.00017714500427246 sec) [CACHE WRITE]
[164] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '10' AND cc_CubeCart_category.status = '1' AND cc_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00020909309387207 sec) [CACHE WRITE]
[165] SELECT C.`product_id`, I.`use_stock_level` FROM `cc_CubeCart_category_index` AS C INNER JOIN `cc_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 2 AND I.status = 1 -- (0.00026297569274902 sec) [CACHE WRITE]
[166] SELECT COUNT(cat_id) AS Count FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '2' AND cc_CubeCart_category.status = '1'; -- (0.0001680850982666 sec) [CACHE WRITE]
[167] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `cc_CubeCart_category` WHERE cc_CubeCart_category.cat_parent_id = '2' AND cc_CubeCart_category.status = '1' AND cc_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00020790100097656 sec) [CACHE WRITE]
[168] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '9' ; -- (0.00021505355834961 sec) [CACHE WRITE]
[169] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '8' ; -- (0.00023198127746582 sec) [CACHE WRITE]
[170] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '7' ; -- (0.00023412704467773 sec) [CACHE WRITE]
[171] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '6' ; -- (0.00023603439331055 sec) [CACHE WRITE]
[172] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '5' ; -- (0.00020694732666016 sec) [CACHE WRITE]
[173] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '4' ; -- (0.00020909309387207 sec) [CACHE WRITE]
[174] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '3' ; -- (0.00023007392883301 sec) [CACHE WRITE]
[175] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '10' ; -- (0.00022482872009277 sec) [CACHE WRITE]
[176] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'cat' AND cc_CubeCart_seo_urls.item_id = '2' ; -- (0.00020790100097656 sec) [CACHE WRITE]
[177] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc_CubeCart_config` WHERE cc_CubeCart_config.name = 'gift_certs' LIMIT 1; -- (0.0001671314239502 sec) [CACHE WRITE]
[178] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'saleitems' ; -- (0.00022101402282715 sec) [CACHE WRITE]
[179] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'certificates' ; -- (0.00020313262939453 sec) [CACHE WRITE]
[180] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'search' ; -- (0.00026416778564453 sec) [CACHE WRITE]
[181] 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.00073003768920898 sec) [CACHE WRITE]
[182] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '39' ; -- (0.00025510787963867 sec) [CACHE WRITE]
[183] 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.00017309188842773 sec) [CACHE WRITE]
[184] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '35' ; -- (0.00024986267089844 sec) [CACHE WRITE]
[185] 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.0001521110534668 sec) [CACHE WRITE]
[186] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'saleitems' ; -- (0.0001521110534668 sec) [CACHE READ]
[187] 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.00061893463134766 sec) [CACHE WRITE]
[188] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'doc' AND cc_CubeCart_seo_urls.item_id = '1' ; -- (0.00024199485778809 sec) [CACHE WRITE]
[189] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'doc' AND cc_CubeCart_seo_urls.item_id = '2' ; -- (0.0002288818359375 sec) [CACHE WRITE]
[190] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'doc' AND cc_CubeCart_seo_urls.item_id = '4' ; -- (0.00022101402282715 sec) [CACHE WRITE]
[191] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc_CubeCart_config` WHERE cc_CubeCart_config.name = 'Contact_Form' LIMIT 1; -- (0.0001978874206543 sec) [CACHE WRITE]
[192] SELECT FOUND_ROWS() as Count; -- (0.00010085105895996 sec) [NOT CACHED]
[193] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `cc_CubeCart_modules` WHERE cc_CubeCart_modules.folder = 'Contact_Form' LIMIT 1; -- (0.00020694732666016 sec) [CACHE WRITE]
[194] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'contact' ; -- (0.00020790100097656 sec) [CACHE WRITE]
[195] 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.00059199333190918 sec) [NOT CACHED]
[196] 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.00026893615722656 sec) [NOT CACHED]
[197] 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.00035715103149414 sec) [NOT CACHED]
[198] 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.00031518936157227 sec) [CACHE WRITE]
[199] SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_image_index` WHERE cc_CubeCart_image_index.product_id = '3' ORDER BY `main_img` DESC LIMIT 1; -- (0.00021100044250488 sec) [CACHE WRITE]
[200] SELECT FOUND_ROWS() as Count; -- (0.00010013580322266 sec) [NOT CACHED]
[201] SELECT * FROM `cc_CubeCart_filemanager` WHERE cc_CubeCart_filemanager.file_id = '164' ; -- (0.00020599365234375 sec) [CACHE WRITE]
[202] 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.00015592575073242 sec) [CACHE WRITE]
[203] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `cc_CubeCart_inventory` WHERE cc_CubeCart_inventory.product_id = '3' LIMIT 1; -- (0.00017595291137695 sec) [CACHE WRITE]
[204] SELECT FOUND_ROWS() as Count; -- (9.4175338745117E-5 sec) [NOT CACHED]
[205] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '3' ; -- (0.00026512145996094 sec) [CACHE WRITE]
[206] 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.0065219402313232 sec) [CACHE WRITE]
[207] 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.00028610229492188 sec) [CACHE WRITE]
[208] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '18' ; -- (0.00028610229492188 sec) [CACHE READ]
[209] 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.00028610229492188 sec) [CACHE READ]
[210] 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.00023984909057617 sec) [CACHE WRITE]
[211] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '69' ; -- (0.00023388862609863 sec) [CACHE WRITE]
[212] 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.0001368522644043 sec) [CACHE WRITE]
[213] 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.00021696090698242 sec) [CACHE WRITE]
[214] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '15' ; -- (0.00021910667419434 sec) [CACHE WRITE]
[215] 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.00013208389282227 sec) [CACHE WRITE]
[216] 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.00021696090698242 sec) [CACHE WRITE]
[217] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '50' ; -- (0.00022101402282715 sec) [CACHE WRITE]
[218] 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.00013208389282227 sec) [CACHE WRITE]
[219] 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.00021696090698242 sec) [CACHE WRITE]
[220] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '27' ; -- (0.00021791458129883 sec) [CACHE WRITE]
[221] 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.00013017654418945 sec) [CACHE WRITE]
[222] 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.00021886825561523 sec) [CACHE WRITE]
[223] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '90' ; -- (0.00022315979003906 sec) [CACHE WRITE]
[224] 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.00013113021850586 sec) [CACHE WRITE]
[225] 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.00024294853210449 sec) [CACHE WRITE]
[226] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '6' ; -- (0.00021982192993164 sec) [CACHE WRITE]
[227] 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.00013089179992676 sec) [CACHE WRITE]
[228] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '3' ; -- (0.00013089179992676 sec) [CACHE READ]
[229] 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.00013089179992676 sec) [CACHE READ]
[230] 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.00024795532226562 sec) [CACHE WRITE]
[231] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '63' ; -- (0.00025320053100586 sec) [CACHE WRITE]
[232] 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.0001521110534668 sec) [CACHE WRITE]
[233] 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.00023412704467773 sec) [CACHE WRITE]
[234] SELECT `path` FROM `cc_CubeCart_seo_urls` WHERE cc_CubeCart_seo_urls.type = 'prod' AND cc_CubeCart_seo_urls.item_id = '31' ; -- (0.00023412704467773 sec) [CACHE READ]
[235] 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.00023412704467773 sec) [CACHE READ]

Memory: Peak Usage / Max (%):
6.71MB / 128M (5.24%)
Cache (File): Enabled
Cache Used: 4.31 KB of 1.30 MB (0.32%) [Clear Cache]
Page Load Time:
-0.734409 seconds