Announcing our 67th season

Season Subscriptions
available now
click here for individual tickets

The Concerts of our 68th Season.

From the New World and Beyond.

This season marks Yoichi Udagawa’s twentieth year as music director and conductor of Cape Ann Symphony. We have an exciting season planned. We hope you will be able to help us thank Yoichi for his contributions!

Classics and the Movies

Saturday, September 28, 2019, 7:30pm, Manchester-By-The-Sea

Sunday, September 29, 2019, 2:00pm, Ipswich

It’s a myth declared by some that Hollywood music can’t be classical. We present true classics used in movies as well as true contemporary classics created for Hollywood.

  • Wagner The Ride of the Valkyries
  • Prokofiev Lieutenant Kije
  • Rózsa Ben Hur Suite
  • Korngold Robin Hood Suite
Info

Holiday Pops

Saturday, November 30, 2019, 2:00pm, Ipswich

Saturday, November 30, 2019, 7:30pm, Manchester-By-The-Sea

Sunday, December 1, 2019, 2:00pm, Manchester-By-The-Sea

Expect lots of joy and fun as we celebrate the holidays with favorites by Anderson, Bach, Herbert, Tchaikovsky, Rutter, Handel and more. And with the Cape Ann Symphony Chorus directed by Wendy Betts. We will conclude with the ever popular audience sing-along.

Info

Mozart, Hayden, Brahms & Lewin

Sunday, March 22, 2020, 2:00pm, Manchester-By-The-Sea

Presenting the joyous, fun filled music of Mozart’s Overture to the Marriage of Figaro and Haydn’s delightful “Clock” Symphony.
We conclude with Brahms’ incredibly majestic, powerful, yet lyrical Piano Concerto No. 1 featuring virtuoso pianist Michael Lewin. If this doesn’t bring everyone out of their seats nothing will.

  • Mozart Marriage of Figaro Overture
  • Haydn Symphony No. 1 “Clock”
  • Brahms Piano Concerto No. 1, Michael Lewin, pianist
Info

Brahms, Dvořák & Déjardin

Saturday, May 16, 2020, 7:30pm, Manchester-By-The-Sea

Sunday, May 17, 2020, 2:00pm, Manchester-By-The-Sea

Brahms returns to us with his powerful Symphony No. 1 which he struggled for 14 years to complete. And we close the season with Dvořák’s gorgeous Cello Concerto featuring Blaise Déjardin, Principal Cellist of the Boston Symphony Orchestra.

  • BRAHMS Symphony No. 1
  • DVORAK Cello Concerto, Blaise Déjardin, Cello
Info

  • Take advantage of the savings offered in our season ticket packages


  • Select the concerts you would like to attend

    Please select 3 or more for subscription pricing

  • Take advantage of the savings offered in our season ticket packages

    2019/20 Season Series

    4 Concerts, $155/person

    3 Concerts, $/person

    4 Concerts, $130/person

    3 Concerts, $/person

    TOTAL ORDER $0

    Click select and proceed to date selection

  • TOTAL: $0

    Please select the dates you would like to attend

    2019 Fall Concert Dates

    2019 Holiday Concert Dates

    2020 Spring Concert Dates

    2020 May Concert Dates

  • Confirm your order

    If this looks correct, proceed to checkout.

    TOTAL $0
