SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    100877, 100811, 100810, 100822, 100764, 
    100785, 100784, 100731, 100730, 100729, 
    100703, 100663, 100662, 100661, 100659, 
    100658, 100657, 100656, 100655, 100654
  )

Query time 0.00059

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
100654 STMLP019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640736000 0 Y N N B N R Y N N Y 10 1640736000 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 5054286304630 GBY3G2100367 N 100664 Copyright Control Various Artists 1638162305 Y 2021-12-17 17:37:27 0
100655 STMLP019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640736000 0 Y N N B N R Y N N Y 10 1640736000 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 5054286304630 GBY3G2100361 N 100664 Copyright Control Various Artists 1638162306 Y 2021-12-17 17:37:27 0
100656 STMLP019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640736000 0 Y N N B N R Y N N Y 10 1640736000 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 5054286304630 GBY3G2100363 N 100664 Copyright Control Various Artists 1638162306 Y 2021-12-17 17:37:27 0
100657 STMLP019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640736000 0 Y N N B N R Y N N Y 10 1640736000 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 5054286304630 GBY3G2100359 N 100664 Copyright Control Various Artists 1638162308 Y 2021-12-17 17:37:27 0
100658 STMLP019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640736000 0 Y N N B N R Y N N Y 10 1640736000 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 5054286304630 GBY3G2100364 N 100664 Copyright Control Various Artists 1638162308 Y 2021-12-17 17:37:27 0
100659 STMLP019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640736000 0 Y N N B N R Y N N Y 10 1640736000 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 5054286304630 GBY3G2100362 N 100664 Copyright Control Various Artists 1638162309 Y 2021-12-17 17:37:27 0
100661 STMLP019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640736000 0 Y N N B N R Y N N Y 10 1640736000 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 5054286304630 GBY3G2100365 N 100664 Copyright Control Various Artists 1638162309 Y 2021-12-17 17:37:27 0
100662 STMLP019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640736000 0 Y N N B N R Y N N Y 10 1640736000 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 5054286304630 GBY3G2100368 N 100664 Copyright Control Various Artists 1638162309 Y 2021-12-17 17:37:27 0
100663 STMLP019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640736000 0 Y N N B N R Y N N Y 10 1640736000 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 5054286304630 GBY3G2100358 N 100664 Copyright Control Various Artists 1638162310 Y 2021-12-17 17:37:27 0
100703 STI287 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640822400 0 Y N N B N R Y N N Y 10 1640822400 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 5054286315292 GBLV62126154 N Copyright Control A. Brogden 1638249002 Y 2021-12-17 17:37:27 0
100729 ONESEVENT120 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640908800 0 Y N N B N R Y N N Y 10 1640908800 0 B 0 0 0 0 6 N 0 P F default 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 5054286321637 GBLV62127349 N Copyright Control Michael O'Brien 1641543254 Y 2021-12-17 17:37:27 0
100730 ONESEVENT120 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640908800 0 Y N N B N R Y N N Y 10 1640908800 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 5054286321637 GBLV62127350 N Copyright Control Michael O'Brien 1638335402 Y 2021-12-17 17:37:27 0
100731 KTRAR053 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640908800 0 Y N N B N R Y N N Y 10 1640908800 0 B 0 0 0 0 6 N 0 P F default 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 5054286298984 GBLV62123288 N Copyright Control Activist 1642164040 Y 2021-12-17 17:37:27 0
100764 WAOD072 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641340800 0 Y N N B N R Y N N Y 10 1641340800 0 B 0 0 0 0 6 N 0 P F default 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 5054286327448 GBLV62128382 N Copyright Control R.Scott 1641542847 Y 2021-12-17 17:37:27 0
100784 OD041 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641168000 0 Y N N B N R Y N N Y 10 1641168000 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;} UKGEQ2200150 N Copyright Control Arain 1638719394 Y 2021-12-17 17:37:27 0
100785 OD041 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641168000 0 Y N N B N R Y N N Y 10 1641168000 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;} UKGEQ2200151 N Copyright Control Arain 1638719435 Y 2021-12-17 17:37:27 0
100810 ONESEVENTY121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641513600 0 Y N N B N R Y N N Y 10 1641513600 0 B 0 0 0 0 6 N 0 P F default 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 5054286337478 GBLV62130577 N All Media Music, BMI, Bucks Music Group Jorg Gradwohl, Frank Banks, Alfie Bamford 1641543269 Y 2021-12-17 17:37:27 0
100811 ONESEVENTY121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641513600 0 Y N N B N R Y N N Y 10 1641513600 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 5054286337478 GBLV62130578 N All Media Music, BMI, Bucks Music Group Jorg Gradwohl, Frank Banks, Alfie Bamford 1638939903 Y 2021-12-17 17:37:27 0
100822 MOK246 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641427200 0 Y N N B N R Y N N Y 10 1641427200 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 5054286335160 NLLB82200001 N Copyright Control Sosa Justin 1638983404 Y 2021-12-17 17:37:27 0
100877 TICTOC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641513600 0 Y N N B N R Y N N Y 10 1641513600 0 B 0 0 0 0 6 N 0 P F default 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 5054286340263 GBLV62131131 N T. Reynolds T. Reynolds 1642164157 Y 2021-12-17 17:37:27 0