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.0156 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 17302 0 0 15.61 min 2.11 s 54.12 ms 747.52 ms 0 0 0 0 34531 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:23.687832 2026-10-06 14:20:07.451454
REPLACE INTO `phpmyadmin` . `p ... ame` , `tables`... phpmyadmin 1576 0 0 1.45 min 485.57 ms 55.25 ms 62.43 ms 0 0 0 0 3143 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:24.711752 2026-10-06 14:19:51.381546
SELECT ( `cat` . `name` COLLAT ... ction_collation... sys 132655 0 0 35.06 s 1.56 ms 264.03 us 17.83 s 130719 1 790121 6 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:12:29.899908 2026-10-06 14:20:07.322638
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 * 4562 0 19 11.20 s 8.01 s 2.45 ms 1.60 s 44974 10 313195 69 0 0 380 0 41531 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:01:02.943794 2026-10-06 14:19:55.305660
SELECT ( `cat` . `name` COLLAT ... den` ) ) , COAL... NULL 6305 0 0 10.08 s 289.51 ms 1.60 ms 2.02 s 7736 1 92517 15 0 0 6305 0 7736 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:10:25.928426 2026-10-06 14:19:35.416107
SELECT IF ( ( `locate` ( ? , ` ... ` . `COMPRESSED... sys * 94 0 0 8.93 s 779.82 ms 95.02 ms 11.77 ms 578 6 1241021 13202 0 0 244 26 45245 26 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2026-10-06 08:37:21.878632 2026-10-06 14:19:21.407039
SELECT ( `cat` . `name` COLLAT ... ) AS `NUMERIC_S... simpedak_db 11896 0 0 8.75 s 2.17 ms 735.31 us 3.77 s 208006 17 1106980 93 0 0 11047 0 195385 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:29.090878 2026-10-06 14:20:03.365030
SELECT ( `cat` . `name` COLLAT ... database` ( `sc... simpedak_db * 18109 0 0 7.55 s 1.29 ms 416.69 us 3.04 s 71437 4 437412 24 0 0 39913 0 107688 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:10:21.686877 2026-10-06 14:20:03.356346
SELECT ( `cat` . `name` COLLAT ... ction_collation... simpedak_db 27286 0 0 7.54 s 833.38 us 276.22 us 3.87 s 21487 1 146318 5 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:10:29.044349 2026-10-06 14:20:03.320612
SELECT ( `cat` . `name` COLLAT ... te_data` , COAL... simpedak_db 10707 0 0 7.17 s 4.70 ms 669.64 us 3.70 s 238676 22 1090802 102 0 0 82 0 227288 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:18.929984 2026-10-06 14:20:03.321667
SELECT ( `cat` . `name` COLLAT ... database` ( `sc... NULL * 14825 0 0 6.54 s 1.56 ms 440.80 us 2.71 s 55888 4 342179 23 0 0 33380 0 89568 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:01:08.620581 2026-10-06 14:19:47.364809
SELECT ( `cat` . `name` COLLAT ... `tbl` . `engine... information_schema * 251 0 0 6.20 s 1.03 s 24.72 ms 78.42 ms 425 2 5414 22 0 0 224 0 0 0 6b962281752cce8cb8541a21b1d4e4db06b701224fba881b1f... 2026-10-06 08:10:24.443675 2026-10-06 13:59:55.590645
SELECT COUNT (?) AS `cnt` , `r ... y_by_digest` GR... sys * 104 0 0 6.19 s 294.17 ms 59.54 ms 12.59 ms 509 5 219917 2115 0 0 146 0 2680 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2026-10-06 09:03:06.973504 2026-10-06 14:07:29.710767
SELECT ( `cat` . `name` COLLAT ... te_data` , COAL... performance_schema 7505 0 0 5.99 s 30.15 ms 797.64 us 2.49 s 380825 51 1278991 170 0 0 43 0 378154 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:12.324925 2026-10-06 14:19:59.303712
SELECT ( `cat` . `name` COLLAT ... ) AS `NUMERIC_S... performance_schema 7938 0 0 5.59 s 2.31 ms 704.00 us 2.40 s 103391 13 522861 66 0 0 7255 0 94362 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:28.438222 2026-10-06 14:19:59.333335
SELECT ( `cat` . `name` COLLAT ... ) AS `NUMERIC_S... sys 8255 0 0 5.51 s 2.21 ms 667.15 us 2.27 s 82513 10 424356 51 0 0 7599 0 75901 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:12:29.831238 2026-10-06 14:20:07.326327
SHOW SESSION VARIABLES LIKE ? NULL * 3797 0 0 5.42 s 2.49 ms 1.43 ms 283.12 ms 3797 1 2198463 579 0 0 3797 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2026-10-06 08:09:57.961405 2026-10-06 14:20:09.290763
SELECT ( `cat` . `name` COLLAT ... den` ) ) , COAL... sys * 10379 0 84 5.40 s 10.33 ms 520.59 us 3.04 s 400 0 40347 4 0 0 10429 0 10542 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:12:29.832683 2026-10-06 14:20:07.327067
SELECT COUNT ( * ) AS `c` FROM ... document_approv... simpedak_db * 159 0 0 5.05 s 63.90 ms 31.75 ms 34.85 ms 159 1 374 2 0 0 318 0 0 0 8586314de6146035fdf39233e80d7d1bade017e7566e476ac3... 2026-10-06 09:03:18.576000 2026-10-06 13:27:49.363334
SELECT ( `cat` . `name` COLLAT ... database` ( `sc... mysql * 12389 0 26 5.05 s 6.34 ms 407.00 us 2.06 s 51936 4 294685 24 0 0 25374 0 75996 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 07:58:51.818954 2026-10-06 14:19:55.296338
SELECT `document_id` , `docume ... document_approv... simpedak_db * 159 0 0 4.98 s 35.18 ms 31.30 ms 25.06 ms 374 2 2063618 12979 0 0 159 0 374 0 76a75a5e759b4af598f59ae43eb8e53b98be9c5f925f1d7a33... 2026-10-06 09:03:18.606916 2026-10-06 13:27:49.394380
SELECT ( `cat` . `name` COLLAT ... te_data` , COAL... sys 5109 0 0 4.82 s 8.49 ms 942.54 us 1.75 s 328236 64 828364 162 0 0 217 0 327537 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:12:26.213811 2026-10-06 14:20:07.291869
SELECT ( `cat` . `name` COLLAT ... ) AS `NUMERIC_S... NULL 6322 0 0 4.72 s 6.05 ms 746.11 us 1.50 s 68418 11 365956 58 0 0 6321 0 68418 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:25.926742 2026-10-06 14:19:35.415417
SELECT ( `cat` . `name` COLLAT ... den` ) ) , COAL... mysql 2672 0 0 4.65 s 630.54 ms 1.74 ms 855.00 ms 5403 2 60903 23 0 0 2672 0 5403 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:13:16.692591 2026-10-06 14:19:55.280133