[ DB ] CONNECT:[ UseTime:0.000437s ] mysql:host=127.0.0.1;dbname=solvexmall_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_shouye` [ RunTime:0.000917s ]
[ 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.000492s ]
[ 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.000493s ]
[ SQL ] SHOW COLUMNS FROM `yzn_chanpin` [ RunTime:0.000824s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_chanpin` WHERE ( `status`=1 AND `catid` = 43 ) [ RunTime:0.000283s ]
[ SQL ] SELECT * FROM `yzn_chanpin` WHERE ( `status`=1 AND `catid` = 43 ) ORDER BY `listorder` ASC LIMIT 48,24 [ RunTime:0.001133s ]
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.000664s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 100000 [ RunTime:0.000374s ]
[ SQL ] select count(id) as countid,id from yzn_chanpin where parentid=280 order by listorder asc LIMIT 20 [ RunTime:0.002006s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 280 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10000 [ RunTime:0.000498s ]
[ SQL ] select count(id) as countid,id from yzn_chanpin where parentid=14 order by listorder asc LIMIT 20 [ RunTime:0.001961s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 14 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10000 [ RunTime:0.000789s ]
[ SQL ] select count(id) as countid,id from yzn_chanpin where parentid=6 order by listorder asc LIMIT 20 [ RunTime:0.002019s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10000 [ RunTime:0.000615s ]
[ 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.000599s ]
[ SQL ] SHOW COLUMNS FROM `yzn_urls` [ RunTime:0.000788s ]
[ SQL ] SELECT * FROM `yzn_urls` WHERE ( xianshi='MEXICO' AND `status`=1 AND `catid` = 125 ) ORDER BY `listorder` ASC LIMIT 10000 [ RunTime:0.000444s ]
[ SQL ] SELECT * FROM `yzn_urls` WHERE ( xianshi='INDONESIA' AND `status`=1 AND `catid` = 125 ) ORDER BY `listorder` ASC LIMIT 10000 [ RunTime:0.000580s ]
[ 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.000428s ]