SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    95818, 95817, 95816, 95815, 95814, 95813, 
    95812, 95811, 95810, 95809, 95808, 
    95807, 95806, 95805, 95804, 95803, 
    95874, 95867, 95638, 95637
  )

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 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
95637 PTR163 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620946800 0 Y N N B N R Y N N Y 10 1620946800 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 5054285882665 GBKQU2151520 N Power Tracks Records DJ Ivan Diaz 1620148802 Y 2021-12-17 17:37:27 0
95638 PTR163 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620946800 0 Y N N B N R Y N N Y 10 1620946800 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 5054285882665 GBKQU2151521 N Power Tracks Records DJ Ivan Diaz 1620148802 Y 2021-12-17 17:37:27 0
95803 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153401 N 95833 Copyright Control Various Artists 1620407406 Y 2021-12-17 17:37:27 0
95804 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153402 N 95833 Copyright Control Various Artists 1620407406 Y 2021-12-17 17:37:27 0
95805 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153403 N 95833 Copyright Control Various Artists 1620407407 Y 2021-12-17 17:37:27 0
95806 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153404 N 95833 Copyright Control Various Artists 1620407409 Y 2021-12-17 17:37:27 0
95807 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153405 N 95833 Copyright Control Various Artists 1646418503 Y 2021-12-17 17:37:27 0
95808 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153406 N 95833 Copyright Control Various Artists 1698085586 Y 2021-12-17 17:37:27 0
95809 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153407 N 95833 Copyright Control Various Artists 1620407413 Y 2021-12-17 17:37:27 0
95810 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153408 N 95833 Copyright Control Various Artists 1620407416 Y 2021-12-17 17:37:27 0
95811 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153409 N 95833 Copyright Control Various Artists 1620407416 Y 2021-12-17 17:37:27 0
95812 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153410 N 95833 Copyright Control Various Artists 1620407419 Y 2021-12-17 17:37:27 0
95813 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153411 N 95833 Copyright Control Various Artists 1620407420 Y 2021-12-17 17:37:27 0
95814 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153412 N 95833 Copyright Control Various Artists 1620407420 Y 2021-12-17 17:37:27 0
95815 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153413 N 95833 Copyright Control Various Artists 1620407420 Y 2021-12-17 17:37:27 0
95816 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153414 N 95833 Copyright Control Various Artists 1620407421 Y 2021-12-17 17:37:27 0
95817 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153415 N 95833 Copyright Control Various Artists 1620407421 Y 2021-12-17 17:37:27 0
95818 HDCSHD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 5054285893166 GBKQU2153417 N 95833 Copyright Control Various Artists 1620407423 Y 2021-12-17 17:37:27 0
95867 PTR166 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620946800 0 Y N N B N R Y N N Y 10 1620946800 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 5054285900901 GBKQU2154825 N Power Tracks Records Jaime Guerrero 1620666301 Y 2021-12-17 17:37:27 0
95874 DNZF1002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621206000 0 Y N N B N R Y N N Y 10 1621206000 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 5054285902295 GBKQU2154966 N DNZ Records Garbie Project 1620668101 Y 2021-12-17 17:37:27 0