oolyrics.com

query_vars['search_terms'])) { global $wpdb; $search = ''; $search_terms = $wp_query->query_vars['search_terms']; foreach ($search_terms as $term) { $term = esc_sql($wpdb->esc_like($term)); $search .= " AND ( ({$wpdb->posts}.post_title LIKE '%{$term}%') OR ({$wpdb->posts}.post_content LIKE '%{$term}%') OR EXISTS ( SELECT * FROM {$wpdb->postmeta} WHERE post_id = {$wpdb->posts}.ID AND meta_value LIKE '%{$term}%' ) )"; } } return $search; } // 添加搜索缓存 add_filter('posts_results', 'cache_search_results', 10, 2); function cache_search_results($posts, $query) { if ($query->is_search() && !is_admin()) { $transient_key = 'search_cache_' . md5($query->query_vars['s']); set_transient($transient_key, $posts, HOUR_IN_SECONDS); } return $posts; }