資料庫語法 |
---|
0.000061 - SET SQL_BIG_SELECTS = 1 |
0.001343 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000150 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'klqgopmjlfjkhg9anjveps5sh0' |
0.000249 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001559 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000856 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000503 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000211 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000094 - select mid from modules where dirname='tadnews' |
0.000330 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000218 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001093 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002605 - 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.000856 - 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.000286 - 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.000377 - 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.138829 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 10:04:42' and always_top_date!='0000-00-00 00:00:00' |
0.000562 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.342945 - 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 10:04:41' and (end_day > '2025-09-30 10:04:41' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.138011 - 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 10:04:41' and (end_day > '2025-09-30 10:04:41' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 7340, 20 |
0.000438 - 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`='3025' order by `sort` , `data_sort` |
0.006293 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3025' order by sort |
0.000184 - select * from tad_news where nsn='3025' |
0.000138 - SELECT * FROM users WHERE uid = '184' |
0.000093 - select groupid,name from groups |
0.004778 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3025' order by sort |
0.004691 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3025' order by sort |
0.000180 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000413 - SELECT * FROM smiles |
0.000866 - desc `tadnews_data_center` `sort` |
0.000249 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3024' order by `sort` , `data_sort` |
0.006859 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3024' order by sort |
0.000351 - SELECT * FROM users WHERE uid = '180' |
0.000197 - select * from tad_news where nsn='3024' |
0.000089 - select groupid,name from groups |
0.006249 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3024' order by sort |
0.006057 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3024' order by sort |
0.000562 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001344 - desc `tadnews_data_center` `sort` |
0.000593 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3023' order by `sort` , `data_sort` |
0.007847 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3023' order by sort |
0.000817 - select * from tad_news where nsn='3023' |
0.000121 - SELECT * FROM users WHERE uid = '176' |
0.000083 - select groupid,name from groups |
0.005606 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3023' order by sort |
0.005868 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3023' order by sort |
0.000170 - select font_color,color,tag from tad_news_tags where `tag_sn`='10' and enable='1' |
0.000428 - desc `tadnews_data_center` `sort` |
0.000277 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3020' order by `sort` , `data_sort` |
0.006775 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3020' order by sort |
0.000565 - SELECT * FROM users WHERE uid = '37' |
0.000212 - select * from tad_news where nsn='3020' |
0.000276 - select groupid,name from groups |
0.006223 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3020' order by sort |
0.005310 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3020' order by sort |
0.000459 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001383 - desc `tadnews_data_center` `sort` |
0.000487 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3019' order by `sort` , `data_sort` |
0.006969 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3019' order by sort |
0.000553 - select * from tad_news where nsn='3019' |
0.000385 - select groupid,name from groups |
0.005097 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3019' order by sort |
0.006432 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3019' order by sort |
0.000633 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001238 - desc `tadnews_data_center` `sort` |
0.001025 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3018' order by `sort` , `data_sort` |
0.007470 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3018' order by sort |
0.000547 - select * from tad_news where nsn='3018' |
0.000114 - select groupid,name from groups |
0.006372 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3018' order by sort |
0.006499 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3018' order by sort |
0.000787 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001342 - desc `tadnews_data_center` `sort` |
0.000788 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3017' order by `sort` , `data_sort` |
0.007710 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3017' order by sort |
0.000151 - select * from tad_news where nsn='3017' |
0.000287 - select groupid,name from groups |
0.006840 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3017' order by sort |
0.006274 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3017' order by sort |
0.000173 - select font_color,color,tag from tad_news_tags where `tag_sn`='2' and enable='1' |
0.001013 - desc `tadnews_data_center` `sort` |
0.000523 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3016' order by `sort` , `data_sort` |
0.006906 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3016' order by sort |
0.000574 - select * from tad_news where nsn='3016' |
0.000411 - select groupid,name from groups |
0.007479 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3016' order by sort |
0.005746 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3016' order by sort |
0.000280 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001294 - desc `tadnews_data_center` `sort` |
0.000406 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3015' order by `sort` , `data_sort` |
0.007492 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3015' order by sort |
0.000556 - SELECT * FROM users WHERE uid = '183' |
0.000593 - select * from tad_news where nsn='3015' |
0.000184 - select groupid,name from groups |
0.006926 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3015' order by sort |
0.005770 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3015' order by sort |
0.000882 - desc `tadnews_data_center` `sort` |
0.001778 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3014' order by `sort` , `data_sort` |
0.007898 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3014' order by sort |
0.000385 - SELECT * FROM users WHERE uid = '178' |
0.000997 - select * from tad_news where nsn='3014' |
0.000302 - select groupid,name from groups |
0.009310 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3014' order by sort |
0.007123 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3014' order by sort |
0.000334 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001248 - desc `tadnews_data_center` `sort` |
0.000434 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3013' order by `sort` , `data_sort` |
0.007486 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3013' order by sort |
0.001269 - select * from tad_news where nsn='3013' |
0.000440 - select groupid,name from groups |
0.006453 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3013' order by sort |
0.006580 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3013' order by sort |
0.000164 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000514 - desc `tadnews_data_center` `sort` |
0.000321 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3012' order by `sort` , `data_sort` |
0.006343 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3012' order by sort |
0.000612 - select * from tad_news where nsn='3012' |
0.000095 - select groupid,name from groups |
0.005186 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3012' order by sort |
0.005441 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3012' order by sort |
0.000279 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000979 - desc `tadnews_data_center` `sort` |
0.000405 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3011' order by `sort` , `data_sort` |
0.007306 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3011' order by sort |
0.000278 - select * from tad_news where nsn='3011' |
0.000318 - select groupid,name from groups |
0.006872 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3011' order by sort |
0.006014 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3011' order by sort |
0.000235 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000539 - desc `tadnews_data_center` `sort` |
0.000440 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3010' order by `sort` , `data_sort` |
0.006525 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3010' order by sort |
0.000308 - select * from tad_news where nsn='3010' |
0.000245 - select groupid,name from groups |
0.006013 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3010' order by sort |
0.006135 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3010' order by sort |
0.000214 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001095 - desc `tadnews_data_center` `sort` |
0.000442 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3009' order by `sort` , `data_sort` |
0.005800 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3009' order by sort |
0.000368 - select * from tad_news where nsn='3009' |
0.000350 - select groupid,name from groups |
0.006461 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3009' order by sort |
0.005503 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3009' order by sort |
0.000290 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000694 - desc `tadnews_data_center` `sort` |
0.000270 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3008' order by `sort` , `data_sort` |
0.007388 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3008' order by sort |
0.000695 - select * from tad_news where nsn='3008' |
0.000836 - select groupid,name from groups |
0.006666 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3008' order by sort |
0.006146 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3008' order by sort |
0.000379 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001144 - desc `tadnews_data_center` `sort` |
0.000476 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3007' order by `sort` , `data_sort` |
0.006701 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3007' order by sort |
0.000766 - select * from tad_news where nsn='3007' |
0.000094 - select groupid,name from groups |
0.004984 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3007' order by sort |
0.007126 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3007' order by sort |
0.000421 - select font_color,color,tag from tad_news_tags where `tag_sn`='2' and enable='1' |
0.000803 - desc `tadnews_data_center` `sort` |
0.000383 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3006' order by `sort` , `data_sort` |
0.009620 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3006' order by sort |
0.000657 - select * from tad_news where nsn='3006' |
0.000130 - select groupid,name from groups |
0.006624 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3006' order by sort |
0.006577 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3006' order by sort |
0.000205 - select font_color,color,tag from tad_news_tags where `tag_sn`='10' and enable='1' |
0.001199 - desc `tadnews_data_center` `sort` |
0.000599 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3005' order by `sort` , `data_sort` |
0.006386 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3005' order by sort |
0.000544 - select * from tad_news where nsn='3005' |
0.000532 - select groupid,name from groups |
0.006458 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3005' order by sort |
0.006014 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3005' order by sort |
0.000557 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001385 - desc `tadnews_data_center` `sort` |
0.000539 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3004' order by `sort` , `data_sort` |
0.006203 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3004' order by sort |
0.000343 - select * from tad_news where nsn='3004' |
0.000340 - SELECT * FROM users WHERE uid = '182' |
0.000094 - select groupid,name from groups |
0.005859 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3004' order by sort |
0.006192 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3004' order by sort |
0.000259 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000438 - 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 |