SELECT 
  * 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  product_id = 130 
  AND company_id = 1 
  AND lang_code = 'en'

Query time 0.00063

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "table": {
      "table_name": "cscart_ult_product_descriptions",
      "access_type": "const",
      "possible_keys": [
        "PRIMARY",
        "product_id",
        "company_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code",
        "company_id"
      ],
      "key_length": "13",
      "ref": [
        "const",
        "const",
        "const"
      ],
      "rows_examined_per_scan": 1,
      "rows_produced_per_join": 1,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "0.00",
        "eval_cost": "0.20",
        "prefix_cost": "0.00",
        "data_read_per_join": "3K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "company_id",
        "product",
        "shortname",
        "short_description",
        "full_description",
        "meta_keywords",
        "meta_description",
        "search_words",
        "page_title",
        "age_warning_message",
        "promo_text"
      ]
    }
  }
}

Result

product_id lang_code company_id product shortname short_description full_description meta_keywords meta_description search_words page_title age_warning_message promo_text
130 en 1 Casio DR-210TM <table class="defTBL" style="word-wrap: break-word; color: #555555; font-family: Helvetica, sans-serif; font-size: 12px; line-height: 18px; text-align: left; background-color: #ffffff;" width="79%"> <thead style="word-wrap: break-word;"> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">DR-210TM Technical Specifications</strong></div> </th> </tr> </thead> <tbody style="word-wrap: break-word;"> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Display</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Digits</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">12</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Type</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">Digitron</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Special</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">Large Display</div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Printer</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Speed - lines/second</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">4.4</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Print Color</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">2 Color-Black/Red</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Type</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">Ribbon</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Ink Ribbon</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">RB-02</div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Features</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Decimal Selector</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">Floating or fixed decimal 0,1,2,3,4,6</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Item Counter</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Independent Memory</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Printing Reference Numbers</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Tax Calculation</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Automatic Constants</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Independent Add Register</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Grand Total</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">MU/MD</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Feed</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Right Shift Key</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Round Off</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Round Up</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Cut Off</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">ADD Mode</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Cost/Sell/Margin</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Paper</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">2-1/4 inch plain</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Power</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Type</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">AC</div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Unit Dimensions</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Size (inches)&nbsp; H x W x L</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">4-3/10" x 8-2/5" x 15"</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Weight oz/lbs</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">3.7 lbs</div> </td> </tr> </tbody> </table> <p> <p style="word-wrap: break-word; margin-top: 10px; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; line-height: 1.25em; color: #555555; font-family: Helvetica, sans-serif; font-size: 12px; text-align: left; background-color: #ffffff;">Technical Specifications Subject to Change</p> </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>