[ DB ] CONNECT:[ UseTime:0.019184s ] mysql:host=bdm820327208.my3w.com;dbname=bdm820327208_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.009615s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009063s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009099s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009214s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008962s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009013s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008821s ]
[ SQL ] SHOW COLUMNS FROM `yzn_product` [ RunTime:0.009448s ]
[ 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.009133s ]
[ 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.008859s ]
[ 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.009097s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( id in(1,6,8) ) ORDER BY `listorder` DESC LIMIT 4 [ RunTime:0.009020s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008800s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008898s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.008807s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.009044s ]
[ DB ] CONNECT:[ UseTime:0.013153s ] mysql:host=bdm820327208.my3w.com;dbname=bdm820327208_db;charset=utf8
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.008835s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.008636s ]
[ DB ] CONNECT:[ UseTime:0.019855s ] mysql:host=bdm820327208.my3w.com;dbname=bdm820327208_db;charset=utf8
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.009087s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.009087s ]
