Noticed this query is execute some times within a day as part of a tracking request: SELECT option_name, option_value FROM option WHERE option_name LIKE ?.

Output:

'2019-03-31'
'UTC'
1554066533'
2019-04-01'
1554076800  
1554076800

Stacktrace:

#0 Piwik\Option->getNameLike(report_to_invalidate_1_2019-03-31%) called at [/var/www/html/core/Option.php:58] #1 Piwik\Option::getLike(report_to_invalidate_1_2019-03-31%) called at [/var/www/html/core/Archive/ArchiveInvalidator.php:70] #2 Piwik\Archive\ArchiveInvalidator->rememberToInvalidateArchivedReportsLater(1, Piwik\Date Object ([*timestamp] => 1554066319,[*timezone] => UTC)) called at [/var/www/html/core/Tracker/Visit.php:561] #3 Piwik\Tracker\Visit->markArchivedReportsAsInvalidIfArchiveAlreadyFinished() called at [/var/www/html/core/Tracker/Visit.php:193] #4 Piwik\Tracker\Visit->handle() called at [/var/www/html/core/Tracker.php:138] #5

Seems isToday is not quite correctly detected here.

timezone of the website is New York: