SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    109483, 109228, 109227, 109167, 109166, 
    108809, 108808, 108807, 108800, 108796, 
    108795, 109600, 108788, 108787, 108779, 
    108778, 108777, 108776, 109363, 109242
  )

Query time 0.00050

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
108776 SD207 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663110000 0 Y N N B N R Y N N Y 10 1663110000 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 5028386720232 GBACW1801352 N Peer Music P.arnold, Neil Hall 1660540506 Y 2022-08-15 06:15:06 0
108777 SD207 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663110000 0 Y N N B N R Y N N Y 10 1663110000 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 5028386720232 GBACW1801353 N Peer Music P.arnold, Neil Hall 1660540506 Y 2022-08-15 06:15:06 0
108778 SD207 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663110000 0 Y N N B N R Y N N Y 10 1663110000 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 5028386720232 GBACW1801354 N Peer Music P.arnold, Neil Hall 1660540506 Y 2022-08-15 06:15:06 0
108779 SD207 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663110000 0 Y N N B N R Y N N Y 10 1663110000 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 5028386720232 GBACW1801355 N Peer Music P.arnold, Neil Hall 1660540506 Y 2022-08-15 06:15:06 0
108787 MOK263 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663196400 0 Y N N B N R Y N N Y 10 1663196400 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 5054286853640 NLLB82200093 N Copyright Control Michiel Greuter 1660626901 Y 2022-08-16 06:15:01 0
108788 MOK263 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663196400 0 Y N N B N R Y N N Y 10 1663196400 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 5054286853640 NLLB82200094 N Copyright Control Michiel Greuter 1660626905 Y 2022-08-16 06:15:05 0
108795 NTWO022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663282800 0 Y N N B N R Y N N Y 10 1663282800 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 5054286668664 GBKQU2247480 N Tidy Publishing Scott Attrill 1664698070 Y 2022-08-17 06:15:01 0
108796 CSD114 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663282800 0 Y N N B N R Y N N Y 10 1663282800 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 5054286850434 GBKQU2275637 N Copyright control Aaron Bradshaw 1664698087 Y 2022-08-17 06:30:02 0
108800 ccm1214 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663282800 0 Y N N B N R Y N N Y 10 1663282800 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 5054286830108 GBKQU2272417 N Hatfish Music Dave Thomas & Sam Thomsitt 1660716902 Y 2022-08-17 07:15:02 0
108807 candy1213 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663282800 0 Y N N B N R Y N N Y 10 1663282800 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 5054286830047 GBKQU2272414 N Hatfish Music David Thomas & Sam Thomsitt 1660717802 Y 2022-08-17 07:30:02 0
108808 A2DR007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663282800 0 Y N N B N R Y N N Y 10 1663282800 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 5054286840107 GBKQU2273923 N Copyright Control Josh McInnes 1660717805 Y 2022-08-17 07:30:05 0
108809 A2DR007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663282800 0 Y N N B N R Y N N Y 10 1663282800 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 5054286840107 GBKQU2273925 N Copyright Control Josh McInnes 1660717806 Y 2022-08-17 07:30:06 0
109166 247HC278 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663282800 0 Y N N B N R Y N N Y 10 1663282800 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 5054286888802 UKT6B2200362 N Copyright Control Robert Cox, Alasdair Taylor, Vicky Fee 1664698101 Y 2022-08-31 06:30:13 0
109167 247HC278 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663282800 0 Y N N B N R Y N N Y 10 1663282800 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 5054286888802 UKT6B2200363 N Copyright Control Robert Cox, Alasdair Taylor, Vicky Fee 1661923814 Y 2022-08-31 06:30:14 0
109227 PANDA030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663282800 0 Y N N B N R Y N N Y 10 1663282800 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 5054286887461 UKT6B2200237 N Aki Bergen Music (PRS-UK) Simone Bocchino 1664698115 Y 2022-08-31 06:45:20 0
109228 PANDA030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663282800 0 Y N N B N R Y N N Y 10 1663282800 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 5054286887461 UKT6B2200344 N Aki Bergen Music (PRS-UK) Simone Bocchino 1661924721 Y 2022-08-31 06:45:21 0
109242 TOKDD19 P A 1 1.69 1 0.000 0 0 0 0.00 0 1662678000 0 Y N N B N R Y N N Y 10 1662678000 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 5054286885801 GBKQU2281049 N Tears of Kunlun Sean Boyle 1662009307 Y 2022-09-01 06:15:07 0
109363 XTR057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1662678000 0 Y N N B N R Y N N Y 10 1662678000 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 5054286896692 GBKQU2282882 N Romain Leyem, Dann Laner, Andriy Ursaki, Mattia Pasini, Emanuele Agostinetto Romain Leyem, Dann Laner 1662228011 Y 2022-09-03 19:00:11 0
109483 EX064 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663282800 0 Y N N B N R Y N N Y 10 1663282800 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 5054286905226 GBKQU2284316 N Exode Records Daniel Edgecombe, Andrew Cavendish, Darren Laxton 1662570901 Y 2022-09-07 18:15:01 0
109600 MMT027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1663196400 0 Y N N B N R Y N N Y 10 1663196400 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 5054286911111 GBKQU2285308 N Jose Francisco Sendra Medina, Andriy Ursaki Jose Francisco Sendra Medina 1663002907 Y 2022-09-12 18:15:07 0