| 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/documents, so not using routes. |
| Using master page: /templates/pages/child.php |
| [1] SELECT * FROM perch3_pages WHERE pagePath='/en/documents' 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/documents' LIMIT 1 |
| [2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-002-006', '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/documents' OR regionPage='*' ORDER BY regionPage DESC |
| [1] SELECT collectionID, collectionTemplate FROM perch3_collections WHERE collectionKey='Documents' |
| [6] 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='_order' WHERE (idx.collectionID=2) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC |
| [6] Using template: /templates/content/documents/librairie_grid.html |