Rollaguard Clearcoat Liquid Laminate, By Daige | Schiller's Digital Printer Group

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

Cake Params
- plugin(null)
- controllerproducts
- actiondiscontinued
- named(empty)
- pass(array)
  0Rollaguard-Liquid-Overlaminating-Film
- 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: 473 ms
Total Queries: 131 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` = '46c5404893f7d8e229da7750c479934320pqnigi53ljars9tlg24dk080' LIMIT 1	0	0	422	maybe slow
BEGIN
INSERT INTO `dpg_ecommerce`.`user_activities` (`useragent`, `user_id`, `last_action`, `last_url`, `user_browser`, `ip_address`, `status`, `modified`, `created`) VALUES ('46c5404893f7d8e229da7750c479934320pqnigi53ljars9tlg24dk080', NULL, 1769223074, '/products/discontinued/Rollaguard-Liquid-Overlaminating-Film', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '216.73.216.165', 0, '2026-01-23 16:51:15', '2026-01-23 16:51:15')	1	1	0
COMMIT
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified` FROM `dpg_ecommerce`.`categories` AS `Category` WHERE `Category`.`parent_id` IS NULL AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	12	12	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 0 LIMIT 1	0	0	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 8 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	22	22	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (15, 18, 27, 28, 29, 30, 31, 32, 33, 34, 35, 46, 51, 52, 64, 69, 71, 89, 166, 207, 213, 224)	40	40	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (15, 18, 27, 28, 29, 30, 31, 32, 33, 34, 35, 46, 51, 52, 64, 69, 71, 89, 166, 207, 213, 224)	13	13	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (15, 18, 27, 28, 29, 30, 31, 32, 33, 34, 35, 46, 51, 52, 64, 69, 71, 89, 166, 207, 213, 224) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	470	470	9
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 15 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	2	2	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (16, 17)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (16, 17)	2	2	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (16, 17) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	18	18	1	maybe slow
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 18 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	6	6	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (23, 24, 25, 70, 204, 221)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (23, 24, 25, 70, 204, 221)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (23, 24, 25, 70, 204, 221) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	69	69	2
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 29 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	1	1	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` = (223)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` = (223)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` = 223 AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	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` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1451 LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 31 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	2	2	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (60, 61)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (60, 61)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (60, 61) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	10	10	1	maybe slow
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 35 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (240, 36, 37)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (240, 36, 37)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (240, 36, 37) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	58	58	2
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 46 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	10	10	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (47, 48, 49, 62, 63, 122, 134, 191, 192, 195)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (47, 48, 49, 62, 63, 122, 134, 191, 192, 195)	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (47, 48, 49, 62, 63, 122, 134, 191, 192, 195) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	119	119	4
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 51 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (53, 54, 55)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (53, 54, 55)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (53, 54, 55) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	53	53	2
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 52 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	4	4	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (56, 57, 58, 59)	7	7	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (56, 57, 58, 59)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (56, 57, 58, 59) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	68	68	2
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 58 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	7	7	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (142, 143, 144, 145, 146, 155, 231)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (142, 143, 144, 145, 146, 155, 231)	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (142, 143, 144, 145, 146, 155, 231) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	36	36	1
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 64 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	5	5	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (65, 66, 67, 68, 186)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (65, 66, 67, 68, 186)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (65, 66, 67, 68, 186) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	24	24	1
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 89 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (90, 156, 157)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (90, 156, 157)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (90, 156, 157) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	36	36	1
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 241 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	0	0	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 9 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (107, 148, 185)	1	1	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (107, 148, 185)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (107, 148, 185) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	29	29	1
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 107 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	1	1	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` = (128)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` = (128)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` = 128 AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	2	2	1	maybe slow
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 10 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (79, 88, 198)	10	10	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (79, 88, 198)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (79, 88, 198) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	26	26	1
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 79 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	10	10	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (239, 102, 103, 108, 109, 116, 118, 141, 225, 226)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (239, 102, 103, 108, 109, 116, 118, 141, 225, 226)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (239, 102, 103, 108, 109, 116, 118, 141, 225, 226) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	55	55	2
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` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1494 LIMIT 1	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 0 LIMIT 1	0	0	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 11 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	9	9	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (19, 73, 77, 110, 113, 131, 203, 211, 222)	14	14	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (19, 73, 77, 110, 113, 131, 203, 211, 222)	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (19, 73, 77, 110, 113, 131, 203, 211, 222) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	90	90	3
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 19 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	4	4	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (238, 139, 140, 165)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (238, 139, 140, 165)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (238, 139, 140, 165) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	16	16	1	maybe slow
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 73 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	7	7	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (74, 112, 121, 127, 200, 201, 220)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (74, 112, 121, 127, 200, 201, 220)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (74, 112, 121, 127, 200, 201, 220) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	15	15	1	maybe slow
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 113 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	2	2	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (114, 115)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (114, 115)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (114, 115) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	41	41	1
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 211 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	0	0	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 12 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (40, 120, 123)	5	5	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (40, 120, 123)	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (40, 120, 123) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	63	63	2
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 40 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	5	5	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (75, 91, 111, 119, 133)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (75, 91, 111, 119, 133)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (75, 91, 111, 119, 133) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	46	46	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` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 696 LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 13 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (43, 126, 152)	3	3	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (43, 126, 152)	2	2	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (43, 126, 152) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	14	14	1	maybe slow
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 43 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (135, 136, 137)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (135, 136, 137)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (135, 136, 137) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	19	19	1	maybe slow
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` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 696 LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 21 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	8	8	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (22, 50, 129, 130, 132, 169, 170, 171)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (22, 50, 129, 130, 132, 169, 170, 171)	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (22, 50, 129, 130, 132, 169, 170, 171) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	20	20	1	maybe slow
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 159 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (160, 161, 162)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (160, 161, 162)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (160, 161, 162) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	36	36	1
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 175 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	6	6	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (176, 177, 178, 179, 189, 190)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (176, 177, 178, 179, 189, 190)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (176, 177, 178, 179, 189, 190) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	34	34	1
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 180 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`name`, `ChildCategory`.`template_id`, `ChildCategory`.`slug`, `ChildCategory`.`slug_lock`, `ChildCategory`.`publish_flag`, `ChildCategory`.`heading`, `ChildCategory`.`meta_tag_title`, `ChildCategory`.`meta_tag_description`, `ChildCategory`.`product_id`, `ChildCategory`.`seq`, `ChildCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (181, 182, 183)	0	0	0
SELECT `SeoRedirect`.`id`, `SeoRedirect`.`product_id`, `SeoRedirect`.`category_id`, `SeoRedirect`.`old_url`, `SeoRedirect`.`new_url`, `SeoRedirect`.`product_flag`, `SeoRedirect`.`category_flag` FROM `dpg_ecommerce`.`seo_redirects` AS `SeoRedirect` WHERE `SeoRedirect`.`category_id` IN (181, 182, 183)	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (181, 182, 183) AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC	102	102	4
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`parent_id` = 228 AND `Category`.`publish_flag` = 'Y' ORDER BY `Category`.`lft` ASC	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`slug` = 'Rollaguard-Liquid-Overlaminating-Film' LIMIT 1	1	1	1
SELECT `Product`.`id`, `Product`.`name` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1204 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` = (1204)	0	0	0
SELECT `InkType`.`id`, `InkType`.`name` FROM `dpg_ecommerce`.`ink_types` AS `InkType` WHERE 1 = 1	20	20	0

