[ DB ] CONNECT:[ UseTime:0.012473s ] mysql:host=bdm820327208.my3w.com;dbname=bdm820327208_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.008697s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008372s ]
[ SQL ] SHOW COLUMNS FROM `yzn_product` [ RunTime:0.008841s ]
[ 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.008360s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_product` WHERE ( `status`=1 AND `catid` in(47,49,50,51,52,45,43,55,48,21,20,19) ) [ RunTime:0.008055s ]
[ SQL ] SELECT * FROM `yzn_product` WHERE ( `status`=1 AND `catid` in(47,49,50,51,52,45,43,55,48,21,20,19) ) ORDER BY `listorder` ASC LIMIT 0,9 [ RunTime:0.008134s ]
