Review Order | Schillers DPG

Item #	Qty	Description	Price Ea.	Ext Price
1109148	2	Magenta 440cc Eco-Sol MAX Ink (ESL3), By SPL Brand	$99.99	$199.98
1109154	2	Yellow 440cc Eco-Sol MAX Ink (ESL3), By SPL Brand	$99.99	$199.98
1109149	2	Cyan 440cc Eco-Sol MAX Ink (ESL3), By SPL Brand	$99.99	$199.98
			Cart Total	$599.94

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent46c5404893f7d8e229da7750c4799343
  time1774395407
  countdown10
- UserAuth(empty)
- SchillersShop(array)
  breadCrumb<a href="/">Digital Printer Group</a> / <a href="/categories/shop/Hardware">Hardware</a> / <a href="/categories/shop/Hardware-Roland">Roland</a> / <a href="/categories/shop/Resin-Roland">Resin</a>
  cart_info(array)
  total_items_ordered6
  total_amount_ordered599.94
====
Request
+
Request

Cake Params
- plugin(null)
- controllercarts
- actionedit_cart
- named(empty)
- pass(empty)
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(array)
  defaultRoute(true)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Logs

default

Total Time: 504 ms
Total Queries: 49 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `UserSetting`.`id`, `UserSetting`.`name`, `UserSetting`.`name_public`, `UserSetting`.`value`, `UserSetting`.`type`, `UserSetting`.`category`, `UserSetting`.`setting_key`, `UserSetting`.`setting_value`, `UserSetting`.`setting_type` FROM `dpg_ecommerce`.`user_settings` AS `UserSetting` WHERE 1 = 1	55	55	0
SELECT `UserActivity`.`id`, `UserActivity`.`useragent`, `UserActivity`.`user_id`, `UserActivity`.`last_action`, `UserActivity`.`last_url`, `UserActivity`.`logout_time`, `UserActivity`.`user_browser`, `UserActivity`.`ip_address`, `UserActivity`.`logout`, `UserActivity`.`deleted`, `UserActivity`.`status`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`useragent` = '46c5404893f7d8e229da7750c4799343qn60cfefk95fqrf60cg17gfjs0' LIMIT 1	1	1	442	maybe slow
BEGIN
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`id` = 2108371	1	1	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`id` = 2108371	1	1	0
UPDATE `dpg_ecommerce`.`user_activities` SET `id` = 2108371, `useragent` = '46c5404893f7d8e229da7750c4799343qn60cfefk95fqrf60cg17gfjs0', `user_id` = NULL, `last_action` = 1774395407, `last_url` = '/carts/edit_cart', `logout_time` = NULL, `user_browser` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', `ip_address` = '216.73.216.111', `logout` = 0, `deleted` = 0, `status` = 0, `created` = '2026-03-24 14:36:39', `modified` = '2026-03-24 14:36:48' WHERE `dpg_ecommerce`.`user_activities`.`id` = '2108371'	1	1	0
COMMIT
SELECT `Cart`.`id`, `Cart`.`session_id`, `Cart`.`user_id`, `Cart`.`item_id`, `Cart`.`product_id`, `Cart`.`color_id`, `Cart`.`color_number`, `Cart`.`color_name`, `Cart`.`cp1_item`, `Cart`.`vitem`, `Cart`.`product_parent`, `Cart`.`order_qty`, `Cart`.`description`, `Cart`.`price_each`, `Cart`.`org_price_each`, `Cart`.`cost_each`, `Cart`.`last_cost_each`, `Cart`.`fixed_cost_each`, `Cart`.`tax_ea`, `Cart`.`shipping_surcharge_each`, `Cart`.`free_shipping_item`, `Cart`.`created`, `Cart`.`status`, `Cart`.`stock_status_id`, `Cart`.`shipping_width`, `Cart`.`shipping_height`, `Cart`.`shipping_length`, `Cart`.`shipping_weight`, `Cart`.`ships_by_itself`, `Cart`.`taxable`, `Cart`.`price_break_description`, `Cart`.`price_break_rule`, `Cart`.`special_price_flag`, `Cart`.`reprice_flag`, `Cart`.`special_price_rule`, `Cart`.`cp1_price_rule`, `Cart`.`hide`, `Item`.`id`, `Item`.`cp1_item`, `Item`.`product_parent`, `Item`.`sell`, `Item`.`org_sell`, `Item`.`sell_update`, `Item`.`sell_update_method`, `Item`.`sell_strategy`, `Item`.`sell_override`, `Item`.`cost`, `Item`.`org_cost`, `Item`.`cost_update`, `Item`.`cost_update_method`, `Item`.`std_cost`, `Item`.`org_std_cost`, `Item`.`std_cost_update`, `Item`.`std_cost_update_method`, `Item`.`last_cost`, `Item`.`org_last_cost`, `Item`.`last_cost_update`, `Item`.`last_cost_update_method`, `Item`.`fixed_cost`, `Item`.`org_fixed_cost`, `Item`.`fixed_cost_update`, `Item`.`fixed_cost_update_method`, `Item`.`dim1`, `Item`.`dim1_unit_id`, `Item`.`dim2`, `Item`.`dim2_unit_id`, `Item`.`item_unit_id`, `Item`.`vitem`, `Item`.`cp_vend_no`, `Item`.`publish_flag`, `Item`.`group_id`, `Item`.`price_group_id`, `Item`.`finish_id`, `Item`.`ships_by_itself`, `Item`.`shipping_width`, `Item`.`shipping_height`, `Item`.`shipping_length`, `Item`.`shipping_weight`, `Item`.`acutal_weight`, `Item`.`shipping_header_id`, `Item`.`free_shipping_item`, `Item`.`stock_status_id`, `Item`.`description_override`, `Item`.`clear_override`, `Item`.`cp1_description`, `Item`.`auto_desc`, `Item`.`keyword`, `Item`.`keyword_2`, `Item`.`color_id`, `Item`.`item_id`, `Item`.`csi`, `Item`.`color_selector_id`, `Item`.`color_number`, `Item`.`cp1_status`, `Item`.`taxable`, `Item`.`min`, `Item`.`max`, `Item`.`qty_avail`, `Item`.`qty_on_hand`, `Item`.`qty_on_po`, `Item`.`qty_on_bo`, `Item`.`qty_commit`, `Item`.`last_po_date`, `Item`.`instock_override`, `Item`.`created`, `Item`.`modified`, `Item`.`cp1_write_off`, `Item`.`cp1_categ_cod`, `Item`.`cp1_subcat_cod`, `Item`.`cp1_categ_subcat`, `Item`.`photo_square`, `Item`.`hide`, `Item`.`sale_end`, `Item`.`sale_price`, `Item`.`sale_start`, `Item`.`legacy_id`, `Item`.`legacy_source`, `Item`.`kit_part`, `Item`.`kit_flag`, `Item`.`kitable`, `Item`.`fedx_flag`, `Item`.`ups_flag`, `Item`.`cp1_export`, `Item`.`cp1_sync`, `Item`.`cp1_update`, `Item`.`cp1_export_flag`, `Item`.`unit_id`, `User`.`id`, `User`.`legacy_id`, `User`.`m1_id`, `User`.`user_bill_to_id`, `User`.`user_group_id`, `User`.`username`, `User`.`email`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`phone`, `User`.`phone_ext`, `User`.`cell`, `User`.`active`, `User`.`email_verified`, `User`.`last_login`, `User`.`last_order`, `User`.`by_admin`, `User`.`ip_address`, `User`.`created`, `User`.`created_by_id`, `User`.`modified`, `User`.`modified_by_id`, `User`.`password`, `User`.`salt`, `User`.`password_v4`, `User`.`salt_v4`, `User`.`send_direct_mail`, `User`.`send_email`, `User`.`unsubscribe`, `User`.`unsubscribe_reason`, `User`.`mailchimp_leid`, `User`.`soft_delete`, `User`.`referral_id`, `User`.`key_code`, `User`.`start_controller`, `User`.`fb_id`, `User`.`fb_access_token`, `User`.`twt_id`, `User`.`twt_access_secret`, `User`.`ldn_id`, `User`.`twt_access_token`, `User`.`is_old_password`, `User`.`remember`, (`User`.`created`) AS `User__created1`, (`User`.`created`) AS `User__created2`, `StockStatus`.`id`, `StockStatus`.`description`, `StockStatus`.`a10n`, `StockStatus`.`sort`, `StockStatus`.`groups`, `StockStatus`.`specification_id`, `StockStatus`.`icon`, `StockStatus`.`text_color`, `StockStatus`.`index_flag`, `StockStatus`.`active` FROM `dpg_ecommerce`.`cart` AS `Cart` LEFT JOIN `dpg_ecommerce`.`items` AS `Item` ON (`Cart`.`item_id` = `Item`.`id`) LEFT JOIN `dpg_ecommerce`.`users` AS `User` ON (`Cart`.`user_id` = `User`.`id`) LEFT JOIN `dpg_ecommerce`.`specification_details` AS `StockStatus` ON (`Cart`.`stock_status_id` = `StockStatus`.`id`) WHERE `Cart`.`order_qty` > 0 AND `Cart`.`session_id` IS NULL AND `Cart`.`status` IS NULL	3	3	16	maybe slow
SELECT `Cart`.`id`, `Cart`.`session_id`, `Cart`.`user_id`, `Cart`.`item_id`, `Cart`.`product_id`, `Cart`.`color_id`, `Cart`.`color_number`, `Cart`.`color_name`, `Cart`.`cp1_item`, `Cart`.`vitem`, `Cart`.`product_parent`, `Cart`.`order_qty`, `Cart`.`description`, `Cart`.`price_each`, `Cart`.`org_price_each`, `Cart`.`cost_each`, `Cart`.`last_cost_each`, `Cart`.`fixed_cost_each`, `Cart`.`tax_ea`, `Cart`.`shipping_surcharge_each`, `Cart`.`free_shipping_item`, `Cart`.`created`, `Cart`.`status`, `Cart`.`stock_status_id`, `Cart`.`shipping_width`, `Cart`.`shipping_height`, `Cart`.`shipping_length`, `Cart`.`shipping_weight`, `Cart`.`ships_by_itself`, `Cart`.`taxable`, `Cart`.`price_break_description`, `Cart`.`price_break_rule`, `Cart`.`special_price_flag`, `Cart`.`reprice_flag`, `Cart`.`special_price_rule`, `Cart`.`cp1_price_rule`, `Cart`.`hide`, `Item`.`id`, `Item`.`cp1_item`, `Item`.`product_parent`, `Item`.`sell`, `Item`.`org_sell`, `Item`.`sell_update`, `Item`.`sell_update_method`, `Item`.`sell_strategy`, `Item`.`sell_override`, `Item`.`cost`, `Item`.`org_cost`, `Item`.`cost_update`, `Item`.`cost_update_method`, `Item`.`std_cost`, `Item`.`org_std_cost`, `Item`.`std_cost_update`, `Item`.`std_cost_update_method`, `Item`.`last_cost`, `Item`.`org_last_cost`, `Item`.`last_cost_update`, `Item`.`last_cost_update_method`, `Item`.`fixed_cost`, `Item`.`org_fixed_cost`, `Item`.`fixed_cost_update`, `Item`.`fixed_cost_update_method`, `Item`.`dim1`, `Item`.`dim1_unit_id`, `Item`.`dim2`, `Item`.`dim2_unit_id`, `Item`.`item_unit_id`, `Item`.`vitem`, `Item`.`cp_vend_no`, `Item`.`publish_flag`, `Item`.`group_id`, `Item`.`price_group_id`, `Item`.`finish_id`, `Item`.`ships_by_itself`, `Item`.`shipping_width`, `Item`.`shipping_height`, `Item`.`shipping_length`, `Item`.`shipping_weight`, `Item`.`acutal_weight`, `Item`.`shipping_header_id`, `Item`.`free_shipping_item`, `Item`.`stock_status_id`, `Item`.`description_override`, `Item`.`clear_override`, `Item`.`cp1_description`, `Item`.`auto_desc`, `Item`.`keyword`, `Item`.`keyword_2`, `Item`.`color_id`, `Item`.`item_id`, `Item`.`csi`, `Item`.`color_selector_id`, `Item`.`color_number`, `Item`.`cp1_status`, `Item`.`taxable`, `Item`.`min`, `Item`.`max`, `Item`.`qty_avail`, `Item`.`qty_on_hand`, `Item`.`qty_on_po`, `Item`.`qty_on_bo`, `Item`.`qty_commit`, `Item`.`last_po_date`, `Item`.`instock_override`, `Item`.`created`, `Item`.`modified`, `Item`.`cp1_write_off`, `Item`.`cp1_categ_cod`, `Item`.`cp1_subcat_cod`, `Item`.`cp1_categ_subcat`, `Item`.`photo_square`, `Item`.`hide`, `Item`.`sale_end`, `Item`.`sale_price`, `Item`.`sale_start`, `Item`.`legacy_id`, `Item`.`legacy_source`, `Item`.`kit_part`, `Item`.`kit_flag`, `Item`.`kitable`, `Item`.`fedx_flag`, `Item`.`ups_flag`, `Item`.`cp1_export`, `Item`.`cp1_sync`, `Item`.`cp1_update`, `Item`.`cp1_export_flag`, `Item`.`unit_id` FROM `dpg_ecommerce`.`cart` AS `Cart` LEFT JOIN `dpg_ecommerce`.`items` AS `Item` ON (`Cart`.`item_id` = `Item`.`id`) WHERE `Cart`.`order_qty` > 0 AND `Cart`.`session_id` IS NULL AND `Cart`.`status` IS NULL	3	3	14	maybe slow
SELECT `Cp1SpecialPrice`.`id`, `Cp1SpecialPrice`.`GRP_TYP`, `Cp1SpecialPrice`.`CUST_NO`, `Cp1SpecialPrice`.`GRP_COD`, `Cp1SpecialPrice`.`RUL_SEQ_NO`, `Cp1SpecialPrice`.`DESCR`, `Cp1SpecialPrice`.`ITEM_FILT`, `Cp1SpecialPrice`.`MIN_QTY`, `Cp1SpecialPrice`.`PRC_METH`, `Cp1SpecialPrice`.`PRC_BASIS`, `Cp1SpecialPrice`.`AMT_OR_PCT`, `Cp1SpecialPrice`.`MIX_MATCH_COD` FROM `dpg_ecommerce`.`cp1_special_prices` AS `Cp1SpecialPrice` WHERE ((((`Cp1SpecialPrice`.`CUST_NO` IS NULL) AND (`Cp1SpecialPrice`.`MIX_MATCH_COD` IS NULL))) OR (((`Cp1SpecialPrice`.`CUST_NO` IS NULL) AND (`Cp1SpecialPrice`.`MIX_MATCH_COD` IS NULL))))	2	2	0
SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1109148 AND (((Item.cp1_item >= '1002051') and (Item.cp1_item <= '1002053')))	0	0	2	maybe slow
SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1109148 AND (((Item.cp1_item >= '1002487') and (Item.cp1_item <= '1002487')))	0	0	2	maybe slow
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21210	1	1	0
BEGIN
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21210	1	1	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21210	1	1	0
UPDATE `dpg_ecommerce`.`cart` SET `id` = 21210, `session_id` = NULL, `user_id` = 1274, `item_id` = 3220, `product_id` = 844, `color_id` = NULL, `color_number` = '', `color_name` = '', `cp1_item` = '1109148', `vitem` = 'SPL-ESL3-M', `product_parent` = NULL, `order_qty` = 2.00, `description` = ' Magenta 440cc Eco-Sol MAX Ink (ESL3), By SPL Brand', `price_each` = 99.99, `org_price_each` = '0.00', `cost_each` = NULL, `last_cost_each` = '0.00', `fixed_cost_each` = '0.00', `tax_ea` = '0.00', `shipping_surcharge_each` = NULL, `free_shipping_item` = 'N', `created` = '2026-03-20 10:49:21', `status` = NULL, `stock_status_id` = 435, `shipping_width` = '0.00', `shipping_height` = '0.00', `shipping_length` = '0.00', `shipping_weight` = '0.00', `ships_by_itself` = '', `taxable` = '', `price_break_description` = NULL, `price_break_rule` = '', `special_price_flag` = NULL, `reprice_flag` = '', `special_price_rule` = NULL, `cp1_price_rule` = '', `hide` = 'N' WHERE `dpg_ecommerce`.`cart`.`id` = '21210'	0	0	0
COMMIT
SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1109154 AND (((Item.cp1_item >= '1002051') and (Item.cp1_item <= '1002053')))	0	0	2	maybe slow
SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1109154 AND (((Item.cp1_item >= '1002487') and (Item.cp1_item <= '1002487')))	0	0	2	maybe slow
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21210	1	1	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21211	1	1	0
BEGIN
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21210	1	1	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21210	1	1	0
UPDATE `dpg_ecommerce`.`cart` SET `id` = 21210, `session_id` = NULL, `user_id` = 1274, `item_id` = 3220, `product_id` = 844, `color_id` = NULL, `color_number` = '', `color_name` = '', `cp1_item` = '1109148', `vitem` = 'SPL-ESL3-M', `product_parent` = NULL, `order_qty` = 2.00, `description` = ' Magenta 440cc Eco-Sol MAX Ink (ESL3), By SPL Brand', `price_each` = 99.99, `org_price_each` = '0.00', `cost_each` = NULL, `last_cost_each` = '0.00', `fixed_cost_each` = '0.00', `tax_ea` = '0.00', `shipping_surcharge_each` = NULL, `free_shipping_item` = 'N', `created` = '2026-03-20 10:49:21', `status` = NULL, `stock_status_id` = 435, `shipping_width` = '0.00', `shipping_height` = '0.00', `shipping_length` = '0.00', `shipping_weight` = '0.00', `ships_by_itself` = '', `taxable` = '', `price_break_description` = NULL, `price_break_rule` = '', `special_price_flag` = NULL, `reprice_flag` = '', `special_price_rule` = NULL, `cp1_price_rule` = '', `hide` = 'N' WHERE `dpg_ecommerce`.`cart`.`id` = '21210'	0	0	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21211	1	1	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21211	1	1	0
UPDATE `dpg_ecommerce`.`cart` SET `id` = 21211, `session_id` = NULL, `user_id` = 1274, `item_id` = 3223, `product_id` = 844, `color_id` = NULL, `color_number` = '', `color_name` = '', `cp1_item` = '1109154', `vitem` = 'SPL-ESL3-Y', `product_parent` = NULL, `order_qty` = 2.00, `description` = ' Yellow 440cc Eco-Sol MAX Ink (ESL3), By SPL Brand', `price_each` = 99.99, `org_price_each` = '0.00', `cost_each` = NULL, `last_cost_each` = '0.00', `fixed_cost_each` = '0.00', `tax_ea` = '0.00', `shipping_surcharge_each` = NULL, `free_shipping_item` = 'N', `created` = '2026-03-20 10:49:36', `status` = NULL, `stock_status_id` = 435, `shipping_width` = '0.00', `shipping_height` = '0.00', `shipping_length` = '0.00', `shipping_weight` = '0.00', `ships_by_itself` = '', `taxable` = '', `price_break_description` = NULL, `price_break_rule` = '', `special_price_flag` = NULL, `reprice_flag` = '', `special_price_rule` = NULL, `cp1_price_rule` = '', `hide` = 'N' WHERE `dpg_ecommerce`.`cart`.`id` = '21211'	0	0	0
COMMIT
SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1109149 AND (((Item.cp1_item >= '1002051') and (Item.cp1_item <= '1002053')))	0	0	3	maybe slow
SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1109149 AND (((Item.cp1_item >= '1002487') and (Item.cp1_item <= '1002487')))	0	0	2	maybe slow
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21210	1	1	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21211	1	1	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21212	1	1	0
BEGIN
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21210	1	1	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21210	1	1	0
UPDATE `dpg_ecommerce`.`cart` SET `id` = 21210, `session_id` = NULL, `user_id` = 1274, `item_id` = 3220, `product_id` = 844, `color_id` = NULL, `color_number` = '', `color_name` = '', `cp1_item` = '1109148', `vitem` = 'SPL-ESL3-M', `product_parent` = NULL, `order_qty` = 2.00, `description` = ' Magenta 440cc Eco-Sol MAX Ink (ESL3), By SPL Brand', `price_each` = 99.99, `org_price_each` = '0.00', `cost_each` = NULL, `last_cost_each` = '0.00', `fixed_cost_each` = '0.00', `tax_ea` = '0.00', `shipping_surcharge_each` = NULL, `free_shipping_item` = 'N', `created` = '2026-03-20 10:49:21', `status` = NULL, `stock_status_id` = 435, `shipping_width` = '0.00', `shipping_height` = '0.00', `shipping_length` = '0.00', `shipping_weight` = '0.00', `ships_by_itself` = '', `taxable` = '', `price_break_description` = NULL, `price_break_rule` = '', `special_price_flag` = NULL, `reprice_flag` = '', `special_price_rule` = NULL, `cp1_price_rule` = '', `hide` = 'N' WHERE `dpg_ecommerce`.`cart`.`id` = '21210'	0	0	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21211	1	1	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21211	1	1	0
UPDATE `dpg_ecommerce`.`cart` SET `id` = 21211, `session_id` = NULL, `user_id` = 1274, `item_id` = 3223, `product_id` = 844, `color_id` = NULL, `color_number` = '', `color_name` = '', `cp1_item` = '1109154', `vitem` = 'SPL-ESL3-Y', `product_parent` = NULL, `order_qty` = 2.00, `description` = ' Yellow 440cc Eco-Sol MAX Ink (ESL3), By SPL Brand', `price_each` = 99.99, `org_price_each` = '0.00', `cost_each` = NULL, `last_cost_each` = '0.00', `fixed_cost_each` = '0.00', `tax_ea` = '0.00', `shipping_surcharge_each` = NULL, `free_shipping_item` = 'N', `created` = '2026-03-20 10:49:36', `status` = NULL, `stock_status_id` = 435, `shipping_width` = '0.00', `shipping_height` = '0.00', `shipping_length` = '0.00', `shipping_weight` = '0.00', `ships_by_itself` = '', `taxable` = '', `price_break_description` = NULL, `price_break_rule` = '', `special_price_flag` = NULL, `reprice_flag` = '', `special_price_rule` = NULL, `cp1_price_rule` = '', `hide` = 'N' WHERE `dpg_ecommerce`.`cart`.`id` = '21211'	0	0	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21212	1	1	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`cart` AS `Cart` WHERE `Cart`.`id` = 21212	1	1	0
UPDATE `dpg_ecommerce`.`cart` SET `id` = 21212, `session_id` = NULL, `user_id` = 1274, `item_id` = 3215, `product_id` = 844, `color_id` = NULL, `color_number` = '', `color_name` = '', `cp1_item` = '1109149', `vitem` = 'SPL-ESL3-C', `product_parent` = NULL, `order_qty` = 2.00, `description` = ' Cyan 440cc Eco-Sol MAX Ink (ESL3), By SPL Brand', `price_each` = 99.99, `org_price_each` = '0.00', `cost_each` = NULL, `last_cost_each` = '0.00', `fixed_cost_each` = '0.00', `tax_ea` = '0.00', `shipping_surcharge_each` = NULL, `free_shipping_item` = 'N', `created` = '2026-03-20 10:49:48', `status` = NULL, `stock_status_id` = 435, `shipping_width` = '0.00', `shipping_height` = '0.00', `shipping_length` = '0.00', `shipping_weight` = '0.00', `ships_by_itself` = '', `taxable` = '', `price_break_description` = NULL, `price_break_rule` = '', `special_price_flag` = NULL, `reprice_flag` = '', `special_price_rule` = NULL, `cp1_price_rule` = '', `hide` = 'N' WHERE `dpg_ecommerce`.`cart`.`id` = '21212'	0	0	0
COMMIT
SELECT `Cart`.`order_qty`, `Cart`.`price_each`, `Cart`.`hide` FROM `dpg_ecommerce`.`cart` AS `Cart` LEFT JOIN `dpg_ecommerce`.`items` AS `Item` ON (`Cart`.`item_id` = `Item`.`id`) LEFT JOIN `dpg_ecommerce`.`users` AS `User` ON (`Cart`.`user_id` = `User`.`id`) LEFT JOIN `dpg_ecommerce`.`specification_details` AS `StockStatus` ON (`Cart`.`stock_status_id` = `StockStatus`.`id`) WHERE `Cart`.`session_id` IS NULL AND `Cart`.`status` IS NULL	3	3	5	maybe slow
SELECT `Cart`.`id`, `Cart`.`session_id`, `Cart`.`user_id`, `Cart`.`item_id`, `Cart`.`product_id`, `Cart`.`color_id`, `Cart`.`color_number`, `Cart`.`color_name`, `Cart`.`cp1_item`, `Cart`.`vitem`, `Cart`.`product_parent`, `Cart`.`order_qty`, `Cart`.`description`, `Cart`.`price_each`, `Cart`.`org_price_each`, `Cart`.`cost_each`, `Cart`.`last_cost_each`, `Cart`.`fixed_cost_each`, `Cart`.`tax_ea`, `Cart`.`shipping_surcharge_each`, `Cart`.`free_shipping_item`, `Cart`.`created`, `Cart`.`status`, `Cart`.`stock_status_id`, `Cart`.`shipping_width`, `Cart`.`shipping_height`, `Cart`.`shipping_length`, `Cart`.`shipping_weight`, `Cart`.`ships_by_itself`, `Cart`.`taxable`, `Cart`.`price_break_description`, `Cart`.`price_break_rule`, `Cart`.`special_price_flag`, `Cart`.`reprice_flag`, `Cart`.`special_price_rule`, `Cart`.`cp1_price_rule`, `Cart`.`hide`, `Item`.`id`, `Item`.`cp1_item`, `Item`.`product_parent`, `Item`.`sell`, `Item`.`org_sell`, `Item`.`sell_update`, `Item`.`sell_update_method`, `Item`.`sell_strategy`, `Item`.`sell_override`, `Item`.`cost`, `Item`.`org_cost`, `Item`.`cost_update`, `Item`.`cost_update_method`, `Item`.`std_cost`, `Item`.`org_std_cost`, `Item`.`std_cost_update`, `Item`.`std_cost_update_method`, `Item`.`last_cost`, `Item`.`org_last_cost`, `Item`.`last_cost_update`, `Item`.`last_cost_update_method`, `Item`.`fixed_cost`, `Item`.`org_fixed_cost`, `Item`.`fixed_cost_update`, `Item`.`fixed_cost_update_method`, `Item`.`dim1`, `Item`.`dim1_unit_id`, `Item`.`dim2`, `Item`.`dim2_unit_id`, `Item`.`item_unit_id`, `Item`.`vitem`, `Item`.`cp_vend_no`, `Item`.`publish_flag`, `Item`.`group_id`, `Item`.`price_group_id`, `Item`.`finish_id`, `Item`.`ships_by_itself`, `Item`.`shipping_width`, `Item`.`shipping_height`, `Item`.`shipping_length`, `Item`.`shipping_weight`, `Item`.`acutal_weight`, `Item`.`shipping_header_id`, `Item`.`free_shipping_item`, `Item`.`stock_status_id`, `Item`.`description_override`, `Item`.`clear_override`, `Item`.`cp1_description`, `Item`.`auto_desc`, `Item`.`keyword`, `Item`.`keyword_2`, `Item`.`color_id`, `Item`.`item_id`, `Item`.`csi`, `Item`.`color_selector_id`, `Item`.`color_number`, `Item`.`cp1_status`, `Item`.`taxable`, `Item`.`min`, `Item`.`max`, `Item`.`qty_avail`, `Item`.`qty_on_hand`, `Item`.`qty_on_po`, `Item`.`qty_on_bo`, `Item`.`qty_commit`, `Item`.`last_po_date`, `Item`.`instock_override`, `Item`.`created`, `Item`.`modified`, `Item`.`cp1_write_off`, `Item`.`cp1_categ_cod`, `Item`.`cp1_subcat_cod`, `Item`.`cp1_categ_subcat`, `Item`.`photo_square`, `Item`.`hide`, `Item`.`sale_end`, `Item`.`sale_price`, `Item`.`sale_start`, `Item`.`legacy_id`, `Item`.`legacy_source`, `Item`.`kit_part`, `Item`.`kit_flag`, `Item`.`kitable`, `Item`.`fedx_flag`, `Item`.`ups_flag`, `Item`.`cp1_export`, `Item`.`cp1_sync`, `Item`.`cp1_update`, `Item`.`cp1_export_flag`, `Item`.`unit_id`, `User`.`id`, `User`.`legacy_id`, `User`.`m1_id`, `User`.`user_bill_to_id`, `User`.`user_group_id`, `User`.`username`, `User`.`email`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`phone`, `User`.`phone_ext`, `User`.`cell`, `User`.`active`, `User`.`email_verified`, `User`.`last_login`, `User`.`last_order`, `User`.`by_admin`, `User`.`ip_address`, `User`.`created`, `User`.`created_by_id`, `User`.`modified`, `User`.`modified_by_id`, `User`.`password`, `User`.`salt`, `User`.`password_v4`, `User`.`salt_v4`, `User`.`send_direct_mail`, `User`.`send_email`, `User`.`unsubscribe`, `User`.`unsubscribe_reason`, `User`.`mailchimp_leid`, `User`.`soft_delete`, `User`.`referral_id`, `User`.`key_code`, `User`.`start_controller`, `User`.`fb_id`, `User`.`fb_access_token`, `User`.`twt_id`, `User`.`twt_access_secret`, `User`.`ldn_id`, `User`.`twt_access_token`, `User`.`is_old_password`, `User`.`remember`, (`User`.`created`) AS `User__created1`, (`User`.`created`) AS `User__created2`, `StockStatus`.`id`, `StockStatus`.`description`, `StockStatus`.`a10n`, `StockStatus`.`sort`, `StockStatus`.`groups`, `StockStatus`.`specification_id`, `StockStatus`.`icon`, `StockStatus`.`text_color`, `StockStatus`.`index_flag`, `StockStatus`.`active` FROM `dpg_ecommerce`.`cart` AS `Cart` LEFT JOIN `dpg_ecommerce`.`items` AS `Item` ON (`Cart`.`item_id` = `Item`.`id`) LEFT JOIN `dpg_ecommerce`.`users` AS `User` ON (`Cart`.`user_id` = `User`.`id`) LEFT JOIN `dpg_ecommerce`.`specification_details` AS `StockStatus` ON (`Cart`.`stock_status_id` = `StockStatus`.`id`) WHERE `Cart`.`order_qty` > 0 AND `Cart`.`session_id` IS NULL AND `Cart`.`status` IS NULL	3	3	14	maybe slow
SELECT `InkType`.`id`, `InkType`.`name` FROM `dpg_ecommerce`.`ink_types` AS `InkType` WHERE 1 = 1	20	20	0

