| 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.