SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    103857, 103856, 103855, 103854, 103853, 
    103852, 103851, 103850, 103849, 103848, 
    103847, 103846, 103845, 103844, 103843, 
    103842, 103841, 103840, 103839, 103838
  )

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
103838 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1932354 N 103864 Copyright Control Various Artists 1644542859 Y 2022-02-10 19:10:23 0
103839 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1964083 N 103864 Copyright Control Various Artists 1644542877 Y 2022-02-10 19:10:23 0
103840 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1932780 N 103864 Copyright Control Various Artists 1644542899 Y 2022-02-10 19:10:24 0
103841 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1932366 N 103864 Copyright Control Various Artists 1644542918 Y 2022-02-10 19:10:25 0
103842 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1952590 N 103864 Copyright Control Various Artists 1644542937 Y 2022-02-10 19:10:26 0
103843 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1938873 N 103864 Copyright Control Various Artists 1644542955 Y 2022-02-10 19:10:26 0
103844 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1937371 N 103864 Copyright Control Various Artists 1644542975 Y 2022-02-10 19:10:27 0
103845 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1939199 N 103864 Copyright Control Various Artists 1644542991 Y 2022-02-10 19:10:27 0
103846 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1931005 N 103864 Copyright Control Various Artists 1644543011 Y 2022-02-10 19:10:27 0
103847 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1952624 N 103864 Copyright Control Various Artists 1644543032 Y 2022-02-10 19:10:28 0
103848 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1933990 N 103864 Copyright Control Various Artists 1644543052 Y 2022-02-10 19:10:28 0
103849 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1934982 N 103864 Copyright Control Various Artists 1644543071 Y 2022-02-10 19:10:28 0
103850 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1949506 N 103864 Copyright Control Various Artists 1644543091 Y 2022-02-10 19:10:28 0
103851 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1934435 N 103864 Copyright Control Various Artists 1644543112 Y 2022-02-10 19:10:29 0
103852 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1938897 N 103864 Copyright Control Various Artists 1644543132 Y 2022-02-10 19:10:29 0
103853 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1932882 N 103864 Copyright Control Various Artists 1644543150 Y 2022-02-10 19:10:29 0
103854 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1937065 N 103864 Copyright Control Various Artists 1644543170 Y 2022-02-10 19:10:29 0
103855 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1933380 N 103864 Copyright Control Various Artists 1644543189 Y 2022-02-10 19:10:29 0
103856 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1933389 N 103864 Copyright Control Various Artists 1644543209 Y 2022-02-10 19:10:30 0
103857 UTDU001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1149462000 0 Y N N B N R Y N N Y 10 1149462000 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 5054286474821 GBKQU1933506 N 103864 Copyright Control Various Artists 1644543227 Y 2022-02-10 19:10:30 0