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 (64963, 64964, 64941, 64942) 
  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 (64963,64964,64941,64942) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
64941 A replacement acorn schoolhouse glass shade for your favorite Barn Light Electric fixtures! Customize the glass with hand-painted bands for a unique look! Acorn Schoolhouse Glass, Replacement Acorn Schoolhouse Glass, Acorn Glass, Replacement Acorn Glass, Schoolhouse Acorn Glass, Replacement schoolhouse, replacement schoolhouse glass, Acorn School house Glass, Replacement Acorn School house Glass, School house Acorn Glass, replacement school house glass, Acorn Schoolhouse Globe, Replacement Acorn Schoolhouse Globe, Acorn Globe, Replacement Acorn Globe, Schoolhouse Acorn Globe, replacement schoolhouse globe, Acorn School house Globe, Replacement Acorn School house Globe, School house Acorn Globe, replacement school house globe, Acorn Schoolhouse Shade, Replacement Acorn Schoolhouse Shade, Acorn Shade, Replacement Acorn Shade, Schoolhouse Acorn Shade, replacement schoolhouse shade, Acorn School house Shade, Replacement Acorn School house Shade, School house Acorn Shade, replacement school house shade, acorn, BLE-ACN-GLASS, replacement globes, striped schoolhouse, striped schoolhouse light,
64942 This replacement round schoolhouse glass is available in multiple sizes and with hand-painted bands in various colors! BLE-RND-GLASS, Round Schoolhouse Glass, Replacement Round Schoolhouse Glass, Round Glass, Replacement Round Glass, Schoolhouse Round Glass, Replacement schoolhouse, replacement schoolhouse glass, Round School house Glass, Replacement Round School house Glass, School house Round Glass, replacement school house glass, Round Schoolhouse Globe, Replacement Round Schoolhouse Globe, Round Globe, Replacement Round Globe, Schoolhouse Round Globe, replacement schoolhouse globe, Round School house Globe, Replacement Round School house Globe, School house Round Globe, replacement school house globe, Round Schoolhouse Shade, Replacement Round Schoolhouse Shade, Round Shade, Replacement Round Shade, Schoolhouse Round Shade, replacement schoolhouse shade, Round School house Shade, Replacement Round School house Shade, School house Round Shade, replacement school house shade, round, replacement globes, striped schoolhouse, striped schoolhouse light,
64963 midcentury, mid-century, mid century, midcentury pendant, mid-century pendant, mid century pendant, midcentury pendant light, midcentury pendant lights, midcentury pendant lighting, mid-century pendant light, mid-century pendant lights, mid-century pendant lighting, mid century pendant light, mid century pendant lights, mid century pendant lighting, midcentury modern, mid century modern, mid-century modern, new downtown, BLE-S-GLB8, BLE-S-GLB12, BLE-S-GLB16, Glass sphere, glass spheres, glass sphere shade, glass sphere shades, sphere glass, sphere glass shade, sphere glass shades, glass sphere light, glass sphere lights, glass sphere lighting, sphere glass light, sphere glass lights, sphere glass lighting, glass sphere pendant, glass sphere pendants, glass sphere ceiling pendant, glass sphere ceiling pendants, glass sphere pendant light, glass sphere pendant lights, glass sphere pendant lighting, glass sphere ceiling light, glass sphere ceiling lights, glass sphere ceiling lighting, Sphere glass pendant, sphere glass pendants, sphere glass ceiling pendant, sphere glass ceiling pendants, sphere glass pendant light, sphere glass pendant lights, sphere glass pendant lighting, sphere glass ceiling light, sphere glass ceiling lights, sphere glass ceiling lighting, glass sphere light fixture, glass sphere light fixtures, glass sphere lighting fixture, glass sphere lighting fixtures, Round glass shade, round glass shades, round glass shade light, round glass shade lights, round glass shade lighting, Glass round shade, glass round shades, glass round shade light, glass round shade lights, glass round shade lighting, round glass light, round glass lights, round glass lighting, glass round light, glass round lights, glass round lighting, Glass round light, glass round lights, glass round lighting, Round glass shade pendant, round glass shade pendants, glass round shade pendant, glass round shade pendants, round glass pendant, round glass pendants, glass round pendant, glass round pendants, glass round ceiling pendant, glass round ceiling pendants, round glass ceiling pendant, round glass ceiling pendants, glass round pendant light, round glass pendant light, glass round pendant lights, round glass pendant lights, glass round pendant lighting, round glass pendant lighting, glass round ceiling light, round glass ceiling light, glass round ceiling lights, round glass ceiling lights, round glass ceiling lighting, glass round ceiling lighting, Glass globe shade, glass globe shades, glass globe shade light, glass globe shade lights, glass globe shade lighting, glass globe shade fixture, glass globe shade fixtures, glass globe shade light fixture, glass globe shade light fixtures, glass globe shade lighting fixture, glass globe shade lighting fixtures, glass globe pendant, glass globe pendants, glass globe ceiling pendant, glass globe ceiling pendants, glass globe pendant light, glass globe pendant lights, glass globe pendant lighting, glass globe ceiling light, glass globe ceiling lights, glass globe ceiling lighting, Globe shade, globe shades, globe shade light, globe shade lights, globe shade lighting, globe shade fixture, globe shade fixtures, globe shade light fixture, globe shade light fixtures, globe shade lighting fixture, globe shade lighting fixtures, globe light shade, globe light shades, globe light fixtures, globe light fixture, globe lighting fixture, globe lighting fixtures, Globe shade pendant, Globe shade pendants, Globe shade ceiling pendant, Globe shade ceiling pendants, globe pendant, globe pendants, globe ceiling pendant, globe ceiling pendants, globe pendant, globe pendants, globe pendant light, globe pendant lights, globe pendant lighting, globe ceiling pendant, globe ceiling pendants, globe ceiling light, globe ceiling lights, globe ceiling lighting, glass ball pendant, glass ball pendants, glass ball pendant light, glass ball pendant lights, glass ball pendant lighting, glass ball stem mount, glass ball stem mounts, glass ball stem mount light, glass ball stem mount lights, glass ball stem mount lighting, glass ball stem mount pendant, glass ball stem mount pendants, glass ball stem mount pendant light, glass ball stem mount pendant lights, glass ball stem mount pendant lighting, glass ball stem mount ceiling pendant, glass ball stem mount ceiling pendants, glass ball stem mount ceiling light, glass ball stem mount ceiling lights, glass ball stem mount ceiling lighting, BLE-S-GLB, Glass Ball collection, Glass Ball Series, the glass ball collection, the glass ball series, SPS 0076, SPS0076, SPS-0076, glass shade, glass ball shade, glass ball shades, glass ball light, glass ball lights, glass ball lighting, stems, Stem pendant lights, stem light mount, stem light mounts, stem, opaque glass pendant, clear glass pendant, glb, glbcl,
64964 Glass Ball Pendant Light, Glass Ball Pendant, Glass Ball Pendants, Glass Ball, Glass Ball Ceiling Pendant Light, Glass Ball Ceiling Pendant, Glass Ball Ceiling Pendants, BLE-C-GLB, BLE-C-GLB8, BLE-C-GLB12, BLE-C-GLB16, glass shade, glass ball shade, glass ball shades, glass ball light, glass ball lights, glass ball lighting, Glass Ball collection, Glass Ball Series, the glass ball collection, the glass ball series, SPS 0076, SPS0076, SPS-0076, 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, opaque glass pendant, clear glass pendant, glb, glbcl,