Shop shipping zone not updating

When I try to edit billing and shipping addresses during checkout process (perch_shop_edit_address_form(1234)), addresses update in the database however the shipping zone doesn't change when editing the country. Shipping options remain the same. I have 2 shipping zones (UK and Ireland) with UK being set as a default. Diagnostics on my checkout page indicates Using shipping opts from cache. and Using shipping zone from cache. after trying to change the country from UK to Ireland. Everything is up-to-date.

Under what circumstances is it possible to change the shipping address country which then allows the correct zone (and consequent options) to be shown?

Thanks.

Runway 3 Diagnostics:

Perch Runway: 3.0.2
Production mode: Development (10)
Installed apps: content (3.0.2), assets (3.0.2), categories (3.0.2), perch_forms (1.9), perch_gallery (2.8.9), perch_shop_orders (1.1), perch_shop_products (1.1), chirp_seo (1), perch_shop (1.1), perch_comments (1.2.1), perch_members (1.6.1), perch_mailchimp (3.1)
DB driver: PDO
DB tables: perch2_backup_plans (0), perch2_backup_resources (0), perch2_backup_runs (0), perch2_categories (11), perch2_category_counts (0), perch2_category_sets (1), perch2_chirp_seo (1), perch2_collection_index (40), perch2_collection_items (8), perch2_collection_revisions (4), perch2_collections (0), perch2_comments (0), perch2_comments_votes (0), perch2_content_index (569), perch2_content_items (215), perch2_content_locks (0), perch2_content_regions (23), perch2_forms (2), perch2_forms_responses (2), perch2_gallery_albums (6), perch2_gallery_image_versions (714), perch2_gallery_images (119), perch2_mailchimp_campaigns (0), perch2_mailchimp_imports (0), perch2_mailchimp_lists (1), perch2_mailchimp_subscribers (69), perch2_mailchimp_subscriptions (71), perch2_mailchimp_webhooks (1), perch2_members (71), perch2_members_forms (1), perch2_members_member_tags (0), perch2_members_sessions (4), perch2_members_tags (0), perch2_menu_items (17), perch2_navigation (0), perch2_navigation_pages (0), perch2_page_routes (7), perch2_page_templates (21), perch2_pages (16), perch2_resource_log (510), perch2_resource_tags (0), perch2_resources (144), perch2_resources_to_tags (0), perch2_settings (41), perch2_shop_addresses (142), perch2_shop_admin_index (102), perch2_shop_brands (8), perch2_shop_cart (1273), perch2_shop_cart_data (190), perch2_shop_cart_items (103), perch2_shop_countries (250), perch2_shop_currencies (152), perch2_shop_customers (71), perch2_shop_emails (1), perch2_shop_index (565), perch2_shop_option_values (0), perch2_shop_options (0), perch2_shop_order_items (0), perch2_shop_order_promotions (0), perch2_shop_order_statuses (9), perch2_shop_orders (0), perch2_shop_orders_meta (1), perch2_shop_product_files (0), perch2_shop_product_option_values (0), perch2_shop_product_options (0), perch2_shop_product_tags (0), perch2_shop_products (3), perch2_shop_promotions (0), perch2_shop_search (3), perch2_shop_shipping_zone_countries (3), perch2_shop_shipping_zones (2), perch2_shop_shippings (3), perch2_shop_tax_exhibits (0), perch2_shop_tax_group_rates (1), perch2_shop_tax_groups (1), perch2_shop_tax_locations (1), perch2_shop_tax_rates (1), perch2_shop_variants (6), perch2_user_passwords (1), perch2_user_privileges (78), perch2_user_role_privileges (23), perch2_user_roles (2), perch2_users (2)
Users: 2
App runtimes:
<?php
    $apps_list = array(
        'perch_members',
        'perch_shop',
        'perch_forms',
        'perch_mailchimp',
        'perch_gallery',
        'perch_comments',
        'chirp_seo'
    );
