Drop files here

SQL upload ( 0 ) x -

Page-related settings Click 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
Options
Set default
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `statement_analysis`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
query db full_scan exec_count err_count warn_count total_latency max_latency avg_latency lock_latency rows_sent rows_sent_avg rows_examined rows_examined_avg rows_affected rows_affected_avg tmp_tables tmp_disk_tables rows_sorted sort_merge_passes digest first_seen last_seen
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... NULL 102 0 0 1.01 s 181.50 ms 9.86 ms 48.97 ms 199 2 2050 20 0 0 102 0 199 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-08-09 16:18:32.365644 2022-08-09 16:27:58.915159
CREATE TABLE IF NOT EXISTS `jo ... f8mb4` COLLATE ... essentialmode 1 0 1 498.82 ms 498.82 ms 498.82 ms 433.00 us 0 0 0 0 0 0 0 0 0 0 861f1b20f3cf45fea2e9ea7ba0d6550eb6e60cc3d7e80cc77d... 2022-08-09 16:28:09.580279 2022-08-09 16:28:09.580279
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila 83 0 0 418.15 ms 291.92 ms 5.04 ms 65.12 ms 648 8 2604 31 0 0 9 0 593 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-08-09 16:17:31.303285 2022-08-09 16:28:18.508869
CREATE TABLE IF NOT EXISTS `ad ... = ? DEFAULT CHA... essentialmode 1 0 2 380.93 ms 380.93 ms 380.93 ms 1.14 ms 0 0 0 0 0 0 0 0 0 0 23eca84bf35a75e5e615db2b787f42f977941571f641ab7efe... 2022-08-09 16:28:03.217990 2022-08-09 16:28:03.217990
CREATE TABLE IF NOT EXISTS `da ... = ? DEFAULT CHA... essentialmode 1 0 1 376.53 ms 376.53 ms 376.53 ms 508.00 us 0 0 0 0 0 0 0 0 0 0 6e3c995cfb86745b09308905ccef5728709d32625f032e08c7... 2022-08-09 16:28:07.421406 2022-08-09 16:28:07.421406
SHOW TABLES FROM `phpmyadmin` NULL 1600 1600 0 350.26 ms 856.12 us 218.91 us 149.07 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2022-08-09 16:16:41.927259 2022-08-09 16:28:24.259551
CREATE TABLE IF NOT EXISTS `ye ... COLLATE = `utf8... essentialmode 1 0 3 315.81 ms 315.81 ms 315.81 ms 503.00 us 0 0 0 0 0 0 0 0 0 0 57c924ea28f5aa91189555a11e85859ab25cbb49c4dbdcab51... 2022-08-09 16:28:18.702440 2022-08-09 16:28:18.702440
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 258 0 0 309.85 ms 5.17 ms 1.20 ms 102.35 ms 4014 16 24151 94 0 0 627 0 7734 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-08-09 16:16:42.636580 2022-08-09 16:28:23.105778
CREATE TABLE IF NOT EXISTS `tr ... COLLATE = `utf8... essentialmode 1 0 2 305.39 ms 305.39 ms 305.39 ms 440.00 us 0 0 0 0 0 0 0 0 0 0 b07874b876b08551c7a24d9cfd67b8ae25d55c2395e162f43f... 2022-08-09 16:28:13.247918 2022-08-09 16:28:13.247918
CREATE TABLE IF NOT EXISTS `ad ... = ? DEFAULT CHA... essentialmode 1 0 2 304.62 ms 304.62 ms 304.62 ms 553.00 us 0 0 0 0 0 0 0 0 0 0 c394bc011764fb2fe77cb07bceb1afdb7340eb7209d858a63c... 2022-08-09 16:28:03.971182 2022-08-09 16:28:03.971182
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... NULL * 351 0 0 302.31 ms 2.25 ms 861.28 us 89.44 ms 351 1 1053 3 0 0 2106 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-08-09 16:16:42.627643 2022-08-09 16:28:24.062576
CREATE TABLE IF NOT EXISTS `pl ... COLLATE = `utf8... essentialmode 1 0 3 300.23 ms 300.23 ms 300.23 ms 543.00 us 0 0 0 0 0 0 0 0 0 0 e8fba1b06917d001e07ebe75213111a3d3066bc1c805a5900d... 2022-08-09 16:28:12.415077 2022-08-09 16:28:12.415077
CREATE TABLE IF NOT EXISTS `tw ... f8mb4` COLLATE ... essentialmode 1 0 3 295.26 ms 295.26 ms 295.26 ms 606.00 us 0 0 0 0 0 0 0 0 0 0 d13abe1183c38d69cc610c3adfb4b5c3ecb91a48b82bac4839... 2022-08-09 16:28:13.907222 2022-08-09 16:28:13.907222
CREATE TABLE IF NOT EXISTS `tw ... COLLATE = `utf8... essentialmode 1 0 3 290.04 ms 290.04 ms 290.04 ms 551.00 us 0 0 0 0 0 0 0 0 0 0 12732524de55a5df55956fb5a50befe419ea46a61c10afd965... 2022-08-09 16:28:14.233668 2022-08-09 16:28:14.233668
CREATE TABLE IF NOT EXISTS `us ... f8mb4` COLLATE ... essentialmode 1 0 2 287.48 ms 287.48 ms 287.48 ms 498.00 us 0 0 0 0 0 0 0 0 0 0 356ba5fadb447e9b7d3a295cd4b99cc626f4c899ac52c66ce0... 2022-08-09 16:28:14.882662 2022-08-09 16:28:14.882662
CREATE TABLE IF NOT EXISTS `bo ... noDB` DEFAULT C... essentialmode 1 0 2 284.40 ms 284.40 ms 284.40 ms 476.00 us 0 0 0 0 0 0 0 0 0 0 ae5b4875679d479af031ce1a75a6d4dd9a0f3f4764271b265a... 2022-08-09 16:28:05.314168 2022-08-09 16:28:05.314168
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL 217 0 0 280.85 ms 7.25 ms 1.29 ms 177.10 ms 909 4 7709 36 0 0 2 0 741 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-08-09 16:17:31.877299 2022-08-09 16:28:23.116415
CREATE TABLE IF NOT EXISTS `ow ... COLLATE = `utf8... essentialmode 1 0 1 274.11 ms 274.11 ms 274.11 ms 586.00 us 0 0 0 0 0 0 0 0 0 0 0c5cbece13d291048e298c59aaee3752c217c1317921ff51f3... 2022-08-09 16:28:11.293130 2022-08-09 16:28:11.293130
CREATE TABLE IF NOT EXISTS `ba ... f8mb4` COLLATE ... essentialmode 1 0 1 265.39 ms 265.39 ms 265.39 ms 485.00 us 0 0 0 0 0 0 0 0 0 0 e38e54cd67a5f76f678c8e422f8b0636bae5a7f34b44159488... 2022-08-09 16:28:04.278466 2022-08-09 16:28:04.278466
CREATE TABLE IF NOT EXISTS `ch ... f8mb4` COLLATE ... essentialmode 1 0 0 261.07 ms 261.07 ms 261.07 ms 471.00 us 0 0 0 0 0 0 0 0 0 0 f460bced6c777df6849038d0fa741269be14b7916eb823666d... 2022-08-09 16:28:06.288204 2022-08-09 16:28:06.288204
INSERT INTO `datastore_data` ( ... ta` ) VALUES (.... essentialmode 1 0 0 253.90 ms 253.90 ms 253.90 ms 1.70 ms 0 0 0 0 499 499 0 0 0 0 b3c62e9fcf9312360d110f1a43852b9e2e5ce1940657cb0ff3... 2022-08-09 16:28:07.729338 2022-08-09 16:28:07.729338
CREATE TABLE IF NOT EXISTS `tw ... f8mb4` COLLATE ... essentialmode 1 0 2 247.41 ms 247.41 ms 247.41 ms 503.00 us 0 0 0 0 0 0 0 0 0 0 d1300bebd0acc062b7e9ec40bfe4ecc36a7f142cb2625941f2... 2022-08-09 16:28:13.550581 2022-08-09 16:28:13.550581
CREATE TABLE IF NOT EXISTS `we ... COLLATE = `utf8... essentialmode 1 0 2 244.86 ms 244.86 ms 244.86 ms 518.00 us 0 0 0 0 0 0 0 0 0 0 efad5f0607580c2cfe2c88fcd13216025b58ba3a4a469aca0f... 2022-08-09 16:28:17.145819 2022-08-09 16:28:17.145819
CREATE TABLE IF NOT EXISTS `ve ... COLLATE = `utf8... essentialmode 1 0 3 238.22 ms 238.22 ms 238.22 ms 526.00 us 0 0 0 0 0 0 0 0 0 0 004e79952d24421572c632e2bac51a98cba95774e8bb93e669... 2022-08-09 16:28:16.484731 2022-08-09 16:28:16.484731
CREATE TABLE IF NOT EXISTS `us ... = ? DEFAULT CHA... essentialmode 1 0 2 236.98 ms 236.98 ms 236.98 ms 160.00 us 0 0 0 0 0 0 0 0 0 0 720237c8301964895fc5f83831d559026cd80366d69c3350f1... 2022-08-09 16:28:15.187186 2022-08-09 16:28:15.187186
Query results operations