wordpress启动SQL中

@ 2009.04.6

[7] => SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (11, 7) ORDER BY t.name ASC
[8] => SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (11,7)
[9] => SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_order, post_title ASC
[10] => SELECT option_value FROM wp_options WHERE option_name = 'page_for_posts' LIMIT 1
[11] => SELECT * FROM wp_users WHERE ID = 1 LIMIT 1
[12] => SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = 1
[13] => SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 5
[14] => SELECT FOUND_ROWS()

7.查询一些用户信息
8.次查询与文章的“自定义域”有关.wordpress SEO meta中有提到,是理解此表的一个不错的例子,这里不多说了
9.查询所有公开的“页面”并按照一定规则排序
10.查询“page_for_posts”所对应的值
11.查询用户“admin”的全部信息
12.查询用户设置情况
13.查询最近的n篇文章的所有数据(最近5篇)
14.得到上一个查询获得的记录条数

以上文字包括 wordpress启动SQL上 仅仅是就SQL表面意思简单的描述,还有很多不完善的地方还会改动…期待wordpress启动SQL下

Comments are closed.

博百优

博百优