資料庫語法 |
---|
0.000106 - SET SQL_BIG_SELECTS = 1 |
0.002797 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000786 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'r5egi4sfmdtmdsvggkt3o48ddu' |
0.000711 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001325 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000917 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000456 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000249 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000301 - select mid from modules where dirname='tadnews' |
0.000495 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000295 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001422 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.003551 - 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.000867 - 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.000656 - 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.000541 - 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.277102 - update tad_news set always_top='0' WHERE always_top_date <='2025-10-01 01:31:05' and always_top_date!='0000-00-00 00:00:00' |
0.001954 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.689317 - 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 01:31:04' and (end_day > '2025-10-01 01:31:04' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.555797 - 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 01:31:04' and (end_day > '2025-10-01 01:31:04' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 7800, 20 |
0.003762 - desc `tadnews_data_center` `sort` |
0.000412 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2486' order by `sort` , `data_sort` |
0.007362 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2486' order by sort |
0.002507 - SELECT * FROM users WHERE uid = '41' |
0.002264 - SELECT * FROM users WHERE uid = '41' |
0.001931 - select * from tad_news where nsn='2486' |
0.006520 - SELECT * FROM users WHERE uid = '41' |
0.000108 - select groupid,name from groups |
0.006592 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2486' order by sort |
0.030094 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2486' order by sort |
0.004203 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000114 - SELECT * FROM smiles |
0.000345 - 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`='2485' order by `sort` , `data_sort` |
0.005410 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2485' order by sort |
0.001095 - select * from tad_news where nsn='2485' |
0.014371 - SELECT * FROM users WHERE uid = '41' |
0.000111 - select groupid,name from groups |
0.004177 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2485' order by sort |
0.003702 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2485' order by sort |
0.000165 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000377 - desc `tadnews_data_center` `sort` |
0.000179 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2483' order by `sort` , `data_sort` |
0.004405 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2483' order by sort |
0.000151 - SELECT * FROM users WHERE uid = '24' |
0.000101 - SELECT * FROM users WHERE uid = '24' |
0.000115 - select * from tad_news where nsn='2483' |
0.000087 - SELECT * FROM users WHERE uid = '24' |
0.000084 - select groupid,name from groups |
0.003988 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2483' order by sort |
0.003784 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2483' order by sort |
0.000155 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000352 - desc `tadnews_data_center` `sort` |
0.000204 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2481' order by `sort` , `data_sort` |
0.003989 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2481' order by sort |
0.000156 - select * from tad_news where nsn='2481' |
0.000112 - SELECT * FROM users WHERE uid = '21' |
0.000093 - select groupid,name from groups |
0.012378 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2481' order by sort |
0.007298 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2481' order by sort |
0.004541 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000345 - desc `tadnews_data_center` `sort` |
0.002169 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2479' order by `sort` , `data_sort` |
0.004118 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2479' order by sort |
0.000137 - SELECT * FROM users WHERE uid = '41' |
0.000125 - SELECT * FROM users WHERE uid = '41' |
0.000246 - SELECT * FROM users WHERE uid = '41' |
0.000079 - SELECT * FROM users WHERE uid = '41' |
0.000143 - select * from tad_news where nsn='2479' |
0.000087 - SELECT * FROM users WHERE uid = '41' |
0.000083 - select groupid,name from groups |
0.004369 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2479' order by sort |
0.003469 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2479' order by sort |
0.000114 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000352 - desc `tadnews_data_center` `sort` |
0.000163 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2478' order by `sort` , `data_sort` |
0.004156 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2478' order by sort |
0.000139 - select * from tad_news where nsn='2478' |
0.000101 - SELECT * FROM users WHERE uid = '41' |
0.000080 - select groupid,name from groups |
0.003733 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2478' order by sort |
0.003890 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2478' order by sort |
0.000210 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000671 - desc `tadnews_data_center` `sort` |
0.000168 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2477' order by `sort` , `data_sort` |
0.004366 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2477' order by sort |
0.000135 - SELECT * FROM users WHERE uid = '41' |
0.000087 - SELECT * FROM users WHERE uid = '41' |
0.000078 - SELECT * FROM users WHERE uid = '41' |
0.000077 - SELECT * FROM users WHERE uid = '41' |
0.000106 - select * from tad_news where nsn='2477' |
0.000080 - SELECT * FROM users WHERE uid = '41' |
0.000078 - select groupid,name from groups |
0.003959 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2477' order by sort |
0.004104 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2477' order by sort |
0.000118 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000324 - desc `tadnews_data_center` `sort` |
0.000271 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2476' order by `sort` , `data_sort` |
0.004506 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2476' order by sort |
0.000156 - SELECT * FROM users WHERE uid = '41' |
0.000104 - SELECT * FROM users WHERE uid = '41' |
0.000118 - select * from tad_news where nsn='2476' |
0.000120 - SELECT * FROM users WHERE uid = '41' |
0.000148 - select groupid,name from groups |
0.004982 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2476' order by sort |
0.005283 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2476' order by sort |
0.000145 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001871 - desc `tadnews_data_center` `sort` |
0.000194 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2475' order by `sort` , `data_sort` |
0.006376 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2475' order by sort |
0.000185 - SELECT * FROM users WHERE uid = '37' |
0.000347 - select * from tad_news where nsn='2475' |
0.000099 - select groupid,name from groups |
0.005786 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2475' order by sort |
0.004565 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2475' order by sort |
0.000285 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000579 - 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`='2474' order by `sort` , `data_sort` |
0.004539 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2474' order by sort |
0.000316 - select * from tad_news where nsn='2474' |
0.000176 - select groupid,name from groups |
0.004852 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2474' order by sort |
0.005335 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2474' order by sort |
0.000584 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001370 - desc `tadnews_data_center` `sort` |
0.000726 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2473' order by `sort` , `data_sort` |
0.006885 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2473' order by sort |
0.000554 - select * from tad_news where nsn='2473' |
0.000224 - select groupid,name from groups |
0.005845 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2473' order by sort |
0.008514 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2473' order by sort |
0.000397 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.003110 - desc `tadnews_data_center` `sort` |
0.000921 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2472' order by `sort` , `data_sort` |
0.007552 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2472' order by sort |
0.000191 - select * from tad_news where nsn='2472' |
0.000356 - select groupid,name from groups |
0.006983 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2472' order by sort |
0.007171 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2472' order by sort |
0.000390 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001928 - desc `tadnews_data_center` `sort` |
0.000286 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2471' order by `sort` , `data_sort` |
0.007959 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2471' order by sort |
0.002518 - select * from tad_news where nsn='2471' |
0.000464 - select groupid,name from groups |
0.007733 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2471' order by sort |
0.008465 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2471' order by sort |
0.000189 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000791 - desc `tadnews_data_center` `sort` |
0.000437 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2470' order by `sort` , `data_sort` |
0.007302 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2470' order by sort |
0.000456 - select * from tad_news where nsn='2470' |
0.000199 - select groupid,name from groups |
0.006637 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2470' order by sort |
0.006926 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2470' order by sort |
0.000156 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000501 - desc `tadnews_data_center` `sort` |
0.000191 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2469' order by `sort` , `data_sort` |
0.006865 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2469' order by sort |
0.000183 - select * from tad_news where nsn='2469' |
0.000106 - select groupid,name from groups |
0.006541 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2469' order by sort |
0.005621 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2469' order by sort |
0.000280 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000570 - desc `tadnews_data_center` `sort` |
0.000222 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2468' order by `sort` , `data_sort` |
0.006082 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2468' order by sort |
0.000156 - select * from tad_news where nsn='2468' |
0.000098 - select groupid,name from groups |
0.006235 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2468' order by sort |
0.005579 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2468' order by sort |
0.000650 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000739 - desc `tadnews_data_center` `sort` |
0.000937 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2467' order by `sort` , `data_sort` |
0.006912 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2467' order by sort |
0.000175 - select * from tad_news where nsn='2467' |
0.000477 - select groupid,name from groups |
0.008932 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2467' order by sort |
0.006769 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2467' order by sort |
0.000399 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001545 - desc `tadnews_data_center` `sort` |
0.000431 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2455' order by `sort` , `data_sort` |
0.007202 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2455' order by sort |
0.000367 - SELECT * FROM users WHERE uid = '17' |
0.000495 - select * from tad_news where nsn='2455' |
0.000256 - SELECT * FROM users WHERE uid = '17' |
0.000249 - select groupid,name from groups |
0.007385 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2455' order by sort |
0.007547 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2455' order by sort |
0.000635 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001146 - desc `tadnews_data_center` `sort` |
0.000627 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2462' order by `sort` , `data_sort` |
0.007239 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2462' order by sort |
0.001095 - select * from tad_news where nsn='2462' |
0.000528 - SELECT * FROM users WHERE uid = '16' |
0.000291 - select groupid,name from groups |
0.006858 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2462' order by sort |
0.007041 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2462' order by sort |
0.000660 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.003180 - desc `tadnews_data_center` `sort` |
0.000390 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2461' order by `sort` , `data_sort` |
0.008723 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2461' order by sort |
0.000828 - SELECT * FROM users WHERE uid = '16' |
0.000512 - select * from tad_news where nsn='2461' |
0.000293 - SELECT * FROM users WHERE uid = '16' |
0.000413 - select groupid,name from groups |
0.007165 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2461' order by sort |
0.006426 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2461' order by sort |
0.000150 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000607 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.001135 - 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 |