SQL Report


Page generated in 0.1504 seconds with 7 queries + 5 queries returning data from cache

Time spent on mysqli queries: 0.06233s | Time spent on PHP: 0.08806s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.00788s | After: 0.00809s | Elapsed: 0.00021s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03175s | After: 0.03211s | Elapsed: 0.00036s



Query results obtained from the cache

Before: 0.03332s | After: 0.03369s | Elapsed [cache]: 0.00038s | Elapsed [db]: 0.00021s



Query #4

Before: 0.03452s | After: 0.07854s | Elapsed: 0.04402s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_time,session_user_idsession_time4 927Using where

Before: 0.08173s | After: 0.09656s | Elapsed: 0.01483s



Query results obtained from the cache

Before: 0.10187s | After: 0.10224s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00022s



Query results obtained from the cache

Before: 0.10774s | After: 0.10876s | Elapsed [cache]: 0.00102s | Elapsed [db]: 0.00068s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_time,session_user_idsession_time4 37Using where

Before: 0.11232s | After: 0.11353s | Elapsed: 0.00121s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_time4 37Using where
1SIMPLEueq_refPRIMARYPRIMARY3forum_fedegnv3.s.session_user_id1 

Before: 0.11523s | After: 0.11656s | Elapsed: 0.00133s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEgrangegroup_legend_namegroup_legend_name3 2Using where
1SIMPLEugrefgroup_id,user_iduser_id3const1Using where

Before: 0.11817s | After: 0.11855s | Elapsed: 0.00037s



Query results obtained from the cache

Before: 0.12347s | After: 0.12395s | Elapsed [cache]: 0.00048s | Elapsed [db]: 0.00027s



Query results obtained from the cache

Before: 0.13610s | After: 0.13699s | Elapsed [cache]: 0.00089s | Elapsed [db]: 0.00068s