資料庫語法 |
---|
0.000382 - SET SQL_BIG_SELECTS = 1 |
0.000947 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000610 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '5ml6ub77s6mj7lcf8eiu9nlsnf' |
0.000421 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000986 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000980 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000641 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000190 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000191 - select mid from modules where dirname='tadnews' |
0.000368 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000343 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.002411 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.003476 - 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.000922 - 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.000451 - 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.000364 - 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.417576 - update tad_news set always_top='0' WHERE always_top_date <='2025-10-01 01:31:08' and always_top_date!='0000-00-00 00:00:00' |
0.001627 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
1.701172 - 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:07' and (end_day > '2025-10-01 01:31:07' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.424305 - 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:07' and (end_day > '2025-10-01 01:31:07' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 7960, 20 |
0.001132 - desc `tadnews_data_center` `sort` |
0.000384 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2204' order by `sort` , `data_sort` |
0.007846 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2204' order by sort |
0.011777 - SELECT * FROM users WHERE uid = '41' |
0.000160 - SELECT * FROM users WHERE uid = '41' |
0.000127 - SELECT * FROM users WHERE uid = '41' |
0.000094 - SELECT * FROM users WHERE uid = '41' |
0.000125 - SELECT * FROM users WHERE uid = '41' |
0.000210 - SELECT * FROM users WHERE uid = '41' |
0.000182 - SELECT * FROM users WHERE uid = '41' |
0.000146 - SELECT * FROM users WHERE uid = '41' |
0.000834 - SELECT * FROM users WHERE uid = '41' |
0.000202 - SELECT * FROM users WHERE uid = '41' |
0.000127 - SELECT * FROM users WHERE uid = '41' |
0.000449 - select * from tad_news where nsn='2204' |
0.001106 - SELECT * FROM users WHERE uid = '41' |
0.000166 - select groupid,name from groups |
0.006638 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2204' order by sort |
0.020329 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2204' order by sort |
0.003608 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000910 - SELECT * FROM smiles |
0.000613 - desc `tadnews_data_center` `sort` |
0.006078 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2203' order by `sort` , `data_sort` |
0.016810 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2203' order by sort |
0.000372 - SELECT * FROM users WHERE uid = '41' |
0.000407 - SELECT * FROM users WHERE uid = '41' |
0.000148 - SELECT * FROM users WHERE uid = '41' |
0.000246 - select * from tad_news where nsn='2203' |
0.000096 - SELECT * FROM users WHERE uid = '41' |
0.000134 - select groupid,name from groups |
0.004997 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2203' order by sort |
0.016665 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2203' order by sort |
0.006591 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000345 - desc `tadnews_data_center` `sort` |
0.000161 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2200' order by `sort` , `data_sort` |
0.016880 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2200' order by sort |
0.000128 - SELECT * FROM users WHERE uid = '11' |
0.000239 - select * from tad_news where nsn='2200' |
0.000216 - SELECT * FROM users WHERE uid = '11' |
0.000182 - select groupid,name from groups |
0.006422 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2200' order by sort |
0.012858 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2200' order by sort |
0.012146 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000821 - desc `tadnews_data_center` `sort` |
0.000429 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2199' order by `sort` , `data_sort` |
0.006419 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2199' order by sort |
0.008676 - SELECT * FROM users WHERE uid = '37' |
0.000147 - select * from tad_news where nsn='2199' |
0.000324 - select groupid,name from groups |
0.005621 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2199' order by sort |
0.013885 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2199' order by sort |
0.001084 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001603 - desc `tadnews_data_center` `sort` |
0.001274 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2196' order by `sort` , `data_sort` |
0.005560 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2196' order by sort |
0.006463 - SELECT * FROM users WHERE uid = '16' |
0.007312 - SELECT * FROM users WHERE uid = '16' |
0.000131 - select * from tad_news where nsn='2196' |
0.000189 - SELECT * FROM users WHERE uid = '16' |
0.000367 - select groupid,name from groups |
0.015126 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2196' order by sort |
0.011974 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2196' order by sort |
0.000267 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002318 - desc `tadnews_data_center` `sort` |
0.006607 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2195' order by `sort` , `data_sort` |
0.005538 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2195' order by sort |
0.002659 - select * from tad_news where nsn='2195' |
0.000940 - SELECT * FROM users WHERE uid = '16' |
0.005721 - select groupid,name from groups |
0.005308 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2195' order by sort |
0.010537 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2195' order by sort |
0.002424 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001768 - desc `tadnews_data_center` `sort` |
0.002068 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2194' order by `sort` , `data_sort` |
0.012198 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2194' order by sort |
0.001820 - select * from tad_news where nsn='2194' |
0.000340 - SELECT * FROM users WHERE uid = '16' |
0.000846 - select groupid,name from groups |
0.005921 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2194' order by sort |
0.015440 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2194' order by sort |
0.003604 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000852 - desc `tadnews_data_center` `sort` |
0.001229 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2193' order by `sort` , `data_sort` |
0.011424 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2193' order by sort |
0.000244 - SELECT * FROM users WHERE uid = '41' |
0.000395 - select * from tad_news where nsn='2193' |
0.000322 - SELECT * FROM users WHERE uid = '41' |
0.000257 - select groupid,name from groups |
0.014768 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2193' order by sort |
0.013604 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2193' order by sort |
0.000189 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001347 - desc `tadnews_data_center` `sort` |
0.003325 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2192' order by `sort` , `data_sort` |
0.007552 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2192' order by sort |
0.000211 - SELECT * FROM users WHERE uid = '41' |
0.000163 - SELECT * FROM users WHERE uid = '41' |
0.000318 - select * from tad_news where nsn='2192' |
0.000197 - SELECT * FROM users WHERE uid = '41' |
0.000085 - select groupid,name from groups |
0.004663 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2192' order by sort |
0.006153 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2192' order by sort |
0.000636 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.013780 - desc `tadnews_data_center` `sort` |
0.004080 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2191' order by `sort` , `data_sort` |
0.005387 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2191' order by sort |
0.009591 - SELECT * FROM users WHERE uid = '41' |
0.009460 - SELECT * FROM users WHERE uid = '41' |
0.000416 - select * from tad_news where nsn='2191' |
0.000198 - SELECT * FROM users WHERE uid = '41' |
0.000412 - select groupid,name from groups |
0.009746 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2191' order by sort |
0.005004 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2191' order by sort |
0.000322 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000963 - desc `tadnews_data_center` `sort` |
0.000369 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2189' order by `sort` , `data_sort` |
0.005814 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2189' order by sort |
0.000521 - SELECT * FROM users WHERE uid = '1' |
0.000328 - select * from tad_news where nsn='2189' |
0.000245 - select groupid,name from groups |
0.004881 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2189' order by sort |
0.004858 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2189' order by sort |
0.000240 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002068 - 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`='2188' order by `sort` , `data_sort` |
0.006533 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2188' order by sort |
0.000152 - select * from tad_news where nsn='2188' |
0.000204 - select groupid,name from groups |
0.005504 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2188' order by sort |
0.005383 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2188' order by sort |
0.000134 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001347 - desc `tadnews_data_center` `sort` |
0.000553 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2180' order by `sort` , `data_sort` |
0.006263 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2180' order by sort |
0.000343 - SELECT * FROM users WHERE uid = '11' |
0.000511 - select * from tad_news where nsn='2180' |
0.000088 - SELECT * FROM users WHERE uid = '11' |
0.000285 - select groupid,name from groups |
0.006850 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2180' order by sort |
0.006362 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2180' order by sort |
0.000111 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001647 - desc `tadnews_data_center` `sort` |
0.000548 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2177' order by `sort` , `data_sort` |
0.007339 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2177' order by sort |
0.000304 - select * from tad_news where nsn='2177' |
0.000133 - SELECT * FROM users WHERE uid = '16' |
0.000172 - select groupid,name from groups |
0.006484 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2177' order by sort |
0.005975 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2177' order by sort |
0.000369 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001385 - desc `tadnews_data_center` `sort` |
0.000343 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2176' order by `sort` , `data_sort` |
0.006637 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2176' order by sort |
0.000928 - SELECT * FROM users WHERE uid = '16' |
0.000743 - select * from tad_news where nsn='2176' |
0.000183 - SELECT * FROM users WHERE uid = '16' |
0.000214 - select groupid,name from groups |
0.006441 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2176' order by sort |
0.006689 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2176' order by sort |
0.000214 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001326 - desc `tadnews_data_center` `sort` |
0.000422 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2175' order by `sort` , `data_sort` |
0.007372 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2175' order by sort |
0.000170 - SELECT * FROM users WHERE uid = '17' |
0.000138 - SELECT * FROM users WHERE uid = '17' |
0.000288 - SELECT * FROM users WHERE uid = '17' |
0.000097 - SELECT * FROM users WHERE uid = '17' |
0.000159 - select * from tad_news where nsn='2175' |
0.000162 - SELECT * FROM users WHERE uid = '17' |
0.000161 - select groupid,name from groups |
0.006472 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2175' order by sort |
0.005560 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2175' order by sort |
0.000383 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.002323 - 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`='2174' order by `sort` , `data_sort` |
0.006559 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2174' order by sort |
0.000399 - select * from tad_news where nsn='2174' |
0.000283 - SELECT * FROM users WHERE uid = '16' |
0.000085 - select groupid,name from groups |
0.005812 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2174' order by sort |
0.005575 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2174' order by sort |
0.000253 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001526 - desc `tadnews_data_center` `sort` |
0.000452 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2173' order by `sort` , `data_sort` |
0.006621 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2173' order by sort |
0.000440 - SELECT * FROM users WHERE uid = '41' |
0.000178 - SELECT * FROM users WHERE uid = '41' |
0.000084 - SELECT * FROM users WHERE uid = '41' |
0.000545 - select * from tad_news where nsn='2173' |
0.000219 - SELECT * FROM users WHERE uid = '41' |
0.000157 - select groupid,name from groups |
0.006756 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2173' order by sort |
0.006560 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2173' order by sort |
0.000303 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002369 - desc `tadnews_data_center` `sort` |
0.001013 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2172' order by `sort` , `data_sort` |
0.007716 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2172' order by sort |
0.000932 - select * from tad_news where nsn='2172' |
0.000385 - select groupid,name from groups |
0.009539 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2172' order by sort |
0.008181 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2172' order by sort |
0.000310 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001421 - desc `tadnews_data_center` `sort` |
0.000546 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2171' order by `sort` , `data_sort` |
0.012057 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2171' order by sort |
0.000819 - select * from tad_news where nsn='2171' |
0.000374 - select groupid,name from groups |
0.007172 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2171' order by sort |
0.007516 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2171' order by sort |
0.000919 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000451 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000960 - 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 |