| Debug Message - Perch Runway 3.1.7 |
| [99] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline
FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline'
UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline
FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC |
| Matched page: /shop, so not using routes. |
| Using master page: /templates/pages/shop/shop.php |
| [1] SELECT * FROM perch3_pages WHERE pagePath='/shop' LIMIT 1 |
| [55] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0 |
| [1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1 |
| INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]') |
| [1] SELECT * FROM perch3_shop_cart WHERE cartID=1850491 |
| [1] SELECT * FROM perch3_shop_cart WHERE cartID=1850491 |
| [nil] SELECT * FROM perch3_shop_sales
WHERE saleFrom<='2025-09-23 13:54:00' AND saleTo>'2025-09-23 13:54:00' AND saleActive=1 AND saleDeleted IS NULL
ORDER BY saleOrder ASC |
| [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Contact Details' AND (regionPage LIKE '%' OR regionPage='*') |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] Using template: /templates/content/_contact_details/site_name.html |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] Using template: /templates/content/_contact_details/site_description.html |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] Using template: /templates/content/_contact_details/tel_only.html |
| Using template: /templates/pages/attributes/default.html |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] Using template: /templates/content/_contact_details/og_image.html |
| Using template: /templates/pages/attributes/og_image.html |
| ------------------------------ Calculating cart ------------------------------ |
| [1] SELECT * FROM perch3_shop_cart WHERE cartID=1850491 |
| [1] SELECT * FROM perch3_shop_cart WHERE cartID=1850491 |
| [1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1 |
| [1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1 |
| [1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1 |
| [1] SELECT * FROM perch3_shop_currencies WHERE currencyID=47 LIMIT 1 |
| [1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=1850491 |
| Tax mode: exc |
| [nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=1850491 ORDER BY itemID ASC |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] Using template: /templates/content/_contact_details/contact_address_schema.html |
| [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='I am looking for menu' AND (regionPage='/shop' OR regionPage='*') |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [6] Using template: /templates/content/_homepage/looking_for_menu.html |
| [51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
| [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop' LIMIT 1 |
| [1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012', '000') ORDER BY pageTreePosition DESC |
| Using template: /templates/navigation/main_nav.html |
| [10] Using template: /templates/navigation/sub_nav.html |
| [8] SELECT regionKey, regionHTML FROM perch3_content_regions
WHERE regionPage='/shop' OR regionPage='*' ORDER BY regionPage DESC |
| [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Shop Headlines' AND (regionPage='/shop' 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=8 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//_shop/shop_headlines.html |
| ------------------------------ Related Products ------------------------------ |
| [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Featured Products' AND (regionPage='/shop' 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=10 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 |
| [1] Using template: /templates/content//_products/featured_products.html |
| [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx
JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID'
JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' WHERE 1=1 AND ((idx.indexKey='productSlug' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC |
| [1] Using template: /templates/shop/products/views/product_block.html |
| [5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products
WHERE parentID=1 AND productDeleted IS NULL
ORDER BY productOrder ASC |
| [1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po
WHERE o.optionID=po.optionID AND po.productID=1
AND o.optionDeleted IS NULL
ORDER BY optionPrecendence ASC |
| [5] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode
FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL
ORDER BY valueOrder ASC |
| [5] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.*
FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov
WHERE pov.productID='1' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL
AND o.optionID='1'
ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC |
| [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx
JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID'
JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' WHERE 1=1 AND ((idx.indexKey='productSlug' AND idx.indexValue IN ('flood-defender-barrier-m3fdb'))) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC |
| [1] Using template: /templates/shop/products/views/product_block.html |
| Using template: /templates/shop/products/views/product_block.html |
| [1] SELECT * FROM perch3_categories WHERE catPath='products/domestic/' LIMIT 1 |
| [33] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/domestic/%' OR idx.indexKey='_category' AND idx.indexValue='products/domestic/')) |
| [25] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx
JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID'
JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='productOrder' AND idx.itemID IN ('31', '15', '50', '8', '49', '11', '52', '14', '10', '7', '56', '9', '59', '60', '30', '51', '61', '13', '25', '53', '12', '26', '27', '55', '54', '20', '16', '22', '19', '21', '23', '24', '1') WHERE 1=1 AND ((idx.indexKey='productSlug' AND idx.indexValue NOT IN ('anti-flood-airbrick-m3afa', 'flood-defender-barrier-m3fdb'))) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval * 1 ASC |
| [25] Using template: /templates/shop/products/views/product_block.html |
| [2] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products
WHERE parentID=56 AND productDeleted IS NULL
ORDER BY productOrder ASC |
| [1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po
WHERE o.optionID=po.optionID AND po.productID=56
AND o.optionDeleted IS NULL
ORDER BY optionPrecendence ASC |
| [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode
FROM perch3_shop_option_values WHERE optionID=5 AND valueDeleted IS NULL
ORDER BY valueOrder ASC |
| [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.*
FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov
WHERE pov.productID='56' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL
AND o.optionID='5'
ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC |
| [2] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products
WHERE parentID=16 AND productDeleted IS NULL
ORDER BY productOrder ASC |
| [1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po
WHERE o.optionID=po.optionID AND po.productID=16
AND o.optionDeleted IS NULL
ORDER BY optionPrecendence ASC |
| [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode
FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL
ORDER BY valueOrder ASC |
| [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.*
FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov
WHERE pov.productID='16' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL
AND o.optionID='2'
ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC |
| Using template: /templates/shop/products/views/product_block.html |
| [1] SELECT * FROM perch3_categories WHERE catPath='products/ici-commercial-flood-protection-solutions/' LIMIT 1 |
| [11] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/ici-commercial-flood-protection-solutions/%' OR idx.indexKey='_category' AND idx.indexValue='products/ici-commercial-flood-protection-solutions/')) |
| [9] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx
JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID'
JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='productOrder' AND idx.itemID IN ('15', '49', '11', '52', '14', '10', '9', '60', '51', '61', '12') WHERE 1=1 AND ((idx.indexKey='productSlug' AND idx.indexValue NOT IN ('anti-flood-airbrick-m3afa', 'flood-defender-barrier-m3fdb'))) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval * 1 ASC |
| [9] Using template: /templates/shop/products/views/product_block.html |
| [1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1 |
| [5] SELECT main.* FROM perch3_categories main WHERE 1=1 AND setID=1 ORDER BY catTreePosition ASC |
| [5] Using template: /templates/categories/products/product_categories_shop.html |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] Using template: /templates/content/_contact_details/site_name.html |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] Using template: /templates/content/_contact_details/tel_only_formatted.html |
| Using template: /templates/pages/attributes/hide_enquiry.html |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [13] Using template: /templates/content//_contact_details/accreditations.html |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] Using template: /templates/content//_contact_details/tel_email.html |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] Using template: /templates/content//_contact_details/address_only.html |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] Using template: /templates/content//_contact_details/address_only_repeater_limited.html |
| [10] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC |
| [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop' LIMIT 1 |
| [1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012', '000') ORDER BY pageTreePosition DESC |
| [10] Using template: /templates/navigation/nav_lis_only.html |
| [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/foot-links' OR pageSortPath='/foot-links' LIMIT 1 |
| [4] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-018%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
| [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop' LIMIT 1 |
| [1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012', '000') ORDER BY pageTreePosition DESC |
| [4] Using template: /templates/navigation/nav_lis_only.html |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [1] Using template: /templates/content//_contact_details/socials.html |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [6] Using template: /templates/content/_homepage/looking_for_menu.html |
| [51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
| [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop' LIMIT 1 |
| [1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012', '000') ORDER BY pageTreePosition DESC |
| Using template: /templates/navigation/main_nav.html |
| [10] Using template: /templates/navigation/sub_nav.html |
| [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
| [6] Using template: /templates/content/_homepage/looking_for_menu.html |
| [51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
| [1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop' LIMIT 1 |
| [1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012', '000') ORDER BY pageTreePosition DESC |
| Using template: /templates/navigation/main_nav.html |
| [10] Using template: /templates/navigation/sub_nav.html |
| Request time: 0.0816 |
| Process time: 0.0815 |
| Memory: 2.5062 |
Array
(
[type] => 8
[message] => Trying to access array offset on value of type null
[file] => /home/m3floodtec/webapps/m3floodtec-com/kpanel/addons/apps/pipit_catalog/runtime.php
[line] => 19
)
|
