20# Plain Bond Paper (JSB-20), By JetSet, Magic Brand

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

Cake Params
- plugin(null)
- controllerproducts
- actionshop
- named(empty)
- pass(array)
  0JetSet-JSB-20-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: 451 ms
Total Queries: 136 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` = '46c5404893f7d8e229da7750c47993431726kskqkirpi1pol5c7dn7pi5' LIMIT 1	0	0	413	maybe slow
BEGIN
INSERT INTO `dpg_ecommerce`.`user_activities` (`useragent`, `user_id`, `last_action`, `last_url`, `user_browser`, `ip_address`, `status`, `modified`, `created`) VALUES ('46c5404893f7d8e229da7750c47993431726kskqkirpi1pol5c7dn7pi5', NULL, 1765007064, '/products/shop/JetSet-JSB-20-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:44:25', '2025-12-05 21:44:25')	1	1	0
COMMIT
SELECT `Product`.`id`, `Product`.`name`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`slug` = 'JetSet-JSB-20-Print-Media' LIMIT 1	1	1	0
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` = 47)) 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` = 47 AND `ItemsProduct`.`item_id` = `Item`.`id`) WHERE `Item`.`publish_flag` != 'N'	9	9	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 `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 `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 `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 `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 `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` = 6	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` = 6	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 `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 `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 `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 `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 `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 `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 `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 `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 `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 `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` = '6' 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` = '9' 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` = '32' 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` = '12' 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` = '24' 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` = '14' 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` = '16' 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` = '8' 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` = '9' 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` = 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` = 98 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` = 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` = 98 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` = 47 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` = 1100503 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` = 1100503 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` = 1100549 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` = 1100549 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` = 1100550 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` = 1100550 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` = 1100497 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` = 1100497 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` = 1100502 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` = 1100502 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` = 1100509 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` = 1100509 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` = 1004464 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` = 1004464 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` = 1100511 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` = 1100511 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` = 1100512 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` = 1100512 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` = 47 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` = (47)	0	0	0
SELECT `InkType`.`id`, `InkType`.`name` FROM `dpg_ecommerce`.`ink_types` AS `InkType` WHERE 1 = 1	20	20	0

84 duplicate queries run.

Query Explain:

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

====

Timer

Memory

Peak Memory Use 26.24 MB

Message	Memory use
Component initialization	5.54 MB
Controller action start	17.27 MB
Controller render start	19.80 MB
View render complete	22.08 MB

Timers

