SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    103655, 103654, 103653, 103652, 103651, 
    103650, 103649, 103648, 103647, 103646, 
    103645, 103644, 103643, 103642, 103641, 
    103640, 103639, 103638
  )

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 18 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
103638 KIT005DD 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 5054286474364 GBKQU1939199 N 103656 Copyright Control Various Artists 1644539091 Y 2022-02-10 19:00:24 0
103639 KIT005DD 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 5054286474364 GBKQU1949519 N 103656 Copyright Control Various Artists 1644539113 Y 2022-02-10 19:00:26 0
103640 KIT005DD 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 5054286474364 GBKQU1944946 N 103656 Copyright Control Various Artists 1644539133 Y 2022-02-10 19:00:29 0
103641 KIT005DD 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 5054286474364 GBKQU1937048 N 103656 Copyright Control Various Artists 1644539154 Y 2022-02-10 19:00:29 0
103642 KIT005DD 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 5054286474364 GBKQU1936730 N 103656 Copyright Control Various Artists 1644539173 Y 2022-02-10 19:00:30 0
103643 KIT005DD 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 5054286474364 GBKQU1932370 N 103656 Copyright Control Various Artists 1644539195 Y 2022-02-10 19:00:32 0
103644 KIT005DD 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 5054286474364 GBKQU1932354 N 103656 Copyright Control Various Artists 1644539215 Y 2022-02-10 19:00:33 0
103645 KIT005DD 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 5054286474364 GBKQU1977790 N 103656 Copyright Control Various Artists 1644539235 Y 2022-02-10 19:00:33 0
103646 KIT005DD 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 5054286474364 GBKQU1933213 N 103656 Copyright Control Various Artists 1644539254 Y 2022-02-10 19:00:34 0
103647 KIT005DD 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 5054286474364 GBKQU1934996 N 103656 Copyright Control Various Artists 1644539274 Y 2022-02-10 19:00:35 0
103648 KIT005DD 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 5054286474364 GBKQU1933223 N 103656 Copyright Control Various Artists 1644539293 Y 2022-02-10 19:00:35 0
103649 KIT005DD 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 5054286474364 GBKQU1937386 N 103656 Copyright Control Various Artists 1644539314 Y 2022-02-10 19:00:35 0
103650 KIT005DD 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 5054286474364 GBKQU1931090 N 103656 Copyright Control Various Artists 1644539338 Y 2022-02-10 19:00:35 0
103651 KIT005DD 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 5054286474364 GBKQU1934022 N 103656 Copyright Control Various Artists 1644539362 Y 2022-02-10 19:00:35 0
103652 KIT005DD 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 5054286474364 GBKQU1931085 N 103656 Copyright Control Various Artists 1644539382 Y 2022-02-10 19:00:36 0
103653 KIT005DD 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 5054286474364 GBKQU1932378 N 103656 Copyright Control Various Artists 1644539404 Y 2022-02-10 19:00:36 0
103654 KIT005DD 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 5054286474364 GBKQU1938893 N 103656 Copyright Control Various Artists 1644539423 Y 2022-02-10 19:00:36 0
103655 KIT005DD 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 5054286474364 GBKQU1949429 N 103656 Copyright Control Various Artists 1644539444 Y 2022-02-10 19:00:36 0