SQL Report


Page generated in 0.0701 seconds with 9 queries + 4 queries returning data from cache

Time spent on mysql4 queries: 0.00707s | Time spent on PHP: 0.06298s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const42 

Before: 0.02551s | After: 0.02558s | Elapsed: 0.00007s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03558s | After: 0.03584s | Elapsed: 0.00026s



Query results obtained from the cache

Before: 0.03661s | After: 0.03771s | Elapsed [cache]: 0.00109s | Elapsed [db]: 0.00103s



Query #4

Before: 0.04193s | After: 0.04211s | Elapsed: 0.00019s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrefsession_time,session_user_idsession_user_id3const1509Using where

Before: 0.04279s | After: 0.04848s | Elapsed: 0.00569s



Query results obtained from the cache

Before: 0.05379s | After: 0.05394s | Elapsed [cache]: 0.00015s | Elapsed [db]: 0.00008s



Query results obtained from the cache

Before: 0.05488s | After: 0.05533s | Elapsed [cache]: 0.00045s | Elapsed [db]: 0.00033s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_time4 18Using where

Before: 0.05663s | After: 0.05694s | Elapsed: 0.00031s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_user_id3 14Using where

Before: 0.05730s | After: 0.05753s | Elapsed: 0.00023s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersrangePRIMARYPRIMARY3 4Using where; Using filesort

Before: 0.05791s | After: 0.05813s | Elapsed: 0.00022s



Query results obtained from the cache

Before: 0.05868s | After: 0.05880s | Elapsed [cache]: 0.00012s | Elapsed [db]: 0.00003s



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

Before: 0.05917s | After: 0.05923s | Elapsed: 0.00006s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_fsfALL    30Using where; Using filesort

Before: 0.06606s | After: 0.06611s | Elapsed: 0.00005s