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 (
    38980, 38979, 38978, 38977, 38950, 38949, 
    39126, 38968, 38962, 38961, 38960, 
    38959, 38958, 38957, 38956, 38955, 
    38954, 38953, 38952, 38951, 38930, 
    39545, 39544, 39543, 39542, 39541, 
    39540, 39539, 39538, 39537, 39536, 
    39535, 39534, 39533, 39532, 39531, 
    39530, 39529, 39528, 39527, 39526, 
    39525, 39524, 39523, 39522, 39521, 
    39492, 39491, 39490, 39489, 39488, 
    39487, 39486, 39485, 39484, 39483, 
    39482, 39481, 39480, 39479, 39478, 
    39477, 39476, 39475, 39474, 39473, 
    39357, 39356, 39355, 39354, 39353, 
    39352, 39351, 39350, 39349, 39348, 
    39347, 39346, 39345, 39344
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00097

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

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
38930 Darren G, Cocaine, White Noize Hardcore, Original Mix, Hardcore, Toolbox Digital Download Cocaine (Original Mix) by White Noize Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. WNH098,White Noize Hardcore,Darren G
38949 Kishuni, Michael V, Recover, Venom Drive, Original Mix, Hardcore, Toolbox Digital Download Recover (Original Mix) by Venom Drive from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. VD005,Venom Drive,Kishuni,Michael V
38950 VD005,Venom Drive,Kishuni,Michael V
38951 STMLP004,Stamina Records,Rhythmics,Mi'A
38952 STMLP004,Stamina Records,A.B,K-Wire
38953 STMLP004,Stamina Records,Rhythmics
38954 STMLP004,Stamina Records,Douglas
38955 STMLP004,Stamina Records,Audio Warfare,Dante,Douglas
38956 STMLP004,Stamina Records,A.B,Ectomorph
38957 STMLP004,Stamina Records,Technikore,Cyrax,DJ Ned (CLSM)
38958 STMLP004,Stamina Records,A.B,Nick 235,Rhona,Substanced
38959 STMLP004,Stamina Records,A.B
38960 STMLP004,Stamina Records,Cyrax,A.B
38961 STMLP004,Stamina Records,A.B,Vinyljustice
38962 STMLP004,Stamina Records,A.B
38968 STI023,Stomp-Inc UK,Area 51
38977 GH2014,G Hard Recordings (Club G Music),The Coredinator
38978 GH2014,G Hard Recordings (Club G Music),The Syndicatorz,Final Judgement
38979 GH2014,G Hard Recordings (Club G Music),Raveriderz
38980 GH2014,G Hard Recordings (Club G Music),Raveriderz,T-Noize
39126 D-Lyte, Eufeion, Bomb Diggy, Hardcore Rapture Digital, Original Mix, Hardcore, Toolbox Digital Download Bomb Diggy (Original Mix) by Hardcore Rapture Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HRD0018,Hardcore Rapture Digital,Eufeion,D-Lyte
39344 Evmix001,Evolution Records,Scott Brown
39345 Evmix001,Evolution Records,Scott Brown
39346 Evmix001,Evolution Records,Scott Brown,Plus System
39347 Evmix001,Evolution Records,Scott Brown,Plus System
39348 Scott Brown, Gang Bang Society, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Gang Bang Society (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Evmix001,Evolution Records,Scott Brown
39349 Evmix001,Evolution Records,Scott Brown,Plus System
39350 Evmix001,Evolution Records,Scott Brown,Plus System
39351 Evmix001,Evolution Records,Scott Brown,Plus System
39352 Evmix001,Evolution Records,Scott Brown,Plus System
39353 Evmix001,Evolution Records,Scott Brown,Plus System
39354 Evmix001,Evolution Records,Scott Brown,Plus System,Sy & Unknown
39355 Evmix001,Evolution Records,Scott Brown,Plus System
39356 Scott Brown, Elysium Plus, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Elysium Plus (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Evmix001,Evolution Records,Scott Brown
39357 Evmix001,Evolution Records,Scott Brown
39473 KUC06,Klubbed Up Collections,Joey Riot,Klubfiller
39474 KUC06,Klubbed Up Collections,Chris Unknown
39475 KUC06,Klubbed Up Collections,Re-Con
39476 KUC06,Klubbed Up Collections,J-Mac,Tom Hayward
39477 KUC06,Klubbed Up Collections,Gammer,Klubfiller
39478 KUC06,Klubbed Up Collections,Nuton
39479 KUC06,Klubbed Up Collections,Clear Vu,Gammer
39480 KUC06,Klubbed Up Collections,Chris Unknown
39481 KUC06,Klubbed Up Collections,Hixxy,Klubfiller,MC Storm
39482 KUC06,Klubbed Up Collections,J-Mac,Tom Hayward
39483 KUC06,Klubbed Up Collections,Chris Unknown,Ganar
39484 KUC06,Klubbed Up Collections,Re-Con,Klubfiller
39485 KUC06,Klubbed Up Collections,Squad-E,Klubfiller
39486 KUC06,Klubbed Up Collections,J-Mac,Tom Hayward
39487 KUC06,Klubbed Up Collections,Re-Force
39488 KUC06,Klubbed Up Collections,Ganar
39489 KUC06,Klubbed Up Collections,Re-Force
39490 KUC06,Klubbed Up Collections,Octane
39491 KUC06,Klubbed Up Collections,Nuton
39492 KUC06,Klubbed Up Collections,J.K
39521 KUC07,Klubbed Up Collections,Joey Riot,Klubfiller
39522 KUC07,Klubbed Up Collections,Klubfiller
39523 KUC07,Klubbed Up Collections,Klubfiller,TDX
39524 KUC07,Klubbed Up Collections,Chris Unknown,Ganar
39525 KUC07,Klubbed Up Collections,Nuton,Re-Force,Zoe Van West
39526 KUC07,Klubbed Up Collections,Hixxy,Klubfiller,MC Storm
39527 KUC07,Klubbed Up Collections,Re-Con,Klubfiller
39528 KUC07,Klubbed Up Collections,Re-Force
39529 KUC07,Klubbed Up Collections,Re-Force
39530 KUC07,Klubbed Up Collections,J-Mac,Tom Hayward,Devan
39531 KUC07,Klubbed Up Collections,J-Mac,Tom Hayward
39532 KUC07,Klubbed Up Collections,J-Mac,Tom Hayward
39533 KUC07,Klubbed Up Collections,Nuton
39534 KUC07,Klubbed Up Collections,Nuton
39535 KUC07,Klubbed Up Collections,Chris Unknown
39536 KUC07,Klubbed Up Collections,Chris Unknown
39537 KUC07,Klubbed Up Collections,DJC
39538 KUC07,Klubbed Up Collections,Klubfiller,MC Storm
39539 KUC07,Klubbed Up Collections,J-Mac
39540 KUC07,Klubbed Up Collections,Klubfiller,Nuton
39541 KUC07,Klubbed Up Collections,Klubfiller,Exergonic,Felixx
39542 KUC07,Klubbed Up Collections,Nuton
39543 KUC07,Klubbed Up Collections,Klubfiller,Chance,Hardcore
39544 KUC07,Klubbed Up Collections,Klubfiller,J-Mac
39545 KUC07,Klubbed Up Collections,Ganar