SQL Report


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

Time spent on mysqli queries: 0.04836s | Time spent on PHP: 1.35324s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_configrefis_dynamicis_dynamic1const23 

Before: 0.33400s | After: 0.33657s | Elapsed: 0.00257s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_usersconstPRIMARYPRIMARY4const1 

Before: 1.10293s | After: 1.11363s | Elapsed: 0.01071s



Query results obtained from the cache

Before: 1.11762s | After: 1.11773s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00181s



Query #4

Before: 1.11799s | After: 1.12359s | Elapsed: 0.00560s



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

Before: 1.19662s | After: 1.22156s | Elapsed: 0.02494s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 1.22856s | After: 1.23015s | Elapsed: 0.00159s



Query results obtained from the cache

Before: 1.29664s | After: 1.29678s | Elapsed [cache]: 0.00014s | Elapsed [db]: 0.01091s



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

Before: 1.30788s | After: 1.31012s | Elapsed: 0.00224s



Query results obtained from the cache

Before: 1.31176s | After: 1.31188s | Elapsed [cache]: 0.00012s | Elapsed [db]: 0.00032s



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

Before: 1.38550s | After: 1.38591s | Elapsed: 0.00040s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrange|filtersession_time,session_user_id,session_fidsession_user_id|session_fid4|3 2 (0%)Using index condition; Using where; Using rowid filter

Before: 1.38622s | After: 1.38654s | Elapsed: 0.00032s



Query results obtained from the cache

Before: 1.38704s | After: 1.38715s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00016s



Query results obtained from the cache

Before: 1.39441s | After: 1.39477s | Elapsed [cache]: 0.00036s | Elapsed [db]: 0.00047s