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 278 0 0 942.21 ms 104.09 ms 3.39 ms 125.64 ms 543 2 5704 21 0 0 278 0 543 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-09-27 09:02:36.821730 2022-09-27 09:12:41.536984
ALTER TABLE `membership_userre ... DD KEY `groupID... busbooking 1 0 0 802.08 ms 802.08 ms 802.08 ms 306.00 us 0 0 0 0 0 0 0 0 0 0 5756eebb5c2a3cdb78489025d9ceb640baeed9ec95534bfaf3... 2022-09-27 09:09:13.506651 2022-09-27 09:09:13.506651
ALTER TABLE `membership_userre ... INCREMENT , AUT... busbooking 1 0 1 752.16 ms 752.16 ms 752.16 ms 342.00 us 0 0 0 0 27 27 0 0 0 0 7caca78c99ee5d75116e343e8ac4ab5d7817deeeb7cad324de... 2022-09-27 09:09:19.210368 2022-09-27 09:09:19.210368
ALTER TABLE `kierunek` ADD PRIMARY KEY ( `id_kieru... baza7 1 0 0 736.31 ms 736.31 ms 736.31 ms 102.44 ms 0 0 0 0 0 0 0 0 0 0 78cf16a0074511734f09385d6d1cd6257c9d8601c54c34be34... 2022-09-27 09:02:32.440154 2022-09-27 09:02:32.440154
ALTER TABLE `availability` ADD ...  , ADD KEY `rou... busbooking 1 0 0 681.00 ms 681.00 ms 681.00 ms 24.79 ms 0 0 0 0 0 0 0 0 0 0 5c2c0d3eb8d776d024e3d1db9fe15349c301c040c4f72f4c04... 2022-09-27 09:09:09.782338 2022-09-27 09:09:09.782338
ALTER TABLE `bookings` ADD PRI ...  ) , ADD KEY `s... busbooking 1 0 0 654.06 ms 654.06 ms 654.06 ms 271.00 us 0 0 0 0 0 0 0 0 0 0 8d5df942dc1b40074104146ac65bc4fd0053f2aeb79b4858ec... 2022-09-27 09:09:10.437477 2022-09-27 09:09:10.437477
ALTER TABLE `membership_users` ... DD KEY `groupID... busbooking 1 0 0 591.28 ms 591.28 ms 591.28 ms 380.00 us 0 0 0 0 0 0 0 0 0 0 d4c0d44e44a2146123298b403f86f3fbf5caf1202311890745... 2022-09-27 09:09:14.098997 2022-09-27 09:09:14.098997
ALTER TABLE `student` ADD PRIMARY KEY ( `id_studen... baza7 1 0 0 551.31 ms 551.31 ms 551.31 ms 105.00 us 0 0 0 0 0 0 0 0 0 0 80e169efb9b018bd56bc91dba643a97b9e93f858e360d31f90... 2022-09-27 09:02:32.997875 2022-09-27 09:02:32.997875
ALTER TABLE `bookings` MODIFY  ... INCREMENT , AUT... busbooking 1 0 1 550.51 ms 550.51 ms 550.51 ms 352.00 us 0 0 0 0 7 7 0 0 0 0 72b5091c683dd906a8ae6c012803a7e67facfd4c4a93bbe664... 2022-09-27 09:09:16.156512 2022-09-27 09:09:16.156512
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila 156 0 0 531.53 ms 205.35 ms 3.41 ms 131.91 ms 1482 10 6096 39 0 0 19 0 1403 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-09-27 09:02:16.326725 2022-09-27 09:12:41.494524
ALTER TABLE `wydzial` ADD PRIMARY KEY ( `id_wydzia... baza7 1 0 0 524.76 ms 524.76 ms 524.76 ms 245.00 us 0 0 0 0 0 0 0 0 0 0 13409d6830c043172f090828f1c22bf982eeabe24cd77a3b16... 2022-09-27 09:02:33.538066 2022-09-27 09:02:33.538066
ALTER TABLE `routes` ADD PRIMARY KEY ( `id` ) busbooking 1 0 0 505.29 ms 505.29 ms 505.29 ms 344.00 us 0 0 0 0 0 0 0 0 0 0 efc6ff67175cbdd5ccd47f3f4e89e3b52e71e597945d9cddba... 2022-09-27 09:09:14.605454 2022-09-27 09:09:14.605454
ALTER TABLE `buses` MODIFY `id ... INCREMENT , AUT... busbooking 1 0 1 504.35 ms 504.35 ms 504.35 ms 183.00 us 0 0 0 0 2 2 0 0 0 0 5199acd10dc4c71ccdf9dbbdf30c6d6048b3239a4ff396987b... 2022-09-27 09:09:16.661462 2022-09-27 09:09:16.661462
ALTER TABLE `seats` ADD PRIMARY KEY ( `id` ) busbooking 1 0 0 503.92 ms 503.92 ms 503.92 ms 358.00 us 0 0 0 0 0 0 0 0 0 0 6fcf0887a21115a828077d819991b8d3a7ec0c0e57cda2a36a... 2022-09-27 09:09:15.110263 2022-09-27 09:09:15.110263
ALTER TABLE `seats` MODIFY `id ... INCREMENT , AUT... busbooking 1 0 1 501.46 ms 501.46 ms 501.46 ms 352.00 us 0 0 0 0 10 10 0 0 0 0 020d56e875096eaf645cdd28dc3091130bf1e6dec6b683f254... 2022-09-27 09:09:20.069224 2022-09-27 09:09:20.069224
ALTER TABLE `membership_groups` ADD PRIMARY KEY ( ... busbooking 1 0 0 501.00 ms 501.00 ms 501.00 ms 332.00 us 0 0 0 0 0 0 0 0 0 0 33af91c2bd84bb3a5f524f9efc9af6790f64acddcb18399005... 2022-09-27 09:09:12.405062 2022-09-27 09:09:12.405062
ALTER TABLE `customers` ADD PRIMARY KEY ( `id` ) busbooking 1 0 0 500.14 ms 500.14 ms 500.14 ms 379.00 us 0 0 0 0 0 0 0 0 0 0 c2cb226a7ced73848c2dcb7af07964748671ae4fdac8c73b91... 2022-09-27 09:09:11.412019 2022-09-27 09:09:11.412019
ALTER TABLE `availability` MOD ... INCREMENT , AUT... busbooking 1 0 1 494.11 ms 494.11 ms 494.11 ms 175.00 us 0 0 0 0 3 3 0 0 0 0 64df92bc156cb117aeac21418de3277c9070b78511ff4c17ee... 2022-09-27 09:09:15.604827 2022-09-27 09:09:15.604827
ALTER TABLE `membership_groupp ... PRIMARY KEY ( `... busbooking 1 0 0 490.68 ms 490.68 ms 490.68 ms 114.00 us 0 0 0 0 0 0 0 0 0 0 90ce6f0c7c590f7b25db9157e60fd1a55918416d3719dab0e0... 2022-09-27 09:09:11.902973 2022-09-27 09:09:11.902973
CREATE TABLE `customers` ( `id ... noDB` DEFAULT C... busbooking 1 0 2 487.14 ms 487.14 ms 487.14 ms 34.23 ms 0 0 0 0 0 0 0 0 0 0 fb8a009c7204d13b6ecb6afe35b669d13a0621812914c1aac3... 2022-09-27 09:09:07.341928 2022-09-27 09:09:07.341928
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL 335 0 0 487.03 ms 62.48 ms 1.45 ms 244.07 ms 2037 6 15609 47 0 0 2 0 1786 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-09-27 09:02:06.876536 2022-09-27 09:12:41.538145
ALTER TABLE `membership_groups ... INCREMENT , AUT... busbooking 1 0 1 479.08 ms 479.08 ms 479.08 ms 352.00 us 0 0 0 0 3 3 0 0 0 0 4e68b8b5220bdd4d4c15663f27ec3f41cdf93697b814174b26... 2022-09-27 09:09:18.040857 2022-09-27 09:09:18.040857
ALTER TABLE `kierunek` MODIFY  ... INCREMENT , AUT... baza7 1 0 1 473.86 ms 473.86 ms 473.86 ms 5.68 ms 0 0 0 0 9 9 0 0 0 0 d52fac9e2472d34f95a7e1f794909f9208e9604a1f7612efc5... 2022-09-27 09:02:34.021321 2022-09-27 09:02:34.021321
ALTER TABLE `buses` ADD PRIMARY KEY ( `id` ) busbooking 1 0 0 472.35 ms 472.35 ms 472.35 ms 360.00 us 0 0 0 0 0 0 0 0 0 0 a7855be2d0dccdf7da5589631ba7b088dfdbcaac22c3513a86... 2022-09-27 09:09:10.910910 2022-09-27 09:09:10.910910
ALTER TABLE `customers` MODIFY ... INCREMENT , AUT... busbooking 1 0 1 468.98 ms 468.98 ms 468.98 ms 375.00 us 0 0 0 0 3 3 0 0 0 0 a6211ef64a1710961498a600d9b855a2804a1c02b99a6a9855... 2022-09-27 09:09:17.131393 2022-09-27 09:09:17.131393
Query results operations