SHOW FULL COLUMNS FROM `qf_conf` [ RunTime:0.001065s ]
SELECT * FROM `qf_conf` [ RunTime:0.000680s ]
SHOW FULL COLUMNS FROM `qf_source_category` [ RunTime:0.000721s ]
SHOW FULL COLUMNS FROM `qf_source` [ RunTime:0.000755s ]
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` = 6359 LIMIT 1 [ RunTime:0.000525s ]
SELECT `source_category_id`,`name` FROM `qf_source_category` WHERE `source_category_id` = 0 [ RunTime:0.000564s ]
UPDATE `qf_source` SET `page_views` = `page_views` + 1 WHERE `status` = 1 AND `is_delete` = 0 AND `source_id` = 6359 [ RunTime:0.002651s ]
SELECT `name`,`image` FROM `qf_source_category` WHERE `status` = 0 AND `is_sys` = 1 ORDER BY `sort` DESC [ RunTime:0.000501s ]
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)) 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 '%%' ) AND `source_id` <> 6359 ORDER BY `weight` DESC,`source_id` DESC LIMIT 10 [ RunTime:0.002293s ]