And they're off!
- 30 June 2018 • Facebook
Australian country music singer and 2018 Order of the Outback Ball MC Tania Kernaghan heading off on one of our scenic river cruises before the big event tonight.
| Time | Δ | Debug Message - Perch 3.1.1 |
|---|---|---|
| 0.0082 | 0 | [57] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0 |
| 0.012 | 0.0038 | [1] SELECT * FROM perch3_pages WHERE pagePath='/index.php' LIMIT 1 |
| 0.0132 | 0.0012 | Using template: /templates/pages/attributes/default.html |
| 0.0133 | 0.0001 | Using sub-template: /templates/pages/attributes/seo.html |
| 0.0133 | 0 | Using sub-template: /templates/pages/attributes/facebook.html |
| 0.0137 | 0.0004 | [6] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Content' AND (regionPage LIKE '/tours/%' OR regionPage='*') |
| 0.0138 | 0.0001 | [5] 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=90 AND idx.itemRev=0) OR (idx.regionID=38 AND idx.itemRev=10) OR (idx.regionID=36 AND idx.itemRev=30) OR (idx.regionID=70 AND idx.itemRev=1) OR (idx.regionID=80 AND idx.itemRev=6) OR (idx.regionID=89 AND idx.itemRev=9)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| 0.014 | 0.0002 | [5] Using template: /templates/content/tour-nav.html |
| 0.0142 | 0.0002 | [14] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC |
| 0.0143 | 0.0001 | [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/index.php' LIMIT 1 |
| 0.0144 | 0.0001 | [1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC |
| 0.0145 | 0.0001 | Using template: /templates/navigation/level1.html |
| 0.0145 | 0 | [5] Using template: /templates/navigation/level2.html |
| 0.0148 | 0.0003 | [5] Using template: /templates/navigation/level2.html |
| 0.0156 | 0.0008 | [3] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/index.php' OR regionPage='*' ORDER BY regionPage DESC |
| 0.0157 | 0.0001 | [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Introduction' AND (regionPage='/index.php' OR regionPage='*') |
| 0.0157 | 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=11 AND idx.itemRev=6)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| 0.0158 | 0.0001 | [1] Using template: /templates/content/introduction.html |
| 0.0161 | 0.0002 | [7] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Content' AND (regionPage LIKE '/tours/%' OR regionPage='/fishing-charters.php' OR regionPage='*') |
| 0.0161 | 0.0001 | [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=90 AND idx.itemRev=0) OR (idx.regionID=38 AND idx.itemRev=10) OR (idx.regionID=36 AND idx.itemRev=30) OR (idx.regionID=72 AND idx.itemRev=0) OR (idx.regionID=70 AND idx.itemRev=1) OR (idx.regionID=80 AND idx.itemRev=6) OR (idx.regionID=89 AND idx.itemRev=9)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| 0.0163 | 0.0001 | [5] Using template: /templates/content/tour.html |
| 0.0164 | 0.0001 | Using sub-template: /templates/content/_tour-notice.html |
| 0.0177 | 0.0013 | [6] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Content' AND (regionPage LIKE '/tours/%' OR regionPage='/fishing-charter.php' OR regionPage='*') |
| 0.0177 | 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=90 AND idx.itemRev=0) OR (idx.regionID=38 AND idx.itemRev=10) OR (idx.regionID=36 AND idx.itemRev=30) OR (idx.regionID=70 AND idx.itemRev=1) OR (idx.regionID=80 AND idx.itemRev=6) OR (idx.regionID=89 AND idx.itemRev=9)) 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.0178 | 0.0001 | [1] Using template: /templates/content/tour.html |
| 0.0179 | 0.0001 | Using sub-template: /templates/content/_tour-notice.html |
| 0.0186 | 0.0008 | Rezdy |
| 0.0187 | 0 | Get api instance 9eef19e75b1847ceaf7e511c2760c96a |
| 1.2957 | 1.2771 | getting products from Rezdy |
| 1.2957 | 0 | successfull call to api |
| 1.2957 | 0 | tour exists |
| 1.2957 | 0 | request status is true1 |
| 1.2963 | 0.0005 | Caching: perch_rezdy_get_by_code7b79afb4853f85611b189ff7e5c23a4e |
| 1.2969 | 0.0006 | [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Reviews' AND (regionPage='/generic.php' OR regionPage='*') |
| 1.297 | 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=49 AND idx.itemRev=15)) 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.2971 | 0.0001 | [1] Using template: /templates/content/reviews-home.html |
| 1.2983 | 0.0012 | [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='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 12:10:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 1 |
| 1.3002 | 0.0019 | [1] SELECT FOUND_ROWS() AS `count` |
| 1.3011 | 0.0009 | [1] Using template: /templates/blog/news-home.html |
| 1.3017 | 0.0006 | [3] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC |
| 1.3019 | 0.0002 | [1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC |
| 1.3028 | 0.0009 | [1] SELECT * FROM perch3_gallery_albums WHERE albumSlug= 'stargazing-tours' |
| 1.303 | 0.0002 | Using template: /templates/gallery/a_list_image.html |
| 1.3031 | 0.0001 | [40] SELECT v.*, i.imageBucket FROM perch3_gallery_image_versions v, perch3_gallery_images i WHERE v.imageID=i.imageID AND i.albumID='4' AND i.imageStatus='active' |
| 1.3032 | 0.0001 | [5] SELECT * FROM perch3_gallery_images WHERE albumID = '4' AND imageStatus='active' ORDER BY imageOrder ASC |
| 1.3038 | 0.0006 | [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Company and contact details' AND (regionPage='/contact.php' OR regionPage='*') |
| 1.3039 | 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 |
| 1.3039 | 0.0001 | [1] Using template: /templates/content/_company-info.html |
| 1.3042 | 0.0003 | [1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer' LIMIT 1 |
| 1.3043 | 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 |
| 1.3044 | 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='/index.php' LIMIT 1 |
| 1.3044 | 0.0001 | [4] Using template: /templates/navigation/footer.html |