kima

Laravel allows you to configure a separate read DB connection - replicate of your main DB only for reading operations, to distribute the load.

Replica databases may have a little delay, so in some cases when you just created a Model and immediately retrieving it, you may not find it, and should query from the write connection

I guess its a PDO behavior.

how many sleep lines you see in the processlist, against how many PHP processes do you have?

you may listen to the KeyWritten and KeyForgotten events, and save the key you received in the event in a dedicated "all_cached_keys" key.

notice to exclude the "all_cached_keys" key so you don't create an infinity loop :)

dont change the collections, just change how you print the table:

		Table 
@foreach ($shops as $shop)

	
	@foreach($shop->products as $product)
-New <tr>-

{{$shop->name}}	
-More product details-
{{$product->pivot->qty}}

-End </tr>-
	@endforeach

@endforeach

		End Table

dont change the collections, just change how you print the table:

		Table 
@foreach ($shops as $shop)

	
	@foreach($shop->products as $product)
-New <tr>-

{{$shop->name}}	
-More product details-
{{$product->pivot->qty}}

-End </tr>-
	@endforeach

@endforeach

		End Table

You can use the ide-helper:model command to generate class annotations including the actual columns, then use reflection class to get them in runtime.

    protected static $columns;
    
    public function scopeSelectWithout($query, $withoutColumns)
    {
        if (!static::$columns) {
            $rc = new \ReflectionClass(static::class);
            
            static::$columns = collect(explode("\n", $rc->getDocComment()))
                ->filter(fn($columnLine) => Str::startsWith($columnLine, ' * @property '))
                ->map(function ($columnLine) {
                    $columnLine = explode(' ', $columnLine);
                    return str_replace('$', '', array_pop($columnLine));
                });
        }
        
        $query->select(array_diff(static::$columns, $withoutColumns));
        
        return $query;
    }

$this->faker->file is a call to a function that copies a file from a directory to another. it should be used as $this->faker->file($sourceDirectory = '/tmp', $targetDirectory = '/tmp', $fullPath = true)

from the code example, it looks like it's not what you are trying to accomplish