Hereford & Worcestershire Chamber of Commerce

Site by Kingsford

Flood Checker

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/category/[slug:category]

Using master page: /templates/pages/shop/categories/categories.php

Page arguments:

Array
(
    [0] => /shop/category/products
    [category] => products
    [1] => products
)

[1] SELECT * FROM perch3_pages WHERE pagePath='/shop/category' 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=1825362

[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2025-09-14 02:46:00' AND saleTo>'2025-09-14 02:46:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC

[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1

[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='products') AND setID=1 ORDER BY catTreePosition ASC

Using template: /templates/categories/category_title.html

[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1

[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='') AND setID=1 ORDER BY catTreePosition ASC

Using template: /templates/categories/category_title.html

[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1

[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='') AND setID=1 ORDER BY catTreePosition ASC

Using template: /templates/categories/category_title.html

[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1

[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='') AND setID=1 ORDER BY catTreePosition ASC

Using template: /templates/categories/category_title.html

[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1

[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='products') AND setID=1 ORDER BY catTreePosition ASC

Using template: /templates/categories/category_title.html

[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1

[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='products') AND setID=1 ORDER BY catTreePosition ASC

Using template: /templates/categories/category_id.html

[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1

[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='products') AND setID=1 ORDER BY catTreePosition ASC

Using template: /templates/categories/category_depth.html

[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Contact Details' AND (regionPage LIKE '%' OR regionPage='*')

[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

[1] Using template: /templates/content/_contact_details/site_name.html

[1] Using template: /templates/content/_contact_details/site_description.html

[1] Using template: /templates/content/_contact_details/tel_only.html

Using template: /templates/pages/attributes/default.html

[1] Using template: /templates/content/_contact_details/og_image.html

Using template: /templates/pages/attributes/og_image.html

------------------------------ Calculating cart ------------------------------

[1] SELECT * FROM perch3_shop_cart WHERE cartID=1825362

[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1

[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1

[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1

[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=47 LIMIT 1

[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=1825362

Tax mode: exc

[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=1825362 ORDER BY itemID ASC

[1] Using template: /templates/content/_contact_details/contact_address_schema.html

[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='I am looking for menu' AND (regionPage='/shop/category' OR regionPage='*')

[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

[6] Using template: /templates/content/_homepage/looking_for_menu.html

[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC

[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/category' LIMIT 1

[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-002', '000-012', '000') ORDER BY pageTreePosition DESC

Using template: /templates/navigation/main_nav.html

[10] Using template: /templates/navigation/sub_nav.html

[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1

[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='products') AND setID=1 ORDER BY catTreePosition ASC

Using template: /templates/categories//products/product_category.html

Using template: /templates/shop/products/views/product_block.html

[1] SELECT * FROM perch3_categories WHERE catPath='products/products/' LIMIT 1

[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1

Filtering query

[2] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=0 AND catPath REGEXP '[[:<:]]products[[:>:]]') AND setID=1 ORDER BY catTreePosition ASC

[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1

[3] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=1) ORDER BY catTreePosition ASC

[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1

[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=5) ORDER BY catTreePosition ASC

Using template: /templates/categories/products/product_categories_list.html

[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1

[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=6) ORDER BY catTreePosition ASC

Using template: /templates/categories/products/product_categories_list.html

[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1

[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=7) ORDER BY catTreePosition ASC

Using template: /templates/categories/products/product_categories_list.html

[3] Using template: /templates/categories/products/product_categories_list.html

[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1

[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=2) ORDER BY catTreePosition ASC

Using template: /templates/categories/products/product_categories_list.html

[2] Using template: /templates/categories/products/product_categories_list.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 (catParentID=0 AND catPath NOT REGEXP '[[:<:]]products[[:>:]]') AND setID=1 ORDER BY catTreePosition ASC

Using template: /templates/categories/products/product_categories_shop.html

[1] Using template: /templates/content/_contact_details/site_name.html

[1] Using template: /templates/content/_contact_details/tel_only_formatted.html

Using template: /templates/pages/attributes/hide_enquiry.html

[13] Using template: /templates/content//_contact_details/accreditations.html

[1] Using template: /templates/content//_contact_details/tel_email.html

[1] Using template: /templates/content//_contact_details/address_only.html

[1] Using template: /templates/content//_contact_details/address_only_repeater_limited.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/category' LIMIT 1

[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-002', '000-012', '000') ORDER BY pageTreePosition DESC

[10] Using template: /templates/navigation/nav_lis_only.html

[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/foot-links' OR pageSortPath='/foot-links' LIMIT 1

[4] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-018%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC

[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/category' LIMIT 1

[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-002', '000-012', '000') ORDER BY pageTreePosition DESC

[4] Using template: /templates/navigation/nav_lis_only.html

[1] Using template: /templates/content//_contact_details/socials.html

[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

[6] Using template: /templates/content/_homepage/looking_for_menu.html

[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC

[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/category' LIMIT 1

[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-002', '000-012', '000') ORDER BY pageTreePosition DESC

Using template: /templates/navigation/main_nav.html

[10] Using template: /templates/navigation/sub_nav.html

[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

[6] Using template: /templates/content/_homepage/looking_for_menu.html

[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC

[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/category' LIMIT 1

[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-002', '000-012', '000') ORDER BY pageTreePosition DESC

Using template: /templates/navigation/main_nav.html

[10] Using template: /templates/navigation/sub_nav.html

Request time: 0.0327

Process time: 0.0322

Memory: 1.4029

Shop