Critical Performance Issue – Duplicate SQL Queries Causing Admin Slowdown

Hello Packlink Support Team,

I’m experiencing a critical performance issue with the Packlink Pro Shipping plugin on the WooCommerce Orders admin page.

Environment Details

• Plugin: Packlink Pro Shipping 3.5.2
• WordPress Version: 6.8.1
• WooCommerce Version: 9.8.5
• PHP Version: 8.1.32
• Server: Apache

Problem Description

The WooCommerce Orders admin page (/wp-admin/edit.php?post_type=shop_order) is extremely slow, taking over 7 seconds to load with only 20 orders displayed.

Root Cause Analysis

Using Query Monitor, I’ve identified that your plugin is executing identical SQL queries multiple times for each order.

Problematic Query:

SELECT * FROM wp_xxx_packlink_entity 
WHERE type = 'OrderShipmentDetails' 
AND ( index_1 = 'ORDER_ID') 
LIMIT 0, 1

Impact:

• Same query executed 10-15 times per order
• With 20 orders displayed = 200+ identical queries
• Each query takes ~0.02s = 4+ seconds just for duplicates

Code Location:

Packlink\WC\R\Base_Repository->select()
Extension: packlink-pro-shipping

Evidence

I can provide:

• Query Monitor screenshots showing duplicates
• Complete query log with timing data
• Performance metrics before/after modifications

Business Impact

This performance issue significantly affects:

• Daily order management workflow
• User experience for store administrators
• Server resource consumption

Request

Please prioritize this optimization in your next update. The current implementation creates an exponential performance degradation as the number of orders increases.

I’m available to provide additional debugging information or test potential fixes.

Thank you for your attention to this matter.

Best regards,

The page I need help with: [log in to see the link]