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 (195) 
  AND cscart_product_descriptions.lang_code = 'ja'

Query time 0.00032

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
195		<p> 内容（「キネマ旬報社」データベースより）: <br />2010年6月にシカゴで行われた「クロスロード・ギター・フェスティヴァル」の模様を映像化。<br /> エリック・クラプトンを中心に、ジェフ・ベック、スティーヴ・ウィンウッドらギターの名手たちの11時間にも及ぶステージからハイライトシーンを収録。2枚組。</p> <p> DVD 1:</p> <p> 01 Promise Land - By Sonny Landreth with Eric Clapton</p> <p> 02 Z. Rider - By Sonny Landreth with Eric Clapton</p> <p> 03 Traveling Shoes - By Robert Randolph & The Family Band</p> <p> 04 Going Down - By Pino Daniele, Joe Bonamassa, Robert Randolph & The Family Band</p> <p> 05 Killing Floor - By Robert Cray with Jimmie Vaughan & Hubert Sumlin</p> <p> 06 Six Strings Down - By Jimmie Vaughan with Robert Cray & Hubert Sumlin</p> <p> 07 Waiting For The Bus - By ZZ Top</p> <p> 08 Jesus Just Left Chicago - By ZZ Top</p> <p> 09 Gypsy Blood - By Doyle Bramhall II</p> <p> 10 In My Time Of Dying (Jesus Make Up My Dying Bed) - By Doyle Bramhall II</p> <p> 11 Bright Lights - By Gary Clark Jr.</p> <p> 12 Long Road Home - By Sheryl Crow with Derek Trucks, Susan Tedeschi, Doyle Bramhall II & Gary Clark Jr.</p> <p> 13 Our Love Is Fading - By Sheryl Crow with Eric Clapton, Doyle Bramhall II & Gary Clark Jr.</p> <p> 14 Blackwaterside - By Bert Jansch</p> <p> 15 Mississippi Blues - By Stefan Grossman & Keb' Mo'</p> <p> 16 Roll And Tumble Blues - By Stefan Grossman</p> <p> 17 One More Last Chance - By Vince Gill with Keb' Mo', James Burton, Earl Klugh & Albert Lee</p> <p> 18 Mystery Train - By Vince Gill with James Burton, Albert Lee, Keb' Mo' & Earl Klugh</p> <p> 19 Lay Down Sally - By Vince Gill with Sheryl Crow, Keb' Mo', Albert Lee, James Burton & Earl Klugh</p> <p> 20 Angelina - By Earl Klugh</p> <p> 21 Vonetta - By Earl Klugh</p> <p> 22 Who Did You Think I Was - By John Mayer Trio</p> <p> 23 Ain't No Sunshine - By John Mayer Trio</p> <p>  </p> <p> DVD 2:</p> <p> 01 Midnight In Harlem - By Derek Trucks & Susan Tedeschi Band</p> <p> 02 Coming Home - By Derek Trucks & Susan Tedeschi Band with Warren Haynes</p> <p> 03 Soulshine - By Warren Haynes</p> <p> 04 Don't Keep Me Wondering - By David Hidalgo & Cesar Rosas with Derek Trucks</p> <p> 05 Space Captain - By Derek Trucks & Susan Tedeschi Band with Warren Haynes, David Hidalgo, Cesar Rosas & Chris Stainton</p> <p> 06 Five Long Years - By Buddy Guy with Jonny Lang & Ronnie Wood</p> <p> 07 Miss You - By Buddy Guy with Jonny Lang & Ronnie Wood</p> <p> 08 Hammerhead - By Jeff Beck</p> <p> 09 Nessun Dorma - By Jeff Beck</p> <p> 10 Crossroads</p> <p> 11 Hands Of The Saints - By Citizen Cope & Eric Clapton</p> <p> 12 I Shot The Sheriff</p> <p> 13 Shake Your Money Maker - By Eric Clapton & Jeff Beck</p> <p> 14 Had To Cry Today - By Steve Winwood & Eric Clapton</p> <p> 15 Voodoo Chile - By Eric Clapton & Steve Winwood</p> <p> 16 Dear Mr. Fantasy - By Steve Winwood & Eric Clapton</p> <p> 17 The Thrill Is Gone - By B.B. King & Ensemble</p> <div>  </div> <p>  </p>