SQL Report


Page generated in 0.063 seconds with 12 queries + 6 queries returning data from cache

Time spent on mysql4 queries: 0.00422s | Time spent on PHP: 0.05876s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const42 

Before: 0.02549s | After: 0.02568s | Elapsed: 0.00019s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03062s | After: 0.03071s | Elapsed: 0.00009s



Query results obtained from the cache

Before: 0.03129s | After: 0.03259s | Elapsed [cache]: 0.00130s | Elapsed [db]: 0.00071s



Query #4

Before: 0.03548s | After: 0.03563s | Elapsed: 0.00015s



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

Before: 0.03611s | After: 0.03861s | Elapsed: 0.00250s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.03965s | After: 0.03979s | Elapsed: 0.00013s



Query results obtained from the cache

Before: 0.04245s | After: 0.04258s | Elapsed [cache]: 0.00013s | Elapsed [db]: 0.00007s



Query results obtained from the cache

Before: 0.04335s | After: 0.04375s | Elapsed [cache]: 0.00040s | Elapsed [db]: 0.00026s



Query results obtained from the cache

Before: 0.04507s | After: 0.04569s | Elapsed [cache]: 0.00062s | Elapsed [db]: 0.00067s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefsession_time,session_user_id,session_fidsession_fid3const2Using where

Before: 0.04668s | After: 0.04682s | Elapsed: 0.00014s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefsession_time,session_user_id,session_fidsession_fid3const2Using where

Before: 0.04716s | After: 0.04741s | Elapsed: 0.00025s



Query results obtained from the cache

Before: 0.04787s | After: 0.04798s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00004s



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

Before: 0.04839s | After: 0.04846s | Elapsed: 0.00007s



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

Before: 0.05254s | After: 0.05262s | Elapsed: 0.00008s



Query results obtained from the cache

Before: 0.05600s | After: 0.05633s | Elapsed [cache]: 0.00033s | Elapsed [db]: 0.00026s



Query #16
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrangeforum_id,forum_id_type,forum_appr_last,fid_time_movedfid_time_moved3 3Using where; Using filesort

Before: 0.06022s | After: 0.06054s | Elapsed: 0.00032s



Query #17
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrefforum_id,forum_id_type,topic_approved,forum_appr_last,fid_time_movedforum_id3const1Using where; Using filesort

Before: 0.06097s | After: 0.06115s | Elapsed: 0.00018s



Query #18
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtconstPRIMARYPRIMARY3const1 

Before: 0.06155s | After: 0.06167s | Elapsed: 0.00012s