Scheduled tasks for perch_comments: delete_spam_comments (1440 mins)
Scheduled tasks for perch_mailchimp: import_data (1 mins)
Editor plug-ins:
H1: c80ca109caff299553e99f2fd257bdba
L1: 45f1adfe02a3a4d1a863b7793c677f10
F1: 0c66c2e1f82f9e0b7617b2cb8270f2c7
headerColour: #f5aa25
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 1
content_collapseList: 1
lang: en-gb
update_2.8.31: done
latest_version:
on_sale_version:
headerScheme: light
perch_gallery_bucket_mode: dynamic
perch_gallery_bucket: gallery
perch_mailchimp_api_key: 4630ebc97c5037e8c31d8d22e1bde96f-us14
perch_mailchimp_campaign_url: /404/
perch_members_login_page: /members/login.php?r={returnURL}
perch_shop_price_tax_mode: inc
perch_shop_site_url: https://crosskeys.dev
perch_shop_invoice_number_format: Invoice%d
dashboard: 0
hide_pwd_reset: 1
content_hideNonEditableRegions: 1
content_frontend_edit: 0
perch_gallery_basicUpload: 0
logoPath: /modify/resources/crosskeys-logo.svg
perch_gallery_update: 2.8.5
perch_shop_update: 1.1
perch_members_update: 1.4
perch_mailchimp_secret: deacab8
perch_comments_akismet_key:
perch_comments_max_spam_days: 0
update_runway_2.8.32: done
perch_shop_trade_price_tax_mode: exc
perch_shop_default_currency: 47
perch_shop_reporting_currency: 47
perch_shop_product_url: /shop/{slug}/{slug}/{sku}/
update_runway_3.0: done
siteOffline: 0
chirp_seo_license_key: GQVBC-OTJIK-O060F-FVEZI
update_runway_3.0.2: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: root
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: pixelmod_ckinn
PERCH_DB_PREFIX: perch2_
PERCH_TZ: UTC
PERCH_EMAIL_FROM: 
PERCH_EMAIL_FROM_NAME: 
PERCH_LOGINPATH: /modify
PERCH_PATH: /*redacted*//root/modify
PERCH_CORE: /*redacted*//root/modify/core
PERCH_RESFILEPATH: /*redacted*//root/modify/resources
PERCH_RESPATH: /modify/resources
PERCH_SCHEDULE_SECRET: /*redacted*/
PERCH_SITEPATH: /*redacted*//root
PERCH_HTML5: 1
PERCH_DEBUG: 1
PERCH_PRODUCTION_MODE: 10
PERCH_RUNWAY: 1
PERCH_ERROR_MODE: DIE
PERCH_DATE_LONG: %d %B %Y
PERCH_DATE_SHORT: %d %b %Y
PERCH_TIME_SHORT: %H:%M
PERCH_TIME_LONG: %H:%M:%S
PERCH_RUNWAY_ROUTED:
PERCH_STRONG_PASSWORDS:
PERCH_ASSET_VERSION: ed79f7a54b300ef2b1e6
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /*redacted*//root/modify/templates
PERCH_TEMPLATE_FILTERS:
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_XHTML_MARKUP:
PERCH_RWD: 1
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_STRIPSLASHES:
PERCH_PROGRESSIVE_FLUSH: 1
PERCH_PARANOID:
PERCH_FORCE_SECURE_COOKIES:
PERCH_DEFAULT_BUCKET: default
PERCH_TRANSLATION_ASSIST:
PERCH_PASSWORD_MIN_LENGTH: 6
PERCH_MAX_FAILED_LOGINS: 10
PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
PERCH_VERIFY_UPLOADS:
PERCH_PRIV_ASSIST:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: markdown
PERCH_SHOP_VERSION: 1.1
Hosting settings

