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 (60601, 64726, 60825, 60659) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00055

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 (60601,64726,60825,60659) 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,
60659 studio pendant light, retro ceiling light, barn light swag light, warehouse shade pendant, artistic pendant lighting, designer swag light, industrial barn light, decorative cord pendant light, unique pendant lighting Customize your pendant lighting with our beautiful Dino Studio Light! This decorative ceiling light adds retro flair to any space! Dino Studio Light Studio Light, studio lighting, aircraft cable lights, Dino pendant, Dino ceiling light, Cable pendant, wavy cord, swag light, BLE-C-STU-WHD, BLE-C-STU-WHD14, BLE-C-STU-WHD12, dino studio, cable pendant, wire pendant, dino, Studio light, studio cable, studio cable light, studio cable pendant, studio cable lights, studio pendant cable, studio, cable, studio wire, studio wire pendant, dino, BLE-C-STU-WHD12, BLE-C-STU-WHD14, SPS-0362, SPS 0362, SPS0362, jadeite, jadite, jadeite light, jadite light,
60825 decorative studio ighting, cable pendant light, modern ceiling light, designer swag light, wavy cord pendant light, office ceiling lighting, decorative cord and cable light fixture, barn light with decorative cord Elevate any space with the Marathon Studio Light! Its adjustable wavy cord and numerous finishes are perfect for homes or offices! Marathon Studio Light, Marathon, Studio Light, Marathon pendant, Marathon Ceiling light, Cable pendant, wavy cord, swag light, BLE-C-STU-YDM, BLE-C-STU-YDM12, BLE-C-STU-YDM14, BLE-C-STU-YDM16, marathon studio, Studio light, studio cable, studio cable light, studio cable pendant, studio cable lights, studio pendant cable, jadeite, jadite, jadeite light, jadite light, studio, cable, studio wire, studio wire pendant, studio wire light, studio wire pendant light, wire pendant, wire pendant light, wire cable light, BLE-C-STU-YDM12, BLE-C-STU-YDM14, BLE-C-STU-YDM16, SPS-0363, SPS 0363, SPS0363, marathon series, marathon collection, the marathon series, the marathon collection,
64726 deep bowl pendant lighting, deep bowl shade, deep bowl warehouse shade, The beauty of deep bowl shade as durable cord hung lighting! Based on original 1940s deep bowl warehouse shades, customize this pendant's cord mount, finish and accessories. wesco, Wesco lighting, Wesco deep bowl cord hung light, pendant lighting, deep bowl, cord hung, pendant, BLE-C-DBW-PC, BLE-C-DBW8-PC, BLE-C-DBW10-PC, BLE-C-DBW12-PC, BLE-C-DBW14-PC, BLE-C-DBW16-PC, Wesco Pendant, new listing, new wilcox, new rlm, ivanhoe wilcox, BLE-C-DBW8, BLE-C-DBW10, BLE-C-DBW12, BLE-C-DBW14, BLE-C-DBW16, BLE-C-DBW, wilcox, deep bowl, deep bowl pendant, wilcox pendant, bowl pendant, wilcox cord hung, wilcox cord mount, wilcox deep bowl, Madrid Modern Cord Hung Pendant, Mini Deep Bowl Pendant, BLE-C-DBW8, madrid, mini pendant, modern pendant, modern cord hung, Madrid Pendant, Madrid Pendant Light, Madrid Pendant Lights, Madrid Pendant Lighting, Madrid ceiling pendant, Madrid Ceiling Pendants, wilcox cord hung pendant, wilcox cord hung pendant light, BLE-C-DBW8, BLE-C-DBW10, BLE-C-DBW12, BLE-C-DBW14, willcox, willcox cord, 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, The Wesco pendant, Wesco pendant, The Wesco pendants, Wesco pendants, 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, outdoor pendent, outdoor pendents, outdoor pendent light, outdoor pendent lights, outdoor pendent lighting, outdoor ceiling pendent, outdoor ceiling pendents, wilcox bowl, wesco cord, wilcox cord pendant, jadeite, jadite, jadeite light, jadite, H-16008, H-16110, H-16112, H-16114, H-16116, H-16118, H-17124, classic deep bowl shade, classic deep bowl shade cord-hung pendant,