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 (30013, 65416, 60783, 61166) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00054

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 (30013,65416,60783,61166) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
30013 bulkhead light fixture, round bulkhead sconce, holophane bulkhead sconce, marine lighting, commercial bulkhead sconce, apartment bulkhead lighting, nautical flush wall sconce, round industrial nautical light This nautical outdoor wall light was inspired by bulkhead lights. Its flush mounted body sits tightly against the wall, shining light through its industrial nautical shade. Anchorage Bulkhead Wall Mount Light Fixture, bulkhead light fixture, round bulkhead sconce, holophane bulkhead sconce, marine lighting, commercial bulkhead sconce, apartment bulkhead lighting, nautical flush wall sconce, round industrial nautical light, BLE-W-BULKRS, bulkhead, bulk head, bulkheads, bulk heads, bulkhead light, bulk head light, bulk head sconce, bulk head wall sconce, bulkheads, Ribbed glass sconce, Ribbed glass sconces, Ribbed glass wall sconce, Ribbed glass wall sconces, White sconce, White sconces, White wall sconce, White wall sconces, surface mount, BULKRS, BULKR, BLKRS, BLKR, Small mount lighting, Small mount light, Small mount lights, Wall mount sconce, wall mount sconces, sconce wall mount, sconce wall mounted, wall mount light, wall mount lights, wall mount lighting, wall mounted light, wall mounted lights, wall mounted lighting, wall mount sconce light, wall mount sconce lights, wall mount sconce lighting, wall mounted sconce light, wall mounted sconce lights, wall mounted sconce lighting, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside sconce, outside sconces, outside wall sconce, outside wall sconces, Out side sconce, out side sconces, out side wall sconce, out side wall sconces, Outside sconce light, Outside sconce lights, Outside sconce lighting, Out side sconce light, Out side sconce lights, Out side sconce lighting, Outside sconce light fixture, Outside sconce light fixtures, Outside sconce lighting fixtures, Outside sconce lighting fixture, 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, ceiling flush mount, nautical sconces, nautical sconce, nautical wall sconces, small anchorage bulkhead light,
60783 cast guard light, cast guard & glass light fixture, cast guard unit, nautical cgu, vapor tight light fixture, vapor tight wall mount light, industrial flush mount light The flush mount guard sconce is an industrial cast guard & glass light inspired by nautical CGUs that make a welcome addition to decorative wall and flush mount ceiling lighting. The Bullet Flush Mount CGG,The Bullet Cast Guard & Glass, Cast Guard, Bullet, CGU, BLE-F-CGGB-PC, HB Sconce, Atomic Sconce, CGU, CGG, CGG Flush Mount, CGG Ceiling Light, CGU Flush Mount, CGU Ceiling Light, bulky, heavy duty, thick guard, Industrial, H-CGU-FB, BLE-F-CGGB-PC, The Bullet Cast Guard, the bullet light, the bullet guard light, the bullet cast light, guard light, the bullet ceiling light, the bullet flush mount light, cage guard flush mount, cast guard mount, cast guard flush mount, cast guard ceiling light, bullet ceiling light, industrial sconce, wall sconce lighting, industrial wall sconce lighting, bullet wall sconce, bullet wall light, cast guard sconce, cast guard wall sconce, flush mount, flush, guard sconce, flush mount guard sconce, flush mount, flush mount sconce, flush mount wall sconce, flush mount sconce, industrial flush mount, industrial flush mount sconce, industrial sconce, wall or ceiling sconce, ceiling sconce, rugged sconce, natuical sconce, nautical sconce, nautical wall sconce, industrial guard flush mount, flush mount, industrial, industrial guard, 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 flush, flush rugged guard, rugged guard flush mount, flush mount rugged guard, rugged guard flush pendant, flush pendant rugged guard, 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, Flush mount light, cgg, cggg, ccg, Pendent outdoor, pendant outdoor, Pendant light outdoor, pendant shade, pendant wet, pendent wet, pendant hanging lights, outdoor hanging pendant, outdoor hanging light, Outdoor ceiling mount, Outdoor semi-flush, outside barn light, outside barn lights, outside barn lighting, outdoor barn light, outdoor barn lights, outdoor barn lighting, outdoor lighting fixture, outdoor lighting fixtures, SPS-0007, SPS 0007, SPS0007, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, Small mount lighting, Small mount light, Small mount lights, foyer light, foyer lights, foyer lighting, Outside flush mount, Outside flush mounts, Outside flush mount light, Outside flush mount lights, Outside flush mount lighting, Outside flush mount light fixture, Outside flush mount light fixtures, Outside flush mount lighting fixture, Outside flush mount lighting fixtures, Outside flush mount pendant, Outside flush mount pendants, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, ble-c-gg, ceiling flush mount, nautical sconces, nautical wall sconces,
61166 filament bulb pendant, solo pendant light, exposed socket pendant, cord hung bulb light, single bulb pendant, edison bulb pendant light, cord hung socket pendant, minimalist bulb pendant Loved for its minimal, bare bulb the Indy Pendant is rooted in vintage industrial lighting styles. Its turn key and custom cord options makes you the designer. Barn Light Indy Industrial Pendant, BLE-PHSCKT, BLE-INDY, hanging bulb, bulb pendant, light cord, pendant light bulbs, Indy Industrial Pendant, Indy Industrial Pendant Light, Indy Industrial Pendant Lights, Indy Industrial Pendant Lighting, Indy Pendant, Indy Pendants, Indy Pendant Light, Indy Pendant Lights, Indy Pendant Lighting, bare bulb light, bare bulb pendant, minimalist pendant, industrial pendant, minimalist ceiling pendant, 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,
65416 The Ellington’s modern, minimalist look brings style and plenty of light to homes and businesses. Customizable with various finish colors and cord styles! BLE-C-EGT, Ellington Pendant Light, Ellington Pendant Light, Ellington Pendant Lighting, Ellington Pendant Lights, Ellington Ceiling Pendant Light, Ellington Ceiling Pendant, Ellington Ceiling Pendants, Ellington Ceiling Light, Ellington Ceiling lights, Ellington ceiling lighting, Ellington pendant, Ellington Pendants, Ellington, Ellington Light, Ellington Lights, Ellington 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, ellingtons