V
Cementa 2022 LOGO

Subverted Expectations Installation Gallery


Categories
Subverted Expectations Installation Gallery
Leave a comment
Time Δ Debug Message - Perch Runway 3.2
0.00360 [38] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch2_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 perch2_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
0.00540.0018Matched route: blog/[blogslug:s]
0.00540Using master page: /templates/pages/blog/post.php
0.00540Page arguments:
Array
(
    [0] => /blog/2021-01-23-subverted-expectations-installation-gallery
    [s] => 2021-01-23-subverted-expectations-installation-gallery
    [1] => 2021-01-23-subverted-expectations-installation-gallery
)
0.00560.0002 [44] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
0.00720.0016 [1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_blog_index idx JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch2_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='2021-01-23-subverted-expectations-installation-gallery')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2021-09-24 19:05:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 10
0.00960.0024 [1] SELECT FOUND_ROWS() AS `count`
0.01010.0004 [1] Using template: /templates/blog/meta_head.html
0.01060.0005 [6] SELECT * FROM perch2_blog_authors ORDER BY authorFamilyName, authorGivenName ASC
0.01110.0005 [1] SELECT * FROM perch2_blog_sections ORDER BY sectionTitle ASC
0.01140.0003 [1] SELECT * FROM perch2_blogs ORDER BY blogTitle ASC
0.02030.0089 [44] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
0.02110.0008 [5] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
0.02130.0002 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/blog/post' LIMIT 1
0.02140.0001 [2] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-005-001', '000-005', '000') ORDER BY pageTreePosition DESC
0.02160.0002 [5] Using template: /templates/navigation/item.html
0.02220.0006 [1] SELECT * FROM perch2_blog_posts WHERE postStatus='Published' AND postDateTime<='2021-09-24 19:05:00' AND postSlug='2021-01-23-subverted-expectations-installation-gallery'
0.02330.0011Using template: /templates/blog/posts/post_simplegrid.html
0.02350.0002 [1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_blog_index idx JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch2_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='2021-01-23-subverted-expectations-installation-gallery')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2021-09-24 19:05:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 10
0.02480.0013 [1] SELECT FOUND_ROWS() AS `count`
0.02490.0001 [1] Using template: /templates/blog/C_post.html
0.02520.0002 [9] Using sub-template: /templates/blog/_responsive_pic_blog.html
0.0460.0209 [3] SELECT * FROM perch2_categories ORDER BY catTreePosition ASC
0.04750.0014 [1] SELECT * FROM perch2_blog_authors WHERE authorID='3' LIMIT 1
0.04770.0002Using template: /templates/blog/author.html
0.04810.0004 [1] SELECT * FROM perch2_categories WHERE catID=3 LIMIT 1
0.04820.0001 [1] SELECT * FROM perch2_categories WHERE catID=15 LIMIT 1
0.04830.0001 [1] SELECT * FROM perch2_categories WHERE catID=26 LIMIT 1
0.04840.0002 [3] Using template: /templates/blog/post_category_link.html
0.04880.0004 [nil] SELECT * FROM perch2_blog_comments WHERE 1=1 AND postID=250 AND commentStatus='LIVE' ORDER BY FIELD(webmentionType, 'like', 'repost', 'comment', NULL) ASC, commentDateTime ASC
0.05260.0038 [0] Using template: /templates/blog/comment.html
0.05290.0003Using template: /templates/blog/posts/post_simplegrid.html
0.05310.0002 [1] SELECT * FROM perch2_blog_posts WHERE postID=250 AND postStatus='Published' AND postDateTime<='2021-09-24 19:05:00'
0.05330.0002Using template: /templates/blog/comment_form.html
0.05410.0008 [3] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/blog/post' OR regionPage='*' ORDER BY regionPage DESC
0.05430.0002 [5] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
0.05450.0002 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/blog/post' LIMIT 1
0.05460.0001 [2] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-005-001', '000-005', '000') ORDER BY pageTreePosition DESC
0.05480.0001 [5] Using template: /templates/navigation/blythe_auto.html
0.05510.0004 [1] SELECT collectionID, collectionTemplate FROM perch2_collections WHERE collectionKey='Events'
0.05530.0001 [2] SELECT idx.itemID FROM perch2_collection_index idx JOIN perch2_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/highlighted%')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
0.05570.0004 [2] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch2_collection_index idx JOIN perch2_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID JOIN perch2_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID JOIN perch2_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='eventDateTime' WHERE (idx.collectionID=3) AND idx.itemID IN (314, 577) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
0.06450.0089 [2] Using template: /templates/content/eventSidebar.html
0.0650.0005 [0] SELECT idx.itemID FROM perch2_collection_index idx JOIN perch2_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/special%')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
0.06560.0006 [nil] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch2_collection_index idx JOIN perch2_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID JOIN perch2_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID JOIN perch2_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='eventDateTime' WHERE (idx.collectionID=3) AND idx.itemID IN (0) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
0.06580.0002Using template: /templates/content/eventSidebar.html
0.0660.0002 [5] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
0.06620.0002 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/blog/post' LIMIT 1
0.06630.0001 [2] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-005-001', '000-005', '000') ORDER BY pageTreePosition DESC
0.06640.0001 [5] Using template: /templates/navigation/blythe_auto.html
0.06680.0004Request time: 0.0668
0.06680Process time: 0.0666
0.06680Memory: 1.273