{ "queryPlanner" : { "plannerVersion" : 1, "namespace" : "WWWBRON_SF2_T2_S86_mongo.cat_claim", "indexFilterSet" : false, "parsedQuery" : { "$and" : [ { "$or" : [ { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-26T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 7 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-26T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 8 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-26T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 9 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-26T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 10 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-26T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 11 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-26T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 12 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-26T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 13 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-26T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 14 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-26T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 15 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-28T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 7 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-28T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 8 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-28T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 9 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-28T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 10 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-28T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 11 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-28T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 12 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-28T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 13 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-28T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 14 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-28T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 15 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-29T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 7 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-29T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 8 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-29T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 9 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-29T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 10 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-29T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 11 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-29T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 12 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-29T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 13 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-29T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 14 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-29T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 15 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-30T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 7 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-30T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 8 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-30T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 9 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-30T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 10 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-30T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 11 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-30T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 12 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-30T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 13 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-30T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 14 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2019-12-30T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 15 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-04T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 7 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-04T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 8 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-04T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 9 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-04T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 10 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-04T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 11 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-04T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 12 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-04T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 13 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-04T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 14 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-04T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 15 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-05T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 7 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-05T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 8 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-05T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 9 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-05T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 10 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-05T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 11 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-05T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 12 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-05T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 13 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-05T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 14 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-05T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 15 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-07T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 7 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-07T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 8 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-07T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 9 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-07T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 10 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-07T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 11 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-07T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 12 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-07T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 13 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-07T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 14 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-07T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 15 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-09T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 7 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-09T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 8 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-09T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 9 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-09T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 10 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-09T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 11 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-09T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 12 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-09T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 13 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-09T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 14 } } ] }, { "$and" : [ { "checkin" : { "$eq" : ISODate("2020-01-09T03:00:00.000+03:00") } }, { "nights" : { "$eq" : 15 } } ] } ] }, { "packet_type" : { "$eq" : 0 } }, { "adult" : { "$gte" : 2 } }, { "people_count" : { "$in" : [ 2, 3 ] } }, { "for_delete" : { "$not" : { "$exists" : true } } }, { "hstop" : { "$not" : { "$exists" : true } } } ] }, "queryHash" : "F7FDBFC3", "planCacheKey" : "2EA30AE7", "winningPlan" : { "stage" : "SORT", "sortPattern" : { "idx_price" : 1 }, "limitAmount" : 600, "inputStage" : { "stage" : "SORT_KEY_GENERATOR", "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "packet_type" : { "$eq" : 0 } }, { "adult" : { "$gte" : 2 } }, { "for_delete" : { "$not" : { "$exists" : true } } }, { "hstop" : { "$not" : { "$exists" : true } } } ] }, "inputStage" : { "stage" : "OR", "inputStages" : [ { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577318400000), new Date(1577318400000)]" ], "nights" : [ "[7.0, 7.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577318400000), new Date(1577318400000)]" ], "nights" : [ "[8.0, 8.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577318400000), new Date(1577318400000)]" ], "nights" : [ "[9.0, 9.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577318400000), new Date(1577318400000)]" ], "nights" : [ "[10.0, 10.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577318400000), new Date(1577318400000)]" ], "nights" : [ "[11.0, 11.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577318400000), new Date(1577318400000)]" ], "nights" : [ "[12.0, 12.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577318400000), new Date(1577318400000)]" ], "nights" : [ "[13.0, 13.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577318400000), new Date(1577318400000)]" ], "nights" : [ "[14.0, 14.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577318400000), new Date(1577318400000)]" ], "nights" : [ "[15.0, 15.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577491200000), new Date(1577491200000)]" ], "nights" : [ "[7.0, 7.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577491200000), new Date(1577491200000)]" ], "nights" : [ "[8.0, 8.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577491200000), new Date(1577491200000)]" ], "nights" : [ "[9.0, 9.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577491200000), new Date(1577491200000)]" ], "nights" : [ "[10.0, 10.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577491200000), new Date(1577491200000)]" ], "nights" : [ "[11.0, 11.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577491200000), new Date(1577491200000)]" ], "nights" : [ "[12.0, 12.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577491200000), new Date(1577491200000)]" ], "nights" : [ "[13.0, 13.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577491200000), new Date(1577491200000)]" ], "nights" : [ "[14.0, 14.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577491200000), new Date(1577491200000)]" ], "nights" : [ "[15.0, 15.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577577600000), new Date(1577577600000)]" ], "nights" : [ "[7.0, 7.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577577600000), new Date(1577577600000)]" ], "nights" : [ "[8.0, 8.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577577600000), new Date(1577577600000)]" ], "nights" : [ "[9.0, 9.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577577600000), new Date(1577577600000)]" ], "nights" : [ "[10.0, 10.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577577600000), new Date(1577577600000)]" ], "nights" : [ "[11.0, 11.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577577600000), new Date(1577577600000)]" ], "nights" : [ "[12.0, 12.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577577600000), new Date(1577577600000)]" ], "nights" : [ "[13.0, 13.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577577600000), new Date(1577577600000)]" ], "nights" : [ "[14.0, 14.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577577600000), new Date(1577577600000)]" ], "nights" : [ "[15.0, 15.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577664000000), new Date(1577664000000)]" ], "nights" : [ "[7.0, 7.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577664000000), new Date(1577664000000)]" ], "nights" : [ "[8.0, 8.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577664000000), new Date(1577664000000)]" ], "nights" : [ "[9.0, 9.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577664000000), new Date(1577664000000)]" ], "nights" : [ "[10.0, 10.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577664000000), new Date(1577664000000)]" ], "nights" : [ "[11.0, 11.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577664000000), new Date(1577664000000)]" ], "nights" : [ "[12.0, 12.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577664000000), new Date(1577664000000)]" ], "nights" : [ "[13.0, 13.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577664000000), new Date(1577664000000)]" ], "nights" : [ "[14.0, 14.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1577664000000), new Date(1577664000000)]" ], "nights" : [ "[15.0, 15.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578096000000), new Date(1578096000000)]" ], "nights" : [ "[7.0, 7.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578096000000), new Date(1578096000000)]" ], "nights" : [ "[8.0, 8.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578096000000), new Date(1578096000000)]" ], "nights" : [ "[9.0, 9.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578096000000), new Date(1578096000000)]" ], "nights" : [ "[10.0, 10.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578096000000), new Date(1578096000000)]" ], "nights" : [ "[11.0, 11.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578096000000), new Date(1578096000000)]" ], "nights" : [ "[12.0, 12.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578096000000), new Date(1578096000000)]" ], "nights" : [ "[13.0, 13.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578096000000), new Date(1578096000000)]" ], "nights" : [ "[14.0, 14.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578096000000), new Date(1578096000000)]" ], "nights" : [ "[15.0, 15.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578182400000), new Date(1578182400000)]" ], "nights" : [ "[7.0, 7.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578182400000), new Date(1578182400000)]" ], "nights" : [ "[8.0, 8.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578182400000), new Date(1578182400000)]" ], "nights" : [ "[9.0, 9.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578182400000), new Date(1578182400000)]" ], "nights" : [ "[10.0, 10.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578182400000), new Date(1578182400000)]" ], "nights" : [ "[11.0, 11.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578182400000), new Date(1578182400000)]" ], "nights" : [ "[12.0, 12.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578182400000), new Date(1578182400000)]" ], "nights" : [ "[13.0, 13.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578182400000), new Date(1578182400000)]" ], "nights" : [ "[14.0, 14.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578182400000), new Date(1578182400000)]" ], "nights" : [ "[15.0, 15.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578355200000), new Date(1578355200000)]" ], "nights" : [ "[7.0, 7.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578355200000), new Date(1578355200000)]" ], "nights" : [ "[8.0, 8.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578355200000), new Date(1578355200000)]" ], "nights" : [ "[9.0, 9.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578355200000), new Date(1578355200000)]" ], "nights" : [ "[10.0, 10.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578355200000), new Date(1578355200000)]" ], "nights" : [ "[11.0, 11.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578355200000), new Date(1578355200000)]" ], "nights" : [ "[12.0, 12.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578355200000), new Date(1578355200000)]" ], "nights" : [ "[13.0, 13.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578355200000), new Date(1578355200000)]" ], "nights" : [ "[14.0, 14.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578355200000), new Date(1578355200000)]" ], "nights" : [ "[15.0, 15.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578528000000), new Date(1578528000000)]" ], "nights" : [ "[7.0, 7.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578528000000), new Date(1578528000000)]" ], "nights" : [ "[8.0, 8.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578528000000), new Date(1578528000000)]" ], "nights" : [ "[9.0, 9.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578528000000), new Date(1578528000000)]" ], "nights" : [ "[10.0, 10.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578528000000), new Date(1578528000000)]" ], "nights" : [ "[11.0, 11.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578528000000), new Date(1578528000000)]" ], "nights" : [ "[12.0, 12.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578528000000), new Date(1578528000000)]" ], "nights" : [ "[13.0, 13.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578528000000), new Date(1578528000000)]" ], "nights" : [ "[14.0, 14.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } }, { "stage" : "IXSCAN", "keyPattern" : { "checkin" : 1, "nights" : 1, "people_count" : 1, "idx_price" : 1 }, "indexName" : "IX_checkin", "isMultiKey" : false, "multiKeyPaths" : { "checkin" : [ ], "nights" : [ ], "people_count" : [ ], "idx_price" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "checkin" : [ "[new Date(1578528000000), new Date(1578528000000)]" ], "nights" : [ "[15.0, 15.0]" ], "people_count" : [ "[2.0, 2.0]", "[3.0, 3.0]" ], "idx_price" : [ "[MinKey, MaxKey]" ] } } ] } } } }, "rejectedPlans" : [ ] }, "serverInfo" : { "host" : "mongodb01", "port" : 27017, "version" : "4.2.1", "gitVersion" : "edf6d45851c0b9ee15548f0f847df141764a317e" }, "ok" : 1 }