SQL Report


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

Time spent on mysql4 queries: 0.035s | Time spent on PHP: 0.11545s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const21 

Before: 0.02034s | After: 0.02083s | Elapsed: 0.00049s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.04511s | After: 0.04841s | Elapsed: 0.00330s



Query results obtained from the cache

Before: 0.04937s | After: 0.04964s | Elapsed [cache]: 0.00027s | Elapsed [db]: 0.00051s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.05064s | After: 0.06300s | Elapsed: 0.01237s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.06375s | After: 0.06965s | Elapsed: 0.00590s



Query #6

Before: 0.06987s | After: 0.07593s | Elapsed: 0.00606s



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

Before: 0.07688s | After: 0.07757s | Elapsed: 0.00069s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.08210s | After: 0.08254s | Elapsed: 0.00044s



Query results obtained from the cache

Before: 0.08707s | After: 0.08737s | Elapsed [cache]: 0.00029s | Elapsed [db]: 0.00042s



Query results obtained from the cache

Before: 0.09041s | After: 0.09066s | Elapsed [cache]: 0.00026s | Elapsed [db]: 0.00075s



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

Before: 0.09280s | After: 0.09564s | Elapsed: 0.00284s



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

Before: 0.09645s | After: 0.09694s | Elapsed: 0.00049s



Query results obtained from the cache

Before: 0.09821s | After: 0.09847s | Elapsed [cache]: 0.00027s | Elapsed [db]: 0.00039s



Query results obtained from the cache

Before: 0.10464s | After: 0.10494s | Elapsed [cache]: 0.00030s | Elapsed [db]: 0.00282s



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.13990s | After: 0.14098s | Elapsed: 0.00108s



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.14204s | After: 0.14271s | Elapsed: 0.00066s



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

Before: 0.14350s | After: 0.14419s | Elapsed: 0.00068s