[ DB ] CONNECT:[ UseTime:0.000504s ] mysql:host=127.0.0.1;dbname=ksgjzb_srok_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_link` [ RunTime:0.000895s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 49 ) [ RunTime:0.000292s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 49 ) ORDER BY `listorder` ASC LIMIT 30,10 [ RunTime:0.000782s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 50 ) [ RunTime:0.000351s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 50 ) ORDER BY `listorder` ASC LIMIT 30,10 [ RunTime:0.000718s ]
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.000724s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 0 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000323s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 169 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 171 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000282s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 171 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000262s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 158 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000260s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000290s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000273s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 10 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000260s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 11 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000269s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 11 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000273s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000263s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000256s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000260s ]
[ SQL ] SHOW COLUMNS FROM `yzn_test` [ RunTime:0.000805s ]
[ 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.000344s ]
[ 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 48,16 [ RunTime:0.002687s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000434s ]
[ 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.000311s ]
[ 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 300,100 [ RunTime:0.000688s ]
[ 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.000326s ]
[ 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 300,100 [ RunTime:0.000690s ]
[ 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.000295s ]
[ 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 300,100 [ RunTime:0.000639s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 24 ) [ RunTime:0.000291s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 24 ) ORDER BY `listorder` ASC LIMIT 30,10 [ RunTime:0.000629s ]
目录
微博
抖音
小红书
公众号