# JR mongo slow query (超過三秒以上) 2022-02-23

- PMS0110041ChangeLog： 最長194.524
``"command": {
"find": "PMS0110041ChangeLog",
"filter": {
"athena_id": 150,
"ikey": {
"$regex": ".*00019236.*"
}
},
"sort": {
"trans_dat": -1
},
"projection": {},
"limit": 1000,
"lsid": {
"id": {
"$binary": {
"base64": "LH0R00f4RQqugiY2rl8sTQ==",
"subType": "04"
}
}
},
"$db": "bacchus"
}``

- bacchus.ScanInfo: 最長92.356
``"command": {
"findAndModify": "ScanInfo",
"query": {
"gcust_cod": "HFD000000003065301",
"pic_nam": "id_f"
},
"remove": true,
"new": false,
"upsert": false,
"fields": {},
"lsid": {
"id": {
"$binary": {
"base64": "jvwfrlNaSnSYuGQ169lyyg==",
"subType": "04"
}
}
}``
- bacchus.AdminApiLog (op: remove): 最長72.962
`` "command": {
"q": {
"$or": [
{
"ins_dat": {
"$lte": "2022-01-23"
}
},
{
"time": {
"$lte": "2022-01-23"
}
}
]
},
"limit": 0
}``

- bacchus.LogsAPI (op: remove): 最長8.769
`` "command": {
"q": {
"ins_datetime": {
"$lte": "2022/01/23"
}
},
"limit": 0
},
"millis": 8769
}``