Forum
If I see debug listed twice, does that mean the pager content is loaded twice?
I have a very demanding page that I'm trying to optimize... When I turn on debug, The listing appears twice... Wondering what that could mean...
Here's the debug in question:
Time Δ Debug Message - Perch Runway 3.1.1
0.0013 0 [106] 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.0068 0.0055 Matched page: /visit-a-preserve, so not using routes.
0.0069 0.0001 Using master page: /templates/pages/preserve_jump.php
0.0071 0.0001 [97] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
0.0088 0.0017 [1] SELECT * FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
0.0099 0.0011 [1] SELECT collectionID, collectionTemplate FROM perch2_collections WHERE collectionKey='Preserves'
0.0102 0.0004 [51] 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='_order' WHERE (idx.collectionID=1) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
2.2291 2.2188 [51] Using template: /templates/content/mapping.html
2.259 0.0299 [1] SELECT groupID FROM perch2_navigation WHERE groupSlug='main-navigation' LIMIT 1
2.2593 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 perch2_navigation_pages np, perch2_pages p WHERE p.pageID=np.pageID AND np.groupID=13 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
2.2599 0.0006 [1] SELECT np.pageTreePosition FROM perch2_pages p, perch2_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=13 AND p.pagePath='/visit-a-preserve' LIMIT 1
2.2605 0.0005 [1] SELECT pageID FROM perch2_navigation_pages WHERE groupID=13 AND pageTreePosition IN ('000-003', '000') ORDER BY pageTreePosition DESC
2.261 0.0005 [6] Using template: /templates/navigation/main_navigation.html
2.2618 0.0008 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' OR pageSortPath='/visit-a-preserve' LIMIT 1
2.2622 0.0004 [1] SELECT * FROM perch2_pages WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition
2.2627 0.0005 [1] Using template: /templates/navigation/breadcrumbs_ml.html
2.2632 0.0005 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Social Networks' AND (regionPage='/visit-a-preserve' OR regionPage='*')
2.2637 0.0005 [5] 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=1643 AND idx.itemRev=16)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
2.2685 0.0048 [5] Using template: /templates/content/global/social.html
2.2706 0.002 [8] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/visit-a-preserve' OR regionPage='*' ORDER BY regionPage DESC
2.2714 0.0008 [5] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'regions/southern-maine/%'))
2.2731 0.0017 [5] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (18, 25, 33, 43, 32) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
2.6017 0.3286 [5] Using template: /templates/content/preserves/region_listing.html
2.6028 0.0011 [21] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'regions/midcoast/%'))
2.6059 0.0031 [21] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (13, 15, 17, 21, 44, 38, 14, 97, 138, 139, 95, 156, 29, 31, 40, 336, 28, 20, 35, 469, 37) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
3.3344 0.7285 [21] Using template: /templates/content/preserves/region_listing.html
3.3376 0.0032 [17] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'regions/mount-desert-island/%'))
3.3403 0.0027 [17] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (41, 26, 34, 30, 12, 100, 98, 1, 24, 91, 22, 92, 101, 102, 96, 36, 19) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
3.9402 0.5999 [17] Using template: /templates/content/preserves/region_listing.html
3.9429 0.0026 [8] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'regions/downeast/%'))
3.9458 0.003 [8] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (42, 39, 94, 16, 23, 27, 99, 93) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
4.3197 0.3739 [8] Using template: /templates/content/preserves/region_listing.html
4.3211 0.0014 [19] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'preserve-attributes/camping/%'))
4.3236 0.0025 [19] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (32, 42, 17, 38, 14, 97, 100, 25, 43, 91, 336, 101, 102, 35, 469, 28, 41, 34, 96) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
5.0414 0.7178 [19] Using template: /templates/content/preserves/preserve_select.html
5.0445 0.0031 [14] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'preserve-attributes/hiking/%'))
5.0477 0.0031 [14] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (42, 30, 16, 23, 139, 95, 93, 24, 469, 39, 21, 44, 34, 27) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
5.9473 0.8997 [14] Using template: /templates/content/preserves/preserve_select.html
5.9496 0.0023 [18] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'preserve-attributes/birding/%'))
5.9522 0.0025 [18] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (30, 38, 138, 16, 23, 99, 1, 24, 43, 29, 31, 40, 39, 21, 156, 34, 36, 27) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
6.7049 0.7528 [18] Using template: /templates/content/preserves/preserve_select.html
6.7079 0.0029 [4] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'preserve-attributes/exploring-history/%'))
6.7094 0.0015 [4] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (42, 33, 39, 44) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
7.1523 0.4429 [4] Using template: /templates/content/preserves/preserve_select.html
7.1532 0.0009 [1] SELECT collectionID, collectionTemplate FROM perch2_collections WHERE collectionKey='Initiatives'
7.1536 0.0004 [8] 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='_order' WHERE (idx.collectionID=2) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
7.3074 0.1538 [8] Using template: /templates/content/initiative/_initiative_sitemap.html
7.3089 0.0015 [1] SELECT setID FROM perch2_category_sets WHERE setSlug='regions' LIMIT 1
7.3094 0.0005 [5] SELECT main.* FROM perch2_categories main WHERE 1=1 AND setID=7 ORDER BY catTreePosition ASC
7.3101 0.0007 [5] Using template: /templates/categories/regions_navigation.html
7.3109 0.0008 [1] SELECT setID FROM perch2_category_sets WHERE setSlug='preserve-attributes' LIMIT 1
7.3112 0.0003 [12] SELECT main.* FROM perch2_categories main WHERE 1=1 AND setID=9 ORDER BY catTreePosition ASC
7.3123 0.001 [12] Using template: /templates/categories/activity_navigation.html
7.3139 0.0017 [1] SELECT collectionID, collectionTemplate FROM perch2_collections WHERE collectionKey='Job'
7.3142 0.0003 [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='start' WHERE (idx.collectionID=6) AND ((idx.indexKey='expire' AND idx.indexValue >= '2018-05-08 23:59:59')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
7.3162 0.0019 Using template: /templates/content/_jobs_sitemap.html
7.3163 0.0002 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' OR pageSortPath='/visit-a-preserve' LIMIT 1
7.3167 0.0004 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pageTreePosition='000-004' LIMIT 1
7.317 0.0003 [7] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-004%' ORDER BY pageTreePosition ASC
7.3177 0.0007 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
7.3179 0.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
7.3183 0.0004 Using template: /templates/navigation/right-col/level1.html
7.3184 0 [1] Using template: /templates/navigation/right-col/level2.html
7.3205 0.0021 Using template: /templates/pages/attributes/default.html
7.3205 0.0001 Using sub-template: /templates/pages/attributes/body_attributes.html
7.3206 0 Using sub-template: /templates/pages/attributes/seo.html
7.3206 0 Using sub-template: /templates/pages/attributes/facebook.html
7.3206 0 Using sub-template: /templates/pages/attributes/page_details.html
7.3208 0.0002 Using template: /templates/pages/attributes/default.html
7.3208 0.0001 Using sub-template: /templates/pages/attributes/body_attributes.html
7.3209 0 Using sub-template: /templates/pages/attributes/seo.html
7.3209 0 Using sub-template: /templates/pages/attributes/facebook.html
7.3209 0 Using sub-template: /templates/pages/attributes/page_details.html
7.3211 0.0002 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/about-us' OR pageSortPath='/about-us' LIMIT 1
7.3214 0.0003 [9] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
7.3222 0.0008 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
7.3225 0.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
7.3229 0.0004 Using template: /templates/navigation/footer/level1.html
7.3229 0 [1] Using template: /templates/navigation/footer/level2.html
7.324 0.0011 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conservation-work' OR pageSortPath='/conservation-work' LIMIT 1
7.3244 0.0003 [6] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
7.325 0.0006 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
7.3253 0.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
7.3257 0.0004 Using template: /templates/navigation/footer/level1.html
7.3257 0 [1] Using template: /templates/navigation/footer/level2.html
7.3266 0.0009 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/get-involved' OR pageSortPath='/get-involved' LIMIT 1
7.3269 0.0003 [5] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
7.3275 0.0006 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
7.3278 0.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
7.3282 0.0004 Using template: /templates/navigation/footer/level1.html
7.3282 0 [1] Using template: /templates/navigation/footer/level2.html
7.329 0.0007 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/mcht-publications' OR pageSortPath='/mcht-publications' LIMIT 1
7.3293 0.0003 [6] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
7.3299 0.0006 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
7.3301 0.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
7.3306 0.0004 Using template: /templates/navigation/footer/level1.html
7.3306 0 [1] Using template: /templates/navigation/footer/level2.html
7.3313 0.0008 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' OR pageSortPath='/visit-a-preserve' LIMIT 1
7.3317 0.0003 [5] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-004%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
7.3322 0.0005 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
7.3325 0.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
7.3329 0.0004 Using template: /templates/navigation/footer/level1.html
7.3329 0 [1] Using template: /templates/navigation/footer/level2.html
7.3336 0.0007 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Offices' AND (regionPage='/visit-a-preserve' OR regionPage='*')
7.3341 0.0005 [4] 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=1629 AND idx.itemRev=12)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
7.4119 0.0777 [1] Using template: /templates/content/global/locations-footer.html
7.4147 0.0028 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Messages' AND (regionPage='/visit-a-preserve' OR regionPage='*')
7.4152 0.0005 [nil] 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=1622 AND idx.itemRev=20)) AND ((idx.indexKey='show_until' AND idx.indexValue >= '2018-05-08 23:59:59')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
7.4171 0.0019 Using template: /templates/content/messages/_message_output.html
7.4173 0.0002
Array
(
[type] => 8
[message] => Undefined variable: content
[file] => /home/mchtorg/deploy.mcht.org/perch/templates/pages/preserve_jump.php
[line] => 18
)
Time Δ Debug Message - Perch Runway 3.1.1
0.0013 0 [106] 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.0068 0.0055 Matched page: /visit-a-preserve, so not using routes.
0.0069 0.0001 Using master page: /templates/pages/preserve_jump.php
0.0071 0.0001 [97] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
0.0088 0.0017 [1] SELECT * FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
0.0099 0.0011 [1] SELECT collectionID, collectionTemplate FROM perch2_collections WHERE collectionKey='Preserves'
0.0102 0.0004 [51] 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='_order' WHERE (idx.collectionID=1) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
2.2291 2.2188 [51] Using template: /templates/content/mapping.html
2.259 0.0299 [1] SELECT groupID FROM perch2_navigation WHERE groupSlug='main-navigation' LIMIT 1
2.2593 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 perch2_navigation_pages np, perch2_pages p WHERE p.pageID=np.pageID AND np.groupID=13 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
2.2599 0.0006 [1] SELECT np.pageTreePosition FROM perch2_pages p, perch2_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=13 AND p.pagePath='/visit-a-preserve' LIMIT 1
2.2605 0.0005 [1] SELECT pageID FROM perch2_navigation_pages WHERE groupID=13 AND pageTreePosition IN ('000-003', '000') ORDER BY pageTreePosition DESC
2.261 0.0005 [6] Using template: /templates/navigation/main_navigation.html
2.2618 0.0008 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' OR pageSortPath='/visit-a-preserve' LIMIT 1
2.2622 0.0004 [1] SELECT * FROM perch2_pages WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition
2.2627 0.0005 [1] Using template: /templates/navigation/breadcrumbs_ml.html
2.2632 0.0005 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Social Networks' AND (regionPage='/visit-a-preserve' OR regionPage='*')
2.2637 0.0005 [5] 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=1643 AND idx.itemRev=16)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
2.2685 0.0048 [5] Using template: /templates/content/global/social.html
2.2706 0.002 [8] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/visit-a-preserve' OR regionPage='*' ORDER BY regionPage DESC
2.2714 0.0008 [5] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'regions/southern-maine/%'))
2.2731 0.0017 [5] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (18, 25, 33, 43, 32) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
2.6017 0.3286 [5] Using template: /templates/content/preserves/region_listing.html
2.6028 0.0011 [21] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'regions/midcoast/%'))
2.6059 0.0031 [21] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (13, 15, 17, 21, 44, 38, 14, 97, 138, 139, 95, 156, 29, 31, 40, 336, 28, 20, 35, 469, 37) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
3.3344 0.7285 [21] Using template: /templates/content/preserves/region_listing.html
3.3376 0.0032 [17] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'regions/mount-desert-island/%'))
3.3403 0.0027 [17] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (41, 26, 34, 30, 12, 100, 98, 1, 24, 91, 22, 92, 101, 102, 96, 36, 19) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
3.9402 0.5999 [17] Using template: /templates/content/preserves/region_listing.html
3.9429 0.0026 [8] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'regions/downeast/%'))
3.9458 0.003 [8] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (42, 39, 94, 16, 23, 27, 99, 93) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
4.3197 0.3739 [8] Using template: /templates/content/preserves/region_listing.html
4.3211 0.0014 [19] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'preserve-attributes/camping/%'))
4.3236 0.0025 [19] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (32, 42, 17, 38, 14, 97, 100, 25, 43, 91, 336, 101, 102, 35, 469, 28, 41, 34, 96) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
5.0414 0.7178 [19] Using template: /templates/content/preserves/preserve_select.html
5.0445 0.0031 [14] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'preserve-attributes/hiking/%'))
5.0477 0.0031 [14] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (42, 30, 16, 23, 139, 95, 93, 24, 469, 39, 21, 44, 34, 27) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
5.9473 0.8997 [14] Using template: /templates/content/preserves/preserve_select.html
5.9496 0.0023 [18] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'preserve-attributes/birding/%'))
5.9522 0.0025 [18] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (30, 38, 138, 16, 23, 99, 1, 24, 43, 29, 31, 40, 39, 21, 156, 34, 36, 27) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
6.7049 0.7528 [18] Using template: /templates/content/preserves/preserve_select.html
6.7079 0.0029 [4] 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=1) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'preserve-attributes/exploring-history/%'))
6.7094 0.0015 [4] 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='title' WHERE (idx.collectionID=1) AND idx.itemID IN (42, 33, 39, 44) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
7.1523 0.4429 [4] Using template: /templates/content/preserves/preserve_select.html
7.1532 0.0009 [1] SELECT collectionID, collectionTemplate FROM perch2_collections WHERE collectionKey='Initiatives'
7.1536 0.0004 [8] 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='_order' WHERE (idx.collectionID=2) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
7.3074 0.1538 [8] Using template: /templates/content/initiative/_initiative_sitemap.html
7.3089 0.0015 [1] SELECT setID FROM perch2_category_sets WHERE setSlug='regions' LIMIT 1
7.3094 0.0005 [5] SELECT main.* FROM perch2_categories main WHERE 1=1 AND setID=7 ORDER BY catTreePosition ASC
7.3101 0.0007 [5] Using template: /templates/categories/regions_navigation.html
7.3109 0.0008 [1] SELECT setID FROM perch2_category_sets WHERE setSlug='preserve-attributes' LIMIT 1
7.3112 0.0003 [12] SELECT main.* FROM perch2_categories main WHERE 1=1 AND setID=9 ORDER BY catTreePosition ASC
7.3123 0.001 [12] Using template: /templates/categories/activity_navigation.html
7.3139 0.0017 [1] SELECT collectionID, collectionTemplate FROM perch2_collections WHERE collectionKey='Job'
7.3142 0.0003 [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='start' WHERE (idx.collectionID=6) AND ((idx.indexKey='expire' AND idx.indexValue >= '2018-05-08 23:59:59')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
7.3162 0.0019 Using template: /templates/content/_jobs_sitemap.html
7.3163 0.0002 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' OR pageSortPath='/visit-a-preserve' LIMIT 1
7.3167 0.0004 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pageTreePosition='000-004' LIMIT 1
7.317 0.0003 [7] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-004%' ORDER BY pageTreePosition ASC
7.3177 0.0007 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
7.3179 0.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
7.3183 0.0004 Using template: /templates/navigation/right-col/level1.html
7.3184 0 [1] Using template: /templates/navigation/right-col/level2.html
7.3205 0.0021 Using template: /templates/pages/attributes/default.html
7.3205 0.0001 Using sub-template: /templates/pages/attributes/body_attributes.html
7.3206 0 Using sub-template: /templates/pages/attributes/seo.html
7.3206 0 Using sub-template: /templates/pages/attributes/facebook.html
7.3206 0 Using sub-template: /templates/pages/attributes/page_details.html
7.3208 0.0002 Using template: /templates/pages/attributes/default.html
7.3208 0.0001 Using sub-template: /templates/pages/attributes/body_attributes.html
7.3209 0 Using sub-template: /templates/pages/attributes/seo.html
7.3209 0 Using sub-template: /templates/pages/attributes/facebook.html
7.3209 0 Using sub-template: /templates/pages/attributes/page_details.html
7.3211 0.0002 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/about-us' OR pageSortPath='/about-us' LIMIT 1
7.3214 0.0003 [9] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
7.3222 0.0008 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
7.3225 0.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
7.3229 0.0004 Using template: /templates/navigation/footer/level1.html
7.3229 0 [1] Using template: /templates/navigation/footer/level2.html
7.324 0.0011 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conservation-work' OR pageSortPath='/conservation-work' LIMIT 1
7.3244 0.0003 [6] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
7.325 0.0006 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
7.3253 0.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
7.3257 0.0004 Using template: /templates/navigation/footer/level1.html
7.3257 0 [1] Using template: /templates/navigation/footer/level2.html
7.3266 0.0009 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/get-involved' OR pageSortPath='/get-involved' LIMIT 1
7.3269 0.0003 [5] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
7.3275 0.0006 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
7.3278 0.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
7.3282 0.0004 Using template: /templates/navigation/footer/level1.html
7.3282 0 [1] Using template: /templates/navigation/footer/level2.html
7.329 0.0007 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/mcht-publications' OR pageSortPath='/mcht-publications' LIMIT 1
7.3293 0.0003 [6] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
7.3299 0.0006 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
7.3301 0.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
7.3306 0.0004 Using template: /templates/navigation/footer/level1.html
7.3306 0 [1] Using template: /templates/navigation/footer/level2.html
7.3313 0.0008 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' OR pageSortPath='/visit-a-preserve' LIMIT 1
7.3317 0.0003 [5] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-004%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
7.3322 0.0005 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/visit-a-preserve' LIMIT 1
7.3325 0.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
7.3329 0.0004 Using template: /templates/navigation/footer/level1.html
7.3329 0 [1] Using template: /templates/navigation/footer/level2.html
7.3336 0.0007 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Offices' AND (regionPage='/visit-a-preserve' OR regionPage='*')
7.3341 0.0005 [4] 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=1629 AND idx.itemRev=12)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
7.4119 0.0777 [1] Using template: /templates/content/global/locations-footer.html
7.4147 0.0028 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Messages' AND (regionPage='/visit-a-preserve' OR regionPage='*')
7.4152 0.0005 [nil] 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=1622 AND idx.itemRev=20)) AND ((idx.indexKey='show_until' AND idx.indexValue >= '2018-05-08 23:59:59')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
7.4171 0.0019 Using template: /templates/content/messages/_message_output.html
7.4173 0.0002
Array
(
[type] => 8
[message] => Undefined variable: content
[file] => /home/mchtorg/deploy.mcht.org/perch/templates/pages/preserve_jump.php
[line] => 18
)
7.4194 0.0021 Request time: 7.4194
7.4194 0 Process time: 7.4193
7.4194 0 Memory: 5.5657
7.4195 0
Array
(
[type] => 8
[message] => Undefined variable: content
[file] => /home/mchtorg/deploy.mcht.org/perch/templates/pages/preserve_jump.php
[line] => 18
)
Are you manually adding
PerchUtil::output_debug()to your template? You don't need to do that with Runway.Oh. Yes. I am. Thanks