SQL Report


Page generated in 0.1825 seconds with 24 queries + 2 queries returning data from cache

Time spent on mysqli queries: 0.02429s | Time spent on PHP: 0.15825s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_configrefis_dynamicis_dynamic1const35 

Before: 0.04988s | After: 0.05072s | Elapsed: 0.00084s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuconstPRIMARYPRIMARY4const1 
1SIMPLEsrefsession_user_idsession_user_id4const1 

Before: 0.07987s | After: 0.08145s | Elapsed: 0.00159s



Query #3
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_banlistALLban_user,ban_email,ban_ip   6Using where

Before: 0.08222s | After: 0.08293s | Elapsed: 0.00071s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_usersconstPRIMARYPRIMARY4const1 

Affected rows: 1 | Before: 0.08372s | After: 0.08445s | Elapsed: 0.00073s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtconstPRIMARY,forum_id,forum_id_type,fid_time_moved,forum_vis_last,latest_topicsPRIMARY4const1 
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.08723s | After: 0.08882s | Elapsed: 0.00159s



Query results obtained from the cache

Before: 0.10151s | After: 0.10158s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00062s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtconstPRIMARYPRIMARY4const1 
1SIMPLEuconstPRIMARYPRIMARY4const1 

Before: 0.11467s | After: 0.11526s | Elapsed: 0.00059s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpreftopic_id,tid_post_timetid_post_time4const1Using where; Using index

Before: 0.11737s | After: 0.11797s | Elapsed: 0.00060s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpconstPRIMARY,poster_idPRIMARY4const1 
1SIMPLEzconstPRIMARYPRIMARY8const,const Unique row not found
1SIMPLEuconstPRIMARYPRIMARY4const1 

Before: 0.11954s | After: 0.12178s | Elapsed: 0.00224s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_langreflang_isolang_iso92const1Using where; Using index

Before: 0.12994s | After: 0.13035s | Elapsed: 0.00042s



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

Before: 0.13104s | After: 0.13211s | Elapsed: 0.00107s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_profile_fields_dataconstPRIMARYPRIMARY4const1 

Before: 0.13265s | After: 0.13328s | Elapsed: 0.00063s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_sessionsrefsession_user_idsession_user_id4const1 

Before: 0.13393s | After: 0.13451s | Elapsed: 0.00058s



Query #14
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLEarefuser_id,auth_option_id,auth_role_idauth_option_id3const1Using where

Before: 0.13532s | After: 0.13603s | Elapsed: 0.00072s



Query #15
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLEarefuser_id,auth_role_iduser_id4const6 
1SIMPLEreq_refPRIMARY,ath_op_idPRIMARY6db0rm_app_phpbb_2.a.auth_role_id,const1 

Before: 0.13689s | After: 0.13762s | Elapsed: 0.00073s



Query #16
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLEarefgroup_id,auth_opt_id,auth_role_idauth_opt_id3const13Using where
1SIMPLEugref|filtergroup_id,user_id,group_leadergroup_id|user_id3|4db0rm_app_phpbb_2.a.group_id10 (1%)Using where; Using rowid filter
1SIMPLEgeq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.a.group_id1Using where

Before: 0.13877s | After: 0.13995s | Elapsed: 0.00118s



Query #17
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLEgALLPRIMARY   17 
1SIMPLEugref|filtergroup_id,user_id,group_leadergroup_id|user_id3|4db0rm_app_phpbb_2.g.group_id10 (1%)Using where; Using rowid filter
1SIMPLEarefgroup_id,auth_role_idgroup_id3db0rm_app_phpbb_2.g.group_id253 
1SIMPLEreq_refPRIMARY,ath_op_idPRIMARY6db0rm_app_phpbb_2.a.auth_role_id,const1 

Before: 0.14078s | After: 0.14660s | Elapsed: 0.00582s



Query #18
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_banlistALLban_end,ban_user   6Using where

Before: 0.14715s | After: 0.14751s | Elapsed: 0.00036s



Query #19
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpconstPRIMARYPRIMARY4const1 
1SIMPLEuconstPRIMARYPRIMARY4const1 

Before: 0.15009s | After: 0.15051s | Elapsed: 0.00043s



Query #20
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuconstPRIMARYPRIMARY4const1 
1SIMPLEugrefuser_iduser_id4const1Using where

Before: 0.17072s | After: 0.17125s | Elapsed: 0.00053s



Query #21
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_config_textconstPRIMARYPRIMARY767const1 

Before: 0.17207s | After: 0.17250s | Elapsed: 0.00042s



Query #22
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_sessionsconstPRIMARYPRIMARY96const1 

Affected rows: 1 | Before: 0.17324s | After: 0.17385s | Elapsed: 0.00061s



Query #23
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsref|filtersession_time,session_user_id,session_fidsession_fid|session_time3|4const3 (12%)Using where; Using rowid filter

Before: 0.17488s | After: 0.17560s | Elapsed: 0.00072s



Query #24
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsref|filtersession_time,session_user_id,session_fidsession_fid|session_time3|4const3 (12%)Using where; Using rowid filter

Before: 0.17634s | After: 0.17696s | Elapsed: 0.00062s



Query #25
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuconstPRIMARYPRIMARY4const1 

Before: 0.17767s | After: 0.17823s | Elapsed: 0.00055s



Query results obtained from the cache

Before: 0.18092s | After: 0.18105s | Elapsed [cache]: 0.00013s | Elapsed [db]: 0.00130s