Sandbox

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 (65547, 61558, 65104, 64866) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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 (65547,61558,65104,64866) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61558	flared light heat lamp, commercial food warmer lighting, diner lights, diner pendant fixtures, heating fixture, decorative commercial lighting, american made restaurant lighting, modern restaurant pendant lights, food warmer & heat lamps	The Canal heating lamps features a long cylindrical cone and flared reflector. Paired with a heat lamp bulb, this pendant is perfect for meal preparation!	Hibachi Food Warmer Pendant, food warmer lights, commercial lighting, restaurant lighting, commercial pendant, BLE-C-FW-HIBACHI, foodwarmer, food warming, food warmer, food warmer pendant, food warming pendants, food warmer pendants, food lamp, food light, restaurant heat lamps, food heat lamp, heat lamp, heat lamp pendant, heat lamp pendants, food light, food lighting, restaurant food warmer, restaurant food warming pendant, heat lamp, restaurant heat lamp, SPS0085, SPS 0085, SPS-0085, Canal Collection, The Canal Collection, Canal Series, The Canal Series, heatlamp, warming lights, warming light, warming lighting, warming pendant, warming pendants, warming ceiling pendant, warming ceiling pendants, warming lamp, buffet lamps, food warmers,
64866		Contemporary yet timeless, this uplight pendant incorporates a wooden top into its design. Handcrafted by talented artisans in the USA and fully customizable!	Wilcox Uplight Wooden Top Pendant, Wilcox Uplight Wooden Top Pendant light, Wilcox Wooden Top Pendant, Wilcox Wooden Top Pendant light, Wilcox Uplight Wooden Pendant, Wilcox Uplight Wooden Pendant light, Wilcox Wooden Pendant, Wilcox Wooden Pendant Light, Wilcox Up light Wooden Top Pendant, Wilcox Up light Wooden Top Pendant light, Wilcox Up light Wooden Pendant, Wilcox Up light Wooden Pendant light, Wooden Uplight pendant, Wooden Up Light Pendant, Wooden Uplight Pendant Light, Wooden Up Light Pendant light, Wilcox wooden pendant, wilcox wooden pendant light, wooden top pendant, wooden top pendant light, wooden pendant, wooden pendant light, Wilcox, Wilcox Uplight, Wilcox wooden uplight, Wilcox Up Light, Wilcox wooden up light, wood, Wilcox Uplight Wood Top Pendant, Wilcox Uplight Wood Top Pendant light, Wilcox Wood Top Pendant, Wilcox Wood Top Pendant light, Wilcox Uplight Wood Pendant, Wilcox Uplight Wood Pendant light, Wilcox Wood Pendant, Wilcox Wood Pendant Light, Wilcox Up light Wood Top Pendant, Wilcox Up light Wood Top Pendant light, Wilcox Up light Wood Pendant, Wilcox Up light Wood Pendant light, Wood Uplight pendant, Wood Up Light Pendant, Wood Uplight Pendant Light, Wood Up Light Pendant light, Wilcox wood pendant, wilcox wood pendant light, wood top pendant, wood top pendant light, wood pendant, wood pendant light, Wilcox, Wilcox Uplight, Wilcox wood uplight, Wilcox Up Light, Wilcox wood up light, wooden, BLE-C-WULW, timber, ore, timber and ore, timber & ore, wilcox cord hung pendant, wilcox cord hung pendant light, wilcox cord hung, wilcox cord, BLE-C-WULW20, BLE-C-WULW18, BLE-C-WULW20, Light with wooden top, light with wood top, light with wooden fixture, light with wood fixture, light with wood top, light with wooden top, light with wood, light with wood socket, light with wooden socket, light with wooden sockets, light with wood sockets, wood socket, wooden sockets, wood socket light, wooden socket lights, Pendant with wooden top, pendant with wood top, Pendant with wooden fixture, pendant with wood fixture, pendant with wood top, pendant with wooden top, pendant with wood, pendant with wood socket, pendant with wooden socket, pendant with wooden sockets, pendant with wood sockets, Pendants with wooden top, pendants with wood top, Pendants with wooden fixture, pendants with wood fixture, pendants with wood top, pendants with wooden top, pendants with wood, pendants with wood socket, pendants with wooden socket, pendants with wooden sockets, pendants with wood sockets, BLE-C-WULW14, BLE-C-WULW16, BLE-C-WULW18, BLE-C-WULW20, Wilcox uplight series, wilcox uplight collection, wilcox up light series, wilcox up light collection, wilcox up-light series, wilcox up-light collection, The Wilcox uplight series, the wilcox uplight collection, the wilcox up light series, the wilcox up light collection, the wilcox up-light series, the wilcox up-light collection, SPS-0501, SPS 0501, SPS0501, wooden wesco, wood wesco, wooden wilcox, wood wilcox, wood fixtures, wood fixture, wooden fixtures, wooden fixture, wooden hanging light, wooden hanging lights, wooden hanging lighting, wood hanging light, wood hanging lights, wood hanging lighting, timber ore wilcox, wooden top barn light, wood lights, wood and metal lights, wilcox uplight wooden top pendent, timber ore,
65104		A handcrafted metal shade and lathe-turned wooden top unite in the Brunson’s truly unique design. Transform every space with this eye-catching pendant light.	BLE-C-BRN, Brunson, the brunson, Bruson Cord, Brunson Cord Pendant, Cord Brunson, Bruson Cord Light, brunson wood, wood pendant, wooden pendant, wood cord pendant, wooden cord pendant, Brunson pendant, wood cord pendant, wooden cord pendant, wood cord light, wooden cord light, timber and ore, timber & ore, timber and ore collection, timber & ore collection, wood lighting, wooden lighting, wood light, wooden light, wood cord lighting, wooden cord lighting, Brunson Wooden Top Pendant, Brunson Wooden Top Pendant Light, Brunson Wood Top Pendant, Bruson Wood top, Bruson wooden top, branson, brunsen, Statement light, statement lights, statement lighting, statement light fixture, statement light fixtures, statement lighting fixture, statement lighting fixtures, State ment light, state ment lights, state ment lighting, state ment light fixture, state ment light fixtures, state ment lighting fixture, state ment lighting fixtures, Statement pendant, statement pendants, statement ceiling pendant, statement ceiling pendants, statement pendant light, statement pendant lights, statement pendant lighting, statement ceiling light, statement ceiling lights, statement ceiling lighting, Decorative light, decorative lights, decorative lighting, decorative light fixture, decorative light fixtures, decorative lighting fixture, decorative lighting fixtures, Decorative pendant, decorative pendants, decorative ceiling pendant, decorative ceiling pendants, decorative pendant light, decorative pendant lights, decorative pendant lighting, decorative ceiling light, decorative ceiling lighting, decorative shade, decorative shades, decorative wood shade, decorative wood shades, decorative wood shade, decorative wooden shade, decorative wood shades, decorative wooden shades, Wood accent light, wood accent lights, wood accent lighting, wood accent light fixture, wood accent light fixtures, wood accent lighting fixture, wood accent lighting fixtures, wood accent, wood accents, Wooden accent light, wooden accent lights, wooden accent lighting, wooden accent light fixture, wooden accent light fixtures, wooden accent lighting fixture, wooden accent lighting fixtures, wooden accent, wooden accents, Wood accent pendant, wood accent pendants, wood accent ceiling pendant, wood accent ceiling pendants, wood accent pendant light, wood accent pendant lights, wood accent pendant lighting, wood accent ceiling light, wood accent ceiling lights, wood accent ceiling lighting, timber & ore collection, the timber & ore collection, timber & ore collection, the timber & ore collection, timber and ore collection, the timber and ore collection, timber and ore collection, the timber and ore collection, timber & ore series, the timber & ore series, timber & ore series, the timber & ore series, timber and ore series, the timber and ore series, timber and ore series, the timber and ore series, Brunson Collection, Brunson Series, SPS-0553, SPS 0553, SPS0553, wood fixtures, wood fixture, wooden fixtures, wooden fixture, wooden hanging light, wooden hanging lights, wooden hanging lighting, wood hanging light, wood hanging lights, wood hanging lighting, 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, wooden top rlm, wood and metal, wooden top barn light, wood lights, wood and metal lights, 23NDP1023, timber ore,
65547		Pendant lighting with a wooden top! Timeless yet contemporary, this handcrafted light fixture brings style and character to any space!	BLE-C-MAN, Manhattan Wooden Top Pendant Light, Manhattan Wooden Top Pendant Light, Manhattan Wooden Top Pendant Lights, Manhattan Wooden Top Pendant Lighting, Manhattan Wooden Top Pendant, Manhattan Wooden Top Pendants, Manhattan Wooden Top Ceiling Pendant, Manhattan Wooden Top Ceiling Pendants, Manhattan Wooden Top Ceiling Light, Manhattan Wooden Top Ceiling Lights, Manhattan Wooden Top Ceiling Lighting, Manhattan Wood Top Pendant Light, Manhattan Wood Top Pendant Lights, Manhattan Wood Top Pendant Lighting, Manhattan Wood Top Pendant, Manhattan Wood Top Pendants, Manhattan Wood Top Ceiling Pendant, Manhattan Wood Top Ceiling Pendants, Manhattan Wood Top Ceiling Light, Manhattan Wood Top Ceiling Lights, Manhattan Wood Top Ceiling Lighting, Manhattan Wooden Pendant Light, Manhattan Wooden Pendant Lights, Manhattan Wooden Pendant Lighting, Manhattan Wooden Pendant, Manhattan Wooden Pendants, Manhattan Wooden Ceiling Pendant, Manhattan Wooden Ceiling Pendants, Manhattan Wooden Ceiling Light, Manhattan Wooden Ceiling Lights, Manhattan Wooden Ceiling Lighting, Manhattan Wood Pendant Light, Manhattan Wood Pendant Lights, Manhattan Wood Pendant Lighting, Manhattan Wood Pendant, Manhattan Wood Pendants, Manhattan Wood Ceiling Pendant, Manhattan Wood Ceiling Pendants, Manhattan Wood Ceiling Light, Manhattan Wood Ceiling Lights, Manhattan Wood Ceiling Lighting, Manhattan Pendant Light, Manhattan Pendant Lights, Manhattan Pendant Lighting, Manhattan Pendant, Manhattan Pendants, Manhattan Ceiling Pendant, Manhattan Ceiling Pendants, Manhattan Ceiling Light, Manhattan Ceiling Lights, Manhattan Ceiling Lighting, Manhattan, The Manhattan, 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, wooden top rlm, wood and metal, wooden top barn light, manhatten,