SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    507029, 1587021, 359010, 363089, 431485, 
    435102, 673234, 796340, 435126, 291580, 
    2045191, 671448, 2071779, 1080125, 
    1440614, 1302583, 1395208, 1717787, 
    1717796, 410762, 1717795, 1414296, 
    431403, 1395206, 2055664, 2055661, 
    1717793, 1717794, 2077225, 2045209, 
    1414285, 2045210, 2045188, 2045195, 
    2045197, 2089927
  )

Query time 0.00145

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "37.62"
    },
    "table": {
      "table_name": "cscart_products",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 36,
      "rows_produced_per_join": 36,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "34.02",
        "eval_cost": "3.60",
        "prefix_cost": "37.62",
        "data_read_per_join": "157K"
      },
      "used_columns": [
        "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",
        "facebook_obj_type",
        "buy_now_url",
        "stoc_intern",
        "pret_achizitie",
        "pret_revanzator",
        "gestiune"
      ],
      "attached_condition": "(`maniamall_cscart`.`cscart_products`.`product_id` in (507029,1587021,359010,363089,431485,435102,673234,796340,435126,291580,2045191,671448,2071779,1080125,1440614,1302583,1395208,1717787,1717796,410762,1717795,1414296,431403,1395206,2055664,2055661,1717793,1717794,2077225,2045209,1414285,2045210,2045188,2045195,2045197,2089927))"
    }
  }
}

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 facebook_obj_type buy_now_url stoc_intern pret_achizitie pret_revanzator gestiune
291580 ADL-AD 2309 P A 1 0.00 1 0.000 0 0 0 0.00 0 1504092197 1732265892 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity <font color='#29B910'></font> -99 25.06 41.00 Y
359010 APT-AG333A P A 1 0.00 10 0.000 0 0 0 0.00 0 1507879939 1733312621 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity <font color='#29B910'></font> -99 7.00 14.00 Y
363089 APT-AB3A P A 1 0.00 15 0.000 0 0 0 0.00 0 1509008268 1732265892 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} <font color='#29B910'></font> -99 4.71 27.00 Y
410762 TKG-213-XL P A 1 0.00 8 0.000 0 0 0 0.00 0 1519635340 1732044743 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity <font color='#29B910'></font> -99 24.99 27.00 Y
431403 APT-AG269 P A 1 0.00 5 0.000 0 0 0 0.00 0 1521727087 1732044743 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity <font color='#29B910'></font> -99 1.32 3.44 Y
431485 APT-AG37B P A 1 0.00 2 0.000 0 0 0 0.00 0 1521727159 1732044743 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} <font color='#29B910'></font> -99 47.05 81.00 Y
435102 GTL-F2B P A 1 0.00 3 0.000 0 0 0 0.00 0 1522236196 1732044743 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} <font color='#29B910'></font> -99 9.76 21.00 Y
435126 GTL-M8A P A 1 0.00 5 0.000 0 0 0 0.00 0 1522236223 1732044743 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} <font color='#29B910'></font> -99 8.77 31.00 Y
507029 APT-AG635 P A 1 0.00 9 0.000 0 0 0 0.00 0 1537515970 1732044744 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} <font color='#29B910'></font> -99 13.50 31.00 Y
671448 MXY-2568 P A 1 0.00 5 0.000 0 0 0 0.00 0 1554979702 1732044746 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity <font color='#29B910'></font> -99 7.44 25.00 Y
673234 MXY-6957 P A 1 0.00 1 0.000 0 0 0 0.00 0 1555326899 1732044746 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} <font color='#29B910'></font> -99 55.48 91.00 Y
796340 MXY-8558 P A 1 0.00 6 0.000 0 0 0 0.00 0 1570448716 1732044747 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} <font color='#29B910'></font> -99 88.38 106.05 Y
1080125 SPG-FA0099 P A 1 0.00 9 0.000 0 0 0 0.00 0 1580980814 1732044748 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} <font color='#29B910'></font> -99 23.93 28.72 Y
1302583 MXY-1585 P A 1 0.00 23 0.000 0 0 0 0.00 0 1599804641 1716205739 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} <font color='#29B910'></font> -99 1.37 1.65 Y
1395206 GTL-D1 P A 1 0.00 5 0.000 0 0 0 0.00 0 1603785885 1712051979 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity <font color='#29B910'></font> -99 21.73 26.08 Y
1395208 GTL-D1A P A 1 0.00 5 0.000 0 0 0 0.00 0 1603785886 1712051979 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity <font color='#29B910'></font> -99 40.57 48.68 Y
1414285 VRK-14214-albastru P A 1 0.00 3 0.000 0 0 0 0.00 0 1604314101 1605595664 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity <font color='#29B910'></font> -99 23.12 27.74 Y
1414296 VRK-15466 P A 1 0.00 1 0.000 0 0 0 0.00 0 1604314108 1605531119 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity <font color='#29B910'></font> -99 4.12 4.95 Y
1440614 VRK-15341 P A 1 0.00 1 0.000 0 0 0 0.00 0 1606289724 1649231351 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} <font color='#29B910'></font> -99 12.81 15.37 Y
1587021 GTL-D3B P A 1 0.00 10 0.000 0 0 0 0.00 0 1614747028 1712051978 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} <font color='#29B910'></font> -99 62.07 74.48 Y
1717787 MSTR-H2X2-albastru P A 1 0.00 4 0.000 0 0 0 0.00 0 1622198392 1732047163 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} -99 46.96 56.35 Y
1717793 MSTR-H2X0,5-verde P A 1 0.00 2 0.000 0 0 0 0.00 0 1622198397 1732047163 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} -99 15.65 18.78 Y
1717794 MSTR-H2X0,5-gri P A 1 0.00 5 0.000 0 0 0 0.00 0 1622198400 1732047163 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} -99 15.65 18.78 Y
1717795 MSTR-H2X0,5-albastru P A 1 0.00 3 0.000 0 0 0 0.00 0 1622198400 1732047163 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} -99 15.65 18.78 Y
1717796 MSTR-H2X0,5-roz P A 1 0.00 7 0.000 0 0 0 0.00 0 1622198401 1732047163 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} -99 15.65 18.78 Y
2045188 SPG-FA0112 P A 1 0.00 8 0.000 0 0 0 0.00 0 1642157833 1642409675 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity -99 48.30 88.00 Y
2045191 SPG-FA0116 P A 1 0.00 9 0.000 0 0 0 0.00 0 1642157834 1643706099 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity -99 48.30 73.00 Y
2045195 SPG-PB0012 P A 1 0.00 4 0.000 0 0 0 0.00 0 1642157835 1643707998 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity -99 19.03 35.00 Y
2045197 SPG-PB0019 P A 1 0.00 6 0.000 0 0 0 0.00 0 1642157836 1642409674 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity -99 19.32 35.00 Y
2045209 SPG-FA1011 P A 1 0.00 4 0.000 0 0 0 0.00 0 1642157841 1643718570 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity -99 48.82 73.00 Y
2045210 SPG-FA1012 P A 1 0.00 5 0.000 0 0 0 0.00 0 1642157842 1642409675 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity -99 64.24 91.00 Y
2055661 JAN-131000 P A 1 0.00 2 0.000 0 0 0 0.00 0 1643190729 1643202320 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity -99 27.93 60.00 Y
2055664 JAN-131300 P A 1 0.00 1 0.000 0 0 0 0.00 0 1643190733 1643202320 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity -99 51.44 87.00 Y
2071779 SPG-FA5000 P A 1 0.00 1 0.000 0 0 0 0.00 0 1644232546 1644237147 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity -99 38.46 58.00 Y
2077225 MXY-15442 P A 1 0.00 2 0.000 0 0 0 0.00 0 1644910485 1716205739 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity -99 12.39 30.00 Y
2089927 APT-AG125E P A 1 0.00 10 0.000 0 0 0 0.00 0 1646137566 1712575651 0 N N N B N R N N N Y 10 0 N 0 0 0 0 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;} activity -99 4.31 21.00 Y