SQL Report


Page generated in 0.274 seconds with 10 queries + 4 queries returning data from cache

Time spent on mysqli queries: 0.15081s | Time spent on PHP: 0.1232s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.01532s | After: 0.01561s | Elapsed: 0.00029s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.04567s | After: 0.04658s | Elapsed: 0.00090s



Query results obtained from the cache

Before: 0.04779s | After: 0.04817s | Elapsed [cache]: 0.00038s | Elapsed [db]: 0.00021s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.04964s | After: 0.10398s | Elapsed: 0.05435s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.10521s | After: 0.14566s | Elapsed: 0.04045s



Query #6

Before: 0.14619s | After: 0.18739s | Elapsed: 0.04120s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_time,session_user_idsession_time4 928Using where

Before: 0.18910s | After: 0.19713s | Elapsed: 0.00803s



Query results obtained from the cache

Before: 0.20347s | After: 0.20391s | Elapsed [cache]: 0.00044s | Elapsed [db]: 0.00026s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_forumsindexPRIMARYforum_lastpost_id3 53Using where; Using index

Before: 0.21286s | After: 0.21322s | Elapsed: 0.00036s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfALLPRIMARY   53Using where; Using filesort
1SIMPLEfarefPRIMARYPRIMARY3forum_fedegnv3.f.forum_id1Using where; Using index

Before: 0.21569s | After: 0.21793s | Elapsed: 0.00224s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_zebrarefPRIMARYPRIMARY3const1 

Before: 0.22503s | After: 0.22532s | Elapsed: 0.00030s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprangePRIMARY,forum_id,post_visibilityPRIMARY3 5Using where; Using filesort
1SIMPLEteq_refPRIMARYPRIMARY3forum_fedegnv3.p.topic_id1 
1SIMPLEfeq_refPRIMARYPRIMARY3forum_fedegnv3.p.forum_id1Using where
1SIMPLEueq_refPRIMARYPRIMARY3forum_fedegnv3.p.poster_id1 

Before: 0.22786s | After: 0.23055s | Elapsed: 0.00269s



Query results obtained from the cache

Before: 0.24781s | After: 0.24821s | Elapsed [cache]: 0.00040s | Elapsed [db]: 0.00023s



Query results obtained from the cache

Before: 0.25916s | After: 0.26005s | Elapsed [cache]: 0.00089s | Elapsed [db]: 0.00071s