SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    85913, 85912, 85911, 86694, 85855, 85819, 
    85809, 86655, 86584, 86583, 86582, 
    85751, 85702, 85701, 85691, 86647, 
    85891, 85890, 85889, 85888
  )

Query time 0.00056

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
85691 FE294 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590706800 0 Y N N B N R Y N N Y 10 1590706800 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 5054285001202 GBKQU2034005 N Fatal Energy Records Samora Hughes 1588222802 Y 2021-12-17 17:37:27 0
85701 TR186 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590706800 0 Y N N B N R Y N N Y 10 1590706800 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 5054285036761 GBKQU2040276 N Copyright Control MCPS Casella (Scott Attrill) 1588222809 Y 2021-12-17 17:37:27 0
85702 PTR112 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590706800 0 Y N N B N R Y N N Y 10 1590706800 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 5054285022412 GBKQU2037942 N Power Tracks Records Power Tracks Records 1588222810 Y 2021-12-17 17:37:27 0
85751 Ev226 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590706800 0 Y N N B N R Y N N Y 10 1590706800 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 5054285066980 GBKQU2045697 N 23rd Precinct Music Ltd Darren Hotchkiss 1588654804 Y 2021-12-17 17:37:27 0
85809 CheekUDC7 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591311600 0 Y N N B N R Y N N Y 10 1591311600 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 5054284594392 GBKQU1597284 N 85822 Copyright Control Various Artists 1588827615 Y 2021-12-17 17:37:27 0
85819 CheekUDC7 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591311600 0 Y N N B N R Y N N Y 10 1591311600 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 5054284594392 GBKQU1417073 N 85822 Copyright Control Various Artists 1588827616 Y 2021-12-17 17:37:27 0
85855 IT040 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591311600 0 Y N N B N R Y N N Y 10 1591311600 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 5054285054147 GBKQU2043459 N Copyright Control David Rosenberg 1591811277 Y 2021-12-17 17:37:27 0
85888 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBLV61915929 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85889 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBLV61922482 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85890 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBLV61914644 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85891 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBLV61903602 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85911 HDB006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591570800 0 Y N N B N R Y N N Y 10 1591570800 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 5054285057629 GBKQU1138275 N 85923 copyright control mcps various artists 1591811276 Y 2021-12-17 17:37:27 0
85912 HDB006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591570800 0 Y N N B N R Y N N Y 10 1591570800 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 5054285057629 GBKQU1377113 N 85923 copyright control mcps various artists 1591811276 Y 2021-12-17 17:37:27 0
85913 HDB006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591570800 0 Y N N B N R Y N N Y 10 1591570800 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 5054285057629 GBKQU1234122 N 85923 copyright control mcps various artists 1591811276 Y 2021-12-17 17:37:27 0
86582 DNZF789 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591138800 0 Y N N B N R Y N N Y 10 1591138800 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 5054285114469 GBKQU2054280 N DNZ Records DJ Oskar, Jamie B 1591766702 Y 2021-12-17 17:37:27 0
86583 DNZF789 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591138800 0 Y N N B N R Y N N Y 10 1591138800 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 5054285114469 GBKQU2054281 N DNZ Records DJ Oskar, Jamie B 1591766716 Y 2021-12-17 17:37:27 0
86584 DNZF789 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591138800 0 Y N N B N R Y N N Y 10 1591138800 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 5054285114469 GBKQU2054282 N DNZ Records DJ Oskar, Jamie B 1591766733 Y 2021-12-17 17:37:27 0
86647 DNZF785 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590620400 0 Y N N B N R Y N N Y 10 1590620400 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 5054285102435 GBKQU2052013 N DNZ Records Schizoofr3nik, DJ Nillos 1591817559 Y 2021-12-17 17:37:27 0
86655 DNZF790 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591225200 0 Y N N B N R Y N N Y 10 1591225200 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 5054285125090 GBKQU2056093 N DNZ Records DJ Miho 1591817674 Y 2021-12-17 17:37:27 0
86694 PTR118 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591311600 0 Y N N B N R Y N N Y 10 1591311600 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 5054285118634 GBKQU2054988 N Power Tracks Records Power Tracks Records 1591822098 Y 2021-12-17 17:37:27 0