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, 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.00094

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "9.08"
    },
    "grouping_operation": {
      "using_filesort": false,
      "table": {
        "table_name": "cscart_ab__mb_motivation_item_objects",
        "access_type": "range",
        "possible_keys": [
          "PRIMARY",
          "mid_otype"
        ],
        "key": "mid_otype",
        "used_key_parts": [
          "motivation_item_id",
          "object_type"
        ],
        "key_length": "6",
        "rows_examined_per_scan": 44,
        "rows_produced_per_join": 44,
        "filtered": "100.00",
        "using_index": true,
        "cost_info": {
          "read_cost": "4.68",
          "eval_cost": "4.40",
          "prefix_cost": "9.08",
          "data_read_per_join": "704"
        },
        "used_columns": [
          "motivation_item_id",
          "object_id",
          "object_type"
        ],
        "attached_condition": "((`zdrowy_db`.`cscart_ab__mb_motivation_item_objects`.`motivation_item_id` in (1,2,3,4)) and (`zdrowy_db`.`cscart_ab__mb_motivation_item_objects`.`object_type` in ('C','D','P')))"
      }
    }
  }
}