SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    106113, 106112, 106111, 106110, 106109, 
    106108, 106107, 106106, 106105, 106104, 
    106103, 106102, 106100, 106043, 106042, 
    106041, 106511, 106510, 106509, 106029
  )

Query time 0.00030

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
106029 STI289 P A 1 1.69 1 0.000 0 0 0 0.00 0 1650841200 0 Y N N B N R Y N N Y 10 1650841200 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 5054286547198 GBKQU2228658 N Copyright Control J. Osborne 1648272602 Y 2022-03-26 06:30:02 0
106041 NTWO012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651014000 0 Y N N B N R Y N N Y 10 1651014000 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 5054286543367 GBKQU2227827 N Copyright Control Rick Chubbs 1651215036 Y 2022-03-28 06:15:03 0
106042 NTWO012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651014000 0 Y N N B N R Y N N Y 10 1651014000 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 5054286543367 GBKQU2227828 N Copyright Control Rick Chubbs 1651215047 Y 2022-03-28 06:15:03 0
106043 NTWO012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651014000 0 Y N N B N R Y N N Y 10 1651014000 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 5054286543367 GBKQU2227829 N Copyright Control Rick Chubbs 1651215056 Y 2022-03-28 06:15:04 0
106100 RAVEMUZIK052 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286552239 GBKQU2229392 N Copyright Control Marc Wehlke, Benjamin Heckmeier, Peter Nitschke 1648530902 Y 2022-03-29 06:15:02 0
106102 MOK254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286570981 NLLB82200025 N 106114 Copyright Control Y. Suzuki, D. Ikeda 1648530904 Y 2022-03-29 06:15:04 0
106103 MOK254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286570981 NLLB82200026 N 106114 Copyright Control Y. Suzuki, D. Ikeda 1648530905 Y 2022-03-29 06:15:05 0
106104 MOK254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286570981 NLLB82200027 N 106114 Copyright Control Y. Suzuki, D. Ikeda 1648530905 Y 2022-03-29 06:15:05 0
106105 MOK254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286570981 NLLB82200028 N 106114 Copyright Control Y. Suzuki, D. Ikeda 1648530905 Y 2022-03-29 06:15:05 0
106106 MOK254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286570981 NLLB82200029 N 106114 Copyright Control Y. Suzuki, D. Ikeda 1648530905 Y 2022-03-29 06:15:05 0
106107 MOK254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286570981 NLLB82200030 N 106114 Copyright Control Y. Suzuki, D. Ikeda 1648530905 Y 2022-03-29 06:15:05 0
106108 MOK254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286570981 NLLB82200031 N 106114 Copyright Control Y. Suzuki, D. Ikeda 1648530906 Y 2022-03-29 06:15:06 0
106109 MOK254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286570981 NLLB82200032 N 106114 Copyright Control Y. Suzuki, D. Ikeda 1648530906 Y 2022-03-29 06:15:06 0
106110 MOK254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286570981 NLLB82200033 N 106114 Copyright Control Y. Suzuki, D. Ikeda 1648530907 Y 2022-03-29 06:15:07 0
106111 MOK254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286570981 NLLB82200034 N 106114 Copyright Control Y. Suzuki, D. Ikeda 1648530907 Y 2022-03-29 06:15:07 0
106112 MOK254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286570981 NLLB82200035 N 106114 Copyright Control Y. Suzuki, D. Ikeda 1648530907 Y 2022-03-29 06:15:07 0
106113 MOK254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651100400 0 Y N N B N R Y N N Y 10 1651100400 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 5054286570981 NLLB82200036 N 106114 Copyright Control Y. Suzuki, D. Ikeda 1648530907 Y 2022-03-29 06:15:07 0
106509 BAB23 P A 1 1.69 1 0.000 0 0 0 0.00 0 1650841200 0 Y N N B N R Y N N Y 10 1650841200 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 5054286626305 NLS202200088 N 2 Dex Publishing R. van Der Vaart / M. Bakker 1650481202 Y 2022-04-20 20:00:02 0
106510 BAB23 P A 1 1.69 1 0.000 0 0 0 0.00 0 1650841200 0 Y N N B N R Y N N Y 10 1650841200 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 5054286626305 NLS202200089 N 2 Dex Publishing R. van Der Vaart / M. Bakker 1650481202 Y 2022-04-20 20:00:02 0
106511 BAB23 P A 1 1.69 1 0.000 0 0 0 0.00 0 1650841200 0 Y N N B N R Y N N Y 10 1650841200 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 5054286626305 NLS202200090 N 2 Dex Publishing R. van Der Vaart / M. Bakker 1650481202 Y 2022-04-20 20:00:02 0