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 (65466, 65475, 65477, 65480) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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 (65466,65475,65477,65480) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
65466	Fully customizable industrial lighting styles! The Bridgeport brings an authentic rugged character to residential and commercial settings!	Bridgeport Flush Mount Light, Bridgeport Flush Mount, Bridgeport Flush Mount Pendant, Bridgeport Pendant, Bridgeport Pendant Light, Bridgeport ceiling light, Bridgeport flush mount ceiling pendant, Bridgeport flush, Flush Bridgeport, The Bridgeport Flush Mount Light, The Bridgeport Flush Mount, The Bridgeport Flush Mount Pendant, The Bridgeport Pendant, The Bridgeport Pendant Light, The Bridgeport ceiling light, The Bridgeport flush mount ceiling pendant, The Bridgeport flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, BLE-F-MI, Bridgeport Vintage Industrial Flush Mount Light, Bridgeport Vintage Industrial Flush Mount, Bridgeport Industrial Flush Mount Light, Bridgeport Industrial Flush Mount, Bridgeport Vintage Flush Mount Light, Bridgeport Vintage Flush Mount, Vintage Industrial Flush Mount Light, Vintage Industrial Flush Mount, Industrial flush mount, industrial flush mount light, metropolitan,
65475	Classic industrial styles with integrated LED tech! Elevate every décor and reduce your energy demands with this vintage-meets-modern flush mount light!	Chicago LED Vintage Industrial Flush Mount Light, Chicago LED Vintage Industrial Flush Mount, chicago led flush mount, BLE-F-OI-LED, Chicago LED, LED chicago, Chicago LED Flush Mount Light, Chicago LED Flush Mount, Chicago LED Flush Mount Lighting, Chicago LED Flush Mount Lights, Chicago LED Flush Mount pendant, Chicago LED Flush Mount pendant Light, Chicago LED Flush Light, Chicago LED Flush pendant Light, Chicago LED Flush pendant, Chicago, BLE-F-OI, Chicago Flush Mount Light, Chicago Flush Mount, Chicago Flush Mount Pendant, Chicago Pendant, Chicago Pendant Light, Chicago ceiling light, Chicago flush mount ceiling pendant, Chicago flush, Flush Chicago, The Chicago Flush Mount Light, The Chicago Flush Mount, The Chicago Flush Mount Pendant, The Chicago Pendant, The Chicago Pendant Light, The Chicago ceiling light, The Chicago flush mount ceiling pendant, The Chicago flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, Chicago Vintage Industrial Flush Mount Light, Chicago Vintage Industrial Flush Mount, Chicago Industrial Flush Mount Light, Chicago Industrial Flush Mount, Chicago Vintage Flush Mount Light, Chicago Vintage Flush Mount, Vintage Industrial Flush Mount Light, Vintage Industrial Flush Mount, Industrial flush mount, industrial flush mount light, metropolitan,
65477	A modern update to vintage styles, the Rochester features a timeless appearance and integrated LED tech! Handcrafted, energy efficient, and fully customizable!	BLE-F-SI-LED, Rochester LED, LED rochester, Rochester LED Flush Mount Light, Rochester LED Flush Mount, Rochester LED Flush Mount Lighting, Rochester LED Flush Mount Lights, Rochester LED Flush Mount pendant, Rochester LED Flush Mount pendant Light, Rochester LED Flush Light, Rochester LED Flush pendant Light, Rochester LED Flush pendant, Rochester, BLE-F-SI, Rochester Flush Mount Light, Rochester Flush Mount, Rochester Flush Mount Pendant, Rochester Pendant, Rochester Pendant Light, Rochester ceiling light, Rochester flush mount ceiling pendant, Rochester flush, Flush Rochester, The Rochester Flush Mount Light, The Rochester Flush Mount, The Rochester Flush Mount Pendant, The Rochester Pendant, The Rochester Pendant Light, The Rochester ceiling light, The Rochester flush mount ceiling pendant, The Rochester flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, Rochester Vintage Industrial Flush Mount Light, Rochester Vintage Industrial Flush Mount, Rochester Industrial Flush Mount Light, Rochester Industrial Flush Mount, Rochester Vintage Flush Mount Light, Rochester Vintage Flush Mount, Vintage Industrial Flush Mount Light, Vintage Industrial Flush Mount, Industrial flush mount, industrial flush mount light, metropolitan,
65480	Eco-friendly, budget-minded, and incredibly stylish: The Syracuse brings cutting-edge LED technology to vintage industrial lighting designs! American made and endlessly customizable!	BLE-F-CI-LED, Syracuse LED, LED syracuse, Syracuse LED Flush Mount Light, Syracuse LED Flush Mount, Syracuse LED Flush Mount Lighting, Syracuse LED Flush Mount Lights, Syracuse LED Flush Mount pendant, Syracuse LED Flush Mount pendant Light, Syracuse LED Flush Light, Syracuse LED Flush pendant Light, Syracuse LED Flush pendant, Syracuse, BLE-F-CI, Syracuse Flush Mount Light, Syracuse Flush Mount, Syracuse Flush Mount Pendant, Syracuse Pendant, Syracuse Pendant Light, Syracuse ceiling light, Syracuse flush mount ceiling pendant, Syracuse flush, Flush Syracuse, The Syracuse Flush Mount Light, The Syracuse Flush Mount, The Syracuse Flush Mount Pendant, The Syracuse Pendant, The Syracuse Pendant Light, The Syracuse ceiling light, The Syracuse flush mount ceiling pendant, The Syracuse flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, Syracuse Vintage Industrial Flush Mount Light, Syracuse Vintage Industrial Flush Mount, Syracuse Industrial Flush Mount Light, Syracuse Industrial Flush Mount, Syracuse Vintage Flush Mount Light, Syracuse Vintage Flush Mount, Vintage Industrial Flush Mount Light, Vintage Industrial Flush Mount, Industrial flush mount, industrial flush mount light, metropolitan,