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 (60604, 60799, 60659, 60800) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00038

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 (60604,60799,60659,60800) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
60604 adjustable pendant light, decorative apartment lighting, swag light fixture, swag light, cord and cable pendant, retro industrial light fixture, exposed cord lighting, designer light fixture Modern studio lighting meets our decorative Bomber shade. This adjustable cable light combines cord and cable to create a unique swag pendant light. bomber pendant lighting, studio lighting, aircraft cable lights, pendant lighting, BLE-C-STU-WHB, BLE-C-STU-WHB11, BLE-C-STU-WHB13, BLE-C-STU-WHB15, BLE-C-STU-WHB17, cable pendant, wire pendant, bomber, bomber studio, bomber studio pendant, studio pendant, studio wire, studio wire pendant, studio cable pendant, bomber pendant light, bomber studio pendant light, BLE-C-STU-WHB11, BLE-C-STU-WHB13, BLE-C-STU-WHB15, BLE-C-STU-WHB17, SPS-0358, SPS 0358, SPS0358, bomber series, bomber collection, SPS-0149, SPS0149, SPS 0149, jadeite, jadite, jadeite light, jadite light, H-15111, H-15113, H-15115, H-15117, curved warehouse shade,
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,
60799 deep cone rlm shade, cord and cable pendant light, decorative pendant with reflector shade, classic cord pendant light, adjustable cord lighting, pendant with wavy cord, apartment pendant light, artistic warehouse shade light, steel cone pendant light The Sterling Deep Cone Studio Light is packed with retro flair! Enjoy this artsy pendant's flared cone RLM shade and industrial cable and cord mount! Sterling Deep Cone Reflector Studio Light, Sterling Deep Cone Reflector, Studio Light, Sterling Pendant, Sterling Ceiling light, Cable pendant, wavy cord, BLE-C-STU-DCS, BLE-C-STU-DCS12, BLE-C-STU-DCS14, BLE-C-STU-DCS16, sterling, deep cone, reflector, sterling reflector, deep cone reflector, wire pendant, studio light, sterling studio, sterling studio light, sterling deep cone studio, Studio light, studio cable, studio cable light, studio cable pendant, studio cable lights, studio pendant cable, studio, cable, studio wire pendant, studio wire, studio pendant light, studio cable pendant light, studio wire cable pendant light, BLE-C-STU-DCS12, BLE-C-STU-DCS14, BLE-C-STU-DCS16, SPS-0364, SPS 0364, SPS0364, jadeite, jadite, jadeite light, jadite light,
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,