这是一部传世之作!顶级网络编程专家Bill Fenner和Andrew M. Rudoff应邀执笔,对W. Richard Stevens的经典作品进行修订。书中吸纳了近几年网络技术的发展,增添了IPv6、SCTP协议和密钥管理套接字等内容,深入讨论了最新的关键标准、实现和技术。书中的所有示例都是在UNIX系统上测试通过的真实的、可运行的代码,继承了Stevens一直强调的理念:“学习网络编程的最好方法就是
SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.001502s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.001757s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.002015s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.001721s ]
SHOW FULL COLUMNS FROM `ls_nav` [ RunTime:0.002370s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.001338s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.002013s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.001678s ]
SHOW FULL COLUMNS FROM `ls_friendly_link` [ RunTime:0.004551s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.001827s ]
SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003965s ]
SELECT * FROM `ls_goods` WHERE `id` = 51705 AND `status` = 1 LIMIT 1 [ RunTime:0.002794s ]
UPDATE `ls_goods` SET `click_count` = 204 , `update_time` = 1771612015 WHERE `id` = 51705 [ RunTime:0.001309s ]
SELECT `name`,`first_category_id`,`second_category_id` FROM `ls_goods` WHERE `id` = 51705 LIMIT 1 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 35 LIMIT 1 [ RunTime:0.001326s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.003932s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.004210s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.001874s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.002724s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.002478s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.002077s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.002363s ]
SHOW FULL COLUMNS FROM `ls_ad` [ RunTime:0.002842s ]
SELECT `a`.*,`ap`.`width`,`ap`.`height` FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 10 AND `ap`.`client` = '2' AND `a`.`status` = '1' AND `a`.`del` = '0' AND `ap`.`status` = '1' AND `ap`.`del` = '0' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.002516s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.003010s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 35 LIMIT 1 [ RunTime:0.001549s ]
SELECT `a`.*,`ap`.`width`,`ap`.`height` FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 11 AND `ap`.`client` = '2' AND `a`.`status` = '1' AND `a`.`del` = '0' AND `ap`.`status` = '1' AND `ap`.`del` = '0' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.002027s ]
SELECT `a`.*,`ap`.`width`,`ap`.`height` FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 14 AND `ap`.`client` = '2' AND `a`.`status` = '1' AND `a`.`del` = '0' AND `ap`.`status` = '1' AND `ap`.`del` = '0' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.002082s ]
SELECT * FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `create_time` <= 1771611955 ORDER BY `create_time` DESC LIMIT 5 [ RunTime:0.583651s ]