| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
select * from `bk_article_classify` where `id` = '34' and `is_active` = '1' and `is_delete` = '0' limit 11msdb_xhjy_pre| Params | |
|---|---|
| 0 | 34 |
| 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_soft` left join `bk_article_soft_classify_relation` on `bk_article_soft_classify_relation`.`article_id` = `bk_article_soft`.`id` left join `bk_article_classify` on `bk_article_soft_classify_relation`.`classify_id` = `bk_article_classify`.`id` left join `bk_article_tag_relation` on `bk_article_tag_relation`.`article_id` = `bk_article_soft`.`id` left join `bk_article_tags` on `bk_article_tag_relation`.`tag_id` = `bk_article_tags`.`id` where `bk_article_soft`.`is_delete` = '1' and `bk_article_soft`.`status` = '1' and `bk_article_classify`.`id` = '34' group by `bk_article_soft`.`id`1.69msdb_xhjy_pre| Params | |
|---|---|
| 0 | 1 |
| 1 | 1 |
| 2 | 34 |
select bk_article_soft.*, group_concat(DISTINCT bk_article_classify.name) as classnames, group_concat(DISTINCT bk_article_tags.name) as tagsnames from `bk_article_soft` left join `bk_article_soft_classify_relation` on `bk_article_soft_classify_relation`.`article_id` = `bk_article_soft`.`id` left join `bk_article_classify` on `bk_article_soft_classify_relation`.`classify_id` = `bk_article_classify`.`id` left join `bk_article_tag_relation` on `bk_article_tag_relation`.`article_id` = `bk_article_soft`.`id` left join `bk_article_tags` on `bk_article_tag_relation`.`tag_id` = `bk_article_tags`.`id` where `bk_article_soft`.`is_delete` = '1' and `bk_article_soft`.`status` = '1' and `bk_article_classify`.`id` = '34' group by `bk_article_soft`.`id` order by `bk_article_soft`.`sort` desc, `bk_article_soft`.`write_time` desc, `bk_article_soft`.`id` desc limit 15 offset 152.89msdb_xhjy_pre| Params | |
|---|---|
| 0 | 1 |
| 1 | 1 |
| 2 | 34 |
select * from `bk_article_classify` where `is_delete` = '0' and `is_active` = '1' and `is_nav` = '1' order by `sort` desc1.99msdb_xhjy_pre| Params | |
|---|---|
| 0 | 0 |
| 1 | 1 |
| 2 | 1 |
| hints | Use SELECT * only if you need all columns from table |
select * from `bk_article_classify` where `id` = '34' and `is_active` = '1' and `is_delete` = '0' limit 1710μsdb_xhjy_pre| Params | |
|---|---|
| 0 | 34 |
| 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` = '34' and `is_active` = '1' and `is_delete` = '0' limit 1830μsdb_xhjy_pre| Params | |
|---|---|
| 0 | 34 |
| 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` = '29' and `is_active` = '1' and `is_delete` = '0' limit 1760μsdb_xhjy_pre| Params | |
|---|---|
| 0 | 29 |
| 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 |