Archive of: Michael Blencowe

Debug Message - Perch Runway 3.2
[957] 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
Matched route: news/category/[slug:cat]
Server address: 3.238.121.7
Using master page: /templates/pages/blog/archive.php
Page arguments:
Array
(
    [0] => /news/category/michael-blencowe
    [cat] => michael-blencowe
    [1] => michael-blencowe
)
[1] SELECT * FROM swt_pages_staging WHERE pagePath='/news/archive' LIMIT 1
[75] SELECT DISTINCT settingID, settingValue FROM swt_settings WHERE userID=0
[1] SELECT locationID FROM swt_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
INSERT INTO swt_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
[1] SELECT * FROM swt_shop_cart WHERE cartID=2186009
[1] SELECT * FROM swt_shop_cart WHERE cartID=2186009
[nil] SELECT * FROM swt_shop_sales WHERE saleFrom<='2024-07-16 06:51:00' AND saleTo>'2024-07-16 06:51:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
[250] SELECT country, countryID FROM swt_shop_countries WHERE countryActive=1 ORDER BY country ASC
Using template: /templates/pages/attributes/seo.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM swt_content_regions WHERE regionKey='Banner image' AND (regionPage='/news/archive' OR regionPage='*')
[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
[85] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/news/archive' LIMIT 1
[2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/ps_nav_template.html
[6] Using template: /templates/navigation/ps_nav_template_children.html
[6] Using template: /templates/navigation/ps_nav_template_children.html
[29] Using template: /templates/navigation/ps_nav_template_children.html
[9] Using template: /templates/navigation/ps_nav_template_children.html
[3] Using template: /templates/navigation/ps_nav_template_children.html
[7] Using template: /templates/navigation/ps_nav_template_children.html
[9] Using template: /templates/navigation/ps_nav_template_children.html
[1] SELECT setID FROM swt_category_sets WHERE setSlug='blog' LIMIT 1
[1] SELECT main.* FROM swt_categories main WHERE 1=1 AND (catSlug='michael-blencowe') AND setID=2 ORDER BY catTreePosition ASC
Using template: /templates/categories/category.html
[1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/news/archive' OR pageSortPath='/news/archive' LIMIT 1
[1] SELECT * FROM swt_pages_staging WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition
[1] Using template: /templates/navigation/breadcrumbs.html
[187] 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/author/michael-blencowe%' OR idx.indexKey='_category' AND idx.indexValue='blog/author/michael-blencowe'))
[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 ('327', '457', '503', '536', '597', '623', '643', '302', '906', '964', '982', '1017', '1020', '1042', '1052', '1053', '1054', '1071', '1072', '1075', '1078', '1101', '1110', '1116', '1117', '1124', '1158', '1168', '1169', '1178', '1189', '1210', '1220', '1230', '1336', '1341', '1350', '1358', '1365', '1368', '1444', '1462', '1488', '1534', '1543', '1544', '1146', '922', '1583', '1608', '1686', '1711', '1731', '1750', '1799', '1819', '1841', '1863', '1935', '1983', '2002', '2003', '2004', '2005', '2006', '2007', '2012', '2013', '2014', '2018', '2024', '2026', '2027', '2030', '2034', '2036', '2039', '2043', '2044', '2047', '2051', '2054', '2057', '2065', '2067', '2059', '2066', '2068', '2071', '2075', '2074', '2077', '2084', '2088', '2090', '2092', '2097', '2095', '2100', '2101', '2105', '2108', '2113', '2116', '2121', '2123', '2124', '2128', '2133', '2134', '2136', '2141', '2142', '2143', '2147', '2152', '2150', '2155', '2156', '2157', '2166', '2167', '2172', '2176', '2179', '2184', '2183', '2186', '2187', '2188', '2189', '2190', '2191', '2192', '2193', '2194', '2197', '2195', '2201', '2204', '2208', '2207', '2210', '2212', '2214', '2215', '2218', '2221', '2220', '2219', '2225', '2227', '2232', '2233', '2235', '2237', '2236', '2238', '2275', '2286', '2298', '2299', '2312', '2322', '2323', '2333', '2356', '2358', '2359', '2364', '2370', '2379', '2392', '2393', '2413', '2414', '2460', '2487', '2532', '2550', '2560', '2576', '2601', '2667', '2679', '2389', '3032') 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<='2024-07-16 06:51:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 24, 12
[1] SELECT FOUND_ROWS() AS `count`
Fetching from cache: perch_blog_post_categories3f464058fb372bc51bfa4d2be87bd4ed
[1] SELECT * FROM swt_blog_posts WHERE postID=2322 AND postStatus='Published' AND postDateTime<='2024-07-16 06:51:00'
[13] SELECT * FROM swt_blog_sections ORDER BY sectionTitle ASC
[1] SELECT * FROM swt_blogs ORDER BY blogTitle ASC
[1] SELECT * FROM swt_categories WHERE catID=33 LIMIT 1
[1] Using template: /templates/blog/category.html
Caching: perch_blog_post_categories3f464058fb372bc51bfa4d2be87bd4ed
Fetching from cache: perch_blog_post_categoriesb89a460daafe2a657962f21359448d43
[1] SELECT * FROM swt_blog_posts WHERE postID=2299 AND postStatus='Published' AND postDateTime<='2024-07-16 06:51:00'
[1] SELECT * FROM swt_categories WHERE catID=33 LIMIT 1
[1] Using template: /templates/blog/category.html
Caching: perch_blog_post_categoriesb89a460daafe2a657962f21359448d43
Fetching from cache: perch_blog_post_categories449a797e0220660e492d8d6df7b16c24
Fetching from cache: perch_blog_post_categories3d141cdf66dbd50936fd44d7fa5c71e2
Fetching from cache: perch_blog_post_categories5073303155f36973c64f5328ae065f87
[1] SELECT * FROM swt_blog_posts WHERE postID=2275 AND postStatus='Published' AND postDateTime<='2024-07-16 06:51:00'
[1] SELECT * FROM swt_categories WHERE catID=33 LIMIT 1
[1] Using template: /templates/blog/category.html
Caching: perch_blog_post_categories5073303155f36973c64f5328ae065f87
Fetching from cache: perch_blog_post_categoriesc7fd21a9218b976a367a7cda79b28747
[1] SELECT * FROM swt_blog_posts WHERE postID=2238 AND postStatus='Published' AND postDateTime<='2024-07-16 06:51:00'
[1] SELECT * FROM swt_categories WHERE catID=33 LIMIT 1
[1] Using template: /templates/blog/category.html
Caching: perch_blog_post_categoriesc7fd21a9218b976a367a7cda79b28747
Fetching from cache: perch_blog_post_categories560ceb686b93b61cc2139d18b9ecbb1e
[1] SELECT * FROM swt_blog_posts WHERE postID=2237 AND postStatus='Published' AND postDateTime<='2024-07-16 06:51:00'
[1] SELECT * FROM swt_categories WHERE catID=33 LIMIT 1
[1] Using template: /templates/blog/category.html
Caching: perch_blog_post_categories560ceb686b93b61cc2139d18b9ecbb1e
Fetching from cache: perch_blog_post_categories471d5930154aee155f6417517c803ea3
[1] SELECT * FROM swt_blog_posts WHERE postID=2236 AND postStatus='Published' AND postDateTime<='2024-07-16 06:51:00'
[1] SELECT * FROM swt_categories WHERE catID=33 LIMIT 1
[1] Using template: /templates/blog/category.html
Caching: perch_blog_post_categories471d5930154aee155f6417517c803ea3
Fetching from cache: perch_blog_post_categoriesbc3de31ea0577eb90adf9fe806a5f4a7
[1] SELECT * FROM swt_blog_posts WHERE postID=2235 AND postStatus='Published' AND postDateTime<='2024-07-16 06:51:00'
[1] SELECT * FROM swt_categories WHERE catID=33 LIMIT 1
[1] Using template: /templates/blog/category.html
Caching: perch_blog_post_categoriesbc3de31ea0577eb90adf9fe806a5f4a7
Fetching from cache: perch_blog_post_categories56a04659e5f933b73c11915e71f8e336
[1] SELECT * FROM swt_blog_posts WHERE postID=2233 AND postStatus='Published' AND postDateTime<='2024-07-16 06:51:00'
[1] SELECT * FROM swt_categories WHERE catID=33 LIMIT 1
[1] Using template: /templates/blog/category.html
Caching: perch_blog_post_categories56a04659e5f933b73c11915e71f8e336
Fetching from cache: perch_blog_post_categories4bf7e33545d86a11a440aa5d09d6d8bf
[1] SELECT * FROM swt_blog_posts WHERE postID=2232 AND postStatus='Published' AND postDateTime<='2024-07-16 06:51:00'
[1] SELECT * FROM swt_categories WHERE catID=33 LIMIT 1
[1] Using template: /templates/blog/category.html
Caching: perch_blog_post_categories4bf7e33545d86a11a440aa5d09d6d8bf
Fetching from cache: perch_blog_post_categories8d3aa2d1351f917adf9aff257d1835fd
[1] SELECT * FROM swt_blog_posts WHERE postID=2227 AND postStatus='Published' AND postDateTime<='2024-07-16 06:51:00'
[1] SELECT * FROM swt_categories WHERE catID=33 LIMIT 1
[1] Using template: /templates/blog/category.html
Caching: perch_blog_post_categories8d3aa2d1351f917adf9aff257d1835fd
[12] Using template: /templates/blog/post_excerpt.html
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/what-we-do' OR pageSortPath='/what-we-do' LIMIT 1
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-002' LIMIT 1
[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
[1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/news/archive' LIMIT 1
[2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/footer-nav.html
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/make-a-difference' OR pageSortPath='/make-a-difference' LIMIT 1
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-005' LIMIT 1
[38] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005%' ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/news/archive' LIMIT 1
[2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
[9] Using template: /templates/navigation/footer-nav.html
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/visit' OR pageSortPath='/visit' LIMIT 1
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-004' LIMIT 1
[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
[1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/news/archive' LIMIT 1
[2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
[29] Using template: /templates/navigation/footer-nav.html
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/make-a-difference' OR pageSortPath='/make-a-difference' LIMIT 1
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-005' LIMIT 1
[10] 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
[1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/news/archive' LIMIT 1
[2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
[9] Using template: /templates/navigation/footer-nav.html
Request time: 0.5349
Process time: 0.5348
Memory: 2.3632