SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    93980, 93981, 93982, 93983, 93984, 93985, 
    93986, 93987, 93988, 93989, 93990, 
    93991, 93992, 93993, 93994, 93995, 
    93996, 93997, 93998, 93999, 94000, 
    94001, 94002, 94003, 94004, 94005, 
    94006, 94007, 94008, 94009, 94010, 
    94011, 94012, 94013, 94014, 94015, 
    94016, 94017, 94018, 94019, 94020, 
    94021, 94022, 94080, 94083, 94084, 
    94086, 94087
  )

Query time 0.00095

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.67"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.87",
        "eval_cost": "4.80",
        "prefix_cost": "21.67",
        "data_read_per_join": "230K"
      },
      "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",
        "parent_product_id",
        "buy_now_url",
        "my_supplier_id",
        "supplier_amount",
        "manufacturer_code",
        "supplier_access_time",
        "rf_stop_update_price",
        "rf_stop_update_amount",
        "rf_stop_update_status",
        "rf_cost"
      ],
      "attached_condition": "(`nuie_scalesta_net`.`cscart_products`.`product_id` in (93980,93981,93982,93983,93984,93985,93986,93987,93988,93989,93990,93991,93992,93993,93994,93995,93996,93997,93998,93999,94000,94001,94002,94003,94004,94005,94006,94007,94008,94009,94010,94011,94012,94013,94014,94015,94016,94017,94018,94019,94020,94021,94022,94080,94083,94084,94086,94087))"
    }
  }
}

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 parent_product_id buy_now_url my_supplier_id supplier_amount manufacturer_code supplier_access_time rf_stop_update_price rf_stop_update_amount rf_stop_update_status rf_cost
93980 SMSLD14BP-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521326 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSLD14BP-E6 1757016007 N N N 0.00
93981 SMSLD15-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521326 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSLD15-E6 1757016007 N N N 0.00
93982 SMSLD16-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521326 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSLD16-E6 1757016007 N N N 0.00
93983 SMSLD17-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521326 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSLD17-E6 1757016007 N N N 0.00
93984 SMSLD17BB-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521327 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSLD17BB-E6 1757016007 N N N 0.00
93985 SMSLD17BP-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521327 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSLD17BP-E6 1757016007 N N N 0.00
93986 SMSP10-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521327 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP10-E6 1757016007 N N N 0.00
93987 SMSP10BB-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521327 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP10BB-E6 1757016007 N N N 0.00
93988 SMSP10BP-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521327 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP10BP-E6 1757016007 N N N 0.00
93989 SMSP70-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521327 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP70-E6 1757016007 N N N 0.00
93990 SMSP70BB-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521327 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP70BB-E6 1757016007 N N N 0.00
93991 SMSP70BP-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521328 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP70BP-E6 1757016007 N N N 0.00
93992 SMSP76-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521328 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP76-E6 1757016007 N N N 0.00
93993 SMSP76BB-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521328 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP76BB-E6 1757016007 N N N 0.00
93994 SMSP76BP-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521328 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP76BP-E6 1757016007 N N N 0.00
93995 SMSP80-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521328 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP80-E6 1757016007 N N N 0.00
93996 SMSP80BB-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521329 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP80BB-E6 1757016007 N N N 0.00
93997 SMSP80BP-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521329 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP80BP-E6 1757016007 N N N 0.00
93998 SMSP90-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521329 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP90-E6 1757016007 N N N 0.00
93999 SMSP90BB-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521329 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP90BB-E6 1757016007 N N N 0.00
94000 SMSP90BP-E6 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521329 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SMSP90BP-E6 1757016007 N N N 0.00
94001 SQBD76-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521330 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQBD76-E5 1757016007 N N N 0.00
94002 SQBD80-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521330 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQBD80-E5 1757016007 N N N 0.00
94003 SQBD90-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521330 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQBD90-E5 1757016007 N N N 0.00
94004 SQCE7676-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521330 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQCE7676-E5 1757016007 N N N 0.00
94005 SQCE8080-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521330 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQCE8080-E5 1757016007 N N N 0.00
94006 SQPD70-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521331 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQPD70-E5 1757016007 N N N 0.00
94007 SQPD76-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521331 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQPD76-E5 1757016007 N N N 0.00
94008 SQPD80-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521332 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQPD80-E5 1757016007 N N N 0.00
94009 SQPD90-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521333 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQPD90-E5 1757016007 N N N 0.00
94010 SQSL10-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521333 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQSL10-E5 1757016007 N N N 0.00
94011 SQSL12-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521333 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQSL12-E5 1757016007 N N N 0.00
94012 SQSP70 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521333 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQSP70 1757016007 N N N 0.00
94013 SQSP70-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521333 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQSP70-E5 1757016007 N N N 0.00
94014 SQSP76-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521333 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQSP76-E5 1757016007 N N N 0.00
94015 SQSP80-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521334 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQSP80-E5 1757016007 N N N 0.00
94016 SQSP90-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521334 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQSP90-E5 1757016007 N N N 0.00
94017 SQU108-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521334 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQU108-E5 1757016007 N N N 0.00
94018 SQU128-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521334 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQU128-E5 1757016007 N N N 0.00
94019 SQU129-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521334 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQU129-E5 1757016007 N N N 0.00
94020 SQU7-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521334 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQU7-E5 1757016007 N N N 0.00
94021 SQU8-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521335 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQU8-E5 1757016007 N N N 0.00
94022 SQU9-E5 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521335 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 SQU9-E5 1757016007 N N N 0.00
94080 WRFL18510GM P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521348 1788033605 0 N N N N N N N Y 10 0 N N 0 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 1 0 WRFL18510GM 1788033605 N N N 0.00
94083 WRFL18530GM P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521349 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 WRFL18530GM 1757016007 N N N 0.00
94084 WRFL18530GMHC P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521349 1757016007 0 N N N N N N N Y 10 0 N N 0 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 1 0 WRFL18530GMHC 1757016007 N N N 0.00
94086 WRFL18580GM P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521349 1788033605 0 N N N N N N N Y 10 0 N N 0 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 1 0 WRFL18580GM 1788033605 N N N 0.00
94087 WRFL18590GM P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521349 1788033605 0 N N N N N N N Y 10 0 N N 0 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 1 0 WRFL18590GM 1788033605 N N N 0.00