Time Δ Debug Message - Perch Runway 3.1.2
0.0480 [43] 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.05170.0037Matched page: /, so not using routes.
0.05170Using master page: /templates/pages/home_with_subscription.php
0.05840.0067 [1] SELECT * FROM perch2_pages WHERE pagePath='/' LIMIT 1
0.06440.006 [68] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
0.06530.0009 [1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.06570.0004INSERT INTO perch2_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',142,'standard','[]')
0.06730.0016 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020278
0.06760.0003 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020278
0.0680.0004 [nil] SELECT * FROM perch2_shop_sales WHERE saleFrom<='2026-01-12 15:24:00' AND saleTo>'2026-01-12 15:24:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
0.06910.001 [6] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/' OR regionPage='*' ORDER BY regionPage DESC
0.07010.001Using template: /templates/pages/attributes/default.html
0.07040.0003Using sub-template: /templates/pages/attributes/seo.html
0.07040.0001Using sub-template: /templates/pages/attributes/facebook.html
0.07050.0001Using sub-template: /templates/pages/attributes/twitter.html
0.07060.0001Using sub-template: /templates/pages/attributes/page_settings.html
0.07470.0041 [15] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/subscription-concert/%' OR idx.indexKey='_category' AND idx.indexValue='products/subscription-concert/') OR (idx.indexKey='_category' AND idx.indexValue LIKE 'products/2019-musicians-unleashed/%' OR idx.indexKey='_category' AND idx.indexValue='products/2019-musicians-unleashed/'))
0.07590.0011 [nil] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='sell_until' AND idx.itemID IN ('433', '436', '439', '229', '102', '106', '84', '95', '230', '231', '232', '550', '536', '541', '563') WHERE 1=1 AND ((idx.indexKey='sell_until' AND idx.indexValue >= '2026-01-12 10:24:04') OR (idx.indexKey='sell_from' AND idx.indexValue <= '2026-01-12 10:24:04')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval HAVING count(*)=2 ORDER BY sortval ASC
0.08150.0056Using template: /templates/shop/products/products_navigation.html
0.08170.0002 [15] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
0.08230.0007 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/' LIMIT 1
0.08290.0005 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC
0.08350.0006Using template: /templates/navigation/navigation-main.html
0.08360.0001 [7] Using template: /templates/navigation/navigation-main-2.html
0.08490.0013------------------------------ Calculating cart ------------------------------
0.08490 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020278
0.08740.0025 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020278
0.08840.001 [1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.08860.0002 [1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.08880.0002 [1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.08920.0004 [1] SELECT * FROM perch2_shop_currencies WHERE currencyID=142 LIMIT 1
0.08950.0003 [1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch2_shop_cart_items WHERE cartID=1020278
0.08980.0003Tax mode: exc
0.08990.0001 [nil] SELECT * FROM perch2_shop_cart_items WHERE cartID=1020278 ORDER BY itemID ASC
0.09070.0008Using template: /templates/shop/cart/mini.html
0.09090.0002 [4] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/20192020-subscription-concert/%' OR idx.indexKey='_category' AND idx.indexValue='products/20192020-subscription-concert/') OR (idx.indexKey='_category' AND idx.indexValue LIKE 'products/current-season/%' OR idx.indexKey='_category' AND idx.indexValue='products/current-season/'))
0.09160.0007 [4] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='sell_until' AND idx.itemID IN ('550', '536', '541', '563') WHERE 1=1 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
0.0980.0064 [4] Using template: /templates/shop/products/2-column-listing_front.html
0.09840.0003 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=563 AND productDeleted IS NULL ORDER BY productOrder ASC
0.09940.0011 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=563 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.10060.0012 [4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.10090.0003 [4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='563' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.10140.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.10160.0002 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='563' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.10210.0005 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.10250.0004 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.10320.0007 [6] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.10410.0009 [12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=550 AND productDeleted IS NULL ORDER BY productOrder ASC
0.10450.0004 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=550 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.10480.0003 [4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.1050.0002 [4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.10540.0004 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.10570.0002 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.10630.0007 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.10660.0003 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.10720.0005 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.10770.0005 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.10860.0008 [4] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=536 AND productDeleted IS NULL ORDER BY productOrder ASC
0.1090.0004 [1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=536 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.10940.0004 [4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.10970.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='536' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.11040.0007 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.11070.0003 [3] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.11180.0011 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=541 AND productDeleted IS NULL ORDER BY productOrder ASC
0.11240.0005 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=541 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.11280.0004 [4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.11310.0003 [4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='541' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.11370.0007 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.1140.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='541' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.11480.0007 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.11510.0003 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.11570.0006 [2] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.11780.0021Using template: /templates/pages/attributes/default.html
0.1180.0001Using sub-template: /templates/pages/attributes/seo.html
0.1180.0001Using sub-template: /templates/pages/attributes/facebook.html
0.11810.0001Using sub-template: /templates/pages/attributes/twitter.html
0.11820.0001Using sub-template: /templates/pages/attributes/page_settings.html
0.11850.0003 [1] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/201920-season-package/%' OR idx.indexKey='_category' AND idx.indexValue='products/201920-season-package/'))
0.11910.0006 [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='sell_until' AND idx.itemID IN ('451') WHERE 1=1 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
0.1210.0019Using template: /templates/shop/products/list.html
0.12110.0001 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.12170.0006 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.12220.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.12250.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.12310.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.12350.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.12410.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.12450.0004 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.1250.0005 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.12530.0002 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.12570.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.12590.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.12660.0006 [4] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/201920-season-package-mini/%' OR idx.indexKey='_category' AND idx.indexValue='products/201920-season-package-mini/'))
0.12750.0009 [4] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='sell_until' AND idx.itemID IN ('471', '484', '489', '464') WHERE 1=1 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
0.13150.004Using template: /templates/shop/products/list.html
0.13150.0001 [12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=464 AND productDeleted IS NULL ORDER BY productOrder ASC
0.13210.0005 [4] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=464 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.13240.0003 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=17 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.13270.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='464' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='17' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.13310.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.13340.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='464' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.13380.0004 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.13410.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='464' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.13450.0004 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.13480.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='464' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.13530.0005 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=471 AND productDeleted IS NULL ORDER BY productOrder ASC
0.13590.0006 [4] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=471 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.13620.0003 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=17 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.13640.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='471' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='17' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.13690.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.13710.0002 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='471' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.13760.0005 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.13790.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='471' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.13830.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.13870.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='471' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.13920.0005 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=484 AND productDeleted IS NULL ORDER BY productOrder ASC
0.13960.0004 [4] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=484 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.13990.0003 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=17 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.14020.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='484' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='17' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.14060.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.14090.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='484' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.14130.0005 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.14160.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='484' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.1420.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.14230.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='484' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.14280.0006 [12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=489 AND productDeleted IS NULL ORDER BY productOrder ASC
0.14350.0006 [4] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=489 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.14390.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=17 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.14420.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='489' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='17' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.14460.0004 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.14490.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='489' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.14540.0005 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.14570.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='489' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.14610.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.14630.0002 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='489' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.1470.0007 [1] SELECT * FROM perch2_shop_products WHERE productSlug='201920-season-series' AND productDeleted IS NULL LIMIT 1
0.14820.0012 [312] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='status' AND idx.indexValue='1')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
0.15320.0051 [38] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='parentID' AND idx.indexValue='')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
0.15410.0009 [24] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' AND idx.itemID IN ('141', '142', '143', '144', '145', '146', '147', '148', '195', '110', '201', '199', '200', '202', '203', '204', '205', '206', '191', '193', '187', '188', '190', '192', '194', '189', '196', '197', '198', '183', '184', '185', '186', '233', '234', '235', '242', '243', '244', '254', '258', '266', '267', '268', '269', '270', '271', '272', '273', '274', '275', '276', '277', '290', '291', '292', '293', '294', '295', '296', '297', '298', '299', '300', '301', '302', '303', '304', '305', '306', '307', '308', '309', '310', '311', '312', '313', '315', '316', '317', '318', '319', '320', '321', '322', '323', '324', '325', '326', '334', '335', '336', '337', '338', '339', '340', '341', '342', '343', '344', '345', '360', '361', '362', '363', '368', '369', '370', '371', '372', '373', '278', '279', '280', '281', '282', '283', '284', '285', '286', '289', '288', '287', '247', '250', '253', '264', '380', '381', '382', '383', '384', '385', '386', '387', '388', '389', '390', '391', '240', '241', '239', '252', '251', '249', '248', '403', '402', '401', '400', '398', '397', '396', '395', '394', '392', '393', '399', '257', '256', '255', '265', '263', '262', '261', '260', '259', '228', '236', '237', '238', '409', '410', '411', '412', '413', '414', '416', '417', '418', '419', '420', '421', '427', '426', '425', '424', '423', '422', '429', '430', '432', '431', '314', '327', '328', '329', '330', '331', '332', '333', '357', '356', '355', '354', '353', '352', '351', '350', '349', '348', '347', '346', '358', '364', '365', '366', '367', '359', '374', '375', '376', '377', '379', '378', '408', '415', '428', '174', '170', '171', '225', '226', '172', '227', '173', '175', '176', '177', '178', '179', '180', '181', '229', '245', '246', '404', '406', '407', '405', '440', '441', '442', '443', '444', '446', '230', '448', '449', '447', '445', '433', '436', '231', '439', '232', '450', '471', '484', '489', '451', '572', '573', '574', '575', '576', '577', '578', '579', '580', '581', '582', '583', '584', '585', '586', '587', '588', '589', '590', '591', '592', '593', '594', '595', '607', '606', '605', '604', '603', '602', '601', '600', '599', '598', '597', '596', '550', '464', '536', '541', '563') AND idx.itemID NOT IN ('207', '217', '224', '110', '233', '228', '314', '333', '358', '359', '408', '415', '428', '170', '229', '102', '106', '59', '84', '95', '230', '448', '449', '433', '436', '231', '439', '232', '450', '471', '484', '489', '451', '550', '464', '536', '541', '563') WHERE 1=1 AND ((idx.indexKey='parentID' AND idx.indexValue=451)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.17320.0192Using template: /templates/shop/products/variant_list.html
0.17330.0001 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.17370.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.17420.0005 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.17460.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.1750.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.17560.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.17590.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.17650.0007 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.17690.0004 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.17760.0007 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.17790.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.17840.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.17870.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.17930.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.17970.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.18030.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.18090.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.18120.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.18180.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.18220.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.18270.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.18310.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.18380.0007 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.18410.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.18470.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.1850.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.18560.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.1860.0005 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.18670.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.18720.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.18750.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.1880.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.18840.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.18890.0005 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.18920.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.18980.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.19010.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.19070.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.1910.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.19160.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.1920.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.19270.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.19320.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.19350.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.19410.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.19440.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.1950.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.19530.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.19590.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.19620.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.19670.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.1970.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.19760.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.1980.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.19870.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.19920.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.19950.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.20020.0007 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.20050.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.20110.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.20140.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.2020.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.20240.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.20290.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.20320.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.20370.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.20410.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.20480.0006 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.20520.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.20560.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.20610.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.20640.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.2070.0005 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.20730.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.20790.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.20820.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.20870.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.20910.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.20960.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.210.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.21070.0006 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.21120.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.21150.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.21210.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.21240.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.2130.0005 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.21330.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.21390.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.21420.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.21470.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.21510.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.21570.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.2160.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.21670.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.21720.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.21750.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.2180.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.21840.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.21890.0005 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.21920.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.21980.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.22010.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.22070.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.2210.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.22160.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.22210.0005 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.22290.0008 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.22350.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.22390.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.22450.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.22480.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.22550.0007 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.22580.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.22640.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.22670.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.22730.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.22760.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.22820.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.22860.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.22930.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.22970.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.230.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.23090.0008 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.23120.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.23180.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.23220.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.23280.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.23310.0004 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.23370.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.23410.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.23480.0007 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.23520.0005 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.2360.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.23650.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.23680.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.23740.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.23770.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.23830.0005 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.23870.0004 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.23910.0004 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.23930.0002 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.23970.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.23990.0002 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.24030.0004 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.24070.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.24120.0005 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.24160.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.24180.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.24230.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.24250.0002 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.24290.0004 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.24310.0002 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.24350.0004 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.24380.0002 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.24440.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.24470.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.24520.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.24560.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.24630.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.24680.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.24720.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.24770.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.24810.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.24860.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.2490.0004 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.24960.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.24990.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.25050.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.25080.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.25150.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.25190.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.25260.0008 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.25310.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.25350.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.25410.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.25440.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.2550.0005 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.25530.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.25590.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.25620.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.25670.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.2570.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.25760.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.2580.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.25860.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.25920.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.25960.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.26010.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.26040.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.2610.0005 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.26130.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.26190.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.26220.0004 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.26280.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.26310.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.26370.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.26410.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.26470.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.26520.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.26550.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.26610.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.26650.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.2670.0005 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.26730.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.26790.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.26820.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.26870.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.2690.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.26960.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.27010.0005 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.27090.0008 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.27140.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.27170.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.27230.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.27260.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.27320.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.27360.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.27410.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.27450.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.2750.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.27530.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.27590.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.27630.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.27690.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.27740.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.27770.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.27830.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.27870.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.27920.0005 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.27960.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.28010.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.28050.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.28110.0007 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.28150.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.28210.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.28260.0005 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.28350.0009 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.28410.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.28450.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.28510.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.28540.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.28610.0007 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.28650.0004 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.28760.0011 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.2880.0004 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.28880.0007 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.28920.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.28990.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.29040.0005 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.2910.0006 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.29140.0003 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.29160.0002 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.29220.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.29260.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.29320.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.29350.0004 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.29410.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.29450.0004 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.29510.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.29550.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.29610.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.29650.0005 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.29720.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.29780.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.29810.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.29870.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.29910.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.29970.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.30.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.30070.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.3010.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.30160.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.3020.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.30260.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.30310.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.30380.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.30430.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.30460.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.30520.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.30550.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.30610.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.30650.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.30710.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.30740.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.3080.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.30830.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.30890.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.30930.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.310.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.31050.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.31080.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.31150.0007 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.31190.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.31250.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.31280.0004 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.31350.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.31380.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.31440.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.31470.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.31530.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.31570.0005 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.31650.0007 [5] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=451 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.31690.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=25 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.31730.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='25' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.31790.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.31820.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.31890.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.31920.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.31980.0006 [1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=21 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.32010.0003 [1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='21' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.32080.0007 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.32110.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='451' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.32260.0014 [1] SELECT * FROM perch2_shop_products WHERE productSlug='2020seasonmini01' AND productDeleted IS NULL LIMIT 1
0.3240.0014 [312] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='status' AND idx.indexValue='1')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
0.32910.0051 [38] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='parentID' AND idx.indexValue='')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
0.32990.0008 [nil] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' AND idx.itemID IN ('141', '142', '143', '144', '145', '146', '147', '148', '195', '110', '201', '199', '200', '202', '203', '204', '205', '206', '191', '193', '187', '188', '190', '192', '194', '189', '196', '197', '198', '183', '184', '185', '186', '233', '234', '235', '242', '243', '244', '254', '258', '266', '267', '268', '269', '270', '271', '272', '273', '274', '275', '276', '277', '290', '291', '292', '293', '294', '295', '296', '297', '298', '299', '300', '301', '302', '303', '304', '305', '306', '307', '308', '309', '310', '311', '312', '313', '315', '316', '317', '318', '319', '320', '321', '322', '323', '324', '325', '326', '334', '335', '336', '337', '338', '339', '340', '341', '342', '343', '344', '345', '360', '361', '362', '363', '368', '369', '370', '371', '372', '373', '278', '279', '280', '281', '282', '283', '284', '285', '286', '289', '288', '287', '247', '250', '253', '264', '380', '381', '382', '383', '384', '385', '386', '387', '388', '389', '390', '391', '240', '241', '239', '252', '251', '249', '248', '403', '402', '401', '400', '398', '397', '396', '395', '394', '392', '393', '399', '257', '256', '255', '265', '263', '262', '261', '260', '259', '228', '236', '237', '238', '409', '410', '411', '412', '413', '414', '416', '417', '418', '419', '420', '421', '427', '426', '425', '424', '423', '422', '429', '430', '432', '431', '314', '327', '328', '329', '330', '331', '332', '333', '357', '356', '355', '354', '353', '352', '351', '350', '349', '348', '347', '346', '358', '364', '365', '366', '367', '359', '374', '375', '376', '377', '379', '378', '408', '415', '428', '174', '170', '171', '225', '226', '172', '227', '173', '175', '176', '177', '178', '179', '180', '181', '229', '245', '246', '404', '406', '407', '405', '440', '441', '442', '443', '444', '446', '230', '448', '449', '447', '445', '433', '436', '231', '439', '232', '450', '471', '484', '489', '451', '572', '573', '574', '575', '576', '577', '578', '579', '580', '581', '582', '583', '584', '585', '586', '587', '588', '589', '590', '591', '592', '593', '594', '595', '607', '606', '605', '604', '603', '602', '601', '600', '599', '598', '597', '596', '550', '464', '536', '541', '563') AND idx.itemID NOT IN ('207', '217', '224', '110', '233', '228', '314', '333', '358', '359', '408', '415', '428', '170', '229', '102', '106', '59', '84', '95', '230', '448', '449', '433', '436', '231', '439', '232', '450', '471', '484', '489', '451', '550', '464', '536', '541', '563') WHERE 1=1 AND ((idx.indexKey='parentID' AND idx.indexValue=464)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.34140.0114Using template: /templates/shop/products/variant_list.html
0.34150.0001 [4] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/20192020-subscription-concert/%' OR idx.indexKey='_category' AND idx.indexValue='products/20192020-subscription-concert/'))
0.3420.0005 [4] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='sell_until' AND idx.itemID IN ('550', '536', '541', '563') WHERE 1=1 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
0.34510.0032Using template: /templates/shop/products/list.html
0.34530.0002 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=563 AND productDeleted IS NULL ORDER BY productOrder ASC
0.34570.0004 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=563 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.34620.0005 [4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.34650.0003 [4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='563' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.34690.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.34720.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='563' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.34770.0005 [12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=550 AND productDeleted IS NULL ORDER BY productOrder ASC
0.34850.0008 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=550 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.34890.0005 [4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.34930.0003 [4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.34990.0006 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.35020.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.35090.0007 [4] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=536 AND productDeleted IS NULL ORDER BY productOrder ASC
0.35140.0006 [1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=536 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.35180.0004 [4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.35220.0003 [4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='536' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.35290.0008 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=541 AND productDeleted IS NULL ORDER BY productOrder ASC
0.35360.0006 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=541 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.3540.0004 [4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.35430.0003 [4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='541' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.35490.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.35530.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='541' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.3570.0017 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Sponsors' AND (regionPage='/' OR regionPage='*')
0.35740.0004 [10] 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=18 AND idx.itemRev=24)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.36380.0063 [10] Using template: /templates/content/sponsors/_footer_logos.html
0.36610.0023Using template: /templates/mailchimp/subscribe_email_address.html
0.36930.0032 [7] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
0.36980.0005 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/' LIMIT 1
0.36990.0002 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC
0.37030.0003 [7] Using template: /templates/navigation/navigation-footer.html
0.37050.0002Using cart from cache.
0.37060Using template: /templates/shop/cart/your_cart.html
0.37070.0001 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Globals' AND (regionPage='/' OR regionPage='*')
0.3710.0004 [1] 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=21 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.37220.0012 [1] Using template: /templates/content/globals/_phone_number.html
0.37240.0001 [1] 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=21 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.37450.0021 [1] Using template: /templates/content/globals/_email_address_main.html
0.37480.0004 [1] 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=21 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.37610.0013 [1] Using template: /templates/content/globals/_social_footer.html
0.37690.0007 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Messages' AND (regionPage='/' OR regionPage='*')
0.37720.0004 [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=81 AND idx.itemRev=4)) AND ((idx.indexKey='start_date' AND idx.indexValue <= '2026-01-12 10:24:04') OR (idx.indexKey='show_until' AND idx.indexValue >= '2026-01-12 10:24:04') OR (idx.indexKey='showModal' AND idx.indexValue='true')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID HAVING count(*)=3 ORDER BY sortval ASC
0.3780.0008Using template: /templates/content/messages/_modal.html
0.37820.0002 [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=81 AND idx.itemRev=4)) AND ((idx.indexKey='show_until' AND idx.indexValue >= '2026-01-12 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
0.3790.0008Using template: /templates/content/messages/_message_output.html
0.37910.0001Request time: 0.3791
0.37920Process time: 0.3787
0.37920Memory: 4.0787
0.37920
Array
(
    [type] => 8192
    [message] => implode(): Passing glue string after array is deprecated. Swap the parameters
    [file] => /home/capeannsymphony/dev.capeannsymphony.org/perch/core/apps/content/PerchContent.class.php
    [line] => 352
)