{"id":3261,"date":"2025-03-24T08:46:34","date_gmt":"2025-03-23T23:46:34","guid":{"rendered":"https:\/\/dexall.co.jp\/articles\/?p=3261"},"modified":"2025-03-24T08:47:05","modified_gmt":"2025-03-23T23:47:05","slug":"%e3%80%90laravel%e5%85%a5%e9%96%80%e3%80%91where%e3%83%a1%e3%82%bd%e3%83%83%e3%83%89%e5%ae%8c%e5%85%a8%e8%a7%a3%e8%aa%ac%ef%bc%81%e5%ae%9f%e8%b7%b5%e7%9a%84%e3%81%aa12%e3%81%ae%e3%83%86%e3%82%af","status":"publish","type":"post","link":"https:\/\/dexall.co.jp\/articles\/?p=3261","title":{"rendered":"\u3010Laravel\u5165\u9580\u3011where\u30e1\u30bd\u30c3\u30c9\u5b8c\u5168\u89e3\u8aac\uff01\u5b9f\u8df5\u7684\u306a12\u306e\u30c6\u30af\u30cb\u30c3\u30af\u3068\u6700\u9069\u5316\u306e\u30b3\u30c4"},"content":{"rendered":"\n<div class=\"toc\"><br \/>\n<b>Warning<\/b>:  Undefined array key \"is_admin\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>116<\/b><br \/>\n<br \/>\n<b>Warning<\/b>:  Undefined array key \"is_category_top\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>121<\/b><br \/>\n<br \/>\n<b>Warning<\/b>:  Undefined array key \"is_top\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>128<\/b><br \/>\n    <div id=\"toc_container\" class=\"sgb-toc--bullets js-smooth-scroll\" data-dialog-title=\"\u76ee\u6b21\">\n      <p class=\"toc_title\">\u76ee\u6b21 <\/p>\n      <ul class=\"toc_list\">  <li class=\"first\">    <a href=\"#i-0\">where\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u790e\u7684\u306a\u77e5\u8b58<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-1\">where\u30e1\u30bd\u30c3\u30c9\u3068\u306f\u4f55\u304b\uff1a\u57fa\u672c\u7684\u306a\u6a5f\u80fd\u3068\u5f79\u5272<\/a>      <\/li>      <li>        <a href=\"#i-2\">where\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u672c\u7684\u306a\u69cb\u6587\u3068\u4f7f\u3044\u65b9<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-3\">Eloquent\u30e2\u30c7\u30eb\u306ewhere\u30e1\u30bd\u30c3\u30c9\u306e\u96c6\u4e2d<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-4\">where\u30e1\u30bd\u30c3\u30c9\u306e\u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u65b9\u6cd5<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-5\">\u7b49\u6761\u4ef6\u3067\u306e\u7d5e\u308a\u8fbc\u307f\u691c\u7d22\u306e\u653b\u7565\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-6\">\u8907\u6570\u6761\u4ef6\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u9ad8\u5ea6\u306a\u691c\u7d22\u306e\u5b9f\u73fe<\/a>      <\/li>      <li>        <a href=\"#i-7\">\u65e5\u4ed8\u7bc4\u56f2\u3067\u306e\u691c\u7d22\u306b\u304a\u3051\u308bwhere\u306e\u6d3b\u7528<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-8\">NULL\u5024\u306e\u4f7f\u3044\u65b9\u3068whereNull\u306e\u4f7f\u7528\u30b7\u30fc\u30f3<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-9\">where\u30e1\u30bd\u30c3\u30c9\u306e\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-10\">\u30b5\u30d6\u30af\u30a8\u30ea\u3092\u4f7f\u7528\u3057\u305f\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u53d6\u5f97<\/a>      <\/li>      <li>        <a href=\"#i-11\">whereHas\u3092\u4f7f\u7528\u3057\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30c7\u30fc\u30bf\u691c\u7d22<\/a>      <\/li>      <li>        <a href=\"#i-12\">whereJsonContains \u3067\u306e JSON \u578b\u30ab\u30e9\u30e0\u306e\u691c\u7d22<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-13\">\u52d5\u7684\u306awhere\u53e5\u306e\u69cb\u7bc9\u3068\u30b9\u30b3\u30fc\u30d7\u306e\u6d3b\u7528<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-14\">where\u30e1\u30bd\u30c3\u30c9\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-15\">\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u8003\u616e\u3057\u305fwhere\u53e5\u306e\u8a2d\u8a08<\/a>      <\/li>      <li>        <a href=\"#i-16\">N+1\u554f\u984c\u3092\u9632\u3050\u305f\u3081\u306ewith\u3068where\u306e\u4f75\u7528<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-17\">\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u3067\u306ewhere\u30e1\u30bd\u30c3\u30c9\u306e\u52b9\u7387\u7684\u306a\u4f7f\u7528\u6cd5<\/a>      <\/li>    <\/ul>  <\/li>  <li class=\"last\">    <a href=\"#i-18\">where\u30e1\u30bd\u30c3\u30c9\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u3068\u3088\u304f\u3042\u308b\u9593\u9055\u3044<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-19\">\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3092\u8003\u616e\u3057\u305fwhere\u306e\u4f7f\u7528\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-20\">\u30c6\u30b9\u30c8\u3057\u3084\u3059\u3044where\u306e\u66f8\u304d\u65b9<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-21\">\u4fdd\u5b88\u6027\u3092\u9ad8\u3081\u308b\u305f\u3081\u306ewhere\u30e1\u30bd\u30c3\u30c9\u306e\u8a2d\u8a08\u539f\u5247<\/a>      <\/li>    <\/ul>  <\/li><\/ul>\n      <a href=\"#\" class=\"sgb-toc-button js-toc-button\" rel=\"nofollow\" data-open-dialog=\"true\"><i class=\"fa fa-list\"><\/i><span class=\"sgb-toc-button__text\">\u76ee\u6b21\u3078<\/span><\/a>\n    <\/div><\/div><h2 class=\"wp-block-heading\" id=\"i-0\">where\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u790e\u7684\u306a\u77e5\u8b58<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-1\">where\u30e1\u30bd\u30c3\u30c9\u3068\u306f\u4f55\u304b\uff1a\u57fa\u672c\u7684\u306a\u6a5f\u80fd\u3068\u5f79\u5272<\/h3>\n\n\n\n<p>Laravel\u306e<code>where<\/code>\u30e1\u30bd\u30c3\u30c9\u306f\u3001Eloquent ORM\u304a\u3088\u3073\u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u30fc\u306e\u4e2d\u6838\u3092\u306a\u3059\u6a5f\u80fd\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u306e\u30ec\u30b3\u30fc\u30c9\u53d6\u5f97\u6642\u306b\u6761\u4ef6\u3092\u6307\u5b9a\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002\u3053\u306e\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001SQL\u306e<code>WHERE<\/code>\u53e5\u306b\u76f8\u5f53\u3059\u308b\u6761\u4ef6\u3092\u30a8\u30ec\u30ac\u30f3\u30c8\u306b\u8a18\u8ff0\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4e3b\u306a\u7279\u5fb4\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u76f4\u611f\u7684\u306a\u30e1\u30bd\u30c3\u30c9\u30c1\u30a7\u30fc\u30f3\u69cb\u6587<\/li>\n\n\n\n<li>SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56\u6e08\u307f<\/li>\n\n\n\n<li>\u52d5\u7684\u306a\u6761\u4ef6\u69cb\u7bc9\u304c\u53ef\u80fd<\/li>\n\n\n\n<li>\u8907\u6570\u306e\u6761\u4ef6\u3092\u67d4\u8edf\u306b\u7d44\u307f\u5408\u308f\u305b\u53ef\u80fd<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-2\">where\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u672c\u7684\u306a\u69cb\u6587\u3068\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>where\u30e1\u30bd\u30c3\u30c9\u306f\u4ee5\u4e0b\u306e3\u3064\u306e\u57fa\u672c\u7684\u306a\u4f7f\u7528\u30d1\u30bf\u30fc\u30f3\u3092\u6301\u3063\u3066\u3044\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u57fa\u672c\u7684\u306a\u7b49\u4fa1\u6761\u4ef6\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u5358\u4e00\u306e\u6761\u4ef6\n$users = DB::table('users')\n    -&gt;where('status', 'active')\n    -&gt;get();\n\n\/\/ \u8907\u6570\u306e\u6761\u4ef6\u3092\u30c1\u30a7\u30fc\u30f3\n$users = DB::table('users')\n    -&gt;where('status', 'active')\n    -&gt;where('age', '&gt;=', 18)\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u914d\u5217\u3092\u4f7f\u7528\u3057\u305f\u8907\u6570\u6761\u4ef6\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8907\u6570\u6761\u4ef6\u3092\u914d\u5217\u3067\u6307\u5b9a\n$users = DB::table('users')\n    -&gt;where([\n        ['status', 'active'],\n        ['age', '&gt;=', 18]\n    ])\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>\u30af\u30ed\u30fc\u30b8\u30e3\u3092\u4f7f\u7528\u3057\u305f\u6761\u4ef6\u30b0\u30eb\u30fc\u30d7\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u6761\u4ef6\u306e\u30b0\u30eb\u30fc\u30d7\u5316\n$users = DB::table('users')\n    -&gt;where(function($query) {\n        $query-&gt;where('status', 'active')\n              -&gt;orWhere('status', 'pending');\n    })\n    -&gt;where('age', '&gt;=', 18)\n    -&gt;get();<\/pre>\n\n\n\n<p>\u6bd4\u8f03\u6f14\u7b97\u5b50\u306f\u4ee5\u4e0b\u306e\u3082\u306e\u304c\u4f7f\u7528\u53ef\u80fd\u3067\u3059\uff1a<\/p>\n\n\n<div id=\"id-0f1a82ce-feb2-4ecd-88a6-f21c5f022501\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u6f14\u7b97\u5b50<\/th><th>\u8aac\u660e<\/th><\/tr><\/thead><tbody><tr><td>=<\/td><td>\u7b49\u3057\u3044<\/td><\/tr><tr><td>&gt;<\/td><td>\u3088\u308a\u5927\u304d\u3044<\/td><\/tr><tr><td>&gt;=<\/td><td>\u4ee5\u4e0a<\/td><\/tr><tr><td>&lt;<\/td><td>\u3088\u308a\u5c0f\u3055\u3044<\/td><\/tr><tr><td>&lt;=<\/td><td>\u4ee5\u4e0b<\/td><\/tr><tr><td>&lt;&gt; or !=<\/td><td>\u7b49\u3057\u304f\u306a\u3044<\/td><\/tr><tr><td>like<\/td><td>\u30d1\u30bf\u30fc\u30f3\u30de\u30c3\u30c1\u30f3\u30b0<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-3\">Eloquent\u30e2\u30c7\u30eb\u306ewhere\u30e1\u30bd\u30c3\u30c9\u306e\u96c6\u4e2d<\/h3>\n\n\n\n<p>Eloquent\u30e2\u30c7\u30eb\u3067\u306f\u3001where\u30e1\u30bd\u30c3\u30c9\u3092\u3055\u3089\u306b\u52b9\u679c\u7684\u306b\u6d3b\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30e2\u30c7\u30eb\u3067\u306e\u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b\nclass User extends Model\n{\n    \/\/ \u30b9\u30b3\u30fc\u30d7\u3092\u4f7f\u7528\u3057\u305f\u5171\u901a\u6761\u4ef6\u306e\u5b9a\u7fa9\n    public function scopeActive($query)\n    {\n        return $query-&gt;where('status', 'active');\n    }\n}\n\n\/\/ \u30b9\u30b3\u30fc\u30d7\u306e\u4f7f\u7528\n$activeUsers = User::active()-&gt;get();<\/pre>\n\n\n\n<p>Eloquent\u30e2\u30c7\u30eb\u306a\u3089\u3067\u306f\u306e\u7279\u5fb4\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3068\u306e\u9023\u643a\u304c\u5bb9\u6613<\/li>\n\n\n\n<li>\u30ed\u30fc\u30ab\u30eb\u30b9\u30b3\u30fc\u30d7\u306b\u3088\u308b\u6761\u4ef6\u306e\u518d\u5229\u7528<\/li>\n\n\n\n<li>\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30b3\u30fc\u30d7\u306b\u3088\u308b\u81ea\u52d5\u7684\u306a\u6761\u4ef6\u9069\u7528<\/li>\n\n\n\n<li>\u30e2\u30c7\u30eb\u30a4\u30d9\u30f3\u30c8\u3068\u306e\u9023\u643a<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3067\u306e\u4f7f\u7528\u4f8b\nclass User extends Model\n{\n    public function activeOrders()\n    {\n        return $this-&gt;hasMany(Order::class)\n                    -&gt;where('status', 'active');\n    }\n}<\/pre>\n\n\n\n<p>where\u30e1\u30bd\u30c3\u30c9\u306f\u5358\u7d14\u306a\u7b49\u4fa1\u6bd4\u8f03\u304b\u3089\u8907\u96d1\u306a\u6761\u4ef6\u307e\u3067\u3001\u69d8\u3005\u306a\u30b1\u30fc\u30b9\u306b\u5bfe\u5fdc\u3067\u304d\u308b\u67d4\u8edf\u6027\u3092\u5099\u3048\u3066\u3044\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u3053\u308c\u3089\u306e\u57fa\u672c\u77e5\u8b58\u3092\u6d3b\u7528\u3057\u305f\u3001\u3088\u308a\u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u65b9\u6cd5\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-4\">where\u30e1\u30bd\u30c3\u30c9\u306e\u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u65b9\u6cd5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-5\">\u7b49\u6761\u4ef6\u3067\u306e\u7d5e\u308a\u8fbc\u307f\u691c\u7d22\u306e\u653b\u7565\u65b9\u6cd5<\/h3>\n\n\n\n<p>\u7b49\u6761\u4ef6\u3067\u306e\u691c\u7d22\u306f\u6700\u3082\u4e00\u822c\u7684\u306a\u4f7f\u7528\u30d1\u30bf\u30fc\u30f3\u3067\u3059\u304c\u3001\u52b9\u679c\u7684\u306b\u6d3b\u7528\u3059\u308b\u305f\u3081\u306b\u306f\u3044\u304f\u3064\u304b\u306e\u30c6\u30af\u30cb\u30c3\u30af\u304c\u3042\u308a\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5358\u4e00\u30ab\u30e9\u30e0\u306e\u5b8c\u5168\u4e00\u81f4\u691c\u7d22\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u57fa\u672c\u7684\u306a\u7b49\u4fa1\u691c\u7d22\n$users = User::where('status', 'active')-&gt;get();\n\n\/\/ whereEqual\u3092\u4f7f\u7528\u3057\u305f\u660e\u793a\u7684\u306a\u7b49\u4fa1\u691c\u7d22\n$users = User::whereEqual('status', 'active')-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u8907\u6570\u5024\u306eOR\u6761\u4ef6\u3067\u306e\u691c\u7d22\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ whereIn\u3092\u4f7f\u7528\u3057\u305f\u8907\u6570\u5024\u306e\u691c\u7d22\n$users = User::whereIn('status', ['active', 'pending'])-&gt;get();\n\n\/\/ orWhere\u3092\u4f7f\u7528\u3057\u305f\u540c\u7b49\u306e\u691c\u7d22\n$users = User::where('status', 'active')\n            -&gt;orWhere('status', 'pending')\n            -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>\u5927\u6587\u5b57\u5c0f\u6587\u5b57\u3092\u533a\u5225\u3057\u306a\u3044\u691c\u7d22\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ lower\u95a2\u6570\u3092\u4f7f\u7528\u3057\u305f\u5927\u6587\u5b57\u5c0f\u6587\u5b57\u3092\u533a\u5225\u3057\u306a\u3044\u691c\u7d22\n$users = User::whereRaw('LOWER(email) = ?', [strtolower($email)])-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-6\">\u8907\u6570\u6761\u4ef6\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u9ad8\u5ea6\u306a\u691c\u7d22\u306e\u5b9f\u73fe<\/h3>\n\n\n\n<p>\u8907\u96d1\u306a\u691c\u7d22\u6761\u4ef6\u3092\u5b9f\u88c5\u3059\u308b\u969b\u306e\u52b9\u679c\u7684\u306a\u30a2\u30d7\u30ed\u30fc\u30c1\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>AND\u6761\u4ef6\u306e\u7d44\u307f\u5408\u308f\u305b\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8907\u6570\u306ewhere\u6761\u4ef6\u3092\u30c1\u30a7\u30fc\u30f3\n$users = User::where('status', 'active')\n            -&gt;where('age', '&gt;=', 18)\n            -&gt;where('subscription', 'premium')\n            -&gt;get();\n\n\/\/ \u914d\u5217\u3092\u4f7f\u7528\u3057\u305f\u8907\u6570\u6761\u4ef6\n$users = User::where([\n    ['status', 'active'],\n    ['age', '&gt;=', 18],\n    ['subscription', 'premium']\n])-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>OR\u6761\u4ef6\u3068AND\u6761\u4ef6\u306e\u6df7\u5728\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ orWhere\u3068\u6761\u4ef6\u30b0\u30eb\u30fc\u30d7\u306e\u7d44\u307f\u5408\u308f\u305b\n$users = User::where('status', 'active')\n            -&gt;where(function($query) {\n                $query-&gt;where('age', '&gt;=', 18)\n                      -&gt;orWhere('parent_approved', true);\n            })\n            -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>\u52d5\u7684\u306a\u6761\u4ef6\u306e\u69cb\u7bc9\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">$query = User::query();\n\n\/\/ \u30ea\u30af\u30a8\u30b9\u30c8\u30d1\u30e9\u30e1\u30fc\u30bf\u306b\u57fa\u3065\u304f\u52d5\u7684\u306a\u6761\u4ef6\u8ffd\u52a0\nif ($request-&gt;has('status')) {\n    $query-&gt;where('status', $request-&gt;status);\n}\n\nif ($request-&gt;has('age')) {\n    $query-&gt;where('age', '&gt;=', $request-&gt;age);\n}\n\n$users = $query-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-7\">\u65e5\u4ed8\u7bc4\u56f2\u3067\u306e\u691c\u7d22\u306b\u304a\u3051\u308bwhere\u306e\u6d3b\u7528<\/h3>\n\n\n\n<p>\u65e5\u4ed8\u691c\u7d22\u306f\u591a\u304f\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u5fc5\u8981\u3068\u3055\u308c\u308b\u6a5f\u80fd\u3067\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u57fa\u672c\u7684\u306a\u65e5\u4ed8\u7bc4\u56f2\u691c\u7d22\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u7279\u5b9a\u306e\u671f\u9593\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\n$orders = Order::whereBetween('created_at', [\n    '2024-01-01 00:00:00',\n    '2024-01-31 23:59:59'\n])-&gt;get();\n\n\/\/ whereDate, whereMonth, whereYear\u306e\u4f7f\u7528\n$orders = Order::whereDate('created_at', '2024-01-15')\n              -&gt;orWhereMonth('created_at', '1')\n              -&gt;orWhereYear('created_at', '2024')\n              -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u76f8\u5bfe\u7684\u306a\u65e5\u4ed8\u7bc4\u56f2\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">use Carbon\\Carbon;\n\n\/\/ \u904e\u53bb7\u65e5\u9593\u306e\u30c7\u30fc\u30bf\n$recentOrders = Order::where('created_at', '&gt;=', Carbon::now()-&gt;subDays(7))\n                     -&gt;get();\n\n\/\/ \u4eca\u6708\u306e\u30c7\u30fc\u30bf\n$thisMonthOrders = Order::whereMonth('created_at', Carbon::now()-&gt;month)\n                        -&gt;whereYear('created_at', Carbon::now()-&gt;year)\n                        -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>\u65e5\u4ed8\u6642\u523b\u306e\u90e8\u5206\u4e00\u81f4\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u55b6\u696d\u6642\u9593\u5185\uff089:00-17:00\uff09\u306e\u6ce8\u6587\u3092\u691c\u7d22\n$businessHourOrders = Order::whereRaw('HOUR(created_at) BETWEEN 9 AND 17')\n                          -&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-8\">NULL\u5024\u306e\u4f7f\u3044\u65b9\u3068whereNull\u306e\u4f7f\u7528\u30b7\u30fc\u30f3<\/h3>\n\n\n\n<p>NULL\u5024\u306e\u51e6\u7406\u306f\u7279\u5225\u306a\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>NULL\u5024\u306e\u691c\u7d22\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ NULL\u5024\u306e\u691c\u7d22\n$users = User::whereNull('deleted_at')-&gt;get();\n\n\/\/ NOT NULL\u5024\u306e\u691c\u7d22\n$users = User::whereNotNull('email_verified_at')-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>NULL\u5024\u3068OR\u6761\u4ef6\u306e\u7d44\u307f\u5408\u308f\u305b\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u524a\u9664\u6e08\u307f\u307e\u305f\u306f\u7121\u52b9\u306a\u30e6\u30fc\u30b6\u30fc\u306e\u691c\u7d22\n$users = User::where(function($query) {\n    $query-&gt;whereNotNull('deleted_at')\n          -&gt;orWhere('status', 'inactive');\n})-&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>NULL\u3068\u7a7a\u6587\u5b57\u306e\u4e21\u65b9\u3092\u8003\u616e\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u304c\u672a\u8a2d\u5b9a\uff08NULL\u307e\u305f\u306f\u7a7a\u6587\u5b57\uff09\u306e\u30e6\u30fc\u30b6\u30fc\u3092\u691c\u7d22\n$users = User::where(function($query) {\n    $query-&gt;whereNull('email')\n          -&gt;orWhere('email', '');\n})-&gt;get();<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u65b9\u6cd5\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u67d4\u8edf\u3067\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u691c\u7d22\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u3055\u3089\u306b\u9ad8\u5ea6\u306a\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-9\">where\u30e1\u30bd\u30c3\u30c9\u306e\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-10\">\u30b5\u30d6\u30af\u30a8\u30ea\u3092\u4f7f\u7528\u3057\u305f\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u53d6\u5f97<\/h3>\n\n\n\n<p>\u30b5\u30d6\u30af\u30a8\u30ea\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u8907\u96d1\u306a\u30c7\u30fc\u30bf\u691c\u7d22\u3092\u52b9\u7387\u7684\u306b\u5b9f\u884c\u3067\u304d\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>whereExists\u306e\u4f7f\u7528\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u6ce8\u6587\u5c65\u6b74\u306e\u3042\u308b\u9867\u5ba2\u3092\u691c\u7d22\n$customers = Customer::whereExists(function ($query) {\n    $query-&gt;select(DB::raw(1))\n          -&gt;from('orders')\n          -&gt;whereColumn('orders.customer_id', 'customers.id');\n})-&gt;get();\n\n\/\/ \u6700\u8fd1\u306e\u6ce8\u6587\u304c\u3042\u308b\u9867\u5ba2\u306e\u307f\u3092\u691c\u7d22\n$customers = Customer::whereExists(function ($query) {\n    $query-&gt;select(DB::raw(1))\n          -&gt;from('orders')\n          -&gt;whereColumn('orders.customer_id', 'customers.id')\n          -&gt;where('orders.created_at', '&gt;=', now()-&gt;subDays(30));\n})-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u30b5\u30d6\u30af\u30a8\u30ea\u3092\u4f7f\u7528\u3057\u305f\u6761\u4ef6\u8a2d\u5b9a\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u5e73\u5747\u6ce8\u6587\u984d\u3088\u308a\u9ad8\u3044\u6ce8\u6587\u3092\u691c\u7d22\n$highValueOrders = Order::where('amount', '&gt;', function($query) {\n    $query-&gt;from('orders')\n          -&gt;selectRaw('AVG(amount)');\n})-&gt;get();\n\n\/\/ \u5404\u30ab\u30c6\u30b4\u30ea\u30fc\u306e\u5e73\u5747\u4fa1\u683c\u3088\u308a\u9ad8\u3044\u5546\u54c1\u3092\u691c\u7d22\n$products = Product::where('price', '&gt;', function($query) {\n    $query-&gt;from('products as p2')\n          -&gt;whereColumn('p2.category_id', 'products.category_id')\n          -&gt;selectRaw('AVG(p2.price)');\n})-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-11\">whereHas\u3092\u4f7f\u7528\u3057\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30c7\u30fc\u30bf\u691c\u7d22<\/h3>\n\n\n\n<p>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u6d3b\u7528\u3057\u305f\u9ad8\u5ea6\u306a\u691c\u7d22\u30d1\u30bf\u30fc\u30f3\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u57fa\u672c\u7684\u306awhereHas\u306e\u4f7f\u7528\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30a2\u30af\u30c6\u30a3\u30d6\u306a\u6295\u7a3f\u3092\u6301\u3064\u30e6\u30fc\u30b6\u30fc\u3092\u691c\u7d22\n$users = User::whereHas('posts', function($query) {\n    $query-&gt;where('status', 'active');\n})-&gt;get();\n\n\/\/ \u7279\u5b9a\u306e\u6570\u4ee5\u4e0a\u306e\u30b3\u30e1\u30f3\u30c8\u304c\u3042\u308b\u6295\u7a3f\u3092\u691c\u7d22\n$posts = Post::whereHas('comments', '&gt;=', 5)-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u8907\u6570\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u691c\u7d22\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30d7\u30ec\u30df\u30a2\u30e0\u30e6\u30fc\u30b6\u30fc\u304b\u3089\u306e\u30b3\u30e1\u30f3\u30c8\u304c\u3042\u308b\u6295\u7a3f\u3092\u691c\u7d22\n$posts = Post::whereHas('comments.user', function($query) {\n    $query-&gt;where('subscription_type', 'premium');\n})-&gt;get();\n\n\/\/ \u7279\u5b9a\u306e\u30bf\u30b0\u304c\u4ed8\u3044\u3066\u3044\u3066\u3001\u304b\u3064\u30b3\u30e1\u30f3\u30c8\u306e\u3042\u308b\u6295\u7a3f\u3092\u691c\u7d22\n$posts = Post::whereHas('tags', function($query) {\n    $query-&gt;where('name', 'Laravel');\n})-&gt;whereHas('comments')-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-12\">whereJsonContains \u3067\u306e JSON \u578b\u30ab\u30e9\u30e0\u306e\u691c\u7d22<\/h3>\n\n\n\n<p>JSON\u578b\u30ab\u30e9\u30e0\u306b\u5bfe\u3059\u308b\u691c\u7d22\u64cd\u4f5c\u3092\u52b9\u7387\u7684\u306b\u884c\u3046\u65b9\u6cd5\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u57fa\u672c\u7684\u306aJSON\u691c\u7d22\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30d7\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u306bspecific_key\u3092\u542b\u3080\u30e6\u30fc\u30b6\u30fc\u3092\u691c\u7d22\n$users = User::whereJsonContains('preferences', 'specific_key')-&gt;get();\n\n\/\/ \u7279\u5b9a\u306e\u5024\u3092\u6301\u3064JSON\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u691c\u7d22\n$users = User::whereJsonContains('preferences-&gt;notifications', 'email')-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u8907\u96d1\u306aJSON\u69cb\u9020\u306e\u691c\u7d22\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8907\u6570\u306e\u6761\u4ef6\u3092\u6301\u3064JSON\u691c\u7d22\n$users = User::whereJsonContains('settings-&gt;enabled_features', [\n    'dark_mode',\n    'notifications'\n])-&gt;get();\n\n\/\/ \u30cd\u30b9\u30c8\u3055\u308c\u305fJSON\u69cb\u9020\u306e\u691c\u7d22\n$users = User::whereJsonContains('preferences-&gt;theme-&gt;colors', [\n    'primary' =&gt; '#000000'\n])-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-13\">\u52d5\u7684\u306awhere\u53e5\u306e\u69cb\u7bc9\u3068\u30b9\u30b3\u30fc\u30d7\u306e\u6d3b\u7528<\/h3>\n\n\n\n<p>\u4fdd\u5b88\u6027\u306e\u9ad8\u3044\u52d5\u7684\u30af\u30a8\u30ea\u306e\u69cb\u7bc9\u65b9\u6cd5\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30af\u30a8\u30ea\u30b9\u30b3\u30fc\u30d7\u306e\u5b9a\u7fa9\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class Product extends Model\n{\n    \/\/ \u4fa1\u683c\u7bc4\u56f2\u306e\u30b9\u30b3\u30fc\u30d7\n    public function scopePriceRange($query, $min, $max)\n    {\n        return $query-&gt;whereBetween('price', [$min, $max]);\n    }\n\n    \/\/ \u5728\u5eab\u72b6\u614b\u306e\u30b9\u30b3\u30fc\u30d7\n    public function scopeStockStatus($query, $status)\n    {\n        switch ($status) {\n            case 'in_stock':\n                return $query-&gt;where('stock', '&gt;', 0);\n            case 'out_of_stock':\n                return $query-&gt;where('stock', 0);\n            case 'low_stock':\n                return $query-&gt;where('stock', '&lt;=', 5)\n                            -&gt;where('stock', '&gt;', 0);\n            default:\n                return $query;\n        }\n    }\n}\n\n\/\/ \u30b9\u30b3\u30fc\u30d7\u306e\u4f7f\u7528\u4f8b\n$products = Product::priceRange(100, 1000)\n                  -&gt;stockStatus('low_stock')\n                  -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u691c\u7d22\u6761\u4ef6\u306e\u30af\u30e9\u30b9\u5316\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class ProductSearchCriteria\n{\n    public function apply($query, array $criteria)\n    {\n        if (isset($criteria['category'])) {\n            $query-&gt;where('category_id', $criteria['category']);\n        }\n\n        if (isset($criteria['price_range'])) {\n            $query-&gt;whereBetween('price', [\n                $criteria['price_range']['min'],\n                $criteria['price_range']['max']\n            ]);\n        }\n\n        if (isset($criteria['tags'])) {\n            $query-&gt;whereHas('tags', function($q) use ($criteria) {\n                $q-&gt;whereIn('name', $criteria['tags']);\n            });\n        }\n\n        return $query;\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\n$criteria = [\n    'category' =&gt; 1,\n    'price_range' =&gt; ['min' =&gt; 100, 'max' =&gt; 1000],\n    'tags' =&gt; ['new', 'featured']\n];\n\n$products = (new ProductSearchCriteria)\n    -&gt;apply(Product::query(), $criteria)\n    -&gt;get();<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u67d4\u8edf\u3067\u4fdd\u5b88\u6027\u306e\u9ad8\u3044\u30af\u30a8\u30ea\u3092\u5b9f\u88c5\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u3053\u308c\u3089\u306e\u5b9f\u88c5\u306b\u304a\u3051\u308b\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-14\">where\u30e1\u30bd\u30c3\u30c9\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-15\">\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u8003\u616e\u3057\u305fwhere\u53e5\u306e\u8a2d\u8a08<\/h3>\n\n\n\n<p>where\u30e1\u30bd\u30c3\u30c9\u306e\u6027\u80fd\u306f\u3001\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u306b\u5927\u304d\u304f\u4f9d\u5b58\u3057\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u57fa\u672c\u7684\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u5b9a\u7fa9\nSchema::create('users', function (Blueprint $table) {\n    $table-&gt;id();\n    $table-&gt;string('email')-&gt;unique();  \/\/ \u5358\u4e00\u30ab\u30e9\u30e0\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\n    $table-&gt;string('status');\n    $table-&gt;timestamp('created_at');\n\n    \/\/ \u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u4f5c\u6210\n    $table-&gt;index(['status', 'created_at']);\n});\n\n\/\/ \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u6d3b\u7528\u3059\u308b\u30af\u30a8\u30ea\n$users = User::where('status', 'active')\n            -&gt;where('created_at', '&gt;=', now()-&gt;subDays(30))\n            -&gt;get();<\/pre>\n\n\n\n<p>\u52b9\u679c\u7684\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u306e\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u983b\u7e41\u306b\u691c\u7d22\u3055\u308c\u308b\u6761\u4ef6\u306b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f5c\u6210<\/li>\n\n\n\n<li>\u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u9806\u5e8f\u3092\u8003\u616e\uff08\u6700\u3082\u7d5e\u308a\u8fbc\u307f\u52b9\u679c\u306e\u9ad8\u3044\u5217\u3092\u5148\u982d\u306b\uff09<\/li>\n\n\n\n<li>\u4e0d\u8981\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u907f\u3051\u3066\u3001INSERT\/UPDATE\u6027\u80fd\u3068\u306e\u30d0\u30e9\u30f3\u30b9\u3092\u53d6\u308b<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li>whereIn\u3068\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u95a2\u4fc2\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u5927\u91cf\u306eIN\u6761\u4ef6\u306f\u907f\u3051\u308b\n\/\/ \u975e\u63a8\u5968\u306e\u4f8b\n$users = User::whereIn('id', range(1, 10000))-&gt;get();\n\n\/\/ \u63a8\u5968\u3055\u308c\u308b\u65b9\u6cd5\n$users = User::where('id', '&gt;=', 1)\n            -&gt;where('id', '&lt;=', 10000)\n            -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>LIKE\u691c\u7d22\u306e\u6700\u9069\u5316\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u524d\u65b9\u4e00\u81f4\u306f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u6d3b\u7528\u3067\u304d\u308b\n$users = User::where('email', 'like', 'test%')-&gt;get();\n\n\/\/ \u5f8c\u65b9\u4e00\u81f4\u3084\u4e2d\u9593\u4e00\u81f4\u306f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u6d3b\u7528\u3067\u304d\u306a\u3044\n\/\/ \u5fc5\u8981\u306a\u5834\u5408\u306f\u5168\u6587\u691c\u7d22\u30a8\u30f3\u30b8\u30f3\u306e\u4f7f\u7528\u3092\u691c\u8a0e\n$users = User::where('email', 'like', '%test%')-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-16\">N+1\u554f\u984c\u3092\u9632\u3050\u305f\u3081\u306ewith\u3068where\u306e\u4f75\u7528<\/h3>\n\n\n\n<p>N+1\u554f\u984c\u306f\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u969b\u306b\u3088\u304f\u767a\u751f\u3059\u308b\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u554f\u984c\u3067\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Eager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\u306e\u57fa\u672c\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ N+1\u554f\u984c\u304c\u767a\u751f\u3059\u308b\u30b3\u30fc\u30c9\n$posts = Post::all();  \/\/ 1\u56de\u306e\u30af\u30a8\u30ea\nforeach ($posts as $post) {\n    $post-&gt;user-&gt;name;  \/\/ \u5404\u6295\u7a3f\u306b\u5bfe\u3057\u3066\u8ffd\u52a0\u30af\u30a8\u30ea\u304c\u767a\u751f\n}\n\n\/\/ Eager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\u3067\u89e3\u6c7a\n$posts = Post::with('user')-&gt;get();  \/\/ 2\u56de\u306e\u30af\u30a8\u30ea\u306e\u307f<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u6761\u4ef6\u4ed8\u304dEager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u6761\u4ef6\u3092\u6307\u5b9a\n$posts = Post::with(['comments' =&gt; function ($query) {\n    $query-&gt;where('approved', true);\n}])-&gt;get();\n\n\/\/ \u8907\u6570\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u540c\u6642\u306b\u30ed\u30fc\u30c9\n$posts = Post::with(['user', 'comments', 'tags'])\n            -&gt;where('status', 'published')\n            -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>whereHas\u3068with\u306e\u7d44\u307f\u5408\u308f\u305b\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u6700\u9069\u5316\u3055\u308c\u305f\u8907\u96d1\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30af\u30a8\u30ea\n$posts = Post::with(['comments', 'user'])\n            -&gt;whereHas('comments', function ($query) {\n                $query-&gt;where('approved', true);\n            })\n            -&gt;whereHas('user', function ($query) {\n                $query-&gt;where('status', 'active');\n            })\n            -&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-17\">\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u3067\u306ewhere\u30e1\u30bd\u30c3\u30c9\u306e\u52b9\u7387\u7684\u306a\u4f7f\u7528\u6cd5<\/h3>\n\n\n\n<p>\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u6271\u3046\u969b\u306e\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30c1\u30e3\u30f3\u30af\u51e6\u7406\u306e\u6d3b\u7528\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30e1\u30e2\u30ea\u52b9\u7387\u306e\u826f\u3044\u5927\u91cf\u30c7\u30fc\u30bf\u51e6\u7406\nUser::where('status', 'active')\n    -&gt;chunk(1000, function ($users) {\n        foreach ($users as $user) {\n            \/\/ \u51e6\u7406\u3092\u5b9f\u884c\n        }\n    });\n\n\/\/ LazyCollection\u306e\u4f7f\u7528\nUser::where('status', 'active')\n    -&gt;lazy()\n    -&gt;each(function ($user) {\n        \/\/ \u51e6\u7406\u3092\u5b9f\u884c\n    });<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u30af\u30a8\u30ea\u306e\u6700\u9069\u5316\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u3092\u53d6\u5f97\n$users = User::select(['id', 'name', 'email'])\n            -&gt;where('status', 'active')\n            -&gt;get();\n\n\/\/ \u30ab\u30a6\u30f3\u30c8\u30af\u30a8\u30ea\u306e\u6700\u9069\u5316\n$count = User::where('status', 'active')\n            -&gt;toBase()  \/\/ Eloquent\u30e2\u30c7\u30eb\u306e\u751f\u6210\u3092\u7701\u7565\n            -&gt;count();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u6d3b\u7528\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">use Illuminate\\Support\\Facades\\Cache;\n\n\/\/ \u983b\u7e41\u306b\u4f7f\u7528\u3055\u308c\u308b\u30af\u30a8\u30ea\u7d50\u679c\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\n$users = Cache::remember('active_users', 3600, function () {\n    return User::where('status', 'active')\n               -&gt;with('profile')\n               -&gt;get();\n});\n\n\/\/ \u30bf\u30b0\u4ed8\u304d\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u4f7f\u7528\n$users = Cache::tags(['users', 'active'])\n            -&gt;remember('active_users', 3600, function () {\n                return User::where('status', 'active')-&gt;get();\n            });<\/pre>\n\n\n\n<p>\u5b9f\u88c5\u6642\u306e\u6ce8\u610f\u70b9\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u304c\u6700\u3082\u91cd\u8981<\/li>\n\n\n\n<li>\u5fc5\u8981\u6700\u5c0f\u9650\u306e\u30c7\u30fc\u30bf\u306e\u307f\u3092\u53d6\u5f97<\/li>\n\n\n\n<li>\u5927\u91cf\u30c7\u30fc\u30bf\u306e\u51e6\u7406\u306f\u30c1\u30e3\u30f3\u30af\u5358\u4f4d\u3067\u5b9f\u884c<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u3092\u9069\u5207\u306b\u9078\u629e<\/li>\n\n\n\n<li>\u30af\u30a8\u30ea\u30ed\u30b0\u3092\u76e3\u8996\u3057\u3066\u30dc\u30c8\u30eb\u30cd\u30c3\u30af\u3092\u7279\u5b9a<\/li>\n<\/ul>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af\u3092\u9069\u5207\u306b\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u5927\u898f\u6a21\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u3082\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u7dad\u6301\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001where\u30e1\u30bd\u30c3\u30c9\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u3068\u3088\u304f\u3042\u308b\u9593\u9055\u3044\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-18\">where\u30e1\u30bd\u30c3\u30c9\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u3068\u3088\u304f\u3042\u308b\u9593\u9055\u3044<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-19\">\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3092\u8003\u616e\u3057\u305fwhere\u306e\u4f7f\u7528\u65b9\u6cd5<\/h3>\n\n\n\n<p>where\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3059\u308b\u969b\u306f\u3001\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306b\u95a2\u3059\u308b\u4ee5\u4e0b\u306e\u70b9\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30e6\u30fc\u30b6\u30fc\u5165\u529b\u306e\u5b89\u5168\u306a\u51e6\u7406\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u5371\u967a\u306a\u5b9f\u88c5\uff08\u907f\u3051\u308b\u3079\u304d\uff09\n$query = \"name = '\" . $request-&gt;input('name') . \"'\";\n$users = DB::table('users')-&gt;whereRaw($query)-&gt;get();\n\n\/\/ \u5b89\u5168\u306a\u5b9f\u88c5\n$users = User::where('name', $request-&gt;input('name'))-&gt;get();\n\n\/\/ \u8907\u6570\u6761\u4ef6\u306e\u5b89\u5168\u306a\u51e6\u7406\n$users = User::query()\n    -&gt;when($request-&gt;filled('name'), function($query) use ($request) {\n        $query-&gt;where('name', $request-&gt;input('name'));\n    })\n    -&gt;when($request-&gt;filled('status'), function($query) use ($request) {\n        $query-&gt;where('status', $request-&gt;input('status'));\n    })\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u9069\u5207\u306a\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u306e\u5b9f\u88c5\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class UserController extends Controller\n{\n    public function search(Request $request)\n    {\n        \/\/ \u30ea\u30af\u30a8\u30b9\u30c8\u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\n        $validated = $request-&gt;validate([\n            'status' =&gt; 'nullable|in:active,inactive',\n            'age' =&gt; 'nullable|integer|min:0',\n            'email' =&gt; 'nullable|email'\n        ]);\n\n        \/\/ \u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u6e08\u307f\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u305f\u30af\u30a8\u30ea\n        return User::query()\n            -&gt;when($validated['status'] ?? null, function($query, $status) {\n                $query-&gt;where('status', $status);\n            })\n            -&gt;when($validated['age'] ?? null, function($query, $age) {\n                $query-&gt;where('age', '&gt;=', $age);\n            })\n            -&gt;get();\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-20\">\u30c6\u30b9\u30c8\u3057\u3084\u3059\u3044where\u306e\u66f8\u304d\u65b9<\/h3>\n\n\n\n<p>\u30c6\u30b9\u30c8\u306e\u3057\u3084\u3059\u3055\u3092\u8003\u616e\u3057\u305fwhere\u53e5\u306e\u5b9f\u88c5\u65b9\u6cd5\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u691c\u7d22\u30ed\u30b8\u30c3\u30af\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u5316\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class UserFilter\n{\n    protected $query;\n\n    public function __construct($query)\n    {\n        $this-&gt;query = $query;\n    }\n\n    public function applyStatusFilter($status)\n    {\n        if ($status) {\n            $this-&gt;query-&gt;where('status', $status);\n        }\n        return $this;\n    }\n\n    public function applyAgeFilter($minAge)\n    {\n        if ($minAge) {\n            $this-&gt;query-&gt;where('age', '&gt;=', $minAge);\n        }\n        return $this;\n    }\n\n    public function getQuery()\n    {\n        return $this-&gt;query;\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\n$filter = new UserFilter(User::query());\n$users = $filter\n    -&gt;applyStatusFilter('active')\n    -&gt;applyAgeFilter(20)\n    -&gt;getQuery()\n    -&gt;get();\n\n\/\/ \u30c6\u30b9\u30c8\u30b3\u30fc\u30c9\nclass UserFilterTest extends TestCase\n{\n    \/** @test *\/\n    public function it_applies_status_filter_correctly()\n    {\n        $filter = new UserFilter(User::query());\n        $query = $filter-&gt;applyStatusFilter('active')-&gt;getQuery();\n\n        $this-&gt;assertEquals(\n            'select * from \"users\" where \"status\" = ?',\n            $query-&gt;toSql()\n        );\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-21\">\u4fdd\u5b88\u6027\u3092\u9ad8\u3081\u308b\u305f\u3081\u306ewhere\u30e1\u30bd\u30c3\u30c9\u306e\u8a2d\u8a08\u539f\u5247<\/h3>\n\n\n\n<p>\u30b3\u30fc\u30c9\u306e\u4fdd\u5b88\u6027\u3092\u9ad8\u3081\u308b\u305f\u3081\u306e\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30af\u30a8\u30ea\u30b9\u30b3\u30fc\u30d7\u306e\u6d3b\u7528\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class User extends Model\n{\n    \/\/ \u30b9\u30c6\u30fc\u30bf\u30b9\u306b\u3088\u308b\u7d5e\u308a\u8fbc\u307f\n    public function scopeWithStatus($query, $status)\n    {\n        return $query-&gt;where('status', $status);\n    }\n\n    \/\/ \u5e74\u9f62\u306b\u3088\u308b\u7d5e\u308a\u8fbc\u307f\n    public function scopeMinAge($query, $age)\n    {\n        return $query-&gt;where('age', '&gt;=', $age);\n    }\n\n    \/\/ \u691c\u8a3c\u6e08\u307f\u30e6\u30fc\u30b6\u30fc\u306e\u7d5e\u308a\u8fbc\u307f\n    public function scopeVerified($query)\n    {\n        return $query-&gt;whereNotNull('email_verified_at');\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\n$users = User::withStatus('active')\n            -&gt;minAge(20)\n            -&gt;verified()\n            -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u30ea\u30dd\u30b8\u30c8\u30ea\u30d1\u30bf\u30fc\u30f3\u306e\u5b9f\u88c5\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class UserRepository\n{\n    public function findActiveUsers(array $criteria = [])\n    {\n        return User::query()\n            -&gt;where('status', 'active')\n            -&gt;when(isset($criteria['min_age']), function($query) use ($criteria) {\n                $query-&gt;where('age', '&gt;=', $criteria['min_age']);\n            })\n            -&gt;when(isset($criteria['email']), function($query) use ($criteria) {\n                $query-&gt;where('email', 'like', $criteria['email'] . '%');\n            })\n            -&gt;get();\n    }\n\n    public function findByFilters(array $filters)\n    {\n        $query = User::query();\n\n        foreach ($filters as $field =&gt; $value) {\n            if ($this-&gt;isValidFilter($field, $value)) {\n                $query-&gt;where($field, $value);\n            }\n        }\n\n        return $query-&gt;get();\n    }\n\n    protected function isValidFilter($field, $value)\n    {\n        $allowedFields = ['status', 'role', 'department'];\n        return in_array($field, $allowedFields) &amp;&amp; !empty($value);\n    }\n}<\/pre>\n\n\n\n<p>\u3088\u304f\u3042\u308b\u9593\u9055\u3044\u3068\u5bfe\u7b56\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>N+1\u554f\u984c\u306e\u56de\u907f\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\n$orders = Order::where('status', 'completed')-&gt;get();\nforeach ($orders as $order) {\n    $customerName = $order-&gt;customer-&gt;name;  \/\/ \u8ffd\u52a0\u30af\u30a8\u30ea\u304c\u767a\u751f\n}\n\n\/\/ \u6700\u9069\u5316\u3055\u308c\u305f\u30b3\u30fc\u30c9\n$orders = Order::with('customer')\n            -&gt;where('status', 'completed')\n            -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u5927\u91cf\u30c7\u30fc\u30bf\u306e\u52b9\u7387\u7684\u306a\u51e6\u7406\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30e1\u30e2\u30ea\u52b9\u7387\u306e\u826f\u3044\u5b9f\u88c5\nUser::where('status', 'active')\n    -&gt;chunk(1000, function ($users) {\n        foreach ($users as $user) {\n            \/\/ \u5404\u30e6\u30fc\u30b6\u30fc\u306e\u51e6\u7406\n        }\n    });\n\n\/\/ \u307e\u305f\u306f\u3001Lazy\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306e\u4f7f\u7528\nUser::where('status', 'active')\n    -&gt;lazy()\n    -&gt;each(function ($user) {\n        \/\/ \u5404\u30e6\u30fc\u30b6\u30fc\u306e\u51e6\u7406\n    });<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u8003\u616e\u3057\u305f\u691c\u7d22\uff1a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u52b9\u679c\u7684\u306b\u4f7f\u7528\u3055\u308c\u308b\u5b9f\u88c5\n$users = User::where('email', 'like', 'test%')-&gt;get();  \/\/ \u524d\u65b9\u4e00\u81f4\n\n\/\/ \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u4f7f\u7528\u3055\u308c\u306a\u3044\u5b9f\u88c5\uff08\u5fc5\u8981\u306a\u5834\u5408\u306f\u5168\u6587\u691c\u7d22\u306e\u4f7f\u7528\u3092\u691c\u8a0e\uff09\n$users = User::where('email', 'like', '%test%')-&gt;get();  \/\/ \u4e2d\u9593\u4e00\u81f4<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u3092\u610f\u8b58\u3059\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u4fdd\u5b88\u6027\u304c\u9ad8\u304f\u3001\u30bb\u30ad\u30e5\u30a2\u3067\u52b9\u7387\u7684\u306a\u30b3\u30fc\u30c9\u3092\u5b9f\u88c5\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Warning: Undefined array key &#8220;is_admin&#8221; in \/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/ &#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,12],"tags":[],"class_list":{"0":"post-3261","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-php-laravel","7":"category-php","8":"nothumb"},"_links":{"self":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/3261","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3261"}],"version-history":[{"count":2,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/3261\/revisions"}],"predecessor-version":[{"id":3263,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/3261\/revisions\/3263"}],"wp:attachment":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}