SQL Report


Page generated in 0.2697 seconds with 9 queries + 3 queries returning data from cache

Time spent on mysqli queries: 0.16364s | Time spent on PHP: 0.10607s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.02215s | After: 0.02245s | Elapsed: 0.00030s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.04963s | After: 0.05057s | Elapsed: 0.00094s



Query results obtained from the cache

Before: 0.05186s | After: 0.05230s | Elapsed [cache]: 0.00044s | Elapsed [db]: 0.00022s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.05386s | After: 0.09402s | Elapsed: 0.04016s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.09528s | After: 0.14480s | Elapsed: 0.04951s



Query #6

Before: 0.14556s | After: 0.17845s | Elapsed: 0.03289s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_time,session_user_idsession_time4 765Using where

Before: 0.18024s | After: 0.18734s | Elapsed: 0.00710s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_forumsconstPRIMARYPRIMARY3const1 

Before: 0.19153s | After: 0.19251s | Elapsed: 0.00097s



Query results obtained from the cache

Before: 0.20281s | After: 0.20323s | Elapsed [cache]: 0.00042s | Elapsed [db]: 0.00025s



Query #10

Before: 0.20591s | After: 0.23692s | Elapsed: 0.03101s



Query results obtained from the cache

Before: 0.23963s | After: 0.24007s | Elapsed [cache]: 0.00044s | Elapsed [db]: 0.00023s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_forumsALL    53Using filesort

Before: 0.25287s | After: 0.25363s | Elapsed: 0.00076s