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 (60603, 60821, 60601, 60800) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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 (60603,60821,60601,60800) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
60601 swag light kit, cable hung pendant light, swag pendant fixture, art studio light, cable pendant, artistic pendant light, decorative modern pendant, retro modern pendant light, tiered shade pendant Modern styles meet classic lighting in the Union Studio Light! Handcrafted in the USA and fully customizable with marine grade, powder coat and natural metal finishes! union, union studio light, studio light, studio, pendant, BLE-C-STU-WHU, BLE-C-STU-WHU10, BLE-C-STU-WHU12, BLE-C-STU-WHU14, wire pendant, cable pendant, union studio, Studio light, studio cable, studio cable light, studio cable pendant, studio cable lights, studio pendant cable, studio, cable, studio, BLE-C-STU-WHU10, BLE-C-STU-WHU12, BLE-C-STU-WHU14, BLE-C-STU-WHU16, union series, union collection, the union series, the union collection, SPS-0360, SPS 0360, SPS0360, jadeite, jadite, jadeite light, jadite light,
60603 exposed cord pendant light, adjustable pendant light, studio lighting, vintage industrial deep bowl light, retro light fixture This vintage inspired deep bowl fixture is a customizable modern studio light. This adjustable cable light combines cord and cable to create a unique industrial pendant. wilcox pendant lighting, deep bowl lights, studio lighting, aircraft cable lights, deep bowl pendant, BLE-C-STU-DBW10, BLE-C-STU-DBW12, BLE-C-STU-DBW14, BLE-C-STU-DBW16, deep bowl lighting, cable hung lighting, studio light, deep bowl studio light, Ceiling lighting, deep bowl ceiling light, wilcox, wilcox studio, deep bowl, Studio light, studio cable, studio cable light, studio cable pendant, studio cable lights, studio pendant cable, studio, cable, Wilcox Studio Light, Wilcox Studio Pendant, BLE-C-STU-DBW16, BLE-C-STU-DBW20, BLE-C-STU-DBW14, BLE-C-STU-DBW10, BLE-C-STU-DBW12, BLE-C-STU-DBW14, SPS-0356, SPS 0356, SPS0356, 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 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,
60800 decorative mini pendant, cable and cord light, waved cord barn light, decorative cord barn light, stylish office lighting, boutique ceiling light, swag lighting Revamp any space with this handcrafted studio pendant! Fully customizable with various finish options and colorful cords! Esso Studio Light, Esso Pendant, Esso Ceiling light, Studio light, Cable pendant, wavy cord, swag light, BLE-C-STU-WHE, BLE-C-STU-WHE8, BLE-C-STU-WHE10, esso studio, studio light, small pendant, small studio light, esso, Studio light, studio cable, studio cable light, studio cable pendant, studio cable lights, studio pendant cable, studio, cable, arlington, studio wire, esso studio wire, esso studio cable, studio wire light, studio wire lights, studio pendant light, studio cable pendant light, studio wire pendant light, eso, SPS-0359, SPS 0359, SPS0359, esso collection, esso series, the esso collection, the esso series, 10 inch, 10 inch shade, 10" shade, jadeite, jadite, jadeite light, jadite light,
60821 stylish artist studio decor, cable pendant light, radial wave RLM shade, waved reflector shade, classic light, adjustable pendant light, wavy cord light, dining room pendant, decorative office light, pendant light with cable and cord ceiling mount The Seaside Studio Light is a pendant packed with retro flair! Enjoy this artistic pendant's radial wave shade and industrial cable and cord mount! Seaside Radial Wave Studio Light, Seaside Radial Wave, Studio Light, Seaside pendant, Seaside ceiling light, Cable pendant, wavy cord, BLE-C-STU-RWS, BLE-C-STU-RWS12, BLE-C-STU-RWS14, BLE-C-STU-RWS16, seaside studio, radial wave studio, studio pendant, seaside, radial, radial wave, Studio light, studio cable, studio cable, jadeite, jadite, jadeite light, jadite light, light, studio cable pendant, studio cable lights, studio pendant cable, studio, cable, sea, sea side, starfire studio pendant, star fire studio pendant, starfire, star fire, radial wave studio, radial wave studio pendant, radial wave studio light, BLE-C-STU-RWS12, BLE-C-STU-RWS14, BLE-C-STU-RWS16, seaside series, seaside collection, sea side series, sea side collection, the seaside series, the seaside collection, the sea side series, the sea side collection, SPS-0156, SPS0156, SPS 0156, graphite, H-19112, H-19114, H-19116, classic radial shade,