SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    3442, 3441, 15431, 4884, 13070, 11475, 
    877, 3500, 3501, 3502, 3504, 3505, 883, 
    884, 3503, 13048, 13038, 3928, 16545, 
    16551, 16528, 15765, 16526, 16547, 
    15767, 16529, 16523, 15764, 16544, 
    16539, 16548, 16527, 16530, 16533, 
    16550, 16538, 16531, 16532, 16546, 
    16520, 16189, 16537, 15876, 16543, 
    15759, 15760, 16534, 15763
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00096

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "33.61"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "index_condition": "((`dev_yourmart_co_bw`.`cscart_product_descriptions`.`product_id` in (3442,3441,15431,4884,13070,11475,877,3500,3501,3502,3504,3505,883,884,3503,13048,13038,3928,16545,16551,16528,15765,16526,16547,15767,16529,16523,15764,16544,16539,16548,16527,16530,16533,16550,16538,16531,16532,16546,16520,16189,16537,15876,16543,15759,15760,16534,15763)) and (`dev_yourmart_co_bw`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "28.81",
        "eval_cost": "4.80",
        "prefix_cost": "33.61",
        "data_read_per_join": "183K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
877 <ul style="margin-top:0px;margin-bottom:10px;color:#4f4f4f;font-family:Roboto, sans-serif;font-size:16px;"><li>All-Cast Construction</li> <li>7000lb (3175.14kg) Tested Capacity</li> <li>Lifts, Winches, Clamps, & More</li> <li>Most Durable Design</li> <li>Size: 152cm</li><li>Min. Lift Height: 11.43cm</li><li>Max. Lift Height: 126.37cm</li><li>Overall Height: 156.85.cm</li><li>Width: 12.7cm</li><li>Depth: 24.46cm</li><li>Rated Load (RL): 2,113kg</li><li>RL on upper 12" (30.5cm): 1206kg</li><li>Tested Load (TL): 1,814kg</li><li>Winching Capacity: 2,268kg</li><li>Clamping Capacity: 340kg</li><li>Weight: 14.2kg</li></ul>
883 <ul><li><strong>Kaufmann Table Foldable HDPE Brown 1.8m</strong></li><li>Large folding table with wooden design HDPE Top and Steel hammertone frame. </li><li><strong>Colour:</strong> Brown</li><li><strong>Open Size:</strong> 180cm (L) x 75cm (W) x 72cm (H). </li><li><strong>Closed Size:</strong> 90cm (L) x 75cm (W) x 8.6cm (H)</li><li><strong>Weight:</strong> 12.56 Kg</li></ul>
884 <ul><li><strong>Kaufmann Table Foldable HDPE Brown 78cm x 78cm</strong></li><li>Square folding table with wooden design HDPE Top and Steel hammertone frame.</li><li><strong>Colour: </strong>Brown</li><li><strong>Open Size: </strong>78cm (L) x 78cm (W) x 70.5cm (H).</li><li><strong>Closed Size: </strong>78cm (L) x 78cm (W) x 4.5cm (H)</li><li><strong>Weight: </strong>8.3 Kg</li></ul>
3441 <p>For more than 20 years, Enlan has made quality knives, the Hunt-Pro collection has an innovative design with excellent quality this is the Enlan Hunt-Pro with a fixed blade and gut hook, perfect for those hunters out there.  Enlan products vary from pocket knife, hunting knife, army knife, tactical knife and fishing knife.</p> <h4>Product Features:</h4> <ul><li>Blade: 7cR17MoV</li><li>Blade: Satin finish with gut hook</li><li>Handle material: Rubber</li><li>Overall Length: 27.5cm</li><li>Length: 11.3cm</li></ul> <p><br /></p>
3442 <p>For more than 20 years, Enlan has made quality knives, the Hunt-Pro collection has an innovative design with excellent quality this is the Enlan Hunt-Pro with a fixed blade and gut hook, perfect for those hunters out there. Enlan products vary from pocket knife, hunting knife, army knife, tactical knife and fishing knife.The Biltong Bok Knife is designed to cut biltong</p> <h4>Product Features:</h4> <ul><li>It comes with a quality black leather belt pouch and a quality wooden display box</li><li>Leather Holster and Wooden Box</li><li>5CR15MOV Steel Blade</li></ul>
3500 <ul><li>High quality stylish stainless steel flask, with unique double walled vacuum technology for optimum insulation</li><li>Keeps your drinks hot for 12 hours and cold for up to 24 hours</li><li>Durable and lightweight, it can take a beating and still provide you with an ice cold drink</li><li>Slim design fits most of the vehicle bottle cup holders</li><li>Stainless steel inner allows for easy cleaning</li><li>Perfect for your gym bag, car, bicycle and backpack to enjoy your long hikes, trekking, hot yoga class, long load trip, or any other outdoor activities</li><li>Five year guarantee</li></ul> <p></p>
3501 <ul><li>High quality stylish stainless steel flask, with unique double walled vacuum technology for optimum insulation</li><li>Keeps your drinks hot for 12 hours and cold for up to 24 hours</li><li>Durable and lightweight, it can take a beating and still provide you with an ice cold drink</li><li>Slim design fits most of the vehicle bottle cup holders</li><li>Stainless steel inner allows for easy cleaning</li><li>Perfect for your gym bag, car, bicycle and backpack to enjoy your long hikes, trekking, hot yoga class, long load trip, or any other outdoor activities</li><li>Five year guarantee</li></ul> <p></p>
3502 <ul><li>High quality flask, with unique double walled vacuum barrier for optimum insulation, keeps your drinks hot or cold for up to 24 hours</li><li>Polished stainless steel inner allows for easy cleaning</li><li>Easy pour stopper with extra wide mouth function</li><li>Includes folding comfy handle for easy handling</li><li>Five year guarantee</li></ul> <table><tbody><tr><th><br /></th><td></td></tr></tbody></table>
3503 <ul><li>Kaufmann 750ml Traveller Flask - Black.</li><li>High quality double walled vacuum insulated flask with wide mouth</li><li>Anti slip powder coating finish</li><li>Healthy and Eco friendly Food Grade Stainless Steel body and all around stain and rust resistant</li><li>Keeps cold for 18hrs and Hot for 12hrs</li><li>Ideal for Camping, Picnics & Work</li><li>Dimensions: 8cm x 8cm x 20cm</li><li>Weight: 0.35kg</li><li>Capacity: 750ml</li><li>Colour: Black</li><li>Warranty: 12 Months</li></ul> <p><br /></p> <p><br /></p> <p></p>
3504 <ul><li>Thermo water cup with steel handle</li><li>Stainless steel, mirror polished</li><li>Double walled for excellent insulation</li><li>Perfect for camping, outdoor activities and travel </li></ul>
3505 <ul><li>High quality flask, with unique double walled vacuum barrier for optimum insulation, keeps your drinks hot or cold for up to 24 hours</li><li>Polished stainless steel inner allows for easy cleaning</li><li>Easy pour stopper with extra wide mouth function</li><li>Includes folding comfy handle for easy handling</li><li>Five year guarantee</li></ul> <p></p>
3928 <ul><li>The do-it-all trail tire</li><li>Aggressive, high volume thread</li><li>EXO Protection offered in select models </li><li>An aggressive tread in high-volume casing, designed with great traction in mind</li><li>The Ardent doesn't forget the racer with large block-style side knobs offering numerous edges for high-speed cornering</li><li>The center tread, while ideal for braking and accelerating traction, also features ramped knobs to minimize rolling resistance</li><li>With a wide variety of size offerings, the Ardent captures every mountain rider's needs</li></ul>
4884 <ul><li>The Garmin Quick Release silicone watch band <b>allows you to run in style</b></li><li>Choose the colour that matches your outfit and switch between straps in a jiffy</li><li>The various colours that are available ensure that there will always be one which goes with your outfit</li></ul>
11475 <ul><li>Maximum output to 100 lumens ANSI-Standard certified lumen output and runtime</li><li>Water proof to IPX7 standard</li><li>Disperse optics with side light design for over 180-degrees of visibility</li><li>Power status indicator alerts remaining run-time before powering off</li><li>Light memory mode</li><li>Compatible with Rev Comp, Compel, Roost and Prompt series helmets</li></ul> <p></p>
13038 <p></p><pre> The Marvel Spartan Tubeless Repair Kit is the answer to flat tyres in the workshop or on the road. The 2 tolls are made from aluminium styled after heated metal. It seals the needle with a neat cap making storage a breeze. It includes 10 plug strips that will last you a long time unless you like to ride extreme trails.</pre>
13048 <p>The Rap II series of multi-tools combine style, technology and ultimate value to offer unparalleled performance for their price range. These multi-tools are developed and manufactured in-house and have a number of innovative functions. The ergonomic side plates are made of lightweight aluminium and offer a custom magnetic holder for a quick emergency connection. The steel tool bits are now longer and introduce our black anti-corrosion technology, which provides superior corrosion resistance. Seven configurations are available with up-to-date options for all modern bicycles; including gravel bikes, mountain bikes, e-bikes and racing bikes. Compact and versatile, these mini tools are built to last and designed to efficiently get riders back on the road or on </p>
13070
15431
15759
15760
15763
15764
15765
15767
15876
16189
16520
16523
16526
16527
16528
16529
16530
16531
16532
16533
16534
16537
16538
16539
16543
16544
16545
16546
16547
16548
16550
16551