26 duplicate queries run.

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 23.49 MB

Message	Memory use
Component initialization	4.51 MB
Controller action start	17.20 MB
Controller render start	18.44 MB
View render complete	20.16 MB

Timers

Total Request Time: 749 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	24.30
Event: Controller.initialize	503.35
Event: Controller.startup	0.42
Controller action	170.87
Event: Controller.beforeRender	10.84
» Processing toolbar data	9.59
Rendering View	5.60
» Event: View.beforeRender	0.03
» Rendering APP/View/Carts/edit_cart.ctp	4.00
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/check_out.ctp	0.81
» » Rendering APP/View/Elements/final-footer.ctp	0.09
Event: View.afterLayout	0.00

====

Log
+

Logs

debug

Time Message
2026-03-24 14:36:47 Data AppController:

====
Variables
+
View Variables
- stockFilter*
- inkFilters(empty)
- show_debug(null)
- show_non_published(null)
- isAdmin(null)
- isAdminSub(null)
- inkTypes(array)
  Eco-SolventEco-Solvent
  SolventSolvent
  UVUV
  LatexLatex
  DyeDye
  Dye-SubDye-Sub
  PigmentPigment
  ScreenScreen
  Thermal TransferThermal Transfer
  HP Latex CertifiedHP Latex Certified
  N/AN/A
  Toner FuserToner Fuser
  Direct to Film Direct to Film
  PageWidePageWide
  Canon UVgel 356Canon UVgel 356
  OfsettOfsett
  ResinResin
  Noritsu Dry LabNoritsu Dry Lab
  Fuji Dry Lab Fuji Dry Lab
  Epson Dry Lab Epson Dry Lab
