A magical night of stargazing and storytelling with the wonderful Kay McGrath for an upcoming episode of Channel 7’s Queensland Weekender! More to come – watch this space.
| Time | Δ | Debug Message - Perch 3.1.1 |
|---|---|---|
| 0.0091 | 0 | [57] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0 |
| 0.0138 | 0.0048 | [1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='postSlug' AND idx.indexValue='2018-06-13-kay-mcgrath-with-yagurli-tours')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2026-03-31 15:15:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 10 |
| 0.0154 | 0.0016 | [1] SELECT FOUND_ROWS() AS `count` |
| 0.0163 | 0.0009 | [1] Using template: /templates/blog/posts/article.html |
| 0.0164 | 0.0001 | Using sub-template: /templates/content/_social-tools.html |
| 0.0169 | 0.0005 | [3] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC |
| 0.0172 | 0.0002 | [1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC |
| 0.0177 | 0.0006 | [1] SELECT * FROM perch3_categories ORDER BY catTreePosition ASC |
| 0.0182 | 0.0004 | [1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='postSlug' AND idx.indexValue='2018-06-13-kay-mcgrath-with-yagurli-tours')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2026-03-31 15:15:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 10 |
| 0.0182 | 0.0001 | [1] SELECT FOUND_ROWS() AS `count` |
| 0.0184 | 0.0001 | Using template: /templates/blog/posts/article.html |
| 0.0185 | 0.0001 | Using sub-template: /templates/content/_social-tools.html |
| 0.0185 | 0 | [2] SELECT catID, catPath FROM perch3_categories |
| 0.0186 | 0.0001 | [1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND ((idx.indexKey='postDateTime' AND idx.indexValue < '2018-06-13 05:57:00')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2026-03-31 15:15:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 1 |
| 0.0197 | 0.0012 | [1] SELECT FOUND_ROWS() AS `count` |
| 0.0198 | 0.0001 | [1] Using template: /templates/blog/post_previous.html |
| 0.02 | 0.0002 | [1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND ((idx.indexKey='postDateTime' AND idx.indexValue > '2018-06-13 05:57:00')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2026-03-31 15:15:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 1 |
| 0.0213 | 0.0013 | [1] SELECT FOUND_ROWS() AS `count` |
| 0.0214 | 0.0001 | [1] Using template: /templates/blog/post_next.html |
| 0.0215 | 0.0002 | [1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='postSlug' AND idx.indexValue='2018-06-13-kay-mcgrath-with-yagurli-tours')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2026-03-31 15:15:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 10 |
| 0.0216 | 0.0001 | [1] SELECT FOUND_ROWS() AS `count` |
| 0.0217 | 0.0001 | [1] Using template: /templates/blog/meta_head.html |
| 0.0219 | 0.0002 | [2] SELECT * FROM perch3_blog_authors ORDER BY authorFamilyName, authorGivenName ASC |
| 0.0223 | 0.0004 | [57] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0 |
| 0.0226 | 0.0003 | [1] SELECT * FROM perch3_pages WHERE pagePath='/blog/post.php' LIMIT 1 |
| 0.0239 | 0.0013 | [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/tours' OR pageSortPath='/tours' LIMIT 1 |
| 0.024 | 0.0001 | [6] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-001%' ORDER BY pageTreePosition ASC |
| 0.0241 | 0.0001 | [0] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/blog/post.php' LIMIT 1 |
| 0.0241 | 0.0001 | Using template: /templates/navigation/level1.html |
| 0.0242 | 0 | [1] Using template: /templates/navigation/level2.html |
| 0.0246 | 0.0004 | [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/about' OR pageSortPath='/about' LIMIT 1 |
| 0.0246 | 0.0001 | [5] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002%' ORDER BY pageTreePosition ASC |
| 0.0247 | 0.0001 | [0] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/blog/post.php' LIMIT 1 |
| 0.0248 | 0.0001 | Using template: /templates/navigation/level1.html |
| 0.0248 | 0 | [1] Using template: /templates/navigation/level2.html |
| 0.0252 | 0.0003 | [1] SELECT groupID FROM perch3_navigation WHERE groupSlug='right-navigation' LIMIT 1 |
| 0.0252 | 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.0253 | 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='/blog/post.php' LIMIT 1 |
| 0.0254 | 0.0001 | [3] Using template: /templates/navigation/level1.html |
| 0.0258 | 0.0004 | [nil] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Company and contact details' AND (regionPage='/blog/post.php' OR regionPage='*') |
| 0.0259 | 0.0001 | No matching content regions found. Check region name (Company and contact details) and page path options. |
| 0.0259 | 0 | [nil] 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 IS NULL AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| 0.0259 | 0.0001 | Using template: /templates/content/_social-tools.html |
| 0.0261 | 0.0001 | [3] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postID' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2026-03-31 15:15:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 3 |
| 0.0276 | 0.0015 | [1] SELECT FOUND_ROWS() AS `count` |
| 0.0276 | 0.0001 | [3] Using template: /templates/blog/post_recent.html |
| 0.0278 | 0.0002 | [1] SELECT * FROM perch3_categories ORDER BY catTreePosition ASC |
| 0.0288 | 0.001 | [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.0289 | 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.0289 | 0.0001 | [1] Using template: /templates/content/_company-info.html |
| 0.0292 | 0.0002 | [1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer' LIMIT 1 |
| 0.0292 | 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.0293 | 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='/blog/post.php' LIMIT 1 |
| 0.0294 | 0.0001 | [4] Using template: /templates/navigation/footer.html |
| 0.0297 | 0.0004 | Array
(
[type] => 2
[message] => Invalid argument supplied for foreach()
[file] => /home/yaya5640/stage.yagurlitours.com.au/blog/post.php
[line] => 177
)
|
