SQL Report


Page generated in 0.1419 seconds with 12 queries + 3 queries returning data from cache

Time spent on mysqli queries: 0.00529s | Time spent on PHP: 0.13662s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const27 

Before: 0.09491s | After: 0.09516s | Elapsed: 0.00025s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY4const1 

Before: 0.11733s | After: 0.11801s | Elapsed: 0.00068s



Query results obtained from the cache

Before: 0.11850s | After: 0.11862s | Elapsed [cache]: 0.00012s | Elapsed [db]: 0.00036s



Query #4

Before: 0.11899s | After: 0.11950s | Elapsed: 0.00051s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrefsession_time,session_user_idsession_user_id4const358Using where

Before: 0.11995s | After: 0.12081s | Elapsed: 0.00086s



Query results obtained from the cache

Before: 0.12244s | After: 0.12249s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00027s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurangeusername_clean,user_typeusername_clean767 3Using where

Before: 0.12400s | After: 0.12435s | Elapsed: 0.00035s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_groupsALL    7Using where; Using filesort

Before: 0.12498s | After: 0.12519s | Elapsed: 0.00021s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurangeusername_clean,user_typeusername_clean767 3Using where; Using filesort

Before: 0.12569s | After: 0.12605s | Elapsed: 0.00037s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_langreflang_isolang_iso92const1Using where

Before: 0.12709s | After: 0.12741s | Elapsed: 0.00032s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfALLPRIMARY   12Using where; Using filesort
1SIMPLEleq_refPRIMARYPRIMARY6db308604267.f.field_id,const1 

Before: 0.12813s | After: 0.12843s | Elapsed: 0.00029s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_time,session_user_idsession_user_id4 1074Using where; Using temporary; Using filesort

Before: 0.12973s | After: 0.13013s | Elapsed: 0.00040s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersrangePRIMARYPRIMARY4 3Using where

Before: 0.13059s | After: 0.13128s | Elapsed: 0.00069s



Query #14
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_profile_fields_dataALLPRIMARY   2Using where

Before: 0.13171s | After: 0.13206s | Elapsed: 0.00035s



Query results obtained from the cache

Before: 0.14154s | After: 0.14161s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00024s