SQL Report


Page generated in 0.1679 seconds with 94 queries + 4 queries returning data from cache

Time spent on mysqli queries: 0.045s | Time spent on PHP: 0.12292s



Query #1
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_config refis_dynamicis_dynamic1const36100.00 

Before: 0.00511s | After: 0.00584s | Elapsed: 0.00073s



Query #2
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEu constPRIMARYPRIMARY4const1100.00 
1SIMPLEs refsession_user_idsession_user_id4const1100.00 

Before: 0.01659s | After: 0.01823s | Elapsed: 0.00165s



Query #3
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_banlist ALLban_user,ban_email,ban_ip   572.00Using where

Before: 0.01913s | After: 0.01975s | Elapsed: 0.00063s



Query #4
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_users constPRIMARYPRIMARY4const1100.00 

Affected rows: 1 | Before: 0.02100s | After: 0.02221s | Elapsed: 0.00121s



Query #5
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEf constPRIMARYPRIMARY3const1100.00 

Before: 0.02372s | After: 0.02460s | Elapsed: 0.00088s



Query results obtained from the cache

Before: 0.03110s | After: 0.03118s | Elapsed [cache]: 0.00008s | Elapsed [db]: 0.00047s



Query results obtained from the cache

Before: 0.05908s | After: 0.05916s | Elapsed [cache]: 0.00008s | Elapsed [db]: 0.00065s



Query #8
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_sessions constPRIMARYPRIMARY96const1100.00 

Affected rows: 1 | Before: 0.06008s | After: 0.06106s | Elapsed: 0.00098s



Query #9
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEs rangesession_time,session_user_id,session_fidsession_time4 180.28Using index condition; Using where

Before: 0.06209s | After: 0.06273s | Elapsed: 0.00064s



Query #10
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEs rangesession_time,session_user_id,session_fidsession_time4 180.28Using index condition; Using where

Before: 0.06333s | After: 0.06384s | Elapsed: 0.00050s



Query #11
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEu constPRIMARYPRIMARY4const1100.00 

Before: 0.06449s | After: 0.06496s | Elapsed: 0.00047s



Query results obtained from the cache

Before: 0.06602s | After: 0.06608s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00043s



Query results obtained from the cache

Before: 0.06788s | After: 0.06805s | Elapsed [cache]: 0.00017s | Elapsed [db]: 0.00088s



Query #14
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEt rangePRIMARY,forum_id,forum_id_type,last_post_time,fid_time_moved,topic_visibility,forum_vis_last,latest_topics,topic_priorityforum_id_type4 55100.00Using index condition; Using temporary; Using filesort
1SIMPLEu eq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.t.topic_last_poster_id1100.00 
1SIMPLEuf eq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.t.topic_poster1100.00 
1SIMPLEf eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.t.forum_id1100.00 
1SIMPLEslp rangesession_time,session_user_idsession_time4 18100.00Using where; Using join buffer (Block Nested Loop)

Before: 0.07246s | After: 0.07456s | Elapsed: 0.00210s



Query #15
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEt refforum_id,forum_id_type,fid_time_moved,forum_vis_last,latest_topicsforum_id3const1920.00Using index condition; Using where; Using filesort

Before: 0.07559s | After: 0.07615s | Elapsed: 0.00056s



Query #16
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEt rangePRIMARY,forum_id,forum_id_type,last_post_time,fid_time_moved,topic_visibility,forum_vis_last,latest_topics,topic_priorityPRIMARY4 19100.00Using where; Using temporary; Using filesort
1SIMPLEu eq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.t.topic_last_poster_id1100.00 
1SIMPLEuf eq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.t.topic_poster1100.00 
1SIMPLEslp rangesession_time,session_user_idsession_time4 18100.00Using where; Using join buffer (Block Nested Loop)

Before: 0.07757s | After: 0.07987s | Elapsed: 0.00230s



Query #17
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEt rangePRIMARYPRIMARY4 1990.00Using where
1SIMPLEu eq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.t.topic_attr_user1100.00Using where

Before: 0.08148s | After: 0.08208s | Elapsed: 0.00060s



Query #18

Before: 0.08217s | After: 0.08257s | Elapsed: 0.00040s



Query #19
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_topics rangePRIMARYPRIMARY4 19100.00Using where

Before: 0.08313s | After: 0.08360s | Elapsed: 0.00047s



Query #20
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.08497s | After: 0.08529s | Elapsed: 0.00031s



Query #21
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.08566s | After: 0.08593s | Elapsed: 0.00026s



Query #22
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.08650s | After: 0.08694s | Elapsed: 0.00044s



Query #23
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.08765s | After: 0.08813s | Elapsed: 0.00049s



Query #24
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.08928s | After: 0.08969s | Elapsed: 0.00041s



Query #25
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.09006s | After: 0.09044s | Elapsed: 0.00038s



Query #26
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.09093s | After: 0.09125s | Elapsed: 0.00032s



Query #27
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.09180s | After: 0.09213s | Elapsed: 0.00032s



Query #28
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.09306s | After: 0.09337s | Elapsed: 0.00031s



Query #29
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.09375s | After: 0.09398s | Elapsed: 0.00024s



Query #30
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.09434s | After: 0.09464s | Elapsed: 0.00030s



Query #31
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.09516s | After: 0.09549s | Elapsed: 0.00033s



Query #32
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.09653s | After: 0.09691s | Elapsed: 0.00039s



Query #33
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.09738s | After: 0.09776s | Elapsed: 0.00037s



Query #34
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.09821s | After: 0.09853s | Elapsed: 0.00032s



Query #35
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.09901s | After: 0.09929s | Elapsed: 0.00028s



Query #36
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.10019s | After: 0.10049s | Elapsed: 0.00030s



Query #37
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.10087s | After: 0.10115s | Elapsed: 0.00028s



Query #38
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.10153s | After: 0.10191s | Elapsed: 0.00038s



Query #39
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.10242s | After: 0.10280s | Elapsed: 0.00037s



Query #40
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.10377s | After: 0.10416s | Elapsed: 0.00040s



Query #41
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.10469s | After: 0.10510s | Elapsed: 0.00041s



Query #42
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.10564s | After: 0.10601s | Elapsed: 0.00037s



Query #43
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.10649s | After: 0.10687s | Elapsed: 0.00037s



Query #44
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.10786s | After: 0.10824s | Elapsed: 0.00038s



Query #45
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.10872s | After: 0.10910s | Elapsed: 0.00038s



Query #46
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.10954s | After: 0.10998s | Elapsed: 0.00044s



Query #47
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.11055s | After: 0.11099s | Elapsed: 0.00044s



Query #48
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.11203s | After: 0.11233s | Elapsed: 0.00030s



Query #49
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.11276s | After: 0.11300s | Elapsed: 0.00024s



Query #50
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.11343s | After: 0.11369s | Elapsed: 0.00025s



Query #51
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.11422s | After: 0.11459s | Elapsed: 0.00037s



Query #52
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.11566s | After: 0.11613s | Elapsed: 0.00046s



Query #53
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.11662s | After: 0.11690s | Elapsed: 0.00027s



Query #54
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.11735s | After: 0.11773s | Elapsed: 0.00037s



Query #55
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.11829s | After: 0.11862s | Elapsed: 0.00033s



Query #56
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.11962s | After: 0.11987s | Elapsed: 0.00025s



Query #57
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.12025s | After: 0.12051s | Elapsed: 0.00026s



Query #58
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.12087s | After: 0.12112s | Elapsed: 0.00025s



Query #59
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.12163s | After: 0.12192s | Elapsed: 0.00029s



Query #60
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.12286s | After: 0.12314s | Elapsed: 0.00028s



Query #61
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.12349s | After: 0.12375s | Elapsed: 0.00027s



Query #62
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.12422s | After: 0.12456s | Elapsed: 0.00033s



Query #63
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.12505s | After: 0.12536s | Elapsed: 0.00031s



Query #64
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.12635s | After: 0.12666s | Elapsed: 0.00031s



Query #65
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.12713s | After: 0.12738s | Elapsed: 0.00025s



Query #66
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.12780s | After: 0.12807s | Elapsed: 0.00026s



Query #67
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.12855s | After: 0.12897s | Elapsed: 0.00041s



Query #68
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.12995s | After: 0.13036s | Elapsed: 0.00041s



Query #69
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.13085s | After: 0.13128s | Elapsed: 0.00042s



Query #70
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.13181s | After: 0.13211s | Elapsed: 0.00030s



Query #71
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.13264s | After: 0.13297s | Elapsed: 0.00033s



Query #72
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.13387s | After: 0.13414s | Elapsed: 0.00028s



Query #73
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.13452s | After: 0.13478s | Elapsed: 0.00026s



Query #74
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.13526s | After: 0.13555s | Elapsed: 0.00028s



Query #75
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.13605s | After: 0.13638s | Elapsed: 0.00033s



Query #76
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.13744s | After: 0.13772s | Elapsed: 0.00029s



Query #77
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.13818s | After: 0.13856s | Elapsed: 0.00038s



Query #78
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.13907s | After: 0.13932s | Elapsed: 0.00025s



Query #79
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.13986s | After: 0.14025s | Elapsed: 0.00039s



Query #80
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.14115s | After: 0.14142s | Elapsed: 0.00027s



Query #81
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.14177s | After: 0.14203s | Elapsed: 0.00026s



Query #82
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.14240s | After: 0.14266s | Elapsed: 0.00026s



Query #83
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.14316s | After: 0.14356s | Elapsed: 0.00040s



Query #84
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.14461s | After: 0.14505s | Elapsed: 0.00044s



Query #85
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.14556s | After: 0.14585s | Elapsed: 0.00030s



Query #86
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.14629s | After: 0.14653s | Elapsed: 0.00024s



Query #87
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.14705s | After: 0.14737s | Elapsed: 0.00032s



Query #88
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.14837s | After: 0.14867s | Elapsed: 0.00029s



Query #89
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.14912s | After: 0.14944s | Elapsed: 0.00031s



Query #90
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.14996s | After: 0.15035s | Elapsed: 0.00039s



Query #91
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.15101s | After: 0.15135s | Elapsed: 0.00034s



Query #92
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.15237s | After: 0.15267s | Elapsed: 0.00030s



Query #93
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.15304s | After: 0.15329s | Elapsed: 0.00025s



Query #94
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.15365s | After: 0.15391s | Elapsed: 0.00026s



Query #95
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.15440s | After: 0.15474s | Elapsed: 0.00034s



Query #96
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums ALL    64100.00Using filesort

Before: 0.15585s | After: 0.15821s | Elapsed: 0.00235s



Query #97
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums indexPRIMARYforum_lastpost_id4 64100.00Using where; Using index

Before: 0.15985s | After: 0.16060s | Elapsed: 0.00075s



Query #98
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEt indexforum_id,forum_id_type,fid_time_moved,forum_vis_last,latest_topicslast_post_time4 570.05Using where
1SIMPLEu eq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.t.topic_last_poster_id1100.00 
1SIMPLEf eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.t.forum_id1100.00 

Before: 0.16381s | After: 0.16662s | Elapsed: 0.00281s