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": [], "impossible_range": true } } ] }, { "table_dependencies": [ { "table": "test1", "row_may_be_null": false, "map_bit": 0, "depends_on_map_bits": [] } ] }, { "best_join_order": ["test1"], "rows": 1, "cost": 0 } ] } } ] }