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 (
    107397, 107396, 107395, 107394, 107393, 
    107392, 107391, 107381, 107675, 107493, 
    107492, 107491, 107729, 107728, 107555, 
    107390, 107389, 107388, 107387, 107280
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
107280 Joe Longbottom, Philthy Efferz, Squid Itch, Pumped, Original Mix, Bounce, Exclusive, Toolbox Digital Download Squid Itch (Original Mix) by Pumped from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. PMD055,Pumped,Philthy Efferz,Joe Longbottom
107381 HNRS101,Hardnoise Records,Nando Cp
107387 Miami House Party, Monkey, Untidy, Extended Mix, Hard House, Toolbox Digital Download Monkey (Extended Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYT004,Untidy,Miami House Party
107388 Sonny Taylor, Bonjourno, Untidy, Extended Mix, Hard House, Toolbox Digital Download Bonjourno (Extended Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYT004,Untidy,Sonny Taylor
107389 Valpy, Love Hearts, Untidy, Extended Mix, Hard House, Toolbox Digital Download Love Hearts (Extended Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYT004,Untidy,Valpy
107390 Eoghan Thomas, A Lil' Untidy, Untidy, Extended Mix, Hard House, Toolbox Digital Download A Lil' Untidy (Extended Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYT004,Untidy,Eoghan Thomas
107391 Cheek584,Cheeky Tracks,Ben Warren
107392 Cheek584,Cheeky Tracks,Ben Warren,BAD
107393 Cheek584,Cheeky Tracks,Ben Warren,N!xy,DeV1Se
107394 Cheek584,Cheeky Tracks,Ben Warren,N!xy,DeV1Se
107395 Cheek584,Cheeky Tracks,Ben Warren,BAD
107396 Ben Warren, This Feeling, Cheeky Tracks, Original Mix, Hard House, Toolbox Digital Download This Feeling (Original Mix) by Cheeky Tracks from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Cheek584,Cheeky Tracks,Ben Warren
107397 Asha, Jack Butler, Jon BW, Head's Up, Cantina Records, Original Mix, Hard House, Toolbox Digital Download Head's Up (Original Mix) by Cantina Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR029,Cantina Records,Jack Butler,Asha,Jon BW
107491 MQDRFR013,+QDance Records,Oo Sweetman/DJ Alan
107492 MQDRFR013,+QDance Records,Oo Sweetman/DJ Alan
107493 MQDRFR013,+QDance Records,Oo Sweetman/DJ Alan,Jorge Medrano/DJ Lara/Chesnut
107555 Chip Shop Boys, If This Ain't Love, Flaunt, Original Mix, Hard House, Toolbox Digital Download If This Ain't Love (Original Mix) by Flaunt from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. FLA056,Flaunt,Chip Shop Boys
107675 Tom Basquil, Release The Pressure, Feersum, Exclusive, Toolbox Digital Download Release The Pressure by Feersum from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
107728 Alan James, Brad Riffresh, The World, Chubby Choons, Alan James Remix, Bounce, Hard House, Toolbox Digital Download The World (Alan James Remix) by Chubby Choons from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CcAJ1,Chubby Choons,Brad Riffresh,Alan James
107729 CcAJ1,Chubby Choons,Brad Riffresh,Alan James