SELECT 
  object_id, 
  name 
FROM 
  seo_names 
WHERE 
  name IN ('jewelry', 'necklaces') 
  AND type = 'c' 
  AND lang_code = 'en'

Query time 0.00086

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "19.05"
    },
    "table": {
      "table_name": "seo_names",
      "access_type": "range",
      "possible_keys": [
        "name",
        "type"
      ],
      "key": "name",
      "used_key_parts": [
        "name",
        "lang_code"
      ],
      "key_length": "758",
      "rows_examined_per_scan": 59,
      "rows_produced_per_join": 5,
      "filtered": "10.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "18.46",
        "eval_cost": "0.59",
        "prefix_cost": "19.05",
        "data_read_per_join": "10K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "lang_code"
      ],
      "attached_condition": "((`goimagine`.`seo_names`.`name` in ('jewelry','necklaces')) and (`goimagine`.`seo_names`.`type` = 'c') and (`goimagine`.`seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

object_id name
2 jewelry
655 jewelry
697 jewelry
4235 jewelry
10218 jewelry
10724 jewelry
13676 jewelry
15129 jewelry
13 necklaces
530 necklaces
696 necklaces
844 necklaces
863 necklaces
2326 necklaces
2358 necklaces
2572 necklaces
2575 necklaces
3160 necklaces
3491 necklaces
3746 necklaces
3913 necklaces
4003 necklaces
4778 necklaces
5510 necklaces
5716 necklaces
6579 necklaces
7615 necklaces
7618 necklaces
7623 necklaces
8031 necklaces
8435 necklaces
8840 necklaces
9313 necklaces
9316 necklaces
9369 necklaces
9595 necklaces
11980 necklaces
12066 necklaces
12173 necklaces
12205 necklaces
12674 necklaces
12753 necklaces
13185 necklaces
13713 necklaces
16616 necklaces
16839 necklaces
16892 necklaces
17097 necklaces
17136 necklaces
17176 necklaces
17673 necklaces
18158 necklaces
19663 necklaces
19670 necklaces
20254 necklaces
22076 necklaces
22397 necklaces
22617 necklaces
23233 necklaces