Mira Showers Triathlon – Sunday April 22nd

by Sandford Parks Lido

Mira Showers Triathlon – Sunday April 22nd

We are pleased to announce that the entry for the fourth running of the Mira Showers Triathlon is open: https://www.active.com/cheltenham-gloucestershire/triathlon/races/mira-showers-triathlon-2018

This is the ideal event for both beginners and triathletes starting their tri season. Last year 70 beginners took part!

The event comprises of a 400 metre swim, a flat cycle route of 17.5km and a 2.8k run. The run is a super sprint distance which is ideal for beginners.

As a slight change to our team entry, for this event we have teams of 3 (Cheltenham Triathlon – teams of 6). This is where all three team members complete the swim, cycle and run individually and the combined time produces the team winners.

We look forward to seeing you!


Time Δ Debug Message - Perch Runway 3.1.1
0.10050 [50] 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.11040.01Matched route: news/[slug:s]
0.11070.0002Using master page: /templates/pages/blog/post.php
0.11070Page arguments:
Array
(
    [0] => /news/2018-03-08-mira-showers-triathlon-sunday-april-22nd
    [s] => 2018-03-08-mira-showers-triathlon-sunday-april-22nd
    [1] => 2018-03-08-mira-showers-triathlon-sunday-april-22nd
)
0.11180.0011 [67] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
0.12170.0099 [1] SELECT * FROM perch3_pages WHERE pagePath='/news/post' LIMIT 1
0.13370.012 [1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.13450.0007INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
0.16080.0263 [1] SELECT * FROM perch3_shop_cart WHERE cartID=26031
0.16140.0006 [1] SELECT * FROM perch3_shop_cart WHERE cartID=26031
0.16270.0013 [nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2018-11-21 03:31:00' AND saleTo>'2018-11-21 03:31:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
0.16590.0032 [1] SELECT * FROM perch3_blog_posts WHERE postStatus='Published' AND postDateTime<='2018-11-21 03:31:00' AND postSlug='2018-03-08-mira-showers-triathlon-sunday-april-22nd'
0.17020.0043 [1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
0.17230.0021 [1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC
0.17580.0035Using template: /templates/blog/post.html
0.19620.0204Using template: /templates/blog/post.html
0.19770.0015------------------------------ Calculating cart ------------------------------
0.19780.0001 [1] SELECT * FROM perch3_shop_cart WHERE cartID=26031
0.2070.0092 [1] SELECT * FROM perch3_shop_cart WHERE cartID=26031
0.210.003 [1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.21070.0007 [1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.21110.0005 [1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.21250.0013 [1] SELECT * FROM perch3_shop_currencies WHERE currencyID=47 LIMIT 1
0.2130.0005 [1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=26031
0.21360.0005Tax mode: inc
0.21440.0008 [nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=26031 ORDER BY itemID ASC
0.21720.0028 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Site Name' AND (regionPage='/news/post' OR regionPage='*')
0.21790.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=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.22540.0074 [1] Using template: /templates/content/text.html
0.23010.0047 [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-03-08-mira-showers-triathlon-sunday-april-22nd')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2018-11-21 03:31:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 10
0.2910.0609 [1] SELECT FOUND_ROWS() AS `count`
0.29180.0008 [1] Using template: /templates/blog/meta_head.html
0.32530.0335 [4] SELECT * FROM perch3_blog_authors ORDER BY authorFamilyName, authorGivenName ASC
0.32790.0027 [67] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
0.33140.0035 [1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
0.33190.0005 [5] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug NOT IN ('discounts', 'events', 'swimming-lessons')) AND setID=2 ORDER BY catTreePosition ASC
0.33340.0015 [5] Using template: /templates/categories/products/shop_nav_list.html
0.3340.0006Using sub-template: /templates/categories/title.html
0.33610.0021 [19] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
0.35040.0143 [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/news/post' LIMIT 1
0.35120.0008 [2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-007-001', '000-007', '000') ORDER BY pageTreePosition DESC
0.35220.001Using template: /templates/navigation/navbar_list.html
0.35260.0004 [1] Using template: /templates/navigation/navbar_list.html
0.35350.0008Using sub-template: /templates/navigation/navbar_item.html
0.35410.0006Using sub-template: /templates/navigation/navbar_item.html
0.35560.0015 [1] Using template: /templates/navigation/navbar_list.html
0.35610.0005Using sub-template: /templates/navigation/navbar_item.html
0.35680.0006Using sub-template: /templates/navigation/navbar_item.html
0.35810.0013 [1] Using template: /templates/navigation/navbar_list.html
0.35890.0008Using sub-template: /templates/navigation/navbar_item.html
0.35950.0006Using sub-template: /templates/navigation/navbar_item.html
0.3610.0015 [2] Using template: /templates/navigation/navbar_list.html
0.36230.0013Using sub-template: /templates/navigation/navbar_item.html
0.36280.0005 [9] Using sub-template: /templates/navigation/navbar_item.html
0.36480.002Using sub-template: /templates/navigation/navbar_item.html
0.3650.0003Using sub-template: /templates/navigation/navbar_item.html
0.38420.0191Using template: /templates/search/form_in_menu.html
0.38710.0029 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Profile' AND (regionPage='/news/post' OR regionPage='*')
0.3880.001 [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=3)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.41430.0262 [1] Using template: /templates/content/profile/social_white_icons.html
0.41610.0019 [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=3)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.43520.0191 [1] Using template: /templates/content/profile/phone.html
0.4370.0018 [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/news/post' OR pageSortPath='/news/post' LIMIT 1
0.43770.0007 [1] SELECT * FROM perch3_pages WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-007-001', '000-007', '000') ORDER BY pageTreePosition
0.43840.0007 [1] Using template: /templates/navigation/breadcrumbs.html
0.43990.0015 [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-03-08-mira-showers-triathlon-sunday-april-22nd')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2018-11-21 03:31:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 10
0.4510.0111 [1] SELECT FOUND_ROWS() AS `count`
0.4520.001 [1] Using template: /templates/blog/post_frontend.html
0.59910.1472Using sub-template: /templates/content/sharing_links.html
0.60250.0033 [1] SELECT setID FROM perch3_category_sets WHERE setSlug='blog' LIMIT 1
0.60310.0006 [1] 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.60390.0008 [1] Using template: /templates/blog/category_link.html
0.60540.0015 [1] SELECT * FROM perch3_blogs WHERE blogSlug='blog' LIMIT 1
0.6060.0006 [1] 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<='2018-11-21 03:31:00' AND p.blogID=1 GROUP BY t.tagID ORDER BY t.tagTitle ASC
0.60740.0015 [1] Using template: /templates/blog/tag_link.html
0.60840.0009 [2] SELECT year(postDateTime) as year, COUNT(*) AS year_qty FROM perch3_blog_posts WHERE postStatus='Published' AND postDateTime<='2018-11-21 03:31:00' GROUP BY year ORDER BY year DESC
0.60910.0008Using template: /templates/blog/months_month_link.html
0.60920.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) = '2018' AND p.postStatus='Published' AND p.postDateTime<='2018-11-21 03:31:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.61040.0012 [2] 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) = '2017' AND p.postStatus='Published' AND p.postDateTime<='2018-11-21 03:31:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.61190.0015 [2] Using template: /templates/blog/months_year_link.html
0.61350.0016Request time: 0.6135
0.61350Process time: 0.5964
0.61360Memory: 7.9773