[ DB ] CONNECT:[ UseTime:0.021117s ] mysql:host=bdm820327208.my3w.com;dbname=bdm820327208_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.009982s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.009411s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009500s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009461s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009424s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009286s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009476s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009345s ]
[ SQL ] SHOW COLUMNS FROM `yzn_product` [ RunTime:0.009950s ]
[ 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.009675s ]
[ 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.009456s ]
[ 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.009586s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( id in(1,6,8) ) ORDER BY `listorder` DESC LIMIT 4 [ RunTime:0.009478s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009273s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009338s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.009311s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.009567s ]
[ DB ] CONNECT:[ UseTime:0.020665s ] mysql:host=bdm820327208.my3w.com;dbname=bdm820327208_db;charset=utf8
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.009731s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.009701s ]
[ DB ] CONNECT:[ UseTime:0.011892s ] mysql:host=bdm820327208.my3w.com;dbname=bdm820327208_db;charset=utf8
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.008030s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.007958s ]
