| 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 route: fr/business-insights/tag/[slug:tag] |
| Using master page: /templates/pages/child.php |
Page arguments: Array
(
[0] => /fr/business-insights/tag/facility-management
[tag] => facility-management
[1] => facility-management
) |
| [1] SELECT * FROM perch3_pages WHERE pagePath='/fr/business-insights/archives' 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='/fr/home' OR pageSortPath='/fr/home' LIMIT 1 |
| [5] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-001%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
| [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/fr/business-insights/archives' LIMIT 1 |
| [3] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-001-001-002', '000-001-001', '000-001', '000') ORDER BY pageTreePosition DESC |
| [5] Using template: /templates/navigation/banner-navigation_inc.html |
| [1] SELECT collectionID, collectionTemplate FROM perch3_collections WHERE collectionKey='Tags' |
| [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='_order' WHERE (idx.collectionID=1) AND ((idx.indexKey='tag_slug' AND idx.indexValue='facility-management')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC |
| [1] Using template: /templates/content/documents/tags_schema.html |
| [1] SELECT collectionID, collectionTemplate FROM perch3_collections WHERE collectionKey='Business Insight' |
| [2] 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') OR (idx.indexKey='postTags.tag_slug' AND idx.indexValue IN ('facility-management'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval HAVING count(*)=2 ORDER BY sortval DESC LIMIT 0, 8 |
| [2] Using template: /templates/content/business-insights/insights_post_in_list_fr.html |
| [1] SELECT * FROM perch3_collections WHERE collectionKey='Tags' LIMIT 1 |
| [2] 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_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=1 |
| [5] SELECT regionKey, regionHTML FROM perch3_content_regions
WHERE regionPage='/fr/business-insights/archives' OR regionPage='*' ORDER BY regionPage DESC |