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 (
    50522, 50521, 50520, 50519, 50518, 50517, 
    50516, 50515, 51281, 50485, 50484, 
    50462, 50461, 50103, 50447, 50408, 
    50465, 50464, 50463, 50393, 50389, 
    50388, 50387, 50072, 50267, 50234, 
    50233, 50232, 50231, 50230, 50229, 
    50228, 50227, 50226, 50225, 50224, 
    50223, 50067, 50066, 50065, 50064, 
    50275, 50274, 50269, 50265, 50039, 
    50001, 88490, 88489, 50040, 50034, 
    50033, 50025, 50152, 50151, 50124, 
    50123, 50122, 49944, 50110, 50107, 
    49954, 49953, 49952, 49951, 49950, 
    50219, 50218, 50217, 50216, 50215, 
    50214, 50213, 50212, 50211, 50210, 
    50209, 50208, 50207, 50206
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00074

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
49944 Ganar, Sahara Bounce, Futureworld Records, Original Mix, Hardcore, Featured Hardcore New, Toolbox Digital Download Sahara Bounce (Original Mix) by Futureworld Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NFWORLD060,Futureworld Records,Ganar
49950 MRV211,Megarave Records,Drokz,The Unfamous
49951 MRV211,Megarave Records,The Unfamous,Drokz
49952 PCR033,Peacock Records,Chrono,Lano,Geoff Da Chef
49953 PCR033,Peacock Records,Chrono,De Man Int Zwart
49954 PCR033,Peacock Records,Chrono,De Man Int Zwart
50001 Jason Bouse, Subliminal, I Only Need You, Ballistik Hardcore, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download I Only Need You (Original Mix) by Ballistik Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BH038,Ballistik Hardcore,Jason Bouse,Subliminal
50025 Obie, Scott Brown, Ultimate Form, Evolution Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Ultimate Form (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev140,Evolution Records,Scott Brown,Obie
50033 NOTV027,Notorious Vinyl,Little Fella
50034 NOTV027,Notorious Vinyl,Little Fella
50039 Dougal, Gammer, Shoulder Lock, Together We Rise, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Shoulder Lock (Original Mix) by Together We Rise from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TWR28,Together We Rise,Dougal,Gammer
50040 Dionne, Miss Special K, Skindogg, Everytime, Totally Ardcore Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Everytime (Original Mix) by Totally Ardcore Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TA022,Totally Ardcore Records,Miss Special K,Skindogg,Dionne
50064 MRV212,Megarave Records,Madnezz,Drs
50065 MRV212,Megarave Records,Madnezz,Mouth of Madness
50066 MRV212,Megarave Records,Madnezz,Aggressive
50067 MRV212,Megarave Records,Madnezz
50072 Scott Brown, This Is Forever, Evolution Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download This Is Forever (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev141,Evolution Records,Scott Brown
50103 Krystal, M-Project, Time Machine, Futureworld Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Time Machine (Original Mix) by Futureworld Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NFWORLD061,Futureworld Records,M-Project,Krystal
50107 CBD2,Core Blimey Digital,Paul Manx,Karly Ratcliffe,Hyperforce
50110 CBD1,Core Blimey Digital,Hyperforce,Paul Manx
50122 UHD098,Universal Hardcore Digital,Jaw D
50123 Nuton, Care For Me, Klubbed Up, Radio Edit, Hardcore, Featured Hardcore New, Hard Dance, Toolbox Digital Download Care For Me (Radio Edit) by Klubbed Up from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KU042,Klubbed Up,Nuton
50124 Nuton, Care For Me, Klubbed Up, DJ Edit, Featured Hardcore New, Hardcore, Toolbox Digital Download Care For Me (DJ Edit) by Klubbed Up from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KU042,Klubbed Up,Nuton
50151 DR066,Desk Records,DJ Aier
50152 Eufeion, Unshakeable, Ninja Hardcore, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Unshakeable (Original Mix) by Ninja Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NINJAHC001,Ninja Hardcore,Eufeion
50206 LWWHAHC13,LW Recordings,Tha Bomber
50207 LWWHAHC13,LW Recordings,Haze,Allison Mclauchlan,Denile,Eufeion
50208 LWWHAHC13,LW Recordings,Conquistador
50209 LWWHAHC13,LW Recordings,Gregor Le Dahl,Allison Gray
50210 LWWHAHC13,LW Recordings,Danox,Tolo
50211 LWWHAHC13,LW Recordings,Mr. Tommy
50212 LWWHAHC13,LW Recordings,Anima
50213 LWWHAHC13,LW Recordings,Lyon Kise
50214 LWWHAHC13,LW Recordings,Deivid Sound
50215 LWWHAHC13,LW Recordings,S3RL,Emi,Razor Sharp
50216 LWWHAHC13,LW Recordings,V-Nax
50217 LWWHAHC13,LW Recordings,Nu-Vizion
50218 LWWHAHC13,LW Recordings,Riko,Skoobi
50219 LWWHAHC13,LW Recordings,Skull Demon
50223 TFDA002,TERRAFORM MUSIC,M-Project
50224 TFDA002,TERRAFORM MUSIC,M-Project
50225 TFDA002,TERRAFORM MUSIC,M-Project,JORDI K-STANYA
50226 TFDA002,TERRAFORM MUSIC,M-Project,JAKAZiD
50227 TFDA002,TERRAFORM MUSIC,DJ Depath,M-Project
50228 TFDA002,TERRAFORM MUSIC,M-Project
50229 TFDA002,TERRAFORM MUSIC,DJ Depath,M-Project,Ruboy
50230 TFDA002,TERRAFORM MUSIC,M-Project,Darwin
50231 TFDA002,TERRAFORM MUSIC,M-Project
50232 TFDA002,TERRAFORM MUSIC,M-Project,TANUKI
50233 TFDA002,TERRAFORM MUSIC,M-Project,DJ-X LAB4
50234 TFDA002,TERRAFORM MUSIC,M-Project,Hell System
50265 Emi, JTS, Technikore, Siren, LW Recordings, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Siren (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHH04,LW Recordings,Technikore,JTS,Emi
50267 Cat Knight, Sc@r, Let It Take Control, Scarred Digital, Haze Remix, Featured Hardcore New, Hardcore, Toolbox Digital Download Let It Take Control (Haze Remix) by Scarred Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SD092,Scarred Digital,Sc@r,Cat Knight
50269 Clsm, DJ Dreem, Open Your Eyes, Out Of This World Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Open Your Eyes (Original Mix) by Out Of This World Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. OOTW005,Out Of This World Records,DJ Dreem,CLSM
50274 Demand, Gammer, Klubfiller Remix (Radio Edit), Mandy Edge, Re-Con, I'm Sorry, Klubbed Up, Gammer & Klubfiller Remix (Radio Edit), Hard Dance, Toolbox Digital Download I'm Sorry (Gammer & Klubfiller Remix (Radio Edit)) by Klubbed Up from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KU044,Klubbed Up,Re-Con,Demand,Mandy Edge,Gammer,Klubfiller Remix (Radio Edit)
50275 Demand, Gammer, Klubfiller, Mandy Edge, Re-Con, I'm Sorry, Klubbed Up, Gammer & Klubfiller Remix, Featured Hardcore New, Hardcore, Toolbox Digital Download I'm Sorry (Gammer & Klubfiller Remix) by Klubbed Up from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KU044,Klubbed Up,Re-Con,Demand,Mandy Edge,Gammer,Klubfiller
50387 MOK170,Mokum Records,Formek
50388 MOK170,Mokum Records,Formek
50389 MOK170,Mokum Records,Formek
50393 Gav G-Style, RockDaParty, GSP, UK Hardcore Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download RockDaParty (UK Hardcore Mix) by GSP from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. GSP068,GSP,Gav G-Style
50408 Ravenew1,Rave Essentials,Tjay,Aaron Mclaren
50447 UHD099,Universal Hardcore Digital,Jaw D
50461 SPECIAL007,Rebirth Society,Mental Crush,Reaper
50462 SPECIAL007,Rebirth Society,Mental Crush,Reaper
50463 JEDI8,Jedi Recordings,DJ Jedi,Luna-C
50464 JEDI8,Jedi Recordings,DJ Jedi
50465 JEDI8,Jedi Recordings,DJ Jedi
50484 Chris Unknown, Klubfiller, Falling, Klubbed Up, Radio Edit, Hard Dance, Toolbox Digital Download Falling (Radio Edit) by Klubbed Up from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KU045,Klubbed Up,Klubfiller,Chris Unknown
50485 Chris Unknown, Klubfiller, Falling, Klubbed Up, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Falling (Original Mix) by Klubbed Up from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KU045,Klubbed Up,Klubfiller,Chris Unknown
50515 TFOH101,The Future Of Hardcore,Clowny,Restless
50516 TFOH101,The Future Of Hardcore,Clowny,Genic,Delgado
50517 TFOH101,The Future Of Hardcore,Doug Horizon
50518 TFOH101,The Future Of Hardcore,Doug Horizon,Darwin
50519 TFOH101,The Future Of Hardcore,Eufeion,Konekshon
50520 TFOH101,The Future Of Hardcore,Gisbo,Lee Johnstone
50521 TFOH101,The Future Of Hardcore,Impact,Resist,Fallon
50522 TFOH101,The Future Of Hardcore,J-Skitz,Zoe Van West
51281 JH168,Justice Hardcore,Future Shock,Naomi Gibson,M-Project
88489 EX014,Exode Records,Skullbomb
88490 EX014,Exode Records,Skullbomb