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

Query time 0.00043

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
128 en 1 Casio FX-115ES <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;" border="0" width="95%"> <tbody style="word-wrap: break-word;"> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Number of Functions</strong></td> <td style="word-wrap: break-word;">279</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Display</strong></td> <td style="word-wrap: break-word;">&nbsp;</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">2-Line Digit</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Natural Textbook</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Digits</td> <td style="word-wrap: break-word;">10 + 2</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Memory</strong></td> <td style="word-wrap: break-word;">&nbsp;</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Store/Recall</td> <td style="word-wrap: break-word;">Yes/Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Recall &amp; Edit values</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Number of independent memories</td> <td style="word-wrap: break-word;">1</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Number of constant memories</td> <td style="word-wrap: break-word;">6</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Features</strong></td> <td style="word-wrap: break-word;">&nbsp;</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Operating system</td> <td style="word-wrap: break-word;">S - V.P.A.M</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Protective hard case</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Clear last entry and clear all</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Review &amp; edit preview entries</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Overhead Model Available</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Fixed decemial capabilities</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Multi-replay</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Plastic Keys</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Mathematics</strong></td> <td style="word-wrap: break-word;">&nbsp;</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Metric conversions</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Scientific notation</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Parenthesis/Constant</td> <td style="word-wrap: break-word;">Yes/-</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Pi</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Xth root</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Fraction calculations</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Complex numbers</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">DMS &lt;&gt; DD / P &lt;&gt; R Conversions</td> <td style="word-wrap: break-word;">Yes/Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Trigonometry</strong></td> <td style="word-wrap: break-word;">&nbsp;</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Sin, Cos, Tan, &amp; Inverses</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Hyperbolic Functions</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Converts between DEG, RAD, GRAD</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Statistics</strong></td> <td style="word-wrap: break-word;">&nbsp;</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">One/two variable</td> <td style="word-wrap: break-word;">Yes/Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Mean, sum, # elements</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Standard Deviation</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Linear Regression</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Log, In, Inverse Log, Exponential</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Store and edit data in memory</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Quadratic, log, exp, power, inverse regression</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">nPr, cPr, x!</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Random number generator</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Calculus</strong></td> <td style="word-wrap: break-word;">&nbsp;</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Complex number calculations</td> <td style="word-wrap: break-word;">No</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Numeric integration</td> <td style="word-wrap: break-word;">No</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Numeric differential calculations</td> <td style="word-wrap: break-word;">No</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Power/Unit Dimensions</strong></td> <td style="word-wrap: break-word;">&nbsp;</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Power</td> <td style="word-wrap: break-word;">Solar Plus w/Battery back-up</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Auto Power Off</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Battery</td> <td style="word-wrap: break-word;">-</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Size (H x W x L) Inches</td> <td style="word-wrap: break-word;">Not available</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Weight (ounces)</td> <td style="word-wrap: break-word;">Not available</td> </tr> </tbody> </table> <p>&nbsp;</p> <p class="contentTextGray" 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 class="contentTextGray" 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;">The FX-115ES is permitted on AP, SAT and PSAT/NMSQT. Policies are subject to change. Visit<a style="word-wrap: break-word; color: #00349a; text-decoration: underline;" href="http://www.collegeboard.com/" target="_blank">www.collegeboard.com</a>for more information.</p> <p>&nbsp;</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>