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 (64919, 64821, 64725, 64689) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

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 (64919,64821,64725,64689) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
64689 Our Chicken Wire Stem Mount Pendant Light offers a unique focal point to homes and businesses! Choose a vivid finish color and revamp your décor today! new listing, chicken stem, chicken pendant, chicken wire, BLE-S-EIO, Chicken Wire Stem Mount Pendant Light, Chicken Wire Stem Mount Pendant Lights, Chicken Wire Stem Mount Pendant Lighting, Chicken Wire Stem Pendant, Chicken Wire Stem Pendants, Chicken Wire Stem Pendant Light, Chicken Wire Stem Pendant Lights, Chicken Wire Stem Ceiling Pendant, Chicken Wire Stem Ceiling Pendants, Chicken Wire Stem, Chicken Wire, Chickenwire, Chicken Wire Pendant, Chicken Wire Pendants, Chicken Wire stem pendant, Chicken Wire stem Pendants, Chicken Wire stem Pendant Light, Chicken Wire stem, Chicken Wire stem Pendant Lights, Chicken Wire stem Pendant Lighting, BLE-C-EIO, Chicken Wire Ceiling Pendant, Chicken Wire Ceiling Pendants, Chicken Wire Ceiling Light, Chicken Wire Ceiling Lights, Chicken Wire Ceiling Lighting, Farmhouse, Farmhouse Lighting, chicken wire light, chicken wire lights, chicken wire lighting, chicken wire collection, chicken wire series, SPS-0451, SPS 0451, SPS0451, stems, Stem pendant lights, stem light mount, stem light mounts, stem, basket, chicken wire basket, basket light,
64725 pendant lighting with chain, chain hung deep bowl light, hanging pendant lamp, factory warehouse pendant light, BLE-C-DBW-CN36 For an eye-catching focal point, install the fully customizable Wilcox Chain Hung Pendant. This chain hung light features a vintage-inspired deep bowl shade! Steber Wilcox Deep Bowl Chain Hung Pendant Light, BLE-C-DBW-CN36, chain hung, chain hung barn light, steber, steber chain hung, wilcox chain hung, steber wilcox, BLE-C-DBW10-CN36, BLE-C-DBW12-CN36, BLE-C-DBW14-CN36, BLE-C-DBW16-CN36, wilcox chain, new listing, new rlm, new wilcox, BLE-C-DBW-PC-CN36, Wesco Deep Bowl Chain Hung Pendant, chain hung, deep bowl, wesco chain hung, chain hung wesco, deep bowl chain, wesco chain, Wesco, Wesco Pendant, Wesco Pendants, Wesco Pendant Light, Wesco Pendant Lights, Wesco Pendant Lighting, Wesco Chain, Wesco Chain Light, Wesco Chain Lights, Wesco Chain Lighting, BLE-CN-DBW16, BLE-CN-DBW20, BLE-CN-DBW8, BLE-CN-DBW10, BLE-CN-DBW12, BLE-CN-DBW14, willcox chain, willcox, Wilcox series, SPS-0158, SPS 0158, SPS0158, Wilcox Series, Wilcox Collection, The Wilcox Series, The Wilcox Collection, Wilcox deep bowl series, wilcox deep bowl collection, the wilcox deep bowl series, the wilcox deep bowl collection, deep bowl series, deep bowl collection, wilcox deep bowl, deep bowl wilcox, wilcox dbw, Wilcox shade, Wilcox shades, Chain barn light, Chain barn lights, Chain barn lighting, The Wesco pendant, Wesco pendant, The Wesco pendants, Wesco pendants, 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, wilcox bowl, jadeite, jadite, jadeite light, jadite light, H-16008, H-16110, H-16112, H-16114, H-16116, H-16118, H-17124, classic deep bowl shade,
64821 Hand-crafted, customizable, and American made! This deep bowl modern pendant light adds a contemporary style to homes and businesses! loma, locke, BLE-C-DBL-PC, The Loma Pendant, The Loma Pendants, The Loma Pendant light, The Loma Pendant Lights, The Loma Pendant Lighting, The Loma Ceiling Pendant, The Loma Ceiling Pendants, The Loma Ceiling Light, The Loma Ceiling Lights, The Loma Ceiling Lighting, Loma Pendant, Loma Pendants, Loma Pendant light, Loma Pendant Lights, Loma Pendant Lighting, Loma Ceiling Pendant, Loma Ceiling Pendants, Loma Ceiling Light, Loma Ceiling Lights, Loma Ceiling Lighting, Loma, The Loma, The Loma Cord Hung Pendant, The Loma Cord Hung Pendants, The Loma Cord Hung Pendant light, The Loma Cord Hung Pendant Lights, The Loma Cord Hung Pendant Lighting, The Loma Cord Hung Ceiling Pendant, The Loma Cord Hung Ceiling Pendants, The Loma Cord Hung Ceiling Light, The Loma Cord Hung Ceiling Lights, The Loma Cord Hung Ceiling Lighting, Loma Cord Hung Pendant, Loma Cord Hung Pendants, Loma Cord Hung Pendant light, Loma Cord Hung Pendant Lights, Loma Cord Hung Pendant Lighting, Loma Cord Hung Ceiling Pendant, Loma Cord Hung Ceiling Pendants, Loma Cord Hung Ceiling Light, Loma Cord Hung Ceiling Lights, Loma Cord Hung Ceiling Lighting, The Loma Cord Pendant, The Loma Cord Pendants, The Loma Cord Pendant light, The Loma Cord Pendant Lights, The Loma Cord Pendant Lighting, The Loma Cord Ceiling Pendant, The Loma Cord Ceiling Pendants, The Loma Cord Ceiling Light, The Loma Cord Ceiling Lights, The Loma Cord Ceiling Lighting, Loma Cord Pendant, Loma Cord Pendants, Loma Cord Pendant light, Loma Cord Pendant Lights, Loma Cord Pendant Lighting, Loma Cord Ceiling Pendant, Loma Cord Ceiling Pendants, Loma Cord Ceiling Light, Loma Cord Ceiling Lights, Loma Cord Ceiling Lighting, hemisphere lighting, hemisphere light, hemisphere pendant, hemisphere, hemisphere fixture, hemisphere cord light, hemisphere cord pendant, hemisphere cord, loma deep bowl, new listing, new rlm, new loma, locke, loma, The Lock Pendant, The Lock Pendants, The Lock Pendant light, The Lock Pendant Lights, The Lock Pendant Lighting, Lock Pendant, Lock Pendants, Lock Pendant light, Lock Pendant Lights, Lock Pendant Lighting, The Lock Cord Hung Pendant, The Lock Cord Hung Pendants, The Lock Cord Hung Pendant light, The Lock Cord Hung Pendant Lights, The Lock Cord Hung Pendant Lighting, Lock Cord Hung Pendant, Lock Cord Hung Pendants, Lock Cord Hung Pendant light, Lock Cord Hung Pendant Lights, Lock Cord Hung Pendant Lighting, The Lock Cord Hung Pendant light, The Lock Cord Hung Lights, The Lock Cord Hung Lighting, Lock Cord Hung Pendant light, Lock Cord Hung Lights, Lock Cord Hung Lighting, The Lock Cord Pendant light, The Lock Cord Lights, The Lock Cord Lighting, Lock Cord Pendant light, Lock Cord Lights, Lock Cord Lighting, The Lock Ceiling Pendant, The Lock Ceiling Pendants, Lock Ceiling Pendant, Lock Ceiling Pendants, The Lock Ceiling Light, The Lock Ceiling Lights, The Lock Ceiling Lighting, Lock Ceiling Light, Lock Ceiling Lights, Lock Ceiling Lighting, Lock, The Lock, The Locke Pendant, The Locke Pendants, The Locke Pendant light, The Locke Pendant Lights, The Locke Pendant Lighting, Locke Pendant, Locke Pendants, Locke Pendant light, Locke Pendant Lights, Locke Pendant Lighting, The Locke Cord Hung Pendant, The Locke Cord Hung Pendants, The Locke Cord Hung Pendant light, The Locke Cord Hung Pendant Lights, The Locke Cord Hung Pendant Lighting, Locke Cord Hung Pendant, Locke Cord Hung Pendants, Locke Cord Hung Pendant light, Locke Cord Hung Pendant Lights, Locke Cord Hung Pendant Lighting, The Locke Cord Hung Pendant light, The Locke Cord Hung Lights, The Locke Cord Hung Lighting, Locke Cord Hung Pendant light, Locke Cord Hung Lights, Locke Cord Hung Lighting, The Locke Cord Pendant light, The Locke Cord Lights, The Locke Cord Lighting, Locke Cord Pendant light, Locke Cord Lights, Locke Cord Lighting, The Locke Ceiling Pendant, The Locke Ceiling Pendants, Locke Ceiling Pendant, Locke Ceiling Pendants, The Locke Ceiling Light, The Locke Ceiling Lights, The Locke Ceiling Lighting, Locke Ceiling Light, Locke Ceiling Lights, Locke Ceiling Lighting, Locke, The Locke, BLE-C-DBL, BLE-C-DBL12, BLE-C-DBL16, BLE-C-DBL20, Dome, dome light, dome lights, dome lighting, Dome shade, dome shades, loma dome shade, loma dome shades, loma dome light shade, loma dome light shades, dome light fixture, dome light fixtures, dome lighting fixture, dome lighting fixtures, dome shade lighting, dome shade lights, dome shade light, dome shade light fixture, dome shade light fixtures, Loma dome light fixture, Loma dome light fixtures, Loma dome lighting fixture, Loma dome lighting fixtures, Loma dome shade lighting, Loma dome shade lights, Loma dome shade light, Loma dome shade light fixture, Loma dome shade light fixtures, BLE-C-DBL, Lima, loma+pendant, loma deep bowl, locke loma deep bowl, locke & loma, lima pendant, lima pendants, loma deep bowl pendant, loma deep bowl pendants, ble-dbl, ble--dbl, dbl, dome pendant light 12", Loma Collection, Loma Series, The Loma Collection, The Loma Series, SPS-0013, SPS 0013, SPS0013, teal, 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, cord loma, jadeite, jadite, jadeite light, jadite light, lomas, H-26112, H-26116, hemisphere, hemisphere collection,
64919 Stylish and fashionable, the Loma embraces the latest trends and cutting-edge LED technology! Customize this look with your favorite combination of colors! locke, loma, BLE-S-DBL-LED, Locke LED Stem Mount Light, Locke LED Stem Mount Lights, Locke LED Stem Mount Lighting, Locke, Lock, Locke LED, Lock LED, hemisphere lighting, hemisphere light, hemisphere pendant, hemisphere, hemisphere fixture, hemisphere stem light, hemisphere stem pendant, hemisphere stem,dome light, led dome light, loma, locke, BLE-S-DBL-LED, The Loma LED Stem Mount Light, The Loma LED Stem Mount Lights, The Loma LED Stem Mount Lighting, Loma LED Stem Mount Light, Loma LED Stem Mount Lights, Loma LED Stem Mount Lighting, Loma LED Stem Light, Loma LED Stem Lights, Loma LED Stem Lighting, Loma LED, Loma, hemisphere lighting, hemisphere light, hemisphere pendant, hemisphere, hemisphere fixture, hemisphere stem pendant, hemisphere stem light, hemisphere stem, Locke LED, BLE-S-DBL20, BLE-S-DBL16, BLE-S-DBL12, Dome, dome light, dome lights, dome lighting, Dome shade, dome shades, loma dome shade, loma dome shades, loma dome light shade, loma dome light shades, dome light fixture, dome light fixtures, dome lighting fixture, dome lighting fixtures, dome shade lighting, dome shade lights, dome shade light, dome shade light fixture, dome shade light fixtures, Loma dome light fixture, Loma dome light fixtures, Loma dome lighting fixture, Loma dome lighting fixtures, Loma dome shade lighting, Loma dome shade lights, Loma dome shade light, Loma dome shade light fixture, Loma dome shade light fixtures, Led Dome, led dome light, led dome lights, led dome lighting, led Dome shade, led dome shades, led loma dome shade, led loma dome shades, led loma dome light shade, led loma dome light shades, led dome light fixture, led dome light fixtures, led dome lighting fixture, led dome lighting fixtures, led dome shade lighting, led dome shade lights, led dome shade light, led dome shade light fixture, led dome shade light fixtures, Led Loma dome light fixture, led Loma dome light fixtures, led Loma dome lighting fixture, led Loma dome lighting fixtures, led Loma dome shade lighting, led Loma dome shade lights, led Loma dome shade light, led Loma dome shade light fixture, led Loma dome shade light fixtures, Dome LED, dome LED light, dome LED lights, dome LED lighting, Dome LED shade, dome LED shades, loma led dome shade, loma led dome shades, loma led dome light shade, loma led dome light shades, dome led light fixture, dome led light fixtures, dome led lighting fixture, dome led lighting fixtures, dome led shade lighting, dome led shade lights, dome led shade light, dome led shade light fixture, dome led shade light fixtures, Loma led dome light fixture, Loma led dome light fixtures, Loma led dome lighting fixture, Loma led dome lighting fixtures, Loma led dome shade lighting, Loma led dome shade lights, Loma led dome shade light, Loma led dome shade light fixture, Loma led dome shade light fixtures, Lima, loma+pendant, loma deep bowl, locke loma deep bowl, locke & loma, lima pendant, lima pendants, loma deep bowl pendant, loma deep bowl pendants, ble-dbl, ble--dbl, dbl, Loma LED Series, Loma LED Collection, The Loma LED Series, The Loma LED Collection, SPS0506, SPS 0506, SPS-0506, lomas, H-26112, H-26116, hemisphere, hemisphere collection,