SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    112520, 112519, 112518, 112517, 112516, 
    112515, 112514, 112513, 112512, 112511, 
    112510, 112509, 112508, 112507, 112506, 
    112505, 112504, 111885, 111884, 111883
  )

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
111883 AAA008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287042302 GBLV62205013 N Copyright Control Ben Fraser 1668835825 Y 2022-11-19 06:30:25 0
111884 AAA008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287042302 GBLV62205014 N Copyright Control Ben Fraser 1668835826 Y 2022-11-19 06:30:26 0
111885 AAA008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287042302 GBLV62205015 N Copyright Control Ben Fraser 1668835826 Y 2022-11-19 06:30:26 0
112504 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213636 N 112522 Aurora Mortem Records Various Artists 1671083104 Y 2022-12-15 06:45:04 0
112505 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213637 N 112522 Aurora Mortem Records Various Artists 1671083104 Y 2022-12-15 06:45:04 0
112506 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213638 N 112522 Aurora Mortem Records Various Artists 1671083104 Y 2022-12-15 06:45:04 0
112507 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213639 N 112522 Aurora Mortem Records Various Artists 1671083105 Y 2022-12-15 06:45:05 0
112508 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213640 N 112522 Aurora Mortem Records Various Artists 1671083106 Y 2022-12-15 06:45:06 0
112509 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213641 N 112522 Aurora Mortem Records Various Artists 1671083106 Y 2022-12-15 06:45:06 0
112510 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213642 N 112522 Aurora Mortem Records Various Artists 1671083106 Y 2022-12-15 06:45:06 0
112511 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213643 N 112522 Aurora Mortem Records Various Artists 1671083106 Y 2022-12-15 06:45:06 0
112512 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213644 N 112522 Aurora Mortem Records Various Artists 1671083107 Y 2022-12-15 06:45:07 0
112513 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213645 N 112522 Aurora Mortem Records Various Artists 1671083107 Y 2022-12-15 06:45:07 0
112514 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213646 N 112522 Aurora Mortem Records Various Artists 1671083107 Y 2022-12-15 06:45:07 0
112515 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213647 N 112522 Aurora Mortem Records Various Artists 1671083108 Y 2022-12-15 06:45:08 0
112516 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213648 N 112522 Aurora Mortem Records Various Artists 1671083108 Y 2022-12-15 06:45:08 0
112517 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213649 N 112522 Aurora Mortem Records Various Artists 1671083108 Y 2022-12-15 06:45:08 0
112518 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213650 N 112522 Aurora Mortem Records Various Artists 1671083108 Y 2022-12-15 06:45:08 0
112519 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213651 N 112522 Aurora Mortem Records Various Artists 1671083109 Y 2022-12-15 06:45:09 0
112520 AMR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287097838 GBLV62213652 N 112522 Aurora Mortem Records Various Artists 1671083109 Y 2022-12-15 06:45:09 0