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 `collectionsources`
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 7,840 k | 83.6 k | 71.18 |
| delete | 526 k | 5,609.5 | 4.78 |
| show fields | 509 k | 5,428.5 | 4.62 |
| insert | 453 k | 4,829.9 | 4.11 |
| update | 326 k | 3,476.4 | 2.96 |
| set option | 261 k | 2,781.8 | 2.37 |
| show keys | 223 k | 2,380.6 | 2.03 |
| change db | 188 k | 2,001 | 1.70 |
| show tables | 132 k | 1,407.9 | 1.20 |
| show create table | 90,050 | 959.8 | 0.82 |
| flush | 66,304 | 706.7 | 0.60 |
| call procedure | 63,120 | 672.8 | 0.57 |
| drop table | 62,295 | 664 | 0.57 |
| insert select | 62,295 | 664 | 0.57 |
| create temporary table | 62,295 | 664 | 0.57 |
| show variables | 40,343 | 430 | 0.37 |
| show grants | 28,837 | 307.4 | 0.26 |
| replace | 19,823 | 211.3 | 0.18 |
| show slave status | 16,900 | 180.1 | 0.15 |
| show master status | 16,383 | 174.6 | 0.15 |
| show create proc | 8,526 | 90.9 | 0.08 |
| show binlogs | 7,159 | 76.3 | 0.06 |
| show plugins | 4,191 | 44.7 | 0.04 |
| show create func | 2,639 | 28.1 | 0.02 |
| show storage engines | 1,158 | 12.3 | 0.01 |
| show status | 628 | 6.7 | 0.01 |
| stmt prepare | 563 | 6 | 0.01 |
| stmt execute | 563 | 6 | 0.01 |
| stmt close | 563 | 6 | 0.01 |
| show table status | 495 | 5.3 | <0.01 |
| show processlist | 43 | 0.5 | <0.01 |