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 (65099, 62226, 64847, 64771) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00030

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 (65099,62226,64847,64771) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
62226	vintage reproduction lighting, dome shade mini pendant, dome shade industrial pendant, period authentic lighting	This period-authentic light fixture was inspired by Benjamin Lighting "sewing machine RLM" shades. It's mini dome is fitted to a vintage style turnkey-socket.	BLE-C-DBG-PC, Getty Dome Shade Pendant, getty, getty cord hung, mini pendant, dome shade, getty dome, pendant with turnkey, turnkey, getty pendant, BLE-C-DBG6-PC, BLE-C-DBG8-PC, BLE-C-DBG10-PC, gladstone, glad stone, Gladstone Pendant Light, Gladstone Pendant, gladstone cord, cord gladstone, Glad stone Pendant Light, Glad stone Pendant, glad stone cord, cord glad stone, BLE-CU-DBG10, BLE-CU-DBG8, BLE-CU-DBG6, BLE-CU-DBG6, BLE-CU-DBG8, BLE-CU-DBG10, SPS-0042, SPS 0042, SPS0042, Gladstone Collection, Glad Stone Collection, Gladstone Series, Glad Stone 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, Warehouse pendent, Warehouse pendents, Ware house pendent, Ware house pendents, Warehouse pendent light, Warehouse pendent lights, Warehouse pendent lighting, Ware house pendent light, Ware house pendent lights, Ware house pendent lighting, Warehouse ceiling pendent, Warehouse ceiling pendents, Ware house ceiling pendent, Ware house ceiling pendents, pendent light, pendent lights, pendent lighting, pendent, ceiling pendent, ceiling pendents, jadeite, jadite, jadeite light, jadite light,
64771	barn light ceiling light, cord hung pendant, flared pendant light, vintage shallow bowl light, ceiling light fixture, gas station lighting, vintage gas station light fixture, cord hung light fixture	The Skylark Pendant Light offers a wide span of light with its flared base and looks right at home in the kitchen, dining room, or office.	Skylark, Skylark Cord Hung, Skylark pendant, shallow bowl pendant, shallow bowl cord hung, BLE-C-SBS-PC, BLE-C-SBS10-PC, BLE-C-SBS12-PC, BLE-C-SBS14-PC, BLE-C-SBS16-PC, new listing, new rlm, new skylark, Skylark Industrial Pendant, BLE-CU-SBS-PC, socket rlm pendant, skylark, shallow bowl, cord hung, cord pendant, BLE-CU-SBS10-PC, BLE-CU-SBS12-PC, BLE-CU-SBS14-PC, BLE-CU-SBS16-PC, Industrial, Ivanhoe, Sinclair, Ivanhoe Sinclair, shallow bowl, BLE-CU-SBS, BLE-CU-SBS10, BLE-CU-SBS12, BLE-CU-SBS14, BLE-CU-SBS16, flat, flat pendant, sinclair pendant, new sinclair, new rlm, new listing, BLE-C-SBS10, BLE-C-SBS12, BLE-C-SBS14, BLE-C-SBS16, Sinclaire, SPS-0155, SPS0155, SPS 0155, Sinclair Series, Sinclair Collection, The Sinclair Series, The Sinclair Collection, SPS-0373, SPS 0373, SPS0373, Sinclair Industrial Collection, Sinclair Industrial 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, jadeite, jadite, jadeite light, jadite light, bowl shallow,
64847	loop-to-loop pendant, stem light, loop and stem fixture, swiveling stem pendant light, vintage brass pendant, filament pendant lighting, nickel ceiling light fixture, single-pole pendant light	The timeless barn light style with a single stem and exposed socket is reminiscent of classic industrial lighting. Perfect dining and island lighting!	sinclair, stem mount, loop, stem and loop, stem loop, ivanhoe, ivanhoe sinclair, sinclair stem & loop, sinclair stem and loop, BLE-S-SL-SBS, BLE-S-SL-SBS10, BLE-S-SL-SBS12, BLE-S-SL-SBS14, BLE-S-SL-SBS16, sinclair stem, new stem & loop, BLE-S-SL-SBS10, BLE-S-SL-SBS12, BLE-S-SL-SBS14, BLE-S-SL-SBS16, BLE-G-SBD12, BLE-G-SBD14, BLE-G-SBD16, Sinclaire, Stem and loop pendants, Stem and loop pendant, SPS-0190, SPS 0190, SPS0190,
65099	flat cone pendant, early 20th century style lighting, filament bulb pendant lighting, flared shade pendant light	Hang this classic American-made Conoco pendant fixture in your nostalgic kitchen. Its flat, disk-like reflector shade is perfect for Edison Bulbs!	Industrial, Pendant, Ivanhoe, Conoco, Ivanhoe Conoco, BLE-CU-FCC10, BLE-CU-FCC12, BLE-CU-FCC15, saucer shade, flat cone shade, flat cone pendant, conoco pendant, conoco cord, flat pendant, shallow pendant, flat, shallow, conoco, conoco pendant, conoco pendant light, Conoco Industrial Pendant Light, Conoco Industrial Pendant, conoco, conoco shade, conoco shades, SPS-0375, SPS-0375, SPS-0375, jadeite, jadite, jadeite light, jadite light,