test.

  1. Home
  2. test

2019/20 Season Series

451

4-Concert Season Package

Info

Variants

  • 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, $115/person

    4 Concerts, $130/person

    3 Concerts, $100/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.00060 [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.00430.0037Matched page: /test, so not using routes.
0.00430Using master page: /templates/pages/test_variant.php
0.00440.0001 [1] SELECT * FROM perch2_pages WHERE pagePath='/test' LIMIT 1
0.00490.0005 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020381
0.00520.0003 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020381
0.00550.0002 [nil] SELECT * FROM perch2_shop_sales WHERE saleFrom<='2026-01-12 17:13:00' AND saleTo>'2026-01-12 17:13:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
0.00650.0011Using template: /templates/pages/attributes/default.html
0.00660.0001Using sub-template: /templates/pages/attributes/seo.html
0.00660Using sub-template: /templates/pages/attributes/facebook.html
0.00670Using sub-template: /templates/pages/attributes/twitter.html
0.00670Using sub-template: /templates/pages/attributes/page_settings.html
0.00720.0004 [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.00810.0009 [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 12:13:13') OR (idx.indexKey='sell_from' AND idx.indexValue <= '2026-01-12 12:13:13')) 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.01230.0042 [68] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
0.0130.0007Using template: /templates/shop/products/products_navigation.html
0.01310.0001 [15] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
0.01360.0005 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/test' LIMIT 1
0.01390.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-020', '000') ORDER BY pageTreePosition DESC
0.01420.0003Using template: /templates/navigation/navigation-main.html
0.01420 [7] Using template: /templates/navigation/navigation-main-2.html
0.01520.001Using cart from cache.
0.01530Using template: /templates/shop/cart/mini.html
0.01580.0006Using template: /templates/pages/attributes/description.html
0.01610.0002 [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/')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
0.01650.0005 [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.0180.0015 [1] Using template: /templates/shop/products/2-column-listing_admin.html
0.01850.0005 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.01930.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.020.0007 [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.02040.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.02120.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.02150.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.02210.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.02240.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.02290.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.02320.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.02380.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.02410.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.0250.0009Using template: /templates/pages/attributes/default.html
0.02520.0002Using sub-template: /templates/pages/attributes/seo.html
0.02520.0001Using sub-template: /templates/pages/attributes/facebook.html
0.02530.0001Using sub-template: /templates/pages/attributes/twitter.html
0.02540.0001Using sub-template: /templates/pages/attributes/page_settings.html
0.02560.0002 [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.02630.0007 [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.02840.0021Using template: /templates/shop/products/list.html
0.02850.0001 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.02930.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.02970.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.030.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.03060.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.0310.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.03140.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.03170.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.03230.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.03250.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.03310.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.03340.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.03410.0007 [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.03470.0006 [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.03750.0029Using template: /templates/shop/products/list.html
0.03760.0001 [12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=464 AND productDeleted IS NULL ORDER BY productOrder ASC
0.03810.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.03850.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.03870.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.03910.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.03940.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.040.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.04050.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='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.04110.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.04150.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.04220.0007 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=471 AND productDeleted IS NULL ORDER BY productOrder ASC
0.0430.0008 [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.04350.0005 [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.04380.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.04450.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.04480.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='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.04540.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.04570.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.04630.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.04670.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='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.04730.0007 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=484 AND productDeleted IS NULL ORDER BY productOrder ASC
0.04790.0006 [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.04830.0005 [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.04870.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='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.04930.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.04960.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.05030.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.05060.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='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.05120.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.05160.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.05220.0007 [12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=489 AND productDeleted IS NULL ORDER BY productOrder ASC
0.0530.0007 [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.05340.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.05380.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='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.05440.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.05470.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='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.05530.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.05570.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.05630.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.05660.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='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.05740.0008------------------------------ A ------------------------------
0.05740 [1] SELECT * FROM perch2_shop_products WHERE productSlug='201920-season-series' AND productDeleted IS NULL LIMIT 1
0.0590.0016 [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.06490.0059 [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.06580.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.08590.0201 [24] Using template: /templates/shop/products/variant_list.html
0.08610.0002 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.08650.0005 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.0870.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.08750.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.08770.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.08820.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.08840.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.08910.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.08950.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.09020.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.09050.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.09110.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.09150.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.09240.0009 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.09280.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.09350.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.09410.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.09470.0006 [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.09540.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.09580.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.09640.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.09670.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.09730.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.09770.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.09830.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.09860.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.09960.001 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.10010.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.10080.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.10140.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.10180.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.10240.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.10290.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.10350.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.10390.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.10450.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.10490.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.10550.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.10580.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.10660.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.1070.0003 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.10750.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.10780.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.10810.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.10850.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.10880.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.10940.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.10980.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.11050.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.11090.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.11160.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.11190.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.1130.0011 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.11340.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.11420.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.11480.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.11520.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.11590.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.11630.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.11690.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.11730.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.11790.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.11820.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.11880.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.11910.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.11990.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.12050.0005 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.12120.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.12170.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.12210.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.12270.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.12310.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.12370.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.12410.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.12480.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.12510.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.12570.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.12610.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.1270.0009 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.12750.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.12810.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.12860.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.1290.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.12960.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.130.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.13060.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.1310.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.13160.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.1320.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.13260.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.13290.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.13380.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.13420.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.13490.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.13540.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.13580.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.13650.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.13690.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.13750.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.1380.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.13860.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.13890.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.13950.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.13990.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.14060.0007 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.14090.0003 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.14150.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.1420.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.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='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.14280.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.14320.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.14370.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.1440.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.14460.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.14490.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.14550.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.14580.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.14650.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.14690.0003 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.14750.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.14790.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.14820.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.14870.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.14910.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.14970.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.150.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.15060.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.15090.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.15150.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.15180.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.15270.0009 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.15310.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.15380.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.15440.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.15470.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.15530.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.15570.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.15690.0012 [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.15730.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.1580.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.15840.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.15930.0009 [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.15970.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.16060.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.16090.0003 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.16150.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.1620.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.16230.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.16280.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.16310.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.16370.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.1640.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.16460.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.16480.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.16510.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.16540.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.1660.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.16630.0003 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.1670.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.16750.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.16790.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.16850.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.16890.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.16950.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.16980.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.17050.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.17080.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.17140.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.17180.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.17260.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.1730.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.17370.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.17420.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.17460.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.17520.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.17550.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.17610.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.17640.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.1770.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.17740.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.17790.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.17830.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.1790.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.17940.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.18010.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.18060.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.18090.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.18160.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.1820.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.18260.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.18290.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.18350.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.18390.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.18450.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.18480.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.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.1860.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.18660.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.18710.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.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.18810.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.18850.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.18910.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.18940.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.190.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.19040.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.1910.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.19140.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.19220.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.19260.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.19330.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.19380.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.19410.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.19470.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.1950.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.19560.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.1960.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.19660.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.19690.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.19740.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.19780.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.19850.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.19890.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.19960.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.20.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.20030.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.20090.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.20120.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.20170.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.20210.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.20270.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.2030.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.20350.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.20380.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.20460.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.20510.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.20570.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.20620.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.20650.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.20710.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.20740.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.2080.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.20830.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.20880.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.20910.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.20970.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.210.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.21080.0007 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.21120.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.2120.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.21260.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.2130.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.21370.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.21420.0005 [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.21490.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.21520.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.21580.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.21610.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.21660.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.21690.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.21750.0006 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.21780.0003 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.21840.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.21890.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.21920.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.21970.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.22010.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.22060.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.22090.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.22150.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.22180.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.22230.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.22280.0005 [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.22380.0009 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.22420.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.22480.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.22530.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.22560.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.22620.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.22660.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.22720.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.22760.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.22820.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.22860.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.22910.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.22950.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.23030.0008 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.23070.0004 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.23140.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.23190.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.23220.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.23280.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.23320.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.23380.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.23410.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.23470.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.23510.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.23560.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.23590.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.23690.0009 [1] SELECT * FROM perch2_shop_products WHERE productID=451 AND productDeleted IS NULL LIMIT 1
0.23750.0006 [24] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=451 AND productDeleted IS NULL ORDER BY productOrder ASC
0.23810.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.23870.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.2390.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.23950.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.23980.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.24040.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.24070.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.24130.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.24150.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.24220.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.24250.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.24290.0005------------------------------ B ------------------------------
0.2430------------------------------ C ------------------------------
0.2430 [1] SELECT * FROM perch2_shop_products WHERE productSlug='2020seasonmini01' AND productDeleted IS NULL LIMIT 1
0.24370.0008 [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.24910.0054 [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.25010.0009 [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.26010.01Using template: /templates/shop/products/variant_list.html
0.26010------------------------------ D ------------------------------
0.26020.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.26070.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.26390.0032Using template: /templates/shop/products/list.html
0.26410.0001 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=563 AND productDeleted IS NULL ORDER BY productOrder ASC
0.26530.0012 [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.26570.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.2660.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.26640.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.26670.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.26730.0006 [12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=550 AND productDeleted IS NULL ORDER BY productOrder ASC
0.2680.0007 [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.26840.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.26870.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.26940.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.26970.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.27050.0008 [4] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=536 AND productDeleted IS NULL ORDER BY productOrder ASC
0.27080.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.27120.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.27150.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.27190.0004 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=541 AND productDeleted IS NULL ORDER BY productOrder ASC
0.27220.0004 [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.27250.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.27270.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='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.27310.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.27330.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='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.2740.0007 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Sponsors' AND (regionPage='/test' OR regionPage='*')
0.27440.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.27950.0051 [10] Using template: /templates/content/sponsors/_footer_logos.html
0.28040.0009Using template: /templates/mailchimp/subscribe_email_address.html
0.28080.0004 [7] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
0.28130.0005 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/test' LIMIT 1
0.28170.0005 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-020', '000') ORDER BY pageTreePosition DESC
0.28230.0006 [7] Using template: /templates/navigation/navigation-footer.html
0.28280.0005Using cart from cache.
0.28290Using template: /templates/shop/cart/your_cart.html
0.28310.0002 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Globals' AND (regionPage='/test' OR regionPage='*')
0.28350.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.2860.0025 [1] Using template: /templates/content/globals/_phone_number.html
0.28620.0003 [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.28760.0013 [1] Using template: /templates/content/globals/_email_address_main.html
0.2880.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.290.0021 [1] Using template: /templates/content/globals/_social_footer.html
0.29060.0005 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Messages' AND (regionPage='/test' OR regionPage='*')
0.2910.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 12:13:14') OR (idx.indexKey='show_until' AND idx.indexValue >= '2026-01-12 12:13:14') 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.29250.0015Using template: /templates/content/messages/_modal.html
0.29270.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.29350.0008Using template: /templates/content/messages/_message_output.html
0.29380.0003Request time: 0.2937
0.29380Process time: 0.2937
0.29380Memory: 2.0117
0.29380
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
)