SQL Report


Page generated in 0.0444 seconds with 8 queries + 5 queries returning data from cache

Time spent on mysqli queries: 0.00153s | Time spent on PHP: 0.0429s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_configrefis_dynamicis_dynamic1const23 

Before: 0.01414s | After: 0.01429s | Elapsed: 0.00015s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_usersconstPRIMARYPRIMARY4const1 

Before: 0.02971s | After: 0.02991s | Elapsed: 0.00021s



Query results obtained from the cache

Before: 0.03014s | After: 0.03020s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00013s



Query #4

Before: 0.03033s | After: 0.03054s | Elapsed: 0.00021s



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

Before: 0.03077s | After: 0.03109s | Elapsed: 0.00031s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.03192s | After: 0.03206s | Elapsed: 0.00014s



Query results obtained from the cache

Before: 0.03333s | After: 0.03338s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00011s



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

Before: 0.03406s | After: 0.03425s | Elapsed: 0.00019s



Query results obtained from the cache

Before: 0.03515s | After: 0.03521s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00021s



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

Before: 0.03570s | After: 0.03587s | Elapsed: 0.00017s



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

Before: 0.03606s | After: 0.03619s | Elapsed: 0.00014s



Query results obtained from the cache

Before: 0.03669s | After: 0.03675s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00013s



Query results obtained from the cache

Before: 0.04112s | After: 0.04130s | Elapsed [cache]: 0.00018s | Elapsed [db]: 0.00031s