This is the brand Page

Category m3-floodtec

Sub Category

Sub Sub Category

Sub Sub Sub Category

Breadcrumb

m3-floodtec /

Categories

Categories Test

Category Content:

Full cat Path: products/m3-floodtec/

Current Cat: m3-floodtec

Products in this category

Sub Categories

m3-floodtec,,,

All other products

Debug Message - Perch Runway 3.1.7
[99] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched route: shop/brands/[slug:brand]
Using master page: /templates/pages/shop/brands/brands.php
Page arguments: 
Array
(
    [0] => /shop/brands/m3-floodtec
    [brand] => m3-floodtec
    [1] => m3-floodtec
)
[1] SELECT * FROM perch3_pages WHERE pagePath='/shop/brands' LIMIT 1
[55] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1832060
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1832060
[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2025-09-16 12:10:00' AND saleTo>'2025-09-16 12:10:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
Using template: /templates/pages/attributes/default.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[5] SELECT main.* FROM perch3_categories main WHERE 1=1 AND setID=1 ORDER BY catTreePosition ASC
[5] Template file not found: /home/m3floodtec/webapps/m3floodtec-com/kpanel/templates/categories/products/product_categories_breadcrumb.html
[10] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/brands' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-001', '000-012', '000') ORDER BY pageTreePosition DESC
[10] Using template: /templates/navigation/item.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[5] SELECT main.* FROM perch3_categories main WHERE 1=1 AND setID=1 ORDER BY catTreePosition ASC
[5] Using template: /templates/categories/products/product_categories.html
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='products/m3-floodtec/') ORDER BY catTreePosition ASC
Using template: /templates/categories/category.html
[0] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/m3-floodtec/%' OR idx.indexKey='_category' AND idx.indexValue='products/m3-floodtec/'))
[nil] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' AND idx.itemID IN (NULL) WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
Using template: /templates/shop/products/views/product_list_categorised.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
Filtering query
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath REGEXP '[[:<:]]m3-floodtec[[:>:]]') AND setID=1 ORDER BY catTreePosition ASC
Using template: /templates/categories/products/product_categories.html
[0] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/m3-floodtec/%' OR idx.indexKey='_category' AND idx.indexValue='products/m3-floodtec/'))
[nil] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' AND idx.itemID IN (NULL) WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
Using template: /templates/shop/products/views/product_list.html
[1] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_brands main ON idx.itemID=main.brandID AND idx.itemKey='brandID' AND ((idx.indexKey='status' AND idx.indexValue='1')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_brands main ON idx.itemID=main.brandID AND idx.itemKey='brandID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='brandID' AND idx2.indexKey='title' AND idx.itemID IN ('1') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, brandID ) as tbl WHERE (brandDeleted IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[1] Using template: /templates/shop/brands/list.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[5] SELECT main.* FROM perch3_categories main WHERE 1=1 AND setID=1 ORDER BY catTreePosition ASC
[5] Using template: /templates/categories/products/product_categories.html
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[7] SELECT main.* FROM perch3_categories main WHERE 1=1 ORDER BY catTreePosition ASC
[7] Using template: /templates/categories/category.html
Request time: 0.022
Process time: 0.0216
Memory: 0.8712