SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    73848, 74094, 74005, 77087, 77086, 73725, 
    73724, 73721, 73720, 73719, 73718, 
    73711, 73701, 74034, 73891, 73926, 
    74241, 73661, 73660, 73781
  )

Query time 0.00057

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
73660 EF011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 5054284131160 GBLV61817211 N Copyright Control Yasuhiro Suzuki, James Kitcher, Will Mayger 1546750810 Y 2021-12-17 17:37:27 0
73661 XTRA135 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 5054284136226 GBLV61818289 N Xtrahard Records Baz Coleman 1546750810 Y 2021-12-17 17:37:27 0
73701 RIOT175 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 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 5054283981421 GBLV61807706 N Copyright Control MCPS Scott Attrill 1629450604 Y 2021-12-17 17:37:27 0
73711 FE177 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 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 5054284149479 GBLV61820977 N Fatal Energy Records David Swan, Jason Osborne, Richard Ackers. 1547096418 Y 2021-12-17 17:37:27 0
73718 CheekA41 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 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 5054283838787 GBKQU1360874 N 73733 Copyright Control Various Artists 1547096428 Y 2021-12-17 17:37:27 0
73719 CheekA41 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 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 5054283838787 GBKQU1209199 N 73733 Copyright Control Various Artists 1547096428 Y 2021-12-17 17:37:27 0
73720 CheekA41 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 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 5054283838787 GBKQU1510868 N 73733 Copyright Control Various Artists 1547096428 Y 2021-12-17 17:37:27 0
73721 CheekA41 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 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 5054283838787 GBLV61640276 N 73733 Copyright Control Various Artists 1547096428 Y 2021-12-17 17:37:27 0
73724 CheekA41 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 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 5054283838787 GBKQU1397454 N 73733 Copyright Control Various Artists 1547096430 Y 2021-12-17 17:37:27 0
73725 CheekA41 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 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 5054283838787 GBKQU1824364 N 73733 Copyright Control Various Artists 1547096430 Y 2021-12-17 17:37:27 0
73781 DNZF442 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548979200 0 Y N N B N R Y N N Y 10 1548979200 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 5054284179247 GBKQU1904464 N DNZ Records Bounce Enforcerz 1547701202 Y 2021-12-17 17:37:27 0
73848 Cheek409 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550188800 0 Y N N B N R Y N N Y 10 1550188800 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 5054284129136 GBKQU1881829 N Copyright Control John Carr, Glen Walker 1547960402 Y 2021-12-17 17:37:27 0
73891 DNZF445 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549497600 0 Y N N B N R Y N N Y 10 1549497600 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 5054284189116 GBKQU1906417 N DNZ Records DJ Suko 1548219604 Y 2021-12-17 17:37:27 0
73926 DNZ339 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549411200 0 Y N N B N R Y N N Y 10 1549411200 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 5054284194424 GBKQU1907621 N DNZ Records Jose Mata, DJ Pipol, A-Gustin 1548478802 Y 2021-12-17 17:37:27 0
74005 PTR085 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550102400 0 Y N N B N R Y N N Y 10 1550102400 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 5054284203980 GBKQU1909550 N Power Tracks Records Power Tracks Records 1548910804 Y 2021-12-17 17:37:27 0
74034 PTR083 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549497600 0 Y N N B N R Y N N Y 10 1549497600 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 5054284192345 GBKQU1907080 N Power Tracks Records Power Tracks Records 1548910829 Y 2021-12-17 17:37:27 0
74094 CATID041 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550102400 0 Y N N B N R Y N N Y 10 1550102400 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 5054284196008 NLN6L1900001 N The Funky Cat Publishing H.C. van Dam 1629450606 Y 2021-12-17 17:37:27 0
74241 DNZF444 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549324800 0 Y N N B N R Y N N Y 10 1549324800 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 5054284189093 GBKQU1906414 N DNZ Records Jamie B 1549516649 Y 2021-12-17 17:37:27 0
77086 bG053 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 5054284428246 GBKQU1954283 N bG 53 Dj Noke - Another Life 1559193686 Y 2021-12-17 17:37:27 0
77087 bG053 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 5054284428246 GBKQU1954284 N bG 53 Dj Noke - Another Life 1559193702 Y 2021-12-17 17:37:27 0