- var(empty)
- cart_items(array)
  0(array)
  Cart(array)
  id21210
  session_id(null)
  user_id1274
  item_id3220
  product_id844
  color_id(null)
  color_number
  color_name
  cp1_item1109148
  vitemSPL-ESL3-M
  product_parent(null)
  order_qty2.00
  description Magenta 440cc Eco-Sol MAX Ink (ESL3), By SPL Brand
  price_each99.99
  org_price_each0.00
  cost_each(null)
  last_cost_each0.00
  fixed_cost_each0.00
  tax_ea0.00
  shipping_surcharge_each(null)
  free_shipping_itemN
  created2026-03-20 10:49:21
  status(null)
  stock_status_id435
  shipping_width0.00
  shipping_height0.00
  shipping_length0.00
  shipping_weight0.00
  ships_by_itself
  taxable
  price_break_description(null)
  price_break_rule
  special_price_flag(null)
  reprice_flag
  special_price_rule(null)
  cp1_price_rule
  hideN
  Item(array)
  id3220
  cp1_item1109148
  product_parentSPL-INK-ESL3-4
  sell99.99
  org_sell89.99
  sell_update2026-01-08
  sell_update_methodInotify Update DPG Items:
  sell_strategy
  sell_override
  cost53.00
  org_cost0.00
  cost_update2023-03-09
  cost_update_methodInotify Update DPG Items:
  std_cost53.00
  org_std_cost0.00
  std_cost_update0000-00-00
  std_cost_update_method
  last_cost53.00
  org_last_cost0.00
  last_cost_update2023-03-09
  last_cost_update_methodInotify Update DPG Items:
  fixed_cost0.00
  org_fixed_cost56.00
  fixed_cost_update2024-08-07
  fixed_cost_update_methodInotify Update DPG Items:
  dim1440.000
  dim1_unit_id12
  dim20.000
  dim2_unit_id31
  item_unit_id2990
  vitemSPL-ESL3-M
  cp_vend_no3100056
  publish_flagY
  group_id4
  price_group_id2802
  finish_id0
  ships_by_itselfN
  shipping_width4
  shipping_height1
  shipping_length21
  shipping_weight2
  acutal_weightY
  shipping_header_id0
  free_shipping_itemN
  stock_status_id0
  description_override
  clear_override(false)
  cp1_descriptionMagenta 440cc Eco-Sol Ink, SPL
  auto_desc
  keyword
  keyword_2
  color_id45
  item_id0
  csi
  color_selector_id0
  color_number
  cp1_statusA
  taxable
  min16
  max24
  qty_avail16
  qty_on_hand16
  qty_on_po0
  qty_on_bo0
  qty_commit0
  last_po_date2026-03-10
  instock_override
  created2014-01-27 16:47:52
  modified2026-01-14 17:00:50
  cp1_write_off
  cp1_categ_cod3000
  cp1_subcat_cod3501
  cp1_categ_subcat3000/3501
  photo_square
  hideN
  sale_end0000-00-00
  sale_price0.00
  sale_start0000-00-00
  legacy_id0
  legacy_source
  kit_partN
  kit_flag
  kitableN
  fedx_flag
  ups_flagY
  cp1_export2016-01-23
  cp1_sync2021-10-15
  cp1_update2021-10-15
  cp1_export_flag
  unit_id12
  User(array)
  id1274
  legacy_id0
  m1_id4689
  user_bill_to_id1083
  user_group_id2
  usernamellight
  emailleann.light@agraphics.biz
  first_nameLeann
  last_nameLight
  title
  phone
  phone_ext
  cell
  active1
  email_verified1
  last_login2026-03-24 14:05:32
  last_order2025-10-06 12:46:22
  by_admin1
  ip_address72.172.196.43
  created2025-04-21 09:11:00
  created_by_id0
  modified2025-10-06 12:46:22
  modified_by_id0
  password1f734d7a80bbd60f6c45a9fb43354e516d975502962bb3b894a7d16082f8e01a
  saltHoLC6KWWVAAsT5M5c6YXVUdH/pNsfpzmSA9kTDtyeVr0O0Ka0Zeb/uYvN1rVT68c
  password_v4
  salt_v4
  send_direct_mail
  send_email
  unsubscribe(false)
  unsubscribe_reason
  mailchimp_leid
  soft_delete
  referral_id0
  key_code
  start_controller
  fb_id(null)
  fb_access_token(null)
  twt_id(null)
  twt_access_secret(null)
  ldn_id(null)
  twt_access_token(null)
  is_old_password0
  remember(false)
  created12025-04-21 09:11:00
  created22025-04-21 09:11:00
  StockStatus(array)
  id435
  descriptionIn Stock
  a10n
  sortB
  groups
  specification_id21
  iconnone
  text_color#38761d
  index_flag
  active
  1(array)
  Cart(array)
  id21211
  session_id(null)
  user_id1274
  item_id3223
  product_id844
  color_id(null)
  color_number
  color_name
  cp1_item1109154
  vitemSPL-ESL3-Y
  product_parent(null)
  order_qty2.00
  description Yellow 440cc Eco-Sol MAX Ink (ESL3), By SPL Brand
  price_each99.99
  org_price_each0.00
  cost_each(null)
  last_cost_each0.00
  fixed_cost_each0.00
  tax_ea0.00
  shipping_surcharge_each(null)
  free_shipping_itemN
  created2026-03-20 10:49:36
  status(null)
  stock_status_id435
  shipping_width0.00
  shipping_height0.00
  shipping_length0.00
  shipping_weight0.00
  ships_by_itself
  taxable
  price_break_description(null)
  price_break_rule
  special_price_flag(null)
  reprice_flag
  special_price_rule(null)
  cp1_price_rule
  hideN
  Item(array)
  id3223
  cp1_item1109154
  product_parentSPL-INK-ESL3-4
  sell99.99
  org_sell89.99
  sell_update2026-01-08
  sell_update_methodInotify Update DPG Items:
  sell_strategy
  sell_override
  cost53.00
  org_cost0.00
  cost_update2023-03-09
  cost_update_methodInotify Update DPG Items:
  std_cost53.00
  org_std_cost0.00
  std_cost_update0000-00-00
  std_cost_update_method
  last_cost53.00
  org_last_cost0.00
  last_cost_update2023-03-09
  last_cost_update_methodInotify Update DPG Items:
  fixed_cost0.00
  org_fixed_cost56.00
  fixed_cost_update2024-08-07
  fixed_cost_update_methodInotify Update DPG Items:
  dim1440.000
  dim1_unit_id12
  dim20.000
  dim2_unit_id31
  item_unit_id2990
  vitemSPL-ESL3-Y
  cp_vend_no3100056
  publish_flagY
  group_id4
  price_group_id2802
  finish_id0
  ships_by_itselfN
  shipping_width4
  shipping_height1
  shipping_length21
  shipping_weight2
  acutal_weightY
  shipping_header_id0
  free_shipping_itemN
  stock_status_id0
  description_override
  clear_override(false)
  cp1_descriptionYellow 440cc Eco-Sol Ink, SPL
  auto_desc
  keyword
  keyword_2
  color_id46
  item_id0
  csi
  color_selector_id0
  color_number
  cp1_statusA
  taxable
  min16
  max24
  qty_avail19
  qty_on_hand19
  qty_on_po0
  qty_on_bo0
  qty_commit0
  last_po_date2026-03-10
  instock_override
  created2014-01-27 16:47:52
  modified2026-01-14 17:00:50
  cp1_write_off
  cp1_categ_cod3000
  cp1_subcat_cod3501
  cp1_categ_subcat3000/3501
  photo_square
  hideN
  sale_end0000-00-00
  sale_price0.00
  sale_start0000-00-00
  legacy_id0
  legacy_source
  kit_partN
  kit_flag
  kitableN
  fedx_flag
  ups_flagY
  cp1_export2016-01-23
  cp1_sync2021-10-15
  cp1_update2021-10-15
  cp1_export_flag
  unit_id12
  User(array)
  id1274
  legacy_id0
  m1_id4689
  user_bill_to_id1083
  user_group_id2
  usernamellight
  emailleann.light@agraphics.biz
  first_nameLeann
  last_nameLight
  title
  phone
  phone_ext
  cell
  active1
  email_verified1
  last_login2026-03-24 14:05:32
  last_order2025-10-06 12:46:22
  by_admin1
  ip_address72.172.196.43
  created2025-04-21 09:11:00
  created_by_id0
  modified2025-10-06 12:46:22
  modified_by_id0
  password1f734d7a80bbd60f6c45a9fb43354e516d975502962bb3b894a7d16082f8e01a
  saltHoLC6KWWVAAsT5M5c6YXVUdH/pNsfpzmSA9kTDtyeVr0O0Ka0Zeb/uYvN1rVT68c
  password_v4
  salt_v4
  send_direct_mail
  send_email
  unsubscribe(false)
  unsubscribe_reason
  mailchimp_leid
  soft_delete
  referral_id0
  key_code
  start_controller
  fb_id(null)
  fb_access_token(null)
  twt_id(null)
  twt_access_secret(null)
  ldn_id(null)
  twt_access_token(null)
  is_old_password0
  remember(false)
  created12025-04-21 09:11:00
  created22025-04-21 09:11:00
  StockStatus(array)
  id435
  descriptionIn Stock
  a10n
  sortB
  groups
  specification_id21
  iconnone
  text_color#38761d
  index_flag
  active
  2(array)
  Cart(array)
  id21212
  session_id(null)
  user_id1274
  item_id3215
  product_id844
  color_id(null)
  color_number
  color_name
  cp1_item1109149
  vitemSPL-ESL3-C
  product_parent(null)
  order_qty2.00
  description Cyan 440cc Eco-Sol MAX Ink (ESL3), By SPL Brand
  price_each99.99
  org_price_each0.00
  cost_each(null)
  last_cost_each0.00
  fixed_cost_each0.00
  tax_ea0.00
  shipping_surcharge_each(null)
  free_shipping_itemN
  created2026-03-20 10:49:48
  status(null)
  stock_status_id435
  shipping_width0.00
  shipping_height0.00
  shipping_length0.00
  shipping_weight0.00
  ships_by_itself
  taxable
  price_break_description(null)
  price_break_rule
  special_price_flag(null)
  reprice_flag
  special_price_rule(null)
  cp1_price_rule
  hideN
  Item(array)
  id3215
  cp1_item1109149
  product_parentSPL-INK-ESL3-4
  sell99.99
  org_sell89.99
  sell_update2026-01-08
  sell_update_methodInotify Update DPG Items:
  sell_strategy
  sell_override
  cost53.00
  org_cost0.00
  cost_update2023-03-09
  cost_update_methodInotify Update DPG Items:
  std_cost53.00
  org_std_cost0.00
  std_cost_update0000-00-00
  std_cost_update_method
  last_cost53.00
  org_last_cost0.00
  last_cost_update2023-03-09
  last_cost_update_methodInotify Update DPG Items:
  fixed_cost0.00
  org_fixed_cost56.00
  fixed_cost_update2024-08-07
  fixed_cost_update_methodInotify Update DPG Items:
  dim1440.000
  dim1_unit_id12
  dim20.000
  dim2_unit_id31
  item_unit_id2990
  vitemSPL-ESL3-C
  cp_vend_no3100056
  publish_flagY
  group_id4
  price_group_id2802
  finish_id0
  ships_by_itselfN
  shipping_width4
  shipping_height1
  shipping_length21
  shipping_weight2
  acutal_weightY
  shipping_header_id0
  free_shipping_itemN
  stock_status_id0
  description_override
  clear_override(false)
  cp1_descriptionCyan 440cc Eco-Sol Ink, SPL
  auto_desc
  keyword
  keyword_2
  color_id44
  item_id0
  csi
  color_selector_id0
  color_number
  cp1_statusA
  taxable
  min8
  max16
  qty_avail10
  qty_on_hand10
  qty_on_po0
  qty_on_bo0
  qty_commit0
  last_po_date2026-02-04
  instock_override
  created2014-01-27 16:47:52
  modified2026-01-14 17:00:50
  cp1_write_off
  cp1_categ_cod3000
  cp1_subcat_cod3501
  cp1_categ_subcat3000/3501
  photo_square
  hideN
  sale_end0000-00-00
  sale_price0.00
  sale_start0000-00-00
  legacy_id0
  legacy_source
  kit_partN
  kit_flag
  kitableN
  fedx_flag
  ups_flagY
  cp1_export2016-01-23
  cp1_sync2021-10-15
  cp1_update2021-10-15
  cp1_export_flag
  unit_id12
  User(array)
  id1274
  legacy_id0
  m1_id4689
  user_bill_to_id1083
  user_group_id2
  usernamellight
  emailleann.light@agraphics.biz
  first_nameLeann
  last_nameLight
  title
  phone
  phone_ext
  cell
  active1
  email_verified1
  last_login2026-03-24 14:05:32
  last_order2025-10-06 12:46:22
  by_admin1
  ip_address72.172.196.43
  created2025-04-21 09:11:00
  created_by_id0
  modified2025-10-06 12:46:22
  modified_by_id0
  password1f734d7a80bbd60f6c45a9fb43354e516d975502962bb3b894a7d16082f8e01a
  saltHoLC6KWWVAAsT5M5c6YXVUdH/pNsfpzmSA9kTDtyeVr0O0Ka0Zeb/uYvN1rVT68c
  password_v4
  salt_v4
  send_direct_mail
  send_email
  unsubscribe(false)
  unsubscribe_reason
  mailchimp_leid
  soft_delete
  referral_id0
  key_code
  start_controller
  fb_id(null)
  fb_access_token(null)
  twt_id(null)
  twt_access_secret(null)
  ldn_id(null)
  twt_access_token(null)
  is_old_password0
  remember(false)
  created12025-04-21 09:11:00
  created22025-04-21 09:11:00
  StockStatus(array)
  id435
  descriptionIn Stock
  a10n
  sortB
  groups
  specification_id21
  iconnone
  text_color#38761d
  index_flag
  active
