SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    73240, 73116, 72858, 72857, 73405, 73404, 
    73403, 73155, 73115, 73351, 73350, 
    73349, 73348, 72836, 73284, 73111, 
    71691, 68825, 49338, 44239, 44238, 
    42033, 73271, 73270, 73252, 73239, 
    73237, 73217, 73156, 73119, 72856, 
    72855, 72852, 72032, 71703, 71486, 
    71485, 71484, 71483, 73020
  )

Query time 0.00064

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
42033 twisttrax049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544745600 0 Y N N B N R Y N N Y 10 1544745600 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 TWISTEDTRAXX scott sentinelz&rikrom 1544294933 Y 2021-12-17 17:37:27 0
44238 twistedtrax050 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544745600 0 Y N N B N R Y N N Y 10 1544745600 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 TWISTEDTRAXX scott sentinelz&rikrom 1544294948 Y 2021-12-17 17:37:27 0
44239 twistedtrax051 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544745600 0 Y N N B N R Y N N Y 10 1544745600 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 TWISTEDTRAXX scott sentinelz&rikrom 1544294964 Y 2021-12-17 17:37:27 0
49338 twistedtraxx52 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544745600 0 Y N N B N R Y N N Y 10 1544745600 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 twistedtraxx scott sentinelz 1544294994 Y 2021-12-17 17:37:27 0
68825 twistedtraxx54 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544745600 0 Y N N B N R Y N N Y 10 1544745600 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 twistedtraxx scottskinner/richardaskham 1544295020 Y 2021-12-17 17:37:27 0
71483 Cheek400B P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 1545350400 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 5054283914443 GBKQU1892776 N Copyright Control Graham Cox, Matt Brown 1541653211 Y 2021-12-17 17:37:27 0
71484 Cheek400B P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 1545350400 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 5054283914443 GBKQU1868424 N Copyright Control Graham Cox, Matt Brown 1541653211 Y 2021-12-17 17:37:27 0
71485 Cheek400B P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 1545350400 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 5054283914443 GBKQU1881837 N Copyright Control Graham Cox, Matt Brown 1541653211 Y 2021-12-17 17:37:27 0
71486 Cheek400B P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 1545350400 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 5054283914443 GBKQU1895279 N Copyright Control Graham Cox, Matt Brown 1541653211 Y 2021-12-17 17:37:27 0
71691 AAA173 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544745600 0 Y N N B N R Y N N Y 10 1544745600 1545955200 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 5054283983111 GBLV61807991 N Ahura Mazda Recordings NITRO Burak Harsitlioglu 1542344404 Y 2021-12-17 17:37:27 0
71703 UTHHD025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 1545350400 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 5054283980301 GBLV61807532 N Ultratech Drake Liddell 1542344408 Y 2021-12-17 17:37:27 0
72032 FILTH005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 1545350400 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 5054283988840 GBLV61809033 N The Filth Foundry Insidious & Boris The Noss 1542776806 Y 2021-12-17 17:37:27 0
72836 HOT021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545004800 0 Y N N B N R Y N N Y 10 1545004800 1546214400 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 5054283987652 GBLV61808860 N Hot Box Digital Miric 1542862801 Y 2021-12-17 17:37:27 0
72852 FBR304 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 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 Defensive Music Ben Stevens / Danny Clark 1542905232 Y 2021-12-17 17:37:27 0
72855 VCR272 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 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 Jason Burgess 1542919828 Y 2021-12-17 17:37:27 0
72856 VCR272 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 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 Jason Burgess 1542919873 Y 2021-12-17 17:37:27 0
72857 VCR273 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545350400 0 Y N N B N R Y N N Y 10 1545350400 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 Jason Burgess 1542919934 Y 2021-12-17 17:37:27 0
72858 VCR273 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545350400 0 Y N N B N R Y N N Y 10 1545350400 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 Jason Burgess 1542919982 Y 2021-12-17 17:37:27 0
73020 RRR1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1543968000 0 Y N N B N R Y N N Y 10 1543968000 1546387200 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 5054283998917 GBLV61811018 N Matt Smith Matt Smith 1543294802 Y 2021-12-17 17:37:27 0
73111 RR7 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544745600 0 Y N N B N R Y N N Y 10 1544745600 1547164800 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 5054284104461 GBLV61811608 N Copyright Control Matt Smith 1543467609 Y 2021-12-17 17:37:27 0
73115 AAA176 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545264000 0 Y N N B N R Y N N Y 10 1545264000 1546473600 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 5054284109268 GBLV61812770 N Ahura Mazda Recordings NITRO Burak Harsitlioglu 1543554004 Y 2021-12-17 17:37:27 0
73116 HWR0013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545350400 0 Y N N B N R Y N N Y 10 1545350400 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 UKLD71800004 N Copyright Control Andy McCall 1543573559 Y 2021-12-17 17:37:27 0
73119 HLXR049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 0 N 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 GB9W51800005 N Copyright Control Kisrty Lee James 1620672605 Y 2021-12-17 17:37:27 0
73155 KD006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545264000 0 Y N N B N R Y N N Y 10 1545264000 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 Miss Detonate Maria Di-Tommaso/Ben Stevens 1543941717 Y 2021-12-17 17:37:27 0
73156 PDHH110 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 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/Povey Povey 1543947352 Y 2021-12-17 17:37:27 0
73217 UBT017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 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 Damien Blanes/Karl Davies 1544034352 Y 2021-12-17 17:37:27 0
73237 FR066 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544140800 0 Y N N B N R Y N N Y 10 1544140800 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 1641475194 Y 07/12/2018 06/01/2019 2021-12-17 17:37:27 0
73239 TMP117 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544176013 0 Y N N B N R Y N N Y 10 1544140800 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 Matt Clarkson 1544176822 Y 2021-12-17 17:37:27 0
73240 TMP118 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545350400 0 Y N N B N R Y N N Y 10 1545350400 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 Gareth Roberts 1544176091 Y 2021-12-17 17:37:27 0
73252 DD143 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544395020 0 Y N N B N R Y N N Y 10 1544313600 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 GBLV61816146 N Copyright Control Nikkdbubble 1544395517 Y 2021-12-17 17:37:27 0
73270 420015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544640271 0 Y N N B N R Y N N Y 10 1544572800 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 AL G AL G 1544640318 Y 2021-12-17 17:37:27 0
73271 TDOG123 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544671174 0 Y N N B N R Y N N Y 10 1544659200 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 Hatfish Dave Owens 1544798720 Y 2021-12-17 17:37:27 0
73284 DER013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1544745600 0 Y N N B N R Y N N Y 10 1544745600 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 Kirk Povey 1544708000 Y 2021-12-17 17:37:27 0
73348 MHR066 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545153863 0 Y N N B N R Y N N Y 10 1545091200 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 Infinite Loops/MCPS Michael Franklin/Craig Jones 1545154224 Y 2021-12-17 17:37:27 0
73349 420018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545190951 0 Y N N B N R Y N N Y 10 1545177600 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 420 Rejords Chris Sharkey, Steve Riggs 1545191555 Y 2021-12-17 17:37:27 0
73350 420016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545191045 0 Y N N B N R Y N N Y 10 1545177600 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 miss Adrenaline Leean Parkinson 1545191139 Y 2021-12-17 17:37:27 0
73351 420017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545191357 0 Y N N B N R Y N N Y 10 1545177600 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 Damaged Gudz Scott Chaney 1546468750 Y 2021-12-17 17:37:27 0
73403 ESP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545321563 0 Y N N B N R Y N N Y 10 1545264000 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 Energy Source Productions DJ Serenity 1545321622 Y 2021-12-17 17:37:27 0
73404 ESP022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545321685 0 Y N N B N R Y N N Y 10 1545264000 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 Energy Source Productions DJ Serenity 1545322517 Y 2021-12-17 17:37:27 0
73405 ESP020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1545321874 0 Y N N B N R Y N N Y 10 1545264000 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 Energy Source Productions DJ Serenity 1545322533 Y 2021-12-17 17:37:27 0