Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (60138, 62984, 61520, 62057) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00034

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (60138,62984,61520,62057) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
60138	pendant light, mini industrial pendant, factory light, industrial-era lighting	Functional and beautiful, the Fargo Pendant Light features a mini shade affixed to an industrial era-style socket and durable cord mount.	Barn Light Fargo Pendant, Fargo Pendant, Mini Pendant, Cord Hung, Turn Key, Deep Bowl, Farmhouse, Industrial, BE-98605, spoke top, spoketop, Pendant island lights, SPS-0163, SPS 0163, SPS0163, fargo collection, fargo series, The Fargo Collection, The Fargo Series, Fargo, Fargo Cord, Fargo Cord Pendant, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, fargo pendant, spoke top pendant lights,
61520	mini pendant, mini task light, petite barn light ceiling light, mini kitchen island light, small RLM light, tiny barn light, classic mini pendant, mini artesia barn pendant, mini reflector shade pendant	Our popular Artesia light, now in mini-shade form! You will love this petite warehouse shade as a lighting accent in your kitchen, entryway, or office.	Barn Light Mini Artesia Pendant, mini pendants, mini artesia, BLE-C-WHMA, island lighting, SPS-0058, SPS 0058, SPS0058, Artesia Collection, Artesia Series, The Artesia Collection, The Artesia Series, The Mini Artesia Collection, The Mini Artesia Series, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, mini artesian, H-15006, mini curved warehouse shade, mini curved warehouse shade cord-hung ceiling light,
62057	vintage deep bowl pendant, deep bowl factory light, industrial deep bowl reflector pendant, vented deep-bowl reflector	For a unique twist on classic barn lighting, hang the Vented Wesco pendant! This highly customizable deep bowl pendant showcases both directional and up lighting.	vented, vented shade, vintage warehouse, BLE-C-VDBW-PC, Wesco Vented Cord Hung Pendant Light, wesco, deep bowl, vinted, ventedd deep bowl, cord hung, BLE-C-VDBW10-PC, BLE-C-VDBW12-PC, BLE-C-VDBW14-PC, BLE-C-VDBW16-PC, vintage ceiling light, vintage style lighting, vintage inspired lighting, ceiling light, ceiling lighting, vented ceiling light, vented pendant light, Wesco vented light, Wesco ceiling light, vented shade, vented shade light, vented warehouse shade, warehouse shade, deep bowl warehouse shade, ceiling light, ceiling lighting, porch light, kitchen light, vented wilcox, vented wilcox cord, Wilcox Vented Pendant Light, Wilcox Vented Pendant, wilcox vinted, vinted, vint, vent wilcox, vent wilcox pendant, vented pendant, wilcox vented pendant, Wilcox uplight, wilcox uplights, BLE-C-VDBW16, BLE-C-VDBW20, BLE-C-VDBW10, BLE-C-VDBW12, BLE-C-VDBW14, SPS-0168, SPS 0168, SPS0168, SPS-0158, SPS 0158, SPS0158, Wilcox Series, Wilcox Collection, The Wilcox Series, The Wilcox Collection, Wilcox deep bowl series, wilcox deep bowl collection, the wilcox deep bowl series, the wilcox deep bowl collection, deep bowl series, deep bowl collection, wilcox vented collection, wilcox vented series, the wilcox vented collection, the wilcox vented series, Wilcox vented deep, natural metals, natural metal, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, wilcox bowl, slotted, slotted light, H-16510, H-16512, H-16514, H-16516, H-16518, H-16524, vented deep bowl shade, vented deep bowl shade cord-hung pendant,
62984	Cord Hung Lighting, Ceramic Lighting, Industrial Lighting, Pendant Lights	Now industrial lighting features a glossy ceramic canopy! This ensures this ceiling light will illuminate your space for many years. Consider for both homes and businesses!	The Kao Gladstone Pendant, Kao Gladstone Pendant, Kao Gladstone, Kao Pendant, kao, Gladstone pendant, Gladstone, pendant light, pendant lighting, ceiling lighting, ceiling pendant, Alabax, pass & Seymour, pass and Seymour, ceramic, ceramic lighting, ceramic pendant, porcelian, BLE-CU-DBG/KAO, BLE-CU-DBG, BLE-CU-DBG10, BLE-CU-DBG8, BLE-CU-DBG10-KAO, BLE-CU-DBG8-KAO, BLE-CU-DBG6-KAO, BLE-CU-DBG8-KAO, BLE-CU-DBG10-KAO, SPS-0374, SPS 0374, SPS0374, Gladstone Collection, Glad Stone Collection, Gladstone Series, Glad Stone Series, Kao Collection, Kao Series, kao collection, kao series, the kao collection, the kao series, koa, kao lighting, kao light, kao lights, kao ceramic ceiling canopy, jadeite, jadite, jadeite light, jadite light,