| 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` = '46c5404893f7d8e229da7750c4799343prefncacn3cj35ug6gbvslfj75' LIMIT 1 | 1 | 1 | 408 | maybe slow |
| BEGIN | | | | |
| SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`id` = 1969310 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`id` = 1969310 | 1 | 1 | 0 | |
| UPDATE `dpg_ecommerce`.`user_activities` SET `id` = 1969310, `useragent` = '46c5404893f7d8e229da7750c4799343prefncacn3cj35ug6gbvslfj75', `user_id` = NULL, `last_action` = 1765009785, `last_url` = '/brands/shop_categories_by_brand/Continental%20Grafix', `logout_time` = NULL, `user_browser` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', `ip_address` = '216.73.216.151', `logout` = 0, `deleted` = 0, `status` = 0, `created` = '2025-12-05 22:29:39', `modified` = '2025-12-05 22:29:50' WHERE `dpg_ecommerce`.`user_activities`.`id` = '1969310' | 1 | 1 | 0 | |
| COMMIT | | | | |
| SELECT `Brand`.`id`, `Brand`.`parent_id`, `Brand`.`lft`, `Brand`.`rght`, `Brand`.`name`, `Brand`.`template_id`, `Brand`.`slug`, `Brand`.`meta_tag_title`, `Brand`.`meta_tag_description`, `Brand`.`url`, `Brand`.`publish_flag` FROM `dpg_ecommerce`.`brands` AS `Brand` WHERE `Brand`.`name` = 'Continental Grafix' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name` FROM `dpg_ecommerce`.`categories` AS `Category` WHERE `Category`.`parent_id` IS NULL | 12 | 12 | 0 | |
| SELECT `BrandsProduct`.`id`, `BrandsProduct`.`brand_id`, `BrandsProduct`.`product_id` FROM `dpg_ecommerce`.`brands_products` AS `BrandsProduct` WHERE `BrandsProduct`.`brand_id` = 118 | 29 | 29 | 1 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1504 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1504 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 3 | 3 | 1 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1510 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1510 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 2 | 2 | 1 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1511 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1511 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 2 | 2 | 1 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1508 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1508 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 3 | 3 | 1 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1512 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1512 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 4 | 4 | 1 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1514 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1514 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 2 | 2 | 1 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1515 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1515 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 2 | 2 | 2 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1516 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1516 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 2 | 2 | 2 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1517 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1517 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 4 | 4 | 2 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 51 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1501 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1501 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 4 | 4 | 2 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 51 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1523 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1523 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 2 | 2 | 2 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 12 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 40 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1524 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1524 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 2 | 2 | 2 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 46 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1525 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1525 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 2 | 2 | 2 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 13 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 43 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1526 AND `Product`.`publish_flag` = 'Y' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1533 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1533 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 3 | 3 | 2 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1534 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1534 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 3 | 3 | 2 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1535 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1535 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 3 | 3 | 2 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1536 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1536 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 3 | 3 | 1 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1496 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1496 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 3 | 3 | 2 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 1 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1497 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1497 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 3 | 3 | 2 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1498 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1498 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 3 | 3 | 2 | maybe slow |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1500 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1500 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 3 | 3 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1521 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1521 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 5 | 5 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 51 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1503 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1503 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 2 | 2 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1556 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1556 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 3 | 3 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 51 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1499 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1499 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 3 | 3 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1522 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1522 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 2 | 2 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 40 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1588 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1588 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 2 | 2 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 12 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 40 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1507 AND `Product`.`publish_flag` = 'Y' 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`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1507 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL | 6 | 6 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `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` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 58 | 1 | 1 | 0 | |
| SELECT `InkType`.`id`, `InkType`.`name` FROM `dpg_ecommerce`.`ink_types` AS `InkType` WHERE 1 = 1 | 20 | 20 | 0 | |
73 duplicate queries run.