SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    106238, 106237, 106236, 106235, 106234, 
    106233, 106680, 106285, 106284, 106556, 
    106371, 106370, 106208, 106232, 106179, 
    106178, 106177, 106176, 106175, 106174
  )

Query time 0.00048

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
106174 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 GBKQU1670297 N 106180 Black Reverb vv.aa. 1648704604 Y 2022-03-31 06:30:04 0
106175 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 GBKQU1697899 N 106180 Black Reverb vv.aa. 1648704604 Y 2022-03-31 06:30:04 0
106176 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 GBLV61637582 N 106180 Black Reverb vv.aa. 1648704604 Y 2022-03-31 06:30:04 0
106177 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 GBKQU1724522 N 106180 Black Reverb vv.aa. 1648704605 Y 2022-03-31 06:30:05 0
106178 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 GBLV61705532 N 106180 Black Reverb vv.aa. 1648704605 Y 2022-03-31 06:30:05 0
106179 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 GBLV61716786 N 106180 Black Reverb vv.aa. 1648704605 Y 2022-03-31 06:30:05 0
106208 STI295 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651446000 0 Y N N B N R Y N N Y 10 1651446000 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 5054286547341 GBKQU2228675 N Copyright Control G. Covington 1648876502 Y 2022-04-02 06:15:02 0
106232 HTTC017 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 5054286592037 GBKQU2235341 N Hard To The Core Digital Arnie 1649138403 Y 2022-04-05 07:00:03 0
106233 BRR194 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651705200 0 Y N N B N R Y N N Y 10 1651705200 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 5054286549147 GBLV62136158 N 106244 Black Reverb Various Artists 1649138408 Y 2022-04-05 07:00:08 0
106234 BRR194 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651705200 0 Y N N B N R Y N N Y 10 1651705200 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 5054286549147 GBKQU1923952 N 106244 Black Reverb Various Artists 1649138409 Y 2022-04-05 07:00:09 0
106235 BRR194 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651705200 0 Y N N B N R Y N N Y 10 1651705200 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 5054286549147 GBKQU1968325 N 106244 Black Reverb Various Artists 1649138413 Y 2022-04-05 07:00:13 0
106236 BRR194 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651705200 0 Y N N B N R Y N N Y 10 1651705200 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 5054286549147 GBLV62038487 N 106244 Black Reverb Various Artists 1649138414 Y 2022-04-05 07:00:14 0
106237 BRR194 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651705200 0 Y N N B N R Y N N Y 10 1651705200 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 5054286549147 GBKQU2045612 N 106244 Black Reverb Various Artists 1649138419 Y 2022-04-05 07:00:19 0
106238 BRR194 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651705200 0 Y N N B N R Y N N Y 10 1651705200 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 5054286549147 GBLV62029431 N 106244 Black Reverb Various Artists 1649138419 Y 2022-04-05 07:00:19 0
106284 Hells062 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651618800 0 Y N N B N R Y N N Y 10 1651618800 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 5054286599081 GBKQU2236632 N Hell's Recordings P. de Rooij, J. Leenards 1649352603 Y 2022-04-07 18:30:03 0
106285 Hells062 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651618800 0 Y N N B N R Y N N Y 10 1651618800 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 5054286599081 GBKQU2236633 N Hell's Recordings P. de Rooij, J. Leenards 1649352604 Y 2022-04-07 18:30:04 0
106370 CR231 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651446000 0 Y N N B N R Y N N Y 10 1651446000 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 5054286606390 GBKQU2237881 N Contagious Records Riko Norton-Wilkes & Justin Dimodica-Harding 1651821225 Y 2022-04-12 19:00:03 0
106371 CR231 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651446000 0 Y N N B N R Y N N Y 10 1651446000 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 5054286606390 GBKQU2237882 N Contagious Records Riko Norton-Wilkes & Justin Dimodica-Harding 1649786404 Y 2022-04-12 19:00:04 0
106556 DNZF1224 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651532400 0 Y N N B N R Y N N Y 10 1651532400 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 5054286632597 GBKQU2241962 N DNZ Records DJ Chiki, Basic Beatz 1650647703 Y 2022-04-22 18:15:03 0
106680 JH339 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651618800 0 Y N N B N R Y N N Y 10 1651618800 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 5054286646464 GBKQU2244110 N Copyright Control The Boosterz 1651821261 Y 2022-04-29 18:30:02 0