PHP:
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cart.class.php:635 - Undefined index: options_identifier
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cart.class.php:951 - Undefined index: tax_inclusive
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cart.class.php:951 - Undefined index: tax_inclusive
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cart.class.php:951 - Undefined index: tax_inclusive
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cart.class.php:951 - Undefined index: tax_inclusive
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cart.class.php:951 - Undefined index: tax_inclusive
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cubecart.class.php:1496 - Undefined index: tax_inclusive
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cubecart.class.php:1496 - Undefined index: tax_inclusive
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cubecart.class.php:1496 - Undefined index: tax_inclusive
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cubecart.class.php:1496 - Undefined index: tax_inclusive
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cubecart.class.php:1496 - Undefined index: tax_inclusive
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cubecart.class.php:1589 - Undefined index: coupons
[Notice] /home/coiff264/public_html/vapchoix.com/classes/tax.class.php:98 - Undefined variable: taxes
[Notice] /home/coiff264/public_html/vapchoix.com/classes/tax.class.php:98 - Undefined index: TPS 811167956 (Standard Rate 5.00%)
[Notice] /home/coiff264/public_html/vapchoix.com/classes/tax.class.php:98 - Undefined index: value
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cubecart.class.php:1616 - Undefined index: gateway
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cubecart.class.php:1979 - Undefined index: base_folder
[Notice] /home/coiff264/public_html/vapchoix.com/classes/cubecart.class.php:1621 - Undefined variable: list_checkouts
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/catalogue.class.php:1047 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/catalogue.class.php:1048 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/catalogue.class.php:1054 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/catalogue.class.php:1112 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/catalogue.class.php:1112 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1040 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1040 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1041 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1043 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1037 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/catalogue.class.php:1047 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/catalogue.class.php:1048 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/catalogue.class.php:1054 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/catalogue.class.php:1112 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/catalogue.class.php:1112 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1040 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1040 - Undefined index: sale_price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1041 - Undefined index: price
[Notice] /home/coiff264/public_html/vapchoix.com/classes/gui.class.php:1043 - Undefined index: price GET:
'Before Sanitise:' =>
'_a' => checkout
'After Sanitise:' =>
'_a' => checkout
SESSION:
'__client' =>
'ip_address' => 216.246.238.153
'useragent' => Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Firefox/38.0
'session_start' => 1432050374
'session_last' => 1432050385
'language' => fr-FR
'currency' => CAD
'admin_id' => 2
'user_language' => en-GB
'__system' =>
'token' => 30a65c276d61b30e4c6f40ef1eaac218
'login_push' => 1
'__recaptcha' =>
'error' =>
'confirmed' =>
'__admin_data' =>
'admin_id' => 2
'customer_id' => 0
'status' => 1
'name' => Claude Lefrancois
'username' => Claude
'new_password' => 1
'email' => papirus39@hotmail.com
'verify' =>
'logins' => 22
'super_user' => 1
'notes' =>
'failLevel' => 0
'blockTime' => 0
'lastTime' => 1432048529
'browser' => Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Firefox/38.0
'ip_address' => 216.246.238.153
'language' => en-GB
'dashboard_notes' =>
'order_notify' => 0
'tour_shown' =>
'__admin' =>
'user_language' => en-GB
'__basket' =>
'contents' =>
'68a2afe6de84a45a05957d387a0aee08' =>
'product_id' => 44
'status' => 1
'product_code' =>
'quantity' => 1
'description' =>
'price' => 800.00
'sale_price' => 185.00
'cost_price' => 0.00
'name' => m248
'cat_id' => 8
'popularity' => 0
'stock_level' => 4
'stock_warning' => 0
'use_stock_level' => 1
'digital' => 0
'digital_path' =>
'product_weight' => 1.700
'tax_type' => 1
'tax_inclusive' => 0
'featured' => 1
'seo_meta_title' =>
'seo_meta_description' =>
'seo_meta_keywords' =>
'upc' =>
'ean' =>
'jan' =>
'isbn' =>
'brand' =>
'google_category' =>
'gtin' =>
'mpn' =>
'date_added' => 2015-05-18 12:23:41
'updated' => 2015-05-18 22:20:47
'manufacturer' =>
'condition' => new
'available' => 1
'minimum_quantity' => 0
'minorder_qty' => 0
'minorder_price' => 0.00
'minorder_subtotal' => 0.00
'ctrl_sale' => 1
'price_to_pay' => 185.00
'full_base_price' => 800.00
'id' => 44
'option_line_price' => 0
'total_price_each' => 185.00
'tax_each' =>
'amount' => 9.25
'tax_inclusive' =>
'tax_name' => TPS 811167956 (Standard Rate 5.00%)
'weight' => 1.700
'discount' => 0.00
'subtotal' => 185.00
'total_tax' => 9.25
'total' => 194.25
'confirm_addresses' => 1
'billing_address' =>
'address_id' => 2
'customer_id' => 2
'billing' => 1
'default' => 1
'description' => Adresse de facturation/livraison
'title' =>
'first_name' => Stéphane
'last_name' => Lefrançois
'company_name' =>
'line1' => 5303 52 nd st
'line2' =>
'town' => Yellowknife
'state' => Northwest Territories
'postcode' => X1A 1V1
'country' => Canada
'hash' => 8027df5dbce59af9ab2ca7020b97760d
'state_id' => 72
'country_id' => 124
'state_abbrev' => NT
'country_iso' => CA
'country_iso3' => CAN
'user_defined' => 1
'delivery_address' =>
'address_id' => 2
'customer_id' => 2
'billing' => 1
'default' => 1
'description' => Adresse de facturation/livraison
'title' =>
'first_name' => Stéphane
'last_name' => Lefrançois
'company_name' =>
'line1' => 5303 52 nd st
'line2' =>
'town' => Yellowknife
'state' => Northwest Territories
'postcode' => X1A 1V1
'country' => Canada
'hash' => 8027df5dbce59af9ab2ca7020b97760d
'state_id' => 72
'country_id' => 124
'state_abbrev' => NT
'country_iso' => CA
'country_iso3' => CAN
'user_defined' => 1
'shipping' =>
'offset' => 5
'name' => Free_Shipping
'product' =>
'value' => 0.00
'tax_id' => 0
'tax' =>
'min_shipping_set' => 1
'shipping_hash' => 09d7f39a99be25aa48bd3e80f7365e20
'order_taxes' =>
'0' =>
'tax_id' => 7
'amount' => 9.25
COOKIE:
'44c621219e3f66a7d4725c437c8fb0f8' => vosm+mLXTfl5KwgWGDFg0Y47t1MCB39DTZrBXydaWfM85sxJ1c622y8GXcLXujU1CPLWy53pdOj0C1p3icQeqLbxzgNyghbH8UTulkfCWeBVicSBbOYABRZ4IZKbGOO/6m2glkRLtkl+9q3v4kGT0eDCH8fECtktRR6tv/p0RQ7j/dVxyx9t4gekKjxIILdHDruCD5DlkLaBkCiqqZ3xiDYKKJULXg+xx094XKuKuT6g3nCFcRN+stqyf98Ww+3/vQCW+/00odNzqmwSdcD9oWkHNQza6ORrd9hchGK922zTQyamS35h2tcJ8cEAPoyX4oWRJD1YLLOo/lovmPt4eNzjOuT1ylmqZmtjiierbIEuj1bGguinKOLKU+fAiwaD6dcnvb3GCwsnDy1vSE1Kkp0OAPErvk5JVHead8GCXVznxuJKeK5SLihQXPwU32EXLz+FiEgbCrknDLhUP7xOmHov0CFjU59j6EKki+i99SLj1mo2756DwK/wa1aJu8qcn60CQm6aVqnNWNofJ0QJrsy+PmxcKI4QuwzcnVZ10YbcsNaLZAOpRnuUjiZBia0TM3WbZCSL232AKjyWEJfYW3zwnKD4AgTRtH6yXyVdQ1cPpncpxycV2kJ5kkYQ98RtH6Y+V2WqVJSyxIgkDrvlz3awYixbcg6xh7wFt9WT1GZxX1rLeJAguo9W4mi3+slt0IkYU7tNsSm7DouWgRSv8qMp4BavQdWbTTgQVBxaanu71vu5yqJzpwBoPVQTR6FzO1ZjAf9l0sedV5lyoAxqwj8G7BENwgp7oY2gn9T7VnLmOe0LyLlpZRwUgkJkaFvUiJ7o/AA6BJZj9XtZap4ylRq84l6pJhLzfoxk6+be/8pIePZ137ZlKlTy6eKqS1RTYSF+IAyJC1Xw7qSlZrBSZZZ9+ZdNpiwrbZVqZuUpNDPqaqQYL6fgbCLfQD1XsIyCOGFlJ/xubq1pNQRFLzmN5Go0pZ5sBsq+bexPDCuQJjiKOVkXKX+2qDhLry7u2D57CtXMf0tqPc1uKQjsyjVwN76J4XFWhdq/1dFonNV1gSH3UQGd6xPvLmBU4JinacjyKxC7Vfnq/8Yj01TZrRNkoC0jMescnsXQTCNEaixVUyyBb+MaQrV0mtleDfLvUWUBLSMx6xyexdBMI0RqLFVTLFUco72qTcpBKqWNEcOxsmYf4XQHtvh59ecRZdjL01JDuUopu5Ta8BgPlCADrap/r/29oHJSNzjPQjx8/9c67FdQ46TZMsSk6TJCIyvIw8+GY015WIRkVjTra8nvP2PEPEhZVHVp+FEwPO12RyTGcJArIEHIpTbphIRTK/GMHxvqZBMMON4MJbLgf0ZAQnhRlV4zol2TIlOepYKIPzgqG8dSudTmqWxBzNs4szoUnZcEX23NDb54qZ+3gQsXzXFeZGulYoGzr/HclZDMvjUOPFEta6+SepapyXXPklmdMLAPw38XRk626AZJ+m1tTRjF5Jj/pqDk2hvq5MtNojYDCdMF9CBqtmRlyjxCZn1Z2M5C9CdLrpIyL3hrRcYCFmLmtQfhVNPnJmNdVVQl7g4R+nklmqcsGHWP4dxa5E6r0rXKvQqukUewXvWy9wdk6LU8Ye9t5DZ/YURbi8aNzLKgXSNieHOV6lufIIThV9adseP0iXzyizgVxnd5HEtIIvsUeLvGp3yM2TcSA9FyB0xeR9dlPvN/UFyEUxB5mmZsAIm1tvHOA3KCFsfxRO6WR8JZ4C6zmKIebqZLb1gT9nzYWIrsHcmusoN5DwZTdH/mJESHoZrQaxfOPt1XSjeskc44PkbPaZTFeWLmusKOADc7p5j7K/AyxzuM3ki9YGTHZBaVS3f15fYuJ1z/UOGxABYfMY0J5iD56YoB4EwTFux6NOZ+izmMEzwoYtKa5h0NnkedUo9N+wDuvpXHJVsWR5JCv7JcS87vBxNVmHobm45ZZpc=001472
'ffdbd13d96d903c026c4876e97eb63a4' => vosm+mLXTfl5KwgWGDFg0Wbo+eBTJiRyudmViGOz3ZC38iXOGJJXPLkw8WmDITJVZjLIr4G9f4WIDuAoh3KCyN75ILPly8oMVVigRwKYQoVt+snnO/qTkBGkxKmwrgwY3svDPZeU4W8lvY0LAgKuC9PI+DL/DsZ02qyXixKHHktyTwXbhb+IN0mtVnWARyqVafT1PC65e2yYTl0lEJEQWSVjRF7xAkecNMvJ+j4iD5W1zblbos5nkOVTbNEz/K7gQxDo4kD7Ue+neOodBmeVitsUagxkt00BnERy56mGivIF0lZbXvsJxtk7xCvKVsjomCXtKaLhgBT9t5xw5KqejxSbNspvBxGt4ThaAnyCgy1pyv3Szi6nAkfkNK784c33000288
'default_horde_view' => auto
'product_view' => grid
'username' => kanimzie@hotmail.com
'PHPSESSID' => 0f3ab1e93c81cedaef9a3aa8ff949259
MySQLi
Queries (162):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_sessions` WHERE psCubeCart_sessions.session_id = '0f3ab1e93c81cedaef9a3aa8ff949259' LIMIT 1; -- (0.000365972518921 sec) [NOT CACHED]
[2] SELECT FOUND_ROWS() as Count; -- (0.000160932540894 sec) [NOT CACHED]
[3] SELECT * FROM `psCubeCart_hooks` WHERE psCubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.000160932540894 sec) [CACHE READ]
[4] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `psCubeCart_code_snippet` WHERE psCubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.000160932540894 sec) [CACHE READ]
[5] SELECT SQL_CALC_FOUND_ROWS `array` FROM `psCubeCart_config` WHERE psCubeCart_config.name = 'logos' LIMIT 1; -- (0.000270128250122 sec) [CACHE WRITE]
[6] SELECT FOUND_ROWS() as Count; -- (0.000188112258911 sec) [NOT CACHED]
[7] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `psCubeCart_modules` WHERE psCubeCart_modules.folder = 'logos' LIMIT 1; -- (0.000188112258911 sec) [CACHE READ]
[8] SELECT `folder` FROM `psCubeCart_modules` WHERE psCubeCart_modules.module = 'livehelp' AND psCubeCart_modules.status = '1' ; -- (0.000188112258911 sec) [CACHE READ]
[9] SELECT * FROM `psCubeCart_currency` WHERE psCubeCart_currency.code = 'CAD' ; -- (0.000174045562744 sec) [CACHE WRITE]
[10] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_customer` WHERE psCubeCart_customer.customer_id = '2' LIMIT 1; -- (0.000208139419556 sec) [CACHE WRITE]
[11] SELECT FOUND_ROWS() as Count; -- (0.000245094299316 sec) [NOT CACHED]
[12] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'login' ; -- (0.000220060348511 sec) [CACHE WRITE]
[13] SELECT * FROM `psCubeCart_addressbook` WHERE psCubeCart_addressbook.customer_id = '2' AND psCubeCart_addressbook.default = '1' ORDER BY billing DESC ; -- (0.000288009643555 sec) [NOT CACHED]
[14] SELECT * FROM `psCubeCart_geo_zone` WHERE psCubeCart_geo_zone.id = '72' ; -- (0.000223159790039 sec) [CACHE WRITE]
[15] SELECT `name` FROM `psCubeCart_geo_country` WHERE psCubeCart_geo_country.numcode = '124' ; -- (0.000205993652344 sec) [CACHE WRITE]
[16] SELECT * FROM `psCubeCart_geo_zone` WHERE psCubeCart_geo_zone.id = '72' ; -- (0.000205993652344 sec) [CACHE READ]
[17] SELECT `iso` FROM `psCubeCart_geo_country` WHERE psCubeCart_geo_country.numcode = '124' ; -- (0.000212907791138 sec) [CACHE WRITE]
[18] SELECT `iso3` FROM `psCubeCart_geo_country` WHERE psCubeCart_geo_country.numcode = '124' ; -- (0.000169038772583 sec) [CACHE WRITE]
[19] SELECT * FROM `psCubeCart_geo_zone` WHERE psCubeCart_geo_zone.id = '72' ; -- (0.000169038772583 sec) [CACHE READ]
[20] SELECT COUNT(customer_id) AS Count FROM `psCubeCart_saved_cart` WHERE psCubeCart_saved_cart.customer_id = '2'; -- (0.000159978866577 sec) [CACHE WRITE]
[21] UPDATE `psCubeCart_saved_cart` SET `basket` = 'a:1:{s:32:\"68a2afe6de84a45a05957d387a0aee08\";a:47:{s:10:\"product_id\";s:2:\"44\";s:6:\"status\";s:1:\"1\";s:12:\"product_code\";s:0:\"\";s:8:\"quantity\";i:1;s:11:\"description\";b:0;s:5:\"price\";s:6:\"800.00\";s:10:\"sale_price\";s:6:\"185.00\";s:10:\"cost_price\";s:4:\"0.00\";s:4:\"name\";s:4:\"m248\";s:6:\"cat_id\";s:1:\"8\";s:10:\"popularity\";s:1:\"0\";s:11:\"stock_level\";s:1:\"4\";s:13:\"stock_warning\";s:1:\"0\";s:15:\"use_stock_level\";s:1:\"1\";s:7:\"digital\";s:1:\"0\";s:12:\"digital_path\";s:0:\"\";s:14:\"product_weight\";s:5:\"1.700\";s:8:\"tax_type\";s:1:\"1\";s:13:\"tax_inclusive\";s:1:\"0\";s:8:\"featured\";s:1:\"1\";s:14:\"seo_meta_title\";s:0:\"\";s:20:\"seo_meta_description\";s:0:\"\";s:17:\"seo_meta_keywords\";s:0:\"\";s:3:\"upc\";s:0:\"\";s:3:\"ean\";s:0:\"\";s:3:\"jan\";s:0:\"\";s:4:\"isbn\";s:0:\"\";s:5:\"brand\";s:0:\"\";s:15:\"google_category\";s:0:\"\";s:4:\"gtin\";s:0:\"\";s:3:\"mpn\";s:0:\"\";s:10:\"date_added\";s:19:\"2015-05-18 12:23:41\";s:7:\"updated\";s:19:\"2015-05-18 22:20:47\";s:12:\"manufacturer\";s:0:\"\";s:9:\"condition\";s:3:\"new\";s:9:\"available\";s:1:\"1\";s:16:\"minimum_quantity\";s:1:\"0\";s:12:\"minorder_qty\";s:1:\"0\";s:14:\"minorder_price\";s:4:\"0.00\";s:17:\"minorder_subtotal\";s:4:\"0.00\";s:9:\"ctrl_sale\";b:1;s:12:\"price_to_pay\";s:6:\"185.00\";s:15:\"full_base_price\";s:6:\"800.00\";s:2:\"id\";i:44;s:17:\"option_line_price\";i:0;s:16:\"total_price_each\";s:6:\"185.00\";s:8:\"tax_each\";a:3:{s:6:\"amount\";s:4:\"9.25\";s:13:\"tax_inclusive\";b:0;s:8:\"tax_name\";s:35:\"TPS 811167956 (Standard Rate 5.00%)\";}}}' WHERE psCubeCart_saved_cart.customer_id = '2'; -- (0.0069420337677 sec) [NOT CACHED]
[22] SELECT SQL_CALC_FOUND_ROWS `array` FROM `psCubeCart_config` WHERE psCubeCart_config.name = 'Per_Category' LIMIT 1; -- (0.0069420337677 sec) [CACHE READ]
[23] SELECT SQL_CACHE T.tax_name AS type_name, D.display, D.name, R.id, R.type_id, R.tax_percent, R.goods, R.shipping, R.county_id FROM psCubeCart_tax_rates AS R, psCubeCart_tax_details AS D, psCubeCart_tax_class AS T, psCubeCart_geo_country AS C WHERE D.id = R.details_id AND C.numcode = R.country_id AND R.type_id = T.id AND D.status = 1 AND R.active = 1 AND R.country_id = 124 -- (0.00211000442505 sec) [CACHE WRITE]
[24] SELECT CI.* , C.status FROM `psCubeCart_category_index` AS CI, `psCubeCart_category` AS C WHERE CI.product_id = '44' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.0016508102417 sec) [CACHE WRITE]
[25] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_inventory` WHERE psCubeCart_inventory.product_id = '44' AND psCubeCart_inventory.status = '1' LIMIT 10 OFFSET 0; -- (0.000250816345215 sec) [CACHE WRITE]
[26] SELECT FOUND_ROWS() as Count; -- (0.000244140625 sec) [NOT CACHED]
[27] SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `psCubeCart_option_matrix` WHERE psCubeCart_option_matrix.product_id = '44' AND psCubeCart_option_matrix.options_identifier IS NULL AND psCubeCart_option_matrix.status = '1' ; -- (0.000244140625 sec) [CACHE READ]
[28] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000255107879639 sec) [CACHE WRITE]
[29] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '44' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000272989273071 sec) [CACHE WRITE]
[30] SELECT FOUND_ROWS() as Count; -- (0.00025200843811 sec) [NOT CACHED]
[31] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '44' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.00025200843811 sec) [CACHE READ]
[32] SELECT SQL_CALC_FOUND_ROWS `array` FROM `psCubeCart_config` WHERE psCubeCart_config.name = 'gift_certs' LIMIT 1; -- (0.00025200843811 sec) [CACHE READ]
[33] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_image_index` WHERE psCubeCart_image_index.product_id = '44' ORDER BY `main_img` DESC LIMIT 1; -- (0.00025200843811 sec) [CACHE READ]
[34] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_image_index` WHERE psCubeCart_image_index.product_id = '44' ORDER BY `main_img` DESC LIMIT 1; -- (0.00025200843811 sec) [CACHE READ]
[35] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '44' ; -- (0.000158071517944 sec) [CACHE WRITE]
[36] SELECT `folder`, `countries` FROM `psCubeCart_modules` WHERE psCubeCart_modules.module = 'shipping' AND psCubeCart_modules.status = '1' ; -- (0.000284910202026 sec) [CACHE WRITE]
[37] SELECT SQL_CALC_FOUND_ROWS `array` FROM `psCubeCart_config` WHERE psCubeCart_config.name = 'Canada_Post' LIMIT 1; -- (0.000159025192261 sec) [CACHE WRITE]
[38] SELECT FOUND_ROWS() as Count; -- (0.000328063964844 sec) [NOT CACHED]
[39] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `psCubeCart_modules` WHERE psCubeCart_modules.folder = 'Canada_Post' LIMIT 1; -- (0.000158071517944 sec) [CACHE WRITE]
[40] SELECT FOUND_ROWS() as Count; -- (0.000134944915771 sec) [NOT CACHED]
[41] INSERT INTO `psCubeCart_request_log` (`request_url`,`request`,`result`,`error`) VALUES ('http://sellonline.canadapost.ca/','\n en\n \n CPC_ELECTRO_MICRO_SC\n J0L 1N0\n 185.00\n \n \n 1\n 1.7\n 0\n 0\n 0\n Online Order\n \n \n Yellowknife\n Northwest Territories\n CA\n X1A 1V1\n \n\n','\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n]>\n\n \n \n 1\n OK\n 2413588\n 0.0\n 0\n \n Priority\n 53.59\n 2015-05-20\n 2015-05-25\n 2\n false\n P_0\n \n \n Xpresspost\n 35.03\n 2015-05-20\n 2015-05-26\n 3\n false\n P_0\n \n \n Expedited\n 16.57\n 2015-05-20\n 2015-06-01\n 2\n false\n P_0\n \n \n Regular\n 16.57\n 2015-05-20\n 2015-06-03\n 4\n false\n P_0\n \n\n \n \n P_0\n \n moyenne_3_72\n 1.94\n 1.94\n 39.0\n 13.0\n 13.0\n \n 1\n Online Order\n \n \n \n \n \n \n\n \n No\n Yes\n No\n\n \n \n \n \n \n \n\n\n\n',''); -- (0.0138630867004 sec) [NOT CACHED]
[42] SELECT SQL_CALC_FOUND_ROWS `array` FROM `psCubeCart_config` WHERE psCubeCart_config.name = 'Free_Shipping' LIMIT 1; -- (0.000198125839233 sec) [CACHE WRITE]
[43] SELECT FOUND_ROWS() as Count; -- (0.000277996063232 sec) [NOT CACHED]
[44] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `psCubeCart_modules` WHERE psCubeCart_modules.folder = 'Free_Shipping' LIMIT 1; -- (0.000165224075317 sec) [CACHE WRITE]
[45] SELECT FOUND_ROWS() as Count; -- (0.000303030014038 sec) [NOT CACHED]
[46] SELECT * FROM `psCubeCart_modules` WHERE psCubeCart_modules.module = 'gateway' AND psCubeCart_modules.status = '1' ORDER BY `position` ASC ; -- (0.000447988510132 sec) [CACHE WRITE]
[47] SELECT SQL_CALC_FOUND_ROWS `array` FROM `psCubeCart_config` WHERE psCubeCart_config.name = 'e_Payments_Interac' LIMIT 1; -- (0.000297069549561 sec) [CACHE WRITE]
[48] SELECT FOUND_ROWS() as Count; -- (0.000277996063232 sec) [NOT CACHED]
[49] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `psCubeCart_modules` WHERE psCubeCart_modules.folder = 'e_Payments_Interac' LIMIT 1; -- (0.000427007675171 sec) [CACHE WRITE]
[50] SELECT FOUND_ROWS() as Count; -- (0.00150895118713 sec) [NOT CACHED]
[51] SELECT SQL_CALC_FOUND_ROWS DISTINCT `cart_order_id` FROM `psCubeCart_order_inventory` WHERE `product_id` IN (44) GROUP BY cart_order_id ORDER BY `id` DESC LIMIT 30; -- (0.00758910179138 sec) [CACHE WRITE]
[52] SELECT FOUND_ROWS() as Count; -- (0.000169038772583 sec) [NOT CACHED]
[53] SELECT SQL_CALC_FOUND_ROWS DISTINCT `product_id` FROM `psCubeCart_order_inventory` WHERE `cart_order_id` IN ('150518-234054-7972','150518-231605-3818','150518-211743-6796','150518-203409-8425','150518-191538-6776','150518-141806-1255','150518-135401-3681','150518-132440-1639','150518-125416-3192') AND `product_id` NOT IN (44) GROUP BY product_id LIMIT 3; -- (0.000663995742798 sec) [CACHE WRITE]
[54] SELECT FOUND_ROWS() as Count; -- (0.000149965286255 sec) [NOT CACHED]
[55] SELECT CI.* , C.status FROM `psCubeCart_category_index` AS CI, `psCubeCart_category` AS C WHERE CI.product_id = '43' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000396013259888 sec) [CACHE WRITE]
[56] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_inventory` WHERE psCubeCart_inventory.product_id = '43' AND psCubeCart_inventory.status = '1' LIMIT 10 OFFSET 0; -- (0.00042986869812 sec) [CACHE WRITE]
[57] SELECT FOUND_ROWS() as Count; -- (0.000159978866577 sec) [NOT CACHED]
[58] SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `psCubeCart_option_matrix` WHERE psCubeCart_option_matrix.product_id = '43' AND psCubeCart_option_matrix.options_identifier IS NULL AND psCubeCart_option_matrix.status = '1' ; -- (0.000223875045776 sec) [CACHE WRITE]
[59] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000127077102661 sec) [CACHE WRITE]
[60] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '43' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000144958496094 sec) [CACHE WRITE]
[61] SELECT FOUND_ROWS() as Count; -- (0.000150203704834 sec) [NOT CACHED]
[62] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '43' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000150203704834 sec) [CACHE READ]
[63] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_image_index` WHERE psCubeCart_image_index.product_id = '43' ORDER BY `main_img` DESC LIMIT 1; -- (0.000272035598755 sec) [CACHE WRITE]
[64] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '43' ; -- (0.000126838684082 sec) [CACHE WRITE]
[65] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000126838684082 sec) [CACHE READ]
[66] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '43' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000126838684082 sec) [CACHE READ]
[67] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '43' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000126838684082 sec) [CACHE READ]
[68] SELECT SQL_CALC_FOUND_ROWS `array` FROM `psCubeCart_config` WHERE psCubeCart_config.name = 'languages' LIMIT 1; -- (0.000360012054443 sec) [CACHE WRITE]
[69] SELECT FOUND_ROWS() as Count; -- (0.000273942947388 sec) [NOT CACHED]
[70] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `psCubeCart_modules` WHERE psCubeCart_modules.folder = 'languages' LIMIT 1; -- (0.000273942947388 sec) [CACHE READ]
[71] SELECT * FROM `psCubeCart_currency` WHERE psCubeCart_currency.active = '1' ; -- (0.000228881835938 sec) [CACHE WRITE]
[72] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'login' ; -- (0.000174999237061 sec) [CACHE WRITE]
[73] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'register' ; -- (0.000205993652344 sec) [CACHE WRITE]
[74] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'search' ; -- (0.000226974487305 sec) [CACHE WRITE]
[75] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000226974487305 sec) [CACHE READ]
[76] SELECT `I`.`product_id`,`I`.`description`,`I`.`name`, `G`.`price`-`G`.`sale_price` AS `saving` FROM `psCubeCart_pricing_group` AS `G` INNER JOIN `psCubeCart_inventory` AS `I` ON `G`.`product_id` = `I`.`product_id` WHERE `G`.`price` > `G`.`sale_price` AND `G`.`sale_price` > 0 AND `G`.`group_id` IN(3) AND `I`.`status` = '1' LIMIT 10 -- (0.000326156616211 sec) [CACHE WRITE]
[77] SELECT `I`.`product_id` FROM `psCubeCart_pricing_group` AS `G` INNER JOIN `psCubeCart_inventory` AS `I` ON `G`.`product_id` = `I`.`product_id` WHERE G.sale_price = 0 AND `group_id` IN(3) AND `I`.`status` = '1' -- (0.000241994857788 sec) [CACHE WRITE]
[78] SELECT `price`, `sale_price`, `product_id`,`description`,`name`, `price`-`sale_price` AS `saving` FROM `psCubeCart_inventory` WHERE `price` > `sale_price` AND `sale_price` > 0 AND `status` = '1' AND `product_id` NOT IN (7,4,5,17,6,36,32,28,9,40,39,35,29,26,24,27,20,3) LIMIT 10 -- (0.000300884246826 sec) [CACHE WRITE]
[79] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '45' ; -- (0.000154972076416 sec) [CACHE WRITE]
[80] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000154972076416 sec) [CACHE READ]
[81] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '45' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000171899795532 sec) [CACHE WRITE]
[82] SELECT FOUND_ROWS() as Count; -- (0.000197172164917 sec) [NOT CACHED]
[83] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '45' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000197172164917 sec) [CACHE READ]
[84] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '44' ; -- (0.000154972076416 sec) [CACHE WRITE]
[85] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000154972076416 sec) [CACHE READ]
[86] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '44' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000174045562744 sec) [CACHE WRITE]
[87] SELECT FOUND_ROWS() as Count; -- (0.000230073928833 sec) [NOT CACHED]
[88] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '44' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000230073928833 sec) [CACHE READ]
[89] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '43' ; -- (0.000230073928833 sec) [CACHE READ]
[90] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000230073928833 sec) [CACHE READ]
[91] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '43' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000230073928833 sec) [CACHE READ]
[92] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '43' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000230073928833 sec) [CACHE READ]
[93] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '42' ; -- (0.000205993652344 sec) [CACHE WRITE]
[94] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000205993652344 sec) [CACHE READ]
[95] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '42' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000172853469849 sec) [CACHE WRITE]
[96] SELECT FOUND_ROWS() as Count; -- (0.000251054763794 sec) [NOT CACHED]
[97] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '42' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000251054763794 sec) [CACHE READ]
[98] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'saleitems' ; -- (0.000157117843628 sec) [CACHE WRITE]
[99] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_newsletter_subscriber` WHERE psCubeCart_newsletter_subscriber.email = 'kanimzie@hotmail.com' LIMIT 1; -- (0.000157117843628 sec) [CACHE READ]
[100] SELECT * FROM `psCubeCart_documents` WHERE psCubeCart_documents.doc_parent_id = '0' AND psCubeCart_documents.doc_status = '1' AND psCubeCart_documents.navigation_link = '1' ORDER BY `doc_order` ASC ; -- (0.000724077224731 sec) [CACHE WRITE]
[101] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'doc' AND psCubeCart_seo_urls.item_id = '8' ; -- (0.000211954116821 sec) [CACHE WRITE]
[102] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'doc' AND psCubeCart_seo_urls.item_id = '2' ; -- (0.000207901000977 sec) [CACHE WRITE]
[103] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'doc' AND psCubeCart_seo_urls.item_id = '3' ; -- (0.000164031982422 sec) [CACHE WRITE]
[104] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'doc' AND psCubeCart_seo_urls.item_id = '4' ; -- (0.000205039978027 sec) [CACHE WRITE]
[105] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'doc' AND psCubeCart_seo_urls.item_id = '5' ; -- (0.0001540184021 sec) [CACHE WRITE]
[106] SELECT SQL_CALC_FOUND_ROWS `array` FROM `psCubeCart_config` WHERE psCubeCart_config.name = 'Contact_Form' LIMIT 1; -- (0.000212907791138 sec) [CACHE WRITE]
[107] SELECT FOUND_ROWS() as Count; -- (0.000233173370361 sec) [NOT CACHED]
[108] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `psCubeCart_modules` WHERE psCubeCart_modules.folder = 'Contact_Form' LIMIT 1; -- (0.000233173370361 sec) [CACHE READ]
[109] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'contact' ; -- (0.00018310546875 sec) [CACHE WRITE]
[110] SELECT * FROM `psCubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `psCubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE psCubeCart_inventory.status = '1' -- (0.00084400177002 sec) [NOT CACHED]
[111] SELECT CI.* , C.status FROM `psCubeCart_category_index` AS CI, `psCubeCart_category` AS C WHERE CI.product_id = '13' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000560998916626 sec) [CACHE WRITE]
[112] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_image_index` WHERE psCubeCart_image_index.product_id = '13' ORDER BY `main_img` DESC LIMIT 1; -- (0.000375986099243 sec) [CACHE WRITE]
[113] SELECT FOUND_ROWS() as Count; -- (0.000226974487305 sec) [NOT CACHED]
[114] SELECT * FROM `psCubeCart_filemanager` WHERE psCubeCart_filemanager.file_id = '20' ; -- (0.000367164611816 sec) [CACHE WRITE]
[115] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000367164611816 sec) [CACHE READ]
[116] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '13' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000370979309082 sec) [CACHE WRITE]
[117] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '13' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000349998474121 sec) [CACHE WRITE]
[118] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `psCubeCart_inventory` WHERE psCubeCart_inventory.product_id = '13' LIMIT 1; -- (0.000259160995483 sec) [CACHE WRITE]
[119] SELECT FOUND_ROWS() as Count; -- (0.000204801559448 sec) [NOT CACHED]
[120] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '13' ; -- (0.000312089920044 sec) [CACHE WRITE]
[121] SELECT SQL_CALC_FOUND_ROWS `name`, `product_id`, `quantity` FROM `psCubeCart_inventory` WHERE psCubeCart_inventory.status = '1' ORDER BY popularity DESC LIMIT 7; -- (0.000298023223877 sec) [CACHE WRITE]
[122] SELECT FOUND_ROWS() as Count; -- (0.0002281665802 sec) [NOT CACHED]
[123] SELECT CI.* , C.status FROM `psCubeCart_category_index` AS CI, `psCubeCart_category` AS C WHERE CI.product_id = '2' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000232934951782 sec) [CACHE WRITE]
[124] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '2' ; -- (0.000160932540894 sec) [CACHE WRITE]
[125] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000160932540894 sec) [CACHE READ]
[126] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '2' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000240802764893 sec) [CACHE WRITE]
[127] SELECT FOUND_ROWS() as Count; -- (0.000180959701538 sec) [NOT CACHED]
[128] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '2' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000180959701538 sec) [CACHE READ]
[129] SELECT CI.* , C.status FROM `psCubeCart_category_index` AS CI, `psCubeCart_category` AS C WHERE CI.product_id = '4' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000196933746338 sec) [CACHE WRITE]
[130] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '4' ; -- (0.000164031982422 sec) [CACHE WRITE]
[131] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000164031982422 sec) [CACHE READ]
[132] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '4' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000203847885132 sec) [CACHE WRITE]
[133] SELECT FOUND_ROWS() as Count; -- (0.000322103500366 sec) [NOT CACHED]
[134] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '4' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000322103500366 sec) [CACHE READ]
[135] SELECT CI.* , C.status FROM `psCubeCart_category_index` AS CI, `psCubeCart_category` AS C WHERE CI.product_id = '8' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000174999237061 sec) [CACHE WRITE]
[136] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '8' ; -- (0.000154972076416 sec) [CACHE WRITE]
[137] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000154972076416 sec) [CACHE READ]
[138] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '8' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000154972076416 sec) [CACHE READ]
[139] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '8' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000154972076416 sec) [CACHE READ]
[140] SELECT CI.* , C.status FROM `psCubeCart_category_index` AS CI, `psCubeCart_category` AS C WHERE CI.product_id = '7' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000174045562744 sec) [CACHE WRITE]
[141] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '7' ; -- (0.000643968582153 sec) [CACHE WRITE]
[142] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000643968582153 sec) [CACHE READ]
[143] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '7' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000179052352905 sec) [CACHE WRITE]
[144] SELECT FOUND_ROWS() as Count; -- (0.00118899345398 sec) [NOT CACHED]
[145] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '7' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.00118899345398 sec) [CACHE READ]
[146] SELECT CI.* , C.status FROM `psCubeCart_category_index` AS CI, `psCubeCart_category` AS C WHERE CI.product_id = '9' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000253915786743 sec) [CACHE WRITE]
[147] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '9' ; -- (0.000208854675293 sec) [CACHE WRITE]
[148] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000208854675293 sec) [CACHE READ]
[149] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '9' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000230073928833 sec) [CACHE WRITE]
[150] SELECT FOUND_ROWS() as Count; -- (0.000207901000977 sec) [NOT CACHED]
[151] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '9' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000207901000977 sec) [CACHE READ]
[152] SELECT CI.* , C.status FROM `psCubeCart_category_index` AS CI, `psCubeCart_category` AS C WHERE CI.product_id = '3' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000219821929932 sec) [CACHE WRITE]
[153] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '3' ; -- (0.00020694732666 sec) [CACHE WRITE]
[154] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.00020694732666 sec) [CACHE READ]
[155] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '3' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000235080718994 sec) [CACHE WRITE]
[156] SELECT FOUND_ROWS() as Count; -- (0.000227928161621 sec) [NOT CACHED]
[157] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '3' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000227928161621 sec) [CACHE READ]
[158] SELECT CI.* , C.status FROM `psCubeCart_category_index` AS CI, `psCubeCart_category` AS C WHERE CI.product_id = '38' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000221967697144 sec) [CACHE WRITE]
[159] SELECT `path` FROM `psCubeCart_seo_urls` WHERE psCubeCart_seo_urls.type = 'prod' AND psCubeCart_seo_urls.item_id = '38' ; -- (0.000151872634888 sec) [CACHE WRITE]
[160] SELECT `group_id` FROM `psCubeCart_customer_membership` WHERE psCubeCart_customer_membership.customer_id = '2' ; -- (0.000151872634888 sec) [CACHE READ]
[161] SELECT SQL_CALC_FOUND_ROWS * FROM `psCubeCart_pricing_group` WHERE psCubeCart_pricing_group.product_id = '38' AND `group_id` IN (3) ORDER BY `price` ASC LIMIT 1; -- (0.000151872634888 sec) [CACHE READ]
[162] SELECT `quantity`, `price` FROM `psCubeCart_pricing_quantity` WHERE psCubeCart_pricing_quantity.product_id = '38' AND `group_id` IN (3) ORDER BY `quantity` ASC, `price` ASC ; -- (0.000151872634888 sec) [CACHE READ]
Memory: Peak Usage / Max (%):
11.49MB / 128M (8.98%) Cache (File): Enabled
Cache Used: 449.28 KB of 521.91 KB (86.08%) [Clear Cache] Page Load Time:
-0.69212 seconds