Press Ctrl+Enter to execute queryPress Enter to execute query
Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: mysql Queried time: During current session
SELECT * FROM `user`
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 13,549 k | 141.3 k | 71.75 |
| delete | 935 k | 9,751.9 | 4.95 |
| show fields | 776 k | 8,086.5 | 4.11 |
| insert | 698 k | 7,271.7 | 3.69 |
| show keys | 535 k | 5,574.8 | 2.83 |
| update | 505 k | 5,264.4 | 2.67 |
| change db | 392 k | 4,083.4 | 2.07 |
| set option | 385 k | 4,013.1 | 2.04 |
| show tables | 243 k | 2,529.9 | 1.28 |
| show create table | 207 k | 2,162.9 | 1.10 |
| flush | 125 k | 1,300.9 | 0.66 |
| call procedure | 66,613 | 694.5 | 0.35 |
| drop table | 65,763 | 685.6 | 0.35 |
| insert select | 65,763 | 685.6 | 0.35 |
| create temporary table | 65,763 | 685.6 | 0.35 |
| show variables | 56,206 | 586 | 0.30 |
| show grants | 46,321 | 482.9 | 0.25 |
| show slave status | 42,605 | 444.2 | 0.23 |
| show master status | 41,831 | 436.1 | 0.22 |
| replace | 29,133 | 303.7 | 0.15 |
| show create proc | 20,328 | 211.9 | 0.11 |
| show binlogs | 16,419 | 171.2 | 0.09 |
| show create func | 6,292 | 65.6 | 0.03 |
| show plugins | 6,278 | 65.4 | 0.03 |
| show storage engines | 3,584 | 37.4 | 0.02 |
| show status | 878 | 9.2 | <0.01 |
| stmt prepare | 585 | 6.1 | <0.01 |
| stmt execute | 585 | 6.1 | <0.01 |
| stmt close | 585 | 6.1 | <0.01 |
| show table status | 522 | 5.4 | <0.01 |
| show processlist | 92 | 1 | <0.01 |