資料庫語法 |
---|
0.000053 - SET SQL_BIG_SELECTS = 1 |
0.001769 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000539 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'kfku90v0bcg7tqgieongf2or7u' |
0.000939 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001828 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000928 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000194 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000509 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000203 - select mid from modules where dirname='tadnews' |
0.000343 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000276 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001362 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.011566 - 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.001047 - 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.000886 - 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.000454 - 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.155322 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 23:08:17' and always_top_date!='0000-00-00 00:00:00' |
0.002087 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.930824 - 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-09-30 23:08:16' and (end_day > '2025-09-30 23:08:16' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.354159 - 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-09-30 23:08:16' and (end_day > '2025-09-30 23:08:16' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 9240, 20 |
0.004369 - desc `tadnews_data_center` `sort` |
0.000708 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='169' order by `sort` , `data_sort` |
0.008148 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='169' order by sort |
0.002094 - SELECT * FROM users WHERE uid = '26' |
0.001080 - select * from tad_news where nsn='169' |
0.000284 - SELECT * FROM users WHERE uid = '26' |
0.008742 - select groupid,name from groups |
0.010207 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='169' order by sort |
0.012811 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='169' order by sort |
0.001563 - SELECT * FROM smiles |
0.009967 - desc `tadnews_data_center` `sort` |
0.000201 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='168' order by `sort` , `data_sort` |
0.005470 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='168' order by sort |
0.000479 - SELECT * FROM users WHERE uid = '18' |
0.000418 - select * from tad_news where nsn='168' |
0.001626 - SELECT * FROM users WHERE uid = '18' |
0.000179 - select groupid,name from groups |
0.014003 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='168' order by sort |
0.012456 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='168' order by sort |
0.007429 - desc `tadnews_data_center` `sort` |
0.000560 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='167' order by `sort` , `data_sort` |
0.005660 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='167' order by sort |
0.000588 - SELECT * FROM users WHERE uid = '24' |
0.000148 - select * from tad_news where nsn='167' |
0.000273 - SELECT * FROM users WHERE uid = '24' |
0.001509 - select groupid,name from groups |
0.006034 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='167' order by sort |
0.011500 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='167' order by sort |
0.008271 - desc `tadnews_data_center` `sort` |
0.005180 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='166' order by `sort` , `data_sort` |
0.005829 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='166' order by sort |
0.001449 - SELECT * FROM users WHERE uid = '24' |
0.000454 - select * from tad_news where nsn='166' |
0.000236 - SELECT * FROM users WHERE uid = '24' |
0.000242 - select groupid,name from groups |
0.012834 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='166' order by sort |
0.006047 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='166' order by sort |
0.006424 - desc `tadnews_data_center` `sort` |
0.005668 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='165' order by `sort` , `data_sort` |
0.006509 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='165' order by sort |
0.000648 - SELECT * FROM users WHERE uid = '26' |
0.000125 - select * from tad_news where nsn='165' |
0.000283 - SELECT * FROM users WHERE uid = '26' |
0.001190 - select groupid,name from groups |
0.012762 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='165' order by sort |
0.013276 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='165' order by sort |
0.006077 - desc `tadnews_data_center` `sort` |
0.000223 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='164' order by `sort` , `data_sort` |
0.006459 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='164' order by sort |
0.000476 - SELECT * FROM users WHERE uid = '24' |
0.000124 - select * from tad_news where nsn='164' |
0.001496 - SELECT * FROM users WHERE uid = '24' |
0.006966 - select groupid,name from groups |
0.006284 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='164' order by sort |
0.012425 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='164' order by sort |
0.006411 - desc `tadnews_data_center` `sort` |
0.001109 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='163' order by `sort` , `data_sort` |
0.012962 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='163' order by sort |
0.000154 - select * from tad_news where nsn='163' |
0.000283 - SELECT * FROM users WHERE uid = '24' |
0.000153 - select groupid,name from groups |
0.004949 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='163' order by sort |
0.011417 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='163' order by sort |
0.006746 - desc `tadnews_data_center` `sort` |
0.000351 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='162' order by `sort` , `data_sort` |
0.006735 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='162' order by sort |
0.001006 - SELECT * FROM users WHERE uid = '24' |
0.007051 - select * from tad_news where nsn='162' |
0.000266 - SELECT * FROM users WHERE uid = '24' |
0.000081 - select groupid,name from groups |
0.005932 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='162' order by sort |
0.013613 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='162' order by sort |
0.005966 - desc `tadnews_data_center` `sort` |
0.000395 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='161' order by `sort` , `data_sort` |
0.005698 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='161' order by sort |
0.001510 - SELECT * FROM users WHERE uid = '24' |
0.181490 - select * from tad_news where nsn='161' |
0.000218 - SELECT * FROM users WHERE uid = '24' |
0.000204 - select groupid,name from groups |
0.006678 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='161' order by sort |
0.021810 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='161' order by sort |
0.025729 - desc `tadnews_data_center` `sort` |
0.000683 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='160' order by `sort` , `data_sort` |
0.013691 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='160' order by sort |
0.001521 - SELECT * FROM users WHERE uid = '24' |
0.000934 - select * from tad_news where nsn='160' |
0.007549 - SELECT * FROM users WHERE uid = '24' |
0.000086 - select groupid,name from groups |
0.006771 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='160' order by sort |
0.014482 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='160' order by sort |
0.002060 - desc `tadnews_data_center` `sort` |
0.001920 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='159' order by `sort` , `data_sort` |
0.017925 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='159' order by sort |
0.000209 - SELECT * FROM users WHERE uid = '24' |
0.007661 - select * from tad_news where nsn='159' |
0.000298 - SELECT * FROM users WHERE uid = '24' |
0.000386 - select groupid,name from groups |
0.009804 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='159' order by sort |
0.010645 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='159' order by sort |
0.003220 - desc `tadnews_data_center` `sort` |
0.000605 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='158' order by `sort` , `data_sort` |
0.007415 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='158' order by sort |
0.000141 - SELECT * FROM users WHERE uid = '24' |
0.000271 - select * from tad_news where nsn='158' |
0.000287 - SELECT * FROM users WHERE uid = '24' |
0.000886 - select groupid,name from groups |
0.006441 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='158' order by sort |
0.006606 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='158' order by sort |
0.000644 - desc `tadnews_data_center` `sort` |
0.000316 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='157' order by `sort` , `data_sort` |
0.005619 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='157' order by sort |
0.000209 - select * from tad_news where nsn='157' |
0.000102 - SELECT * FROM users WHERE uid = '24' |
0.000087 - select groupid,name from groups |
0.004559 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='157' order by sort |
0.005215 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='157' order by sort |
0.000481 - desc `tadnews_data_center` `sort` |
0.000337 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='153' order by `sort` , `data_sort` |
0.009776 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='153' order by sort |
0.000184 - SELECT * FROM users WHERE uid = '16' |
0.000235 - SELECT * FROM users WHERE uid = '16' |
0.000204 - select * from tad_news where nsn='153' |
0.000084 - SELECT * FROM users WHERE uid = '16' |
0.000096 - select groupid,name from groups |
0.009201 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='153' order by sort |
0.008450 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='153' order by sort |
0.007268 - desc `tadnews_data_center` `sort` |
0.000945 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='152' order by `sort` , `data_sort` |
0.006906 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='152' order by sort |
0.000908 - SELECT * FROM users WHERE uid = '9' |
0.009841 - SELECT * FROM users WHERE uid = '9' |
0.000269 - SELECT * FROM users WHERE uid = '9' |
0.000107 - select * from tad_news where nsn='152' |
0.000071 - SELECT * FROM users WHERE uid = '9' |
0.000302 - select groupid,name from groups |
0.006268 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='152' order by sort |
0.013881 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='152' order by sort |
0.009473 - desc `tadnews_data_center` `sort` |
0.000576 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='151' order by `sort` , `data_sort` |
0.007568 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='151' order by sort |
0.010457 - select * from tad_news where nsn='151' |
0.000535 - SELECT * FROM users WHERE uid = '18' |
0.000261 - select groupid,name from groups |
0.006908 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='151' order by sort |
0.009936 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='151' order by sort |
0.009475 - desc `tadnews_data_center` `sort` |
0.000444 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='150' order by `sort` , `data_sort` |
0.006917 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='150' order by sort |
0.007617 - SELECT * FROM users WHERE uid = '15' |
0.000498 - select * from tad_news where nsn='150' |
0.000271 - SELECT * FROM users WHERE uid = '15' |
0.000384 - select groupid,name from groups |
0.013262 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='150' order by sort |
0.026754 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='150' order by sort |
0.005188 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001758 - desc `tadnews_data_center` `sort` |
0.006086 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='149' order by `sort` , `data_sort` |
0.047793 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='149' order by sort |
0.001533 - SELECT * FROM users WHERE uid = '26' |
0.002620 - select * from tad_news where nsn='149' |
0.002337 - SELECT * FROM users WHERE uid = '26' |
0.004603 - select groupid,name from groups |
0.008312 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='149' order by sort |
0.009179 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='149' order by sort |
0.002465 - desc `tadnews_data_center` `sort` |
0.002167 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='148' order by `sort` , `data_sort` |
0.020859 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='148' order by sort |
0.000522 - select * from tad_news where nsn='148' |
0.000684 - SELECT * FROM users WHERE uid = '26' |
0.000686 - select groupid,name from groups |
0.008463 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='148' order by sort |
0.008110 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='148' order by sort |
0.001989 - desc `tadnews_data_center` `sort` |
0.000855 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='147' order by `sort` , `data_sort` |
0.007969 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='147' order by sort |
0.000657 - SELECT * FROM users WHERE uid = '26' |
0.000340 - select * from tad_news where nsn='147' |
0.000137 - SELECT * FROM users WHERE uid = '26' |
0.000114 - select groupid,name from groups |
0.006649 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='147' order by sort |
0.005970 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='147' order by sort |
0.000575 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.001107 - 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 |