[ DB ] CONNECT:[ UseTime:0.013662s ] mysql:host=bdm820327208.my3w.com;dbname=bdm820327208_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.009320s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 43 LIMIT 1 [ RunTime:0.008894s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008893s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008875s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008858s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008930s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008903s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 43 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.015877s ]
[ SQL ] SHOW COLUMNS FROM `yzn_product` [ RunTime:0.009472s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE ( `status`=1 AND (FIND_IN_SET('4', flag)) AND `catid` in(55,43) ) ORDER BY `listorder` ASC LIMIT 4 [ RunTime:0.009009s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_product` WHERE ( `status`=1 AND `catid` in(55,43) ) [ RunTime:0.008805s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE ( `status`=1 AND `catid` in(55,43) ) ORDER BY `listorder` ASC LIMIT 0,9 [ RunTime:0.008929s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( id in(1,6,8) ) ORDER BY `listorder` DESC LIMIT 4 [ RunTime:0.008968s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008736s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008744s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008759s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.009005s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.008880s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.008857s ]