SHOW FULL COLUMNS FROM `qf_conf` [ RunTime:0.001310s ]
SELECT * FROM `qf_conf` [ RunTime:0.000821s ]
SHOW FULL COLUMNS FROM `qf_source_category` [ RunTime:0.000910s ]
SHOW FULL COLUMNS FROM `qf_source` [ RunTime:0.000965s ]
SELECT source_id as id,`source_category_id`,`title`,`url`,create_time as time,`vod_content`,`vod_pic`,`is_type` FROM `qf_source` WHERE `status` = 1 AND `is_delete` = 0 AND `source_id` = 6444 LIMIT 1 [ RunTime:0.000721s ]
SELECT `source_category_id`,`name` FROM `qf_source_category` WHERE `source_category_id` = 0 [ RunTime:0.000499s ]
UPDATE `qf_source` SET `page_views` = `page_views` + 1 WHERE `status` = 1 AND `is_delete` = 0 AND `source_id` = 6444 [ RunTime:0.002569s ]
SELECT `name`,`image` FROM `qf_source_category` WHERE `status` = 0 AND `is_sys` = 1 ORDER BY `sort` DESC [ RunTime:0.000611s ]
SELECT a.*, (IF(title LIKE '%魔幻%' OR description LIKE '%魔幻%', 1, 0) + IF(title LIKE '%手机%' OR description LIKE '%手机%', 1, 0) + IF(title LIKE '%王飞%' OR description LIKE '%王飞%', 1, 0) + IF(title LIKE '%乔%' OR description LIKE '%乔%', 1, 0) + IF(title LIKE '%%' OR description LIKE '%%', 1, 0)) as weight FROM `qf_source` `a` WHERE `status` = 1 AND `is_delete` = 0 AND ( `title` LIKE '%魔幻%' OR `description` LIKE '%魔幻%' OR `title` LIKE '%手机%' OR `description` LIKE '%手机%' OR `title` LIKE '%王飞%' OR `description` LIKE '%王飞%' OR `title` LIKE '%乔%' OR `description` LIKE '%乔%' OR `title` LIKE '%%' OR `description` LIKE '%%' ) AND `source_id` <> 6444 ORDER BY `weight` DESC,`source_id` DESC LIMIT 10 [ RunTime:0.002342s ]