[ DB ] CONNECT:[ UseTime:0.000624s ] mysql:host=127.0.0.1;dbname=51heiliao_vip;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.000905s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 0 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000457s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000454s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000399s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000377s ]
[ SQL ] SHOW COLUMNS FROM `yzn_product` [ RunTime:0.000920s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_product` WHERE ( `status` = '1' AND `trade` = '4' AND `price` = '2' AND `type` = '3' AND `status`=1 AND `catid` = 5 ) [ RunTime:0.000433s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE ( `status` = '1' AND `trade` = '4' AND `price` = '2' AND `type` = '3' AND `status`=1 AND `catid` = 5 ) ORDER BY `listorder` ASC LIMIT 0,8 [ RunTime:0.000500s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( id in(1,6,8) AND `parentid` = 0 ) ORDER BY `listorder` ASC LIMIT 4 [ RunTime:0.000578s ]
