SHOW FULL COLUMNS FROM `zp_config` [ RunTime:0.001408s ]
SELECT * FROM `zp_config` WHERE ( 1=1 ) LIMIT 1 [ RunTime:0.000463s ]
SHOW FULL COLUMNS FROM `zp_information_category` [ RunTime:0.001133s ]
SELECT * FROM `zp_information_category` WHERE `pid` = 0 AND `status` = 100 [ RunTime:0.000943s ]
SHOW FULL COLUMNS FROM `zp_information` [ RunTime:0.001202s ]
SELECT COUNT(*) AS think_count FROM `zp_information` `i` LEFT JOIN `zp_information_category` `c` ON `i`.`category_id`=`c`.`id` WHERE `i`.`status` = '100' AND ( `i`.`title` LIKE '%.NET%' OR `i`.`keywords` LIKE '%.NET%' ) [ RunTime:0.001440s ]
SELECT `i`.`id`,`i`.`title`,`i`.`image`,`i`.`keywords`,`i`.`description`,`i`.`publish_time`,`i`.`category_id`,c.name category FROM `zp_information` `i` LEFT JOIN `zp_information_category` `c` ON `i`.`category_id`=`c`.`id` WHERE `i`.`status` = '100' AND ( `i`.`title` LIKE '%.NET%' OR `i`.`keywords` LIKE '%.NET%' ) ORDER BY `is_topping` DESC,`publish_time` DESC LIMIT 0,3 [ RunTime:0.000403s ]