SHOW FULL COLUMNS FROM `site_articles` [ RunTime:0.036335s ]
SHOW FULL COLUMNS FROM `site_154_articles` [ RunTime:0.036055s ]
SELECT `a`.`title`,`s`.`onlinedAt`,`c`.`columnName`,`s`.`url` FROM `site_154_articles` `s` LEFT JOIN `articles` `a` ON `a`.`articleId`=`s`.`articleId` LEFT JOIN `columns` `c` ON `c`.`columnId`=`s`.`columnId` WHERE `s`.`isTop` = '1' AND `s`.`siteId` = '154' ORDER BY `s`.`onlinedAt` DESC LIMIT 10 [ RunTime:0.047236s ]
SHOW FULL COLUMNS FROM `columns` [ RunTime:0.036100s ]
SELECT * FROM `columns` WHERE `siteId` = 154 AND `columnKey` = 'notice' LIMIT 1 [ RunTime:0.035298s ]
SELECT `a`.`title`,`s`.`url` FROM `site_154_articles` `s` LEFT JOIN `articles` `a` ON `a`.`articleId`=`s`.`articleId` LEFT JOIN `columns` `c` ON `c`.`columnId`=`s`.`columnId` WHERE `s`.`columnId` = '4670' AND `s`.`siteId` = '154' ORDER BY `s`.`onlinedAt` DESC LIMIT 5 [ RunTime:0.043451s ]
SELECT COUNT(*) AS think_count FROM `site_154_articles` `s` LEFT JOIN `articles` `a` ON `a`.`articleId`=`s`.`articleId` WHERE `s`.`siteId` = '154' LIMIT 1 [ RunTime:0.099209s ]
SELECT `a`.`title`,`a`.`thumb`,`a`.`abstract`,`s`.`onlinedAt`,`s`.`url` FROM `site_154_articles` `s` LEFT JOIN `articles` `a` ON `a`.`articleId`=`s`.`articleId` WHERE `s`.`siteId` = '154' ORDER BY `s`.`onlinedAt` DESC LIMIT 2710,10 [ RunTime:0.054123s ]