SQL Report


Page generated in 0.0792 seconds with 12 queries + 2 queries returning data from cache

Time spent on mysqli queries: 0.0115s | Time spent on PHP: 0.06771s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_configrefis_dynamicis_dynamic1const23 

Before: 0.01854s | After: 0.01868s | Elapsed: 0.00014s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Before: 0.04927s | After: 0.04951s | Elapsed: 0.00023s



Query #3
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_usersconstPRIMARYPRIMARY4const1 

Before: 0.05090s | After: 0.05111s | Elapsed: 0.00021s



Query results obtained from the cache

Before: 0.05136s | After: 0.05145s | Elapsed [cache]: 0.00010s | Elapsed [db]: 0.00011s



Query #5

Affected rows: 0 | Before: 0.05157s | After: 0.05167s | Elapsed: 0.00010s



Query #6

FAILED - mysqli Error 1114: The table 'nbb_sessions' is full



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_sessionsALLsession_time,session_user_id   38510Using where

Before: 0.05228s | After: 0.06161s | Elapsed: 0.00934s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.06274s | After: 0.06287s | Elapsed: 0.00012s



Query results obtained from the cache

Before: 0.06462s | After: 0.06470s | Elapsed [cache]: 0.00008s | Elapsed [db]: 0.00008s



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

Before: 0.06548s | After: 0.06573s | Elapsed: 0.00026s



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

Before: 0.06693s | After: 0.06710s | Elapsed: 0.00016s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsref|filtersession_time,session_user_id,session_fidsession_fid|session_time3|4const4 (0%)Using where; Using rowid filter

Before: 0.06731s | After: 0.06745s | Elapsed: 0.00013s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_forumsALL    129Using where

Before: 0.06799s | After: 0.06819s | Elapsed: 0.00021s



Query #14
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_forumsALL    129Using filesort

Before: 0.07345s | After: 0.07381s | Elapsed: 0.00036s