[ DB ] CONNECT:[ UseTime:0.001086s ] mysql:host=127.0.0.1;dbname=plj_en;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_en_category` [ RunTime:0.009809s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE `catdir` = 'Auxiliary_boost' LIMIT 1 [ RunTime:0.000489s ]
[ DB ] CONNECT:[ UseTime:0.000857s ] mysql:host=127.0.0.1;dbname=plj_en;charset=utf8
[ SQL ] SELECT * FROM `yzn_en_category` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000343s ]
[ SQL ] SHOW COLUMNS FROM `yzn_en_model_field` [ RunTime:0.032009s ]
[ 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.000346s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 0 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000437s ]
[ SQL ] SHOW COLUMNS FROM `yzn_en_attachment` [ RunTime:0.010475s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000320s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000230s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000198s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000198s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 2 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000298s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 3 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000511s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 4 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000282s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000308s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000229s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000336s ]
[ SQL ] SHOW COLUMNS FROM `yzn_en_banner` [ RunTime:0.010816s ]
[ SQL ] SELECT * FROM `yzn_en_banner` WHERE ( status=1 AND groupid = 2 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000404s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000389s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000254s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000281s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000222s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 2 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000372s ]
[ SQL ] SHOW COLUMNS FROM `yzn_en_model` [ RunTime:0.009226s ]
[ SQL ] SELECT * FROM `yzn_en_model` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000322s ]
[ SQL ] SHOW COLUMNS FROM `yzn_en_product` [ RunTime:0.009073s ]
[ 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` = 10 ) [ RunTime:0.001382s ]
[ 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` = 10 ) ORDER BY `listorder` ASC LIMIT 0,8 [ RunTime:0.000323s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000257s ]
[ 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.001663s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( id in(2,4,5,6) ) ORDER BY `listorder` ASC LIMIT 4 [ RunTime:0.000284s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000260s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000330s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000256s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000215s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 2 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 4 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000423s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000389s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_en_attachment` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000289s ]
[ SQL ] SELECT * FROM `yzn_en_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000347s ]
CN
EN
