資料庫語法 |
---|
0.000198 - SET SQL_BIG_SELECTS = 1 |
0.001458 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000692 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'up23r31jpk035pkhl7sqdon46h' |
0.000827 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001469 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000743 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000531 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000784 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000417 - select mid from modules where dirname='tadnews' |
0.000484 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000192 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001635 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002160 - 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.000597 - 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.001556 - 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.000661 - 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.278723 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 01:26:11' and always_top_date!='0000-00-00 00:00:00' |
0.000792 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.137580 - select * from tad_news where 1 and enable='1' and prefix_tag = '12' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 01:26:10' and (end_day > '2025-09-30 01:26:10' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.039851 - select * from tad_news where 1 and enable='1' and prefix_tag = '12' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 01:26:10' and (end_day > '2025-09-30 01:26:10' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 40, 20 |
0.001348 - desc `tadnews_data_center` `sort` |
0.000562 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10491' order by `sort` , `data_sort` |
0.006706 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10491' order by sort |
0.000258 - SELECT * FROM users WHERE uid = '37' |
0.000126 - select * from tad_news where nsn='10491' |
0.000430 - select groupid,name from groups |
0.007279 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10491' order by sort |
0.006941 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10491' order by sort |
0.000157 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000088 - SELECT * FROM smiles |
0.000542 - desc `tadnews_data_center` `sort` |
0.000381 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10476' order by `sort` , `data_sort` |
0.007927 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10476' order by sort |
0.000332 - select * from tad_news where nsn='10476' |
0.000105 - select groupid,name from groups |
0.005714 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10476' order by sort |
0.004223 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10476' order by sort |
0.000121 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000342 - desc `tadnews_data_center` `sort` |
0.000283 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10475' order by `sort` , `data_sort` |
0.007936 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10475' order by sort |
0.000180 - select * from tad_news where nsn='10475' |
0.000084 - select groupid,name from groups |
0.005482 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10475' order by sort |
0.006039 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10475' order by sort |
0.000455 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001516 - 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`='10474' order by `sort` , `data_sort` |
0.006462 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10474' order by sort |
0.000168 - select * from tad_news where nsn='10474' |
0.000116 - select groupid,name from groups |
0.008923 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10474' order by sort |
0.006348 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10474' order by sort |
0.000369 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000908 - desc `tadnews_data_center` `sort` |
0.000224 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10473' order by `sort` , `data_sort` |
0.007310 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10473' order by sort |
0.000473 - select * from tad_news where nsn='10473' |
0.000143 - select groupid,name from groups |
0.005026 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10473' order by sort |
0.004881 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10473' order by sort |
0.000351 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.005051 - desc `tadnews_data_center` `sort` |
0.000603 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10472' order by `sort` , `data_sort` |
0.005442 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10472' order by sort |
0.000198 - select * from tad_news where nsn='10472' |
0.000149 - select groupid,name from groups |
0.012246 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10472' order by sort |
0.010815 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10472' order by sort |
0.006563 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001357 - desc `tadnews_data_center` `sort` |
0.000313 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10471' order by `sort` , `data_sort` |
0.005760 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10471' order by sort |
0.004823 - select * from tad_news where nsn='10471' |
0.000095 - select groupid,name from groups |
0.005792 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10471' order by sort |
0.008002 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10471' order by sort |
0.006234 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.008545 - desc `tadnews_data_center` `sort` |
0.000664 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10470' order by `sort` , `data_sort` |
0.005194 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10470' order by sort |
0.000375 - select * from tad_news where nsn='10470' |
0.000106 - select groupid,name from groups |
0.012133 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10470' order by sort |
0.008448 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10470' order by sort |
0.000131 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000666 - desc `tadnews_data_center` `sort` |
0.000166 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10469' order by `sort` , `data_sort` |
0.005558 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10469' order by sort |
0.000211 - select * from tad_news where nsn='10469' |
0.000243 - select groupid,name from groups |
0.004282 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10469' order by sort |
0.005583 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10469' order by sort |
0.000300 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001610 - desc `tadnews_data_center` `sort` |
0.000550 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10468' order by `sort` , `data_sort` |
0.004897 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10468' order by sort |
0.000140 - select * from tad_news where nsn='10468' |
0.000123 - select groupid,name from groups |
0.004289 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10468' order by sort |
0.004091 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10468' order by sort |
0.000196 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000695 - desc `tadnews_data_center` `sort` |
0.000653 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10467' order by `sort` , `data_sort` |
0.007421 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10467' order by sort |
0.000555 - select * from tad_news where nsn='10467' |
0.000082 - select groupid,name from groups |
0.004789 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10467' order by sort |
0.006338 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10467' order by sort |
0.000267 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000570 - desc `tadnews_data_center` `sort` |
0.000567 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10466' order by `sort` , `data_sort` |
0.005336 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10466' order by sort |
0.000434 - select * from tad_news where nsn='10466' |
0.000160 - select groupid,name from groups |
0.005386 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10466' order by sort |
0.005283 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10466' order by sort |
0.000370 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000394 - desc `tadnews_data_center` `sort` |
0.000216 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10439' order by `sort` , `data_sort` |
0.008320 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10439' order by sort |
0.000214 - select * from tad_news where nsn='10439' |
0.000208 - select groupid,name from groups |
0.006664 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10439' order by sort |
0.005818 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10439' order by sort |
0.000301 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000975 - desc `tadnews_data_center` `sort` |
0.000752 - 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.004926 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10390' order by sort |
0.000183 - select * from tad_news where nsn='10390' |
0.000084 - select groupid,name from groups |
0.004952 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10390' order by sort |
0.004628 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10390' order by sort |
0.001374 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000742 - desc `tadnews_data_center` `sort` |
0.000338 - 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.005803 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10389' order by sort |
0.000136 - select * from tad_news where nsn='10389' |
0.000197 - select groupid,name from groups |
0.005231 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10389' order by sort |
0.006218 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10389' order by sort |
0.000260 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000352 - desc `tadnews_data_center` `sort` |
0.000172 - 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.004630 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10388' order by sort |
0.000279 - select * from tad_news where nsn='10388' |
0.000143 - select groupid,name from groups |
0.005003 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10388' order by sort |
0.005045 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10388' order by sort |
0.010269 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001403 - desc `tadnews_data_center` `sort` |
0.000357 - 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.005150 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10387' order by sort |
0.007103 - select * from tad_news where nsn='10387' |
0.000091 - select groupid,name from groups |
0.006360 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10387' order by sort |
0.006747 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10387' order by sort |
0.000160 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001428 - desc `tadnews_data_center` `sort` |
0.000724 - 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.005877 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10386' order by sort |
0.000271 - select * from tad_news where nsn='10386' |
0.000087 - select groupid,name from groups |
0.005007 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10386' order by sort |
0.007426 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10386' order by sort |
0.000154 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000584 - desc `tadnews_data_center` `sort` |
0.000460 - 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.005129 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10385' order by sort |
0.000210 - select * from tad_news where nsn='10385' |
0.000127 - select groupid,name from groups |
0.006669 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10385' order by sort |
0.006764 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10385' order by sort |
0.000119 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001144 - desc `tadnews_data_center` `sort` |
0.000197 - 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.005138 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10384' order by sort |
0.000498 - select * from tad_news where nsn='10384' |
0.000128 - select groupid,name from groups |
0.006294 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10384' order by sort |
0.005789 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10384' order by sort |
0.000290 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000110 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000340 - 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 |