[ DB ] CONNECT:[ UseTime:0.000434s ] mysql:host=127.0.0.1;dbname=hwj_web_zhongwan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.001235s ]
[ SQL ] SELECT `id`,`catname`,`catdir`,`parentid`,`url` FROM `yzn_category` WHERE ( status=1 ) [ RunTime:0.000494s ]
[ SQL ] SHOW COLUMNS FROM `yzn_footer` [ RunTime:0.001019s ]
[ SQL ] SELECT * FROM `yzn_footer` WHERE `catid` = 119 AND `status` = 1 [ RunTime:0.000423s ]
[ SQL ] SHOW COLUMNS FROM `yzn_attachment` [ RunTime:0.000983s ]
[ SQL ] SELECT * FROM `yzn_attachment` WHERE `id` = 0 [ RunTime:0.000334s ]
[ SQL ] SELECT * FROM `yzn_attachment` WHERE `id` = 0 [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `yzn_attachment` WHERE `id` = 0 [ RunTime:0.000319s ]
[ SQL ] SELECT * FROM `yzn_category` `c` INNER JOIN `yzn_index` `i` ON `c`.`id`=`i`.`catid` INNER JOIN `yzn_attachment` `a` ON `i`.`thumb`=`a`.`id` WHERE `i`.`catid` = 24 [ RunTime:0.000584s ]
[ SQL ] SHOW COLUMNS FROM `yzn_product` [ RunTime:0.001054s ]
[ SQL ] SELECT * FROM `yzn_product` `p` INNER JOIN `yzn_category` `c` ON `c`.`id`=`p`.`catid` INNER JOIN `yzn_attachment` `a` ON `a`.`id`=`p`.`thumb` WHERE ( c.id=33 ) LIMIT 1 [ RunTime:0.000576s ]
[ SQL ] SELECT * FROM `yzn_product` `p` WHERE `p`.`id` = '193' LIMIT 1 [ RunTime:0.000339s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE `id` = 37 [ RunTime:0.000312s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE `id` = 20 [ RunTime:0.000308s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE `id` IN (11,12,15,16,18,19) [ RunTime:0.000382s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10) [ RunTime:0.000403s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE `id` = 32 [ RunTime:0.000309s ]
[ SQL ] SELECT * FROM `yzn_product` `p` WHERE `p`.`id` = '193' LIMIT 1 [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE `id` = 37 [ RunTime:0.000291s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE `id` = 20 [ RunTime:0.000305s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE `id` IN (11,12,15,16,18,19) [ RunTime:0.000377s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10) [ RunTime:0.000411s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE `id` = 32 [ RunTime:0.000307s ]
[ SQL ] SELECT * FROM `yzn_attachment` WHERE `id` IN (3119,3120,3117,3121,3122,3123,3124,3118,3125,3126,3127,3128,3129,3130,3131,3132,3133,3134) [ RunTime:0.000474s ]
[ SQL ] SELECT `p`.`thumb`,`p`.`catid`,`p`.`id`,`p`.`title`,`p`.`keywords`,`p`.`description`,`p`.`prodetail`,`p`.`occption`,`a`.`path`,`c`.`catdir`,`c`.`url`,`p`.`flag` FROM `yzn_product` `p` INNER JOIN `yzn_attachment` `a` ON `p`.`occption`=`a`.`id` INNER JOIN `yzn_category` `c` ON `c`.`id`=`p`.`catid` WHERE ( p.flag=4 ) [ RunTime:0.000421s ]