- session_id(null)
- totals(array)
  t_qty6
  t_price599.94
- page_titleReview Order | Schillers DPG
- referBack/
- isMobileN
- $request->data(empty)
- $this->validationErrors(array)
  UserSetting(empty)
  User(empty)
  UserGroup(empty)
  UserActivity(empty)
  Cart(empty)
  Item(empty)
  StockStatus(empty)
  Cp1SpecialPrice(empty)
  InkType(empty)
- Loaded Helpers(array)
  0Form
  1Html
  2Session
  3Js
  4UserAuth
  5Image
  6Number
  7SimpleGraph
  8DebugTimer
  9Toolbar
  10Flash
  11HtmlToolbar
====

Time	Message
2026-03-24 14:36:47	Data AppController:

Environment

App Constants

Constant	Value
CONFIG	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/Config/
AUTHORIZENET_LOG_FILE	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/tmp/logs/auth_net.log
SITE_URL	https://dpgtest.schillers.com/
SITE_NAME	Schillers, DPG
SITE_REGISTRATION	1
ALLOW_DELETE_ACCOUNT	0
SEND_REGISTRATION_MAIL	1
SEND_PASSWORD_CHANGE_MAIL	1
EMAIL_VERIFICATION	0
EMAIL_FROM_ADDRESS	dpg@schillers.com
EMAIL_FROM_NAME	Schillers, DPG
ALLOW_CHANGE_USERNAME	1
BANNED_USERNAMES	Administrator, SuperAdmin
USE_RECAPTCHA	0
PRIVATE_KEY_FROM_RECAPTCHA
PUBLIC_KEY_FROM_RECAPTCHA
LOGIN_REDIRECT_URL	/
LOGOUT_REDIRECT_URL	/
PERMISSIONS	1
ADMIN_PERMISSIONS	0
DEFAULT_GROUP_ID	2
ADMIN_GROUP_ID	1
GUEST_GROUP_ID	3
USE_FB_LOGIN	0
FB_APP_ID
FB_SECRET
FB_SCOPE	user_status, publish_stream, email
USE_TWT_LOGIN	0
TWT_APP_ID
TWT_SECRET
USE_GMAIL_LOGIN	0
GMAIL_API_KEY
GMAIL_CLIENT_ID
GMAIL_CLIENT_SECRET
USE_YAHOO_LOGIN	0
USE_LDN_LOGIN	0
LDN_API_KEY
LDN_SECRET_KEY
USE_FS_LOGIN	0
FS_CLIENT_ID
FS_CLIENT_SECRET
VIEW_ONLINE_USER_TIME	30
USE_HTTPS	1
HTTPS_URLS
IMG_DIR	umphotos_not_used
QRDN	12345694
LOGIN_COOKIE_NAME	UMPremiumCookie
DEFAULT_IMAGE_PATH	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/Plugin/Usermgmt/webroot/img/default.jpg
DEFAULT_IMAGE_URL	https://dpgtest.schillers.com/usermgmt/img/default.jpg
ADMIN_EMAIL_ADDRESS	s.moeckel@schillers.com
USE_RECAPTCHA_ON_LOGIN	0
BAD_LOGIN_ALLOW_COUNT	5
USE_RECAPTCHA_ON_REGISTRATION	0
USE_RECAPTCHA_ON_FORGOT_PASSWORD	0
USE_RECAPTCHA_ON_EMAIL_VERIFICATION	0
USE_REMEMBER_ME	1
ALLOW_USER_MULTIPLE_LOGIN	1
ALLOW_ADMIN_MULTIPLE_LOGIN	1
LOGIN_IDLE_TIME	120

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/Lib/
CACHE	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/tmp/cache/
CAKE	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/lib
CORE_PATH	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/lib/
CAKE_VERSION	2.10.7
CSS	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://dpgtest.schillers.com
IMAGES	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/tmp/logs/
ROOT	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com
TESTS	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/Test/
TMP	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/tmp/
VENDORS	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.5.38
Path	/sbin:/usr/sbin:/bin:/usr/bin
Pp Custom Php Ini	/var/www/vhosts/system/dpgtest.schillers.com/etc/php.ini
Pp Custom Php Cgi Index	plesk-php55-fastcgi
Http Connection	close
Script Name	/app/webroot/index.php
Request Uri	/carts/edit_cart
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/carts/edit_cart
Remote Port	14484
Script Filename	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/webroot/index.php
Server Admin	root@localhost
Document Root	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com
Remote Addr	216.73.216.111
Server Port	443
Server Addr	74.208.101.187
Server Name	dpgtest.schillers.com
Server Software	Apache
Server Signature	<address>Apache Server at dpgtest.schillers.com Port 443</address>
Http Host	dpgtest.schillers.com
Http Accept Encoding	gzip, br, zstd, deflate
Http Cookie	CAKEPHP=qn60cfefk95fqrf60cg17gfjs0
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Ssl Tls Sni	dpgtest.schillers.com
Https	on
Unique Id	acLnz0rQSlAAAFYNOy8AAAAK
Redirect Status	200
Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Https	on
Redirect Unique Id	acLnz0rQSlAAAFYNOy8AAAAK
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Redirect Https	on
Redirect Redirect Unique Id	acLnz0rQSlAAAFYNOy8AAAAK
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1774381007.6578
Request Time	1774381007

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/lib
- 2/opt/plesk/php/5.5/share/pear
- 3-> /var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/FlashComponent.php
  2CORE/Controller/Component/RequestHandlerComponent.php
  3CORE/Controller/Component/PaginatorComponent.php
  4CORE/Controller/Component/CookieComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  4CORE/Model/ModelValidator.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/dpgComponent.php
  1APP/Controller/Component/upsComponent.php
  2APP/Controller/Component/tempComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/CartsController.php
  1APP/Controller/AppController.php
  2APP/Controller/AccountsController.php
  3APP/Controller/AssetsController.php
  4APP/Controller/BrandsController.php
  5APP/Controller/CatalogsController.php
  6APP/Controller/CategoriesController.php
  7APP/Controller/CategoriesProductsController.php
  8APP/Controller/ColorSelectorItemsController.php
  9APP/Controller/ColorSelectorsController.php
  10APP/Controller/CompaniesController.php
  11APP/Controller/ConfigurationsController.php
  12APP/Controller/Cp1SpecialPricesController.php
  13APP/Controller/DocsController.php
  14APP/Controller/DpgAssetsController.php
  15APP/Controller/Ec1SeoRedirectLogsController.php
  16APP/Controller/Ec1SeoRedirectsController.php
  17APP/Controller/ExportsController.php
  18APP/Controller/FreightCodesController.php
  19APP/Controller/GroupsController.php
  20APP/Controller/ImportsController.php
  21APP/Controller/InkProductsController.php
  22APP/Controller/InkTypesController.php
  23APP/Controller/ItemHistoriesController.php
  24APP/Controller/ItemsController.php
  25APP/Controller/KitsController.php
  26APP/Controller/M1AssetTypesController.php
  27APP/Controller/M1AssetsController.php
  28APP/Controller/M1CompaniesController.php
  29APP/Controller/M1CompanyAssetsController.php
  30APP/Controller/MarketingsController.php
  31APP/Controller/OrderLinesController.php
  32APP/Controller/OrdersController.php
  33APP/Controller/PagesController.php
  34APP/Controller/PaymentTermsController.php
  35APP/Controller/PhotosController.php
  36APP/Controller/ProductSideBarsController.php
  37APP/Controller/ProductsController.php
  38APP/Controller/RegistrationsController.php
  39APP/Controller/SeeAlsosController.php
  40APP/Controller/SeoRedirectsController.php
  41APP/Controller/ShippingHeadersController.php
  42APP/Controller/ShippingRatesController.php
  43APP/Controller/SitemapsController.php
  44APP/Controller/SlidersController.php
  45APP/Controller/SpecificationDetailsController.php
  46APP/Controller/SpecificationsController.php
  47APP/Controller/SubGroupsController.php
  48APP/Controller/TemplatesController.php
  49APP/Controller/TestMethodsController.php
  50APP/Controller/UnitsController.php
  51APP/Controller/UtilitiesController.php
  52APP/Controller/VendorsController.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/Model/Cart.php
  2APP/Model/Item.php
  3APP/Model/SpecificationDetail.php
  4APP/Model/Cp1SpecialPrice.php
  5APP/Model/InkType.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/autoload.php
  2APP/Vendor/composer/autoload_real.php
  3APP/Vendor/composer/ClassLoader.php
  4APP/Vendor/composer/autoload_namespaces.php
  5APP/Vendor/composer/autoload_psr4.php
  6APP/Vendor/composer/autoload_classmap.php
  7APP/Vendor/composer/autoload_files.php
  8APP/Vendor/symfony/polyfill-mbstring/bootstrap.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Controller(array)
  0DebugKit/Controller/DebugKitAppController.php
  1DebugKit/Controller/ToolbarAccessController.php
  Usermgmt(array)
  Config(array)
  0Usermgmt/Config/bootstrap.php
  1Usermgmt/Config/routes.php
  Plugin(array)
  0Usermgmt/Lib/routes/SlugRoute.php
  Component(array)
  0Usermgmt/Controller/Component/UserAuthComponent.php
  1Usermgmt/Controller/Component/ControllerListComponent.php
  2Usermgmt/Controller/Component/SslComponent.php
  Model(array)
  0Usermgmt/Model/UserSetting.php
  1Usermgmt/Model/UserMgmtAppModel.php
  2Usermgmt/Model/User.php
  3Usermgmt/Model/UserGroup.php
  4Usermgmt/Model/UserActivity.php
  Controller(array)
  0Usermgmt/Controller/UserMgmtAppController.php
  1Usermgmt/Controller/AutocompleteController.php
  2Usermgmt/Controller/ContentsController.php
  3Usermgmt/Controller/UserBillTosController.php
  4Usermgmt/Controller/UserCompaniesController.php
  5Usermgmt/Controller/UserContactsController.php
  6Usermgmt/Controller/UserEmailSignaturesController.php
  7Usermgmt/Controller/UserEmailTemplatesController.php
  8Usermgmt/Controller/UserEmailsController.php
  9Usermgmt/Controller/UserGroupPermissionsController.php
  10Usermgmt/Controller/UserGroupsController.php
  11Usermgmt/Controller/UserSettingsController.php
  12Usermgmt/Controller/UserShipTosController.php
  13Usermgmt/Controller/UsersController.php
====

Shopping Cart

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 504 ms Total Queries: 49 queries

Query Explain:

Memory

Timers

Logs

debug

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 504 ms
Total Queries: 49 queries