SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    103925, 103924, 103923, 103922, 103921, 
    103920, 103919, 103918, 103917, 103916, 
    103915, 103914, 103913, 103912, 103911, 
    103910, 103909, 103908, 103907, 103906
  )

Query time 0.00047

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
103906 KIT004DC 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 5054286474241 GBKQU1938622 N 103920 Copyright Control Various Artists 1644544123 Y 2022-02-10 19:15:04 0
103907 KIT004DC 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 5054286474241 GBKQU1931026 N 103920 Copyright Control Various Artists 1644544141 Y 2022-02-10 19:15:05 0
103908 KIT004DC 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 5054286474241 GBKQU1946537 N 103920 Copyright Control Various Artists 1644544160 Y 2022-02-10 19:15:05 0
103909 KIT004DC 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 5054286474241 GBKQU1934420 N 103920 Copyright Control Various Artists 1644544180 Y 2022-02-10 19:15:06 0
103910 KIT004DC 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 5054286474241 GBKQU1931056 N 103920 Copyright Control Various Artists 1644544201 Y 2022-02-10 19:15:06 0
103911 KIT004DC 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 5054286474241 GBKQU1930967 N 103920 Copyright Control Various Artists 1644544222 Y 2022-02-10 19:15:08 0
103912 KIT004DC 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 5054286474241 GBKQU1930942 N 103920 Copyright Control Various Artists 1644544243 Y 2022-02-10 19:15:09 0
103913 KIT004DC 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 5054286474241 GBKQU1930952 N 103920 Copyright Control Various Artists 1644544263 Y 2022-02-10 19:15:10 0
103914 KIT004DC 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 5054286474241 GBKQU1933682 N 103920 Copyright Control Various Artists 1644544286 Y 2022-02-10 19:15:10 0
103915 KIT004DC 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 5054286474241 GBKQU1933399 N 103920 Copyright Control Various Artists 1644544307 Y 2022-02-10 19:15:11 0
103916 KIT004DC 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 5054286474241 GBKQU1933965 N 103920 Copyright Control Various Artists 1644544325 Y 2022-02-10 19:15:12 0
103917 KIT004DC 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 5054286474241 GBKQU1933981 N 103920 Copyright Control Various Artists 1644544343 Y 2022-02-10 19:15:13 0
103918 KIT004DC 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 5054286474241 GBKQU1933506 N 103920 Copyright Control Various Artists 1644544360 Y 2022-02-10 19:15:13 0
103919 KIT004DC 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 5054286474241 GBKQU1933477 N 103920 Copyright Control Various Artists 1644544379 Y 2022-02-10 19:15:13 0
103920 KIT004DC 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 5054286474241 Y 1743769583 Y 2022-02-10 19:15:13 0
103921 KIT004DB 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 5054286474265 GBKQU1933026 N 103936 Copyright Control Various Artists 1644544395 Y 2022-02-10 19:15:16 0
103922 KIT004DB 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 5054286474265 GBKQU1931013 N 103936 Copyright Control Various Artists 1644544416 Y 2022-02-10 19:15:17 0
103923 KIT004DB 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 5054286474265 GBKQU1933557 N 103936 Copyright Control Various Artists 1644544433 Y 2022-02-10 19:15:18 0
103924 KIT004DB 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 5054286474265 GBKQU1933547 N 103936 Copyright Control Various Artists 1644544450 Y 2022-02-10 19:15:18 0
103925 KIT004DB 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 5054286474265 GBKQU1933913 N 103936 Copyright Control Various Artists 1644544473 Y 2022-02-10 19:15:18 0