SQL Report


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

Time spent on mysql4 queries: 0.02091s | Time spent on PHP: 0.06406s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const21 

Before: 0.01030s | After: 0.01084s | Elapsed: 0.00054s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.02501s | After: 0.02584s | Elapsed: 0.00082s



Query results obtained from the cache

Before: 0.02643s | After: 0.02663s | Elapsed [cache]: 0.00020s | Elapsed [db]: 0.00037s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.02731s | After: 0.03093s | Elapsed: 0.00362s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.03141s | After: 0.03617s | Elapsed: 0.00476s



Query #6

Before: 0.03649s | After: 0.04099s | Elapsed: 0.00450s



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

Before: 0.04234s | After: 0.04429s | Elapsed: 0.00195s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.05145s | After: 0.05235s | Elapsed: 0.00090s



Query results obtained from the cache

Before: 0.05497s | After: 0.05516s | Elapsed [cache]: 0.00019s | Elapsed [db]: 0.00040s



Query results obtained from the cache

Before: 0.05757s | After: 0.05778s | Elapsed [cache]: 0.00022s | Elapsed [db]: 0.00058s



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

Before: 0.05901s | After: 0.05968s | Elapsed: 0.00067s



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

Before: 0.06041s | After: 0.06092s | Elapsed: 0.00050s



Query results obtained from the cache

Before: 0.06189s | After: 0.06208s | Elapsed [cache]: 0.00019s | Elapsed [db]: 0.00040s



Query results obtained from the cache

Before: 0.06670s | After: 0.06692s | Elapsed [cache]: 0.00021s | Elapsed [db]: 0.00049s



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.07184s | After: 0.07294s | Elapsed: 0.00111s



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

Before: 0.07380s | After: 0.07452s | Elapsed: 0.00073s



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

Before: 0.07532s | After: 0.07612s | Elapsed: 0.00080s