SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    105602, 105601, 106552, 106551, 105974, 
    105973, 105972, 105971, 105595, 105543, 
    106354, 106322, 106192, 106191, 106190, 
    106189, 106188, 106187, 105542, 105505
  )

Query time 0.00045

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
105505 STDIGI054 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649545200 0 Y N N B N R Y N N Y 10 1649545200 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 5054286521884 GBKQU2224074 N Smiley Tunes Digital M. Zhuchkov 1646975701 Y 2022-03-11 06:15:01 0
105542 GSP093 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649631600 0 Y N N B N R Y N N Y 10 1649631600 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 5054286544517 GBKQU2228045 N copyright control GavGStyle 1647279018 Y 2022-03-14 18:30:18 0
105543 NTWO011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649804400 0 Y N N B N R Y N N Y 10 1649804400 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 5054286543343 GBKQU2227825 N Tidy Publishing Scott Attrill 1650637942 Y 2022-03-14 18:30:20 0
105595 DARKULLP004t11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649890800 0 Y N N B N R Y N N Y 10 1649890800 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 5054286432098 GBKQU2208433 N Copyright Control Paula Vigara Vives, Jordi Gran 1647322214 Y 2022-03-15 06:30:14 0
105601 Hells061 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649977200 0 Y N N B N R Y N N Y 10 1649977200 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 5054286503026 GBKQU2220760 N Copyright Control M. Molema 1647407702 Y 2022-03-16 06:15:02 0
105602 Hells061 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649977200 0 Y N N B N R Y N N Y 10 1649977200 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 5054286503026 GBKQU2220761 N Copyright Control M. Molema 1647407702 Y 2022-03-16 06:15:02 0
105971 MOK253 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649890800 0 Y N N B N R Y N N Y 10 1649890800 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 5054286565710 NLLB82200021 N Copyright Control Michael McCrum 1647975604 Y 2022-03-22 20:00:04 0
105972 MOK253 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649890800 0 Y N N B N R Y N N Y 10 1649890800 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 5054286565710 NLLB82200022 N Copyright Control Michael McCrum 1647975605 Y 2022-03-22 20:00:05 0
105973 MOK253 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649890800 0 Y N N B N R Y N N Y 10 1649890800 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 5054286565710 NLLB82200023 N Copyright Control Michael McCrum 1647975605 Y 2022-03-22 20:00:05 0
105974 MOK253 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649890800 0 Y N N B N R Y N N Y 10 1649890800 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 5054286565710 NLLB82200024 N Copyright Control Michael McCrum 1647975605 Y 2022-03-22 20:00:05 0
106187 DARKUG006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649718000 0 Y N N B N R Y N N Y 10 1649718000 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 5054286489009 GBKQU2218199 N Copyright Control S. Van Der Krans 1648752301 Y 2022-03-31 19:45:01 0
106188 DARKUG006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649718000 0 Y N N B N R Y N N Y 10 1649718000 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 5054286489009 GBKQU2218200 N Copyright Control S. Van Der Krans 1648752305 Y 2022-03-31 19:45:05 0
106189 DARKUG006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649718000 0 Y N N B N R Y N N Y 10 1649718000 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 5054286489009 GBKQU2218201 N Copyright Control S. Van Der Krans 1648752305 Y 2022-03-31 19:45:05 0
106190 DARKUG006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649718000 0 Y N N B N R Y N N Y 10 1649718000 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 5054286489009 GBKQU2218202 N Copyright Control S. Van Der Krans 1648752306 Y 2022-03-31 19:45:06 0
106191 DARKUG006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649718000 0 Y N N B N R Y N N Y 10 1649718000 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 5054286489009 GBKQU2218203 N Copyright Control S. Van Der Krans 1648752306 Y 2022-03-31 19:45:06 0
106192 DARKUG006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649718000 0 Y N N B N R Y N N Y 10 1649718000 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 5054286489009 GBKQU2218204 N Copyright Control S. Van Der Krans 1648752306 Y 2022-03-31 19:45:06 0
106322 MMT023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649718000 0 Y N N B N R Y N N Y 10 1649718000 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 5054286606307 GBKQU2237867 N Max Mayorov Max Mayorov 1649700006 Y 2022-04-11 19:00:06 0
106354 MMT023A P A 1 1.69 1 0.000 0 0 0 0.00 0 1649718000 0 Y N N B N R Y N N Y 10 1649718000 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 5054286606338 GBKQU2237873 N Max Mayorov Max Mayorov 1649700017 Y 2022-04-11 19:00:17 0
106551 KARNAGEDIGITA26 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649890800 0 Y N N B N R Y N N Y 10 1649890800 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 5054286581147 GBKQU2233672 N Copyright Control Eduardo Segura 1650648627 Y 2022-04-22 18:15:02 0
106552 KARNAGEDIGITA26 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649890800 0 Y N N B N R Y N N Y 10 1649890800 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 5054286581147 GBKQU2233673 N Copyright Control Eduardo Segura 1650648639 Y 2022-04-22 18:15:02 0