SELECT installation_id,
           node_id,
           gateway_id,
           relay_gateway_id,
           signal_id,
           time,
           rec_time
    FROM Stowlen.IDontKnoo_1203
    WHERE installation_id=594100
      AND time>'2014-12-13 22:20:59'
      AND node_id=34267405
      AND (gateway_id<>34267405
           OR relay_gateway_id<>34267405)
      AND signal_id<>12
      AND rec_seqno>=0
    ORDER BY time LIMIT 1

    TRACE: {
      "steps": [
        {
          "join_preparation": {
            "select#": 1,
            "steps": [
              {
                "expanded_query": "/* select#1 */ select `Stowlen`.`IDontKnoo_1203`.`installation_id` AS `installation_id`,`Stowlen`.`IDontKnoo_1203`.`node_id` AS `node_id`,`Stowlen`.`IDontKnoo_1203`.`gateway_id` AS `gateway_id`,`Stowlen`.`IDontKnoo_1203`.`relay_gateway_id` AS `relay_gateway_id`,`Stowlen`.`IDontKnoo_1203`.`signal_id` AS `signal_id`,`Stowlen`.`IDontKnoo_1203`.`time` AS `time`,`Stowlen`.`IDontKnoo_1203`.`rec_time` AS `rec_time` from `Stowlen`.`IDontKnoo_1203` where ((`Stowlen`.`IDontKnoo_1203`.`installation_id` = 594100) and (`Stowlen`.`IDontKnoo_1203`.`time` > '2014-12-13 22:20:59') and (`Stowlen`.`IDontKnoo_1203`.`node_id` = 34267405) and ((`Stowlen`.`IDontKnoo_1203`.`gateway_id` <> 34267405) or (`Stowlen`.`IDontKnoo_1203`.`relay_gateway_id` <> 34267405)) and (`Stowlen`.`IDontKnoo_1203`.`signal_id` <> 12) and (`Stowlen`.`IDontKnoo_1203`.`rec_seqno` >= 0)) order by `Stowlen`.`IDontKnoo_1203`.`time` limit 1"
              }
            ]
          }
        },
        {
          "join_optimization": {
            "select#": 1,
            "steps": [
              {
                "condition_processing": {
                  "condition": "WHERE",
                  "original_condition": "((`Stowlen`.`IDontKnoo_1203`.`installation_id` = 594100) and (`Stowlen`.`IDontKnoo_1203`.`time` > '2014-12-13 22:20:59') and (`Stowlen`.`IDontKnoo_1203`.`node_id` = 34267405) and ((`Stowlen`.`IDontKnoo_1203`.`gateway_id` <> 34267405) or (`Stowlen`.`IDontKnoo_1203`.`relay_gateway_id` <> 34267405)) and (`Stowlen`.`IDontKnoo_1203`.`signal_id` <> 12) and (`Stowlen`.`IDontKnoo_1203`.`rec_seqno` >= 0))",
                  "steps": [
                    {
                      "transformation": "equality_propagation",
                      "resulting_condition": "((`Stowlen`.`IDontKnoo_1203`.`time` > '2014-12-13 22:20:59') and ((`Stowlen`.`IDontKnoo_1203`.`gateway_id` <> 34267405) or (`Stowlen`.`IDontKnoo_1203`.`relay_gateway_id` <> 34267405)) and (`Stowlen`.`IDontKnoo_1203`.`signal_id` <> 12) and (`Stowlen`.`IDontKnoo_1203`.`rec_seqno` >= 0) and multiple equal(594100, `Stowlen`.`IDontKnoo_1203`.`installation_id`) and multiple equal(34267405, `Stowlen`.`IDontKnoo_1203`.`node_id`))"
                    },
                    {
                      "transformation": "constant_propagation",
                      "resulting_condition": "((`Stowlen`.`IDontKnoo_1203`.`time` > '2014-12-13 22:20:59') and ((`Stowlen`.`IDontKnoo_1203`.`gateway_id` <> 34267405) or (`Stowlen`.`IDontKnoo_1203`.`relay_gateway_id` <> 34267405)) and (`Stowlen`.`IDontKnoo_1203`.`signal_id` <> 12) and (`Stowlen`.`IDontKnoo_1203`.`rec_seqno` >= 0) and multiple equal(594100, `Stowlen`.`IDontKnoo_1203`.`installation_id`) and multiple equal(34267405, `Stowlen`.`IDontKnoo_1203`.`node_id`))"
                    },
                    {
                      "transformation": "trivial_condition_removal",
                      "resulting_condition": "((`Stowlen`.`IDontKnoo_1203`.`time` > '2014-12-13 22:20:59') and ((`Stowlen`.`IDontKnoo_1203`.`gateway_id` <> 34267405) or (`Stowlen`.`IDontKnoo_1203`.`relay_gateway_id` <> 34267405)) and (`Stowlen`.`IDontKnoo_1203`.`signal_id` <> 12) and (`Stowlen`.`IDontKnoo_1203`.`rec_seqno` >= 0) and multiple equal(594100, `Stowlen`.`IDontKnoo_1203`.`installation_id`) and multiple equal(34267405, `Stowlen`.`IDontKnoo_1203`.`node_id`))"
                    }
                  ]
                }
              },
              {
                "table_dependencies": [
                  {
                    "table": "`Stowlen`.`IDontKnoo_1203`",
                    "row_may_be_null": false,
                    "map_bit": 0,
                    "depends_on_map_bits": [
                    ]
                  }
                ]
              },
              {
                "ref_optimizer_key_uses": [
                  {
                    "table": "`Stowlen`.`IDontKnoo_1203`",
                    "field": "installation_id",
                    "equals": "594100",
                    "null_rejecting": false
                  },
                  {
                    "table": "`Stowlen`.`IDontKnoo_1203`",
                    "field": "installation_id",
                    "equals": "594100",
                    "null_rejecting": false
                  },
                  {
                    "table": "`Stowlen`.`IDontKnoo_1203`",
                    "field": "installation_id",
                    "equals": "594100",
                    "null_rejecting": false
                  },
                  {
                    "table": "`Stowlen`.`IDontKnoo_1203`",
                    "field": "installation_id",
                    "equals": "594100",
                    "null_rejecting": false
                  }
                ]
              },
              {
                "rows_estimation": [
                  {
                    "table": "`Stowlen`.`IDontKnoo_1203`",
                    "range_analysis": {
                      "table_scan": {
                        "rows": 140474166,
                        "cost": 2.91e7
                      },
                      "potential_range_indices": [
                        {
                          "index": "IDontKnoo_time_ix",
                          "usable": true,
                          "key_parts": [
                            "time"
                          ]
                        },
                        {
                          "index": "IDontKnoo_insid_time_ix",
                          "usable": true,
                          "key_parts": [
                            "installation_id",
                            "time"
                          ]
                        },
                        {
                          "index": "IDontKnoo_insid_sid_time_ix",
                          "usable": true,
                          "key_parts": [
                            "installation_id",
                            "signal_id",
                            "time"
                          ]
                        },
                        {
                          "index": "IDontKnoo_insid_sid_zone_time_ix",
                          "usable": true,
                          "key_parts": [
                            "installation_id",
                            "signal_id",
                            "zone",
                            "time"
                          ]
                        },
                        {
                          "index": "IDontKnoo_insid_zone_time_ix",
                          "usable": true,
                          "key_parts": [
                            "installation_id",
                            "zone",
                            "time"
                          ]
                        }
                      ],
                      "setup_range_conditions": [
                      ],
                      "group_index_range": {
                        "chosen": false,
                        "cause": "not_group_by_or_distinct"
                      },
                      "analyzing_range_alternatives": {
                        "range_scan_alternatives": [
                          {
                            "index": "IDontKnoo_time_ix",
                            "ranges": [
                              "2014-12-13 22:20:59 < time"
                            ],
                            "index_dives_for_eq_ranges": true,
                            "rowid_ordered": false,
                            "using_mrr": false,
                            "index_only": false,
                            "rows": 70237080,
                            "cost": 8.43e7,
                            "chosen": false,
                            "cause": "cost"
                          },
                          {
                            "index": "IDontKnoo_insid_time_ix",
                            "ranges": [
                              "594100 <= installation_id <= 594100 AND 2014-12-13 22:20:59 < time"
                            ],
                            "index_dives_for_eq_ranges": true,
                            "rowid_ordered": false,
                            "using_mrr": false,
                            "index_only": false,
                            "rows": 224662,
                            "cost": 269595,
                            "chosen": true
                          },
                          {
                            "index": "IDontKnoo_insid_sid_time_ix",
                            "ranges": [
                              "594100 <= installation_id <= 594100 AND signal_id < 12",
                              "594100 <= installation_id <= 594100 AND 12 < signal_id"
                            ],
                            "index_dives_for_eq_ranges": true,
                            "rowid_ordered": false,
                            "using_mrr": false,
                            "index_only": false,
                            "rows": 181707,
                            "cost": 218050,
                            "chosen": true
                          },
                          {
                            "index": "IDontKnoo_insid_sid_zone_time_ix",
                            "ranges": [
                              "594100 <= installation_id <= 594100 AND signal_id < 12",
                              "594100 <= installation_id <= 594100 AND 12 < signal_id"
                            ],
                            "index_dives_for_eq_ranges": true,
                            "rowid_ordered": false,
                            "using_mrr": false,
                            "index_only": false,
                            "rows": 192789,
                            "cost": 231349,
                            "chosen": false,
                            "cause": "cost"
                          },
                          {
                            "index": "IDontKnoo_insid_zone_time_ix",
                            "ranges": [
                              "594100 <= installation_id <= 594100"
                            ],
                            "index_dives_for_eq_ranges": true,
                            "rowid_ordered": false,
                            "using_mrr": false,
                            "index_only": false,
                            "rows": 175004,
                            "cost": 210006,
                            "chosen": true
                          }
                        ],
                        "analyzing_roworder_intersect": {
                          "usable": false,
                          "cause": "too_few_roworder_scans"
                        }
                      },
                      "chosen_range_access_summary": {
                        "range_access_plan": {
                          "type": "range_scan",
                          "index": "IDontKnoo_insid_zone_time_ix",
                          "rows": 175004,
                          "ranges": [
                            "594100 <= installation_id <= 594100"
                          ]
                        },
                        "rows_for_plan": 175004,
                        "cost_for_plan": 210006,
                        "chosen": true
                      }
                    }
                  }
                ]
              },
              {
                "considered_execution_plans": [
                  {
                    "plan_prefix": [
                    ],
                    "table": "`Stowlen`.`IDontKnoo_1203`",
                    "best_access_path": {
                      "considered_access_paths": [
                        {
                          "access_type": "ref",
                          "index": "IDontKnoo_insid_time_ix",
                          "rows": 224662,
                          "cost": 269594,
                          "chosen": true
                        },
                        {
                          "access_type": "ref",
                          "index": "IDontKnoo_insid_sid_time_ix",
                          "rows": 181707,
                          "cost": 218048,
                          "chosen": true
                        },
                        {
                          "access_type": "ref",
                          "index": "IDontKnoo_insid_sid_zone_time_ix",
                          "rows": 192789,
                          "cost": 231347,
                          "chosen": false
                        },
                        {
                          "access_type": "ref",
                          "index": "IDontKnoo_insid_zone_time_ix",
                          "rows": 175004,
                          "cost": 210005,
                          "chosen": true
                        },
                        {
                          "access_type": "range",
                          "cause": "heuristic_index_cheaper",
                          "chosen": false
                        }
                      ]
                    },
                    "cost_for_plan": 210005,
                    "rows_for_plan": 175004,
                    "chosen": true
                  }
                ]
              },
              {
                "attaching_conditions_to_tables": {
                  "original_condition": "((`Stowlen`.`IDontKnoo_1203`.`node_id` = 34267405) and (`Stowlen`.`IDontKnoo_1203`.`installation_id` = 594100) and (`Stowlen`.`IDontKnoo_1203`.`time` > '2014-12-13 22:20:59') and ((`Stowlen`.`IDontKnoo_1203`.`gateway_id` <> 34267405) or (`Stowlen`.`IDontKnoo_1203`.`relay_gateway_id` <> 34267405)) and (`Stowlen`.`IDontKnoo_1203`.`signal_id` <> 12) and (`Stowlen`.`IDontKnoo_1203`.`rec_seqno` >= 0))",
                  "attached_conditions_computation": [
                  ],
                  "attached_conditions_summary": [
                    {
                      "table": "`Stowlen`.`IDontKnoo_1203`",
                      "attached": "((`Stowlen`.`IDontKnoo_1203`.`node_id` = 34267405) and (`Stowlen`.`IDontKnoo_1203`.`time` > '2014-12-13 22:20:59') and ((`Stowlen`.`IDontKnoo_1203`.`gateway_id` <> 34267405) or (`Stowlen`.`IDontKnoo_1203`.`relay_gateway_id` <> 34267405)) and (`Stowlen`.`IDontKnoo_1203`.`signal_id` <> 12) and (`Stowlen`.`IDontKnoo_1203`.`rec_seqno` >= 0))"
                    }
                  ]
                }
              },
              {
                "clause_processing": {
                  "clause": "ORDER BY",
                  "original_clause": "`Stowlen`.`IDontKnoo_1203`.`time`",
                  "items": [
                    {
                      "item": "`Stowlen`.`IDontKnoo_1203`.`time`"
                    }
                  ],
                  "resulting_clause_is_simple": true,
                  "resulting_clause": "`Stowlen`.`IDontKnoo_1203`.`time`"
                }
              },
              {
                "refine_plan": [
                  {
                    "table": "`Stowlen`.`IDontKnoo_1203`"
                  }
                ]
              },
              {
                "added_back_ref_condition": "((`Stowlen`.`IDontKnoo_1203`.`installation_id` <=> 594100) and ((`Stowlen`.`IDontKnoo_1203`.`node_id` = 34267405) and (`Stowlen`.`IDontKnoo_1203`.`time` > '2014-12-13 22:20:59') and ((`Stowlen`.`IDontKnoo_1203`.`gateway_id` <> 34267405) or (`Stowlen`.`IDontKnoo_1203`.`relay_gateway_id` <> 34267405)) and (`Stowlen`.`IDontKnoo_1203`.`signal_id` <> 12) and (`Stowlen`.`IDontKnoo_1203`.`rec_seqno` >= 0)))"
              },
              {
                "reconsidering_access_paths_for_index_ordering": {
                  "clause": "ORDER BY",
                  "rows_estimation": {
                    "table": "`Stowlen`.`IDontKnoo_1203`",
                    "index": "IDontKnoo_time_ix",
                    "range_analysis": {
                      "table_scan": {
                        "rows": 140474166,
                        "cost": 1.69e8
                      },
                      "potential_range_indices": [
                        {
                          "index": "IDontKnoo_time_ix",
                          "usable": true,
                          "key_parts": [
                            "time"
                          ]
                        },
                        {
                          "index": "IDontKnoo_insid_time_ix",
                          "usable": false,
                          "cause": "not_applicable"
                        },
                        {
                          "index": "IDontKnoo_insid_sid_time_ix",
                          "usable": false,
                          "cause": "not_applicable"
                        },
                        {
                          "index": "IDontKnoo_insid_sid_zone_time_ix",
                          "usable": false,
                          "cause": "not_applicable"
                        },
                        {
                          "index": "IDontKnoo_insid_zone_time_ix",
                          "usable": false,
                          "cause": "not_applicable"
                        }
                      ],
                      "setup_range_conditions": [
                      ],
                      "group_index_range": {
                        "chosen": false,
                        "cause": "not_group_by_or_distinct"
                      },
                      "analyzing_range_alternatives": {
                        "range_scan_alternatives": [
                          {
                            "index": "IDontKnoo_time_ix",
                            "ranges": [
                              "2014-12-13 22:20:59 < time"
                            ],
                            "index_dives_for_eq_ranges": true,
                            "rowid_ordered": false,
                            "using_mrr": false,
                            "index_only": false,
                            "rows": 70237080,
                            "cost": 8.43e7,
                            "chosen": true
                          }
                        ],
                        "analyzing_roworder_intersect": {
                          "usable": false,
                          "cause": "too_few_roworder_scans"
                        }
                      },
                      "chosen_range_access_summary": {
                        "range_access_plan": {
                          "type": "range_scan",
                          "index": "IDontKnoo_time_ix",
                          "rows": 70237080,
                          "ranges": [
                            "2014-12-13 22:20:59 < time"
                          ]
                        },
                        "rows_for_plan": 70237080,
                        "cost_for_plan": 8.43e7,
                        "chosen": true
                      }
                    }
                  },
                  "index_order_summary": {
                    "table": "`Stowlen`.`IDontKnoo_1203`",
                    "index_provides_order": true,
                    "order_direction": "asc",
                    "index": "IDontKnoo_time_ix",
                    "plan_changed": true,
                    "access_type": "range"
                  }
                }
              }
            ]
          }
        },
        {
          "join_execution": {
            "select#": 1,
            "steps": [
            ]
          }
        }
      ]
    }