Debug Message - Perch Runway 3.1.4 |
[43] 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 route: projects/[slug:projectSlug] |
Using master page: /templates/pages/project.php |
Page arguments: Array
(
[0] => /projects/weltenwandler-showreels
[projectSlug] => weltenwandler-showreels
[1] => weltenwandler-showreels
) |
[1] SELECT collectionID, collectionTemplate FROM perch3_collections WHERE collectionKey='Projects de' |
[1] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx
JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=5) AND ((idx.indexKey='projectSlug' AND idx.indexValue='weltenwandler-showreels')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC LIMIT 0, 1 |
Using template: /templates/content/project_components/project-main-lang.html |
[30] Using sub-template: /templates/content/project_components/project.html |
[1] SELECT * FROM perch3_collections WHERE collectionKey='Projects en' LIMIT 1 |
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=4
AND ci.itemRev=r.itemRev AND ci.itemID=153 |
[1] SELECT * FROM perch3_collections WHERE collectionKey='Kunden' LIMIT 1 |
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=8
AND ci.itemRev=r.itemRev AND ci.itemID=89 |
[1] SELECT * FROM perch3_collections WHERE collectionKey='Products' LIMIT 1 |
[15] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=10
AND ci.itemRev=r.itemRev AND ci.itemID IN (157, 158, 159, 160, 168, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179) ORDER BY r.itemOrder ASC |
[19] SELECT catID, catPath FROM perch3_categories |
[1] SELECT * FROM perch3_pages WHERE pagePath='/project.php' LIMIT 1 |
[1] SELECT collectionID, collectionTemplate FROM perch3_collections WHERE collectionKey='Projects en' |
[1] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx
JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=4) AND ((idx.indexKey='_id' AND idx.indexValue=153)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC |
[30] Using template: /templates/content/project_components/project.html |
[1] SELECT * FROM perch3_collections WHERE collectionKey='Kunden' LIMIT 1 |
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=8
AND ci.itemRev=r.itemRev AND ci.itemID=89 |
[1] SELECT * FROM perch3_collections WHERE collectionKey='Products' LIMIT 1 |
[15] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=10
AND ci.itemRev=r.itemRev AND ci.itemID IN (157, 158, 159, 160, 168, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179) ORDER BY r.itemOrder ASC |
[5] SELECT regionKey, regionHTML FROM perch3_content_regions
WHERE regionPage='/project.php' OR regionPage='*' ORDER BY regionPage DESC |
[18] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx
JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=5) AND ((idx.indexKey='externalLink' AND idx.indexValue='') OR (idx.indexKey='_order' AND idx.indexValue < 1033) OR (idx.indexKey='projectSlug' AND idx.indexValue != 'weltenwandler-showreels')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval HAVING count(*)=3 ORDER BY sortval DESC |
Using template: /templates/content/project_components/_prev.html |
[40] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx
JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=5) AND ((idx.indexKey='externalLink' AND idx.indexValue='') OR (idx.indexKey='projectSlug' AND idx.indexValue != 'weltenwandler-showreels')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval HAVING count(*)=2 ORDER BY sortval DESC |
Using template: /templates/content/project_components/_prev.html |
[21] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx
JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=5) AND ((idx.indexKey='_order' AND idx.indexValue > 1033) OR (idx.indexKey='externalLink' AND idx.indexValue='') OR (idx.indexKey='projectSlug' AND idx.indexValue != 'weltenwandler-showreels')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval HAVING count(*)=3 ORDER BY sortval ASC |
Using template: /templates/content/project_components/_next.html |
[40] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx
JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=5) AND ((idx.indexKey='externalLink' AND idx.indexValue='') OR (idx.indexKey='projectSlug' AND idx.indexValue != 'weltenwandler-showreels')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval HAVING count(*)=2 ORDER BY sortval ASC |
Using template: /templates/content/project_components/_next.html |
[40] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx
JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=5) AND ((idx.indexKey='externalLink' AND idx.indexValue='') OR (idx.indexKey='projectSlug' AND idx.indexValue != 'weltenwandler-showreels')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval HAVING count(*)=2 ORDER BY sortval ASC |
Using template: /templates/content/project_components/_prev.html |
[1] SELECT collectionID, collectionTemplate FROM perch3_collections WHERE collectionKey='Navigation' |
[7] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx
JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=14) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC |
[2] Using template: /templates/content/layout_components/navigation_components/navigation-item-home.html |
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/project.php' OR pageSortPath='/project.php' LIMIT 1 |
[2] SELECT * FROM perch3_pages WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-009-001', '000-009', '000') ORDER BY pageTreePosition |
[2] Using template: /templates/navigation/breadcrumbs.html |
[1] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx
JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=5) AND ((idx.indexKey='projectSlug' AND idx.indexValue='weltenwandler-showreels')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC LIMIT 0, 1 |
[30] Using template: /templates/content//project_components/project-detail.html |
[1] SELECT * FROM perch3_collections WHERE collectionKey='Kunden' LIMIT 1 |
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=8
AND ci.itemRev=r.itemRev AND ci.itemID=89 |
[1] SELECT * FROM perch3_collections WHERE collectionKey='Products' LIMIT 1 |
[15] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=10
AND ci.itemRev=r.itemRev AND ci.itemID IN (157, 158, 159, 160, 168, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179) ORDER BY r.itemOrder ASC |
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=8
AND ci.itemRev=r.itemRev AND ci.itemID=89 |
[3] SELECT * FROM perch3_categories ORDER BY catTreePosition ASC |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Related Headline' AND (regionPage='/project.php' 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=55 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] Using template: /templates/content//global_components/headline-text-full-width.html |
[4] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx
JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=5) AND ((idx.indexKey='projectSlug' AND idx.indexValue != 'weltenwandler-showreels')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC LIMIT 0, 4 |
[4] Using template: /templates/content//project_components/project-related.html |
[1] SELECT * FROM perch3_collections WHERE collectionKey='Kunden' LIMIT 1 |
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=8
AND ci.itemRev=r.itemRev AND ci.itemID=280 |
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=8
AND ci.itemRev=r.itemRev AND ci.itemID=156 |
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=8
AND ci.itemRev=r.itemRev AND ci.itemID=33 |
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r
WHERE r.itemID=ci.itemID AND ci.collectionID=8
AND ci.itemRev=r.itemRev AND ci.itemID=89 |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Cookiebanner' AND (regionPage='/project.php' 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=41 AND idx.itemRev=11)) 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/global_components/cookiebanner.html |
Request time: 1.653 |
Process time: 1.6526 |
Memory: 5.2337 |
Array
(
[type] => 8
[message] => Undefined index: news-title
[file] => /var/www/html/theme/global/navigation.php
[line] => 132
)
|