SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    120592, 120591, 120590, 120589, 120588, 
    120587, 120586, 120585, 120584, 120583, 
    120582, 120581, 120580, 120579, 120578, 
    120577, 120576, 120575, 120574, 120573, 
    120572, 120571
  )

Query time 0.00062

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 22 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
120571 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBKQU2255376 N 120593 +QDance Records Various Artits 1701840323 Y 2023-12-06 06:25:23 0
120572 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBLV62118184 N 120593 +QDance Records Various Artits 1701840327 Y 2023-12-06 06:25:27 0
120573 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBKQU2301573 N 120593 +QDance Records Various Artits 1701840329 Y 2023-12-06 06:25:29 0
120574 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBKQU2255381 N 120593 +QDance Records Various Artits 1701840332 Y 2023-12-06 06:25:32 0
120575 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBKQU2206868 N 120593 +QDance Records Various Artits 1701840334 Y 2023-12-06 06:25:34 0
120576 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBKQU2305352 N 120593 +QDance Records Various Artits 1701840338 Y 2023-12-06 06:25:38 0
120577 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBKQU2276528 N 120593 +QDance Records Various Artits 1701840340 Y 2023-12-06 06:25:40 0
120578 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBKQU2376413 N 120593 +QDance Records Various Artits 1701840341 Y 2023-12-06 06:25:41 0
120579 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBLV62118185 N 120593 +QDance Records Various Artits 1701840343 Y 2023-12-06 06:25:43 0
120580 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBKQU2258305 N 120593 +QDance Records Various Artits 1701840345 Y 2023-12-06 06:25:45 0
120581 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBKQU2349874 N 120593 +QDance Records Various Artits 1701840348 Y 2023-12-06 06:25:48 0
120582 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBLV62309957 N 120593 +QDance Records Various Artits 1701840349 Y 2023-12-06 06:25:49 0
120583 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBLV62309958 N 120593 +QDance Records Various Artits 1701840351 Y 2023-12-06 06:25:51 0
120584 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBLV62132958 N 120593 +QDance Records Various Artits 1701840360 Y 2023-12-06 06:26:00 0
120585 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBKQU2200050 N 120593 +QDance Records Various Artits 1701840371 Y 2023-12-06 06:26:11 0
120586 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBKQU2353694 N 120593 +QDance Records Various Artits 1701840378 Y 2023-12-06 06:26:18 0
120587 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBLV62137682 N 120593 +QDance Records Various Artits 1701840382 Y 2023-12-06 06:26:22 0
120588 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBLV62118183 N 120593 +QDance Records Various Artits 1701840384 Y 2023-12-06 06:26:24 0
120589 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBLV62118186 N 120593 +QDance Records Various Artits 1701840386 Y 2023-12-06 06:26:26 0
120590 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 QZS632171889 N 120593 +QDance Records Various Artits 1701840391 Y 2023-12-06 06:26:31 0
120591 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBKQU2352194 N 120593 +QDance Records Various Artits 1701840392 Y 2023-12-06 06:26:32 0
120592 MQDRCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1704240000 0 Y N N B N R Y N N Y 10 1704240000 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 5054287825066 GBLV62309959 N 120593 +QDance Records Various Artits 1701840394 Y 2023-12-06 06:26:34 0