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 (
    74051, 74050, 74049, 74048, 74047, 74046, 
    74045, 74044, 74043, 73817, 73816, 
    74713, 74712, 74711, 74710, 74709, 
    74708, 74707, 74706, 74705, 74704, 
    74703, 74702, 74701, 74700, 74699, 
    74698, 74697, 74696, 74695, 74694, 
    74466, 74601, 74540, 74092, 73927, 
    73907, 73906, 73824, 73952
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00060

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 40 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
73816 Gary O'Connor, The Kraken, Digital Snail Gary O'Connor, The Kraken, Digital Snail
73817 Gary O'Connor, The Kraken, Digital Snail Gary O'Connor, The Kraken, Digital Snail
73824 Marc Lewis, Survival Instinct, Inside Out Digital, Exclusive, Toolbox Digital Download Survival Instinct by Inside Out Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
73906 Cheek408,Cheeky Tracks,Curve Pusher
73907 Cheek408,Cheeky Tracks,Curve Pusher
73927 UTHHD028,Ultratech,VaderMonkey,Helz Bellz
73952 korruption,hardhouse,harddance korruption,hardhouse,harddance
74043 ALBUTH004,Ultratech,VaderMonkey
74044 ALBUTH004,Ultratech,VaderMonkey
74045 ALBUTH004,Ultratech,VaderMonkey
74046 ALBUTH004,Ultratech,VaderMonkey
74047 ALBUTH004,Ultratech,VaderMonkey
74048 ALBUTH004,Ultratech,VaderMonkey
74049 ALBUTH004,Ultratech,VaderMonkey
74050 ALBUTH004,Ultratech,VaderMonkey
74051 ALBUTH004,Ultratech,VaderMonkey,Stompalott
74092 Kirk P Kirk P
74466 FILTH007,The Filth Foundry,Daisy,Miric
74540 Wayne,German,Spoon,Bender,Gouryella,Remix,Rework,Bootleg,Neverland,Recordings, The launch of the label's 2019 campaign sees chart topping producer Wayne G added to the list of guest artists to feature. Wayne has encapsulate everything this label stands for, a deep rolling baseline dub synths which encase that epic classic riff. Wayne,German,Spoon,Bender,Gouryella,Remix,Rework,Bootleg,Neverland,Recordings,
74601
74694
74695
74696
74697
74698
74699
74700
74701
74702
74703
74704
74705
74706
74707
74708
74709
74710
74711
74712
74713