SHOW FULL COLUMNS FROM `idc_kefu_category` [ RunTime:0.002026s ]
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.000703s ]
SHOW FULL COLUMNS FROM `idc_kefu` [ RunTime:0.003049s ]
SELECT * FROM `idc_kefu` WHERE ( `status` = 1 AND ( `category_id` IN (1,2,3,4,8) ) ) AND `idc_kefu`.`delete_time` IS NULL ORDER BY `sort` DESC,`id` ASC LIMIT 0,1000 [ RunTime:0.001327s ]
SHOW FULL COLUMNS FROM `idc_news` [ RunTime:0.003500s ]
SHOW FULL COLUMNS FROM `idc_help` [ RunTime:0.003519s ]
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.001619s ]
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.001725s ]
SELECT * FROM `idc_news` WHERE `status` = 1 ORDER BY `views` DESC LIMIT 5 [ RunTime:0.001912s ]
SELECT * FROM `idc_help` WHERE `status` = 1 ORDER BY `views` DESC LIMIT 5 [ RunTime:0.001065s ]
