SQL Report


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

Time spent on mysql4 queries: 1.92552s | Time spent on PHP: 0.32213s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const21 

Before: 0.01162s | After: 0.01213s | Elapsed: 0.00051s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03035s | After: 0.03102s | Elapsed: 0.00067s



Query results obtained from the cache

Before: 0.17338s | After: 0.17395s | Elapsed [cache]: 0.00056s | Elapsed [db]: 0.00079s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.17574s | After: 1.31963s | Elapsed: 1.14389s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 1.32099s | After: 1.36543s | Elapsed: 0.04444s



Query #6

Before: 1.36568s | After: 2.09966s | Elapsed: 0.73398s



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

Before: 2.10126s | After: 2.10218s | Elapsed: 0.00092s



Query results obtained from the cache

Before: 2.23084s | After: 2.23142s | Elapsed [cache]: 0.00057s | Elapsed [db]: 0.00103s



Query results obtained from the cache

Before: 2.23881s | After: 2.23943s | Elapsed [cache]: 0.00062s | Elapsed [db]: 0.00076s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_forumsALL    4Using filesort

Before: 2.24521s | After: 2.24632s | Elapsed: 0.00111s