SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    67841, 68817, 67790, 67789, 67788, 67787, 
    67786, 67785, 67784, 67783, 67782, 
    67781, 67780, 67779, 67778, 67777, 
    67776, 67775, 67774, 67773, 67772, 
    67771, 68694, 68693, 68661, 68532, 
    68124, 68123, 68692, 68662, 68573, 
    68531, 68374, 68361, 68199, 67871, 
    67844, 67843, 67840, 68201
  )

Query time 0.00055

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
67771 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Jo Parsons / Ben Stevens 1524495514 Y 2021-12-17 17:37:27 0
67772 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Tidy Publishing Paul Glazby 1524495546 Y 2021-12-17 17:37:27 0
67773 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Lucy Goldberg 1524495583 Y 2021-12-17 17:37:27 0
67774 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Johhny Newell 1524495616 Y 2021-12-17 17:37:27 0
67775 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 John Hardiman 1524495794 Y 2021-12-17 17:37:27 0
67776 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Kirsty Gannon / Lucy Goldberg 1524495844 Y 2021-12-17 17:37:27 0
67777 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Clarkson / Jay Lowe 1524495897 Y 2021-12-17 17:37:27 0
67778 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Chris Waddleton / Lucy Goldberg 1524495935 Y 2021-12-17 17:37:27 0
67779 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Chris Waddleton 1524495983 Y 2021-12-17 17:37:27 0
67780 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Truelove Music Andy Farley 1524496027 Y 2021-12-17 17:37:27 0
67781 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Gary Byrne 1524496056 Y 2021-12-17 17:37:27 0
67782 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Incisions 1524496085 Y 2021-12-17 17:37:27 0
67783 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Truelove Music Paul King 1524496133 Y 2021-12-17 17:37:27 0
67784 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 1524496164 Y 2021-12-17 17:37:27 0
67785 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Kirsty Gannon / Craig Lee 1524496197 Y 2021-12-17 17:37:27 0
67786 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Tidy Publishing Paul Glazby 1524496231 Y 2021-12-17 17:37:27 0
67787 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Music Paul Maddox / Ken Slater 1524496265 Y 2021-12-17 17:37:27 0
67788 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Tidy Publishing Paul Glazby / Mik Cree 1524496310 Y 2021-12-17 17:37:27 0
67789 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Tidy Publishing Paul Glazby 1524496334 Y 2021-12-17 17:37:27 0
67790 VCRHHA007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528671600 0 Y N N B N R Y N N Y 10 1528671600 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 Tidy Publishing Paul Glazby 1524496401 Y 2021-12-17 17:37:27 0
67840 VCR267 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527807600 0 Y N N B N R Y N N Y 10 1527807600 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 Kirsty Walker / Ryan Handley 1524584747 Y 2021-12-17 17:37:27 0
67841 VCR268 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529017200 0 Y N N B N R Y N N Y 10 1529017200 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 Charlie Lyons / Jeremy Winters 1524580824 Y 2021-12-17 17:37:27 0
67843 TBRDR004A P A 1 1.69 1 0.000 0 0 0 0.00 0 1527807600 0 Y N N B N R Y N N Y 10 1527807600 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 Nik Denton 1524585928 Y 2021-12-17 17:37:27 0
67844 TBRDR004B P A 1 1.69 1 0.000 0 0 0 0.00 0 1527807600 0 Y N N B N R Y N N Y 10 1527807600 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 Nik Denton 1524585982 Y 2021-12-17 17:37:27 0
67871 FBR295 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527807600 0 Y N N B N R Y N N Y 10 1527807600 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 Joseph 1524670901 Y 2021-12-17 17:37:27 0
68123 Cheek375 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528412400 0 Y N N B N R Y N N Y 10 1528412400 1529622000 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 5054283661552 GBKQU1818756 N Copyright Control Tony Di Bart, Andy Blissett, Lucinda Drayton 1525928404 Y 2021-12-17 17:37:27 0
68124 Cheek375 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528412400 0 Y N N B N R Y N N Y 10 1528412400 1529622000 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 5054283661552 GBKQU1828790 N Copyright Control Tony Di Bart, Andy Blissett, Lucinda Drayton 1525928405 Y 2021-12-17 17:37:27 0
68199 DB025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527807600 0 Y N N B N R Y N N Y 10 1527807600 1529017200 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 labelworx 5054283636857 GBKQU1842668 N Drop Bear Digital Leigh Jones, Mish Bennetts, Dan Hall 1527363198 Y 2021-12-17 17:37:27 0
68201 TMP106 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527721200 0 Y N N B N R Y N N Y 10 1527721200 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 Shane Percival & Chris Glossop 1526373892 Y 2021-12-17 17:37:27 0
68361 FR056a P A 1 1.69 1 0.000 0 0 0 0.00 0 1527807600 0 Y N N B N R Y N N Y 10 1527807600 0 N 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 Tim Sloan & Daniel Allen 1601225899 Y 2021-12-17 17:37:27 0
68374 HOT008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527807600 0 Y N N B N R Y N N Y 10 1527807600 1529017200 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 5054283685466 GBKQU1852301 N Hot Box Digital Matt Wade & Syanide 1527224406 Y 2021-12-17 17:37:27 0
68531 SS077 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527807600 0 Y N N B N R Y N N Y 10 1527807600 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 Recodings Paul Norris 1527604592 Y 2021-12-17 17:37:27 0
68532 PDHH097 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528412400 0 Y N N B N R Y N N Y 10 1528412400 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/Liddell Liddell 1527617389 Y 2021-12-17 17:37:27 0
68573 F4A003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527807600 0 Y N N B N R Y N N Y 10 1527807600 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 Alex Brough 1527764153 Y 2021-12-17 17:37:27 0
68661 TGR064 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528412400 0 Y N N B N R Y N N Y 10 1528412400 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 Paul Batten 1528310327 Y 2021-12-17 17:37:27 0
68662 UBT010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528315610 0 Y N N B N R Y N N Y 10 1528239600 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 / Mark Hard 1528316123 Y 2021-12-17 17:37:27 0
68692 ON051 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528399300 0 Y N N B N R Y N N Y 10 1528326000 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 1528399821 Y 2021-12-17 17:37:27 0
68693 ON052 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528412400 0 Y N N B N R Y N N Y 10 1528412400 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 Rob Yellowley, Anna Kitson 1528440182 Y 2021-12-17 17:37:27 0
68694 IOD056 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528412400 0 Y N N B N R Y N N Y 10 1528412400 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 Inside Out Digital Matt Wade / Pez 1528404020 Y 2021-12-17 17:37:27 0
68817 DD135 P A 1 1.69 1 0.000 0 0 0 0.00 0 1528732174 0 Y N N B N R Y N N Y 10 1528671600 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 GBKQU1861155 N Copyright Control Nick Georgiadis 1528732822 Y 2021-12-17 17:37:27 0