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 (58117, 62356, 61428, 61518) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00055

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 (58117,62356,61428,61518) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
58117 Mid-Century light, Industrial light, pendant lighting, mid century lighting, industrial lighting, double ceiling mount, cgg, ceiling light, ship light, ship lights, metal, pendant, rustic, bullet shape, marine pendant, bathroom, vanity, kitchen, A rugged look for modern spaces! This industrial pendant light offers plenty of style and character to homes and businesses! Fully customizable! Barn Light, Wall Mount, Double CGU Pendant ,Cast Guard, Atomic Pendant, CGU, CGU Pendant, BLE-S-CGG2H, Industrial Loft Double Pendant, ceiling pendant, industrial ceiling pendant, industrial ceiling pendant, pendant lighting, industrial pendant lighting, industrial ceiling light, loft ceiling light, loft double pendant, cast guard ceiling light, cast guard and glass ceiling light, industrial lighting, outdoor lighting, outdoor ceiling light, exterior ceiling light, exterior ceiling lighting, exterior lighting, loft pendant, double loft pendant, loft double pendant, Industrial Loft Double Pendant Light, Industrial Loft Double 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, rugged guard chandelier, rugged guard chandeliers, cgg, cggg, ccg, SPS-0423, SPS0423, SPS 0423, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, ble-c-gg, nautical cage pendant, double atomic, double cage wall light,
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
61518 wire cage stem mount pendant, stem mount industrial pendant, rustic swag light, wire cage warehouse shade pendant, wire guard pendant, wire guard stem mount ceiling light, decorative wire guard shade The Blue Collar Pendant combines a wire guard warehouse shade with a hefty stem mount pendant for an industrial but airy statement light fixture. The Blue Collar Stem Mount Pendant, BLE-S-WGGWS, blue collar pendant, wire guard shade, BLE-S-WGGWS12-PC, BLE-S-WGGWS14-PC, BLE-S-WGGWS16-PC, wire shade, wire pendant light, wire guard pendant light, wire guard stem mount, wire guard shade light, wire guard lighting, wire guard rlm shade, wire guard ceiling light, wire ceiling light, ceiling light, ceiling pendant light, stem mount ceiling light, blue collar pendant, blue collar wire guard, blue collar wire guard lighting, blue collar stem mount, blue collar stem mount lighting, blue collar industrial pendant, blue collar industrial pendant lighting, blue collar wire guard industrial pendant lighting, blue collar, blue collar light, blue collar lights, blue collar lighting, new listing, BLE-S-WGGWS12, BLE-S-WGGWS14, BLE-S-WGGWS16, blue collar collection, blue collar series, the blue collar collection, the blue collar series, SPS-0054, SPS 0054, SPS0054, stems, Stem pendant lights, stem light mount, stem light mounts, stem, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, 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, outdoor pendent, outdoor pendents, outdoor pendent light, outdoor pendent lights, outdoor pendent lighting, outdoor ceiling pendent, outdoor ceiling pendents,
62356 industrial led pendant, rustic cast guard pendant, ceiling pendant The LED Industrial Guard Stem Pendant combines a rustic cast guard and glass body with the very latest in compact LED technology from Cree! Free Shipping! cgg led, tgg led, cast guard and glass led, cast guard and glass pendant led, led pendant, led stem mount, vapor jar pendant, vaporjar pendant led, led vaporjar pendant, industrial led pendant, rustic led pendant, rustic pendant led, led rustic pendant, Industrial Guard LED Stem Mount Pendant Light, Industrial Guard LED Stem Mount Pendant, Industrial Guard LED Stem Mount Pendants, Industrial Guard LED Stem Mount, Industrial Guard LED Stem Mounts, Industrial Guard LED Pendant Light, Industrial Guard LED Pendant, Industrial Guard LED, LED industrial guard, LED nautical pendant, Nautical led pendant, BLE-S-CGG, Industrial Guard Stem Mount Pendant Light, Industrial Guard Stem Mount Pendant, Industrial Guard Stem Mount Pendant Lighting, Industrial Guard Stem Mount Pendant Lights, Industrial Guard Stem Mount Pendants, Industrial Guard Pendant Light, Industrial Guard Pendant, Industrial Guard Pendants, Industrial Guard Stem Mount, Industrial Guard Stem Mounts, Industrial Guard Stem Mount light, Industrial Guard Stem Pendant Light, Industrial Guard Stem Pendant, Industrial Guard Stem Pendants, Nautical Guard Stem Mount Pendant Light, Nautical Guard Stem Mount Pendant, Nautical Guard Stem Mount Pendant Lighting, Nautical Guard Stem Mount Pendant Lights, Nautical Guard Stem Mount Pendants, Nautical Guard Pendant Light, Nautical Guard Pendant, Nautical Guard Pendants, Nautical Guard Stem Mount, Nautical Guard Stem Mounts, Nautical Guard Stem Mount light, Nautical Guard Stem Pendant Light, Nautical Guard Stem Pendant, Nautical Guard Stem Pendants, Rustic Guard Stem Mount Pendant Light, Rustic Guard Stem Mount Pendant, Rustic Guard Stem Mount Pendant Lighting, Rustic Guard Stem Mount Pendant Lights, Rustic Guard Stem Mount Pendants, Rustic Guard Pendant Light, Rustic Guard Pendant, Rustic Guard Pendants, Rustic Guard Stem Mount, Rustic Guard Stem Mounts, Rustic Guard Stem Mount light, Rustic Guard Stem Pendant Light, Rustic Guard Stem Pendant, Rustic Guard Stem Pendants, industrial pendant, industrial pendants, industrial pendant light, industrial stem mount, industrial guard, industrial guard light, nautical pendant, nautical pendants, nautical pendant light, nautical stem mount, nautical guard, nautical guard light, rustic pendant, rustic pendants, rustic pendant light, rustic stem mount, rustic guard, rustic guard light, BLE-S-CGG-LED, 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 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, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling 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