SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    37261, 37189, 37186, 37157, 58968, 40532, 
    40347, 40346, 40345, 40344, 37060, 
    40530, 40524, 40523, 40522, 40521, 
    40520, 40354, 36734, 36533
  )

Query time 0.00032

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
36533 BS016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1409526000 0 Y N N B N R Y N N Y 10 1409526000 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 5054281186910 GBKQU1449969 N Basic Hard Music Company Jose Acinas 1409558818 Y 2021-12-17 17:37:27 0
36734 HNRS043 P A 1 1.69 1 0.000 0 0 0 0.00 0 1409871600 0 Y N N B N R Y N N Y 10 1409871600 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 5054281278295 GBKQU1469769 N Hardnoise Records Nando CP 1409899540 Y 2021-12-17 17:37:27 0
37060 OMP012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1411081200 0 Y N N B N R Y N N Y 10 1411081200 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 5054281287556 GBKQU1471598 N OMPTraxx James Donnelly & Wain Johnstone 1411722333 Y 2021-12-17 17:37:27 0
37157 ACTD051 P A 1 1.69 1 0.000 0 0 0 0.00 0 1411426800 0 Y N N B N R Y N N Y 10 1411426800 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 5054281318687 GBKQU1478202 N Active Sound Records Kernnel 1410930003 Y 2021-12-17 17:37:27 0
37186 DNZF053 P A 1 1.69 1 0.000 0 0 0 0.00 0 1411426800 0 Y N N B N R Y N N Y 10 1411426800 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 5054281317550 GBKQU1477960 N DNZ Records Dj Akiles 1411722386 Y 2021-12-17 17:37:27 0
37189 dan031mx P A 1 1.69 1 0.000 0 0 0 0.00 0 1411426800 0 Y N N B N R Y N N Y 10 1411426800 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 5054281322967 ES60B1400322 N Squad Music SL Sergio Caurin Balaguer, Jaime Guerrero Zapata, Jose Daniel Sanz Escobedo 1411722417 Y 2021-12-17 17:37:27 0
37261 OMP013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1411686000 0 Y N N B N R Y N N Y 10 1411686000 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 5054281331426 GBKQU1480938 N OMPTraxx Tom Berry & James Donnelly 1411722654 Y 2021-12-17 17:37:27 0
40344 DR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1411081200 0 Y N N B N R Y N N Y 10 1411081200 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 5054281305960 GBKQU1475552 N Dean Fitz Dean Fitz 1422075948 Y 2021-12-17 17:37:27 0
40345 DR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1411081200 0 Y N N B N R Y N N Y 10 1411081200 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 5054281305960 GBKQU1475553 N Dean Fitz Dean Fitz 1422075951 Y 2021-12-17 17:37:27 0
40346 DR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1411081200 0 Y N N B N R Y N N Y 10 1411081200 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 5054281305960 GBKQU1475554 N Dean Fitz Dean Fitz 1422075953 Y 2021-12-17 17:37:27 0
40347 DR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1411081200 0 Y N N B N R Y N N Y 10 1411081200 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 5054281305960 GBKQU1475555 N Dean Fitz Dean Fitz 1422075955 Y 2021-12-17 17:37:27 0
40354 DR005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1409871600 0 Y N N B N R Y N N Y 10 1409871600 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 5054281249356 GBKQU1464066 N Infusion Productionz Infusion Productionz 1422076001 Y 2021-12-17 17:37:27 0
40520 DR006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1409871600 0 Y N N B N R Y N N Y 10 1409871600 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 5054281263888 GBKQU1466884 N Fitzer Fitzer 1422076528 Y 2021-12-17 17:37:27 0
40521 DR006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1409871600 0 Y N N B N R Y N N Y 10 1409871600 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 5054281263888 GBKQU1466885 N Fitzer Fitzer 1422076530 Y 2021-12-17 17:37:27 0
40522 DR006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1409871600 0 Y N N B N R Y N N Y 10 1409871600 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 5054281263888 GBKQU1466886 N Fitzer Fitzer 1422076535 Y 2021-12-17 17:37:27 0
40523 DR006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1409871600 0 Y N N B N R Y N N Y 10 1409871600 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 5054281263888 GBKQU1466887 N Fitzer Fitzer 1422076538 Y 2021-12-17 17:37:27 0
40524 DR007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1410476400 0 Y N N B N R Y N N Y 10 1410476400 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 5054281272460 GBKQU1468583 N Fitzer Fitzer 1422076541 Y 2021-12-17 17:37:27 0
40530 DR008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1410476400 0 Y N N B N R Y N N Y 10 1410476400 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 5054281275119 GBKQU1469139 N Infusion Productionz Infusion Productionz 1422076561 Y 2021-12-17 17:37:27 0
40532 DR010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1411081200 0 Y N N B N R Y N N Y 10 1411081200 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 5054281321007 GBKQU1478880 N Fitzer Fitzer 1422076568 Y 2021-12-17 17:37:27 0
58968 TPS045 P A 1 1.69 1 0.000 0 0 0 0.00 0 1411254000 0 Y N N B N R Y N N Y 10 1411254000 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 5054281379060 GBKQU1492939 N TPS RECORDS Dj manel 1494478812 Y 2021-12-17 17:37:27 0