{"id":3267,"date":"2025-03-24T08:46:33","date_gmt":"2025-03-23T23:46:33","guid":{"rendered":"https:\/\/dexall.co.jp\/articles\/?p=3267"},"modified":"2025-03-24T08:47:04","modified_gmt":"2025-03-23T23:47:04","slug":"%e3%80%90%e5%ae%8c%e5%85%a8%e8%a7%a3%e8%aa%ac%e3%80%91laravel-wherehas%e3%81%ae%e4%bd%bf%e3%81%84%e6%96%b9%e3%81%a8%e3%83%91%e3%83%95%e3%82%a9%e3%83%bc%e3%83%9e%e3%83%b3%e3%82%b9%e6%9c%80%e9%81%a9","status":"publish","type":"post","link":"https:\/\/dexall.co.jp\/articles\/?p=3267","title":{"rendered":"\u3010\u5b8c\u5168\u89e3\u8aac\u3011Laravel whereHas\u306e\u4f7f\u3044\u65b9\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af2024"},"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\">Laravel whereHas\u3068\u306f\uff1f\u57fa\u790e\u304b\u3089\u7406\u89e3\u3059\u308b<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-1\">whereHas\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u672c\u7684\u306a\u69cb\u6587\u3068\u52d5\u4f5c\u539f\u7406<\/a>      <\/li>      <li>        <a href=\"#i-2\">whereHas\u304c\u89e3\u6c7a\u3059\u308b\u5178\u578b\u7684\u306a\u8ab2\u984c<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-3\">orWhereHas\u3068\u306e\u9055\u3044\u3068\u4f7f\u3044\u5206\u3051<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-4\">whereHas\u306e\u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u65b9\u6cd5<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-5\">1\u5bfe\u591a\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u6d3b\u7528\u4f8b<\/a>      <\/li>      <li>        <a href=\"#i-6\">\u591a\u5bfe\u591a\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u6d3b\u7528\u4f8b<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-7\">\u30cd\u30b9\u30c8\u3055\u308c\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u4f7f\u7528\u65b9\u6cd5<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-8\">whereHas\u3092\u4f7f\u7528\u3057\u305f\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u96c6<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-9\">\u7279\u5b9a\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3059\u95a2\u9023\u30ec\u30b3\u30fc\u30c9\u306e\u7d5e\u308a\u8fbc\u307f<\/a>      <\/li>      <li>        <a href=\"#i-10\">\u95a2\u9023\u30ec\u30b3\u30fc\u30c9\u306e\u6570\u306b\u57fa\u3065\u304f\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-11\">\u8907\u96d1\u306a\u6761\u4ef6\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u691c\u7d22\u306e\u5b9f\u88c5<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-12\">whereHas\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-13\">N+1\u554f\u984c\u306e\u56de\u907f\u3068eager\u30ed\u30fc\u30c9\u306e\u9069\u5207\u306a\u4f7f\u7528<\/a>      <\/li>      <li>        <a href=\"#i-14\">\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-15\">\u30af\u30a8\u30ea\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-16\">whereHas\u306e\u5b9f\u8df5\u7684\u306a\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-17\">E\u30b3\u30de\u30fc\u30b9\u3067\u306e\u5546\u54c1\u691c\u7d22\u6a5f\u80fd\u306e\u5b9f\u88c5<\/a>      <\/li>      <li>        <a href=\"#i-18\">\u30d6\u30ed\u30b0\u30b7\u30b9\u30c6\u30e0\u3067\u306e\u30bf\u30b0\u4ed8\u304d\u8a18\u4e8b\u691c\u7d22<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-19\">\u30bd\u30fc\u30b7\u30e3\u30eb\u30e1\u30c7\u30a3\u30a2\u3067\u306e\u30e6\u30fc\u30b6\u30fc\u95a2\u9023\u691c\u7d22<\/a>      <\/li>    <\/ul>  <\/li>  <li class=\"last\">    <a href=\"#i-20\">whereHas\u306e\u30c7\u30d0\u30c3\u30b0\u3068\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-21\">\u4e00\u822c\u7684\u306a\u30a8\u30e9\u30fc\u30d1\u30bf\u30fc\u30f3\u3068\u89e3\u6c7a\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-22\">\u30af\u30a8\u30ea\u30ed\u30b0\u3092\u4f7f\u7528\u3057\u305f\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u5206\u6790<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-23\">\u30c6\u30b9\u30c8\u6642\u306e\u52b9\u679c\u7684\u306a\u30e2\u30c3\u30af\u65b9\u6cd5<\/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\">Laravel whereHas\u3068\u306f\uff1f\u57fa\u790e\u304b\u3089\u7406\u89e3\u3059\u308b<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-1\">whereHas\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u672c\u7684\u306a\u69cb\u6587\u3068\u52d5\u4f5c\u539f\u7406<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">whereHas\u30e1\u30bd\u30c3\u30c9\u306f\u3001Laravel\u306e\u30a8\u30ed\u30af\u30a2\u30f3\u30c8\u3067\u63d0\u4f9b\u3055\u308c\u308b\u5f37\u529b\u306a\u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u30e1\u30bd\u30c3\u30c9\u3067\u3059\u3002\u3053\u306e\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u6761\u4ef6\u306b\u57fa\u3065\u3044\u3066\u30e1\u30a4\u30f3\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u57fa\u672c\u7684\u306a\u69cb\u6587\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\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=\"\">\/\/ \u57fa\u672c\u7684\u306a\u4f7f\u7528\u65b9\u6cd5\n$posts = Post::whereHas('comments', function($query) {\n    $query-&gt;where('is_approved', true);\n})-&gt;get();\n\n\/\/ \u4e0a\u8a18\u306eSQL\u306f\u304a\u304a\u3088\u305d\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\n\/\/ SELECT * FROM posts \n\/\/ WHERE EXISTS (\n\/\/     SELECT * FROM comments \n\/\/     WHERE posts.id = comments.post_id \n\/\/     AND comments.is_approved = true\n\/\/ )<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">whereHas\u306e\u5185\u90e8\u3067\u306f\u3001EXISTS\u30b5\u30d6\u30af\u30a8\u30ea\u304c\u751f\u6210\u3055\u308c\u3001\u6307\u5b9a\u3055\u308c\u305f\u6761\u4ef6\u306b\u4e00\u81f4\u3059\u308b\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30ec\u30b3\u30fc\u30c9\u304c\u5b58\u5728\u3059\u308b\u304b\u3069\u3046\u304b\u3092\u30c1\u30a7\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-2\">whereHas\u304c\u89e3\u6c7a\u3059\u308b\u5178\u578b\u7684\u306a\u8ab2\u984c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">whereHas\u30e1\u30bd\u30c3\u30c9\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u4e00\u822c\u7684\u306a\u958b\u767a\u4e0a\u306e\u8ab2\u984c\u3092\u52b9\u7387\u7684\u306b\u89e3\u6c7a\u3057\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u95a2\u9023\u30c7\u30fc\u30bf\u306b\u57fa\u3065\u304f\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0<\/strong><\/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\u30bf\u30b0\u304c\u4ed8\u3044\u305f\u8a18\u4e8b\u306e\u307f\u3092\u53d6\u5f97\n$posts = Post::whereHas('tags', function($query) {\n    $query-&gt;where('name', 'Laravel');\n})-&gt;get();\n\n\/\/ \u627f\u8a8d\u6e08\u307f\u306e\u30b3\u30e1\u30f3\u30c8\u304c\u3042\u308b\u8a18\u4e8b\u306e\u307f\u3092\u53d6\u5f97\n$posts = Post::whereHas('comments', function($query) {\n    $query-&gt;where('status', 'approved');\n})-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u8907\u6570\u306e\u6761\u4ef6\u306b\u3088\u308b\u7d5e\u308a\u8fbc\u307f<\/strong><\/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\u30e6\u30fc\u30b6\u30fc\u304c\u66f8\u3044\u305f\u8a18\u4e8b\u3067\u3001\u304b\u3064\u627f\u8a8d\u6e08\u307f\u30b3\u30e1\u30f3\u30c8\u304c\u3042\u308b\u3082\u306e\u3092\u53d6\u5f97\n$posts = Post::whereHas('user', function($query) {\n    $query-&gt;where('status', 'active');\n})-&gt;whereHas('comments', function($query) {\n    $query-&gt;where('is_approved', true);\n})-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-3\">orWhereHas\u3068\u306e\u9055\u3044\u3068\u4f7f\u3044\u5206\u3051<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">whereHas\u3068orWhereHas\u306f\u3001\u6761\u4ef6\u306e\u7d44\u307f\u5408\u308f\u305b\u65b9\u304c\u7570\u306a\u308a\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>whereHas\u306e\u5834\u5408\uff08AND\u6761\u4ef6\uff09<\/strong><\/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=\"\">\/\/ Laravel\u30bf\u30b0\u3068PHP\u30bf\u30b0\u306e\u4e21\u65b9\u3092\u6301\u3064\u8a18\u4e8b\u3092\u53d6\u5f97\n$posts = Post::whereHas('tags', function($query) {\n    $query-&gt;where('name', 'Laravel');\n})-&gt;whereHas('tags', function($query) {\n    $query-&gt;where('name', 'PHP');\n})-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>orWhereHas\u306e\u5834\u5408\uff08OR\u6761\u4ef6\uff09<\/strong><\/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=\"\">\/\/ Laravel\u30bf\u30b0\u307e\u305f\u306fPHP\u30bf\u30b0\u3092\u6301\u3064\u8a18\u4e8b\u3092\u53d6\u5f97\n$posts = Post::whereHas('tags', function($query) {\n    $query-&gt;where('name', 'Laravel');\n})-&gt;orWhereHas('tags', function($query) {\n    $query-&gt;where('name', 'PHP');\n})-&gt;get();<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u3044\u5206\u3051\u306e\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n<div id=\"id-381ab90b-b4ef-44b1-90bb-c8c0bbdba199\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30e1\u30bd\u30c3\u30c9<\/th><th>\u4f7f\u7528\u30b1\u30fc\u30b9<\/th><th>\u7279\u5fb4<\/th><\/tr><\/thead><tbody><tr><td>whereHas<\/td><td>\u8907\u6570\u306e\u6761\u4ef6\u3092\u5168\u3066\u6e80\u305f\u3059\u5fc5\u8981\u304c\u3042\u308b\u5834\u5408<\/td><td>\u3088\u308a\u53b3\u5bc6\u306a\u691c\u7d22\u304c\u53ef\u80fd<\/td><\/tr><tr><td>orWhereHas<\/td><td>\u3044\u305a\u308c\u304b\u306e\u6761\u4ef6\u3092\u6e80\u305f\u305b\u3070\u3088\u3044\u5834\u5408<\/td><td>\u3088\u308a\u5e83\u3044\u691c\u7d22\u7d50\u679c\u304c\u5f97\u3089\u308c\u308b<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">whereHas\u3068orWhereHas\u3092\u9069\u5207\u306b\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u8907\u96d1\u306a\u691c\u7d22\u6761\u4ef6\u3092\u8868\u73fe\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u4ee5\u4e0b\u306f\u5b9f\u8df5\u7684\u306a\u4f8b\u3067\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=\"\">\/\/ Laravel\u30bf\u30b0\u304c\u3042\u308bOR\uff08PHP\u30bf\u30b0\u304b\u3064\u627f\u8a8d\u6e08\u307f\u30b3\u30e1\u30f3\u30c8\u304c\u3042\u308b\uff09\u8a18\u4e8b\u3092\u53d6\u5f97\n$posts = Post::whereHas('tags', function($query) {\n    $query-&gt;where('name', 'Laravel');\n})-&gt;orWhere(function($query) {\n    $query-&gt;whereHas('tags', function($q) {\n        $q-&gt;where('name', 'PHP');\n    })-&gt;whereHas('comments', function($q) {\n        $q-&gt;where('is_approved', true);\n    });\n})-&gt;get();<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u57fa\u672c\u7684\u306a\u7406\u89e3\u3092\u8e0f\u307e\u3048\u305f\u4e0a\u3067\u3001\u3088\u308a\u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u65b9\u6cd5\u3084\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af\u3092\u7fd2\u5f97\u3059\u308b\u3053\u3068\u3067\u3001\u52b9\u7387\u7684\u306a\u30af\u30a8\u30ea\u306e\u5b9f\u88c5\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-4\">whereHas\u306e\u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u65b9\u6cd5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-5\">1\u5bfe\u591a\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u6d3b\u7528\u4f8b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">1\u5bfe\u591a\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306f\u3001whereHas\u304c\u6700\u3082\u983b\u7e41\u306b\u4f7f\u7528\u3055\u308c\u308b\u30b7\u30c1\u30e5\u30a8\u30fc\u30b7\u30e7\u30f3\u306e\u4e00\u3064\u3067\u3059\u3002\u4ee5\u4e0b\u306b\u5b9f\u8df5\u7684\u306a\u4f8b\u3092\u793a\u3057\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\u5b9a\u7fa9\nclass User extends Model\n{\n    public function posts()\n    {\n        return $this-&gt;hasMany(Post::class);\n    }\n}\n\nclass Post extends Model\n{\n    public function comments()\n    {\n        return $this-&gt;hasMany(Comment::class);\n    }\n}\n\n\/\/ \u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u4f8b\n\/\/ 1. \u6295\u7a3f\u6570\u304c5\u3064\u4ee5\u4e0a\u306e\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u30e6\u30fc\u30b6\u30fc\u3092\u53d6\u5f97\n$users = User::whereHas('posts', function($query) {\n    $query-&gt;where('status', 'published');\n}, '&gt;=', 5)-&gt;get();\n\n\/\/ 2. \u904e\u53bb30\u65e5\u4ee5\u5185\u306b\u30b3\u30e1\u30f3\u30c8\u304c\u3064\u3044\u305f\u6295\u7a3f\u3092\u6301\u3064\u30e6\u30fc\u30b6\u30fc\u3092\u53d6\u5f97\n$users = User::whereHas('posts', function($query) {\n    $query-&gt;whereHas('comments', function($q) {\n        $q-&gt;where('created_at', '&gt;=', now()-&gt;subDays(30));\n    });\n})-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-6\">\u591a\u5bfe\u591a\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u6d3b\u7528\u4f8b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u591a\u5bfe\u591a\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306f\u3001\u4e2d\u9593\u30c6\u30fc\u30d6\u30eb\u306e\u6761\u4ef6\u3082\u542b\u3081\u305f\u8907\u96d1\u306a\u30af\u30a8\u30ea\u304c\u53ef\u80fd\u3067\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\u5b9a\u7fa9\nclass Post extends Model\n{\n    public function tags()\n    {\n        return $this-&gt;belongsToMany(Tag::class)\n            -&gt;withTimestamps()\n            -&gt;withPivot('added_by');\n    }\n}\n\n\/\/ \u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u4f8b\n\/\/ 1. \u7279\u5b9a\u306e\u7ba1\u7406\u8005\u304c\u8ffd\u52a0\u3057\u305f\u30bf\u30b0\u3092\u6301\u3064\u6295\u7a3f\u3092\u53d6\u5f97\n$posts = Post::whereHas('tags', function($query) {\n    $query-&gt;wherePivot('added_by', 1); \/\/ admin_id = 1\n})-&gt;get();\n\n\/\/ 2. \u8907\u6570\u306e\u5fc5\u9808\u30bf\u30b0\u3092\u6301\u3064\u6295\u7a3f\u3092\u53d6\u5f97\n$posts = Post::whereHas('tags', function($query) {\n    $query-&gt;where('name', 'Laravel');\n})-&gt;whereHas('tags', function($query) {\n    $query-&gt;where('name', 'Performance');\n})-&gt;get();\n\n\/\/ 3. \u30bf\u30b0\u4ed8\u3051\u3055\u308c\u305f\u65e5\u6642\u306b\u57fa\u3065\u304f\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\n$posts = Post::whereHas('tags', function($query) {\n    $query-&gt;wherePivot('created_at', '&gt;=', now()-&gt;subDays(7));\n})-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-7\">\u30cd\u30b9\u30c8\u3055\u308c\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u4f7f\u7528\u65b9\u6cd5<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u8907\u6570\u968e\u5c64\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u6271\u3046\u5834\u5408\u3001whereHas\u3092\u5165\u308c\u5b50\u306b\u3057\u3066\u4f7f\u7528\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\u5b9a\u7fa9\nclass Department extends Model\n{\n    public function teams()\n    {\n        return $this-&gt;hasMany(Team::class);\n    }\n}\n\nclass Team extends Model\n{\n    public function projects()\n    {\n        return $this-&gt;hasMany(Project::class);\n    }\n}\n\nclass Project extends Model\n{\n    public function tasks()\n    {\n        return $this-&gt;hasMany(Task::class);\n    }\n}\n\n\/\/ \u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u4f8b\n\/\/ 1. \u9ad8\u512a\u5148\u5ea6\u306e\u30bf\u30b9\u30af\u304c\u3042\u308b\u9032\u884c\u4e2d\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u6301\u3064\u30c1\u30fc\u30e0\u304c\u3042\u308b\u90e8\u9580\u3092\u53d6\u5f97\n$departments = Department::whereHas('teams', function($query) {\n    $query-&gt;whereHas('projects', function($q) {\n        $q-&gt;where('status', 'in_progress')\n          -&gt;whereHas('tasks', function($q) {\n              $q-&gt;where('priority', 'high');\n          });\n    });\n})-&gt;get();\n\n\/\/ 2. \u3088\u308a\u8aad\u307f\u3084\u3059\u3044\u5f62\u306b\u5206\u5272\u3057\u305f\u4f8b\n$departments = Department::whereHas('teams', function($query) {\n    $query-&gt;whereHas('projects', function($q) {\n        $q-&gt;where('status', 'in_progress');\n\n        \/\/ \u30bf\u30b9\u30af\u306b\u95a2\u3059\u308b\u6761\u4ef6\u3092\u5225\u306ewhere\u53e5\u3068\u3057\u3066\u8ffd\u52a0\n        $q-&gt;whereHas('tasks', function($taskQuery) {\n            $taskQuery-&gt;where('priority', 'high')\n                     -&gt;where('status', '!=', 'completed');\n        });\n    });\n})\n-&gt;with(['teams.projects' =&gt; function($query) {\n    \/\/ Eager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\u306e\u6761\u4ef6\u3092\u8ffd\u52a0\n    $query-&gt;where('status', 'in_progress');\n}])\n-&gt;get();<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9f\u88c5\u306e\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n<div id=\"id-1f646904-841c-43fb-9c81-d3da8329aeee\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30b7\u30ca\u30ea\u30aa<\/th><th>\u63a8\u5968\u30a2\u30d7\u30ed\u30fc\u30c1<\/th><th>\u6ce8\u610f\u70b9<\/th><\/tr><\/thead><tbody><tr><td>1\u5bfe\u591a<\/td><td>\u30b7\u30f3\u30d7\u30eb\u306a\u6761\u4ef6\u304b\u3089\u59cb\u3081\u308b<\/td><td>N+1\u554f\u984c\u306b\u6ce8\u610f<\/td><\/tr><tr><td>\u591a\u5bfe\u591a<\/td><td>\u4e2d\u9593\u30c6\u30fc\u30d6\u30eb\u306e\u6761\u4ef6\u3082\u8003\u616e<\/td><td>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u8a2d\u8a08\u304c\u91cd\u8981<\/td><\/tr><tr><td>\u30cd\u30b9\u30c8<\/td><td>\u6761\u4ef6\u3092\u5206\u5272\u3057\u3066\u53ef\u8aad\u6027\u3092\u78ba\u4fdd<\/td><td>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u6ce8\u610f<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">\u3053\u308c\u3089\u306e\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u3067\u3001\u8907\u96d1\u306a\u30c7\u30fc\u30bf\u69cb\u9020\u306b\u304a\u3044\u3066\u3082\u52b9\u7387\u7684\u306a\u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u307e\u305f\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066with\u30e1\u30bd\u30c3\u30c9\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u6700\u9069\u5316\u3059\u308b\u3053\u3068\u3082\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-8\">whereHas\u3092\u4f7f\u7528\u3057\u305f\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u96c6<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-9\">\u7279\u5b9a\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3059\u95a2\u9023\u30ec\u30b3\u30fc\u30c9\u306e\u7d5e\u308a\u8fbc\u307f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9f\u8df5\u7684\u306a\u30b7\u30ca\u30ea\u30aa\u3067\u306f\u3001\u8907\u6570\u306e\u6761\u4ef6\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u8907\u96d1\u306a\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002\u4ee5\u4e0b\u306b\u4e3b\u8981\u306a\u30d1\u30bf\u30fc\u30f3\u3092\u793a\u3057\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=\"\">\/\/ \u57fa\u672c\u7684\u306a\u30d1\u30bf\u30fc\u30f3\uff1a\u6761\u4ef6\u306e\u7d44\u307f\u5408\u308f\u305b\nclass Order extends Model\n{\n    public function items()\n    {\n        return $this-&gt;hasMany(OrderItem::class);\n    }\n\n    public function customer()\n    {\n        return $this-&gt;belongsTo(Customer::class);\n    }\n}\n\n\/\/ 1. \u9ad8\u984d\u5546\u54c1\u3092\u542b\u3080\u6ce8\u6587\u306e\u691c\u7d22\n$orders = Order::whereHas('items', function($query) {\n    $query-&gt;where('price', '&gt;=', 10000);\n})-&gt;get();\n\n\/\/ 2. \u8907\u6570\u306e\u5546\u54c1\u30ab\u30c6\u30b4\u30ea\u30fc\u3092\u542b\u3080\u6ce8\u6587\n$orders = Order::whereHas('items', function($query) {\n    $query-&gt;whereIn('category', ['electronics', 'accessories']);\n})-&gt;get();\n\n\/\/ 3. VIP\u9867\u5ba2\u306e\u5927\u53e3\u6ce8\u6587\n$orders = Order::whereHas('customer', function($query) {\n    $query-&gt;where('status', 'vip');\n})-&gt;whereHas('items', function($query) {\n    $query-&gt;having(DB::raw('SUM(quantity * price)'), '&gt;=', 100000);\n})-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-10\">\u95a2\u9023\u30ec\u30b3\u30fc\u30c9\u306e\u6570\u306b\u57fa\u3065\u304f\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30ec\u30b3\u30fc\u30c9\u6570\u306b\u57fa\u3065\u304f\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u306f\u3001\u30d3\u30b8\u30cd\u30b9\u30ed\u30b8\u30c3\u30af\u306e\u5b9f\u88c5\u3067\u3088\u304f\u4f7f\u7528\u3055\u308c\u308b\u30d1\u30bf\u30fc\u30f3\u3067\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=\"\">class Product extends Model\n{\n    public function reviews()\n    {\n        return $this-&gt;hasMany(Review::class);\n    }\n\n    public function orderItems()\n    {\n        return $this-&gt;hasMany(OrderItem::class);\n    }\n}\n\n\/\/ 1. \u8a55\u4fa1\u6570\u306b\u3088\u308b\u5546\u54c1\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\n$popularProducts = Product::whereHas('reviews', function($query) {\n    $query-&gt;where('rating', '&gt;=', 4);\n}, '&gt;=', 10)-&gt;get();\n\n\/\/ 2. \u8907\u5408\u6761\u4ef6\u3067\u306e\u6ce8\u6587\u6570\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\n$products = Product::where(function($query) {\n    \/\/ \u76f4\u8fd130\u65e5\u306e\u6ce8\u6587\u6570\u304c20\u4ee5\u4e0a\n    $query-&gt;whereHas('orderItems', function($q) {\n        $q-&gt;where('created_at', '&gt;=', now()-&gt;subDays(30));\n    }, '&gt;=', 20)\n    \/\/ \u304b\u3064 \u8a55\u4fa1\u304c4\u4ee5\u4e0a\u306e\u5546\u54c1\n    -&gt;whereHas('reviews', function($q) {\n        $q-&gt;where('rating', '&gt;=', 4);\n    });\n})-&gt;get();\n\n\/\/ 3. \u5728\u5eab\u5207\u308c\u30ea\u30b9\u30af\u5546\u54c1\u306e\u691c\u51fa\n$products = Product::whereHas('orderItems', function($query) {\n    $query-&gt;select(DB::raw('COUNT(*)'))\n          -&gt;where('created_at', '&gt;=', now()-&gt;subDays(7))\n          -&gt;havingRaw('COUNT(*) &gt;= ?', [10]);\n})-&gt;where('stock', '&lt;=', 20)-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-11\">\u8907\u96d1\u306a\u6761\u4ef6\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u691c\u7d22\u306e\u5b9f\u88c5<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u3088\u308a\u8907\u96d1\u306a\u30d3\u30b8\u30cd\u30b9\u30ed\u30b8\u30c3\u30af\u3092\u5b9f\u88c5\u3059\u308b\u5834\u5408\u306e\u4f8b\u3092\u793a\u3057\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=\"\">class Course extends Model\n{\n    public function students()\n    {\n        return $this-&gt;belongsToMany(Student::class);\n    }\n\n    public function assignments()\n    {\n        return $this-&gt;hasMany(Assignment::class);\n    }\n\n    public function lessons()\n    {\n        return $this-&gt;hasMany(Lesson::class);\n    }\n}\n\n\/\/ 1. \u9ad8\u5ea6\u306a\u6761\u4ef6\u3092\u6301\u3064\u30b9\u30b3\u30fc\u30d7\u306e\u4f5c\u6210\nclass Course extends Model\n{\n    \/\/ \u30a2\u30af\u30c6\u30a3\u30d6\u306a\u53d7\u8b1b\u751f\u304c\u3044\u308b\u30b3\u30fc\u30b9\u306e\u30b9\u30b3\u30fc\u30d7\n    public function scopeWithActiveStudents($query)\n    {\n        return $query-&gt;whereHas('students', function($q) {\n            $q-&gt;where('status', 'active')\n              -&gt;where('last_login_at', '&gt;=', now()-&gt;subDays(30));\n        });\n    }\n\n    \/\/ \u9032\u6357\u7387\u306e\u9ad8\u3044\u30b3\u30fc\u30b9\u306e\u30b9\u30b3\u30fc\u30d7\n    public function scopeHighProgress($query, $progressRate = 80)\n    {\n        return $query-&gt;whereHas('students', function($q) use ($progressRate) {\n            $q-&gt;where('progress', '&gt;=', $progressRate);\n        }, '&gt;=', 5);\n    }\n}\n\n\/\/ 2. \u8907\u6570\u306e\u6761\u4ef6\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u9ad8\u5ea6\u306a\u691c\u7d22\n$courses = Course::withActiveStudents()\n    -&gt;where(function($query) {\n        $query-&gt;whereHas('assignments', function($q) {\n            $q-&gt;where('due_date', '&gt;=', now())\n              -&gt;where('due_date', '&lt;=', now()-&gt;addDays(7));\n        })-&gt;orWhereHas('lessons', function($q) {\n            $q-&gt;where('start_date', '&gt;=', now())\n              -&gt;where('start_date', '&lt;=', now()-&gt;addDays(7));\n        });\n    })\n    -&gt;whereHas('students', function($query) {\n        $query-&gt;where('progress', '&gt;=', 50);\n    }, '&gt;=', 3)\n    -&gt;get();\n\n\/\/ 3. \u52d5\u7684\u306a\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u306e\u69cb\u7bc9\nclass CourseController extends Controller\n{\n    public function index(Request $request)\n    {\n        $query = Course::query();\n\n        \/\/ \u52d5\u7684\u306a\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u306e\u8ffd\u52a0\n        if ($request-&gt;has('min_students')) {\n            $query-&gt;whereHas('students', function($q) {}, '&gt;=', \n                $request-&gt;input('min_students'));\n        }\n\n        if ($request-&gt;has('assignment_type')) {\n            $query-&gt;whereHas('assignments', function($q) use ($request) {\n                $q-&gt;where('type', $request-&gt;input('assignment_type'));\n            });\n        }\n\n        if ($request-&gt;has('progress_rate')) {\n            $query-&gt;whereHas('students', function($q) use ($request) {\n                $q-&gt;where('progress', '&gt;=', \n                    $request-&gt;input('progress_rate'));\n            });\n        }\n\n        return $query-&gt;get();\n    }\n}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\uff1a<\/p>\n\n\n<div id=\"id-58aaa8ab-a68a-46b5-a74c-ef3a79be7c54\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30d1\u30bf\u30fc\u30f3<\/th><th>\u4f7f\u7528\u30b7\u30fc\u30f3<\/th><th>\u30e1\u30ea\u30c3\u30c8<\/th><\/tr><\/thead><tbody><tr><td>\u30b9\u30b3\u30fc\u30d7\u5b9a\u7fa9<\/td><td>\u983b\u7e41\u306b\u4f7f\u7528\u3059\u308b\u6761\u4ef6<\/td><td>\u30b3\u30fc\u30c9\u306e\u518d\u5229\u7528\u6027\u304c\u5411\u4e0a<\/td><\/tr><tr><td>\u52d5\u7684\u30d5\u30a3\u30eb\u30bf\u30fc<\/td><td>API\u5b9f\u88c5<\/td><td>\u67d4\u8edf\u306a\u691c\u7d22\u6761\u4ef6\u306e\u69cb\u7bc9\u304c\u53ef\u80fd<\/td><\/tr><tr><td>\u8907\u5408\u6761\u4ef6<\/td><td>\u8907\u96d1\u306a\u30d3\u30b8\u30cd\u30b9\u30ed\u30b8\u30c3\u30af<\/td><td>\u4fdd\u5b88\u6027\u306e\u9ad8\u3044\u30b3\u30fc\u30c9\u69cb\u9020<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">\u3053\u308c\u3089\u306e\u30d1\u30bf\u30fc\u30f3\u3092\u9069\u5207\u306b\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u4fdd\u5b88\u6027\u304c\u9ad8\u304f\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3082\u8003\u616e\u3057\u305f\u5b9f\u88c5\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002\u307e\u305f\u3001\u30d3\u30b8\u30cd\u30b9\u30ed\u30b8\u30c3\u30af\u306e\u5909\u66f4\u306b\u3082\u67d4\u8edf\u306b\u5bfe\u5fdc\u3067\u304d\u308b\u69cb\u9020\u3092\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-12\">whereHas\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-13\">N+1\u554f\u984c\u306e\u56de\u907f\u3068eager\u30ed\u30fc\u30c9\u306e\u9069\u5207\u306a\u4f7f\u7528<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">whereHas\u3092\u4f7f\u7528\u3059\u308b\u969b\u3001\u6700\u3082\u6ce8\u610f\u3059\u3079\u304d\u70b9\u306fN+1\u554f\u984c\u306e\u56de\u907f\u3067\u3059\u3002\u4ee5\u4e0b\u306b\u3001\u554f\u984c\u306e\u7279\u5b9a\u3068\u89e3\u6c7a\u65b9\u6cd5\u3092\u793a\u3057\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=\"\">\/\/ N+1\u554f\u984c\u304c\u767a\u751f\u3059\u308b\u30b3\u30fc\u30c9\n$posts = Post::whereHas('comments', function($query) {\n    $query-&gt;where('is_approved', true);\n})-&gt;get();\n\nforeach ($posts as $post) {\n    \/\/ \u5404\u6295\u7a3f\u306b\u5bfe\u3057\u3066\u8ffd\u52a0\u306e\u30af\u30a8\u30ea\u304c\u5b9f\u884c\u3055\u308c\u308b\n    echo $post-&gt;comments-&gt;count() . \" comments\\n\";\n}\n\n\/\/ \u6700\u9069\u5316\u3055\u308c\u305f\u30b3\u30fc\u30c9\n$posts = Post::whereHas('comments', function($query) {\n    $query-&gt;where('is_approved', true);\n})\n-&gt;with(['comments' =&gt; function($query) {\n    $query-&gt;where('is_approved', true);\n}])\n-&gt;get();\n\n\/\/ \u30af\u30a8\u30ea\u30ed\u30b0\u306e\u78ba\u8a8d\u65b9\u6cd5\n\\DB::enableQueryLog();\n\/\/ \u30af\u30a8\u30ea\u5b9f\u884c\n$posts = Post::whereHas('comments')-&gt;with('comments')-&gt;get();\n\/\/ \u30ed\u30b0\u306e\u8868\u793a\ndd(\\DB::getQueryLog());<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Eager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\uff1a<\/p>\n\n\n<div id=\"id-6639ddb5-790a-4c68-9bb0-1a04d2a424b1\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30b7\u30ca\u30ea\u30aa<\/th><th>\u63a8\u5968\u30a2\u30d7\u30ed\u30fc\u30c1<\/th><th>\u6ce8\u610f\u70b9<\/th><\/tr><\/thead><tbody><tr><td>\u5358\u4e00\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3<\/td><td><code>with()<\/code> \u3092\u4f7f\u7528<\/td><td>\u30af\u30a8\u30ea\u6761\u4ef6\u306e\u4e00\u81f4\u3092\u78ba\u8a8d<\/td><\/tr><tr><td>\u8907\u6570\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3<\/td><td><code>with(['relation1', 'relation2'])<\/code><\/td><td>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306b\u6ce8\u610f<\/td><\/tr><tr><td>\u6761\u4ef6\u4ed8\u304d\u30ed\u30fc\u30c9<\/td><td><code>when()<\/code> \u3068\u7d44\u307f\u5408\u308f\u305b\u308b<\/td><td>\u4e0d\u8981\u306a\u30ed\u30fc\u30c9\u3092\u907f\u3051\u308b<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-14\">\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">whereHas\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u6700\u9069\u5316\u3059\u308b\u306b\u306f\u3001\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u304c\u4e0d\u53ef\u6b20\u3067\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=\"\">\/\/ \u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u5b9a\u4f8b\nclass CreateCommentsTable extends Migration\n{\n    public function up()\n    {\n        Schema::create('comments', function (Blueprint $table) {\n            $table-&gt;id();\n            $table-&gt;foreignId('post_id')-&gt;constrained();\n            $table-&gt;boolean('is_approved')-&gt;default(false);\n            $table-&gt;timestamps();\n\n            \/\/ \u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u4f5c\u6210\n            $table-&gt;index(['post_id', 'is_approved']);\n        });\n    }\n}\n\n\/\/ \u30af\u30a8\u30ea\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u5206\u6790\n$explain = DB::select('EXPLAIN SELECT * FROM posts WHERE EXISTS (\n    SELECT * FROM comments \n    WHERE posts.id = comments.post_id \n    AND comments.is_approved = true\n)');<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u306e\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u5916\u90e8\u30ad\u30fc\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9<\/strong><\/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\u5916\u90e8\u30ad\u30fc\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\n$table-&gt;foreign('user_id')-&gt;references('id')-&gt;on('users')-&gt;index();\n\n\/\/ \u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u5fc5\u8981\u306a\u5834\u5408\n$table-&gt;index(['user_id', 'status']);<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u691c\u7d22\u6761\u4ef6\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9<\/strong><\/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=\"\">\/\/ \u983b\u7e41\u306b\u4f7f\u7528\u3055\u308c\u308b\u691c\u7d22\u6761\u4ef6\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\n$table-&gt;index(['status', 'created_at']);\n\n\/\/ \u90e8\u5206\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u6d3b\u7528\uff08PostgreSQL\u306e\u5834\u5408\uff09\n\/\/ migration\u5185\u3067\u5b9f\u884c\nDB::statement('CREATE INDEX comments_approved_idx ON comments (post_id) WHERE is_approved = true');<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-15\">\u30af\u30a8\u30ea\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">whereHas\u3092\u4f7f\u7528\u3057\u305f\u30af\u30a8\u30ea\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u3092\u5b9f\u88c5\u3057\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=\"\">class PostRepository\n{\n    \/\/ \u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u6d3b\u7528\u3057\u305f\u30af\u30a8\u30ea\u306e\u5b9f\u88c5\n    public function getApprovedCommentPosts($minutes = 60)\n    {\n        $cacheKey = 'posts_with_approved_comments';\n\n        return Cache::remember($cacheKey, now()-&gt;addMinutes($minutes), function() {\n            return Post::whereHas('comments', function($query) {\n                $query-&gt;where('is_approved', true);\n            })\n            -&gt;with(['comments' =&gt; function($query) {\n                $query-&gt;where('is_approved', true);\n            }])\n            -&gt;get();\n        });\n    }\n\n    \/\/ \u30bf\u30b0\u4ed8\u304d\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u5b9f\u88c5\n    public function getPostsByTag($tagName, $minutes = 30)\n    {\n        $cacheKey = \"posts_with_tag_{$tagName}\";\n\n        return Cache::tags(['posts', 'tags'])-&gt;remember($cacheKey, \n            now()-&gt;addMinutes($minutes), function() use ($tagName) {\n                return Post::whereHas('tags', function($query) use ($tagName) {\n                    $query-&gt;where('name', $tagName);\n                })-&gt;with('tags')-&gt;get();\n        });\n    }\n\n    \/\/ \u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u81ea\u52d5\u66f4\u65b0\n    public function updatePost($post)\n    {\n        DB::transaction(function() use ($post) {\n            $post-&gt;save();\n            Cache::tags(['posts'])-&gt;flush();\n        });\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\nclass PostController extends Controller\n{\n    protected $repository;\n\n    public function __construct(PostRepository $repository)\n    {\n        $this-&gt;repository = $repository;\n    }\n\n    public function index($tagName = null)\n    {\n        if ($tagName) {\n            return $this-&gt;repository-&gt;getPostsByTag($tagName);\n        }\n        return $this-&gt;repository-&gt;getApprovedCommentPosts();\n    }\n}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306e\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30af\u30a8\u30ea\u306e\u76e3\u8996<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30af\u30a8\u30ea\u30ed\u30b0\u306e\u5b9a\u671f\u7684\u306a\u78ba\u8a8d<\/li>\n\n\n\n<li>\u5b9f\u884c\u6642\u9593\u306e\u8a08\u6e2c<\/li>\n\n\n\n<li>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u7ba1\u7406<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5b9a\u671f\u7684\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u4f7f\u7528\u72b6\u6cc1\u306e\u78ba\u8a8d<\/li>\n\n\n\n<li>\u4e0d\u8981\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u524a\u9664<\/li>\n\n\n\n<li>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u518d\u69cb\u7bc9<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u6709\u52b9\u671f\u9650\u306e\u9069\u5207\u306a\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u30bf\u30b0\u306e\u52b9\u679c\u7684\u306a\u4f7f\u7528<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u30af\u30ea\u30a2\u6761\u4ef6\u306e\u660e\u78ba\u5316<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\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\u3001whereHas\u3092\u4f7f\u7528\u3057\u305f\u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5927\u5e45\u306b\u6539\u5584\u3067\u304d\u307e\u3059\u3002\u7279\u306b\u5927\u898f\u6a21\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u306f\u3001\u3053\u308c\u3089\u306e\u6700\u9069\u5316\u304c\u91cd\u8981\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-16\">whereHas\u306e\u5b9f\u8df5\u7684\u306a\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-17\">E\u30b3\u30de\u30fc\u30b9\u3067\u306e\u5546\u54c1\u691c\u7d22\u6a5f\u80fd\u306e\u5b9f\u88c5<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">E\u30b3\u30de\u30fc\u30b9\u30b5\u30a4\u30c8\u3067\u306e\u5546\u54c1\u691c\u7d22\u306f\u3001\u8907\u6570\u306e\u6761\u4ef6\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u8907\u96d1\u306a\u30af\u30a8\u30ea\u304c\u5fc5\u8981\u306b\u306a\u308a\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=\"\">class Product extends Model\n{\n    public function categories()\n    {\n        return $this-&gt;belongsToMany(Category::class);\n    }\n\n    public function variants()\n    {\n        return $this-&gt;hasMany(ProductVariant::class);\n    }\n\n    public function reviews()\n    {\n        return $this-&gt;hasMany(Review::class);\n    }\n\n    \/\/ \u5728\u5eab\u306e\u3042\u308b\u5546\u54c1\u306e\u30b9\u30b3\u30fc\u30d7\n    public function scopeInStock($query)\n    {\n        return $query-&gt;whereHas('variants', function($q) {\n            $q-&gt;where('stock', '&gt;', 0);\n        });\n    }\n\n    \/\/ \u8a55\u4fa1\u306e\u9ad8\u3044\u5546\u54c1\u306e\u30b9\u30b3\u30fc\u30d7\n    public function scopeHighlyRated($query, $minRating = 4)\n    {\n        return $query-&gt;whereHas('reviews', function($q) use ($minRating) {\n            $q-&gt;having(DB::raw('AVG(rating)'), '&gt;=', $minRating);\n        });\n    }\n}\n\nclass ProductController extends Controller\n{\n    public function search(Request $request)\n    {\n        $query = Product::query();\n\n        \/\/ \u30ab\u30c6\u30b4\u30ea\u30fc\u306b\u3088\u308b\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\n        if ($request-&gt;has('category')) {\n            $query-&gt;whereHas('categories', function($q) use ($request) {\n                $q-&gt;where('slug', $request-&gt;category);\n            });\n        }\n\n        \/\/ \u4fa1\u683c\u5e2f\u306b\u3088\u308b\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\n        if ($request-&gt;has('price_range')) {\n            $query-&gt;whereHas('variants', function($q) use ($request) {\n                [$min, $max] = explode('-', $request-&gt;price_range);\n                $q-&gt;whereBetween('price', [$min, $max]);\n            });\n        }\n\n        \/\/ \u5728\u5eab\u72b6\u6cc1\u3067\u306e\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\n        if ($request-&gt;has('in_stock')) {\n            $query-&gt;inStock();\n        }\n\n        \/\/ \u8a55\u4fa1\u306b\u3088\u308b\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\n        if ($request-&gt;has('min_rating')) {\n            $query-&gt;highlyRated($request-&gt;min_rating);\n        }\n\n        return $query-&gt;with(['categories', 'variants', 'reviews'])\n                    -&gt;paginate(20);\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-18\">\u30d6\u30ed\u30b0\u30b7\u30b9\u30c6\u30e0\u3067\u306e\u30bf\u30b0\u4ed8\u304d\u8a18\u4e8b\u691c\u7d22<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30d6\u30ed\u30b0\u30b7\u30b9\u30c6\u30e0\u3067\u306f\u3001\u30bf\u30b0\u3084\u30ab\u30c6\u30b4\u30ea\u30fc\u3092\u4f7f\u3063\u305f\u8a18\u4e8b\u306e\u691c\u7d22\u304c\u4e00\u822c\u7684\u3067\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=\"\">class Post extends Model\n{\n    public function tags()\n    {\n        return $this-&gt;belongsToMany(Tag::class);\n    }\n\n    public function author()\n    {\n        return $this-&gt;belongsTo(User::class, 'user_id');\n    }\n\n    public function comments()\n    {\n        return $this-&gt;hasMany(Comment::class);\n    }\n\n    \/\/ \u4eba\u6c17\u8a18\u4e8b\u306e\u30b9\u30b3\u30fc\u30d7\n    public function scopePopular($query)\n    {\n        return $query-&gt;whereHas('comments', function($q) {\n            $q-&gt;where('created_at', '&gt;=', now()-&gt;subDays(30));\n        }, '&gt;=', 5);\n    }\n}\n\nclass BlogController extends Controller\n{\n    public function index(Request $request)\n    {\n        $query = Post::query()-&gt;with(['tags', 'author', 'comments']);\n\n        \/\/ \u8907\u6570\u30bf\u30b0\u3067\u306e\u691c\u7d22\n        if ($request-&gt;has('tags')) {\n            $tagSlugs = explode(',', $request-&gt;tags);\n            foreach ($tagSlugs as $slug) {\n                $query-&gt;whereHas('tags', function($q) use ($slug) {\n                    $q-&gt;where('slug', $slug);\n                });\n            }\n        }\n\n        \/\/ \u7279\u5b9a\u306e\u8457\u8005\u306e\u4eba\u6c17\u8a18\u4e8b\n        if ($request-&gt;has('author')) {\n            $query-&gt;whereHas('author', function($q) use ($request) {\n                $q-&gt;where('username', $request-&gt;author);\n            })-&gt;popular();\n        }\n\n        return $query-&gt;latest()-&gt;paginate(15);\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-19\">\u30bd\u30fc\u30b7\u30e3\u30eb\u30e1\u30c7\u30a3\u30a2\u3067\u306e\u30e6\u30fc\u30b6\u30fc\u95a2\u9023\u691c\u7d22<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30bd\u30fc\u30b7\u30e3\u30eb\u30e1\u30c7\u30a3\u30a2\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u306e\u8907\u96d1\u306a\u691c\u7d22\u6a5f\u80fd\u306e\u5b9f\u88c5\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=\"\">class User extends Model\n{\n    public function followers()\n    {\n        return $this-&gt;belongsToMany(User::class, 'followers', 'followed_id', 'follower_id');\n    }\n\n    public function following()\n    {\n        return $this-&gt;belongsToMany(User::class, 'followers', 'follower_id', 'followed_id');\n    }\n\n    public function posts()\n    {\n        return $this-&gt;hasMany(Post::class);\n    }\n\n    public function interests()\n    {\n        return $this-&gt;belongsToMany(Interest::class);\n    }\n}\n\nclass UserSearchService\n{\n    public function findPotentialConnections(User $user)\n    {\n        \/\/ \u5171\u901a\u306e\u8208\u5473\u3092\u6301\u3064\u30d5\u30a9\u30ed\u30ef\u30fc\u306e\u30d5\u30a9\u30ed\u30ef\u30fc\u3092\u691c\u7d22\n        return User::whereHas('interests', function($query) use ($user) {\n            $query-&gt;whereIn('id', $user-&gt;interests-&gt;pluck('id'));\n        })\n        -&gt;whereHas('followers', function($query) use ($user) {\n            $query-&gt;whereIn('follower_id', $user-&gt;followers-&gt;pluck('id'));\n        })\n        -&gt;where('id', '!=', $user-&gt;id)\n        -&gt;whereDoesntHave('followers', function($query) use ($user) {\n            $query-&gt;where('follower_id', $user-&gt;id);\n        })\n        -&gt;withCount(['followers', 'following', 'posts'])\n        -&gt;having('followers_count', '&gt;=', 5)\n        -&gt;get();\n    }\n\n    public function findActiveUsersInNetwork(User $user)\n    {\n        $thirtyDaysAgo = now()-&gt;subDays(30);\n\n        return User::whereHas('following', function($query) use ($user) {\n            $query-&gt;where('followed_id', $user-&gt;id);\n        })\n        -&gt;whereHas('posts', function($query) use ($thirtyDaysAgo) {\n            $query-&gt;where('created_at', '&gt;=', $thirtyDaysAgo);\n        }, '&gt;=', 5)\n        -&gt;withCount(['posts' =&gt; function($query) use ($thirtyDaysAgo) {\n            $query-&gt;where('created_at', '&gt;=', $thirtyDaysAgo);\n        }])\n        -&gt;orderBy('posts_count', 'desc')\n        -&gt;get();\n    }\n}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9f\u88c5\u306e\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n<div id=\"id-fe0af275-00c8-4043-a677-ee2d251a413e\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/th><th>\u91cd\u8981\u306a\u8003\u616e\u70b9<\/th><th>\u6700\u9069\u5316\u30a2\u30d7\u30ed\u30fc\u30c1<\/th><\/tr><\/thead><tbody><tr><td>E\u30b3\u30de\u30fc\u30b9<\/td><td>\u691c\u7d22\u6761\u4ef6\u306e\u67d4\u8edf\u6027<\/td><td>\u30b9\u30b3\u30fc\u30d7\u306e\u6d3b\u7528\u3068\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565<\/td><\/tr><tr><td>\u30d6\u30ed\u30b0<\/td><td>\u30b3\u30f3\u30c6\u30f3\u30c4\u306e\u95a2\u9023\u6027<\/td><td>\u30bf\u30b0\u30d9\u30fc\u30b9\u306e\u691c\u7d22\u6700\u9069\u5316<\/td><\/tr><tr><td>SNS<\/td><td>\u30e6\u30fc\u30b6\u30fc\u95a2\u4fc2\u306e\u8907\u96d1\u6027<\/td><td>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u3068\u6761\u4ef6\u306e\u5206\u5272<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">\u3053\u308c\u3089\u306e\u5b9f\u88c5\u4f8b\u306f\u3001whereHas\u3092\u4f7f\u7528\u3057\u305f\u5b9f\u8df5\u7684\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u958b\u767a\u306e\u57fa\u790e\u3068\u306a\u308a\u307e\u3059\u3002\u7279\u306b\u3001\u8907\u96d1\u306a\u30d3\u30b8\u30cd\u30b9\u30ed\u30b8\u30c3\u30af\u3092\u52b9\u7387\u7684\u306b\u5b9f\u88c5\u3059\u308b\u969b\u306e\u53c2\u8003\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-20\">whereHas\u306e\u30c7\u30d0\u30c3\u30b0\u3068\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-21\">\u4e00\u822c\u7684\u306a\u30a8\u30e9\u30fc\u30d1\u30bf\u30fc\u30f3\u3068\u89e3\u6c7a\u65b9\u6cd5<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">whereHas\u3092\u4f7f\u7528\u3059\u308b\u969b\u306b\u3088\u304f\u906d\u9047\u3059\u308b\u30a8\u30e9\u30fc\u3068\u305d\u306e\u89e3\u6c7a\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u540d\u306e\u8aa4\u308a<\/strong><\/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=\"\">\/\/ \u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u30b3\u30fc\u30c9\n$posts = Post::whereHas('comment', function($query) { \/\/ 'comments'\u304c\u6b63\u3057\u3044\n    $query-&gt;where('is_approved', true);\n})-&gt;get();\n\n\/\/ \u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\n\/\/ Illuminate\\Database\\Eloquent\\RelationNotFoundException: Call to undefined relationship [comment] on model [App\\Models\\Post].\n\n\/\/ \u89e3\u6c7a\u65b9\u6cd5\nclass Post extends Model\n{\n    \/\/ \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u540d\u3092\u6b63\u3057\u304f\u5b9a\u7fa9\n    public function comments() \/\/ \u8907\u6570\u5f62\u304c\u6b63\u3057\u3044\n    {\n        return $this-&gt;hasMany(Comment::class);\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30af\u30ed\u30fc\u30b8\u30e3\u5185\u3067\u306e\u30b9\u30b3\u30fc\u30d7\u554f\u984c<\/strong><\/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=\"\">\/\/ \u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u30b3\u30fc\u30c9\n$status = 'approved';\n$posts = Post::whereHas('comments', function($query) {\n    $query-&gt;where('status', $status); \/\/ $status\u304c\u672a\u5b9a\u7fa9\n})-&gt;get();\n\n\/\/ \u89e3\u6c7a\u65b9\u6cd5\n$status = 'approved';\n$posts = Post::whereHas('comments', function($query) use ($status) {\n    $query-&gt;where('status', $status);\n})-&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>N+1\u554f\u984c\u306e\u691c\u51fa\u3068\u89e3\u6c7a<\/strong><\/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\\DB::enableQueryLog();\n\n$posts = Post::whereHas('comments')-&gt;get();\nforeach ($posts as $post) {\n    echo $post-&gt;comments-&gt;count();\n}\n\n\/\/ \u30af\u30a8\u30ea\u30ed\u30b0\u306e\u78ba\u8a8d\ndd(\\DB::getQueryLog()); \/\/ \u591a\u6570\u306e\u30af\u30a8\u30ea\u304c\u5b9f\u884c\u3055\u308c\u3066\u3044\u308b\n\n\/\/ \u89e3\u6c7a\u65b9\u6cd5\n$posts = Post::whereHas('comments')\n    -&gt;with('comments')\n    -&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-22\">\u30af\u30a8\u30ea\u30ed\u30b0\u3092\u4f7f\u7528\u3057\u305f\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u5206\u6790<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5206\u6790\u3057\u3001\u6700\u9069\u5316\u3059\u308b\u65b9\u6cd5\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=\"\">class QueryDebugService\n{\n    public function analyzeQuery($callback)\n    {\n        \/\/ \u30af\u30a8\u30ea\u30ed\u30b0\u306e\u6709\u52b9\u5316\n        \\DB::enableQueryLog();\n\n        \/\/ \u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u8a18\u9332\u958b\u59cb\n        $initialMemory = memory_get_usage();\n\n        \/\/ \u5b9f\u884c\u6642\u9593\u306e\u8a08\u6e2c\u958b\u59cb\n        $startTime = microtime(true);\n\n        \/\/ \u30af\u30a8\u30ea\u306e\u5b9f\u884c\n        $result = $callback();\n\n        \/\/ \u5b9f\u884c\u6642\u9593\u306e\u8a08\u6e2c\u7d42\u4e86\n        $endTime = microtime(true);\n\n        \/\/ \u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u8a08\u7b97\n        $memoryUsed = memory_get_usage() - $initialMemory;\n\n        \/\/ \u30af\u30a8\u30ea\u30ed\u30b0\u306e\u53d6\u5f97\n        $queryLog = \\DB::getQueryLog();\n\n        \/\/ \u5206\u6790\u7d50\u679c\u306e\u51fa\u529b\n        return [\n            'execution_time' =&gt; ($endTime - $startTime) * 1000 . 'ms',\n            'memory_used' =&gt; $this-&gt;formatBytes($memoryUsed),\n            'query_count' =&gt; count($queryLog),\n            'queries' =&gt; collect($queryLog)-&gt;map(function($query) {\n                return [\n                    'sql' =&gt; $query['query'],\n                    'bindings' =&gt; $query['bindings'],\n                    'time' =&gt; $query['time'] . 'ms'\n                ];\n            })\n        ];\n    }\n\n    private function formatBytes($bytes)\n    {\n        $units = ['B', 'KB', 'MB', 'GB'];\n        $bytes = max($bytes, 0);\n        $pow = floor(($bytes ? log($bytes) : 0) \/ log(1024));\n        $pow = min($pow, count($units) - 1);\n\n        return round($bytes \/ (1024 ** $pow), 2) . ' ' . $units[$pow];\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\nclass PostController extends Controller\n{\n    protected $debugService;\n\n    public function __construct(QueryDebugService $debugService)\n    {\n        $this-&gt;debugService = $debugService;\n    }\n\n    public function index()\n    {\n        $analysis = $this-&gt;debugService-&gt;analyzeQuery(function() {\n            return Post::whereHas('comments', function($query) {\n                $query-&gt;where('is_approved', true);\n            })-&gt;with('comments')-&gt;get();\n        });\n\n        dd($analysis);\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-23\">\u30c6\u30b9\u30c8\u6642\u306e\u52b9\u679c\u7684\u306a\u30e2\u30c3\u30af\u65b9\u6cd5<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">whereHas\u3092\u4f7f\u7528\u3059\u308b\u30b3\u30fc\u30c9\u306e\u30c6\u30b9\u30c8\u65b9\u6cd5\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=\"\">class PostTest extends TestCase\n{\n    use RefreshDatabase;\n\n    \/** @test *\/\n    public function it_can_get_posts_with_approved_comments()\n    {\n        \/\/ \u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u306e\u6e96\u5099\n        $postWithApprovedComments = Post::factory()-&gt;create();\n        $postWithoutApprovedComments = Post::factory()-&gt;create();\n\n        Comment::factory()\n            -&gt;count(3)\n            -&gt;for($postWithApprovedComments)\n            -&gt;create(['is_approved' =&gt; true]);\n\n        Comment::factory()\n            -&gt;count(2)\n            -&gt;for($postWithoutApprovedComments)\n            -&gt;create(['is_approved' =&gt; false]);\n\n        \/\/ whereHas\u3092\u4f7f\u7528\u3057\u305f\u30af\u30a8\u30ea\u306e\u30c6\u30b9\u30c8\n        $posts = Post::whereHas('comments', function($query) {\n            $query-&gt;where('is_approved', true);\n        })-&gt;get();\n\n        $this-&gt;assertCount(1, $posts);\n        $this-&gt;assertTrue($posts-&gt;contains($postWithApprovedComments));\n        $this-&gt;assertFalse($posts-&gt;contains($postWithoutApprovedComments));\n    }\n\n    \/** @test *\/\n    public function it_can_get_posts_with_multiple_conditions()\n    {\n        \/\/ \u8907\u96d1\u306a\u6761\u4ef6\u306e\u30c6\u30b9\u30c8\n        $post = Post::factory()-&gt;create();\n        $user = User::factory()-&gt;create(['is_admin' =&gt; true]);\n\n        Comment::factory()\n            -&gt;count(5)\n            -&gt;for($post)\n            -&gt;for($user)\n            -&gt;create(['is_approved' =&gt; true]);\n\n        $posts = Post::whereHas('comments', function($query) {\n            $query-&gt;where('is_approved', true);\n        }, '&gt;=', 5)\n        -&gt;whereHas('comments.user', function($query) {\n            $query-&gt;where('is_admin', true);\n        })\n        -&gt;get();\n\n        $this-&gt;assertCount(1, $posts);\n        $this-&gt;assertTrue($posts-&gt;contains($post));\n    }\n}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30d0\u30c3\u30b0\u3068\u30c6\u30b9\u30c8\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\uff1a<\/p>\n\n\n<div id=\"id-85107ffe-8047-4bdd-ada8-4ea261508ad6\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30ab\u30c6\u30b4\u30ea<\/th><th>\u63a8\u5968\u30a2\u30d7\u30ed\u30fc\u30c1<\/th><th>\u6ce8\u610f\u70b9<\/th><\/tr><\/thead><tbody><tr><td>\u30a8\u30e9\u30fc\u691c\u51fa<\/td><td>\u30af\u30a8\u30ea\u30ed\u30b0\u306e\u6d3b\u7528<\/td><td>\u672c\u756a\u74b0\u5883\u3067\u306e\u7121\u52b9\u5316<\/td><\/tr><tr><td>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9<\/td><td>\u6bb5\u968e\u7684\u306a\u8a08\u6e2c<\/td><td>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u76e3\u8996<\/td><\/tr><tr><td>\u30c6\u30b9\u30c8<\/td><td>\u30d5\u30a1\u30af\u30c8\u30ea\u306e\u6d3b\u7528<\/td><td>\u30c7\u30fc\u30bf\u6e96\u5099\u306e\u81ea\u52d5\u5316<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">\u3053\u308c\u3089\u306e\u30c7\u30d0\u30c3\u30b0\u3068\u30c6\u30b9\u30c8\u624b\u6cd5\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001whereHas\u3092\u4f7f\u7528\u3057\u305f\u30b3\u30fc\u30c9\u306e\u4fe1\u983c\u6027\u3068\u4fdd\u5b88\u6027\u3092\u9ad8\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u7279\u306b\u3001\u8907\u96d1\u306a\u30af\u30a8\u30ea\u306e\u52d5\u4f5c\u78ba\u8a8d\u3084\u6027\u80fd\u6700\u9069\u5316\u306e\u969b\u306b\u5f79\u7acb\u3061\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":["post-3267","post","type-post","status-publish","format-standard","category-php-laravel","category-php","nothumb"],"_links":{"self":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/3267","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=3267"}],"version-history":[{"count":2,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/3267\/revisions"}],"predecessor-version":[{"id":3269,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/3267\/revisions\/3269"}],"wp:attachment":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}