SQL Report


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

Time spent on mysqli queries: 2.63802s | Time spent on PHP: 0.11192s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.01136s | After: 0.01209s | Elapsed: 0.00073s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03669s | After: 0.03705s | Elapsed: 0.00036s



Query results obtained from the cache

Before: 0.03830s | After: 0.03869s | Elapsed [cache]: 0.00039s | Elapsed [db]: 0.00021s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.04017s | After: 0.88149s | Elapsed: 0.84132s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.88256s | After: 2.00738s | Elapsed: 1.12482s



Query #6

Before: 2.00786s | After: 2.67025s | Elapsed: 0.66240s



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

Before: 2.67181s | After: 2.67765s | Elapsed: 0.00584s



Query results obtained from the cache

Before: 2.68375s | After: 2.68411s | Elapsed [cache]: 0.00036s | Elapsed [db]: 0.00022s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfALL    53Using filesort

Before: 2.69051s | After: 2.69127s | Elapsed: 0.00076s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_time4 31Using where
1SIMPLEueq_refPRIMARYPRIMARY3forum_fedegnv3.s.session_user_id1 

Before: 2.69737s | After: 2.69889s | Elapsed: 0.00152s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEgrangegroup_legend_namegroup_legend_name3 2Using where
1SIMPLEugrefgroup_id,user_iduser_id3const1Using where

Before: 2.71984s | After: 2.72011s | Elapsed: 0.00027s



Query results obtained from the cache

Before: 2.72385s | After: 2.72420s | Elapsed [cache]: 0.00035s | Elapsed [db]: 0.00020s



Query results obtained from the cache

Before: 2.73522s | After: 2.73622s | Elapsed [cache]: 0.00100s | Elapsed [db]: 0.00073s