[ DB ] CONNECT:[ UseTime:0.000568s ] mysql:host=127.0.0.1;dbname=ksgjzb_srok_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_link` [ RunTime:0.000960s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 49 ) [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 49 ) ORDER BY `listorder` ASC LIMIT 90,10 [ RunTime:0.000996s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 50 ) [ RunTime:0.000287s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 50 ) ORDER BY `listorder` ASC LIMIT 90,10 [ RunTime:0.000707s ]
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.000841s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 0 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 169 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000441s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 171 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000316s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 171 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000312s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 158 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000284s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000266s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000269s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 10 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000305s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 11 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000278s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 11 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000320s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000248s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000290s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000293s ]
[ SQL ] SHOW COLUMNS FROM `yzn_test` [ RunTime:0.000769s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_test` `Test` LEFT JOIN `yzn_test_data` `Test_data` ON `Test`.`id`=`Test_data`.`did` WHERE ( flag != 1 AND `status`=1 AND `catid` = 5 ) [ RunTime:0.000245s ]
[ SQL ] SELECT `Test`.*,`Test_data`.* FROM `yzn_test` `Test` LEFT JOIN `yzn_test_data` `Test_data` ON `Test`.`id`=`Test_data`.`did` WHERE ( flag != 1 AND `status`=1 AND `catid` = 5 ) ORDER BY `inputtime` DESC LIMIT 144,16 [ RunTime:0.003332s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000350s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` `Link` LEFT JOIN `yzn_link_data` `Link_data` ON `Link`.`id`=`Link_data`.`did` WHERE ( `status`=1 AND `catid` = 20 ) [ RunTime:0.000410s ]
[ SQL ] SELECT `Link`.*,`Link_data`.* FROM `yzn_link` `Link` LEFT JOIN `yzn_link_data` `Link_data` ON `Link`.`id`=`Link_data`.`did` WHERE ( `status`=1 AND `catid` = 20 ) ORDER BY `listorder` ASC LIMIT 900,100 [ RunTime:0.000703s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` `Link` LEFT JOIN `yzn_link_data` `Link_data` ON `Link`.`id`=`Link_data`.`did` WHERE ( `status`=1 AND `catid` = 21 ) [ RunTime:0.000226s ]
[ SQL ] SELECT `Link`.*,`Link_data`.* FROM `yzn_link` `Link` LEFT JOIN `yzn_link_data` `Link_data` ON `Link`.`id`=`Link_data`.`did` WHERE ( `status`=1 AND `catid` = 21 ) ORDER BY `listorder` ASC LIMIT 900,100 [ RunTime:0.000537s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` `Link` LEFT JOIN `yzn_link_data` `Link_data` ON `Link`.`id`=`Link_data`.`did` WHERE ( `status`=1 AND `catid` = 22 ) [ RunTime:0.000274s ]
[ SQL ] SELECT `Link`.*,`Link_data`.* FROM `yzn_link` `Link` LEFT JOIN `yzn_link_data` `Link_data` ON `Link`.`id`=`Link_data`.`did` WHERE ( `status`=1 AND `catid` = 22 ) ORDER BY `listorder` ASC LIMIT 900,100 [ RunTime:0.000546s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 24 ) [ RunTime:0.000223s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 24 ) ORDER BY `listorder` ASC LIMIT 90,10 [ RunTime:0.000520s ]