demo.phpmyadmin.net / phpMyAdmin demo - MySQL / sys / x$statement_analysis

Customize appearance of the navigation panel.

แผงนำทาง

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
เชื่อมกับแผงหลัก Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
ตารางที่ใช้ล่าสุด Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

เซิร์ฟเวอร์

Display servers selection Display server choice at the top of the navigation panel.
แสดงเซิร์ฟเวอร์เป็นรายการ Show server listing as a list instead of a drop down.

ตัวเลือกการแสดงฐานข้อมูล

ฐานข้อมูล

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

ตาราง

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

วางไฟล์ที่นี่

SQL upload ( 0 ) x -

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace ใช้เวลา:

Always expand query messages

Show query history at start

Show current browsing query

Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.

Switch to dark theme

Collapse Expand Requery แก้ไข Explain การทำแฟ้มประวัติ Query failed ฐานข้อมูล: Queried time:

โหมดเรียกดู

ปรับแต่งโหมดเรียกดู

โหมดเรียกดู

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
ไฮไลท์ตัวชี้ ไฮไลท์แถวที่ถูกชี้โดยเคอร์เซอร์
เครื่องหมายแถว ไฮไลท์แถวที่เลือก
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

กำลังแสดงแถวที่ 0 - ...

(Query took 0.0041 seconds.)

SELECT * FROM `x$statement_analysis`

Filter rows:

Partial texts

Full texts

แสดงเนื้อหาไบนารี

แสดงเนื้อหา BLOB

Hide browser transformation

ข้อความที่รู้จักกันดี

ไบนารีที่รู้จักกันดี

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 `TABLE_CATALOG` , `sch` ....	sys		2859	0	0	814063314000	1706935000	284737000	439879000000	2815	1	17022	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-06-26 15:16:01.482072	2024-06-26 15:19:38.384511
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	4	0	0	632007968000	478680668000	158001992000	1108000000	4	1	18949	4737	0	0	24	4	2444	4	bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...	2024-06-26 15:16:42.547769	2024-06-26 15:17:36.924809
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	682	0	0	492523589000	5888360000	722175000	181160000000	6443	9	42578	62	0	0	1556	0	11906	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-26 15:16:01.132312	2024-06-26 15:19:44.082317
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	21	0	0	485360832000	465509737000	23112420000	7641000000	182	9	896	43	0	0	0	0	0	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-26 15:16:02.903999	2024-06-26 15:18:42.629070
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	431	0	0	449270536000	3784125000	1042391000	51177000000	638	1	17940	42	0	0	422	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-06-26 15:16:01.973914	2024-06-26 15:19:43.779949
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	733	0	19	417373392000	3013622000	569404000	152013000000	7927	11	47228	64	0	0	1606	0	13067	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-26 15:16:02.086793	2024-06-26 15:19:43.449100
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	678	0	0	360494925000	1872469000	531703000	132479000000	5854	9	39518	58	0	0	1526	0	10692	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-26 15:16:02.022305	2024-06-26 15:19:43.668439
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		333	0	0	353807696000	3536883000	1062485000	121606000000	19086	57	96429	290	0	0	333	0	19086	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-26 15:16:01.916637	2024-06-26 15:19:43.546971
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sys	*	28	0	0	297355528000	257511481000	10619840000	12263000000	73	3	7759	277	0	0	21	0	73	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-26 15:16:03.705167	2024-06-26 15:19:33.410482
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	328	0	0	274809960000	1632565000	837835000	29894000000	328	1	188272	574	0	0	328	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-06-26 15:16:01.898876	2024-06-26 15:19:43.657070
SHOW SESSION VARIABLES LIKE ?	mysql	*	225	0	0	262234840000	48279590000	1165488000	21908000000	225	1	129150	574	0	0	225	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-06-26 15:16:01.893093	2024-06-26 15:19:43.200966
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	3	0	0	256116775000	233043232000	85372258000	457000000	5	2	5	2	0	0	9	2	972	2	c552f840b97cf2c164de85ef343eae0b410364ed59846f9192...	2024-06-26 15:17:30.087292	2024-06-26 15:17:30.204005
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		230	0	0	249930513000	4661437000	1086654000	98457000000	9859	43	51759	225	0	0	196	0	9783	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-26 15:16:01.896295	2024-06-26 15:19:43.153986
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila	*	8	0	0	247242005000	241370346000	30905250000	3766000000	74	9	592	74	0	0	6	0	74	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-26 15:16:02.732298	2024-06-26 15:19:24.081728
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		5	0	0	235954807000	69389448000	47190961000	1554000000	17	3	178	36	0	0	5	0	17	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-26 15:16:46.173631	2024-06-26 15:19:24.131084
SHOW TABLES FROM `phpmyadmin`	NULL		941	941	0	229154576000	7980609000	243522000	90187000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-06-26 15:16:01.076936	2024-06-26 15:19:44.507229
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		84	0	0	199523934000	61388576000	2375284000	30279000000	172	2	5411	64	0	0	84	0	172	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-26 15:16:01.926036	2024-06-26 15:19:43.141486
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	vedettfak		44	0	0	199167871000	149582416000	4526542000	17662000000	59	1	737	17	0	0	44	0	59	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-26 15:16:01.924662	2024-06-26 15:19:42.543522
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	Internship	*	322	0	0	177348718000	1752835000	550772000	67506000000	2751	9	17738	55	0	0	711	0	5016	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-26 15:16:48.500926	2024-06-26 15:19:44.145653
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sys	*	217	0	0	174688121000	5723646000	805014000	88998000000	4	0	712	3	0	0	248	0	1284	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-26 15:16:03.463248	2024-06-26 15:19:38.340175
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	170	0	0	174135384000	3228767000	1024325000	78127000000	170	1	23536	138	0	0	170	0	170	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-26 15:16:01.909059	2024-06-26 15:19:43.534261
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan...	sys	*	8	0	0	167165218000	53188494000	20895652000	3657000000	30	4	9685	1211	0	0	28	0	79	0	92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc...	2024-06-26 15:17:08.692705	2024-06-26 15:19:05.580923
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	db_finlps	*	298	0	0	165412413000	1505101000	555075000	62858000000	2576	9	17211	58	0	0	657	0	4702	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-26 15:17:20.086835	2024-06-26 15:19:40.224106
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	432	0	0	165378499000	2061593000	382820000	73320000000	1902	4	11814	27	0	0	395	0	2942	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-26 15:16:01.361831	2024-06-26 15:19:43.805389
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	5	0	0	140289987000	49703485000	28057997000	1130000000	6	1	104	21	0	0	16	0	358	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-06-26 15:16:21.305389	2024-06-26 15:19:07.827095

Filter rows:

การดำเนินงานผลแบบสอบถาม

Copy to clipboard

ส่งออก

Display chart

สร้างมุมมอง

เซิร์ฟเวอร์ phpMyAdmin ทดลองใช้งาน: Git information missing!