Total Request Time: 670 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	35.07
Event: Controller.initialize	463.03
Event: Controller.startup	1.16
Controller action	66.48
Event: Controller.beforeRender	10.91
» Processing toolbar data	9.91
Rendering View	9.58
» Event: View.beforeRender	0.03
» Rendering APP/View/Products/shop.ctp	4.51
» » Rendering APP/View/Elements/Templates/product_V2.ctp	4.29
» » » Rendering APP/View/Elements/Products/shop/group_1.ctp	0.11
» » » Rendering APP/View/Elements/Templates/item_tableV2.ctp	3.90
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	4.17
» » Rendering APP/View/Elements/header_menu.ctp	0.26
» » Rendering APP/View/Elements/Pages/default_page.ctp	2.51
» » » Rendering APP/View/Elements/hMenu01.ctp	1.85
» » » » Rendering APP/View/Elements/Search/productSearch.ctp	0.32
» » » 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:44:24	Data AppController:
2025-12-05 21:44:25	Array ( [ ] => Array ( [0] => Array ( [id] => 104 [cp1_item] => 1100503 [product_parent] => JSB [price_group] => [price_group_sort] => [vitem] => 46291 [keyword] => [keyword_2] => [sell] => 24.68 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 15.52 [lease] => 0 [last_cost] => 9.60 [publish_flag] => Y [cp1_write_off] => [description] => 24" x 150f Roll [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#ff0000">Due In!</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 24.000 [sortB] => 150.000 [image] => Array ( [icon] => [alt] => JetSet, Magic Brand Part Number 46291 for 24" x 150f Roll ) [kit_flag] => ) [1] => Array ( [id] => 185 [cp1_item] => 1100502 [product_parent] => JSB [price_group] => [price_group_sort] => [vitem] => 14919 [keyword] => [keyword_2] => [sell] => 92.5 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 62.08 [lease] => 0 [last_cost] => 38.40 [publish_flag] => Y [cp1_write_off] => [description] => 24" x 150f Roll [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#ff0000">Due In!</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 24.000 [sortB] => 150.000 [image] => Array ( [icon] => [alt] => JetSet, Magic Brand Part Number 14919 for 24" x 150f Roll ) [kit_flag] => ) [2] => Array ( [id] => 152 [cp1_item] => 1100497 [product_parent] => JSB [price_group] => [price_group_sort] => [vitem] => 37282 [keyword] => [keyword_2] => [sell] => 49.35 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 31.04 [lease] => 0 [last_cost] => 19.20 [publish_flag] => Y [cp1_write_off] => [description] => 24" x 300f Roll [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#ff0000">Due In!</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 24.000 [sortB] => 300.000 [image] => Array ( [icon] => [alt] => JetSet, Magic Brand Part Number 37282 for 24" x 300f Roll ) [kit_flag] => ) [3] => Array ( [id] => 150 [cp1_item] => 1100511 [product_parent] => JSB [price_group] => [price_group_sort] => [vitem] => 46292 [keyword] => [keyword_2] => [sell] => 30.83 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 19.39 [lease] => 0 [last_cost] => 12.00 [publish_flag] => Y [cp1_write_off] => [description] => 30" x 50y Roll [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#ff0000">Due In!</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 30.000 [sortB] => 50.000 [image] => Array ( [icon] => [alt] => JetSet, Magic Brand Part Number 46292 for 30" x 50y Roll ) [kit_flag] => ) [4] => Array ( [id] => 162 [cp1_item] => 1100509 [product_parent] => JSB [price_group] => [price_group_sort] => [vitem] => 38168 [keyword] => [keyword_2] => [sell] => 61.71 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 38.81 [lease] => 0 [last_cost] => 17.90 [publish_flag] => Y [cp1_write_off] => [description] => 30" x 300f Roll [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#ff0000">Due In!</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 30.000 [sortB] => 300.000 [image] => Array ( [icon] => [alt] => JetSet, Magic Brand Part Number 38168 for 30" x 300f Roll ) [kit_flag] => ) [5] => Array ( [id] => 156 [cp1_item] => 1100512 [product_parent] => JSB [price_group] => [price_group_sort] => [vitem] => 46784 [keyword] => [keyword_2] => [sell] => 41.94 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 26.38 [lease] => 0 [last_cost] => 13.24 [publish_flag] => Y [cp1_write_off] => [description] => 34" x 50y Roll [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#ff0000">Due In!</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 34.000 [sortB] => 50.000 [image] => Array ( [icon] => [alt] => JetSet, Magic Brand Part Number 46784 for 34" x 50y Roll ) [kit_flag] => ) [6] => Array ( [id] => 101 [cp1_item] => 1100550 [product_parent] => JSB [price_group] => [price_group_sort] => [vitem] => 60805 [keyword] => [keyword_2] => [sell] => 138.81 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 93.16 [lease] => 0 [last_cost] => 93.16 [publish_flag] => Y [cp1_write_off] => [description] => 36" x 150f Roll [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#ff0000">Due In!</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 36.000 [sortB] => 150.000 [image] => Array ( [icon] => [alt] => JetSet, Magic Brand Part Number 60805 for 36" x 150f Roll ) [kit_flag] => ) [7] => Array ( [id] => 154 [cp1_item] => 1100549 [product_parent] => JSB [price_group] => [price_group_sort] => [vitem] => 46293 [keyword] => [keyword_2] => [sell] => 37.03 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 23.29 [lease] => 0 [last_cost] => 14.40 [publish_flag] => Y [cp1_write_off] => [description] => 36" x 150f Roll [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#ff0000">Due In!</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 36.000 [sortB] => 150.000 [image] => Array ( [icon] => [alt] => JetSet, Magic Brand Part Number 46293 for 36" x 150f Roll ) [kit_flag] => ) [8] => Array ( [id] => 167 [cp1_item] => 1004464 [product_parent] => JSB [price_group] => [price_group_sort] => [vitem] => 30126 [keyword] => [keyword_2] => [sell] => 74.03 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 46.56 [lease] => 0 [last_cost] => 28.80 [publish_flag] => Y [cp1_write_off] => [description] => 36" x 300f Roll [free_shipping_item] => N [color_icon] => Array ( [icon] => [alt] => ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#ff0000">Due In!</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => 36.000 [sortB] => 300.000 [image] => Array ( [icon] => [alt] => JetSet, Magic Brand Part Number 30126 for 36" x 300f Roll ) [kit_flag] => ) ) )
2025-12-05 21:44:25	layout_default default.ctp:
2025-12-05 21:44:25	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)
 id47
 name20# Plain Bond Paper (JSB-20)
 cat_name
 cart_name{WxLu} {item_unit} {product_name}
 cart_short_name{WxLu} {item_unit}
 child_nameITC-JSB-20
 short_nameJSB20
 keyword
 keyword_2
 publish_flagY
 slug_lockY
 slugJetSet-JSB-20-Print-Media
 group_id1
 sub_group_id28
 primary_brand_id3
 template_id39
 sub_template_id0
 descriptionJSB-20 20# Plain Bond Paper
 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_id98
 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_id0
 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_idZ
 stock_status_flagN
 stock_status_rating0
 stock_status_id560
 storage_requirement_id0
 thickness_dimension20.000
 thickness_id144
 total_thickness_dimension0.000
 total_thickness_id0
 meta_tag_title
 meta_tag_description
 meta_brandJetSet, Magic Brand
 meta_categoriesCAD
 meta_certifications
 meta_cp1_items1004464, 1100497, 1100502, 1100503, 1100509, 1100511, 1100512, 1100549, 1100550
 meta_vitems14919, 30126, 37282, 38168, 46291, 46292, 46293, 46784, 60805
 meta_ink_typesDye
 meta_specifications20-# • Plain Bond Paper
 meta_substrates
 manual_key_words
 key_words(JSB-20), 20, 14919, 30126, 37282, 38168, 46291, 46292, 46293, 46784, 60805, 1004464, 1100497, 1100502, 1100503, 1100509, 1100511, 1100512, 1100549, 1100550, 20#, Bond, CAD, Dye, ITC-JSB-20, JSB, JSB20, JetSet, Magic Brand, Media, Paper, Plain, Print
 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)
 id28
 nameCAD
 group_id1
 a10n
 Template(array)
 id39
 nameProduct w/vitem
 notesUses item_tableV2 Show vitem vs keyword
 templateproduct_V2.ctp
 StockStatus(array)
 id560
 descriptionDue In!
 text_color#ff0000
 PrimaryBrand(array)
 id3
 parent_id(null)
 lft67
 rght68
 nameMagic Brand
 template_id16
 slugDigital_Print_Group_Brands_Magic_Brand
 meta_tag_title
 meta_tag_description
 urlhttps://www.magicinkjet.com
 publish_flagY
 Item(array)
 0(array)
 id104
 cp1_item1100503
 product_parentJSB
 sell24.68
 org_sell0.00
 sell_override
 cost15.52
 org_cost0.00
 std_cost15.52
 org_std_cost0.00
 last_cost9.60
 org_last_cost0.00
 fixed_cost0.00
 org_fixed_cost15.52
 dim124.000
 dim1_unit_id13
 dim2150.000
 dim2_unit_id1
 item_unit_id18
 vitem46291
 cp_vend_noINTCOA
 publish_flagY
 group_id1
 price_group_id2802
 finish_id0
 ships_by_itselfY
 shipping_width5
 shipping_height5
 shipping_length26
 shipping_weight6
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_description24"x50y JSB-20 JetSet
 auto_desc
 keyword
 keyword_2
 color_id0
 item_id0
 csi
 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_date2015-09-21
 instock_override
 created2013-10-30 17:20:41
 modified2025-12-05 17:00:40
 cost_update2022-12-27
 cost_update_methodInotify Update DPG Items:
 last_cost_update0000-00-00
 last_cost_update_methodInotify Update Items
 fixed_cost_update2024-08-07
 fixed_cost_update_methodInotify Update DPG Items:
 sell_update2022-12-27
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3225
 cp1_categ_subcat3000/3225
 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_export2024-04-08
 cp1_sync2021-10-15
 cp1_update2021-10-15
 cp1_export_flag
 unit_id6
 ItemsProduct(array)
 id45987
 item_id104
 product_id47
 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)
 id154
 cp1_item1100549
 product_parentJSB
 sell37.03
 org_sell0.00
 sell_override
 cost23.29
 org_cost0.00
 std_cost23.29
 org_std_cost0.00
 last_cost14.40
 org_last_cost0.00
 fixed_cost0.00
 org_fixed_cost23.29
 dim136.000
 dim1_unit_id13
 dim2150.000
 dim2_unit_id1
 item_unit_id18
 vitem46293
 cp_vend_noINTCOA
 publish_flagY
 group_id1
 price_group_id2802
 finish_id0
 ships_by_itselfY
 shipping_width7
 shipping_height7
 shipping_length39
 shipping_weight9
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_description36"x50y JSB-20 JetSet
 auto_desc
 keyword
 keyword_2
 color_id0
 item_id0
 csi
 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_date2015-05-13
 instock_override
 created2013-10-30 17:20:42
 modified2025-12-05 17:00:41
 cost_update2022-12-27
 cost_update_methodInotify Update DPG Items:
 last_cost_update0000-00-00
 last_cost_update_methodInotify Update Items
 fixed_cost_update2024-08-07
 fixed_cost_update_methodInotify Update DPG Items:
 sell_update2022-12-27
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3225
 cp1_categ_subcat3000/3225
 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_export2024-04-08
 cp1_sync2021-10-15
 cp1_update2021-10-15
 cp1_export_flag
 unit_id6
 ItemsProduct(array)
 id45988
 item_id154
 product_id47
 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)
 id101
 cp1_item1100550
 product_parentJSB
 sell138.81
 org_sell0.00
 sell_override
 cost93.16
 org_cost0.00
 std_cost93.16
 org_std_cost0.00
 last_cost93.16
 org_last_cost57.60
 fixed_cost0.00
 org_fixed_cost93.16
 dim136.000
 dim1_unit_id13
 dim2150.000
 dim2_unit_id1
 item_unit_id18
 vitem60805
 cp_vend_noINTCOA
 publish_flagY
 group_id1
 price_group_id2802
 finish_id0
 ships_by_itselfY
 shipping_width9
 shipping_height9
 shipping_length37
 shipping_weight32
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_description36"x50y JSB-20 JetSet (4-Pack)
 auto_desc
 keyword
 keyword_2
 color_id0
 item_id0
 csi
 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_date2025-10-10
 instock_override
 created2013-10-30 17:20:41
 modified2025-12-05 17:00:41
 cost_update2022-12-27
 cost_update_methodInotify Update DPG Items:
 last_cost_update2025-10-10
 last_cost_update_methodInotify Update DPG Items:
 fixed_cost_update2024-08-07
 fixed_cost_update_methodInotify Update DPG Items:
 sell_update2022-12-27
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3225
 cp1_categ_subcat3000/3225
 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_export2024-04-08
 cp1_sync2021-10-15
 cp1_update2021-10-15
 cp1_export_flag
 unit_id6
 ItemsProduct(array)
 id45989
 item_id101
 product_id47
 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)
 id152
 cp1_item1100497
 product_parentJSB
 sell49.35
 org_sell0.00
 sell_override
 cost31.04
 org_cost0.00
 std_cost31.04
 org_std_cost0.00
 last_cost19.20
 org_last_cost0.00
 fixed_cost0.00
 org_fixed_cost31.04
 dim124.000
 dim1_unit_id13
 dim2300.000
 dim2_unit_id1
 item_unit_id18
 vitem37282
 cp_vend_noINTCOA
 publish_flagY
 group_id1
 price_group_id2802
 finish_id0
 ships_by_itselfY
 shipping_width7
 shipping_height7
 shipping_length26
 shipping_weight12
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_description24"x300f JSB-20 JetSet (2 Rolls)
 auto_desc
 keyword
 keyword_2
 color_id0
 item_id0
 csi
 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_date2016-03-09
 instock_override
 created2013-10-30 17:20:42
 modified2025-12-05 17:00:40
 cost_update2022-12-27
 cost_update_methodInotify Update DPG Items:
 last_cost_update0000-00-00
 last_cost_update_methodInotify Update Items
 fixed_cost_update2024-08-07
 fixed_cost_update_methodInotify Update DPG Items:
 sell_update2022-12-27
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3225
 cp1_categ_subcat3000/3225
 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_export2024-04-08
 cp1_sync2021-10-15
 cp1_update2021-10-15
 cp1_export_flag
 unit_id1
 ItemsProduct(array)
 id45990
 item_id152
 product_id47
 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
 4(array)
 id185
 cp1_item1100502
 product_parentJSB
 sell92.50
 org_sell0.00
 sell_override
 cost62.08
 org_cost0.00
 std_cost62.08
 org_std_cost0.00
 last_cost38.40
 org_last_cost0.00
 fixed_cost0.00
 org_fixed_cost62.08
 dim124.000
 dim1_unit_id13
 dim2150.000
 dim2_unit_id1
 item_unit_id18
 vitem14919
 cp_vend_noINTCOA
 publish_flagY
 group_id1
 price_group_id2802
 finish_id0
 ships_by_itselfY
 shipping_width8
 shipping_height8
 shipping_length26
 shipping_weight24
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_description24"x50y JSB-20 JetSet (4 Rolls)
 auto_desc
 keyword
 keyword_2
 color_id0
 item_id0
 csi
 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_date2017-10-03
 instock_override
 created2013-10-30 17:20:42
 modified2025-12-05 17:00:40
 cost_update2022-12-27
 cost_update_methodInotify Update DPG Items:
 last_cost_update0000-00-00
 last_cost_update_methodInotify Update Items
 fixed_cost_update2024-08-07
 fixed_cost_update_methodInotify Update DPG Items:
 sell_update2022-12-27
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3225
 cp1_categ_subcat3000/3225
 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_export2024-04-08
 cp1_sync2021-10-15
 cp1_update2021-10-15
 cp1_export_flag
 unit_id6
 ItemsProduct(array)
 id45991
 item_id185
 product_id47
 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
 5(array)
 id162
 cp1_item1100509
 product_parentJSB
 sell61.71
 org_sell0.00
 sell_override
 cost38.81
 org_cost0.00
 std_cost38.81
 org_std_cost0.00
 last_cost17.90
 org_last_cost0.00
 fixed_cost0.00
 org_fixed_cost38.81
 dim130.000
 dim1_unit_id13
 dim2300.000
 dim2_unit_id1
 item_unit_id18
 vitem38168
 cp_vend_noINTCOA
 publish_flagY
 group_id1
 price_group_id2802
 finish_id0
 ships_by_itselfY
 shipping_width7
 shipping_height7
 shipping_length32
 shipping_weight14
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_description30"x300f JSB-20 JetSet
 auto_desc
 keyword
 keyword_2
 color_id0
 item_id0
 csi
 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_date0000-00-00
 instock_override
 created2013-10-30 17:20:42
 modified2025-12-05 17:00:40
 cost_update2022-12-27
 cost_update_methodInotify Update DPG Items:
 last_cost_update2024-07-18
 last_cost_update_methodInotify Update DPG Items:
 fixed_cost_update2024-08-07
 fixed_cost_update_methodInotify Update DPG Items:
 sell_update2022-12-27
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3225
 cp1_categ_subcat3000/3225
 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_export2024-04-08
 cp1_sync2021-10-15
 cp1_update2021-10-15
 cp1_export_flag
 unit_id1
 ItemsProduct(array)
 id45992
 item_id162
 product_id47
 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
 6(array)
 id167
 cp1_item1004464
 product_parentJSB
 sell74.03
 org_sell0.00
 sell_override
 cost46.56
 org_cost0.00
 std_cost46.56
 org_std_cost0.00
 last_cost28.80
 org_last_cost0.00
 fixed_cost0.00
 org_fixed_cost46.56
 dim136.000
 dim1_unit_id13
 dim2300.000
 dim2_unit_id1
 item_unit_id18
 vitem30126
 cp_vend_noINTCOA
 publish_flagY
 group_id1
 price_group_id2802
 finish_id0
 ships_by_itselfY
 shipping_width7
 shipping_height7
 shipping_length39
 shipping_weight16
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_description36"x300f JSB-20 JetSet
 auto_desc
 keyword
 keyword_2
 color_id0
 item_id0
 csi
 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_date2016-03-21
 instock_override
 created2013-10-30 17:20:42
 modified2025-12-05 17:00:23
 cost_update2022-12-27
 cost_update_methodInotify Update DPG Items:
 last_cost_update0000-00-00
 last_cost_update_methodInotify Update Items
 fixed_cost_update2024-08-07
 fixed_cost_update_methodInotify Update DPG Items:
 sell_update2022-12-27
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3225
 cp1_categ_subcat3000/3225
 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_export2024-04-08
 cp1_sync2021-10-15
 cp1_update2021-10-15
 cp1_export_flag
 unit_id1
 ItemsProduct(array)
 id45993
 item_id167
 product_id47
 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
 7(array)
 id150
 cp1_item1100511
 product_parentJSB
 sell30.83
 org_sell0.00
 sell_override
 cost19.39
 org_cost0.00
 std_cost19.39
 org_std_cost0.00
 last_cost12.00
 org_last_cost0.00
 fixed_cost0.00
 org_fixed_cost19.39
 dim130.000
 dim1_unit_id13
 dim250.000
 dim2_unit_id6
 item_unit_id18
 vitem46292
 cp_vend_noINTCOA
 publish_flagY
 group_id1
 price_group_id2802
 finish_id0
 ships_by_itselfY
 shipping_width5
 shipping_height5
 shipping_length32
 shipping_weight8
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_description30"x50y JSB-20 JetSet
 auto_desc
 keyword
 keyword_2
 color_id0
 item_id0
 csi
 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_date2014-01-15
 instock_override
 created2013-10-30 17:20:42
 modified2025-12-05 17:00:40
 cost_update2022-12-27
 cost_update_methodInotify Update DPG Items:
 last_cost_update0000-00-00
 last_cost_update_methodInotify Update Items
 fixed_cost_update2024-08-07
 fixed_cost_update_methodInotify Update DPG Items:
 sell_update2022-12-27
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3225
 cp1_categ_subcat3000/3225
 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_export2024-04-08
 cp1_sync2021-10-15
 cp1_update2021-10-15
 cp1_export_flag
 unit_id6
 ItemsProduct(array)
 id45994
 item_id150
 product_id47
 Item_Unit(array)
 id18
 nameRoll
 conversion1.0000
 a10nRoll
 purposelinear
 sortZZ
 Dim1_Unit(array)
 id13
 nameInches
 conversion1.0000
 a10n"
 purposeeach
 sortA
 Dim2_Unit(array)
 id6
 nameYards
 conversion36.0000
 a10ny
 purposelinear
 sortE
 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
 8(array)
 id156
 cp1_item1100512
 product_parentJSB
 sell41.94
 org_sell0.00
 sell_override
 cost26.38
 org_cost0.00
 std_cost26.38
 org_std_cost0.00
 last_cost13.24
 org_last_cost16.32
 fixed_cost0.00
 org_fixed_cost26.38
 dim134.000
 dim1_unit_id13
 dim250.000
 dim2_unit_id6
 item_unit_id18
 vitem46784
 cp_vend_noINTCOA
 publish_flagY
 group_id1
 price_group_id2802
 finish_id0
 ships_by_itselfY
 shipping_width7
 shipping_height7
 shipping_length39
 shipping_weight9
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_description34"x50y JSB-20 JetSet
 auto_desc
 keyword
 keyword_2
 color_id0
 item_id0
 csi
 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_date0000-00-00
 instock_override
 created2013-10-30 17:20:42
 modified2025-12-05 17:00:40
 cost_update2022-12-27
 cost_update_methodInotify Update DPG Items:
 last_cost_update2024-09-20
 last_cost_update_methodInotify Update DPG Items:
 fixed_cost_update2024-08-07
 fixed_cost_update_methodInotify Update DPG Items:
 sell_update2022-12-27
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3225
 cp1_categ_subcat3000/3225
 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_export2024-04-08
 cp1_sync2021-10-15
 cp1_update2021-10-15
 cp1_export_flag
 unit_id6
 ItemsProduct(array)
 id45995
 item_id156
 product_id47
 Item_Unit(array)
 id18
 nameRoll
 conversion1.0000
 a10nRoll
 purposelinear
 sortZZ
 Dim1_Unit(array)
 id13
 nameInches
 conversion1.0000
 a10n"
 purposeeach
 sortA
 Dim2_Unit(array)
 id6
 nameYards
 conversion36.0000
 a10ny
 purposelinear
 sortE
 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
 BaseStockPlain Bond Paper
