SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    10705, 10195, 10670, 9457, 8862, 11485, 
    10960, 10172, 10201, 10945, 397, 10188
  )

Query time 0.00073

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY,product_id_idx PRIMARY 3 12 Using index condition

Result

product_id product_code product_type status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp updated_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 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 shipping_availability_id ms_type master_id unit_price aval_status facebook_obj_type cp_additinal_product_enabled cp_additinal_product_items cp_delivery_date youtube_link show_youtube_video replace_main_image size_chart_id staff_notes emo_pn emo_paczka emo_dostawca emo_kreskowy emo_nrdostawcy emo_uwagi emo_source
397 ODF 87DL A 1 0.00 0.00 0.000 0 0 0 0.00 0 1453193674 1743601021 0 N N N O N R N N N Y 10 0 N 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;} 0 M 0 26 0 activity Y {"485452311":{"product_id":"10711","amount":"1","modifier":"0","modifier_type":"A"},"828798611":{"product_id":"706","amount":"0","modifier":"0","modifier_type":"A"},"1601861446":{"product_id":"717","amount":"0","modifier":"0","modifier_type":"A"},"989859408":{"product_id":"10389","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 25.10.2022 mk price update/akt cen + 6% 0
8862 ODV-GLL-1061 P A 1 0.00 0.00 22.500 0 0 0 0.00 0 1453199170 1744930846 0 N N N O N R N N N Y 10 0 N 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;} 0 M 0 26 0 activity Y {"220132549":{"product_id":"10713","amount":"1","modifier":"0","modifier_type":"A"}} 0 N N 1 mt 2020/11/16 - update kombinacji (dodano kołnierz EDT, wyczyszczono zbędne kombinacje) mt 2020/11/17 - aktualizacja opisu kołnierza (EN)(DE) 0
9457 AAY B1500 A 1 0.00 0.00 0.000 0 0 0 0.00 0 1562069153 1743601006 0 N N N O N R N N N Y 10 0 N 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;} 6 N 0 26 0 activity Y {"1336707857":{"product_id":"10967","amount":"1","modifier":"0","modifier_type":"A"},"1538550662":{"product_id":"9938","amount":"0","modifier":"0","modifier_type":"A"},"1078722597":{"product_id":"9892","amount":"0","modifier":"0","modifier_type":"A"},"777959239":{"product_id":"3320","amount":"0","modifier":"0","modifier_type":"A"},"1580483528":{"product_id":"3325","amount":"0","modifier":"0","modifier_type":"A"},"1795389237":{"product_id":"8295","amount":"0","modifier":"0","modifier_type":"A"},"817974407":{"product_id":"9870","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 01/07/2022 Prices x 1.1 AD 31.10.2023r Kołnierz jako dodatkowy produkt 0
10172 ODV-GLU-0061 P A 1 0.00 0.00 22.500 0 0 0 0.00 0 1491308212 1745783397 0 N N N O N R N N N Y 10 0 N 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;} 0 M 0 26 0 activity Y {"220132549":{"product_id":"10713","amount":"1","modifier":"0","modifier_type":"A"},"1692962521":{"product_id":"3317","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 1 08.01.2024 AD Promocja zostaje na MK06 i 08 28/10/2023 kk Discount, price reduced in combinations by 10% for sizes that we had in stock in stock i.e. FK06, MK06 and MK08 01/10/2023 combinations with flashing deleted. Flashing as additional product. Prices, weights and delivery time updated according to e-cennik 03-2023 kk 2022/04/16 wyrzucono tekst Was ist der Unterschied zwischen den Kategorien der VELUX Dachfenster? Die Unterschiede zwischen den Dachfenster Standard (2-fach Verglasung) sowie Premium (3-fach Verglasung) zu den Dachfenster Luxury von VELUX ist minimal, aber bares Geld wert. Im Großen und Ganzen gibt es Unterschiede in der Verglasung, sowie in der Griffleiste. Die Dämmwerte vergleichbarer Scheibenpakete sind identisch, aber die Dachfenster Luxury (GGL, GGU, GPL, GPU) verfügen im Innenbereich über ein Verbundsicherheitsglas. Dies hat zum einen den Vorteil, falls eine Innenscheibe mal kaputt geht, dass das Verletzungsrisiko minimiert ist, zum anderen sorgt es für etwas höhere Schallisolierung der Fenster. Zudem haben Premium Dachfenster - außer mit Verglasung --50 - eine bessere Widerstandsklasse gegen Einbruch. Der andere Unterschied liegt in der Griffleiste. Während Premium Dachfenster mehr mit einem Griff ausgestattet sind, der eine leichtere Handhabung erlaubt, sind bei Standard/Standard Plus noch die von Velux bekannten Griffleisten montiert. Neben dem optischen Unterschied, sowie der etwas leichteren Bedienung, liegt auch die Leistung der Dauerlüftung bei Premium Dachfenster etwas höher (23-59 m³/h statt 23-50m³/h). Die Unterschiede sind für den täglichen Gebrauch eher zu vernachlässigen, aber dafür bekommt man original Velux Dachfenster zu einem sehr günstigen Preis. 0
10188 ODF 87DF A 1 0.00 0.00 0.000 0 0 0 0.00 0 1500975809 1743601022 0 N N N O N R N N N Y 10 0 N 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;} 0 M 0 26 0 activity Y {"485452311":{"product_id":"10711","amount":"1","modifier":"0","modifier_type":"A"},"1579586812":{"product_id":"709","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 08.07.2022 mk akt zdjęć 18.07.2022 mk aktualizacja treści 25.10.2022 mk price update/akt cen + 16% 0
10195 87DX P A 1 0.00 0.00 0.000 0 0 0 0.00 0 1511514843 1745016023 0 N N N O N R N N N Y 10 0 N 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;} 0 M 0 26 0 activity Y {"1538550662":{"product_id":"9938","amount":"0","modifier":"0","modifier_type":"A"},"1078722597":{"product_id":"9892","amount":"0","modifier":"0","modifier_type":"A"},"1601861446":{"product_id":"717","amount":"0","modifier":"0","modifier_type":"A"},"1068444053":{"product_id":"3322","amount":"0","modifier":"0","modifier_type":"A"},"989859408":{"product_id":"10389","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 Pricelist Update: SEPT 2020 /MT 0
10201 ODF 87DJ P A 1 0.00 0.00 0.000 0 0 0 0.00 0 1520854537 1743601020 0 N N N O N R N N N Y 10 0 N 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;} 0 M 0 26 0 activity Y {"485452311":{"product_id":"10711","amount":"1","modifier":"0","modifier_type":"A"},"828798611":{"product_id":"706","amount":"0","modifier":"0","modifier_type":"A"},"556170291":{"product_id":"4939","amount":"0","modifier":"0","modifier_type":"A"},"1601861446":{"product_id":"717","amount":"0","modifier":"0","modifier_type":"A"},"1897124715":{"product_id":"10104","amount":"0","modifier":"0","modifier_type":"A"},"989859408":{"product_id":"10389","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 08.07.2022 mk akt zdjęć 18.07.2022 mk akt. treści 25.10.2022 mk - price update/akt cen + 6% 0
10670 SKY-OD3 P A 1 0.00 0.00 0.000 0 0 0 0.00 0 1658923922 1743601005 0 N N N O N R N N N Y 10 0 N 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;} 0 N 0 0 0 product Y {"850075394":{"product_id":"10678","amount":"1","modifier":"0","modifier_type":"A"},"99900246":{"product_id":"10701","amount":"0","modifier":"0","modifier_type":"A"},"1538550662":{"product_id":"9938","amount":"0","modifier":"0","modifier_type":"A"},"1078722597":{"product_id":"9892","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
10705 87GC A 1 0.00 0.00 15.000 0 0 0 0.00 0 1682412542 1750421827 0 N N N O N R N N N Y 10 0 N 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;} 0 M 0 26 0 activity Y {"1538550662":{"product_id":"9938","amount":"0","modifier":"0","modifier_type":"A"},"1601861446":{"product_id":"717","amount":"0","modifier":"0","modifier_type":"A"},"1078722597":{"product_id":"9892","amount":"0","modifier":"0","modifier_type":"A"},"1068444053":{"product_id":"3322","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
10945 ODV-GBL-2015 P A 1 0.00 0.00 22.500 0 0 0 0.00 0 1697017421 1743601022 0 N N N O N R N N N Y 10 0 N 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;} 0 M 0 26 0 activity Y {"178116869":{"product_id":"10946","amount":"1","modifier":"0","modifier_type":"A"}} 0 N N 1 AD 11.10.2023 Skończone 0
10960 ODF-87WT A 1 0.00 0.00 0.000 0 0 0 0.00 0 1697790340 1748952145 0 N N N O N R N N N Y 10 0 N 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;} 0 M 0 26 10 activity Y {"1725723642":{"product_id":"11199","amount":"1","modifier":"0","modifier_type":"A"}} 0 N N 0 AD 15.12 Wir arbeiten ganz viel. 0
11485 ODF-87WN A 1 0.00 0.00 0.000 0 0 0 0.00 0 1743666981 1748952156 0 N N N O N R N N N Y 10 0 N 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;} 0 M 0 26 10 activity Y {"1725723642":{"product_id":"11199","amount":"1","modifier":"0","modifier_type":"A"}} 0 N N 0 AD 15.12 Wir arbeiten ganz viel. 0