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 (62449, 62622, 61517, 62358) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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 (62449,62622,61517,62358) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61517	wire guard warehouse shade pendant light, industrial guard shade pendant, wire guard ceiling light, caged pendant light	The Blue Collar pendant shows off industrial styling with its wire cage guard silhouette. This caged pendant light is ideal for kitchen lighting and bright task lighting!	Blue Collar Pendant, BLE-C-WGGWS, wire guard warehouse shade, wire guard shade, wire guard pendant, cage light, BLE-C-WGGWS12, BLE-C-WGGWS14, BLE-C-WGGWS16, caged pendant, caged pendant light, caged light, blue collar wire guard, blue collar warehouse shade, blue collar pendant, blue collar caged pendant, blue collar cage pendant, blue collar wire cage pendant, blue collar wire cage guard pendant, blue collar cage light, blue collar wire cage light, blue collar, blue collar cord hung, blue collar cord hung pendant, blue collar ceiling light, wire cage ceiling light, blue collar wire cage ceiling light, cord hung cage light, cage light, cage guard light, wire guard cage, wire guard light, blue collar wire guard, new listing, BLE-C-WGGWS12, BLE-C-WGGWS14, BLE-C-WGGWS16, blue collar collection, blue collar series, the blue collar collection, the blue collar series, SPS-0054, SPS 0054, SPS0054, 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,
62358	custom led pendant light, industrial led pendant, led pendant lighting, industrial guard pendant	Vintage and modern, this industrial LED pendant light features a timeless style and the latest technology! Durable and fully customizable, elevate any project with this ceiling light!	Industrial Guard LED Cord Hung Pendant, BLE-C-CGGFS-PC-LED, cgg led, tgg led, cast guard and glass led, cast guard and glass pendant led, led pendant, led cord mount, vapor jar pendant, vaporjar pendant led, led vaporjar pendant, industrial led pendant, rustic led pendant, rustic pendant led, led rustic pendant, industrial lighting, industrial pendant, led cord light, led cord hung lighting, LED industrial pendant, Industrial LED light, Industrial LED pendant, Industrial Guard LED Pendant Light, industrial guard pendant, industrial guard pendants, industrial guard pendant light, industrial guard pendant lighting, industrial guard light, industrial guard fixture, led industrial guard fixture, guard fixture, guard led fixture, cage fixture, cage pendant, cage ceiling pendant, industrial guard cord hung pendant, industrial guard cord hung pendant light, Rugged guard LED light, rugged guard LED lights, rugged guard LED lighting, rugged guard LED light fixture, rugged guard LED lighting fixture, rugged guard LED light fixtures, rugged guard LED lighting fixtures, rugged guard LED pendant, rugged guard LED pendant lights, rugged guard LED ceiling pendant, rugged guard LED ceiling pendants, rugged guard LED ceiling light, rugged guard LED ceiling lights, rugged guard LED ceiling lighting, LED rugged guard pendant, LED rugged guard pendant lights, LED rugged guard ceiling pendant, LED rugged guard ceiling pendants, LED rugged guard ceiling light, LED rugged guard ceiling lights, LED rugged guard ceiling lighting, SPS-0409, SPS 0409, SPS0409, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, Industrial guard led cord pendant, Industrial guard led cord pendants, ble-c-gg
62449	modern industrial pendant, modern kitchen light, modern ring pendant light, kitchen island pendant	The Brewster Pendant boasts a clean-cut, streamline style straight from the Atomic Era with its three-ring pendant design and durable cord mount.	Barn Light Brewster Pendant, Cord Hung, Brewster, Atomic light, rugged pendant, modern pendant, C-10LC, BLE-C-ULBR-PC, kitchen island light, ring pendant, halo pendant, ring pendant light, Pendant island lights, SPS-0034, SPS 0034, SPS0034, Brewster Collection, Brewster Series, The Brewster Collection, The Brewster Series, 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,
62622		This light features rugged guard suspended from a chain mount! Fully customizable with cast guard types and finish colors!	industrial guard chain hung pendant, aluminum cast guard light, vapor proof lighting, vaporproof lighting, vapor tight light, nautical light, industrial guard chain pendant, chain hung pendant lighting, chain lighting, BLE-C-CGGFS-PC-CN36, Industrial Guard Chain Hung Pendant Light, Industrial Chain Hung Pendant Light, Industrial Guard Chain mount Pendant Light, Industrial Guard Chain Mount Pendant, Industrial Guard Chain Pendant Light, Industrial Guard Chain Pendant, Industrial Pendant, Industrial chain pendant, industrial chain pendants, nautical pendant, nautical chain pendant, nautical guard pendant, nautical guard chain pendant, nautical guard pendant light, nautical guard chain pendant light, Rugged guard light, rugged guard lights, rugged guard lighting, rugged guard light fixture, rugged guard lighting fixture, rugged guard light fixtures, rugged guard lighting fixtures, rugged guard pendant, rugged guard pendant lights, rugged guard ceiling pendant, rugged guard ceiling pendants, rugged guard ceiling light, rugged guard ceiling lights, rugged guard ceiling lighting, rugged guard chain, chain rugged guard, rugged guard chain mount, chain mount rugged guard, rugged guard chain pendant, chain pendant rugged guard, SPS-0548, SPS0548, SPS 0548, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, ble-c-gg