如何显示查询中运行的SQL查询？

您好 @Keith Donegan:

如果我正确理解了您的问题,我认为这就是您想要的吗?

 <?php echo $GLOBALS['wp_query']->request; ?>
 

$wp_query是一个全局变量,它包含循环运行的当前查询.如果您在循环仍处于活动状态时甚至在循环之后立即运行上述代码,则应该为您提供循环中的SQL.只需确保检查一下,然后再运行其他使用query_posts()的东西即可.

Hi @Keith Donegan:

If I understand your question correctly I think this is what you are looking for?

<?php echo $GLOBALS['wp_query']->request; ?>

$wp_query is a global variable that contains the current query run by the loop. If you run the above code anytime while the loop is still active or even right after the loop it should give you the SQL from the loop. Just make sure you inspect it before letting something else run that uses query_posts() again.

如果您基于WP_Query运行查询,就是这样:

 $customPosts = new WP_Query($yourArgs);
echo "Last SQL-Query: {$customPosts->request}";
 

If you ran a query based on WP_Query, it's this:

$customPosts = new WP_Query($yourArgs);
echo "Last SQL-Query: {$customPosts->request}";

查看此答案:最佳您的functions.php文件的代码集合

然后将?debug=sql添加到任何WP URL,它将输出已运行查询的完整列表.(是的,这很可怕...)

See this answer: Best Collection of Code for your functions.php file

Then add ?debug=sql to any WP URL, and it'll output the full list of queries that were run. (And yes, it's scary...)

如果您仅对循环感兴趣,这就是我通常使用的方法:

 add_filter( 'posts_request', 'dump_request' );

function dump_request( $input ) {

    var_dump($input);

    return $input;
}
 

If you are only interested in Loops this is what I usually use:

add_filter( 'posts_request', 'dump_request' );

function dump_request( $input ) {

    var_dump($input);

    return $input;
}