Debug Message - Perch Runway 3.1.7 |
[99] 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 |
Matched page: /, so not using routes. |
Using master page: /templates/pages/home/home.php |
[1] SELECT * FROM perch3_pages WHERE pagePath='/' LIMIT 1 |
[55] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0 |
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1 |
INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]') |
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1818865 |
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1818865 |
[nil] SELECT * FROM perch3_shop_sales
WHERE saleFrom<='2025-09-11 14:09:00' AND saleTo>'2025-09-11 14:09:00' AND saleActive=1 AND saleDeleted IS NULL
ORDER BY saleOrder ASC |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Contact Details' AND (regionPage LIKE '%' OR regionPage='*') |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/site_name.html |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/site_description.html |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/tel_only.html |
Using template: /templates/pages/attributes/default.html |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/og_image.html |
Using template: /templates/pages/attributes/og_image.html |
------------------------------ Calculating cart ------------------------------ |
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1818865 |
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1818865 |
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1 |
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1 |
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1 |
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=47 LIMIT 1 |
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=1818865 |
Tax mode: exc |
[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=1818865 ORDER BY itemID ASC |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/contact_address_schema.html |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='I am looking for menu' AND (regionPage='/' OR regionPage='*') |
[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=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[6] Using template: /templates/content/_homepage/looking_for_menu.html |
[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/' LIMIT 1 |
[1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC |
Using template: /templates/navigation/main_nav.html |
[10] Using template: /templates/navigation/sub_nav.html |
[10] SELECT regionKey, regionHTML FROM perch3_content_regions
WHERE regionPage='/' OR regionPage='*' ORDER BY regionPage DESC |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Homepage Splitter' AND (regionPage='/' OR regionPage='*') |
[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=577 AND idx.itemRev=1)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[4] Using template: /templates/content/_homepage/homepage_splitter_grid.html |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='New Content Blocks' AND (regionPage='/' OR regionPage='*') |
[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=264 AND idx.itemRev=123)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_new_blocks/_new_blocks.html |
Using sub-template: /templates/content/_new_blocks/text_only_block.html |
Using sub-template: /templates/content/_new_blocks/text_square_block.html |
Using sub-template: /templates/content/_new_blocks/text_image_block.html |
Using sub-template: /templates/content/_new_blocks/feature_image_block.html |
Using sub-template: /templates/content/_new_blocks/gallery_block.html |
Using sub-template: /templates/content/_new_blocks/link_banner_block.html |
Using sub-template: /templates/content/_new_blocks/product_listing.html |
Using sub-template: /templates/content/_new_blocks/customers_block.html |
Using sub-template: /templates/content/_new_blocks/social_media_block.html |
Using sub-template: /templates/content/_new_blocks/case_studies.html |
Using sub-template: /templates/content/_new_blocks/spacer_block.html |
Using sub-template: /templates/content/_blocks/image_for_text_image.html |
[8] Using sub-template: /templates/content/_blocks/image_for_text_image.html |
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/case-studies' OR pageSortPath='/case-studies' LIMIT 1 |
[37] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-014%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/' LIMIT 1 |
[1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/the-hurt-arms' OR regionPage='*') |
[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=553 AND idx.itemRev=6)) 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 perch3_pages WHERE pageID=118 LIMIT 1 |
[1] Using template: /templates/content//_case_studies/case_study_list.html |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/low-threshold-commercial-properties' OR regionPage='*') |
[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=547 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 |
[1] SELECT * FROM perch3_pages WHERE pageID=117 LIMIT 1 |
[1] Using template: /templates/content//_case_studies/case_study_list.html |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/jm-construction-riverside-leeds' OR regionPage='*') |
[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=571 AND idx.itemRev=1)) 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 perch3_pages WHERE pageID=121 LIMIT 1 |
[1] Using template: /templates/content//_case_studies/case_study_list.html |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/bayer-environmental-science' OR regionPage='*') |
[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=517 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 |
[1] SELECT * FROM perch3_pages WHERE pageID=111 LIMIT 1 |
[1] Using template: /templates/content//_case_studies/case_study_list.html |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/heritage-timber-doors' OR regionPage='*') |
[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=523 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 perch3_pages WHERE pageID=112 LIMIT 1 |
[1] Using template: /templates/content//_case_studies/case_study_list.html |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/ashbys-of-kingsbridge' OR regionPage='*') |
[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=565 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 perch3_pages WHERE pageID=120 LIMIT 1 |
[1] Using template: /templates/content//_case_studies/case_study_list.html |
[57] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Testimonials' AND (regionPage LIKE '%' OR regionPage='*') |
[6] 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=136 AND idx.itemRev=8) OR (idx.regionID=137 AND idx.itemRev=0) OR (idx.regionID=138 AND idx.itemRev=0) OR (idx.regionID=139 AND idx.itemRev=0) OR (idx.regionID=141 AND idx.itemRev=3) OR (idx.regionID=143 AND idx.itemRev=0) OR (idx.regionID=163 AND idx.itemRev=0) OR (idx.regionID=164 AND idx.itemRev=0) OR (idx.regionID=165 AND idx.itemRev=1) OR (idx.regionID=170 AND idx.itemRev=0) OR (idx.regionID=172 AND idx.itemRev=0) OR (idx.regionID=182 AND idx.itemRev=2) OR (idx.regionID=190 AND idx.itemRev=0) OR (idx.regionID=201 AND idx.itemRev=0) OR (idx.regionID=212 AND idx.itemRev=0) OR (idx.regionID=217 AND idx.itemRev=0) OR (idx.regionID=222 AND idx.itemRev=0) OR (idx.regionID=241 AND idx.itemRev=1) OR (idx.regionID=246 AND idx.itemRev=2) OR (idx.regionID=251 AND idx.itemRev=0) OR (idx.regionID=256 AND idx.itemRev=0) OR (idx.regionID=262 AND idx.itemRev=0) OR (idx.regionID=340 AND idx.itemRev=0) OR (idx.regionID=350 AND idx.itemRev=8) OR (idx.regionID=356 AND idx.itemRev=0) OR (idx.regionID=360 AND idx.itemRev=0) OR (idx.regionID=365 AND idx.itemRev=1) OR (idx.regionID=369 AND idx.itemRev=3) OR (idx.regionID=374 AND idx.itemRev=0) OR (idx.regionID=405 AND idx.itemRev=3) OR (idx.regionID=411 AND idx.itemRev=1) OR (idx.regionID=417 AND idx.itemRev=0) OR (idx.regionID=429 AND idx.itemRev=0) OR (idx.regionID=441 AND idx.itemRev=0) OR (idx.regionID=447 AND idx.itemRev=0) OR (idx.regionID=453 AND idx.itemRev=0) OR (idx.regionID=458 AND idx.itemRev=0) OR (idx.regionID=462 AND idx.itemRev=0) OR (idx.regionID=467 AND idx.itemRev=0) OR (idx.regionID=475 AND idx.itemRev=0) OR (idx.regionID=481 AND idx.itemRev=0) OR (idx.regionID=486 AND idx.itemRev=0) OR (idx.regionID=491 AND idx.itemRev=0) OR (idx.regionID=497 AND idx.itemRev=0) OR (idx.regionID=502 AND idx.itemRev=0) OR (idx.regionID=507 AND idx.itemRev=0) OR (idx.regionID=515 AND idx.itemRev=0) OR (idx.regionID=521 AND idx.itemRev=0) OR (idx.regionID=527 AND idx.itemRev=0) OR (idx.regionID=533 AND idx.itemRev=0) OR (idx.regionID=538 AND idx.itemRev=0) OR (idx.regionID=545 AND idx.itemRev=0) OR (idx.regionID=551 AND idx.itemRev=0) OR (idx.regionID=557 AND idx.itemRev=0) OR (idx.regionID=563 AND idx.itemRev=1) OR (idx.regionID=569 AND idx.itemRev=0) OR (idx.regionID=575 AND idx.itemRev=0)) 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, 6 |
[2] Using template: /templates/content/_testimonials/testimonial_only.html |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='News Articles' AND (regionPage='/news' OR regionPage='*') |
[6] 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=82 AND idx.itemRev=183)) 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, 6 |
[6] Using template: /templates/content/_news/news_testimonial.html |
[8] 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=82 AND idx.itemRev=183)) 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, 8 |
[8] Using template: /templates/content/_news/news_article_list.html |
Using sub-template: /templates/content/_pagination/pagination.html |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/site_name.html |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/tel_only_formatted.html |
Using template: /templates/pages/attributes/hide_enquiry.html |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content//quick_quote.html |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[13] Using template: /templates/content//_contact_details/accreditations.html |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content//_contact_details/tel_email.html |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content//_contact_details/address_only.html |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content//_contact_details/address_only_repeater_limited.html |
[10] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC |
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/' LIMIT 1 |
[1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC |
[10] Using template: /templates/navigation/nav_lis_only.html |
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/foot-links' OR pageSortPath='/foot-links' LIMIT 1 |
[4] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-018%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/' LIMIT 1 |
[1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC |
[4] Using template: /templates/navigation/nav_lis_only.html |
[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=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content//_contact_details/socials.html |
[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=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[6] Using template: /templates/content/_homepage/looking_for_menu.html |
[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/' LIMIT 1 |
[1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC |
Using template: /templates/navigation/main_nav.html |
[10] Using template: /templates/navigation/sub_nav.html |
[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=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[6] Using template: /templates/content/_homepage/looking_for_menu.html |
[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/' LIMIT 1 |
[1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC |
Using template: /templates/navigation/main_nav.html |
[10] Using template: /templates/navigation/sub_nav.html |
Request time: 0.0507 |
Process time: 0.0502 |
Memory: 2.0378 |