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, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (204) 
  AND cscart_product_descriptions.lang_code = 'tr'

Query time 0.00021

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    }
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text	unit_name
204		<p><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">Collecting The Police's drummer's solo work on one CD. </span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">Track Listing:</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">1. Too Kool To Kalypso </span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">2. Don't Box Me In</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">3. Tulsa Tango</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">4. Koteja </span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">5. Serengeti Long Walk</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">6. Equalizer Main Title</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">7. Anacott Steel</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">8. Slither</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">9. Night Drive </span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">10. Taxi Ride Home</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">11. Bill Is Dead</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">12. Wield the Spade </span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">13. Look Up </span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">14. Rain</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">15. Childhood Friends</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">16. Mud Lions </span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">17. Pizica Degli Ucci</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">18. Chrystal/Drive Daisy/End Title</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">19. George Trip/End Montage/End Title</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">20. Big Drum Tribe </span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">21. Regret</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">(5OCD09)</span></p>				<p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>