Slow MySQL Query

WP Query Monitor keeps reporting a slow query related to Nexgen Gallery:

SELECT SQL_CALC_FOUND_ROWS *
FROM wp_posts
WHERE 1=1
AND ((wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'future'
OR wp_posts.post_status = 'draft'
OR wp_posts.post_status = 'pending'
OR wp_posts.post_status = 'private')))
ORDER BY wp_posts.post_date DESC
LIMIT 0, 17

The calling trace for this is as follows:

    WP_Query->get_posts()
    wp-includes/class-wp-query.php:3429
    WP_Query->query()
    wp-includes/class-wp-query.php:3949
    WP_Query->__construct()
    wp-includes/class-wp-query.php:4081
    Imagely\N\D\WPPostDriver->run_query()
    wp-content/plugins/nextgen-gallery/src/DataMapper/WPPostDriver.php:418
    Imagely\N\D\DriverBase->find_all()
    wp-content/plugins/nextgen-gallery/src/DataMapper/DriverBase.php:174
    M_Marketing->{closure:M_Marketing::_register_adapters():168}()
    wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/marketing/module.marketing.php:169
    do_action('init')
    wp-includes/plugin.php:517

The marketing module really should not be adding such a delay. By the way, is anybody still developing NGG? As we haven’t had an update in over half a year, and it still hasn’t been patched for PHP 8.4, despite the fact that 8.5 is about to be released.

• This topic was modified 5 months, 1 week ago by ispreview.