News › Archive of 2011

Feb 22 2011
The Picture of Dorian Gray theatre & dinner at Ballyvolane House

THEATRE & DINNER AT BALLYVOLANE HOUSE
WONDERLAND PRODUCTIONS PRESENTS
THE PICTURE OF DORIAN …

Read more ›

‹ Page 2 of 2

Time	Δ	Debug Message - Perch Runway 3.1.1
0.0225	0	[39] 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.0253	0.0028	Matched route: news/[year:year]
0.0253	0.0001	Using master page: /templates/pages/news/archive.php
0.0253	0	Page arguments: Array ( [0] => /news/2011 [year] => 2011 [1] => 2011 )
0.0257	0.0004	[33] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
0.0289	0.0032	[1] SELECT * FROM perch3_pages WHERE pagePath='/news/archive' LIMIT 1
0.0297	0.0008	Using template: /templates/pages/attributes/default.html
0.0299	0.0001	Using sub-template: /templates/pages/attributes/seo.html
0.0299	0	Using sub-template: /templates/pages/attributes/facebook.html
0.0299	0	Using sub-template: /templates/pages/attributes/twitter.html
0.0307	0.0007	[22] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
0.031	0.0004	[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/news/archive' LIMIT 1
0.0312	0.0001	[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-009-002', '000-009', '000') ORDER BY pageTreePosition DESC
0.0314	0.0002	Using template: /templates/navigation/item.html
0.0314	0	[7] Using template: /templates/navigation/subitem.html
0.0319	0.0005	[9] Using template: /templates/navigation/subitem.html
0.0348	0.0029	[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 >= '2011-01-01 00:00:00' AND idx.indexValue <= '2011-12-31 23:59:59'))) 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-09-29 06:50:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 8, 8
0.0377	0.0028	[1] SELECT FOUND_ROWS() AS `count`
0.0389	0.0013	[1] Using template: /templates/blog/post_in_list.html
0.0391	0.0001	Rescoping to perch:blog
0.0391	0	Using sub-template: /templates/blog/_blog_image_listing.html
0.0398	0.0007	[1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
0.0402	0.0004	[1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC
0.0412	0.001	[1] SELECT setID FROM perch3_category_sets WHERE setSlug='blog' LIMIT 1
0.0414	0.0002	[10] 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.0425	0.001	[10] Using template: /templates/blog/category_link_box.html
0.0438	0.0014	[1] SELECT * FROM perch3_blogs WHERE blogSlug='blog' LIMIT 1
0.044	0.0002	[1] SELECT * FROM perch3_blog_sections WHERE sectionSlug='posts' LIMIT 1
0.0441	0.0001	[18] 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<='2026-09-29 06:50:00' AND p.sectionID=1 AND p.blogID=1 GROUP BY t.tagID ORDER BY t.tagTitle ASC
0.0449	0.0007	[18] Using template: /templates/blog/tag_link.html
0.0456	0.0008	[10] SELECT year(postDateTime) as year, COUNT(*) AS year_qty FROM perch3_blog_posts WHERE postStatus='Published' AND postDateTime<='2026-09-29 06:50:00' GROUP BY year ORDER BY year DESC
0.0465	0.0009	Using template: /templates/blog/months_month_link.html
0.0466	0	[4] 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<='2026-09-29 06:50:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0479	0.0013	[11] 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<='2026-09-29 06:50:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0496	0.0018	[11] 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) = '2016' AND p.postStatus='Published' AND p.postDateTime<='2026-09-29 06:50:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0514	0.0017	[7] 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) = '2015' AND p.postStatus='Published' AND p.postDateTime<='2026-09-29 06:50:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0529	0.0016	[8] 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) = '2014' AND p.postStatus='Published' AND p.postDateTime<='2026-09-29 06:50:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0545	0.0015	[6] 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) = '2013' AND p.postStatus='Published' AND p.postDateTime<='2026-09-29 06:50:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0559	0.0014	[7] 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) = '2012' AND p.postStatus='Published' AND p.postDateTime<='2026-09-29 06:50:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0573	0.0015	[5] 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) = '2011' AND p.postStatus='Published' AND p.postDateTime<='2026-09-29 06:50:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0587	0.0013	[8] 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) = '2010' AND p.postStatus='Published' AND p.postDateTime<='2026-09-29 06:50:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0601	0.0015	[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) = '2009' AND p.postStatus='Published' AND p.postDateTime<='2026-09-29 06:50:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0613	0.0011	[10] Using template: /templates/blog/months_year_link.html
0.0618	0.0005	[1] SELECT setID FROM perch3_category_sets WHERE setSlug='blog' LIMIT 1
0.0619	0.0001	[10] 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.0627	0.0008	[10] Using template: /templates/blog/category_link.html
0.0633	0.0006	[1] SELECT * FROM perch3_blogs WHERE blogSlug='blog' LIMIT 1
0.0635	0.0002	[1] SELECT * FROM perch3_blog_sections WHERE sectionSlug='posts' LIMIT 1
0.0636	0.0001	[18] 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<='2026-09-29 06:50:00' AND p.sectionID=1 AND p.blogID=1 GROUP BY t.tagID ORDER BY t.tagTitle ASC
0.0642	0.0005	[18] Using template: /templates/blog/tag_link.html
0.0649	0.0008	[10] Using template: /templates/blog/year_link.html
0.0657	0.0008	[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='secondary' LIMIT 1
0.066	0.0003	[6] 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=1 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
0.0664	0.0003	[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=1 AND p.pagePath='/news/archive' LIMIT 1
0.0666	0.0002	[6] Using template: /templates/navigation/secondary_item.html
0.0672	0.0006	Request time: 0.0672
0.0672	0	Process time: 0.0668
0.0672	0	Memory: 3.9707
0.0672	0	Array ( [type] => 8 [message] => Undefined variable: obfuscatedEmail [file] => /home/ballyvol/public_html/dev/inc/functions.inc.php [line] => 14 )

News › Archive of 2011

The Picture of Dorian Gray theatre & dinner at Ballyvolane House

Subscribe to our Email Newsletter