SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    90895, 90615, 90614, 90624, 90536, 90162, 
    89928, 89927, 89922, 89694, 89689, 
    89688, 89687, 89686, 89680, 89590, 
    89589, 90080, 90079, 90077
  )

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
89589 247HC203 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604534400 0 Y N N B N R Y N N Y 10 1604534400 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 5054285401798 UKT6B2000067 N Peermusic / copyright control A.Taylor, D.Heavey, R.Cox 1602003905 Y 2021-12-17 17:37:27 0
89590 247HC203 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604534400 0 Y N N B N R Y N N Y 10 1604534400 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 5054285401798 UKT6B2000068 N Peermusic / copyright control A.Taylor, D.Heavey, R.Cox 1602003905 Y 2021-12-17 17:37:27 0
89680 LTB06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285394656 GBLV62006868 N Copyright Control Matt Dawson & Vaughan Murphy 1602047218 Y 2021-12-17 17:37:27 0
89686 Cheek488B P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285297537 GBKQU2087547 N BMG Music Publishing Vincent De Giorgio, Chris Sheppard, Brad Daymond 1602047402 Y 2021-12-17 17:37:27 0
89687 Cheek488B P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285297537 GBKQU2087548 N BMG Music Publishing Vincent De Giorgio, Chris Sheppard, Brad Daymond 1602047402 Y 2021-12-17 17:37:27 0
89688 Cheek488B P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285297537 GBKQU2087551 N BMG Music Publishing Vincent De Giorgio, Chris Sheppard, Brad Daymond 1602047403 Y 2021-12-17 17:37:27 0
89689 Cheek488B P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285297537 GBKQU2087552 N BMG Music Publishing Vincent De Giorgio, Chris Sheppard, Brad Daymond 1602047403 Y 2021-12-17 17:37:27 0
89694 PMD033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 1605830400 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 5054285378786 GBLV62004040 N Pumped Gavin Eggar Joe Longbottom 1602047705 Y 2021-12-17 17:37:27 0
89922 ST018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1605225600 0 Y N N B N R Y N N Y 10 1605225600 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 5054285391402 GBLV62006342 N copyright control Jon Hemming 1616758073 Y 2021-12-17 17:37:27 0
89927 CHUBBY031 P A 1 1.69 1 0.000 0 0 0 0.00 0 1605225600 0 Y N N B N R Y N N Y 10 1605225600 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 5054285424735 GBLV62012054 N Bradley Milburn Bradley Milburn 1602782101 Y 2021-12-17 17:37:27 0
89928 CHUBBY031 P A 1 1.69 1 0.000 0 0 0 0.00 0 1605225600 0 Y N N B N R Y N N Y 10 1605225600 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 5054285424735 GBLV62012056 N Bradley Milburn Bradley Milburn 1602782102 Y 2021-12-17 17:37:27 0
90077 DNZ419 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285432044 GBLV62013367 N DNZ Records DJ Oskar, Sergio Caubal 1603129504 Y 2021-12-17 17:37:27 0
90079 DNZ419 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285432044 GBLV62013370 N DNZ Records DJ Oskar, Sergio Caubal 1603129504 Y 2021-12-17 17:37:27 0
90080 DNZ419 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285432044 GBLV62013371 N DNZ Records DJ Oskar, Sergio Caubal 1603129504 Y 2021-12-17 17:37:27 0
90162 BTIDMUSIC054 P A 1 1.69 1 0.000 0 0 0 0.00 0 1605225600 0 Y N N B N R Y N N Y 10 1605225600 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 5054285444238 GBLV62015518 N Copyright Control Walker 1603731902 Y 2021-12-17 17:37:27 0
90536 CR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1605225600 0 Y N N B N R Y N N Y 10 1605225600 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 5054285459102 GBLV62017758 N Copyright Control David Jackson, Jack Butler, Jamie Ainsworth 1616758076 Y 2021-12-17 17:37:27 0
90614 DNZF900 P A 1 1.69 1 0.000 0 0 0 0.00 0 1605657600 0 Y N N B N R Y N N Y 10 1605657600 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 5054285475119 GBLV62020995 N DNZ Records DJ Oskar, Sergio Caubal 1604941502 Y 2021-12-17 17:37:27 0
90615 DNZF900 P A 1 1.69 1 0.000 0 0 0 0.00 0 1605657600 0 Y N N B N R Y N N Y 10 1605657600 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 5054285475119 GBLV62020996 N DNZ Records DJ Oskar, Sergio Caubal 1604941503 Y 2021-12-17 17:37:27 0
90624 DNZF898 P A 1 1.69 1 0.000 0 0 0 0.00 0 1605484800 0 Y N N B N R Y N N Y 10 1605484800 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 5054285475102 GBLV62020994 N DNZ Records Klubb Efekt 1604941508 Y 2021-12-17 17:37:27 0
90895 NLR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1605697769 0 Y N N B N R Y N N Y 10 1605657600 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;} N copright control / Tom Ellard Engineered by Jason Nawty / Mixed by Snooky / Mastered by Jon Doe 1616758078 Y 2021-12-17 17:37:27 0