SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    79485, 79484, 79483, 79482, 79481, 79480, 
    79479, 79473, 79472, 79475, 79474, 
    78864, 79371, 79362, 78850, 78630, 
    79249, 79248, 79247, 79243
  )

Query time 0.00045

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
78630 IT027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563750000 0 Y N N B N R Y N N Y 10 1563750000 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 5054284472492 GBKQU1963237 N Copyright Control David Rosenberg 1561266027 Y 2021-12-17 17:37:27 0
78850 FE231 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563750000 0 Y N N B N R Y N N Y 10 1563750000 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 5054284435329 GBKQU1955950 N Fatal Energy Records David Swan, Roland Kovacs, Usachev Kirill 1561266112 Y 2021-12-17 17:37:27 0
78864 FE232 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563922800 0 Y N N B N R Y N N Y 10 1563922800 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 5054284435336 GBKQU1955952 N Fatal Energy Records Emil Runnesdotter 1561438803 Y 2021-12-17 17:37:27 0
79243 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 GBKQU1923010 N 79251 Copyright Control Various Artists 1562302862 Y 2021-12-17 17:37:27 0
79247 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 GBKQU1909623 N 79251 Copyright Control Various Artists 1562302862 Y 2021-12-17 17:37:27 0
79248 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 GBKQU1911295 N 79251 Copyright Control Various Artists 1562302863 Y 2021-12-17 17:37:27 0
79249 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 GBKQU1916081 N 79251 Copyright Control Various Artists 1562302863 Y 2021-12-17 17:37:27 0
79362 DNZF575 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563750000 0 Y N N B N R Y N N Y 10 1563750000 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 5054284506906 GBKQU1969784 N DNZ Records Garbie Project 1562821202 Y 2021-12-17 17:37:27 0
79371 DNZF578 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563836400 0 Y N N B N R Y N N Y 10 1563836400 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 5054284506982 GBKQU1969792 N DNZ Records T-Jay 1562821205 Y 2021-12-17 17:37:27 0
79472 DNZ365 P A 1 1.69 1 0.000 0 0 0 0.00 0 1564095600 0 Y N N B N R Y N N Y 10 1564095600 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 5054284514550 GBKQU1971422 N DNZ Records Jamie B, DJ Oskar 1563339603 Y 2021-12-17 17:37:27 0
79473 DNZ365 P A 1 1.69 1 0.000 0 0 0 0.00 0 1564095600 0 Y N N B N R Y N N Y 10 1564095600 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 5054284514550 GBKQU1971424 N DNZ Records Jamie B, DJ Oskar 1563339603 Y 2021-12-17 17:37:27 0
79474 DNZF580 P A 1 1.69 1 0.000 0 0 0 0.00 0 1563922800 0 Y N N B N R Y N N Y 10 1563922800 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 5054284514505 GBKQU1971401 N DNZ Records Jamie B, Nova Scotia 1563339603 Y 2021-12-17 17:37:27 0
79475 DNZF581 P A 1 1.69 1 0.000 0 0 0 0.00 0 1564009200 0 Y N N B N R Y N N Y 10 1564009200 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 5054284514512 GBKQU1971403 N DNZ Records Jamie B 1563339604 Y 2021-12-17 17:37:27 0
79479 LWIBIZA201904 P A 1 1.69 1 0.000 0 0 0 0.00 0 1564095600 0 Y N N B N R Y N N Y 10 1564095600 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 5054284520001 GBKQU1895871 N 79504 Copyright Control Various Artists 1563426003 Y 2021-12-17 17:37:27 0
79480 LWIBIZA201904 P A 1 1.69 1 0.000 0 0 0 0.00 0 1564095600 0 Y N N B N R Y N N Y 10 1564095600 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 5054284520001 GBKQU1923437 N 79504 Copyright Control Various Artists 1563426004 Y 2021-12-17 17:37:27 0
79481 LWIBIZA201904 P A 1 1.69 1 0.000 0 0 0 0.00 0 1564095600 0 Y N N B N R Y N N Y 10 1564095600 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 5054284520001 GBKQU1926822 N 79504 Copyright Control Various Artists 1563426004 Y 2021-12-17 17:37:27 0
79482 LWIBIZA201904 P A 1 1.69 1 0.000 0 0 0 0.00 0 1564095600 0 Y N N B N R Y N N Y 10 1564095600 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 5054284520001 GBKQU1931296 N 79504 Copyright Control Various Artists 1563426004 Y 2021-12-17 17:37:27 0
79483 LWIBIZA201904 P A 1 1.69 1 0.000 0 0 0 0.00 0 1564095600 0 Y N N B N R Y N N Y 10 1564095600 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 5054284520001 GBKQU1914485 N 79504 Copyright Control Various Artists 1563426004 Y 2021-12-17 17:37:27 0
79484 LWIBIZA201904 P A 1 1.69 1 0.000 0 0 0 0.00 0 1564095600 0 Y N N B N R Y N N Y 10 1564095600 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 5054284520001 GBLV61812588 N 79504 Copyright Control Various Artists 1563426004 Y 2021-12-17 17:37:27 0
79485 LWIBIZA201904 P A 1 1.69 1 0.000 0 0 0 0.00 0 1564095600 0 Y N N B N R Y N N Y 10 1564095600 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 5054284520001 GBKQU1926968 N 79504 Copyright Control Various Artists 1563426004 Y 2021-12-17 17:37:27 0