Sandbox

SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (
    561, 9810, 560, 559, 9890, 9811, 9889
  ) 
  AND cscart_ult_product_descriptions.company_id = 2 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00047

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cscart_ult_product_descriptions	range	PRIMARY,product_id,company_id	PRIMARY	13		7	Using index condition

Result

product_id	full_description	meta_keywords
559	<p>CC1000 – a basic system of overhead shutters. The access cover is installed on the front of the box. They can be installed to windows whose frame’s max. thickness does not exceed 95 mm. There is no version with a mosquito net. CC1000 shutters are an ideal solution for industrial facilities.</p> <p>The CC1000 shutter has a revision panel from the front, and therefore it can be built up only from the outside.</p> <p>The access to the centre of the shutter is possible from the inside of the apartment.</p>
560	<p>TL1000 is one of the better shutter systems that can be used in newly-built facilities and those being modernized. The access cover is installed on the bottom of the box - it also allows the possibility of building up the box of shutters from the inside of the apartment without concern about the service access to the shutters. They can be installed to windows whose frame’s max. thickness does not exceed 95 mm. TL1000 shutters have no version with a mosquito net.</p>	shutters, top mounted shutters
561	<p style="text-align: justify;">TP1000 is a system that can be installed on wide window frames, even up to 202 mm (with broadening to 264 mm). Using an expanding element we increase the depth of the box by 31 mm or 62 mm. This system has the capability of creating a revision cover from the bottom (with a build-up box from the inside), or the front (during the installation on a wide window frame). The possible service is both manual - with the use of a belt - and electric - with the use of a switch or a remote control. It has two-chamber load carrying walls that provide better thermal insulation and their high stiffness makes it impossible to bend the box during the installation.</p> <p style="text-align: justify;">The TP1000 shutter can be istalled from the internal and external side. Front profiles additionally rifled and additionally equipped with plaster slats facilitate the installation. The revision cover in such a build-up installation occurs from the bottom, and the operation of the shutter takes place from the inside of the room.</p> <p style="text-align: justify;"> </p>	shutters, top mounted shutters
9810
9811
9889
9890