[ DB ] CONNECT:[ UseTime:0.018586s ] mysql:host=bdm820327208.my3w.com;dbname=bdm820327208_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.008735s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 55 LIMIT 1 [ RunTime:0.008249s ]
[ SQL ] SHOW COLUMNS FROM `yzn_product` [ RunTime:0.008629s ]
[ SQL ] UPDATE `yzn_product` SET `hits` = `hits` + 1 WHERE `id` = 31 [ RunTime:0.008199s ]
[ SQL ] SELECT `Product`.*,`Product_data`.* FROM `yzn_product` `Product` LEFT JOIN `yzn_product_data` `Product_data` ON `Product`.`id`=`Product_data`.`did` WHERE ( id=31 ) LIMIT 1 [ RunTime:0.008391s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008284s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008312s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008264s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008281s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008266s ]
[ DB ] CONNECT:[ UseTime:0.019025s ] mysql:host=bdm820327208.my3w.com;dbname=bdm820327208_db;charset=utf8
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 43 LIMIT 1 [ RunTime:0.008811s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008690s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE ( `status`=1 AND (FIND_IN_SET('4', flag)) AND `catid` in(47,49,50,51,52,45,43,55,48,21,20,19) ) ORDER BY `listorder` ASC LIMIT 4 [ RunTime:0.008976s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE ( `catid` = 55 AND `status` = 1 AND `id` < 31 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.009085s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE ( `catid` = 55 AND `status` = 1 AND `id` > 31 ) LIMIT 1 [ RunTime:0.008723s ]
[ SQL ] SHOW COLUMNS FROM `yzn_article` [ RunTime:0.009227s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_article` WHERE ( `status`=1 AND (FIND_IN_SET('4', flag)) AND `catid` in(14,10,9,6) ) [ RunTime:0.008646s ]
[ SQL ] SELECT * FROM `yzn_article` WHERE ( `status`=1 AND (FIND_IN_SET('4', flag)) AND `catid` in(14,10,9,6) ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.008843s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( id in(1,6,8) ) ORDER BY `listorder` DESC LIMIT 4 [ RunTime:0.008704s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008662s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008606s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008607s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.008714s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.008750s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.008726s ]