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

Result

product_id	meta_keywords	meta_description	search_words
61428	outdoor hanging lantern pendant, nautical overhead lighting, industrial cast guard pendant, marine lighting, cord hung pendant lantern, jelly jar pendant, industrial kitchen lighting fixture	Presenting a classic nautical charm, this ceiling light brings a bold style to every space! Create a custom look with various finishes, shades, and guards and revamp your home or business!	Industrial Guard Cord Hung Pendant, BLE-C-CGGFS-PC, rustic pendant, maritime pendant, cgu, cgg, tgg, cast guard pendant, cast guard and glass, mini flare shade, cord hung pendant, Atomic Topless Industrial Guard Pendant, Atomic Industrial Guard Cord Hung Pendant, Industrial Guard Cord Hung Pendant, industrial pendant, industrial ceiling pendant, rugged pendant, rugged pendant light, industrial pendant light, rugged ceiling pendant, 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, jelly jar light, jelly jar lights, jelly jar light fixture, jelly jar light fixtures, cgg, cggg, ccg, 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, 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, industrial guard cord pendant, industrial guard cord pendants, industrial guard cord pendant light, industrial guard cord pendant lights, industrial guard cord pendant lighting, industrial guard cord, pendent light, pendent lights, pendent lighting, pendent, ceiling pendent, ceiling pendents, Industrial pendent lighting, Industrial pendent light, Industrial pendent lights, Industrial ceiling pendent, Industrial ceiling pendents, ble-c-gg
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,
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,
62540	ring sconce, industrial wall light, jelly jar light, wall sconce, RGU vented sconce, sconce with rings	This durable, industrial-grade wall light is built to last a lifetime and available in an array of finish colors! Enjoy this light both indoors or outside.	Industrial Static Topless RGU Sconce, BLE-W-RGU-PC, industrial rgu sconce, RGU sconce, rgu sconce, topless rgu sconce, static rgu, static topless rgu, wall sconce, industrial sconce, vented sconce, ring sconce, static ring sconce, static ring wall sconce, static sconce, static sconce light, static ring sconce light, ring sconce, ring wall sconce, ring sconce light, industrial static wall sconce, industrial static ring, industrial static ring wall sconce, ring guard, ring guards, ring guard fixture, ring guard fixtures, ring guard light fixture, ring guard light fixtures, ring, ring fixture, ring fixtures, ring light fixture, ring light fixtures, industrial ring guard, industrial ring guards, ring industrial guard fixtures, ring industrial guard light fixture, industrial ring guard light fixtures, ring industrial guard, ring industrial guards, ring industrial guard fixtures, ring industrial guard light fixture, ring industrial guard light fixtures, ring sconce, ring sconces, ring wall sconce, ring wall sconces, ring wall light, ring wall lights, ring wall lighting, ring sconce light, ring sconce lights, ring sconce lighting, industrial ring guard sconce, industrial ring guard sconces, ring industrial guard wall sconce, ring industrial guard wall sconces, ring industrial guard wall light, ring industrial guard wall lights, ring industrial guard wall lighting, Ring guard sconce, ring guard sconces, ring guard wall sconce, ring guard wall sconces, ring guard sconce light, ring guard sconce lighting, ring guard wall light, ring guard wall lights, ring guard wall lighting, cgg, cggg, ccg, topless industrial guard sconce, Industrial streamline, Stream industrial guard sconce, industrial guard, industrial guard sconce with cage, Industrial vanity lighting, SPS-0412, SPS 0412, SPS0412, static ring collection, static ring series, the static ring collection, the static ring series, static ring guard collection, static ring guard series, the static ring guard collection, the static ring guard series, static guard collection, static guard series, the static guard collection, the static guard series, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces, ble-c-gg, nautical cage sconce,