SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    79240, 79238, 79236, 79234, 79341, 79340, 
    83864, 79346, 83852, 79345, 78379, 
    78378, 78376, 78374, 78372, 79222, 
    78202, 79224, 79311, 79310
  )

Query time 0.00038

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
78202 GCJD10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1562886000 0 Y N N B N R Y N N Y 10 1562886000 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 5054284440613 GBKQU1956957 N Paul Rodriguez Music Chris C & Jon Doe 1560406884 Y 2021-12-17 17:37:27 0
78372 STMLP014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563145200 0 Y N N B N R Y N N Y 10 1563145200 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 5054284449425 GBY3G1400062 N 78382 Copyright Control Various Artists 1560661208 Y 2021-12-17 17:37:27 0
78374 STMLP014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563145200 0 Y N N B N R Y N N Y 10 1563145200 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 5054284449425 GBY3G1800270 N 78382 Copyright Control Various Artists 1560661208 Y 2021-12-17 17:37:27 0
78376 STMLP014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563145200 0 Y N N B N R Y N N Y 10 1563145200 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 5054284449425 GBY3G1500165 N 78382 Copyright Control Various Artists 1560661208 Y 2021-12-17 17:37:27 0
78378 STMLP014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563145200 0 Y N N B N R Y N N Y 10 1563145200 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 5054284449425 GBY3G1800259 N 78382 Copyright Control Various Artists 1560661209 Y 2021-12-17 17:37:27 0
78379 STMLP014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563145200 0 Y N N B N R Y N N Y 10 1563145200 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 5054284449425 GBY3G1900313 N 78382 Copyright Control Various Artists 1560661209 Y 2021-12-17 17:37:27 0
79222 DNZF567 P A 1 1.69 1 0.000 0 0 0 0.00 0 1562886000 0 Y N N B N R Y N N Y 10 1562886000 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 5054284492650 GBKQU1967126 N DNZ Records Sparkos, Deekay 1562302854 Y 2021-12-17 17:37:27 0
79224 DNZF566 P A 1 1.69 1 0.000 0 0 0 0.00 0 1562799600 0 Y N N B N R Y N N Y 10 1562799600 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 5054284492582 GBKQU1967114 N DNZ Records Garbie Project 1562302855 Y 2021-12-17 17:37:27 0
79234 LWHDB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563490800 0 Y N N B N R Y N N Y 10 1563490800 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 5054284498171 GBKQU1923147 N 79251 Copyright Control Various Artists 1562302860 Y 2021-12-17 17:37:27 0
79236 LWHDB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563490800 0 Y N N B N R Y N N Y 10 1563490800 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 5054284498171 GBKQU1928576 N 79251 Copyright Control Various Artists 1562302860 Y 2021-12-17 17:37:27 0
79238 LWHDB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563490800 0 Y N N B N R Y N N Y 10 1563490800 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 5054284498171 GBKQU1917348 N 79251 Copyright Control Various Artists 1562302861 Y 2021-12-17 17:37:27 0
79240 LWHDB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563490800 0 Y N N B N R Y N N Y 10 1563490800 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 5054284498171 AU8N01100113 N 79251 Copyright Control Various Artists 1562302862 Y 2021-12-17 17:37:27 0
79310 DNZF565 P A 1 1.69 1 0.000 0 0 0 0.00 0 1562713200 0 Y N N B N R Y N N Y 10 1562713200 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 5054284492568 GBKQU1967112 N DNZ Records V-Star 1562302913 Y 2021-12-17 17:37:27 0
79311 DNZF565 P A 1 1.69 1 0.000 0 0 0 0.00 0 1562713200 0 Y N N B N R Y N N Y 10 1562713200 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 5054284492568 GBKQU1967113 N DNZ Records V-Star 1562302913 Y 2021-12-17 17:37:27 0
79340 DNZF573 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563404400 0 Y N N B N R Y N N Y 10 1563404400 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 5054284501147 GBKQU1968683 N DNZ Records Garbie Project 1562648401 Y 2021-12-17 17:37:27 0
79341 DNZF573 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563404400 0 Y N N B N R Y N N Y 10 1563404400 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 5054284501147 GBKQU1968684 N DNZ Records Garbie Project 1562648401 Y 2021-12-17 17:37:27 0
79345 DNZF568 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563145200 0 Y N N B N R Y N N Y 10 1563145200 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 5054284501130 GBKQU1968682 N DNZ Records Que & Rkay 1562648402 Y 2021-12-17 17:37:27 0
79346 DNZ364 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563318000 0 Y N N B N R Y N N Y 10 1563318000 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 5054284501123 GBKQU1968681 N DNZ Records Paul Norval, DJ Oskar 1562648403 Y 2021-12-17 17:37:27 0
83852 IDR056 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563231600 0 Y N N B N R Y N N Y 10 1563231600 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 5054284455600 GBKQU1959796 N innervate records LEZAMAboy 1581830342 Y 2021-12-17 17:37:27 0
83864 IDR057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563318000 0 Y N N B N R Y N N Y 10 1563318000 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 5054284455624 GBKQU1959798 N Innervate Digital Tone-E & Alvin Van Blur 1581830571 Y 2021-12-17 17:37:27 0