[ DB ] CONNECT:[ UseTime:0.000427s ] mysql:host=127.0.0.1;dbname=solvexmall_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_shouye` [ RunTime:0.000741s ]
[ SQL ] SELECT * FROM `yzn_shouye` WHERE ( id=1 AND `status`=1 AND `catid` in(12,125,1) ) ORDER BY `listorder` ASC LIMIT 1 [ RunTime:0.000435s ]
[ SQL ] SELECT * FROM `yzn_shouye` WHERE ( id=1 AND `status`=1 AND `catid` in(12,125,1) ) ORDER BY `listorder` ASC LIMIT 1 [ RunTime:0.000527s ]
[ DB ] CONNECT:[ UseTime:0.000472s ] mysql:host=127.0.0.1;dbname=solvexmall_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.000563s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000318s ]
[ SQL ] SHOW COLUMNS FROM `yzn_chanpin` [ RunTime:0.000603s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_chanpin` WHERE ( `status`=1 AND `catid` = 41 ) [ RunTime:0.000354s ]
[ SQL ] SELECT * FROM `yzn_chanpin` WHERE ( `status`=1 AND `catid` = 41 ) ORDER BY `listorder` ASC LIMIT 0,24 [ RunTime:0.000572s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 100000 [ RunTime:0.000552s ]
[ SQL ] select count(id) as countid,id from yzn_chanpin where parentid=280 order by listorder asc LIMIT 20 [ RunTime:0.002106s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 280 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10000 [ RunTime:0.000507s ]
[ SQL ] select count(id) as countid,id from yzn_chanpin where parentid=14 order by listorder asc LIMIT 20 [ RunTime:0.002142s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 14 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10000 [ RunTime:0.000737s ]
[ SQL ] select count(id) as countid,id from yzn_chanpin where parentid=6 order by listorder asc LIMIT 20 [ RunTime:0.001655s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10000 [ RunTime:0.000533s ]
[ SQL ] SELECT * FROM `yzn_shouye` WHERE ( id=1 AND `status`=1 AND `catid` in(12,125,1) ) ORDER BY `listorder` ASC LIMIT 1 [ RunTime:0.000437s ]
[ SQL ] SHOW COLUMNS FROM `yzn_urls` [ RunTime:0.000572s ]
[ SQL ] SELECT * FROM `yzn_urls` WHERE ( xianshi='MEXICO' AND `status`=1 AND `catid` = 125 ) ORDER BY `listorder` ASC LIMIT 10000 [ RunTime:0.000409s ]
[ SQL ] SELECT * FROM `yzn_urls` WHERE ( xianshi='INDONESIA' AND `status`=1 AND `catid` = 125 ) ORDER BY `listorder` ASC LIMIT 10000 [ RunTime:0.000354s ]
[ SQL ] SELECT * FROM `yzn_shouye` WHERE ( id=1 AND `status`=1 AND `catid` in(12,125,1) ) ORDER BY `listorder` ASC LIMIT 1 [ RunTime:0.000354s ]