SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    68835, 69400, 69349, 69324, 69291, 69257, 
    69256, 69255, 69123, 68831, 68697, 
    68696, 68879, 68906, 68576, 69176, 
    69175, 69174, 69033, 67842, 69173, 
    69172, 69100, 69099, 69032, 69022, 
    68905, 68408, 68368, 68367, 68695, 
    68547, 68555, 68904, 68903, 68834, 
    68833, 68725, 68605, 68292
  )

Query time 0.00060

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
67842 VCR269 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530226800 0 Y N N B N R Y N N Y 10 1530226800 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 Pickup / Myles Davies 1524580918 Y 2021-12-17 17:37:27 0
68292 TT024a 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 1530226800 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 5054283633832 GBKQU1842037 N Tuff Trax Garett Reimond 1526533226 Y 2021-12-17 17:37:27 0
68367 Cheek377 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529622000 0 Y N N B N R Y N N Y 10 1529622000 1530831600 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 5054283679410 GBKQU1803446 N Copyright Control Jamie Tennant 1527224403 Y 2021-12-17 17:37:27 0
68368 Cheek377 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529622000 0 Y N N B N R Y N N Y 10 1529622000 1530831600 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 5054283679410 GBKQU1828787 N Copyright Control Jamie Tennant 1527224403 Y 2021-12-17 17:37:27 0
68408 DB026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529622000 0 Y N N B N R Y N N Y 10 1529622000 1530831600 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 5054283690088 GBKQU1853393 N Drop Bear Digital Matt Wade, Pez, Marc Coyne 1527224463 Y 2021-12-17 17:37:27 0
68547 IR030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529535600 0 Y N N B N R Y N N Y 10 1529535600 1530745200 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 5054283702903 GBKQU1855967 N Innervate Records Noath 1527742802 Y 2021-12-17 17:37:27 0
68555 HOT009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529276400 0 Y N N B N R Y N N Y 10 1529276400 1530486000 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 5054283706710 GBKQU1856705 N Hot Box Digital Pez 1527742807 Y 2021-12-17 17:37:27 0
68576 UTHHD023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530313200 0 Y N N B N R Y N N Y 10 1530313200 1531522800 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 5054283696097 GBKQU1854638 N Ultratech Jay Middleton 1527829202 Y 2021-12-17 17:37:27 0
68605 HWR005 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 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 N Hooverweight Records Mark Hard & Dan Dyson 1632310888 Y 2021-12-17 17:37:27 0
68695 IOD057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529535600 0 Y N N B N R Y N N Y 10 1529535600 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 Inside Out Digital Gary Toomey 1529655331 Y 2021-12-17 17:37:27 0
68696 IOD058 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530745200 0 Y N N B N R Y N N Y 10 1530745200 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 Inside Out Digital Marc lewis 1529655338 Y 2021-12-17 17:37:27 0
68697 IOD059 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530745200 0 Y N N B N R Y N N Y 10 1530745200 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 Inside Out Digital Dean Liddell 1530813256 Y 2021-12-17 17:37:27 0
68725 TMP107 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 Tempo Trax Rob Yellowley 1528545479 Y 2021-12-17 17:37:27 0
68831 AAA164 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530745200 0 Y N N B N R Y N N Y 10 1530745200 1531954800 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 5054283728088 GBKQU1861213 N Ahura Mazda Recordings NITRO Burak Harsitlioglu 1528866003 Y 2021-12-17 17:37:27 0
68833 FBR296 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 Craig Jones 1528917407 Y 2021-12-17 17:37:27 0
68834 FR056b 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 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 1601225916 Y 2021-12-17 17:37:27 0
68835 Cheek380 P A 1 1.69 1 0.000 0 0 0 0.00 0 1531436400 0 Y N N B N R Y N N Y 10 1531436400 1532646000 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 5054283720860 GBKQU1804858 N Copyright Control Matt Wade, Joe Swales 1528952401 Y 2021-12-17 17:37:27 0
68879 HOT010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530486000 0 Y N N B N R Y N N Y 10 1530486000 1531695600 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 5054283734133 GBKQU1862514 N Hot Box Digital Kirk P 1529038802 Y 2021-12-17 17:37:27 0
68903 RPR175 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529150519 0 Y N N B N R Y N N Y 10 1529103600 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 GBXME0800175 N none Gemma Stapleton 1529151321 Y 2021-12-17 17:37:27 0
68904 RPR176 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529153354 0 Y N N B N R Y N N Y 10 1529103600 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 GBXME0800176 N none Gemma Stapleton 1529154022 Y 2021-12-17 17:37:27 0
68905 PDHH098 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529622000 0 Y N N B N R Y N N Y 10 1529622000 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/Fullard/Bee/Stevens Fullard/Bee/Stevens 1529156105 Y 2021-12-17 17:37:27 0
68906 MHR009A P A 1 1.69 1 0.000 0 0 0 0.00 0 1530399600 0 Y N N B N R Y N N Y 10 1530399600 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;} 3 GBKQU1863327 N Defensive Music Toryn Davis, Justin Kashi 1529233508 Y 2021-12-17 17:37:27 0
69022 JAM024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529622000 0 Y N N B N R Y N N Y 10 1529622000 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 UKG3L1800005 N Copyright Control James Price/Aaron James 1529603184 Y 2021-12-17 17:37:27 0
69032 TND019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529661810 0 Y N N B N R Y N N Y 10 1529622000 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 Marc Lewis 1529662520 Y 2021-12-17 17:37:27 0
69033 DER001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530226800 0 Y N N B N R Y N N Y 10 1530226800 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, Pez, Matt Rush 1529699939 Y 2021-12-17 17:37:27 0
69099 420010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529971534 0 Y N N B N R Y N N Y 10 1529967600 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 Ali Murdoch Ali Murdoch 1529972120 Y 2021-12-17 17:37:27 0
69100 242009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1529972276 0 Y N N B N R Y N N Y 10 1529967600 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 Skol Skol Kelly 1529973026 Y 2021-12-17 17:37:27 0
69123 HWR006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530831600 0 Y N N B N R Y N N Y 10 1530831600 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 Hooverweight Records Damaged Gudz 1711483472 Y 2021-12-17 17:37:27 0
69172 DD136 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530183504 0 Y N N B N R Y N N Y 10 1530140400 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 GBKQU1866694 N Copyright Control Dan Hall 1530183620 Y 2021-12-17 17:37:27 0
69173 F4A004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530189071 0 Y N N B N R Y N N Y 10 1530140400 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 23rd Precinct Frank Farrell / Justin Fox 1530189921 Y 2021-12-17 17:37:27 0
69174 SS078 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530226800 0 Y N N B N R Y N N Y 10 1530226800 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/Matt Clarkson 1530198104 Y 2021-12-17 17:37:27 0
69175 SSD033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530226800 0 Y N N B N R Y N N Y 10 1530226800 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/Steve Taylor 1530226054 Y 2021-12-17 17:37:27 0
69176 COOKIE022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530239841 0 Y N N B N R Y N N Y 10 1530226800 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 1530240322 Y 2021-12-17 17:37:27 0
69255 PDHH099 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530831600 0 Y N N B N R Y N N Y 10 1530831600 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/Orton Orton/Stevens 1530812097 Y 2021-12-17 17:37:27 0
69256 UBT011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530831600 0 Y N N B N R Y N N Y 10 1530831600 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 Mischief Duo 1530833306 Y 2021-12-17 17:37:27 0
69257 TND020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530838931 0 Y N N B N R Y N N Y 10 1530831600 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 LeeRoy, Miss Cheeky B 1530839720 Y 2021-12-17 17:37:27 0
69291 F4A005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1530878651 0 Y N N B N R Y N N Y 10 1530831600 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 Ross Mair 1530879321 Y 2021-12-17 17:37:27 0
69324 JTH009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1531040950 0 Y N N B N R Y N N Y 10 1531004400 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/A N Copyright Control Gareth Jones / Ben Kaye 1546877282 Y 2021-12-17 17:37:27 0
69349 DD137 P A 1 1.69 1 0.000 0 0 0 0.00 0 1531246438 0 Y N N B N R Y N N Y 10 1531177200 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 GBKQU1870374 N Copyright Control Nikkdbubble 1531246520 Y 2021-12-17 17:37:27 0
69400 TMP108 P A 1 1.69 1 0.000 0 0 0 0.00 0 1531402953 0 Y N N B N R Y N N Y 10 1531350000 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 John Reilly 1531403122 Y 2021-12-17 17:37:27 0