SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    122285, 122284, 122283, 122282, 109540, 
    109539, 109538, 109537, 109536, 109535, 
    109534, 109533, 109532, 109531, 109530, 
    109529, 109528, 109270, 109808, 109735
  )

Query time 0.00050

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
109270 STI305 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664578800 0 Y N N B N R Y N N Y 10 1664578800 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 5054286852148 GBKQU2275980 N Copyright Control B. Cooper, R. Love 1665125760 Y 2022-09-01 06:15:20 0
109528 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBKQU2203659 N 109541 Copyright Control Various Artists 1662659108 Y 2022-09-08 18:45:08 0
109529 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBLV62123569 N 109541 Copyright Control Various Artists 1662659108 Y 2022-09-08 18:45:08 0
109530 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBLV62124592 N 109541 Copyright Control Various Artists 1662659109 Y 2022-09-08 18:45:09 0
109531 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBLV62118829 N 109541 Copyright Control Various Artists 1662659110 Y 2022-09-08 18:45:10 0
109532 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBLV62124267 N 109541 Copyright Control Various Artists 1662659113 Y 2022-09-08 18:45:13 0
109533 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBKQU2194553 N 109541 Copyright Control Various Artists 1662659113 Y 2022-09-08 18:45:13 0
109534 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBLV62121251 N 109541 Copyright Control Various Artists 1662659113 Y 2022-09-08 18:45:13 0
109535 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBLV62128321 N 109541 Copyright Control Various Artists 1662659113 Y 2022-09-08 18:45:13 0
109536 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBLV62115653 N 109541 Copyright Control Various Artists 1662659114 Y 2022-09-08 18:45:14 0
109537 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBLV62111117 N 109541 Copyright Control Various Artists 1662659114 Y 2022-09-08 18:45:14 0
109538 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBKQU2139842 N 109541 Copyright Control Various Artists 1662659114 Y 2022-09-08 18:45:14 0
109539 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBLV62102581 N 109541 Copyright Control Various Artists 1662659114 Y 2022-09-08 18:45:14 0
109540 LWHTS05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054286907527 GBLV62102206 N 109541 Copyright Control Various Artists 1662659114 Y 2022-09-08 18:45:14 0
109735 247HCLP018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664492400 0 Y N N B N R Y N N Y 10 1664492400 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 5054286927976 UKT6B2200401 N 109736 Peer Music / Copyright Control Various Artists 1663696808 Y 2022-09-20 19:00:08 0
109808 DARKUL150 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664492400 0 Y N N B N R Y N N Y 10 1664492400 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 5054286935261 GBKQU2288993 N Copyright Control Lara Verhoef 1663953305 Y 2022-09-23 18:15:05 0
122282 LWHTS05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054288017941 GBKQU2203659 N 122294 Copyright Control Various Artists 1708046727 Y 2024-02-16 02:09:05 0
122283 LWHTS05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054288017941 GBLV62123569 N 122294 Copyright Control Various Artists 1708046762 Y 2024-02-16 02:09:09 0
122284 LWHTS05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054288017941 GBLV62124592 N 122294 Copyright Control Various Artists 1708046811 Y 2024-02-16 02:09:17 0
122285 LWHTS05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054288017941 GBLV62118829 N 122294 Copyright Control Various Artists 1708046836 Y 2024-02-16 02:09:21 0