SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    103742, 103741, 103740, 103739, 103738, 
    103737, 103736, 103735, 103734, 103733, 
    103732, 103731, 103730, 103729, 103728, 
    103727, 103717, 103716, 103715, 103714
  )

Query time 0.00052

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
103714 KIT005DC P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474296 GBKQU1936719 N 103717 Copyright Control Various Artists 1644540598 Y 2022-02-10 19:05:08 0
103715 KIT005DC P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474296 GBKQU2131515 N 103717 Copyright Control Various Artists 1644540621 Y 2022-02-10 19:05:09 0
103716 KIT005DC P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474296 GBKQU1931093 N 103717 Copyright Control Various Artists 1644540642 Y 2022-02-10 19:05:09 0
103717 KIT005DC P A 1 8.99 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474296 Y 1743769583 Y 2022-02-10 19:05:11 0
103727 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1933036 N 103746 Copyright Control Various Artists 1644540839 Y 2022-02-10 19:05:19 0
103728 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1935377 N 103746 Copyright Control Various Artists 1644540856 Y 2022-02-10 19:05:20 0
103729 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1937384 N 103746 Copyright Control Various Artists 1644540873 Y 2022-02-10 19:05:22 0
103730 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1936720 N 103746 Copyright Control Various Artists 1644540893 Y 2022-02-10 19:05:22 0
103731 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1949506 N 103746 Copyright Control Various Artists 1644540913 Y 2022-02-10 19:05:25 0
103732 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1935259 N 103746 Copyright Control Various Artists 1644540935 Y 2022-02-10 19:05:26 0
103733 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1932826 N 103746 Copyright Control Various Artists 1644540959 Y 2022-02-10 19:05:27 0
103734 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1935593 N 103746 Copyright Control Various Artists 1644540976 Y 2022-02-10 19:05:27 0
103735 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1933227 N 103746 Copyright Control Various Artists 1644540995 Y 2022-02-10 19:05:27 0
103736 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1935519 N 103746 Copyright Control Various Artists 1644541016 Y 2022-02-10 19:05:27 0
103737 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU2119684 N 103746 Copyright Control Various Artists 1644541037 Y 2022-02-10 19:05:27 0
103738 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1933059 N 103746 Copyright Control Various Artists 1644541053 Y 2022-02-10 19:05:27 0
103739 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1935528 N 103746 Copyright Control Various Artists 1644541072 Y 2022-02-10 19:05:28 0
103740 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1969332 N 103746 Copyright Control Various Artists 1644541092 Y 2022-02-10 19:05:28 0
103741 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1938897 N 103746 Copyright Control Various Artists 1644541110 Y 2022-02-10 19:05:28 0
103742 KIT005DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1199145600 0 Y N N B N R Y N N Y 10 1199145600 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 5054286474357 GBKQU1934919 N 103746 Copyright Control Various Artists 1644541129 Y 2022-02-10 19:05:28 0