SQL Report


Page generated in 0.0735 seconds with 12 queries + 6 queries returning data from cache

Time spent on mysql4 queries: 0.00444s | Time spent on PHP: 0.06907s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const42 

Before: 0.02463s | After: 0.02496s | Elapsed: 0.00033s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Before: 0.02914s | After: 0.02954s | Elapsed: 0.00040s



Query #3
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03233s | After: 0.03252s | Elapsed: 0.00019s



Query results obtained from the cache

Before: 0.03378s | After: 0.03623s | Elapsed [cache]: 0.00245s | Elapsed [db]: 0.00168s



Query #5

Affected rows: 0 | Before: 0.04192s | After: 0.04206s | Elapsed: 0.00014s



Query #6

Before: 0.04225s | After: 0.04264s | Elapsed: 0.00039s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsALLsession_time,session_user_id   1230Using where

Before: 0.04340s | After: 0.04530s | Elapsed: 0.00190s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.04646s | After: 0.04661s | Elapsed: 0.00015s



Query results obtained from the cache

Before: 0.04953s | After: 0.04971s | Elapsed [cache]: 0.00018s | Elapsed [db]: 0.00008s



Query results obtained from the cache

Before: 0.05064s | After: 0.05106s | Elapsed [cache]: 0.00042s | Elapsed [db]: 0.00035s



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

Before: 0.05253s | After: 0.05265s | Elapsed: 0.00012s



Query results obtained from the cache

Before: 0.05392s | After: 0.05473s | Elapsed [cache]: 0.00081s | Elapsed [db]: 0.00120s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_forumsALLPRIMARY   77Using where; Using filesort

Before: 0.05619s | After: 0.05634s | Elapsed: 0.00015s



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

Before: 0.06126s | After: 0.06158s | Elapsed: 0.00032s



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

Before: 0.06228s | After: 0.06252s | Elapsed: 0.00024s



Query results obtained from the cache

Before: 0.06321s | After: 0.06335s | Elapsed [cache]: 0.00014s | Elapsed [db]: 0.00005s



Query #17
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_fsfALL    29Using where; Using filesort

Before: 0.06462s | After: 0.06471s | Elapsed: 0.00009s



Query results obtained from the cache

Before: 0.06904s | After: 0.06948s | Elapsed [cache]: 0.00044s | Elapsed [db]: 0.00038s