PHP: 5.6.30
Zend: 2.6.0
OS: Darwin
SAPI: apache2handler
Safe mode: not detected
MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
MySQL server: 5.6.35
Free disk space: 12.38 GB
Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, gd, SPL, iconv, intl, json, ldap, mbstring, session, standard, mysqlnd, mysqli, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, mysql, SimpleXML, soap, sockets, exif, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, apache2handler, imap, gettext, mcrypt, pgsql, pdo_pgsql, igbinary, memcached, mhash
GD: Yes
ImageMagick: No
PHP max upload size: 32M
PHP max form post size: 32M
PHP memory limit: 128M
Total max uploadable file size: 32M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: Yes
HTTPS: on
SSL_TLS_SNI: crosskeys.dev
SSL_SERVER_S_DN_C: UK
SSL_SERVER_S_DN_ST: /*redacted*/
SSL_SERVER_S_DN_L: /*redacted*/
SSL_SERVER_S_DN_O: /*redacted*/
SSL_SERVER_S_DN_CN: /*redacted*/
SSL_SERVER_S_DN_Email: /*redacted*/
SSL_SERVER_I_DN_C: UK
SSL_SERVER_I_DN_ST: /*redacted*/
SSL_SERVER_I_DN_L: /*redacted*/
SSL_SERVER_I_DN_O: /*redacted*/
SSL_SERVER_I_DN_CN: /*redacted*/
SSL_SERVER_I_DN_Email: /*redacted*/
SSL_VERSION_INTERFACE: mod_ssl/2.2.31
SSL_VERSION_LIBRARY: OpenSSL/1.0.2j
SSL_PROTOCOL: TLSv1.2
SSL_SECURE_RENEG: true
SSL_COMPRESS_METHOD: NULL
SSL_CIPHER: ECDHE-RSA-AES256-GCM-SHA384
SSL_CIPHER_EXPORT: false
SSL_CIPHER_USEKEYSIZE: 256
SSL_CIPHER_ALGKEYSIZE: 256
SSL_CLIENT_VERIFY: NONE
SSL_SERVER_M_VERSION: 1
SSL_SERVER_M_SERIAL: BC7E3396F86B8E74
SSL_SERVER_V_START: Mar 11 01:22:58 2017 GMT
SSL_SERVER_V_END: Mar 9 01:22:58 2027 GMT
SSL_SERVER_S_DN: /*redacted*/
SSL_SERVER_I_DN: /*redacted*/
SSL_SERVER_A_KEY: rsaEncryption
SSL_SERVER_A_SIG: sha1WithRSAEncryption
SSL_SESSION_ID: 63A0C4BD5FB4A6792EA131260DA29A9D409C600849A28EA16F37D8239AEE60BE
HTTP_HOST: /*redacted*/
HTTP_ACCEPT_ENCODING: gzip, deflate
HTTP_COOKIE: __utma=258655320.1604131853.1472088318.1492515424.1492643792.50; __utmz=258655320.1472088318.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); PHPSESSID=1c695b7b2672f420059ca89360d6ba23; cmsa=1
HTTP_CONNECTION: keep-alive
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/603.1.30 (KHTML, like Gecko) Version/10.1 Safari/603.1.30
HTTP_ACCEPT_LANGUAGE: en-gb
HTTP_REFERER: https://redacted/modify/core/settings/diagnostics/
HTTP_DNT: 1
PATH: /usr/bin:/bin:/usr/sbin:/sbin
SERVER_SOFTWARE: Apache
SERVER_NAME: crosskeys.dev
SERVER_ADDR: ::1
SERVER_PORT: 443
REMOTE_ADDR: ::1
DOCUMENT_ROOT: /*redacted*/
SERVER_ADMIN: you@example.com
SCRIPT_FILENAME: /*redacted*//root/modify/core/settings/diagnostics/index.php
REMOTE_PORT: 60946
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /modify/core/settings/diagnostics/?extended
SCRIPT_NAME: /modify/core/settings/diagnostics/index.php
PHP_SELF: /modify/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1493229044.84
REQUEST_TIME: 1493229044
argc: 1

Template being used to edit addresses: /templates/shop/addresses/edit.html

