• SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
    FROM wp_posts
    INNER JOIN wp_term_relationships
    ON (wp_posts.ID = wp_term_relationships.object_id)
    INNER JOIN wp_postmeta
    ON ( wp_posts.ID = wp_postmeta.post_id )
    INNER JOIN wp_postmeta AS mt1
    ON ( wp_posts.ID = mt1.post_id )
    WHERE 1=1
    AND ( wp_term_relationships.term_taxonomy_id IN (55) )
    AND ( wp_postmeta.meta_key = ‘_psad_featured_order’
    AND ( ( mt1.meta_key = ‘_visibility’
    AND CAST(mt1.meta_value AS CHAR) IN (‘catalog’,’visible’) ) ) )
    AND wp_posts.post_type = ‘product’
    AND ((wp_posts.post_status = ‘publish’))
    GROUP BY wp_posts.ID
    ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.menu_order ASC, wp_posts.post_title ASC
    LIMIT 0, 16

    =======
    CALLER
    =======
    WP_Query->get_posts()-
    WP_Query->query()
    query_posts()
    WC_PSAD->rewrite_shop_page()
    do_action(‘woocommerce_after_shop_loop’)

    https://www.ads-software.com/plugins/woocommerce-product-sort-and-display/

  • The topic ‘Slow Database Queries (above 0.05s)’ is closed to new replies.