| Debug Message - Perch Runway 3.2 |
| [39] 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 page: /en/business-insights, so not using routes. |
| Using master page: /templates/pages/child.php |
| [1] SELECT * FROM perch3_pages WHERE pagePath='/en/business-insights' LIMIT 1 |
| Using template: /templates/pages/attributes/default.html |
| Using sub-template: /templates/pages/attributes/seo.html |
| [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/en/home' OR pageSortPath='/en/home' LIMIT 1 |
| [5] SELECT * FROM perch3_pages 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 perch3_pages WHERE pagePath='/en/business-insights' LIMIT 1 |
| [2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-002-001', '000-002', '000') ORDER BY pageTreePosition DESC |
| [5] Using template: /templates/navigation/banner-navigation_inc.html |
| [6] SELECT regionKey, regionHTML FROM perch3_content_regions
WHERE regionPage='/en/business-insights' OR regionPage='*' ORDER BY regionPage DESC |
| [1] SELECT collectionID, collectionTemplate FROM perch3_collections WHERE collectionKey='Business Insight' |
| [1] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx
JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='postDateTime' WHERE (idx.collectionID=3) AND ((idx.indexKey='is_hidden' AND idx.indexValue != 'hidden')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval DESC LIMIT 0, 1 |
| [1] Using template: /templates/content/business-insights/insight_post_en.html |
| [1] SELECT * FROM perch3_collections WHERE collectionKey='Personnes' LIMIT 1 |
| [1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=4
AND ci.itemRev=r.itemRev AND ci.itemID=14 |
| [1] SELECT * FROM perch3_collections WHERE collectionKey='Tags' LIMIT 1 |
| [1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=1
AND ci.itemRev=r.itemRev AND ci.itemID=2 |
| [1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=4
AND ci.itemRev=r.itemRev AND ci.itemID=14 |
| [1] SELECT * FROM perch3_categories ORDER BY catTreePosition ASC |
| [3] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx
JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='postDateTime' WHERE (idx.collectionID=3) AND ((idx.indexKey='is_hidden' AND idx.indexValue != 'hidden')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval DESC LIMIT 0, 8 |
| [3] Using template: /templates/content/business-insights/insights_recent_post_in_list_en.html |
| [1] SELECT * FROM perch3_collections WHERE collectionKey='Tags' LIMIT 1 |
| [1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=1
AND ci.itemRev=r.itemRev AND ci.itemID=2 |
| [1] SELECT * FROM perch3_categories ORDER BY catTreePosition ASC |
| [1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=1
AND ci.itemRev=r.itemRev AND ci.itemID IN (1, 2) ORDER BY r.itemOrder ASC |
| [1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=1
AND ci.itemRev=r.itemRev AND ci.itemID=1 |
| [4] SELECT catID, catPath FROM perch3_categories |