[ DB ] CONNECT:[ UseTime:0.000793s ] mysql:host=127.0.0.1;dbname=ksgjzb_srok_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_link` [ RunTime:0.001045s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 49 ) [ RunTime:0.000307s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 49 ) ORDER BY `listorder` ASC LIMIT 120,10 [ RunTime:0.000977s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 50 ) [ RunTime:0.000437s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 50 ) ORDER BY `listorder` ASC LIMIT 120,10 [ RunTime:0.000840s ]
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.001024s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 0 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 169 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000418s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 171 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000345s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 171 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000256s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000401s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 158 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000506s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000367s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000339s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 10 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000408s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 11 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000358s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 11 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000293s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000256s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000275s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000433s ]
[ SQL ] SHOW COLUMNS FROM `yzn_test` [ RunTime:0.001172s ]
[ 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.000437s ]
[ 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 192,16 [ RunTime:0.003997s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000483s ]
[ 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.000406s ]
[ 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 1200,100 [ RunTime:0.000565s ]
[ 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 1200,100 [ RunTime:0.000549s ]
[ 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.000312s ]
[ 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 1200,100 [ RunTime:0.000609s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 24 ) [ RunTime:0.000267s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 24 ) ORDER BY `listorder` ASC LIMIT 120,10 [ RunTime:0.000564s ]
目录
微博
抖音
小红书
公众号