SHOW FULL COLUMNS FROM `lay_cms_article` [ RunTime:0.000910s ]
SHOW FULL COLUMNS FROM `lay_cms_category` [ RunTime:0.000413s ]
SELECT `id`,`pid`,`name`,`alias`,`org`,`nav`,`desc` FROM `lay_cms_category` WHERE `nav` = 1 ORDER BY `sort` ASC [ RunTime:0.000298s ]
SELECT COUNT(*) AS think_count FROM `lay_cms_article` `cms_article` LEFT JOIN `lay_cms_category` `cms_category` ON `cms_article`.`cid`=`cms_category`.`id` WHERE `tags` LIKE '%HeyPiggy%' LIMIT 1 [ RunTime:0.000580s ]
SELECT `cms_article`.`id`,cms_article. cid,cms_article. uuid,cms_article. title,cms_article. cover,cms_article. author,cms_article. path,cms_article. resume,cms_article. tags,cms_article. top,cms_article. view,cms_article. create_time,cms_category.name as category,cms_category. alias,`cms_category`.`org` FROM `lay_cms_article` `cms_article` LEFT JOIN `lay_cms_category` `cms_category` ON `cms_article`.`cid`=`cms_category`.`id` WHERE `tags` LIKE '%HeyPiggy%' ORDER BY `top` DESC,`cms_article`.`id` DESC LIMIT 0,20 [ RunTime:0.000510s ]
SELECT `id` FROM `lay_cms_article` WHERE `cid` = 36 [ RunTime:0.000396s ]
SELECT `id`,`uuid`,`title`,`path`,`author`,`cover`,`resume`,`top`,`view`,`create_time` FROM `lay_cms_article` WHERE `id` IN (662,752,746,674,660) [ RunTime:0.000237s ]
SELECT `id`,`uuid`,`title`,`path`,`author`,`cover`,`resume`,`top`,`view`,`create_time` FROM `lay_cms_article` WHERE `cid` = 36 ORDER BY `view` DESC LIMIT 5 [ RunTime:0.000372s ]
SELECT COUNT(*) AS think_count FROM `lay_cms_article` LIMIT 1 [ RunTime:0.000133s ]
