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 (65101, 65102, 65103) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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 (65101,65102,65103) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
65101 With its large-scale profile and classic appearance, the 28” Sinclair stands out in every décor! Customize its appearance with your favorite finish color! BLE-C-STU-SBS28, 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,
65102 With its 28” shade and stem mounting, the Sinclair stands out in every home or business. Durably crafted and fully customizable, create the perfect look for your space! BLE-S-SBS28, 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,
65103 Industrial and eye-catching, this chain hung pendant features a large, 28” shade! Meticulously crafted and customizable for truly unique looks! BLE-CN-SBS28, 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,