SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    68534, 68533, 68459, 68363, 68362, 68360, 
    68358, 68357, 68135, 68065, 68064, 
    67902, 67896, 67685, 67684, 66983, 
    68359, 67955, 68319, 68312, 67848, 
    67845, 67839, 67686, 67683, 66841, 
    66840, 66839, 67958, 68200, 67770, 
    67769, 67768, 67767, 67766, 67765, 
    67764, 67763, 67762, 67761
  )

Query time 0.00092

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
66839 TBF012A P A 1 1.69 1 0.000 0 0 0 0.00 0 1526598000 0 Y N N B N R Y N N Y 10 1526598000 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 The Bounce Factory Tom Berry 1523614620 Y 2021-12-17 17:37:27 0
66840 TBF012B P A 1 1.69 1 0.000 0 0 0 0.00 0 1526598000 0 Y N N B N R Y N N Y 10 1526598000 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 The Bounce Factory Tom Berry 1523614620 Y 2021-12-17 17:37:27 0
66841 TBF012C P A 1 1.69 1 0.000 0 0 0 0.00 0 1526598000 0 Y N N B N R Y N N Y 10 1526598000 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 The Bounce Factory Tom Berry 1523614620 Y 2021-12-17 17:37:27 0
66983 HWR004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 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 G-Mix 1711483465 Y 2021-12-17 17:37:27 0
67683 PKTTXXCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526598000 0 Y N N B N R Y N N Y 10 1526598000 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 / Kirsty Gannon 1524084089 Y 2021-12-17 17:37:27 0
67684 PKTTXXCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 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 / Matt Clarkson 1524084141 Y 2021-12-17 17:37:27 0
67685 PKTTXXCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 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 / Carl Nicholson 1524084245 Y 2021-12-17 17:37:27 0
67686 PKTTXXCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526598000 0 Y N N B N R Y N N Y 10 1526598000 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 / Ryan Tregurtha / Terrence Blunt 1524085015 Y 2021-12-17 17:37:27 0
67761 VCRHHA006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526252400 0 Y N N B N R Y N N Y 10 1526252400 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 Norris 1524494800 Y 2021-12-17 17:37:27 0
67762 VCRHHA006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526252400 0 Y N N B N R Y N N Y 10 1526252400 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 Jody Lock 1524494828 Y 2021-12-17 17:37:27 0
67763 VCRHHA006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526252400 0 Y N N B N R Y N N Y 10 1526252400 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 1524494859 Y 2021-12-17 17:37:27 0
67764 VCRHHA006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526252400 0 Y N N B N R Y N N Y 10 1526252400 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 James Hill 1524494884 Y 2021-12-17 17:37:27 0
67765 VCRHHA006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526252400 0 Y N N B N R Y N N Y 10 1526252400 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 Richard Roberts 1524494914 Y 2021-12-17 17:37:27 0
67766 VCRHHA006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526252400 0 Y N N B N R Y N N Y 10 1526252400 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 1524494953 Y 2021-12-17 17:37:27 0
67767 14/05/2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526252400 0 Y N N B N R Y N N Y 10 1526252400 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 Jeremy Winters / Charlie Lyons 1524495040 Y 2021-12-17 17:37:27 0
67768 VCRHHA006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526252400 0 Y N N B N R Y N N Y 10 1526252400 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 Mike Taylor 1524495072 Y 2021-12-17 17:37:27 0
67769 VCRHHA006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526252400 0 Y N N B N R Y N N Y 10 1526252400 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 Glazby 1524495111 Y 2021-12-17 17:37:27 0
67770 VCRHHA006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526252400 0 Y N N B N R Y N N Y 10 1526252400 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 Ian Mulford 1524495139 Y 2021-12-17 17:37:27 0
67839 VCR266 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526598000 0 Y N N B N R Y N N Y 10 1526598000 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 Adrian Buss 1524580673 Y 2021-12-17 17:37:27 0
67845 FBR294 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526598000 0 Y N N B N R Y N N Y 10 1526598000 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 Darren Meredith / Elliot Fletcher 1524588923 Y 2021-12-17 17:37:27 0
67848 TT021a P A 1 1.69 1 0.000 0 0 0 0.00 0 1526598000 0 Y N N B N R Y N N Y 10 1526598000 1527807600 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 5054283633771 GBKQU1842028 N Tuff Trax Scott Chaney & Dave Pearson 1524632401 Y 2021-12-17 17:37:27 0
67896 TT022a P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 1528412400 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 5054283633795 GBKQU1842030 N Tuff Trax Scott Chaney 1524718818 Y 2021-12-17 17:37:27 0
67902 FE140 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 1528412400 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 5054283596694 GBKQU1833983 N Fatal Energy Records Jason Osbourne 1524718819 Y 2021-12-17 17:37:27 0
67955 HOT007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526857200 0 Y N N B N R Y N N Y 10 1526857200 1528066800 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 5054283644364 GBKQU1844278 N Hot Box Digital Matt Wade & Miric 1524805419 Y 2021-12-17 17:37:27 0
67958 AAA161 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526511600 0 Y N N B N R Y N N Y 10 1526511600 1527721200 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 5054283642629 GBKQU1843834 N Ahura Mazda Recordings NITRO Burak Harsitlioglu 1524805422 Y 2021-12-17 17:37:27 0
68064 Cheek373 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 1528412400 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 5054283661521 GBLV61714296 N Copyright Control Alan Sharkey, Matt Clarkson 1525669202 Y 2021-12-17 17:37:27 0
68065 Cheek373 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 1528412400 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 5054283661521 GBKQU1808403 N Copyright Control Alan Sharkey, Matt Clarkson 1525669202 Y 2021-12-17 17:37:27 0
68135 PDHH096 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 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/Longbottom/Ingham Longbottom/Ingham 1531425578 Y 2021-12-17 17:37:27 0
68200 TMP105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526373807 0 Y N N B N R Y N N Y 10 1526338800 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 1526373922 Y 2021-12-17 17:37:27 0
68312 JAM023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526598000 0 Y N N B N R Y N N Y 10 1526598000 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 UKG3L1800004 N Copyright Control Teresa Bint 1526600674 Y 2021-12-17 17:37:27 0
68319 F4A002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1526648913 0 Y N N B N R Y N N Y 10 1526598000 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 Bry Randall 1526649322 Y 2021-12-17 17:37:27 0
68357 FD026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 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 Frantic Digital Damien Blanes / Dave Owens 1526838931 Y 2021-12-17 17:37:27 0
68358 TBF013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 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 The Bounce Factory Dan Diamond / Jamie Russell / Ad Molland 1526932008 Y 2021-12-17 17:37:27 0
68359 DD134 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527004896 0 Y N N B N R Y N N Y 10 1526943600 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 GBKQU1854129 N Copyright Control Nikkdbubble/Si Stevens 1527005723 Y 2021-12-17 17:37:27 0
68360 TND018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 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 Simon Mowling, Ben MacDonald 1527076538 Y 2021-12-17 17:37:27 0
68362 UBT009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 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 Kelly Newbies 1527141606 Y 2021-12-17 17:37:27 0
68363 SSD032 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527202800 0 Y N N B N R Y N N Y 10 1527202800 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 King/Martin Cook 1527181137 Y 2021-12-17 17:37:27 0
68459 BZK071 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527235004 0 Y N N B N R Y N N Y 10 1527202800 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 Copyright Control Dave Owens / James Jackson 1593722243 Y 2021-12-17 17:37:27 0
68533 420005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527630674 0 Y N N B N R Y N N Y 10 1527548400 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 Damaged Gudz 1527631220 Y 2021-12-17 17:37:27 0
68534 420006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1527631057 0 Y N N B N R Y N N Y 10 1527548400 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 Sean Inside Out/Dale West Sean Inside Out/Dale West 1527631240 Y 2021-12-17 17:37:27 0