2025-08-10T12:33:09.755538129Z;ip-172-26-94-248.ec2.internal;tidb10218000100066887827;db-1901897336590700544-e0e452ea-tidb-31;slowlog # Time: 2025-08-10T12:33:08.858663923Z
# Txn_start_ts: 460017942521708654
# User@Host: go_saas_new[go_saas_new] @ 172.26.127.139 [172.26.127.139]
# Conn_ID: 1473602862
# Query_time: 1.378242983
# Parse_time: 0
# Compile_time: 0.000882639
# Rewrite_time: 0.000109259
# Optimize_time: 0.000634024
# Wait_TS: 0.000011273
# Cop_time: 1.377075856 Process_time: 0.991241946 Wait_time: 0.000068216 Request_count: 2 Process_keys: 2 Total_keys: 1764135 Get_snapshot_time: 0.000 Rocksdb_delete_skipped_count: 1065037 Rocksdb_key_skipped_count: 2829206 Rocksdb_block_cache_hit_count: 4766
# DB: dh_app_8038
# Index_names: [dh_game_bet_order:idx_message_status_platform_id_create_time_unix]
# Is_internal: false
# Digest: 4d3917ec66b931673eb01a5e9e126e64172822f53d94bd5f333ab7be3f314752
# Stats: dh_game_bet_order:460017863564199445[45167001;5227774]
# Num_cop_tasks: 2
# Cop_proc_avg: 0.495620973 Cop_proc_p90: 0.754222363 Cop_proc_max: 0.754222363 Cop_proc_addr: db-tikv-11.db-tikv-peer.tidb10218000100066887827.svc:20160
# Cop_wait_avg: 3.4108e-05 Cop_wait_p90: 3.9515e-05 Cop_wait_max: 3.9515e-05 Cop_wait_addr: db-tikv-3.db-tikv-peer.tidb10218000100066887827.svc:20160
# Mem_max: 28482
# Prepared: true
# Plan_from_cache: false
# Plan_from_binding: false
# Has_more_results: false
# KV_total: 1.613474877
# PD_total: 0.00104409
# Backoff_total: 0
# Write_sql_response_total: 0.000021465
# Result_rows: 0
# Warnings: [{"Level":"Note","Message":"[dh_game_bet_order,idx_message_status_sitecode_create_time_unix] remain after pruning paths for dh_game_bet_order given Prop{SortItems: [], TaskTp: copSingleReadTask}","IsExtra":true},{"Level":"Note","Message":"[dh_game_bet_order,idx_message_status_sitecode_create_time_unix] remain after pruning paths for dh_game_bet_order given Prop{SortItems: [], TaskTp: copMultiReadTask}","IsExtra":true},{"Level":"Note","Message":"[dh_game_bet_order,idx_message_status_sitecode_create_time_unix] remain after pruning paths for dh_game_bet_order given Prop{SortItems: [], TaskTp: rootTask}","IsExtra":true},{"Level":"Note","Message":"[dh_game_bet_order,idx_message_status_platform_id_create_time_unix,idx_message_status_sitecode_create_time_unix] remain after pruning paths for dh_game_bet_order given Prop{SortItems: [{dh_app_8038.dh_game_bet_order.platform_id asc}], TaskTp: rootTask}","IsExtra":true}]
# Succ: true
# IsExplicitTxn: false
# IsSyncStatsFailed: false
# Plan: tidb_decode_plan('tQ3wTDAJNV85CTAJMQlncm91cCBieTpkaF9hcHBfODAzOC5kaF9nYW1lX2JldF9vcmRlci5wbGF0Zm9ybV9pZCwgZnVuY3M6Zmlyc3Ryb3coojoACCktPqIsALgJMAl0aW1lOjEuMzhzLCBsb29wczoxCTkuNjIgS0IJTi9BCjEJM18yOQkwCTAJZHK9AChzaXRlX2NvZGUsIKKAAH4rADRtZXNzYWdlX3N0YXR1c34uABhjcmVhdGVfAdIQX3VuaXhW3gBULCBDb25jdXJyZW5jeTpPRkYJMTcuOBHvGDIJMzBfMjgF8FZAACgJMzU0IEJ5dGVzCSEgWDMJMV8yNihCdWlsZCkJMV8wCTAJZ3QodgMBPqoAPCwgMTc1NDgyMTk4NiksIGzeQAAQOTA2NilWtwCwLCBjb3BfdGFzazoge251bTogMiwgbWF4OiA3NTQuOW1zLCBtaW46IDIzNy44AQ4kYXZnOiA0OTYuMwEOCHA5NS4qADxheF9wcm9jX2tleXM6IDEsASA6EgAIdG90BRIYOiA5OTEuMgFFARMwd2FpdDogNjguMsK1cwWVZHJfY2FjaGVfaGl0X3JhdGlvOiAwLjAwLCBiIVQFswhfZHUFGgGgCDcuOQU6AYQgZGlzdHNxbF9jPdJIIDJ9LCBycGNfaW5mbzp7Q29wOgHwGF9ycGM6MywBhAhhbF9BJEg6MS42MXN9LFJlc29sdmVMb2NrGSoAMT4qACg5bXN9fSwgdGlrdgWTBDp7IQEBhgw6NzUwAd4hPwQyNAULLTwANQEXCHA4MBEiIUUNLSBpdGVyczoyLCAhkgRzOgG0PHNjYW5fZGV0YWlsOiB7dG8BqAFkCGVzcy1oAS9CFwAkX3NpemU6IDEyOBGzLZVMNzY0MTM1LCBnZXRfc25hcHNob3QJ+RAgMjIuNSVFsHJvY2tzZGI6IHtkZWxldGVfc2tpcHBlZF9jb3VudDogMTA2NTAzNywga2V5XzocACgyODI5MjA2LCBibCE7BCB7OccNPig0NzY2fX19CU4vQQEEHAo0CTQ3XzI0bSYQdGFibGWhEgBnMgYFLCwgaW5kZXg6aWR4XzYABABfvSAAXz5DAwAoNiwABCwgHS0ELCA+LgA0KSwgcmFuZ2U6WzgsOF0B3whlcCClhRw6dHJ1ZQkyCf7pAWLpASEKAQSJOhg3KFByb2JlkToEZXF6OgS9ZhQiODMzMCJh7wFPAQQhYQw1XzI1fmEBAGsZ7kBmYWxzZQkwCQlOL0EJTi9BCg==')
# Plan_digest: de03a8e85470a790a5612bbbd60ddc9eb7c2d7ebd27f5bd7bf25962b248c7682
# Binary_plan: tidb_decode_binary_plan('jw/wPAqKDwoLU3RyZWFtQWdnXzkSpg0KDVByb2plY3Rpb25fMjkSnwsKDkluZGV4TG9va1VwXzI4EoIJCgxTZWwRJBQ2ErkCChEFJPB5UmFuZ2VTY2FuXzI0IWdmZmZmhm5AMAI4AkACSoUBCoIBCgtkaF9hcHBfODAzOBIRZGhfZ2FtZV9iZXRfb3JkZXIaYAovaWR4X21lc3NhZ2Vfc3RhdHVzX3BsYXRmb3JtX2lkX2NyZWF0ZV90aW1lX3VuaXgSDm1lc3MZLQgSC3AZLgwSEGNyNi8ACFIccgGlNDpbOCw4XSwga2VlcCBvAXugOnRydWVqWXRpa3ZfdGFzazp7cHJvYyBtYXg6NzUwbXMsIG1pbjoyNDABCxxhdmc6IDQ5NQEMCHA4MBEiCHA5NRELIGl0ZXJzOjIsIAFMFHM6Mn1w/xEBBAF4EQoY/wEaAQEhAAEBCIB1QCEnEFJ+Z3QoPSQELmQ+IwEALj7SADwsIDE3NTQ4MjE5ODYpLCBs3kAAfDkwNjYpWhN0aW1lOjEuMzhzLCBsb29wczoxYsMCY29wKRYgIHtudW06IDIsJRoYIDc1NC45bS0dFCAyMzcuOAEOLSAINi4zAQ4IcDk1LioACGF4XyFbIF9rZXlzOiAxLAEgOhIACHRvdAUSGDogOTkxLjIBRQETwHdhaXQ6IDY4LjLCtXMsIGNvcHJfY2FjaGVfaGl0X3JhdGlvOiAwLjAwLCBidWlsZF8hfQhfZHUFGhhuOiAyNy45BToBhJhkaXN0c3FsX2NvbmN1cnJlbmN5OiAyfSwgcnBjX2luZm86e0NvcDoB8BhfcnBjOjMsAYQIYWxfLSJANjFzfSxSZXNvbHZlTG9jazoVKgAxPioAHDltc319arQC/l0CYl0CRCwgc2Nhbl9kZXRhaWw6IHt0bwGpIWYIZXNzLWlBjEIXACRfc2l6ZTogMTI4EbQtlkw3NjQxMzUsIGdldF9zbmFwc2hvdAn6ECAyMi41JUaYcm9ja3NkYjoge2RlbGV0ZV9za2lwcGVkX2NvdW50OiAxMDY1MDM3YWYAeT4cACgyODI5MjA2LCBibCE8BCB7OcgNPhQ0NzY2fX1aOAMMEtcBCi6FBDg3EmwKEVRhYmxlUm93SUSJhCQ1IfjYMq28pXZAYVsMSiIKIH6ABARSEJ0REGZhbHNlXrcDIAIhXj+ZEyPEeQVcDFIzZXF6twNEc2l0ZV9jb2RlLCAiODMzMCIpVlsAMCEa7MtBG8WeQDgBQAFSjwMIcOICnUIYIVturgm0xgkwCFKwAXY9BB2GdikAvUUALHorADaABX4uAD6/BFLjAAhiD0N9lhRPRkZw5I4uNwUkIcYqI51MkJ9AKaE8DAAA8D8hLixSmAFncm91cCBieTqq3gA0ZnVuY3M6Zmlyc3Ryb3d6xwE9GAgpLT6iZgBS5gA8cPxMeP///////////wEYAQ==')
# Resource_group: default
# Request_unit_read: 538.317486125
# Request_unit_v2: 539.317486125
use dh_app_8038;
SELECT distinct(platform_id) FROM `dh_game_bet_order` WHERE message_status in (?) AND (create_time_unix > ? and create_time_unix < ?) AND site_code = ? [arguments: (8, 1754821986, 1754829066, "8330")];