Changeset 34127

Timestamp:

09/14/2015 07:24:59 PM (9 years ago)

Author:

wonderboymusic

Message:

In WP_Media_List_Table, fetch all pending comment counts at once, instead of for each row in the loop.

See #11381.

File:

• trunk/src/wp-admin/includes/class-wp-media-list-table.php (modified) (4 diffs)

trunk/src/wp-admin/includes/class-wp-media-list-table.php

@@ -9 +9 @@
  */
 class WP_Media_List_Table extends WP_List_Table {
+    /**
+     * Store the pending comment count for each post
+     *
+     * @access public
+     * @since 4.4.0
+     * @var array
+     */
+    public $pending_count = array();
 
     private $detached;
@@ -150 +158 @@
             /** This action is documented in wp-admin/includes/class-wp-posts-list-table.php */
             do_action( 'restrict_manage_posts', $this->screen->post_type );
-            
+
             submit_button( __( 'Filter' ), 'button', 'filter_action', false, array( 'id' => 'post-query-submit' ) );
         }
@@ -482 +490 @@
         echo '<div class="post-com-count-wrapper">';
 
-        $pending_comments = get_pending_comments_num( $post->ID );
+        if ( isset( $this->pending_count[ $post->ID ] ) ) {
+            $pending_comments = $this->pending_count[ $post->ID ];
+        } else {
+            $pending_comments = get_pending_comments_num( $post->ID );
+        }
+
         $this->comments_bubble( $post->ID, $pending_comments );
 
@@ -549 +562 @@
      */
     public function display_rows() {
-        global $post;
+        global $post, $wp_query;
+
+        $post_ids = wp_list_pluck( $wp_query->posts, 'ID' );
+        reset( $wp_query->posts );
+
+        $this->pending_count = get_pending_comments_num( $post_ids );
 
         add_filter( 'the_title','esc_html' );