SHOW FULL COLUMNS FROM `qf_conf` [ RunTime:0.001040s ]
SELECT * FROM `qf_conf` [ RunTime:0.000855s ]
SHOW FULL COLUMNS FROM `qf_source_category` [ RunTime:0.000779s ]
SHOW FULL COLUMNS FROM `qf_source` [ RunTime:0.000950s ]
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` = 6445 LIMIT 1 [ RunTime:0.000563s ]
SELECT `source_category_id`,`name` FROM `qf_source_category` WHERE `source_category_id` = 0 [ RunTime:0.000468s ]
UPDATE `qf_source` SET `page_views` = `page_views` + 1 WHERE `status` = 1 AND `is_delete` = 0 AND `source_id` = 6445 [ RunTime:0.002610s ]
SELECT `name`,`image` FROM `qf_source_category` WHERE `status` = 0 AND `is_sys` = 1 ORDER BY `sort` DESC [ RunTime:0.000491s ]
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` <> 6445 ORDER BY `weight` DESC,`source_id` DESC LIMIT 10 [ RunTime:0.002194s ]