rsWarframe:SECONDARY> db.accounts.find({IP:{$gte:NumberInt(-656117760),$lte:NumberInt(-656116737)}},{IP:1}).explain() { "queryPlanner" : { "plannerVersion" : 1, "namespace" : "lotus.accounts", "indexFilterSet" : false, "parsedQuery" : { "$and" : [ { "IP" : { "$lte" : -656116737 } }, { "IP" : { "$gte" : -656117760 } } ] }, "winningPlan" : { "stage" : "PROJECTION", "transformBy" : { "IP" : 1 }, "inputStage" : { "stage" : "FETCH", "filter" : { "IP" : { "$gte" : -656117760 } }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "IP" : 1 }, "indexName" : "IP_1", "isMultiKey" : true, "multiKeyPaths" : { "IP" : [ "IP" ] }, "isUnique" : false, "isSparse" : true, "isPartial" : false, "indexVersion" : 1, "direction" : "forward", "indexBounds" : { "IP" : [ "[-inf.0, -656116737]" ] } } } }, "rejectedPlans" : [ { "stage" : "PROJECTION", "transformBy" : { "IP" : 1 }, "inputStage" : { "stage" : "FETCH", "filter" : { "IP" : { "$lte" : -656116737 } }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "IP" : 1 }, "indexName" : "IP_1", "isMultiKey" : true, "multiKeyPaths" : { "IP" : [ "IP" ] }, "isUnique" : false, "isSparse" : true, "isPartial" : false, "indexVersion" : 1, "direction" : "forward", "indexBounds" : { "IP" : [ "[-656117760, inf.0]" ] } } } } ] }, "serverInfo" : { "host" : "war-data0", "port" : 27017, "version" : "4.0.16", "gitVersion" : "2a5433168a53044cb6b4fa8083e4cfd7ba142221" }, "ok" : 1, "operationTime" : Timestamp(1588604060, 36), "$clusterTime" : { "clusterTime" : Timestamp(1588604060, 50), "signature" : { "hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="), "keyId" : NumberLong(0) } } }