資料庫語法 |
---|
0.003244 - SET SQL_BIG_SELECTS = 1 |
0.001702 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.013983 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '5h3bfqps2d5ht96csr19153qou' |
0.002721 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001224 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.006805 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000411 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000668 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.002685 - select mid from modules where dirname='tadnews' |
0.000585 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.013351 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.002236 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.003382 - 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.001382 - 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.000608 - 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.000330 - 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.338644 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 21:22:39' and always_top_date!='0000-00-00 00:00:00' |
0.000822 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
1.964366 - 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 21:22:38' and (end_day > '2025-09-30 21:22:38' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.780317 - 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 21:22:38' and (end_day > '2025-09-30 21:22:38' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 580, 20 |
0.002742 - desc `tadnews_data_center` `sort` |
0.005861 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10393' order by `sort` , `data_sort` |
0.054455 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10393' order by sort |
0.007433 - select * from tad_news where nsn='10393' |
0.002409 - SELECT * FROM users WHERE uid = '278' |
0.000303 - select groupid,name from groups |
0.028101 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10393' order by sort |
0.004979 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10393' order by sort |
0.017920 - select font_color,color,tag from tad_news_tags where `tag_sn`='10' and enable='1' |
0.000235 - SELECT * FROM smiles |
0.000803 - desc `tadnews_data_center` `sort` |
0.004167 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10392' order by `sort` , `data_sort` |
0.029986 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10392' order by sort |
0.006509 - SELECT * FROM users WHERE uid = '180' |
0.005388 - select * from tad_news where nsn='10392' |
0.000213 - select groupid,name from groups |
0.010239 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10392' order by sort |
0.033283 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10392' order by sort |
0.002568 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002892 - desc `tadnews_data_center` `sort` |
0.004290 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10391' order by `sort` , `data_sort` |
0.013185 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10391' order by sort |
0.014344 - select * from tad_news where nsn='10391' |
0.000271 - select groupid,name from groups |
0.013693 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10391' order by sort |
0.006425 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10391' order by sort |
0.006445 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000699 - desc `tadnews_data_center` `sort` |
0.000362 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10390' order by `sort` , `data_sort` |
0.018192 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10390' order by sort |
0.000552 - SELECT * FROM users WHERE uid = '37' |
0.000417 - select * from tad_news where nsn='10390' |
0.006820 - select groupid,name from groups |
0.018955 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10390' order by sort |
0.010229 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10390' order by sort |
0.014231 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001524 - 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`='10389' order by `sort` , `data_sort` |
0.036716 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10389' order by sort |
0.000334 - select * from tad_news where nsn='10389' |
0.000095 - select groupid,name from groups |
0.009269 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10389' order by sort |
0.043963 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10389' order by sort |
0.000273 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000716 - desc `tadnews_data_center` `sort` |
0.000583 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10388' order by `sort` , `data_sort` |
0.027533 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10388' order by sort |
0.006604 - select * from tad_news where nsn='10388' |
0.007272 - select groupid,name from groups |
0.014820 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10388' order by sort |
0.038259 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10388' order by sort |
0.005151 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.002898 - desc `tadnews_data_center` `sort` |
0.000245 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10387' order by `sort` , `data_sort` |
0.015482 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10387' order by sort |
0.018152 - select * from tad_news where nsn='10387' |
0.000172 - select groupid,name from groups |
0.011578 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10387' order by sort |
0.017917 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10387' order by sort |
0.025394 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.002643 - desc `tadnews_data_center` `sort` |
0.000346 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10386' order by `sort` , `data_sort` |
0.020654 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10386' order by sort |
0.004462 - select * from tad_news where nsn='10386' |
0.000331 - select groupid,name from groups |
0.029441 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10386' order by sort |
0.035884 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10386' order by sort |
0.007099 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001533 - desc `tadnews_data_center` `sort` |
0.005841 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10385' order by `sort` , `data_sort` |
0.024770 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10385' order by sort |
0.005742 - select * from tad_news where nsn='10385' |
0.003537 - select groupid,name from groups |
0.018354 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10385' order by sort |
0.027965 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10385' order by sort |
0.011870 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.006434 - desc `tadnews_data_center` `sort` |
0.011752 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10384' order by `sort` , `data_sort` |
0.016763 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10384' order by sort |
0.009818 - select * from tad_news where nsn='10384' |
0.000527 - select groupid,name from groups |
0.031880 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10384' order by sort |
0.027458 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10384' order by sort |
0.004174 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000494 - desc `tadnews_data_center` `sort` |
0.000739 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10383' order by `sort` , `data_sort` |
0.021397 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10383' order by sort |
0.010298 - SELECT * FROM users WHERE uid = '186' |
0.000207 - select * from tad_news where nsn='10383' |
0.000232 - select groupid,name from groups |
0.024211 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10383' order by sort |
0.015072 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10383' order by sort |
0.027336 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001430 - desc `tadnews_data_center` `sort` |
0.014626 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10382' order by `sort` , `data_sort` |
0.027364 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10382' order by sort |
0.008938 - select * from tad_news where nsn='10382' |
0.000788 - select groupid,name from groups |
0.005185 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10382' order by sort |
0.035856 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10382' order by sort |
0.007283 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001384 - desc `tadnews_data_center` `sort` |
0.006888 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10381' order by `sort` , `data_sort` |
0.016856 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10381' order by sort |
0.011750 - select * from tad_news where nsn='10381' |
0.000387 - select groupid,name from groups |
0.043402 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10381' order by sort |
0.010677 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10381' order by sort |
0.011514 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001030 - desc `tadnews_data_center` `sort` |
0.009836 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10380' order by `sort` , `data_sort` |
0.029304 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10380' order by sort |
0.000369 - SELECT * FROM users WHERE uid = '249' |
0.003449 - select * from tad_news where nsn='10380' |
0.002049 - select groupid,name from groups |
0.055833 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10380' order by sort |
0.036286 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10380' order by sort |
0.000113 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.003137 - desc `tadnews_data_center` `sort` |
0.000581 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10379' order by `sort` , `data_sort` |
0.039759 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10379' order by sort |
0.006561 - select * from tad_news where nsn='10379' |
0.000602 - select groupid,name from groups |
0.039274 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10379' order by sort |
0.044858 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10379' order by sort |
0.015271 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002162 - desc `tadnews_data_center` `sort` |
0.002614 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10378' order by `sort` , `data_sort` |
0.039239 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10378' order by sort |
0.018832 - select * from tad_news where nsn='10378' |
0.008440 - select groupid,name from groups |
0.040533 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10378' order by sort |
0.057077 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10378' order by sort |
0.016384 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000535 - desc `tadnews_data_center` `sort` |
0.002815 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10377' order by `sort` , `data_sort` |
0.027471 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10377' order by sort |
0.021874 - select * from tad_news where nsn='10377' |
0.000372 - select groupid,name from groups |
0.022599 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10377' order by sort |
0.028275 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10377' order by sort |
0.001106 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.007266 - desc `tadnews_data_center` `sort` |
0.001536 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10376' order by `sort` , `data_sort` |
0.016439 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10376' order by sort |
0.001384 - select * from tad_news where nsn='10376' |
0.003796 - select groupid,name from groups |
0.007694 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10376' order by sort |
0.036800 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10376' order by sort |
0.003106 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000730 - desc `tadnews_data_center` `sort` |
0.000746 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10375' order by `sort` , `data_sort` |
0.034365 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10375' order by sort |
0.002950 - select * from tad_news where nsn='10375' |
0.000135 - select groupid,name from groups |
0.017794 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10375' order by sort |
0.018373 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10375' order by sort |
0.011935 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.004698 - desc `tadnews_data_center` `sort` |
0.010455 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10374' order by `sort` , `data_sort` |
0.018601 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10374' order by sort |
0.005336 - select * from tad_news where nsn='10374' |
0.000343 - select groupid,name from groups |
0.025550 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10374' order by sort |
0.009449 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10374' order by sort |
0.016459 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001405 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.005557 - 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 |