• Hey,

    The plugin works great but I’m unable to run it as it is generating multiple queries to shipping data for each shipping zone, on every page in wp-admin. I have 25 shipping zones.

    WC_Shipping_Zone_Data_Store->read_zone_locations() 200
    0.1511
    WC_Data_Store_WP->read_meta() 200
    0.1472
    WC_Shipping_Zone_Data_Store->get_methods() 200 0.1414
    WC_Shipping_Zone_Data_Store->read() 200
    0.1372

    SELECT zone_name, zone_order
    FROM wp_XXXXXXXXXX_woocommerce_shipping_zones
    WHERE zone_id = X
    LIMIT 1 8
    WC_Shipping_Zone_Data_Store->read()
    8 calls
    Plugin: woocommerce
    8 calls
    WC_Shipping_Zones::get_zones()
    4 calls
    WC_Shipping_Zones::get_zone_by()
    4 calls

    SELECT location_code, location_type
    FROM wp_XXXXXXXXXX_woocommerce_shipping_zone_locations
    WHERE zone_id = X 8
    WC_Shipping_Zone_Data_Store->read_zone_locations()
    8 calls
    Plugin: woocommerce
    8 calls
    WC_Shipping_Zones::get_zones()
    4 calls
    WC_Shipping_Zones::get_zone_by()
    4 calls
    SELECT meta_id as meta_id, meta_key, meta_value
    FROM wp_XXXXXXXXXX_postmeta
    WHERE post_id = X
    ORDER BY meta_id 8
    WC_Data_Store_WP->read_meta()
    8 calls
    Plugin: woocommerce
    8 calls
    WC_Shipping_Zones::get_zones()
    4 calls
    WC_Shipping_Zones::get_zone_by()
    4 calls
    SELECT method_id, method_order, instance_id, is_enabled
    FROM wp_XXXXXXXXXX_woocommerce_shipping_zone_methods
    WHERE zone_id = X 8
    WC_Shipping_Zone_Data_Store->get_methods()
    8 calls

    I look forward to your feedback

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Duplicate shipping queries on every page’ is closed to new replies.