TR3 TrueVIS Inks, By Roland DGA | Schiller's Digital Printer Group

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

Cake Params
- plugin(null)
- controllerproducts
- actionshop
- named(empty)
- pass(array)
  0Roland-DGA-TR3-TrueVIS-Eco-Solvent-Inks
- 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: 475 ms
Total Queries: 133 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` = '46c5404893f7d8e229da7750c47993438j599bmri8pqadb02u2mvc4f57' LIMIT 1	0	0	432	maybe slow
BEGIN
INSERT INTO `dpg_ecommerce`.`user_activities` (`useragent`, `user_id`, `last_action`, `last_url`, `user_browser`, `ip_address`, `status`, `modified`, `created`) VALUES ('46c5404893f7d8e229da7750c47993438j599bmri8pqadb02u2mvc4f57', NULL, 1765009645, '/products/shop/Roland-DGA-TR3-TrueVIS-Eco-Solvent-Inks', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '216.73.216.151', 0, '2025-12-05 22:27:25', '2025-12-05 22:27:25')	1	1	0
COMMIT
SELECT `Product`.`id`, `Product`.`name`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`slug` = 'Roland-DGA-TR3-TrueVIS-Eco-Solvent-Inks' LIMIT 1	1	1	1
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `Group`.`id`, `Group`.`name`, `Group`.`a10n`, `SubGroup`.`id`, `SubGroup`.`name`, `SubGroup`.`group_id`, `SubGroup`.`a10n`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template`, `StockStatus`.`id`, `StockStatus`.`description`, `StockStatus`.`text_color`, `PrimaryBrand`.`id`, `PrimaryBrand`.`parent_id`, `PrimaryBrand`.`lft`, `PrimaryBrand`.`rght`, `PrimaryBrand`.`name`, `PrimaryBrand`.`template_id`, `PrimaryBrand`.`slug`, `PrimaryBrand`.`meta_tag_title`, `PrimaryBrand`.`meta_tag_description`, `PrimaryBrand`.`url`, `PrimaryBrand`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` LEFT JOIN `dpg_ecommerce`.`groups` AS `Group` ON (`Product`.`group_id` = `Group`.`id`) LEFT JOIN `dpg_ecommerce`.`sub_groups` AS `SubGroup` ON (`Product`.`sub_group_id` = `SubGroup`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Product`.`template_id` = `Template`.`id`) LEFT JOIN `dpg_ecommerce`.`specification_details` AS `StockStatus` ON (`Product`.`stock_status_id` = `StockStatus`.`id`) LEFT JOIN `dpg_ecommerce`.`brands` AS `PrimaryBrand` ON (`Product`.`primary_brand_id` = `PrimaryBrand`.`id`) WHERE ((`Product`.`publish_flag` != 'N') AND (`Product`.`id` = 1608)) 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` = 1608 AND `ItemsProduct`.`item_id` = `Item`.`id`) WHERE `Item`.`publish_flag` != 'N'	10	10	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` = 33	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` = 33	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` = 33	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` = 33	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` = 33	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` = 33	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` = 33	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` = 33	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` = 33	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` = 33	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` = 14	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` = 14	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` = 14	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` = 14	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` = 14	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` = 14	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` = 14	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` = 14	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` = 14	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` = 14	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` = 31	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` = 31	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` = 31	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` = 31	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` = 31	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` = 31	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` = 31	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` = 31	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` = 31	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` = 31	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 4	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 4	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 4	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 4	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 4	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 4	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 4	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 4	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 4	1	1	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 4	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` = 345	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` = 388	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` = 345	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` = 345	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` = 345	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` = 345	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` = 345	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` = 345	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` = 388	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` = 345	1	1	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 `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` = 47	1	1	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` = 57	1	1	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` = 44	1	1	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` = 55	1	1	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` = 49	1	1	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` = 48	1	1	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` = 54	1	1	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` = 46	1	1	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` = 53	1	1	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` = 45	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 `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` = '2' 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` = '2' 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` = '2' 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` = '2' 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` = '2' 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` = '2' 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` = '2' 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` = '2' 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` = '2' 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` = '2' 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` = 194 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` = 194 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 `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` = 1608 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` = 1163931 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` = 1163931 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` = 1163936 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` = 1163936 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` = 1163929 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` = 1163929 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` = 1163933 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` = 1163933 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` = 1163935 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` = 1163935 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` = 1163934 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` = 1163934 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` = 1163932 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` = 1163932 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` = 1163928 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` = 1163928 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` = 9011270 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` = 9011270 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` = 1163930 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` = 1163930 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` = 1608 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` = (1608)	0	0	0
SELECT `InkType`.`id`, `InkType`.`name` FROM `dpg_ecommerce`.`ink_types` AS `InkType` WHERE 1 = 1	20	20	0

77 duplicate queries run.

Query Explain:

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

====

Timer

Memory

Peak Memory Use 28.58 MB

Message	Memory use
Component initialization	5.54 MB
Controller action start	17.26 MB
Controller render start	19.86 MB
View render complete	22.15 MB

Timers

Total Request Time: 712 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	34.14
Event: Controller.initialize	486.39
Event: Controller.startup	1.20
Controller action	71.91
Event: Controller.beforeRender	16.59
» Processing toolbar data	15.44
Rendering View	10.25
» Event: View.beforeRender	0.03
» Rendering APP/View/Products/shop.ctp	5.16
» » Rendering APP/View/Elements/Templates/product_V2.ctp	4.90
» » » Rendering APP/View/Elements/Templates/item_tableV2.ctp	4.66
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	4.04
» » Rendering APP/View/Elements/header_menu.ctp	0.23
» » Rendering APP/View/Elements/Pages/default_page.ctp	2.43
» » » Rendering APP/View/Elements/hMenu01.ctp	1.81
» » » » Rendering APP/View/Elements/Search/productSearch.ctp	0.31
» » » 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 22:27:25	Data AppController:
2025-12-05 22:27:25	Array ( [500ml] => Array ( [0] => Array ( [id] => 11263 [cp1_item] => 1163929 [product_parent] => ROL-INK-TR3 [price_group] => 500ml [price_group_sort] => 1 [vitem] => TR3-CY [keyword] => [keyword_2] => [sell] => 129.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 110.49 [lease] => 0 [last_cost] => 110.49 [publish_flag] => Y [cp1_write_off] => [description] => Cyan 500ml [free_shipping_item] => N [color_icon] => Array ( [icon] => /assets/Icons/C.gif [alt] => Cyan ) [qty_on_hand] => 1 [stock_status_id] => 0 [stock_status_text] => <span style="color:#38761d">In Stock</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => C [sortB] => [image] => Array ( [icon] => [alt] => Roland DGA Part Number TR3-CY for Cyan 500ml ) [kit_flag] => ) [1] => Array ( [id] => 11265 [cp1_item] => 1163934 [product_parent] => ROL-INK-TR3 [price_group] => 500ml [price_group_sort] => 1 [vitem] => TR3-LC [keyword] => [keyword_2] => [sell] => 129.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 110.49 [lease] => 0 [last_cost] => 110.49 [publish_flag] => Y [cp1_write_off] => [description] => Light Cyan 500ml [free_shipping_item] => N [color_icon] => Array ( [icon] => /assets/Icons/LC.gif [alt] => Light Cyan ) [qty_on_hand] => 1 [stock_status_id] => 0 [stock_status_text] => <span style="color:#38761d">In Stock</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => CL [sortB] => [image] => Array ( [icon] => [alt] => Roland DGA Part Number TR3-LC for Light Cyan 500ml ) [kit_flag] => ) [2] => Array ( [id] => 11264 [cp1_item] => 1163933 [product_parent] => ROL-INK-TR3 [price_group] => 500ml [price_group_sort] => 1 [vitem] => TR3-GR [keyword] => [keyword_2] => [sell] => 129.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 103.99 [lease] => 0 [last_cost] => 103.99 [publish_flag] => Y [cp1_write_off] => [description] => Green 500ml [free_shipping_item] => N [color_icon] => Array ( [icon] => /assets/Icons/G.gif [alt] => Green ) [qty_on_hand] => 1 [stock_status_id] => 0 [stock_status_text] => <span style="color:#38761d">In Stock</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => G [sortB] => [image] => Array ( [icon] => [alt] => Roland DGA Part Number TR3-GR for Green 500ml ) [kit_flag] => ) [3] => Array ( [id] => 11261 [cp1_item] => 1163931 [product_parent] => ROL-INK-TR3 [price_group] => 500ml [price_group_sort] => 1 [vitem] => TR3-BK [keyword] => [keyword_2] => [sell] => 129.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 110.49 [lease] => 0 [last_cost] => 110.49 [publish_flag] => Y [cp1_write_off] => [description] => Black 500ml [free_shipping_item] => N [color_icon] => Array ( [icon] => /assets/Icons/K.gif [alt] => Black ) [qty_on_hand] => 1 [stock_status_id] => 0 [stock_status_text] => <span style="color:#38761d">In Stock</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => J [sortB] => [image] => Array ( [icon] => [alt] => Roland DGA Part Number TR3-BK for Black 500ml ) [kit_flag] => ) [4] => Array ( [id] => 11267 [cp1_item] => 1163930 [product_parent] => ROL-INK-TR3 [price_group] => 500ml [price_group_sort] => 1 [vitem] => TR3-MG [keyword] => [keyword_2] => [sell] => 129.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 110.49 [lease] => 0 [last_cost] => 110.49 [publish_flag] => Y [cp1_write_off] => [description] => Magenta 500ml [free_shipping_item] => N [color_icon] => Array ( [icon] => /assets/Icons/M.gif [alt] => Magenta ) [qty_on_hand] => 1 [stock_status_id] => 0 [stock_status_text] => <span style="color:#38761d">In Stock</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => M [sortB] => [image] => Array ( [icon] => [alt] => Roland DGA Part Number TR3-MG for Magenta 500ml ) [kit_flag] => ) [5] => Array ( [id] => 11266 [cp1_item] => 1163935 [product_parent] => ROL-INK-TR3 [price_group] => 500ml [price_group_sort] => 1 [vitem] => TR3-LM [keyword] => [keyword_2] => [sell] => 129.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 110.49 [lease] => 0 [last_cost] => 110.49 [publish_flag] => Y [cp1_write_off] => [description] => Light Magenta 500ml [free_shipping_item] => N [color_icon] => Array ( [icon] => /assets/Icons/LM.gif [alt] => Light Magenta ) [qty_on_hand] => 1 [stock_status_id] => 0 [stock_status_text] => <span style="color:#38761d">In Stock</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => ML [sortB] => [image] => Array ( [icon] => [alt] => Roland DGA Part Number TR3-LM for Light Magenta 500ml ) [kit_flag] => ) [6] => Array ( [id] => 11268 [cp1_item] => 1163932 [product_parent] => ROL-INK-TR3 [price_group] => 500ml [price_group_sort] => 1 [vitem] => TR3-OR [keyword] => [keyword_2] => [sell] => 129.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 103.99 [lease] => 0 [last_cost] => 103.99 [publish_flag] => Y [cp1_write_off] => [description] => Orange 500ml [free_shipping_item] => N [color_icon] => Array ( [icon] => /assets/Icons/O.gif [alt] => Orange ) [qty_on_hand] => 1 [stock_status_id] => 0 [stock_status_text] => <span style="color:#38761d">In Stock</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => Or [sortB] => [image] => Array ( [icon] => [alt] => Roland DGA Part Number TR3-OR for Orange 500ml ) [kit_flag] => ) [7] => Array ( [id] => 11269 [cp1_item] => 1163928 [product_parent] => ROL-INK-TR3 [price_group] => 500ml [price_group_sort] => 1 [vitem] => TR3-YE [keyword] => [keyword_2] => [sell] => 129.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 110.49 [lease] => 0 [last_cost] => 110.49 [publish_flag] => Y [cp1_write_off] => [description] => Yellow 500ml [free_shipping_item] => N [color_icon] => Array ( [icon] => /assets/Icons/Y.gif [alt] => Yellow ) [qty_on_hand] => 1 [stock_status_id] => 0 [stock_status_text] => <span style="color:#38761d">In Stock</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => Y [sortB] => [image] => Array ( [icon] => [alt] => Roland DGA Part Number TR3-YE for Yellow 500ml ) [kit_flag] => ) ) [Speciality] => Array ( [0] => Array ( [id] => 11262 [cp1_item] => 1163936 [product_parent] => ROL-INK-TR3 [price_group] => Speciality [price_group_sort] => 9 [vitem] => TR3-CL [keyword] => [keyword_2] => [sell] => 79.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 63.99 [lease] => 0 [last_cost] => 63.99 [publish_flag] => Y [cp1_write_off] => [description] => Cleaning 750ml [free_shipping_item] => N [color_icon] => Array ( [icon] => /assets/Icons/W.gif [alt] => Cleaning ) [qty_on_hand] => 2 [stock_status_id] => 0 [stock_status_text] => <span style="color:#38761d">In Stock</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => [sortB] => [image] => Array ( [icon] => [alt] => Roland DGA Part Number TR3-CL for Cleaning 750ml ) [kit_flag] => ) [1] => Array ( [id] => 11270 [cp1_item] => 9011270 [product_parent] => ROL-INK-TR3 [price_group] => Speciality [price_group_sort] => 9 [vitem] => TR3-WH [keyword] => [keyword_2] => [sell] => 94.99 [sell_override] => [sale_price] => 0.00 [sale_range] => [cost] => 75.99 [lease] => 0 [last_cost] => 75.99 [publish_flag] => Y [cp1_write_off] => [description] => White 250ml [free_shipping_item] => N [color_icon] => Array ( [icon] => /assets/Icons/W.gif [alt] => White ) [qty_on_hand] => 0 [stock_status_id] => 0 [stock_status_text] => <span style="color:#b30000">Special Order</span> [price_break] => [price_break_flag] => [order_qty] => [cart_flag] => N [sortA] => Z2 [sortB] => [image] => Array ( [icon] => [alt] => Roland DGA Part Number TR3-WH for White 250ml ) [kit_flag] => ) ) )
2025-12-05 22:27:25	layout_default default.ctp:
2025-12-05 22:27: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)
 id1608
 nameTR3 TrueVIS Inks
 cat_name
 cart_name{item_description_override} {item_color} {dim1}{dim1u} {item_unit} {product_name}
 cart_short_name{item_description_override} {item_color} {dim1}{dim1u}
 child_nameROL-INK-TR3
 short_nameTR3 TrueVIS
 keyword
 keyword_2
 publish_flagY
 slug_lockN
 slugRoland-DGA-TR3-TrueVIS-Eco-Solvent-Inks
 group_id4
 sub_group_id34
 primary_brand_id2
 template_id39
 sub_template_id0
 description
 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_id0
 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_id194
 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_flag
 stock_status_rating0
 stock_status_id437
 storage_requirement_id0
 thickness_dimension0.000
 thickness_id0
 total_thickness_dimension0.000
 total_thickness_id0
 meta_tag_title
 meta_tag_description
 meta_brandRoland DGA
 meta_categoriesInk Inks Roland TrueVIS
 meta_certifications
 meta_cp1_items1163931, 1163936, 1163929, 1163933, 1163935, 1163934, 1163932, 1163928, 1163930
 meta_vitemsTR3-BK, TR3-CL, TR3-CY, TR3-GR, TR3-LM, TR3-LC, TR3-OR, TR3-YE, TR3-WH, TR3-MG
 meta_ink_types
 meta_specifications
 meta_substrates
 manual_key_words
 key_words1163928, 1163929, 1163930, 1163931, 1163932, 1163933, 1163934, 1163935, 1163936, 250ml, 500ml, 750ml, DGA, Eco, Ink Inks Roland TrueVIS, Inks, ROL-INK-TR3, Roland, Roland DGA, Solvent, TR3, TR3-BK, TR3-CL, TR3-CY, TR3-GR, TR3-LC, TR3-LM, TR3-MG, TR3-OR, TR3-WH, TR3-YE, TrueVIS
 washability_id0
 m1_sync0000-00-00 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
 created2025-05-27
 modified2025-08-07
 Group(array)
 id4
 nameInk
 a10nInks
 SubGroup(array)
 id34
 nameEco-Solvent
 group_id4
 a10n
 Template(array)
 id39
 nameProduct w/vitem
 notesUses item_tableV2 Show vitem vs keyword
 templateproduct_V2.ctp
 StockStatus(array)
 id437
 descriptionSpecial Order
 text_color#b30000
 PrimaryBrand(array)
 id2
 parent_id(null)
 lft111
 rght124
 nameRoland DGA
 template_id9
 slugDigital_Print_Group_Brands_Roland_DGA
 meta_tag_title
 meta_tag_description
 urlhttps://www.rolanddga.com/
 publish_flagY
 Item(array)
 0(array)
 id11261
 cp1_item1163931
 product_parentROL-INK-TR3
 sell129.99
 org_sell142.99
 sell_override
 cost110.49
 org_cost105.81
 std_cost110.49
 org_std_cost105.81
 last_cost110.49
 org_last_cost105.81
 fixed_cost105.81
 org_fixed_cost0.00
 dim1500.000
 dim1_unit_id14
 dim20.000
 dim2_unit_id31
 item_unit_id33
 vitemTR3-BK
 cp_vend_noROLAND
 publish_flagY
 group_id4
 price_group_id345
 finish_id0
 ships_by_itselfN
 shipping_width2
 shipping_height8
 shipping_length14
 shipping_weight2
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_descriptionBlack TR3 TrueVIS 500ml Ink Pouch, Roland
 auto_descBlack 500ml
 keyword
 keyword_2
 color_id47
 item_id0
 csiN
 color_selector_id0
 color_number
 cp1_statusA
 taxableN
 min0
 max1
 qty_avail1
 qty_on_hand1
 qty_on_po0
 qty_on_bo0
 qty_commit0
 last_po_date2025-10-17
 instock_override
 created2025-05-27 16:33:59
 modified2025-12-05 17:02:20
 cost_update2025-08-07
 cost_update_methodInotify Update DPG Items:
 last_cost_update2025-10-24
 last_cost_update_methodInotify Update DPG Items:
 fixed_cost_update0000-00-00
 fixed_cost_update_method
 sell_update2025-08-07
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3501
 cp1_categ_subcat3000/3501
 photo_square
 hideN
 sale_end0000-00-00
 sale_price0.00
 sale_start0000-00-00
 legacy_id0
 legacy_source
 kit_partN
 kit_flag
 kitableN
 fedx_flag
 ups_flag
 cp1_export0000-00-00
 cp1_sync(null)
 cp1_update0000-00-00
 cp1_export_flag
 unit_id0
 ItemsProduct(array)
 id50356
 item_id11261
 product_id1608
 Item_Unit(array)
 id33
 namePouch
 conversion1.0000
 a10nPouch
 purposeeach
 sortZZ
 Dim1_Unit(array)
 id14
 nameMilliliter
 conversion1.0000
 a10nml
 purposefluid
 sortZZ
 Dim2_Unit(array)
 id31
 nameN/A
 conversion1.0000
 a10n
 purpose
 sortZZ
 Group(array)
 id4
 nameInk
 a10nInks
 PriceGroup(array)
 id345
 description500ml
 a10n
 sort1
 groups4
 specification_id13
 iconnone
 text_color#000000
 index_flagN
 active
 StockStatus(empty)
 Color(array)
 id47
 descriptionBlack
 a10nK
 sortJ
 groups4
 specification_id11
 icon/assets/Icons/K.gif
 text_color#000000
 index_flag
 active
 ShippingHeader(array)
 id0
 nameN/A
 a10nN/A
 zones(null)
 extra_fee(null)
 value
 1(array)
 id11262
 cp1_item1163936
 product_parentROL-INK-TR3
 sell79.99
 org_sell88.00
 sell_override
 cost63.99
 org_cost61.60
 std_cost63.99
 org_std_cost61.60
 last_cost63.99
 org_last_cost61.60
 fixed_cost61.60
 org_fixed_cost0.00
 dim1750.000
 dim1_unit_id14
 dim20.000
 dim2_unit_id31
 item_unit_id33
 vitemTR3-CL
 cp_vend_noROLAND
 publish_flagY
 group_id4
 price_group_id388
 finish_id0
 ships_by_itselfN
 shipping_width2
 shipping_height8
 shipping_length14
 shipping_weight2
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_descriptionCleaning TR3-CL TrueVIS 750ml Ink Pouch, Roland
 auto_descCleaning 750ml
 keyword
 keyword_2
 color_id57
 item_id0
 csiN
 color_selector_id0
 color_number
 cp1_statusA
 taxableN
 min1
 max2
 qty_avail2
 qty_on_hand2
 qty_on_po0
 qty_on_bo0
 qty_commit0
 last_po_date2025-10-17
 instock_override
 created2025-05-27 16:33:59
 modified2025-12-05 17:02:20
 cost_update2025-06-06
 cost_update_methodInotify Update DPG Items:
 last_cost_update2025-06-06
 last_cost_update_methodInotify Update DPG Items:
 fixed_cost_update0000-00-00
 fixed_cost_update_method
 sell_update2025-06-02
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3501
 cp1_categ_subcat3000/3501
 photo_square
 hideN
 sale_end0000-00-00
 sale_price0.00
 sale_start0000-00-00
 legacy_id0
 legacy_source
 kit_partN
 kit_flag
 kitableN
 fedx_flag
 ups_flag
 cp1_export0000-00-00
 cp1_sync(null)
 cp1_update0000-00-00
 cp1_export_flag
 unit_id0
 ItemsProduct(array)
 id50357
 item_id11262
 product_id1608
 Item_Unit(array)
 id33
 namePouch
 conversion1.0000
 a10nPouch
 purposeeach
 sortZZ
 Dim1_Unit(array)
 id14
 nameMilliliter
 conversion1.0000
 a10nml
 purposefluid
 sortZZ
 Dim2_Unit(array)
 id31
 nameN/A
 conversion1.0000
 a10n
 purpose
 sortZZ
 Group(array)
 id4
 nameInk
 a10nInks
 PriceGroup(array)
 id388
 descriptionSpeciality
 a10n
 sort9
 groups4
 specification_id13
 iconnone
 text_color
 index_flag
 active
 StockStatus(empty)
 Color(array)
 id57
 descriptionCleaning
 a10nClean
 sort
 groups4
 specification_id11
 icon/assets/Icons/W.gif
 text_color
 index_flag
 active
 ShippingHeader(array)
 id0
 nameN/A
 a10nN/A
 zones(null)
 extra_fee(null)
 value
 2(array)
 id11263
 cp1_item1163929
 product_parentROL-INK-TR3
 sell129.99
 org_sell142.99
 sell_override
 cost110.49
 org_cost105.81
 std_cost110.49
 org_std_cost105.81
 last_cost110.49
 org_last_cost105.81
 fixed_cost105.81
 org_fixed_cost0.00
 dim1500.000
 dim1_unit_id14
 dim20.000
 dim2_unit_id31
 item_unit_id33
 vitemTR3-CY
 cp_vend_noROLAND
 publish_flagY
 group_id4
 price_group_id345
 finish_id0
 ships_by_itselfN
 shipping_width2
 shipping_height8
 shipping_length14
 shipping_weight2
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_descriptionCyan TR3TrueVIS 500ml Ink Pouch, Roland
 auto_descCyan 500ml
 keyword
 keyword_2
 color_id44
 item_id0
 csiN
 color_selector_id0
 color_number
 cp1_statusA
 taxableN
 min0
 max1
 qty_avail1
 qty_on_hand1
 qty_on_po0
 qty_on_bo0
 qty_commit0
 last_po_date2025-10-17
 instock_override
 created2025-05-27 16:33:59
 modified2025-12-05 17:02:20
 cost_update2025-08-07
 cost_update_methodInotify Update DPG Items:
 last_cost_update2025-10-24
 last_cost_update_methodInotify Update DPG Items:
 fixed_cost_update0000-00-00
 fixed_cost_update_method
 sell_update2025-08-07
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3501
 cp1_categ_subcat3000/3501
 photo_square
 hideN
 sale_end0000-00-00
 sale_price0.00
 sale_start0000-00-00
 legacy_id0
 legacy_source
 kit_partN
 kit_flag
 kitableN
 fedx_flag
 ups_flag
 cp1_export0000-00-00
 cp1_sync(null)
 cp1_update0000-00-00
 cp1_export_flag
 unit_id0
 ItemsProduct(array)
 id50358
 item_id11263
 product_id1608
 Item_Unit(array)
 id33
 namePouch
 conversion1.0000
 a10nPouch
 purposeeach
 sortZZ
 Dim1_Unit(array)
 id14
 nameMilliliter
 conversion1.0000
 a10nml
 purposefluid
 sortZZ
 Dim2_Unit(array)
 id31
 nameN/A
 conversion1.0000
 a10n
 purpose
 sortZZ
 Group(array)
 id4
 nameInk
 a10nInks
 PriceGroup(array)
 id345
 description500ml
 a10n
 sort1
 groups4
 specification_id13
 iconnone
 text_color#000000
 index_flagN
 active
 StockStatus(empty)
 Color(array)
 id44
 descriptionCyan
 a10nC
 sortC
 groups4
 specification_id11
 icon/assets/Icons/C.gif
 text_color
 index_flag
 active
 ShippingHeader(array)
 id0
 nameN/A
 a10nN/A
 zones(null)
 extra_fee(null)
 value
 3(array)
 id11264
 cp1_item1163933
 product_parentROL-INK-TR3
 sell129.99
 org_sell142.99
 sell_override
 cost103.99
 org_cost110.49
 std_cost103.99
 org_std_cost110.49
 last_cost103.99
 org_last_cost110.49
 fixed_cost105.81
 org_fixed_cost0.00
 dim1500.000
 dim1_unit_id14
 dim20.000
 dim2_unit_id31
 item_unit_id33
 vitemTR3-GR
 cp_vend_noROLAND
 publish_flagY
 group_id4
 price_group_id345
 finish_id0
 ships_by_itselfN
 shipping_width6
 shipping_height6
 shipping_length14
 shipping_weight2
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_descriptionGreen TR3 TrueVIS 500ml Ink Pouch, Roland
 auto_descGreen 500ml
 keyword
 keyword_2
 color_id55
 item_id0
 csiN
 color_selector_id0
 color_number
 cp1_statusA
 taxableN
 min0
 max1
 qty_avail1
 qty_on_hand1
 qty_on_po0
 qty_on_bo0
 qty_commit0
 last_po_date2025-10-17
 instock_override
 created2025-05-27 16:33:59
 modified2025-12-05 17:02:20
 cost_update2025-10-28
 cost_update_methodInotify Update DPG Items:
 last_cost_update2025-10-28
 last_cost_update_methodInotify Update DPG Items:
 fixed_cost_update0000-00-00
 fixed_cost_update_method
 sell_update2025-08-07
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3501
 cp1_categ_subcat3000/3501
 photo_square
 hideN
 sale_end0000-00-00
 sale_price0.00
 sale_start0000-00-00
 legacy_id0
 legacy_source
 kit_partN
 kit_flag
 kitableN
 fedx_flag
 ups_flag
 cp1_export0000-00-00
 cp1_sync(null)
 cp1_update0000-00-00
 cp1_export_flag
 unit_id0
 ItemsProduct(array)
 id50359
 item_id11264
 product_id1608
 Item_Unit(array)
 id33
 namePouch
 conversion1.0000
 a10nPouch
 purposeeach
 sortZZ
 Dim1_Unit(array)
 id14
 nameMilliliter
 conversion1.0000
 a10nml
 purposefluid
 sortZZ
 Dim2_Unit(array)
 id31
 nameN/A
 conversion1.0000
 a10n
 purpose
 sortZZ
 Group(array)
 id4
 nameInk
 a10nInks
 PriceGroup(array)
 id345
 description500ml
 a10n
 sort1
 groups4
 specification_id13
 iconnone
 text_color#000000
 index_flagN
 active
 StockStatus(empty)
 Color(array)
 id55
 descriptionGreen
 a10nG
 sortG
 groups6,4
 specification_id11
 icon/assets/Icons/G.gif
 text_color#000000
 index_flag
 active
 ShippingHeader(array)
 id0
 nameN/A
 a10nN/A
 zones(null)
 extra_fee(null)
 value
 4(array)
 id11266
 cp1_item1163935
 product_parentROL-INK-TR3
 sell129.99
 org_sell142.99
 sell_override
 cost110.49
 org_cost105.81
 std_cost110.49
 org_std_cost105.81
 last_cost110.49
 org_last_cost105.81
 fixed_cost105.81
 org_fixed_cost0.00
 dim1500.000
 dim1_unit_id14
 dim20.000
 dim2_unit_id31
 item_unit_id33
 vitemTR3-LM
 cp_vend_noROLAND
 publish_flagY
 group_id4
 price_group_id345
 finish_id0
 ships_by_itselfN
 shipping_width2
 shipping_height8
 shipping_length14
 shipping_weight2
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_descriptionLight Magenta TR3 TrueVIS 500ml Ink Pouch, Roland
 auto_descLight Magenta 500ml
 keyword
 keyword_2
 color_id49
 item_id0
 csiN
 color_selector_id0
 color_number
 cp1_statusA
 taxableN
 min0
 max1
 qty_avail1
 qty_on_hand1
 qty_on_po0
 qty_on_bo0
 qty_commit0
 last_po_date2025-10-17
 instock_override
 created2025-05-27 16:34:00
 modified2025-12-05 17:02:20
 cost_update2025-08-07
 cost_update_methodInotify Update DPG Items:
 last_cost_update2025-10-24
 last_cost_update_methodInotify Update DPG Items:
 fixed_cost_update0000-00-00
 fixed_cost_update_method
 sell_update2025-08-07
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3501
 cp1_categ_subcat3000/3501
 photo_square
 hideN
 sale_end0000-00-00
 sale_price0.00
 sale_start0000-00-00
 legacy_id0
 legacy_source
 kit_partN
 kit_flag
 kitableN
 fedx_flag
 ups_flag
 cp1_export0000-00-00
 cp1_sync(null)
 cp1_update0000-00-00
 cp1_export_flag
 unit_id0
 ItemsProduct(array)
 id50360
 item_id11266
 product_id1608
 Item_Unit(array)
 id33
 namePouch
 conversion1.0000
 a10nPouch
 purposeeach
 sortZZ
 Dim1_Unit(array)
 id14
 nameMilliliter
 conversion1.0000
 a10nml
 purposefluid
 sortZZ
 Dim2_Unit(array)
 id31
 nameN/A
 conversion1.0000
 a10n
 purpose
 sortZZ
 Group(array)
 id4
 nameInk
 a10nInks
 PriceGroup(array)
 id345
 description500ml
 a10n
 sort1
 groups4
 specification_id13
 iconnone
 text_color#000000
 index_flagN
 active
 StockStatus(empty)
 Color(array)
 id49
 descriptionLight Magenta
 a10nLm
 sortML
 groups4
 specification_id11
 icon/assets/Icons/LM.gif
 text_color
 index_flag
 active
 ShippingHeader(array)
 id0
 nameN/A
 a10nN/A
 zones(null)
 extra_fee(null)
 value
 5(array)
 id11265
 cp1_item1163934
 product_parentROL-INK-TR3
 sell129.99
 org_sell142.99
 sell_override
 cost110.49
 org_cost105.81
 std_cost110.49
 org_std_cost105.81
 last_cost110.49
 org_last_cost105.81
 fixed_cost105.81
 org_fixed_cost0.00
 dim1500.000
 dim1_unit_id14
 dim20.000
 dim2_unit_id31
 item_unit_id33
 vitemTR3-LC
 cp_vend_noROLAND
 publish_flagY
 group_id4
 price_group_id345
 finish_id0
 ships_by_itselfN
 shipping_width2
 shipping_height8
 shipping_length14
 shipping_weight2
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_descriptionLight Cyan TR3 TrueVIS 500ml Ink Pouch, Roland
 auto_descLight Cyan 500ml
 keyword
 keyword_2
 color_id48
 item_id0
 csiN
 color_selector_id0
 color_number
 cp1_statusA
 taxableN
 min0
 max1
 qty_avail1
 qty_on_hand1
 qty_on_po0
 qty_on_bo0
 qty_commit0
 last_po_date2025-10-17
 instock_override
 created2025-05-27 16:33:59
 modified2025-12-05 17:02:20
 cost_update2025-08-07
 cost_update_methodInotify Update DPG Items:
 last_cost_update2025-10-24
 last_cost_update_methodInotify Update DPG Items:
 fixed_cost_update0000-00-00
 fixed_cost_update_method
 sell_update2025-08-07
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3501
 cp1_categ_subcat3000/3501
 photo_square
 hideN
 sale_end0000-00-00
 sale_price0.00
 sale_start0000-00-00
 legacy_id0
 legacy_source
 kit_partN
 kit_flag
 kitableN
 fedx_flag
 ups_flag
 cp1_export0000-00-00
 cp1_sync(null)
 cp1_update0000-00-00
 cp1_export_flag
 unit_id0
 ItemsProduct(array)
 id50361
 item_id11265
 product_id1608
 Item_Unit(array)
 id33
 namePouch
 conversion1.0000
 a10nPouch
 purposeeach
 sortZZ
 Dim1_Unit(array)
 id14
 nameMilliliter
 conversion1.0000
 a10nml
 purposefluid
 sortZZ
 Dim2_Unit(array)
 id31
 nameN/A
 conversion1.0000
 a10n
 purpose
 sortZZ
 Group(array)
 id4
 nameInk
 a10nInks
 PriceGroup(array)
 id345
 description500ml
 a10n
 sort1
 groups4
 specification_id13
 iconnone
 text_color#000000
 index_flagN
 active
 StockStatus(empty)
 Color(array)
 id48
 descriptionLight Cyan
 a10nLc
 sortCL
 groups4
 specification_id11
 icon/assets/Icons/LC.gif
 text_color
 index_flag
 active
 ShippingHeader(array)
 id0
 nameN/A
 a10nN/A
 zones(null)
 extra_fee(null)
 value
 6(array)
 id11268
 cp1_item1163932
 product_parentROL-INK-TR3
 sell129.99
 org_sell142.99
 sell_override
 cost103.99
 org_cost110.49
 std_cost103.99
 org_std_cost110.49
 last_cost103.99
 org_last_cost110.49
 fixed_cost105.81
 org_fixed_cost0.00
 dim1500.000
 dim1_unit_id14
 dim20.000
 dim2_unit_id31
 item_unit_id33
 vitemTR3-OR
 cp_vend_noROLAND
 publish_flagY
 group_id4
 price_group_id345
 finish_id0
 ships_by_itselfN
 shipping_width2
 shipping_height8
 shipping_length14
 shipping_weight2
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_descriptionOrange TR3 TrueVIS 500ml Ink Pouch, Roland
 auto_descOrange 500ml
 keyword
 keyword_2
 color_id54
 item_id0
 csiN
 color_selector_id0
 color_number
 cp1_statusA
 taxableN
 min0
 max1
 qty_avail1
 qty_on_hand1
 qty_on_po0
 qty_on_bo0
 qty_commit0
 last_po_date2025-10-17
 instock_override
 created2025-05-27 16:34:00
 modified2025-12-05 17:02:20
 cost_update2025-10-28
 cost_update_methodInotify Update DPG Items:
 last_cost_update2025-10-28
 last_cost_update_methodInotify Update DPG Items:
 fixed_cost_update0000-00-00
 fixed_cost_update_method
 sell_update2025-08-07
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3501
 cp1_categ_subcat3000/3501
 photo_square
 hideN
 sale_end0000-00-00
 sale_price0.00
 sale_start0000-00-00
 legacy_id0
 legacy_source
 kit_partN
 kit_flag
 kitableN
 fedx_flag
 ups_flag
 cp1_export0000-00-00
 cp1_sync(null)
 cp1_update0000-00-00
 cp1_export_flag
 unit_id0
 ItemsProduct(array)
 id50362
 item_id11268
 product_id1608
 Item_Unit(array)
 id33
 namePouch
 conversion1.0000
 a10nPouch
 purposeeach
 sortZZ
 Dim1_Unit(array)
 id14
 nameMilliliter
 conversion1.0000
 a10nml
 purposefluid
 sortZZ
 Dim2_Unit(array)
 id31
 nameN/A
 conversion1.0000
 a10n
 purpose
 sortZZ
 Group(array)
 id4
 nameInk
 a10nInks
 PriceGroup(array)
 id345
 description500ml
 a10n
 sort1
 groups4
 specification_id13
 iconnone
 text_color#000000
 index_flagN
 active
 StockStatus(empty)
 Color(array)
 id54
 descriptionOrange
 a10nO
 sortOr
 groups4
 specification_id11
 icon/assets/Icons/O.gif
 text_color
 index_flag
 active
 ShippingHeader(array)
 id0
 nameN/A
 a10nN/A
 zones(null)
 extra_fee(null)
 value
 7(array)
 id11269
 cp1_item1163928
 product_parentROL-INK-TR3
 sell129.99
 org_sell142.99
 sell_override
 cost110.49
 org_cost105.81
 std_cost110.49
 org_std_cost105.81
 last_cost110.49
 org_last_cost105.81
 fixed_cost105.81
 org_fixed_cost0.00
 dim1500.000
 dim1_unit_id14
 dim20.000
 dim2_unit_id31
 item_unit_id33
 vitemTR3-YE
 cp_vend_noROLAND
 publish_flagY
 group_id4
 price_group_id345
 finish_id0
 ships_by_itselfN
 shipping_width2
 shipping_height8
 shipping_length14
 shipping_weight2
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_descriptionYellow TR3 TrueVIS 500ml Ink Pouch, Roland
 auto_descYellow 500ml
 keyword
 keyword_2
 color_id46
 item_id0
 csiN
 color_selector_id0
 color_number
 cp1_statusA
 taxableN
 min0
 max1
 qty_avail1
 qty_on_hand1
 qty_on_po0
 qty_on_bo0
 qty_commit0
 last_po_date2025-10-17
 instock_override
 created2025-05-27 16:34:00
 modified2025-12-05 17:02:20
 cost_update2025-08-07
 cost_update_methodInotify Update DPG Items:
 last_cost_update2025-10-24
 last_cost_update_methodInotify Update DPG Items:
 fixed_cost_update0000-00-00
 fixed_cost_update_method
 sell_update2025-08-07
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3501
 cp1_categ_subcat3000/3501
 photo_square
 hideN
 sale_end0000-00-00
 sale_price0.00
 sale_start0000-00-00
 legacy_id0
 legacy_source
 kit_partN
 kit_flag
 kitableN
 fedx_flag
 ups_flag
 cp1_export0000-00-00
 cp1_sync(null)
 cp1_update0000-00-00
 cp1_export_flag
 unit_id0
 ItemsProduct(array)
 id50363
 item_id11269
 product_id1608
 Item_Unit(array)
 id33
 namePouch
 conversion1.0000
 a10nPouch
 purposeeach
 sortZZ
 Dim1_Unit(array)
 id14
 nameMilliliter
 conversion1.0000
 a10nml
 purposefluid
 sortZZ
 Dim2_Unit(array)
 id31
 nameN/A
 conversion1.0000
 a10n
 purpose
 sortZZ
 Group(array)
 id4
 nameInk
 a10nInks
 PriceGroup(array)
 id345
 description500ml
 a10n
 sort1
 groups4
 specification_id13
 iconnone
 text_color#000000
 index_flagN
 active
 StockStatus(empty)
 Color(array)
 id46
 descriptionYellow
 a10nY
 sortY
 groups4
 specification_id11
 icon/assets/Icons/Y.gif
 text_color#000000
 index_flag
 active
 ShippingHeader(array)
 id0
 nameN/A
 a10nN/A
 zones(null)
 extra_fee(null)
 value
 8(array)
 id11270
 cp1_item9011270
 product_parentROL-INK-TR3
 sell94.99
 org_sell0.00
 sell_override
 cost75.99
 org_cost0.00
 std_cost74.40
 org_std_cost0.00
 last_cost75.99
 org_last_cost0.00
 fixed_cost75.99
 org_fixed_cost0.00
 dim1250.000
 dim1_unit_id14
 dim20.000
 dim2_unit_id31
 item_unit_id33
 vitemTR3-WH
 cp_vend_noROLAND
 publish_flagY
 group_id4
 price_group_id388
 finish_id0
 ships_by_itselfN
 shipping_width2
 shipping_height8
 shipping_length14
 shipping_weight2
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_descriptionWhite TR3-WH TrueVIS 500ml Ink Pouch, Roland
 auto_descWhite 250ml
 keyword
 keyword_2
 color_id53
 item_id0
 csiN
 color_selector_id0
 color_number
 cp1_statusA
 taxableN
 min0
 max0
 qty_avail0
 qty_on_hand0
 qty_on_po0
 qty_on_bo0
 qty_commit0
 last_po_date0000-00-00
 instock_override
 created2025-05-27 16:33:59
 modified2025-05-27 16:44:11
 cost_update2025-08-07
 cost_update_methodManual: 2025-08-07
 last_cost_update2025-08-07
 last_cost_update_methodManual: 2025-08-07
 fixed_cost_update2025-08-07
 fixed_cost_update_methodManual: 2025-08-07
 sell_update2025-08-07
 sell_update_methodManual: 2025-08-07
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3501
 cp1_categ_subcat3000/3501
 photo_square
 hideN
 sale_end0000-00-00
 sale_price0.00
 sale_start0000-00-00
 legacy_id0
 legacy_source
 kit_partN
 kit_flag
 kitableN
 fedx_flag
 ups_flagY
 cp1_export0000-00-00
 cp1_sync0000-00-00
 cp1_update0000-00-00
 cp1_export_flag
 unit_id0
 ItemsProduct(array)
 id50364
 item_id11270
 product_id1608
 Item_Unit(array)
 id33
 namePouch
 conversion1.0000
 a10nPouch
 purposeeach
 sortZZ
 Dim1_Unit(array)
 id14
 nameMilliliter
 conversion1.0000
 a10nml
 purposefluid
 sortZZ
 Dim2_Unit(array)
 id31
 nameN/A
 conversion1.0000
 a10n
 purpose
 sortZZ
 Group(array)
 id4
 nameInk
 a10nInks
 PriceGroup(array)
 id388
 descriptionSpeciality
 a10n
 sort9
 groups4
 specification_id13
 iconnone
 text_color
 index_flag
 active
 StockStatus(empty)
 Color(array)
 id53
 descriptionWhite
 a10nW
 sortZ2
 groups6,7,4,1,5
 specification_id11
 icon/assets/Icons/W.gif
 text_color
 index_flag
 active
 ShippingHeader(array)
 id0
 nameN/A
 a10nN/A
 zones(null)
 extra_fee(null)
 value
 9(array)
 id11267
 cp1_item1163930
 product_parentROL-INK-TR3
 sell129.99
 org_sell142.99
 sell_override
 cost110.49
 org_cost105.81
 std_cost110.49
 org_std_cost105.81
 last_cost110.49
 org_last_cost105.81
 fixed_cost105.81
 org_fixed_cost0.00
 dim1500.000
 dim1_unit_id14
 dim20.000
 dim2_unit_id31
 item_unit_id33
 vitemTR3-MG
 cp_vend_noROLAND
 publish_flagY
 group_id4
 price_group_id345
 finish_id0
 ships_by_itselfN
 shipping_width2
 shipping_height8
 shipping_length14
 shipping_weight2
 acutal_weightY
 shipping_header_id0
 free_shipping_itemN
 stock_status_id0
 description_override
 clear_override(false)
 cp1_descriptionMagenta TR3 TrueVIS 500ml Ink Pouch, Roland
 auto_descMagenta 500ml
 keyword
 keyword_2
 color_id45
 item_id0
 csiN
 color_selector_id0
 color_number
 cp1_statusA
 taxableN
 min0
 max1
 qty_avail1
 qty_on_hand1
 qty_on_po0
 qty_on_bo0
 qty_commit0
 last_po_date2025-10-17
 instock_override
 created2025-05-27 16:34:00
 modified2025-12-05 17:02:20
 cost_update2025-08-07
 cost_update_methodInotify Update DPG Items:
 last_cost_update2025-10-24
 last_cost_update_methodInotify Update DPG Items:
 fixed_cost_update0000-00-00
 fixed_cost_update_method
 sell_update2025-08-07
 sell_update_methodInotify Update DPG Items:
 sell_strategy
 cp1_write_off
 cp1_categ_cod3000
 cp1_subcat_cod3501
 cp1_categ_subcat3000/3501
 photo_square
 hideN
 sale_end0000-00-00
 sale_price0.00
 sale_start0000-00-00
 legacy_id0
 legacy_source
 kit_partN
 kit_flag
 kitableN
 fedx_flag
 ups_flag
 cp1_export0000-00-00
 cp1_sync(null)
 cp1_update0000-00-00
 cp1_export_flag
 unit_id0
 ItemsProduct(array)
 id50365
 item_id11267
 product_id1608
 Item_Unit(array)
 id33
 namePouch
 conversion1.0000
 a10nPouch
 purposeeach
 sortZZ
 Dim1_Unit(array)
 id14
 nameMilliliter
 conversion1.0000
 a10nml
 purposefluid
 sortZZ
 Dim2_Unit(array)
 id31
 nameN/A
 conversion1.0000
 a10n
 purpose
 sortZZ
 Group(array)
 id4
 nameInk
 a10nInks
 PriceGroup(array)
 id345
 description500ml
 a10n
 sort1
 groups4
 specification_id13
 iconnone
 text_color#000000
 index_flagN
 active
 StockStatus(empty)
 Color(array)
 id45
 descriptionMagenta
 a10nM
 sortM
 groups4
 specification_id11
 icon/assets/Icons/M.gif
 text_color
 index_flag
 active
 ShippingHeader(array)
 id0
 nameN/A
 a10nN/A
 zones(null)
 extra_fee(null)
 value
 Durabilities(array)
 outside3 years
- item_array(array)
 500ml(array)
 0(array)
 id11263
 cp1_item1163929
 product_parentROL-INK-TR3
 price_group500ml
 price_group_sort1
 vitemTR3-CY
 keyword
 keyword_2
 sell129.99
 sell_override
 sale_price0.00
 sale_range
 cost110.49
 lease0
 last_cost110.49
 publish_flagY
 cp1_write_off
 descriptionCyan 500ml
 free_shipping_itemN
 color_icon(array)
 icon/assets/Icons/C.gif
 altCyan
 qty_on_hand1
 stock_status_id0
 stock_status_textIn Stock
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortAC
 sortB
 image(array)
 icon
 altRoland DGA Part Number TR3-CY for Cyan 500ml
 kit_flag
 1(array)
 id11265
 cp1_item1163934
 product_parentROL-INK-TR3
 price_group500ml
 price_group_sort1
 vitemTR3-LC
 keyword
 keyword_2
 sell129.99
 sell_override
 sale_price0.00
 sale_range
 cost110.49
 lease0
 last_cost110.49
 publish_flagY
 cp1_write_off
 descriptionLight Cyan 500ml
 free_shipping_itemN
 color_icon(array)
 icon/assets/Icons/LC.gif
 altLight Cyan
 qty_on_hand1
 stock_status_id0
 stock_status_textIn Stock
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortACL
 sortB
 image(array)
 icon
 altRoland DGA Part Number TR3-LC for Light Cyan 500ml
 kit_flag
 2(array)
 id11264
 cp1_item1163933
 product_parentROL-INK-TR3
 price_group500ml
 price_group_sort1
 vitemTR3-GR
 keyword
 keyword_2
 sell129.99
 sell_override
 sale_price0.00
 sale_range
 cost103.99
 lease0
 last_cost103.99
 publish_flagY
 cp1_write_off
 descriptionGreen 500ml
 free_shipping_itemN
 color_icon(array)
 icon/assets/Icons/G.gif
 altGreen
 qty_on_hand1
 stock_status_id0
 stock_status_textIn Stock
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortAG
 sortB
 image(array)
 icon
 altRoland DGA Part Number TR3-GR for Green 500ml
 kit_flag
 3(array)
 id11261
 cp1_item1163931
 product_parentROL-INK-TR3
 price_group500ml
 price_group_sort1
 vitemTR3-BK
 keyword
 keyword_2
 sell129.99
 sell_override
 sale_price0.00
 sale_range
 cost110.49
 lease0
 last_cost110.49
 publish_flagY
 cp1_write_off
 descriptionBlack 500ml
 free_shipping_itemN
 color_icon(array)
 icon/assets/Icons/K.gif
 altBlack
 qty_on_hand1
 stock_status_id0
 stock_status_textIn Stock
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortAJ
 sortB
 image(array)
 icon
 altRoland DGA Part Number TR3-BK for Black 500ml
 kit_flag
 4(array)
 id11267
 cp1_item1163930
 product_parentROL-INK-TR3
 price_group500ml
 price_group_sort1
 vitemTR3-MG
 keyword
 keyword_2
 sell129.99
 sell_override
 sale_price0.00
 sale_range
 cost110.49
 lease0
 last_cost110.49
 publish_flagY
 cp1_write_off
 descriptionMagenta 500ml
 free_shipping_itemN
 color_icon(array)
 icon/assets/Icons/M.gif
 altMagenta
 qty_on_hand1
 stock_status_id0
 stock_status_textIn Stock
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortAM
 sortB
 image(array)
 icon
 altRoland DGA Part Number TR3-MG for Magenta 500ml
 kit_flag
 5(array)
 id11266
 cp1_item1163935
 product_parentROL-INK-TR3
 price_group500ml
 price_group_sort1
 vitemTR3-LM
 keyword
 keyword_2
 sell129.99
 sell_override
 sale_price0.00
 sale_range
 cost110.49
 lease0
 last_cost110.49
 publish_flagY
 cp1_write_off
 descriptionLight Magenta 500ml
 free_shipping_itemN
 color_icon(array)
 icon/assets/Icons/LM.gif
 altLight Magenta
 qty_on_hand1
 stock_status_id0
 stock_status_textIn Stock
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortAML
 sortB
 image(array)
 icon
 altRoland DGA Part Number TR3-LM for Light Magenta 500ml
 kit_flag
 6(array)
 id11268
 cp1_item1163932
 product_parentROL-INK-TR3
 price_group500ml
 price_group_sort1
 vitemTR3-OR
 keyword
 keyword_2
 sell129.99
 sell_override
 sale_price0.00
 sale_range
 cost103.99
 lease0
 last_cost103.99
 publish_flagY
 cp1_write_off
 descriptionOrange 500ml
 free_shipping_itemN
 color_icon(array)
 icon/assets/Icons/O.gif
 altOrange
 qty_on_hand1
 stock_status_id0
 stock_status_textIn Stock
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortAOr
 sortB
 image(array)
 icon
 altRoland DGA Part Number TR3-OR for Orange 500ml
 kit_flag
 7(array)
 id11269
 cp1_item1163928
 product_parentROL-INK-TR3
 price_group500ml
 price_group_sort1
 vitemTR3-YE
 keyword
 keyword_2
 sell129.99
 sell_override
 sale_price0.00
 sale_range
 cost110.49
 lease0
 last_cost110.49
 publish_flagY
 cp1_write_off
 descriptionYellow 500ml
 free_shipping_itemN
 color_icon(array)
 icon/assets/Icons/Y.gif
 altYellow
 qty_on_hand1
 stock_status_id0
 stock_status_textIn Stock
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortAY
 sortB
 image(array)
 icon
 altRoland DGA Part Number TR3-YE for Yellow 500ml
 kit_flag
 Speciality(array)
 0(array)
 id11262
 cp1_item1163936
 product_parentROL-INK-TR3
 price_groupSpeciality
 price_group_sort9
 vitemTR3-CL
 keyword
 keyword_2
 sell79.99
 sell_override
 sale_price0.00
 sale_range
 cost63.99
 lease0
 last_cost63.99
 publish_flagY
 cp1_write_off
 descriptionCleaning 750ml
 free_shipping_itemN
 color_icon(array)
 icon/assets/Icons/W.gif
 altCleaning
 qty_on_hand2
 stock_status_id0
 stock_status_textIn Stock
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortA
 sortB
 image(array)
 icon
 altRoland DGA Part Number TR3-CL for Cleaning 750ml
 kit_flag
 1(array)
 id11270
 cp1_item9011270
 product_parentROL-INK-TR3
 price_groupSpeciality
 price_group_sort9
 vitemTR3-WH
 keyword
 keyword_2
 sell94.99
 sell_override
 sale_price0.00
 sale_range
 cost75.99
 lease0
 last_cost75.99
 publish_flagY
 cp1_write_off
 descriptionWhite 250ml
 free_shipping_itemN
 color_icon(array)
 icon/assets/Icons/W.gif
 altWhite
 qty_on_hand0
 stock_status_id0
 stock_status_textSpecial Order
 price_break
 price_break_flag
 order_qty
 cart_flagN
 sortAZ2
 sortB
 image(array)
 icon
 altRoland DGA Part Number TR3-WH for White 250ml
 kit_flag
- templateproduct_V2
- productSideBars(empty)
- breadCrumb<a href="/">Digital Printer Group</a> / TR3 TrueVIS Inks
- meta_tag_description
- page_titleTR3 TrueVIS Inks, By Roland DGA | Schiller's Digital Printer Group
- aSeeAlsos(array)
 Product(array)
 id1608
 nameTR3 TrueVIS Inks
 SeeAlso(empty)
- isMobileN
- menu<div id="navigation"> <ul class="top-level"><li class= 'product' ><a href='/products/shop/'>Digital Print Media</a><ul class='sub-level'><li><a href='/categories/shop/Backlit-Digital-Print-Media'>Backlit</a><ul class='sub-level'><li><a href='/categories/shop/Backlit-Film-Digital-Print-Media'>Film</a></li><li><a href='/categories/shop/Digital-Print-Media-Backlit-Vinyl'>Vinyl</a></li></ul></li><li><a href='/categories/shop/Banner-Digital-Print-Media'>Banner</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Banner-1-Sided'>1-Sided</a></li><li><a href='/categories/shop/Digital-Print-Media-Banner-2-Sided'>2-Sided</a></li><li><a href='/categories/shop/Digital-Print-Media-Banner-Adhesive-Backed'>Adhesive Backed</a></li><li><a href='/categories/shop/Digital-Print-Media-Banner-RollUp'>RollUp</a></li><li><a href='/categories/shop/Mesh-Banner-Digital-Print-Media'>Mesh</a></li><li><a href='/categories/shop/Stands-Banner-Digital-Print-Media'>Stands</a></li></ul></li><li><a href='/categories/shop/Digital-Print-Media-CAD'>CAD</a></li><li><a href='/categories/shop/Canvas-Digital-Print-Media'>Canvas</a></li><li><a href='/categories/shop/Digital-Print-Media-Clear-Film'>Clear Film</a><ul class='sub-level'><li class= 'product' ><a href='/products/shop/STS-DTF-Clear-Film-Print-Media'>STS Direct to Film</a></li></ul></li><li><a href='/categories/shop/Digital-Print-Media-Dye-Sublimation-Paper'>Dye Sublimation Paper</a></li><li><a href='/categories/shop/Digital-Print-Media-Fabric'>Fabric</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Fabric-Printable'>Printable</a></li><li><a href='/categories/shop/Digital-Print-Media-Fabric-Dye-Sublimation'>Dye Sublimation</a></li></ul></li><li><a href='/categories/shop/Fine-Art-Digital-Print-Media'>Fine Art</a></li><li><a href='/categories/shop/Floor-Digital-Print-Media'>Floor</a></li><li><a href='/categories/shop/Digital-Print-Media-Magnetics'>Magnetics</a></li><li><a href='/categories/shop/Photobase-Digital-Print-Media'>Photobase</a><ul class='sub-level'><li><a href='/categories/shop/Dry-Lab-Photobase-Digital-Print-Media'>Dry Lab</a></li><li><a href='/categories/shop/Digital-Print-Media-Photobase-Adhesive-Backed'>Adhesive Backed</a></li><li><a href='/categories/shop/Digital-Print-Media-Photobase-Paper'>Paper</a></li></ul></li><li><a href='/categories/shop/Calendered-Vinyl-Digital-Print-Media'>Vinyl Calendered</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Clear'>Clear</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Translucent'>Translucent</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-White'>White</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Reflective'>Reflective</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Industrial'>Industrial 7-Year</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Air-Release'>Air Release</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Promotional'>Promotional 3-Year</a></li><li><a href='/categories/shop/Intermediate-Vinyl-Calendered-Digital-Print-Media'>Intermediate 5-Year</a></li><li><a href='/categories/shop/Promotional-3-Year-Air-Release-Vinyl-Calendered-Digital-Print-Media'>Promotional 3-Year Air Release </a></li><li><a href='/categories/shop/Intermediate-5-Year-Air-Release-Vinyl-Calendered-Digital-Print-Media'>Intermediate 5-Year Air Release</a></li></ul></li><li><a href='/categories/shop/Wall-Digital-Print-Media'>Wall</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Wall-PSA'>PSA</a></li><li><a href='/categories/shop/Digital-Print-Media-Wall-Wet-Strength-Paper'>Wet-Strength Paper</a></li><li><a href='/categories/shop/Digital-Print-Media-Wall-Wallpaper'>Wallpaper</a></li></ul></li><li><a href='/categories/shop/Windows-Digital-Print-Media'>Windows</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Windows-Cling'>Cling</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-PSA'>PSA</a></li><li><a href='/categories/shop/Perforated-Windows-Digital-Print-Media'>Perforated</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-60-40-Outside-Mount'>60/40 Outside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-50-50-Outside-Mount'>50/50 Outside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-60-40-Inside-Mount'>60/40 Inside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-80-20-Outside-Mount'>80/20 Outside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-65-35-Outside-Mount'>65/35 Outside Mount</a></li><li><a href='/categories/shop/70-30-Outside-Mount-Perforated-Windows-Digital-Print-Media'>70/30 Outside Mount</a></li><li><a href='/categories/shop/80-20-Inside-Mount-Perforated-Windows-Digital-Print-Media'>80/20 Inside Mount </a></li></ul></li><li><a href='/categories/shop/Printable-Etched-Windows-Digital-Print-Media'>Printable Etched</a></li></ul></li><li><a href='/categories/shop/Cast-Vinyl-Digital-Print-Media'>Vinyl Cast </a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-White'>White</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-Translucent'>Translucent</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-Vehicle-Wrap'> Vehicle Wrap</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-Air-Release'>Air Release</a></li><li><a href='/categories/shop/Reflective-Vinyl-Cast-Digital-Print-Media'>Reflective </a></li></ul></li><li><a href='/categories/shop/Presentation-Digital-Print-Media'>Presentation</a></li><li><a href='/categories/shop/RollUp-Banner-Digital-Print-Media'>RollUp</a></li><li><a href='/categories/shop/Heat-Transfer-Digital-Print-Media'>Heat Transfer</a><ul class='sub-level'><li><a href='/categories/shop/Print-Cut-Films-Heat-Transfer-Digital-Print-Media'>Print/Cut Films</a></li><li><a href='/categories/shop/Cut-Films-Heat-Transfer-Digital-Print-Media'>Cut Films</a></li><li><a href='/categories/shop/Transfer-Mask-Heat-Transfer-Digital-Print-Media'>Transfer Mask</a></li></ul></li><li><a href='/categories/shop/Proofing-Digital-Print-Media'>Proofing</a></li><li><a href='/categories/shop/Durables-Digital-Print-Media'>Durables</a></li><li><a href='/categories/shop/Styrene-Digital-Print-Media'>Styrene</a></li><li><a href='/categories/shop/POS-Digital-Print-Media'>POS</a></li></li></ul><li><a href='/categories/shop/Clearance'>Clearance</a><ul class='sub-level'></li></ul><li><a href='/categories/shop/Graphic-Sign'>Graphic/Sign</a><ul class='sub-level'><li><a href='/categories/shop/Graphic-Sign-Vinyl-Cutter-Blades'>Vinyl Cutter Blades</a><ul class='sub-level'><li><a href='/categories/shop/Graphic-Sign-Vinyl-Cutter-Blades-Roland'>Roland</a></li></ul></li><li><a href='/categories/shop/Graphic-Sign-Vinyl'>Sign Vinyl</a></li><li><a href='/categories/shop/Application-Tape-Graphic-Sign'>Application Tape</a></li></li></ul><li><a href='/categories/shop/Hardware'>Hardware</a><ul class='sub-level'><li><a href='/categories/shop/Hardware-Roland'>Roland</a><ul class='sub-level'><li><a href='/categories/shop/Resin-Roland'>Resin</a></li><li><a href='/categories/shop/Hardware-Roland-Print-Only'>Print Only</a></li><li><a href='/categories/shop/Hardware-Roland-Printer-Cutters'>Printer/Cutters</a></li><li><a href='/categories/shop/UV-Benchtop-Flatbed-Roland-Hardware'>UV Benchtop Flatbed</a></li><li><a href='/categories/shop/Hardware-Roland-UV-Printer-Cutters'>UV Printer/Cutters</a></li><li><a href='/categories/shop/Hardware-Roland-Vinyl-Cutters'>Vinyl Cutters</a></li><li><a href='/categories/shop/Hardware-Roland-Sublimation'>Sublimation</a></li><li><a href='/categories/shop/Hardware-Roland-Common-Replacement-Parts'>Replacement Parts</a></li><li><a href='/categories/shop/UV-Flatbed-Roland-Hardware'>UV Flatbed</a></li><li class= 'product' ><a href='/products/shop/Roland-DGA-XT-640S-DTG-Multi-Station-Direct-to-Garment-Printer'>Direct-to-Garment Printer</a></li></ul></li><li><a href='/categories/shop/Hardware-GFP-Graphic-Finish-Partners'>GFP (Graphic Finish Partners)</a></li><li><a href='/categories/shop/Vanguard-Digital-UV-Flatbed-Printer-Hardware'>Vanguard Digital UV Flatbed Printer</a></li></li></ul><li class= 'product' ><a href='/products/shop/'>Inks</a><ul class='sub-level'><li><a href='/categories/shop/Inks-Roland'>Roland</a><ul class='sub-level'><li><a href='/categories/shop/Garment-Roland-Inks'>Garment</a></li><li><a href='/categories/shop/Inks-Roland-Eco-UV'>Eco-UV</a></li><li><a href='/categories/shop/Inks-Roland-Eco-Sol-MAX'>Eco-Sol MAX</a></li><li><a href='/categories/shop/TrueVIS-Roland-Inks'>TrueVIS</a></li></ul></li><li><a href='/categories/shop/Inks-SPL-Brand'>SPL Brand</a><ul class='sub-level'><li><a href='/categories/shop/Inks-SPL-Brand-Roland'>Roland</a></li><li><a href='/categories/shop/Inks-SPL-Brand-Epson'>Epson</a></li><li><a href='/categories/shop/Inks-SPL-Brand-Canon'>Canon</a></li><li><a href='/categories/shop/Inks-SPL-Brand-Mutoh'>Mutoh</a></li><li><a href='/categories/shop/HP-SPL-Brand-Inks'>HP</a></li><li><a href='/categories/shop/Mimaki-SPL-Brand-Inks'>Mimaki</a></li><li><a href='/categories/shop/Oki-Data-SPL-Brand-Inks'>Oki Data</a></li></ul></li><li><a href='/categories/shop/Inks-Seiko-Okidata'>Seiko/Okidata</a></li><li><a href='/categories/shop/Inks-Canon'>Canon</a></li><li><a href='/categories/shop/Inks-Epson'>Epson</a><ul class='sub-level'><li><a href='/categories/shop/Inks-Epson-Epson-OEM'>Epson OEM</a></li><li><a href='/categories/shop/Inks-Epson-SPL-Brand'>SPL Brand</a></li></ul></li><li><a href='/categories/shop/Inks-UV-Adhesion-Promoters'>UV Adhesion Promoters</a></li><li><a href='/categories/shop/Vanguard-Digital-Inks'>Vanguard Digital</a></li><li><a href='/categories/shop/HP-Inks'>HP</a><ul class='sub-level'></ul></li><li><a href='/categories/shop/STS-Direct-to-Film-Supplies'>STS Direct to Film Supplies</a></li></li></ul><li><a href='/categories/shop/Lamination'>Lamination</a><ul class='sub-level'><li><a href='/categories/shop/Lamination-PSA'>PSA</a><ul class='sub-level'><li><a href='/categories/shop/Lamination-PSA-Foor'>Floor</a></li><li><a href='/categories/shop/Lamination-PSA-Cast'>Cast</a></li><li><a href='/categories/shop/Lamination-PSA-Calendered'>Calendered</a></li><li><a href='/categories/shop/Lamination-PSA-Polycarbonate'>Polycarbonate </a></li><li><a href='/categories/shop/Lamination-PSA-Speciality'>Speciality</a></li></ul></li><li class= 'product' ><a href='/products/shop/Kraft-Paper'>Kraft Paper</a></li><li><a href='/categories/shop/Thermal-Lamination-Supplies'>Thermal</a></li></li></ul><li><a href='/categories/shop/Mounting-Supplies'>Mounting</a><ul class='sub-level'><li><a href='/categories/shop/PSA-Mounting'>PSA</a><ul class='sub-level'><li><a href='/categories/shop/Mounting-PSA-Clear'>Clear</a></li><li><a href='/categories/shop/Mounting-PSA-White'>White</a></li><li><a href='/categories/shop/Mounting-PSA-Window'>Window</a></li></ul></li><li><a href='/categories/shop/Heat-Activated-Backing-Films-Mounting'>Heat-Activated Backing Films</a></li><li class= 'product' ><a href='/products/shop/Kraft-Paper'>Kraft Paper</a></li></li></ul><li><a href='/categories/shop/Shop-Tools-Supplies'>Shop Tools & Supplies</a><ul class='sub-level'><li><a href='/categories/shop/Shop-Tools-Supplies-Safety-Rulers'>Safety Rulers</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-Media-Racks'>Media Racks</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-Grommet-Press'>Grommet Press</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-UV-Adhesion-Promoters'>UV Adhesion Promoters</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-Grommets'>Grommets</a></li><li><a href='/categories/shop/Squeegees-Shop-Tools-Supplies'>Squeegees</a></li><li><a href='/categories/shop/Cutting-Tools-and-Supplies-Shop-Tools-Supplies'>Cutting Tools and Supplies</a></li><li><a href='/categories/shop/Weeding-Tools-Shop-Tools-Supplies'>Weeding Tools</a></li></li></ul><li><a href='/categories/shop/Heat-Transfer-Films'>Heat Transfer Films</a><ul class='sub-level'><li><a href='/categories/shop/Print-Cut-Films-Heat-Transfer-Films'>Print/Cut Films</a></li><li><a href='/categories/shop/Cut-Films-Heat-Transfer-Films'>Cut Films</a></li><li><a href='/categories/shop/Transfer-Mask-Heat-Transfer-Films'>Transfer Mask </a></li></li></ul><li><a href='/categories/shop/Sign-Vinyl'>Sign Vinyl</a><ul class='sub-level'><li><a href='/categories/shop/Premium-Sign-Vinyl'>Premium </a></li><li><a href='/categories/shop/Intermediate-Sign-Vinyl'>Intermediate </a></li><li><a href='/categories/shop/Decorative-Sign-Vinyl'>Decorative </a></li><li><a href='/categories/shop/Specialty-Sign-Vinyl'>Specialty</a></li><li><a href='/categories/shop/Reflective-Sign-Vinyl'>Reflective </a></li><li><a href='/categories/shop/Application-Tape-Sign-Vinyl'>Application Tape</a></li></li></ul><li><a href='/categories/shop/Best-Sellers'>Best Sellers</a><ul class='sub-level'><li><a href='/categories/shop/Print-Best-Sellers'>Print</a></li><li><a href='/categories/shop/Protection-Best-Sellers'>Protection</a></li><li><a href='/categories/shop/Mounting-Best-Sellers'>Mounting</a></li></li></ul><li><a href='/categories/shop/New-Products'>New Products</a><ul class='sub-level'></li></ul></ul></div>
- $request->data(empty)
- $this->validationErrors(array)
 UserSetting(empty)
 User(empty)
 UserGroup(empty)
 UserActivity(empty)
 Product(empty)
 Template(empty)
 PrimaryBrand(empty)
 Group(empty)
 SubGroup(empty)
 StockStatus(empty)
 Item(empty)
 Item_Unit(empty)
 Dim1_Unit(empty)
 Dim2_Unit(empty)
 ShippingHeader(empty)
 PriceGroup(empty)
 Color(empty)
 ItemsProduct(empty)
 ShippingRates(empty)
 Specification(empty)
 SpecificationDetail(empty)
 ProductSideBar(empty)
 Cp1SpecialPrice(empty)
 UserBillTo(empty)
 SeeAlso(empty)
 Releated(empty)
 InkType(empty)
 Cart(empty)
- Loaded Helpers(array)
 0Form
 1Html
 2Session
 3Js
 4UserAuth
 5Image
 6Recaptcha
 7Number
 8SimpleGraph
 9DebugTimer
 10Toolbar
 11Flash
 12HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	5.5.38
Path	/sbin:/usr/sbin:/bin:/usr/bin
Pp Custom Php Ini	/var/www/vhosts/system/dpgtest.schillers.com/etc/php.ini
Pp Custom Php Cgi Index	plesk-php55-fastcgi
Http Connection	close
Script Name	/app/webroot/index.php
Request Uri	/products/shop/Roland-DGA-TR3-TrueVIS-Eco-Solvent-Inks
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/products/shop/Roland-DGA-TR3-TrueVIS-Eco-Solvent-Inks
Remote Port	34442
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	aTOwrUrQSlAAAEwBMFEAAAAU
Redirect Status	200
Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Https	on
Redirect Unique Id	aTOwrUrQSlAAAEwBMFEAAAAU
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Redirect Https	on
Redirect Redirect Unique Id	aTOwrUrQSlAAAEwBMFEAAAAU
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1764995245.1979
Request Time	1764995245

====

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
Cyan 500ml	TR3-CY	1163929	$129.99
Light Cyan 500ml	TR3-LC	1163934	$129.99
Green 500ml	TR3-GR	1163933	$129.99
Black 500ml	TR3-BK	1163931	$129.99
Magenta 500ml	TR3-MG	1163930	$129.99
Light Magenta 500ml	TR3-LM	1163935	$129.99
Orange 500ml	TR3-OR	1163932	$129.99
Yellow 500ml	TR3-YE	1163928	$129.99

	Description	Vendor #	Item #	Price
	Cleaning 750ml	TR3-CL	1163936	$79.99
	White 250ml	TR3-WH	9011270	$94.99

TR3 TrueVIS Inks

500ml

Speciality

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 475 ms Total Queries: 133 queries

Query Explain:

Memory

Timers

Logs

debug

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 475 ms
Total Queries: 133 queries