SQL Report


Page generated in 7.6471 seconds with 8 queries + 4 queries returning data from cache

Time spent on mysqli queries: 7.5675s | Time spent on PHP: 0.07962s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.00921s | After: 0.00943s | Elapsed: 0.00022s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.02997s | After: 0.03033s | Elapsed: 0.00036s



Query results obtained from the cache

Before: 0.03155s | After: 0.03194s | Elapsed [cache]: 0.00039s | Elapsed [db]: 0.00021s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.03347s | After: 1.95682s | Elapsed: 1.92335s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 1.95808s | After: 3.02881s | Elapsed: 1.07073s



Query #6

Before: 3.02939s | After: 5.16403s | Elapsed: 2.13464s



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

Before: 5.16587s | After: 5.17181s | Elapsed: 0.00595s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_forumsconstPRIMARYPRIMARY3const1 

Before: 5.17521s | After: 5.17613s | Elapsed: 0.00092s



Query results obtained from the cache

Before: 5.18520s | After: 5.18557s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00023s



Query #10

Before: 5.18790s | After: 7.61924s | Elapsed: 2.43133s



Query results obtained from the cache

Before: 7.62193s | After: 7.62228s | Elapsed [cache]: 0.00035s | Elapsed [db]: 0.00020s



Query results obtained from the cache

Before: 7.63286s | After: 7.63374s | Elapsed [cache]: 0.00088s | Elapsed [db]: 0.00066s