What time trackers do you use?

Question

Time Management

Hello.
tell me time trackers ...
now I use wakatime, but there are problems: when several projects are open in the IDE, or when I debug in the browser or when I cut out from the layout, etc. time for tasks is not taken into account correctly ...
there is some tool, which will hang in the tray, occasionally remind me and show the time of my work, turn itself off when there is no activity at the computer (left for lunch) and something like that ..
Purpose: to collect the time of work is not hemorrhagic for me. (you can also pay)
the fact that vakatime divides time into projects is simply magical and you don’t want to give it up.
Thanks in advance. 

Answer 1

RescueTime - considers everything just perfect, while perfectly categorizing your activity, showing the percentage of distraction, the percentage of effective work.
The program is quite smart, if you just start the IDE and step back for 10 minutes, RescueTime will not count them as effective for you, or rather, it will not count them at all :)
There is a seemingly free version

Answer 2

Do a pre-record check. You don't need to do anything if there is a record. You need to do something if there is no record.

if(mysqli_num_rows($ip) == 0){
     //Записываем в базу
}

Answer 3

In order for the record not to be entered 2 times, there must be unique keys in the table

Answer 4

In order not to do a check every time, you can make the ip key and insert it usingINSERT ... ON DUPLICATE KEY UPDATE

Answer 5

You need to add the Unique key to the fields for which you do not want duplicates. In your case, you can do this:
And make this kind of queries when adding
Thus, the database server, when trying to make a record, rests on a unique key. Because the request will specify the on duplicate key update command; the server will simply update the value in the line. Good luck!