將檔案拖放至此處

SQL 上載 ( 0 ) x -

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





摺疊 展開 重新查詢 編輯 語句分析 效能分析 書籤 查詢失敗 資料庫 : 查詢時間 :
未命名 *
v 顯示／隱藏資料表清單 全螢幕檢視 從其他資料庫加入資料表 新頁面 開啟頁面 儲存頁面 另存頁面為 刪除頁面 建立資料表 建立關聯 請選擇要顯示的欄位 重新載入 說明 直角連結 / 直線連結 對齊格線 v 全部摺疊／展開 摺疊／展開 切換關聯線 匯出綱要 > 移動選單 > 標記文字
v v
資料表數： 0
v wordpress wp_actionscheduler_actions
* action_id : bigint(20) unsigned
* hook : varchar(191)
* status : varchar(20)
* scheduled_date_gmt : datetime
* scheduled_date_local : datetime
* args : varchar(191)
* schedule : longtext
* group_id : bigint(20) unsigned
* attempts : int(11)
* last_attempt_gmt : datetime
* last_attempt_local : datetime
* claim_id : bigint(20) unsigned
* extended_args : varchar(8000)
* priority : tinyint(3) unsigned
v wordpress wp_actionscheduler_claims
* claim_id : bigint(20) unsigned
* date_created_gmt : datetime
v wordpress wp_actionscheduler_groups
* group_id : bigint(20) unsigned
* slug : varchar(255)
v wordpress wp_actionscheduler_logs
* log_id : bigint(20) unsigned
* action_id : bigint(20) unsigned
* message : text
* log_date_gmt : datetime
* log_date_local : datetime
v wordpress wp_adfoin_integration
* id : bigint(20) unsigned
* title : text
* form_provider : varchar(255)
* form_id : varchar(255)
* form_name : varchar(255)
* action_provider : varchar(255)
* task : varchar(255)
* data : longtext
* extra_data : longtext
* status : int(1)
* time : timestamp
v wordpress wp_adfoin_log
* id : bigint(20) unsigned
* response_code : int(3)
* response_message : varchar(255)
* integration_id : bigint(20)
* request_data : longtext
* response_data : longtext
* time : timestamp
v wordpress wp_aiowps_audit_log
* id : bigint(20)
* network_id : bigint(20)
* site_id : bigint(20)
* username : varchar(60)
* ip : varchar(45)
* level : varchar(25)
* event_type : varchar(25)
* details : text
* stacktrace : text
* created : int(10) unsigned
v wordpress wp_aiowps_debug_log
* id : bigint(20)
* created : datetime
* logtime : int(10) unsigned
* level : varchar(25)
* network_id : bigint(20)
* site_id : bigint(20)
* message : text
* type : varchar(25)
v wordpress wp_aiowps_events
* id : bigint(20)
* event_type : varchar(150)
* username : varchar(150)
* user_id : bigint(20)
* event_date : datetime
* created : int(10) unsigned
* ip_or_host : varchar(100)
* referer_info : varchar(255)
* url : varchar(255)
* country_code : varchar(50)
* event_data : longtext
v wordpress wp_aiowps_global_meta
* meta_id : bigint(20)
* date_time : datetime
* created : int(10) unsigned
* meta_key1 : varchar(255)
* meta_key2 : varchar(255)
* meta_key3 : varchar(255)
* meta_key4 : varchar(255)
* meta_key5 : varchar(255)
* meta_value1 : varchar(255)
* meta_value2 : text
* meta_value3 : text
* meta_value4 : longtext
* meta_value5 : longtext
v wordpress wp_aiowps_logged_in_users
* id : bigint(20)
* user_id : bigint(20)
* username : varchar(60)
* ip_address : varchar(45)
* site_id : bigint(20)
* created : int(10) unsigned
* expires : int(10) unsigned
v wordpress wp_aiowps_login_lockdown
* id : bigint(20)
* user_id : bigint(20)
* user_login : varchar(150)
* lockdown_date : datetime
* created : int(10) unsigned
* release_date : datetime
* released : int(10) unsigned
* failed_login_ip : varchar(100)
* lock_reason : varchar(128)
* unlock_key : varchar(128)
* is_lockout_email_sent : tinyint(1)
* backtrace_log : text
* ip_lookup_result : longtext
v wordpress wp_aiowps_message_store
* id : bigint(20)
* message_key : text
* message_value : text
* created : int(10) unsigned
v wordpress wp_aiowps_permanent_block
* id : bigint(20)
* blocked_ip : varchar(100)
* block_reason : varchar(128)
* country_origin : varchar(50)
* blocked_date : datetime
* created : int(10) unsigned
* unblock : tinyint(1)
v wordpress wp_bv_activities_store
* id : bigint(20)
* site_id : int(11)
* user_id : int(11)
* username : text
* request_id : text
* ip : varchar(50)
* event_type : varchar(60)
* event_data : mediumtext
* time : int(11)
v wordpress wp_bv_fw_requests
* id : bigint(20)
* ip : varchar(50)
* status : int(1)
* time : bigint(20)
* path : varchar(100)
* host : varchar(100)
* method : varchar(100)
* resp_code : int(6)
* category : int(1)
* referer : varchar(200)
* user_agent : varchar(200)
* filenames : text
* query_string : text
* rules_info : text
* request_id : varchar(200)
* matched_rules : text
v wordpress wp_bv_ip_store
* id : bigint(20)
* start_ip_range : varbinary(16)
* end_ip_range : varbinary(16)
* is_fw : tinyint(1)
* is_lp : tinyint(1)
* type : int(1)
* is_v6 : tinyint(1)
v wordpress wp_bv_lp_requests
* id : bigint(20)
* ip : varchar(50)
* status : int(1)
* username : varchar(50)
* message : varchar(100)
* category : int(1)
* time : bigint(20)
* request_id : varchar(200)
v wordpress wp_commentmeta
* meta_id : bigint(20) unsigned
* comment_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v wordpress wp_comments
* comment_ID : bigint(20) unsigned
* comment_post_ID : bigint(20) unsigned
* comment_author : tinytext
* comment_author_email : varchar(100)
* comment_author_url : varchar(200)
* comment_author_IP : varchar(100)
* comment_date : datetime
* comment_date_gmt : datetime
* comment_content : text
* comment_karma : int(11)
* comment_approved : varchar(20)
* comment_agent : varchar(255)
* comment_type : varchar(20)
* comment_parent : bigint(20) unsigned
* user_id : bigint(20) unsigned
v wordpress wp_evf_entries
* entry_id : bigint(20) unsigned
* form_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* user_device : varchar(100)
* user_ip_address : varchar(100)
* referer : text
* fields : longtext
* status : varchar(20)
* viewed : tinyint(1)
* starred : tinyint(1)
* date_created : datetime
v wordpress wp_evf_entrymeta
* meta_id : bigint(20) unsigned
* entry_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v wordpress wp_evf_sessions
* session_id : bigint(20) unsigned
* session_key : char(32)
* session_value : longtext
* session_expiry : bigint(20) unsigned
v wordpress wp_e_events
* id : bigint(20) unsigned
* event_data : text
* created_at : datetime
v wordpress wp_e_submissions
* id : bigint(20) unsigned
* type : varchar(60)
* hash_id : varchar(60)
* main_meta_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* referer : varchar(500)
* referer_title : varchar(300)
* element_id : varchar(20)
* form_name : varchar(60)
* campaign_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* user_ip : varchar(46)
* user_agent : text
* actions_count : int(11)
* actions_succeeded_count : int(11)
* status : varchar(20)
* is_read : tinyint(1)
* meta : text
* created_at_gmt : datetime
* updated_at_gmt : datetime
* created_at : datetime
* updated_at : datetime
v wordpress wp_e_submissions_actions_log
* id : bigint(20) unsigned
* submission_id : bigint(20) unsigned
* action_name : varchar(60)
* action_label : varchar(60)
* status : varchar(20)
* log : text
* created_at_gmt : datetime
* updated_at_gmt : datetime
* created_at : datetime
* updated_at : datetime
v wordpress wp_e_submissions_values
* id : bigint(20) unsigned
* submission_id : bigint(20) unsigned
* key : varchar(60)
* value : longtext
v wordpress wp_jetpack_waf_blocklog
* log_id : bigint(20) unsigned
* timestamp : datetime
* rule_id : bigint(20)
* reason : longtext
v wordpress wp_litespeed_img_optming
* id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* optm_status : tinyint(4)
* src : varchar(1000)
* server_info : text
v wordpress wp_options
* option_id : bigint(20) unsigned
* option_name : varchar(191)
* option_value : longtext
* autoload : varchar(20)
v wordpress wp_postmeta
* meta_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v wordpress wp_posts
* ID : bigint(20) unsigned
* post_author : bigint(20) unsigned
* post_date : datetime
* post_date_gmt : datetime
* post_content : longtext
* post_title : text
* post_excerpt : text
* post_status : varchar(20)
* comment_status : varchar(20)
* ping_status : varchar(20)
* post_password : varchar(255)
* post_name : varchar(200)
* to_ping : text
* pinged : text
* post_modified : datetime
* post_modified_gmt : datetime
* post_content_filtered : longtext
* post_parent : bigint(20) unsigned
* guid : varchar(255)
* menu_order : int(11)
* post_type : varchar(20)
* post_mime_type : varchar(100)
* comment_count : bigint(20)
v wordpress wp_rednaopdfwpform_custom_field
* id : int(11)
* name : varchar(200)
* code : mediumtext
* form_id : int(11)
v wordpress wp_rednaopdfwpform_form_config
* id : int(11)
* original_id : bigint(20)
* name : varchar(200)
* fields : mediumtext
* notifications : mediumtext
v wordpress wp_rednaopdfwpform_records
* id : int(11)
* original_id : bigint(20)
* form_id : int(11)
* date : datetime
* user_id : int(11)
* entry : mediumtext
* seq_num : varchar(20)
* raw : mediumtext
v wordpress wp_rednaopdfwpform_templates
* id : int(11)
* pages : mediumtext
* styles : mediumtext
* document_settings : mediumtext
* form_id : int(11)
* name : varchar(200)
v wordpress wp_rnpagebuilder_entry_meta
* id : int(11)
* entry_id : bigint(20)
* name : varchar(200)
* value : mediumtext
v wordpress wp_rnpagebuilder_form_config
* id : int(11)
* original_id : bigint(20)
* name : varchar(200)
* fields : mediumtext
* notifications : mediumtext
v wordpress wp_rnpagebuilder_page
* id : int(11)
* areas : mediumtext
* filter : mediumtext
* general_settings : mediumtext
* sort : mediumtext
* formid : varchar(10)
* formulas : mediumtext
* type : varchar(50)
* name : varchar(200)
v wordpress wp_rnpagebuilder_records
* entry_id : bigint(20)
* form_id : bigint(20)
* starred : tinyint(4)
* fields : mediumtext
* date : datetime
* user_id : bigint(20)
v wordpress wp_rnpagebuilder_records_detail
* entry_detail_id : int(11)
* entry_id : int(11)
* form_id : bigint(20)
* uniq_id : int(11)
* type : varchar(30)
* sub_type : varchar(300)
* original_type : varchar(300)
* field_id : varchar(50)
* value : mediumtext
* exvalue1 : mediumtext
* exvalue2 : mediumtext
* exvalue3 : mediumtext
* exvalue4 : mediumtext
* exvalue5 : mediumtext
* exvalue6 : mediumtext
* path_id : varchar(100)
* numericvalue : double
* numericvalue2 : double
* datevalue : datetime
* datevalue2 : datetime
v wordpress wp_rnpagebuilder_template
* id : int(11)
* name : varchar(1000)
* kind : varchar(20)
* type : varchar(20)
* options : mediumtext
v wordpress wp_rnpdfimporter_form_config
* id : int(11)
* original_id : bigint(20)
* name : varchar(200)
* fields : mediumtext
* notifications : mediumtext
v wordpress wp_rnpdfimporter_pdf_import
* id : int(11)
* field_settings : mediumtext
* date_format : varchar(100)
* name : varchar(200)
* form_used : int(11)
* pdf_file_path : varchar(3000)
* pdf_name : varchar(3000)
* pdf_file_name : mediumtext
* attach_to_email : mediumtext
* skip_condition : mediumtext
v wordpress wp_rnpdfimporter_records
* id : int(11)
* original_id : bigint(20)
* form_id : int(11)
* date : datetime
* user_id : int(11)
* entry : mediumtext
* seq_num : varchar(20)
* raw : mediumtext
v wordpress wp_tablesome_event_log
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* type : varchar(25)
* table_id : bigint(20) unsigned
* trigger_id : int(11) unsigned
* action_id : int(11) unsigned
* status : tinyint(3) unsigned
* content : text
* user_ip : varbinary(16)
* user_agent : text
* created_at : datetime
v wordpress wp_tablesome_records
* record_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* content : longtext
* author_id : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
* rank_order : varchar(255)
v wordpress wp_tablesome_table_0
* id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* author_id : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
* rank_order : varchar(255)
v wordpress wp_tablesome_table_82
* id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* column_1 : text
* column_2 : text
* column_3 : text
* column_4 : text
* column_5 : text
* column_6 : text
* column_7 : text
* author_id : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
* rank_order : varchar(255)
* column_1_meta : text
* column_7_meta : text
v wordpress wp_tablesome_table_94
* id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* column_1 : text
* column_2 : text
* column_3 : text
* column_4 : text
* author_id : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
* rank_order : varchar(255)
v wordpress wp_tablesome_table_96
* id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* author_id : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
* rank_order : varchar(255)
* column_4 : text
* column_5 : text
* column_6 : text
* column_7 : text
* column_6_meta : text
* column_8 : text
v wordpress wp_tablesome_table_117
* id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* author_id : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
* rank_order : varchar(255)
* column_2 : text
* column_3 : text
* column_4 : text
* column_5 : text
* column_4_meta : text
* column_6 : text
v wordpress wp_termmeta
* meta_id : bigint(20) unsigned
* term_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v wordpress wp_terms
* term_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
* term_group : bigint(10)
v wordpress wp_term_relationships
* object_id : bigint(20) unsigned
* term_taxonomy_id : bigint(20) unsigned
* term_order : int(11)
v wordpress wp_term_taxonomy
* term_taxonomy_id : bigint(20) unsigned
* term_id : bigint(20) unsigned
* taxonomy : varchar(32)
* description : longtext
* parent : bigint(20) unsigned
* count : bigint(20)
v wordpress wp_usermeta
* umeta_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v wordpress wp_users
* ID : bigint(20) unsigned
* user_login : varchar(60)
* user_pass : varchar(255)
* user_nicename : varchar(50)
* user_email : varchar(100)
* user_url : varchar(100)
* user_registered : datetime
* user_activation_key : varchar(255)
* user_status : int(11)
* display_name : varchar(250)
v wordpress wp_wfblockediplog
* IP : binary(16)
* countryCode : varchar(2)
* blockCount : int(10) unsigned
* unixday : int(10) unsigned
* blockType : varchar(50)
v wordpress wp_wfblocks7
* id : bigint(20) unsigned
* type : int(10) unsigned
* IP : binary(16)
* blockedTime : bigint(20)
* reason : varchar(255)
* lastAttempt : int(10) unsigned
* blockedHits : int(10) unsigned
* expiration : bigint(20) unsigned
* parameters : text
v wordpress wp_wfconfig
* name : varchar(100)
* val : longblob
* autoload : enum('no','yes')
v wordpress wp_wfcrawlers
* IP : binary(16)
* patternSig : binary(16)
* status : char(8)
* lastUpdate : int(10) unsigned
* PTR : varchar(255)
v wordpress wp_wffilechanges
* filenameHash : char(64)
* file : varchar(1000)
* md5 : char(32)
v wordpress wp_wffilemods
* filenameMD5 : binary(16)
* filename : varchar(1000)
* real_path : text
* knownFile : tinyint(3) unsigned
* oldMD5 : binary(16)
* newMD5 : binary(16)
* SHAC : binary(32)
* stoppedOnSignature : varchar(255)
* stoppedOnPosition : int(10) unsigned
* isSafeFile : varchar(1)
v wordpress wp_wfhits
* id : int(10) unsigned
* attackLogTime : double(17,6) unsigned
* ctime : double(17,6) unsigned
* IP : binary(16)
* jsRun : tinyint(4)
* statusCode : int(11)
* isGoogle : tinyint(4)
* userID : int(10) unsigned
* newVisit : tinyint(3) unsigned
* URL : text
* referer : text
* UA : text
* action : varchar(64)
* actionDescription : text
* actionData : text
v wordpress wp_wfhoover
* id : int(10) unsigned
* owner : text
* host : text
* path : text
* hostKey : varbinary(124)
v wordpress wp_wfissues
* id : int(10) unsigned
* time : int(10) unsigned
* lastUpdated : int(10) unsigned
* status : varchar(10)
* type : varchar(20)
* severity : tinyint(3) unsigned
* ignoreP : char(32)
* ignoreC : char(32)
* shortMsg : varchar(255)
* longMsg : text
* data : text
v wordpress wp_wfknownfilelist
* id : int(11) unsigned
* path : text
* wordpress_path : text
v wordpress wp_wflivetraffichuman
* IP : binary(16)
* identifier : binary(32)
* expiration : int(10) unsigned
v wordpress wp_wflocs
* IP : binary(16)
* ctime : int(10) unsigned
* failed : tinyint(3) unsigned
* city : varchar(255)
* region : varchar(255)
* countryName : varchar(255)
* countryCode : char(2)
* lat : float(10,7)
* lon : float(10,7)
v wordpress wp_wflogins
* id : int(10) unsigned
* hitID : int(11)
* ctime : double(17,6) unsigned
* fail : tinyint(3) unsigned
* action : varchar(40)
* username : varchar(255)
* userID : int(10) unsigned
* IP : binary(16)
* UA : text
v wordpress wp_wfls_2fa_secrets
* id : int(11) unsigned
* user_id : bigint(20) unsigned
* secret : tinyblob
* recovery : blob
* ctime : int(10) unsigned
* vtime : int(10) unsigned
* mode : enum('authenticator')
v wordpress wp_wfls_role_counts
* serialized_roles : varbinary(255)
* two_factor_inactive : tinyint(1)
* user_count : bigint(20) unsigned
v wordpress wp_wfls_settings
* name : varchar(191)
* value : longblob
* autoload : enum('no','yes')
v wordpress wp_wfnotifications
* id : varchar(32)
* new : tinyint(3) unsigned
* category : varchar(255)
* priority : int(11)
* ctime : int(10) unsigned
* html : text
v wordpress wp_wfpendingissues
* id : int(10) unsigned
* time : int(10) unsigned
* lastUpdated : int(10) unsigned
* status : varchar(10)
* type : varchar(20)
* severity : tinyint(3) unsigned
* ignoreP : char(32)
* ignoreC : char(32)
* shortMsg : varchar(255)
* longMsg : text
* data : text
v wordpress wp_wfreversecache
* IP : binary(16)
* host : varchar(255)
* lastUpdate : int(10) unsigned
v wordpress wp_wfsecurityevents
* id : bigint(20) unsigned
* type : varchar(255)
* data : text
* event_time : double(14,4)
* state : enum('new','sending','sent')
* state_timestamp : timestamp
v wordpress wp_wfsnipcache
* id : int(10) unsigned
* IP : varchar(45)
* expiration : timestamp
* body : varchar(255)
* count : int(10) unsigned
* type : int(10) unsigned
v wordpress wp_wfstatus
* id : bigint(20) unsigned
* ctime : double(17,6) unsigned
* level : tinyint(3) unsigned
* type : char(5)
* msg : varchar(1000)
v wordpress wp_wftrafficrates
* eMin : int(10) unsigned
* IP : binary(16)
* hitType : enum('hit','404')
* hits : int(10) unsigned
v wordpress wp_wfwaffailures
* id : int(10) unsigned
* throwable : text
* rule_id : int(10) unsigned
* timestamp : timestamp
v wordpress wp_wpforms_entries
* entry_id : bigint(20)
* form_id : bigint(20)
* post_id : bigint(20)
* user_id : bigint(20)
* status : varchar(30)
* type : varchar(30)
* viewed : tinyint(1)
* starred : tinyint(1)
* fields : longtext
* meta : longtext
* date : datetime
* date_modified : datetime
* ip_address : varchar(128)
* user_agent : varchar(256)
* user_uuid : varchar(36)
v wordpress wp_wpforms_entry_fields
* id : bigint(20)
* entry_id : bigint(20)
* form_id : bigint(20)
* field_id : int(11)
* value : longtext
* date : datetime
v wordpress wp_wpforms_entry_meta
* id : bigint(20)
* entry_id : bigint(20)
* form_id : bigint(20)
* user_id : bigint(20)
* status : varchar(30)
* type : varchar(255)
* data : longtext
* date : datetime
v wordpress wp_wpforms_logs
* id : bigint(20)
* title : varchar(255)
* message : longtext
* types : varchar(255)
* create_at : datetime
* form_id : bigint(20)
* entry_id : bigint(20)
* user_id : bigint(20)
v wordpress wp_wpforms_payments
* id : bigint(20)
* form_id : bigint(20)
* status : varchar(10)
* subtotal_amount : decimal(26,8)
* discount_amount : decimal(26,8)
* total_amount : decimal(26,8)
* currency : varchar(3)
* entry_id : bigint(20)
* gateway : varchar(20)
* type : varchar(12)
* mode : varchar(4)
* transaction_id : varchar(40)
* customer_id : varchar(40)
* subscription_id : varchar(40)
* subscription_status : varchar(10)
* title : varchar(255)
* date_created_gmt : datetime
* date_updated_gmt : datetime
* is_published : tinyint(1)
v wordpress wp_wpforms_payment_meta
* id : bigint(20)
* payment_id : bigint(20)
* meta_key : varchar(255)
* meta_value : longtext
v wordpress wp_wpforms_tasks_meta
* id : bigint(20)
* action : varchar(255)
* data : longtext
* date : datetime
v wordpress wp_wpstg_queue
* id : bigint(20) unsigned
* action : varchar(1000)
* jobId : varchar(1000)
* status : char(20)
* priority : bigint(20)
* args : longtext
* custom : longtext
* claimed_at : datetime
* updated_at : datetime
建立關聯
FOREIGN KEY
on delete
on update
刪除關聯