Debug Message - Perch 3.1.1 |
[1] SELECT * FROM perch3_pages WHERE pagePath='/meet-the-team.php' LIMIT 1 |
Using template: /templates/pages/attributes/default.html |
Using sub-template: /templates/pages/attributes/seo.html |
[2] SELECT regionKey, regionHTML FROM perch3_content_regions
WHERE regionPage='/meet-the-team.php' OR regionPage='*' ORDER BY regionPage DESC |
Using template: /templates/search/main-job-search.html |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Team' AND (regionPage='/meet-the-team.php' OR regionPage='*') |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=8 AND idx.itemRev=193)) AND ((idx.indexKey='slug' AND idx.indexValue='gerry-lindup')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC LIMIT 0, 1 |
[1] Using template: /templates/content/team-item.html |
[27] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Job Listing' AND (regionPage LIKE '/jobs/%' OR regionPage='*') |
[6] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='j_ref' WHERE ((idx.regionID=286 AND idx.itemRev=1) OR (idx.regionID=283 AND idx.itemRev=0) OR (idx.regionID=288 AND idx.itemRev=1) OR (idx.regionID=289 AND idx.itemRev=1) OR (idx.regionID=290 AND idx.itemRev=1) OR (idx.regionID=292 AND idx.itemRev=1) OR (idx.regionID=280 AND idx.itemRev=1) OR (idx.regionID=264 AND idx.itemRev=1) OR (idx.regionID=277 AND idx.itemRev=3) OR (idx.regionID=276 AND idx.itemRev=1) OR (idx.regionID=255 AND idx.itemRev=2) OR (idx.regionID=278 AND idx.itemRev=1) OR (idx.regionID=262 AND idx.itemRev=2) OR (idx.regionID=261 AND idx.itemRev=1) OR (idx.regionID=275 AND idx.itemRev=2) OR (idx.regionID=253 AND idx.itemRev=5) OR (idx.regionID=273 AND idx.itemRev=1) OR (idx.regionID=203 AND idx.itemRev=2) OR (idx.regionID=291 AND idx.itemRev=1) OR (idx.regionID=285 AND idx.itemRev=2) OR (idx.regionID=274 AND idx.itemRev=3) OR (idx.regionID=279 AND idx.itemRev=2) OR (idx.regionID=267 AND idx.itemRev=1) OR (idx.regionID=257 AND idx.itemRev=2) OR (idx.regionID=204 AND idx.itemRev=2) OR (idx.regionID=281 AND idx.itemRev=1) OR (idx.regionID=287 AND idx.itemRev=1)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval DESC LIMIT 0, 6 |
[6] Using template: /templates/content/job-slide.html |
[2] SELECT * FROM perch3_categories ORDER BY catTreePosition ASC |