SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    103647, 103646, 103645, 103644, 103643, 
    103642, 103641, 103640, 103639, 103638, 
    105262, 105261, 105260, 105259, 105258, 
    105257, 105256, 105255, 105254, 105253
  )

Query time 0.00048

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
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
105253 TW12CD1D P A 1 1.69 1 0.000 0 0 0 0.00 0 1194048000 0 Y N N B N R Y N N Y 10 1194048000 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 5054286524625 GBKQU2224688 N 105262 Copyright Control Various Artists 1646678199 Y 2022-03-07 18:15:35 0
105254 TW12CD1D P A 1 1.69 1 0.000 0 0 0 0.00 0 1194048000 0 Y N N B N R Y N N Y 10 1194048000 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 5054286524625 GBKQU2224689 N 105262 Copyright Control Various Artists 1646678219 Y 2022-03-07 18:15:35 0
105255 TW12CD1D P A 1 1.69 1 0.000 0 0 0 0.00 0 1194048000 0 Y N N B N R Y N N Y 10 1194048000 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 5054286524625 GBKQU2224690 N 105262 Copyright Control Various Artists 1646678242 Y 2022-03-07 18:15:36 0
105256 TW12CD1D P A 1 1.69 1 0.000 0 0 0 0.00 0 1194048000 0 Y N N B N R Y N N Y 10 1194048000 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 5054286524625 GBKQU2224691 N 105262 Copyright Control Various Artists 1646678264 Y 2022-03-07 18:15:37 0
105257 TW12CD1D P A 1 1.69 1 0.000 0 0 0 0.00 0 1194048000 0 Y N N B N R Y N N Y 10 1194048000 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 5054286524625 GBKQU2224692 N 105262 Copyright Control Various Artists 1646678281 Y 2022-03-07 18:15:37 0
105258 TW12CD1D P A 1 1.69 1 0.000 0 0 0 0.00 0 1194048000 0 Y N N B N R Y N N Y 10 1194048000 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 5054286524625 GBKQU2224693 N 105262 Copyright Control Various Artists 1646678301 Y 2022-03-07 18:15:38 0
105259 TW12CD1D P A 1 1.69 1 0.000 0 0 0 0.00 0 1194048000 0 Y N N B N R Y N N Y 10 1194048000 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 5054286524625 GBKQU2224694 N 105262 Copyright Control Various Artists 1646678319 Y 2022-03-07 18:15:38 0
105260 TW12CD1D P A 1 1.69 1 0.000 0 0 0 0.00 0 1194048000 0 Y N N B N R Y N N Y 10 1194048000 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 5054286524625 GBKQU2224695 N 105262 Copyright Control Various Artists 1646678338 Y 2022-03-07 18:15:40 0
105261 TW12CD1D P A 1 1.69 1 0.000 0 0 0 0.00 0 1194048000 0 Y N N B N R Y N N Y 10 1194048000 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 5054286524625 GBKQU2224696 N 105262 Copyright Control Various Artists 1646678359 Y 2022-03-07 18:15:42 0
105262 TW12CD1D P A 1 8.99 1 0.000 0 0 0 0.00 0 1194048000 0 Y N N B N R Y N N Y 10 1194048000 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 5054286524625 Y 1743769588 Y 2022-03-07 18:15:42 0