SQL Report


Page generated in 0.161 seconds with 9 queries + 4 queries returning data from cache

Time spent on mysqli queries: 0.06727s | Time spent on PHP: 0.09375s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.00817s | After: 0.00841s | Elapsed: 0.00024s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03163s | After: 0.03197s | Elapsed: 0.00034s



Query results obtained from the cache

Before: 0.03323s | After: 0.03360s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00020s



Query #4

Before: 0.03443s | After: 0.08465s | Elapsed: 0.05022s



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

Before: 0.08787s | After: 0.09868s | Elapsed: 0.01082s



Query results obtained from the cache

Before: 0.10406s | After: 0.10445s | Elapsed [cache]: 0.00040s | Elapsed [db]: 0.00022s



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

Before: 0.11099s | After: 0.11126s | Elapsed: 0.00027s



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

Before: 0.11375s | After: 0.11598s | Elapsed: 0.00223s



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

Before: 0.12104s | After: 0.12243s | Elapsed: 0.00138s



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

Before: 0.12434s | After: 0.12568s | Elapsed: 0.00134s



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

Before: 0.12676s | After: 0.12719s | Elapsed: 0.00043s



Query results obtained from the cache

Before: 0.13266s | After: 0.13313s | Elapsed [cache]: 0.00047s | Elapsed [db]: 0.00027s



Query results obtained from the cache

Before: 0.14656s | After: 0.14744s | Elapsed [cache]: 0.00088s | Elapsed [db]: 0.00067s