<perch:form id="address" method="post" app="perch_shop" class="edit-address">
    <fieldset>
        <div class="large-6 columns">
            <perch:label for="first_name">First name</perch:label>
            <perch:input type="text" id="first_name" required="true" label="First name" placeholder="First name *" />
            <perch:error for="first_name" type="required"><small>Please add your name</small></perch:error>
    </div>
    <div class="large-6 columns">
            <perch:label for="last_name">Last name</perch:label>
            <perch:input type="text" id="last_name" required="true" label="Last name" placeholder="Last name *" />
            <perch:error for="last_name" type="required"><small>Please add your name</small></perch:error>
    </div>
    <div class="large-12 columns">
            <perch:label for="address_1">Address 1</perch:label>
            <perch:input type="text" id="address_1" required="true" label="Address 1" placeholder="Address 1 *" />
            <perch:error for="address_1" type="required"><small>Please add the first line of your billing address</small></perch:error>

            <perch:label for="address_2">Address 2</perch:label>
            <perch:input type="text" id="address_2" label="Address 2" placeholder="Address 2" />
    </div>
    <div class="large-6 columns">
            <perch:label for="postcode">Postcode</perch:label>
            <perch:input type="text" id="postcode" label="Postcode" placeholder="Postcode" />
    </div>
    <div class="large-6 columns">
            <perch:label for="city">Town / City</perch:label>
            <perch:input type="text" id="city" required="true" label="Town / City" placeholder="Town / City *" />
            <perch:error for="city" type="required"><small>Please add the city</small></perch:error>
    </div>
    <div class="large-6 columns">
            <perch:label for="county">County / State</perch:label>
            <perch:input type="text" id="county" required="true" label="County / State" placeholder="County / State *" />
            <perch:error for="county" type="required"><small>Please add the county or region</small></perch:error>
    </div>
    <div class="large-6 columns">
            <perch:label for="country">Country</perch:label>
            <perch:input type="select" options="<perch:shop id="country_list" />" value="236" id="country" label="Country" />
    </div>
    </fieldset>    
    <div class="continue">
        <a class="button remove" href="/shop/checkout">Cancel</a> <perch:input type="submit" value="Update" class="button" />
        <perch:input type="hidden" id="addressID" />
        <perch:input type="hidden" id="r" value="/shop/addresses" />
    </div>
</perch:form>

Checkout page diagnostics:

