SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    119709, 119708, 119707, 119706, 119705, 
    119704, 119703, 119702, 119701, 119700, 
    119699, 119698, 119697, 119696, 119695, 
    119694, 119693, 119692, 119691, 119690, 
    119689, 119688
  )

Query time 0.00033

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
119688 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2308618 N 119710 Copyright Control Various Artists 1701702354 Y 2023-12-04 16:05:54 0
119689 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBLV62214863 N 119710 Copyright Control Various Artists 1701702356 Y 2023-12-04 16:05:56 0
119690 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2368907 N 119710 Copyright Control Various Artists 1701702358 Y 2023-12-04 16:05:58 0
119691 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2325981 N 119710 Copyright Control Various Artists 1701702363 Y 2023-12-04 16:06:03 0
119692 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2368909 N 119710 Copyright Control Various Artists 1701702366 Y 2023-12-04 16:06:06 0
119693 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2361463 N 119710 Copyright Control Various Artists 1701702369 Y 2023-12-04 16:06:09 0
119694 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBLV62217254 N 119710 Copyright Control Various Artists 1701702375 Y 2023-12-04 16:06:15 0
119695 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2316061 N 119710 Copyright Control Various Artists 1701702379 Y 2023-12-04 16:06:19 0
119696 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2359475 N 119710 Copyright Control Various Artists 1701702385 Y 2023-12-04 16:06:25 0
119697 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2307739 N 119710 Copyright Control Various Artists 1701702388 Y 2023-12-04 16:06:28 0
119698 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2329168 N 119710 Copyright Control Various Artists 1701702391 Y 2023-12-04 16:06:31 0
119699 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2362424 N 119710 Copyright Control Various Artists 1701702394 Y 2023-12-04 16:06:34 0
119700 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBLV62217077 N 119710 Copyright Control Various Artists 1701702397 Y 2023-12-04 16:06:37 0
119701 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2351974 N 119710 Copyright Control Various Artists 1701702402 Y 2023-12-04 16:06:42 0
119702 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2360894 N 119710 Copyright Control Various Artists 1701702406 Y 2023-12-04 16:06:46 0
119703 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2329149 N 119710 Copyright Control Various Artists 1701702410 Y 2023-12-04 16:06:50 0
119704 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2330824 N 119710 Copyright Control Various Artists 1701702412 Y 2023-12-04 16:06:52 0
119705 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2339596 N 119710 Copyright Control Various Artists 1701702414 Y 2023-12-04 16:06:54 0
119706 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2341590 N 119710 Copyright Control Various Artists 1701702416 Y 2023-12-04 16:06:56 0
119707 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBLV62217072 N 119710 Copyright Control Various Artists 1701702420 Y 2023-12-04 16:07:00 0
119708 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2332776 N 119710 Copyright Control Various Artists 1701702422 Y 2023-12-04 16:07:02 0
119709 CheekA88 P A 1 1.69 1 0.000 0 0 0 0.00 0 1702598400 0 Y N N B N R Y N N Y 10 1702598400 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 5054287564484 GBKQU2359459 N 119710 Copyright Control Various Artists 1701702424 Y 2023-12-04 16:07:04 0