資料庫語法 |
---|
0.000303 - SET SQL_BIG_SELECTS = 1 |
0.001734 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.001159 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '3niospparpdca1tpsfjjn7ahiq' |
0.000701 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001367 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000857 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000186 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000289 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000145 - select mid from modules where dirname='tadnews' |
0.000236 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000329 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001192 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002283 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,5) AND b.bid IN (152,150,148,147,146,145,135,134,133,132,122,121,120,125,118,117,116,115,114,113,112,111,96,92,91,105,104,103,102,101,88,87,86,85,84,83,82,110,80,79,69,68,67,66,65,62,61,60,127,109,108,107,106,100,59,57,55,54,53,52,51,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,124,19,18,17,16,15,14,13,11,10,9,8,7,6,5,4,3,2,1,119,74,72,22,136,95,94,93,89,77,76,75,73,71,70,21) ORDER BY b.weight, m.block_id |
0.000519 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'system_block_login.tpl') ORDER BY tpl_refid |
0.000488 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'tadtools_app_block.tpl') ORDER BY tpl_refid |
0.000339 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'system_block_dummy.tpl') ORDER BY tpl_refid |
0.145628 - update tad_news set always_top='0' WHERE always_top_date <='2025-10-01 03:55:08' and always_top_date!='0000-00-00 00:00:00' |
0.001447 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.278099 - select * from tad_news where 1 and enable='1' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-10-01 03:55:05' and (end_day > '2025-10-01 03:55:05' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.174537 - select * from tad_news where 1 and enable='1' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-10-01 03:55:05' and (end_day > '2025-10-01 03:55:05' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 9180, 20 |
0.002415 - desc `tadnews_data_center` `sort` |
0.001390 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='253' order by `sort` , `data_sort` |
0.009426 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='253' order by sort |
0.000518 - SELECT * FROM users WHERE uid = '24' |
0.000672 - select * from tad_news where nsn='253' |
0.000287 - SELECT * FROM users WHERE uid = '24' |
0.000488 - select groupid,name from groups |
0.008706 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='253' order by sort |
0.006979 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='253' order by sort |
0.000646 - SELECT * FROM smiles |
0.000886 - desc `tadnews_data_center` `sort` |
0.000305 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='252' order by `sort` , `data_sort` |
0.006491 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='252' order by sort |
0.000828 - SELECT * FROM users WHERE uid = '24' |
0.000596 - select * from tad_news where nsn='252' |
0.000191 - SELECT * FROM users WHERE uid = '24' |
0.000434 - select groupid,name from groups |
0.007348 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='252' order by sort |
0.009669 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='252' order by sort |
0.001617 - desc `tadnews_data_center` `sort` |
0.000804 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='251' order by `sort` , `data_sort` |
0.008454 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='251' order by sort |
0.000700 - SELECT * FROM users WHERE uid = '24' |
0.000500 - select * from tad_news where nsn='251' |
0.000309 - SELECT * FROM users WHERE uid = '24' |
0.000569 - select groupid,name from groups |
0.008433 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='251' order by sort |
0.008147 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='251' order by sort |
0.001333 - desc `tadnews_data_center` `sort` |
0.000566 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='250' order by `sort` , `data_sort` |
0.007633 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='250' order by sort |
0.000167 - SELECT * FROM users WHERE uid = '24' |
0.000150 - select * from tad_news where nsn='250' |
0.000181 - SELECT * FROM users WHERE uid = '24' |
0.000091 - select groupid,name from groups |
0.005715 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='250' order by sort |
0.008084 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='250' order by sort |
0.002254 - desc `tadnews_data_center` `sort` |
0.001027 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='248' order by `sort` , `data_sort` |
0.009838 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='248' order by sort |
0.000537 - SELECT * FROM users WHERE uid = '16' |
0.000278 - select * from tad_news where nsn='248' |
0.000260 - SELECT * FROM users WHERE uid = '16' |
0.000336 - select groupid,name from groups |
0.006165 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='248' order by sort |
0.007911 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='248' order by sort |
0.001997 - desc `tadnews_data_center` `sort` |
0.002150 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='246' order by `sort` , `data_sort` |
0.010373 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='246' order by sort |
0.001199 - SELECT * FROM users WHERE uid = '16' |
0.000549 - select * from tad_news where nsn='246' |
0.000273 - SELECT * FROM users WHERE uid = '16' |
0.000252 - select groupid,name from groups |
0.008822 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='246' order by sort |
0.008857 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='246' order by sort |
0.001376 - desc `tadnews_data_center` `sort` |
0.001539 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='245' order by `sort` , `data_sort` |
0.007471 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='245' order by sort |
0.000214 - select * from tad_news where nsn='245' |
0.000137 - SELECT * FROM users WHERE uid = '16' |
0.000313 - select groupid,name from groups |
0.005615 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='245' order by sort |
0.006791 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='245' order by sort |
0.002209 - desc `tadnews_data_center` `sort` |
0.000722 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='244' order by `sort` , `data_sort` |
0.007394 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='244' order by sort |
0.000201 - select * from tad_news where nsn='244' |
0.000160 - SELECT * FROM users WHERE uid = '17' |
0.000184 - select groupid,name from groups |
0.006744 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='244' order by sort |
0.006490 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='244' order by sort |
0.001214 - desc `tadnews_data_center` `sort` |
0.001036 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='243' order by `sort` , `data_sort` |
0.011323 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='243' order by sort |
0.000293 - SELECT * FROM users WHERE uid = '26' |
0.000461 - select * from tad_news where nsn='243' |
0.000197 - SELECT * FROM users WHERE uid = '26' |
0.000386 - select groupid,name from groups |
0.006617 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='243' order by sort |
0.007979 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='243' order by sort |
0.001253 - desc `tadnews_data_center` `sort` |
0.000584 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='242' order by `sort` , `data_sort` |
0.008152 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='242' order by sort |
0.000190 - SELECT * FROM users WHERE uid = '17' |
0.000287 - select * from tad_news where nsn='242' |
0.000452 - SELECT * FROM users WHERE uid = '17' |
0.000728 - select groupid,name from groups |
0.007629 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='242' order by sort |
0.007041 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='242' order by sort |
0.002140 - desc `tadnews_data_center` `sort` |
0.000608 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='241' order by `sort` , `data_sort` |
0.007218 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='241' order by sort |
0.000958 - SELECT * FROM users WHERE uid = '15' |
0.000739 - select * from tad_news where nsn='241' |
0.000246 - SELECT * FROM users WHERE uid = '15' |
0.000443 - select groupid,name from groups |
0.008004 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='241' order by sort |
0.007189 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='241' order by sort |
0.001798 - desc `tadnews_data_center` `sort` |
0.001160 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='240' order by `sort` , `data_sort` |
0.005366 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='240' order by sort |
0.000233 - select * from tad_news where nsn='240' |
0.000114 - SELECT * FROM users WHERE uid = '15' |
0.000093 - select groupid,name from groups |
0.005670 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='240' order by sort |
0.006704 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='240' order by sort |
0.000607 - desc `tadnews_data_center` `sort` |
0.000207 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='239' order by `sort` , `data_sort` |
0.007612 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='239' order by sort |
0.000283 - SELECT * FROM users WHERE uid = '15' |
0.000397 - select * from tad_news where nsn='239' |
0.000080 - SELECT * FROM users WHERE uid = '15' |
0.000083 - select groupid,name from groups |
0.005301 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='239' order by sort |
0.005937 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='239' order by sort |
0.001522 - desc `tadnews_data_center` `sort` |
0.000210 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='238' order by `sort` , `data_sort` |
0.007157 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='238' order by sort |
0.000219 - select * from tad_news where nsn='238' |
0.000485 - SELECT * FROM users WHERE uid = '26' |
0.000126 - select groupid,name from groups |
0.006739 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='238' order by sort |
0.004734 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='238' order by sort |
0.000995 - desc `tadnews_data_center` `sort` |
0.000778 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='237' order by `sort` , `data_sort` |
0.006018 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='237' order by sort |
0.000441 - select * from tad_news where nsn='237' |
0.000386 - SELECT * FROM users WHERE uid = '26' |
0.000203 - select groupid,name from groups |
0.006557 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='237' order by sort |
0.005105 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='237' order by sort |
0.000891 - desc `tadnews_data_center` `sort` |
0.000993 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='236' order by `sort` , `data_sort` |
0.005790 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='236' order by sort |
0.000324 - select * from tad_news where nsn='236' |
0.000186 - SELECT * FROM users WHERE uid = '26' |
0.000354 - select groupid,name from groups |
0.005691 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='236' order by sort |
0.005327 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='236' order by sort |
0.001606 - desc `tadnews_data_center` `sort` |
0.000329 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='235' order by `sort` , `data_sort` |
0.006262 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='235' order by sort |
0.000175 - select * from tad_news where nsn='235' |
0.000373 - SELECT * FROM users WHERE uid = '16' |
0.000083 - select groupid,name from groups |
0.005023 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='235' order by sort |
0.004604 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='235' order by sort |
0.000949 - desc `tadnews_data_center` `sort` |
0.000175 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='233' order by `sort` , `data_sort` |
0.004527 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='233' order by sort |
0.000134 - SELECT * FROM users WHERE uid = '18' |
0.000431 - select * from tad_news where nsn='233' |
0.000163 - SELECT * FROM users WHERE uid = '18' |
0.000310 - select groupid,name from groups |
0.005080 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='233' order by sort |
0.004845 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='233' order by sort |
0.001052 - desc `tadnews_data_center` `sort` |
0.000356 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='232' order by `sort` , `data_sort` |
0.005461 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='232' order by sort |
0.000241 - SELECT * FROM users WHERE uid = '18' |
0.000420 - select * from tad_news where nsn='232' |
0.000146 - SELECT * FROM users WHERE uid = '18' |
0.000284 - select groupid,name from groups |
0.005042 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='232' order by sort |
0.004527 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='232' order by sort |
0.001451 - desc `tadnews_data_center` `sort` |
0.000252 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='230' order by `sort` , `data_sort` |
0.006091 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='230' order by sort |
0.000478 - select * from tad_news where nsn='230' |
0.000307 - SELECT * FROM users WHERE uid = '24' |
0.000322 - select groupid,name from groups |
0.005180 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='230' order by sort |
0.005160 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='230' order by sort |
0.000316 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.001311 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'tadnews_index.tpl') ORDER BY tpl_refid |