SQL Report


Page generated in 0.181 seconds with 12 queries + 3 queries returning data from cache

Time spent on mysqli queries: 0.06682s | Time spent on PHP: 0.11416s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.00799s | After: 0.00876s | Elapsed: 0.00077s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03343s | After: 0.03383s | Elapsed: 0.00040s



Query results obtained from the cache

Before: 0.03526s | After: 0.03569s | Elapsed [cache]: 0.00043s | Elapsed [db]: 0.00024s



Query #4

Before: 0.03666s | After: 0.08305s | Elapsed: 0.04639s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_time,session_user_idsession_time4 832Using where

Before: 0.08478s | After: 0.09294s | Elapsed: 0.00816s



Query results obtained from the cache

Before: 0.10012s | After: 0.10049s | Elapsed [cache]: 0.00036s | Elapsed [db]: 0.00022s



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

Before: 0.10748s | After: 0.10775s | Elapsed: 0.00027s



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

Before: 0.11015s | After: 0.11269s | Elapsed: 0.00255s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprefforum_id,poster_id,post_visibilityposter_id3const5Using where; Using filesort

Before: 0.11883s | After: 0.12007s | Elapsed: 0.00124s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprefforum_id,poster_id,post_visibilityposter_id3const5Using where; Using filesort

Before: 0.12171s | After: 0.12312s | Elapsed: 0.00142s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE       No tables used

Before: 0.12419s | After: 0.12464s | Elapsed: 0.00044s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_zebrarefPRIMARYPRIMARY3const1 

Before: 0.12924s | After: 0.13007s | Elapsed: 0.00083s



Query #13
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.13314s | After: 0.13679s | Elapsed: 0.00365s



Query results obtained from the cache

Before: 0.15410s | After: 0.15446s | Elapsed [cache]: 0.00036s | Elapsed [db]: 0.00023s



Query #15
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_forumsALL    53Using filesort

Before: 0.16446s | After: 0.16517s | Elapsed: 0.00072s