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 (65789, 65790, 65791) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00027

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": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65789,65790,65791) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
65789 BLE-C-STU-SBS28, BLE-C-STU-SBS28-LED, Sinclair 28" Pendant Light, Sinclair 28" Pendant, Sinclair 28" Light, Sinclair 28" Cord Pendant Light, Sinclair 28" Cord Pendant, Sinclair 28" Cord Light, Sinclair 28" Cord, Sinclair 28 Pendant Light, Sinclair 28 Pendant, Sinclair 28 Light, Sinclair 28 Cord Pendant Light, Sinclair 28 Cord Pendant, Sinclair 28 Cord Light, Sinclair 28 Cord, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Cord Pendant Light, 28” Sinclair Cord Pendant, 28” Sinclair Cord Light, 28” Sinclair Cord, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Cord Pendant Light, 28” Sinclair Cord Pendant, 28” Sinclair Cord Light, 28” Sinclair Cord, 28 Sinclair Pendant Light, 28 Sinclair Pendant, 28 Sinclair Light, 28 Sinclair Cord Pendant Light, 28 Sinclair Cord Pendant, 28 Sinclair Cord Light, 28 Sinclair Cord, Sinclair, Sinclair Pendant Light, Sinclair Pendant, Sinclair Cord Pendant, Sinclair Cord, 28”, 28" sinclair, sinclair led, sinclair led pendant, oversized led pendant, big led light, led sinclair, sinclair led cord, 28" sinclair led,
65790 BLE-CN-SBS28, BLE-CN-SBS28-LED, Sinclair 28" Pendant Light, Sinclair 28" Pendant, Sinclair 28" Light, Sinclair 28" Chain Pendant Light, Sinclair 28" Chain Pendant, Sinclair 28" Chain Light, Sinclair 28" Chain, Sinclair 28 Pendant Light, Sinclair 28 Pendant, Sinclair 28 Light, Sinclair 28 Chain Pendant Light, Sinclair 28 Chain Pendant, Sinclair 28 Chain Light, Sinclair 28 Chain, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Chain Pendant Light, 28” Sinclair Chain Pendant, 28” Sinclair Chain Light, 28” Sinclair Chain, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Chain Pendant Light, 28” Sinclair Chain Pendant, 28” Sinclair Chain Light, 28” Sinclair Chain, 28 Sinclair Pendant Light, 28 Sinclair Pendant, 28 Sinclair Light, 28 Sinclair Chain Pendant Light, 28 Sinclair Chain Pendant, 28 Sinclair Chain Light, 28 Sinclair Chain, Sinclair, Sinclair Pendant Light, Sinclair Pendant, Sinclair Chain Pendant, Sinclair Chain, Sinclair 28" Chain Hung Pendant Light, Sinclair 28" Chain Hung Pendant, Sinclair 28" Chain Mount Pendant Light, Sinclair 28" Chain Mount Pendant, Sinclair 28 Chain Hung Pendant Light, Sinclair 28 Chain Hung Pendant, Sinclair 28 Chain Mount Pendant Light, Sinclair 28 Chain Mount Pendant, 28 Sinclair Chain Hung Pendant Light, 28 Sinclair Chain Hung Pendant, 28 Sinclair Chain Mount Pendant Light, 28 Sinclair Chain Mount Pendant, 28" sinclair, oversized led sinclair, sinclair led, led sinclair, big sinclair, led chain sinclair, sinclair chain led, oversized sinclair, 28 sinclair, 28 led sinclair, giant sinclair, sinclair chain 28"
65791 BLE-S-SBS28, BLE-S-SBS28-LED, Sinclair 28" Pendant Light, Sinclair 28" Pendant, Sinclair 28" Light, Sinclair 28" Stem Pendant Light, Sinclair 28" Stem Pendant, Sinclair 28" Stem Light, Sinclair 28" Stem, Sinclair 28 Pendant Light, Sinclair 28 Pendant, Sinclair 28 Light, Sinclair 28 Stem Pendant Light, Sinclair 28 Stem Pendant, Sinclair 28 Stem Light, Sinclair 28 Stem, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Stem Pendant Light, 28” Sinclair Stem Pendant, 28” Sinclair Stem Light, 28” Sinclair Stem, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Stem Pendant Light, 28” Sinclair Stem Pendant, 28” Sinclair Stem Light, 28” Sinclair Stem, 28 Sinclair Pendant Light, 28 Sinclair Pendant, 28 Sinclair Light, 28 Sinclair Stem Pendant Light, 28 Sinclair Stem Pendant, 28 Sinclair Stem Light, 28 Sinclair Stem, Sinclair, Sinclair Pendant Light, Sinclair Pendant, Sinclair Stem Pendant, Sinclair Stem, 28”, Sinclair 28” Stem Mount Pendant Light, Sinclair 28" Stem Mount Pendant, Sinclair 28" Stem Mount, Sinclair 28" Stem Mount Light, Sinclair 28 Stem Mount Pendant Light, Sinclair 28 Stem Mount Pendant, Sinclair 28 Stem Mount, Sinclair 28 Stem Mount Light, 28” Sinclair Stem Mount Pendant Light, 28” Sinclair Stem Mount Pendant, 28” Sinclair Stem Mount, 28” Sinclair Stem Mount Light, 28 Sinclair Stem Mount Pendant Light, 28 Sinclair Stem Mount Pendant, 28 Sinclair Stem Mount, 28 Sinclair Stem Mount Light, 28" sinclair, oversized led sinclair, sinclair led 28" 28 sinclair led, large oversized sinclair, sinclair led stem, stem led sinclair, oversized stem led sinclair,