[ DB ] CONNECT:[ UseTime:0.000986s ] mysql:host=127.0.0.1;dbname=plj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.009884s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000458s ]
[ SQL ] SHOW COLUMNS FROM `yzn_attachment` [ RunTime:0.010425s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000345s ]
[ SQL ] SHOW COLUMNS FROM `yzn_model_field` [ RunTime:0.009470s ]
[ 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.000797s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 0 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000493s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000371s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000314s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000405s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000260s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000243s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000579s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000393s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000387s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000376s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000295s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000357s ]
[ SQL ] SHOW COLUMNS FROM `yzn_banner` [ RunTime:0.009280s ]
[ SQL ] SELECT * FROM `yzn_banner` WHERE ( status=1 AND groupid = 2 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000329s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000301s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000260s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000254s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000199s ]
[ SQL ] SHOW COLUMNS FROM `yzn_model` [ RunTime:0.009377s ]
[ SQL ] SELECT * FROM `yzn_model` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000329s ]
[ SQL ] SHOW COLUMNS FROM `yzn_product` [ RunTime:0.010170s ]
[ 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` in(8,9,10,11,2) ) [ RunTime:0.001532s ]
[ 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` in(8,9,10,11,2) ) ORDER BY `listorder` ASC LIMIT 0,8 [ RunTime:0.000410s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000291s ]
[ 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.001763s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000258s ]
[ 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.000334s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000325s ]
[ 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.000310s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000244s ]
[ 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.000313s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( id in(2,4,5,6) ) ORDER BY `listorder` ASC LIMIT 4 [ RunTime:0.000334s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000280s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000235s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000260s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000252s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000342s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000347s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000334s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000289s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000326s ]
CN
EN
EN
