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
CREATE TABLE `Salle_Groupe_Con ... Concert` ) ON D... musique 1 0 0 332.18 ms 332.18 ms 332.18 ms 458.00 us 0 0 0 0 0 0 0 0 0 0 19ccdaa7dd8994753648c18b9c00b01af5f1abea4c3e82e5e4... 2022-12-09 13:04:23.452003 2022-12-09 13:04:23.452003
CREATE TABLE `ludotheque_perso ... noDB` DEFAULT C... ludo 1 0 4 324.09 ms 324.09 ms 324.09 ms 302.00 us 0 0 0 0 0 0 0 0 0 0 647cdf10429216a9fe8cb3f095cef961e154b87554d0153a34... 2022-12-09 13:02:24.480806 2022-12-09 13:02:24.480806
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... NULL 25 0 0 310.93 ms 56.75 ms 12.44 ms 16.61 ms 52 2 561 22 0 0 25 0 52 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-09 13:02:30.904200 2022-12-09 13:06:02.491973
CREATE TABLE `personne` ( `id_ ... noDB` DEFAULT C... ludo 1 0 3 307.14 ms 307.14 ms 307.14 ms 534.00 us 0 0 0 0 0 0 0 0 0 0 d6e3cffb3c6b0dcec3fd871994968903f77fa199d363e8428b... 2022-12-09 13:02:23.158486 2022-12-09 13:02:23.158486
CREATE TABLE `Personne_Role` ( ... id_Role` ) ON D... musique 1 0 0 304.06 ms 304.06 ms 304.06 ms 416.00 us 0 0 0 0 0 0 0 0 0 0 c27942ae890326edbd90afd89c874c804ad73eddf93da86f78... 2022-12-09 13:04:22.808122 2022-12-09 13:04:22.808122
CREATE TABLE `specialite_perso ... noDB` DEFAULT C... ludo 1 0 4 290.60 ms 290.60 ms 290.60 ms 481.00 us 0 0 0 0 0 0 0 0 0 0 6577cc395d1be73937efbfb92ae33c0e84cd6176f26670660e... 2022-12-09 13:02:24.134677 2022-12-09 13:02:24.134677
CREATE TABLE `essai` . `baza1` ... utf8` COLLATE `... essai 1 0 2 283.42 ms 283.42 ms 283.42 ms 239.00 us 0 0 0 0 0 0 0 0 0 0 2472925508b4041ec1191d4eff23784bfc703b6d56780a20e4... 2022-12-09 13:08:04.479409 2022-12-09 13:08:04.479409
CREATE TABLE `Style_Groupe` (  ... _Groupe` ) ON D... musique 1 0 0 277.02 ms 277.02 ms 277.02 ms 377.00 us 0 0 0 0 0 0 0 0 0 0 153d6acfb37c7a6f77d39d6c6b7353888555fe1da5782b847b... 2022-12-09 13:04:23.103427 2022-12-09 13:04:23.103427
CREATE TABLE `jouet_ludotheque ... noDB` DEFAULT C... ludo 1 0 4 272.00 ms 272.00 ms 272.00 ms 560.00 us 0 0 0 0 0 0 0 0 0 0 f6023cf3d3109817ab5f84a48cf6c155c0b487abf85937c680... 2022-12-09 13:02:24.770938 2022-12-09 13:02:24.770938
SHOW SESSION VARIABLES LIKE ? musique * 116 0 0 269.21 ms 4.33 ms 2.32 ms 22.28 ms 116 1 66584 574 0 0 116 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-09 13:04:21.087365 2022-12-09 13:07:21.155982
CREATE TABLE `theme` ( `id_the ... noDB` DEFAULT C... ludo 1 0 2 260.23 ms 260.23 ms 260.23 ms 400.00 us 0 0 0 0 0 0 0 0 0 0 89c6a279173b050fcf07e0e4b3678ed9c672fff6c5215fccc8... 2022-12-09 13:02:23.827494 2022-12-09 13:02:23.827494
CREATE TABLE `Personne` ( `id_ ... _Groupe` ) ON D... musique 1 0 0 253.50 ms 253.50 ms 253.50 ms 197.00 us 0 0 0 0 0 0 0 0 0 0 2f8a28dfa73890e756eccc20979d50a31d5d5e473b04a34e35... 2022-12-09 13:04:21.989077 2022-12-09 13:04:21.989077
CREATE TABLE `Salle` ( `id_Sal ... ersonne` ) ON D... musique 1 0 0 251.33 ms 251.33 ms 251.33 ms 417.00 us 0 0 0 0 0 0 0 0 0 0 20a89d594e30bdbbe7e7a04ca9c5bdadb1eaa8bcb1073392df... 2022-12-09 13:04:22.256649 2022-12-09 13:04:22.256649
CREATE TABLE `Style` ( `id_Sty ... T , `Style` VAR... musique 1 0 0 240.17 ms 240.17 ms 240.17 ms 390.00 us 0 0 0 0 0 0 0 0 0 0 2af611f9377621f9cd9f36e40c12c2f8d1a72935304ea2628d... 2022-12-09 13:04:21.539733 2022-12-09 13:04:21.539733
CREATE TABLE `ludotheque` ( `i ... noDB` DEFAULT C... ludo 1 0 3 231.74 ms 231.74 ms 231.74 ms 608.00 us 0 0 0 0 0 0 0 0 0 0 b2334048195ad5083f0f9dc367cc42d1f9e10e4fa41a33e440... 2022-12-09 13:02:22.832953 2022-12-09 13:02:22.832953
CREATE TABLE `jouet_theme` ( ` ... noDB` DEFAULT C... ludo 1 0 4 218.82 ms 218.82 ms 218.82 ms 204.00 us 0 0 0 0 0 0 0 0 0 0 845bfe0c9be681b54cf963df0107685173ca0ba98aebf5e114... 2022-12-09 13:02:24.995533 2022-12-09 13:02:24.995533
CREATE TABLE `Concert` ( `id_C ... ACTER (?) , DES... musique 1 0 0 217.46 ms 217.46 ms 217.46 ms 392.00 us 0 0 0 0 0 0 0 0 0 0 f5aded0fcf161673dfc3495936d2486c48c20c7c193bc6a853... 2022-12-09 13:04:22.488811 2022-12-09 13:04:22.488811
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... ludo * 11 0 0 205.99 ms 184.60 ms 18.73 ms 13.64 ms 91 8 490 45 0 0 3 0 91 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-09 13:02:27.430131 2022-12-09 13:04:33.688055
INSERT INTO `Personne_Role` (  ... le` ) VALUES (.... musique 5 0 0 204.07 ms 54.84 ms 40.81 ms 1.24 ms 0 0 0 0 12 2 0 0 0 0 596832186c8abe47a0e4dfa3d023db4579c1b236ec74e0a92a... 2022-12-09 13:04:24.250191 2022-12-09 13:04:24.463151
CREATE SCHEMA IF NOT EXISTS `m ... tf8` COLLATE `u... NULL 6 0 17 195.22 ms 55.09 ms 32.54 ms 73.00 us 0 0 0 0 6 1 0 0 0 0 e92c0a6eb1f0e8955898f889756bb1d9abf9373705211622b9... 2022-12-09 13:04:21.068475 2022-12-09 13:07:12.177064
CREATE TABLE ROLE ( `id_Role`  ... MENT , ROLE VAR... musique 6 5 0 190.63 ms 188.72 ms 31.77 ms 2.00 ms 0 0 0 0 0 0 0 0 0 0 883d248653b88cb6c7964ce7c372c57a43bb6a7e742578db09... 2022-12-09 13:04:21.284867 2022-12-09 13:07:16.494077
CREATE TABLE `specialite` ( `i ... noDB` DEFAULT C... ludo 1 0 2 185.12 ms 185.12 ms 185.12 ms 441.00 us 0 0 0 0 0 0 0 0 0 0 435fd7f02bb5b0baf14b5557ca5bc56ffc1a8eee8b79c55ad8... 2022-12-09 13:02:23.358845 2022-12-09 13:02:23.358845
SHOW TABLES FROM `phpmyadmin` NULL 852 852 0 181.00 ms 4.55 ms 212.44 us 75.43 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2022-12-09 13:02:11.419780 2022-12-09 13:08:05.848269
CREATE TABLE `jouet` ( `id_jou ... noDB` DEFAULT C... ludo 1 0 2 175.43 ms 175.43 ms 175.43 ms 546.00 us 0 0 0 0 0 0 0 0 0 0 08e0c609cc80231d332fe06a699dd4f4ba48fbccb84a1202cf... 2022-12-09 13:02:23.549767 2022-12-09 13:02:23.549767
CREATE TABLE `Groupe` ( `id_Gr ... `nomGroupe` VAR... musique 1 0 0 175.01 ms 175.01 ms 175.01 ms 418.00 us 0 0 0 0 0 0 0 0 0 0 1989fc5acafeee0cd9424e4c5385bb66a5486f86babbe6b590... 2022-12-09 13:04:21.729251 2022-12-09 13:04:21.729251
Query results operations