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 (
    74072, 74071, 74056, 73996, 73977, 73815, 
    73673, 73599, 73598, 73821, 73994, 
    73976, 73740, 73734, 73880, 73819, 
    73484, 73483, 73820, 73874, 73626, 
    73873, 73872, 73871, 73870, 73869, 
    73868, 73867, 73866, 73865, 73864, 
    73863, 73862, 73861, 73860, 73859, 
    73858, 73857, 73856, 73855
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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
73483 Cheek404,Cheeky Tracks,One Foot In The Rave
73484 Cheek404,Cheeky Tracks,One Foot In The Rave
73598
73599
73626 Rat-E, Brain Ticket, Hot Box Digital, Original Mix, Exclusive, Toolbox Digital Download Brain Ticket (Original Mix) by Hot Box Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HOT023,Hot Box Digital,Rat-E
73673 DB032,Drop Bear Digital ,Mr. E,DJ Ben,Banga Matt,Asylum
73734 Ant Hornsby, Tuff Groove, Elevate Uplifting Hard House from Ant Hornsby making a welcome return to Tuff Groove for 2019 Ant Hornsby, Tuff Groove, Elevate
73740 FILTH006,The Filth Foundry,Fredrik Redegard
73815 Ben Stevens, Gary O'Connor, In My Mind, Digital Snail, Exclusive, Toolbox Digital Download In My Mind by Digital Snail from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Digital Snail, In My Mind, Ben Stevens, Gary O'Connor
73819
73820
73821
73855
73856
73857
73858
73859
73860
73861
73862
73863
73864
73865
73866
73867
73868
73869
73870
73871
73872
73873
73874
73880 One Foot In The Rave One Foot In The Rave
73976 Kumite, Cannonball Run, Nitrox, Exclusive, Toolbox Digital Download Cannonball Run by Nitrox from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
73977
73994 TMP119,Nico Ahlqvist,Matt Clarkson,Born Ready,Tempo Trax,Hard House Hard House TMP119,Nico Ahlqvist,Matt Clarkson,Born Ready,Tempo Trax,Hard House
73996 premonition digital,kirk p,Different Forever Whateve,music,hardhouse,hard house,filth,nrg,rave,hardhouse,trance,hard house,hard trance premonition digital,kirk p,Different Forever Whateve,music,hardhouse,hard house,filth,nrg,rave,hardhouse,trance,hard house,hard trance
74056
74071
74072