Archive of: Volunteering

Time Δ Debug Message - Perch Runway 3.2
1782908888.54010 [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
1782908888.56730.0271Matched route: news/category/[slug:cat]
1782908888.56740.0002Server address: 216.73.217.103
1782908888.56750Using master page: /templates/pages/blog/archive.php
1782908888.56750Page arguments:
Array
(
    [0] => /news/category/volunteering
    [cat] => volunteering
    [1] => volunteering
)
1782908888.56780.0003 [1] SELECT * FROM swt_pages_staging WHERE pagePath='/news/archive' LIMIT 1
1782908888.56910.0012 [86] SELECT DISTINCT settingID, settingValue FROM swt_settings WHERE userID=0
1782908888.57110.002 [1] SELECT locationID FROM swt_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
1782908888.57190.0008INSERT INTO swt_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
1782908888.57410.0023 [1] SELECT * FROM swt_shop_cart WHERE cartID=22483014
1782908888.57480.0006 [1] SELECT * FROM swt_shop_cart WHERE cartID=22483014
1782908888.57550.0008 [nil] SELECT * FROM swt_shop_sales WHERE saleFrom<='2026-07-01 12:28:00' AND saleTo>'2026-07-01 12:28:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
1782908888.57710.0016 [250] SELECT country, countryID FROM swt_shop_countries WHERE countryActive=1 ORDER BY country ASC
1782908888.57850.0014Using template: /templates/pages/attributes/seo.html
1782908888.57910.0005 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM swt_content_regions WHERE regionKey='Banner image' AND (regionPage='/news/archive' OR regionPage='*')
1782908888.57990.0009 [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=103 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
1782908888.58140.0015 [82] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1782908888.58440.003 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/news/archive' LIMIT 1
1782908888.58510.0007 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
1782908888.58780.0027Using template: /templates/navigation/ps_nav_template.html
1782908888.58780.0001 [6] Using template: /templates/navigation/ps_nav_template_children.html
1782908888.58870.0009 [4] Using template: /templates/navigation/ps_nav_template_children.html
1782908888.58930.0005 [29] Using template: /templates/navigation/ps_nav_template_children.html
1782908888.59240.0031 [10] Using template: /templates/navigation/ps_nav_template_children.html
1782908888.59360.0012 [7] Using template: /templates/navigation/ps_nav_template_children.html
1782908888.59450.0009 [9] Using template: /templates/navigation/ps_nav_template_children.html
1782908888.59850.0041 [1] SELECT setID FROM swt_category_sets WHERE setSlug='blog' LIMIT 1
1782908888.59950.001 [1] SELECT main.* FROM swt_categories main WHERE 1=1 AND (catSlug='volunteering') AND setID=2 ORDER BY catTreePosition ASC
1782908888.60080.0012Using template: /templates/categories/category.html
1782908888.60090.0002 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/news/archive' OR pageSortPath='/news/archive' LIMIT 1
1782908888.60160.0006 [1] SELECT * FROM swt_pages_staging WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition
1782908888.60380.0022 [1] Using template: /templates/navigation/breadcrumbs.html
1782908888.60440.0006 [92] SELECT DISTINCT idx.itemID FROM swt_blog_index idx JOIN swt_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'blog/volunteering%' OR idx.indexKey='_category' AND idx.indexValue='blog/volunteering'))
1782908888.62080.0164 [12] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM swt_blog_index idx JOIN swt_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN swt_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' AND idx.itemID IN ('907', '910', '931', '954', '962', '980', '991', '994', '1067', '1069', '1200', '1278', '1329', '1342', '1399', '1415', '1416', '1417', '1423', '1459', '1476', '1481', '1648', '1662', '1726', '1783', '1872', '1877', '1904', '1951', '2553', '2587', '2773', '2840', '2890', '3009', '3019', '3069', '3089', '3122', '3196', '3201', '3202', '3246', '3247', '3250', '3249', '3275', '3372', '3370', '3373', '3402', '3418', '3437', '3458', '3466', '3469', '3505', '3568', '3597', '3601', '3628', '3641', '3669', '3693', '3713', '3712', '3716', '3721', '3748', '3778', '3869', '3872', '3881', '3891', '3909', '3946', '950', '1033', '1386', '1505', '2598', '1068', '1239', '1664', '2614', '2730', '3574', '3679', '3777', '3880', '3892') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2026-07-01 12:28:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 12
1782908888.67960.0588 [1] SELECT FOUND_ROWS() AS `count`
1782908888.68030.0007 [1] SELECT * FROM swt_blog_posts WHERE postID=3946 AND postStatus='Published' AND postDateTime<='2026-07-01 12:28:00'
1782908888.68120.0009 [13] SELECT * FROM swt_blog_sections ORDER BY sectionTitle ASC
1782908888.68220.001 [1] SELECT * FROM swt_blogs ORDER BY blogTitle ASC
1782908888.68340.0012 [1] SELECT * FROM swt_categories WHERE catID=36 LIMIT 1
1782908888.68390.0005 [1] SELECT * FROM swt_categories WHERE catID=47 LIMIT 1
1782908888.68440.0005 [1] SELECT * FROM swt_categories WHERE catID=222 LIMIT 1
1782908888.68520.0008 [3] Using template: /templates/blog/category.html
1782908888.68570.0005 [1] SELECT * FROM swt_blog_posts WHERE postID=3909 AND postStatus='Published' AND postDateTime<='2026-07-01 12:28:00'
1782908888.68680.0011 [1] SELECT * FROM swt_categories WHERE catID=47 LIMIT 1
1782908888.68750.0007 [1] SELECT * FROM swt_categories WHERE catID=50 LIMIT 1
1782908888.68870.0012 [2] Using template: /templates/blog/category.html
1782908888.68920.0005 [1] SELECT * FROM swt_blog_posts WHERE postID=3881 AND postStatus='Published' AND postDateTime<='2026-07-01 12:28:00'
1782908888.69050.0013 [1] SELECT * FROM swt_categories WHERE catID=195 LIMIT 1
1782908888.6910.0005 [1] SELECT * FROM swt_categories WHERE catID=79 LIMIT 1
1782908888.69150.0005 [1] SELECT * FROM swt_categories WHERE catID=47 LIMIT 1
1782908888.69210.0006 [3] Using template: /templates/blog/category.html
1782908888.69270.0006 [1] SELECT * FROM swt_blog_posts WHERE postID=3892 AND postStatus='Published' AND postDateTime<='2026-07-01 12:28:00'
1782908888.69350.0008 [1] SELECT * FROM swt_categories WHERE catID=95 LIMIT 1
1782908888.6940.0005 [1] SELECT * FROM swt_categories WHERE catID=39 LIMIT 1
1782908888.69450.0005 [2] Using template: /templates/blog/category.html
1782908888.69490.0004 [1] SELECT * FROM swt_blog_posts WHERE postID=3891 AND postStatus='Published' AND postDateTime<='2026-07-01 12:28:00'
1782908888.69570.0008 [1] SELECT * FROM swt_categories WHERE catID=195 LIMIT 1
1782908888.69620.0005 [1] SELECT * FROM swt_categories WHERE catID=47 LIMIT 1
1782908888.69690.0007 [2] Using template: /templates/blog/category.html
1782908888.69740.0005 [1] SELECT * FROM swt_blog_posts WHERE postID=3869 AND postStatus='Published' AND postDateTime<='2026-07-01 12:28:00'
1782908888.69820.0009 [1] SELECT * FROM swt_categories WHERE catID=195 LIMIT 1
1782908888.69870.0004 [1] SELECT * FROM swt_categories WHERE catID=79 LIMIT 1
1782908888.69920.0005 [1] SELECT * FROM swt_categories WHERE catID=47 LIMIT 1
1782908888.70.0007 [3] Using template: /templates/blog/category.html
1782908888.70050.0006 [1] SELECT * FROM swt_blog_posts WHERE postID=3880 AND postStatus='Published' AND postDateTime<='2026-07-01 12:28:00'
1782908888.70150.001 [1] SELECT * FROM swt_categories WHERE catID=36 LIMIT 1
1782908888.7020.0005 [1] SELECT * FROM swt_categories WHERE catID=39 LIMIT 1
1782908888.70270.0006 [1] SELECT * FROM swt_categories WHERE catID=226 LIMIT 1
1782908888.70330.0006 [3] Using template: /templates/blog/category.html
1782908888.70380.0005 [1] SELECT * FROM swt_blog_posts WHERE postID=3778 AND postStatus='Published' AND postDateTime<='2026-07-01 12:28:00'
1782908888.70460.0008 [1] SELECT * FROM swt_categories WHERE catID=251 LIMIT 1
1782908888.70510.0005 [1] SELECT * FROM swt_categories WHERE catID=70 LIMIT 1
1782908888.70560.0005 [1] SELECT * FROM swt_categories WHERE catID=47 LIMIT 1
1782908888.70610.0005 [3] Using template: /templates/blog/category.html
1782908888.70660.0005 [1] SELECT * FROM swt_blog_posts WHERE postID=3777 AND postStatus='Published' AND postDateTime<='2026-07-01 12:28:00'
1782908888.70740.0008 [1] SELECT * FROM swt_categories WHERE catID=39 LIMIT 1
1782908888.7080.0006 [1] Using template: /templates/blog/category.html
1782908888.70840.0003 [1] SELECT * FROM swt_blog_posts WHERE postID=3748 AND postStatus='Published' AND postDateTime<='2026-07-01 12:28:00'
1782908888.70930.0009 [1] SELECT * FROM swt_categories WHERE catID=271 LIMIT 1
1782908888.70980.0006 [1] SELECT * FROM swt_categories WHERE catID=51 LIMIT 1
1782908888.71040.0006 [1] SELECT * FROM swt_categories WHERE catID=47 LIMIT 1
1782908888.71080.0004 [1] SELECT * FROM swt_categories WHERE catID=222 LIMIT 1
1782908888.71130.0005 [4] Using template: /templates/blog/category.html
1782908888.7120.0007 [1] SELECT * FROM swt_blog_posts WHERE postID=3721 AND postStatus='Published' AND postDateTime<='2026-07-01 12:28:00'
1782908888.71270.0007 [1] SELECT * FROM swt_categories WHERE catID=267 LIMIT 1
1782908888.71330.0006 [1] SELECT * FROM swt_categories WHERE catID=47 LIMIT 1
1782908888.71390.0007 [2] Using template: /templates/blog/category.html
1782908888.71440.0005 [1] SELECT * FROM swt_blog_posts WHERE postID=3716 AND postStatus='Published' AND postDateTime<='2026-07-01 12:28:00'
1782908888.71520.0008 [1] SELECT * FROM swt_categories WHERE catID=251 LIMIT 1
1782908888.71570.0004 [1] SELECT * FROM swt_categories WHERE catID=70 LIMIT 1
1782908888.71620.0005 [1] SELECT * FROM swt_categories WHERE catID=47 LIMIT 1
1782908888.71680.0006 [3] Using template: /templates/blog/category.html
1782908888.71760.0008 [12] Using template: /templates/blog/post_excerpt.html
1782908888.73010.0124 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/what-we-do' OR pageSortPath='/what-we-do' LIMIT 1
1782908888.73140.0013 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-002' LIMIT 1
1782908888.73240.001 [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
1782908888.73460.0023 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/news/archive' LIMIT 1
1782908888.73530.0007 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
1782908888.73760.0023 [6] Using template: /templates/navigation/footer-nav.html
1782908888.73890.0013 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/make-a-difference' OR pageSortPath='/make-a-difference' LIMIT 1
1782908888.73970.0008 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-005' LIMIT 1
1782908888.74020.0005 [38] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005%' ORDER BY pageTreePosition ASC
1782908888.74280.0026 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/news/archive' LIMIT 1
1782908888.74350.0008 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
1782908888.74570.0022 [10] Using template: /templates/navigation/footer-nav.html
1782908888.74950.0038 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/visit' OR pageSortPath='/visit' LIMIT 1
1782908888.75040.0008 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-004' LIMIT 1
1782908888.7510.0006 [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
1782908888.75350.0025 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/news/archive' LIMIT 1
1782908888.75420.0007 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
1782908888.75630.0021 [29] Using template: /templates/navigation/footer-nav.html
1782908888.75960.0033 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/make-a-difference' OR pageSortPath='/make-a-difference' LIMIT 1
1782908888.76040.0008 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-005' LIMIT 1
1782908888.76090.0005 [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
1782908888.76310.0022 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/news/archive' LIMIT 1
1782908888.76370.0006 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
1782908888.76570.002 [10] Using template: /templates/navigation/footer-nav.html
1782908888.76770.002Request time: 0.2305
1782908888.76770Process time: 0.2303
1782908888.76770Memory: 2.267