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 (60798, 65548, 65964, 65800) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00051

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 (60798,65548,65964,65800) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
60798	studio pendant light, cord and cable pendant, modern cable pendant light, swag light, shallow bowl rlm light with unique mount, classic cable light, adjustable cord hung pendant, wavy cord ceiling light, industrial chic lighting, retro modern pendant ligh	The Aero's flared shade adds a little timeless charm to this studio light fixture. Go industrial chic with an RLM shade and unique ceiling mount!	Aero Studio Light, Aero, Studio Light, Aero Pendant, Aero Ceiling Light, Cable pendant, wavy cord, swag light, aero, aero studio, studio pendant, BLE-C-STU-SBA12, BLE-C-STU-SBA14, BLE-C-STU-SBA16, SPS-0365, SPS0365, SPS 0365, jadeite, jadite, jadeite light, jadite light,
65548		A stunning modern design, the Alto adds touches of character to a home or business. Handcrafted, customizable, and truly unique!	BLE-C-ATO, Alto Wooden Cylinder Pendant Light, Alto Wooden Cylinder Pendant Lights, Alto Wooden Cylinder Pendant Lighting, Alto Wooden Cylinder Pendant, Alto Wooden Cylinder Pendants, Alto Wooden Cylinder Ceiling Pendant, Alto Wooden Cylinder Ceiling Pendants, Alto Wooden Cylinder Ceiling Light, Alto Wooden Cylinder Ceiling Lights, Alto Wooden Cylinder ceiling Lighting, Alto Wood Cylinder Pendant Light, Alto Wood Cylinder Pendant Lights, Alto Wood Cylinder Pendant Lighting, Alto Wood Cylinder Pendant, Alto Wood Cylinder Pendants, Alto Wood Cylinder Ceiling Pendant, Alto Wood Cylinder Ceiling Pendants, Alto Wood Cylinder Ceiling Light, Alto Wood Cylinder Ceiling Lights, Alto Wood Cylinder ceiling Lighting, Alto Wooden Pendant Light, Alto Wooden Pendant Lights, Alto Wooden Pendant Lighting, Alto Wooden Pendant, Alto Wooden Pendants, Alto Wooden Ceiling Pendant, Alto Wooden Ceiling Pendants, Alto Wooden Ceiling Light, Alto Wooden Ceiling Lights, Alto Wooden ceiling Lighting, Alto Wood Pendant Light, Alto Wood Pendant Lights, Alto Wood Pendant Lighting, Alto Wood Pendant, Alto Wood Pendants, Alto Wood Ceiling Pendant, Alto Wood Ceiling Pendants, Alto Wood Ceiling Light, Alto Wood Ceiling Lights, Alto Wood ceiling Lighting, Alto, Alto Pendant Light, Alto Pendant Lights, Alto Pendant Lighting, Alto Pendant, Alto Pendants, Alto Ceiling Pendant, Alto Ceiling Pendants, Alto Ceiling Light, Alto Ceiling Lights, Alto ceiling 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, alto cylinder, tube downlight, tube style downlight, timber, timber and ore, timber & ore,
65800			42" avalon, oversized avalon, 42 avalon, avalon 42, avalon 42", 42" avalon led, led avalon 42, 42 avalon led, oversized avalon led, 42" led avalon,
65964		The Isos LED Cone Studio Pendant combines modern form with natural warmth, featuring hand-spun metal and an optional wood accent. Made in Florida.	isos studio, led isos, the isos, oversized led, oversized led light, oversized light, large modern light, modern led, studio isos, isos collection, studio mount led, oversized studio light, adjustable led light,