SQL Report


Page generated in 0.0908 seconds with 12 queries + 5 queries returning data from cache

Time spent on mysql4 queries: 0.02703s | Time spent on PHP: 0.06376s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const21 

Before: 0.01156s | After: 0.01224s | Elapsed: 0.00069s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.02844s | After: 0.02921s | Elapsed: 0.00077s



Query results obtained from the cache

Before: 0.02999s | After: 0.03020s | Elapsed [cache]: 0.00021s | Elapsed [db]: 0.00052s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.03115s | After: 0.03744s | Elapsed: 0.00629s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.03809s | After: 0.04357s | Elapsed: 0.00548s



Query #6

Before: 0.04390s | After: 0.04871s | Elapsed: 0.00481s



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

Before: 0.05017s | After: 0.05434s | Elapsed: 0.00417s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.06166s | After: 0.06248s | Elapsed: 0.00083s



Query results obtained from the cache

Before: 0.06473s | After: 0.06490s | Elapsed [cache]: 0.00017s | Elapsed [db]: 0.00040s



Query results obtained from the cache

Before: 0.06732s | After: 0.06751s | Elapsed [cache]: 0.00019s | Elapsed [db]: 0.00057s



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

Before: 0.06870s | After: 0.06945s | Elapsed: 0.00075s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_id,session_fidsession_user_id3 2Using index condition; Using where

Before: 0.07019s | After: 0.07071s | Elapsed: 0.00051s



Query results obtained from the cache

Before: 0.07172s | After: 0.07192s | Elapsed [cache]: 0.00020s | Elapsed [db]: 0.00040s



Query results obtained from the cache

Before: 0.07669s | After: 0.07691s | Elapsed [cache]: 0.00022s | Elapsed [db]: 0.00053s



Query #15
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrangeforum_id,forum_id_type,fid_time_moved,forum_vis_lastforum_id_type4 5Using index condition; Using temporary; Using filesort
1SIMPLEfALLPRIMARY   4Using where; Using join buffer (Block Nested Loop)

Before: 0.08176s | After: 0.08307s | Elapsed: 0.00131s



Query #16
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrefforum_id,forum_id_type,fid_time_moved,topic_visibility,forum_vis_lastforum_id3const5Using where; Using filesort

Before: 0.08396s | After: 0.08459s | Elapsed: 0.00062s



Query #17
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrangePRIMARYPRIMARY3 5Using where

Before: 0.08541s | After: 0.08620s | Elapsed: 0.00079s