SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    88313, 88312, 88311, 88310, 88261, 88260, 
    88259, 89141, 88890, 88747, 88679, 
    88678, 88336, 88392, 88206, 88205, 
    88204, 88203, 88202, 88201
  )

Query time 0.00073

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
88201 HTH001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1599433200 0 Y N N B N R Y N N Y 10 1599433200 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 5054285248393 GBKQU1340006 N 88207 Copyright Control various artists 1596982676 Y 2021-12-17 17:37:27 0
88202 HTH001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1599433200 0 Y N N B N R Y N N Y 10 1599433200 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 5054285248393 GBKQU1148570 N 88207 Copyright Control various artists 1596982676 Y 2021-12-17 17:37:27 0
88203 HTH001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1599433200 0 Y N N B N R Y N N Y 10 1599433200 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 5054285248393 GBKQU2055682 N 88207 Copyright Control various artists 1596982676 Y 2021-12-17 17:37:27 0
88204 HTH001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1599433200 0 Y N N B N R Y N N Y 10 1599433200 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 5054285248393 GBKQU1340015 N 88207 Copyright Control various artists 1596982676 Y 2021-12-17 17:37:27 0
88205 HTH001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1599433200 0 Y N N B N R Y N N Y 10 1599433200 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 5054285248393 GBKQU1911335 N 88207 Copyright Control various artists 1596982677 Y 2021-12-17 17:37:27 0
88206 HTH001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1599433200 0 Y N N B N R Y N N Y 10 1599433200 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 5054285248393 GBKQU1149879 N 88207 Copyright Control various artists 1596982677 Y 2021-12-17 17:37:27 0
88259 Cheek495 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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 5054285147498 GBKQU2048417 N Copyright Control Dennis Van Der Driesschen, Wessel Van Diepen, Jonny Coffer, Shahid Khan, Arrow Benjamin, Carla Williams 1597820402 Y 2021-12-17 17:37:27 0
88260 Cheek495 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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 5054285147498 GBKQU2060444 N Copyright Control Dennis Van Der Driesschen, Wessel Van Diepen, Jonny Coffer, Shahid Khan, Arrow Benjamin, Carla Williams 1597820402 Y 2021-12-17 17:37:27 0
88261 Cheek495 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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 5054285147498 GBKQU2060446 N Copyright Control Dennis Van Der Driesschen, Wessel Van Diepen, Jonny Coffer, Shahid Khan, Arrow Benjamin, Carla Williams 1597820402 Y 2021-12-17 17:37:27 0
88310 Collect005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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 5054285312995 GBKQU2090518 N Zero Range Zero Range 1598292003 Y 2021-12-17 17:37:27 0
88311 Collect005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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 5054285312995 GBKQU2090519 N Zero Range Zero Range 1598292003 Y 2021-12-17 17:37:27 0
88312 Collect005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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 5054285312995 GBKQU2090520 N Zero Range Zero Range 1598292003 Y 2021-12-17 17:37:27 0
88313 Collect005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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 5054285312995 GBKQU2090521 N Zero Range Zero Range 1598292003 Y 2021-12-17 17:37:27 0
88336 DNZF853 P A 1 1.69 1 0.000 0 0 0 0.00 0 1599519600 0 Y N N B N R Y N N Y 10 1599519600 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 5054285323069 GBKQU2092653 N DNZ Records Nova Scotia 1598551202 Y 2021-12-17 17:37:27 0
88392 DNZF852 P A 1 1.69 1 0.000 0 0 0 0.00 0 1599433200 0 Y N N B N R Y N N Y 10 1599433200 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 5054285322932 GBKQU2092639 N DNZ Records Garbie Project 1598892451 Y 2021-12-17 17:37:27 0
88678 DNZ414 P A 1 1.69 1 0.000 0 0 0 0.00 0 1599606000 0 Y N N B N R Y N N Y 10 1599606000 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 5054285330135 GBKQU2094179 N DNZ Records Jamie B 1598980202 Y 2021-12-17 17:37:27 0
88679 DNZF854 P A 1 1.69 1 0.000 0 0 0 0.00 0 1599692400 0 Y N N B N R Y N N Y 10 1599692400 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 5054285330166 GBKQU2094182 N DNZ Records T-Jay 1598980203 Y 2021-12-17 17:37:27 0
88747 PTR131 P A 1 1.69 1 0.000 0 0 0 0.00 0 1599778800 0 Y N N B N R Y N N Y 10 1599778800 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 5054285331385 GBKQU2094424 N DJ Ruiz & DJ Kano DJ Ruiz & DJ Kano 1599066303 Y 2021-12-17 17:37:27 0
88890 DNZF858 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600124400 0 Y N N B N R Y N N Y 10 1600124400 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 5054285337172 GBKQU2095707 N DNZ Records Basic Beatz 1599239401 Y 2021-12-17 17:37:27 0
89141 awe5554 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600210800 0 Y N N B N R Y N N Y 10 1600210800 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 5054285358405 GBLV62000146 N EDM Starlight Joe N 1600189814 Y 2021-12-17 17:37:27 0