Sandbox

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 (64988, 64769, 64761, 64745) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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 (64988,64769,64761,64745) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
64745	hand spun pendant shade, stem mounted pendant lighting, shallow bowl pendant, shallow bowl factory reflector, utility lighting, warehouse light, retail store lighting	Inspired by vintage pendant lighting, the Dominion showcases an artisan hand-spun shallow bowl shade and durable stem mount.	dominion, BLE-S-SBD12, BLE-S-SBD14, BLE-S-SBD16, BLE-S-SBD, shallow bowl pendant, stem mount pendant, stem mount light, benjamin dominion, dominion stem, dominion pendant, shallow stem, flat stem, shallow, flat, stem dominion, new listing, new dominion, new rlm, dominion, district, District Stem Light, district, shallow bowl, pendant, BLE-S-SBD12, stem mount pendant, BLE-S-SBD12-PC, BLE-S-SBD14-PC, BLE-S-SBD16-PC, BLE-S-SBD12, BLE-S-SBD14, BLE-S-SBD16, Outdoor farm light, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, SPS-0152, SPS0152, SPS0152, Dominion Series, Dominion Collection, The Dominion Series, The Dominion Collection, stems, Stem pendant lights, stem light mount, stem light mounts, stem, pastel, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, exterior ceiling mount light, exterior ceiling mount lights, exterior ceiling mount lighting, exterior ceiling mount light fixture, exterior ceiling mount light fixtures, exterior ceiling mount lighting fixture, exterior ceiling mount lighting fixtures, exterior ceiling mount, exterior ceiling mounts, exterior ceiling mount fixture, exterior ceiling mount fixtures, Ceiling mount exterior light, Ceiling mount exterior lights, Ceiling mount exterior lighting, Ceiling mount exterior light fixture, Ceiling mount exterior light fixtures, Ceiling mount exterior lighting fixture, Ceiling mount exterior lighting fixtures, 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, jadeite, jadite, jadeite light, jadite light, bowl shallow, H-15512, H-15514, H-15516, shallow dome warehouse shade, shallow dome warehouse stem mount,
64761	gas station lighting, exterior pendant light, shallow shade ceiling light, yard light, gas station light, outdoor light,	The Marathon's shallow bowl shade and durable stem mount is ideal for outdoor ceiling lighting and interior spaces! Customizable and handcrafted!	benjamin marathon, gas station light, benjamin marathon, marathon stem mount, marathon pendant, BLE-G-YDM, BLE-S-YDM12, BLE-S-YDM14, BLE-S-YDM16, marathon, marathon stem, shallow pendant, shallow, new listing, new rlm, new marathon, Maritime stem mount, Maritime Pendant, Maritime Ceiling light, stem mount Yard Light, Yard Light Pendant, Shallow bowl stem mount, shallow bowl pendant, The Maritime Shallow Bowl Stem Mount Pendant, BLE-S-YDM-PC, YDM12-PC, BLE-S-YDM14-PC, BLE-S-YDM16-PC, BLE-S-YDM12, BLE-S-YDM14, BLE-S-YDM16, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, marathon series, marathon collection, the marathon series, the marathon collection, SPS-0109, SPS 0109, SPS0109, stems, Stem pendant lights, stem light mount, stem light mounts, stem, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, exterior ceiling mount light, exterior ceiling mount lights, exterior ceiling mount lighting, exterior ceiling mount light fixture, exterior ceiling mount light fixtures, exterior ceiling mount lighting fixture, exterior ceiling mount lighting fixtures, exterior ceiling mount, exterior ceiling mounts, exterior ceiling mount fixture, exterior ceiling mount fixtures, Ceiling mount exterior light, Ceiling mount exterior lights, Ceiling mount exterior lighting, Ceiling mount exterior light fixture, Ceiling mount exterior light fixtures, Ceiling mount exterior lighting fixture, Ceiling mount exterior lighting fixtures, jadeite, jadite, jadeite light, jadite light, bowl shallow,
64769	hanging barn lamp, single chain pendant light, swag light, industrial chain pendant light	Add industrial flair to swag lighting with this Steber Chain Pendant! This single chain pendant light features a fully customizable shallow bowl shade.	Steber Sinclair Draftsman Chain Hung Pendant Light, BLE-C-SBS-HEX-CN36, chain hung, chain hung barn light, steber, steber chain hung, chain hung sinclair, chain hung draftsman, sinclair chain hung, steber sinclair draftsman, sinclair draftsman, BLE-C-SBS10-HEX-CN36, BLE-C-SBS12-HEX-CN36, BLE-C-SBS14-HEX-CN36, BLE-C-SBS16-HEX-CN36, sinclair, sinclair chain, shallow chain pendant, shallow bowl chain, flat chain pendant, flat chain, new listing, new sinclair, new rlm, Skylark Shallow Bowl Chain Hung Pendant, BLE-C-SBS-HEX-PC-CN36, skylark chain, chain hung skylark, sinclair chain hung, chain hung sinclair, skylark, shallow bowl chain, chain hung shallow bowl, chain hung shallow bowl, BLE-C-SBS10-HEX-PC-CN36, BLE-C-SBS12-HEX-PC-CN36, BLE-C-SBS14-HEX-PC-CN36, BLE-C-SBS16-HEX-PC-CN36, BLE-CN-SBS10, BLE-CN-SBS12, BLE-CN-SBS14, BLE-CN-SBS16, Sinclaire, SPS-0155, SPS0155, SPS 0155, Sinclair Series, Sinclair Collection, The Sinclair Series, The Sinclair Collection, jadeite, jadite, jadeite light, jadite light, bowl shallow,
64988		Versatile, stylish, and efficient. This USA-made and fully customizable stem mount pendant includes the latest LED technology and an array of unique finish options.	BLE-S-SBS-LED, Benjamin® Sinclair LED Stem Mount Pendant, Benjamin Sinclair LED Stem Mount Pendant, Sinclair LED stem mount pendant, Sinclair LED stem mount pendant light, Sinclair LED stem mount pendant lights, Sinclair LED stem mount pendant lighting, Sinclair LED stem mount light, Sinclair LED stem mount lights, Sinclair led stem mount lighting, Led stem mount, LED stem mounts, LED stem mount lights, led stem mount lighting, LED stem light, LED stem lights, LED stem 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 stem mount, Sinclair stem mounts, LED ceiling light, led ceiling lights, led ceiling lighting, LED sinclair, Sinclair LED, BLE-S-SBS-LED, Skylark LED stem mount pendant, Skylark LED stem mount pendant light, Skylark LED stem mount pendant lights, Skylark LED stem mount pendant lighting, Skylark LED stem mount light, Skylark LED stem mount lights, Skylark led stem mount lighting, Led stem mount, LED stem mounts, LED stem mount lights, led stem mount lighting, LED stem light, LED stem lights, LED stem lighting, Skylark LED Pendant Lights, Skylark LED Pendant Lighting, Skylark LED Light, Skylark LED Lights, Skylark LED Lighting, Skylark LED pendant, Skylark LED pendants, LED pendant, LED pendants, LED pendant light, LED pendant lights, LED pendant lighting, Skylark stem mount, Skylark stem mounts, LED ceiling light, led ceiling lights, led ceiling lighting, The Skylark LED Stem Mount Pendant, The Skylark LED Stem Mount Pendants, The Skylark LED Stem Mount Pendant Light, The Skylark LED Stem Mount Pendant Lights, The Skylark LED Stem Mount Pendant Lighting, BLE-S-SBS10, BLE-S-SBS12, BLE-S-SBS14, BLE-S-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, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants,