SQL Report


Page generated in 0.3145 seconds with 52 queries + 3 queries returning data from cache

Time spent on mysqli queries: 0.07095s | Time spent on PHP: 0.24359s



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

Before: 0.06156s | After: 0.06214s | Elapsed: 0.00058s



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

Before: 0.10853s | After: 0.10978s | Elapsed: 0.00126s



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

Before: 0.11068s | After: 0.11117s | Elapsed: 0.00049s



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

Affected rows: 1 | Before: 0.11369s | After: 0.11486s | Elapsed: 0.00118s



Query results obtained from the cache

Before: 0.15519s | After: 0.15526s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00040s



Query #6
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEf ALLPRIMARY,left_right_id,forum_lastpost_id   64100.00Using temporary; Using filesort
1SIMPLEslp rangesession_time,session_user_idsession_time4 9100.00Using where; Using join buffer (Block Nested Loop)

Before: 0.16608s | After: 0.17571s | Elapsed: 0.00963s



Query #7
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEp rangePRIMARY,topic_id,tid_post_timePRIMARY4 17100.00Using where
1SIMPLEt eq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.p.topic_id1100.00 

Before: 0.18211s | After: 0.18305s | Elapsed: 0.00094s



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

Before: 0.19906s | After: 0.19963s | Elapsed: 0.00057s



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

Before: 0.20041s | After: 0.20088s | Elapsed: 0.00047s



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

Before: 0.20296s | After: 0.20330s | Elapsed: 0.00034s



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

Before: 0.20394s | After: 0.20442s | Elapsed: 0.00048s



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

Before: 0.20559s | After: 0.20593s | Elapsed: 0.00034s



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

Before: 0.20640s | After: 0.20681s | Elapsed: 0.00041s



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

Before: 0.20784s | After: 0.20825s | Elapsed: 0.00041s



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

Before: 0.20884s | After: 0.20919s | Elapsed: 0.00034s



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

Before: 0.21027s | After: 0.21059s | Elapsed: 0.00032s



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

Before: 0.21107s | After: 0.21144s | Elapsed: 0.00037s



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

Before: 0.21254s | After: 0.21294s | Elapsed: 0.00041s



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

Before: 0.21351s | After: 0.21395s | Elapsed: 0.00044s



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

Before: 0.21528s | After: 0.21574s | Elapsed: 0.00047s



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

Before: 0.21631s | After: 0.21666s | Elapsed: 0.00034s



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

Before: 0.21770s | After: 0.21810s | Elapsed: 0.00040s



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

Before: 0.21877s | After: 0.21915s | Elapsed: 0.00039s



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

Before: 0.22025s | After: 0.22070s | Elapsed: 0.00044s



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

Before: 0.22117s | After: 0.22153s | Elapsed: 0.00036s



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

Before: 0.22270s | After: 0.22309s | Elapsed: 0.00040s



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

Before: 0.22360s | After: 0.22389s | Elapsed: 0.00028s



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

Before: 0.22498s | After: 0.22528s | Elapsed: 0.00030s



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

Before: 0.22576s | After: 0.22606s | Elapsed: 0.00030s



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

Before: 0.22711s | After: 0.22764s | Elapsed: 0.00052s



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

Before: 0.22832s | After: 0.22871s | Elapsed: 0.00040s



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

Before: 0.22987s | After: 0.23020s | Elapsed: 0.00032s



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

Before: 0.23077s | After: 0.23110s | Elapsed: 0.00032s



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

Before: 0.23255s | After: 0.23289s | Elapsed: 0.00034s



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

Before: 0.23339s | After: 0.23376s | Elapsed: 0.00037s



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

Before: 0.23468s | After: 0.23499s | Elapsed: 0.00031s



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

Before: 0.23546s | After: 0.23577s | Elapsed: 0.00031s



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

Before: 0.23688s | After: 0.23721s | Elapsed: 0.00033s



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

Before: 0.23770s | After: 0.23803s | Elapsed: 0.00032s



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

Before: 0.23922s | After: 0.23975s | Elapsed: 0.00052s



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

Before: 0.24041s | After: 0.24090s | Elapsed: 0.00049s



Query #42
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEg ALLgroup_legend_name   1631.25Using where; Using filesort
1SIMPLEug refgroup_id,user_iduser_id4const1100.00Using where

Before: 0.24194s | After: 0.24274s | Elapsed: 0.00080s



Query #43
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts index tid_post_time8 310033.33Using where; Using index

Before: 0.24599s | After: 0.24718s | Elapsed: 0.00119s



Query #44
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_topics ALL    81833.33Using where

Before: 0.24761s | After: 0.24828s | Elapsed: 0.00067s



Query #45
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_users ALL    66033.33Using where

Before: 0.24893s | After: 0.25003s | Elapsed: 0.00109s



Query #46
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEu ALL    660100.00Using temporary; Using filesort
1SIMPLEs refsession_user_idsession_user_id4db0rm_app_phpbb_2.u.user_id174100.00Using where

Before: 0.25155s | After: 0.28375s | Elapsed: 0.03220s



Query #47
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_sessions rangesession_time,session_user_idsession_time4 180650.00Using index condition; Using where

Before: 0.28528s | After: 0.28876s | Elapsed: 0.00348s



Query #48
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEt ALL    433.33Using where; Using filesort

Before: 0.29024s | After: 0.29067s | Elapsed: 0.00043s



Query #49
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEt ALL    433.33Using where; Using filesort

Before: 0.29126s | After: 0.29161s | Elapsed: 0.00035s



Query results obtained from the cache

Before: 0.29442s | After: 0.29448s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00044s



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

Affected rows: 1 | Before: 0.29527s | After: 0.29638s | Elapsed: 0.00112s



Query #52
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEs rangesession_time,session_user_idsession_time4 950.00Using index condition; Using where

Before: 0.29738s | After: 0.29820s | Elapsed: 0.00081s



Query #53
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEs rangesession_time,session_user_idsession_time4 90.56Using index condition; Using where

Before: 0.29909s | After: 0.29976s | Elapsed: 0.00067s



Query #54
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEu rangePRIMARYPRIMARY4 4100.00Using where; Using filesort

Before: 0.30121s | After: 0.30215s | Elapsed: 0.00094s



Query results obtained from the cache

Before: 0.30305s | After: 0.30317s | Elapsed [cache]: 0.00012s | Elapsed [db]: 0.00057s