- item_array(array)
 (array)
 0(array)
 id104
 cp1_item1100503
 product_parentJSB
 price_group
 price_group_sort
 vitem46291
 keyword
 keyword_2
 sell24.68
 sell_override
 sale_price0.00
 sale_range
 cost15.52
 lease0
 last_cost9.60
 publish_flagY
 cp1_write_off
 description24" x 150f Roll
 free_shipping_itemN
 color_icon(array)
 icon
 alt
 qty_on_hand0
 stock_status_id0
 stock_status_textDue In!
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortA24.000
 sortB150.000
 image(array)
 icon
 altJetSet, Magic Brand Part Number 46291 for 24" x 150f Roll
 kit_flag
 1(array)
 id185
 cp1_item1100502
 product_parentJSB
 price_group
 price_group_sort
 vitem14919
 keyword
 keyword_2
 sell92.5
 sell_override
 sale_price0.00
 sale_range
 cost62.08
 lease0
 last_cost38.40
 publish_flagY
 cp1_write_off
 description24" x 150f Roll
 free_shipping_itemN
 color_icon(array)
 icon
 alt
 qty_on_hand0
 stock_status_id0
 stock_status_textDue In!
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortA24.000
 sortB150.000
 image(array)
 icon
 altJetSet, Magic Brand Part Number 14919 for 24" x 150f Roll
 kit_flag
 2(array)
 id152
 cp1_item1100497
 product_parentJSB
 price_group
 price_group_sort
 vitem37282
 keyword
 keyword_2
 sell49.35
 sell_override
 sale_price0.00
 sale_range
 cost31.04
 lease0
 last_cost19.20
 publish_flagY
 cp1_write_off
 description24" x 300f Roll
 free_shipping_itemN
 color_icon(array)
 icon
 alt
 qty_on_hand0
 stock_status_id0
 stock_status_textDue In!
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortA24.000
 sortB300.000
 image(array)
 icon
 altJetSet, Magic Brand Part Number 37282 for 24" x 300f Roll
 kit_flag
 3(array)
 id150
 cp1_item1100511
 product_parentJSB
 price_group
 price_group_sort
 vitem46292
 keyword
 keyword_2
 sell30.83
 sell_override
 sale_price0.00
 sale_range
 cost19.39
 lease0
 last_cost12.00
 publish_flagY
 cp1_write_off
 description30" x 50y Roll
 free_shipping_itemN
 color_icon(array)
 icon
 alt
 qty_on_hand0
 stock_status_id0
 stock_status_textDue In!
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortA30.000
 sortB50.000
 image(array)
 icon
 altJetSet, Magic Brand Part Number 46292 for 30" x 50y Roll
 kit_flag
 4(array)
 id162
 cp1_item1100509
 product_parentJSB
 price_group
 price_group_sort
 vitem38168
 keyword
 keyword_2
 sell61.71
 sell_override
 sale_price0.00
 sale_range
 cost38.81
 lease0
 last_cost17.90
 publish_flagY
 cp1_write_off
 description30" x 300f Roll
 free_shipping_itemN
 color_icon(array)
 icon
 alt
 qty_on_hand0
 stock_status_id0
 stock_status_textDue In!
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortA30.000
 sortB300.000
 image(array)
 icon
 altJetSet, Magic Brand Part Number 38168 for 30" x 300f Roll
 kit_flag
 5(array)
 id156
 cp1_item1100512
 product_parentJSB
 price_group
 price_group_sort
 vitem46784
 keyword
 keyword_2
 sell41.94
 sell_override
 sale_price0.00
 sale_range
 cost26.38
 lease0
 last_cost13.24
 publish_flagY
 cp1_write_off
 description34" x 50y Roll
 free_shipping_itemN
 color_icon(array)
 icon
 alt
 qty_on_hand0
 stock_status_id0
 stock_status_textDue In!
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortA34.000
 sortB50.000
 image(array)
 icon
 altJetSet, Magic Brand Part Number 46784 for 34" x 50y Roll
 kit_flag
 6(array)
 id101
 cp1_item1100550
 product_parentJSB
 price_group
 price_group_sort
 vitem60805
 keyword
 keyword_2
 sell138.81
 sell_override
 sale_price0.00
 sale_range
 cost93.16
 lease0
 last_cost93.16
 publish_flagY
 cp1_write_off
 description36" x 150f Roll
 free_shipping_itemN
 color_icon(array)
 icon
 alt
 qty_on_hand0
 stock_status_id0
 stock_status_textDue In!
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortA36.000
 sortB150.000
 image(array)
 icon
 altJetSet, Magic Brand Part Number 60805 for 36" x 150f Roll
 kit_flag
 7(array)
 id154
 cp1_item1100549
 product_parentJSB
 price_group
 price_group_sort
 vitem46293
 keyword
 keyword_2
 sell37.03
 sell_override
 sale_price0.00
 sale_range
 cost23.29
 lease0
 last_cost14.40
 publish_flagY
 cp1_write_off
 description36" x 150f Roll
 free_shipping_itemN
 color_icon(array)
 icon
 alt
 qty_on_hand0
 stock_status_id0
 stock_status_textDue In!
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortA36.000
 sortB150.000
 image(array)
 icon
 altJetSet, Magic Brand Part Number 46293 for 36" x 150f Roll
 kit_flag
 8(array)
 id167
 cp1_item1004464
 product_parentJSB
 price_group
 price_group_sort
 vitem30126
 keyword
 keyword_2
 sell74.03
 sell_override
 sale_price0.00
 sale_range
 cost46.56
 lease0
 last_cost28.80
 publish_flagY
 cp1_write_off
 description36" x 300f Roll
 free_shipping_itemN
 color_icon(array)
 icon
 alt
 qty_on_hand0
 stock_status_id0
 stock_status_textDue In!
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortA36.000
 sortB300.000
 image(array)
 icon
 altJetSet, Magic Brand Part Number 30126 for 36" x 300f Roll
 kit_flag
