{
  "ref_optimizer_key_uses": [
    {
      "table": "ttt",
      "field": "id2",
      "equals": "'8'",
      "null_rejecting": false
    }
  ]
},
{
  "rows_estimation": [
    {
      "table": "ttt",
      "range_analysis": {
        "table_scan": {
          "rows": 8238369,
          "cost": 4165718.152
        },
        "potential_range_indexes": [
          {
            "index": "PRIMARY",
            "usable": false,
            "cause": "not applicable"
          },
          {
            "index": "id2_ctime",
            "usable": true,
            "key_parts": ["id2", "ctime"]
          },
          {
            "index": "time",
            "usable": true,
            "key_parts": ["ctime"]
          }
        ],
        "setup_range_conditions": [],
        "analyzing_range_alternatives": {
          "range_scan_alternatives": [
            {
              "index": "id2_ctime",
              "ranges": ["(8,TTTTTT) < (id2,ctime) <= (8)"],
              "rowid_ordered": false,
              "using_mrr": false,
              "index_only": false,
              "rows": 8,
              "cost": 9.750467415,
              "chosen": true
            },
            {
              "index": "time",
              "ranges": ["(TTTTTT) < (ctime)"],
              "rowid_ordered": false,
              "using_mrr": false,
              "index_only": false,
              "rows": 174,
              "cost": 209.0299402,
              "chosen": false,
              "cause": "cost"
            }
          ],
          "analyzing_roworder_intersect": {
            "cause": "too few roworder scans"
          },
          "analyzing_index_merge_union": []
        },
        "group_index_range": {
          "chosen": false,
          "cause": "no group by or distinct"
        },
        "chosen_range_access_summary": {
          "range_access_plan": {
            "type": "range_scan",
            "index": "id2_ctime",
            "rows": 8,
            "ranges": ["(8,TTTTTT) < (id2,ctime) <= (8)"]
          },
          "rows_for_plan": 8,
          "cost_for_plan": 9.750467415,
          "chosen": true
        }
      }
    },
    {
      "table": "ttt",
      "rowid_filters": [
        {
          "key": "id2_ctime",
          "build_cost": 0.336822739,
          "rows": 8
        },
        {
          "key": "time",
          "build_cost": 10.05669642,
          "rows": 174
        }
      ]
    },
    {
      "selectivity_for_indexes": [
        {
          "index_name": "id2_ctime",
          "selectivity_from_index": 9.71066e-7
        }
      ],
      "selectivity_for_columns": [],
      "cond_selectivity": 9.71066e-7
    }
  ]
},
{
  "considered_execution_plans": [
    {
      "plan_prefix": [],
      "table": "ttt",
      "best_access_path": {
        "considered_access_paths": [
          {
            "access_type": "ref",
            "index": "id2_ctime",
            "rows": 1025552,
            "cost": 824537.8898,
            "chosen": true
          },
          {
            "access_type": "range",
            "resulting_rows": 8,
            "cost": 9.750467415,
            "chosen": true,
            "use_tmp_table": true
          }
        ],
        "chosen_access_method": {
          "type": "range",
          "records": 8,
          "cost": 9.750467415,
          "uses_join_buffering": false
        }
      },
      "rows_for_plan": 8,
      "cost_for_plan": 11.35046742,
      "cost_for_sorting": 8
    }
  ]
},
{
  "best_join_order": ["ttt"]
},
{
  "substitute_best_equal": {
    "condition": "WHERE",
    "resulting_condition": "ttt.id2 = '8' and ttt.ctime > TTTTTT"
  }
},
{
  "attaching_conditions_to_tables": {
    "attached_conditions_computation": [],
    "attached_conditions_summary": [
      {
        "table": "ttt",
        "attached": "ttt.id2 = '8' and ttt.ctime > TTTTTT"
      }
    ]
  }
}