反馈人：李冠
java的mongodb中，t_onbuy_publish_platform_param 集合查询超慢SQL（40多秒）
解决方案：在命中索引的情况下，还要带上分片键
执行的命令如下：
{
"username": "rwuser",
"ns": "zhcxkj_comprehensive_shopee.t_onbuy_publish_platform_param",
"op": "query",
"millis": 44306,
"docsExamined": 275870,
"keysExamined": 0,
"nreturned": 0,
"ndeleted": 0,
"ninserted": 0,
"nMatched": 0,
"nModified": 0,
"ts": {
"date": 1760335355576
},
"clientIp": "10.17.62.250",
"locks": {
"Global": {
"acquireCount": {
"r": 2288
},
"timeWaitingTicketMicros": {
"r": 27091
}
},
"Database": {
"acquireCount": {
"r": 2288
}
},
"Collection": {
"acquireCount": {
"r": 2288
}
}
},
"command": "{ find: "t_onbuy_publish_platform_param", filter: { queue_detail_id: { in: [ 1317856, 1317857 ] } }, projection: { sortKey: { meta: "sortKey" } }, sort: { queue_detail_id: -1 }, shardVersion: [ Timestamp(25, 0), ObjectId(68b6a5d599f786f046a5e624) ], lsid: { id: UUID("ed552ad2-3674-4722-aaef-6dbe29994d40"), uid: BinData(0, 109178812F0C2E953B72EBAB4C7B30ADD8C5E612275C84C7DFBF7A9DE713ECF5) }, clusterTime: { clusterTime: Timestamp(1760335310, 13719), signature: { hash: BinData(0, E28BA2C85CEC9AD295AD0550422FD5059649DC07), keyId: 7527127265109344260 } }, client: { driver: { name: "mongo-java-driver|sync", version: "4.6.1" }, os: { type: "Linux", name: "Linux", architecture: "amd64", version: "4.18.0-147.5.1.6.h1152.eulerosv2r9.x86_64" }, platform: "Java/Oracle Corporation/17.0.2+8-86", mongos: { host: "host-192-168-61-103:8635", client: "10.17.62.250:50010", version: "4.0.3" }, username: "rwuser" }, configServerState: { opTime: { ts: Timestamp(1760335310, 13535), t: 6 } }, db: "zhcxkj_comprehensive_shopee" }",
"original_log": "2025-10-13T06:02:35.576+0000 I COMMAND [conn5366166] command zhcxkj_comprehensive_shopee.t_onbuy_publish_platform_param clientIp: 10.17.62.250 username: rwuser command: find { find: "t_onbuy_publish_platform_param", filter: { queue_detail_id: { in: [ 1317856, 1317857 ] } }, projection: { sortKey: { meta: "sortKey" } }, sort: { queue_detail_id: -1 }, shardVersion: [ Timestamp(25, 0), ObjectId(68b6a5d599f786f046a5e624) ], lsid: { id: UUID("ed552ad2-3674-4722-aaef-6dbe29994d40"), uid: BinData(0, 109178812F0C2E953B72EBAB4C7B30ADD8C5E612275C84C7DFBF7A9DE713ECF5) }, clusterTime: { clusterTime: Timestamp(1760335310, 13719), signature: { hash: BinData(0, E28BA2C85CEC9AD295AD0550422FD5059649DC07), keyId: 7527127265109344260 } }, client: { driver: { name: "mongo-java-driver|sync", version: "4.6.1" }, os: { type: "Linux", name: "Linux", architecture: "amd64", version: "4.18.0-147.5.1.6.h1152.eulerosv2r9.x86_64" }, platform: "Java/Oracle Corporation/17.0.2+8-86", mongos: { host: "host-192-168-61-103:8635", client: "10.17.62.250:50010", version: "4.0.3" }, username: "rwuser" }, configServerState: { opTime: { ts: Timestamp(1760335310, 13535), t: 6 } }, db: "zhcxkj_comprehensive_shopee" } planSummary: COLLSCAN keysExamined:0 docsExamined:275870 hasSortStage:1 cursorExhausted:1 numYields:2287 nreturned:0 reslen:422 locks:{ Global: { acquireCount: { r: 2288 }, timeWaitingTicketMicros: { r: 27091 } }, Database: { acquireCount: { r: 2288 } }, Collection: { acquireCount: { r: 2288 } } } protocol:op_msg 44306ms"
}
