× 关闭我有建议/意见
|
|
Query: DESCRIBE `article`
Warning: SQL Error: 144: Table './ucdchina_home/article' is marked as crashed and last (automatic?) repair failed in /home/ucdchina/ucdchina.com/portal/cake/libs/model/datasources/dbo_source.php on line 440
Query: select a.* from article a where a.id in (select ca.article_id from category_article_relation ca where ca.category_id=1) and a.state='auth' order by a.click_num desc,id asc limit 1360,20
Warning: SQL Error: 144: Table './ucdchina_home/article' is marked as crashed and last (automatic?) repair failed in /home/ucdchina/ucdchina.com/portal/cake/libs/model/datasources/dbo_source.php on line 440
Query: select count(1) count from article a where a.id in (select ca.article_id from category_article_relation ca where ca.category_id in (1)) and a.state='auth'
Warning: SQL Error: 144: Table './ucdchina_home/article' is marked as crashed and last (automatic?) repair failed in /home/ucdchina/ucdchina.com/portal/cake/libs/model/datasources/dbo_source.php on line 440
Query: select s.owner_name,sum(ss.count) as total from site s join (select site_id,count(a.id) as count from article a inner join category_article_relation ca on a.id=ca.article_id where a.site_id>0 and ca.category_id in (1) and a.state='auth' group by a.site_id) ss on s.id=ss.site_id group by s.owner_name order by total desc limit 9
Warning: SQL Error: 144: Table './ucdchina_home/article' is marked as crashed and last (automatic?) repair failed in /home/ucdchina/ucdchina.com/portal/cake/libs/model/datasources/dbo_source.php on line 440
Query: select created from article where state='auth'order by created desc limit 1
Warning: SQL Error: 144: Table './ucdchina_home/article' is marked as crashed and last (automatic?) repair failed in /home/ucdchina/ucdchina.com/portal/cake/libs/model/datasources/dbo_source.php on line 440
Query: select count(1) count from article a where a.id in (select ca.article_id from category_article_relation ca where ca.category_id in (1)) and a.state='auth' and a.created>'2025-02-04 16:37:59'
Warning: SQL Error: 144: Table './ucdchina_home/article' is marked as crashed and last (automatic?) repair failed in /home/ucdchina/ucdchina.com/portal/cake/libs/model/datasources/dbo_source.php on line 440
Query: select count(1) count from article a where a.id in (select ca.article_id from category_article_relation ca where ca.category_id in (1)) and a.state='auth' and a.created>'2025-02-05 10:37:59'
Warning: SQL Error: 144: Table './ucdchina_home/article' is marked as crashed and last (automatic?) repair failed in /home/ucdchina/ucdchina.com/portal/cake/libs/model/datasources/dbo_source.php on line 440