2 duplicate queries run.

Query Explain:

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

====

Timer

Memory

Peak Memory Use 33.95 MB

Message	Memory use
Component initialization	5.50 MB
Controller action start	18.39 MB
Controller render start	18.84 MB
View render complete	20.93 MB

Timers

Total Request Time: 902 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	33.78
Event: Controller.initialize	763.60
Event: Controller.startup	0.79
Controller action	6.58
Event: Controller.beforeRender	11.72
» Processing toolbar data	10.18
Rendering View	5.46
» Event: View.beforeRender	0.03
» Rendering APP/View/Products/discontinued.ctp	0.12
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	4.54
» » Rendering APP/View/Elements/header_menu.ctp	0.24
» » Rendering APP/View/Elements/Pages/default_page.ctp	2.94
» » » Rendering APP/View/Elements/hMenu01.ctp	2.33
» » » » Rendering APP/View/Elements/Search/productSearch.ctp	0.38
» » » Rendering APP/Plugin/Usermgmt/View/Elements/message.ctp	0.10
» » » 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
2026-01-23 16:51:14 Data AppController:

2026-01-23 16:51:15 layout_default default.ctp:

2026-01-23 16:51:15 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)
 id1204
 nameRollaguard Clearcoat Liquid Laminate
 cat_name
 cart_name{dim1} {dim1u} {item_keyword} {product_name}
 cart_short_name{dim1} {dim1u} {item_keyword}
 child_name
 short_nameRollaguard
 keyword
 keyword_2
 publish_flagD
 slug_lockN
 slugRollaguard-Liquid-Overlaminating-Film
 group_id2
 sub_group_id32
 primary_brand_id89
 template_id39
 sub_template_id0
 description<ul> <li style="margin: 0in 0in 0.0001pt 0.5in;">Costs significantly less per application than film laminates.</li> <li style="margin: 0in 0in 0.0001pt 0.5in;">Provides excellent UV, abrasion and water protection.</li> <li style="margin: 0in 0in 0.0001pt 0.5in;">Enhances the vibrancy of the inks.</li> <li style="margin: 0in 0in 0.0001pt 0.5in;">Media retains its flexibility.</li> <li style="margin: 0in 0in 8pt 0.5in;">Will not crack or peel off</li> </ul>
 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_id0
 layerable
 liner_id0
 liner_thickness_dimension0.000
 liner_thickness_id0
 min_application_temperature_id0
 removability_id0
 removal_temperature_range_id0
 service_temperature_range_id0
 shelf_life_id0
 sort_idZ
 stock_status_flagN
 stock_status_rating0
 stock_status_id560
 storage_requirement_id0
 thickness_dimension0.000
 thickness_id0
 total_thickness_dimension0.000
 total_thickness_id0
 meta_tag_title
 meta_tag_description
 meta_brandDaige
 meta_categoriesLaminating Lamination
 meta_certifications
 meta_cp1_items1002028, 1002027
 meta_vitemsWGALS, WGALG
 meta_ink_types
 meta_specifications(0.000/0.000) Activation Temp:
 meta_substrates
 manual_key_words
 key_words(0.000/0.000) Activation Temp:, 1002027, 1002028, Clearcoat, Daige, Film, Gloss, Laminate, Laminating Lamination, Liquid, Overlaminating, Rollaguard, Satin, WGALG, WGALS
 washability_id0
 m1_sync2021-10-15 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
 created2018-04-20
 modified2024-09-25
