[wp-hackers] Recent Comments Plugins.

[Podz]

Jason Bainbridge wrote:
>>http://wp-plugins.net/index.php?id=169
>>[1] => 9.0837478637695E-05
>>[1] => 7.0095062255859E-05
>>[1] => 6.7949295043945E-05
>>[1] => 6.7234039306641E-05
>>[1] => 6.8187713623047E-05
>>[1] => 6.6995620727539E-05
>>[1] => 6.6995620727539E-05
>>[1] => 6.6995620727539E-05
>>[1] => 6.6995620727539E-05
>>[1] => 6.6995620727539E-05
>>[1] => 6.6995620727539E-05
>>[1] => 6.6995620727539E-05
>>[1] => 0.00013589859008789   <-----
>>The one indicated actually does something. The stuff above are functions
>>not called but they execute (strangely).
> 
> 
> Can you turn on the debug output for that plugin by un-commenting the
> $output row towards the bottom and commenting out the other line? Also
> does the query diagnostics plugin give you the actual query? Try
> running an EXPLAIN on it if you can like Matt's post earlier in the
> thread.
> Where was the call to get_recent_comments placed?

The call is in my sidebar.

The output as seen in the Source of the page:
[47] => Array
         (
             [0] => SELECT ID, post_title, post_excerpt FROM t2b_posts 
WHERE post_status = 'publish' AND post_password ='' AND post_date_gmt < 
'2005-07-20 19:26:16' ORDER BY post_date DESC LIMIT 6, 5
             [1] => 0.010740995407104
         )

     [48] => Array
         (
             [0] => SELECT option_name FROM t2b_options WHERE 
option_name = 'kjgrc_grc_max_comments'
             [1] => 0.00023198127746582
         )

     [49] => Array
         (
             [0] => SELECT option_name FROM t2b_options WHERE 
option_name = 'kjgrc_grc_chars_per_comment'
             [1] => 0.00016689300537109
         )

     [50] => Array
         (
             [0] => SELECT option_name FROM t2b_options WHERE 
option_name = 'kjgrc_grc_chars_per_word'
             [1] => 0.00016593933105469
         )

     [51] => Array
         (
             [0] => SELECT option_name FROM t2b_options WHERE 
option_name = 'kjgrc_grc_format'
             [1] => 0.0001521110534668
         )

     [52] => Array
         (
             [0] => SELECT option_name FROM t2b_options WHERE 
option_name = 'kjgrc_grt_max_comments'
             [1] => 0.00014710426330566
         )

     [53] => Array
         (
             [0] => SELECT option_name FROM t2b_options WHERE 
option_name = 'kjgrc_grt_chars_per_comment'
             [1] => 0.00014901161193848
         )

     [54] => Array
         (
             [0] => SELECT option_name FROM t2b_options WHERE 
option_name = 'kjgrc_grt_chars_per_word'
             [1] => 0.00014281272888184
         )

     [55] => Array
         (
             [0] => SELECT option_name FROM t2b_options WHERE 
option_name = 'kjgrc_grt_format'
             [1] => 0.00015687942504883
         )

     [56] => Array
         (
             [0] => SELECT option_name FROM t2b_options WHERE 
option_name = 'kjgrc_misc_exclude_cat'
             [1] => 0.00015091896057129
         )

     [57] => Array
         (
             [0] => SELECT option_name FROM t2b_options WHERE 
option_name = 'kjgrc_gravatar_size'
             [1] => 0.00014209747314453
         )

     [58] => Array
         (
             [0] => SELECT option_name FROM t2b_options WHERE 
option_name = 'kjgrc_gravatar_alt_url'
             [1] => 0.00014400482177734
         )

     [59] => Array
         (
             [0] => SELECT option_name FROM t2b_options WHERE 
option_name = 'kjgrc_gravatar_rating'
             [1] => 0.00013899803161621
         )

     [60] => Array
         (
             [0] => SELECT DISTINCT t2b_comments.* FROM t2b_comments 
LEFT JOIN t2b_posts ON t2b_posts.ID=t2b_comments.comment_post_ID WHERE 
(post_status = 'publish' OR post_status = 'static') AND 
comment_approved= '1' AND  post_password = '' AND comment_type = '' 
ORDER BY comment_date DESC LIMIT 5
             [1] => 0.25421714782715
         )