SQL Report


Page generated in 10.6296 seconds with 8 queries + 4 queries returning data from cache

Time spent on mysqli queries: 10.53771s | Time spent on PHP: 0.09193s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.01018s | After: 0.01103s | Elapsed: 0.00085s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03781s | After: 0.03878s | Elapsed: 0.00097s



Query results obtained from the cache

Before: 0.04001s | After: 0.04039s | Elapsed [cache]: 0.00038s | Elapsed [db]: 0.00021s



Query #4

Before: 0.04124s | After: 2.77392s | Elapsed: 2.73268s



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

Before: 2.77573s | After: 2.78281s | Elapsed: 0.00709s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_forumsconstPRIMARYPRIMARY3const1 

Before: 2.78681s | After: 2.78781s | Elapsed: 0.00100s



Query results obtained from the cache

Before: 2.79863s | After: 2.79904s | Elapsed [cache]: 0.00041s | Elapsed [db]: 0.00026s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 2.80219s | After: 6.33723s | Elapsed: 3.53505s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 6.33854s | After: 7.74572s | Elapsed: 1.40718s



Query #10

Before: 7.74636s | After: 10.59926s | Elapsed: 2.85290s



Query results obtained from the cache

Before: 10.60239s | After: 10.60281s | Elapsed [cache]: 0.00042s | Elapsed [db]: 0.00021s



Query results obtained from the cache

Before: 10.61506s | After: 10.61598s | Elapsed [cache]: 0.00092s | Elapsed [db]: 0.00071s