Time Δ Debug Message - Perch Runway 3.2
1783468258.30430 [906] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM swt_pages_staging p LEFT JOIN swt_page_routes pr ON p.pageID=pr.pageID LEFT JOIN swt_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 swt_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
1783468258.32920.025Matched route: shop/category/[slug:cat]
1783468258.32940.0002Server address: 216.73.217.142
1783468258.32940Using master page: /templates/pages/shop/category.php
1783468258.32940Page arguments:
Array
(
    [0] => /shop/category/books
    [cat] => books
    [1] => books
)
1783468258.32970.0003 [1] SELECT * FROM swt_pages_staging WHERE pagePath='/shop/category' LIMIT 1
1783468258.33080.0011 [86] SELECT DISTINCT settingID, settingValue FROM swt_settings WHERE userID=0
1783468258.33240.0016 [1] SELECT * FROM swt_shop_cart WHERE cartID=22757078
1783468258.3330.0007 [1] SELECT * FROM swt_shop_cart WHERE cartID=22757078
1783468258.33350.0005 [nil] SELECT * FROM swt_shop_sales WHERE saleFrom<='2026-07-07 23:50:00' AND saleTo>'2026-07-07 23:50:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
1783468258.33450.001 [0] SELECT setID FROM swt_category_sets WHERE setSlug='' LIMIT 1
1783468258.33490.0005 [1] SELECT main.* FROM swt_categories main WHERE 1=1 AND (catPath='shop/books/') ORDER BY catTreePosition ASC
1783468258.33550.0006Using template: /templates/categories/category.html
1783468258.33570.0002 [250] SELECT country, countryID FROM swt_shop_countries WHERE countryActive=1 ORDER BY country ASC
1783468258.33690.0012Using template: /templates/pages/attributes/seo.html
1783468258.33720.0003 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM swt_content_regions WHERE regionKey='Banner image' AND (regionPage='/shop/category' OR regionPage='*')
1783468258.33790.0007 [nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM swt_content_index idx JOIN swt_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN swt_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=190 AND idx.itemRev=0)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
1783468258.33890.001 [82] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1783468258.34150.0027 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/category' LIMIT 1
1783468258.34210.0006 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-001', '000-010', '000') ORDER BY pageTreePosition DESC
1783468258.34470.0026Using template: /templates/navigation/ps_nav_template.html
1783468258.34480 [6] Using template: /templates/navigation/ps_nav_template_children.html
1783468258.34560.0008 [4] Using template: /templates/navigation/ps_nav_template_children.html
1783468258.34620.0006 [29] Using template: /templates/navigation/ps_nav_template_children.html
1783468258.3490.0028 [10] Using template: /templates/navigation/ps_nav_template_children.html
1783468258.35010.0011 [7] Using template: /templates/navigation/ps_nav_template_children.html
1783468258.35080.0007 [9] Using template: /templates/navigation/ps_nav_template_children.html
1783468258.35360.0028 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/category' OR pageSortPath='/shop/category' LIMIT 1
1783468258.35440.0008 [1] SELECT * FROM swt_pages_staging WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-010-001', '000-010', '000') ORDER BY pageTreePosition
1783468258.35660.0021 [1] Using template: /templates/navigation/breadcrumbs.html
1783468258.3570.0004 [42] SELECT DISTINCT idx.itemID FROM swt_shop_index idx JOIN swt_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'shop/books%' OR idx.indexKey='_category' AND idx.indexValue='shop/books'))
1783468258.3950.038 [27] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM swt_shop_index idx JOIN swt_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN swt_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' AND idx.itemID IN ('754', '1496', '712', '2332', '711', '1377', '1497', '3094', '3624', '2742', '3992', '2820', '2107', '3112', '3110', '2333', '2866', '3107', '3113', '3140', '3142', '3145', '3552', '4025', '785', '4676', '4666', '4675', '2331', '3095', '3141', '3623', '3989', '4026', '4178', '4223', '4667', '3990', '3991', '427', '4677', '4678') 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
1783468258.48190.0869 [27] Using template: /templates/shop/products/list.html
1783468258.4840.0021 [1] SELECT * FROM swt_shop_currencies WHERE currencyID=47 LIMIT 1
1783468258.49650.0125 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/what-we-do' OR pageSortPath='/what-we-do' LIMIT 1
1783468258.49740.0009 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-002' LIMIT 1
1783468258.50140.004 [7] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1783468258.50340.002 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/category' LIMIT 1
1783468258.5040.0005 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-001', '000-010', '000') ORDER BY pageTreePosition DESC
1783468258.50590.0019 [6] Using template: /templates/navigation/footer-nav.html
1783468258.50650.0006 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/make-a-difference' OR pageSortPath='/make-a-difference' LIMIT 1
1783468258.5070.0005 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-005' LIMIT 1
1783468258.50740.0004 [38] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005%' ORDER BY pageTreePosition ASC
1783468258.50980.0024 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/category' LIMIT 1
1783468258.51580.0061 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-001', '000-010', '000') ORDER BY pageTreePosition DESC
1783468258.51850.0026 [10] Using template: /templates/navigation/footer-nav.html
1783468258.52260.0041 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/visit' OR pageSortPath='/visit' LIMIT 1
1783468258.52320.0006 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-004' LIMIT 1
1783468258.52370.0004 [30] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-004%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1783468258.52660.0029 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/category' LIMIT 1
1783468258.52730.0007 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-001', '000-010', '000') ORDER BY pageTreePosition DESC
1783468258.54240.0151 [29] Using template: /templates/navigation/footer-nav.html
1783468258.54370.0013 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/make-a-difference' OR pageSortPath='/make-a-difference' LIMIT 1
1783468258.54450.0007 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-005' LIMIT 1
1783468258.54490.0004 [11] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1783468258.54840.0036 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/category' LIMIT 1
1783468258.54910.0007 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-001', '000-010', '000') ORDER BY pageTreePosition DESC
1783468258.55280.0037 [10] Using template: /templates/navigation/footer-nav.html
1783468258.55430.0015Request time: 0.2513
1783468258.55430Process time: 0.2511
1783468258.55430Memory: 2.853