| Time | Δ | Debug Message - Perch Runway 3.1.1 |
| 0.0558 | 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.0598 | 0.004 | Matched route: news/category/[slug:cat] |
| 0.0599 | 0.0001 | Using master page: /templates/pages/news/archive.php |
| 0.0599 | 0 | Page arguments: Array
(
[0] => /news/category/general
[cat] => general
[1] => general
) |
| 0.0605 | 0.0006 | [33] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0 |
| 0.0854 | 0.0249 | [0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1 |
| 0.0861 | 0.0006 | [1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='blog/general/') ORDER BY catTreePosition ASC |
| 0.0878 | 0.0017 | Using template: /templates/categories/category.html |
| 0.105 | 0.0172 | [1] SELECT * FROM perch3_categories WHERE catPath='blog/general/' LIMIT 1 |
| 0.1058 | 0.0008 | [1] SELECT * FROM perch3_pages WHERE pagePath='/news/archive' LIMIT 1 |
| 0.1069 | 0.001 | Using template: /templates/pages/attributes/default.html |
| 0.1089 | 0.002 | Using sub-template: /templates/pages/attributes/seo.html |
| 0.109 | 0.0001 | Using sub-template: /templates/pages/attributes/facebook.html |
| 0.109 | 0 | Using sub-template: /templates/pages/attributes/twitter.html |
| 0.1139 | 0.0049 | [22] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC |
| 0.1147 | 0.0008 | [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/news/archive' LIMIT 1 |
| 0.1149 | 0.0003 | [2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-009-002', '000-009', '000') ORDER BY pageTreePosition DESC |
| 0.1153 | 0.0004 | Using template: /templates/navigation/item.html |
| 0.1154 | 0 | [7] Using template: /templates/navigation/subitem.html |
| 0.116 | 0.0006 | [9] Using template: /templates/navigation/subitem.html |
| 0.1173 | 0.0013 | [1] SELECT * FROM perch3_categories WHERE catPath='blog/general/' LIMIT 1 |
| 0.1177 | 0.0003 | [0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1 |
| 0.1179 | 0.0002 | [1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='blog/general/') ORDER BY catTreePosition ASC |
| 0.1182 | 0.0003 | [1] Template file not found: /home/ballyvol/public_html/dev/perch/templates/categories/category_blog_intro.html |
| 0.1195 | 0.0013 | [133] SELECT DISTINCT idx.itemID FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'blog/general/%' OR idx.indexKey='_category' AND idx.indexValue='blog/general/')) |
| 0.1219 | 0.0024 | [8] 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' AND idx.itemID IN ('3', '21', '5', '19', '20', '22', '25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '50', '51', '52', '53', '54', '55', '56', '57', '58', '59', '60', '61', '62', '63', '64', '65', '66', '67', '68', '69', '70', '71', '72', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '99', '100', '101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '113', '114', '115', '116', '117', '118', '119', '120', '121', '122', '123', '124', '125', '126', '127', '128', '129', '130', '131', '132', '133', '134', '135', '136', '137', '138', '139', '140', '141', '142', '143', '144', '145', '148', '149', '151', '1', '161', '162') 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<='2025-05-08 01:07:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 48, 8 |
| 0.1821 | 0.0601 | [1] SELECT FOUND_ROWS() AS `count` |
| 0.1838 | 0.0018 | [8] Using template: /templates/blog/post_in_list.html |
| 0.1841 | 0.0003 | Rescoping to perch:blog |
| 0.1842 | 0 | Using sub-template: /templates/blog/_blog_image_listing.html |
| 0.1849 | 0.0007 | [1] SELECT *
FROM perch3_blog_sections ORDER BY sectionTitle ASC |
| 0.1856 | 0.0007 | [1] SELECT *
FROM perch3_blogs ORDER BY blogTitle ASC |
| 0.1886 | 0.0029 | [1] SELECT setID FROM perch3_category_sets WHERE setSlug='blog' LIMIT 1 |
| 0.1888 | 0.0003 | [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.1908 | 0.0019 | [10] Using template: /templates/blog/category_link_box.html |
| 0.2043 | 0.0135 | [1] SELECT * FROM perch3_blogs WHERE blogSlug='blog' LIMIT 1 |
| 0.2046 | 0.0003 | [1] SELECT * FROM perch3_blog_sections WHERE sectionSlug='posts' LIMIT 1 |
| 0.2048 | 0.0002 | [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<='2025-05-08 01:07:00'
AND p.sectionID=1 AND p.blogID=1
GROUP BY t.tagID
ORDER BY t.tagTitle ASC
|
| 0.2191 | 0.0143 | [18] Using template: /templates/blog/tag_link.html |
| 0.2266 | 0.0075 | [10] SELECT year(postDateTime) as year, COUNT(*) AS year_qty
FROM perch3_blog_posts
WHERE postStatus='Published'
AND postDateTime<='2025-05-08 01:07:00' GROUP BY year
ORDER BY year DESC |
| 0.2279 | 0.0013 | Using template: /templates/blog/months_month_link.html |
| 0.228 | 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<='2025-05-08 01:07:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| 0.2302 | 0.0022 | [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<='2025-05-08 01:07:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| 0.233 | 0.0028 | [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<='2025-05-08 01:07:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| 0.235 | 0.002 | [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<='2025-05-08 01:07:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| 0.2365 | 0.0015 | [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<='2025-05-08 01:07:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| 0.2381 | 0.0016 | [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<='2025-05-08 01:07:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| 0.2397 | 0.0015 | [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<='2025-05-08 01:07:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| 0.2413 | 0.0016 | [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<='2025-05-08 01:07:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| 0.2427 | 0.0015 | [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<='2025-05-08 01:07:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| 0.2443 | 0.0016 | [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<='2025-05-08 01:07:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| 0.2455 | 0.0012 | [10] Using template: /templates/blog/months_year_link.html |
| 0.2611 | 0.0156 | [1] SELECT setID FROM perch3_category_sets WHERE setSlug='blog' LIMIT 1 |
| 0.2616 | 0.0005 | [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.2628 | 0.0012 | [10] Using template: /templates/blog/category_link.html |
| 0.2694 | 0.0067 | [1] SELECT * FROM perch3_blogs WHERE blogSlug='blog' LIMIT 1 |
| 0.2698 | 0.0004 | [1] SELECT * FROM perch3_blog_sections WHERE sectionSlug='posts' LIMIT 1 |
| 0.27 | 0.0002 | [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<='2025-05-08 01:07:00'
AND p.sectionID=1 AND p.blogID=1
GROUP BY t.tagID
ORDER BY t.tagTitle ASC
|
| 0.2709 | 0.0008 | [18] Using template: /templates/blog/tag_link.html |
| 0.2717 | 0.0009 | [10] Using template: /templates/blog/year_link.html |
| 0.2735 | 0.0018 | [1] SELECT groupID FROM perch3_navigation WHERE groupSlug='secondary' LIMIT 1 |
| 0.2739 | 0.0004 | [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.2745 | 0.0005 | [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.2748 | 0.0003 | [6] Using template: /templates/navigation/secondary_item.html |
| 0.2755 | 0.0007 | Request time: 0.2754 |
| 0.2755 | 0 | Process time: 0.2741 |
| 0.2755 | 0 | Memory: 4.0161 |
| 0.2755 | 0 | Array
(
[type] => 8
[message] => Undefined variable: obfuscatedEmail
[file] => /home/ballyvol/public_html/dev/inc/functions.inc.php
[line] => 14
)
|
