SQL Report


Page generated in 0.0875 seconds with 10 queries + 6 queries returning data from cache

Time spent on mysql4 queries: 0.01066s | Time spent on PHP: 0.07688s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const42 

Before: 0.03677s | After: 0.03686s | Elapsed: 0.00009s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.04342s | After: 0.04351s | Elapsed: 0.00009s



Query results obtained from the cache

Before: 0.04418s | After: 0.04537s | Elapsed [cache]: 0.00119s | Elapsed [db]: 0.00072s



Query #4

Before: 0.04922s | After: 0.04966s | Elapsed: 0.00044s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsALLsession_time,session_user_id   8409Using where

Before: 0.05032s | After: 0.05913s | Elapsed: 0.00881s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.06048s | After: 0.06071s | Elapsed: 0.00023s



Query results obtained from the cache

Before: 0.06371s | After: 0.06392s | Elapsed [cache]: 0.00021s | Elapsed [db]: 0.00007s



Query results obtained from the cache

Before: 0.06506s | After: 0.06561s | Elapsed [cache]: 0.00055s | Elapsed [db]: 0.00039s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfrangeleft_right_idleft_right_id3 4Using where

Before: 0.06669s | After: 0.06690s | Elapsed: 0.00021s



Query results obtained from the cache

Before: 0.06755s | After: 0.06822s | Elapsed [cache]: 0.00066s | Elapsed [db]: 0.00074s



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

Before: 0.06924s | After: 0.06931s | Elapsed: 0.00007s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefsession_time,session_user_id,session_fidsession_fid3const8Using where

Before: 0.07472s | After: 0.07515s | Elapsed: 0.00043s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefsession_time,session_user_id,session_fidsession_fid3const8Using where

Before: 0.07564s | After: 0.07585s | Elapsed: 0.00020s



Query results obtained from the cache

Before: 0.07641s | After: 0.07655s | Elapsed [cache]: 0.00014s | Elapsed [db]: 0.00005s



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

Before: 0.07774s | After: 0.07782s | Elapsed: 0.00008s



Query results obtained from the cache

Before: 0.08246s | After: 0.08298s | Elapsed [cache]: 0.00051s | Elapsed [db]: 0.00035s