Sandbox

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 (
    69545, 69446, 69448, 69449, 69447, 69547, 
    69549, 69546, 69452, 69548, 69451, 
    69450, 70246, 70245
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00107

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "24.42"
    },
    "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": 14,
      "rows_produced_per_join": 14,
      "filtered": "100.00",
      "index_condition": "((`cscartdb`.`cscart_product_descriptions`.`product_id` in (69545,69446,69448,69449,69447,69547,69549,69546,69452,69548,69451,69450,70246,70245)) and (`cscartdb`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "23.02",
        "eval_cost": "1.40",
        "prefix_cost": "24.42",
        "data_read_per_join": "53K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id	short_description	full_description
69446		Built at a 15 degree slope One quick adjustment makes this bench fits all! No need to adjust the arms and knee rest! Simply move the chest rest up or down for a perfect fit! Chest rest adjust from 26" high to 34" high. Heavy duty 2 x4 wood construction! Two-inch-thick cushions covered with black vinyl. Adjustable face cradle for added comfort. Eye bolts for attaching hand and ankle cuffs. Easily disassembled and stored under a bed. Arm and knee rest can be adjusted to be parallel or at an angle.
69447		One quick adjustment makes this bench fits all! No need to adjust the arms and knee rest! Simply move the chest rest up or down for a perfect fit! Heavy duty 2 x4 wood construction! Two-inch-thick cushions covered with black vinyl. Adjustable face cradle for added comfort. Eye bolts for attaching hand and ankle cuffs. Easily disassembled and stored under a bed. Legs can be adjusted parallel or spread apart.
69448		This is my regular size angle spanking bench. While it may hold someone of plus size stature, a larger person may find my plus size angle bench more comfortable. This bench is designed to hold up to 300 lbs. This bench is a good fit for people with medium to small size build. It is made of 2 x 4 pine wood. All joints are either bolted or screwed together. No nails are used in this. The chest rest is 10" wide by 27" long. It is mounted with a 15-degree angle. This results in the perfect positioning for spanking, and other fun activities. The chest rest is cushioned with 2" thick foam padding. The padding is covered with a durable black vinyl. (Leather is available upon request.) The arm rest are made of 2 x 4s x 14" long. They too or padded with two-inch-thick foam. The two-knee rest are 6" wide, and 19" long and stands about 14 1/2"" from the floor. They are also cushioned with 2" thick foam and covered with black vinyl. The knee rest has been re-engineered for greater stability. They can be mounted parallel to each other, or with a 10-degree angle causing the legs to be spread apart. This allows plenty of room for a person to stand between the legs. The angle of the sub is great for penetration. The rear knee extensions can easily be removed for storage by unscrewing the two mounting nuts. The heavy-duty construction of this bench is guaranteed to last a lifetime. I now have video instructions to make this item even more easy to assemble. Copy and paste the link below to view the video assembly instructions. https://www.youtube.com/watch?v=DVeos25NhMs
69449		Get ready to spoil your sub with the spoiler bench. This item has been newly improved with adjustable height knee rest that comes standard with each bench. This is now standard equipment with all purchase. Your sub will feel so comfortable lying on 2" thick foam, with a massage table face cradle, and an optional vibrator located in just the right spot to add sexual stimulation to both male and female. In fact, your sub may be so comfortable, that he or she may completely forget that they are locked in place with both hand and ankle cuffs. This bench is designed for both small and large size subs. This is because you will be given the option to plus size this bench at check out. That means that instead of a 10" wide chest rest, it will come with a 16" wide chest rest. It is made of 2 x 4 pine wood. All joints are either bolted or screwed together. No nails are used in this. The chest rest is 10" wide by 27" long. It is mounted with a 15-degree angle. This results in the perfect positioning for spanking, and other fun activities. The chest rest is cushioned with 2" thick foam padding. The padding is covered with a durable black vinyl. (Leather is available upon request.) A massage table face cradle comes standard with this bench. (No more neck crimps) The arm rest are made of 2 x 4s x 14" long. They too or padded with two-inch-thick foam. The two-knee rest are 6" wide, and 19" long and stands about 14 1/2" from the floor. They are also cushioned with 2" thick foam and covered with black vinyl. The knee rest can be mounted parallel to each other, or with a 10-degree angle causing the legs to be spread apart. This allows plenty of room for a person to stand between the legs. The angle of the bench is great for penetration. The rear knee extensions can easily be removed for storage by unscrewing the mounting nuts. The heavy-duty construction of this bench is guaranteed to last a lifetime. I now have video instructions to make this item even more easy to assemble.
69450		Heavy duty leather ankle cuffs. These cuffs are made of 1/8" thick x 2" wide genuine leather. There is a D-ring riveted to the center of the cuffs. Made long enough to fit any ankle size. Heavy duty construction will last a lifetime. Get $15.00 off of this price when purchased with any of my spanking benches.
69451		Heavy duty leather handcuffs. These are not the cheap China made cuffs. I make these cuffs out of 1/8" thick x 2" wide genuine leather. There is a D-ring riveted to the center of the cuffs. Made long enough to fit any wrist size. Heavy duty construction will last a lifetime. Get $15.00 off of this price when purchased with any of my benches.
69452		This is my wooden hand to feet stockade. It is made of a 2 x 6 x 26" board. Beautifully hand sanded and stained. It has two 2 1/2" diameter holes in the center for the wrist, and two 3 1/2" diameter holes on the ends for the ankles. Once you secure your sub wrist and ankles in this, you will force him or her to have their rear end in the air for spankings, and all sort of other fun activities. It has a hinge on one end, and a hasp for a padlock on the other end. It is absolutely escape proof once locked.
69545		This bench is designed with a gap in the chest rest of the bench making it more comfortable for women. This is great for adding nipple clamps or weights. This is also idea for women who simply don't like to lay on their breast. It has a built-in massage table face cradle for added comfort. This means you can stay on the bench for longer periods of time without getting neck crimps. It is made of 2 x 4 pine wood. All joints are either bolted or screwed together. No nails are used in this. The chest rest is 16" wide by 27" long. It is mounted with a 15-degree angle. The face cradle at the front of the bench has 2" thick foam on the inside, covered with a soft yet durable vinyl. The cushion at the back end of the chest rest is 16" wide and 11 1/2" long, with 2" thick foam padding. The padding is covered with a durable black vinyl. (Leather is available upon request.) The arm rest are made of 2 x 4s x 14" long. They too or padded with two-inch-thick foam. The two-knee rest are 6" wide, and 19" long and stands about 14 1/2"" from the floor. They are also cushioned with 2" thick foam and covered with black vinyl. The knee rest has been reengineered for greater stability. They can be mounted parallel to each other, or with a 10-degree angle causing the legs to be spread apart. This allows plenty of room for a person to stand between the legs. The rear knee extensions can easily be removed for storage by unscrewing the two mounting nuts. The heavy-duty construction of this bench is guaranteed to last a lifetime, and will hold up to 400 lbs. If you like this bench, but prefer to have it built without the angle, no problem. When you place your order, simply write in the comment section "please build my bench without the angle". Upon checkout, you will have the option to add a set of heavy-duty leather hand and ankle cuffs. The bench already comes with eye bolts in just the right places for attaching hand and ankle cuffs. You will also have the option to add a vibrator to the rear of the bench, to add additional stimulation.
69546		My adjustable angle bench with face cradle is just the ticket for those persons who are not sure if they want to have the bench level, or at an angle. Now you can have it both ways, and some. Use the bench completely level, or simply remove a pin to adjust the bench to five different angles. Adjustments can be easily done without having your sub get off the bench. Now you will find just the right angle for whatever play you had in mind. This bench is made with a solid 2 x 4 frame. The chest rest is 11 1/2" wide, and 28" long. It stands 30" from the floor when completely level. It is padded with 2" thick foam, and covered with a soft, yet durable black vinyl. It has a built-in face cradle which is also padded with 2" thick foam. The face cradle allows your sub to be perfectly comfortable for long periods of time without getting a kink in the neck. The arm rest are 3 1/2" wide and 14" long. The knee rest are 6" wide and 19" long. All are padded with 2" thick foam and covered with black vinyl. The knee rest and cross brace extensions can be easily removed for storage.
69547		Take a good look at our heavy duty angle spanking bench. It is built with the big boys in mind. In fact, it is guaranteed to hold up to 400 lbs. It is made of 2 x 4 pine wood. All joints are either bolted, or screwed together. No nails are used in this. Improvements have been made to this bench, that is not yet shown in the above photos. A 29" long 2 x 4 brace has been added to the bottom of the front legs. This provides even more stability. The chest rest is 16" wide by 27" long. It is mounted with a 15 degree angle. This results in the perfect positioning for spanking, and other fun activities. The chest rest is cushioned with 2" thick foam padding. The padding is covered with a durable black vinyl. (Leather is available upon request.) The arm rest are made of 2 x 4s x 14" long. They are also padded with two-inch-thick foam. The two-knee rest are 6" wide, and 19" long and stands about 14 1/2"" from the floor. They are also cushioned with 2" thick foam and covered with black vinyl. The knee rest has been reengineered for greater stability. They can be mounted parallel to each other, or with a 10-degree angle causing the legs to be spread apart. This allows plenty of room for a person to stand between the legs. You will find that the sub is in a great angle for penetration. The rear knee extensions can easily be removed for storage by unscrewing the two mounting nuts. The heavy-duty construction of this bench is guaranteed to last a lifetime. If you like this bench, but prefer to have it built without the angle, no problem. When you place your order, simply write in the comment section "please build my bench without the angle". Copy and paste the code below into your web browser window to view a video which explains the differences between the plus size angle bench, and the regular angle bench. The video also shows how to assemble the plus size angle bench after it arrives. https://youtu.be/MaOtR2itNzw
69548		This is my adjustable angle bench. It is made from 2 x 4 pine wood. The chest rest measures 12” wide, and 29” long. It is covered with 2” thick foam padding, then topped off with a comfortable yet durable black vinyl covering. When the chest rest is in the level position, it stands about 32” from the floor. The chest rest can be adjusted to 5 different angles, going from level to 30 degrees slope simply by removing a pin. The two-arm rest are also made of 2 x 4 pine wood. It too is covered with 2” thick foam padding, then topped off with the black vinyl. The two-knee rest are six inches wide and stands about 15” from the floor. They are covered with 2” thick foam and topped off with black vinyl. The rear knee supports can be mounted either parallel to each other or angled out 10 degrees from each other. There are eye bolts mounted on the bench in just the right places for attaching handcuffs, or ankle cuffs. The rear knee support and front brace can be easily removed for storage.
69549		Built with comfort in mind, this is my face cradle spanking bench. It's perfect for those of you who gets a crook in their neck when lying on the side of their face. Its heavy-duty construction is made with 2 x 4 pine wood. The chest rest stands 30" off the floor, it is 17" long and 16" wide. " It is padded with 2" thick foam which is topped off with a soft yet durable vinyl fabric. It has an adjustable face cradle. This face cradle is the same type that is used on professional massage tables. The face cradle slides in and out, as well as tilt to different angles for maximum comfort. The face cradle extends an additional 10" from the chest rest when it is in the all the way in position. If you slide the face cradle all the way out, it extends an additional 16" from the chest rest. The face cradle allows your sub to stay on the bench for long periods of time without neck crimps. The arm rest are made of 2 x4 x 14" pine wood. They too are padded with two in thick foam and covered with vinyl fabric. The two-knee rest are 19" long and 6" wide. They are designed to be mounted parallel to each other, or at an angle to spread the legs apart. Like the arm, and chest, the knee rest is padded with 2" thick foam and covered with black vinyl fabric. The knee rest, face cradle, and arm supports can all be easily removed for storage, or transporting. There are eye bolts located near the wrist, and ankle portions of the bench that allows for the use of hand or ankle cuffs. This is an excellent bench for people having limited play space.
70245		This is my wooden adjustable length doggy style stockade. It is made from carefully hand sanded and beautifully stained pine wood. The front half of the body of the stockade is made from a piece of 1x4x36" long stained pine wood. The back half of the stockade body is made from a piece of 1 x 4 x 19" pine wood. There is a massage table face cradle at the front of the stockade. It is made of 3" thick foam covered by black vinyl. The wrist stockade is made of a 2 x 4 x 26" pine board. It has 2 1/2" size holes drilled in it. This will fit a medium sized wrist. The feet stockade is made of a 2 x 6 x 15" pine board. It has 3 1/2" holes drilled in it. This will fit medium sized ankles. Send me an email if you would like custom size holes drilled for the stockades. Would you like to see photos of a model using this item? Just drop me an email.
70246		This is my regular spanking bench. It is made of beautifully sanded and painted 2 x 4 wood. The chest rest is 10" wide, and 27" long. It is covered with two inches of foam padding, topped off with a soft, smooth, but durable vinyl. The two-arm rest are made of 2 x 4 cut 14" long. They too are covered with 2" thick foam, then topped off with black vinyl. The two-knee rest are 19" long, and 6" wide. Like the arms, they are covered with 2" thick foam, and black vinyl. The knee rest are designed to be mounted parallel to each other, or at an angle to spread the legs apart. They can also be easily removed for storage. There are four eye bolts located in just the right spot to attach handcuffs and ankle cuffs. There Is plenty of space to add additional eye bolts if you like. This bench is made to be both strong and durable. Comes in black, other colors are available upon request.