SQL Report


Page generated in 0.0575 seconds with 9 queries + 4 queries returning data from cache

Time spent on mysqli queries: 0.01332s | Time spent on PHP: 0.04414s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_configrefis_dynamicis_dynamic1const23 

Before: 0.01376s | After: 0.01390s | Elapsed: 0.00013s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_usersconstPRIMARYPRIMARY4const1 

Before: 0.02962s | After: 0.02984s | Elapsed: 0.00022s



Query results obtained from the cache

Before: 0.03012s | After: 0.03023s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00014s



Query #4

Before: 0.03037s | After: 0.03063s | Elapsed: 0.00026s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_sessionsALLsession_time,session_user_id   57454Using where

Before: 0.03088s | After: 0.04262s | Elapsed: 0.01174s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.04364s | After: 0.04376s | Elapsed: 0.00013s



Query results obtained from the cache

Before: 0.04515s | After: 0.04521s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00014s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfrangeleft_right_idleft_right_id3 1Using index condition
1SIMPLEfarefPRIMARYPRIMARY3sunphu_newforum.f.forum_id1Using where; Using index

Before: 0.04603s | After: 0.04626s | Elapsed: 0.00023s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmALLdisp_idx   4Using where
1SIMPLEueq_refPRIMARYPRIMARY4sunphu_newforum.m.user_id1 
1SIMPLEgeq_refPRIMARYPRIMARY3sunphu_newforum.m.group_id1 

Before: 0.04721s | After: 0.04749s | Elapsed: 0.00028s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefsession_time,session_user_id,session_fidsession_fid3const8Using where

Before: 0.04828s | After: 0.04848s | Elapsed: 0.00020s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsref|filtersession_time,session_user_id,session_fidsession_fid|session_user_id3|4const8 (0%)Using where; Using rowid filter

Before: 0.04869s | After: 0.04883s | Elapsed: 0.00014s



Query results obtained from the cache

Before: 0.04930s | After: 0.04936s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00012s



Query results obtained from the cache

Before: 0.05387s | After: 0.05412s | Elapsed [cache]: 0.00026s | Elapsed [db]: 0.00031s