SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    106173, 106172, 106171, 106170, 106642, 
    106605, 106596, 106583, 106579, 106565, 
    106546, 106545, 106544, 106543, 106542, 
    106541, 106540, 106539, 106538, 106537
  )

Query time 0.00041

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
106170 BRR193 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651273200 0 Y N N B N R Y N N Y 10 1651273200 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 5054286549123 GBKQU1618449 N 106180 Black Reverb vv.aa. 1648704603 Y 2022-03-31 06:30:03 0
106171 BRR193 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651273200 0 Y N N B N R Y N N Y 10 1651273200 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 5054286549123 GBKQU1631770 N 106180 Black Reverb vv.aa. 1648704603 Y 2022-03-31 06:30:03 0
106172 BRR193 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651273200 0 Y N N B N R Y N N Y 10 1651273200 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 5054286549123 GBKQU1658645 N 106180 Black Reverb vv.aa. 1648704604 Y 2022-03-31 06:30:04 0
106173 BRR193 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651273200 0 Y N N B N R Y N N Y 10 1651273200 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 5054286549123 GBKQU1668519 N 106180 Black Reverb vv.aa. 1648704604 Y 2022-03-31 06:30:04 0
106537 DSBCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286629214 NLS161801631 N 106547 2 Dex Publishing F. Stramaccioni 1650561309 Y 2022-04-21 18:15:09 0
106538 DSBCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286629214 NLS161801359 N 106547 2 Dex Publishing F. Stramaccioni 1650561309 Y 2022-04-21 18:15:09 0
106539 DSBCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286629214 NLS161802615 N 106547 2 Dex Publishing F. Stramaccioni 1650561309 Y 2022-04-21 18:15:09 0
106540 DSBCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286629214 NLS161802888 N 106547 2 Dex Publishing F. Stramaccioni 1650561310 Y 2022-04-21 18:15:10 0
106541 DSBCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286629214 NLS161701109 N 106547 2 Dex Publishing F. Stramaccioni 1650561310 Y 2022-04-21 18:15:10 0
106542 DSBCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286629214 NLS161802078 N 106547 2 Dex Publishing F. Stramaccioni 1650561310 Y 2022-04-21 18:15:10 0
106543 DSBCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286629214 NLS161801851 N 106547 2 Dex Publishing F. Stramaccioni 1650561310 Y 2022-04-21 18:15:10 0
106544 DSBCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286629214 NLS161802751 N 106547 2 Dex Publishing F. Stramaccioni 1650561310 Y 2022-04-21 18:15:10 0
106545 DSBCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286629214 NLS161802222 N 106547 2 Dex Publishing F. Stramaccioni 1650561311 Y 2022-04-21 18:15:11 0
106546 DSBCD01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286629214 NLS161801737 N 106547 2 Dex Publishing F. Stramaccioni 1650561311 Y 2022-04-21 18:15:11 0
106565 WAODB001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286632337 GBKQU1635833 N 106606 Copyright Control R.Scott 1650647710 Y 2022-04-22 18:15:10 0
106579 WAODB001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286632337 GBKQU1635835 N 106606 Copyright Control R.Scott 1650647713 Y 2022-04-22 18:15:13 0
106583 WAODB001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286632337 GBKQU1635828 N 106606 Copyright Control R.Scott 1650647714 Y 2022-04-22 18:15:14 0
106596 WAODB001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286632337 GBKQU1635831 N 106606 Copyright Control R.Scott 1650647716 Y 2022-04-22 18:15:16 0
106605 WAODB001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286632337 GBKQU1635829 N 106606 Copyright Control R.Scott 1650647718 Y 2022-04-22 18:15:18 0
106642 CSP011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651186800 0 Y N N B N R Y N N Y 10 1651186800 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 5054286634935 GBKQU2242400 N Copyright Control Julien Ricquart-Cazin 1650910502 Y 2022-04-25 19:15:02 0