20-mil Solvent Satin Canvas (ESM-SSC2), By Certified Media, Roland DGA

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent46c5404893f7d8e229da7750c4799343
  time1765006767
  countdown10
- UserAuth(empty)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerproducts
- actionshop
- named(empty)
- pass(array)
  0Roland-DGA-ESM-SSC2-Canvas-Print-Media
- 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: 444 ms
Total Queries: 81 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` = '46c5404893f7d8e229da7750c4799343nbv30lid3ovegl2bhcibpr8ui7' LIMIT 1	0	0	425	maybe slow
BEGIN
INSERT INTO `dpg_ecommerce`.`user_activities` (`useragent`, `user_id`, `last_action`, `last_url`, `user_browser`, `ip_address`, `status`, `modified`, `created`) VALUES ('46c5404893f7d8e229da7750c4799343nbv30lid3ovegl2bhcibpr8ui7', NULL, 1765006767, '/products/shop/Roland-DGA-ESM-SSC2-Canvas-Print-Media', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '216.73.216.151', 0, '2025-12-05 21:39:27', '2025-12-05 21:39:27')	1	1	0
COMMIT
SELECT `Product`.`id`, `Product`.`name`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`slug` = 'Roland-DGA-ESM-SSC2-Canvas-Print-Media' LIMIT 1	1	1	1
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `Group`.`id`, `Group`.`name`, `Group`.`a10n`, `SubGroup`.`id`, `SubGroup`.`name`, `SubGroup`.`group_id`, `SubGroup`.`a10n`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template`, `StockStatus`.`id`, `StockStatus`.`description`, `StockStatus`.`text_color`, `PrimaryBrand`.`id`, `PrimaryBrand`.`parent_id`, `PrimaryBrand`.`lft`, `PrimaryBrand`.`rght`, `PrimaryBrand`.`name`, `PrimaryBrand`.`template_id`, `PrimaryBrand`.`slug`, `PrimaryBrand`.`meta_tag_title`, `PrimaryBrand`.`meta_tag_description`, `PrimaryBrand`.`url`, `PrimaryBrand`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` LEFT JOIN `dpg_ecommerce`.`groups` AS `Group` ON (`Product`.`group_id` = `Group`.`id`) LEFT JOIN `dpg_ecommerce`.`sub_groups` AS `SubGroup` ON (`Product`.`sub_group_id` = `SubGroup`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Product`.`template_id` = `Template`.`id`) LEFT JOIN `dpg_ecommerce`.`specification_details` AS `StockStatus` ON (`Product`.`stock_status_id` = `StockStatus`.`id`) LEFT JOIN `dpg_ecommerce`.`brands` AS `PrimaryBrand` ON (`Product`.`primary_brand_id` = `PrimaryBrand`.`id`) WHERE ((`Product`.`publish_flag` != 'N') AND (`Product`.`id` = 1539)) ORDER BY `Product`.`id` ASC LIMIT 1	1	1	0
SELECT `Item`.`id`, `Item`.`cp1_item`, `Item`.`product_parent`, `Item`.`sell`, `Item`.`org_sell`, `Item`.`sell_override`, `Item`.`cost`, `Item`.`org_cost`, `Item`.`std_cost`, `Item`.`org_std_cost`, `Item`.`last_cost`, `Item`.`org_last_cost`, `Item`.`fixed_cost`, `Item`.`org_fixed_cost`, `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`.`cost_update`, `Item`.`cost_update_method`, `Item`.`last_cost_update`, `Item`.`last_cost_update_method`, `Item`.`fixed_cost_update`, `Item`.`fixed_cost_update_method`, `Item`.`sell_update`, `Item`.`sell_update_method`, `Item`.`sell_strategy`, `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`, `ItemsProduct`.`id`, `ItemsProduct`.`item_id`, `ItemsProduct`.`product_id` FROM `dpg_ecommerce`.`items` AS `Item` JOIN `dpg_ecommerce`.`items_products` AS `ItemsProduct` ON (`ItemsProduct`.`product_id` = 1539 AND `ItemsProduct`.`item_id` = `Item`.`id`) WHERE `Item`.`publish_flag` != 'N'	4	4	1	maybe slow
SELECT `Item_Unit`.`id`, `Item_Unit`.`name`, `Item_Unit`.`conversion`, `Item_Unit`.`a10n`, `Item_Unit`.`purpose`, `Item_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Item_Unit` WHERE `Item_Unit`.`id` = 18	1	1	0
SELECT `Item_Unit`.`id`, `Item_Unit`.`name`, `Item_Unit`.`conversion`, `Item_Unit`.`a10n`, `Item_Unit`.`purpose`, `Item_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Item_Unit` WHERE `Item_Unit`.`id` = 18	1	1	0
SELECT `Item_Unit`.`id`, `Item_Unit`.`name`, `Item_Unit`.`conversion`, `Item_Unit`.`a10n`, `Item_Unit`.`purpose`, `Item_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Item_Unit` WHERE `Item_Unit`.`id` = 18	1	1	0
SELECT `Item_Unit`.`id`, `Item_Unit`.`name`, `Item_Unit`.`conversion`, `Item_Unit`.`a10n`, `Item_Unit`.`purpose`, `Item_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Item_Unit` WHERE `Item_Unit`.`id` = 18	1	1	0
SELECT `Dim1_Unit`.`id`, `Dim1_Unit`.`name`, `Dim1_Unit`.`conversion`, `Dim1_Unit`.`a10n`, `Dim1_Unit`.`purpose`, `Dim1_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim1_Unit` WHERE `Dim1_Unit`.`id` = 13	1	1	0
SELECT `Dim1_Unit`.`id`, `Dim1_Unit`.`name`, `Dim1_Unit`.`conversion`, `Dim1_Unit`.`a10n`, `Dim1_Unit`.`purpose`, `Dim1_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim1_Unit` WHERE `Dim1_Unit`.`id` = 13	1	1	0
SELECT `Dim1_Unit`.`id`, `Dim1_Unit`.`name`, `Dim1_Unit`.`conversion`, `Dim1_Unit`.`a10n`, `Dim1_Unit`.`purpose`, `Dim1_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim1_Unit` WHERE `Dim1_Unit`.`id` = 13	1	1	0
SELECT `Dim1_Unit`.`id`, `Dim1_Unit`.`name`, `Dim1_Unit`.`conversion`, `Dim1_Unit`.`a10n`, `Dim1_Unit`.`purpose`, `Dim1_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim1_Unit` WHERE `Dim1_Unit`.`id` = 13	1	1	0
SELECT `Dim2_Unit`.`id`, `Dim2_Unit`.`name`, `Dim2_Unit`.`conversion`, `Dim2_Unit`.`a10n`, `Dim2_Unit`.`purpose`, `Dim2_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim2_Unit` WHERE `Dim2_Unit`.`id` = 1	1	1	0
SELECT `Dim2_Unit`.`id`, `Dim2_Unit`.`name`, `Dim2_Unit`.`conversion`, `Dim2_Unit`.`a10n`, `Dim2_Unit`.`purpose`, `Dim2_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim2_Unit` WHERE `Dim2_Unit`.`id` = 1	1	1	0
SELECT `Dim2_Unit`.`id`, `Dim2_Unit`.`name`, `Dim2_Unit`.`conversion`, `Dim2_Unit`.`a10n`, `Dim2_Unit`.`purpose`, `Dim2_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim2_Unit` WHERE `Dim2_Unit`.`id` = 1	1	1	0
SELECT `Dim2_Unit`.`id`, `Dim2_Unit`.`name`, `Dim2_Unit`.`conversion`, `Dim2_Unit`.`a10n`, `Dim2_Unit`.`purpose`, `Dim2_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim2_Unit` WHERE `Dim2_Unit`.`id` = 1	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 1	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 1	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 1	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 1	1	1	0
SELECT `PriceGroup`.`id`, `PriceGroup`.`description`, `PriceGroup`.`a10n`, `PriceGroup`.`sort`, `PriceGroup`.`groups`, `PriceGroup`.`specification_id`, `PriceGroup`.`icon`, `PriceGroup`.`text_color`, `PriceGroup`.`index_flag`, `PriceGroup`.`active` FROM `dpg_ecommerce`.`specification_details` AS `PriceGroup` WHERE `PriceGroup`.`id` = 2802	0	0	0
SELECT `PriceGroup`.`id`, `PriceGroup`.`description`, `PriceGroup`.`a10n`, `PriceGroup`.`sort`, `PriceGroup`.`groups`, `PriceGroup`.`specification_id`, `PriceGroup`.`icon`, `PriceGroup`.`text_color`, `PriceGroup`.`index_flag`, `PriceGroup`.`active` FROM `dpg_ecommerce`.`specification_details` AS `PriceGroup` WHERE `PriceGroup`.`id` = 2802	0	0	0
SELECT `PriceGroup`.`id`, `PriceGroup`.`description`, `PriceGroup`.`a10n`, `PriceGroup`.`sort`, `PriceGroup`.`groups`, `PriceGroup`.`specification_id`, `PriceGroup`.`icon`, `PriceGroup`.`text_color`, `PriceGroup`.`index_flag`, `PriceGroup`.`active` FROM `dpg_ecommerce`.`specification_details` AS `PriceGroup` WHERE `PriceGroup`.`id` = 2802	0	0	0
SELECT `PriceGroup`.`id`, `PriceGroup`.`description`, `PriceGroup`.`a10n`, `PriceGroup`.`sort`, `PriceGroup`.`groups`, `PriceGroup`.`specification_id`, `PriceGroup`.`icon`, `PriceGroup`.`text_color`, `PriceGroup`.`index_flag`, `PriceGroup`.`active` FROM `dpg_ecommerce`.`specification_details` AS `PriceGroup` WHERE `PriceGroup`.`id` = 2802	0	0	0
SELECT `StockStatus`.`id`, `StockStatus`.`description`, `StockStatus`.`text_color` FROM `dpg_ecommerce`.`specification_details` AS `StockStatus` WHERE `StockStatus`.`id` = 0	0	0	0
SELECT `StockStatus`.`id`, `StockStatus`.`description`, `StockStatus`.`text_color` FROM `dpg_ecommerce`.`specification_details` AS `StockStatus` WHERE `StockStatus`.`id` = 0	0	0	0
SELECT `StockStatus`.`id`, `StockStatus`.`description`, `StockStatus`.`text_color` FROM `dpg_ecommerce`.`specification_details` AS `StockStatus` WHERE `StockStatus`.`id` = 0	0	0	0
SELECT `StockStatus`.`id`, `StockStatus`.`description`, `StockStatus`.`text_color` FROM `dpg_ecommerce`.`specification_details` AS `StockStatus` WHERE `StockStatus`.`id` = 0	0	0	0
SELECT `Color`.`id`, `Color`.`description`, `Color`.`a10n`, `Color`.`sort`, `Color`.`groups`, `Color`.`specification_id`, `Color`.`icon`, `Color`.`text_color`, `Color`.`index_flag`, `Color`.`active` FROM `dpg_ecommerce`.`specification_details` AS `Color` WHERE `Color`.`id` = 0	0	0	0
SELECT `Color`.`id`, `Color`.`description`, `Color`.`a10n`, `Color`.`sort`, `Color`.`groups`, `Color`.`specification_id`, `Color`.`icon`, `Color`.`text_color`, `Color`.`index_flag`, `Color`.`active` FROM `dpg_ecommerce`.`specification_details` AS `Color` WHERE `Color`.`id` = 0	0	0	0
SELECT `Color`.`id`, `Color`.`description`, `Color`.`a10n`, `Color`.`sort`, `Color`.`groups`, `Color`.`specification_id`, `Color`.`icon`, `Color`.`text_color`, `Color`.`index_flag`, `Color`.`active` FROM `dpg_ecommerce`.`specification_details` AS `Color` WHERE `Color`.`id` = 0	0	0	0
SELECT `Color`.`id`, `Color`.`description`, `Color`.`a10n`, `Color`.`sort`, `Color`.`groups`, `Color`.`specification_id`, `Color`.`icon`, `Color`.`text_color`, `Color`.`index_flag`, `Color`.`active` FROM `dpg_ecommerce`.`specification_details` AS `Color` WHERE `Color`.`id` = 0	0	0	0
SELECT `ShippingHeader`.`id`, `ShippingHeader`.`name`, `ShippingHeader`.`a10n`, `ShippingHeader`.`zones`, `ShippingHeader`.`extra_fee` FROM `dpg_ecommerce`.`shipping_headers` AS `ShippingHeader` WHERE `ShippingHeader`.`id` = 0	1	1	0
SELECT `ShippingHeader`.`id`, `ShippingHeader`.`name`, `ShippingHeader`.`a10n`, `ShippingHeader`.`zones`, `ShippingHeader`.`extra_fee` FROM `dpg_ecommerce`.`shipping_headers` AS `ShippingHeader` WHERE `ShippingHeader`.`id` = 0	1	1	0
SELECT `ShippingHeader`.`id`, `ShippingHeader`.`name`, `ShippingHeader`.`a10n`, `ShippingHeader`.`zones`, `ShippingHeader`.`extra_fee` FROM `dpg_ecommerce`.`shipping_headers` AS `ShippingHeader` WHERE `ShippingHeader`.`id` = 0	1	1	0
SELECT `ShippingHeader`.`id`, `ShippingHeader`.`name`, `ShippingHeader`.`a10n`, `ShippingHeader`.`zones`, `ShippingHeader`.`extra_fee` FROM `dpg_ecommerce`.`shipping_headers` AS `ShippingHeader` WHERE `ShippingHeader`.`id` = 0	1	1	0
SELECT `ShippingRates`.`id`, `ShippingRates`.`weight`, `ShippingRates`.`value`, `ShippingRates`.`shipping_header_id` FROM `dpg_ecommerce`.`shipping_rates` AS `ShippingRates` WHERE `ShippingRates`.`shipping_header_id` = 0 AND `ShippingRates`.`weight` = '11' LIMIT 1	0	0	0
SELECT `ShippingRates`.`id`, `ShippingRates`.`weight`, `ShippingRates`.`value`, `ShippingRates`.`shipping_header_id` FROM `dpg_ecommerce`.`shipping_rates` AS `ShippingRates` WHERE `ShippingRates`.`shipping_header_id` = 0 AND `ShippingRates`.`weight` = '22' LIMIT 1	0	0	0
SELECT `ShippingRates`.`id`, `ShippingRates`.`weight`, `ShippingRates`.`value`, `ShippingRates`.`shipping_header_id` FROM `dpg_ecommerce`.`shipping_rates` AS `ShippingRates` WHERE `ShippingRates`.`shipping_header_id` = 0 AND `ShippingRates`.`weight` = '10' LIMIT 1	0	0	0
SELECT `ShippingRates`.`id`, `ShippingRates`.`weight`, `ShippingRates`.`value`, `ShippingRates`.`shipping_header_id` FROM `dpg_ecommerce`.`shipping_rates` AS `ShippingRates` WHERE `ShippingRates`.`shipping_header_id` = 0 AND `ShippingRates`.`weight` = '20' LIMIT 1	0	0	0
SELECT `Specification`.`id`, `Specification`.`name` FROM `dpg_ecommerce`.`specifications` AS `Specification` WHERE `Specification`.`id` = 21 LIMIT 1	1	1	0
SELECT `SpecificationDetail`.`id`, `SpecificationDetail`.`description`, `SpecificationDetail`.`a10n`, `SpecificationDetail`.`sort`, `SpecificationDetail`.`groups`, `SpecificationDetail`.`specification_id`, `SpecificationDetail`.`icon`, `SpecificationDetail`.`text_color`, `SpecificationDetail`.`index_flag`, `SpecificationDetail`.`active` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`specification_id` = (21)	11	11	0
SELECT `Specification`.`id`, `Specification`.`name` FROM `dpg_ecommerce`.`specifications` AS `Specification` WHERE `Specification`.`id` = 21 LIMIT 1	1	1	0
SELECT `SpecificationDetail`.`id`, `SpecificationDetail`.`description`, `SpecificationDetail`.`a10n`, `SpecificationDetail`.`sort`, `SpecificationDetail`.`groups`, `SpecificationDetail`.`specification_id`, `SpecificationDetail`.`icon`, `SpecificationDetail`.`text_color`, `SpecificationDetail`.`index_flag`, `SpecificationDetail`.`active` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`specification_id` = (21)	11	11	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 17 LIMIT 1	1	1	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 304 LIMIT 1	1	1	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 17 LIMIT 1	1	1	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 304 LIMIT 1	1	1	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1	0	0	0
SELECT `ProductSideBar`.`id`, `ProductSideBar`.`heading_text`, `ProductSideBar`.`heading_text_id`, `ProductSideBar`.`product_id`, `ProductSideBar`.`heading_color`, `ProductSideBar`.`heading_text_color`, `ProductSideBar`.`heading_icon`, `ProductSideBar`.`new_heading_icon`, `ProductSideBar`.`body_text`, `ProductSideBar`.`download_file_path`, `ProductSideBar`.`download_icon_path`, `ProductSideBar`.`download_icon_alt_text`, `ProductSideBar`.`footer_text_id`, `ProductSideBar`.`footer_color`, `ProductSideBar`.`footer_text_color`, `ProductSideBar`.`footer_text`, `ProductSideBar`.`footer_body_text`, `ProductSideBar`.`footer_link`, `ProductSideBar`.`footer_icon`, `ProductSideBar`.`new_footer_icon`, `ProductSideBar`.`sort_flag`, `ProductSideBar`.`sort`, `ProductSideBar`.`publish_flag`, `ProductSideBar`.`type`, `ProductSideBar`.`new_type`, `ProductSideBar`.`product_link_id`, `ProductSideBar`.`product_link_path`, `ProductSideBar`.`file_flag`, `ProductSideBar`.`position` FROM `dpg_ecommerce`.`product_side_bars` AS `ProductSideBar` WHERE `ProductSideBar`.`product_id` = 1539 AND `ProductSideBar`.`publish_flag` = 'Y' ORDER BY `ProductSideBar`.`sort` ASC	0	0	0
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`, `UserBillTo`.`id`, `UserBillTo`.`m1_id`, `UserBillTo`.`name`, `UserBillTo`.`address1`, `UserBillTo`.`address2`, `UserBillTo`.`city`, `UserBillTo`.`state`, `UserBillTo`.`zip`, `UserBillTo`.`phone`, `UserBillTo`.`fax`, `UserBillTo`.`web_page`, `UserBillTo`.`web`, `UserBillTo`.`cp1_account`, `UserBillTo`.`payment_term_id`, `UserBillTo`.`freight_code_id`, `UserBillTo`.`tax_cod`, `UserBillTo`.`tax_number`, `UserBillTo`.`created`, `UserBillTo`.`modified`, `UserBillTo`.`last_login`, `UserBillTo`.`last_order`, `UserBillTo`.`last_sale`, `UserBillTo`.`saleperson_id`, `UserBillTo`.`salesperson`, `UserBillTo`.`assigned_to_id`, `UserBillTo`.`sync`, `UserBillTo`.`m1_import`, `UserBillTo`.`active`, `UserBillTo`.`keywords`, `UserBillTo`.`key_code` FROM `dpg_ecommerce`.`cp1_special_prices` AS `Cp1SpecialPrice` LEFT JOIN `dpg_ecommerce`.`user_bill_tos` AS `UserBillTo` ON (`UserBillTo`.`cp1_account` = `Cp1SpecialPrice`.`CUST_NO`) WHERE ((((`Cp1SpecialPrice`.`CUST_NO` IS NULL) AND (`UserBillTo`.`name` IS NULL))) OR (`Cp1SpecialPrice`.`CUST_NO` IS NULL)) ORDER BY `Cp1SpecialPrice`.`RUL_SEQ_NO` DESC	2	2	1	maybe slow
SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1008793 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` = 1008793 AND (((Item.cp1_item >= '1002487') and (Item.cp1_item <= '1002487')))	0	0	2	maybe slow
SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1109582 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` = 1109582 AND (((Item.cp1_item >= '1002487') and (Item.cp1_item <= '1002487')))	0	0	2	maybe slow
SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 9010708 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` = 9010708 AND (((Item.cp1_item >= '1002487') and (Item.cp1_item <= '1002487')))	0	0	2	maybe slow
SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 9010709 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` = 9010709 AND (((Item.cp1_item >= '1002487') and (Item.cp1_item <= '1002487')))	0	0	2	maybe slow
SELECT `Product`.`id`, `Product`.`name` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1539 LIMIT 1	1	1	0
SELECT `SeeAlso`.`id`, `SeeAlso`.`name`, `SeeAlso`.`product_id`, `SeeAlso`.`override`, `SeeAlso`.`sort`, `SeeAlso`.`publish_flag` FROM `dpg_ecommerce`.`see_alsos` AS `SeeAlso` WHERE `SeeAlso`.`product_id` = (1539)	0	0	0
SELECT `InkType`.`id`, `InkType`.`name` FROM `dpg_ecommerce`.`ink_types` AS `InkType` WHERE 1 = 1	20	20	0

43 duplicate queries run.

Query Explain:

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

====

Timer

Memory

Peak Memory Use 28.44 MB

Message	Memory use
Component initialization	5.54 MB
Controller action start	17.28 MB
Controller render start	19.60 MB
View render complete	21.86 MB

Timers

Total Request Time: 646 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	29.66
Event: Controller.initialize	474.66
Event: Controller.startup	1.32
Controller action	47.21
Event: Controller.beforeRender	17.31
» Processing toolbar data	16.18
Rendering View	8.27
» Event: View.beforeRender	0.05
» Rendering APP/View/Products/shop.ctp	3.44
» » Rendering APP/View/Elements/Templates/product_V2.ctp	3.17
» » » Rendering APP/View/Elements/Products/shop/group_1.ctp	0.12
» » » Rendering APP/View/Elements/Templates/item_tableV2.ctp	2.68
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	3.85
» » Rendering APP/View/Elements/header_menu.ctp	0.22
» » Rendering APP/View/Elements/Pages/default_page.ctp	2.33
» » » Rendering APP/View/Elements/hMenu01.ctp	1.72
» » » » Rendering APP/View/Elements/Search/productSearch.ctp	0.30
» » » Rendering APP/Plugin/Usermgmt/View/Elements/message.ctp	0.11
» » » Rendering APP/Plugin/Usermgmt/View/Elements/message_validation.ctp	0.08
» » Rendering APP/View/Elements/dpg-footer.ctp	0.08
» » Rendering APP/View/Elements/final-footer.ctp	0.08
Event: View.afterLayout	0.00

====

Log

Logs

debug

Time	Message
2025-12-05 21:39:27	Data AppController:
2025-12-05 21:39:27	Array ( [ ] => Array ( [0] => Array ( [id] => 10708 [cp1_item] => 9010708 [product_parent] => ROL-ESM-SSC2 [price_group] => [price_group_sort] => [vitem] => ESM-SSC2-45-20 [keyword] => [keyword_2] => [sell] => 135.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 101.99 [lease] => 0 [last_cost] => 0.00 [publish_flag] => Y [cp1_write_off] => [description] => 20" x 45f [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#b30000">Special Order</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 20.000 [sortB] => 45.000 [image] => Array ( [icon] => [alt] => Certified Media, Roland DGA Part Number ESM-SSC2-45-20 for 20" x 45f ) [kit_flag] => ) [1] => Array ( [id] => 10709 [cp1_item] => 9010709 [product_parent] => ROL-ESM-SSC2 [price_group] => [price_group_sort] => [vitem] => ESM-SSC2-99-20 [keyword] => [keyword_2] => [sell] => 235.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 176.99 [lease] => 0 [last_cost] => 0.00 [publish_flag] => Y [cp1_write_off] => [description] => 20" x 99f [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#b30000">Special Order</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 20.000 [sortB] => 99.000 [image] => Array ( [icon] => [alt] => Certified Media, Roland DGA Part Number ESM-SSC2-99-20 for 20" x 99f ) [kit_flag] => ) [2] => Array ( [id] => 231 [cp1_item] => 1008793 [product_parent] => ROL-ESM-SSC2 [price_group] => [price_group_sort] => [vitem] => ESM-SSC2-99-30 [keyword] => [keyword_2] => [sell] => 353.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 241.49 [lease] => 0 [last_cost] => 241.49 [publish_flag] => Y [cp1_write_off] => [description] => 30" x 99f [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#b30000">Special Order</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 30.000 [sortB] => 99.000 [image] => Array ( [icon] => [alt] => Certified Media, Roland DGA Part Number ESM-SSC2-99-30 for 30" x 99f ) [kit_flag] => ) [3] => Array ( [id] => 341 [cp1_item] => 1109582 [product_parent] => ROL-ESM-SSC2 [price_group] => [price_group_sort] => [vitem] => ESM-SSC2-99-54 [keyword] => [keyword_2] => [sell] => 635.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 434.24 [lease] => 0 [last_cost] => 434.24 [publish_flag] => Y [cp1_write_off] => [description] => 54" x 99f [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#b30000">Special Order</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 54.000 [sortB] => 99.000 [image] => Array ( [icon] => [alt] => Certified Media, Roland DGA Part Number ESM-SSC2-99-54 for 54" x 99f ) [kit_flag] => ) ) )
2025-12-05 21:39:27	layout_default default.ctp:
2025-12-05 21:39:27	Data default_page:

====

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)
- product(array)
  Product(array)
  id1539
  name20-mil Solvent Satin Canvas (ESM-SSC2)
  cat_name
  cart_name{WxLu} 20-mil Satin Cotton Blend Canvas (ESM-SSC2)
  cart_short_name{WxLu}
  child_nameROL-ESM-SSC2
  short_nameESM-SSC2
  keyword
  keyword_2
  publish_flagY
  slug_lockN
  slugRoland-DGA-ESM-SSC2-Canvas-Print-Media
  group_id1
  sub_group_id7
  primary_brand_id2
  template_id39
  sub_template_id0
  descriptionSolvent Satin Canvas
  description_1
  description_2
  description_3
  description_4
  description_heading
  description_1_heading
  description_2_heading
  description_3_heading
  description_4_heading
  footer
  footer_heading
  description_short
  photo_rectangular
  photo_rectangular_2
  photo_square
  flag_url
  adhesive_id0
  adhesive_thickness_dimension0.000
  adhesive_thickness_id0
  application_temperature_range_id0
  back_side_id0
  base_stock_id304
  block_out
  block_out_id0
  carrier_id0
  carrier_thickness_dimension0.000
  carrier_thickness_id0
  color_id0
  exclusion_id0
  film_thickness_dimension0.000
  film_thickness_id0
  finish_id17
  flag_id0
  free_shipping_itemN
  ht_cut_direction_id0
  ht_peel_id0
  ht_preheat
  ht_pressure_id0
  ht_temp_id0
  ht_time_id0
  inside_durability_id0
  outside_durability_id0
  layerable
  liner_id0
  liner_thickness_dimension0.000
  liner_thickness_id0
  min_application_temperature_id0
  removability_id0
  removal_temperature_range_id0
  service_temperature_range_id0
  shelf_life_id0
  sort_idN
  stock_status_flagN
  stock_status_rating0
  stock_status_id437
  storage_requirement_id0
  thickness_dimension20.000
  thickness_id142
  total_thickness_dimension0.000
  total_thickness_id0
  meta_tag_title
  meta_tag_description
  meta_brandCertified Media, Roland DGA
  meta_categoriesCanvas, Digital Print Media
  meta_certifications
  meta_cp1_items1008793, 1109582, 9010708, 9010709
  meta_vitemsESM-SSC2-45-20, ESM-SSC2-99-20, ESM-SSC2-99-30, ESM-SSC2-99-54
  meta_ink_types
  meta_specifications20-mil Satin • 65% polyester 35% Cotton Blend Canvas
  meta_substrates
  manual_key_words
  key_words(ESM-SSC2), 1008793, 1109582, 20-mil, 9010708, 9010709, Canvas, Certified Media, DGA, Digital Print Media, ESM, ESM-SSC2, ESM-SSC2-45-20, ESM-SSC2-99-20, ESM-SSC2-99-30, ESM-SSC2-99-54, Media, Print, ROL-ESM-SSC2, Roland, Roland DGA, SSC2, Satin, Solvent
  washability_id0
  m1_sync2022-06-23 00:00:00
  dpg_sync0000-00-00 00:00:00
  std_price_update0000-00-00 00:00:00
  sell_update0000-00-00 00:00:00
  sell_strategy
  ink_type_id0
  profile_id0
  cs_count0
  created0000-00-00
  modified2024-05-02
  Group(array)
  id1
  namePrinting
  a10nPrint Media
  SubGroup(array)
  id7
  nameCanvas
  group_id1
  a10n
  Template(array)
  id39
  nameProduct w/vitem
  notesUses item_tableV2 Show vitem vs keyword
  templateproduct_V2.ctp
  StockStatus(array)
  id437
  descriptionSpecial Order
  text_color#b30000
  PrimaryBrand(array)
  id2
  parent_id(null)
  lft111
  rght124
  nameRoland DGA
  template_id9
  slugDigital_Print_Group_Brands_Roland_DGA
  meta_tag_title
  meta_tag_description
  urlhttps://www.rolanddga.com/
  publish_flagY
  Item(array)
  0(array)
  id231
  cp1_item1008793
  product_parentROL-ESM-SSC2
  sell353.99
  org_sell321.99
  sell_override
  cost241.49
  org_cost0.00
  std_cost241.49
  org_std_cost0.00
  last_cost241.49
  org_last_cost0.00
  fixed_cost0.00
  org_fixed_cost241.49
  dim130.000
  dim1_unit_id13
  dim299.000
  dim2_unit_id1
  item_unit_id18
  vitemESM-SSC2-99-30
  cp_vend_noROLAND
  publish_flagY
  group_id1
  price_group_id2802
  finish_id0
  ships_by_itselfY
  shipping_width10
  shipping_height10
  shipping_length34
  shipping_weight11
  acutal_weight
  shipping_header_id0
  free_shipping_itemN
  stock_status_id0
  description_override
  clear_override(false)
  cp1_description30"x99f ESM-SSC2 Roland Certified
  auto_desc
  keyword
  keyword_2
  color_id0
  item_id0
  csiN
  color_selector_id0
  color_number
  cp1_statusA
  taxable
  min0
  max0
  qty_avail0
  qty_on_hand0
  qty_on_po0
  qty_on_bo0
  qty_commit0
  last_po_date2024-06-18
  instock_override
  created2013-10-30 17:20:42
  modified2025-12-05 17:00:27
  cost_update2023-05-15
  cost_update_methodClipboard 05/15/23
  last_cost_update2023-05-15
  last_cost_update_methodClipboard 05/15/23
  fixed_cost_update2024-08-07
  fixed_cost_update_methodInotify Update DPG Items:
  sell_update2025-06-06
  sell_update_methodInotify Update DPG Items:
  sell_strategy
  cp1_write_off
  cp1_categ_cod3000
  cp1_subcat_cod3203
  cp1_categ_subcat3000/3203
  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_id1
  ItemsProduct(array)
  id47158
  item_id231
  product_id1539
  Item_Unit(array)
  id18
  nameRoll
  conversion1.0000
  a10nRoll
  purposelinear
  sortZZ
  Dim1_Unit(array)
  id13
  nameInches
  conversion1.0000
  a10n"
  purposeeach
  sortA
  Dim2_Unit(array)
  id1
  nameFeet
  conversion12.0000
  a10nf
  purposelinear
  sortC
  Group(array)
  id1
  namePrinting
  a10nPrint Media
  PriceGroup(empty)
  StockStatus(empty)
  Color(empty)
  ShippingHeader(array)
  id0
  nameN/A
  a10nN/A
  zones(null)
  extra_fee(null)
  value
  1(array)
  id341
  cp1_item1109582
  product_parentROL-ESM-SSC2
  sell635.99
  org_sell578.99
  sell_override
  cost434.24
  org_cost0.00
  std_cost434.24
  org_std_cost0.00
  last_cost434.24
  org_last_cost0.00
  fixed_cost0.00
  org_fixed_cost434.24
  dim154.000
  dim1_unit_id13
  dim299.000
  dim2_unit_id1
  item_unit_id18
  vitemESM-SSC2-99-54
  cp_vend_noROLAND
  publish_flagY
  group_id1
  price_group_id2802
  finish_id0
  ships_by_itselfY
  shipping_width10
  shipping_height10
  shipping_length57
  shipping_weight22
  acutal_weight
  shipping_header_id0
  free_shipping_itemN
  stock_status_id0
  description_override
  clear_override(false)
  cp1_description54"x99f ESM-SSC2 Roland Certified
  auto_desc
  keyword
  keyword_2
  color_id0
  item_id0
  csiN
  color_selector_id0
  color_number
  cp1_statusA
  taxable
  min0
  max0
  qty_avail0
  qty_on_hand0
  qty_on_po0
  qty_on_bo0
  qty_commit0
  last_po_date2020-11-10
  instock_override
  created2013-10-30 17:20:42
  modified2025-12-05 17:00:55
  cost_update2023-05-15
  cost_update_methodClipboard 05/15/23
  last_cost_update2023-05-15
  last_cost_update_methodClipboard 05/15/23
  fixed_cost_update2024-08-07
  fixed_cost_update_methodInotify Update DPG Items:
  sell_update2025-06-06
  sell_update_methodInotify Update DPG Items:
  sell_strategy
  cp1_write_off
  cp1_categ_cod3000
  cp1_subcat_cod3203
  cp1_categ_subcat3000/3203
  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_id1
  ItemsProduct(array)
  id47159
  item_id341
  product_id1539
  Item_Unit(array)
  id18
  nameRoll
  conversion1.0000
  a10nRoll
  purposelinear
  sortZZ
  Dim1_Unit(array)
  id13
  nameInches
  conversion1.0000
  a10n"
  purposeeach
  sortA
  Dim2_Unit(array)
  id1
  nameFeet
  conversion12.0000
  a10nf
  purposelinear
  sortC
  Group(array)
  id1
  namePrinting
  a10nPrint Media
  PriceGroup(empty)
  StockStatus(empty)
  Color(empty)
  ShippingHeader(array)
  id0
  nameN/A
  a10nN/A
  zones(null)
  extra_fee(null)
  value
  2(array)
  id10708
  cp1_item9010708
  product_parentROL-ESM-SSC2
  sell135.99
  org_sell0.00
  sell_override
  cost101.99
  org_cost0.00
  std_cost0.00
  org_std_cost0.00
  last_cost0.00
  org_last_cost0.00
  fixed_cost101.99
  org_fixed_cost0.00
  dim120.000
  dim1_unit_id13
  dim245.000
  dim2_unit_id1
  item_unit_id18
  vitemESM-SSC2-45-20
  cp_vend_noROLAND
  publish_flagY
  group_id1
  price_group_id2802
  finish_id0
  ships_by_itselfY
  shipping_width10
  shipping_height10
  shipping_length24
  shipping_weight10
  acutal_weight
  shipping_header_id0
  free_shipping_itemN
  stock_status_id0
  description_override
  clear_override(false)
  cp1_descriptionSolvent Satin Canvas, 20in x 45ft
  auto_desc
  keyword
  keyword_2
  color_id0
  item_id0
  csiN
  color_selector_id0
  color_number
  cp1_status
  taxableN
  min0
  max0
  qty_avail0
  qty_on_hand0
  qty_on_po0
  qty_on_bo0
  qty_commit0
  last_po_date0000-00-00
  instock_override
  created2023-05-15 11:42:40
  modified2025-06-06 11:45:13
  cost_update2023-05-15
  cost_update_methodClipboard 05/15/23
  last_cost_update2023-05-15
  last_cost_update_methodClipboard 05/15/23
  fixed_cost_update2023-05-15
  fixed_cost_update_methodClipboard 05/15/23
  sell_update2023-05-15
  sell_update_methodClipboard 05/15/23
  sell_strategy
  cp1_write_off
  cp1_categ_cod3000
  cp1_subcat_cod3203
  cp1_categ_subcat3000/3203
  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_export0000-00-00
  cp1_sync0000-00-00
  cp1_update0000-00-00
  cp1_export_flag
  unit_id0
  ItemsProduct(array)
  id47160
  item_id10708
  product_id1539
  Item_Unit(array)
  id18
  nameRoll
  conversion1.0000
  a10nRoll
  purposelinear
  sortZZ
  Dim1_Unit(array)
  id13
  nameInches
  conversion1.0000
  a10n"
  purposeeach
  sortA
  Dim2_Unit(array)
  id1
  nameFeet
  conversion12.0000
  a10nf
  purposelinear
  sortC
  Group(array)
  id1
  namePrinting
  a10nPrint Media
  PriceGroup(empty)
  StockStatus(empty)
  Color(empty)
  ShippingHeader(array)
  id0
  nameN/A
  a10nN/A
  zones(null)
  extra_fee(null)
  value
  3(array)
  id10709
  cp1_item9010709
  product_parentROL-ESM-SSC2
  sell235.99
  org_sell0.00
  sell_override
  cost176.99
  org_cost0.00
  std_cost0.00
  org_std_cost0.00
  last_cost0.00
  org_last_cost0.00
  fixed_cost176.99
  org_fixed_cost0.00
  dim120.000
  dim1_unit_id13
  dim299.000
  dim2_unit_id1
  item_unit_id18
  vitemESM-SSC2-99-20
  cp_vend_noROLAND
  publish_flagY
  group_id1
  price_group_id2802
  finish_id0
  ships_by_itselfY
  shipping_width10
  shipping_height10
  shipping_length24
  shipping_weight20
  acutal_weight
  shipping_header_id0
  free_shipping_itemN
  stock_status_id0
  description_override
  clear_override(false)
  cp1_descriptionSolvent Satin Canvas, 20in x 99ft
  auto_desc
  keyword
  keyword_2
  color_id0
  item_id0
  csiN
  color_selector_id0
  color_number
  cp1_status
  taxableN
  min0
  max0
  qty_avail0
  qty_on_hand0
  qty_on_po0
  qty_on_bo0
  qty_commit0
  last_po_date0000-00-00
  instock_override
  created2023-05-15 11:42:40
  modified2025-06-06 11:45:13
  cost_update2023-05-15
  cost_update_methodClipboard 05/15/23
  last_cost_update2023-05-15
  last_cost_update_methodClipboard 05/15/23
  fixed_cost_update2023-05-15
  fixed_cost_update_methodClipboard 05/15/23
  sell_update2023-05-15
  sell_update_methodClipboard 05/15/23
  sell_strategy
  cp1_write_off
  cp1_categ_cod3000
  cp1_subcat_cod3203
  cp1_categ_subcat3000/3203
  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_export0000-00-00
  cp1_sync0000-00-00
  cp1_update0000-00-00
  cp1_export_flag
  unit_id0
  ItemsProduct(array)
  id47161
  item_id10709
  product_id1539
  Item_Unit(array)
  id18
  nameRoll
  conversion1.0000
  a10nRoll
  purposelinear
  sortZZ
  Dim1_Unit(array)
  id13
  nameInches
  conversion1.0000
  a10n"
  purposeeach
  sortA
  Dim2_Unit(array)
  id1
  nameFeet
  conversion12.0000
  a10nf
  purposelinear
  sortC
  Group(array)
  id1
  namePrinting
  a10nPrint Media
  PriceGroup(empty)
  StockStatus(empty)
  Color(empty)
  ShippingHeader(array)
  id0
  nameN/A
  a10nN/A
  zones(null)
  extra_fee(null)
  value
  Finish** RESET **
  BaseStock65% polyester 35% Cotton Blend Canvas
- item_array(array)
  (array)
  0(array)
  id10708
  cp1_item9010708
  product_parentROL-ESM-SSC2
  price_group
  price_group_sort
  vitemESM-SSC2-45-20
  keyword
  keyword_2
  sell135.99
  sell_override
  sale_price0.00
  sale_range
  cost101.99
  lease0
  last_cost0.00
  publish_flagY
  cp1_write_off
  description20" x 45f
  free_shipping_itemN
  color_icon(array)
  icon
  alt
  qty_on_hand0
  stock_status_id0
  stock_status_text<span style="color:#b30000">Special Order</span>
  price_break
  price_break_flag
  order_qty
  cart_flagN
  sortA20.000
  sortB45.000
  image(array)
  icon
  altCertified Media, Roland DGA Part Number ESM-SSC2-45-20 for 20" x 45f
  kit_flag
  1(array)
  id10709
  cp1_item9010709
  product_parentROL-ESM-SSC2
  price_group
  price_group_sort
  vitemESM-SSC2-99-20
  keyword
  keyword_2
  sell235.99
  sell_override
  sale_price0.00
  sale_range
  cost176.99
  lease0
  last_cost0.00
  publish_flagY
  cp1_write_off
  description20" x 99f
  free_shipping_itemN
  color_icon(array)
  icon
  alt
  qty_on_hand0
  stock_status_id0
  stock_status_text<span style="color:#b30000">Special Order</span>
  price_break
  price_break_flag
  order_qty
  cart_flagN
  sortA20.000
  sortB99.000
  image(array)
  icon
  altCertified Media, Roland DGA Part Number ESM-SSC2-99-20 for 20" x 99f
  kit_flag
  2(array)
  id231
  cp1_item1008793
  product_parentROL-ESM-SSC2
  price_group
  price_group_sort
  vitemESM-SSC2-99-30
  keyword
  keyword_2
  sell353.99
  sell_override
  sale_price0.00
  sale_range
  cost241.49
  lease0
  last_cost241.49
  publish_flagY
  cp1_write_off
  description30" x 99f
  free_shipping_itemN
  color_icon(array)
  icon
  alt
  qty_on_hand0
  stock_status_id0
  stock_status_text<span style="color:#b30000">Special Order</span>
  price_break
  price_break_flag
  order_qty
  cart_flagN
  sortA30.000
  sortB99.000
  image(array)
  icon
  altCertified Media, Roland DGA Part Number ESM-SSC2-99-30 for 30" x 99f
  kit_flag
  3(array)
  id341
  cp1_item1109582
  product_parentROL-ESM-SSC2
  price_group
  price_group_sort
  vitemESM-SSC2-99-54
  keyword
  keyword_2
  sell635.99
  sell_override
  sale_price0.00
  sale_range
  cost434.24
  lease0
  last_cost434.24
  publish_flagY
  cp1_write_off
  description54" x 99f
  free_shipping_itemN
  color_icon(array)
  icon
  alt
  qty_on_hand0
  stock_status_id0
  stock_status_text<span style="color:#b30000">Special Order</span>
  price_break
  price_break_flag
  order_qty
  cart_flagN
  sortA54.000
  sortB99.000
  image(array)
  icon
  altCertified Media, Roland DGA Part Number ESM-SSC2-99-54 for 54" x 99f
  kit_flag
- templateproduct_V2
- productSideBars(empty)
- breadCrumb<a href="/">Digital Printer Group</a> / 20-mil Solvent Satin Canvas (ESM-SSC2)
- meta_tag_descriptionSolvent Satin Canvas
- page_title20-mil Solvent Satin Canvas (ESM-SSC2), By Certified Media, Roland DGA | Schiller's Digital Printer Group
- aSeeAlsos(array)
  Product(array)
  id1539
  name20-mil Solvent Satin Canvas (ESM-SSC2)
  SeeAlso(empty)
- isMobileN
- menu<div id="navigation"> <ul class="top-level"><li class= 'product' ><a href='/products/shop/'>Digital Print Media</a><ul class='sub-level'><li><a href='/categories/shop/Backlit-Digital-Print-Media'>Backlit</a><ul class='sub-level'><li><a href='/categories/shop/Backlit-Film-Digital-Print-Media'>Film</a></li><li><a href='/categories/shop/Digital-Print-Media-Backlit-Vinyl'>Vinyl</a></li></ul></li><li><a href='/categories/shop/Banner-Digital-Print-Media'>Banner</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Banner-1-Sided'>1-Sided</a></li><li><a href='/categories/shop/Digital-Print-Media-Banner-2-Sided'>2-Sided</a></li><li><a href='/categories/shop/Digital-Print-Media-Banner-Adhesive-Backed'>Adhesive Backed</a></li><li><a href='/categories/shop/Digital-Print-Media-Banner-RollUp'>RollUp</a></li><li><a href='/categories/shop/Mesh-Banner-Digital-Print-Media'>Mesh</a></li><li><a href='/categories/shop/Stands-Banner-Digital-Print-Media'>Stands</a></li></ul></li><li><a href='/categories/shop/Digital-Print-Media-CAD'>CAD</a></li><li><a href='/categories/shop/Canvas-Digital-Print-Media'>Canvas</a></li><li><a href='/categories/shop/Digital-Print-Media-Clear-Film'>Clear Film</a><ul class='sub-level'><li class= 'product' ><a href='/products/shop/STS-DTF-Clear-Film-Print-Media'>STS Direct to Film</a></li></ul></li><li><a href='/categories/shop/Digital-Print-Media-Dye-Sublimation-Paper'>Dye Sublimation Paper</a></li><li><a href='/categories/shop/Digital-Print-Media-Fabric'>Fabric</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Fabric-Printable'>Printable</a></li><li><a href='/categories/shop/Digital-Print-Media-Fabric-Dye-Sublimation'>Dye Sublimation</a></li></ul></li><li><a href='/categories/shop/Fine-Art-Digital-Print-Media'>Fine Art</a></li><li><a href='/categories/shop/Floor-Digital-Print-Media'>Floor</a></li><li><a href='/categories/shop/Digital-Print-Media-Magnetics'>Magnetics</a></li><li><a href='/categories/shop/Photobase-Digital-Print-Media'>Photobase</a><ul class='sub-level'><li><a href='/categories/shop/Dry-Lab-Photobase-Digital-Print-Media'>Dry Lab</a></li><li><a href='/categories/shop/Digital-Print-Media-Photobase-Adhesive-Backed'>Adhesive Backed</a></li><li><a href='/categories/shop/Digital-Print-Media-Photobase-Paper'>Paper</a></li></ul></li><li><a href='/categories/shop/Calendered-Vinyl-Digital-Print-Media'>Vinyl Calendered</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Clear'>Clear</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Translucent'>Translucent</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-White'>White</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Reflective'>Reflective</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Industrial'>Industrial 7-Year</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Air-Release'>Air Release</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Promotional'>Promotional 3-Year</a></li><li><a href='/categories/shop/Intermediate-Vinyl-Calendered-Digital-Print-Media'>Intermediate 5-Year</a></li><li><a href='/categories/shop/Promotional-3-Year-Air-Release-Vinyl-Calendered-Digital-Print-Media'>Promotional 3-Year Air Release </a></li><li><a href='/categories/shop/Intermediate-5-Year-Air-Release-Vinyl-Calendered-Digital-Print-Media'>Intermediate 5-Year Air Release</a></li></ul></li><li><a href='/categories/shop/Wall-Digital-Print-Media'>Wall</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Wall-PSA'>PSA</a></li><li><a href='/categories/shop/Digital-Print-Media-Wall-Wet-Strength-Paper'>Wet-Strength Paper</a></li><li><a href='/categories/shop/Digital-Print-Media-Wall-Wallpaper'>Wallpaper</a></li></ul></li><li><a href='/categories/shop/Windows-Digital-Print-Media'>Windows</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Windows-Cling'>Cling</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-PSA'>PSA</a></li><li><a href='/categories/shop/Perforated-Windows-Digital-Print-Media'>Perforated</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-60-40-Outside-Mount'>60/40 Outside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-50-50-Outside-Mount'>50/50 Outside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-60-40-Inside-Mount'>60/40 Inside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-80-20-Outside-Mount'>80/20 Outside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-65-35-Outside-Mount'>65/35 Outside Mount</a></li><li><a href='/categories/shop/70-30-Outside-Mount-Perforated-Windows-Digital-Print-Media'>70/30 Outside Mount</a></li><li><a href='/categories/shop/80-20-Inside-Mount-Perforated-Windows-Digital-Print-Media'>80/20 Inside Mount </a></li></ul></li><li><a href='/categories/shop/Printable-Etched-Windows-Digital-Print-Media'>Printable Etched</a></li></ul></li><li><a href='/categories/shop/Cast-Vinyl-Digital-Print-Media'>Vinyl Cast </a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-White'>White</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-Translucent'>Translucent</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-Vehicle-Wrap'> Vehicle Wrap</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-Air-Release'>Air Release</a></li><li><a href='/categories/shop/Reflective-Vinyl-Cast-Digital-Print-Media'>Reflective </a></li></ul></li><li><a href='/categories/shop/Presentation-Digital-Print-Media'>Presentation</a></li><li><a href='/categories/shop/RollUp-Banner-Digital-Print-Media'>RollUp</a></li><li><a href='/categories/shop/Heat-Transfer-Digital-Print-Media'>Heat Transfer</a><ul class='sub-level'><li><a href='/categories/shop/Print-Cut-Films-Heat-Transfer-Digital-Print-Media'>Print/Cut Films</a></li><li><a href='/categories/shop/Cut-Films-Heat-Transfer-Digital-Print-Media'>Cut Films</a></li><li><a href='/categories/shop/Transfer-Mask-Heat-Transfer-Digital-Print-Media'>Transfer Mask</a></li></ul></li><li><a href='/categories/shop/Proofing-Digital-Print-Media'>Proofing</a></li><li><a href='/categories/shop/Durables-Digital-Print-Media'>Durables</a></li><li><a href='/categories/shop/Styrene-Digital-Print-Media'>Styrene</a></li><li><a href='/categories/shop/POS-Digital-Print-Media'>POS</a></li></li></ul><li><a href='/categories/shop/Clearance'>Clearance</a><ul class='sub-level'></li></ul><li><a href='/categories/shop/Graphic-Sign'>Graphic/Sign</a><ul class='sub-level'><li><a href='/categories/shop/Graphic-Sign-Vinyl-Cutter-Blades'>Vinyl Cutter Blades</a><ul class='sub-level'><li><a href='/categories/shop/Graphic-Sign-Vinyl-Cutter-Blades-Roland'>Roland</a></li></ul></li><li><a href='/categories/shop/Graphic-Sign-Vinyl'>Sign Vinyl</a></li><li><a href='/categories/shop/Application-Tape-Graphic-Sign'>Application Tape</a></li></li></ul><li><a href='/categories/shop/Hardware'>Hardware</a><ul class='sub-level'><li><a href='/categories/shop/Hardware-Roland'>Roland</a><ul class='sub-level'><li><a href='/categories/shop/Resin-Roland'>Resin</a></li><li><a href='/categories/shop/Hardware-Roland-Print-Only'>Print Only</a></li><li><a href='/categories/shop/Hardware-Roland-Printer-Cutters'>Printer/Cutters</a></li><li><a href='/categories/shop/UV-Benchtop-Flatbed-Roland-Hardware'>UV Benchtop Flatbed</a></li><li><a href='/categories/shop/Hardware-Roland-UV-Printer-Cutters'>UV Printer/Cutters</a></li><li><a href='/categories/shop/Hardware-Roland-Vinyl-Cutters'>Vinyl Cutters</a></li><li><a href='/categories/shop/Hardware-Roland-Sublimation'>Sublimation</a></li><li><a href='/categories/shop/Hardware-Roland-Common-Replacement-Parts'>Replacement Parts</a></li><li><a href='/categories/shop/UV-Flatbed-Roland-Hardware'>UV Flatbed</a></li><li class= 'product' ><a href='/products/shop/Roland-DGA-XT-640S-DTG-Multi-Station-Direct-to-Garment-Printer'>Direct-to-Garment Printer</a></li></ul></li><li><a href='/categories/shop/Hardware-GFP-Graphic-Finish-Partners'>GFP (Graphic Finish Partners)</a></li><li><a href='/categories/shop/Vanguard-Digital-UV-Flatbed-Printer-Hardware'>Vanguard Digital UV Flatbed Printer</a></li></li></ul><li class= 'product' ><a href='/products/shop/'>Inks</a><ul class='sub-level'><li><a href='/categories/shop/Inks-Roland'>Roland</a><ul class='sub-level'><li><a href='/categories/shop/Garment-Roland-Inks'>Garment</a></li><li><a href='/categories/shop/Inks-Roland-Eco-UV'>Eco-UV</a></li><li><a href='/categories/shop/Inks-Roland-Eco-Sol-MAX'>Eco-Sol MAX</a></li><li><a href='/categories/shop/TrueVIS-Roland-Inks'>TrueVIS</a></li></ul></li><li><a href='/categories/shop/Inks-SPL-Brand'>SPL Brand</a><ul class='sub-level'><li><a href='/categories/shop/Inks-SPL-Brand-Roland'>Roland</a></li><li><a href='/categories/shop/Inks-SPL-Brand-Epson'>Epson</a></li><li><a href='/categories/shop/Inks-SPL-Brand-Canon'>Canon</a></li><li><a href='/categories/shop/Inks-SPL-Brand-Mutoh'>Mutoh</a></li><li><a href='/categories/shop/HP-SPL-Brand-Inks'>HP</a></li><li><a href='/categories/shop/Mimaki-SPL-Brand-Inks'>Mimaki</a></li><li><a href='/categories/shop/Oki-Data-SPL-Brand-Inks'>Oki Data</a></li></ul></li><li><a href='/categories/shop/Inks-Seiko-Okidata'>Seiko/Okidata</a></li><li><a href='/categories/shop/Inks-Canon'>Canon</a></li><li><a href='/categories/shop/Inks-Epson'>Epson</a><ul class='sub-level'><li><a href='/categories/shop/Inks-Epson-Epson-OEM'>Epson OEM</a></li><li><a href='/categories/shop/Inks-Epson-SPL-Brand'>SPL Brand</a></li></ul></li><li><a href='/categories/shop/Inks-UV-Adhesion-Promoters'>UV Adhesion Promoters</a></li><li><a href='/categories/shop/Vanguard-Digital-Inks'>Vanguard Digital</a></li><li><a href='/categories/shop/HP-Inks'>HP</a><ul class='sub-level'></ul></li><li><a href='/categories/shop/STS-Direct-to-Film-Supplies'>STS Direct to Film Supplies</a></li></li></ul><li><a href='/categories/shop/Lamination'>Lamination</a><ul class='sub-level'><li><a href='/categories/shop/Lamination-PSA'>PSA</a><ul class='sub-level'><li><a href='/categories/shop/Lamination-PSA-Foor'>Floor</a></li><li><a href='/categories/shop/Lamination-PSA-Cast'>Cast</a></li><li><a href='/categories/shop/Lamination-PSA-Calendered'>Calendered</a></li><li><a href='/categories/shop/Lamination-PSA-Polycarbonate'>Polycarbonate </a></li><li><a href='/categories/shop/Lamination-PSA-Speciality'>Speciality</a></li></ul></li><li class= 'product' ><a href='/products/shop/Kraft-Paper'>Kraft Paper</a></li><li><a href='/categories/shop/Thermal-Lamination-Supplies'>Thermal</a></li></li></ul><li><a href='/categories/shop/Mounting-Supplies'>Mounting</a><ul class='sub-level'><li><a href='/categories/shop/PSA-Mounting'>PSA</a><ul class='sub-level'><li><a href='/categories/shop/Mounting-PSA-Clear'>Clear</a></li><li><a href='/categories/shop/Mounting-PSA-White'>White</a></li><li><a href='/categories/shop/Mounting-PSA-Window'>Window</a></li></ul></li><li><a href='/categories/shop/Heat-Activated-Backing-Films-Mounting'>Heat-Activated Backing Films</a></li><li class= 'product' ><a href='/products/shop/Kraft-Paper'>Kraft Paper</a></li></li></ul><li><a href='/categories/shop/Shop-Tools-Supplies'>Shop Tools & Supplies</a><ul class='sub-level'><li><a href='/categories/shop/Shop-Tools-Supplies-Safety-Rulers'>Safety Rulers</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-Media-Racks'>Media Racks</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-Grommet-Press'>Grommet Press</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-UV-Adhesion-Promoters'>UV Adhesion Promoters</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-Grommets'>Grommets</a></li><li><a href='/categories/shop/Squeegees-Shop-Tools-Supplies'>Squeegees</a></li><li><a href='/categories/shop/Cutting-Tools-and-Supplies-Shop-Tools-Supplies'>Cutting Tools and Supplies</a></li><li><a href='/categories/shop/Weeding-Tools-Shop-Tools-Supplies'>Weeding Tools</a></li></li></ul><li><a href='/categories/shop/Heat-Transfer-Films'>Heat Transfer Films</a><ul class='sub-level'><li><a href='/categories/shop/Print-Cut-Films-Heat-Transfer-Films'>Print/Cut Films</a></li><li><a href='/categories/shop/Cut-Films-Heat-Transfer-Films'>Cut Films</a></li><li><a href='/categories/shop/Transfer-Mask-Heat-Transfer-Films'>Transfer Mask </a></li></li></ul><li><a href='/categories/shop/Sign-Vinyl'>Sign Vinyl</a><ul class='sub-level'><li><a href='/categories/shop/Premium-Sign-Vinyl'>Premium </a></li><li><a href='/categories/shop/Intermediate-Sign-Vinyl'>Intermediate </a></li><li><a href='/categories/shop/Decorative-Sign-Vinyl'>Decorative </a></li><li><a href='/categories/shop/Specialty-Sign-Vinyl'>Specialty</a></li><li><a href='/categories/shop/Reflective-Sign-Vinyl'>Reflective </a></li><li><a href='/categories/shop/Application-Tape-Sign-Vinyl'>Application Tape</a></li></li></ul><li><a href='/categories/shop/Best-Sellers'>Best Sellers</a><ul class='sub-level'><li><a href='/categories/shop/Print-Best-Sellers'>Print</a></li><li><a href='/categories/shop/Protection-Best-Sellers'>Protection</a></li><li><a href='/categories/shop/Mounting-Best-Sellers'>Mounting</a></li></li></ul><li><a href='/categories/shop/New-Products'>New Products</a><ul class='sub-level'></li></ul></ul></div>
- $request->data(empty)
- $this->validationErrors(array)
  UserSetting(empty)
  User(empty)
  UserGroup(empty)
  UserActivity(empty)
  Product(empty)
  Template(empty)
  PrimaryBrand(empty)
  Group(empty)
  SubGroup(empty)
  StockStatus(empty)
  Item(empty)
  Item_Unit(empty)
  Dim1_Unit(empty)
  Dim2_Unit(empty)
  ShippingHeader(empty)
  PriceGroup(empty)
  Color(empty)
  ItemsProduct(empty)
  ShippingRates(empty)
  Specification(empty)
  SpecificationDetail(empty)
  ProductSideBar(empty)
  Cp1SpecialPrice(empty)
  UserBillTo(empty)
  SeeAlso(empty)
  Releated(empty)
  InkType(empty)
  Cart(empty)
- Loaded Helpers(array)
  0Form
  1Html
  2Session
  3Js
  4UserAuth
  5Image
  6Recaptcha
  7Number
  8SimpleGraph
  9DebugTimer
  10Toolbar
  11Flash
  12HtmlToolbar
====

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	/products/shop/Roland-DGA-ESM-SSC2-Canvas-Print-Media
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/products/shop/Roland-DGA-ESM-SSC2-Canvas-Print-Media
Remote Port	22276
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.151
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 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	aTOlbkrQSlAAAHQVtVIAAACf
Redirect Status	200
Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Https	on
Redirect Unique Id	aTOlbkrQSlAAAHQVtVIAAACf
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Redirect Https	on
Redirect Redirect Unique Id	aTOlbkrQSlAAAHQVtVIAAACf
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1764992367.4038
Request Time	1764992367

====

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
  1CORE/Model/Behavior/TreeBehavior.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
  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/ProductsController.php
  1APP/Controller/AppController.php
  2APP/Controller/AccountsController.php
  3APP/Controller/AssetsController.php
  4APP/Controller/BrandsController.php
  5APP/Controller/CartsController.php
  6APP/Controller/CatalogsController.php
  7APP/Controller/CategoriesController.php
  8APP/Controller/CategoriesProductsController.php
  9APP/Controller/ColorSelectorItemsController.php
  10APP/Controller/ColorSelectorsController.php
  11APP/Controller/CompaniesController.php
  12APP/Controller/ConfigurationsController.php
  13APP/Controller/Cp1SpecialPricesController.php
  14APP/Controller/DocsController.php
  15APP/Controller/DpgAssetsController.php
  16APP/Controller/Ec1SeoRedirectLogsController.php
  17APP/Controller/Ec1SeoRedirectsController.php
  18APP/Controller/ExportsController.php
  19APP/Controller/FreightCodesController.php
  20APP/Controller/GroupsController.php
  21APP/Controller/ImportsController.php
  22APP/Controller/InkProductsController.php
  23APP/Controller/InkTypesController.php
  24APP/Controller/ItemHistoriesController.php
  25APP/Controller/ItemsController.php
  26APP/Controller/KitsController.php
  27APP/Controller/M1AssetTypesController.php
  28APP/Controller/M1AssetsController.php
  29APP/Controller/M1CompaniesController.php
  30APP/Controller/M1CompanyAssetsController.php
  31APP/Controller/MarketingsController.php
  32APP/Controller/OrderLinesController.php
  33APP/Controller/OrdersController.php
  34APP/Controller/PagesController.php
  35APP/Controller/PaymentTermsController.php
  36APP/Controller/PhotosController.php
  37APP/Controller/ProductSideBarsController.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/Product.php
  2APP/Model/Template.php
  3APP/Model/Brand.php
  4APP/Model/Group.php
  5APP/Model/SubGroup.php
  6APP/Model/SpecificationDetail.php
  7APP/Model/Item.php
  8APP/Model/Unit.php
  9APP/Model/ShippingHeader.php
  10APP/Model/Specification.php
  11APP/Model/ProductSideBar.php
  12APP/Model/Cp1SpecialPrice.php
  13APP/Model/SeeAlso.php
  14APP/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
  Recaptcha(array)
  Component(array)
  0Recaptcha/Controller/Component/RecaptchaComponent.php
  Behavior(array)
  0Recaptcha/Model/Behavior/RecaptchaBehavior.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
====

Description	Vendor #	Item #	Price
20" x 45f	ESM-SSC2-45-20	9010708	$135.99
20" x 99f	ESM-SSC2-99-20	9010709	$235.99
30" x 99f	ESM-SSC2-99-30	1008793	$353.99
54" x 99f	ESM-SSC2-99-54	1109582	$635.99

20-mil Solvent Satin Canvas (ESM-SSC2)

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 444 ms Total Queries: 81 queries

Query Explain:

Memory

Timers

Logs

debug

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 444 ms
Total Queries: 81 queries