Cookie

Current Route

Sql Logs

article

Total Time: 529 ms Total Queries: 2 queries

Query

Affected

Num. rows

Took (ms)

Actions

SELECT `Thdlist`.*, `Titlecap`.* FROM `data_article`.`thdlist` AS `Thdlist` LEFT JOIN `data_article`.`titlecap` AS `Titlecap` ON (`Thdlist`.`thd`=`Titlecap`.`thd`) WHERE `Thdlist`.`cnt` > 0 ORDER BY `Thdlist`.`updateTime` desc LIMIT 80, 20

20

20

31

maybe slow

SELECT COUNT(*) AS `count` FROM `data_article`.`thdlist` AS `Thdlist` LEFT JOIN `data_article`.`titlecap` AS `Titlecap` ON (`Thdlist`.`thd`=`Titlecap`.`thd`) WHERE `Thdlist`.`cnt` > 0