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 (64747, 64989, 65096, 64847) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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 (64747,64989,65096,64847) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
64747 lighting pendant, barn light pendant, shallow bowl pendant light, vintage industrial lighting, GU24 compatible lighting, warehouse shade cord hung pendants, american made ceiling light, shallow bowl ceiling light, hanging light This hanging pendant light features vintage barn lighting style with vibrant color options! The District's shallow bowl makes a statement in any space. BLE-C-SBD12, dominion, shallow bowl pendant, BLE-C-SBD, BLE-C-SBD14, BLE-C-SBD16, dominion pendant, ivanhoe dominion, shallow pendant, shallow, flat pendant, new listing, new rlm, new dominion, dominion, district, District Cord Hung Pendant, BLE-C-SBD12, district, shallow bowl, cord hung pendant, BLE-C-SBD12-PC, BLE-C-SBD14-PC, BLE-C-SBD16-PC, BLE-C-SBD12, BLE-C-SBD14, BLE-C-SBD16, SPS-0152, SPS0152, SPS0152, Dominion Series, Dominion Collection, The Dominion Series, The Dominion Collection, 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, jadeite, jadite, jadeite light, jadite light, bowl shallow, H-15512, H-15514, H-15516, shallow dome warehouse shade, shallow dome warehouse cord-hung pendant,
64847 loop-to-loop pendant, stem light, loop and stem fixture, swiveling stem pendant light, vintage brass pendant, filament pendant lighting, nickel ceiling light fixture, single-pole pendant light The timeless barn light style with a single stem and exposed socket is reminiscent of classic industrial lighting. Perfect dining and island lighting! sinclair, stem mount, loop, stem and loop, stem loop, ivanhoe, ivanhoe sinclair, sinclair stem & loop, sinclair stem and loop, BLE-S-SL-SBS, BLE-S-SL-SBS10, BLE-S-SL-SBS12, BLE-S-SL-SBS14, BLE-S-SL-SBS16, sinclair stem, new stem & loop, BLE-S-SL-SBS10, BLE-S-SL-SBS12, BLE-S-SL-SBS14, BLE-S-SL-SBS16, BLE-G-SBD12, BLE-G-SBD14, BLE-G-SBD16, Sinclaire, Stem and loop pendants, Stem and loop pendant, SPS-0190, SPS 0190, SPS0190,
64989 Timeless designs and efficient LED technology! This pendant is handcrafted in the USA and fully customizable! Revamp your space with this fashionable lighting! BLE-C-SBS-LED, The Skylark LED Pendant, The Skylark LED Pendants, Skylark LED Pendant, Skylark LED Pendants, The Skylark LED Pendant light, The Skylark LED Pendant Lights, The Skylark LED Pendant Lighting, Skylark LED Pendant light, Skylark LED Pendant Lights, Skylark LED Pendant Lighting, Skylark LED ceiling pendant, Skylark LED ceiling pendants, Skylark LED ceiling light, skylark LED ceiling lighting, LED ceiling pendant, LED ceiling pendants, LED ceiling light, LED ceiling lights, LED ceiling lighting, LED pendant light, LED pendant Lights, LED pendant lighting, Cord hung LED, cord mount LED, led cord hung, LED cord mount, Ivanhoe® Sinclair LED Pendant, Ivanhoe Sinclair LED Pendant, Ivanhoe Sinclair LED Pendant Light, Ivanhoe Sinclair LED Pendant Lights, Ivanhoe Sinclair LED Pendant Lighting, Ivanhoe Sinclair LED Light, Ivanhoe Sinclair LED Lights, Ivanhoe Sinclair LED Lighting, Sinclair LED Pendant Lights, Sinclair LED Pendant Lighting, Sinclair LED Light, Sinclair LED Lights, Sinclair LED Lighting, Sinclair LED pendant, Sinclair LED pendants, LED pendant, LED pendants, LED pendant light, LED pendant lights, LED pendant lighting, Sinclair cord hung, Sinclair cord mount, BLE-C-SBS10, BLE-C-SBS12, BLE-C-SBS14, BLE-C-SBS16, Sinclaire, SPS-0463, SPS 0463, SPS0463, Sinclair LED series, Sinclair LED Collection, The Sinclair LED series, the Sinclair LED Collection, Sinclair Integrated LED series, Sinclair Integrated LED Collection, The Sinclair Integrated LED series, The Sinclair Integrated LED Collection, Ivanhoe warehouse led pendant, Ivanhoe warehouse led pendants,
65096 shallow bowl pendant light, shallow bowl shade with turn switch key, industrial pendant lamp, vintage style factory light Vintage-inspired, handcrafted, and fully customizable! With its classic style, the Sinclair helps every home or business feel stylish, elevated, and welcoming! Sinclair Spoke Top Pendant Light, Sinclair Spoke Top Pendant, Sinclair Spoke Top, Sinclair Spoke, Spoke Top Sinclair, Spoke Top Sinclair Pendant, Spoke Top Sinclair Pendant Light, Sinclair pendant, Sinclair pendant, Sinclair, spoke top, spoke top pendant, spoke pendant, pendant spoke top, spoke pendant, spoke pendant light, sinclair ceiling pendant, BLE-CCS-SBS10, BLE-CCS-SBS12, BLE-CCS-SBS14, BLE-CCS-SBS16, Sinclaire, SPS-0180, SPS0180, SPS 0180, Sinclair collection, Sinclair Series, the Sinclair collection, the Sinclair Series, Sinclair Spoke Top Collection, Sinclair Spoke Top Series, The Sinclair Spoke Top Collection, The Sinclair Spoke Top Series, Vintage green spoke light, 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, Warehouse pendent, Warehouse pendents, Ware house pendent, Ware house pendents, Warehouse pendent light, Warehouse pendent lights, Warehouse pendent lighting, Ware house pendent light, Ware house pendent lights, Ware house pendent lighting, Warehouse ceiling pendent, Warehouse ceiling pendents, Ware house ceiling pendent, Ware house ceiling pendents, pendent light, pendent lights, pendent lighting, pendent, ceiling pendent, ceiling pendents, Warehouse pendent, Warehouse pendent light, ble-cc-sbs, spoke top pendant lights,