SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    101672, 101545, 101174, 101536, 101526, 
    101525, 101519, 101362, 100737, 100736, 
    92949, 101434, 101391, 101390, 101389, 
    101379, 101356, 101034, 100839, 100838
  )

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
92949 VCR350 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;} 4 N Toolbox Publishing Ben Stevens 1612125153 Y 2021-12-17 17:37:27 0
100736 OVD010X 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;} 4 N Copyright Control Andy Naylor 1641384021 Y 07/01/2022 06/02/2022 2021-12-17 17:37:27 0
100737 OVD010 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;} 4 N Copyright Control Andy Naylor 1641555043 Y 07/01/2022 06/02/2022 2021-12-17 17:37:27 0
100838 PMD047 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 1642118400 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;} 4 labelworx 5054286338543 GBLV62130789 N Pumped Joe Longbottom 1638984003 Y 2021-12-17 17:37:27 0
100839 PMD046 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 1642118400 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;} 4 labelworx 5054286338536 GBLV62130788 N Pumped Joe Longbottom 1638984004 Y 2021-12-17 17:37:27 0
101034 RR12 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;} 4 N copyright controll matt smith 1639598580 Y 2021-12-17 17:37:27 0
101174 BTN025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641772800 0 Y N N B N R Y N N Y 10 1641772800 1642982400 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;} 1 labelworx 5054286360599 GBLV62134881 N Bring the noise recordings Dan Carter 1640019901 Y 2021-12-20 18:05:01 0
101356 GAR027 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;} 4 N Copyright Control Paul Hunter 1642254319 Y 31/12/2021 30/01/2022 2021-12-27 21:36:48 0
101362 GARH010 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;} 4 N Copyright Control Tom Revans 1642255545 Y 07/01/2022 06/02/2022 2021-12-28 23:04:09 0
101379 FLY018 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;} 4 N Copyright Control Team Sly 1640773943 Y 0 0 2021-12-29 11:22:59 0
101389 EM012 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;} 4 N Emmanating Records Kieran Bradbury 1640900372 Y 0 0 2021-12-30 22:20:44 0
101390 FCP022 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;} 4 N Full Circle Productions Zillin Redeker 1640937859 Y 0 0 2021-12-30 22:39:18 0
101391 BDR028 P A 1 1.69 1 0.000 0 0 0 0.00 0 1640936048 0 Y N N B N R Y N N Y 10 1640908800 0 N 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;} 4 N Copyright Control Darren Williams 1643636027 Y 0 0 2021-12-31 08:34:08 0
101434 ESP085 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641220196 0 Y N N B N R Y N N Y 10 1641168000 0 N 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;} 4 N Energy Source Productions DJ Serenity 1641563742 Y 2022-01-03 15:29:56 0
101519 FCP023 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;} 4 N Full Circle Productions Graham Jenkins 1641505180 Y 0 0 2022-01-06 22:39:40 0
101525 BB040 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641539486 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;} 4 N Copyright Control Ben Miles 1641539723 Y 0 0 2022-01-07 08:11:26 0
101526 IA033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641548320 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;} 4 N Copyright Control Tara Nicholson 1641548718 Y 0 0 2022-01-07 10:38:40 0
101536 SFR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641681109 0 Y N N B N R Y N N Y 10 1641600000 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;} 4 N Shark Fin Records Dean Richardson 1641681921 Y 0 0 2022-01-08 23:31:49 0
101545 ESP086 P A 1 1.69 1 0.000 0 0 0 0.00 0 1641822391 0 Y N N B N R Y N N Y 10 1641772800 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;} 4 N Energy Source Productions DJ Serenity 1641823221 Y 0 0 2022-01-10 14:46:31 0
101672 MELT022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642115155 0 Y N N B N R Y N N Y 10 1642032000 0 N 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;} 4 GBLV62134071 N Copyright Control Andrew Cullen 1642115720 Y 2022-01-14 00:05:55 0