SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    42487, 42577, 42576, 42575, 42574, 42573, 
    42572, 42478, 42787, 42817, 42638, 
    42589, 42493, 42492, 42491, 42630, 
    42629, 42518, 42568, 42422
  )

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
42422 DNZF091 P A 1 1.69 1 0.000 0 0 0 0.00 0 1430953200 0 Y N N B N R Y N N Y 10 1430953200 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 5054281670990 GBKQU1536342 N DNZ Records DJ Nillos 1429246958 Y 2021-12-17 17:37:27 0
42478 BS028 P A 1 1.69 1 0.000 0 0 0 0.00 0 1432076400 0 Y N N B N R Y N N Y 10 1432076400 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 5054281670372 GBKQU1536204 N Basics Hard Music Company Miguel Aimeur 1429592403 Y 2021-12-17 17:37:27 0
42487 NRG001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1432162800 0 Y N N B N R Y N N Y 10 1432162800 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 5054281660847 UKAYC1500001 N Copyright Control D.Morgan, B.Lee, A.Green, P.Crawley, S.Corlett, D.Lewin 1429678829 Y 2021-12-17 17:37:27 0
42491 RE020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431558000 0 Y N N B N R Y N N Y 10 1431558000 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 5054281673793 GBKQU1536922 N Relay Records Jumpin Jack 1429678846 Y 2021-12-17 17:37:27 0
42492 RE020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431558000 0 Y N N B N R Y N N Y 10 1431558000 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 5054281673793 GBKQU1536923 N Relay Records Jumpin Jack 1429678849 Y 2021-12-17 17:37:27 0
42493 RE020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431558000 0 Y N N B N R Y N N Y 10 1431558000 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 5054281673793 GBKQU1536924 N Relay Records Jumpin Jack 1429678851 Y 2021-12-17 17:37:27 0
42518 DNZF090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431471600 0 Y N N B N R Y N N Y 10 1431471600 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 5054281678347 GBKQU1538101 N DNZ Records JJ 1429851613 Y 2021-12-17 17:37:27 0
42568 RE021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431298800 0 Y N N B N R Y N N Y 10 1431298800 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 5054281689145 GBKQU1540358 N Relay Records Klubb Eff3kt 1430197209 Y 2021-12-17 17:37:27 0
42572 DNZ152 P A 1 1.69 1 0.000 0 0 0 0.00 0 1432076400 0 Y N N B N R Y N N Y 10 1432076400 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 5054281689190 GBKQU1540367 N DNZ Records Ste Ingham 1430197226 Y 2021-12-17 17:37:27 0
42573 DNZ152 P A 1 1.69 1 0.000 0 0 0 0.00 0 1432076400 0 Y N N B N R Y N N Y 10 1432076400 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 5054281689190 GBKQU1540368 N DNZ Records Ste Ingham 1430197229 Y 2021-12-17 17:37:27 0
42574 DNZ152 P A 1 1.69 1 0.000 0 0 0 0.00 0 1432076400 0 Y N N B N R Y N N Y 10 1432076400 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 5054281689190 GBKQU1540370 N DNZ Records Ste Ingham 1430197232 Y 2021-12-17 17:37:27 0
42575 DNZ152 P A 1 1.69 1 0.000 0 0 0 0.00 0 1432076400 0 Y N N B N R Y N N Y 10 1432076400 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 5054281689190 GBKQU1540371 N DNZ Records Ste Ingham 1430197235 Y 2021-12-17 17:37:27 0
42576 DNZ152 P A 1 1.69 1 0.000 0 0 0 0.00 0 1432076400 0 Y N N B N R Y N N Y 10 1432076400 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 5054281689190 GBKQU1540372 N DNZ Records Ste Ingham 1430197238 Y 2021-12-17 17:37:27 0
42577 DNZ152 P A 1 1.69 1 0.000 0 0 0 0.00 0 1432076400 0 Y N N B N R Y N N Y 10 1432076400 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 5054281689190 GBKQU1540373 N DNZ Records Ste Ingham 1430197243 Y 2021-12-17 17:37:27 0
42589 DNZF094 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431558000 0 Y N N B N R Y N N Y 10 1431558000 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 5054281687615 GBKQU1540008 N DNZ Records Marilyn 1430283629 Y 2021-12-17 17:37:27 0
42629 EDD096 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431471600 0 Y N N B N R Y N N Y 10 1431471600 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 5054281694620 GBKQU1541595 N Emotive Dance Digital Jorge Hardbass, Vito 1430456408 Y 2021-12-17 17:37:27 0
42630 EDD096 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431471600 0 Y N N B N R Y N N Y 10 1431471600 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 5054281694620 GBKQU1541596 N Emotive Dance Digital Jorge Hardbass, Vito 1430456410 Y 2021-12-17 17:37:27 0
42638 DR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431644400 0 Y N N B N R Y N N Y 10 1431644400 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 5054281697379 GBKQU1542131 N Fitzer Liam McDermott 1430542804 Y 2021-12-17 17:37:27 0
42787 EDD091 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281702189 GBKQU1543145 N Emotive Dance Digital One & Brivi, DJ Xito & DJ Trip 1430974827 Y 2021-12-17 17:37:27 0
42817 RE022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431817200 0 Y N N B N R Y N N Y 10 1431817200 1433026800 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;} 4 labelworx 5054281702257 GBKQU1543151 N Relay Records Audio Chimp 1430974950 Y 2021-12-17 17:37:27 0