Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Thdlist`.`id`, `Thdlist`.`daturl`, `Thdlist`.`thd`, `Thdlist`.`title`, `Thdlist`.`createTime`, `Thdlist`.`updateTime`, `Thdlist`.`sts`, `Thdlist`.`cnt`, `Thdlist`.`twitterid`, `Thdlist`.`twitterpostTime`, `Thdlist`.`twitterref`, `Thdlist`.`hashtag`, `Thdlist`.`net`, `Thdlist`.`category` FROM `data_article`.`thdlist` AS `Thdlist` WHERE `Thdlist`.`id` = '3771484523949' AND `Thdlist`.`sts` = '10' LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `Affiliate`.`id`, `Affiliate`.`ref`, `Affiliate`.`asin`, `Affiliate`.`title`, `Affiliate`.`LowestNewPrice`, `Affiliate`.`MediumImage`, `Affiliate`.`itemName`, `Affiliate`.`itemPrice`, `Affiliate`.`affiliateUrl`, `Affiliate`.`imageUrl`, `Affiliate`.`createTime` FROM `data_article`.`affiliate` AS `Affiliate` WHERE `Affiliate`.`id` = '3771484523949' | 0 | 0 | 0 | |
Click an "Explain" link above, to see the query explanation.