SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    103976, 103975, 103974, 103973, 103972, 
    103971, 103970, 103969, 103968, 103967, 
    103966, 103965, 103964, 103963, 103962, 
    103961, 103960, 103959, 103947, 103946
  )

Query time 0.00042

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
103946 RES004D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286474586 GBKQU1934014 N 103947 Copyright Control Various Artists 1644544887 Y 2022-02-10 19:15:26 0
103947 RES004D P A 1 8.99 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286474586 Y 1743769583 Y 2022-02-10 19:15:27 0
103959 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215915 N Copyright Control Various Artists 1644545107 Y 2022-02-10 19:15:40 0
103960 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215916 N Copyright Control Various Artists 1644545125 Y 2022-02-10 19:15:41 0
103961 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215917 N Copyright Control Various Artists 1644545143 Y 2022-02-10 19:15:42 0
103962 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215918 N Copyright Control Various Artists 1644545163 Y 2022-02-10 19:15:43 0
103963 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215919 N Copyright Control Various Artists 1644545182 Y 2022-02-10 19:15:43 0
103964 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215920 N Copyright Control Various Artists 1644545200 Y 2022-02-10 19:15:43 0
103965 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215921 N Copyright Control Various Artists 1644545217 Y 2022-02-10 19:15:44 0
103966 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215922 N Copyright Control Various Artists 1644545234 Y 2022-02-10 19:15:44 0
103967 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215923 N Copyright Control Various Artists 1644545254 Y 2022-02-10 19:15:44 0
103968 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215924 N Copyright Control Various Artists 1644545272 Y 2022-02-10 19:15:44 0
103969 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215925 N Copyright Control Various Artists 1644545292 Y 2022-02-10 19:15:45 0
103970 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215926 N Copyright Control Various Artists 1644545310 Y 2022-02-10 19:15:45 0
103971 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215927 N Copyright Control Various Artists 1644545330 Y 2022-02-10 19:15:45 0
103972 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215928 N Copyright Control Various Artists 1644545347 Y 2022-02-10 19:15:45 0
103973 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215929 N Copyright Control Various Artists 1644545368 Y 2022-02-10 19:15:46 0
103974 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215930 N Copyright Control Various Artists 1644545389 Y 2022-02-10 19:15:46 0
103975 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215931 N Copyright Control Various Artists 1644545407 Y 2022-02-10 19:15:46 0
103976 TIDYTVA01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1072915200 0 Y N N B N R Y N N Y 10 1072915200 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;} labelworx 5054286476689 GBKQU2215932 N Copyright Control Various Artists 1644545442 Y 2022-02-10 19:15:46 0