CHELTENHAM AWARD WINNERS!

by Sandford Parks Lido

CHELTENHAM AWARD WINNERS!

All of us at Sandford Parks Lido are delighted to have been awarded two awards at the inaugural Cheltenham Awards hosted by Gloucestershire Live; The Cheltenham Hospitality, Leisure & Tourism Award and The Cheltenham Champion Award.

We consider this a great honour, thank you to all of you who pass through our gates!


Time Δ Debug Message - Perch Runway 3.1.4
0.00510 [53] 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
0.00620.0011Matched route: news/[slug:s]
0.00630.0001Using master page: /templates/pages/blog/post.php
0.00630Page arguments:
Array
(
    [0] => /news/2018-09-11-cheltenham-award-winners
    [s] => 2018-09-11-cheltenham-award-winners
    [1] => 2018-09-11-cheltenham-award-winners
)
0.00650.0002 [70] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
0.00710.0006 [1] SELECT * FROM perch3_pages WHERE pagePath='/news/post' LIMIT 1
0.00790.0008 [1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.0080.0001INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
0.00970.0017 [1] SELECT * FROM perch3_shop_cart WHERE cartID=918277
0.01020.0005 [1] SELECT * FROM perch3_shop_cart WHERE cartID=918277
0.01050.0003 [nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2019-03-18 19:22:00' AND saleTo>'2019-03-18 19:22:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
0.01140.0009 [1] SELECT * FROM perch3_blog_posts WHERE postStatus='Published' AND postDateTime<='2019-03-18 19:22:00' AND postSlug='2018-09-11-cheltenham-award-winners'
0.01270.0012 [1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
0.0130.0003 [1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC
0.01360.0006Using template: /templates/blog/post.html
0.01460.001Using sub-template: /templates/blog/blocks/photo.html
0.01490.0003Using sub-template: /templates/blog/blocks/photos.html
0.01530.0003Using sub-template: /templates/blog/blocks/content.html
0.01630.001Using template: /templates/blog/post.html
0.01640.0001Using sub-template: /templates/blog/blocks/photo.html
0.01650Using sub-template: /templates/blog/blocks/photos.html
0.01650Using sub-template: /templates/blog/blocks/content.html
0.01670.0002------------------------------ Calculating cart ------------------------------
0.01670 [1] SELECT * FROM perch3_shop_cart WHERE cartID=918277
0.01740.0007 [1] SELECT * FROM perch3_shop_cart WHERE cartID=918277
0.01770.0003 [1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.01790.0001 [1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.0180.0001 [1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.01820.0002 [1] SELECT * FROM perch3_shop_currencies WHERE currencyID=47 LIMIT 1
0.01830.0001 [1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=918277
0.01880.0005Tax mode: inc
0.0190.0001 [nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=918277 ORDER BY itemID ASC
0.01950.0006 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Profile' AND (regionPage='/news/post' OR regionPage='*')
0.01970.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=156 AND idx.itemRev=4)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.01990.0002 [1] Using template: /templates/content/profile/contact_intro_contact.html
0.02040.0005 [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=156 AND idx.itemRev=4)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.02050.0002 [1] Using template: /templates/content/profile/contact_intro_social.html
0.02110.0006 [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=156 AND idx.itemRev=4)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.02130.0002 [1] Using template: /templates/content/profile/social_white_icons.html
0.02190.0006 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Site Name' AND (regionPage='/news/post' OR regionPage='*')
0.0220.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=134 AND idx.itemRev=2)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.02210.0001 [1] Using template: /templates/content/text.html
0.02280.0007 [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-09-11-cheltenham-award-winners')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2019-03-18 19:22:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 10
0.02530.0025 [1] SELECT FOUND_ROWS() AS `count`
0.02560.0003 [1] Using template: /templates/blog/meta_head.html
0.02690.0013 [7] SELECT * FROM perch3_blog_authors ORDER BY authorFamilyName, authorGivenName ASC
0.02830.0014 [70] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
0.02880.0005 [1] SELECT groupID FROM perch3_navigation WHERE groupSlug='header-menu' LIMIT 1
0.02890.0001 [13] 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=6 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=2 ORDER BY np.pageTreePosition ASC
0.02910.0002 [0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=6 AND p.pagePath='/news/post' LIMIT 1
0.02930.0002Using template: /templates/navigation/item.html
0.02930 [3] Using template: /templates/navigation/item-lvl-2.html
0.02990.0006 [2] Using template: /templates/navigation/item-lvl-2.html
0.03020.0003 [2] Using template: /templates/navigation/item-lvl-2.html
0.03050.0003 [5] Using template: /templates/navigation/item-lvl-2.html
0.03190.0014 [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/news/post' OR pageSortPath='/news/post' LIMIT 1
0.03210.0001 [1] SELECT * FROM perch3_pages WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-008-001', '000-008', '000') ORDER BY pageTreePosition
0.03220.0001 [1] Using template: /templates/navigation/breadcrumbs.html
0.03270.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-09-11-cheltenham-award-winners')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2019-03-18 19:22:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 10
0.03280.0001 [1] SELECT FOUND_ROWS() AS `count`
0.0330.0002 [1] Using template: /templates/blog/post_frontend.html
0.03360.0006Using sub-template: /templates/blog/blocks/photo.html
0.03370.0001Using sub-template: /templates/blog/blocks/photos.html
0.03380.0001Using sub-template: /templates/blog/blocks/content.html
0.03380.0001Using sub-template: /templates/content/sharing_links.html
0.03540.0016 [1] SELECT setID FROM perch3_category_sets WHERE setSlug='blog' LIMIT 1
0.03550.0001 [nil] SELECT main.* , COALESCE(cc.countValue,0) AS `count.blog.post` FROM perch3_categories main LEFT OUTER JOIN perch3_category_counts cc ON cc.catID=main.catID WHERE 1=1 AND setID=1 AND (cc.countType='blog.post' OR cc.countType IS NULL) AND cc.countValue > 0 ORDER BY catTreePosition ASC
0.03570.0002Using template: /templates/blog/category_link.html
0.0360.0003 [1] SELECT * FROM perch3_blogs WHERE blogSlug='blog' LIMIT 1
0.03610.0001 [nil] SELECT t.tagTitle, t.tagSlug, COUNT(p2t.postID) AS qty FROM perch3_blog_tags t, perch3_blog_posts_to_tags p2t, perch3_blog_posts p WHERE p2t.tagID=t.tagID AND p2t.postID=p.postID AND p.postStatus='Published' AND p.postDateTime<='2019-03-18 19:22:00' AND p.blogID=1 GROUP BY t.tagID ORDER BY t.tagTitle ASC
0.03670.0005 [0] Using template: /templates/blog/tag_link.html
0.03670.0001 [2] SELECT year(postDateTime) as year, COUNT(*) AS year_qty FROM perch3_blog_posts WHERE postStatus='Published' AND postDateTime<='2019-03-18 19:22:00' GROUP BY year ORDER BY year DESC
0.03720.0004Using template: /templates/blog/months_month_link.html
0.03720.0001 [1] SELECT DISTINCT year(postDateTime) AS year, month(postDateTime) AS month, CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date, COUNT(*) AS month_qty FROM perch3_blog_posts p WHERE year(postDateTime) = '2019' AND p.postStatus='Published' AND p.postDateTime<='2019-03-18 19:22:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.03790.0007 [1] SELECT DISTINCT year(postDateTime) AS year, month(postDateTime) AS month, CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date, COUNT(*) AS month_qty FROM perch3_blog_posts p WHERE year(postDateTime) = '2018' AND p.postStatus='Published' AND p.postDateTime<='2019-03-18 19:22:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.03860.0006 [2] Using template: /templates/blog/months_year_link.html
0.03930.0008 [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=156 AND idx.itemRev=4)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.03950.0002 [1] Using template: /templates/content/profile/location_address.html
0.03980.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=156 AND idx.itemRev=4)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.03990.0002 [1] Using template: /templates/content/profile/footer_logos.html
0.04010.0002 [1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer' LIMIT 1
0.04020.0001 [2] 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=5 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
0.04030.0001 [0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=5 AND p.pagePath='/news/post' LIMIT 1
0.04050.0001 [2] Using template: /templates/navigation/footer-list.html
0.04090.0005 [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=156 AND idx.itemRev=4)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.04110.0002 [1] Using template: /templates/content/profile/footer_contact.html
0.04150.0004Request time: 0.0415
0.04150Process time: 0.0408
0.04150Memory: 1.2928