- templateproduct_V2
- productSideBars(empty)
- breadCrumb<a href="/">Digital Printer Group</a> / 20# Plain Bond Paper (JSB-20)
- meta_tag_descriptionJSB-20 20# Plain Bond Paper
- page_title20# Plain Bond Paper (JSB-20), By JetSet, Magic Brand | Schiller's Digital Printer Group
- aSeeAlsos(array)
 Product(array)
 id47
 name20# Plain Bond Paper (JSB-20)
 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/JetSet-JSB-20-Print-Media
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/products/shop/JetSet-JSB-20-Print-Media
Remote Port	57124
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	aTOmmErQSlAAAHVEELIAAAD0
Redirect Status	200
Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Https	on
Redirect Unique Id	aTOmmErQSlAAAHVEELIAAAD0
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Redirect Https	on
Redirect Redirect Unique Id	aTOmmErQSlAAAHVEELIAAAD0
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1764992664.8328
Request Time	1764992664

====

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
24" x 150f Roll	46291	1100503	$24.68
24" x 150f Roll	14919	1100502	$92.50
24" x 300f Roll	37282	1100497	$49.35
30" x 50y Roll	46292	1100511	$30.83
30" x 300f Roll	38168	1100509	$61.71
34" x 50y Roll	46784	1100512	$41.94
36" x 150f Roll	60805	1100550	$138.81
36" x 150f Roll	46293	1100549	$37.03
36" x 300f Roll	30126	1004464	$74.03

20# Plain Bond Paper (JSB-20)

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 451 ms Total Queries: 136 queries

Query Explain:

Memory

Timers

Logs

debug

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 451 ms
Total Queries: 136 queries