How to fix Random Posts Query slow issue ?

  • winson9998

    (@winson9998)


    5 years ago

    How to fix Random Posts Query slow issue ?
    I use Query Monitor to show widgets Random Posts Query slow.
    I am a novice, where should I modify it, thanks.

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
    FROM wp_posts
    WHERE 1=1
    AND wp_posts.post_type = ‘post’
    AND ((wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘inherit’))
    ORDER BY RAND()
    LIMIT 0, 5

    WP_Query->get_posts()
    wp-includes/class-wp-query.php:3024
    WP_Query->query()
    wp-includes/class-wp-query.php:3465
    WP_Query->__construct()
    wp-includes/class-wp-query.php:3576
    WP_Widget_Ultimate_Posts->widget()
    wp-content/plugins/ultimate-posts-widget/ultimate-posts-widget.php:204
    WP_Widget->display_callback()
    wp-includes/class-wp-widget.php:380
    dynamic_sidebar(‘sidebar-1’)
    wp-includes/widgets.php:823
    load_template(‘wp-content/themes/freedom/sidebar.php’)
    wp-includes/template.php:730
    locate_template()
    wp-includes/template.php:676
    get_sidebar()
    wp-includes/general-template.php:136

The topic ‘How to fix Random Posts Query slow issue ?’ is closed to new replies.