Discovery 627 Back Brace

  • Click to enlarge
Discovery 627 Back Brace

Tap to enlarge

5.0 average, based on 2 reviews

$99.99 $62.99


Product Information
Specification

Discovery Specialty Series

Due to popular demand, the Discovery LP series was introduced as an alternative to the original Discovery series.  With contoured side wings and a standard sizing system, the Discovery LP’s fit patients of different shapes and sizes more comfortably, while offering the same features and models of the original Discovery line.

Discovery 627 - The low-profile version of the Discovery 7 (10” back panel) The Discovery 627 utilizes a contoured belt and a standard sizing system, allowing it to be very low-profile and discreet. With a 10” posterior panel, the Discovery 627 provides optimum support while remaining lightweight and comfortable to wear.

Use for:

  • Post-Operative Support
  • Spinal Stenosis
  • Post Laminectomy Syndrome
  • Decompressive Procedures
  • Degenerated, herniated, or Bulging Discs
  • Chronic Lower Back Pain
  • Sprains and Strains
 SMALL   (25"-32" waist)
 MEDIUM   (32"-38" waist)
 LARGE   (38"-44" waist)
 X LARGE   (44"-50" waist)
XX LARGE   (50"-56" waist)
XXX LARGE  (56"-62" waist)
XXXX LARGE   (62"-68" waist)

 

 

 

 

 

 

 

Sugg HCPC: L0627/ L0462

View/Download Instructions

View PDAC Approval Letter

Product Code Discovery 627 Back Brace
Manufacturer Comfortland
Condition New
Weight 2lb

Customer Reviews

Average Rating: 5

light and easy

1 2 3 4 5
I wear this when I sit at work and clean house. helps me from reinjury. I also like the fact that I could order one that fits my waist, my other brace seemed like it wraped around me twice. (12 May 2017, 13:17)

Medical Brace

1 2 3 4 5
My bulging disk got to the point that I couldn’t even sleep anymore. I wear this brace during the day and now I can sleep at night. The pain is still there but I feel like I am giving it a chance to heal. My chiropractor recommended this brace because he knew I was paying for it out of my pocket. It is not a flimsy cheap brace. (29 Dec 2015, 15:39)
Write a review

Write Review

Please enter a valid email address.
This field is required.
Top

eCommerce by CubeCart

PHP:
No Errors or Warnings
GET:
'Before Sanitise:' =>
'seo_path' => discovery-627-back-brace
'After Sanitise:' =>
'_a' => product
'product_id' => 175

