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 (
    392240, 392241, 392233, 392230, 392231, 
    392232, 392229, 392223, 392224, 392225, 
    392226, 392227, 392228, 392222, 392219, 
    392220, 392221, 392211, 392210
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00121

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "26.64"
    },
    "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": 19,
      "rows_produced_per_join": 19,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "22.84",
        "eval_cost": "3.80",
        "prefix_cost": "26.64",
        "data_read_per_join": "129K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (392240,392241,392233,392230,392231,392232,392229,392223,392224,392225,392226,392227,392228,392222,392219,392220,392221,392211,392210)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
392210 <p></p> <ul><li><span class="a-list-item">95% Polyester, 5% Spandex </span></li><li><span class="a-list-item">Imported </span></li><li><span class="a-list-item">Button closure </span></li><li><span class="a-list-item">Machine Wash </span></li><li><span class="a-list-item">【Fabric】95% polyester & 5% spandex. The fabric is light, breathable and elastic. </span></li><li><span class="a-list-item">【High Quality Polo Shirt】This men's polo shirt is made of high elastic fabric, which is breathable and wrinkle-resistant and not pilling. Comfortable and breathable, sweat-absorbing effect is good, so you are not afraid of hot summer days.This golf polo is one of the necessities of summer shirt. </span></li><li><span class="a-list-item">【Special Design】On the basis of collared shirt, the stripe contrast design is added to the cuff edge and placket, which makes the whole dress more fashionable and energetic than the classic polo style.</span></li></ul>
392211 <p></p> <ul><li><span class="a-list-item">100% Polyester&nbsp;</span></li><li><span class="a-list-item">Imported&nbsp;</span></li><li><span class="a-list-item">Button closure&nbsp;</span></li><li><span class="a-list-item">Machine Wash&nbsp;</span></li><li><span class="a-list-item">PLAIN BLUE: Do you like to stand out from the crowd? In these fun clothes you'll definitely do. This blue suit for men is your go-to outfit for several occasions, like a bachelor party, a prom, and a festival. Or create the flag of the United States of America with a blue, red and white suit for the 4th of July and Independence Day. Dress to impress!&nbsp;</span></li><li><span class="a-list-item">CHECK YOUR SIZE: Our suits are outstanding in any situation, so make sure to measure yourself! You don't want to ruin the party with a small suit, do you? Check the measure guide within the images and make sure you receive a size that suits you! The Suit fitting is Slim Fit, so if you are doubting between two sizes, we advise to pick the larger one!&nbsp;</span></li><li><span class="a-list-item">PERFECT FOR ANY OCCASION: Stylish, high-quality suit. Offstream suits are great as a Halloween costume, Outdoor Events, Celebrations, Homecoming and Prom. For when you need to be the best looking at the party.</span></li></ul>
392219 <p></p> <ul><li><span class="a-list-item">100% Polyester&nbsp;</span></li><li><span class="a-list-item">Imported&nbsp;</span></li><li><span class="a-list-item">Button closure&nbsp;</span></li><li><span class="a-list-item">Machine Wash&nbsp;</span></li><li><span class="a-list-item">PLAIN BLUE: Do you like to stand out from the crowd? In these fun clothes you'll definitely do. This blue suit for men is your go-to outfit for several occasions, like a bachelor party, a prom, and a festival. Or create the flag of the United States of America with a blue, red and white suit for the 4th of July and Independence Day. Dress to impress!&nbsp;</span></li><li><span class="a-list-item">CHECK YOUR SIZE: Our suits are outstanding in any situation, so make sure to measure yourself! You don't want to ruin the party with a small suit, do you? Check the measure guide within the images and make sure you receive a size that suits you! The Suit fitting is Slim Fit, so if you are doubting between two sizes, we advise to pick the larger one!&nbsp;</span></li><li><span class="a-list-item">PERFECT FOR ANY OCCASION: Stylish, high-quality suit. Offstream suits are great as a Halloween costume, Outdoor Events, Celebrations, Homecoming and Prom. For when you need to be the best looking at the party.</span></li></ul>
392220 <p></p> <ul><li><span class="a-list-item">100% Polyester&nbsp;</span></li><li><span class="a-list-item">Imported&nbsp;</span></li><li><span class="a-list-item">Button closure&nbsp;</span></li><li><span class="a-list-item">Machine Wash&nbsp;</span></li><li><span class="a-list-item">PLAIN BLUE: Do you like to stand out from the crowd? In these fun clothes you'll definitely do. This blue suit for men is your go-to outfit for several occasions, like a bachelor party, a prom, and a festival. Or create the flag of the United States of America with a blue, red and white suit for the 4th of July and Independence Day. Dress to impress!&nbsp;</span></li><li><span class="a-list-item">CHECK YOUR SIZE: Our suits are outstanding in any situation, so make sure to measure yourself! You don't want to ruin the party with a small suit, do you? Check the measure guide within the images and make sure you receive a size that suits you! The Suit fitting is Slim Fit, so if you are doubting between two sizes, we advise to pick the larger one!&nbsp;</span></li><li><span class="a-list-item">PERFECT FOR ANY OCCASION: Stylish, high-quality suit. Offstream suits are great as a Halloween costume, Outdoor Events, Celebrations, Homecoming and Prom. For when you need to be the best looking at the party.</span></li></ul>
392221 <p></p> <ul><li><span class="a-list-item">100% Polyester&nbsp;</span></li><li><span class="a-list-item">Imported&nbsp;</span></li><li><span class="a-list-item">Button closure&nbsp;</span></li><li><span class="a-list-item">Machine Wash&nbsp;</span></li><li><span class="a-list-item">PLAIN BLUE: Do you like to stand out from the crowd? In these fun clothes you'll definitely do. This blue suit for men is your go-to outfit for several occasions, like a bachelor party, a prom, and a festival. Or create the flag of the United States of America with a blue, red and white suit for the 4th of July and Independence Day. Dress to impress!&nbsp;</span></li><li><span class="a-list-item">CHECK YOUR SIZE: Our suits are outstanding in any situation, so make sure to measure yourself! You don't want to ruin the party with a small suit, do you? Check the measure guide within the images and make sure you receive a size that suits you! The Suit fitting is Slim Fit, so if you are doubting between two sizes, we advise to pick the larger one!&nbsp;</span></li><li><span class="a-list-item">PERFECT FOR ANY OCCASION: Stylish, high-quality suit. Offstream suits are great as a Halloween costume, Outdoor Events, Celebrations, Homecoming and Prom. For when you need to be the best looking at the party.</span></li></ul>
392222 <p></p> <ul><li><span class="a-list-item">95% Polyester, 5% Spandex </span></li><li><span class="a-list-item">Imported </span></li><li><span class="a-list-item">Button closure </span></li><li><span class="a-list-item">Machine Wash </span></li><li><span class="a-list-item">【Fabric】95% polyester & 5% spandex. The fabric is light, breathable and elastic. </span></li><li><span class="a-list-item">【High Quality Polo Shirt】This men's polo shirt is made of high elastic fabric, which is breathable and wrinkle-resistant and not pilling. Comfortable and breathable, sweat-absorbing effect is good, so you are not afraid of hot summer days.This golf polo is one of the necessities of summer shirt. </span></li><li><span class="a-list-item">【Special Design】On the basis of collared shirt, the stripe contrast design is added to the cuff edge and placket, which makes the whole dress more fashionable and energetic than the classic polo style.</span></li></ul>
392223 <p></p> <ul><li><span class="a-list-item">100% Polyester&nbsp;</span></li><li><span class="a-list-item">Imported&nbsp;</span></li><li><span class="a-list-item">Button closure&nbsp;</span></li><li><span class="a-list-item">Machine Wash&nbsp;</span></li><li><span class="a-list-item">PLAIN BLUE: Do you like to stand out from the crowd? In these fun clothes you'll definitely do. This blue suit for men is your go-to outfit for several occasions, like a bachelor party, a prom, and a festival. Or create the flag of the United States of America with a blue, red and white suit for the 4th of July and Independence Day. Dress to impress!&nbsp;</span></li><li><span class="a-list-item">CHECK YOUR SIZE: Our suits are outstanding in any situation, so make sure to measure yourself! You don't want to ruin the party with a small suit, do you? Check the measure guide within the images and make sure you receive a size that suits you! The Suit fitting is Slim Fit, so if you are doubting between two sizes, we advise to pick the larger one!&nbsp;</span></li><li><span class="a-list-item">PERFECT FOR ANY OCCASION: Stylish, high-quality suit. Offstream suits are great as a Halloween costume, Outdoor Events, Celebrations, Homecoming and Prom. For when you need to be the best looking at the party.</span></li></ul>
392224 <p></p> <ul><li><span class="a-list-item">100% Polyester&nbsp;</span></li><li><span class="a-list-item">Imported&nbsp;</span></li><li><span class="a-list-item">Button closure&nbsp;</span></li><li><span class="a-list-item">Machine Wash&nbsp;</span></li><li><span class="a-list-item">PLAIN BLUE: Do you like to stand out from the crowd? In these fun clothes you'll definitely do. This blue suit for men is your go-to outfit for several occasions, like a bachelor party, a prom, and a festival. Or create the flag of the United States of America with a blue, red and white suit for the 4th of July and Independence Day. Dress to impress!&nbsp;</span></li><li><span class="a-list-item">CHECK YOUR SIZE: Our suits are outstanding in any situation, so make sure to measure yourself! You don't want to ruin the party with a small suit, do you? Check the measure guide within the images and make sure you receive a size that suits you! The Suit fitting is Slim Fit, so if you are doubting between two sizes, we advise to pick the larger one!&nbsp;</span></li><li><span class="a-list-item">PERFECT FOR ANY OCCASION: Stylish, high-quality suit. Offstream suits are great as a Halloween costume, Outdoor Events, Celebrations, Homecoming and Prom. For when you need to be the best looking at the party.</span></li></ul>
392225 <p></p> <ul><li><span class="a-list-item">100% Polyester&nbsp;</span></li><li><span class="a-list-item">Imported&nbsp;</span></li><li><span class="a-list-item">Button closure&nbsp;</span></li><li><span class="a-list-item">Machine Wash&nbsp;</span></li><li><span class="a-list-item">PLAIN BLUE: Do you like to stand out from the crowd? In these fun clothes you'll definitely do. This blue suit for men is your go-to outfit for several occasions, like a bachelor party, a prom, and a festival. Or create the flag of the United States of America with a blue, red and white suit for the 4th of July and Independence Day. Dress to impress!&nbsp;</span></li><li><span class="a-list-item">CHECK YOUR SIZE: Our suits are outstanding in any situation, so make sure to measure yourself! You don't want to ruin the party with a small suit, do you? Check the measure guide within the images and make sure you receive a size that suits you! The Suit fitting is Slim Fit, so if you are doubting between two sizes, we advise to pick the larger one!&nbsp;</span></li><li><span class="a-list-item">PERFECT FOR ANY OCCASION: Stylish, high-quality suit. Offstream suits are great as a Halloween costume, Outdoor Events, Celebrations, Homecoming and Prom. For when you need to be the best looking at the party.</span></li></ul>
392226 <p></p> <ul><li><span class="a-list-item">100% Polyester&nbsp;</span></li><li><span class="a-list-item">Imported&nbsp;</span></li><li><span class="a-list-item">Button closure&nbsp;</span></li><li><span class="a-list-item">Machine Wash&nbsp;</span></li><li><span class="a-list-item">PLAIN BLUE: Do you like to stand out from the crowd? In these fun clothes you'll definitely do. This blue suit for men is your go-to outfit for several occasions, like a bachelor party, a prom, and a festival. Or create the flag of the United States of America with a blue, red and white suit for the 4th of July and Independence Day. Dress to impress!&nbsp;</span></li><li><span class="a-list-item">CHECK YOUR SIZE: Our suits are outstanding in any situation, so make sure to measure yourself! You don't want to ruin the party with a small suit, do you? Check the measure guide within the images and make sure you receive a size that suits you! The Suit fitting is Slim Fit, so if you are doubting between two sizes, we advise to pick the larger one!&nbsp;</span></li><li><span class="a-list-item">PERFECT FOR ANY OCCASION: Stylish, high-quality suit. Offstream suits are great as a Halloween costume, Outdoor Events, Celebrations, Homecoming and Prom. For when you need to be the best looking at the party.</span></li></ul>
392227 <p></p> <ul><li><span class="a-list-item">100% Polyester&nbsp;</span></li><li><span class="a-list-item">Imported&nbsp;</span></li><li><span class="a-list-item">Button closure&nbsp;</span></li><li><span class="a-list-item">Machine Wash&nbsp;</span></li><li><span class="a-list-item">PLAIN BLUE: Do you like to stand out from the crowd? In these fun clothes you'll definitely do. This blue suit for men is your go-to outfit for several occasions, like a bachelor party, a prom, and a festival. Or create the flag of the United States of America with a blue, red and white suit for the 4th of July and Independence Day. Dress to impress!&nbsp;</span></li><li><span class="a-list-item">CHECK YOUR SIZE: Our suits are outstanding in any situation, so make sure to measure yourself! You don't want to ruin the party with a small suit, do you? Check the measure guide within the images and make sure you receive a size that suits you! The Suit fitting is Slim Fit, so if you are doubting between two sizes, we advise to pick the larger one!&nbsp;</span></li><li><span class="a-list-item">PERFECT FOR ANY OCCASION: Stylish, high-quality suit. Offstream suits are great as a Halloween costume, Outdoor Events, Celebrations, Homecoming and Prom. For when you need to be the best looking at the party.</span></li></ul>
392228 <p></p> <ul><li><span class="a-list-item">100% Polyester&nbsp;</span></li><li><span class="a-list-item">Imported&nbsp;</span></li><li><span class="a-list-item">Button closure&nbsp;</span></li><li><span class="a-list-item">Machine Wash&nbsp;</span></li><li><span class="a-list-item">PLAIN BLUE: Do you like to stand out from the crowd? In these fun clothes you'll definitely do. This blue suit for men is your go-to outfit for several occasions, like a bachelor party, a prom, and a festival. Or create the flag of the United States of America with a blue, red and white suit for the 4th of July and Independence Day. Dress to impress!&nbsp;</span></li><li><span class="a-list-item">CHECK YOUR SIZE: Our suits are outstanding in any situation, so make sure to measure yourself! You don't want to ruin the party with a small suit, do you? Check the measure guide within the images and make sure you receive a size that suits you! The Suit fitting is Slim Fit, so if you are doubting between two sizes, we advise to pick the larger one!&nbsp;</span></li><li><span class="a-list-item">PERFECT FOR ANY OCCASION: Stylish, high-quality suit. Offstream suits are great as a Halloween costume, Outdoor Events, Celebrations, Homecoming and Prom. For when you need to be the best looking at the party.</span></li></ul>
392229 <p></p> <ul><li><span class="a-list-item">95% Polyester, 5% Spandex </span></li><li><span class="a-list-item">Imported </span></li><li><span class="a-list-item">Button closure </span></li><li><span class="a-list-item">Machine Wash </span></li><li><span class="a-list-item">【Fabric】95% polyester & 5% spandex. The fabric is light, breathable and elastic. </span></li><li><span class="a-list-item">【High Quality Polo Shirt】This men's polo shirt is made of high elastic fabric, which is breathable and wrinkle-resistant and not pilling. Comfortable and breathable, sweat-absorbing effect is good, so you are not afraid of hot summer days.This golf polo is one of the necessities of summer shirt. </span></li><li><span class="a-list-item">【Special Design】On the basis of collared shirt, the stripe contrast design is added to the cuff edge and placket, which makes the whole dress more fashionable and energetic than the classic polo style.</span></li></ul>
392230 <p></p> <ul><li><span class="a-list-item">95% Polyester, 5% Spandex </span></li><li><span class="a-list-item">Imported </span></li><li><span class="a-list-item">Button closure </span></li><li><span class="a-list-item">Machine Wash </span></li><li><span class="a-list-item">【Fabric】95% polyester & 5% spandex. The fabric is light, breathable and elastic. </span></li><li><span class="a-list-item">【High Quality Polo Shirt】This men's polo shirt is made of high elastic fabric, which is breathable and wrinkle-resistant and not pilling. Comfortable and breathable, sweat-absorbing effect is good, so you are not afraid of hot summer days.This golf polo is one of the necessities of summer shirt. </span></li><li><span class="a-list-item">【Special Design】On the basis of collared shirt, the stripe contrast design is added to the cuff edge and placket, which makes the whole dress more fashionable and energetic than the classic polo style.</span></li></ul>
392231 <p></p> <ul><li><span class="a-list-item">95% Polyester, 5% Spandex </span></li><li><span class="a-list-item">Imported </span></li><li><span class="a-list-item">Button closure </span></li><li><span class="a-list-item">Machine Wash </span></li><li><span class="a-list-item">【Fabric】95% polyester & 5% spandex. The fabric is light, breathable and elastic. </span></li><li><span class="a-list-item">【High Quality Polo Shirt】This men's polo shirt is made of high elastic fabric, which is breathable and wrinkle-resistant and not pilling. Comfortable and breathable, sweat-absorbing effect is good, so you are not afraid of hot summer days.This golf polo is one of the necessities of summer shirt. </span></li><li><span class="a-list-item">【Special Design】On the basis of collared shirt, the stripe contrast design is added to the cuff edge and placket, which makes the whole dress more fashionable and energetic than the classic polo style.</span></li></ul>
392232 <p></p> <ul><li><span class="a-list-item">95% Polyester, 5% Spandex </span></li><li><span class="a-list-item">Imported </span></li><li><span class="a-list-item">Button closure </span></li><li><span class="a-list-item">Machine Wash </span></li><li><span class="a-list-item">【Fabric】95% polyester & 5% spandex. The fabric is light, breathable and elastic. </span></li><li><span class="a-list-item">【High Quality Polo Shirt】This men's polo shirt is made of high elastic fabric, which is breathable and wrinkle-resistant and not pilling. Comfortable and breathable, sweat-absorbing effect is good, so you are not afraid of hot summer days.This golf polo is one of the necessities of summer shirt. </span></li><li><span class="a-list-item">【Special Design】On the basis of collared shirt, the stripe contrast design is added to the cuff edge and placket, which makes the whole dress more fashionable and energetic than the classic polo style.</span></li></ul>
392233 <p></p> <ul><li><span class="a-list-item">70% polyester 30% viscose </span></li><li><span class="a-list-item">Imported </span></li><li><span class="a-list-item">Button closure </span></li><li><span class="a-list-item">Dry Clean Only </span></li><li><span class="a-list-item">【Quality Fabric and Workmanship】 Our suits are made of 70% polyester + 30% viscose, the combination of high quality stretch fabric and meticulous craftsmanship makes this suit more breathable, soft, smooth and wrinkle free, easier to wash and keep the shape slim, designed by professional designers, simple style, a basic suit for everyday wear. </span></li><li><span class="a-list-item">【Multi-occasion】The classic and stylish check stripe design of the Antonio Uomo men's suit makes it suitable for many occasions, such as business meetings, weddings, everyday life, graduation parties, dating, grand holidays and more. It is also a great gift for fathers, brothers, husbands and male friends, which can make men more charming in different occasions. </span></li><li><span class="a-list-item">【Features】Blazer:Full shoulder design, slim fit, two button closure, notched lapels, 3 practical inside pocket openings, 2 front flap pockets, one practical handkerchief pocket; Vest: v-neck vest/single breasted 5 buttons; Trousers: flat front, invisible zip, adjustable waist. Slim fit suits are a little tighter than regular suits, when you wear it you will be slimmer and sharper.</span></li></ul>
392240 <p></p> <ul><li><span class="a-list-item">70% polyester 30% viscose </span></li><li><span class="a-list-item">Imported </span></li><li><span class="a-list-item">Button closure </span></li><li><span class="a-list-item">Dry Clean Only </span></li><li><span class="a-list-item">【Quality Fabric and Workmanship】 Our suits are made of 70% polyester + 30% viscose, the combination of high quality stretch fabric and meticulous craftsmanship makes this suit more breathable, soft, smooth and wrinkle free, easier to wash and keep the shape slim, designed by professional designers, simple style, a basic suit for everyday wear. </span></li><li><span class="a-list-item">【Multi-occasion】The classic and stylish check stripe design of the Antonio Uomo men's suit makes it suitable for many occasions, such as business meetings, weddings, everyday life, graduation parties, dating, grand holidays and more. It is also a great gift for fathers, brothers, husbands and male friends, which can make men more charming in different occasions. </span></li><li><span class="a-list-item">【Features】Blazer:Full shoulder design, slim fit, two button closure, notched lapels, 3 practical inside pocket openings, 2 front flap pockets, one practical handkerchief pocket; Vest: v-neck vest/single breasted 5 buttons; Trousers: flat front, invisible zip, adjustable waist. Slim fit suits are a little tighter than regular suits, when you wear it you will be slimmer and sharper.</span></li></ul>
392241 <p></p> <ul><li><span class="a-list-item">70% polyester 30% viscose </span></li><li><span class="a-list-item">Imported </span></li><li><span class="a-list-item">Button closure </span></li><li><span class="a-list-item">Dry Clean Only </span></li><li><span class="a-list-item">【Quality Fabric and Workmanship】 Our suits are made of 70% polyester + 30% viscose, the combination of high quality stretch fabric and meticulous craftsmanship makes this suit more breathable, soft, smooth and wrinkle free, easier to wash and keep the shape slim, designed by professional designers, simple style, a basic suit for everyday wear. </span></li><li><span class="a-list-item">【Multi-occasion】The classic and stylish check stripe design of the Antonio Uomo men's suit makes it suitable for many occasions, such as business meetings, weddings, everyday life, graduation parties, dating, grand holidays and more. It is also a great gift for fathers, brothers, husbands and male friends, which can make men more charming in different occasions. </span></li><li><span class="a-list-item">【Features】Blazer:Full shoulder design, slim fit, two button closure, notched lapels, 3 practical inside pocket openings, 2 front flap pockets, one practical handkerchief pocket; Vest: v-neck vest/single breasted 5 buttons; Trousers: flat front, invisible zip, adjustable waist. Slim fit suits are a little tighter than regular suits, when you wear it you will be slimmer and sharper.</span></li></ul>