SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    480519, 524885, 697773, 866373, 1118377, 
    697683, 612103, 880671, 1434961, 694679, 
    822677, 614913, 301401, 822659, 613219, 
    613221, 1025388, 822679, 1025367, 
    1025365, 1230911, 1338749, 1731846, 
    1732251, 359020, 1153153, 1153155, 
    1338924, 1231165, 1731742, 1732158, 
    1231166, 1732357, 1153734, 1732013, 
    1663556
  )

Query time 0.10046

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "42.53"
    },
    "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": "38.93",
        "eval_cost": "3.60",
        "prefix_cost": "42.53",
        "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 (480519,524885,697773,866373,1118377,697683,612103,880671,1434961,694679,822677,614913,301401,822659,613219,613221,1025388,822679,1025367,1025365,1230911,1338749,1731846,1732251,359020,1153153,1153155,1338924,1231165,1731742,1732158,1231166,1732357,1153734,1732013,1663556))"
    }
  }
}

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
301401 APT-AG596 P A 1 0.00 5 0.000 0 0 0 0.00 0 1505217239 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 7.86 25.00 Y
359020 APT-AG273B P A 1 0.00 3 0.000 0 0 0 0.00 0 1507879950 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 8.00 27.00 Y
480519 APT-AG538 P A 1 0.00 2 0.000 0 0 0 0.00 0 1531218911 1732044744 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 17.10 44.00 Y
524885 BLW-4866 P A 1 0.00 1 0.000 0 0 0 0.00 0 1540378868 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 7.12 16.00 Y
612103 MRA33-090818-3 P A 1 0.00 1 0.000 0 0 0 0.00 0 1549913108 1732129721 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 28.80 0.00 Y
613219 MRA33-170817-7 P A 1 0.00 1 0.000 0 0 0 0.00 0 1549914075 1581000975 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 54.55 0.00 N
613221 MRA33-170817-6 P A 1 0.00 1 0.000 0 0 0 0.00 0 1549914077 1581000976 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 70.00 0.00 N
614913 MRA33-TCT-4473 P A 1 0.00 2 0.000 0 0 0 0.00 0 1549915488 1581000979 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 5.00 0.00 N
694679 MRA33-260319-1 P A 1 0.00 1 0.000 0 0 0 0.00 0 1558973523 1581001082 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 25.45 0.00 N
697683 MRA33-TCT-2927 P A 1 0.00 2 0.000 0 0 0 0.00 0 1559139226 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 2.26 0.00 Y
697773 MRA33-TCT-2589 P A 1 0.00 1 0.000 0 0 0 0.00 0 1559139385 1614174127 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 14.09 0.00 Y
822659 BLW-4859 P A 1 0.00 8 0.000 0 0 0 0.00 0 1572351777 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 7.31 8.77 Y
822677 BLW-75-739 P A 1 0.00 2 0.000 0 0 0 0.00 0 1572351795 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 20.71 26.25 Y
822679 BLW-8933 P A 1 0.00 1 0.000 0 0 0 0.00 0 1572351797 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 5.26 6.31 Y
866373 AMO-02160 P A 1 0.00 2 0.000 0 0 0 0.00 0 1573474933 1732044747 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 56.78 68.13 Y
880671 AMO-01706 P A 1 0.00 1 0.000 0 0 0 0.00 0 1574334650 1574335584 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.34 10.01 Y
1025365 MTO-BSP0758 P A 1 0.00 1 0.000 0 0 0 0.00 0 1579303774 1665485308 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 0.00 0.00 Y
1025367 MTO-BSP0763 P A 1 0.00 14 0.000 0 0 0 0.00 0 1579303774 1665485309 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 0.00 0.00 Y
1025388 MTO-R50033.2 P A 1 0.00 9 0.000 0 0 0 0.00 0 1579303777 1665485312 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 0.00 0.00 Y
1118377 MXY-4077 P A 1 0.00 3 0.000 0 0 0 0.00 0 1584357636 1716205740 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.00 19.19 Y
1153153 BLW-2974 P A 1 0.00 1 0.000 0 0 0 0.00 0 1589787251 1713961975 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.73 2.07 Y
1153155 BLW-2969 P A 1 0.00 3 0.000 0 0 0 0.00 0 1589787252 1713961974 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 3.11 3.73 Y
1153734 GBZ-55779 P A 1 0.00 1 0.000 0 0 0 0.00 0 1589971484 1590038973 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 0.00 9.00 N
1230911 MXY-10848 P A 1 0.00 2 0.000 0 0 0 0.00 0 1595827251 1716205786 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 32.07 38.48 Y
1231165 MFER-GF-0179 P A 1 0.00 3 0.000 0 0 0 0.00 0 1595847092 1665484886 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 0.00 0.00 Y
1231166 MFER-GF-0180 P A 1 0.00 4 0.000 0 0 0 0.00 0 1595847092 1665484886 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 0.00 0.00 Y
1338749 MRA33-250920-6 P A 1 0.00 1 0.000 0 0 0 0.00 0 1602740853 1732043142 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 160.00 202.00 N
1338924 MRA33-100720-8 P A 1 0.00 1 0.000 0 0 0 0.00 0 1602740927 1732043142 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 40.00 62.00 N
1434961 MXY-12035 P A 1 0.00 20 0.000 0 0 0 0.00 0 1605175229 1732092411 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.05 1.18 Y
1663556 CRD-GLOFCC091 P A 1 0.00 1 0.000 0 0 0 0.00 0 1618246118 1732037292 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 0.00 0.00 N
1731742 MRA33-150621-4 P A 1 0.00 3 0.000 0 0 0 0.00 0 1624014515 1624014515 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 4.09 0.00 Y
1731846 MRA33-040621-19 P A 1 0.00 1 0.000 0 0 0 0.00 0 1624014569 1683891194 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 150.00 0.00 Y
1732013 MRA33-120421-1 P A 1 0.00 1 0.000 0 0 0 0.00 0 1624014659 1624014659 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 63.64 0.00 Y
1732158 MRA33-220221-10 P A 1 0.00 1 0.000 0 0 0 0.00 0 1624014746 1732091974 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 250.00 0.00 Y
1732251 MRA33-270121-2 P A 1 0.00 2 0.000 0 0 0 0.00 0 1624014798 1666349973 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.45 0.00 N
1732357 MRA33-041220-1 P A 1 0.00 1 0.000 0 0 0 0.00 0 1624014859 1624014859 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 40.00 0.00 Y