SELECT 
  * 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  product_id = 718 
  AND company_id = 2 
  AND lang_code = 'en'

Query time 0.00029

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_ult_product_descriptions const PRIMARY,product_id,company_id PRIMARY 13 const,const,const 1

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 youtube_link show_youtube_video replace_main_image custom_header
718 en 2 FAKRO adaptation module ZWMA <p style="text-align: justify;">ZWMA adaptation module makes it possible to control FAKRO electric appliances equipped with Z-Wave module e.g. Electro Z-Wave window or roller shutter ARZ Z-Wave with the use of other control system. The module has four double (open - stop - close) digital inputs to which can be connected potential-free signals from various devices e.g external thermostat, time switch, the KNX/EIB system, etc. The module enable control of up to 231 devices simultaneously or in four groups maximum.</p> <p class="hd1" style="text-align: justify;">Technical parameters</p> <table border="1" cellpadding="2" cellspacing="2" style="width: 325px; height: 116px; text-align: left;"> <tbody> <tr> <td align="undefined" colspan="2" nowrap="nowrap" rowspan="1" style="width: 211px;" valign="undefined">Technical parameters:</td> </tr> <tr> <td align="undefined" nowrap="nowrap" style="width: 99px;" valign="undefined">power supply</td> <td align="undefined" nowrap="nowrap" style="width: 211px;" valign="undefined">230VAC</td> </tr> <tr> <td align="undefined" nowrap="nowrap" style="width: 99px;" valign="undefined">working temperature</td> <td align="undefined" nowrap="nowrap" style="width: 211px;" valign="undefined">(+5° C) to (40° C)</td> </tr> <tr> <td align="undefined" nowrap="nowrap" style="width: 99px;" valign="undefined">working range</td> <td align="undefined" nowrap="nowrap" style="width: 211px;" valign="undefined">to 40m</td> </tr> <tr> <td align="undefined" nowrap="nowrap" style="width: 99px;" valign="undefined">working frequency</td> <td align="undefined" nowrap="nowrap" style="width: 211px;" valign="undefined">868,42 MHz</td> </tr> <tr> <td align="undefined" nowrap="nowrap" style="width: 99px;" valign="undefined">Maximum cable length</td> <td align="undefined" nowrap="nowrap" style="width: 211px;" valign="undefined">5 m</td> </tr> <tr> <td align="undefined" nowrap="nowrap" valign="undefined">dimensions</td> <td align="undefined" nowrap="nowrap" style="width: 211px;" valign="undefined">120 x 80 x 45 mm</td> </tr> </tbody> </table> <p><iframe allowfullscreen="" frameborder="0" height="480" scrolling="no" src="https://www.youtube.com/embed/nVdVp-oHlRY" width="854"></iframe></p> N N