How to optimize pagination in WordPress? sometimes it takes 2 or 3 seconds

34 Views Asked by At

Enter a fixed category(term_taxonomy_id = 262) A SQL LIKE that:

    SELECT   wp_posts.ID     
    FROM wp_posts  LEFT JOIN wp_term_relationships 
    ON (wp_posts.ID = wp_term_relationships.object_id)     
    WHERE 1=1  AND (wp_term_relationships.term_taxonomy_id IN (262)) 
    AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')))     
    GROUP BY wp_posts.ID     
    ORDER BY wp_posts.post_date DESC     
    LIMIT 0, 15;

and the sql explain is: explain sql Reduce SQL query time

0

There are 0 best solutions below