SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    92969, 92968, 92967, 92966, 92964, 92963, 
    92962, 92961, 92960, 92959, 92826, 
    92822, 92812, 92811, 92810, 92809, 
    1644, 92657, 92654, 93172
  )

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
1644 twistedtraxx77 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614297600 0 Y N N B Y R Y N N Y 10 1614297600 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;} TDISC004C N twisted traxx rikrom 1610714585 Y 2021-12-17 17:37:27 0
92654 ST024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613692800 0 Y N N B N R Y N N Y 10 1613692800 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 5054285539897 GBLV62032753 N copyright control Paul Clark 1619644428 Y 2021-12-17 17:37:27 0
92657 BTIDMUSIC085 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613692800 0 Y N N B N R Y N N Y 10 1613692800 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 5054285552902 GBLV62035087 N BTID Music Wigman, Goddard 1629450054 Y 2021-12-17 17:37:27 0
92809 ST025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614297600 0 Y N N B N R Y N N Y 10 1614297600 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 5054285624678 GBKQU2106162 N copyright control UNIT DVSN 1629450056 Y 2021-12-17 17:37:27 0
92810 TIDYBAEP02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614297600 0 Y N N B N R Y N N Y 10 1614297600 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 5054285619490 GBKQU2105142 N Copyright Control Various Artists 1619644351 Y 2021-12-17 17:37:27 0
92811 TIDYBAEP02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614297600 0 Y N N B N R Y N N Y 10 1614297600 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 5054285619490 GBKQU2105143 N Copyright Control Various Artists 1611723902 Y 2021-12-17 17:37:27 0
92812 TIDYBAEP02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614297600 0 Y N N B N R Y N N Y 10 1614297600 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 5054285619490 GBKQU2105144 N Copyright Control Various Artists 1611723903 Y 2021-12-17 17:37:27 0
92822 BTIDMUSIC051 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614297600 0 Y N N B N R Y N N Y 10 1614297600 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 5054285552919 GBLV62035088 N BTID Music Goddard 1619644354 Y 2021-12-17 17:37:27 0
92826 CR008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614297600 0 Y N N B N R Y N N Y 10 1614297600 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 5054285595794 GBKQU2101496 N Copyright Control Steve Riggs, Jay Ainsworth 1619644357 Y 2021-12-17 17:37:27 0
92959 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU1944022 N 93004 Copyright Control Various Artists 1612199708 Y 2021-12-17 17:37:27 0
92960 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU1705482 N 93004 Copyright Control Various Artists 1612199708 Y 2021-12-17 17:37:27 0
92961 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBLV61632046 N 93004 Copyright Control Various Artists 1612199710 Y 2021-12-17 17:37:27 0
92962 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBLV61632031 N 93004 Copyright Control Various Artists 1612199711 Y 2021-12-17 17:37:27 0
92963 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU1140809 N 93004 Copyright Control Various Artists 1612199712 Y 2021-12-17 17:37:27 0
92964 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBLV61632029 N 93004 Copyright Control Various Artists 1612199712 Y 2021-12-17 17:37:27 0
92966 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBLV61632037 N 93004 Copyright Control Various Artists 1612199713 Y 2021-12-17 17:37:27 0
92967 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU1872197 N 93004 Copyright Control Various Artists 1612199713 Y 2021-12-17 17:37:27 0
92968 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBLV61632028 N 93004 Copyright Control Various Artists 1612199713 Y 2021-12-17 17:37:27 0
92969 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU1875275 N 93004 Copyright Control Various Artists 1612199714 Y 2021-12-17 17:37:27 0
93172 DNZF950 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285677643 GBKQU2115171 N DNZ Records Jamie B 1612804203 Y 2021-12-17 17:37:27 0