如何使用WP_QUERY来降低查询次数

我在页脚中有以下代码（我删除了不必要的html），我正在尝试优化这些代码。我的服务器白天窒息：）如果posts_per_page 设置为1，则每个帖子有48个查询。如果我设置为18 就像我想的那样86 每个帖子的查询量，对我来说似乎很大，尤其是因为我有1500篇帖子。有没有办法对此进行优化？为什么WP\\u Query不能在单个查询中完成任务？

 $footer_query = new WP_Query(array(

     \'posts_per_page\' => 18,
     \'orderby\' => \'rand\',
     \'post_type\' => \'post\',
     \'post_status\' => \'publish\',
     \'no_found_rows\' => true, // counts posts, remove if pagination require
     \'update_post_term_cache\' => false, // grabs terms, remove if terms required (category, tag...)
     // look for post which has featured img
     \'meta_query\' => array(
       array(
          \'key\' => \'_thumbnail_id\',
            )
      )
      ));


      // LOOP
      if ($footer_query->have_posts()) :
       while ($footer_query->have_posts()) : $footer_query->the_post(); 
      ?>

         <a href="<?php the_permalink() ?>">
           <?php echo get_the_post_thumbnail( get_the_ID(), \'small_thumbnail\', array(\'class\' => \'img-responsive\') ); ?>
         </a>

        <a href="<?php the_permalink() ?>">
            <?php the_title(); ?>
            <?php echo get_field(\'subtitle\', get_the_ID()); ?>
        </a>

   <?php
   endif; 
   endwhile; 

 wp_reset_query();

$args = [ \'posts_per_page\' => 18, \'orderby\' => \'rand\', \'no_found_rows\' => true, // counts posts, remove if pagination require // look for post which has featured img \'meta_query\' => [ [ \'key\' => \'_thumbnail_id\', ] ] ]; $footer_query = new WP_Query( $args ); // Update the thumbnail cache update_post_thumbnail_cache( $footer_query ); // LOOP if ($footer_query->have_posts()) : while ($footer_query->have_posts()) : $footer_query->the_post(); ?> <a href="<?php the_permalink() ?>"> <?php echo get_the_post_thumbnail( get_the_ID(), \'small_thumbnail\', array(\'class\' => \'img-responsive\') ); ?> </a> <a href="<?php the_permalink() ?>"> <?php the_title(); ?> </a> <?php endwhile; wp_reset_postdata(); endif;

小码农CODE

相关推荐

为什么WP-Query的拼写是这样的？