| Debug Message - Perch 3.1.4 |
| [40] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0 |
| [4] SELECT regionKey, regionHTML FROM perch2_content_regions
WHERE regionPage='/index.php' OR regionPage='*' ORDER BY regionPage DESC |
| [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Latest pages' AND (regionPage='/index.php' OR regionPage='*') |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx
JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=46 AND idx.itemRev=10)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC LIMIT 0, 3 |
| [1] Using template: /templates/content/latest_pages.html |
| [5] 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='postDateTime' 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<='2019-04-24 17:32:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 5 |
| [1] SELECT FOUND_ROWS() AS `count` |
| [5] Using template: /templates/blog/latest_news.html |
| [3] SELECT *
FROM perch2_blog_sections ORDER BY sectionTitle ASC |
| [1] SELECT *
FROM perch2_blogs ORDER BY blogTitle ASC |
| [nil] SELECT DISTINCT e.* FROM perch2_events e WHERE eventDateTime>='2019-04-24T17:32:47+01:00' ORDER BY eventDateTime ASC LIMIT 1 |
| Using template: /templates/events/listing/next-event.html |
| [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Place information' AND (regionPage='/places/cemetery.php' OR regionPage='*') |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx
JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=5)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] SELECT * FROM perch2_pages WHERE pageID=3 LIMIT 1 |
| [1] Using template: /templates/content/latest_page.html |
| [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Community group information' AND (regionPage='/community/youth-club.php' OR regionPage='*') |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx
JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=25 AND idx.itemRev=5)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] SELECT * FROM perch2_pages WHERE pageID=9 LIMIT 1 |
| [1] Using template: /templates/content/latest_page.html |
| [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Parish Council information' AND (regionPage='/parish-council/meetings.php' OR regionPage='*') |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx
JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=29 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 |
| [1] SELECT * FROM perch2_pages WHERE pageID=10 LIMIT 1 |
| [1] Using template: /templates/content/latest_page.html |