SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    104473, 104472, 104471, 104470, 104469, 
    104468, 104467, 104466, 104465, 104464, 
    102273, 102272, 102271, 102241, 105014, 
    104448, 102207, 105000, 104893, 104892
  )

Query time 0.00047

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
102207 MQDRHRD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646697600 0 Y N N B N R Y N N Y 10 1646697600 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 5054286439653 GBKQU2209603 N +QDance Records DJ Comare 1644123907 Y 2022-02-06 06:05:07 0
102241 DARKULLP004t02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286431466 GBKQU2208353 N Copyright Control Paula Vigara Vives, Itamar Medyoni 1644297002 Y 2022-02-08 06:10:02 0
102271 MOK251 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286473800 NLLB82200012 N Copyright Control Y.Suzuki 1644339902 Y 2022-02-08 18:05:02 0
102272 MOK251 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286473800 NLLB82200013 N Copyright Control Y.Suzuki 1644339902 Y 2022-02-08 18:05:02 0
102273 MOK251 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286473800 NLLB82200014 N Copyright Control Y.Suzuki 1644339902 Y 2022-02-08 18:05:02 0
104448 Ycore44 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646697600 0 Y N N B N R Y N N Y 10 1646697600 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 5054286493198 GBKQU2219030 N Copyright control Damon Deakin 1646987015 Y 2022-02-17 18:30:02 0
104464 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU2159071 N 104482 Copyright Control Various Artists 1645247108 Y 2022-02-19 06:05:08 0
104465 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU2145567 N 104482 Copyright Control Various Artists 1645247109 Y 2022-02-19 06:05:09 0
104466 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU2115511 N 104482 Copyright Control Various Artists 1645247110 Y 2022-02-19 06:05:10 0
104467 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU2017127 N 104482 Copyright Control Various Artists 1645247111 Y 2022-02-19 06:05:11 0
104468 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU1834429 N 104482 Copyright Control Various Artists 1645247111 Y 2022-02-19 06:05:11 0
104469 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU2187494 N 104482 Copyright Control Various Artists 1645247111 Y 2022-02-19 06:05:11 0
104470 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU1905626 N 104482 Copyright Control Various Artists 1645247112 Y 2022-02-19 06:05:12 0
104471 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU2050318 N 104482 Copyright Control Various Artists 1645247112 Y 2022-02-19 06:05:12 0
104472 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU1731506 N 104482 Copyright Control Various Artists 1645247112 Y 2022-02-19 06:05:12 0
104473 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU2097246 N 104482 Copyright Control Various Artists 1645247112 Y 2022-02-19 06:05:12 0
104892 R90983 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286521105 NLS202200038 N 2 Dex Publishing D. Del Olmo Pastor 1646241350 Y 2022-03-02 18:15:50 0
104893 R90983 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286521105 NLS202200039 N 2 Dex Publishing D. Del Olmo Pastor 1646241351 Y 2022-03-02 18:15:51 0
105000 JH333 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646611200 0 Y N N B N R Y N N Y 10 1646611200 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 5054286524199 GBKQU2224562 N Copyright Control Kacky 1646987001 Y 2022-03-05 06:05:01 0
105014 JH334 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646784000 0 Y N N B N R Y N N Y 10 1646784000 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 5054286524250 GBKQU2224568 N copyright control Smeets 1646987030 Y 2022-03-07 18:03:39 0