[ DB ] CONNECT:[ UseTime:0.000554s ] mysql:host=127.0.0.1;dbname=ksgjzb_srok_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_link` [ RunTime:0.001076s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 49 ) [ RunTime:0.000335s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 49 ) ORDER BY `listorder` ASC LIMIT 100,10 [ RunTime:0.001003s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 50 ) [ RunTime:0.000270s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 50 ) ORDER BY `listorder` ASC LIMIT 100,10 [ RunTime:0.000684s ]
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.000801s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 0 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000417s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 169 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 171 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000474s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 171 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000402s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000443s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 158 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000303s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000315s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000278s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000284s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 10 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 11 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000317s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 11 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000292s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000284s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000405s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000300s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000329s ]
[ SQL ] SHOW COLUMNS FROM `yzn_test` [ RunTime:0.000841s ]
[ 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.000294s ]
[ 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 160,16 [ RunTime:0.003538s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000473s ]
[ 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.000370s ]
[ 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 1000,100 [ RunTime:0.000632s ]
[ 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.000398s ]
[ 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 1000,100 [ RunTime:0.000647s ]
[ 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.000389s ]
[ 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 1000,100 [ RunTime:0.000516s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 24 ) [ RunTime:0.000262s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 24 ) ORDER BY `listorder` ASC LIMIT 100,10 [ RunTime:0.000442s ]
目录
微博
抖音
小红书
公众号