SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    99468, 99905, 99309, 98768, 98767, 98732, 
    98731, 98730, 98729, 1660, 99167, 99166, 
    99165, 99164, 99163, 99162, 99161, 
    99160, 99159, 99158
  )

Query time 0.00073

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
1660 twistedtraxx93 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B Y R Y N N Y 10 1633042800 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;} N chris chris 1610714384 Y 2021-12-17 17:37:27 0
98729 Cheek547 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 5054285941720 GBKQU2162916 N Maxximum Songs Juergen Wind, Frank Hassas, Olaf Jeglitza 1630473603 Y 2021-12-17 17:37:27 0
98730 Cheek547 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 5054285941720 GBKQU2162917 N Maxximum Songs Juergen Wind, Frank Hassas, Olaf Jeglitza 1630473603 Y 2021-12-17 17:37:27 0
98731 Cheek547 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 5054285941720 GBKQU2162918 N Maxximum Songs Juergen Wind, Frank Hassas, Olaf Jeglitza 1630473603 Y 2021-12-17 17:37:27 0
98732 Cheek547 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 5054285941720 GBKQU2162919 N Maxximum Songs Juergen Wind, Frank Hassas, Olaf Jeglitza 1698091294 Y 2021-12-17 17:37:27 0
98767 TIBUK008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 5054286145585 GBKQU2196443 N Copyright Control Dean Palfreman, Kayleigh O'Neill 1630602302 Y 2021-12-17 17:37:27 0
98768 TIBUK008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 5054286145585 GBKQU2196444 N Copyright Control Dean Palfreman, Kayleigh O'Neill 1698091306 Y 2021-12-17 17:37:27 0
99158 JACKEDUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632956400 0 Y N N B N R Y N N Y 10 1632956400 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 5054286174882 GBLV62101322 N 99168 Jumpin Jack, Zero Range, Basic Beatz, A-Side Jumpin Jack, Zero Range, Basic Beatz, A-Side 1632158109 Y 2021-12-17 17:37:27 0
99159 JACKEDUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632956400 0 Y N N B N R Y N N Y 10 1632956400 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 5054286174882 GBLV62101323 N 99168 Jumpin Jack, Zero Range, Basic Beatz, A-Side Jumpin Jack, Zero Range, Basic Beatz, A-Side 1632158109 Y 2021-12-17 17:37:27 0
99160 JACKEDUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632956400 0 Y N N B N R Y N N Y 10 1632956400 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 5054286174882 GBLV62101309 N 99168 Jumpin Jack, Zero Range, Basic Beatz, A-Side Jumpin Jack, Zero Range, Basic Beatz, A-Side 1632158110 Y 2021-12-17 17:37:27 0
99161 JACKEDUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632956400 0 Y N N B N R Y N N Y 10 1632956400 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 5054286174882 GBLV62101324 N 99168 Jumpin Jack, Zero Range, Basic Beatz, A-Side Jumpin Jack, Zero Range, Basic Beatz, A-Side 1632158110 Y 2021-12-17 17:37:27 0
99162 JACKEDUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632956400 0 Y N N B N R Y N N Y 10 1632956400 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 5054286174882 GBLV62101325 N 99168 Jumpin Jack, Zero Range, Basic Beatz, A-Side Jumpin Jack, Zero Range, Basic Beatz, A-Side 1632158110 Y 2021-12-17 17:37:27 0
99163 JACKEDUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632956400 0 Y N N B N R Y N N Y 10 1632956400 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 5054286174882 GBLV62101326 N 99168 Jumpin Jack, Zero Range, Basic Beatz, A-Side Jumpin Jack, Zero Range, Basic Beatz, A-Side 1632158111 Y 2021-12-17 17:37:27 0
99164 JACKEDUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632956400 0 Y N N B N R Y N N Y 10 1632956400 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 5054286174882 GBLV62101327 N 99168 Jumpin Jack, Zero Range, Basic Beatz, A-Side Jumpin Jack, Zero Range, Basic Beatz, A-Side 1632158111 Y 2021-12-17 17:37:27 0
99165 JACKEDUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632956400 0 Y N N B N R Y N N Y 10 1632956400 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 5054286174882 GBLV62101328 N 99168 Jumpin Jack, Zero Range, Basic Beatz, A-Side Jumpin Jack, Zero Range, Basic Beatz, A-Side 1632158111 Y 2021-12-17 17:37:27 0
99166 JACKEDUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632956400 0 Y N N B N R Y N N Y 10 1632956400 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 5054286174882 GBLV62101329 N 99168 Jumpin Jack, Zero Range, Basic Beatz, A-Side Jumpin Jack, Zero Range, Basic Beatz, A-Side 1632158111 Y 2021-12-17 17:37:27 0
99167 JACKEDUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632956400 0 Y N N B N R Y N N Y 10 1632956400 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 5054286174882 GBLV62101330 N 99168 Jumpin Jack, Zero Range, Basic Beatz, A-Side Jumpin Jack, Zero Range, Basic Beatz, A-Side 1632158111 Y 2021-12-17 17:37:27 0
99309 SHARPD011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 5054286186168 GBLV62103277 N Copyright Control Malcolm Duffy, Jean Philippe Aviance 1698091490 Y 2021-12-17 17:37:27 0
99468 LKR010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633561200 0 Y N N B N R Y N N Y 10 1633561200 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;} CH6542183376 N Copyright Control Craig Martin Geary 1698091487 Y 2021-12-17 17:37:27 0
99905 BG79 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633302000 0 Y N N B N R Y N N Y 10 1633302000 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 5054286240532 GBLV62113022 N Buggie dance Dj noke 1634707816 Y 2021-12-17 17:37:27 0