SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    101603, 101602, 101601, 101599, 101598, 
    101596, 101595, 101594, 101593, 101592, 
    101591, 101590, 101585, 101583, 101582, 
    101544, 102132, 102131, 102130, 102129
  )

Query time 0.00055

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
101544 MQDRFR008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644364800 0 Y N N B N R Y N N Y 10 1644364800 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 5054286378266 GBKQU2200105 N +QDance Records Oo Sweetman 1641791402 Y 2022-01-10 06:10:02 0
101582 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBLV62101049 N 101606 Copyright Control Various Artists 1641964506 Y 2022-01-12 06:15:06 0
101583 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2112344 N 101606 Copyright Control Various Artists 1641964507 Y 2022-01-12 06:15:07 0
101585 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2186508 N 101606 Copyright Control Various Artists 1641964509 Y 2022-01-12 06:15:09 0
101590 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2192160 N 101606 Copyright Control Various Artists 1641964512 Y 2022-01-12 06:15:12 0
101591 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBLV62104207 N 101606 Copyright Control Various Artists 1641964512 Y 2022-01-12 06:15:12 0
101592 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2161144 N 101606 Copyright Control Various Artists 1641964512 Y 2022-01-12 06:15:12 0
101593 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2176578 N 101606 Copyright Control Various Artists 1641964512 Y 2022-01-12 06:15:12 0
101594 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2171932 N 101606 Copyright Control Various Artists 1641964512 Y 2022-01-12 06:15:12 0
101595 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2159431 N 101606 Copyright Control Various Artists 1641964513 Y 2022-01-12 06:15:13 0
101596 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2132409 N 101606 Copyright Control Various Artists 1641964513 Y 2022-01-12 06:15:13 0
101598 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2151536 N 101606 Copyright Control Various Artists 1641964513 Y 2022-01-12 06:15:13 0
101599 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2155163 N 101606 Copyright Control Various Artists 1641964514 Y 2022-01-12 06:15:14 0
101601 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2161145 N 101606 Copyright Control Various Artists 1641964514 Y 2022-01-12 06:15:14 0
101602 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2137817 N 101606 Copyright Control Various Artists 1641964514 Y 2022-01-12 06:15:14 0
101603 LWSHD14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1644537600 0 Y N N B N R Y N N Y 10 1644537600 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 5054286377245 GBKQU2139214 N 101606 Copyright Control Various Artists 1641964514 Y 2022-01-12 06:15:14 0
102129 HDCRFTL002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286453741 GBKQU2211648 N 102133 Copyright Control Various Artists 1643649634 Y 2022-01-31 18:20:34 0
102130 HDCRFTL002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286453741 GBKQU2211649 N 102133 Copyright Control Various Artists 1643649634 Y 2022-01-31 18:20:34 0
102131 HDCRFTL002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286453741 GBKQU2211650 N 102133 Copyright Control Various Artists 1643649634 Y 2022-01-31 18:20:34 0
102132 HDCRFTL002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286453741 GBKQU2211651 N 102133 Copyright Control Various Artists 1643649634 Y 2022-01-31 18:20:34 0