Laravel eager loading query where 0 = 1

Asked Apr 19 '20 at 19:15

Active Apr 19 '20 at 21:45

Viewed 1,299 times

when I execute this code in Laravel 7.2.0

$news = NewsPost::select('title','slug','category_id', 'image', 'fulltext', 'created_at')->with('category:id,title,slug')->orderBy('created_at', 'desc')->simplePaginate(10);

I have 3 query on the page

select `title`, `slug`, `category_id`, `image`, `fulltext`, `created_at` from `news_posts` where `news_posts`.`deleted_at` is null order by `created_at` desc limit 11 offset 0
select `id`, `title`, `slug` from `news_categories` where `news_categories`.`id` in (2, 4)
select * from `news_categories` where 0 = 1

I cannot understand what is the purpose of last query and what means where 0 = 1

asked Apr 19 '20 at 19:15

schel4ok

May be it's false statement for all time. That's why `where 0 = 1` use – A.A Noman Apr 19 '20 at 19:23
What you mean under "false statement"? – schel4ok Apr 19 '20 at 19:29
Try the following: `php artisan tinker` `DB::enableQueryLog();` `$news = NewsPost::select('title','slug','category_id', 'image', 'fulltext', 'created_at')->with('category:id,title,slug')->orderBy('created_at', 'desc')->simplePaginate(10);` `DB::getQueryLog()` See if that third query `select * from `news_categories` where 0 = 1` shows up. – djunehor Apr 19 '20 at 19:33
yes. it is showing – schel4ok Apr 19 '20 at 19:40
Maybe this one helps you since it can better understand what i mean https://stackoverflow.com/a/6034021/9378077 – AH.Pooladvand Apr 19 '20 at 19:52
not really helped – schel4ok Apr 19 '20 at 20:14
1

See this answer: https://stackoverflow.com/a/30528708/3429323 probably your NewsPost contains a row eothout category, so laravel do this. Don't make sense for me, but reading this answers, you can understand why this happens. – Elias Soares Apr 20 '20 at 00:02
did you find the reason / a solution. I have a similar issue – Gordon Freeman Oct 26 '21 at 17:44
Any news here? @schel4ok – Jan Jan 21 '22 at 10:30

Laravel eager loading query where 0 = 1

0 Answers0