SQL Report


Page generated in 0.0495 seconds with 11 queries + 4 queries returning data from cache

Time spent on mysqli queries: 0.00305s | Time spent on PHP: 0.04644s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_configrefis_dynamicis_dynamic1const23 

Before: 0.00825s | After: 0.00849s | Elapsed: 0.00023s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsconstPRIMARY,session_user_idPRIMARY96const1 
1SIMPLEuconstPRIMARYPRIMARY4const1 

Before: 0.01849s | After: 0.01887s | Elapsed: 0.00039s



Query results obtained from the cache

Before: 0.01997s | After: 0.02008s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00026s



Query results obtained from the cache

Before: 0.02229s | After: 0.02237s | Elapsed [cache]: 0.00008s | Elapsed [db]: 0.00011s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurangeusername_clean,user_typeusername_clean767 9Using index condition; Using where

Before: 0.02392s | After: 0.02414s | Elapsed: 0.00023s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEgALL    7Using where; Using filesort
1SIMPLEugrefgroup_id,user_iduser_id4const1Using where

Before: 0.02522s | After: 0.02548s | Elapsed: 0.00026s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurangeusername_clean,user_typeusername_clean767 9Using index condition; Using where; Using filesort

Before: 0.02631s | After: 0.02652s | Elapsed: 0.00021s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_langreflang_isolang_iso92const1Using where; Using index

Before: 0.02698s | After: 0.02712s | Elapsed: 0.00014s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfALLPRIMARY   13Using where; Using filesort
1SIMPLEleq_refPRIMARYPRIMARY6sunphu_newforum.f.field_id,const1 

Before: 0.02745s | After: 0.02786s | Elapsed: 0.00041s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_sessionsrangesession_time,session_user_idsession_user_id4 9Using index condition; Using where

Before: 0.02912s | After: 0.02933s | Elapsed: 0.00021s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_usersrangePRIMARYPRIMARY4 9Using where

Before: 0.02958s | After: 0.02986s | Elapsed: 0.00028s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_profile_fields_datarangePRIMARYPRIMARY4 9Using where

Before: 0.03029s | After: 0.03046s | Elapsed: 0.00017s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEnbb_sessionsconstPRIMARYPRIMARY96const1 

Affected rows: 1 | Before: 0.04010s | After: 0.04062s | Elapsed: 0.00051s



Query results obtained from the cache

Before: 0.04095s | After: 0.04106s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00021s



Query results obtained from the cache

Before: 0.04348s | After: 0.04389s | Elapsed [cache]: 0.00041s | Elapsed [db]: 0.00047s