Sandbox

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 (330, 331, 391, 390, 393, 389, 388) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "16.81"
    },
    "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": 7,
      "rows_produced_per_join": 7,
      "filtered": "100.00",
      "index_condition": "((`eshopuga_upgr_4122`.`cscart_product_descriptions`.`product_id` in (330,331,391,390,393,389,388)) and (`eshopuga_upgr_4122`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "15.41",
        "eval_cost": "1.40",
        "prefix_cost": "16.81",
        "data_read_per_join": "26K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "meta_keywords",
        "meta_description",
        "search_words",
        "promo_text"
      ]
    }
  }
}

Result

product_id	short_description	promo_text
330	<p><strong>INCLUDES:</strong> Wonderfully displayed in a handsome basket, our Classical Fruit Basket contains the most luscious domestic and tropical fruits available. Fruits may include apples, oranges, grapes, kiwi, pears, nectarines, bananas, pineapple, and coconut as available. A great gift for any occasion.<br></p> <p><strong>INFO: </strong>A basket filled with fresh fruit and seasonal flowers. Ideal for relatives, as a thank you gift, for employees, for convalescence, and for anyone who needs a pick me up. A healthy and impressive gift, this gift basket is overflowing with fresh, delicious, seasonal fruit. Fruit baskets are a traditional and useful gift that express many sentiments, from congratulations and thank you, to the difficult expression of sympathy. Send this gift today and they are sure to appreciate the generous thought and the delicious fruit! Please note, the variety of fruit may vary.</p> <p>Remember, each of our fruit baskets is put together by hand with the best selection of the freshest seasonal fruit! All baskets are made locally!</p>	<p class="text-justify"><b>WE OFFER NO-QUIBBLE GUARANTEE!</b></p> <p class="text-justify">You can order with confidence thanks to our quality guarantees. We take great care and pride in packing all our fruit gift baskets and provide a 7 day freshness guarantee for your peace of mind. But we're human and understand that things don’t always work out as expected - our no quibble guarantee means that we will make things right for you without any hassle.</p>
331	<p><strong>INCLUDES:</strong> One of our most popular baskets, the fruitful basket is filled with a selection of delicious tropical fruits, candies, nuts, crackers, savory jams and jellies and delectable cookies.</p> <p><strong>INFO:</strong> Ideal for relatives, as a thank you gift, for employees, for convalescence, and for anyone who needs a pick me up. A healthy and impressive gift, this gift basket is overflowing with fresh, delicious, seasonal fruit. Fruit baskets are a traditional and useful gift that express many sentiments, from congratulations and thank you, to the difficult expression of sympathy. Send this gift today and they are sure to appreciate the generous thought and the delicious fruit! Please note, the variety of fruit may vary.<br>Remember, each of our fruit baskets is put together by hand with the best selection of the freshest seasonal fruit! All baskets are made locally!</p>	<p><b>WE OFFER NO-QUIBBLE GUARANTEE!</b></p> <p>You can order with confidence thanks to our quality guarantees. We take great care and pride in packing all our fruit gift baskets and provide a 7 day freshness guarantee for your peace of mind. But we're human and understand that things don’t always work out as expected - our no quibble guarantee means that we will make things right for you without any hassle.</p>
388	<p><strong style="background-color: initial;">DETAILS:</strong> You won't have to say a word - the elegant sophistication of these gorgeous white roses will get your message across.</p> <p><strong>DELIVERY:</strong> Deliveries are normally made between 8am and 7pm - (Mon to Sun). However, during busy periods, these delivery times may differ slightly, and we reserve the right to deliver between <strong>7am and 7pm</strong> East African Time (+3GMT). Our florist delivered flowers and arrangements are personally hand delivered by our local florists. Vase are for the purpose of photographs only but can be purchased separately where necessary</p> <p><strong>CONTENT:</strong> All of our flowers, bouquets and arrangements are individually crafted from the freshest blooms. While we always strive to ensure that products are accurately represented in our photographs, from season to season and subject to availability, our florists may be required to substitute one or more flowers for a variety of equal or greater quality, appearance and value. </p>	<p><b>WE OFFER NO-QUIBBLE GUARANTEE!</b></p> <p>You can order with confidence thanks to our quality guarantees. We take great care and pride in packing all our flower and plant gifts and provide a 7 day freshness guarantee for your peace of mind. But we're human and understand that things don’t always work out as expected - our no quibble guarantee means that we will make things right for you without any hassle.</p>
389	<p><strong style="background-color: initial;">DETAILS:</strong> You won't have to say a word - the elegant sophistication of these gorgeous yellow roses will get your message across.</p> <p><strong>DELIVERY:</strong> Deliveries are normally made between 8am and 7pm - (Mon to Sun). However, during busy periods, these delivery times may differ slightly, and we reserve the right to deliver between <strong>7am and 7pm</strong> East African Time (+3GMT). Our florist delivered flowers and arrangements are personally hand delivered by our local florists. Vase are for the purpose of photographs only but can be purchased separately where necessary</p> <p><strong>CONTENT:</strong> All of our flowers, bouquets and arrangements are individually crafted from the freshest blooms. While we always strive to ensure that products are accurately represented in our photographs, from season to season and subject to availability, our florists may be required to substitute one or more flowers for a variety of equal or greater quality, appearance and value. </p>	<p><b>WE OFFER NO-QUIBBLE GUARANTEE!</b></p> <p>You can order with confidence thanks to our quality guarantees. We take great care and pride in packing all our flower and plant gifts and provide a 7 day freshness guarantee for your peace of mind. But we're human and understand that things don’t always work out as expected - our no quibble guarantee means that we will make things right for you without any hassle.</p>
390	<p><strong style="background-color: initial;">DETAILS:</strong> You won't have to say a word - the elegant sophistication of these gorgeous RED roses will get your message across.</p> <p><strong>DELIVERY:</strong> Deliveries are normally made between 8am and 7pm - (Mon to Sun). However, during busy periods, these delivery times may differ slightly, and we reserve the right to deliver between <strong>7am and 7pm</strong> East African Time (+3GMT). Our florist delivered flowers and arrangements are personally hand delivered by our local florists. Vase are for the purpose of photographs only but can be purchased separately where necessary</p> <p><strong>CONTENT:</strong> All of our flowers, bouquets and arrangements are individually crafted from the freshest blooms. While we always strive to ensure that products are accurately represented in our photographs, from season to season and subject to availability, our florists may be required to substitute one or more flowers for a variety of equal or greater quality, appearance and value. </p>	<p><b>WE OFFER NO-QUIBBLE GUARANTEE!</b></p> <p>You can order with confidence thanks to our quality guarantees. We take great care and pride in packing all our flower and plant gifts and provide a 7 day freshness guarantee for your peace of mind. But we're human and understand that things don’t always work out as expected - our no quibble guarantee means that we will make things right for you without any hassle.</p>
391	<p><strong style="background-color: initial;">DETAILS:</strong> You won't have to say a word - the elegant sophistication of these gorgeous ORANGE roses will get your message across.</p> <p><strong>DELIVERY:</strong> Deliveries are normally made between 8am and 7pm - (Mon to Sun). However, during busy periods, these delivery times may differ slightly, and we reserve the right to deliver between <strong>7am and 7pm</strong> East African Time (+3GMT). Our florist delivered flowers and arrangements are personally hand delivered by our local florists. Vase are for the purpose of photographs only but can be purchased separately where necessary</p> <p><strong>CONTENT:</strong> All of our flowers, bouquets and arrangements are individually crafted from the freshest blooms. While we always strive to ensure that products are accurately represented in our photographs, from season to season and subject to availability, our florists may be required to substitute one or more flowers for a variety of equal or greater quality, appearance and value. </p>	<p><b>WE OFFER NO-QUIBBLE GUARANTEE!</b></p> <p>You can order with confidence thanks to our quality guarantees. We take great care and pride in packing all our flower and plant gifts and provide a 7 day freshness guarantee for your peace of mind. But we're human and understand that things don’t always work out as expected - our no quibble guarantee means that we will make things right for you without any hassle.</p>
393	<p><strong style="background-color: initial;">DETAILS:</strong> You won't have to say a word - the elegant sophistication of these LONG STEM WHITE gorgeous roses will get your message across.</p> <p><strong>DELIVERY:</strong> Deliveries are normally made between 8am and 7pm - (Mon to Sun). However, during busy periods, these delivery times may differ slightly, and we reserve the right to deliver between <strong>7am and 7pm</strong> East African Time (+3GMT). Our florist delivered flowers and arrangements are personally hand delivered by our local florists. Vase are for the purpose of photographs only but can be purchased separately where necessary</p> <p><strong>CONTENT:</strong> All of our flowers, bouquets and arrangements are individually crafted from the freshest blooms. While we always strive to ensure that products are accurately represented in our photographs, from season to season and subject to availability, our florists may be required to substitute one or more flowers for a variety of equal or greater quality, appearance and value. </p>	<p><b>WE OFFER NO-QUIBBLE GUARANTEE!</b></p> <p>You can order with confidence thanks to our quality guarantees. We take great care and pride in packing all our flower and plant gifts and provide a 7 day freshness guarantee for your peace of mind. But we're human and understand that things don’t always work out as expected - our no quibble guarantee means that we will make things right for you without any hassle.</p>