SESSION:
'__client' =>
'ip_address' => 54.226.76.27
'useragent' => CCBot/2.0 (http://commoncrawl.org/faq/)
'session_start' => 1519127675
'session_last' => 1519127675
'language' => en-GB
'__system' =>
'token' => 701ccb7b5671ce49ff03cbfacf3c6fa1

MySQLi
Queries (135):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_sessions` WHERE mainCubeCart_sessions.session_id = '611p1uhtp2litjdrdu4f3vclq5' LIMIT 1; -- (0.00020694732666 sec) [NOT CACHED]
[2] INSERT INTO `mainCubeCart_sessions` (`admin_id`,`customer_id`,`ip_address`,`location`,`session_id`,`session_last`,`session_start`,`useragent`) VALUES ('0','0','54.226.76.27','','611p1uhtp2litjdrdu4f3vclq5','1519127675','1519127675','CCBot/2.0 (http://commoncrawl.org/faq/)'); -- (0.00335097312927 sec) [NOT CACHED]
[3] SELECT * FROM `mainCubeCart_hooks` WHERE mainCubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00335097312927 sec) [CACHE READ]
[4] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `mainCubeCart_code_snippet` WHERE mainCubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.00335097312927 sec) [CACHE READ]
[5] SELECT * FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.path = 'discovery-627-back-brace' ; -- (0.000258922576904 sec) [CACHE WRITE]
[6] SELECT SQL_CALC_FOUND_ROWS `array` FROM `mainCubeCart_config` WHERE mainCubeCart_config.name = 'logos' LIMIT 1; -- (0.000258922576904 sec) [CACHE READ]
[7] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `mainCubeCart_modules` WHERE mainCubeCart_modules.folder = 'logos' LIMIT 1; -- (0.000258922576904 sec) [CACHE READ]
[8] SELECT `folder` FROM `mainCubeCart_modules` WHERE mainCubeCart_modules.module = 'livehelp' AND mainCubeCart_modules.status = '1' ; -- (0.000258922576904 sec) [CACHE READ]
[9] SELECT path FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '175' ; -- (0.000249862670898 sec) [CACHE WRITE]
[10] SELECT path FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '175' ; -- (0.000249862670898 sec) [CACHE READ]
[11] SELECT * FROM `mainCubeCart_currency` WHERE mainCubeCart_currency.code = 'USD' ; -- (0.000249862670898 sec) [CACHE READ]
[12] SELECT CI.* , C.status FROM `mainCubeCart_category_index` AS CI, `mainCubeCart_category` AS C WHERE CI.product_id = '175' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000274896621704 sec) [CACHE WRITE]
[13] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_inventory` WHERE mainCubeCart_inventory.product_id = '175' AND mainCubeCart_inventory.status = '1' LIMIT 10 OFFSET 0; -- (0.00036096572876 sec) [CACHE WRITE]
[14] SELECT FOUND_ROWS() as Count; -- (9.48905944824E-5 sec) [NOT CACHED]
[15] SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `mainCubeCart_option_matrix` WHERE mainCubeCart_option_matrix.product_id = '175' AND mainCubeCart_option_matrix.options_identifier IS NULL AND mainCubeCart_option_matrix.status = '1' ; -- (0.000128984451294 sec) [CACHE WRITE]
[16] SELECT `quantity`, `price` FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '175' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00018310546875 sec) [CACHE WRITE]
[17] SELECT `folder` FROM `mainCubeCart_modules` WHERE mainCubeCart_modules.module = 'social' AND mainCubeCart_modules.status = '1' ; -- (0.00018310546875 sec) [CACHE READ]
[18] SELECT `folder` FROM `mainCubeCart_modules` WHERE mainCubeCart_modules.module = 'social' AND mainCubeCart_modules.status = '1' ; -- (0.00018310546875 sec) [CACHE READ]
[19] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_inventory` WHERE mainCubeCart_inventory.product_id = '175' AND mainCubeCart_inventory.status = '1' LIMIT 10 OFFSET 0; -- (0.00018310546875 sec) [CACHE READ]
[20] SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `mainCubeCart_option_matrix` WHERE mainCubeCart_option_matrix.product_id = '175' AND mainCubeCart_option_matrix.options_identifier IS NULL AND mainCubeCart_option_matrix.status = '1' ; -- (0.00018310546875 sec) [CACHE READ]
[21] SELECT `quantity`, `price` FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '175' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00018310546875 sec) [CACHE READ]
[22] UPDATE `mainCubeCart_inventory` SET `popularity` = `popularity` + 1 WHERE mainCubeCart_inventory.product_id = '175'; -- (0.00019097328186 sec) [NOT CACHED]
[23] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_image_index` WHERE mainCubeCart_image_index.product_id = '175' ORDER BY `main_img` DESC LIMIT 1; -- (0.000241041183472 sec) [CACHE WRITE]
[24] SELECT FOUND_ROWS() as Count; -- (9.3936920166E-5 sec) [NOT CACHED]
[25] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.000174999237061 sec) [CACHE WRITE]
[26] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.000174999237061 sec) [CACHE READ]
[27] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.000174999237061 sec) [CACHE READ]
[28] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.000174999237061 sec) [CACHE READ]
[29] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.000174999237061 sec) [CACHE READ]
[30] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.000174999237061 sec) [CACHE READ]
[31] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.000174999237061 sec) [CACHE READ]
[32] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.000174999237061 sec) [CACHE READ]
[33] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.000174999237061 sec) [CACHE READ]
[34] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.000174999237061 sec) [CACHE READ]
[35] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.000174999237061 sec) [CACHE READ]
[36] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.000174999237061 sec) [CACHE READ]
[37] SELECT `rating` FROM `mainCubeCart_reviews` WHERE mainCubeCart_reviews.product_id = '175' AND mainCubeCart_reviews.approved = '1' ; -- (0.00020694732666 sec) [CACHE WRITE]
[38] SELECT * FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '175' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC ; -- (0.000216007232666 sec) [CACHE WRITE]
[39] SELECT `name`, `URL` FROM `mainCubeCart_manufacturers` WHERE mainCubeCart_manufacturers.id = '4' ; -- (0.000216007232666 sec) [CACHE READ]
[40] SELECT * FROM `mainCubeCart_image_index` AS `i` INNER JOIN `mainCubeCart_filemanager` AS `f` ON i.file_id = f.file_id WHERE i.product_id = 175 ORDER BY i.main_img DESC ; -- (0.00025200843811 sec) [CACHE WRITE]
[41] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[42] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[43] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[44] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[45] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[46] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[47] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[48] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[49] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[50] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[51] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[52] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[53] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '386' ; -- (0.00025200843811 sec) [CACHE READ]
[54] SELECT `set_id` FROM `mainCubeCart_options_set_product` WHERE mainCubeCart_options_set_product.product_id = '175' ; -- (0.000147104263306 sec) [CACHE WRITE]
[55] SELECT * FROM `mainCubeCart_option_assign` WHERE mainCubeCart_option_assign.product = '175' AND mainCubeCart_option_assign.set_member_id = '0' AND mainCubeCart_option_assign.set_enabled = '1' ; -- (0.000402927398682 sec) [CACHE WRITE]
[56] SELECT * FROM `mainCubeCart_option_group` WHERE `option_id` IN (22,22,22,22,22,22,22) ORDER BY `priority` ASC, `option_name` ASC ; -- (0.000218152999878 sec) [CACHE WRITE]
[57] SELECT * FROM `mainCubeCart_option_value` WHERE mainCubeCart_option_value.option_id = '22' AND `value_id` IN (195,196,197,199,200,206,207) ORDER BY `priority` ASC, `value_name` ASC ; -- (0.000340938568115 sec) [CACHE WRITE]
[58] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_reviews` WHERE mainCubeCart_reviews.approved = '1' AND mainCubeCart_reviews.product_id = '175' ORDER BY time DESC LIMIT 5 OFFSET 0; -- (0.000298023223877 sec) [CACHE WRITE]
[59] SELECT FOUND_ROWS() as Count; -- (8.89301300049E-5 sec) [NOT CACHED]
[60] SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `mainCubeCart_reviews` WHERE mainCubeCart_reviews.approved = '1' AND mainCubeCart_reviews.product_id = '175' ; -- (0.000202178955078 sec) [CACHE WRITE]
[61] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '175' ; -- (0.000225067138672 sec) [CACHE WRITE]
[62] SELECT `set_id` FROM `mainCubeCart_options_set_product` WHERE mainCubeCart_options_set_product.product_id = '175' ; -- (0.000225067138672 sec) [CACHE READ]
[63] SELECT * FROM `mainCubeCart_option_assign` WHERE mainCubeCart_option_assign.product = '175' AND mainCubeCart_option_assign.set_member_id = '0' AND mainCubeCart_option_assign.set_enabled = '1' ; -- (0.000225067138672 sec) [CACHE READ]
[64] SELECT * FROM `mainCubeCart_option_group` WHERE `option_id` IN (22,22,22,22,22,22,22) ORDER BY `priority` ASC, `option_name` ASC ; -- (0.000225067138672 sec) [CACHE READ]
[65] SELECT * FROM `mainCubeCart_option_value` WHERE mainCubeCart_option_value.option_id = '22' AND `value_id` IN (195,196,197,199,200,206,207) ORDER BY `priority` ASC, `value_name` ASC ; -- (0.000225067138672 sec) [CACHE READ]
[66] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `mainCubeCart_option_matrix` WHERE mainCubeCart_option_matrix.product_id = '175' AND mainCubeCart_option_matrix.use_stock = '1' AND mainCubeCart_option_matrix.status = '1' LIMIT 1; -- (0.000248908996582 sec) [CACHE WRITE]
[67] SELECT FOUND_ROWS() as Count; -- (9.20295715332E-5 sec) [NOT CACHED]
[68] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_category_index` WHERE mainCubeCart_category_index.product_id = '175' AND mainCubeCart_category_index.primary = '1' LIMIT 1; -- (0.000221014022827 sec) [CACHE WRITE]
[69] SELECT FOUND_ROWS() as Count; -- (9.10758972168E-5 sec) [NOT CACHED]
[70] SELECT `path`, `custom` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'cat' AND mainCubeCart_seo_urls.item_id = '22' ; -- (9.10758972168E-5 sec) [CACHE READ]
[71] SELECT path FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '175' ; -- (9.10758972168E-5 sec) [CACHE READ]
[72] SELECT SQL_CALC_FOUND_ROWS `array` FROM `mainCubeCart_config` WHERE mainCubeCart_config.name = 'languages' LIMIT 1; -- (9.10758972168E-5 sec) [CACHE READ]
[73] SELECT * FROM `mainCubeCart_currency` WHERE mainCubeCart_currency.active = '1' ; -- (9.10758972168E-5 sec) [CACHE READ]
[74] SELECT path FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '175' ; -- (9.10758972168E-5 sec) [CACHE READ]
[75] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'login' ; -- (9.10758972168E-5 sec) [CACHE READ]
[76] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'register' ; -- (9.10758972168E-5 sec) [CACHE READ]
[77] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'search' ; -- (9.10758972168E-5 sec) [CACHE READ]
[78] SELECT * FROM `mainCubeCart_customer_membership` WHERE mainCubeCart_customer_membership.customer_id = '0' ; -- (9.10758972168E-5 sec) [CACHE READ]
[79] SELECT `price`, `sale_price`, `product_id`,`description`,`name`, `price`-`sale_price` AS `saving` FROM `mainCubeCart_inventory` WHERE `price` > `sale_price` AND `sale_price` > 0 AND `status` = '1' LIMIT 3 -- (9.10758972168E-5 sec) [CACHE READ]
[80] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '2' ; -- (9.10758972168E-5 sec) [CACHE READ]
[81] SELECT `quantity`, `price` FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '2' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (9.10758972168E-5 sec) [CACHE READ]
[82] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '3' ; -- (9.10758972168E-5 sec) [CACHE READ]
[83] SELECT `quantity`, `price` FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '3' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (9.10758972168E-5 sec) [CACHE READ]
[84] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '4' ; -- (9.10758972168E-5 sec) [CACHE READ]
[85] SELECT `quantity`, `price` FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '4' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (9.10758972168E-5 sec) [CACHE READ]
[86] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'saleitems' ; -- (9.10758972168E-5 sec) [CACHE READ]
[87] SELECT * FROM `mainCubeCart_documents` WHERE mainCubeCart_documents.doc_parent_id = '0' AND mainCubeCart_documents.doc_status = '1' AND mainCubeCart_documents.navigation_link = '1' ORDER BY `doc_order` ASC ; -- (9.10758972168E-5 sec) [CACHE READ]
[88] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'doc' AND mainCubeCart_seo_urls.item_id = '2' ; -- (9.10758972168E-5 sec) [CACHE READ]
[89] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'doc' AND mainCubeCart_seo_urls.item_id = '3' ; -- (9.10758972168E-5 sec) [CACHE READ]
[90] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'doc' AND mainCubeCart_seo_urls.item_id = '4' ; -- (9.10758972168E-5 sec) [CACHE READ]
[91] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'doc' AND mainCubeCart_seo_urls.item_id = '5' ; -- (9.10758972168E-5 sec) [CACHE READ]
[92] SELECT SQL_CALC_FOUND_ROWS `array` FROM `mainCubeCart_config` WHERE mainCubeCart_config.name = 'Contact_Form' LIMIT 1; -- (9.10758972168E-5 sec) [CACHE READ]
[93] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `mainCubeCart_modules` WHERE mainCubeCart_modules.folder = 'Contact_Form' LIMIT 1; -- (9.10758972168E-5 sec) [CACHE READ]
[94] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'contact' ; -- (9.10758972168E-5 sec) [CACHE READ]
[95] SELECT product_id FROM `mainCubeCart_inventory` WHERE mainCubeCart_inventory.status = '1' AND mainCubeCart_inventory.featured = '1' ; -- (9.10758972168E-5 sec) [CACHE READ]
[96] SELECT CI.* , C.status FROM `mainCubeCart_category_index` AS CI, `mainCubeCart_category` AS C WHERE CI.product_id = '100' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000298976898193 sec) [CACHE WRITE]
[97] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_inventory` WHERE mainCubeCart_inventory.product_id = '100' LIMIT 1; -- (0.000380039215088 sec) [CACHE WRITE]
[98] SELECT FOUND_ROWS() as Count; -- (9.20295715332E-5 sec) [NOT CACHED]
[99] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_image_index` WHERE mainCubeCart_image_index.product_id = '100' ORDER BY `main_img` DESC LIMIT 1; -- (0.000198125839233 sec) [CACHE WRITE]
[100] SELECT FOUND_ROWS() as Count; -- (8.9168548584E-5 sec) [NOT CACHED]
[101] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '139' ; -- (8.9168548584E-5 sec) [CACHE READ]
[102] SELECT `quantity`, `price` FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '100' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (8.9168548584E-5 sec) [CACHE READ]
[103] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '100' ; -- (0.000208854675293 sec) [CACHE WRITE]
[104] SELECT SQL_CALC_FOUND_ROWS `name`, `product_id`, `quantity`, `price`, `sale_price`, `tax_type`, `tax_inclusive` FROM `mainCubeCart_inventory` WHERE mainCubeCart_inventory.status = '1' ORDER BY popularity DESC LIMIT 6; -- (0.000208854675293 sec) [CACHE READ]
[105] SELECT CI.* , C.status FROM `mainCubeCart_category_index` AS CI, `mainCubeCart_category` AS C WHERE CI.product_id = '220' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000208854675293 sec) [CACHE READ]
[106] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '220' ; -- (0.000208854675293 sec) [CACHE READ]
[107] SELECT `quantity`, `price` FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '220' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000208854675293 sec) [CACHE READ]
[108] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_image_index` WHERE mainCubeCart_image_index.product_id = '220' ORDER BY `main_img` DESC LIMIT 1; -- (0.000208854675293 sec) [CACHE READ]
[109] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '435' ; -- (0.000208854675293 sec) [CACHE READ]
[110] SELECT CI.* , C.status FROM `mainCubeCart_category_index` AS CI, `mainCubeCart_category` AS C WHERE CI.product_id = '5' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000208854675293 sec) [CACHE READ]
[111] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '5' ; -- (0.000208854675293 sec) [CACHE READ]
[112] SELECT `quantity`, `price` FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '5' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000208854675293 sec) [CACHE READ]
[113] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_image_index` WHERE mainCubeCart_image_index.product_id = '5' ORDER BY `main_img` DESC LIMIT 1; -- (0.000208854675293 sec) [CACHE READ]
[114] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '12' ; -- (0.000208854675293 sec) [CACHE READ]
[115] SELECT CI.* , C.status FROM `mainCubeCart_category_index` AS CI, `mainCubeCart_category` AS C WHERE CI.product_id = '112' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000208854675293 sec) [CACHE READ]
[116] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '112' ; -- (0.000208854675293 sec) [CACHE READ]
[117] SELECT `quantity`, `price` FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '112' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000208854675293 sec) [CACHE READ]
[118] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_image_index` WHERE mainCubeCart_image_index.product_id = '112' ORDER BY `main_img` DESC LIMIT 1; -- (0.000208854675293 sec) [CACHE READ]
[119] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '441' ; -- (0.000208854675293 sec) [CACHE READ]
[120] SELECT CI.* , C.status FROM `mainCubeCart_category_index` AS CI, `mainCubeCart_category` AS C WHERE CI.product_id = '4' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000208854675293 sec) [CACHE READ]
[121] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '4' ; -- (0.000208854675293 sec) [CACHE READ]
[122] SELECT `quantity`, `price` FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '4' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000208854675293 sec) [CACHE READ]
[123] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_image_index` WHERE mainCubeCart_image_index.product_id = '4' ORDER BY `main_img` DESC LIMIT 1; -- (0.000208854675293 sec) [CACHE READ]
[124] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '11' ; -- (0.000208854675293 sec) [CACHE READ]
[125] SELECT CI.* , C.status FROM `mainCubeCart_category_index` AS CI, `mainCubeCart_category` AS C WHERE CI.product_id = '98' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000208854675293 sec) [CACHE READ]
[126] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '98' ; -- (0.000208854675293 sec) [CACHE READ]
[127] SELECT `quantity`, `price` FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '98' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000208854675293 sec) [CACHE READ]
[128] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_image_index` WHERE mainCubeCart_image_index.product_id = '98' ORDER BY `main_img` DESC LIMIT 1; -- (0.000208854675293 sec) [CACHE READ]
[129] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '138' ; -- (0.000208854675293 sec) [CACHE READ]
[130] SELECT CI.* , C.status FROM `mainCubeCart_category_index` AS CI, `mainCubeCart_category` AS C WHERE CI.product_id = '2' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000208854675293 sec) [CACHE READ]
[131] SELECT `path` FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '2' ; -- (0.000208854675293 sec) [CACHE READ]
[132] SELECT `quantity`, `price` FROM `mainCubeCart_pricing_quantity` WHERE mainCubeCart_pricing_quantity.product_id = '2' AND mainCubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000208854675293 sec) [CACHE READ]
[133] SELECT SQL_CALC_FOUND_ROWS * FROM `mainCubeCart_image_index` WHERE mainCubeCart_image_index.product_id = '2' ORDER BY `main_img` DESC LIMIT 1; -- (0.000208854675293 sec) [CACHE READ]
[134] SELECT * FROM `mainCubeCart_filemanager` WHERE mainCubeCart_filemanager.file_id = '21' ; -- (0.000208854675293 sec) [CACHE READ]
[135] SELECT path FROM `mainCubeCart_seo_urls` WHERE mainCubeCart_seo_urls.type = 'prod' AND mainCubeCart_seo_urls.item_id = '175' ; -- (0.000208854675293 sec) [CACHE READ]

Memory: Peak Usage / Max (%):
5.06MB / 32M (15.81%)
Cache (File): Enabled
Cache Used: 413.17 KB of 967.33 KB (42.71%) [Clear Cache]
Page Load Time:
0.169632911682 seconds