Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    125591, 125019, 65927, 66093, 74538, 
    118791, 33524, 54128, 59547, 59837
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00046

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cscart_product_descriptions	range	PRIMARY,product_id	PRIMARY	9		10	Using where

Result

product_id	short_description	meta_keywords	meta_description	search_words
33524
54128	<table class="album-only-tracks"> <tr> <td class="track-name">Fruit Machine - 100% Juicy (Continuous DJ Mix)</td> <td class="track-actions"><span class="album-only-label">Album Only</span></td> </tr> </table>	Various Artists, 100% Juicy - Mixed by Fruit Machine, Toolbox Recordings, Featured Compilations, Hard House, Compilations, Toolbox Digital	Download 100% Juicy - Mixed by Fruit Machine by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59547		Various Artists, Fireball Recordings: 100% Hard House, Vol. 1, Fireball, Featured Compilations, Hard House, Compilations, Toolbox Digital	Download Fireball Recordings: 100% Hard House, Vol. 1 by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59837		Wizard, Wizard Producer Album, Effective Recordings, Featured Compilations, Hard House, Compilations, Toolbox Digital	Download Wizard Producer Album by Effective Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
65927	<table class="album-only-tracks"> <tr> <td class="track-name">Various Artists - Hard Vocal Anthems, Vol. 4 (Continuous DJ Mix 1)</td> <td class="track-actions"><span class="album-only-label">Album Only</span></td> </tr> <tr> <td class="track-name">Various Artists - Hard Vocal Anthems, Vol. 4 (Continuous DJ Mix 2)</td> <td class="track-actions"><span class="album-only-label">Album Only</span></td> </tr> </table>	Various Artists, Hard Vocal Anthems, Vol. 4, Hard Dance Coalition, Hard House, Featured Compilations, Compilations, Toolbox Digital	Download Hard Vocal Anthems, Vol. 4 by Hard Dance Coalition from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.	DCHVA004,Hard Dance Coalition
66093	<table class="album-only-tracks"> <tr> <td class="track-name">Various Artists - Hoover Anthems, Vol. 3 (Continuous DJ Mix 1)</td> <td class="track-actions"><span class="album-only-label">Album Only</span></td> </tr> <tr> <td class="track-name">Various Artists - Hoover Anthems, Vol. 3 (Continuous DJ Mix 2)</td> <td class="track-actions"><span class="album-only-label">Album Only</span></td> </tr> </table>	Various Artists, Hoover Anthems., Vol. 3, Hard Dance Coalition, Hard House, Featured Compilations, Compilations, Toolbox Digital	Download Hoover Anthems., Vol. 3 by Hard Dance Coalition from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.	HDCHA003,Hard Dance Coalition
74538		Various Artists, Best Of Twist Trax: Vol. 3, Twist Trax, Featured Compilations, Hard House, Compilations, Toolbox Digital	Download Best Of Twist Trax: Vol. 3 by Twist Trax from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
118791				TTLP006,Tuff Trax
125019		Various Artists, Full On Summer 2024, Cheeky Tracks, Hard House, Compilations, Toolbox Digital	Download Full On Summer 2024 by Cheeky Tracks from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.	CheekA97,Cheeky Tracks
125591		Various Artists, Harder Faster, Vol 1, Tidy, Hard House, Compilations, Toolbox Digital	Download Harder Faster, Vol 1 by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.	TIDYHF001D,Tidy