SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    100888, 100887, 100886, 100885, 100884, 
    100883, 100882, 100881, 100880, 100878, 
    100844, 100843, 100809, 100780, 100646, 
    100483, 99747, 100808, 100367, 100779
  )

Query time 0.00050

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
99747 FD063 P A 1 1.69 1 0.000 0 0 0 0.00 0 1639094400 0 Y N N B N R Y N N Y 10 1639094400 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 Damien Blanes / Fabio Seramota 1634118140 Y 2021-12-17 17:37:27 0
100367 BTN024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1638748800 0 Y N N B N R Y N N Y 10 1638748800 1639958400 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;} 1 labelworx 5054286300335 GBLV62123503 N Bring The Noise Recordings Andy Naylor 1637211901 Y 2021-12-17 17:37:27 0
100483 INR083 P A 1 1.69 1 0.000 0 0 0 0.00 0 1639094400 0 Y N N B N R Y N N Y 10 1639094400 1640304000 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 5054286306535 GBLV62124562 N Copyright Control Spyndl 1637687403 Y 2021-12-17 17:37:27 0
100646 TTLFD021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1639094400 0 Y N N B N R Y N N Y 10 1639094400 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 Joshua Brown/Pete Ledwidge 1641760824 Y 10/12/2021 09/01/2022 2021-12-17 17:37:27 0
100779 KK010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1638651353 0 Y N N B N R Y N N Y 10 1638576000 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 Miles 1638651623 Y 2021-12-17 17:37:27 0
100780 VRF014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1639094400 0 Y N N B N R Y N N Y 10 1639094400 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 Jay Key 1638667191 Y 2021-12-17 17:37:27 0
100808 KR019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1638835200 0 Y N N B N R Y N N Y 10 1638835200 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 Harrison 1638813839 Y 2021-12-17 17:37:27 0
100809 GARH008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1639094400 0 Y N N B N R Y N N Y 10 1639094400 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 Dean Richardson 1642255139 Y 10/12/2021 09/01/2022 2021-12-17 17:37:27 0
100843 TRI008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1639094400 0 Y N N B N R Y N N Y 10 1639094400 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 1639045242 Y 2021-12-17 17:37:27 0
100844 SS096 P A 1 1.69 1 0.000 0 0 0 0.00 0 1639094400 0 Y N N B N R Y N N Y 10 1639094400 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 Slingshot Recordings Paul Norris/Gary O'Connor 1639150609 Y 2021-12-17 17:37:27 0
100878 FCP020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1639094400 0 Y N N B N R Y N N Y 10 1639094400 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 Full Circle Productions Tara Nicholson 1639084432 Y 2021-12-17 17:37:27 0
100880 BDR025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1639124618 0 Y N N B N R Y N N Y 10 1639094400 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 Nico Ahlqvist 1643558330 Y 10/12/2021 09/01/2022 2021-12-17 17:37:27 0
100881 IA030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1639128429 0 Y N N B N R Y N N Y 10 1639094400 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 TRIAC 1639128622 Y 2021-12-17 17:37:27 0
100882 TBTK021A P A 1 1.69 1 0.000 0 0 0 0.00 0 1639132736 0 Y N N B N R Y N N Y 10 1639094400 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 Toolbox Publishing Gary O'Connor 1639133121 Y 2021-12-17 17:37:27 0
100883 TBTK021B P A 1 1.69 1 0.000 0 0 0 0.00 0 1639132770 0 Y N N B N R Y N N Y 10 1639094400 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 Toolbox Publishing Gary O'Connor 1639133142 Y 2021-12-17 17:37:27 0
100884 TBTK021C P A 1 1.69 1 0.000 0 0 0 0.00 0 1639132806 0 Y N N B N R Y N N Y 10 1639094400 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 Toolbox Publishing Gary O'Connor 1639133162 Y 2021-12-17 17:37:27 0
100885 TBTK021D P A 1 1.69 1 0.000 0 0 0 0.00 0 1639132852 0 Y N N B N R Y N N Y 10 1639094400 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 Toolbox Publishing / Copyright Control Gary O'Connor, Tanya Sly, Gary Sly 1639133183 Y 2021-12-17 17:37:27 0
100886 TBTK021E P A 1 1.69 1 0.000 0 0 0 0.00 0 1639132887 0 Y N N B N R Y N N Y 10 1639094400 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 Toolbox Publishing Gary O'Connor 1639133204 Y 2021-12-17 17:37:27 0
100887 TBTK021F P A 1 1.69 1 0.000 0 0 0 0.00 0 1639133012 0 Y N N B N R Y N N Y 10 1639094400 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 Toolbox Publishing Gary O'Connor 1639133225 Y 2021-12-17 17:37:27 0
100888 TBTK021G P A 1 1.69 1 0.000 0 0 0 0.00 0 1639133073 0 Y N N B N R Y N N Y 10 1639094400 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 Toolbox Publishing Gary O'Connor / Paul Norris 1639133244 Y 2021-12-17 17:37:27 0