- page_titleRollaguard Clearcoat Liquid Laminate, By Daige | Schiller's Digital Printer Group
- 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)
 Category(empty)
 Product(empty)
 ParentCategory(empty)
 Template(empty)
 ChildCategory(empty)
 SeoRedirect(empty)
 CategoriesProduct(empty)
 SeeAlso(empty)
 Releated(empty)
 PrimaryBrand(empty)
 InkType(empty)
- Loaded Helpers(array)
 0Form
 1Html
 2Session
 3Js
 4UserAuth
 5Image
 6Recaptcha
 7Number
 8SimpleGraph
 9DebugTimer
 10Toolbar
 11Flash
 12HtmlToolbar
====

Time	Message
2026-01-23 16:51:14	Data AppController:
2026-01-23 16:51:15	layout_default default.ctp:
2026-01-23 16:51:15	Data default_page:

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/discontinued/Rollaguard-Liquid-Overlaminating-Film
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/products/discontinued/Rollaguard-Liquid-Overlaminating-Film
Remote Port	19606
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.165
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	aXP7YkrQSlAAAF-lOZQAAAAa
Redirect Status	200
Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Https	on
Redirect Unique Id	aXP7YkrQSlAAAF-lOZQAAAAa
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Redirect Https	on
Redirect Redirect Unique Id	aXP7YkrQSlAAAF-lOZQAAAAa
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1769208674.5186
Request Time	1769208674

====

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/Category.php
  2APP/Model/Product.php
  3APP/Model/Template.php
  4APP/Model/SeoRedirect.php
  5APP/Model/SeeAlso.php
  6APP/Model/Brand.php
  7APP/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
====

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 473 ms Total Queries: 131 queries

Query Explain:

Memory

Timers

Logs

debug

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 473 ms
Total Queries: 131 queries