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 (162, 159, 158) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.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	range	PRIMARY,product_id,company_id	PRIMARY	13		3	Using index condition

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
158		<table><tbody><tr><td>AIKO safes are designed to provide maximum protection against fire and foil any tampering and break-ins. The anti-burglary Construction: Body & Door: Tough steel plates precisely engineered using industry leading manufacturing techniques. Inserted with Premium formulated Ultra Fine Bubble Concrete provides the most effective insulation against intense heat to ensure valuables are protected from burglary & fire.Automatic Stopper: The automatic stopper feature allows users to close the door with slightest of push.Locking System: Fitted with Solid Steel bolt locking system to lock horizontally. Fitted with Single Key lock system, with ultra secure cylinder Key.Test & Approvals: Achieved the following international test certificates. 1. JIS - Japan Standard 2. KS - Korea Standard 3. SINTEF - Norway Standard 4. CNAL - China Standard Built in Alarm: (Optional) To set off anti burglary alarm Terms and Conditions 1. Only loca</td></tr></tbody></table><table width="100%" style="margin-top: 20px;"><tbody><tr><td colspan="8"><h4>SIZE (APPROX.) & BRIEF SPECIFICATION</h4></td></tr><tr><td colspan="8"><table width="100%"><tbody><tr bgcolor="#660000"><td class="arial_11pt_white" style="font-family: Arial, Helvetica, sans-serif; font-size: 11px; color: #ffffff; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 6px; text-decoration: none;" width="45%" height="35"><strong>Model</strong></td><td class="arial_11pt_white" style="font-family: Arial, Helvetica, sans-serif; font-size: 11px; color: #ffffff; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 6px; text-decoration: none;" width="55%"><strong>AS 30 - Single Key</strong></td></tr><tr><td width="45%">Outside</td><td width="55%">320 H x 400 W x 330 D MM</td></tr><tr><td>Inside</td><td>220 H x 320 W x 210 D MM</td></tr><tr><td>Weight</td><td>30 KGS</td></tr><tr><td>Accessory</td><td>NIL</td></tr><tr><td>Capacity</td><td>14 LTR</td></tr></tbody></table></td></tr></tbody></table>				<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>
159		<p>All AIKO safes are designed to provide maximum protection against fire and foil any tampering and break-ins. The anti-burglary</p><p>Construction: Body & Door: Tough steel plates precisely engineered using industry leading manufacturing techniques. Inserted with Premium formulated Ultra Fine Bubble Concrete provides the most effective insulation against intense heat to ensure valuables are protected from burglary & fire.</p><p>Automatic Stopper: The automatic stopper feature allows users to close the door with slightest of push.</p><p>Locking System: Fitted with 4 directional Solid Steel bolt locking system to lock horizontally & Vertically. Fitted with Dual Key lock system, with ultra secure cylinder Keys, Key & Dial or Key & Digital lock system.</p><p>Automatic Re-locking: Fitted with Automatic Re-locking device.</p><p>Test & Approvals: Achieved the following international test certificates. 1. JIS - Japan Standard 2. KS - Korea Standard 3. SINTEF - Norway Standard</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>