SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    65260, 65340, 65210, 64553, 65258, 65257, 
    65256, 65255, 65254, 65253, 65252, 
    65251, 65250, 65249, 65248, 65247, 
    65246, 65245, 65244, 65243, 65242, 
    65241, 65240, 65239, 65238, 65237, 
    65236, 65235, 65234, 65233, 65232, 
    65231, 65230, 65229, 65163, 65162, 
    65161, 65160, 65159, 65114
  )

Query time 0.00059

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
64553 PDHH086 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515110400 0 Y N N B N R Y N N Y 10 1515110400 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/Banks Sean Taylor/Tara Banks 1512683678 Y 2021-12-17 17:37:27 0
65114 IGLA62 P A 1 1.69 1 0.000 0 0 0 0.00 0 1514629393 0 Y N N B N R Y N N Y 10 1514592000 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 1514629858 Y 2021-12-17 17:37:27 0
65159 IGLA63 P A 1 1.69 1 0.000 0 0 0 0.00 0 1514725218 0 Y N N B N R Y N N Y 10 1514678400 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 1514726122 Y 2021-12-17 17:37:27 0
65160 IGLA64 P A 1 1.69 1 0.000 0 0 0 0.00 0 1514725301 0 Y N N B N R Y N N Y 10 1514678400 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/Dave Owens 1514726140 Y 2021-12-17 17:37:27 0
65161 IGLA65 P A 1 1.69 1 0.000 0 0 0 0.00 0 1514725386 0 Y N N B N R Y N N Y 10 1514678400 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/Steven Ricketts 1514726157 Y 2021-12-17 17:37:27 0
65162 IGLA66 P A 1 1.69 1 0.000 0 0 0 0.00 0 1514725466 0 Y N N B N R Y N N Y 10 1514678400 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/Steven Ricketts 1514726175 Y 2021-12-17 17:37:27 0
65163 IGLA67 P A 1 1.69 1 0.000 0 0 0 0.00 0 1514725545 0 Y N N B N R Y N N Y 10 1514678400 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/Steve Maynard 1514726194 Y 2021-12-17 17:37:27 0
65210 TND008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515110400 0 Y N N B N R Y N N Y 10 1515110400 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 1514975097 Y 2021-12-17 17:37:27 0
65229 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515065037 0 Y N N B N R Y N N Y 10 1515024000 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 / Aaron Langstaff 1515065423 Y 2021-12-17 17:37:27 0
65230 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515065099 0 Y N N B N R Y N N Y 10 1515024000 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 1515065442 Y 2021-12-17 17:37:27 0
65231 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515065152 0 Y N N B N R Y N N Y 10 1515024000 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 Stuart Byrne 1515065463 Y 2021-12-17 17:37:27 0
65232 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515065183 0 Y N N B N R Y N N Y 10 1515024000 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 Kris O'Rourke 1515065481 Y 2021-12-17 17:37:27 0
65233 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515065225 0 Y N N B N R Y N N Y 10 1515024000 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 Wayne German 1515065501 Y 2021-12-17 17:37:27 0
65234 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067084 0 Y N N B N R Y N N Y 10 1515024000 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 1515067221 Y 2021-12-17 17:37:27 0
65235 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067239 0 Y N N B N R Y N N Y 10 1515024000 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 / Nik Denton 1515068126 Y 2021-12-17 17:37:27 0
65236 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067291 0 Y N N B N R Y N N Y 10 1515024000 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 Lusty 1515068145 Y 2021-12-17 17:37:27 0
65237 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067354 0 Y N N B N R Y N N Y 10 1515024000 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 / Paul Maddox 1515068171 Y 2021-12-17 17:37:27 0
65238 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067392 0 Y N N B N R Y N N Y 10 1515024000 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 Andy Farley 1515068191 Y 2021-12-17 17:37:27 0
65239 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067433 0 Y N N B N R Y N N Y 10 1515024000 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 1515068209 Y 2021-12-17 17:37:27 0
65240 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067465 0 Y N N B N R Y N N Y 10 1515024000 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 Dawn Lee 1515068230 Y 2021-12-17 17:37:27 0
65241 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067545 0 Y N N B N R Y N N Y 10 1515024000 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 1515068251 Y 2021-12-17 17:37:27 0
65242 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067673 0 Y N N B N R Y N N Y 10 1515024000 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 Andy Farley / Jeff Payne 1515068271 Y 2021-12-17 17:37:27 0
65243 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067699 0 Y N N B N R Y N N Y 10 1515024000 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 Leighton Smith 1515068292 Y 2021-12-17 17:37:27 0
65244 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067748 0 Y N N B N R Y N N Y 10 1515024000 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 Jeff Payne 1515068312 Y 2021-12-17 17:37:27 0
65245 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067860 0 Y N N B N R Y N N Y 10 1515024000 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 Ben Stevens / Mark Tench 1515068329 Y 2021-12-17 17:37:27 0
65246 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067897 0 Y N N B N R Y N N Y 10 1515024000 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 / Gaz Fullard 1515068350 Y 2021-12-17 17:37:27 0
65247 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515067929 0 Y N N B N R Y N N Y 10 1515024000 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 Kris O'Rourke 1515068369 Y 2021-12-17 17:37:27 0
65248 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515068171 0 Y N N B N R Y N N Y 10 1515024000 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 / Rob Tissera / Adam Martin 1515069020 Y 2021-12-17 17:37:27 0
65249 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515068485 0 Y N N B N R Y N N Y 10 1515024000 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 / Rob Tissera / Adam Martin 1515069039 Y 2021-12-17 17:37:27 0
65250 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515068530 0 Y N N B N R Y N N Y 10 1515024000 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 / Anthony Ratcliffe 1515069059 Y 2021-12-17 17:37:27 0
65251 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515068563 0 Y N N B N R Y N N Y 10 1515024000 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 Andy Farley / Paul Glazby 1515069078 Y 2021-12-17 17:37:27 0
65252 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515068713 0 Y N N B N R Y N N Y 10 1515024000 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 Andy Farley / Paul Glazby 1515069097 Y 2021-12-17 17:37:27 0
65253 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515068746 0 Y N N B N R Y N N Y 10 1515024000 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 Steve Maynard / Frank Farrell 1515069116 Y 2021-12-17 17:37:27 0
65254 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515068799 0 Y N N B N R Y N N Y 10 1515024000 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 / John Weatherley 1515069136 Y 2021-12-17 17:37:27 0
65255 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515068826 0 Y N N B N R Y N N Y 10 1515024000 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 Justin Roper 1515069154 Y 2021-12-17 17:37:27 0
65256 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515068860 0 Y N N B N R Y N N Y 10 1515024000 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 Mark Tench / Myles Davies 1515069175 Y 2021-12-17 17:37:27 0
65257 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515068908 0 Y N N B N R Y N N Y 10 1515024000 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 / Matt Clarkson 1515069194 Y 2021-12-17 17:37:27 0
65258 VCRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515070767 0 Y N N B N R Y N N Y 10 1515024000 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 Fabio Seramota 1515070824 Y 2021-12-17 17:37:27 0
65260 FBRB2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515542400 0 Y N N B N R Y N N Y 10 1515542400 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 1515075436 Y 2021-12-17 17:37:27 0
65340 JTH007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515355257 0 Y N N B N R Y N N Y 10 1515283200 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 Martin Cook/Mark Heyes 1515356120 Y 2021-12-17 17:37:27 0