Forum

Thread tagged as: Problem

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
)
Monty Lewis

Monty Lewis 2 points

  • 3 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Are you manually adding PerchUtil::output_debug() to your template? You don't need to do that with Runway.

Oh. Yes. I am. Thanks