SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    94130, 94129, 92909, 94092, 94091, 94090, 
    94089, 94048, 93759, 93510, 93264, 
    93263, 93262, 93261, 93260, 93259, 
    93258, 89226, 93946, 93940
  )

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
89226 RRR015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615334400 0 Y N N B N R Y N N Y 10 1615334400 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;} 4 N Hatfish Music / Copyright Control Gary Cooke, Dave Owens 1642007349 Y 10/03/2021 09/04/2021 2021-12-17 17:37:27 0
92909 VCR307 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615593600 0 Y N N B N R Y N N Y 10 1615507200 0 N 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;} 4 N Copyright Control Jody Lock 1615534836 Y 2021-12-17 17:37:27 0
93258 Cheek515 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 1616716800 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;} 4 labelworx 5054285523391 GBLV62029815 N Copyright Control Daniel Gibson 1612976727 Y 2021-12-17 17:37:27 0
93259 Cheek515 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 1616716800 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;} 4 labelworx 5054285523391 GBLV62029816 N Copyright Control Daniel Gibson 1612976728 Y 2021-12-17 17:37:27 0
93260 Cheek515 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 1616716800 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;} 4 labelworx 5054285523391 GBLV62004114 N Copyright Control Daniel Gibson 1612976729 Y 2021-12-17 17:37:27 0
93261 Cheek515 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 1616716800 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;} 4 labelworx 5054285523391 GBLV62029817 N Copyright Control Daniel Gibson 1612976729 Y 2021-12-17 17:37:27 0
93262 Cheek515 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 1616716800 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;} 4 labelworx 5054285523391 GBLV62029818 N Copyright Control Daniel Gibson 1612976729 Y 2021-12-17 17:37:27 0
93263 Cheek515 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 1616716800 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;} 4 labelworx 5054285523391 GBLV62029819 N Copyright Control Daniel Gibson 1612976730 Y 2021-12-17 17:37:27 0
93264 HOT082 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 1616716800 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;} 4 labelworx 5054285678404 GBKQU2115283 N Hot Box Digital StuartM 1612976731 Y 2021-12-17 17:37:27 0
93510 FD043 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 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;} 3 N Copyright Control Phil Wale 1613902819 Y 2021-12-17 17:37:27 0
93759 TGR075 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 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;} 4 N Copyright control Anton Chui-Foon 1614419610 Y 2021-12-17 17:37:27 0
93940 GAR005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615060323 0 Y N N B N R Y N N Y 10 1614988800 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;} 4 N Copyright Control Andrew Holmes/Adam Bennett 1642247991 Y 06/03/2021 05/04/2021 2021-12-17 17:37:27 0
93946 HF031 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615189500 0 Y N N B N R Y N N Y 10 1615161600 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;} 4 N Toolbox Digital Jason Briley 1615189660 Y 2021-12-17 17:37:27 0
94048 VR004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 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;} 4 N Copyright Control Ross Farley/Matt Clarkson/Slenderman 1615353822 Y 2021-12-17 17:37:27 0
94089 ON056 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 0 N 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;} 4 N Orrible Noize Recordings Rob Yellowley 1615484694 Y 2021-12-17 17:37:27 0
94090 FR124 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 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;} 4 N Copyright Control Scott Chaney 1615500305 Y 2021-12-17 17:37:27 0
94091 BDR002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615537456 0 Y N N B N R Y N N Y 10 1615507200 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;} 4 N Copyright Control Dave Grabowski 1643556168 Y 12/03/2021 11/04/2021 2021-12-17 17:37:27 0
94092 ESP067 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615566036 0 Y N N B N R Y N N Y 10 1615507200 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;} 4 N Energy Source Productions DJ Serenity 1615566620 Y 2021-12-17 17:37:27 0
94129 PDR034 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615648068 0 Y N N B N R Y N N Y 10 1615593600 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;} 4 N Toolbox Publishing, Copyright Control pat glenny/ben vennard 1642264772 Y 13/03/2021 12/04/2021 2021-12-17 17:37:27 0
94130 PDR034 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615648186 0 Y N N B N R Y N N Y 10 1615593600 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;} 4 N copyright control pat glenny/ben vennard/Team Sly 1615651243 Y 2021-12-17 17:37:27 0