[ DB ] CONNECT:[ UseTime:0.001453s ] mysql:host=127.0.0.1;dbname=plj_en;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_en_category` [ RunTime:0.008471s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE `catdir` = 'enhanced' LIMIT 1 [ RunTime:0.000464s ]
[ DB ] CONNECT:[ UseTime:0.000905s ] mysql:host=127.0.0.1;dbname=plj_en;charset=utf8
[ SQL ] SELECT * FROM `yzn_en_category` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000367s ]
[ SQL ] SHOW COLUMNS FROM `yzn_en_model_field` [ RunTime:0.017575s ]
[ SQL ] SELECT `name`,`title`,`remark`,`type`,`isadd`,`iscore`,`ifsystem`,`ifrequire`,`setting` FROM `yzn_en_model_field` WHERE `modelid` = 0 AND `status` = 1 ORDER BY `listorder` ASC,`id` ASC [ RunTime:0.000313s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 0 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000480s ]
[ SQL ] SHOW COLUMNS FROM `yzn_en_attachment` [ RunTime:0.008836s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000295s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000305s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000249s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000245s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000267s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 2 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000311s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 3 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000293s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 4 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000304s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000235s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000288s ]
[ SQL ] SHOW COLUMNS FROM `yzn_en_banner` [ RunTime:0.009961s ]
[ SQL ] SELECT * FROM `yzn_en_banner` WHERE ( status=1 AND groupid = 2 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000442s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000416s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000245s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000253s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000228s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 2 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000600s ]
[ SQL ] SHOW COLUMNS FROM `yzn_en_model` [ RunTime:0.017551s ]
[ SQL ] SELECT * FROM `yzn_en_model` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000436s ]
[ SQL ] SHOW COLUMNS FROM `yzn_en_product` [ RunTime:0.011690s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_en_product` `Product` LEFT JOIN `yzn_en_product_data` `Product_data` ON `Product`.`id`=`Product_data`.`did` WHERE ( `status`=1 AND `catid` = 9 ) [ RunTime:0.001787s ]
[ SQL ] SELECT `Product`.*,`Product_data`.* FROM `yzn_en_product` `Product` LEFT JOIN `yzn_en_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.000521s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000323s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 44 UNION ALL ( SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 44 ) UNION ALL ( SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 44 ) [ RunTime:0.001919s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( id in(2,4,5,6) ) ORDER BY `listorder` ASC LIMIT 4 [ RunTime:0.000883s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000395s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000254s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000318s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 2 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000446s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 4 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000402s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000608s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.002206s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000411s ]
CN
EN
