SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    102140, 102139, 102138, 102137, 104577, 
    102089, 102088, 102087, 104332, 104331, 
    104330, 104329, 104578, 104542, 104541, 
    104540, 104490, 104489, 102082, 102075
  )

Query time 0.00049

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
102075 TiOS120 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646006400 0 Y N N B N R Y N N Y 10 1646006400 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 5054286431619 GBKQU2208382 N This Is Our Sound LTD Carl Franklin, Charlene Franklin 1646405455 Y 2022-01-29 06:05:01 0
102082 THR22001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646006400 0 Y N N B N R Y N N Y 10 1646006400 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 5054286434924 GBKQU2208927 N Twisted Hardcore Records Jose C. 1643433304 Y 2022-01-29 06:15:04 0
102087 TiOS121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646179200 0 Y N N B N R Y N N Y 10 1646179200 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 5054286431626 GBKQU2208383 N This Is Our Sound LTD Charlene Franklin, Carl Franklin 1646405497 Y 2022-01-31 06:05:02 0
102088 CR228 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646179200 0 Y N N B N R Y N N Y 10 1646179200 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 5054286441113 GBKQU2209777 N Contagious Records Riko Norton-Wilkes & Justin Dimodica-Harding 1646405517 Y 2022-01-31 06:05:02 0
102089 CR228 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646179200 0 Y N N B N R Y N N Y 10 1646179200 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 5054286441113 GBKQU2209778 N Contagious Records Riko Norton-Wilkes & Justin Dimodica-Harding 1643605502 Y 2022-01-31 06:05:02 0
102137 THR22006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646265600 0 Y N N B N R Y N N Y 10 1646265600 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 5054286445371 GBKQU2210390 N Twisted Hardcore Records Y. Schaefer & Patrick Groen 1643691902 Y 2022-02-01 06:05:02 0
102138 Hells057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646265600 0 Y N N B N R Y N N Y 10 1646265600 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 5054286442714 GBKQU2209981 N Copyright Control D. vd Berkmortel 1643691903 Y 2022-02-01 06:05:03 0
102139 Hells057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646265600 0 Y N N B N R Y N N Y 10 1646265600 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 5054286442714 GBKQU2209982 N Copyright Control D. vd Berkmortel 1643691903 Y 2022-02-01 06:05:03 0
102140 Hells057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646265600 0 Y N N B N R Y N N Y 10 1646265600 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 5054286442714 GBKQU2209983 N Copyright Control D. vd Berkmortel 1643691903 Y 2022-02-01 06:05:03 0
104329 DARKUG001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646092800 0 Y N N B N R Y N N Y 10 1646092800 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 5054286488910 GBKQU2218157 N Copyright Control R.Santi 1644944701 Y 2022-02-15 18:05:01 0
104330 DARKUG001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646092800 0 Y N N B N R Y N N Y 10 1646092800 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 5054286488910 GBKQU2218158 N Copyright Control R.Santi 1644944702 Y 2022-02-15 18:05:02 0
104331 DARKUG001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646092800 0 Y N N B N R Y N N Y 10 1646092800 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 5054286488910 GBKQU2218159 N Copyright Control R.Santi 1644944702 Y 2022-02-15 18:05:02 0
104332 DARKUG001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646092800 0 Y N N B N R Y N N Y 10 1646092800 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 5054286488910 GBKQU2218160 N Copyright Control R.Santi 1644944702 Y 2022-02-15 18:05:02 0
104489 OD046 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646006400 0 Y N N B N R Y N N Y 10 1646006400 0 N 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;} UKGEQ2200157 N Copyright Control Markku Rantanen 1645729781 Y 2022-02-20 20:13:46 0
104490 OD046 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646006400 0 Y N N B N R Y N N Y 10 1646006400 0 N 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;} UKGEQ2200158 N Copyright Control Markku Rantanen 1645729784 Y 2022-02-20 20:15:14 0
104540 EX061 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646006400 0 Y N N B N R Y N N Y 10 1646006400 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 5054286505563 GBKQU2221225 N Exode Records Fabien Nadal 1645549507 Y 2022-02-22 18:05:07 0
104541 EX061 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646006400 0 Y N N B N R Y N N Y 10 1646006400 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 5054286505563 GBKQU2221226 N Exode Records Fabien Nadal 1645549508 Y 2022-02-22 18:05:08 0
104542 EX061 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646006400 0 Y N N B N R Y N N Y 10 1646006400 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 5054286505563 GBKQU2221227 N Exode Records Fabien Nadal 1645549509 Y 2022-02-22 18:05:09 0
104577 JH332 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646179200 0 Y N N B N R Y N N Y 10 1646179200 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 5054286509554 GBKQU2221997 N Copyright Control HiroHiro 1646405565 Y 2022-02-24 18:05:02 0
104578 JH331 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646006400 0 Y N N B N R Y N N Y 10 1646006400 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 5054286509547 GBKQU2221996 N copyright control EzKiLL & Nikki 1646405483 Y 2022-02-24 18:05:03 0