SQL Report


Page generated in 3.1962 seconds with 12 queries + 5 queries returning data from cache

Time spent on mysqli queries: 3.03394s | Time spent on PHP: 0.16227s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.00898s | After: 0.00919s | Elapsed: 0.00021s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03550s | After: 0.03586s | Elapsed: 0.00036s



Query results obtained from the cache

Before: 0.03708s | After: 0.03747s | Elapsed [cache]: 0.00039s | Elapsed [db]: 0.00021s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.03896s | After: 0.81667s | Elapsed: 0.77771s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.81774s | After: 1.98423s | Elapsed: 1.16649s



Query #6

Before: 1.98470s | After: 3.05184s | Elapsed: 1.06714s



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

Before: 3.05337s | After: 3.05909s | Elapsed: 0.00572s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 3.06654s | After: 3.06702s | Elapsed: 0.00048s



Query results obtained from the cache

Before: 3.07242s | After: 3.07278s | Elapsed [cache]: 0.00036s | Elapsed [db]: 0.00023s



Query results obtained from the cache

Before: 3.07609s | After: 3.07647s | Elapsed [cache]: 0.00038s | Elapsed [db]: 0.00077s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_id,session_fidsession_time4 36Using where

Before: 3.07873s | After: 3.08008s | Elapsed: 0.00135s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_id,session_fidsession_time4 32Using where

Before: 3.08142s | After: 3.08304s | Elapsed: 0.00161s



Query results obtained from the cache

Before: 3.08619s | After: 3.08667s | Elapsed [cache]: 0.00048s | Elapsed [db]: 0.00027s



Query results obtained from the cache

Before: 3.10048s | After: 3.10157s | Elapsed [cache]: 0.00109s | Elapsed [db]: 0.00076s



Query #15
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrangeforum_id,forum_id_type,fid_time_moved,forum_vis_lastforum_id_type4 44Using where; Using filesort
1SIMPLEfeq_refPRIMARYPRIMARY3forum_fedegnv3.t.forum_id1 

Before: 3.12866s | After: 3.13738s | Elapsed: 0.00872s



Query #16
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrefforum_id,forum_id_type,fid_time_moved,topic_visibility,forum_vis_lastforum_id3const26Using where; Using filesort

Before: 3.13985s | After: 3.14234s | Elapsed: 0.00250s



Query #17
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrangePRIMARYPRIMARY3 16Using where

Before: 3.14416s | After: 3.14581s | Elapsed: 0.00165s