SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    98260, 98259, 98258, 98257, 98256, 98255, 
    98254, 98253, 98252, 98251, 98250, 
    98249, 98248, 98247, 98246, 98245, 
    98244, 98243, 98242, 98241
  )

Query time 0.00028

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 20 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
98241 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596623 Y 2021-12-17 17:37:27 0
98242 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596608 Y 2021-12-17 17:37:27 0
98243 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor/Danny Gilligan/Zeetah Massiah 1628596613 Y 2021-12-17 17:37:27 0
98244 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor/Ger Quinlan 1628596610 Y 2021-12-17 17:37:27 0
98245 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor/Tenchy 1628596598 Y 2021-12-17 17:37:27 0
98246 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596597 Y 2021-12-17 17:37:27 0
98247 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596596 Y 2021-12-17 17:37:27 0
98248 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Paul Norris/Gary O'Connor 1628596594 Y 2021-12-17 17:37:27 0
98249 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596593 Y 2021-12-17 17:37:27 0
98250 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596594 Y 2021-12-17 17:37:27 0
98251 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596593 Y 2021-12-17 17:37:27 0
98252 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Andy Farley/Gary O'Connor 1628596591 Y 2021-12-17 17:37:27 0
98253 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596588 Y 2021-12-17 17:37:27 0
98254 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596588 Y 2021-12-17 17:37:27 0
98255 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596568 Y 2021-12-17 17:37:27 0
98256 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596569 Y 2021-12-17 17:37:27 0
98257 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596569 Y 2021-12-17 17:37:27 0
98258 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596569 Y 2021-12-17 17:37:27 0
98259 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor 1628596570 Y 2021-12-17 17:37:27 0
98260 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Toolbox Publishing Gary O'Connor/Amber Dowler 1628596572 Y 2021-12-17 17:37:27 0