SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    105210, 105209, 105250, 105249, 105248, 
    105247, 105246, 105245, 105244, 105243, 
    105242, 105241, 105240, 105208, 105207, 
    105206, 105205, 105204, 105203, 105202
  )

Query time 0.00042

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
105202 TW10CD2D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524526 GBKQU2224639 N 105208 Copyright Control Various Artists 1646677326 Y 2022-03-07 18:15:05 0
105203 TW10CD2D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524526 GBKQU2224640 N 105208 Copyright Control Various Artists 1646677345 Y 2022-03-07 18:15:05 0
105204 TW10CD2D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524526 GBKQU2224641 N 105208 Copyright Control Various Artists 1646677366 Y 2022-03-07 18:15:05 0
105205 TW10CD2D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524526 GBKQU2224642 N 105208 Copyright Control Various Artists 1646677384 Y 2022-03-07 18:15:05 0
105206 TW10CD2D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524526 GBKQU2224643 N 105208 Copyright Control Various Artists 1646677405 Y 2022-03-07 18:15:06 0
105207 TW10CD2D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524526 GBKQU2224644 N 105208 Copyright Control Various Artists 1646677422 Y 2022-03-07 18:15:06 0
105208 TW10CD2D P A 1 8.99 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524526 Y 1743769588 Y 2022-03-07 18:15:06 0
105209 TIDYW11LAD P A 1 1.69 1 0.000 0 0 0 0.00 0 1167609600 0 Y N N B N R Y N N Y 10 1167609600 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 5054286524595 GBKQU2224666 N 105218 Copyright Control Various Artists 1646677443 Y 2022-03-07 18:15:09 0
105210 TIDYW11LAD P A 1 1.69 1 0.000 0 0 0 0.00 0 1167609600 0 Y N N B N R Y N N Y 10 1167609600 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 5054286524595 GBKQU2224667 N 105218 Copyright Control Various Artists 1646677461 Y 2022-03-07 18:15:10 0
105240 TW10CD3D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524533 GBKQU2224645 N 105250 Copyright Control Various Artists 1646677975 Y 2022-03-07 18:15:28 0
105241 TW10CD3D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524533 GBKQU2224646 N 105250 Copyright Control Various Artists 1646677994 Y 2022-03-07 18:15:29 0
105242 TW10CD3D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524533 GBKQU2224647 N 105250 Copyright Control Various Artists 1646678012 Y 2022-03-07 18:15:31 0
105243 TW10CD3D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524533 GBKQU2224648 N 105250 Copyright Control Various Artists 1646678033 Y 2022-03-07 18:15:31 0
105244 TW10CD3D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524533 GBKQU2224649 N 105250 Copyright Control Various Artists 1646678051 Y 2022-03-07 18:15:31 0
105245 TW10CD3D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524533 GBKQU2224650 N 105250 Copyright Control Various Artists 1646678068 Y 2022-03-07 18:15:31 0
105246 TW10CD3D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524533 GBKQU2224651 N 105250 Copyright Control Various Artists 1646678086 Y 2022-03-07 18:15:31 0
105247 TW10CD3D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524533 GBKQU2224652 N 105250 Copyright Control Various Artists 1646678104 Y 2022-03-07 18:15:32 0
105248 TW10CD3D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524533 GBKQU2224653 N 105250 Copyright Control Various Artists 1646678122 Y 2022-03-07 18:15:32 0
105249 TW10CD3D P A 1 1.69 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524533 GBKQU2224654 N 105250 Copyright Control Various Artists 1646678141 Y 2022-03-07 18:15:32 0
105250 TW10CD3D P A 1 8.99 1 0.000 0 0 0 0.00 0 1162512000 0 Y N N B N R Y N N Y 10 1162512000 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 5054286524533 Y 1743769588 Y 2022-03-07 18:15:32 0