SQL Report


Page generated in 0.0705 seconds with 14 queries + 5 queries returning data from cache

Time spent on mysql4 queries: 0.00497s | Time spent on PHP: 0.06551s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const42 

Before: 0.02581s | After: 0.02628s | Elapsed: 0.00047s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03104s | After: 0.03112s | Elapsed: 0.00009s



Query results obtained from the cache

Before: 0.03170s | After: 0.03278s | Elapsed [cache]: 0.00108s | Elapsed [db]: 0.00070s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.03584s | After: 0.03597s | Elapsed: 0.00013s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.03632s | After: 0.03642s | Elapsed: 0.00010s



Query #6

Before: 0.03655s | After: 0.03669s | Elapsed: 0.00014s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrefsession_time,session_user_idsession_user_id3const1050Using where

Before: 0.03714s | After: 0.04010s | Elapsed: 0.00296s



Query results obtained from the cache

Before: 0.04338s | After: 0.04351s | Elapsed [cache]: 0.00014s | Elapsed [db]: 0.00006s



Query results obtained from the cache

Before: 0.04429s | After: 0.04466s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00026s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfALL    77Using filesort

Before: 0.04566s | After: 0.04583s | Elapsed: 0.00016s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrefforum_id,forum_id_type,last_post_time,forum_appr_last,fid_time_movedfid_time_moved3const2Using where

Before: 0.04622s | After: 0.04636s | Elapsed: 0.00013s



Query results obtained from the cache

Before: 0.05113s | After: 0.05198s | Elapsed [cache]: 0.00085s | Elapsed [db]: 0.00083s



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

Before: 0.05357s | After: 0.05366s | Elapsed: 0.00009s



Query #14
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEgrefgroup_legend_namegroup_legend_name1const11Using where
1SIMPLEugrefgroup_id,user_iduser_id3const1Using where

Before: 0.06291s | After: 0.06298s | Elapsed: 0.00007s



Query #15
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_time4 13Using where

Before: 0.06436s | After: 0.06457s | Elapsed: 0.00021s



Query #16
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_user_id3 5Using where

Before: 0.06495s | After: 0.06515s | Elapsed: 0.00019s



Query #17
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersrangePRIMARYPRIMARY3 2Using where; Using filesort

Before: 0.06556s | After: 0.06572s | Elapsed: 0.00016s



Query results obtained from the cache

Before: 0.06618s | After: 0.06629s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00006s



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

Before: 0.06720s | After: 0.06726s | Elapsed: 0.00007s