SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    104382, 104381, 104380, 104379, 102165, 
    102164, 102163, 102162, 102161, 102160, 
    102159, 102158, 102157, 102156, 102155, 
    102154, 102150, 104598, 102142, 102141
  )

Query time 0.00039

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
102141 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 GBKQU2209984 N Copyright Control D. vd Berkmortel 1643691904 Y 2022-02-01 06:05:04 0
102142 DARKULLP004t13 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 5054286431183 GBKQU2208321 N Copyright Control Paula Vigara Vives, Jordi Gran 1643691904 Y 2022-02-01 06:05:04 0
102150 FINRGL002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286449300 GBKQU2210842 N Copyright Control Kimon Kukulis 1643778601 Y 2022-02-02 06:10:01 0
102154 247HC255 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286415015 UKT6B2200068 N Copyright Control L.Jungkeit 1646405580 Y 2022-02-02 06:15:01 0
102155 247HC255 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286415015 UKT6B2200067 N Copyright Control L.Jungkeit 1643778902 Y 2022-02-02 06:15:02 0
102156 247HC255 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286415015 UKT6B2200078 N Copyright Control L.Jungkeit 1643778902 Y 2022-02-02 06:15:02 0
102157 247HC255 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286415015 UKT6B2200079 N Copyright Control L.Jungkeit 1643778903 Y 2022-02-02 06:15:03 0
102158 247HC255 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286415015 UKT6B2200080 N Copyright Control L.Jungkeit 1643778904 Y 2022-02-02 06:15:04 0
102159 247HC255 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286415015 UKT6B2200081 N Copyright Control L.Jungkeit 1643778905 Y 2022-02-02 06:15:05 0
102160 247HC255 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286415015 UKT6B2200082 N Copyright Control L.Jungkeit 1643778907 Y 2022-02-02 06:15:07 0
102161 247HC255 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286415015 UKT6B2200083 N Copyright Control L.Jungkeit 1643778908 Y 2022-02-02 06:15:08 0
102162 PANDA016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286415312 UKT6B2100274 N Peer Music / Copyright Control R.Cox, A.Taylor 1646405599 Y 2022-02-02 06:15:08 0
102163 PANDA016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286415312 UKT6B2200164 N Peer Music / Copyright Control R.Cox, A.Taylor 1643778908 Y 2022-02-02 06:15:08 0
102164 KARNAGEDIGITA25 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286441694 GBKQU2209842 N Copyright Control Bastien Falco, Rodrigue Gilbert 1643778909 Y 2022-02-02 06:15:09 0
102165 KARNAGEDIGITA25 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286441694 GBKQU2209843 N Copyright Control Bastien Falco, Rodrigue Gilbert 1643778909 Y 2022-02-02 06:15:09 0
104379 RAVECD02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286491613 GBKQU1916106 N 104396 Copyright Control Lammert Brouwer 1645031413 Y 2022-02-16 18:10:13 0
104380 RAVECD02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286491613 GBKQU1960858 N 104396 Copyright Control Lammert Brouwer 1645031415 Y 2022-02-16 18:10:15 0
104381 RAVECD02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286491613 GBKQU2007139 N 104396 Copyright Control Lammert Brouwer 1645031416 Y 2022-02-16 18:10:16 0
104382 RAVECD02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646352000 0 Y N N B N R Y N N Y 10 1646352000 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 5054286491613 GBKQU2007141 N 104396 Copyright Control Lammert Brouwer 1645031416 Y 2022-02-16 18:10:16 0
104598 DNZF1193 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 5054286510130 GBKQU2222104 N DNZ Records Slamma, Kinn 1645722313 Y 2022-02-24 18:05:13 0