SELECT 
  cscart_ab__mb_motivation_item_objects.motivation_item_id, 
  cscart_ab__mb_motivation_item_objects.object_type, 
  GROUP_CONCAT(
    cscart_ab__mb_motivation_item_objects.object_id
  ) as object_ids 
FROM 
  cscart_ab__mb_motivation_item_objects 
WHERE 
  1 
  AND cscart_ab__mb_motivation_item_objects.motivation_item_id IN (1, 9, 2, 3, 4) 
  AND cscart_ab__mb_motivation_item_objects.object_type IN ('C', 'D', 'P') 
GROUP BY 
  cscart_ab__mb_motivation_item_objects.motivation_item_id, 
  cscart_ab__mb_motivation_item_objects.object_type

Query time 0.00050

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.00"
    },
    "grouping_operation": {
      "using_filesort": false,
      "table": {
        "table_name": "cscart_ab__mb_motivation_item_objects",
        "access_type": "index",
        "possible_keys": [
          "PRIMARY",
          "mid_otype"
        ],
        "key": "mid_otype",
        "used_key_parts": [
          "motivation_item_id",
          "object_type"
        ],
        "key_length": "6",
        "rows_examined_per_scan": 15,
        "rows_produced_per_join": 4,
        "filtered": "30.00",
        "using_index": true,
        "cost_info": {
          "read_cost": "3.10",
          "eval_cost": "0.90",
          "prefix_cost": "4.00",
          "data_read_per_join": "71"
        },
        "used_columns": [
          "motivation_item_id",
          "object_id",
          "object_type"
        ],
        "attached_condition": "((`eshopuga_upgr_4122`.`cscart_ab__mb_motivation_item_objects`.`motivation_item_id` in (1,9,2,3,4)) and (`eshopuga_upgr_4122`.`cscart_ab__mb_motivation_item_objects`.`object_type` in ('C','D','P')))"
      }
    }
  }
}