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 368 0 0 1.70 s 139.21 ms 4.62 ms 214.47 ms 710 2 7407 20 0 0 368 0 710 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-09-28 23:32:05.695204 2022-09-28 23:39:54.703607
ALTER TABLE `employee` ADD PRIMARY KEY ( `employee... cpt310 1 0 0 795.31 ms 795.31 ms 795.31 ms 1.07 ms 0 0 0 0 0 0 0 0 0 0 bd7633d2e53259305365666e9b38cf5bb0bb6a8090c5157dd9... 2022-09-28 23:34:08.956748 2022-09-28 23:34:08.956748
CREATE TABLE `department` ( `d ...  `DeptName` VAR... sakila 5 1 0 731.67 ms 234.97 ms 146.33 ms 1.36 ms 0 0 0 0 0 0 0 0 0 0 04c536f499ceefc3317f9c0f2b898b36a8c40571bd991f18ec... 2022-09-28 23:32:17.716520 2022-09-28 23:35:28.734402
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql 16 0 0 647.84 ms 608.43 ms 40.49 ms 16.66 ms 496 31 3060 191 0 0 3 0 495 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-09-28 23:32:02.452432 2022-09-28 23:36:12.143337
CREATE TABLE `autor` ( `codigo ... ERENCES `libro`... biblioteca 1 0 0 543.24 ms 543.24 ms 543.24 ms 457.00 us 0 0 0 0 0 0 0 0 0 0 08d32717e3428eab9338e55150a5fd700227c26a9eab1f1d29... 2022-09-28 23:36:24.961326 2022-09-28 23:36:24.961326
ALTER TABLE `Usuarios` ADD FOR ... LETE CASCADE ON... roles 1 0 0 521.08 ms 521.08 ms 521.08 ms 67.00 us 0 0 0 0 0 0 0 0 0 0 c50137b6d85db663449ce5b51c37221fc71f66dbd60454d422... 2022-09-28 23:38:41.913546 2022-09-28 23:38:41.913546
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila 96 0 0 493.62 ms 249.89 ms 5.14 ms 73.69 ms 538 6 2290 24 0 0 6 0 467 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-09-28 23:31:51.024436 2022-09-28 23:40:12.676636
DROP TABLE IF EXISTS `department` sakila 4 0 0 475.97 ms 136.60 ms 118.99 ms 468.00 us 0 0 0 0 0 0 0 0 0 0 5df4420400415984b013b03ac92f87856bb6555af70794bb86... 2022-09-28 23:32:49.698562 2022-09-28 23:35:28.493219
ALTER TABLE `tbl_employee_audi ... ER (?) NOT NULL... cpt310 1 0 1 450.95 ms 450.95 ms 450.95 ms 275.00 us 0 0 0 0 0 0 0 0 0 0 30065c3516eb2c67d84dd4853c39e737a1efb13668d11bb230... 2022-09-28 23:34:09.754258 2022-09-28 23:34:09.754258
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... NULL 366 0 0 398.44 ms 5.06 ms 1.09 ms 214.61 ms 1912 5 11242 31 0 0 344 0 1890 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-09-28 23:32:05.694341 2022-09-28 23:39:54.700478
SHOW TABLES FROM `phpmyadmin` NULL 1540 1540 0 363.34 ms 4.57 ms 235.94 us 157.42 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2022-09-28 23:31:50.640372 2022-09-28 23:40:18.847344
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL 282 0 0 334.84 ms 2.80 ms 1.19 ms 208.21 ms 1399 5 10250 36 0 0 0 0 1197 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-09-28 23:31:51.498285 2022-09-28 23:39:54.707738
ALTER TABLE `tbl_employee_audit` ADD PRIMARY KEY (... cpt310 1 0 0 327.19 ms 327.19 ms 327.19 ms 129.00 us 0 0 0 0 0 0 0 0 0 0 ff632aa39e764384e5fa0d6c4049516e51a166c98a58def534... 2022-09-28 23:34:09.288338 2022-09-28 23:34:09.288338
CREATE TABLE `usuario_ejemplar ... ENCES `usuario`... biblioteca 1 0 0 312.81 ms 312.81 ms 312.81 ms 418.00 us 0 0 0 0 0 0 0 0 0 0 96c34ceb903d066ef7d82768fcfce7224a0bef0fd9ea841e48... 2022-09-28 23:36:25.458611 2022-09-28 23:36:25.458611
SHOW SESSION VARIABLES LIKE ? sakila * 213 0 0 281.89 ms 6.30 ms 1.32 ms 22.53 ms 213 1 122262 574 0 0 213 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-09-28 23:31:51.103124 2022-09-28 23:40:12.696704
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... sakila 242 0 0 269.27 ms 3.58 ms 1.11 ms 143.72 ms 1238 5 7006 29 0 0 193 0 1041 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-09-28 23:31:51.036263 2022-09-28 23:40:12.697691
CREATE TABLE `employee_departm ... ES `department`... sakila 1 0 0 250.84 ms 250.84 ms 250.84 ms 462.00 us 0 0 0 0 0 0 0 0 0 0 0f19338ac6ca529bda3f023ce4d51f97315b0f50859b83c1e1... 2022-09-28 23:35:29.050805 2022-09-28 23:35:29.050805
CREATE TABLE `editorial` ( `id ... ERENCES `libro`... biblioteca 1 0 0 241.56 ms 241.56 ms 241.56 ms 406.00 us 0 0 0 0 0 0 0 0 0 0 87f21127266cc39e830e9c4265359378d7b882a21d147fbe42... 2022-09-28 23:36:24.401171 2022-09-28 23:36:24.401171
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 70 0 0 241.40 ms 66.61 ms 3.45 ms 46.28 ms 138 2 1605 23 0 0 70 0 138 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-09-28 23:31:51.079550 2022-09-28 23:40:12.679321
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 172 0 0 234.73 ms 4.78 ms 1.36 ms 74.36 ms 2632 15 15709 91 0 0 421 0 5074 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-09-28 23:31:51.495604 2022-09-28 23:40:11.345624
CREATE TABLE `roles` . `Cargos ... Y ( `ID` ) ) EN... roles 1 0 0 233.54 ms 233.54 ms 233.54 ms 351.00 us 0 0 0 0 0 0 0 0 0 0 21357f825fd568c22e7f2b54c9105ecd3bd8c5a4034305da9e... 2022-09-28 23:35:25.700035 2022-09-28 23:35:25.700035
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... NULL * 260 0 0 226.72 ms 2.23 ms 871.99 us 66.92 ms 260 1 780 3 0 0 1560 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-09-28 23:31:51.480832 2022-09-28 23:40:11.357779
CREATE TABLE `libro` ( `codigo ... o` VARCHARACTER... biblioteca 2 1 0 223.19 ms 222.71 ms 111.60 ms 561.00 us 0 0 0 0 0 0 0 0 0 0 02a9076f70a5a581386cbb441b3bf92f926b8c0c55d791af78... 2022-09-28 23:36:23.903065 2022-09-28 23:37:10.521904
CREATE TABLE `ejemplar` ( `idE ... ERENCES `libro`... biblioteca 1 0 0 221.83 ms 221.83 ms 221.83 ms 404.00 us 0 0 0 0 0 0 0 0 0 0 79d1cd63e5e2f9a6987f646f36f1a65b8d5fb4dd47461f9bf3... 2022-09-28 23:36:24.141744 2022-09-28 23:36:24.141744
CREATE TABLE `department` ( `d ...  `DeptName` VAR... sakila 1 0 0 217.69 ms 217.69 ms 217.69 ms 505.00 us 0 0 0 0 0 0 0 0 0 0 901dc39b320436cf4673abb92e5d49c4f1eefee2498137a233... 2022-09-28 23:32:08.353347 2022-09-28 23:32:08.353347
Query results operations