[ DB ] CONNECT:[ UseTime:0.000958s ] mysql:host=127.0.0.1;dbname=plj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_model_field` [ RunTime:0.008836s ]
[ SQL ] SELECT `name`,`title`,`remark`,`type`,`isadd`,`iscore`,`ifsystem`,`ifrequire`,`setting` FROM `yzn_model_field` WHERE `modelid` = 0 AND `status` = 1 ORDER BY `listorder` ASC,`id` ASC [ RunTime:0.000392s ]
[ SQL ] SHOW COLUMNS FROM `yzn_banner` [ RunTime:0.007471s ]
[ SQL ] SELECT * FROM `yzn_banner` WHERE ( status=1 AND groupid = 2 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000424s ]
[ SQL ] SHOW COLUMNS FROM `yzn_attachment` [ RunTime:0.007655s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000292s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000225s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000295s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000171s ]
[ SQL ] SHOW COLUMNS FROM `yzn_product` [ RunTime:0.008366s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_product` `Product` LEFT JOIN `yzn_product_data` `Product_data` ON `Product`.`id`=`Product_data`.`did` WHERE ( `status`=1 AND `catid` = 9 ) [ RunTime:0.000598s ]
[ SQL ] SELECT `Product`.*,`Product_data`.* FROM `yzn_product` `Product` LEFT JOIN `yzn_product_data` `Product_data` ON `Product`.`id`=`Product_data`.`did` WHERE ( `status`=1 AND `catid` = 9 ) ORDER BY `listorder` ASC LIMIT 0,8 [ RunTime:0.000692s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000282s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 44 UNION ALL ( SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 44 ) UNION ALL ( SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 44 ) [ RunTime:0.000737s ]