BACK TO ALL EXPERIENCES

MAN’S BEST FRIEND

ANIMALS & PLANTS EXPERIENCE DAYS
We all know that animals and plants contribute to every part of our lives and ensure our very survival. In this collection we celebrate times where we give something back, caring for wild animals and generating plant life.

Your Interest

Working With Animals

We have been working with animals for over 30,000 years and that special bond is only strengthening. Work alongside a Keeper or Farmer and learn to care for animals such as Tigers and big cats, Goats and Ponies or Birds of Prey. You feel privileged to get to know them individually.
Browse the Bundle

Gardening At Famous Houses

We British love our gardens and it’s a passion that dates back through history. This is an opportunity to work alongside professional gardeners in some of the UK’s finest gardens. Explore famous historical houses and their gardens to learn new skills and discover rare plants from all over the world.
Browse the Bundle

Ancient Crafts

The word ‘Craft’ comes from the Middle English word for ‘strength’ or ‘skill’. Gain new strengths and skills by creating your own design metal work or wooden items for your home. Learn from traditional Blacksmiths or Wood Carvers to make beautiful objects by hand.
Browse the Bundle

Farm Life

Farm animals give us so much, whether it’s clothing, food and transport or companionship and devotion. If you’re looking to own farm animals such as Goats, Ponies, Sheep and Cattle or just want to get to know them better - this bundle is for you.
Browse the Bundle

Touch Wood

People have been making objects from wood from the earliest times and wood is still an important material today. Learn the joy and skill of carpentry, green woodworking or carving and create beautiful items for your home, whether it’s stools, chairs or cabinets or spoons using Nordic tools and techniques.
Browse the Bundle

Learn Survival Skills

You’re in decent shape and your phone has GPS but what happens if you’re injured or stranded and the batteries die? A chance to learn some key life skills if you find yourself without that digital crutch. We can survive up to six weeks without food but water and shelter are far more important. Learn these and other key survival skills.
Browse the Bundle

Apex Predators

Apex predators are animals at the top of their food chains with only humans as predators. Get close to and work with stunningly beautiful predators such as Tigers - amongst the most magnificent and endangered animals on Earth and walk with majestic birds of prey.
Browse the Bundle

The Coast is Clear

As an Island we are fortunate to have extraordinary coastal experiences. Did you know Britain’s coasts are the best places in the world for being calm enough to see amazing wildlife? You can experience this for yourself as you explore the coast on a Powerboat, scramble along it with Coasteering and ride high with the Surf.
Browse the Bundle

Live Off The Land

Experience the joys of living outdoors, learning to live like our ancestors and work with nature. Nature has sustained us for thousands of years. Find out about the wild plants around you and prepare delicious dishes or your own herbal remedies to take home.
Browse the Bundle
Latest Bundle

Live Off The Land

