SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    72204, 70361, 73117, 73112, 71487, 72922, 
    72854, 72853, 72851, 71741, 71202, 
    71175, 71174, 71432, 71152, 71742, 
    71123, 71178, 42032, 71586, 71585, 
    71318, 71549, 71433, 70126, 71459, 
    71014, 70360, 71345, 71344, 71285, 
    71177, 71319, 71290, 71107, 71022, 
    71284, 71277, 71228, 71227
  )

Query time 0.00067

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 40 Using where

Result

product_id product_code product_type status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp usergroup_ids is_edp edp_shipping unlimited_download tracking free_shipping zero_price_action is_pbp is_op is_oper is_returnable return_period avail_since exclusive_end_date out_of_stock_actions localization min_qty max_qty qty_step list_qty_count tax_ids age_verification age_limit options_type exceptions_type details_layout shipping_params final_category aggregator aggregator_id ean isrc tbid is_album from_album publisher writers updated_timestamp available_worldwide stream_release_date download_release_date added_timestamp parent_product_id
42032 twisttrax048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1542326400 0 Y N N B N R Y N N Y 10 1542326400 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N TWISTEDTRAXX grady g 1541973329 Y 2021-12-17 17:37:27 0
70126 FBR302 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541721600 0 Y N N B N R Y N N Y 10 1541721600 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Copyright Control Michael Hagan 1535474973 Y 2021-12-17 17:37:27 0
70360 TBR188 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541376000 0 Y N N B N R Y N N Y 10 1541376000 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Copyright Control Dan Diamond 1536178723 Y 2021-12-17 17:37:27 0
70361 TBR189 P A 1 1.69 1 0.000 0 0 0 0.00 0 1543795200 0 Y N N B N R Y N N Y 10 1543795200 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Copyright Control LeeRoy 1543866057 Y 2021-12-17 17:37:27 0
71014 FILTH004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541376000 0 Y N N B N R Y N N Y 10 1541376000 1542585600 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 labelworx 5054283919837 GBKQU1896283 N The Filth Foundry D-Fi 1539147601 Y 2021-12-17 17:37:27 0
71022 FE160 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540857600 0 Y N N B N R Y N N Y 10 1540857600 1542067200 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 3 labelworx 5054283917673 GBKQU1895888 N Fatal Energy Records David Swan, Jason Osborne 1539147604 Y 2021-12-17 17:37:27 0
71107 DT087 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540944000 0 Y N N B N R Y N N Y 10 1540944000 1543363200 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 labelworx 5054283932133 GBKQU1898441 N Devious Trax David Jackson & Dina Watson 1539752406 Y 2021-12-17 17:37:27 0
71123 DB030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1542412800 0 Y N N B N R Y N N Y 10 1542412800 1543622400 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 labelworx 5054283928129 GBKQU1897781 N Drop Bear Digital Leigh Jones, Mish Bennetts 1540011602 Y 2021-12-17 17:37:27 0
71152 UTHHT017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1542672000 0 Y N N B N R Y N N Y 10 1542672000 1543881600 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 3 labelworx 5054283898569 GBKQU1892371 N Ultratech Jay Middleton 1540184402 Y 2021-12-17 17:37:27 0
71174 FLA032 P A 1 1.69 1 0.000 0 0 0 0.00 0 1542758400 0 Y N N B N R Y N N Y 10 1542758400 1543968000 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 labelworx 5054283927511 GBKQU1897652 N FLAUNT Shaun Williams 1540270815 Y 2021-12-17 17:37:27 0
71175 FLA032 P A 1 1.69 1 0.000 0 0 0 0.00 0 1542758400 0 Y N N B N R Y N N Y 10 1542758400 1543968000 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 labelworx 5054283927511 GBKQU1897653 N FLAUNT Shaun Williams 1540270815 Y 2021-12-17 17:37:27 0
71177 DER010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541116800 0 Y N N B N R Y N N Y 10 1541116800 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Copyright Control Matt Wade 1540296722 Y 2021-12-17 17:37:27 0
71178 DER011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1542326400 0 Y N N B N R Y N N Y 10 1542326400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Copyright Control Matt Wade, Joe Swales 1540296851 Y 2021-12-17 17:37:27 0
71202 TT019b P A 1 1.69 1 0.000 0 0 0 0.00 0 1542931200 0 Y N N B N R Y N N Y 10 1542931200 1544140800 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 labelworx 5054283941999 GBLV61800515 N Tuff Trax Mark Hard 1540443602 Y 2021-12-17 17:37:27 0
71227 SSD036 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540508400 0 Y N N B N R Y N N Y 10 1540508400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Copyright Control Alf Graham 1540494335 Y 2021-12-17 17:37:27 0
71228 FR064 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540508400 0 Y N N B N R Y N N Y 10 1540508400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Toolbox Publishing, Copyright Control Tim Sloan, Ross Farley, Rob Yellowley 1641475048 Y 26/10/2018 25/11/2018 2021-12-17 17:37:27 0
71277 SS080 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540771200 0 Y N N B N R Y N N Y 10 1540771200 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Slingshot Recordings Neil Bee/Paul Norris 1540681058 Y 2021-12-17 17:37:27 0
71284 TMP114 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540824263 0 Y N N B N R Y N N Y 10 1540771200 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Tempo Trax Ben Stevens/Lee Mills 1540824321 Y 2021-12-17 17:37:27 0
71285 TMP115 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541116800 0 Y N N B N R Y N N Y 10 1541116800 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Tempo Trax Simon Grant 1540824334 Y 2021-12-17 17:37:27 0
71290 ON054 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540944000 0 Y N N B N R Y N N Y 10 1540944000 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Orrible Noize Recordings Leigh Jones & Mish CheekyB 1540935920 Y 2021-12-17 17:37:27 0
71318 HOT019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541980800 0 Y N N B N R Y N N Y 10 1541980800 1543190400 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 labelworx 5054283949889 GBLV61801946 N Hot Box Digital Leeroy & Dan Dyson 1540962009 Y 2021-12-17 17:37:27 0
71319 DD141 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541012920 0 Y N N B N R Y N N Y 10 1540944000 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 GBLV61803810 N Copyright Control Ant Preece 1541088929 Y 2021-12-17 17:37:27 0
71344 UBT016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541116800 0 Y N N B N R Y N N Y 10 1541116800 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Unbounded Traxx One Foot In The Rave 1541097591 Y 2021-12-17 17:37:27 0
71345 FR065 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541116800 0 Y N N B N R Y N N Y 10 1541116800 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Toolbox Publishing Rob Yellowley 1641475120 Y 02/11/2018 02/12/2018 2021-12-17 17:37:27 0
71432 KD005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1542672000 0 Y N N B N R Y N N Y 10 1542672000 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Damaged gudz & Mark Heyes Dave Pearson & Mark Heyes 1541333966 Y 2021-12-17 17:37:27 0
71433 PDHH108 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541721600 0 Y N N B N R Y N N Y 10 1541721600 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Premonition Digital Liegh Jones/Mish B 1541431080 Y 2021-12-17 17:37:27 0
71459 420014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541580524 0 Y N N B N R Y N N Y 10 1541548800 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 Copyright Co N Kid Sample Kid Sample 1541581222 Y 2021-12-17 17:37:27 0
71487 UTHHD026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1543449600 0 Y N N B N R Y N N Y 10 1543449600 1544659200 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 labelworx 5054283960211 GBLV61804040 N Ultratech Jay Middleton 1541653211 Y 2021-12-17 17:37:27 0
71549 HELL009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541765995 0 Y N N B N R Y N N Y 10 1541721600 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Toolbox Publishing James Jackson 1642352433 Y 09/11/2018 09/12/2018 2021-12-17 17:37:27 0
71585 D23 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541980800 0 Y N N B N R Y N N Y 10 1541980800 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N delusion phatt beats 1541959922 Y 2021-12-17 17:37:27 0
71586 D24 P A 1 1.69 1 0.000 0 0 0 0.00 0 1541980800 0 Y N N B N R Y N N Y 10 1541980800 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N delusion phatt beats 1541961766 Y 2021-12-17 17:37:27 0
71741 PDHH109 P A 1 1.69 1 0.000 0 0 0 0.00 0 1542931200 0 Y N N B N R Y N N Y 10 1542931200 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Premonition Digital Rob Yellowley 1542621635 Y 2021-12-17 17:37:27 0
71742 DD142 P A 1 1.69 1 0.000 0 0 0 0.00 0 1542622534 0 Y N N B N R Y N N Y 10 1542585600 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 digital_dama N Copyright Control Goldie 1542623424 Y 2021-12-17 17:37:27 0
72204 HOT020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1543795200 0 Y N N B N R Y N N Y 10 1543795200 1545004800 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 labelworx 5054283987621 GBLV61808859 N Hot Box Digital Kirk P 1542777091 Y 2021-12-17 17:37:27 0
72851 FBR303 P A 1 1.69 1 0.000 0 0 0 0.00 0 1542931200 0 Y N N B N R Y N N Y 10 1542931200 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Copyright Control Patrick Kelly 1542905181 Y 2021-12-17 17:37:27 0
72853 VCR271 P A 1 1.69 1 0.000 0 0 0 0.00 0 1542931200 0 Y N N B N R Y N N Y 10 1542931200 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Copyright Control Danny Clark / Matt Clarkson 1542919125 Y 2021-12-17 17:37:27 0
72854 JAM029 P A 1 1.69 1 0.000 0 0 0 0.00 0 1542931200 0 Y N N B N R Y N N Y 10 1542931200 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 UKG3L1800009 N Copyright Control Dave Neale 1542919785 Y 2021-12-17 17:37:27 0
72922 TMP116 P A 1 1.69 1 0.000 0 0 0 0.00 0 1543005944 0 Y N N B N R Y N N Y 10 1542931200 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Tempo Trax Danny Haynes 1543006822 Y 2021-12-17 17:37:27 0
73112 SSD037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1543536000 0 Y N N B N R Y N N Y 10 1543536000 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Copyright Control Will Shepherd/Lee Mills 1543515727 Y 2021-12-17 17:37:27 0
73117 DER012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1543584836 0 Y N N B N R Y N N Y 10 1543536000 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 4 N Copyright Control One Foot In The Rave 1543585523 Y 2021-12-17 17:37:27 0