| Time | Δ | Debug Message - Perch 3.1.1 |
| 0.0291 | 0 | [57] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0 |
| 0.0332 | 0.0041 | [1] SELECT * FROM perch3_pages WHERE pagePath='/about/faq.php' LIMIT 1 |
| 0.0347 | 0.0015 | Using template: /templates/pages/attributes/default.html |
| 0.0348 | 0.0001 | Using sub-template: /templates/pages/attributes/seo.html |
| 0.0348 | 0 | Using sub-template: /templates/pages/attributes/facebook.html |
| 0.0355 | 0.0007 | [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/tours' OR pageSortPath='/tours' LIMIT 1 |
| 0.0356 | 0.0001 | [6] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-001%' ORDER BY pageTreePosition ASC |
| 0.0357 | 0.0001 | [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/about/faq.php' LIMIT 1 |
| 0.036 | 0.0003 | [2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-002-003', '000-002', '000') ORDER BY pageTreePosition DESC |
| 0.0362 | 0.0002 | Using template: /templates/navigation/level1.html |
| 0.0363 | 0 | [1] Using template: /templates/navigation/level2.html |
| 0.0367 | 0.0004 | [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/about' OR pageSortPath='/about' LIMIT 1 |
| 0.0368 | 0.0001 | [5] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002%' ORDER BY pageTreePosition ASC |
| 0.0369 | 0.0001 | [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/about/faq.php' LIMIT 1 |
| 0.0369 | 0.0001 | [2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-002-003', '000-002', '000') ORDER BY pageTreePosition DESC |
| 0.037 | 0.0001 | Using template: /templates/navigation/level1.html |
| 0.037 | 0 | [1] Using template: /templates/navigation/level2.html |
| 0.0374 | 0.0004 | [1] SELECT groupID FROM perch3_navigation WHERE groupSlug='right-navigation' LIMIT 1 |
| 0.0374 | 0.0001 | [3] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes
FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=2 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC |
| 0.0375 | 0.0001 | [0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=2 AND p.pagePath='/about/faq.php' LIMIT 1 |
| 0.0378 | 0.0003 | [3] Using template: /templates/navigation/level1.html |
| 0.0383 | 0.0005 | [4] SELECT regionKey, regionHTML FROM perch3_content_regions
WHERE regionPage='/about/faq.php' OR regionPage='*' ORDER BY regionPage DESC |
| 0.0389 | 0.0006 | [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Header' AND (regionPage='/about/faq.php' OR regionPage='*') |
| 0.0391 | 0.0002 | [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=15 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| 0.045 | 0.0058 | [1] Using template: /templates/content/section-hero.html |
| 0.0454 | 0.0004 | [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='FAQ' AND (regionPage='/about/faq.php' OR regionPage='*') |
| 0.0456 | 0.0002 | [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='_order' WHERE ((idx.regionID=17 AND idx.itemRev=26)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| 0.0497 | 0.0041 | [6] Using template: /templates/content/faq.html |
| 0.0509 | 0.0011 | [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Promotions' AND (regionPage='/generic.php' OR regionPage='*') |
| 0.0509 | 0.0001 | [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=41 AND idx.itemRev=32)) AND ((idx.indexKey='type' AND idx.indexValue='default')) 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 |
| 0.051 | 0.0001 | [1] Using template: /templates/content/promotion.html |
| 0.0515 | 0.0005 | [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Company and contact details' AND (regionPage='/contact.php' OR regionPage='*') |
| 0.0516 | 0.0001 | [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=19)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| 0.0517 | 0.0001 | [1] Using template: /templates/content/_company-info.html |
| 0.052 | 0.0003 | [1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer' LIMIT 1 |
| 0.052 | 0.0001 | [4] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes
FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=4 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC |
| 0.0521 | 0.0001 | [0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=4 AND p.pagePath='/about/faq.php' LIMIT 1 |
| 0.0523 | 0.0002 | [4] Using template: /templates/navigation/footer.html |