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

Query time 0.00005

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
228 <p> &nbsp;</p> <div class="bottom-gradient" style="border-top-width: 0px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px; border-style: initial; border-color: initial; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; background-image: -webkit-linear-gradient(bottom, #f6f6f5, #ffffff 32px); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-bottom-style: solid; border-bottom-color: #cccccc; color: #222222; font-family: Arial, Helvetica, sans-serif; line-height: 14px; text-align: left; padding: 0px; margin: 0px;"> <div class="text-col narrow" style="margin-top: 15px; margin-right: 10px; margin-bottom: 0px; margin-left: 0px; padding-top: 10px; padding-right: 0px; padding-bottom: 0px; padding-left: 40px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; width: 375px; float: left; height: auto; border: 0px initial initial;"> <div class="feature-block feature-block2" style="margin-top: 16px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; padding: 0px; border: 0px initial initial;"> <h3 style="margin-top: 0px; margin-right: 0px; margin-bottom: 0.5em; margin-left: 0px; border-image: initial; font-size: 20px; font: inherit; vertical-align: baseline; font-weight: normal; font-family: BryantLGMedium; text-transform: uppercase; padding: 0px; border: 0px initial initial;"> <span style="border-image: initial; font-size: 20px; font: inherit; vertical-align: baseline; color: #d80546; padding: 0px; margin: 0px; border: 0px initial initial;">さまざまな3D映像方式に対応</span></h3> <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; border: 0px initial initial;"> 「サイドバイサイド」、「トップアンドボトム」、「インターレース(ラインバイライン)」といった様々な３D映像の伝送方式に対応。視聴できる３Dコンテンツの幅が広がります。<br /> ※HDMIケーブルでの接続時のみ各方式への切替に対応します。<br /> <br /> LGのCINEMA 3Dは、偏光フィルムを利用して左右の目で同時に映像を見る構造をとり、3Dメガネのシャッター開閉がないため、3D再生時に生じるフリッカー（ちらつき）や、クロストーク（映像が二重にみえるようなぼやけ）を極限まで低減し、目の負担を軽減することができます。 世界的な第三者試験認証機関であるT&Uuml;V Rheinland（テュフ・ラインランド）やIntertek（インターテック）からも「フリッカーフリー」の3Dモニターとして認証を受けています。</p> </div> </div> <div class="media-col" style="margin-top: 15px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 40px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; float: left; height: auto; border: 0px initial initial;"> <div class="feature-bottom-img" style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px initial initial;"> <span style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px initial initial;"></span></div> </div> </div> <div class="bottom-gradient" style="border-top-width: 0px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px; border-style: initial; border-color: initial; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; background-image: -webkit-linear-gradient(bottom, #f6f6f5, #ffffff 32px); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-bottom-style: solid; border-bottom-color: #cccccc; color: #222222; font-family: Arial, Helvetica, sans-serif; line-height: 14px; text-align: left; padding: 0px; margin: 0px;"> <div class="media-col" style="margin-top: 15px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 40px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; float: left; height: auto; border: 0px initial initial;"> <div class="feature-bottom-img" style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px initial initial;"> <span style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px initial initial;"></span></div> </div> <div class="text-col narrow" style="margin-top: 15px; margin-right: 10px; margin-bottom: 0px; margin-left: 0px; padding-top: 10px; padding-right: 0px; padding-bottom: 0px; padding-left: 40px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; width: 375px; float: left; height: auto; border: 0px initial initial;"> <div class="feature-block feature-block2" style="margin-top: 16px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; padding: 0px; border: 0px initial initial;"> <h3 style="margin-top: 0px; margin-right: 0px; margin-bottom: 0.5em; margin-left: 0px; border-image: initial; font-size: 20px; font: inherit; vertical-align: baseline; font-weight: normal; font-family: BryantLGMedium; text-transform: uppercase; padding: 0px; border: 0px initial initial;"> <span style="border-image: initial; font-size: 20px; font: inherit; vertical-align: baseline; color: #d80546; padding: 0px; margin: 0px; border: 0px initial initial;">軽量設計の快適３Dメガネ付属</span></h3> <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; border: 0px initial initial;"> わずか１６ｇの重さ。他方式の一般的な３Dメガネの3分の１以下の超軽量設計です。<br /> 偏光方式を採用することで、透過性も高く明るい３D映像の視聴が可能です。メガネ本体に電気駆動する機能はないので、電池交換や充電の必要もありません。また、従来の高価な３Dメガネとは異なり、気軽に３Dメガネのみの購入もできるので、家族や友人と一緒に３D映像を楽しむこともできます。</p> </div> </div> </div> <div class="bottom-gradient" style="border-top-width: 0px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px; border-style: initial; border-color: initial; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; background-image: -webkit-linear-gradient(bottom, #f6f6f5, #ffffff 32px); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-bottom-style: solid; border-bottom-color: #cccccc; color: #222222; font-family: Arial, Helvetica, sans-serif; line-height: 14px; text-align: left; padding: 0px; margin: 0px;"> <div class="text-col narrow" style="margin-top: 15px; margin-right: 10px; margin-bottom: 0px; margin-left: 0px; padding-top: 10px; padding-right: 0px; padding-bottom: 0px; padding-left: 40px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; width: 375px; float: left; height: auto; border: 0px initial initial;"> <div class="feature-block feature-block2" style="margin-top: 16px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; padding: 0px; border: 0px initial initial;"> <h3 style="margin-top: 0px; margin-right: 0px; margin-bottom: 0.5em; margin-left: 0px; border-image: initial; font-size: 20px; font: inherit; vertical-align: baseline; font-weight: normal; font-family: BryantLGMedium; text-transform: uppercase; padding: 0px; border: 0px initial initial;"> <span style="border-image: initial; font-size: 20px; font: inherit; vertical-align: baseline; color: #d80546; padding: 0px; margin: 0px; border: 0px initial initial;">３D映像を明るく鮮明に再現</span></h3> <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; border: 0px initial initial;"> 3Dカラーエフェクト機能を使用することで、３Dモードの画質を最適化します。 暗くなりがちだった３D映像を明るくし、クリアな３Dを実現します。</p> </div> </div> <div class="media-col" style="margin-top: 15px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 40px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; float: left; height: auto; border: 0px initial initial;"> <div class="feature-bottom-img" style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px initial initial;"> <span style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px initial initial;"></span></div> </div> </div> <div class="bottom-gradient" style="border-top-width: 0px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px; border-style: initial; border-color: initial; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; background-image: -webkit-linear-gradient(bottom, #f6f6f5, #ffffff 32px); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-bottom-style: solid; border-bottom-color: #cccccc; color: #222222; font-family: Arial, Helvetica, sans-serif; line-height: 14px; text-align: left; padding: 0px; margin: 0px;"> <div class="media-col" style="margin-top: 15px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 40px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; float: left; height: auto; border: 0px initial initial;"> <div class="feature-bottom-img" style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px initial initial;"> <span style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px initial initial;"></span></div> </div> <div class="text-col narrow" style="margin-top: 15px; margin-right: 10px; margin-bottom: 0px; margin-left: 0px; padding-top: 10px; padding-right: 0px; padding-bottom: 0px; padding-left: 40px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; width: 375px; float: left; height: auto; border: 0px initial initial;"> <div class="feature-block feature-block2" style="margin-top: 16px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; padding: 0px; border: 0px initial initial;"> <h3 style="margin-top: 0px; margin-right: 0px; margin-bottom: 0.5em; margin-left: 0px; border-image: initial; font-size: 20px; font: inherit; vertical-align: baseline; font-weight: normal; font-family: BryantLGMedium; text-transform: uppercase; padding: 0px; border: 0px initial initial;"> <span style="border-image: initial; font-size: 20px; font: inherit; vertical-align: baseline; color: #d80546; padding: 0px; margin: 0px; border: 0px initial initial;">3D対応ゲーム機などにも接続</span></h3> <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; border: 0px initial initial;"> HDMI 1.4a端子を搭載しているので、３D対応のゲーム機やブルーレイプレーヤーを接続して３Dコンテンツを楽しめます。もちろん通常の２Dで表示するモニターとしてもご使用いただけます。<br /><br />※全てのHDMI接続機器は、３D対応コンテンツの正常な動きを保証するものではありません。 </p> </div> </div> </div> <p> &nbsp;</p>