Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
When I use
$project = Project::select(['id', 'subdomain'])
->where([
'subdomain' => $subdomain,
'published' => true
])
->first();
instead of $project = Project::where('subdomain', $subdomain)->where('published', true)->first(); (causing select *... ) and I check things in debug bar the query execution does not seem to change much at all.
I know the localhost database is small so perhaps 1.8-2.2ms per query won't fluctuate much.. but still I expected more. Any ideas if my select usage approach to optimize here is the right one?
It’s certainly cleaner to only get the columns you need, but on the query you are doing you won’t see much difference in performance (as you are finding out).
It your table had more columns in it, you might see a little more variation.
If you want to check performance, you could try seeding 10000 rows and then rerunning your tests.
I would also put an index on published if you haven't already.
Indexed several columns already. Not the published column. Will have to look into it. Indexing all or almost all in one table might not be efficient either. Not an expert yet by far though so open for all suggestions and appreciate yours yet again.
You are correct that too many indexes might slow things down. However indexes that can only have two values will improve the speed, unless of course you don't have any unpublished posts,
Use cache as well
Thanks. Looking into using Cache as well. Just not sure who to tag request like the one I have yet. Once for trying to grab cache, if not load data and add to cache. But how to make the first query to do a $john = Cache::tags(['people', 'artists'])->get('John'); of sorts for this project query I am not certain of yet.
It should be something like this
$project = Cache::remember("project.{$subdomain}", now()->addHours(12), function () use ($subdomain) {
return Project::where('subdomain', $subdomain)->where('published', true)->first();
});
Added
$project = Cache::remember("subdomain.{$subdomain}", now()->addHours(12), function () use ($subdomain) {
return Project::select(['id', 'subdomain'])
->where([
'subdomain' => $subdomain,
'published' => true
])
->first();
});
and it works well. Thanks a lot for @michaloravec . Making headway here!
NB Need to understand where use here comes from still. But looking into that.
use is bringing $subdomain into the scope of the closure.
@rhand You need to use it to inherit a variable from parent scope
Thanks @lemmon and @michaloravec . The bringing into scope of $subdomain using use makes sense here. So did example #3 at https://www.php.net/manual/en/functions.anonymous.php to be able to use variables in the anonymous function or closure.
Please or to participate in this conversation.