SQL Report


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

Time spent on mysqli queries: 0.25201s | Time spent on PHP: 0.85543s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_configrefis_dynamicis_dynamic1const23 

Before: 0.31734s | After: 0.31763s | Elapsed: 0.00029s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_usersconstPRIMARYPRIMARY4const1 

Before: 0.42927s | After: 0.42958s | Elapsed: 0.00031s



Query results obtained from the cache

Before: 0.42997s | After: 0.43010s | Elapsed [cache]: 0.00013s | Elapsed [db]: 0.00018s



Query #4

Before: 0.43035s | After: 0.43420s | Elapsed: 0.00385s



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

Before: 0.49503s | After: 0.59468s | Elapsed: 0.09965s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.61029s | After: 0.69409s | Elapsed: 0.08380s



Query results obtained from the cache

Before: 0.71402s | After: 0.71414s | Elapsed [cache]: 0.00012s | Elapsed [db]: 0.01625s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfrangeleft_right_idleft_right_id3 7Using index condition

Before: 0.79882s | After: 0.81558s | Elapsed: 0.01676s



Query results obtained from the cache

Before: 0.86753s | After: 0.86769s | Elapsed [cache]: 0.00016s | Elapsed [db]: 0.04303s



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

Before: 0.89856s | After: 0.92503s | Elapsed: 0.02647s



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

Before: 0.96847s | After: 0.98936s | Elapsed: 0.02089s



Query results obtained from the cache

Before: 1.02847s | After: 1.02862s | Elapsed [cache]: 0.00015s | Elapsed [db]: 0.03530s



Query results obtained from the cache

Before: 1.10013s | After: 1.10063s | Elapsed [cache]: 0.00050s | Elapsed [db]: 0.01100s