When large data can slow down my website, is this the effect of log duplication ?

[gagaltotal]

Is this duplication of data logs the cause? I have tested various queries using Selectraw which are pruned daily and monthly when calculating when this data is a lot, it really affects the slowness of the website and the database in MySQL, because it has accommodated 700K data in 3 years

please help if there is an update for duplicate logs?

example code daily in my helpers :

if (!function_exists('getVisitorToday')) {
    function getVisitorToday()
    {
		$result = DB::table('shetabit_visits')->selectRaw('COUNT(DISTINCT ip) as count, DATE(created_at) as date')
				->groupByRaw('DATE(created_at)')
				->whereDate('created_at', now()->today())
				->first();
		if ($result) {
			return $result->count;
		} else {
			return '';
		}
	}
}

example code monthly in my helpers :

if (!function_exists('getVisitorMonth')) {
    function getVisitorMonth()
    {
		$result = DB::table('shetabit_visits')->selectRaw('COUNT(DISTINCT ip) as count, MONTH(created_at) as month')
				->groupByRaw('MONTH(created_at)')
				->whereYear('created_at', date('Y'))
				->whereMonth('created_at', date('m'))
				->limit('20000')
				->first();
		if ($result) {
			return $result->count;
		} else {
			return '';
		}
	}
}

[gagaltotal]

I made a view query in MySQL and it also didn't affect the speed of the website, because there was too much data from duplicate logs

example query view days :

CREATE VIEW visitor_day_counts AS
SELECT 
    COUNT(DISTINCT ip) as visitor_count,
    DATE(created_at) as visitor_day
FROM 
    shetabit_visits
GROUP BY 
    DATE(created_at);

example query month :

CREATE VIEW visitor_month_counts AS
SELECT 
    COUNT(DISTINCT ip) as visitor_count,
    DATE_FORMAT(created_at,'%Y-%m') AS visitor_month
FROM 
    shetabit_visits
GROUP BY 
    DATE_FORMAT(created_at,'%Y-%m');

[gagaltotal]

SOLVED DUPLICATE LOG :

            $visit = ViewPage::where('ip', $request->ip())->count();
    
            if ($visit >= 1) {
                return view(getTheme('home'));
            }else{
		        visitor()->visit(); // create a visit log
		        return view(getTheme('home'));
        }

File Shetabit/visitor/src/Visitor.php :

    public function visit(Model $model = null)
        {
            if (in_array($this->request->path(), $this->except)) {
                return;
            }
    
            $data = $this->prepareLog();
    
            $existingVisit = Visit::where('ip', $data['ip'])
                ->where('url', $data['url'])
                ->where('device', $data['device'])
                ->where('platform', $data['platform'])
                ->first();
    
            if ($existingVisit) {
                return $existingVisit;
            }
    
            if (null !== $model && method_exists($model, 'visitLogs')) {
                $visit = $model->visitLogs()->create($data);
            } else {
                $visit = Visit::create($data);
            }
    
            return $visit;
        }