SHOW FULL COLUMNS FROM `site_articles` [ RunTime:0.033528s ]
SHOW FULL COLUMNS FROM `site_150_articles` [ RunTime:0.033365s ]
SELECT `a`.`title`,`s`.`onlinedAt`,`c`.`columnName`,`s`.`url` FROM `site_150_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` = '150' ORDER BY `s`.`onlinedAt` DESC LIMIT 10 [ RunTime:0.041199s ]
SHOW FULL COLUMNS FROM `columns` [ RunTime:0.033194s ]
SELECT * FROM `columns` WHERE `siteId` = 150 AND `columnKey` = 'notice' LIMIT 1 [ RunTime:0.032396s ]
SELECT `a`.`title`,`s`.`url` FROM `site_150_articles` `s` LEFT JOIN `articles` `a` ON `a`.`articleId`=`s`.`articleId` LEFT JOIN `columns` `c` ON `c`.`columnId`=`s`.`columnId` WHERE `s`.`columnId` = '4542' AND `s`.`siteId` = '150' ORDER BY `s`.`onlinedAt` DESC LIMIT 5 [ RunTime:0.040310s ]
SELECT COUNT(*) AS think_count FROM `site_150_articles` `s` LEFT JOIN `articles` `a` ON `a`.`articleId`=`s`.`articleId` WHERE `s`.`siteId` = '150' LIMIT 1 [ RunTime:0.088700s ]
SELECT `a`.`title`,`a`.`thumb`,`a`.`abstract`,`s`.`onlinedAt`,`s`.`url` FROM `site_150_articles` `s` LEFT JOIN `articles` `a` ON `a`.`articleId`=`s`.`articleId` WHERE `s`.`siteId` = '150' ORDER BY `s`.`onlinedAt` DESC LIMIT 4820,10 [ RunTime:0.073717s ]