SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    109476, 110290, 110148, 110032, 109711, 
    109710, 109709, 109708, 109707, 109706, 
    109705, 109704, 109703, 109885, 109762, 
    109761, 109685, 110147, 109668, 109667
  )

Query time 0.00037

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
109476 247HC276 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666306800 0 Y N N B N R Y N N Y 10 1666306800 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 5054286887331 UKT6B2200341 N Copyright Control Igor Kallio 1666347686 Y 2022-09-07 07:30:03 0
109667 STI308 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665961200 0 Y N N B N R Y N N Y 10 1665961200 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 5054286899082 GBKQU2283368 N 109669 Copyright Control A. Brogden 1663391710 Y 2022-09-17 06:15:10 0
109668 STI308 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665961200 0 Y N N B N R Y N N Y 10 1665961200 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 5054286899082 GBKQU2283369 N 109669 Copyright Control A. Brogden 1663391710 Y 2022-09-17 06:15:10 0
109685 STI309 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666134000 0 Y N N B N R Y N N Y 10 1666134000 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 5054286899099 GBKQU2283370 N Copyright Control A. Brogden 1663564502 Y 2022-09-19 06:15:02 0
109703 Sti325 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666220400 0 Y N N B N R Y N N Y 10 1666220400 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 5054286906698 GBKQU2284539 N Copyright Control B. Cooper 1663650901 Y 2022-09-20 06:15:01 0
109704 MOK267 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666220400 0 Y N N B N R Y N N Y 10 1666220400 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 5054286891451 NLLB82200102 N Copyright Control Fabrizio Sabatino 1663650906 Y 2022-09-20 06:15:06 0
109705 MOK267 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666220400 0 Y N N B N R Y N N Y 10 1666220400 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 5054286891451 NLLB82200103 N Copyright Control Fabrizio Sabatino 1663650906 Y 2022-09-20 06:15:06 0
109706 MOK267 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666220400 0 Y N N B N R Y N N Y 10 1666220400 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 5054286891451 NLLB82200104 N Copyright Control Fabrizio Sabatino 1663650907 Y 2022-09-20 06:15:07 0
109707 MOK267 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666220400 0 Y N N B N R Y N N Y 10 1666220400 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 5054286891451 NLLB82200105 N Copyright Control Fabrizio Sabatino 1663650907 Y 2022-09-20 06:15:07 0
109708 MOK267 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666220400 0 Y N N B N R Y N N Y 10 1666220400 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 5054286891451 NLLB82200106 N Copyright Control Fabrizio Sabatino 1663650907 Y 2022-09-20 06:15:07 0
109709 MOK267 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666220400 0 Y N N B N R Y N N Y 10 1666220400 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 5054286891451 NLLB82200107 N Copyright Control Fabrizio Sabatino 1663650907 Y 2022-09-20 06:15:07 0
109710 MOK267 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666220400 0 Y N N B N R Y N N Y 10 1666220400 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 5054286891451 NLLB82200108 N Copyright Control Fabrizio Sabatino 1663650907 Y 2022-09-20 06:15:07 0
109711 MOK267 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666220400 0 Y N N B N R Y N N Y 10 1666220400 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 5054286891451 NLLB82200109 N Copyright Control Fabrizio Sabatino 1663650908 Y 2022-09-20 06:15:08 0
109761 ATECH13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666134000 0 Y N N B N R Y N N Y 10 1666134000 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 5054286918110 GBKQU2286229 N Copyright Control R. Besgrove 1663780502 Y 2022-09-21 18:15:02 0
109762 ATECH13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666134000 0 Y N N B N R Y N N Y 10 1666134000 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 5054286918110 GBKQU2286230 N Copyright Control R. Besgrove 1663780504 Y 2022-09-21 18:15:04 0
109885 SD209 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666134000 0 Y N N B N R Y N N Y 10 1666134000 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 5028386720430 GBACW1801357 N Peer Music G.Mendoza, C.Walker 1664298903 Y 2022-09-27 18:15:03 0
110032 XLUSIVE005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666220400 0 Y N N B N R Y N N Y 10 1666220400 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 5054286947882 GBKQU2290832 N Andriy Ursaki, Sven Beke Andriy Ursaki, Sven Beke 1664472601 Y 2022-09-29 18:30:01 0
110147 DNZF1339 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665961200 0 Y N N B N R Y N N Y 10 1665961200 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 5054286962250 GBKQU2292930 N DNZ Records Sethrow Gallagher 1665076502 Y 2022-10-06 18:15:02 0
110148 DARKUL152 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666220400 0 Y N N B N R Y N N Y 10 1666220400 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 5054286962694 GBKQU2292986 N Copyright Control Alan Robertson 1665077401 Y 2022-10-06 18:30:01 0
110290 DNZF1341 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666220400 0 Y N N B N R Y N N Y 10 1666220400 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 5054286974741 GBKQU2294793 N DNZ Records Anthony Simpson, Wayne Bishop 1665682202 Y 2022-10-13 18:30:02 0