SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    101123, 101122, 101121, 101120, 101119, 
    101118, 101117, 101116, 101115, 101114, 
    101113, 101112, 101111, 101110, 101109, 
    101071, 101070, 101069, 101068, 101067
  )

Query time 0.00050

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
101067 LWDNCD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642118400 0 Y N N B N R Y N N Y 10 1642118400 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 5054286352044 FR9W12107803 N 101072 Copyright Control Various Artists 1639674608 Y 2021-12-17 17:37:27 0
101068 LWDNCD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642118400 0 Y N N B N R Y N N Y 10 1642118400 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 5054286352044 GBKQU2165793 N 101072 Copyright Control Various Artists 1639674608 Y 2021-12-17 17:37:27 0
101069 LWDNCD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642118400 0 Y N N B N R Y N N Y 10 1642118400 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 5054286352044 GBKQU2150477 N 101072 Copyright Control Various Artists 1639674608 Y 2021-12-17 17:37:27 0
101070 LWDNCD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642118400 0 Y N N B N R Y N N Y 10 1642118400 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 5054286352044 UKG4K2100017 N 101072 Copyright Control Various Artists 1639674608 Y 2021-12-17 17:37:27 0
101071 LWDNCD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642118400 0 Y N N B N R Y N N Y 10 1642118400 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 5054286352044 GBKQU2142228 N 101072 Copyright Control Various Artists 1639674608 Y 2021-12-17 17:37:27 0
101109 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1377112 N 101141 mcps copyright control various artists 1639804205 Y 2021-12-18 06:10:05 0
101110 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBU6Z1100036 N 101141 mcps copyright control various artists 1639804205 Y 2021-12-18 06:10:05 0
101111 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1135496 N 101141 mcps copyright control various artists 1639804205 Y 2021-12-18 06:10:05 0
101112 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1340009 N 101141 mcps copyright control various artists 1639804206 Y 2021-12-18 06:10:06 0
101113 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1222649 N 101141 mcps copyright control various artists 1639804206 Y 2021-12-18 06:10:06 0
101114 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1165925 N 101141 mcps copyright control various artists 1639804206 Y 2021-12-18 06:10:06 0
101115 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1383632 N 101141 mcps copyright control various artists 1639804207 Y 2021-12-18 06:10:07 0
101116 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBLV61807666 N 101141 mcps copyright control various artists 1639804207 Y 2021-12-18 06:10:07 0
101117 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1279672 N 101141 mcps copyright control various artists 1639804207 Y 2021-12-18 06:10:07 0
101118 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1377113 N 101141 mcps copyright control various artists 1639804208 Y 2021-12-18 06:10:08 0
101119 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1298486 N 101141 mcps copyright control various artists 1639804208 Y 2021-12-18 06:10:08 0
101120 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1299460 N 101141 mcps copyright control various artists 1639804208 Y 2021-12-18 06:10:08 0
101121 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1138277 N 101141 mcps copyright control various artists 1639804208 Y 2021-12-18 06:10:08 0
101122 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1148507 N 101141 mcps copyright control various artists 1639804208 Y 2021-12-18 06:10:08 0
101123 HDP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286340836 GBKQU1148563 N 101141 mcps copyright control various artists 1639804208 Y 2021-12-18 06:10:08 0