- 中国教育学会2006年度工作总结 2007-04-26
- 中国教育学会2007年工作要点 2007-04-26
- 青少年创意大赛拒绝造假 2007-04-24
- “反对伪书劣书,为青少年提供优质助学读物”倡议书 2005-05-18
- 中国教育学会关于教育学术界学风建设倡议书 2003-03-19
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
select * from `bk_article_classify` where `id` = '31' and `is_active` = '1' and `is_delete` = '0' limit 1
1.02msdb_xhjy_preParams | |
---|---|
0 | 31 |
1 | 1 |
2 | 0 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select count(*) as aggregate from `bk_article_main` left join `bk_article_classify_relation` on `bk_article_classify_relation`.`article_id` = `bk_article_main`.`id` left join `bk_article_classify` on `bk_article_classify_relation`.`classify_id` = `bk_article_classify`.`id` left join `bk_article_tag_relation` on `bk_article_tag_relation`.`article_id` = `bk_article_main`.`id` left join `bk_article_tags` on `bk_article_tag_relation`.`tag_id` = `bk_article_tags`.`id` where `bk_article_main`.`is_delete` = '1' and `bk_article_main`.`status` = '1' and `bk_article_classify`.`id` = '31' group by `bk_article_main`.`id`
11.19msdb_xhjy_preParams | |
---|---|
0 | 1 |
1 | 1 |
2 | 31 |
select bk_article_main.*, group_concat(DISTINCT bk_article_classify.name) as classnames, group_concat(DISTINCT bk_article_classify.id) as classifyid, group_concat(DISTINCT bk_article_tags.name) as tagsnames from `bk_article_main` left join `bk_article_classify_relation` on `bk_article_classify_relation`.`article_id` = `bk_article_main`.`id` left join `bk_article_classify` on `bk_article_classify_relation`.`classify_id` = `bk_article_classify`.`id` left join `bk_article_tag_relation` on `bk_article_tag_relation`.`article_id` = `bk_article_main`.`id` left join `bk_article_tags` on `bk_article_tag_relation`.`tag_id` = `bk_article_tags`.`id` where `bk_article_main`.`is_delete` = '1' and `bk_article_main`.`status` = '1' and `bk_article_classify`.`id` = '31' group by `bk_article_main`.`id` order by `bk_article_main`.`is_stick` desc, `bk_article_main`.`sort` desc, `bk_article_main`.`write_time` desc, `bk_article_main`.`id` desc limit 15 offset 720
43.93msdb_xhjy_preParams | |
---|---|
0 | 1 |
1 | 1 |
2 | 31 |
select * from `bk_article_classify` where `is_delete` = '0' and `is_active` = '1' and `is_nav` = '1' order by `sort` desc
2.04msdb_xhjy_preParams | |
---|---|
0 | 0 |
1 | 1 |
2 | 1 |
hints | Use SELECT * only if you need all columns from table |
select * from `bk_article_classify` where `id` = '31' and `is_active` = '1' and `is_delete` = '0' limit 1
730μsdb_xhjy_preParams | |
---|---|
0 | 31 |
1 | 1 |
2 | 0 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `bk_article_classify` where `id` = '31' and `is_active` = '1' and `is_delete` = '0' limit 1
730μsdb_xhjy_preParams | |
---|---|
0 | 31 |
1 | 1 |
2 | 0 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `bk_article_classify` where `id` = '6' and `is_active` = '1' and `is_delete` = '0' limit 1
710μsdb_xhjy_preParams | |
---|---|
0 | 6 |
1 | 1 |
2 | 0 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |