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 (64616, 64617, 64615, 64614) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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 (64616,64617,64615,64614) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
64614 Partnering beautiful aesthetics and cutting-edge technology, this LED light bulb brings a decorative character and energy efficiency to homes and businesses! 28VORN-I-2W-2200K-E26-T-120V, Voronoi I LED Tala Lamp, Voronoi I LED Tala Lamps, The Voronoi I LED Tala Lamp, The Voronoi I LED Tala Lamps, Voronoi I LED Tala Bulb, Voronoi I LED Tala Light Bulb, Voronoi I LED Tala Light Bulbs, Tala Lamps, Tala Light Bulb, Tala Bulbs, Tala Light Bulbs, Voronoi, Voronoi Light Bulb, Voronoi Light Bulbs, Voronoi Bulb, Voronoi LED Bulb, Voronoi LED Bulbs, Voronoi LED Light Bulb, Voronoi LED Light Bulbs, Voronoi, Voronoi I, LED Bulb, LED Bulbs, LED Light Bulb, LED Light Bulbs, Tala Lamp, Tala Lamps, tala, decorative bulb, decorative bulbs, decorative light bulb, decorative light bulbs, decorative lighting bulb, decorative lighting bulbs, decorative led bulb, decorative led bulbs, decorative led light bulb, decorative led light bulbs, decorative led lighting bulb, decorative led lighting bulbs, led decorative bulb, led decorative bulbs, led decorative light bulb, led decorative light bulbs, led decorative lighting bulb, led decorative lighting bulbs, stylish bulb, stylish bulbs, stylish light bulb, stylish light bulbs, stylish lighting bulb, stylish lighting bulbs, stylish led bulb, stylish led bulbs, stylish led light bulbs, stylish led lighting bulb, stylish led lighting bulbs, led stylish bulb, led stylish bulbs, led stylish light bulb, led stylish light bulbs, led stylish lighting bulb, globe tala,
64615 Elevated aesthetics for an LED light bulb! This bulb offers a decorative touch and reduces energy consumption! Transform your décor with this unique light bulb! 28VORN-II-3W-2200K-E26-T-120V, Voronoi II LED Tala Lamp, Voronoi II LED Tala Lamps, The Voronoi II LED Tala Lamp, The Voronoi II LED Tala Lamps, Voronoi II LED Tala Bulb, Voronoi II LED Tala Bulbs, Voronoi II Tala LED Light Bulbs, Voronoi II Tala LED Light Bulb, Voronoi II Tala Bulb, Voronoi II Tala Bulbs, Voronoi II LED Bulb, Voronoi II LED Bulbs, Voronoi II LED Light Bulb, Voronoi II LED Light Bulbs, Voronoi II, Voronoi, Voronoi II Light Bulb, Voronoi II Light Bulbs, Voronoi Light Bulb, Voronoi Light Bulbs, Voronoi II LED Light Bulb, Voronoi II LED Light Bulbs, LED Bulb, LED bulbs, LED Light Bulb, LED Light Bulbs, Voronoi II Lamp, Voronoi II Lamps, Voronoi II LED Lamp, Voronoi II LED Lamps, Tala Lamp, Tala Lamps, tala, decorative bulb, decorative bulbs, decorative light bulb, decorative light bulbs, decorative lighting bulb, decorative lighting bulbs, decorative led bulb, decorative led bulbs, decorative led light bulb, decorative led light bulbs, decorative led lighting bulb, decorative led lighting bulbs, led decorative bulb, led decorative bulbs, led decorative light bulb, led decorative light bulbs, led decorative lighting bulb, led decorative lighting bulbs, stylish bulb, stylish bulbs, stylish light bulb, stylish light bulbs, stylish lighting bulb, stylish lighting bulbs, stylish led bulb, stylish led bulbs, stylish led light bulbs, stylish led lighting bulb, stylish led lighting bulbs, led stylish bulb, led stylish bulbs, led stylish light bulb, led stylish light bulbs, led stylish lighting bulb,
64616 An elevated LED light bulb design! This LED bulb functions as an accent piece and reduces electricity consumption! Save money and elevate a décor with this bulb! 28ENNO-6W-2700K-E26-MP-120V, Enno LED Tala Lamp, Enno LED Tala Lamps, Enno LED Tala Bulb, Enno LED Tala Bulbs, Enno LED Tala Light Bulbs, Enno LED Tala Light Bulb, Enno LED Bulb, Enno LED bulbs, Enno LED Light Bulb, Enno LED Light Bulbs, Enno, Enno Lamp, Tala LED Bulb, Tala Bulb, Tala Bulbs, Tala LED bulbs, Tala LED Light Bulb, Tala LED Light Bulbs, LED bulb, LED bulbs, LED Light Bulb, LED Light Bulbs, Tala, decorative bulb, decorative bulbs, decorative light bulb, decorative light bulbs, decorative lighting bulb, decorative lighting bulbs, decorative led bulb, decorative led bulbs, decorative led light bulb, decorative led light bulbs, decorative led lighting bulb, decorative led lighting bulbs, led decorative bulb, led decorative bulbs, led decorative light bulb, led decorative light bulbs, led decorative lighting bulb, led decorative lighting bulbs, stylish bulb, stylish bulbs, stylish light bulb, stylish light bulbs, stylish lighting bulb, stylish lighting bulbs, stylish led bulb, stylish led bulbs, stylish led light bulbs, stylish led lighting bulb, stylish led lighting bulbs, led stylish bulb, led stylish bulbs, led stylish light bulb, led stylish light bulbs, led stylish lighting bulb,
64617 Eye-catching LED Light Bulbs! This LED bulb features a fashionable aesthetic and energy efficient design! Budget conscious and environmentally friendly! 28OBLO-6W-2700K-E26-MP-120V, Oblo LED Tala Lamp, Oblo LED Tala Lamps, The Oblo LED Tala Lamp, The Oblo LED Tala Lamps, Oblo LED Tala Bulb, Oblo LED Tala Bulbs, Oblo LED Tala Light Bulb, Oblo LED Tala Light Bulbs, Oblo LED Bulb, Oblo LED Bulbs, Oblo LED Light Bulb, Oblo LED Light Bulbs, Oblo Bulb, Oblo Bulbs, Oblo, LED bulb, LED bulbs, LED Light Bulb, LED Light Bulbs, Tala, Tala Bulb, Tala Bulbs, Tala LED Bulb, Tala LED Bulbs, Tala LED Light Bulb, Tala LED Light Bulbs, tala, decorative bulb, decorative bulbs, decorative light bulb, decorative light bulbs, decorative lighting bulb, decorative lighting bulbs, decorative led bulb, decorative led bulbs, decorative led light bulb, decorative led light bulbs, decorative led lighting bulb, decorative led lighting bulbs, led decorative bulb, led decorative bulbs, led decorative light bulb, led decorative light bulbs, led decorative lighting bulb, led decorative lighting bulbs, stylish bulb, stylish bulbs, stylish light bulb, stylish light bulbs, stylish lighting bulb, stylish lighting bulbs, stylish led bulb, stylish led bulbs, stylish led light bulbs, stylish led lighting bulb, stylish led lighting bulbs, led stylish bulb, led stylish bulbs, led stylish light bulb, led stylish light bulbs, led stylish lighting bulb,