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 (62449, 62432, 61517, 62060) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00054

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 (62449,62432,61517,62060) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61517 wire guard warehouse shade pendant light, industrial guard shade pendant, wire guard ceiling light, caged pendant light The Blue Collar pendant shows off industrial styling with its wire cage guard silhouette. This caged pendant light is ideal for kitchen lighting and bright task lighting! Blue Collar Pendant, BLE-C-WGGWS, wire guard warehouse shade, wire guard shade, wire guard pendant, cage light, BLE-C-WGGWS12, BLE-C-WGGWS14, BLE-C-WGGWS16, caged pendant, caged pendant light, caged light, blue collar wire guard, blue collar warehouse shade, blue collar pendant, blue collar caged pendant, blue collar cage pendant, blue collar wire cage pendant, blue collar wire cage guard pendant, blue collar cage light, blue collar wire cage light, blue collar, blue collar cord hung, blue collar cord hung pendant, blue collar ceiling light, wire cage ceiling light, blue collar wire cage ceiling light, cord hung cage light, cage light, cage guard light, wire guard cage, wire guard light, blue collar wire guard, new listing, BLE-C-WGGWS12, BLE-C-WGGWS14, BLE-C-WGGWS16, blue collar collection, blue collar series, the blue collar collection, the blue collar series, SPS-0054, SPS 0054, SPS0054, 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,
62060 For custom commercial and residential up lighting, try our vented Astro light! This shallow bowl shade has small vents for added light and industrial edge. vented, vented shade, vintage warehouse, Astro Shallow Bowl Vented Cord Hung Pendant, astro, BLE-C-VSBA-PC, BLE-C-VSBA12-PC, BLE-C-VSBA14-PC, BLE-C-VSBA16-PC, Shallow bowl pendant, cord hung pendant, warehouse shade, vented warehouse shade, vented lighting, astro lighting, astro light, astro shade light, astro ceiling light, vintage inspired lighting, interior lighting, indoor lighting, farmhouse lighting, farmhouse light, astro vented, vented astro, Astro Vented, Vented Astro, BLE-C-VSBA12, BLE-C-VSBA14, BLE-C-VSBA16, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, aero vented series, aero vented collection, SPS-0169, SPS0169, SPS 0169, 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, slotted, slotted light, bowl shallow,
62432 industrial led ceiling light, led light, cord hung led pendant Ideal for industrial LED ceiling lighting, this cord hung pendant features a flared warehouse shade with horizontal vents on the neck that casts LED light up and down. Cherokee LED Uplight Cord Hung Pendant, BLE-C-ULC-PC-LED, led cherokee, led uplight, cord hung led, cherokee led, led cord hung pendant, led barn light, vented led pendant, cherokee led, cherokee cord, cherokee cord hung, cherokee cord pendant, cherokee cord hung pendant, cherokee uplight, cherokee up light, uplight cherokee, up light cherokee, led uplight, led up light, uplight led, up light led, uplight pendant, up light pendant, led uplight pendant, led up light pendant, uplight led pendant, up light led pendant, BLE-C-ULC12, BLE-C-ULC14, BLE-C-ULC16, BLE-C-ULC18, SPS-0161, SPS 0161, SPS0161, cherokee uplight series, cherokee uplight collection, the cherokee uplight series, the cherokee uplight collection, cherokee up light series, cherokee up light collection, the cherokee up light series, the cherokee up light collection, cherokee up-light series, cherokee up-light collection, the cherokee up-light series, the cherokee up-light collection, cherokee series, cherokee collection, the cherokee series, the cherokee collection, The Cherokee led, Cherokee led, cherokee led light, cherokee pendants, slotted, slotted light,
62449 modern industrial pendant, modern kitchen light, modern ring pendant light, kitchen island pendant The Brewster Pendant boasts a clean-cut, streamline style straight from the Atomic Era with its three-ring pendant design and durable cord mount. Barn Light Brewster Pendant, Cord Hung, Brewster, Atomic light, rugged pendant, modern pendant, C-10LC, BLE-C-ULBR-PC, kitchen island light, ring pendant, halo pendant, ring pendant light, Pendant island lights, SPS-0034, SPS 0034, SPS0034, Brewster Collection, Brewster Series, The Brewster Collection, The Brewster Series, 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,