SHOW FULL COLUMNS FROM `idc_kefu_category` [ RunTime:0.002151s ]
SELECT `C`.`id`,`C`.`name`,`C`.`description`,`C`.`icon` FROM `idc_kefu_category` `C` WHERE ( `status` = '1' ) AND `C`.`delete_time` IS NULL ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000589s ]
SHOW FULL COLUMNS FROM `idc_news` [ RunTime:0.001942s ]
SHOW FULL COLUMNS FROM `idc_help` [ RunTime:0.001834s ]
SELECT COUNT(*) AS think_count FROM (( SELECT id, title, description, content, picture, create_time, views, author, "news" as doc_type FROM `idc_news` WHERE ( `status` = 1 AND `title` LIKE '%%' ) ) UNION ALL ( SELECT id, title, description, content, picture, create_time, views, author, "help" as doc_type FROM `idc_help` WHERE ( `status` = 1 AND `title` LIKE '%%' ) )) as a [ RunTime:0.000781s ]
SELECT * FROM (( SELECT id, title, description, content, picture, create_time, views, author, "news" as doc_type FROM `idc_news` WHERE ( `status` = 1 AND `title` LIKE '%%' ) ) UNION ALL ( SELECT id, title, description, content, picture, create_time, views, author, "help" as doc_type FROM `idc_help` WHERE ( `status` = 1 AND `title` LIKE '%%' ) )) as a ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.000695s ]
SELECT * FROM `idc_news` WHERE `status` = 1 ORDER BY `views` DESC LIMIT 5 [ RunTime:0.000579s ]
SELECT * FROM `idc_help` WHERE `status` = 1 ORDER BY `views` DESC LIMIT 5 [ RunTime:0.000463s ]