一般来讲WordPress的文章数量达到一定量级时,运行速度就会变慢。网上看到的代码,记录一下解决SQL_CALC_FOUND_ROWS查询使网站变慢问题。
<?php /** * Plugin Name: WP Fast Query * Plugin URI: https://jiloc.com/ * Description: WordPress 10w+数据时, 解决SQL_CALC_FOUND_ROWS查询使网站变慢问题 * Version: 1.0.0 * Author: Leo * Author URI: https://jiloc.com/ * Author Email: [email protected] * Text Domain: wp-fast-query * Domain Path: /languages * License: GPL 2.0 * License URI: http://www.gnu.org/licenses/gpl-2.0.html */ if ( ! function_exists( 'jset_no_found_rows' ) ) { /** * 设置WP_Query的 'no_found_rows' 属性为true,禁用SQL_CALC_FOUND_ROWS * * @param WP_Query $wp_query WP_Query实例 * @return void */ function jset_no_found_rows(WP_Query $wp_query) { $wp_query->set('no_found_rows', true); } } add_filter( 'pre_get_posts', 'jset_no_found_rows', 10, 1 ); if ( ! function_exists( 'jset_found_posts' ) ) { /** * 使用 EXPLAIN 方式重构 */ function jset_found_posts($clauses, WP_Query $wp_query) { // Don't proceed if it's a singular page. if ($wp_query->is_singular()) { return $clauses; } global $wpdb; $where = isset($clauses['where']) ? $clauses['where'] : ''; $join = isset($clauses['join']) ? $clauses['join'] : ''; $distinct = isset($clauses['distinct']) ? $clauses['distinct'] : ''; $wp_query->found_posts = (int)$wpdb->get_row("EXPLAIN SELECT $distinct * FROM {$wpdb->posts} $join WHERE 1=1 $where")->rows; $posts_per_page = (!empty($wp_query->query_vars['posts_per_page']) ? absint($wp_query->query_vars['posts_per_page']) : absint(get_option('posts_per_page'))); $wp_query->max_num_pages = ceil($wp_query->found_posts / $posts_per_page); return $clauses; } } add_filter( 'posts_clauses', 'jset_found_posts', 10, 2 );