SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  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 (
    954, 955, 953, 6186, 1008, 3740, 1007, 
    1006
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00029

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": "3",
      "used_key_parts": ["product_id"],
      "rows": 8,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (954,955,953,6186,1008,3740,1007,1006)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
953 <p> BUD 70&quot; H open rack with larger support base and upright angles. Black textured finish. Ships broken down in 2 cartons with all necessary hardware.</p> <p> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Exceptionally strong structure made up of chassis-type base and supporting angles.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Uprights: .11&quot; steel channels, 3.00&quot; deep.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Top Plate, 1.12&quot; x 3.12&quot;.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Rails tapped #10-32 on EIA universal spacing. (Use #7346 screws - order separately)&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Base is 19.96&quot; x 22.00&quot; and drilled for RC-7758 casters.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Racks have been tested to 650# equipment load capacity.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Racks are shipped knocked down in two (2) cartons, with all necessary assembly hardware included.</span></p>
954 <p> BUD: Table top rack w/ 21" of panel space. 24" overall height. Black textured finish </p><p> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Chassis-type base holds heavy components for table mounting applications. Supporting angles provide strength and rigidity. Panel mounting rails tapped #10-32 on E.I.A. universal spacing. (Use #7346 screws - order separately) Standard 19" panel fits flush with front. Base, 20.37" x 12.00". Shipped knocked down.</span> </p><p> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Finish: Black Texture</span> </p> table top rack, tabletop rack, 2' rack, 2' open rack, 2 foot rack, 2 foot open rack, tabletop equipment rack, table top equipment rack
955 <p>These swingframe racks offer all the conveniences of a wall mounted rack, plus the added advantage of a swing out frame for easy access to the rear of your equipment.</p><p style="margin-top: 0px; font-size: 12px; line-height: 18px; margin-bottom: 20px; color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; background-color: rgb(255, 255, 255);"><strong>Features</strong></p><ul><li>Left or right hand hinge.</li><li>#12-24 panel mounting hardware (Use #9260 screws - order separately)</li><li>Velcro cable straps included</li><li>16" on center wall mounting (wall mounting hardware not included).</li><li>75# equipment load capacity</li><li>Two Styles: Style A - Knockdown Assembly, Style B - Welded Assembly<br><br><strong>Finish:</strong> Black Texture (BT)</li></ul>
1006 <p> BUD INDUSTRIES: &nbsp;31.5&quot; X 19&quot; (panel space) - 35.62&quot; overall height - 36 lbs - Black Textured Finish</p> <p> &nbsp;</p> <h1 style="font-size: 18px; color: rgb(0, 56, 214); margin-bottom: 18px; padding-top: 0px; padding-bottom: 0px; font-family: Tahoma, Geneva, sans-serif; line-height: 18px; background-color: rgb(255, 255, 255);"> Design Features</h1> <p> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Exceptionally strong structure made up of chassis-type base and supporting angles.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Uprights: .11&quot; steel channels, 3.00&quot; deep.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">top plate, 1.12&quot; x 3.12&quot;.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Rails tapped #10-32 on EIA universal spacing. (Use #7346 screws - order separately)&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Base is 19.96&quot; x 22.00&quot; and drilled for RC-7758 casters.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Racks have been tested to 650# equipment load capacity.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Racks are shipped knocked down in two (2) cartons, with all necessary assembly hardware included.</span></p>
1007 <p> BUD INDUSTRIES: 42" X 19" (panel space) - 50" overall height - 27 lbs - Aluminum Finish (Black Textured Finish also available for $14.30 more). </p><p> Rack is shipped unassembled in one box with all necessary hardware included. </p>
1008 <p> BUD INDUSTRIES: 77" X 19" (panel space) - 84" overall height - 37 lbs - Comes in an aluminum finish (black textured finish also available for $16 more). </p><p> Rack is shipped unassembled in one box with all necessary hardware included. </p>
3740 <p> BUD Industries 31&quot; table top open rack with a metallic gray finish (MG). &nbsp;It is available in a black textured finish as well, but is a special order item with a week to 10 day lead time. &nbsp;Supporting angles provide strength and durability. &nbsp;Standard 19&quot; rack mountable equipment fits flush with front rails. &nbsp;Shipped knocked down with all assembling hardware included.</p>
6186 <p>Bud Industries 19" ventilated shelf for open rack. Black textured finish</p>