資料庫語法 |
---|
0.000057 - SET SQL_BIG_SELECTS = 1 |
0.000791 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000499 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'oqteglhvmtqcpj30hgqj7nrfrj' |
0.000189 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001076 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000279 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000298 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000207 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000119 - select mid from modules where dirname='tadnews' |
0.000215 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000246 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001283 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.001562 - 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.000485 - 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.000371 - 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.000298 - 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.282450 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 23:29:50' and always_top_date!='0000-00-00 00:00:00' |
0.000249 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.563504 - 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 23:29:47' and (end_day > '2025-09-30 23:29:47' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.273281 - 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 23:29:47' and (end_day > '2025-09-30 23:29:47' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 8720, 20 |
0.002930 - desc `tadnews_data_center` `sort` |
0.001409 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1025' order by `sort` , `data_sort` |
0.009395 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1025' order by sort |
0.000707 - select * from tad_news where nsn='1025' |
0.000836 - SELECT * FROM users WHERE uid = '24' |
0.000301 - select groupid,name from groups |
0.008923 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1025' order by sort |
0.009247 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1025' order by sort |
0.000354 - SELECT * FROM smiles |
0.001324 - desc `tadnews_data_center` `sort` |
0.000734 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1024' order by `sort` , `data_sort` |
0.009018 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1024' order by sort |
0.000170 - select * from tad_news where nsn='1024' |
0.000448 - SELECT * FROM users WHERE uid = '24' |
0.000732 - select groupid,name from groups |
0.006839 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1024' order by sort |
0.006894 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1024' order by sort |
0.002299 - desc `tadnews_data_center` `sort` |
0.000825 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1023' order by `sort` , `data_sort` |
0.008191 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1023' order by sort |
0.001504 - SELECT * FROM users WHERE uid = '21' |
0.000578 - select * from tad_news where nsn='1023' |
0.000327 - SELECT * FROM users WHERE uid = '21' |
0.000363 - select groupid,name from groups |
0.007591 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1023' order by sort |
0.008111 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1023' order by sort |
0.000502 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
0.002868 - desc `tadnews_data_center` `sort` |
0.001100 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1022' order by `sort` , `data_sort` |
0.007759 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1022' order by sort |
0.001218 - SELECT * FROM users WHERE uid = '15' |
0.000516 - select * from tad_news where nsn='1022' |
0.000271 - SELECT * FROM users WHERE uid = '15' |
0.000236 - select groupid,name from groups |
0.007668 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1022' order by sort |
0.006149 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1022' order by sort |
0.000461 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001399 - desc `tadnews_data_center` `sort` |
0.000890 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1013' order by `sort` , `data_sort` |
0.006753 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1013' order by sort |
0.000813 - SELECT * FROM users WHERE uid = '15' |
0.000315 - SELECT * FROM users WHERE uid = '15' |
0.000174 - SELECT * FROM users WHERE uid = '15' |
0.000459 - select * from tad_news where nsn='1013' |
0.000274 - SELECT * FROM users WHERE uid = '15' |
0.000305 - select groupid,name from groups |
0.007541 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1013' order by sort |
0.007119 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1013' order by sort |
0.000492 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.002670 - desc `tadnews_data_center` `sort` |
0.000206 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1012' order by `sort` , `data_sort` |
0.007650 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1012' order by sort |
0.000538 - SELECT * FROM users WHERE uid = '15' |
0.000229 - SELECT * FROM users WHERE uid = '15' |
0.000530 - select * from tad_news where nsn='1012' |
0.000172 - SELECT * FROM users WHERE uid = '15' |
0.000333 - select groupid,name from groups |
0.006970 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1012' order by sort |
0.005704 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1012' order by sort |
0.000346 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.002206 - desc `tadnews_data_center` `sort` |
0.001141 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1010' order by `sort` , `data_sort` |
0.007507 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1010' order by sort |
0.000186 - SELECT * FROM users WHERE uid = '26' |
0.000615 - select * from tad_news where nsn='1010' |
0.000458 - SELECT * FROM users WHERE uid = '26' |
0.000393 - select groupid,name from groups |
0.007666 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1010' order by sort |
0.006551 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1010' order by sort |
0.002105 - desc `tadnews_data_center` `sort` |
0.001111 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1009' order by `sort` , `data_sort` |
0.008997 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1009' order by sort |
0.000680 - select * from tad_news where nsn='1009' |
0.000196 - SELECT * FROM users WHERE uid = '24' |
0.000226 - select groupid,name from groups |
0.006997 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1009' order by sort |
0.006900 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1009' order by sort |
0.002438 - desc `tadnews_data_center` `sort` |
0.000897 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1008' order by `sort` , `data_sort` |
0.008409 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1008' order by sort |
0.000605 - select * from tad_news where nsn='1008' |
0.000400 - SELECT * FROM users WHERE uid = '24' |
0.000130 - select groupid,name from groups |
0.005994 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1008' order by sort |
0.004881 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1008' order by sort |
0.002003 - desc `tadnews_data_center` `sort` |
0.000554 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1007' order by `sort` , `data_sort` |
0.006053 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1007' order by sort |
0.001693 - select * from tad_news where nsn='1007' |
0.000550 - SELECT * FROM users WHERE uid = '24' |
0.000321 - select groupid,name from groups |
0.005944 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1007' order by sort |
0.005424 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1007' order by sort |
0.001259 - desc `tadnews_data_center` `sort` |
0.000818 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='996' order by `sort` , `data_sort` |
0.005834 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='996' order by sort |
0.000296 - select * from tad_news where nsn='996' |
0.000435 - SELECT * FROM users WHERE uid = '20' |
0.000340 - select groupid,name from groups |
0.005257 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='996' order by sort |
0.004844 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='996' order by sort |
0.001350 - desc `tadnews_data_center` `sort` |
0.000881 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='995' order by `sort` , `data_sort` |
0.006315 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='995' order by sort |
0.000293 - select * from tad_news where nsn='995' |
0.000419 - SELECT * FROM users WHERE uid = '20' |
0.000391 - select groupid,name from groups |
0.005071 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='995' order by sort |
0.004986 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='995' order by sort |
0.001753 - desc `tadnews_data_center` `sort` |
0.000410 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='994' order by `sort` , `data_sort` |
0.005617 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='994' order by sort |
0.000480 - SELECT * FROM users WHERE uid = '15' |
0.000451 - select * from tad_news where nsn='994' |
0.000327 - SELECT * FROM users WHERE uid = '15' |
0.000420 - select groupid,name from groups |
0.004934 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='994' order by sort |
0.004980 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='994' order by sort |
0.000389 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001488 - desc `tadnews_data_center` `sort` |
0.000821 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='993' order by `sort` , `data_sort` |
0.008229 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='993' order by sort |
0.000584 - SELECT * FROM users WHERE uid = '15' |
0.000818 - select * from tad_news where nsn='993' |
0.000294 - SELECT * FROM users WHERE uid = '15' |
0.000282 - select groupid,name from groups |
0.006474 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='993' order by sort |
0.005879 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='993' order by sort |
0.000178 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001951 - desc `tadnews_data_center` `sort` |
0.000686 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='992' order by `sort` , `data_sort` |
0.006938 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='992' order by sort |
0.000464 - SELECT * FROM users WHERE uid = '17' |
0.000436 - select * from tad_news where nsn='992' |
0.000181 - SELECT * FROM users WHERE uid = '17' |
0.000329 - select groupid,name from groups |
0.006473 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='992' order by sort |
0.004782 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='992' order by sort |
0.002952 - desc `tadnews_data_center` `sort` |
0.000841 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='991' order by `sort` , `data_sort` |
0.005508 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='991' order by sort |
0.000159 - SELECT * FROM users WHERE uid = '15' |
0.000141 - SELECT * FROM users WHERE uid = '15' |
0.000901 - select * from tad_news where nsn='991' |
0.000310 - SELECT * FROM users WHERE uid = '15' |
0.000346 - select groupid,name from groups |
0.005754 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='991' order by sort |
0.005482 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='991' order by sort |
0.000496 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001752 - desc `tadnews_data_center` `sort` |
0.000484 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='990' order by `sort` , `data_sort` |
0.006809 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='990' order by sort |
0.000627 - select * from tad_news where nsn='990' |
0.000288 - SELECT * FROM users WHERE uid = '24' |
0.000388 - select groupid,name from groups |
0.006189 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='990' order by sort |
0.014476 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='990' order by sort |
0.002281 - 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`='989' order by `sort` , `data_sort` |
0.008872 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='989' order by sort |
0.000223 - select * from tad_news where nsn='989' |
0.000122 - SELECT * FROM users WHERE uid = '24' |
0.000331 - select groupid,name from groups |
0.007687 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='989' order by sort |
0.006727 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='989' order by sort |
0.001260 - desc `tadnews_data_center` `sort` |
0.000552 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='988' order by `sort` , `data_sort` |
0.006215 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='988' order by sort |
0.000167 - select * from tad_news where nsn='988' |
0.000111 - SELECT * FROM users WHERE uid = '20' |
0.000083 - select groupid,name from groups |
0.005516 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='988' order by sort |
0.005304 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='988' order by sort |
0.000679 - desc `tadnews_data_center` `sort` |
0.000219 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='987' order by `sort` , `data_sort` |
0.005247 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='987' order by sort |
0.000132 - SELECT * FROM users WHERE uid = '15' |
0.000108 - select * from tad_news where nsn='987' |
0.000081 - SELECT * FROM users WHERE uid = '15' |
0.000081 - select groupid,name from groups |
0.004450 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='987' order by sort |
0.004419 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='987' order by sort |
0.000116 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000291 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000305 - 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 |