Experience the joys of living outdoors, learning to live like our ancestors and work with nature. Nature has sustained us for thousands of years. Find out about the wild plants around you and prepare delicious dishes or your own herbal remedies to take home.
Browse the Bundle
Debug Message - Perch Runway 3.0.11
[48] 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: [slug:category]
Using master page: /templates/pages/category.php
Page arguments:
Array
(
    [0] => /animals-and-plants
    [category] => animals-and-plants
    [1] => animals-and-plants
)
[1] SELECT * FROM perch3_pages WHERE pagePath='/category' LIMIT 1
[63] 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=141556
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141556
[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2019-10-18 04:03:00' AND saleTo>'2019-10-18 04:03:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='products/animals-and-plants/') ORDER BY catTreePosition ASC
Using template: /templates/categories/category.html
Rescoping to perch:category
Using sub-template: /templates/shop/products/product_tags.html
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='products/animals-and-plants/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_meta.html
Missing variant.
[63] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141556
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141556
[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=141556
Tax mode: inc
[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=141556 ORDER BY itemID ASC
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141556
[1] SELECT * FROM perch3_humdinger_vouchers WHERE voucherKey=NULL
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141556
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141556
[1] SELECT * FROM perch3_humdinger_vouchers WHERE voucherKey=NULL
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141556
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[104] SELECT main.* FROM perch3_categories main WHERE 1=1 AND setID=2 ORDER BY catTreePosition ASC
[104] Using template: /templates/categories/category_main_menu.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='filters' LIMIT 1
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND setID=3 ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/filter_menu.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='explore-main' LIMIT 1
[8] 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 perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=1 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=1 AND p.pagePath='/category' LIMIT 1
[8] Using template: /templates/navigation/list_item.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='my-experiences' LIMIT 1
[4] 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 perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=5 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=5 AND p.pagePath='/category' LIMIT 1
[4] Using template: /templates/navigation/list_item.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='explore-side' LIMIT 1
[4] 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 perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=2 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=2 AND p.pagePath='/category' LIMIT 1
[4] Using template: /templates/navigation/list_item.html
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='products/animals-and-plants/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_background.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[9] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=1) AND setID=2 ORDER BY catTreePosition ASC
[9] Using template: /templates/categories/category_icons.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[9] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=1 AND catPath NOT REGEXP '[[:<:]]extra[[:>:]]' AND catParentID=1) AND setID=2 ORDER BY catTreePosition ASC
Using template: /templates/categories/category.html
Rescoping to perch:category
Using sub-template: /templates/shop/products/product_tags.html
[9] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=1 AND catPath NOT REGEXP '[[:<:]]extra[[:>:]]' AND catParentID=1) ORDER BY catTreePosition ASC
[4] 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/animals-and-plants/working-with-animals/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/working-with-animals/'))
[4] 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='price' AND idx.itemID IN ('141', '1026', '132', '80') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[2] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=80 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=80 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] 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
[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='80' 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 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/animals-and-plants/gardening-at-famous-houses/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/gardening-at-famous-houses/'))
[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='price' AND idx.itemID IN ('133') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[2] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 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=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] 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
[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='133' 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
[3] 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/animals-and-plants/ancient-crafts/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/ancient-crafts/'))
[3] 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='price' AND idx.itemID IN ('758', '427', '420') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[2] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=420 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=420 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] 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
[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='420' 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 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/animals-and-plants/farm-life/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/farm-life/'))
[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='price' AND idx.itemID IN ('132') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[4] 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/animals-and-plants/touch-wood/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/touch-wood/'))
[4] 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='price' AND idx.itemID IN ('758', '826', '427', '759') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[1] 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/animals-and-plants/learn-survival-skills/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/learn-survival-skills/'))
[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='price' AND idx.itemID IN ('757') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[2] 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/animals-and-plants/apex-predators/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/apex-predators/'))
[2] 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='price' AND idx.itemID IN ('1026', '80') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[2] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=80 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=80 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] 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
[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='80' 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
[3] 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/animals-and-plants/the-coast-is-clear/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/the-coast-is-clear/'))
[3] 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='price' AND idx.itemID IN ('73', '202', '5') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[2] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=5 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=5 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] 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
[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='5' 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
[3] 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/animals-and-plants/live-off-the-land/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/live-off-the-land/'))
[3] 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='price' AND idx.itemID IN ('750', '748', '747') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[9] Using template: /templates/categories/category_list.html
[1] SELECT SQL_CALC_FOUND_ROWS DISTINCT main.* FROM perch3_categories main WHERE 1=1 AND (catPath NOT REGEXP '[[:<:]]extra[[:>:]]' AND catParentID!=0 AND catPath REGEXP '[[:<:]]animals-and-plants[[:>:]]') ORDER BY catID DESC LIMIT 0, 1
[9] SELECT FOUND_ROWS() AS `count`
[1] Using template: /templates/categories/recent_category.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer-info' LIMIT 1
[5] 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 perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=3 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=3 AND p.pagePath='/category' LIMIT 1
[5] Using template: /templates/navigation/list_item.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer-account' LIMIT 1
[4] 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 perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=4 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=4 AND p.pagePath='/category' LIMIT 1
[4] Using template: /templates/navigation/list_item.html
Request time: 0.6605
Process time: 0.6582
Memory: 3.5596