將檔案拖放至此處

SQL 上載 ( 0 ) x -

頁面相關設定 點選此列以回到頁面頂端
請按 Ctrl+Enter 執行查詢 請按 Enter 執行查詢
遞增
遞減
排序:
SQL 偵錯
次數
執行排序
使用時間
排序依:
群組查詢
解除群組查詢
摺疊 展開 顯示追蹤 隱藏追蹤 次數 : 使用時間 :
書籤
重新整理
新增
無書籤
新增書籤
選項
設為預設值





摺疊 展開 重新查詢 編輯 語句分析 效能分析 書籤 查詢失敗 資料庫 : 查詢時間 :
瀏覽模式
自訂瀏覽模式。
瀏覽模式
說明文件 僅使用圖示或文字,又或兩者都使用。 還原預設值
說明文件 僅使用圖示或文字,又或兩者都使用。 還原預設值
說明文件 是否顯示「顯示全部資料列」的按鈕。 還原預設值
說明文件 瀏覽查詢結果時,一次最多顯示的列數。如果結果超過此列數,則會顯示「上一頁」和「下一頁」的連結。 還原預設值
說明文件 SMART - 即是對 TIME、DATE、DATETIME 和 TIMESTAMP 類型的欄位遞減排序,其他欄位遞增。 還原預設值
說明文件 凸顯滑鼠指標所指的資料列。 還原預設值
說明文件 凸顯所選的資料列。 還原預設值
說明文件 還原預設值
說明文件 還原預設值
說明文件 每 X 儲存格重複標題;若要關閉此功能,請設為 0 還原預設值
說明文件 瀏覽非數字欄位時,所顯示的最大字元數。 還原預設值
說明文件 連結包含了編輯、複製和刪除。 還原預設值
說明文件 是否顯示缺少獨一鍵的資料列連結。 還原預設值
說明文件 預設使用主鍵來排列資料表。 還原預設值
說明文件 瀏覽資料表時,會使用上次的資料表排序。 還原預設值
說明文件 顯示用選項 還原預設值
SELECT * FROM `events_statements_current`
行內編輯 ] [ 編輯 ] [ SQL 語句分析 ] [ 建立 PHP 程式碼 ] [ 重新整理 ]
THREAD_ID
Thread associated with the event. Together with EV…
EVENT_ID
Thread's current event number at the start of the …
END_EVENT_ID
NULL when the event starts, set to the thread's cu…
EVENT_NAME
Event instrument name and a NAME from the setup_in…
SOURCE
Name and line number of the source file containing…
TIMER_START
Value in picoseconds when the event timing started…
TIMER_END
Value in picoseconds when the event timing ended, …
TIMER_WAIT
Value in picoseconds of the event's duration or NU…
LOCK_TIME
Time in picoseconds spent waiting for locks. The t…
SQL_TEXT
The SQL statement, or NULL if the command is not a…
DIGEST
Statement digest.
DIGEST_TEXT
Statement digest text.
CURRENT_SCHEMA
Statement's default database for the statement, or…
OBJECT_TYPE
Reserved, currently NULL
OBJECT_SCHEMA
Reserved, currently NULL
OBJECT_NAME
Reserved, currently NULL
OBJECT_INSTANCE_BEGIN
Address in memory of the statement object.
MYSQL_ERRNO
Error code. See MariaDB Error Codes for a full lis…
RETURNED_SQLSTATE
The SQLSTATE value.
MESSAGE_TEXT
Statement error message. See MariaDB Error Codes.
ERRORS
0 if SQLSTATE signifies completion (starting with …
WARNINGS
Number of warnings from the diagnostics area.
ROWS_AFFECTED
Number of rows affected the statement affected.
ROWS_SENT
Number of rows returned.
ROWS_EXAMINED
Number of rows read during the statement's executi…
CREATED_TMP_DISK_TABLES
Number of on-disk temp tables created by the state…
CREATED_TMP_TABLES
Number of temp tables created by the statement.
SELECT_FULL_JOIN
Number of joins performed by the statement which d…
SELECT_FULL_RANGE_JOIN
Number of joins performed by the statement which u…
SELECT_RANGE
Number of joins performed by the statement which u…
SELECT_RANGE_CHECK
Number of joins without keys performed by the stat…
SELECT_SCAN
Number of joins performed by the statement which u…
SORT_MERGE_PASSES
Number of merge passes by the sort algorithm perfo…
SORT_RANGE
Number of sorts performed by the statement which u…
SORT_ROWS
Number of rows sorted by the statement.
SORT_SCAN
Number of sorts performed by the statement which u…
NO_INDEX_USED
0 if the statement performed a table scan with an …
NO_GOOD_INDEX_USED
0 if a good index was found for the statement, 1 i…
NESTING_EVENT_ID
Reserved, currently NULL.
NESTING_EVENT_TYPE
Reserved, currently NULL.
查詢結果選項 新增檢視表 新增檢視表
將此 SQL 查詢加為書籤 將此 SQL 查詢加為書籤