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 (65300, 65301, 65422, 65423) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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 (65300,65301,65422,65423) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
65300 Handcrafted flush mount lighting with a timeless design! The Conoco embraces classic styles and a fully customizable appearance, making it perfect for every home or business! BLE-F-FCC, Conoco flush mount, conoco flush mounts, conoco flush mount pendant, conoco flush mount pendants, conoco flush mount pendant light, conoco flush mount pendant lights, conoco flush mount pendant lighting, conoco flush mount, conoco flush mounts, conoco flush mount pendant, conoco flush mount pendants, conoco flush pendant, conoco flush pendants, conoco flush mount light, conoco flush pendant, flush mount conoco, flush conoco, Conoco flush, conoco flush pendant, conoco flush pendant light, conoco flush mount pendants, flush mount, flush mount light, flush mount pendant light, flush mount pendant lighting,
65301 Timeless lighting styles for smaller spaces, this flush mount pendant stands out in any décor! American made and fully customizable! BLE-F-SBD, Dominion flush mount, dominion flush mounts, dominion flush mount pendant, dominion flush mount pendants, dominion flush mount pendant light, dominion flush mount pendant lights, dominion flush mount pendant lighting, dominion flush mount, dominion flush mounts, dominion flush mount pendant, dominion flush mount pendants, dominion flush pendant, dominion flush pendants, dominion flush mount light, dominion flush pendant, flush mount dominion, flush dominion, Dominion flush, dominion flush pendant, dominion flush pendant light, dominion flush mount pendants, flush mount, flush mount light, flush mount pendant light, flush mount pendant lighting, H-15512, H-15514, H-15516, shallow dome warehouse shade, shallow dome warehouse flush mount,
65422 With a wavy shade and fully customizable design, the Seaside brings a stylish edge to homes and businesses. Handcrafted and American made! BLE-F-RWS, Seaside, seaside flush, seaside flush mount, seaside flush mount pendant, seaside flush mount pendant light, seaside flush mount pendant lights, seaside flush mount ceiling pendant, seaside flush mount ceiling light, seaside flush mount ceiling lighting, seaside flush ceiling mount, seaside flush pendant, seaside flush mount light, seaside flush mount lights, seaside flush mount lighting, seaside flush light, seaside flush lights, seaside flush pendant, seaside flush ceiling pendant, seaside flush ceiling mount, seaside flush pendant light, seaside flush ceiling pendant light, seaside flush ceiling mount, The Seaside, The seaside flush, the seaside flush mount, the seaside flush mount pendant, the seaside flush mount pendant light, the seaside flush mount pendant lights, the seaside flush mount ceiling pendant, the seaside flush mount ceiling light, the seaside flush mount ceiling lighting, the seaside flush ceiling mount, the seaside flush pendant, the seaside flush mount light, the seaside flush mount lights, the seaside flush mount lighting, the seaside flush light, the seaside flush lights, the seaside flush pendant, the seaside flush ceiling pendant, the seaside flush ceiling mount, the seaside flush pendant light, the seaside flush ceiling pendant light, the seaside flush ceiling mount, flush mount pendant, flush mount light, flush mount ceiling pendant, flush mount, flush mount light, seaside, H-19112, H-19114, H-19116, classic radial shade,
65423 A timeless yet eye-catching shape, this flush mount pendant brings character and style to homes and businesses. Customize its style with your favorite colors and accessories! BLE-F-DCS, Sterling, Sterling Flush, Sterling Flush Mount, sterling flush mount light, sterling flush mount pendant, sterling flush mount pendant light, sterling flush mount ceiling pendant, sterling flush mount ceiling pendants, Sterling flush mount ceiling light, sterling flush mount ceiling lights, sterling flush mount ceiling lighting, sterling flush ceiling mount, sterling flush ceiling mounts, sterling flush light, sterling flush lights, sterling flush lighting, sterling ceiling light, sterling ceiling lights, sterling ceiling lighting, sterling flush mount lighting, The Sterling, The Sterling Flush, The Sterling Flush Mount, The sterling flush mount light, The sterling flush mount pendant, The sterling flush mount pendant light, The sterling flush mount ceiling pendant, The sterling flush mount ceiling pendants, The Sterling flush mount ceiling light, The sterling flush mount ceiling lights, The sterling flush mount ceiling lighting, The sterling flush ceiling mount, The sterling flush ceiling mounts, The sterling flush light, The sterling flush lights, the sterling flush lighting, the sterling ceiling light, the sterling ceiling lights, the sterling ceiling lighting, the sterling flush mount lighting, flush mount pendant, flush mount light, flush mount ceiling pendant, flush mount, flush mount light,