Time    Δ   Debug Message - Perch Runway 3.0.2
0.066   0   [19] 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.0703  0.0043  Matched page: /shop/checkout, so not using routes.
0.0704  0.0001  Using master page: /templates/pages/shop/checkout.php
0.0722  0.0017  [1] SELECT * FROM perch2_members_sessions WHERE sessionID='6c8baa0a5e0f653cd0fd3898a1f5b27815c22420' AND sessionHttpFootprint='568a433c0590f9d192764a925c09da6b3e3edb56' AND sessionExpires>'2017-04-26 16:33:18' LIMIT 1
0.0732  0.001   User is logged in
0.0779  0.0048  [1] SELECT * FROM perch2_pages WHERE pagePath='/shop/checkout' LIMIT 1
0.0862  0.0083  [1] SELECT * FROM perch2_shop_cart WHERE cartID=1387
0.0869  0.0006  [1] SELECT * FROM perch2_shop_cart WHERE cartID=1387
0.0882  0.0013  [40] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
0.0955  0.0073  [1] SELECT * FROM perch2_shop_customers WHERE memberID=67
0.0984  0.0028  [1] SELECT * FROM perch2_shop_addresses WHERE customerID='67' AND addressID=134
0.0998  0.0015  
Array
(
    [first_name] => First
    [last_name] => Name
    [address_1] => 123 Test road
    [address_2] => 
    [postcode] => 
    [city] => Dublin
    [county] => Dublin
    [country] => 236
    [addressID] => 134
    [r] => /shop/addresses
)
0.1001  0.0003  UPDATE perch2_shop_addresses SET addressDynamicFields='{\"first_name\":\"Test\",\"last_name\":\"Name\",\"address_1\":\"123 Test road\",\"address_2\":\"\",\"postcode\":\"\",\"country\":\"236\",\"company\":\"test\",\"city\":\"Dublin\",\"county\":\"Dublin\",\"addressID\":\"134\",\"r\":\"\\/shop\\/addresses\"}', addressFirstName='Test', addressLastName='Name', addressCompany='test', addressLine1='123 Test road', countryID='236', addressUpdated='2017-04-26 16:33:18' WHERE addressID='134'
0.102   0.0018  No ids to log.
0.1042  0.0022  Using cart from cache.
0.1052  0.001   [3] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/shop/checkout' OR regionPage='*' ORDER BY regionPage DESC
0.1059  0.0007  [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Site Name' AND (regionPage='/shop/checkout' OR regionPage='*')
0.1063  0.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=1 AND idx.itemRev=2)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.1095  0.0032  [1] Using template: /templates/content/shared/site_name.html
0.1118  0.0023  [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Site Description' AND (regionPage='/shop/checkout' OR regionPage='*')
0.1124  0.0006  [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=2 AND idx.itemRev=3)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.1162  0.0038  [1] Using template: /templates/content/shared/site_desc.html
0.117   0.0007  Using cart from cache.
0.1177  0.0007  Using template: /templates/pages/attributes/default.html
0.1179  0.0002  Using sub-template: /templates/pages/attributes/_seo.html
0.119   0.0011  Using cart from cache.
0.1199  0.001   Using template: /templates/shop/cart/mini.html
0.1219  0.0019  [1] SELECT billingAddress, shippingAddress FROM perch2_shop_cart WHERE billingAddress IS NOT NULL AND cartID=1387
0.1225  0.0006  [1] SELECT * FROM perch2_shop_customers WHERE memberID=67
0.123   0.0005  [1] SELECT * FROM perch2_shop_addresses WHERE customerID='67' AND orderID IS NULL AND addressSlug='default'
0.1234  0.0004  [1] SELECT * FROM perch2_shop_addresses WHERE customerID='67' AND orderID IS NULL AND addressSlug='shipping'
0.1239  0.0005  Using template: /templates/shop/addresses/confirm.html
0.1243  0.0004  [1] SELECT * FROM perch2_shop_countries WHERE countryID='236' LIMIT 1
0.1248  0.0006  [1] SELECT * FROM perch2_shop_countries WHERE countryID='236' LIMIT 1
0.1276  0.0028  [1] SELECT * FROM perch2_shop_customers WHERE memberID=67
0.1302  0.0027  [2] SELECT main.* FROM perch2_shop_addresses main WHERE 1=1 AND (customerID=67) AND addressDeleted IS NULL AND orderID IS NULL ORDER BY addressTitle ASC
0.1313  0.0011  Using template: /templates/shop/addresses/list.html
0.1315  0.0002  [1] SELECT * FROM perch2_shop_countries WHERE countryID='236' LIMIT 1
0.132   0.0005  [1] SELECT * FROM perch2_shop_countries WHERE countryID='236' LIMIT 1
0.1326  0.0006  Using shipping opts from cache.
0.1326  0   Using shipping zone from cache.
0.1335  0.0009  [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_admin_index idx JOIN perch2_shop_shippings main ON idx.itemID=main.shippingID AND idx.itemKey='shippingID' JOIN perch2_shop_admin_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='shippingID' AND idx2.indexKey='_id' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, shippingID ) as tbl WHERE (shippingID IN (2)) GROUP BY itemID, sortval ORDER BY sortval ASC
0.1415  0.008   Using template: /addons/apps/perch_shop/templates/shop/shippings/options.html
0.142   0.0005  [1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2)
0.1432  0.0013  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.1436  0.0004  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=2 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.1444  0.0008  Using shipping opts from cache.
0.1445  0.0001  [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_admin_index idx JOIN perch2_shop_shippings main ON idx.itemID=main.shippingID AND idx.itemKey='shippingID' JOIN perch2_shop_admin_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='shippingID' AND idx2.indexKey='_id' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, shippingID ) as tbl WHERE (shippingID IN (2)) GROUP BY itemID, sortval ORDER BY sortval ASC
0.1502  0.0057  [1] Using template: /addons/apps/perch_shop/templates/shop/shippings/options.html
0.1506  0.0003  [1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2)
0.1511  0.0006  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.1515  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=2 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.1534  0.0019  [1] SELECT * FROM perch2_shop_currencies WHERE currencyID=47 LIMIT 1
0.1547  0.0013  Using cart from cache.
0.1553  0.0006  [1] Using template: /templates/shop/cart/cart_static.html
0.1587  0.0034  Using template: /templates/mailchimp/subscribe.html
0.1609  0.0022  Request time: 0.1609
0.161   0.0001  Process time: 0.1587
0.161   0   Memory: 7.0897