Events

TBC
Opening Day 2019

Opening Day 2019

Sandford Parks Lido
TBC
Easter Eggstravaganza!

Easter Eggstravaganza!

Sandford Parks Lido
TBC
Sunrise Swim

Sunrise Swim

Sandford Parks Lido
TBC
Sunset Swim

Sunset Swim

Sandford Parks Lido
TBC
Outdoor Cinema - Friday

Outdoor Cinema - Friday

Sandford Parks Lido
TBC
Outdoor Cinema - Saturday

Outdoor Cinema - Saturday

Sandford Parks Lido
TBC
Dog Swim - Saturday

Dog Swim - Saturday

Sandford Parks Lido
TBC
Dog Swim - Sunday

Dog Swim - Sunday

Sandford Parks Lido
Time Δ Debug Message - Perch Runway 3.1.4
0.00350 [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.00430.0008Matched route: events/category/[slug:cat]
0.00440.0001Using master page: /templates/pages/events/index.php
0.00440Page arguments:
Array
(
    [0] => /events/category/family
    [cat] => family
    [1] => family
)
0.00460.0002 [70] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
0.00520.0006 [1] SELECT * FROM perch3_pages WHERE pagePath='/events' LIMIT 1
0.00610.0009 [1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.00630.0001INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
0.0090.0027 [1] SELECT * FROM perch3_shop_cart WHERE cartID=918273
0.00940.0005 [1] SELECT * FROM perch3_shop_cart WHERE cartID=918273
0.010.0005 [nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2019-03-18 19:21:00' AND saleTo>'2019-03-18 19:21:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
0.01070.0007------------------------------ Calculating cart ------------------------------
0.01080 [1] SELECT * FROM perch3_shop_cart WHERE cartID=918273
0.01150.0007 [1] SELECT * FROM perch3_shop_cart WHERE cartID=918273
0.01190.0004 [1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.0120.0001 [1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.01210.0001 [1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.01240.0003 [1] SELECT * FROM perch3_shop_currencies WHERE currencyID=47 LIMIT 1
0.01250.0001 [1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=918273
0.01310.0006Tax mode: inc
0.01320.0001 [nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=918273 ORDER BY itemID ASC
0.01390.0006 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Profile' AND (regionPage='/events' OR regionPage='*')
0.0140.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.01420.0002 [1] Using template: /templates/content/profile/contact_intro_contact.html
0.01510.0009 [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.01530.0002 [1] Using template: /templates/content/profile/contact_intro_social.html
0.0160.0007 [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.01610.0002 [1] Using template: /templates/content/profile/social_white_icons.html
0.01690.0007 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Site Name' AND (regionPage='/events' OR regionPage='*')
0.0170.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.01710.0001 [1] Using template: /templates/content/text.html
0.01740.0003Using template: /templates/pages/attributes/default.html
0.01750.0001Using sub-template: /templates/pages/attributes/seo.html
0.01760.0001Using sub-template: /templates/pages/attributes/facebook.html
0.01770Using sub-template: /templates/pages/attributes/twitter.html
0.01880.0012 [1] SELECT groupID FROM perch3_navigation WHERE groupSlug='header-menu' LIMIT 1
0.0190.0002 [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.01920.0002 [1] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=6 AND p.pagePath='/events' LIMIT 1
0.01930.0001 [1] SELECT pageID FROM perch3_navigation_pages WHERE groupID=6 AND pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
0.01950.0002Using template: /templates/navigation/item.html
0.01960 [3] Using template: /templates/navigation/item-lvl-2.html
0.02010.0005 [2] Using template: /templates/navigation/item-lvl-2.html
0.02060.0005 [2] Using template: /templates/navigation/item-lvl-2.html
0.02090.0004 [5] Using template: /templates/navigation/item-lvl-2.html
0.02240.0015 [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/events' OR pageSortPath='/events' LIMIT 1
0.02260.0001 [1] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageTreePosition IN ('000-007', '000') ORDER BY pageTreePosition
0.02270.0001 [1] Using template: /templates/navigation/breadcrumbs.html
0.02310.0004 [1] SELECT collectionID, collectionTemplate FROM perch3_collections WHERE collectionKey='Events'
0.02320.0001 [13] SELECT idx.itemID FROM perch3_collection_index idx JOIN perch3_collection_revisions c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.collectionID=c.collectionID WHERE (idx.collectionID=3) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'events/family/%'))
0.02340.0002 [13] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='date' WHERE (idx.collectionID=3) AND idx.itemID IN (27, 28, 32, 36, 30, 39, 43, 33, 45, 42, 41, 49, 48) AND ((idx.indexKey='date' AND idx.indexValue >= '2019-03-18 00:00:00')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
0.03490.0115Using template: /templates/content/events/list.html
0.03510.0002 [13] Using sub-template: /templates/content/events/card.html
0.03540.0003Using sub-template: /templates/content/events/price.html
0.0360.0006 [1] SELECT * FROM perch3_categories ORDER BY catTreePosition ASC
0.05550.0195 [1] SELECT setID FROM perch3_category_sets WHERE setSlug='events' LIMIT 1
0.05570.0002 [7] SELECT main.* FROM perch3_categories main WHERE 1=1 AND setID=3 ORDER BY catTreePosition ASC
0.05590.0002 [7] Using template: /templates/categories/events/list.html
0.05690.0011 [1] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='date' WHERE (idx.collectionID=3) AND ((idx.indexKey='featured' AND idx.indexValue='1')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC LIMIT 0, 3
0.05720.0003Using template: /templates/content/events/small_card.html
0.05730.0001 [1] Using sub-template: /templates/content/events/price.html
0.0580.0007 [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.05820.0002 [1] Using template: /templates/content/profile/location_address.html
0.05840.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.05860.0002 [1] Using template: /templates/content/profile/footer_logos.html
0.05880.0002 [1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer' LIMIT 1
0.0590.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.05910.0002 [0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=5 AND p.pagePath='/events' LIMIT 1
0.05920.0001 [2] Using template: /templates/navigation/footer-list.html
0.05980.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.060.0002 [1] Using template: /templates/content/profile/footer_contact.html
0.06090.0009Request time: 0.0608
0.06090Process time: 0.0606
0.06090Memory: 1.6699