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

Query time 0.00041

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,61390,60783,60484) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
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,
60484	rustic wall sconce, wall sconce, vapor proof wall light, bulkhead wall light, cast guard and glass sconce, marine sconce	Rugged, customizable, and stylish: this industrial wall sconce is a versatile lighting option, perfect for indoor and outdoor applications! Create a truly unique look for any space!	HB Sconce, Cast Guard, Atomic Sconce, CGU, CGU Sconce, Industrial Static Topless Sconce, Topless Sconce, 10W1CG, BLE-W-CGGT, rustic wall sconce, CGG, static sconce, topless static sconce, Industrial Static Topless Sconce, Atomic Industrial Static Sconce, industrial sconce, static sconce, industrial wall sconce, static wall sconce, staic, static, 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 sconce, rugged guard wall sconce, rugged guard sconce light, rugged guard sconce lights, rugged guard sconce lighting, rugged guard wall light, rugged guard wall lights, rugged guard wall lighting, Ribbed glass sconce, Ribbed glass sconces, Ribbed glass wall sconce, Ribbed glass wall sconces, cgg, cggg, ccg, sconce outdoor wet rated, sconce outdoor wet-rated, Light with photocell, outdoor light light with photocell, SPS-0027, SPS 0027, SPS0027, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, Wall mount outdoor lights, Wall mount outdoor light, Wall mount outdoor lighting, Wall mount outdoor light fixture, Wall mount outdoor light fixtures, Wall mount outdoor lighting fixture, Wall mount outdoor lighting fixtures, wall light sconce, wall light sconces, pastel, Caged lights, Caged light, 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 wall sconces, nautical cage sconce,
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,
61390	industrial farmhouse style, nautical wall sconce, marine light, beach house light, light fixtures nautical	The Streamline Industrial Guard Sconce is ideal for outdoor use in harsh weather or indoor settings. The flared half-shade has a distinct modern nautical feel.	Atomic Streamline Industrial Guard Sconce, BLE-W-CGGFS, nautical light, streamline sconce, streamline, streamline lighting, atomic streamline, atomic industrial sconce, wall sconce, wall light, streamline wall sconce, streamline wall light, streamline guard sconce, outdoor streamline guard sconce, outdoor streamline guard wall light, outdoor streamline guard wall sconce, outdoor streamline guard sconce, exterior streamline guard sconce, exterior streamline guard wall light, exterior streamline guard wall sconce, exterior streamline guard sconce, outdoor guard wall light, outdoor guard wall sconce, outdoor guard sconce, exterior guard sconce, exterior guard wall light, exterior guard wall sconce, exterior guard sconce, outdoor wall light, outdoor wall sconce, outdoor sconce, exterior sconce, exterior wall light, exterior wall sconce, exterior sconce, hallway lighting, hallway light, hallway sconce, hallway wall sconce, hallway wall light, bathroom lighting, bathroom light, bathroom sconce, bathroom wall sconce, bathroom wall light, Atomic Topless Streamline Industrial Guard Sconce, Streamline Industrial Guard Sconce, Atomic Streamline Industrial Guard Sconce, Ribbed glass sconce, Ribbed glass sconces, Ribbed glass wall sconce, Ribbed glass wall sconces, jelly jar light, jelly jar lights, jelly jar light fixture, jelly jar light fixtures, cgg, cggg, ccg, sconce outdoor wet rated, sconce outdoor wet-rated, Light with photocell, outdoor light light with photocell, Industrial streamline, Stream industrial guard sconce, industrial guard, industrial guard sconce with cage, Industrial vanity lighting, SPS-0019, SPS 0019, SPS0019, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, Industrial guardsconce, Industrial guardsconces, Caged lights, Caged light, 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, toggle switch, wall mount with on off switch, wall mount with on/off switch, wall light with on off switch, wall light with on/off switch, wall fixture with on off switch, wall fixture with on/off switch, Sconce with switch, Sconce with switch, Wall Sconce with switch, Sconce fixture with switch, Sconce fixtures with switch, wall sconces with switch, toggle on off switch, toggle on/off switch, Sconce with on off switch, Sconce with on/off switch, on off switch, on/off switch, Integrated Switch, toggle, 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, streamline industrial sconce, nautical wall sconces, nautical cage sconce,