Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sys »View: statement_analysis
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.0158 seconds.)
SELECT * FROM `statement_analysis`
querydbfull_scanexec_counterr_countwarn_counttotal_latencymax_latencyavg_latencylock_latencyrows_sentrows_sent_avgrows_examinedrows_examined_avgrows_affectedrows_affected_avgtmp_tablestmp_disk_tablesrows_sortedsort_merge_passesdigestfirst_seenlast_seen
REPLACE INTO `phpmyadmin` . `p ... ame` , `tables`... NULL 18740 0 0 17.25 min 2.11 s 55.23 ms 808.66 ms 0 0 0 0 37402 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:23.687832 2026-10-06 15:47:36.264740
REPLACE INTO `phpmyadmin` . `p ... ame` , `tables`... phpmyadmin 1887 0 0 1.79 min 485.57 ms 57.07 ms 74.46 ms 0 0 0 0 3765 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:24.711752 2026-10-06 15:47:34.265987
SELECT ( `cat` . `name` COLLAT ... ction_collation... sys 169116 0 0 44.59 s 1.56 ms 263.48 us 22.69 s 166848 1 1007891 6 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:12:29.899908 2026-10-06 15:47:13.011137
REPLACE INTO `phpmyadmin` . `p ... ame` , `tables`... NULL 246 0 0 14.64 s 211.71 ms 59.51 ms 19.31 ms 0 0 0 0 491 2 0 0 0 0 3f68cdacb0dc8def195c35b2b0d0ad9677d9e170013adb2c51... 2026-10-06 08:10:26.952120 2026-10-06 10:25:39.883890
SELECT ( `cat` . `name` COLLAT ... te_data` , COAL... mysql * 5127 0 19 11.55 s 8.01 s 2.25 ms 1.80 s 50923 10 356352 70 0 0 383 0 46923 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:01:02.943794 2026-10-06 15:47:36.195404
SELECT IF ( ( `locate` ( ? , ` ... ` . `COMPRESSED... sys * 113 0 0 10.30 s 779.82 ms 91.17 ms 13.08 ms 703 6 1379768 12210 0 0 286 31 55672 31 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2026-10-06 08:37:21.878632 2026-10-06 15:28:55.084148
SELECT ( `cat` . `name` COLLAT ... den` ) ) , COAL... NULL 6649 0 0 10.26 s 289.51 ms 1.54 ms 2.13 s 7987 1 95804 14 0 0 6649 0 7987 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:10:25.928426 2026-10-06 15:47:22.242481
SELECT ( `cat` . `name` COLLAT ... ) AS `NUMERIC_S... simpedak_db 12636 0 0 9.28 s 2.17 ms 733.92 us 3.99 s 218092 17 1159772 92 0 0 11740 0 204996 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:29.090878 2026-10-06 15:47:20.373886
SELECT ( `cat` . `name` COLLAT ... database` ( `sc... simpedak_db * 19458 0 0 8.11 s 1.29 ms 416.69 us 3.26 s 76878 4 470214 24 0 0 42860 0 115632 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:10:21.686877 2026-10-06 15:47:20.365027
SELECT ( `cat` . `name` COLLAT ... ction_collation... simpedak_db 27902 0 0 7.74 s 833.38 us 277.33 us 3.97 s 21520 1 148265 5 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:10:29.044349 2026-10-06 15:47:20.311856
SELECT ( `cat` . `name` COLLAT ... te_data` , COAL... simpedak_db 11454 0 0 7.67 s 4.70 ms 669.09 us 3.95 s 254968 22 1169994 102 0 0 86 0 243088 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:18.929984 2026-10-06 15:47:20.312896
SELECT ( `cat` . `name` COLLAT ... database` ( `sc... NULL * 15487 0 0 6.83 s 1.56 ms 440.80 us 2.83 s 58376 4 357407 23 0 0 34870 0 93552 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:01:08.620581 2026-10-06 15:47:22.232079
SELECT ( `cat` . `name` COLLAT ... `tbl` . `engine... information_schema * 280 0 0 6.79 s 1.03 s 24.24 ms 86.82 ms 474 2 6012 21 0 0 248 0 0 0 6b962281752cce8cb8541a21b1d4e4db06b701224fba881b1f... 2026-10-06 08:10:24.443675 2026-10-06 15:43:16.671045
SELECT ( `cat` . `name` COLLAT ... te_data` , COAL... performance_schema 8155 0 0 6.47 s 30.15 ms 793.49 us 2.71 s 414931 51 1392793 171 0 0 44 0 412039 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:12.324925 2026-10-06 15:47:34.152459
SELECT COUNT (?) AS `cnt` , `r ... y_by_digest` GR... sys * 112 0 0 6.47 s 294.17 ms 57.76 ms 13.08 ms 534 5 230618 2059 0 0 152 0 2814 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2026-10-06 09:03:06.973504 2026-10-06 15:37:52.807388
SELECT ( `cat` . `name` COLLAT ... ) AS `NUMERIC_S... sys 9590 0 0 6.41 s 2.21 ms 668.26 us 2.63 s 96212 10 495736 52 0 0 8877 0 89024 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:12:29.831238 2026-10-06 15:47:13.014952
SELECT ( `cat` . `name` COLLAT ... den` ) ) , COAL... sys * 12175 0 96 6.31 s 12.02 ms 518.37 us 3.56 s 458 0 46916 4 0 0 12218 0 10790 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:12:29.832683 2026-10-06 15:47:13.015733
SELECT COUNT ( * ) AS `c` FROM ... document_approv... simpedak_db * 193 0 0 6.13 s 63.90 ms 31.74 ms 41.57 ms 193 1 420 2 0 0 386 0 0 0 8586314de6146035fdf39233e80d7d1bade017e7566e476ac3... 2026-10-06 09:03:18.576000 2026-10-06 15:43:32.493639
SHOW SESSION VARIABLES LIKE ? NULL * 4242 0 0 6.08 s 2.49 ms 1.43 ms 316.71 ms 4242 1 2456118 579 0 0 4242 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2026-10-06 08:09:57.961405 2026-10-06 15:47:38.169753
SELECT `document_id` , `docume ... document_approv... simpedak_db * 193 0 0 6.04 s 35.18 ms 31.28 ms 30.48 ms 420 2 2506392 12986 0 0 193 0 420 0 76a75a5e759b4af598f59ae43eb8e53b98be9c5f925f1d7a33... 2026-10-06 09:03:18.606916 2026-10-06 15:43:32.525965
SELECT ( `cat` . `name` COLLAT ... ) AS `NUMERIC_S... performance_schema 8530 0 0 6.00 s 2.31 ms 703.72 us 2.58 s 110439 13 558787 66 0 0 7796 0 100865 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:28.438222 2026-10-06 15:47:34.214096
SELECT ( `cat` . `name` COLLAT ... database` ( `sc... mysql * 13813 0 26 5.62 s 6.34 ms 406.72 us 2.29 s 58012 4 328663 24 0 0 28241 0 84576 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 07:58:51.818954 2026-10-06 15:47:36.185897
SELECT ( `cat` . `name` COLLAT ... te_data` , COAL... sys 5741 0 0 5.37 s 8.49 ms 935.62 us 1.97 s 363635 63 928548 162 0 0 223 0 362850 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:12:26.213811 2026-10-06 15:46:49.008725
SELECT * FROM `INNODB_COLUMNS` LIMIT ?, ... information_schema * 10 0 0 5.12 s 597.28 ms 512.17 ms 37.33 ms 250 25 250 25 0 0 10 10 0 0 1512ccbc467635564d751a38813be9534f3a3cf75c1a1f59a8... 2026-10-06 08:58:43.005179 2026-10-06 14:50:02.838316
SELECT ( `cat` . `name` COLLAT ... database` ( `sc... sys * 12250 0 0 5.10 s 1.22 ms 416.42 us 2.04 s 48946 4 301436 25 0 0 27053 0 73800 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:12:26.420122 2026-10-06 15:47:13.003535