SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    111857, 111856, 111855, 111854, 111853, 
    111852, 111851, 111850, 111849, 111848, 
    111847, 111846, 111831, 111830, 111829, 
    111828, 111801, 111797, 111792, 111791
  )

Query time 0.00042

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
111791 ONESEVENTY148 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287001095 GBKQU2298984 N Songtrust Jack Newman 1673037473 Y 2022-11-16 07:00:02 0
111792 ONESEVENTY148 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287001095 GBKQU2298985 N Songtrust Jack Newman 1668578403 Y 2022-11-16 07:00:03 0
111797 FINRGH009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287030736 GBLV62203248 N Copyright Control Juho Pirhonen 1668578410 Y 2022-11-16 07:00:10 0
111801 CSD131 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054286971634 GBKQU2294295 N Copyright Control Carley Parker 1668579301 Y 2022-11-16 07:15:01 0
111828 247HC291 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287005925 UKT6B2200570 N Copyright Control Ryan Gallagher 1668579316 Y 2022-11-16 07:15:16 0
111829 247HC291 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287005925 UKT6B2200569 N Copyright Control Ryan Gallagher 1668579316 Y 2022-11-16 07:15:16 0
111830 247HC291 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287005925 UKT6B2200571 N Copyright Control Ryan Gallagher 1668579316 Y 2022-11-16 07:15:16 0
111831 247HC291 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287005925 UKT6B2200573 N Copyright Control Ryan Gallagher 1668579317 Y 2022-11-16 07:15:17 0
111846 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2100385 N 111862 Copyright Control Various Artists 1668662107 Y 2022-11-17 06:15:07 0
111847 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2200369 N 111862 Copyright Control Various Artists 1668662107 Y 2022-11-17 06:15:07 0
111848 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2100388 N 111862 Copyright Control Various Artists 1668662107 Y 2022-11-17 06:15:07 0
111849 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2200381 N 111862 Copyright Control Various Artists 1668662107 Y 2022-11-17 06:15:07 0
111850 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2200373 N 111862 Copyright Control Various Artists 1668662108 Y 2022-11-17 06:15:08 0
111851 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2100384 N 111862 Copyright Control Various Artists 1668662108 Y 2022-11-17 06:15:08 0
111852 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2200372 N 111862 Copyright Control Various Artists 1668662108 Y 2022-11-17 06:15:08 0
111853 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2200376 N 111862 Copyright Control Various Artists 1668662108 Y 2022-11-17 06:15:08 0
111854 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2100390 N 111862 Copyright Control Various Artists 1668662108 Y 2022-11-17 06:15:08 0
111855 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2100387 N 111862 Copyright Control Various Artists 1668662109 Y 2022-11-17 06:15:09 0
111856 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2100383 N 111862 Copyright Control Various Artists 1668662109 Y 2022-11-17 06:15:09 0
111857 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2200379 N 111862 Copyright Control Various Artists 1668662109 Y 2022-11-17 06:15:09 0