SQL Report


Page generated in 0.0677 seconds with 7 queries + 3 queries returning data from cache

Time spent on mysql4 queries: 0.01392s | Time spent on PHP: 0.0538s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const24 

Before: 0.02682s | After: 0.02721s | Elapsed: 0.00040s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.04374s | After: 0.04406s | Elapsed: 0.00032s



Query results obtained from the cache

Before: 0.04457s | After: 0.04508s | Elapsed [cache]: 0.00051s | Elapsed [db]: 0.00035s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.04589s | After: 0.04615s | Elapsed: 0.00027s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.04649s | After: 0.04670s | Elapsed: 0.00021s



Query #6

Before: 0.04684s | After: 0.05363s | Elapsed: 0.00679s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_time,session_user_idsession_time4 232Using index condition; Using where

Before: 0.05428s | After: 0.05943s | Elapsed: 0.00515s



Query results obtained from the cache

Before: 0.06301s | After: 0.06327s | Elapsed [cache]: 0.00026s | Elapsed [db]: 0.00029s



Query results obtained from the cache

Before: 0.06440s | After: 0.06519s | Elapsed [cache]: 0.00079s | Elapsed [db]: 0.00113s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_time4 10Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARYPRIMARY3cattibri1.s.session_user_id1 

Before: 0.06603s | After: 0.06682s | Elapsed: 0.00078s