SELECT 
  * 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  product_id = 10460 
  AND company_id = 1 
  AND lang_code = 'de'

Query time 0.00026

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
10460 de 1 Ecke COUNTRY 680 : Karton = 24 Ecken a 6.2cm Höhe <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Karton</strong></td> <td style="text-align: center;" width="95">Stück</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Gewicht</td> </tr> <tr> <td><strong>Verblender</strong></td> <td>63</td> <td>1m<sup>2</sup></td> <td>17,9 kg</td> </tr> <tr> <td><strong>Ecke</strong></td> <td>24</td> <td>1,8 lfm</td> <td>10,4 kg</td> </tr> </tbody> </table> Ecke COUNTRY 680 ✔ für außen ✔ auf der Basis von gepresstem Beton ✔ der belgischen Architektur ähnlich ✔ Höhe – 6,2cm | Günstig ! ✉ info@baubay.de Ecke COUNTRY 680 : Karton = 24 Stück | baubaY.de ! N N