SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    65416, 65415, 65414, 65413, 65412, 65411, 
    65410, 65409, 65408, 65407, 65467, 
    65425, 61778, 65423, 65286, 65285, 
    65284, 65283, 65282, 65281, 65280, 
    65279, 65278, 65277, 65276, 65275, 
    65274, 65273, 65272, 65271, 65270, 
    65269, 65268, 65267, 65266, 65265, 
    65264, 65263, 65262, 65261
  )

Query time 0.00061

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
61778 VCR257 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515715200 0 Y N N B N R Y N N Y 10 1515715200 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 1504613810 Y 2021-12-17 17:37:27 0
65261 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 Copyright Control Wayne German 1515075479 Y 2021-12-17 17:37:27 0
65262 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 Copyright Control Ben MacDonald 1515075519 Y 2021-12-17 17:37:27 0
65263 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 / Sam Townend 1515075552 Y 2021-12-17 17:37:27 0
65264 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 Copyright Control Derek Newton 1515075576 Y 2021-12-17 17:37:27 0
65265 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 / Anthony Ratcliffe 1515075615 Y 2021-12-17 17:37:27 0
65266 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 Copyright Control Matt Wade 1515075642 Y 2021-12-17 17:37:27 0
65267 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 Copyright Control Michael Hagan 1515075675 Y 2021-12-17 17:37:27 0
65268 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 Copyright Control Richard Shepherd / Rob Yellowley 1515075719 Y 2021-12-17 17:37:27 0
65269 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 Jeff Payne / Ben Stevens 1515075758 Y 2021-12-17 17:37:27 0
65270 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 Copyright Control Matt Wade / Simon Mowling 1515075794 Y 2021-12-17 17:37:27 0
65271 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 Copyright Control Simon Mowling / Marc Lewis 1515075834 Y 2021-12-17 17:37:27 0
65272 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 Gaz Fullard / Ben Stevens 1515075882 Y 2021-12-17 17:37:27 0
65273 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 Copyright Control John Reilly 1515075914 Y 2021-12-17 17:37:27 0
65274 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 Copyright Control Adrian Buss 1515075941 Y 2021-12-17 17:37:27 0
65275 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 Copyright Control Nikk Geordasis 1515076003 Y 2021-12-17 17:37:27 0
65276 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 Copyright Control Dina Watson / Si Stevens 1515076042 Y 2021-12-17 17:37:27 0
65277 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 Copyright Control Andrew Cullen 1515076067 Y 2021-12-17 17:37:27 0
65278 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 Marc Lewis / Ben Stevens 1515076108 Y 2021-12-17 17:37:27 0
65279 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 Copyright Control Neil Bee 1515076140 Y 2021-12-17 17:37:27 0
65280 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 Copyright Control Aaron Price 1515076164 Y 2021-12-17 17:37:27 0
65281 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 / Skol Kelly 1515076208 Y 2021-12-17 17:37:27 0
65282 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 Copyright Control Craig Jones 1515076243 Y 2021-12-17 17:37:27 0
65283 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 / Anthony Ratcliffe 1515076273 Y 2021-12-17 17:37:27 0
65284 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 Copyright Control Ollie Thompson 1515076330 Y 2021-12-17 17:37:27 0
65285 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 Copyright Control Rick Eastham 1515076361 Y 2021-12-17 17:37:27 0
65286 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 Copyright Control Kris O'Rourke 1515076387 Y 2021-12-17 17:37:27 0
65407 TBBO2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1516147200 0 Y N N B N R Y N N Y 10 1516147200 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 Aaron James 1515579741 Y 2021-12-17 17:37:27 0
65408 TBBO2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1516147200 0 Y N N B N R Y N N Y 10 1516147200 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 Homson 1515579958 Y 2021-12-17 17:37:27 0
65409 TBBO2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1516147200 0 Y N N B N R Y N N Y 10 1516147200 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 Rob Yellowley 1515580201 Y 2021-12-17 17:37:27 0
65410 TBBO2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1516147200 0 Y N N B N R Y N N Y 10 1516147200 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 Sean Taylor / Dale West 1515580260 Y 2021-12-17 17:37:27 0
65411 TBBO2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1516147200 0 Y N N B N R Y N N Y 10 1516147200 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 Pearson / Tony King 1515580299 Y 2021-12-17 17:37:27 0
65412 TBBO2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1516147200 0 Y N N B N R Y N N Y 10 1516147200 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 / Hannah Stott 1515580339 Y 2021-12-17 17:37:27 0
65413 TBBO2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1516147200 0 Y N N B N R Y N N Y 10 1516147200 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 1515580417 Y 2021-12-17 17:37:27 0
65414 TBBO2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1516147200 0 Y N N B N R Y N N Y 10 1516147200 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 O'Connor 1515580449 Y 2021-12-17 17:37:27 0
65415 TBBO2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1516147200 0 Y N N B N R Y N N Y 10 1516147200 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 1515580485 Y 2021-12-17 17:37:27 0
65416 TBBO2017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1516147200 0 Y N N B N R Y N N Y 10 1516147200 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 Phil Cogan 1515580522 Y 2021-12-17 17:37:27 0
65423 TDOG116 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515651315 0 Y N N B N R Y N N Y 10 1515628800 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 1515652223 Y 2021-12-17 17:37:27 0
65425 IOD045 P A 1 1.69 1 0.000 0 0 0 0.00 0 1515715200 0 Y N N B N R Y N N Y 10 1515715200 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 / Kenny Seear 1515713255 Y 2021-12-17 17:37:27 0
65467 D10R P A 1 1.69 1 0.000 0 0 0 0.00 0 1515890147 0 Y N N B N R Y N N Y 10 1515888000 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 delusion delusion 1515890719 Y 2021-12-17 17:37:27 0