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 (65416, 61166, 61211, 59412) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00038

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 (65416,61166,61211,59412) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
59412	raw brass hanging pendant, brass ceiling light, Cord hung lighting, vintage industrial pendant light	This vintage pendant light features a cloth cord mount with an exposed socket. Customize this reproduction pendant with a unique bulb!	Minimalist Raw Brass Pendant, minimal pendant light, single bulb hanging pendant, raw brass hanging pendant, brass ceiling light, cloth cord pendant light, vintage industrial edison light, BLE-501-TW, minimalist, minimalist pendant, bare bulb pendant, bare bulb light, bare bulb pendant light, minimalist pendant light, 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,
61166	filament bulb pendant, solo pendant light, exposed socket pendant, cord hung bulb light, single bulb pendant, edison bulb pendant light, cord hung socket pendant, minimalist bulb pendant	Loved for its minimal, bare bulb the Indy Pendant is rooted in vintage industrial lighting styles. Its turn key and custom cord options makes you the designer.	Barn Light Indy Industrial Pendant, BLE-PHSCKT, BLE-INDY, hanging bulb, bulb pendant, light cord, pendant light bulbs, Indy Industrial Pendant, Indy Industrial Pendant Light, Indy Industrial Pendant Lights, Indy Industrial Pendant Lighting, Indy Pendant, Indy Pendants, Indy Pendant Light, Indy Pendant Lights, Indy Pendant Lighting, bare bulb light, bare bulb pendant, minimalist pendant, industrial pendant, minimalist ceiling 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,
61211	hanging light cord, hanging bulb pendant, electrical swag light kit, socket pendant, porcelain socket pendant light, decorative socket pendant, filament bulb pendant, bare porcelain socket pendant light, bare bulb pendant	This modern drop cord fixture follows a simple industrial style and features a ceramic porcelain socket and cloth cord mount. Big savings + Free Shipping!	The Indy Porcelain Socket Pendant, BLE-C-PINDY, BLE-INDY, hanging bulb, bulb pendant, light cord, pendant light bulbs,Indy Pendant, light cord, hanging bulb, bulb pendant, hanging bulbs, pendant light bulbs, drop cord, porcelain socket, socket pendant, socket light, pindy socket, pindy sockets, pindy cup, pindy cups, pendy socket, pendy sockets, pendy cup, pendy cups,
65416		The Ellington’s modern, minimalist look brings style and plenty of light to homes and businesses. Customizable with various finish colors and cord styles!	BLE-C-EGT, Ellington Pendant Light, Ellington Pendant Light, Ellington Pendant Lighting, Ellington Pendant Lights, Ellington Ceiling Pendant Light, Ellington Ceiling Pendant, Ellington Ceiling Pendants, Ellington Ceiling Light, Ellington Ceiling lights, Ellington ceiling lighting, Ellington pendant, Ellington Pendants, Ellington, Ellington Light, Ellington Lights, Ellington Lighting, 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, ellingtons