SQL Report


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

Time spent on mysqli queries: 0.06215s | Time spent on PHP: 0.10763s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.00991s | After: 0.01012s | Elapsed: 0.00021s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03892s | After: 0.03983s | Elapsed: 0.00091s



Query results obtained from the cache

Before: 0.04104s | After: 0.04142s | Elapsed [cache]: 0.00038s | Elapsed [db]: 0.00021s



Query #4

Before: 0.04224s | After: 0.08953s | Elapsed: 0.04729s



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

Before: 0.09265s | After: 0.10145s | Elapsed: 0.00879s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.10763s | After: 0.10846s | Elapsed: 0.00084s



Query results obtained from the cache

Before: 0.11232s | After: 0.11268s | Elapsed [cache]: 0.00036s | Elapsed [db]: 0.00023s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfrangeleft_right_idleft_right_id3 5Using where

Before: 0.11556s | After: 0.11670s | Elapsed: 0.00114s



Query results obtained from the cache

Before: 0.12069s | After: 0.12105s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00077s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_id,session_fidsession_time4 77Using where

Before: 0.13525s | After: 0.13683s | Elapsed: 0.00159s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_id,session_fidsession_time4 73Using where

Before: 0.13812s | After: 0.13950s | Elapsed: 0.00138s



Query results obtained from the cache

Before: 0.14143s | After: 0.14180s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00020s



Query results obtained from the cache

Before: 0.15520s | After: 0.15641s | Elapsed [cache]: 0.00121s | Elapsed [db]: 0.00099s