SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    112229, 112228, 112227, 112226, 112225, 
    112224, 112223, 112134, 112133, 112132, 
    112131, 112130, 112129, 112128, 112127, 
    112126, 112125, 112124, 112236, 112235
  )

Query time 0.00057

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
112124 Hito2022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672444800 0 Y N N B N R Y N N Y 10 1672444800 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 5054287068807 QZDA82193550 N 112135 Twisted Hardcore Records J. Blaazer 1669872602 Y 2022-12-01 06:30:02 0
112125 Hito2022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672444800 0 Y N N B N R Y N N Y 10 1672444800 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 5054287068807 GBLV62209075 N 112135 Twisted Hardcore Records J. Blaazer 1669872604 Y 2022-12-01 06:30:04 0
112126 Hito2022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672444800 0 Y N N B N R Y N N Y 10 1672444800 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 5054287068807 GBLV62209076 N 112135 Twisted Hardcore Records J. Blaazer 1669872605 Y 2022-12-01 06:30:05 0
112127 Hito2022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672444800 0 Y N N B N R Y N N Y 10 1672444800 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 5054287068807 GBLV62209077 N 112135 Twisted Hardcore Records J. Blaazer 1669872605 Y 2022-12-01 06:30:05 0
112128 Hito2022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672444800 0 Y N N B N R Y N N Y 10 1672444800 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 5054287068807 GBLV62209078 N 112135 Twisted Hardcore Records J. Blaazer 1669872605 Y 2022-12-01 06:30:05 0
112129 Hito2022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672444800 0 Y N N B N R Y N N Y 10 1672444800 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 5054287068807 GBLV62209079 N 112135 Twisted Hardcore Records J. Blaazer 1669872605 Y 2022-12-01 06:30:05 0
112130 Hito2022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672444800 0 Y N N B N R Y N N Y 10 1672444800 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 5054287068807 GBKQU2251589 N 112135 Twisted Hardcore Records J. Blaazer 1669872605 Y 2022-12-01 06:30:05 0
112131 Hito2022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672444800 0 Y N N B N R Y N N Y 10 1672444800 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 5054287068807 GBLV62209080 N 112135 Twisted Hardcore Records J. Blaazer 1669872606 Y 2022-12-01 06:30:06 0
112132 Hito2022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672444800 0 Y N N B N R Y N N Y 10 1672444800 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 5054287068807 GBKQU2173680 N 112135 Twisted Hardcore Records J. Blaazer 1669872606 Y 2022-12-01 06:30:06 0
112133 Hito2022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672444800 0 Y N N B N R Y N N Y 10 1672444800 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 5054287068807 GBLV62209081 N 112135 Twisted Hardcore Records J. Blaazer 1669872606 Y 2022-12-01 06:30:06 0
112134 Hito2022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672444800 0 Y N N B N R Y N N Y 10 1672444800 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 5054287068807 GBLV62209082 N 112135 Twisted Hardcore Records J. Blaazer 1669872606 Y 2022-12-01 06:30:06 0
112223 SSUC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672531200 0 Y N N B N R Y N N Y 10 1672531200 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 5054287082612 QZSRH2100073 N 112230 Copyright Control Simon Antill 1670346903 Y 2022-12-06 18:15:03 0
112224 SSUC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672531200 0 Y N N B N R Y N N Y 10 1672531200 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 5054287082612 QZSRH2200007 N 112230 Copyright Control Simon Antill 1670346904 Y 2022-12-06 18:15:04 0
112225 SSUC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672531200 0 Y N N B N R Y N N Y 10 1672531200 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 5054287082612 QZSRH2100036 N 112230 Copyright Control Simon Antill 1670346904 Y 2022-12-06 18:15:04 0
112226 SSUC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672531200 0 Y N N B N R Y N N Y 10 1672531200 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 5054287082612 QZSRH2100093 N 112230 Copyright Control Simon Antill 1670346905 Y 2022-12-06 18:15:05 0
112227 SSUC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672531200 0 Y N N B N R Y N N Y 10 1672531200 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 5054287082612 QZSRH2100019 N 112230 Copyright Control Simon Antill 1670346905 Y 2022-12-06 18:15:05 0
112228 SSUC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672531200 0 Y N N B N R Y N N Y 10 1672531200 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 5054287082612 QZSRH2100131 N 112230 Copyright Control Simon Antill 1670346906 Y 2022-12-06 18:15:06 0
112229 SSUC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672531200 0 Y N N B N R Y N N Y 10 1672531200 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 5054287082612 QZSRH2200056 N 112230 Copyright Control Simon Antill 1670346906 Y 2022-12-06 18:15:06 0
112235 247HC302 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672358400 0 Y N N B N R Y N N Y 10 1672358400 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 5054287081370 UKT6B2200691 N Copyright Control Luis Jungkeit 1670347803 Y 2022-12-06 18:30:03 0
112236 247HC302 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672358400 0 Y N N B N R Y N N Y 10 1672358400 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 5054287081370 UKT6B2200698 N Copyright Control Luis Jungkeit 1670347804 Y 2022-12-06 18:30:04 0