MySQLi
Queries (119):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_sessions` WHERE CubeCart_sessions.session_id = 'vnbkus6s02u1fal7jv2r71r301' LIMIT 1; -- (0.00024890899658203 sec) [NOT CACHED]
[2] SELECT FOUND_ROWS() as Count; -- (0.00014591217041016 sec) [NOT CACHED]
[3] SELECT * FROM `CubeCart_lang_strings` WHERE CubeCart_lang_strings.language = 'en-US' ; -- (0.00019621849060059 sec) [CACHE WRITE]
[4] SELECT * FROM `CubeCart_hooks` WHERE CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00028800964355469 sec) [CACHE WRITE]
[5] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `CubeCart_code_snippet` WHERE CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.00018095970153809 sec) [CACHE WRITE]
[6] SELECT C.cat_id, C.cat_name, C.cat_parent_id, S.path FROM `CubeCart_category` as C LEFT JOIN `CubeCart_seo_urls` as S ON S.item_id=C.cat_id AND S.type='cat' AND S.custom='1' ORDER BY C.cat_id DESC -- (0.00042510032653809 sec) [CACHE WRITE]
[7] SELECT `cat_id`, `cat_name` FROM `CubeCart_category_language` WHERE CubeCart_category_language.language = 'en-US' ; -- (0.00016903877258301 sec) [CACHE WRITE]
[8] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'logos' LIMIT 1; -- (0.00022506713867188 sec) [CACHE WRITE]
[9] SELECT FOUND_ROWS() as Count; -- (0.00018000602722168 sec) [NOT CACHED]
[10] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.00020098686218262 sec) [CACHE WRITE]
[11] SELECT `folder` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'livehelp' AND CubeCart_modules.status = '1' ; -- (0.00021600723266602 sec) [CACHE WRITE]
[12] SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.code = 'USD' ; -- (0.00026392936706543 sec) [CACHE WRITE]
[13] SELECT * FROM `CubeCart_documents` WHERE CubeCart_documents.doc_home = '1' AND CubeCart_documents.doc_status = '1' ; -- (0.00036191940307617 sec) [CACHE WRITE]
[14] INSERT INTO `CubeCart_system_error_log` (`message`,`time`) VALUES ('File: [cubecart.class.php] Line: [97] \"SELECT I.* FROM `CubeCart_inventory` AS I JOIN `CubeCart_category` AS C ON C.cat_id=I.cat_id AND C.`status`=1 AND I.status = \'1\' AND I.latest = \'1\' ORDER BY I.date_added DESC, I.product_id DESC LIMIT 5\" - Unknown column \'I.date_added\' in \'order clause\'','1493782191'); -- (0.00026392936706543 sec) [ERROR - NOT CACHED]
[15] INSERT INTO `CubeCart_system_error_log` (`message`,`time`) VALUES ('File: [cubecart.class.php] Line: [97] \"SELECT I.* FROM `CubeCart_inventory` AS I JOIN `CubeCart_category` AS C ON C.cat_id=I.cat_id AND C.`status`=1 AND I.status = \'1\' AND I.latest = \'1\' ORDER BY I.date_added DESC, I.product_id DESC LIMIT 5\" - Unknown column \'I.date_added\' in \'order clause\'','1493782191'); -- (0.00026392936706543 sec) [ERROR - CACHE WRITE]
[16] INSERT INTO `CubeCart_system_error_log` (`message`,`time`) VALUES ('[Warning] /home/scythe0000/public_html/tingyen/classes/cubecart.class.php:99 - Invalid argument supplied for foreach()','1493782191'); -- (0.00021100044250488 sec) [ERROR - NOT CACHED]
[17] DELETE FROM `CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY)) ; -- (0.00052499771118164 sec) [ERROR - NOT CACHED]
[18] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'languages' LIMIT 1; -- (0.00064206123352051 sec) [CACHE WRITE]
[19] SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.active = '1' ; -- (0.00039386749267578 sec) [CACHE WRITE]
[20] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'login' ; -- (0.00028085708618164 sec) [CACHE WRITE]
[21] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'register' ; -- (0.00027084350585938 sec) [CACHE WRITE]
[22] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '0' AND CubeCart_category.status = '1' AND CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00036501884460449 sec) [CACHE WRITE]
[23] SELECT `cat_id`, `cat_name` FROM `CubeCart_category_language` WHERE CubeCart_category_language.language = 'en-US' ; -- (0.00036501884460449 sec) [CACHE READ]
[24] SELECT C.`product_id`, I.`use_stock_level` FROM `CubeCart_category_index` AS C INNER JOIN `CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 5 AND I.status = 1 -- (0.0006101131439209 sec) [CACHE WRITE]
[25] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '5' AND CubeCart_category.status = '1'; -- (0.0002589225769043 sec) [CACHE WRITE]
[26] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '5' AND CubeCart_category.status = '1' AND CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00025200843811035 sec) [CACHE WRITE]
[27] SELECT C.`product_id`, I.`use_stock_level` FROM `CubeCart_category_index` AS C INNER JOIN `CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 2 AND I.status = 1 -- (0.00063586235046387 sec) [CACHE WRITE]
[28] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '2' AND CubeCart_category.status = '1'; -- (0.00025105476379395 sec) [CACHE WRITE]
[29] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '2' AND CubeCart_category.status = '1' AND CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00023889541625977 sec) [CACHE WRITE]
[30] SELECT C.`product_id`, I.`use_stock_level` FROM `CubeCart_category_index` AS C INNER JOIN `CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 4 AND I.status = 1 -- (0.00048708915710449 sec) [CACHE WRITE]
[31] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '4' AND CubeCart_category.status = '1'; -- (0.00023102760314941 sec) [CACHE WRITE]
[32] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '4' AND CubeCart_category.status = '1' AND CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00023579597473145 sec) [CACHE WRITE]
[33] SELECT C.`product_id`, I.`use_stock_level` FROM `CubeCart_category_index` AS C INNER JOIN `CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 6 AND I.status = 1 -- (0.00046896934509277 sec) [CACHE WRITE]
[34] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '6' AND CubeCart_category.status = '1'; -- (0.00022792816162109 sec) [CACHE WRITE]
[35] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '6' AND CubeCart_category.status = '1' AND CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00025391578674316 sec) [CACHE WRITE]
[36] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'cat' AND CubeCart_seo_urls.item_id = '5' ; -- (0.00026798248291016 sec) [CACHE WRITE]
[37] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'cat' AND CubeCart_seo_urls.item_id = '2' ; -- (0.00026392936706543 sec) [CACHE WRITE]
[38] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'cat' AND CubeCart_seo_urls.item_id = '4' ; -- (0.00026202201843262 sec) [CACHE WRITE]
[39] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'cat' AND CubeCart_seo_urls.item_id = '6' ; -- (0.0002598762512207 sec) [CACHE WRITE]
[40] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'gift_certs' LIMIT 1; -- (0.0002129077911377 sec) [CACHE WRITE]
[41] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'saleitems' ; -- (0.00026106834411621 sec) [CACHE WRITE]
[42] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'certificates' ; -- (0.00023293495178223 sec) [CACHE WRITE]
[43] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'search' ; -- (0.00027799606323242 sec) [CACHE WRITE]
[44] SELECT * FROM `CubeCart_documents` WHERE CubeCart_documents.doc_parent_id = '0' AND CubeCart_documents.doc_status = '1' AND CubeCart_documents.navigation_link = '1' ORDER BY `doc_order` ASC ; -- (0.0004420280456543 sec) [CACHE WRITE]
[45] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'doc' AND CubeCart_seo_urls.item_id = '1' ; -- (0.00027704238891602 sec) [CACHE WRITE]
[46] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'doc' AND CubeCart_seo_urls.item_id = '2' ; -- (0.00027704238891602 sec) [CACHE WRITE]
[47] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'doc' AND CubeCart_seo_urls.item_id = '4' ; -- (0.0002589225769043 sec) [CACHE WRITE]
[48] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'Contact_Form' LIMIT 1; -- (0.00018978118896484 sec) [CACHE WRITE]
[49] SELECT `product_id` FROM `CubeCart_inventory` WHERE CubeCart_inventory.status = '1' AND CubeCart_inventory.featured = '1' -- (0.00089192390441895 sec) [NOT CACHED]
[50] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '83' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00029587745666504 sec) [CACHE WRITE]
[51] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_inventory` WHERE CubeCart_inventory.product_id = '83' LIMIT 1; -- (0.00032305717468262 sec) [CACHE WRITE]
[52] SELECT FOUND_ROWS() as Count; -- (0.0001680850982666 sec) [NOT CACHED]
[53] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '83' ORDER BY `main_img` DESC LIMIT 1; -- (0.00025391578674316 sec) [CACHE WRITE]
[54] SELECT FOUND_ROWS() as Count; -- (0.00015401840209961 sec) [NOT CACHED]
[55] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '3' ; -- (0.00023794174194336 sec) [CACHE WRITE]
[56] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '83' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00019311904907227 sec) [CACHE WRITE]
[57] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '83' ; -- (0.00027704238891602 sec) [CACHE WRITE]
[58] SELECT SQL_CALC_FOUND_ROWS `name`, `product_id`, `quantity`, `price`, `sale_price`, `tax_type`, `tax_inclusive` FROM `CubeCart_inventory` WHERE CubeCart_inventory.status = '1' ORDER BY popularity DESC LIMIT 10; -- (0.00067400932312012 sec) [CACHE WRITE]
[59] SELECT FOUND_ROWS() as Count; -- (0.00018310546875 sec) [NOT CACHED]
[60] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '29' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00029397010803223 sec) [CACHE WRITE]
[61] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '29' ; -- (0.00029206275939941 sec) [CACHE WRITE]
[62] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '29' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00021100044250488 sec) [CACHE WRITE]
[63] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '29' ORDER BY `main_img` DESC LIMIT 1; -- (0.00025415420532227 sec) [CACHE WRITE]
[64] SELECT FOUND_ROWS() as Count; -- (0.0001530647277832 sec) [NOT CACHED]
[65] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '80' ; -- (0.00023293495178223 sec) [CACHE WRITE]
[66] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '79' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00028204917907715 sec) [CACHE WRITE]
[67] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '79' ; -- (0.00027179718017578 sec) [CACHE WRITE]
[68] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '79' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00019693374633789 sec) [CACHE WRITE]
[69] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '79' ORDER BY `main_img` DESC LIMIT 1; -- (0.00025010108947754 sec) [CACHE WRITE]
[70] SELECT FOUND_ROWS() as Count; -- (0.0001530647277832 sec) [NOT CACHED]
[71] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '12' ; -- (0.00023412704467773 sec) [CACHE WRITE]
[72] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '50' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00029397010803223 sec) [CACHE WRITE]
[73] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '50' ; -- (0.00028300285339355 sec) [CACHE WRITE]
[74] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '50' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00019478797912598 sec) [CACHE WRITE]
[75] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '50' ORDER BY `main_img` DESC LIMIT 1; -- (0.0002598762512207 sec) [CACHE WRITE]
[76] SELECT FOUND_ROWS() as Count; -- (0.0001530647277832 sec) [NOT CACHED]
[77] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '103' ; -- (0.00023293495178223 sec) [CACHE WRITE]
[78] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '19' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00029397010803223 sec) [CACHE WRITE]
[79] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '19' ; -- (0.00028395652770996 sec) [CACHE WRITE]
[80] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '19' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00019693374633789 sec) [CACHE WRITE]
[81] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '19' ORDER BY `main_img` DESC LIMIT 1; -- (0.00025105476379395 sec) [CACHE WRITE]
[82] SELECT FOUND_ROWS() as Count; -- (0.00015401840209961 sec) [NOT CACHED]
[83] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '20' ; -- (0.0002281665802002 sec) [CACHE WRITE]
[84] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '22' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00028014183044434 sec) [CACHE WRITE]
[85] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '22' ; -- (0.00029802322387695 sec) [CACHE WRITE]
[86] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '22' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00019598007202148 sec) [CACHE WRITE]
[87] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '22' ORDER BY `main_img` DESC LIMIT 1; -- (0.00025105476379395 sec) [CACHE WRITE]
[88] SELECT FOUND_ROWS() as Count; -- (0.00017094612121582 sec) [NOT CACHED]
[89] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '23' ; -- (0.00023293495178223 sec) [CACHE WRITE]
[90] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '25' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00027799606323242 sec) [CACHE WRITE]
[91] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '25' ; -- (0.00029206275939941 sec) [CACHE WRITE]
[92] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '25' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00019693374633789 sec) [CACHE WRITE]
[93] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '25' ORDER BY `main_img` DESC LIMIT 1; -- (0.00024604797363281 sec) [CACHE WRITE]
[94] SELECT FOUND_ROWS() as Count; -- (0.00015091896057129 sec) [NOT CACHED]
[95] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '109' ; -- (0.00024104118347168 sec) [CACHE WRITE]
[96] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '74' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00027799606323242 sec) [CACHE WRITE]
[97] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '74' ; -- (0.00028491020202637 sec) [CACHE WRITE]
[98] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '74' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00021600723266602 sec) [CACHE WRITE]
[99] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '74' ORDER BY `main_img` DESC LIMIT 1; -- (0.00024604797363281 sec) [CACHE WRITE]
[100] SELECT FOUND_ROWS() as Count; -- (0.00015401840209961 sec) [NOT CACHED]
[101] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '7' ; -- (0.00024199485778809 sec) [CACHE WRITE]
[102] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '30' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00027894973754883 sec) [CACHE WRITE]
[103] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '30' ; -- (0.00027894973754883 sec) [CACHE WRITE]
[104] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '30' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00020694732666016 sec) [CACHE WRITE]
[105] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '30' ORDER BY `main_img` DESC LIMIT 1; -- (0.0002448558807373 sec) [CACHE WRITE]
[106] SELECT FOUND_ROWS() as Count; -- (0.0001518726348877 sec) [NOT CACHED]
[107] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '31' ; -- (0.00022792816162109 sec) [CACHE WRITE]
[108] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '60' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00049209594726562 sec) [CACHE WRITE]
[109] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '60' ; -- (0.00029087066650391 sec) [CACHE WRITE]
[110] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '60' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00026798248291016 sec) [CACHE WRITE]
[111] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '60' ORDER BY `main_img` DESC LIMIT 1; -- (0.00025701522827148 sec) [CACHE WRITE]
[112] SELECT FOUND_ROWS() as Count; -- (0.0001530647277832 sec) [NOT CACHED]
[113] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '86' ; -- (0.00024890899658203 sec) [CACHE WRITE]
[114] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '8' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00027799606323242 sec) [CACHE WRITE]
[115] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '8' ; -- (0.00028800964355469 sec) [CACHE WRITE]
[116] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '8' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00020694732666016 sec) [CACHE WRITE]
[117] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '8' ORDER BY `main_img` DESC LIMIT 1; -- (0.00024795532226562 sec) [CACHE WRITE]
[118] SELECT FOUND_ROWS() as Count; -- (0.0001521110534668 sec) [NOT CACHED]
[119] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '93' ; -- (0.00023102760314941 sec) [CACHE WRITE]