SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    108078, 108077, 108058, 108056, 108417, 
    108060, 108850, 108963, 108962, 108386, 
    108063, 107976, 108380, 108171, 108128, 
    107947, 108896, 108895, 112381, 108982
  )

Query time 0.00046

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
107947 UPR182 P A 1 1.69 1 0.000 0 0 0 0.00 0 1658790000 0 Y N N B N R Y N N Y 10 1658790000 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 5054286738824 NL3TA2205601 N Copyright Control B. Svane 1656220502 Y 2022-06-26 06:15:02 0
107976 BKW033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1659049200 0 Y N N B N R Y N N Y 10 1659049200 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 5054286757306 IT0282200001 N Theracords Music Publishing M. Capri - G. Miserocchi 1656480610 Y 2022-06-29 06:30:10 0
108056 CATID104 P A 1 1.69 1 0.000 0 0 0 0.00 0 1659567600 0 Y N N B N R Y N N Y 10 1659567600 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 5054286782957 NLN6L2200021 N 108059 The Funky Cat Publishing H.C. van Dam 1657041309 Y 2022-07-05 18:15:09 0
108058 CATID104 P A 1 1.69 1 0.000 0 0 0 0.00 0 1659567600 0 Y N N B N R Y N N Y 10 1659567600 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 5054286782957 NLN6L2200022 N 108059 The Funky Cat Publishing H.C. van Dam 1657041310 Y 2022-07-05 18:15:10 0
108060 UPR184 P A 1 1.69 1 0.000 0 0 0 0.00 0 1659394800 0 Y N N B N R Y N N Y 10 1659394800 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 5054286782285 NL3TA2205801 N Copyright Control J. Nagadowski, P. Aarts 1657042201 Y 2022-07-05 18:30:01 0
108063 UPR183 P A 1 1.69 1 0.000 0 0 0 0.00 0 1659049200 0 Y N N B N R Y N N Y 10 1659049200 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 5054286782995 NL3TA2205701 N Copyright Control T. van der Steege, S. Kruemmel 1657043103 Y 2022-07-05 18:45:03 0
108077 STDIGI062 P A 1 1.69 1 0.000 0 0 0 0.00 0 1659654000 0 Y N N B N R Y N N Y 10 1659654000 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 5054286746485 GBKQU2259508 N Smiley Tunes Digital Michael Zhuchkov 1657085402 Y 2022-07-06 06:30:02 0
108078 A4T202206 P A 1 1.69 1 0.000 0 0 0 0.00 0 1659654000 0 Y N N B N R Y N N Y 10 1659654000 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 5054286778615 GBKQU2264141 N Copyright Control Ignasi Pertinez Romagosa 1657085402 Y 2022-07-06 06:30:02 0
108128 BBD088 P A 1 1.69 1 0.000 0 0 0 0.00 0 1658790000 0 Y N N B N R Y N N Y 10 1658790000 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 5054286785927 GBKQU2265301 N We Distribute Erick Humberto Hernandez Escobar 1657215006 Y 2022-07-07 18:30:06 0
108171 BBDSp001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1658876400 0 Y N N B N R Y N N Y 10 1658876400 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 5054286794745 GBKQU2266826 N We Distribute Adrian Dziura, Ryan Benjamins 1657602902 Y 2022-07-12 06:15:02 0
108380 INFEXEUP015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1658962800 0 Y N N B N R Y N N Y 10 1658962800 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 5054286813286 GBKQU2269579 N Copyright Control Danny McGill 1658337302 Y 2022-07-20 18:15:02 0
108386 HARSH191 P A 1 1.69 1 0.000 0 0 0 0.00 0 1659049200 0 Y N N B N R Y N N Y 10 1659049200 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 5054286811497 GBKQU2269304 N HARSH RECORDS Miguel Moreno, Sealtiel Diaz 1658339101 Y 2022-07-20 18:45:01 0
108417 CNN010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1659481200 0 Y N N B N R Y N N Y 10 1659481200 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 5054286818069 GBKQU2270405 N Copyright Control Lars Dalm, Noah Vermeulen 1658510102 Y 2022-07-22 18:15:02 0
108850 KKR122 P A 1 1.69 1 0.000 0 0 0 0.00 0 1659308400 0 Y N N B N R Y N N Y 10 1659308400 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 5054286798804 GBKQU2267432 N Copyright Control Alvaro Angel Tello Camarena & Diego Eduardo Padilla Nieto 1661190392 Y 2022-08-22 18:30:08 0
108895 KKR120 P A 1 1.69 1 0.000 0 0 0 0.00 0 1658703600 0 Y N N B N R Y N N Y 10 1658703600 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 5054286740933 GBKQU2258733 N Copyright Control Jack Stirling 1661191237 Y 2022-08-22 18:45:02 0
108896 KKR120 P A 1 1.69 1 0.000 0 0 0 0.00 0 1658703600 0 Y N N B N R Y N N Y 10 1658703600 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 5054286740933 GBKQU2258734 N Copyright Control Jack Stirling 1661191250 Y 2022-08-22 18:45:02 0
108962 KKR121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1659049200 0 Y N N B N R Y N N Y 10 1659049200 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 5054286766360 GBKQU2262323 N Copyright Control Pierre Albert 1661192125 Y 2022-08-22 18:45:48 0
108963 KKR121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1659049200 0 Y N N B N R Y N N Y 10 1659049200 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 5054286766360 GBKQU2262324 N Copyright Control Pierre Albert 1661192139 Y 2022-08-22 18:45:48 0
108982 KKR119 P A 1 1.69 1 0.000 0 0 0 0.00 0 1658444400 0 Y N N B N R Y N N Y 10 1658444400 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 5054286740926 GBKQU2258732 N Copyright Control Mario Jorge Fonseca Garcia 1661192389 Y 2022-08-22 18:45:55 0
112381 KKR119a P A 1 1.69 1 0.000 0 0 0 0.00 0 1658444400 0 Y N N B N R Y N N Y 10 1658444400 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 5054287088027 GBKQU2258732 N Copyright Control Mario Jorge Fonseca Garcia 1670520613 Y 2022-12-08 18:15:01 0