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 `auth_assignment`
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 3,222 k | 319.8 k | 73.97 |
| delete | 243 k | 24.2 k | 5.59 |
| insert | 140 k | 13.9 k | 3.22 |
| show fields | 132 k | 13.1 k | 3.04 |
| show keys | 119 k | 11.8 k | 2.72 |
| update | 105 k | 10.4 k | 2.40 |
| change db | 94,472 | 9,375.8 | 2.17 |
| set option | 70,299 | 6,976.8 | 1.61 |
| show tables | 68,108 | 6,759.4 | 1.56 |
| show create table | 48,479 | 4,811.3 | 1.11 |
| flush | 34,775 | 3,451.2 | 0.80 |
| show variables | 23,178 | 2,300.3 | 0.53 |
| show grants | 12,113 | 1,202.2 | 0.28 |
| replace | 11,487 | 1,140 | 0.26 |
| show slave status | 8,836 | 876.9 | 0.20 |
| show master status | 8,577 | 851.2 | 0.20 |
| show create proc | 5,292 | 525.2 | 0.12 |
| show binlogs | 4,184 | 415.2 | 0.10 |
| show create func | 1,638 | 162.6 | 0.04 |
| show storage engines | 822 | 81.6 | 0.02 |
| show plugins | 795 | 78.9 | 0.02 |
| call procedure | 380 | 37.7 | 0.01 |
| show status | 373 | 37 | 0.01 |
| insert select | 291 | 28.9 | 0.01 |
| create temporary table | 291 | 28.9 | 0.01 |
| drop table | 291 | 28.9 | 0.01 |
| stmt prepare | 52 | 5.2 | <0.01 |
| stmt close | 52 | 5.2 | <0.01 |
| stmt execute | 52 | 5.2 | <0.01 |
| show processlist | 28 | 2.8 | <0.01 |