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 (61525, 61529, 61526, 61528) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00052

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 (61525,61529,61526,61528) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61525 cast guard post mount light, industrial yard light, barn yard post mount, cast guard and flare shade post mount light, sidewalk lighting, commercial post mount lighting, marine grade post light, post mount lights Go nautical with the Aero cast guard pole light. With its flared shade and industrial guard this yard light is great for commercial and residential lighting. Astro Industrial Guard Post Mount , BLE-PMS-TGG-SBA, pole mount light, walkway lighting, cast guard pole mounts, astro and cast guard yard light, pole mount, pole light, post light, post mount light, BLE-PMS-TGG-SBA12, BLE-PMS-TGG-SBA14, Industrial post mount lighting, post mount, cast guard post light, post lighting, industrial post mount, industrial post fixture, post fixture, pole fixture, industrial post light, post light, industrial post mount lighting, industrial guard, industrial guard post mount, rugged guard light, rugged post light, rugged pole light, rugged post light, Aero Industrial Guard Post Mount Light, Aero Industrial Guard Post Mount, Aero Industrial Post Mount Light, Aero Industrial Post Mount, Aero Guard Post Mount Light, Aero Industrial Post Mount, Aero Post Mount Light, Aero Post Mount, BLE-PMS-TGG-SBA12, BLE-PMS-TGG-SBA14, pier, peir, pier light, peir light, Post lamp, Pole lamps, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, Lampposts, Lamppost, Lamp posts, Lamp post, pier mount, pier mounts, pier mount light, pier mount lights, pier mount lighting, pier mount fixture, pier mount fixtures, pier mount light fixture, pier mount light fixtures, pier mount lighting fixture, pier mount lighting fixtures, pier light, pier lights, pier lighting, pier light fixture, pier light fixtures, pier lighting fixture, pier lighting fixtures, dock light, dock lights, dock lighting, dock mount light, dock mount lights, dock mount lighting, dock light fixture, dock light fixtures, dock lighting fixture, dock lighting fixtures, BLE PMS, lamp post lights, outdoor pole lights, light post lighting,
61526 post mount barn lighting, industrial post mount, post mount for parking lots, commercial pole mount lighting, decorative nautical post mount fixture, decorative yard lighting, cast guard and shade post mount, outdoor pole light This post mount light features a decorative barn light shade and industrial cast-guard. Made of commercial grade aluminum, the Bomber adds decorative flair! Old Dixie Industrial Guard Post Mount, old dixie pole mount, yard lighting, BLE-PMS-TGG-WHB, pole light, post mount light, pole mount, post lighting, BLE-PMS-TGG-WHB11, BLE-PMS-TGG-WHB13, Bomber Industrial Guard Post Mount Light, Bomber Post Mount Light, Bomber Industrial Guard Post Mount, Bomber Industrial Guard Post Mounts, Bomber Industrial Post Mounts, industrial post mount, industrial post mounts, industrial guard post mount, industrial guard post mounts, industrial pole mount, industrial guard pole mount, BLE-PMS-TGG-WHB11, BLE-PMS-TGG-WHB13, pier, peir, pier light, peir light, Post lamp, Pole lamps, SPS-0245, SPS0245, SPS 0245, bomber series, bomber collection, SPS-0149, SPS0149, SPS 0149, Lampposts, Lamppost, Lamp posts, Lamp post, pier mount, pier mounts, pier mount light, pier mount lights, pier mount lighting, pier mount fixture, pier mount fixtures, pier mount light fixture, pier mount light fixtures, pier mount lighting fixture, pier mount lighting fixtures, pier light, pier lights, pier lighting, pier light fixture, pier light fixtures, pier lighting fixture, pier lighting fixtures, dock light, dock lights, dock lighting, dock mount light, dock mount lights, dock mount lighting, dock light fixture, dock light fixtures, dock lighting fixture, dock lighting fixtures, BLE PMS, lamp post lights, outdoor pole lights, light post lighting, H-15111, H-15113, H-15115, H-15117, curved warehouse shade, curved warehouse shade post light,
61528 cast guard and glass shade pole light, industrial yard lighting, barn shade pole mount lighting, commercial post mount light, marine grade exterior pole light, Perfect for sidewalks, docks, and more, the Union Industrial Guard adds a decorative touch to any setting. Features a retro RLM style shade and guard and glass fixture. Universal Industrial Guard Post Mount, BLE-PMS-TGG-WHU, decorative walkway light, industrial guard pole light, exterior lighting, pole mount, pole light, post mount, post mount light, BLE-PMS-TGG-WHU12, BLE-PMS-TGG-WHU14, Union Industrial Guard Post Mount Light, Union Industrial Guard Post Mount, Industrial Guard Post Mount Light, Industrial Guard Post Mount, Industrial post mount, industrial post mounts, union post mount, union post mount light, BLE-PMS-TGG-WHU12-N, BLE-PMS-TGG-WHU12, BLE-PMS-TGG-WHU14-N, BLE-PMS-TGG-WHU14, union series, union collection, the union series, the union collection, SPS-0247, SPS 0247, SPS0247, Lampposts, Lamppost, Lamp posts, Lamp post, pier mount, pier mounts, pier mount light, pier mount lights, pier mount lighting, pier mount fixture, pier mount fixtures, pier mount light fixture, pier mount light fixtures, pier mount lighting fixture, pier mount lighting fixtures, pier light, pier lights, pier lighting, pier light fixture, pier light fixtures, pier lighting fixture, pier lighting fixtures, dock light, dock lights, dock lighting, dock mount light, dock mount lights, dock mount lighting, dock light fixture, dock light fixtures, dock lighting fixture, dock lighting fixtures, BLE PMS, lamp post lights, outdoor pole lights, light post lighting,
61529 radial wave post mount, galvanized post mount, industrial decorative post mount, pole mount sidewalk lighting, pole mount light, decorative pole mount light fixture, post mount lighting, post mount residential lighting Combining a fluted RLM shade and industrial guard and glass fixture, this post mount light fixture makes for stylish commercial sidewalk lighting! Radial Wave Industrial Guard Post Mount, BLE-PMS-TGG-RWS, radial wave post mount, industrial post mount, post mount lighting, sidewalk light, pole mount light, pole mount, pole light, BLE-PMS-TGG-RWS12, BLE-PMS-TGG-RWS14, Seaside Industrial Guard Post Mount Light, Seaside Industrial Guard Post Mount, Seaside Post Mount Light, Seaside Post Mount, Seaside Industrial Guard, Industrial guard, industrial guard post mount, industrial guard light, industrial post mount, industrial post mounts, industrial pole light, pole light, post light, industrial post light, BLE-PMS-TGG-RWS12, BLE-PMS-TGG-RWS14, pier, peir, pier light, peir light, Post lamp, Pole lamps, seaside series, seaside collection, sea side series, sea side collection, the seaside series, the seaside collection, the sea side series, the sea side collection, SPS-0156, SPS0156, SPS 0156, Lampposts, Lamppost, Lamp posts, Lamp post, pier mount, pier mounts, pier mount light, pier mount lights, pier mount lighting, pier mount fixture, pier mount fixtures, pier mount light fixture, pier mount light fixtures, pier mount lighting fixture, pier mount lighting fixtures, pier light, pier lights, pier lighting, pier light fixture, pier light fixtures, pier lighting fixture, pier lighting fixtures, pier light, pier lights, pier lighting, pier light fixture, pier light fixtures, pier lighting fixture, pier lighting fixtures, dock light, dock lights, dock lighting, dock mount light, dock mount lights, dock mount lighting, dock light fixture, dock light fixtures, dock lighting fixture, dock lighting fixtures, BLE PMS, lamp post lights, outdoor pole lights, light post lighting, H-19112, H-19114, H-19116, classic radial shade, classic radial shade post light,