select * from test1 where id in ('802388088375689216','802387982614183936') | { "steps": [ { "join_preparation": { "select_id": 1, "steps": [ { "expanded_query": "select test1.`id` AS `id` from test1 where test1.`id` in ('802388088375689216','802387982614183936')" } ] } }, { "join_optimization": { "select_id": 1, "steps": [ { "condition_processing": { "condition": "WHERE", "original_condition": "test1.`id` in ('802388088375689216','802387982614183936')", "steps": [ { "transformation": "equality_propagation", "resulting_condition": "test1.`id` in ('802388088375689216','802387982614183936')" }, { "transformation": "constant_propagation", "resulting_condition": "test1.`id` in ('802388088375689216','802387982614183936')" }, { "transformation": "trivial_condition_removal", "resulting_condition": "test1.`id` in ('802388088375689216','802387982614183936')" } ] } }, { "ref_optimizer_key_uses": [] }, { "rows_estimation": [ { "table": "test1", "range_analysis": { "table_scan": { "rows": 2, "cost": 0.0111808 }, "potential_range_indexes": [ { "index": "PRIMARY", "usable": true, "key_parts": ["id"] } ], "setup_range_conditions": [], "group_index_range": { "chosen": false, "cause": "no group by or distinct" } } }, { "selectivity_for_indexes": [], "selectivity_for_columns": [], "cond_selectivity": 1 } ] }, { "table_dependencies": [ { "table": "test1", "row_may_be_null": false, "map_bit": 0, "depends_on_map_bits": [] } ] }, { "considered_execution_plans": [ { "plan_prefix": "", "get_costs_for_tables": [ { "best_access_path": { "table": "test1", "plan_details": { "record_count": 1 }, "considered_access_paths": [ { "access_type": "scan", "rows": 2, "rows_after_filter": 2, "rows_out": 2, "cost": 0.0111808, "index_only": false, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 2, "rows_out": 2, "cost": 0.0111808, "uses_join_buffering": false } } } ] }, { "plan_prefix": "", "table": "test1", "rows_for_plan": 2, "cost_for_plan": 0.0111808 } ] }, { "best_join_order": ["test1"], "rows": 2, "cost": 0.0111808 }, { "substitute_best_equal": { "condition": "WHERE", "resulting_condition": "test1.`id` in ('802388088375689216','802387982614183936')" } }, { "attaching_conditions_to_tables": { "attached_conditions_computation": [], "attached_conditions_summary": [ { "table": "test1", "attached_condition": "test1.`id` in ('802388088375689216','802387982614183936')" } ] } }, { "make_join_readinfo": [] } ] } } ] }