您可以使用
$args = array( \'post_type\' => \'post\' ,\'posts_per_page\' => 10, \'category_name\' => \'orange\' );
$query = new WP_Query( $args );
printf( \'<h2>Generated SQL:</h2><pre>%s</pre>\', $query->request );
显示生成的
SQL 查询上述示例将为您提供：
<h2>Generated SQL:</h2>
<pre>
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1
AND ( wp_term_relationships.term_taxonomy_id IN (123) )
AND wp_posts.post_type = \'post\'
AND (wp_posts.post_status = \'publish\' OR wp_posts.post_status = \'private\')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 10
</pre>
