Debug Output - /index.php?_a=basket
This can be disabled via "Store Settings" » "Advanced" (Tab) » "Enable Debugging".
PHP:
[Warning] /home/cambarga/public_html/classes/cart.class.php:1232 - Undefined array key "options_identifier"[Warning] /home/cambarga/public_html/classes/cubecart.class.php:660 - Undefined array key "billing_address"[Warning] /home/cambarga/public_html/classes/cubecart.class.php:660 - Trying to access array offset on value of type null GET:
'Before Sanitise:' =>
'_a' => basket
'After Sanitise:' =>
'_a' => basket
POST:
Empty SESSION:
'__client' =>
'ip_address' => 98.211.12.144
'useragent' => Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0
'session_start' => 1688595467
'session_last' => 1688595469
'currency' => USD
'admin_id' => 1
'language' => en-US
'__recaptcha' =>
'error' => The verification code was incorrect. Please try again.
'confirmed' =>
'__system' =>
'token_acp' => 01fb27c60fb90167ed34b6c74f779ed9
'recent_extensions' =>
'0' =>
'name' => Ideal Postcodes - Search as you type address finder
'url' => https://www.cubecart.com/extensions/plugins/ideal-postcodes-search-as-you-type-address-finder
'image' => https://www.cubecart.com//img/sellers/1/514/master.png
'price' => Free
'1' =>
'name' => Charge Anywhere Gateway
'url' => https://www.cubecart.com/extensions/payment-gateways/charge-anywhere-gateway
'image' => https://www.cubecart.com//img/noimage.png
'price' => Free
'2' =>
'name' => Amazing Yellow Responsive
'url' => https://www.cubecart.com/extensions/skins/amazing-yellow-responsive
'image' => https://www.cubecart.com//img/sellers/470/511/master.jpeg
'price' => $10.00
'3' =>
'name' => Amazing Blue Responsive
'url' => https://www.cubecart.com/extensions/skins/amazing-blue-responsive
'image' => https://www.cubecart.com//img/sellers/470/510/master.jpg
'price' => $10.00
'4' =>
'name' => PayPal Zettle POS System
'url' => https://www.cubecart.com/extensions/plugins/paypal-zettle-pos-system
'image' => https://www.cubecart.com//img/sellers/1/509/master.png
'price' => Free
'5' =>
'name' => Paymentsense - Connect-E
'url' => https://www.cubecart.com/extensions/payment-gateways/paymentsense-connect-e
'image' => https://www.cubecart.com//img/sellers/1/507/master.png
'price' => £40.00
'6' =>
'name' => Advanced Export
'url' => https://www.cubecart.com/extensions/plugins/advanced-export
'image' => https://www.cubecart.com//img/sellers/457/506/master.png
'price' => £25.00
'7' =>
'name' => Google Analytics for eCommerce
'url' => https://www.cubecart.com/extensions/plugins/google-analytics-for-ecommerce
'image' => https://www.cubecart.com//img/sellers/1/505/master.png
'price' => Free
'8' =>
'name' => gpwebpay
'url' => https://www.cubecart.com/extensions/payment-gateways/gpwebpay
'image' => https://www.cubecart.com//img/noimage.png
'price' => Free
'9' =>
'name' => Basix (Bootstrap Responsive Skin)
'url' => https://www.cubecart.com/extensions/skins/basix-bootstrap-responsive-skin
'image' => https://www.cubecart.com//img/sellers/1/440/master.png
'price' => Free
'10' =>
'name' => Amzin (Bootstrap Responsive Skin)
'url' => https://www.cubecart.com/extensions/skins/amzin-bootstrap-responsive-skin
'image' => https://www.cubecart.com//img/sellers/1/455/master.png
'price' => Free
'11' =>
'name' => CBurst (Bootstrap Responsive Skin)
'url' => https://www.cubecart.com/extensions/skins/cburst-bootstrap-responsive-skin
'image' => https://www.cubecart.com//img/sellers/1/467/master.jpg
'price' => Free
'rss_news' =>
'title' => News & Announcements Latest Topics
'link' => https://forums.cubecart.com/forum/1-news-announcements/
'description' => News & Announcements Latest Topics
'language' => en
'items' =>
'0' =>
'title' => CubeCart 6.5 Released - Featuring Search-as-you-type (Powered by Elasticsearch)
'link' => https://forums.cubecart.com/topic/58285-cubecart-65-released-featuring-search-as-you-type-powered-by-elasticsearch/
'1' =>
'title' => Are you still using an old version PayPal? How to check and why you need to upgrade..
'link' => https://forums.cubecart.com/topic/58262-are-you-still-using-an-old-version-paypal-how-to-check-and-why-you-need-to-upgrade/
'2' =>
'title' => CubeCart 6.4.10 Released
'link' => https://forums.cubecart.com/topic/58246-cubecart-6410-released/
'3' =>
'title' => Bring your in-store and online worlds together with Zettle and CubeCart
'link' => https://forums.cubecart.com/topic/58224-bring-your-in-store-and-online-worlds-together-with-zettle-and-cubecart/
'4' =>
'title' => CubeCart 6.4.9 Released
'link' => https://forums.cubecart.com/topic/58189-cubecart-649-released/
'token' => 1dfb43e0b9d99cf3db29c64601365700
'version_check' => 1
'CLEAR_CACHE' => 1
'__admin_data' =>
'admin_id' => 1
'customer_id' => 0
'status' => 1
'name' => Claudia Myers
'username' => cam
'new_password' => 1
'email' => cambarga@cambargainstore.com
'verify' =>
'logins' => 165
'super_user' => 1
'notes' =>
'failLevel' => 0
'blockTime' => 0
'lastTime' => 1688572692
'browser' => Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0
'ip_address' => 98.211.12.144
'language' => en-GB
'dashboard_notes' =>
'order_notify' => 1
'tour_shown' => 1
'__admin' =>
'user_language' => en-GB
'__paypal_commerce' =>
'reference_id' => 64a59699abc3b
'placement' => basket
'__basket' =>
'contents' =>
'e61c712fdaa06e55c5f3038dca6c7bf3' =>
'id' => 425
'quantity' => 1
'digital' => 0
'in_sale' => 0
'cost_price' => 0
'option_line_price' => 0
'total_price_each' => 11.99
'description' => Cook's Food Center, Inc.
147 First Ave. Tiffin, O.
Ph: 447-1466
( Tiffin, Ohio )
2-Way Ready-Opener for bottles and beverage cans
Double duty opens juice & beverage cans - Removes bottle caps
These bottle and can opener combos were promo
'name' => 1950s Cooks Food Center 2 Way Ready Opener with Sleeve
'product_code' => BCO-CFCTO
'product_weight' => 0.18
'product_width' =>
'product_height' =>
'product_depth' =>
'tax_each' =>
'tax_id' => 4
'amount' => 0
'tax_inclusive' =>
'tax_name' =>
'tax_percent' => 0
'option_absolute_price' =>
'weight' => 0.1800
'discount' => 0.00
'subtotal' => 11.99
'total_tax' => 0.00
'total' => 11.99
'delivery_address' =>
'postcode' => 40162
'country' => United States
'state' => Kentucky
'state_id' => 27
'country_id' => 840
'state_abbrev' => KY
'country_iso' => US
'country_iso3' => USA
'user_defined' =>
'estimate' =>
'billing_address' =>
'postcode' => 40162
'country' => United States
'state' => Kentucky
'state_id' => 27
'country_id' => 840
'state_abbrev' => KY
'country_iso' => US
'country_iso3' => USA
'user_defined' =>
'estimate' =>
'shipping' =>
'offset' => 1
'name' => Shipped Via:
'product' => USPS First Class
'value' => 4.81
'tax_id' => 999999
'tax' =>
'tax_id' => 999999
'amount' => 0.00
'tax_inclusive' => 0
'tax_name' => inherited
'tax_percent' => 0
'default_shipping_set' => 1
COOKIE:
'__zlcmid' => 1G5lr5Q2jrLqp1A
'_ga_YR5PL0Q1LD' => GS1.1.1688595426.134.0.1688595426.0.0.0
'_ga' => GA1.1.993836406.1685323118
'__atuvc' => 12|22
'__atssc' => facebook;1,twitter;1,pinterest;2
'CCS_C0D76961DD' => j40cj4gej3qnj9cm53ic6tcrt3
FILES:
Empty MySQLi
Queries (61):
1. Hack: 1688595469.04830 --- Duration: 366 µs [NOT CACHED]
SELECT * FROM `CubeCart_sessions` WHERE CubeCart_sessions.session_id = 'j40cj4gej3qnj9cm53ic6tcrt3' LIMIT 1;
2. Hack: 1688595469.05490 --- Duration: 366 µs [CACHE READ] --- Key: sql.b1155e0c8e0e57e48dc5f04d301ca22f
SELECT * FROM `CubeCart_domains` ;
3. Hack: 1688595469.05920 --- Duration: 366 µs [CACHE READ] --- Key: sql.c26bcc9929bd98be6ba307a3a2e8a3a5
SELECT * FROM `CubeCart_hooks` WHERE CubeCart_hooks.enabled = '1' ORDER BY `priority` ASC ;
4. Hack: 1688595469.05940 --- Duration: 366 µs [CACHE READ] --- Key: sql.e7d05ef4374f066a3efba2a3ea216f98
SELECT * FROM `CubeCart_code_snippet` WHERE CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ;
5. Hack: 1688595469.06160 --- Duration: 366 µs [CACHE READ] --- Key: sql.8b329e02580e6c58aa518a78581e1f81
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 WHERE S.type='cat' AND S.redirect='0' ORDER BY C.cat_id DESC
6. Hack: 1688595469.06170 --- Duration: 366 µs [CACHE READ] --- Key: sql.784fdb2b60fbad9a6a38eaeb084869e6
SELECT `cat_id`, `cat_name` FROM `CubeCart_category_language` WHERE CubeCart_category_language.language = 'en-US' ;
7. Hack: 1688595469.07150 --- Duration: 366 µs [CACHE READ] --- Key: sql.9f4d336ab38411ccee69d40e94301120
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'logos' LIMIT 1;
8. Hack: 1688595469.07160 --- Duration: 366 µs [CACHE READ] --- Key: sql.af89f6f3816e32effe2dc65a3b699ace
SELECT `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'logos' LIMIT 1;
9. Hack: 1688595469.07290 --- Duration: 366 µs [CACHE READ] --- Key: sql.a960d397b6231f673f9903b310ffe11d
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'google_analytics' LIMIT 1;
10. Hack: 1688595469.07300 --- Duration: 366 µs [CACHE READ] --- Key: sql.372825f50134d265afa1b1a1541f1cd9
SELECT `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'google_analytics' LIMIT 1;
11. Hack: 1688595469.07330 --- Duration: 366 µs [CACHE READ] --- Key: sql.7d71c4eee1369e6f70ea420478803257
SELECT `folder` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'livehelp' AND CubeCart_modules.status = '1' ;
12. Hack: 1688595469.07450 --- Duration: 366 µs [CACHE READ] --- Key: sql.4a35e7246b0ac1d1a04ebc1f28e7d0af
SELECT `name` FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.numcode = '840' ;
13. Hack: 1688595469.07550 --- Duration: 366 µs [CACHE READ] --- Key: sql.152ae680bad59457f2f433f300961382
SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.code = 'USD' ;
14. Hack: 1688595469.08080 --- Duration: 568 µs [NOT CACHED]
SELECT MIN(`live_from`) AS `next_time` FROM `CubeCart_inventory` WHERE `live_from` > UNIX_TIMESTAMP() LIMIT 1;
15. Hack: 1688595469.09380 --- Duration: 568 µs [CACHE READ] --- Key: sql.8d71d6b6c622fa0950087ac022d34ca2
SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '425' AND CI.cat_id = C.cat_id ORDER BY CI.primary DESC
16. Hack: 1688595469.09390 --- Duration: 568 µs [CACHE READ] --- Key: sql.313a3c2049e8fbbfa6d74042c24fd15b
SELECT * FROM `CubeCart_inventory` WHERE CubeCart_inventory.product_id = '425' AND CubeCart_inventory.status = '1' LIMIT 10 OFFSET 0;
17. Hack: 1688595469.09440 --- Duration: 343 µs [NOT CACHED]
SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `CubeCart_option_matrix` WHERE CubeCart_option_matrix.product_id = '425' AND CubeCart_option_matrix.options_identifier IS NULL AND CubeCart_option_matrix.status = '1' ;
18. Hack: 1688595469.09450 --- Duration: 343 µs [CACHE READ] --- Key: sql.589a50d3f67ea8910c24def69ec7d2f7
SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '425' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ;
19. Hack: 1688595469.09450 --- Duration: 343 µs [CACHE READ] --- Key: sql.313a3c2049e8fbbfa6d74042c24fd15b
SELECT * FROM `CubeCart_inventory` WHERE CubeCart_inventory.product_id = '425' AND CubeCart_inventory.status = '1' LIMIT 10 OFFSET 0;
20. Hack: 1688595469.09480 --- Duration: 194 µs [NOT CACHED]
SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `CubeCart_option_matrix` WHERE CubeCart_option_matrix.product_id = '425' AND CubeCart_option_matrix.options_identifier IS NULL AND CubeCart_option_matrix.status = '1' ;
21. Hack: 1688595469.09480 --- Duration: 194 µs [CACHE READ] --- Key: sql.589a50d3f67ea8910c24def69ec7d2f7
SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '425' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ;
22. Hack: 1688595469.10340 --- Duration: 8461 µs [ERROR - NOT CACHED]
INSERT INTO `CubeCart_system_error_log` (`message`,`url`,`backtrace`,`time`) VALUES ('[Warning] /home/cambarga/public_html/classes/cart.class.php:1232 - Undefined array key "options_identifier"','https://www.cambargainstore.com/index.php?_a=basket','update() (cart.class.php:1524) verifyBasket() (cubecart.class.php:657) _basket() (cubecart.class.php:377) loadPage() (controller.index.inc.php:90) include() (index.php:27) ','1688595469');
23. Hack: 1688595469.10370 --- Duration: 285 µs [NOT CACHED]
DELETE FROM `CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) ;
24. Hack: 1688595469.10410 --- Duration: 268 µs [NOT CACHED]
SELECT `stock_level` FROM `CubeCart_inventory` WHERE CubeCart_inventory.product_id = '425' LIMIT 1;
25. Hack: 1688595469.10540 --- Duration: 999 µs [ERROR - NOT CACHED]
INSERT INTO `CubeCart_system_error_log` (`message`,`url`,`backtrace`,`time`) VALUES ('[Warning] /home/cambarga/public_html/classes/cubecart.class.php:660 - Undefined array key "billing_address"','https://www.cambargainstore.com/index.php?_a=basket','_basket() (cubecart.class.php:377) loadPage() (controller.index.inc.php:90) include() (index.php:27) ','1688595469');
26. Hack: 1688595469.10560 --- Duration: 231 µs [NOT CACHED]
DELETE FROM `CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) ;
27. Hack: 1688595469.10670 --- Duration: 986 µs [ERROR - NOT CACHED]
INSERT INTO `CubeCart_system_error_log` (`message`,`url`,`backtrace`,`time`) VALUES ('[Warning] /home/cambarga/public_html/classes/cubecart.class.php:660 - Trying to access array offset on value of type null','https://www.cambargainstore.com/index.php?_a=basket','_basket() (cubecart.class.php:377) loadPage() (controller.index.inc.php:90) include() (index.php:27) ','1688595469');
28. Hack: 1688595469.10700 --- Duration: 236 µs [NOT CACHED]
DELETE FROM `CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) ;
29. Hack: 1688595469.10710 --- Duration: 236 µs [CACHE READ] --- Key: sql.6991e1252f6ab21b4d1d2ac9587b0641
SELECT * FROM `CubeCart_geo_country` WHERE status > 0 ORDER BY `name` ASC ;
30. Hack: 1688595469.10770 --- Duration: 236 µs [CACHE READ] --- Key: sql.f31b25ec3af777cb9200c44997fc06d2
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'Per_Category' LIMIT 1;
31. Hack: 1688595469.10780 --- Duration: 236 µs [CACHE READ] --- Key: sql.184cba32a2976699b1f7839da637f72c
SELECT 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 CubeCart_tax_rates AS R, CubeCart_tax_details AS D, CubeCart_tax_class AS T, CubeCart_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 = 840
32. Hack: 1688595469.10790 --- Duration: 236 µs [CACHE READ] --- Key: sql.313a3c2049e8fbbfa6d74042c24fd15b
SELECT * FROM `CubeCart_inventory` WHERE CubeCart_inventory.product_id = '425' AND CubeCart_inventory.status = '1' LIMIT 10 OFFSET 0;
33. Hack: 1688595469.10830 --- Duration: 359 µs [NOT CACHED]
SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `CubeCart_option_matrix` WHERE CubeCart_option_matrix.product_id = '425' AND CubeCart_option_matrix.options_identifier = '' AND CubeCart_option_matrix.status = '1' ;
34. Hack: 1688595469.10830 --- Duration: 359 µs [CACHE READ] --- Key: sql.589a50d3f67ea8910c24def69ec7d2f7
SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '425' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ;
35. Hack: 1688595469.10850 --- Duration: 359 µs [CACHE READ] --- Key: sql.02efc79352dc86869047c5977a6efc00
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'gift_certs' LIMIT 1;
36. Hack: 1688595469.10860 --- Duration: 359 µs [CACHE READ] --- Key: sql.6ed081b1fe72b2c2a9e8d7f15371e897
SELECT * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '425' ORDER BY `main_img` DESC LIMIT 1;
37. Hack: 1688595469.10870 --- Duration: 359 µs [CACHE READ] --- Key: sql.6ed081b1fe72b2c2a9e8d7f15371e897
SELECT * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '425' ORDER BY `main_img` DESC LIMIT 1;
38. Hack: 1688595469.10880 --- Duration: 359 µs [CACHE READ] --- Key: sql.f623be8ce6f8c8f3ffbb92e7e50e5b3f
SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2418' ;
39. Hack: 1688595469.10940 --- Duration: 419 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '425' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
40. Hack: 1688595469.10960 --- Duration: 419 µs [CACHE READ] --- Key: sql.c98d5a94d0f670c8eedc290bf1f7e4db
SELECT `folder`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'shipping' AND CubeCart_modules.status = '1' ORDER BY `position` asc ;
41. Hack: 1688595469.10960 --- Duration: 419 µs [CACHE READ] --- Key: sql.57cbb1051c60a3418b659cb939c06ae8
SELECT `id` FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.numcode = '840' ;
42. Hack: 1688595469.10970 --- Duration: 419 µs [CACHE READ] --- Key: sql.04c9decbab506f419da58e6ffb133511
SELECT * FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.id = '226' AND CubeCart_geo_country.status = '1' ;
43. Hack: 1688595469.10990 --- Duration: 419 µs [CACHE READ] --- Key: sql.9f6899e0cc5ecd1f0060a07d9e0d1ad6
SELECT * FROM `CubeCart_geo_zone` WHERE CubeCart_geo_zone.id = '27' AND CubeCart_geo_zone.status = '1' ;
44. Hack: 1688595469.10990 --- Duration: 419 µs [CACHE READ] --- Key: sql.4a35e7246b0ac1d1a04ebc1f28e7d0af
SELECT `name` FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.numcode = '840' ;
45. Hack: 1688595469.10990 --- Duration: 419 µs [CACHE READ] --- Key: sql.9f6899e0cc5ecd1f0060a07d9e0d1ad6
SELECT * FROM `CubeCart_geo_zone` WHERE CubeCart_geo_zone.id = '27' AND CubeCart_geo_zone.status = '1' ;
46. Hack: 1688595469.11000 --- Duration: 419 µs [CACHE READ] --- Key: sql.45408f4b8b0fc57d6e326e212e96e3ed
SELECT `iso` FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.numcode = '840' ;
47. Hack: 1688595469.11010 --- Duration: 419 µs [CACHE READ] --- Key: sql.3bf21cabb871544b74eca63a995cb919
SELECT `iso3` FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.numcode = '840' ;
48. Hack: 1688595469.11010 --- Duration: 419 µs [CACHE READ] --- Key: sql.9f6899e0cc5ecd1f0060a07d9e0d1ad6
SELECT * FROM `CubeCart_geo_zone` WHERE CubeCart_geo_zone.id = '27' AND CubeCart_geo_zone.status = '1' ;
49. Hack: 1688595469.11020 --- Duration: 419 µs [CACHE READ] --- Key: sql.c7e2eeda81fb6fce699fe067468b243f
SELECT `status` FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.iso = 'US' ;
50. Hack: 1688595469.11020 --- Duration: 419 µs [CACHE READ] --- Key: sql.57cbb1051c60a3418b659cb939c06ae8
SELECT `id` FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.numcode = '840' ;
51. Hack: 1688595469.11020 --- Duration: 419 µs [CACHE READ] --- Key: sql.04c9decbab506f419da58e6ffb133511
SELECT * FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.id = '226' AND CubeCart_geo_country.status = '1' ;
52. Hack: 1688595469.11020 --- Duration: 419 µs [CACHE READ] --- Key: sql.9f6899e0cc5ecd1f0060a07d9e0d1ad6
SELECT * FROM `CubeCart_geo_zone` WHERE CubeCart_geo_zone.id = '27' AND CubeCart_geo_zone.status = '1' ;
53. Hack: 1688595469.11030 --- Duration: 419 µs [CACHE READ] --- Key: sql.4a35e7246b0ac1d1a04ebc1f28e7d0af
SELECT `name` FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.numcode = '840' ;
54. Hack: 1688595469.11030 --- Duration: 419 µs [CACHE READ] --- Key: sql.9f6899e0cc5ecd1f0060a07d9e0d1ad6
SELECT * FROM `CubeCart_geo_zone` WHERE CubeCart_geo_zone.id = '27' AND CubeCart_geo_zone.status = '1' ;
55. Hack: 1688595469.11030 --- Duration: 419 µs [CACHE READ] --- Key: sql.45408f4b8b0fc57d6e326e212e96e3ed
SELECT `iso` FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.numcode = '840' ;
56. Hack: 1688595469.11030 --- Duration: 419 µs [CACHE READ] --- Key: sql.3bf21cabb871544b74eca63a995cb919
SELECT `iso3` FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.numcode = '840' ;
57. Hack: 1688595469.11030 --- Duration: 419 µs [CACHE READ] --- Key: sql.9f6899e0cc5ecd1f0060a07d9e0d1ad6
SELECT * FROM `CubeCart_geo_zone` WHERE CubeCart_geo_zone.id = '27' AND CubeCart_geo_zone.status = '1' ;
58. Hack: 1688595469.11040 --- Duration: 419 µs [CACHE READ] --- Key: sql.30761e67a50c02194e89b23055e24e75
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'All_In_One_Shipping' LIMIT 1;
59. Hack: 1688595469.11050 --- Duration: 419 µs [CACHE READ] --- Key: sql.3489cb14f101c9167ce56948d2400cea
SELECT `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'All_In_One_Shipping' LIMIT 1;
60. Hack: 1688595469.11170 --- Duration: 419 µs [CACHE READ] --- Key: sql.c0006ab57e1b2e0dfac0fb776ebd7c66
SELECT * FROM `CubeCart_shipping_zones` ORDER BY sort_order, id ;
61. Hack: 1688595469.11420 --- Duration: 419 µs [CACHE READ] --- Key: sql.66555e33bff436ecd8b5d4d71f777bb6
SELECT * FROM `CubeCart_shipping_rates` ORDER BY zone_id, id ;
Memory: Peak Usage / Max (%):
8.5MB / 512M (1.66%) Cache (File): Enabled
Cache Used: 879.16kB of 2.77MB (31.05%)
Hits: 68 / 1451 [Clear Cache] Page Load Time:
0.076932907104492 seconds
Debug Output - /index.php?_a=basket
This can be disabled via "Store Settings" » "Advanced" (Tab) » "Enable Debugging".
PHP:
[Warning] /home/cambarga/public_html/classes/cart.class.php:1232 - Undefined array key "options_identifier"[Warning] /home/cambarga/public_html/classes/tax.class.php:135 - Undefined variable $basket_taxes[Warning] /home/cambarga/public_html/classes/tax.class.php:136 - Undefined variable $display_taxes[Warning] /home/cambarga/public_html/classes/cubecart.class.php:2344 - Undefined array key "scope" GET:
'Before Sanitise:' =>
'_a' => basket
'After Sanitise:' =>
'_a' => basket
POST:
Empty SESSION:
'__client' =>
'ip_address' => 98.211.12.144
'useragent' => Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0
'session_start' => 1688595469
'session_last' => 1688595469
'currency' => USD
'admin_id' => 1
'language' => en-US
'__recaptcha' =>
'error' => The verification code was incorrect. Please try again.
'confirmed' =>
'__system' =>
'token_acp' => 01fb27c60fb90167ed34b6c74f779ed9
'recent_extensions' =>
'0' =>
'name' => Ideal Postcodes - Search as you type address finder
'url' => https://www.cubecart.com/extensions/plugins/ideal-postcodes-search-as-you-type-address-finder
'image' => https://www.cubecart.com//img/sellers/1/514/master.png
'price' => Free
'1' =>
'name' => Charge Anywhere Gateway
'url' => https://www.cubecart.com/extensions/payment-gateways/charge-anywhere-gateway
'image' => https://www.cubecart.com//img/noimage.png
'price' => Free
'2' =>
'name' => Amazing Yellow Responsive
'url' => https://www.cubecart.com/extensions/skins/amazing-yellow-responsive
'image' => https://www.cubecart.com//img/sellers/470/511/master.jpeg
'price' => $10.00
'3' =>
'name' => Amazing Blue Responsive
'url' => https://www.cubecart.com/extensions/skins/amazing-blue-responsive
'image' => https://www.cubecart.com//img/sellers/470/510/master.jpg
'price' => $10.00
'4' =>
'name' => PayPal Zettle POS System
'url' => https://www.cubecart.com/extensions/plugins/paypal-zettle-pos-system
'image' => https://www.cubecart.com//img/sellers/1/509/master.png
'price' => Free
'5' =>
'name' => Paymentsense - Connect-E
'url' => https://www.cubecart.com/extensions/payment-gateways/paymentsense-connect-e
'image' => https://www.cubecart.com//img/sellers/1/507/master.png
'price' => £40.00
'6' =>
'name' => Advanced Export
'url' => https://www.cubecart.com/extensions/plugins/advanced-export
'image' => https://www.cubecart.com//img/sellers/457/506/master.png
'price' => £25.00
'7' =>
'name' => Google Analytics for eCommerce
'url' => https://www.cubecart.com/extensions/plugins/google-analytics-for-ecommerce
'image' => https://www.cubecart.com//img/sellers/1/505/master.png
'price' => Free
'8' =>
'name' => gpwebpay
'url' => https://www.cubecart.com/extensions/payment-gateways/gpwebpay
'image' => https://www.cubecart.com//img/noimage.png
'price' => Free
'9' =>
'name' => Basix (Bootstrap Responsive Skin)
'url' => https://www.cubecart.com/extensions/skins/basix-bootstrap-responsive-skin
'image' => https://www.cubecart.com//img/sellers/1/440/master.png
'price' => Free
'10' =>
'name' => Amzin (Bootstrap Responsive Skin)
'url' => https://www.cubecart.com/extensions/skins/amzin-bootstrap-responsive-skin
'image' => https://www.cubecart.com//img/sellers/1/455/master.png
'price' => Free
'11' =>
'name' => CBurst (Bootstrap Responsive Skin)
'url' => https://www.cubecart.com/extensions/skins/cburst-bootstrap-responsive-skin
'image' => https://www.cubecart.com//img/sellers/1/467/master.jpg
'price' => Free
'rss_news' =>
'title' => News & Announcements Latest Topics
'link' => https://forums.cubecart.com/forum/1-news-announcements/
'description' => News & Announcements Latest Topics
'language' => en
'items' =>
'0' =>
'title' => CubeCart 6.5 Released - Featuring Search-as-you-type (Powered by Elasticsearch)
'link' => https://forums.cubecart.com/topic/58285-cubecart-65-released-featuring-search-as-you-type-powered-by-elasticsearch/
'1' =>
'title' => Are you still using an old version PayPal? How to check and why you need to upgrade..
'link' => https://forums.cubecart.com/topic/58262-are-you-still-using-an-old-version-paypal-how-to-check-and-why-you-need-to-upgrade/
'2' =>
'title' => CubeCart 6.4.10 Released
'link' => https://forums.cubecart.com/topic/58246-cubecart-6410-released/
'3' =>
'title' => Bring your in-store and online worlds together with Zettle and CubeCart
'link' => https://forums.cubecart.com/topic/58224-bring-your-in-store-and-online-worlds-together-with-zettle-and-cubecart/
'4' =>
'title' => CubeCart 6.4.9 Released
'link' => https://forums.cubecart.com/topic/58189-cubecart-649-released/
'token' => 1dfb43e0b9d99cf3db29c64601365700
'version_check' => 1
'CLEAR_CACHE' => 1
'__admin_data' =>
'admin_id' => 1
'customer_id' => 0
'status' => 1
'name' => Claudia Myers
'username' => cam
'new_password' => 1
'email' => cambarga@cambargainstore.com
'verify' =>
'logins' => 165
'super_user' => 1
'notes' =>
'failLevel' => 0
'blockTime' => 0
'lastTime' => 1688572692
'browser' => Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0
'ip_address' => 98.211.12.144
'language' => en-GB
'dashboard_notes' =>
'order_notify' => 1
'tour_shown' => 1
'__admin' =>
'user_language' => en-GB
'__paypal_commerce' =>
'reference_id' => 64a59699abc3b
'placement' => basket
'__basket' =>
'contents' =>
'e61c712fdaa06e55c5f3038dca6c7bf3' =>
'id' => 425
'quantity' => 1
'digital' => 0
'in_sale' => 0
'cost_price' => 0
'option_line_price' => 0
'total_price_each' => 11.99
'description' => Cook's Food Center, Inc.
147 First Ave. Tiffin, O.
Ph: 447-1466
( Tiffin, Ohio )
2-Way Ready-Opener for bottles and beverage cans
Double duty opens juice & beverage cans - Removes bottle caps
These bottle and can opener combos were promo
'name' => 1950s Cooks Food Center 2 Way Ready Opener with Sleeve
'product_code' => BCO-CFCTO
'product_weight' => 0.18
'product_width' =>
'product_height' =>
'product_depth' =>
'tax_each' =>
'tax_id' => 4
'amount' => 0
'tax_inclusive' =>
'tax_name' =>
'tax_percent' => 0
'option_absolute_price' =>
'weight' => 0.1800
'discount' => 0.00
'subtotal' => 11.99
'total_tax' => 0.00
'total' => 16.80
'delivery_address' =>
'postcode' => 40162
'country' => United States
'state' => Kentucky
'state_id' => 27
'country_id' => 840
'state_abbrev' => KY
'country_iso' => US
'country_iso3' => USA
'user_defined' =>
'estimate' =>
'billing_address' =>
'postcode' => 40162
'country' => United States
'state' => Kentucky
'state_id' => 27
'country_id' => 840
'state_abbrev' => KY
'country_iso' => US
'country_iso3' => USA
'user_defined' =>
'estimate' =>
'shipping' =>
'offset' => 1
'name' => Shipped Via:
'product' => USPS First Class
'value' => 4.81
'tax_id' => 999999
'tax' =>
'tax_id' => 999999
'amount' => 0.00
'tax_inclusive' => 0
'tax_name' => inherited
'tax_percent' => 0
'default_shipping_set' => 1
'shipping_hash' => 00c48246b2bf45240d1de0bd9bb2b63f
'order_taxes' =>
COOKIE:
'__zlcmid' => 1G5lr5Q2jrLqp1A
'_ga_YR5PL0Q1LD' => GS1.1.1688595426.134.0.1688595426.0.0.0
'_ga' => GA1.1.993836406.1685323118
'__atuvc' => 12|22
'__atssc' => facebook;1,twitter;1,pinterest;2
'CCS_C0D76961DD' => j40cj4gej3qnj9cm53ic6tcrt3
FILES:
Empty MySQLi
Queries (90):
1. Hack: 1688595469.28090 --- Duration: 333 µs [NOT CACHED]
SELECT * FROM `CubeCart_sessions` WHERE CubeCart_sessions.session_id = 'j40cj4gej3qnj9cm53ic6tcrt3' LIMIT 1;
2. Hack: 1688595469.28750 --- Duration: 333 µs [CACHE READ] --- Key: sql.b1155e0c8e0e57e48dc5f04d301ca22f
SELECT * FROM `CubeCart_domains` ;
3. Hack: 1688595469.29190 --- Duration: 333 µs [CACHE READ] --- Key: sql.c26bcc9929bd98be6ba307a3a2e8a3a5
SELECT * FROM `CubeCart_hooks` WHERE CubeCart_hooks.enabled = '1' ORDER BY `priority` ASC ;
4. Hack: 1688595469.29210 --- Duration: 333 µs [CACHE READ] --- Key: sql.e7d05ef4374f066a3efba2a3ea216f98
SELECT * FROM `CubeCart_code_snippet` WHERE CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ;
5. Hack: 1688595469.29430 --- Duration: 333 µs [CACHE READ] --- Key: sql.8b329e02580e6c58aa518a78581e1f81
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 WHERE S.type='cat' AND S.redirect='0' ORDER BY C.cat_id DESC
6. Hack: 1688595469.29440 --- Duration: 333 µs [CACHE READ] --- Key: sql.784fdb2b60fbad9a6a38eaeb084869e6
SELECT `cat_id`, `cat_name` FROM `CubeCart_category_language` WHERE CubeCart_category_language.language = 'en-US' ;
7. Hack: 1688595469.30350 --- Duration: 333 µs [CACHE READ] --- Key: sql.9f4d336ab38411ccee69d40e94301120
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'logos' LIMIT 1;
8. Hack: 1688595469.30370 --- Duration: 333 µs [CACHE READ] --- Key: sql.af89f6f3816e32effe2dc65a3b699ace
SELECT `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'logos' LIMIT 1;
9. Hack: 1688595469.30500 --- Duration: 333 µs [CACHE READ] --- Key: sql.a960d397b6231f673f9903b310ffe11d
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'google_analytics' LIMIT 1;
10. Hack: 1688595469.30510 --- Duration: 333 µs [CACHE READ] --- Key: sql.372825f50134d265afa1b1a1541f1cd9
SELECT `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'google_analytics' LIMIT 1;
11. Hack: 1688595469.30540 --- Duration: 333 µs [CACHE READ] --- Key: sql.7d71c4eee1369e6f70ea420478803257
SELECT `folder` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'livehelp' AND CubeCart_modules.status = '1' ;
12. Hack: 1688595469.30660 --- Duration: 333 µs [CACHE READ] --- Key: sql.4a35e7246b0ac1d1a04ebc1f28e7d0af
SELECT `name` FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.numcode = '840' ;
13. Hack: 1688595469.30760 --- Duration: 333 µs [CACHE READ] --- Key: sql.152ae680bad59457f2f433f300961382
SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.code = 'USD' ;
14. Hack: 1688595469.31290 --- Duration: 531 µs [NOT CACHED]
SELECT MIN(`live_from`) AS `next_time` FROM `CubeCart_inventory` WHERE `live_from` > UNIX_TIMESTAMP() LIMIT 1;
15. Hack: 1688595469.32570 --- Duration: 531 µs [CACHE READ] --- Key: sql.8d71d6b6c622fa0950087ac022d34ca2
SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '425' AND CI.cat_id = C.cat_id ORDER BY CI.primary DESC
16. Hack: 1688595469.32580 --- Duration: 531 µs [CACHE READ] --- Key: sql.313a3c2049e8fbbfa6d74042c24fd15b
SELECT * FROM `CubeCart_inventory` WHERE CubeCart_inventory.product_id = '425' AND CubeCart_inventory.status = '1' LIMIT 10 OFFSET 0;
17. Hack: 1688595469.32630 --- Duration: 386 µs [NOT CACHED]
SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `CubeCart_option_matrix` WHERE CubeCart_option_matrix.product_id = '425' AND CubeCart_option_matrix.options_identifier IS NULL AND CubeCart_option_matrix.status = '1' ;
18. Hack: 1688595469.32640 --- Duration: 386 µs [CACHE READ] --- Key: sql.589a50d3f67ea8910c24def69ec7d2f7
SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '425' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ;
19. Hack: 1688595469.32650 --- Duration: 386 µs [CACHE READ] --- Key: sql.313a3c2049e8fbbfa6d74042c24fd15b
SELECT * FROM `CubeCart_inventory` WHERE CubeCart_inventory.product_id = '425' AND CubeCart_inventory.status = '1' LIMIT 10 OFFSET 0;
20. Hack: 1688595469.32670 --- Duration: 192 µs [NOT CACHED]
SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `CubeCart_option_matrix` WHERE CubeCart_option_matrix.product_id = '425' AND CubeCart_option_matrix.options_identifier IS NULL AND CubeCart_option_matrix.status = '1' ;
21. Hack: 1688595469.32680 --- Duration: 192 µs [CACHE READ] --- Key: sql.589a50d3f67ea8910c24def69ec7d2f7
SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '425' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ;
22. Hack: 1688595469.33930 --- Duration: 12383 µs [ERROR - NOT CACHED]
INSERT INTO `CubeCart_system_error_log` (`message`,`url`,`backtrace`,`time`) VALUES ('[Warning] /home/cambarga/public_html/classes/cart.class.php:1232 - Undefined array key "options_identifier"','https://www.cambargainstore.com/index.php?_a=basket','update() (cart.class.php:1524) verifyBasket() (cubecart.class.php:657) _basket() (cubecart.class.php:377) loadPage() (controller.index.inc.php:90) include() (index.php:27) ','1688595469');
23. Hack: 1688595469.33960 --- Duration: 321 µs [NOT CACHED]
DELETE FROM `CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) ;
24. Hack: 1688595469.34000 --- Duration: 301 µs [NOT CACHED]
SELECT `stock_level` FROM `CubeCart_inventory` WHERE CubeCart_inventory.product_id = '425' LIMIT 1;
25. Hack: 1688595469.34040 --- Duration: 301 µs [CACHE READ] --- Key: sql.6991e1252f6ab21b4d1d2ac9587b0641
SELECT * FROM `CubeCart_geo_country` WHERE status > 0 ORDER BY `name` ASC ;
26. Hack: 1688595469.34100 --- Duration: 301 µs [CACHE READ] --- Key: sql.f31b25ec3af777cb9200c44997fc06d2
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'Per_Category' LIMIT 1;
27. Hack: 1688595469.34110 --- Duration: 301 µs [CACHE READ] --- Key: sql.184cba32a2976699b1f7839da637f72c
SELECT 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 CubeCart_tax_rates AS R, CubeCart_tax_details AS D, CubeCart_tax_class AS T, CubeCart_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 = 840
28. Hack: 1688595469.34120 --- Duration: 301 µs [CACHE READ] --- Key: sql.313a3c2049e8fbbfa6d74042c24fd15b
SELECT * FROM `CubeCart_inventory` WHERE CubeCart_inventory.product_id = '425' AND CubeCart_inventory.status = '1' LIMIT 10 OFFSET 0;
29. Hack: 1688595469.34160 --- Duration: 370 µs [NOT CACHED]
SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `CubeCart_option_matrix` WHERE CubeCart_option_matrix.product_id = '425' AND CubeCart_option_matrix.options_identifier = '' AND CubeCart_option_matrix.status = '1' ;
30. Hack: 1688595469.34160 --- Duration: 370 µs [CACHE READ] --- Key: sql.589a50d3f67ea8910c24def69ec7d2f7
SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '425' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ;
31. Hack: 1688595469.34180 --- Duration: 370 µs [CACHE READ] --- Key: sql.02efc79352dc86869047c5977a6efc00
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'gift_certs' LIMIT 1;
32. Hack: 1688595469.34190 --- Duration: 370 µs [CACHE READ] --- Key: sql.6ed081b1fe72b2c2a9e8d7f15371e897
SELECT * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '425' ORDER BY `main_img` DESC LIMIT 1;
33. Hack: 1688595469.34200 --- Duration: 370 µs [CACHE READ] --- Key: sql.6ed081b1fe72b2c2a9e8d7f15371e897
SELECT * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '425' ORDER BY `main_img` DESC LIMIT 1;
34. Hack: 1688595469.34210 --- Duration: 370 µs [CACHE READ] --- Key: sql.f623be8ce6f8c8f3ffbb92e7e50e5b3f
SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2418' ;
35. Hack: 1688595469.34280 --- Duration: 455 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '425' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
36. Hack: 1688595469.34290 --- Duration: 455 µs [CACHE READ] --- Key: sql.c98d5a94d0f670c8eedc290bf1f7e4db
SELECT `folder`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'shipping' AND CubeCart_modules.status = '1' ORDER BY `position` asc ;
37. Hack: 1688595469.34300 --- Duration: 455 µs [CACHE READ] --- Key: sql.c7e2eeda81fb6fce699fe067468b243f
SELECT `status` FROM `CubeCart_geo_country` WHERE CubeCart_geo_country.iso = 'US' ;
38. Hack: 1688595469.34310 --- Duration: 455 µs [CACHE READ] --- Key: sql.30761e67a50c02194e89b23055e24e75
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'All_In_One_Shipping' LIMIT 1;
39. Hack: 1688595469.34320 --- Duration: 455 µs [CACHE READ] --- Key: sql.3489cb14f101c9167ce56948d2400cea
SELECT `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'All_In_One_Shipping' LIMIT 1;
40. Hack: 1688595469.34430 --- Duration: 455 µs [CACHE READ] --- Key: sql.c0006ab57e1b2e0dfac0fb776ebd7c66
SELECT * FROM `CubeCart_shipping_zones` ORDER BY sort_order, id ;
41. Hack: 1688595469.34700 --- Duration: 455 µs [CACHE READ] --- Key: sql.66555e33bff436ecd8b5d4d71f777bb6
SELECT * FROM `CubeCart_shipping_rates` ORDER BY zone_id, id ;
42. Hack: 1688595469.36140 --- Duration: 11338 µs [ERROR - NOT CACHED]
INSERT INTO `CubeCart_system_error_log` (`message`,`url`,`backtrace`,`time`) VALUES ('[Warning] /home/cambarga/public_html/classes/tax.class.php:135 - Undefined variable $basket_taxes','https://www.cambargainstore.com/index.php?_a=basket','displayTaxes() (cubecart.class.php:1892) _displayBasket() (cubecart.class.php:770) _basket() (cubecart.class.php:377) loadPage() (controller.index.inc.php:90) include() (index.php:27) ','1688595469');
43. Hack: 1688595469.36170 --- Duration: 270 µs [NOT CACHED]
DELETE FROM `CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) ;
44. Hack: 1688595469.36290 --- Duration: 1094 µs [ERROR - NOT CACHED]
INSERT INTO `CubeCart_system_error_log` (`message`,`url`,`backtrace`,`time`) VALUES ('[Warning] /home/cambarga/public_html/classes/tax.class.php:136 - Undefined variable $display_taxes','https://www.cambargainstore.com/index.php?_a=basket','displayTaxes() (cubecart.class.php:1892) _displayBasket() (cubecart.class.php:770) _basket() (cubecart.class.php:377) loadPage() (controller.index.inc.php:90) include() (index.php:27) ','1688595469');
45. Hack: 1688595469.36320 --- Duration: 225 µs [NOT CACHED]
DELETE FROM `CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) ;
46. Hack: 1688595469.36330 --- Duration: 225 µs [CACHE READ] --- Key: sql.ace97a921b3de4308ecd1d9578f63049
SELECT * FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'gateway' AND CubeCart_modules.status = '1' ORDER BY `position` ASC ;
47. Hack: 1688595469.36370 --- Duration: 225 µs [CACHE READ] --- Key: sql.36427162e9783c99de7f346f0ea01ecc
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'paypal_commerce' LIMIT 1;
48. Hack: 1688595469.36380 --- Duration: 225 µs [CACHE READ] --- Key: sql.8e99d62b1015440d8bea436853722e5c
SELECT `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'paypal_commerce' LIMIT 1;
49. Hack: 1688595469.36500 --- Duration: 961 µs [ERROR - NOT CACHED]
INSERT INTO `CubeCart_system_error_log` (`message`,`url`,`backtrace`,`time`) VALUES ('[Warning] /home/cambarga/public_html/classes/cubecart.class.php:2344 - Undefined array key "scope"','https://www.cambargainstore.com/index.php?_a=basket','_listPaymentOptions() (cubecart.class.php:1900) _displayBasket() (cubecart.class.php:770) _basket() (cubecart.class.php:377) loadPage() (controller.index.inc.php:90) include() (index.php:27) ','1688595469');
50. Hack: 1688595469.36520 --- Duration: 213 µs [NOT CACHED]
DELETE FROM `CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) ;
51. Hack: 1688595469.36800 --- Duration: 213 µs [CACHE READ] --- Key: sql.313a3c2049e8fbbfa6d74042c24fd15b
SELECT * FROM `CubeCart_inventory` WHERE CubeCart_inventory.product_id = '425' AND CubeCart_inventory.status = '1' LIMIT 10 OFFSET 0;
52. Hack: 1688595469.36830 --- Duration: 251 µs [NOT CACHED]
SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `CubeCart_option_matrix` WHERE CubeCart_option_matrix.product_id = '425' AND CubeCart_option_matrix.options_identifier IS NULL AND CubeCart_option_matrix.status = '1' ;
53. Hack: 1688595469.36840 --- Duration: 251 µs [CACHE READ] --- Key: sql.589a50d3f67ea8910c24def69ec7d2f7
SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '425' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ;
54. Hack: 1688595469.36850 --- Duration: 251 µs [CACHE READ] --- Key: sql.27f7cbaecfa684047b917631ecb9c41b
SELECT COUNT(*) AS Count FROM `CubeCart_modules` WHERE CubeCart_modules.status = '1' AND CubeCart_modules.module = 'gateway';
55. Hack: 1688595469.36860 --- Duration: 251 µs [CACHE READ] --- Key: sql.22de32a30b55c02d27c55cd7c9a760fb
SELECT DISTINCT `cart_order_id` FROM `CubeCart_order_inventory` WHERE `product_id` IN (425) GROUP BY `cart_order_id` ORDER BY `id` DESC LIMIT 30;
56. Hack: 1688595469.36870 --- Duration: 251 µs [CACHE READ] --- Key: sql.9d9a3fac9f41ed68c542d1e042bf00e5
SELECT DISTINCT `product_id` FROM `CubeCart_order_inventory` WHERE `cart_order_id` IN ('230523-110310-2261') AND `product_id` NOT IN (425) GROUP BY `product_id` LIMIT 10;
57. Hack: 1688595469.37150 --- Duration: 251 µs [CACHE READ] --- Key: sql.cc848f7da1b2744f4b26e930a01f7b83
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'languages' LIMIT 1;
58. Hack: 1688595469.37160 --- Duration: 251 µs [CACHE READ] --- Key: sql.40a3788bfc051bc2f7f2e82eb8947680
SELECT `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'languages' LIMIT 1;
59. Hack: 1688595469.37170 --- Duration: 251 µs [CACHE READ] --- Key: sql.aef541648e9e4c57ae0f797f4ab71b65
SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.active = '1' ;
60. Hack: 1688595469.37250 --- Duration: 372 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'login' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
61. Hack: 1688595469.37280 --- Duration: 266 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'register' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
62. Hack: 1688595469.37380 --- Duration: 337 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'search' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
63. Hack: 1688595469.37470 --- Duration: 337 µs [CACHE READ] --- Key: sql.61fb3e780a7a6d8010435704ef64effd
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 ;
64. Hack: 1688595469.37510 --- Duration: 379 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'doc' AND CubeCart_seo_urls.item_id = '2' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
65. Hack: 1688595469.37560 --- Duration: 359 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'doc' AND CubeCart_seo_urls.item_id = '4' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
66. Hack: 1688595469.37600 --- Duration: 330 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'doc' AND CubeCart_seo_urls.item_id = '7' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
67. Hack: 1688595469.37650 --- Duration: 359 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'doc' AND CubeCart_seo_urls.item_id = '5' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
68. Hack: 1688595469.37690 --- Duration: 327 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'doc' AND CubeCart_seo_urls.item_id = '8' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
69. Hack: 1688595469.37740 --- Duration: 339 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'doc' AND CubeCart_seo_urls.item_id = '6' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
70. Hack: 1688595469.37780 --- Duration: 309 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'doc' AND CubeCart_seo_urls.item_id = '3' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
71. Hack: 1688595469.37790 --- Duration: 309 µs [CACHE READ] --- Key: sql.5b7c8d4717857e4525cef259983ba057
SELECT `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'Contact_Form' LIMIT 1;
72. Hack: 1688595469.37800 --- Duration: 309 µs [CACHE READ] --- Key: sql.21727de72e83418f54a00ec8e9863139
SELECT `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'Contact_Form' LIMIT 1;
73. Hack: 1688595469.37830 --- Duration: 255 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'contact' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
74. Hack: 1688595469.37870 --- Duration: 255 µs [CACHE READ] --- Key: sql.94ec2e533e92ea5009cd2509fdeda625
SELECT product_id FROM `CubeCart_inventory` WHERE CubeCart_inventory.status = '1' AND CubeCart_inventory.featured = '1' ;
75. Hack: 1688595469.37890 --- Duration: 255 µs [CACHE READ] --- Key: sql.f95ccc7ebb95973f4b756a23c767d8c5
SELECT `name`, `product_id`, `quantity`, `price`, `sale_price`, `tax_type`, `tax_inclusive` FROM `CubeCart_inventory` WHERE CubeCart_inventory.status = '1' ORDER BY popularity DESC LIMIT 3;
76. Hack: 1688595469.37900 --- Duration: 255 µs [CACHE READ] --- Key: sql.da640103d0b2c6458b053e58bb1a7bff
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.primary DESC
77. Hack: 1688595469.37930 --- Duration: 284 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '8' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
78. Hack: 1688595469.37940 --- Duration: 284 µs [CACHE READ] --- Key: sql.6416483a3c8bdc8e87c161c82df18cfc
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 ;
79. Hack: 1688595469.37950 --- Duration: 284 µs [CACHE READ] --- Key: sql.9ec2388d974d380695b352a2c670e519
SELECT * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '8' ORDER BY `main_img` DESC LIMIT 1;
80. Hack: 1688595469.37960 --- Duration: 284 µs [CACHE READ] --- Key: sql.f9200a05239fff25f14858ce08c23848
SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '27' ;
81. Hack: 1688595469.37970 --- Duration: 284 µs [CACHE READ] --- Key: sql.ce26d38e2ca66b44c0dd0b5fc4a61f7e
SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '81' AND CI.cat_id = C.cat_id ORDER BY CI.primary DESC
82. Hack: 1688595469.38010 --- Duration: 294 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '81' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
83. Hack: 1688595469.38020 --- Duration: 294 µs [CACHE READ] --- Key: sql.7e89ed579e6028e0db8982072565fa19
SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '81' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ;
84. Hack: 1688595469.38030 --- Duration: 294 µs [CACHE READ] --- Key: sql.8ef454a0a6e637ced492051681e08317
SELECT * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '81' ORDER BY `main_img` DESC LIMIT 1;
85. Hack: 1688595469.38040 --- Duration: 294 µs [CACHE READ] --- Key: sql.ca4ab82cd30a04d83b993fd0fc30d36a
SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '502' ;
86. Hack: 1688595469.38050 --- Duration: 294 µs [CACHE READ] --- Key: sql.a9b15abdce9245685e7f1808d808268f
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.primary DESC
87. Hack: 1688595469.38080 --- Duration: 266 µs [NOT CACHED]
SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '29' AND CubeCart_seo_urls.redirect = '0' LIMIT 1;
88. Hack: 1688595469.38090 --- Duration: 266 µs [CACHE READ] --- Key: sql.5dd7a8bc408ccdd55f687af30a2d47f0
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 ;
89. Hack: 1688595469.38100 --- Duration: 266 µs [CACHE READ] --- Key: sql.c4b680dd12498867789f10c9cdb1a787
SELECT * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '29' ORDER BY `main_img` DESC LIMIT 1;
90. Hack: 1688595469.38110 --- Duration: 266 µs [CACHE READ] --- Key: sql.fbd31fc54205c01eab03fc65c6f9215d
SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '600' ;
Memory: Peak Usage / Max (%):
9.26MB / 512M (1.81%) Cache (File): Enabled
Cache Used: 914.78kB of 2.77MB (32.30%)
Hits: 107 / 1451 [Clear Cache] Page Load Time:
0.11795592308044 seconds