Schillers DPG

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent46c5404893f7d8e229da7750c4799343
  time1765004380
  countdown10
- UserAuth(empty)
- SchillersShop(array)
  breadCrumb<a href="/">Digital Printer Group</a> / <a href="/categories/shop/Mounting-Supplies">Mounting</a>
====
Request
+
Request

Cake Params
- plugin(null)
- controllerbrands
- actionshop_categories_by_brand
- named(empty)
- pass(array)
  0Sihl
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(array)
  defaultRoute(true)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Logs

default

Total Time: 414 ms
Total Queries: 153 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `UserSetting`.`id`, `UserSetting`.`name`, `UserSetting`.`name_public`, `UserSetting`.`value`, `UserSetting`.`type`, `UserSetting`.`category`, `UserSetting`.`setting_key`, `UserSetting`.`setting_value`, `UserSetting`.`setting_type` FROM `dpg_ecommerce`.`user_settings` AS `UserSetting` WHERE 1 = 1	55	55	0
SELECT `UserActivity`.`id`, `UserActivity`.`useragent`, `UserActivity`.`user_id`, `UserActivity`.`last_action`, `UserActivity`.`last_url`, `UserActivity`.`logout_time`, `UserActivity`.`user_browser`, `UserActivity`.`ip_address`, `UserActivity`.`logout`, `UserActivity`.`deleted`, `UserActivity`.`status`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`useragent` = '46c5404893f7d8e229da7750c4799343fs4olje0ukqlitmi1df1sb08m3' LIMIT 1	1	1	414	maybe slow
BEGIN
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`id` = 1969107	1	1	0
SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`id` = 1969107	1	1	0
UPDATE `dpg_ecommerce`.`user_activities` SET `id` = 1969107, `useragent` = '46c5404893f7d8e229da7750c4799343fs4olje0ukqlitmi1df1sb08m3', `user_id` = NULL, `last_action` = 1765004380, `last_url` = '/brands/shop_categories_by_brand/Sihl', `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 20:59:37', `modified` = '2025-12-05 20:59:40' WHERE `dpg_ecommerce`.`user_activities`.`id` = '1969107'	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` = 'Sihl' 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` = 77	39	39	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1059 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` = 1059 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` = 180	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1130 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` = 1130 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1202 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` = 1202 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	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` = 1236 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` = 1236 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	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` = 1057 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` = 1057 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	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` = 1328 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` = 1328 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1348 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` = 1348 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` = 15	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1356 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` = 1356 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1084 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` = 1084 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1355 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` = 1355 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` = 35	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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1358 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` = 1358 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1073 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` = 1073 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	4	4	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` = 31	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` = 1359 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` = 1359 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	4	4	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` = 31	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` = 1357 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` = 1357 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1129 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` = 1129 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` = 18	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` = 1410 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` = 1427 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` = 1427 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	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` = 1428 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` = 1428 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	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` = 1347 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` = 1433 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` = 1433 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1082 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` = 1082 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1434 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` = 1434 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1435 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` = 1435 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1349 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` = 1349 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` = 18	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` = 1456 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` = 1456 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1465 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` = 1465 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	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` = 1334 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` = 1455 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` = 1455 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` = 18	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 `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1097 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` = 1097 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	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` = 1095 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` = 1096 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` = 1436 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` = 1436 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1584 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` = 1584 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` = 18	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` = 31	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1595 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` = 1595 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1596 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` = 1596 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1603 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` = 1603 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1604 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` = 1604 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` = 35	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1609 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` = 1609 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` = 51	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1237 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` = 1237 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` = 51	1	1	0
SELECT `InkType`.`id`, `InkType`.`name` FROM `dpg_ecommerce`.`ink_types` AS `InkType` WHERE 1 = 1	20	20	0

62 duplicate queries run.

Query Explain:

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

====

Timer

Memory

Peak Memory Use 23.58 MB

Message	Memory use
Component initialization	4.27 MB
Controller action start	16.86 MB
Controller render start	18.36 MB
View render complete	20.38 MB

Timers

Total Request Time: 695 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	27.02
Event: Controller.initialize	500.21
Event: Controller.startup	0.36
Controller action	54.48
Event: Controller.beforeRender	7.69
» Processing toolbar data	6.59
Rendering View	14.15
» Event: View.beforeRender	0.03
» Rendering APP/View/Elements/Templates/Brands/shop_categories_by_brand.ctp	8.78
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	4.60
» » Rendering APP/View/Elements/header_menu.ctp	0.23
» » Rendering APP/View/Elements/Pages/default_page.ctp	2.98
» » » Rendering APP/View/Elements/hMenu01.ctp	2.35
» » » » Rendering APP/View/Elements/Search/productSearch.ctp	0.40
» » » Rendering APP/Plugin/Usermgmt/View/Elements/message.ctp	0.11
» » » Rendering APP/Plugin/Usermgmt/View/Elements/message_validation.ctp	0.08
» » Rendering APP/View/Elements/dpg-footer.ctp	0.08
» » Rendering APP/View/Elements/final-footer.ctp	0.08
Event: View.afterLayout	0.00

====

Log
+

Logs

debug

Time Message
2025-12-05 20:59:40 Data AppController:

2025-12-05 20:59:41 layout_default default.ctp:

2025-12-05 20:59:41 Data default_page:

====
Variables
+
View Variables
- stockFilter*
- inkFilters(empty)
- show_debug(null)
- show_non_published(null)
- isAdmin(null)
- isAdminSub(null)
- inkTypes(array)
  Eco-SolventEco-Solvent
  SolventSolvent
  UVUV
  LatexLatex
  DyeDye
  Dye-SubDye-Sub
  PigmentPigment
  ScreenScreen
  Thermal TransferThermal Transfer
  HP Latex CertifiedHP Latex Certified
  N/AN/A
  Toner FuserToner Fuser
  Direct to Film Direct to Film
  PageWidePageWide
  Canon UVgel 356Canon UVgel 356
  OfsettOfsett
  ResinResin
  Noritsu Dry LabNoritsu Dry Lab
  Fuji Dry Lab Fuji Dry Lab
  Epson Dry Lab Epson Dry Lab
- var(empty)
- categories(array)
  0(array)
  idALL
  parent_id0
  name
  headingAll Products
  lft0
  rght0
  primary_brand_id77
  brand_nameSihl
  slugALL
  parent_name
  display_nameAll Products
  allY
  masterN
  sub_masterN
  1(array)
  id15
  parent_id8
  nameBacklit
  heading
  lft2
  rght7
  primary_brand_id77
  brand_nameSihl
  slugBacklit-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Backlit
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  2(array)
  id16
  parent_id15
  nameFilm
  heading
  lft3
  rght4
  primary_brand_id77
  brand_nameSihl
  slugBacklit-Film-Digital-Print-Media
  parent_nameBacklit
  display_nameBacklit Film
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id15
  parent_id8
  lft2
  rght7
  nameBacklit
  template_id22
  slugBacklit-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleBacklit Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq1
  modified2023-05-03
  3(array)
  id18
  parent_id8
  nameBanner
  headingddddd
  lft8
  rght21
  primary_brand_id77
  brand_nameSihl
  slugBanner-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameddddd
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  4(array)
  id70
  parent_id18
  nameRollUp
  heading(null)
  lft15
  rght16
  primary_brand_id77
  brand_nameSihl
  slugDigital-Print-Media-Banner-RollUp
  parent_nameBanner
  display_nameBanner RollUp
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id18
  parent_id8
  lft8
  rght21
  nameBanner
  template_id22
  slugBanner-Digital-Print-Media
  slug_lockY
  publish_flagY
  headingddddd
  meta_tag_title
  meta_tag_description
  product_id0
  seq4
  modified2023-05-03
  5(array)
  id28
  parent_id8
  nameCanvas
  heading
  lft24
  rght25
  primary_brand_id77
  brand_nameSihl
  slugCanvas-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Canvas
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  6(array)
  id29
  parent_id8
  nameClear Film
  heading(null)
  lft26
  rght29
  primary_brand_id77
  brand_nameSihl
  slugDigital-Print-Media-Clear-Film
  parent_nameDigital Print Media
  display_nameDigital Print Media Clear Film
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  7(array)
  id31
  parent_id8
  nameFabric
  heading(null)
  lft32
  rght37
  primary_brand_id77
  brand_nameSihl
  slugDigital-Print-Media-Fabric
  parent_nameDigital Print Media
  display_nameDigital Print Media Fabric
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  8(array)
  id60
  parent_id31
  namePrintable
  heading(null)
  lft33
  rght34
  primary_brand_id77
  brand_nameSihl
  slugDigital-Print-Media-Fabric-Printable
  parent_nameFabric
  display_nameFabric Printable
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id31
  parent_id8
  lft32
  rght37
  nameFabric
  template_id22
  slugDigital-Print-Media-Fabric
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_title(null)
  meta_tag_description(null)
  product_id(null)
  seq16
  modified2023-05-03
  9(array)
  id35
  parent_id8
  namePhotobase
  heading
  lft44
  rght53
  primary_brand_id77
  brand_nameSihl
  slugPhotobase-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Photobase
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  10(array)
  id36
  parent_id35
  nameAdhesive Backed
  heading(null)
  lft47
  rght48
  primary_brand_id77
  brand_nameSihl
  slugDigital-Print-Media-Photobase-Adhesive-Backed
  parent_namePhotobase
  display_namePhotobase Adhesive Backed
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id35
  parent_id8
  lft44
  rght53
  namePhotobase
  template_id22
  slugPhotobase-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titlePhotobase Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq22
  modified2023-05-03
  11(array)
  id37
  parent_id35
  namePaper
  heading(null)
  lft49
  rght50
  primary_brand_id77
  brand_nameSihl
  slugDigital-Print-Media-Photobase-Paper
  parent_namePhotobase
  display_namePhotobase Paper
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id35
  parent_id8
  lft44
  rght53
  namePhotobase
  template_id22
  slugPhotobase-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titlePhotobase Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq22
  modified2023-05-03
  12(array)
  id199
  parent_id35
  nameWet Strength
  heading
  lft51
  rght52
  primary_brand_id77
  brand_nameSihl
  slugWet-Strength-Photobase-Digital-Print-Media
  parent_namePhotobase
  display_namePhotobase Wet Strength
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id35
  parent_id8
  lft44
  rght53
  namePhotobase
  template_id22
  slugPhotobase-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titlePhotobase Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq22
  modified2023-05-03
  13(array)
  id51
  parent_id8
  nameWall
  heading
  lft76
  rght83
  primary_brand_id77
  brand_nameSihl
  slugWall-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Wall
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  14(array)
  id53
  parent_id51
  namePSA
  heading(null)
  lft77
  rght78
  primary_brand_id77
  brand_nameSihl
  slugDigital-Print-Media-Wall-PSA
  parent_nameWall
  display_nameWall PSA
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id51
  parent_id8
  lft76
  rght83
  nameWall
  template_id22
  slugWall-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleWall Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq37
  modified2023-05-03
  15(array)
  id55
  parent_id51
  nameWallpaper
  heading(null)
  lft81
  rght82
  primary_brand_id77
  brand_nameSihl
  slugDigital-Print-Media-Wall-Wallpaper
  parent_nameWall
  display_nameWall Wallpaper
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id51
  parent_id8
  lft76
  rght83
  nameWall
  template_id22
  slugWall-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleWall Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq37
  modified2023-05-03
  16(array)
  id143
  parent_id58
  name50/50 Outside Mount
  heading(null)
  lft92
  rght93
  primary_brand_id77
  brand_nameSihl
  slugDigital-Print-Media-Windows-Perforated-50-50-Outside-Mount
  parent_namePerforated
  display_namePerforated 50/50 Outside Mount
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id58
  parent_id52
  lft89
  rght104
  namePerforated
  template_id22
  slugPerforated-Windows-Digital-Print-Media
  slug_lockN
  publish_flagY
  heading
  meta_tag_titlePerforated Windows Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq44
  modified2023-05-03
  17(array)
  id69
  parent_id8
  namePresentation
  heading
  lft120
  rght121
  primary_brand_id77
  brand_nameSihl
  slugPresentation-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Presentation
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  18(array)
  id71
  parent_id8
  nameRollUp
  heading
  lft122
  rght123
  primary_brand_id77
  brand_nameSihl
  slugRollUp-Banner-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media RollUp
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  19(array)
  id224
  parent_id8
  namePOS
  heading
  lft138
  rght139
  primary_brand_id77
  brand_nameSihl
  slugPOS-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media POS
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  20(array)
  id181
  parent_id180
  namePrint
  heading
  lft330
  rght331
  primary_brand_id77
  brand_nameSihl
  slugPrint-Best-Sellers
  parent_nameBest Sellers
  display_nameBest Sellers Print
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id180
  parent_id(null)
  lft329
  rght336
  nameBest Sellers
  template_id22
  slugBest-Sellers
  slug_lockN
  publish_flagY
  heading
  meta_tag_title
  meta_tag_description
  product_id(null)
  seq160
  modified2023-05-03
- headingShop Sihl Categories
- brand_urlhttp://www.sihlinc.com/
- alt_textLink to Sihl Web Site
- isMobileN
- menu<div id="navigation"> <ul class="top-level"><li class= 'product' ><a href='/products/shop/'>Digital Print Media</a><ul class='sub-level'><li><a href='/categories/shop/Backlit-Digital-Print-Media'>Backlit</a><ul class='sub-level'><li><a href='/categories/shop/Backlit-Film-Digital-Print-Media'>Film</a></li><li><a href='/categories/shop/Digital-Print-Media-Backlit-Vinyl'>Vinyl</a></li></ul></li><li><a href='/categories/shop/Banner-Digital-Print-Media'>Banner</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Banner-1-Sided'>1-Sided</a></li><li><a href='/categories/shop/Digital-Print-Media-Banner-2-Sided'>2-Sided</a></li><li><a href='/categories/shop/Digital-Print-Media-Banner-Adhesive-Backed'>Adhesive Backed</a></li><li><a href='/categories/shop/Digital-Print-Media-Banner-RollUp'>RollUp</a></li><li><a href='/categories/shop/Mesh-Banner-Digital-Print-Media'>Mesh</a></li><li><a href='/categories/shop/Stands-Banner-Digital-Print-Media'>Stands</a></li></ul></li><li><a href='/categories/shop/Digital-Print-Media-CAD'>CAD</a></li><li><a href='/categories/shop/Canvas-Digital-Print-Media'>Canvas</a></li><li><a href='/categories/shop/Digital-Print-Media-Clear-Film'>Clear Film</a><ul class='sub-level'><li class= 'product' ><a href='/products/shop/STS-DTF-Clear-Film-Print-Media'>STS Direct to Film</a></li></ul></li><li><a href='/categories/shop/Digital-Print-Media-Dye-Sublimation-Paper'>Dye Sublimation Paper</a></li><li><a href='/categories/shop/Digital-Print-Media-Fabric'>Fabric</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Fabric-Printable'>Printable</a></li><li><a href='/categories/shop/Digital-Print-Media-Fabric-Dye-Sublimation'>Dye Sublimation</a></li></ul></li><li><a href='/categories/shop/Fine-Art-Digital-Print-Media'>Fine Art</a></li><li><a href='/categories/shop/Floor-Digital-Print-Media'>Floor</a></li><li><a href='/categories/shop/Digital-Print-Media-Magnetics'>Magnetics</a></li><li><a href='/categories/shop/Photobase-Digital-Print-Media'>Photobase</a><ul class='sub-level'><li><a href='/categories/shop/Dry-Lab-Photobase-Digital-Print-Media'>Dry Lab</a></li><li><a href='/categories/shop/Digital-Print-Media-Photobase-Adhesive-Backed'>Adhesive Backed</a></li><li><a href='/categories/shop/Digital-Print-Media-Photobase-Paper'>Paper</a></li></ul></li><li><a href='/categories/shop/Calendered-Vinyl-Digital-Print-Media'>Vinyl Calendered</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Clear'>Clear</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Translucent'>Translucent</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-White'>White</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Reflective'>Reflective</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Industrial'>Industrial 7-Year</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Air-Release'>Air Release</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Promotional'>Promotional 3-Year</a></li><li><a href='/categories/shop/Intermediate-Vinyl-Calendered-Digital-Print-Media'>Intermediate 5-Year</a></li><li><a href='/categories/shop/Promotional-3-Year-Air-Release-Vinyl-Calendered-Digital-Print-Media'>Promotional 3-Year Air Release </a></li><li><a href='/categories/shop/Intermediate-5-Year-Air-Release-Vinyl-Calendered-Digital-Print-Media'>Intermediate 5-Year Air Release</a></li></ul></li><li><a href='/categories/shop/Wall-Digital-Print-Media'>Wall</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Wall-PSA'>PSA</a></li><li><a href='/categories/shop/Digital-Print-Media-Wall-Wet-Strength-Paper'>Wet-Strength Paper</a></li><li><a href='/categories/shop/Digital-Print-Media-Wall-Wallpaper'>Wallpaper</a></li></ul></li><li><a href='/categories/shop/Windows-Digital-Print-Media'>Windows</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Windows-Cling'>Cling</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-PSA'>PSA</a></li><li><a href='/categories/shop/Perforated-Windows-Digital-Print-Media'>Perforated</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-60-40-Outside-Mount'>60/40 Outside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-50-50-Outside-Mount'>50/50 Outside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-60-40-Inside-Mount'>60/40 Inside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-80-20-Outside-Mount'>80/20 Outside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-65-35-Outside-Mount'>65/35 Outside Mount</a></li><li><a href='/categories/shop/70-30-Outside-Mount-Perforated-Windows-Digital-Print-Media'>70/30 Outside Mount</a></li><li><a href='/categories/shop/80-20-Inside-Mount-Perforated-Windows-Digital-Print-Media'>80/20 Inside Mount </a></li></ul></li><li><a href='/categories/shop/Printable-Etched-Windows-Digital-Print-Media'>Printable Etched</a></li></ul></li><li><a href='/categories/shop/Cast-Vinyl-Digital-Print-Media'>Vinyl Cast </a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-White'>White</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-Translucent'>Translucent</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-Vehicle-Wrap'> Vehicle Wrap</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-Air-Release'>Air Release</a></li><li><a href='/categories/shop/Reflective-Vinyl-Cast-Digital-Print-Media'>Reflective </a></li></ul></li><li><a href='/categories/shop/Presentation-Digital-Print-Media'>Presentation</a></li><li><a href='/categories/shop/RollUp-Banner-Digital-Print-Media'>RollUp</a></li><li><a href='/categories/shop/Heat-Transfer-Digital-Print-Media'>Heat Transfer</a><ul class='sub-level'><li><a href='/categories/shop/Print-Cut-Films-Heat-Transfer-Digital-Print-Media'>Print/Cut Films</a></li><li><a href='/categories/shop/Cut-Films-Heat-Transfer-Digital-Print-Media'>Cut Films</a></li><li><a href='/categories/shop/Transfer-Mask-Heat-Transfer-Digital-Print-Media'>Transfer Mask</a></li></ul></li><li><a href='/categories/shop/Proofing-Digital-Print-Media'>Proofing</a></li><li><a href='/categories/shop/Durables-Digital-Print-Media'>Durables</a></li><li><a href='/categories/shop/Styrene-Digital-Print-Media'>Styrene</a></li><li><a href='/categories/shop/POS-Digital-Print-Media'>POS</a></li></li></ul><li><a href='/categories/shop/Clearance'>Clearance</a><ul class='sub-level'></li></ul><li><a href='/categories/shop/Graphic-Sign'>Graphic/Sign</a><ul class='sub-level'><li><a href='/categories/shop/Graphic-Sign-Vinyl-Cutter-Blades'>Vinyl Cutter Blades</a><ul class='sub-level'><li><a href='/categories/shop/Graphic-Sign-Vinyl-Cutter-Blades-Roland'>Roland</a></li></ul></li><li><a href='/categories/shop/Graphic-Sign-Vinyl'>Sign Vinyl</a></li><li><a href='/categories/shop/Application-Tape-Graphic-Sign'>Application Tape</a></li></li></ul><li><a href='/categories/shop/Hardware'>Hardware</a><ul class='sub-level'><li><a href='/categories/shop/Hardware-Roland'>Roland</a><ul class='sub-level'><li><a href='/categories/shop/Resin-Roland'>Resin</a></li><li><a href='/categories/shop/Hardware-Roland-Print-Only'>Print Only</a></li><li><a href='/categories/shop/Hardware-Roland-Printer-Cutters'>Printer/Cutters</a></li><li><a href='/categories/shop/UV-Benchtop-Flatbed-Roland-Hardware'>UV Benchtop Flatbed</a></li><li><a href='/categories/shop/Hardware-Roland-UV-Printer-Cutters'>UV Printer/Cutters</a></li><li><a href='/categories/shop/Hardware-Roland-Vinyl-Cutters'>Vinyl Cutters</a></li><li><a href='/categories/shop/Hardware-Roland-Sublimation'>Sublimation</a></li><li><a href='/categories/shop/Hardware-Roland-Common-Replacement-Parts'>Replacement Parts</a></li><li><a href='/categories/shop/UV-Flatbed-Roland-Hardware'>UV Flatbed</a></li><li class= 'product' ><a href='/products/shop/Roland-DGA-XT-640S-DTG-Multi-Station-Direct-to-Garment-Printer'>Direct-to-Garment Printer</a></li></ul></li><li><a href='/categories/shop/Hardware-GFP-Graphic-Finish-Partners'>GFP (Graphic Finish Partners)</a></li><li><a href='/categories/shop/Vanguard-Digital-UV-Flatbed-Printer-Hardware'>Vanguard Digital UV Flatbed Printer</a></li></li></ul><li class= 'product' ><a href='/products/shop/'>Inks</a><ul class='sub-level'><li><a href='/categories/shop/Inks-Roland'>Roland</a><ul class='sub-level'><li><a href='/categories/shop/Garment-Roland-Inks'>Garment</a></li><li><a href='/categories/shop/Inks-Roland-Eco-UV'>Eco-UV</a></li><li><a href='/categories/shop/Inks-Roland-Eco-Sol-MAX'>Eco-Sol MAX</a></li><li><a href='/categories/shop/TrueVIS-Roland-Inks'>TrueVIS</a></li></ul></li><li><a href='/categories/shop/Inks-SPL-Brand'>SPL Brand</a><ul class='sub-level'><li><a href='/categories/shop/Inks-SPL-Brand-Roland'>Roland</a></li><li><a href='/categories/shop/Inks-SPL-Brand-Epson'>Epson</a></li><li><a href='/categories/shop/Inks-SPL-Brand-Canon'>Canon</a></li><li><a href='/categories/shop/Inks-SPL-Brand-Mutoh'>Mutoh</a></li><li><a href='/categories/shop/HP-SPL-Brand-Inks'>HP</a></li><li><a href='/categories/shop/Mimaki-SPL-Brand-Inks'>Mimaki</a></li><li><a href='/categories/shop/Oki-Data-SPL-Brand-Inks'>Oki Data</a></li></ul></li><li><a href='/categories/shop/Inks-Seiko-Okidata'>Seiko/Okidata</a></li><li><a href='/categories/shop/Inks-Canon'>Canon</a></li><li><a href='/categories/shop/Inks-Epson'>Epson</a><ul class='sub-level'><li><a href='/categories/shop/Inks-Epson-Epson-OEM'>Epson OEM</a></li><li><a href='/categories/shop/Inks-Epson-SPL-Brand'>SPL Brand</a></li></ul></li><li><a href='/categories/shop/Inks-UV-Adhesion-Promoters'>UV Adhesion Promoters</a></li><li><a href='/categories/shop/Vanguard-Digital-Inks'>Vanguard Digital</a></li><li><a href='/categories/shop/HP-Inks'>HP</a><ul class='sub-level'></ul></li><li><a href='/categories/shop/STS-Direct-to-Film-Supplies'>STS Direct to Film Supplies</a></li></li></ul><li><a href='/categories/shop/Lamination'>Lamination</a><ul class='sub-level'><li><a href='/categories/shop/Lamination-PSA'>PSA</a><ul class='sub-level'><li><a href='/categories/shop/Lamination-PSA-Foor'>Floor</a></li><li><a href='/categories/shop/Lamination-PSA-Cast'>Cast</a></li><li><a href='/categories/shop/Lamination-PSA-Calendered'>Calendered</a></li><li><a href='/categories/shop/Lamination-PSA-Polycarbonate'>Polycarbonate </a></li><li><a href='/categories/shop/Lamination-PSA-Speciality'>Speciality</a></li></ul></li><li class= 'product' ><a href='/products/shop/Kraft-Paper'>Kraft Paper</a></li><li><a href='/categories/shop/Thermal-Lamination-Supplies'>Thermal</a></li></li></ul><li><a href='/categories/shop/Mounting-Supplies'>Mounting</a><ul class='sub-level'><li><a href='/categories/shop/PSA-Mounting'>PSA</a><ul class='sub-level'><li><a href='/categories/shop/Mounting-PSA-Clear'>Clear</a></li><li><a href='/categories/shop/Mounting-PSA-White'>White</a></li><li><a href='/categories/shop/Mounting-PSA-Window'>Window</a></li></ul></li><li><a href='/categories/shop/Heat-Activated-Backing-Films-Mounting'>Heat-Activated Backing Films</a></li><li class= 'product' ><a href='/products/shop/Kraft-Paper'>Kraft Paper</a></li></li></ul><li><a href='/categories/shop/Shop-Tools-Supplies'>Shop Tools & Supplies</a><ul class='sub-level'><li><a href='/categories/shop/Shop-Tools-Supplies-Safety-Rulers'>Safety Rulers</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-Media-Racks'>Media Racks</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-Grommet-Press'>Grommet Press</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-UV-Adhesion-Promoters'>UV Adhesion Promoters</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-Grommets'>Grommets</a></li><li><a href='/categories/shop/Squeegees-Shop-Tools-Supplies'>Squeegees</a></li><li><a href='/categories/shop/Cutting-Tools-and-Supplies-Shop-Tools-Supplies'>Cutting Tools and Supplies</a></li><li><a href='/categories/shop/Weeding-Tools-Shop-Tools-Supplies'>Weeding Tools</a></li></li></ul><li><a href='/categories/shop/Heat-Transfer-Films'>Heat Transfer Films</a><ul class='sub-level'><li><a href='/categories/shop/Print-Cut-Films-Heat-Transfer-Films'>Print/Cut Films</a></li><li><a href='/categories/shop/Cut-Films-Heat-Transfer-Films'>Cut Films</a></li><li><a href='/categories/shop/Transfer-Mask-Heat-Transfer-Films'>Transfer Mask </a></li></li></ul><li><a href='/categories/shop/Sign-Vinyl'>Sign Vinyl</a><ul class='sub-level'><li><a href='/categories/shop/Premium-Sign-Vinyl'>Premium </a></li><li><a href='/categories/shop/Intermediate-Sign-Vinyl'>Intermediate </a></li><li><a href='/categories/shop/Decorative-Sign-Vinyl'>Decorative </a></li><li><a href='/categories/shop/Specialty-Sign-Vinyl'>Specialty</a></li><li><a href='/categories/shop/Reflective-Sign-Vinyl'>Reflective </a></li><li><a href='/categories/shop/Application-Tape-Sign-Vinyl'>Application Tape</a></li></li></ul><li><a href='/categories/shop/Best-Sellers'>Best Sellers</a><ul class='sub-level'><li><a href='/categories/shop/Print-Best-Sellers'>Print</a></li><li><a href='/categories/shop/Protection-Best-Sellers'>Protection</a></li><li><a href='/categories/shop/Mounting-Best-Sellers'>Mounting</a></li></li></ul><li><a href='/categories/shop/New-Products'>New Products</a><ul class='sub-level'></li></ul></ul></div>
- $request->data(empty)
- $this->validationErrors(array)
  UserSetting(empty)
  User(empty)
  UserGroup(empty)
  UserActivity(empty)
  Brand(empty)
  Category(empty)
  BrandsProduct(empty)
  Product(empty)
  ParentCategory(empty)
  CategoriesProduct(empty)
  InkType(empty)
- Loaded Helpers(array)
  0Form
  1Html
  2Session
  3Js
  4UserAuth
  5Image
  6Number
  7SimpleGraph
  8DebugTimer
  9Toolbar
  10Flash
  11HtmlToolbar
====

Time	Message
2025-12-05 20:59:40	Data AppController:
2025-12-05 20:59:41	layout_default default.ctp:
2025-12-05 20:59:41	Data default_page:

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	5.5.38
Path	/sbin:/usr/sbin:/bin:/usr/bin
Pp Custom Php Ini	/var/www/vhosts/system/dpgtest.schillers.com/etc/php.ini
Pp Custom Php Cgi Index	plesk-php55-fastcgi
Http Connection	close
Script Name	/app/webroot/index.php
Request Uri	/brands/shop_categories_by_brand/Sihl
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/brands/shop_categories_by_brand/Sihl
Remote Port	1817
Script Filename	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/webroot/index.php
Server Admin	root@localhost
Document Root	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com
Remote Addr	216.73.216.151
Server Port	443
Server Addr	74.208.101.187
Server Name	dpgtest.schillers.com
Server Software	Apache
Server Signature	<address>Apache Server at dpgtest.schillers.com Port 443</address>
Http Host	dpgtest.schillers.com
Http Accept Encoding	gzip, br, zstd, deflate
Http Cookie	CAKEPHP=fs4olje0ukqlitmi1df1sb08m3
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Ssl Tls Sni	dpgtest.schillers.com
Https	on
Unique Id	aTOcHErQSlAAAHQcwA0AAACl
Redirect Status	200
Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Https	on
Redirect Unique Id	aTOcHErQSlAAAHQcwA0AAACl
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Redirect Https	on
Redirect Redirect Unique Id	aTOcHErQSlAAAHQcwA0AAACl
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1764989980.4566
Request Time	1764989980

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/lib
- 2/opt/plesk/php/5.5/share/pear
- 3-> /var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  1CORE/Model/Behavior/TreeBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/FlashComponent.php
  2CORE/Controller/Component/RequestHandlerComponent.php
  3CORE/Controller/Component/PaginatorComponent.php
  4CORE/Controller/Component/CookieComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/dpgComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/BrandsController.php
  1APP/Controller/AppController.php
  2APP/Controller/AccountsController.php
  3APP/Controller/AssetsController.php
  4APP/Controller/CartsController.php
  5APP/Controller/CatalogsController.php
  6APP/Controller/CategoriesController.php
  7APP/Controller/CategoriesProductsController.php
  8APP/Controller/ColorSelectorItemsController.php
  9APP/Controller/ColorSelectorsController.php
  10APP/Controller/CompaniesController.php
  11APP/Controller/ConfigurationsController.php
  12APP/Controller/Cp1SpecialPricesController.php
  13APP/Controller/DocsController.php
  14APP/Controller/DpgAssetsController.php
  15APP/Controller/Ec1SeoRedirectLogsController.php
  16APP/Controller/Ec1SeoRedirectsController.php
  17APP/Controller/ExportsController.php
  18APP/Controller/FreightCodesController.php
  19APP/Controller/GroupsController.php
  20APP/Controller/ImportsController.php
  21APP/Controller/InkProductsController.php
  22APP/Controller/InkTypesController.php
  23APP/Controller/ItemHistoriesController.php
  24APP/Controller/ItemsController.php
  25APP/Controller/KitsController.php
  26APP/Controller/M1AssetTypesController.php
  27APP/Controller/M1AssetsController.php
  28APP/Controller/M1CompaniesController.php
  29APP/Controller/M1CompanyAssetsController.php
  30APP/Controller/MarketingsController.php
  31APP/Controller/OrderLinesController.php
  32APP/Controller/OrdersController.php
  33APP/Controller/PagesController.php
  34APP/Controller/PaymentTermsController.php
  35APP/Controller/PhotosController.php
  36APP/Controller/ProductSideBarsController.php
  37APP/Controller/ProductsController.php
  38APP/Controller/RegistrationsController.php
  39APP/Controller/SeeAlsosController.php
  40APP/Controller/SeoRedirectsController.php
  41APP/Controller/ShippingHeadersController.php
  42APP/Controller/ShippingRatesController.php
  43APP/Controller/SitemapsController.php
  44APP/Controller/SlidersController.php
  45APP/Controller/SpecificationDetailsController.php
  46APP/Controller/SpecificationsController.php
  47APP/Controller/SubGroupsController.php
  48APP/Controller/TemplatesController.php
  49APP/Controller/TestMethodsController.php
  50APP/Controller/UnitsController.php
  51APP/Controller/UtilitiesController.php
  52APP/Controller/VendorsController.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/Model/Brand.php
  2APP/Model/Category.php
  3APP/Model/BrandsProduct.php
  4APP/Model/Product.php
  5APP/Model/InkType.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/autoload.php
  2APP/Vendor/composer/autoload_real.php
  3APP/Vendor/composer/ClassLoader.php
  4APP/Vendor/composer/autoload_namespaces.php
  5APP/Vendor/composer/autoload_psr4.php
  6APP/Vendor/composer/autoload_classmap.php
  7APP/Vendor/composer/autoload_files.php
  8APP/Vendor/symfony/polyfill-mbstring/bootstrap.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Controller(array)
  0DebugKit/Controller/DebugKitAppController.php
  1DebugKit/Controller/ToolbarAccessController.php
  Usermgmt(array)
  Config(array)
  0Usermgmt/Config/bootstrap.php
  1Usermgmt/Config/routes.php
  Plugin(array)
  0Usermgmt/Lib/routes/SlugRoute.php
  Component(array)
  0Usermgmt/Controller/Component/UserAuthComponent.php
  1Usermgmt/Controller/Component/ControllerListComponent.php
  2Usermgmt/Controller/Component/SslComponent.php
  Model(array)
  0Usermgmt/Model/UserSetting.php
  1Usermgmt/Model/UserMgmtAppModel.php
  2Usermgmt/Model/User.php
  3Usermgmt/Model/UserGroup.php
  4Usermgmt/Model/UserActivity.php
  Controller(array)
  0Usermgmt/Controller/UserMgmtAppController.php
  1Usermgmt/Controller/AutocompleteController.php
  2Usermgmt/Controller/ContentsController.php
  3Usermgmt/Controller/UserBillTosController.php
  4Usermgmt/Controller/UserCompaniesController.php
  5Usermgmt/Controller/UserContactsController.php
  6Usermgmt/Controller/UserEmailSignaturesController.php
  7Usermgmt/Controller/UserEmailTemplatesController.php
  8Usermgmt/Controller/UserEmailsController.php
  9Usermgmt/Controller/UserGroupPermissionsController.php
  10Usermgmt/Controller/UserGroupsController.php
  11Usermgmt/Controller/UserSettingsController.php
  12Usermgmt/Controller/UserShipTosController.php
  13Usermgmt/Controller/UsersController.php
====

Shop Sihl Categories

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 414 ms Total Queries: 153 queries

Query Explain:

Memory

Timers

Logs

debug

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 414 ms
Total Queries: 153 queries