{"id":3273,"date":"2025-03-24T08:46:33","date_gmt":"2025-03-23T23:46:33","guid":{"rendered":"https:\/\/dexall.co.jp\/articles\/?p=3273"},"modified":"2025-03-24T08:47:03","modified_gmt":"2025-03-23T23:47:03","slug":"laravel%e3%81%aewith%e3%83%a1%e3%82%bd%e3%83%83%e3%83%89%e3%82%92%e5%ae%8c%e5%85%a8%e6%94%bb%e7%95%a5%ef%bc%81%e3%83%91%e3%83%95%e3%82%a9%e3%83%bc%e3%83%9e%e3%83%b3%e3%82%b9%e3%81%8c3%e5%80%8d","status":"publish","type":"post","link":"https:\/\/dexall.co.jp\/articles\/?p=3273","title":{"rendered":"Laravel\u306eWith\u30e1\u30bd\u30c3\u30c9\u3092\u5b8c\u5168\u653b\u7565\uff01\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c3\u500d\u5411\u4e0a\u3059\u308b7\u3064\u306e\u5b9f\u8df5\u30c6\u30af\u30cb\u30c3\u30af"},"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\">With\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u790e\u3068\u91cd\u8981\u6027<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-1\">N+1\u554f\u984c\u3092\u89e3\u6c7a\u3059\u308b\u5f37\u529b\u306a\u6b66\u5668<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-2\">Eloquent\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u52b9\u7387\u30ed\u30fc\u30c9\u65b9\u6cd5<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-3\">With\u30e1\u30bd\u30c3\u30c9\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-4\">\u30b9\u30c6\u30c3\u30d71\uff1a\u6b63\u3057\u3044\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u9078\u629e<\/a>      <\/li>      <li>        <a href=\"#i-5\">\u30b9\u30c6\u30c3\u30d72\uff1a\u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u3092\u53d6\u5f97\u3059\u308b\u6700\u9069\u5316<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-6\">\u30b9\u30c6\u30c3\u30d73\uff1a\u30cd\u30b9\u30c8\u5316\u3055\u308c\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u52b9\u7387\u7684\u306a\u30ed\u30fc\u30c9<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-7\">\u5b9f\u8df5\u7684\u306aWith\u30e1\u30bd\u30c3\u30c9\u306e\u6d3b\u7528\u30d1\u30bf\u30fc\u30f3<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-8\">\u8907\u6570\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u540c\u6642\u30ed\u30fc\u30c9\u624b\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-9\">\u6761\u4ef6\u4ed8\u304d\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u30ed\u30fc\u30c9\u6226\u7565<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-10\">\u30ab\u30a6\u30f3\u30c8\u3068\u5171\u306b\u4f7f\u7528\u3059\u308b\u624b\u6cd5<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-11\">With\u30e1\u30bd\u30c3\u30c9\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-12\">\u30af\u30a8\u30ea\u30ed\u30b0\u3092\u6d3b\u7528\u3057\u305f\u554f\u984c\u7279\u5b9a\u65b9\u6cd5<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-13\">\u4e00\u822c\u7684\u306a\u554f\u984c\u3068\u89e3\u6c7a\u30a2\u30d7\u30ed\u30fc\u30c1<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-17\">With\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u305f\u5b9f\u88c5\u4f8b<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-18\">EC\u30b5\u30a4\u30c8\u3067\u306e\u5546\u54c1\u4e00\u89a7\u8868\u793a\u306e\u6700\u9069\u5316\u4e8b\u4f8b<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-19\">\u30d6\u30ed\u30b0\u30b7\u30b9\u30c6\u30e0\u3067\u306e\u30b3\u30e1\u30f3\u30c8\u8868\u793a\u306e\u52b9\u7387\u5316<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-20\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u8a08\u6e2c\u3068\u6539\u5584\u52b9\u679c\u306e\u691c\u8a3c<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-21\">\u5b9f\u969b\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6539\u5584\u6570\u5024<\/a>      <\/li>      <li>        <a href=\"#i-22\">\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u6700\u9069\u5316\u52b9\u679c<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-23\">\u6539\u5584\u52b9\u679c\u306e\u53ef\u8996\u5316\u3068\u5206\u6790<\/a>      <\/li>    <\/ul>  <\/li>  <li class=\"last\">    <a href=\"#i-24\">With\u30e1\u30bd\u30c3\u30c9\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u3068\u307e\u3068\u3081<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-25\">\u73fe\u5834\u3067\u4f7f\u3048\u308b\u5177\u4f53\u7684\u306a\u5b9f\u88c5\u306e\u8996\u70b9<\/a>      <\/li>      <li>        <a href=\"#i-28\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306e\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-32\">\u307e\u3068\u3081<\/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\">With\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u790e\u3068\u91cd\u8981\u6027<\/h2>\n\n\n\n<p>Laravel\u958b\u767a\u306b\u304a\u3044\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u306e\u52b9\u7387\u7684\u306a\u9023\u643a\u306f\u975e\u5e38\u306b\u91cd\u8981\u3067\u3059\u3002\u7279\u306b\u3001\u95a2\u9023\u3059\u308b\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u969b\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u5168\u4f53\u306e\u5fdc\u7b54\u6027\u306b\u5927\u304d\u306a\u5f71\u97ff\u3092\u4e0e\u3048\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001Laravel\u306e<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u790e\u3068\u3001\u305d\u306e\u91cd\u8981\u6027\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-1\">N+1\u554f\u984c\u3092\u89e3\u6c7a\u3059\u308b\u5f37\u529b\u306a\u6b66\u5668<\/h3>\n\n\n\n<p>N+1\u554f\u984c\u306f\u3001\u591a\u304f\u306eWeb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u958b\u767a\u8005\u304c\u76f4\u9762\u3059\u308b\u5178\u578b\u7684\u306a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u554f\u984c\u3067\u3059\u3002\u4ee5\u4e0b\u306e\u4f8b\u3067\u5177\u4f53\u7684\u306b\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/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\u4f8b\n$posts = Post::all();\nforeach ($posts as $post) {\n    echo $post-&gt;author-&gt;name; \/\/ \u5404\u6295\u7a3f\u3054\u3068\u306b\u5225\u500b\u306eSQL\u30af\u30a8\u30ea\u304c\u767a\u884c\u3055\u308c\u308b\n}\n\n\/\/ \u5b9f\u884c\u3055\u308c\u308bSQL\u30af\u30a8\u30ea\n\/\/ SELECT * FROM posts;\n\/\/ SELECT * FROM authors WHERE id = 1;\n\/\/ SELECT * FROM authors WHERE id = 2;\n\/\/ SELECT * FROM authors WHERE id = 3;\n\/\/ ...<\/pre>\n\n\n\n<p>\u3053\u306e\u554f\u984c\u306b\u5bfe\u3057\u3066\u3001<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u52b9\u7387\u7684\u306a\u89e3\u6c7a\u7b56\u3092\u63d0\u4f9b\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=\"\">\/\/ with\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u305f\u6700\u9069\u5316\u4f8b\n$posts = Post::with('author')-&gt;get();\nforeach ($posts as $post) {\n    echo $post-&gt;author-&gt;name; \/\/ \u8ffd\u52a0\u306e\u30af\u30a8\u30ea\u306f\u767a\u751f\u3057\u306a\u3044\n}\n\n\/\/ \u5b9f\u884c\u3055\u308c\u308bSQL\u30af\u30a8\u30ea\n\/\/ SELECT * FROM posts;\n\/\/ SELECT * FROM authors WHERE id IN (1, 2, 3, ...);<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-2\">Eloquent\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u52b9\u7387\u30ed\u30fc\u30c9\u65b9\u6cd5<\/h3>\n\n\n\n<p>Eloquent\u3067\u306f\u3001\u69d8\u3005\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u578b\u306b\u5bfe\u5fdc\u3057\u305f<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u306e\u4f7f\u7528\u65b9\u6cd5\u304c\u3042\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=\"\">\/\/ 1. \u5358\u4e00\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n$posts = Post::with('author')-&gt;get();\n\n\/\/ 2. \u8907\u6570\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n$posts = Post::with(['author', 'comments'])-&gt;get();\n\n\/\/ 3. \u30cd\u30b9\u30c8\u3055\u308c\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n$posts = Post::with('comments.user')-&gt;get();\n\n\/\/ 4. \u7279\u5b9a\u306e\u30ab\u30e9\u30e0\u306e\u307f\u53d6\u5f97\n$posts = Post::with('author:id,name')-&gt;get();<\/pre>\n\n\n\n<p>\u5404\u30d1\u30bf\u30fc\u30f3\u306e\u7279\u5fb4\u3068\u4f7f\u7528\u5834\u9762\uff1a<\/p>\n\n\n<div id=\"id-ce37f943-b01c-411e-81cf-3e7167d50c58\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30d1\u30bf\u30fc\u30f3<\/th><th>\u4f7f\u7528\u5834\u9762<\/th><th>\u7279\u5fb4<\/th><\/tr><\/thead><tbody><tr><td>\u5358\u4e00\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3<\/td><td>1\u5bfe1\u30011\u5bfe\u591a\u306e\u57fa\u672c\u7684\u306a\u95a2\u9023\u30c7\u30fc\u30bf\u53d6\u5f97<\/td><td>\u30b7\u30f3\u30d7\u30eb\u3067\u5206\u304b\u308a\u3084\u3059\u3044<\/td><\/tr><tr><td>\u8907\u6570\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3<\/td><td>\u8907\u6570\u306e\u95a2\u9023\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u304c\u5fc5\u8981\u306a\u5834\u5408<\/td><td>1\u56de\u306e\u30af\u30a8\u30ea\u3067\u8907\u6570\u306e\u95a2\u9023\u30c7\u30fc\u30bf\u3092\u53d6\u5f97<\/td><\/tr><tr><td>\u30cd\u30b9\u30c8\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3<\/td><td>\u968e\u5c64\u7684\u306a\u30c7\u30fc\u30bf\u69cb\u9020\u304c\u5fc5\u8981\u306a\u5834\u5408<\/td><td>\u6df1\u3044\u968e\u5c64\u306e\u30c7\u30fc\u30bf\u3082\u52b9\u7387\u7684\u306b\u53d6\u5f97<\/td><\/tr><tr><td>\u30ab\u30e9\u30e0\u6307\u5b9a<\/td><td>\u5fc5\u8981\u6700\u5c0f\u9650\u306e\u30c7\u30fc\u30bf\u306e\u307f\u53d6\u5f97\u3057\u305f\u3044\u5834\u5408<\/td><td>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3068\u30af\u30a8\u30ea\u6642\u9593\u3092\u524a\u6e1b<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<p>\u4ee5\u4e0a\u306e\u57fa\u790e\u7684\u306a\u4f7f\u3044\u65b9\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u3067\u3001<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u3092\u52b9\u679c\u7684\u306b\u6d3b\u7528\u3057\u3066\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u3055\u3089\u306b\u8e0f\u307f\u8fbc\u3093\u3060\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\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-3\">With\u30e1\u30bd\u30c3\u30c9\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af<\/h2>\n\n\n\n<p>Laravel\u306e<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3059\u308b\u969b\u3001\u9069\u5207\u306a\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af\u3092\u9069\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5927\u5e45\u306b\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u30013\u3064\u306e\u91cd\u8981\u306a\u30b9\u30c6\u30c3\u30d7\u306b\u5206\u3051\u3066\u3001\u5177\u4f53\u7684\u306a\u6700\u9069\u5316\u624b\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-4\">\u30b9\u30c6\u30c3\u30d71\uff1a\u6b63\u3057\u3044\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u9078\u629e<\/h3>\n\n\n\n<p>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u9078\u629e\u306f\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306e\u51fa\u767a\u70b9\u3068\u306a\u308a\u307e\u3059\u3002\u9069\u5207\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u9078\u629e\u3059\u308b\u3053\u3068\u3067\u3001\u4e0d\u8981\u306a\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3092\u9632\u304e\u3001\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u6291\u5236\u3067\u304d\u307e\u3059\u3002<\/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=\"\">\/\/ \u826f\u304f\u306a\u3044\u4f8b\uff1a\u3059\u3079\u3066\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u53d6\u5f97\n$posts = Post::with(['author', 'comments', 'categories', 'tags', 'media'])\n    -&gt;get();\n\n\/\/ \u826f\u3044\u4f8b\uff1a\u5fc5\u8981\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u307f\u3092\u9078\u629e\n$posts = Post::with(['author', 'comments' =&gt; function($query) {\n    $query-&gt;latest()-&gt;limit(5);\n}])-&gt;get();<\/pre>\n\n\n\n<p>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u9078\u629e\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u672c\u5f53\u306b\u5fc5\u8981\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u307f\u3092\u6307\u5b9a\u3059\u308b<\/li>\n\n\n\n<li>\u30af\u30ed\u30fc\u30b8\u30e3\u3092\u4f7f\u7528\u3057\u3066\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306b\u3082\u6761\u4ef6\u3092\u4ed8\u3051\u308b<\/li>\n\n\n\n<li>\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3068\u7d44\u307f\u5408\u308f\u305b\u3066\u4f7f\u7528\u3059\u308b<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-5\">\u30b9\u30c6\u30c3\u30d72\uff1a\u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u3092\u53d6\u5f97\u3059\u308b\u6700\u9069\u5316<\/h3>\n\n\n\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u53d6\u5f97\u3059\u308b\u30ab\u30e9\u30e0\u3092\u6700\u9069\u5316\u3059\u308b\u3053\u3068\u3067\u3001\u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u3001\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u6539\u5584\u3067\u304d\u307e\u3059\u3002<\/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\u6700\u9069\u5316\u4f8b\n$posts = Post::with(['author:id,name,email', 'comments:id,post_id,content'])\n    -&gt;select(['id', 'title', 'author_id'])\n    -&gt;get();\n\n\/\/ \u3088\u308a\u9ad8\u5ea6\u306a\u6700\u9069\u5316\u4f8b\n$posts = Post::with(['author' =&gt; function($query) {\n    $query-&gt;select(['id', 'name', 'email'])\n        -&gt;whereActive(true);\n}])-&gt;get();<\/pre>\n\n\n\n<p>\u30ab\u30e9\u30e0\u9078\u629e\u306e\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af\uff1a<\/p>\n\n\n<div id=\"id-f0fac48c-4592-40d7-80a8-4a791f384a36\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30c6\u30af\u30cb\u30c3\u30af<\/th><th>\u5b9f\u88c5\u65b9\u6cd5<\/th><th>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6539\u5584\u52b9\u679c<\/th><\/tr><\/thead><tbody><tr><td>\u57fa\u672c\u30ab\u30e9\u30e0\u9078\u629e<\/td><td><code>select()<\/code> \u30e1\u30bd\u30c3\u30c9\u306e\u4f7f\u7528<\/td><td>\u8ee2\u9001\u30c7\u30fc\u30bf\u91cf\u306e\u524a\u6e1b<\/td><\/tr><tr><td>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30ab\u30e9\u30e0\u9078\u629e<\/td><td>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u540d\u306b<code>:\u30ab\u30e9\u30e0\u540d<\/code>\u3092\u4ed8\u52a0<\/td><td>JOIN\u6642\u306e\u30c7\u30fc\u30bf\u91cf\u524a\u6e1b<\/td><\/tr><tr><td>\u6761\u4ef6\u4ed8\u304d\u30ab\u30e9\u30e0\u9078\u629e<\/td><td>\u30af\u30ed\u30fc\u30b8\u30e3\u5185\u3067\u306e<code>select()<\/code>\u4f7f\u7528<\/td><td>\u67d4\u8edf\u306a\u6761\u4ef6\u6307\u5b9a\u304c\u53ef\u80fd<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-6\">\u30b9\u30c6\u30c3\u30d73\uff1a\u30cd\u30b9\u30c8\u5316\u3055\u308c\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u52b9\u7387\u7684\u306a\u30ed\u30fc\u30c9<\/h3>\n\n\n\n<p>\u30cd\u30b9\u30c8\u5316\u3055\u308c\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u52b9\u7387\u7684\u306b\u30ed\u30fc\u30c9\u3059\u308b\u3053\u3068\u3067\u3001\u8907\u96d1\u306a\u30c7\u30fc\u30bf\u69cb\u9020\u3067\u3082\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u7dad\u6301\u3067\u304d\u307e\u3059\u3002<\/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\u30cd\u30b9\u30c8\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n$posts = Post::with('comments.user')\n    -&gt;get();\n\n\/\/ \u6700\u9069\u5316\u3055\u308c\u305f\u30cd\u30b9\u30c8\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n$posts = Post::with(['comments' =&gt; function($query) {\n    $query-&gt;select(['id', 'post_id', 'user_id', 'content'])\n        -&gt;with(['user' =&gt; function($query) {\n            $query-&gt;select(['id', 'name', 'email']);\n        }]);\n}])-&gt;get();\n\n\/\/ \u6761\u4ef6\u4ed8\u304d\u30cd\u30b9\u30c8\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n$posts = Post::with(['comments' =&gt; function($query) {\n    $query-&gt;whereHas('user', function($query) {\n        $query-&gt;where('role', 'admin');\n    });\n}])-&gt;get();<\/pre>\n\n\n\n<p>\u30cd\u30b9\u30c8\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u6700\u9069\u5316\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u6df1\u3055\u306e\u5236\u5fa1<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5fc5\u8981\u4ee5\u4e0a\u306b\u6df1\u3044\u30cd\u30b9\u30c8\u3092\u907f\u3051\u308b<\/li>\n\n\n\n<li>\u5404\u968e\u5c64\u3067\u5fc5\u8981\u6700\u5c0f\u9650\u306e\u30ab\u30e9\u30e0\u3092\u9078\u629e<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u6761\u4ef6\u306e\u9069\u5207\u306a\u914d\u7f6e<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>WHERE\u53e5\u3092\u9069\u5207\u306a\u968e\u5c64\u306b\u914d\u7f6e<\/li>\n\n\n\n<li>JOIN\u306e\u4f7f\u7528\u3092\u6700\u5c0f\u9650\u306b\u6291\u3048\u308b<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30e1\u30e2\u30ea\u7ba1\u7406<\/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=\"\">   \/\/ \u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u6291\u3048\u308b\u30c1\u30e3\u30f3\u30af\u51e6\u7406\n   Post::with(['comments', 'author'])\n       -&gt;chunk(100, function($posts) {\n           foreach ($posts as $post) {\n               \/\/ \u51e6\u7406\n           }\n       });<\/pre>\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<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u306e\u52b9\u679c\u3092\u6700\u5927\u9650\u306b\u5f15\u304d\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u5b9f\u969b\u306e\u4f7f\u7528\u6642\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u8981\u4ef6\u306b\u5fdc\u3058\u3066\u3001\u3053\u308c\u3089\u306e\u30c6\u30af\u30cb\u30c3\u30af\u3092\u9078\u629e\u7684\u306b\u9069\u7528\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-7\">\u5b9f\u8df5\u7684\u306aWith\u30e1\u30bd\u30c3\u30c9\u306e\u6d3b\u7528\u30d1\u30bf\u30fc\u30f3<\/h2>\n\n\n\n<p>\u5b9f\u969b\u306e\u958b\u767a\u73fe\u5834\u3067\u306f\u3001<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u3092\u3088\u308a\u9ad8\u5ea6\u306b\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u8907\u96d1\u306a\u30c7\u30fc\u30bf\u53d6\u5f97\u8981\u4ef6\u306b\u5bfe\u5fdc\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001\u5b9f\u8df5\u7684\u306a\u6d3b\u7528\u30d1\u30bf\u30fc\u30f3\u3092\u5177\u4f53\u7684\u306a\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u3068\u5171\u306b\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-8\">\u8907\u6570\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u540c\u6642\u30ed\u30fc\u30c9\u624b\u6cd5<\/h3>\n\n\n\n<p>\u8907\u6570\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u52b9\u7387\u7684\u306b\u540c\u6642\u30ed\u30fc\u30c9\u3059\u308b\u624b\u6cd5\u306f\u3001\u5927\u898f\u6a21\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u3088\u304f\u4f7f\u7528\u3055\u308c\u308b\u30d1\u30bf\u30fc\u30f3\u3067\u3059\u3002<\/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\u8907\u6570\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u30ed\u30fc\u30c9\n$orders = Order::with(['customer', 'products', 'payments'])\n    -&gt;latest()\n    -&gt;paginate(20);\n\n\/\/ \u6761\u4ef6\u4ed8\u304d\u8907\u6570\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u30ed\u30fc\u30c9\n$orders = Order::with([\n    'customer' =&gt; function($query) {\n        $query-&gt;select(['id', 'name', 'email', 'status'])\n            -&gt;where('status', 'active');\n    },\n    'products' =&gt; function($query) {\n        $query-&gt;select(['id', 'name', 'price', 'stock'])\n            -&gt;where('stock', '&gt;', 0);\n    },\n    'payments' =&gt; function($query) {\n        $query-&gt;select(['id', 'order_id', 'amount', 'status'])\n            -&gt;whereIn('status', ['completed', 'pending']);\n    }\n])-&gt;get();\n\n\/\/ \u52d5\u7684\u306a\u8907\u6570\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u30ed\u30fc\u30c9\n$relations = ['customer', 'products'];\nif (request()-&gt;includes_payments) {\n    $relations[] = 'payments';\n}\n$orders = Order::with($relations)-&gt;get();<\/pre>\n\n\n\n<p>\u5b9f\u88c5\u306e\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u914d\u5217\u306e\u69cb\u9020\u5316<\/li>\n\n\n\n<li>\u6761\u4ef6\u4ed8\u304d\u30af\u30a8\u30ea\u306e\u9069\u5207\u306a\u914d\u7f6e<\/li>\n\n\n\n<li>\u52d5\u7684\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5236\u5fa1<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-9\">\u6761\u4ef6\u4ed8\u304d\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u30ed\u30fc\u30c9\u6226\u7565<\/h3>\n\n\n\n<p>\u6761\u4ef6\u306b\u5fdc\u3058\u3066\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u30ed\u30fc\u30c9\u3059\u308b\u6226\u7565\u306f\u3001\u67d4\u8edf\u306a\u30c7\u30fc\u30bf\u53d6\u5f97\u3092\u5b9f\u73fe\u3059\u308b\u91cd\u8981\u306a\u30d1\u30bf\u30fc\u30f3\u3067\u3059\u3002<\/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=\"\">\/\/ when\u306b\u3088\u308b\u6761\u4ef6\u4ed8\u304d\u30ed\u30fc\u30c9\n$posts = Post::query()\n    -&gt;when($userType === 'admin', function($query) {\n        $query-&gt;with(['deletedComments', 'revisions']);\n    })\n    -&gt;when($userType === 'user', function($query) {\n        $query-&gt;with(['activeComments']);\n    })\n    -&gt;get();\n\n\/\/ \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5185\u3067\u306e\u6761\u4ef6\u5206\u5c90\n$posts = Post::with([\n    'comments' =&gt; function($query) use ($filters) {\n        $query-&gt;when(\n            $filters['date'] ?? false,\n            fn($query, $date) =&gt; $query-&gt;whereDate('created_at', $date)\n        )-&gt;when(\n            $filters['status'] ?? false,\n            fn($query, $status) =&gt; $query-&gt;where('status', $status)\n        );\n    }\n])-&gt;get();\n\n\/\/ \u5b58\u5728\u30c1\u30a7\u30c3\u30af\u4ed8\u304d\u306e\u30ed\u30fc\u30c9\n$posts = Post::with(['comments' =&gt; function($query) {\n    $query-&gt;has('replies')\n        -&gt;withCount('likes');\n}])-&gt;get();<\/pre>\n\n\n\n<p>\u6761\u4ef6\u4ed8\u304d\u30ed\u30fc\u30c9\u306e\u6d3b\u7528\u30b7\u30fc\u30f3\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30e6\u30fc\u30b6\u30fc\u6a29\u9650\u306b\u5fdc\u3058\u305f\u30c7\u30fc\u30bf\u5236\u5fa1<\/li>\n\n\n\n<li>\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u306e\u52d5\u7684\u9069\u7528<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u306e\u5b58\u5728\u6027\u306b\u57fa\u3065\u304f\u5236\u5fa1<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-10\">\u30ab\u30a6\u30f3\u30c8\u3068\u5171\u306b\u4f7f\u7528\u3059\u308b\u624b\u6cd5<\/h3>\n\n\n\n<p>\u95a2\u9023\u30c7\u30fc\u30bf\u306e\u30ab\u30a6\u30f3\u30c8\u3092\u52b9\u7387\u7684\u306b\u53d6\u5f97\u3059\u308b\u624b\u6cd5\u306f\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u30e6\u30fc\u30b6\u30d3\u30ea\u30c6\u30a3\u306e\u4e21\u9762\u3067\u91cd\u8981\u3067\u3059\u3002<\/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\u30ab\u30a6\u30f3\u30c8\u53d6\u5f97\n$posts = Post::withCount([\n    'comments',\n    'likes',\n    'bookmarks'\n])-&gt;get();\n\n\/\/ \u6761\u4ef6\u4ed8\u304d\u30ab\u30a6\u30f3\u30c8\n$posts = Post::withCount([\n    'comments',\n    'activeComments' =&gt; function($query) {\n        $query-&gt;where('status', 'active');\n    },\n    'pendingComments' =&gt; function($query) {\n        $query-&gt;where('status', 'pending');\n    }\n])-&gt;get();\n\n\/\/ \u30ab\u30a6\u30f3\u30c8\u3068\u901a\u5e38\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u7d44\u307f\u5408\u308f\u305b\n$posts = Post::with(['author', 'categories'])\n    -&gt;withCount([\n        'comments',\n        'likes' =&gt; function($query) {\n            $query-&gt;where('created_at', '&gt;=', now()-&gt;subDays(7));\n        }\n    ])\n    -&gt;having('comments_count', '&gt;=', 10)\n    -&gt;get();\n\n\/\/ \u96c6\u8a08\u95a2\u6570\u306e\u6d3b\u7528\n$posts = Post::withSum('orders', 'amount')\n    -&gt;withAvg('ratings', 'score')\n    -&gt;withMax('comments', 'created_at')\n    -&gt;get();<\/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>\u30ab\u30a6\u30f3\u30c8\u30af\u30a8\u30ea\u306e\u6700\u9069\u5316<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u8a2d\u5b9a<\/li>\n\n\n\n<li>N+1\u554f\u984c\u306e\u56de\u907f<\/li>\n<\/ul>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u6d3b\u7528\u30d1\u30bf\u30fc\u30f3\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u67d4\u8edf\u3067\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u53d6\u5f97\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002\u5b9f\u969b\u306e\u5b9f\u88c5\u6642\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u8981\u4ef6\u3084\u898f\u6a21\u306b\u5fdc\u3058\u3066\u3001\u6700\u9069\u306a\u30d1\u30bf\u30fc\u30f3\u3092\u9078\u629e\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-11\">With\u30e1\u30bd\u30c3\u30c9\u306e\u30c7\u30d0\u30c3\u30b0\u3068\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0<\/h2>\n\n\n\n<p><code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3059\u308b\u969b\u306b\u767a\u751f\u3059\u308b\u554f\u984c\u306e\u591a\u304f\u306f\u3001\u9069\u5207\u306a\u30c7\u30d0\u30c3\u30b0\u624b\u6cd5\u3092\u77e5\u308b\u3053\u3068\u3067\u52b9\u7387\u7684\u306b\u89e3\u6c7a\u3067\u304d\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001\u5b9f\u8df5\u7684\u306a\u30c7\u30d0\u30c3\u30b0\u624b\u6cd5\u3068\u3088\u304f\u3042\u308b\u554f\u984c\u306e\u89e3\u6c7a\u30a2\u30d7\u30ed\u30fc\u30c1\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-12\">\u30af\u30a8\u30ea\u30ed\u30b0\u3092\u6d3b\u7528\u3057\u305f\u554f\u984c\u7279\u5b9a\u65b9\u6cd5<\/h3>\n\n\n\n<p>Laravel\u3067\u306f\u3001\u767a\u884c\u3055\u308c\u308bSQL\u30af\u30a8\u30ea\u3092\u8a73\u7d30\u306b\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u306f<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u306e\u554f\u984c\u3092\u7279\u5b9a\u3059\u308b\u4e0a\u3067\u975e\u5e38\u306b\u91cd\u8981\u3067\u3059\u3002<\/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=\"\">\/\/ \u30af\u30a8\u30ea\u30ed\u30b0\u306e\u6709\u52b9\u5316\nDB::enableQueryLog();\n\n$posts = Post::with(['author', 'comments'])-&gt;get();\n\n\/\/ \u30af\u30a8\u30ea\u30ed\u30b0\u306e\u53d6\u5f97\u3068\u8868\u793a\n$queries = DB::getQueryLog();\ndd($queries);\n\n\/\/ \u5b9f\u969b\u306e\u30ed\u30b0\u51fa\u529b\u4f8b\uff1a\n\/*\narray:3 [\n  0 =&gt; array:3 [\n    \"query\" =&gt; \"select * from `posts`\"\n    \"bindings\" =&gt; []\n    \"time\" =&gt; 0.89\n  ]\n  1 =&gt; array:3 [\n    \"query\" =&gt; \"select * from `users` where `id` in (?, ?, ?)\"\n    \"bindings\" =&gt; [1, 2, 3]\n    \"time\" =&gt; 0.76\n  ]\n  2 =&gt; array:3 [\n    \"query\" =&gt; \"select * from `comments` where `post_id` in (?, ?, ?)\"\n    \"bindings\" =&gt; [1, 2, 3]\n    \"time\" =&gt; 1.23\n  ]\n]\n*\/<\/pre>\n\n\n\n<p>\u30c7\u30d0\u30c3\u30b0\u306b\u5f79\u7acb\u3064\u30c4\u30fc\u30eb\u7fa4\uff1a<\/p>\n\n\n<div id=\"id-e4f143d8-b5d0-40ee-be39-332f96f800e2\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30c4\u30fc\u30eb<\/th><th>\u7528\u9014<\/th><th>\u4f7f\u7528\u65b9\u6cd5<\/th><\/tr><\/thead><tbody><tr><td>Laravel Debugbar<\/td><td>\u30af\u30a8\u30ea\u306e\u53ef\u8996\u5316<\/td><td>composer require barryvdh\/laravel-debugbar \u2013dev<\/td><\/tr><tr><td>Laravel Telescope<\/td><td>\u8a73\u7d30\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u76e3\u8996<\/td><td>composer require laravel\/telescope \u2013dev<\/td><\/tr><tr><td>MySQL EXPLAIN<\/td><td>\u30af\u30a8\u30ea\u5b9f\u884c\u8a08\u753b\u306e\u78ba\u8a8d<\/td><td>EXPLAIN SELECT * FROM posts;<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-13\">\u4e00\u822c\u7684\u306a\u554f\u984c\u3068\u89e3\u6c7a\u30a2\u30d7\u30ed\u30fc\u30c1<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-14\">1. N+1\u554f\u984c\u306e\u518d\u767a<\/h4>\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$posts = Post::with('comments')-&gt;get();\nforeach ($posts as $post) {\n    \/\/ \u3053\u308c\u306f\u65b0\u305f\u306aN+1\u554f\u984c\u3092\u5f15\u304d\u8d77\u3053\u3059\n    $post-&gt;comments-&gt;filter(function ($comment) {\n        return $comment-&gt;user-&gt;is_active;\n    });\n}\n\n\/\/ \u89e3\u6c7a\u7b56\n$posts = Post::with(['comments.user' =&gt; function($query) {\n    $query-&gt;where('is_active', true);\n}])-&gt;get();<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-15\">2. \u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u6025\u5897<\/h4>\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$posts = Post::with(['comments' =&gt; function($query) {\n    $query-&gt;withCount('replies');\n}])-&gt;get(); \/\/ \u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u4e00\u5ea6\u306b\u30ed\u30fc\u30c9\n\n\/\/ \u89e3\u6c7a\u7b56\uff1a\u30c1\u30e3\u30f3\u30af\u51e6\u7406\u306e\u4f7f\u7528\nPost::with(['comments' =&gt; function($query) {\n    $query-&gt;withCount('replies');\n}])-&gt;chunk(100, function($posts) {\n    foreach ($posts as $post) {\n        \/\/ \u51e6\u7406\n    }\n});<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-16\">3. \u4e88\u671f\u3057\u306a\u3044\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u6319\u52d5<\/h4>\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\uff1a\u6761\u4ef6\u304c\u610f\u56f3\u3057\u306a\u3044\u5834\u6240\u306b\u9069\u7528\u3055\u308c\u308b\n$posts = Post::with(['comments' =&gt; function($query) {\n    $query-&gt;where('is_approved', true);\n}])-&gt;where('status', 'published')-&gt;get();\n\n\/\/ \u89e3\u6c7a\u7b56\uff1a\u30af\u30a8\u30ea\u30b9\u30b3\u30fc\u30d7\u306e\u4f7f\u7528\nclass Post extends Model\n{\n    public function approvedComments()\n    {\n        return $this-&gt;hasMany(Comment::class)-&gt;where('is_approved', true);\n    }\n}\n\n$posts = Post::with('approvedComments')\n    -&gt;where('status', 'published')\n    -&gt;get();<\/pre>\n\n\n\n<p>\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\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\u5b9f\u884c\u306e\u78ba\u8a8d<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30af\u30a8\u30ea\u30ed\u30b0\u3092\u6709\u52b9\u5316\u3057\u3066\u78ba\u8a8d<\/li>\n\n\n\n<li>\u5b9f\u884c\u3055\u308c\u308bSQL\u306e\u6570\u3092\u30ab\u30a6\u30f3\u30c8<\/li>\n\n\n\n<li>\u30af\u30a8\u30ea\u306e\u5b9f\u884c\u6642\u9593\u3092\u8a08\u6e2c<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30c7\u30fc\u30bf\u6574\u5408\u6027\u306e\u78ba\u8a8d<\/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=\"\">   \/\/ \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u5b58\u5728\u78ba\u8a8d\n   $post = Post::find(1);\n   dd([\n       'has_relation' =&gt; $post-&gt;relationLoaded('comments'),\n       'relation_count' =&gt; $post-&gt;comments-&gt;count(),\n       'eager_loaded' =&gt; array_keys($post-&gt;getRelations())\n   ]);<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u691c\u8a3c<\/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=\"\">   $startTime = microtime(true);\n\n   $posts = Post::with(['author', 'comments'])-&gt;get();\n\n   $endTime = microtime(true);\n   $executionTime = ($endTime - $startTime) * 1000; \/\/ \u30df\u30ea\u79d2\u5358\u4f4d\n\n   Log::info(\"Query execution time: {$executionTime}ms\");<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u30c7\u30d0\u30c3\u30b0\u624b\u6cd5\u3068\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u30a2\u30d7\u30ed\u30fc\u30c1\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u3067\u3001<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u306b\u95a2\u9023\u3059\u308b\u554f\u984c\u3092\u52b9\u7387\u7684\u306b\u7279\u5b9a\u3057\u89e3\u6c7a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u307e\u305f\u3001\u5b9a\u671f\u7684\u306a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\u3092\u884c\u3046\u3053\u3068\u3067\u3001\u554f\u984c\u306e\u65e9\u671f\u767a\u898b\u3068\u4e88\u9632\u3082\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-17\">With\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u305f\u5b9f\u88c5\u4f8b<\/h2>\n\n\n\n<p>\u5b9f\u969b\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u304a\u3051\u308b<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u306e\u6d3b\u7528\u65b9\u6cd5\u3092\u3001\u5177\u4f53\u7684\u306a\u5b9f\u88c5\u4f8b\u3092\u901a\u3058\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001EC\u30b5\u30a4\u30c8\u3068\u30d6\u30ed\u30b0\u30b7\u30b9\u30c6\u30e0\u3068\u3044\u3046\u4e00\u822c\u7684\u306a\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u3092\u53d6\u308a\u4e0a\u3052\u3001\u5b9f\u8df5\u7684\u306a\u5b9f\u88c5\u65b9\u6cd5\u3092\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-18\">EC\u30b5\u30a4\u30c8\u3067\u306e\u5546\u54c1\u4e00\u89a7\u8868\u793a\u306e\u6700\u9069\u5316\u4e8b\u4f8b<\/h3>\n\n\n\n<p>EC\u30b5\u30a4\u30c8\u3067\u306f\u3001\u5546\u54c1\u4e00\u89a7\u8868\u793a\u306e\u969b\u306b\u95a2\u9023\u3059\u308b\u591a\u304f\u306e\u60c5\u5831\u3092\u52b9\u7387\u7684\u306b\u53d6\u5f97\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u4ee5\u4e0b\u306b\u3001\u6700\u9069\u5316\u3055\u308c\u305f\u5b9f\u88c5\u4f8b\u3092\u793a\u3057\u307e\u3059\u3002<\/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=\"\">\/\/ Product\u30e2\u30c7\u30eb\u306e\u5b9a\u7fa9\nclass Product extends Model\n{\n    public function category()\n    {\n        return $this-&gt;belongsTo(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    public function scopeAvailable($query)\n    {\n        return $query-&gt;where('status', 'active')\n            -&gt;where('stock', '&gt;', 0);\n    }\n}\n\n\/\/ ProductController\u3067\u306e\u5b9f\u88c5\nclass ProductController extends Controller\n{\n    public function index(Request $request)\n    {\n        $products = Product::with([\n            'category:id,name,slug',\n            'variants' =&gt; function($query) {\n                $query-&gt;select(['id', 'product_id', 'size', 'color', 'price', 'stock'])\n                    -&gt;where('stock', '&gt;', 0);\n            },\n            'reviews' =&gt; function($query) {\n                $query-&gt;select(['id', 'product_id', 'rating'])\n                    -&gt;whereNotNull('rating');\n            }\n        ])\n        -&gt;available()\n        -&gt;withAvg('reviews', 'rating')\n        -&gt;withCount(['variants' =&gt; function($query) {\n            $query-&gt;where('stock', '&gt;', 0);\n        }])\n        -&gt;when($request-&gt;category, function($query, $category) {\n            $query-&gt;whereHas('category', function($q) use ($category) {\n                $q-&gt;where('slug', $category);\n            });\n        })\n        -&gt;paginate(20);\n\n        return view('products.index', compact('products'));\n    }\n}\n\n\/\/ Blade\u30d3\u30e5\u30fc\u3067\u306e\u8868\u793a\n@foreach($products as $product)\n    &lt;div class=\"product-card\"&gt;\n        &lt;h3&gt;{{ $product-&gt;name }}&lt;\/h3&gt;\n        &lt;p&gt;\u30ab\u30c6\u30b4\u30ea\u30fc: {{ $product-&gt;category-&gt;name }}&lt;\/p&gt;\n        &lt;p&gt;\u5e73\u5747\u8a55\u4fa1: {{ number_format($product-&gt;reviews_avg_rating, 1) }}&lt;\/p&gt;\n        &lt;p&gt;\u5728\u5eab\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3: {{ $product-&gt;variants_count }}\u7a2e\u985e&lt;\/p&gt;\n\n        @if($product-&gt;variants-&gt;isNotEmpty())\n            &lt;div class=\"variants\"&gt;\n                @foreach($product-&gt;variants as $variant)\n                    &lt;div class=\"variant\"&gt;\n                        {{ $variant-&gt;size }} \/ {{ $variant-&gt;color }}:\n                        \u00a5{{ number_format($variant-&gt;price) }}\n                    &lt;\/div&gt;\n                @endforeach\n            &lt;\/div&gt;\n        @endif\n    &lt;\/div&gt;\n@endforeach<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-19\">\u30d6\u30ed\u30b0\u30b7\u30b9\u30c6\u30e0\u3067\u306e\u30b3\u30e1\u30f3\u30c8\u8868\u793a\u306e\u52b9\u7387\u5316<\/h3>\n\n\n\n<p>\u30d6\u30ed\u30b0\u30b7\u30b9\u30c6\u30e0\u3067\u306f\u3001\u8a18\u4e8b\u3068\u305d\u308c\u306b\u95a2\u9023\u3059\u308b\u30b3\u30e1\u30f3\u30c8\u3001\u8457\u8005\u60c5\u5831\u306a\u3069\u3092\u52b9\u7387\u7684\u306b\u8868\u793a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/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=\"\">\/\/ Post\u30e2\u30c7\u30eb\u306e\u5b9a\u7fa9\nclass Post extends Model\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)-&gt;orderBy('created_at', 'desc');\n    }\n\n    public function tags()\n    {\n        return $this-&gt;belongsToMany(Tag::class);\n    }\n\n    public function scopePublished($query)\n    {\n        return $query-&gt;where('status', 'published')\n            -&gt;where('published_at', '&lt;=', now());\n    }\n}\n\n\/\/ PostController\u3067\u306e\u5b9f\u88c5\nclass PostController extends Controller\n{\n    public function show($slug)\n    {\n        $post = Post::with([\n            'author:id,name,profile_image',\n            'comments' =&gt; function($query) {\n                $query-&gt;with([\n                    'user:id,name,profile_image',\n                    'replies' =&gt; function($q) {\n                        $q-&gt;with('user:id,name,profile_image')\n                            -&gt;latest()\n                            -&gt;limit(3);\n                    }\n                ])\n                -&gt;whereNull('parent_id')\n                -&gt;latest()\n                -&gt;limit(10);\n            },\n            'tags:id,name,slug'\n        ])\n        -&gt;published()\n        -&gt;withCount([\n            'comments',\n            'likes'\n        ])\n        -&gt;where('slug', $slug)\n        -&gt;firstOrFail();\n\n        \/\/ \u95a2\u9023\u8a18\u4e8b\u306e\u53d6\u5f97\n        $relatedPosts = Post::with('author:id,name')\n            -&gt;published()\n            -&gt;whereHas('tags', function($query) use ($post) {\n                $query-&gt;whereIn('id', $post-&gt;tags-&gt;pluck('id'));\n            })\n            -&gt;where('id', '!=', $post-&gt;id)\n            -&gt;latest()\n            -&gt;limit(3)\n            -&gt;get();\n\n        return view('posts.show', compact('post', 'relatedPosts'));\n    }\n}\n\n\/\/ \u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u6d3b\u7528\u3057\u305f\u6700\u9069\u5316\nclass PostController extends Controller\n{\n    public function index()\n    {\n        $posts = Cache::remember('posts.index', now()-&gt;addMinutes(15), function() {\n            return Post::with([\n                'author:id,name',\n                'tags:id,name'\n            ])\n            -&gt;published()\n            -&gt;withCount('comments')\n            -&gt;latest()\n            -&gt;paginate(12);\n        });\n\n        return view('posts.index', compact('posts'));\n    }\n}<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u5b9f\u88c5\u4f8b\u306e\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u9078\u629e\u7684\u306a\u30ab\u30e9\u30e0\u53d6\u5f97<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u3092\u6307\u5b9a<\/li>\n\n\n\n<li>\u4e0d\u8981\u306a\u30c7\u30fc\u30bf\u8ee2\u9001\u3092\u524a\u6e1b<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u6761\u4ef6\u4ed8\u304d\u30ed\u30fc\u30c9\u306e\u6d3b\u7528<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30b9\u30c6\u30fc\u30bf\u30b9\u3084\u5728\u5eab\u72b6\u6cc1\u306b\u3088\u308b\u7d5e\u308a\u8fbc\u307f<\/li>\n\n\n\n<li>\u30e6\u30fc\u30b6\u30fc\u5165\u529b\u306b\u57fa\u3065\u304f\u52d5\u7684\u306a\u30af\u30a8\u30ea\u69cb\u7bc9<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u9069\u5207\u306a\u6d3b\u7528<\/li>\n\n\n\n<li>\u30af\u30a8\u30ea\u306e\u30b9\u30b3\u30fc\u30d7\u5316\u306b\u3088\u308b\u518d\u5229\u7528\u6027\u306e\u5411\u4e0a<\/li>\n\n\n\n<li>\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3068\u306e\u7d44\u307f\u5408\u308f\u305b<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30c7\u30fc\u30bf\u306e\u968e\u5c64\u69cb\u9020\u306e\u8003\u616e<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30cd\u30b9\u30c8\u3055\u308c\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u52b9\u7387\u7684\u306a\u30ed\u30fc\u30c9<\/li>\n\n\n\n<li>\u5fc5\u8981\u306b\u5fdc\u3058\u305f\u30c7\u30fc\u30bf\u306e\u5236\u9650\uff08limit\uff09<\/li>\n<\/ul>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u5b9f\u88c5\u4f8b\u306f\u3001\u5b9f\u969b\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u5fdc\u7528\u53ef\u80fd\u306a\u5177\u4f53\u7684\u306a\u30b3\u30fc\u30c9\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u5404\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u306b\u5fdc\u3058\u3066\u9069\u5207\u306b\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3059\u308b\u3053\u3068\u3067\u3001\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u53d6\u5f97\u3068\u8868\u793a\u3092\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-20\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u8a08\u6e2c\u3068\u6539\u5584\u52b9\u679c\u306e\u691c\u8a3c<\/h2>\n\n\n\n<p><code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u306e\u52b9\u679c\u3092\u5b9a\u91cf\u7684\u306b\u628a\u63e1\u3059\u308b\u305f\u3081\u306b\u3001\u5b9f\u969b\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u8a08\u6e2c\u3068\u6539\u5584\u52b9\u679c\u306e\u691c\u8a3c\u3092\u884c\u3044\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001\u5177\u4f53\u7684\u306a\u6e2c\u5b9a\u65b9\u6cd5\u3068\u3001\u5b9f\u969b\u306e\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u306b\u304a\u3051\u308b\u6539\u5584\u52b9\u679c\u3092\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-21\">\u5b9f\u969b\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6539\u5584\u6570\u5024<\/h3>\n\n\n\n<p>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u8a08\u6e2c\u306b\u306f\u3001Laravel Debugbar\u3068\u30ab\u30b9\u30bf\u30e0\u306e\u8a08\u6e2c\u30b3\u30fc\u30c9\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/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=\"\">\/\/ \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u8a08\u6e2c\u7528\u306e\u30df\u30c9\u30eb\u30a6\u30a7\u30a2\nclass PerformanceMonitor\n{\n    public function handle($request, Closure $next)\n    {\n        \/\/ \u958b\u59cb\u6642\u306e\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u8a18\u9332\n        $startMemory = memory_get_usage();\n\n        \/\/ \u958b\u59cb\u6642\u9593\u3092\u8a18\u9332\n        $startTime = microtime(true);\n\n        \/\/ \u30ea\u30af\u30a8\u30b9\u30c8\u306e\u51e6\u7406\n        $response = $next($request);\n\n        \/\/ \u5b9f\u884c\u6642\u9593\u306e\u8a08\u7b97\n        $executionTime = (microtime(true) - $startTime) * 1000;\n\n        \/\/ \u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u8a08\u7b97\n        $memoryUsage = (memory_get_usage() - $startMemory) \/ 1024 \/ 1024;\n\n        \/\/ \u30ed\u30b0\u306b\u8a18\u9332\n        Log::info(\"Performance metrics\", [\n            'execution_time_ms' =&gt; round($executionTime, 2),\n            'memory_usage_mb' =&gt; round($memoryUsage, 2),\n            'url' =&gt; $request-&gt;url(),\n            'method' =&gt; $request-&gt;method()\n        ]);\n\n        return $response;\n    }\n}\n\n\/\/ \u30c6\u30b9\u30c8\u30b1\u30fc\u30b91: \u5546\u54c1\u4e00\u89a7\u306e\u53d6\u5f97\nclass ProductPerformanceTest extends TestCase\n{\n    public function testProductListingPerformance()\n    {\n        \/\/ \u6700\u9069\u5316\u524d\u306e\u30af\u30a8\u30ea\n        $startTime = microtime(true);\n        $products = Product::all();\n        foreach ($products as $product) {\n            $product-&gt;category;\n            $product-&gt;variants;\n        }\n        $withoutWithTime = microtime(true) - $startTime;\n\n        \/\/ \u6700\u9069\u5316\u5f8c\u306e\u30af\u30a8\u30ea\n        $startTime = microtime(true);\n        $products = Product::with(['category', 'variants'])-&gt;get();\n        $withWithTime = microtime(true) - $startTime;\n\n        return [\n            'without_with' =&gt; $withoutWithTime,\n            'with_with' =&gt; $withWithTime,\n            'improvement' =&gt; round((1 - $withWithTime \/ $withoutWithTime) * 100, 2)\n        ];\n    }\n}<\/pre>\n\n\n\n<p>\u5b9f\u6e2c\u5024\u306b\u3088\u308b\u6539\u5584\u52b9\u679c\uff1a<\/p>\n\n\n<div id=\"id-a064292b-42f7-44d4-a36b-8a71827fa370\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30b7\u30ca\u30ea\u30aa<\/th><th>\u6700\u9069\u5316\u524d<\/th><th>\u6700\u9069\u5316\u5f8c<\/th><th>\u6539\u5584\u7387<\/th><\/tr><\/thead><tbody><tr><td>\u5546\u54c1\u4e00\u89a7\uff08100\u4ef6\uff09<\/td><td>850ms<\/td><td>320ms<\/td><td>62.4%<\/td><\/tr><tr><td>\u30d6\u30ed\u30b0\u8a18\u4e8b\u8a73\u7d30<\/td><td>620ms<\/td><td>280ms<\/td><td>54.8%<\/td><\/tr><tr><td>\u30e6\u30fc\u30b6\u30fc\u4e00\u89a7<\/td><td>750ms<\/td><td>290ms<\/td><td>61.3%<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-22\">\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u6700\u9069\u5316\u52b9\u679c<\/h3>\n\n\n\n<p>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u6539\u5584\u3092\u8a08\u6e2c\u3059\u308b\u305f\u3081\u306e\u30b3\u30fc\u30c9\u4f8b\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=\"\">\/\/ \u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u8a08\u6e2c\u7528\u306e\u30d8\u30eb\u30d1\u30fc\u95a2\u6570\nfunction measureMemoryUsage(callable $callback): array\n{\n    \/\/ GC\u3092\u5f37\u5236\u5b9f\u884c\u3057\u3066\u30e1\u30e2\u30ea\u72b6\u614b\u3092\u30af\u30ea\u30fc\u30f3\u306b\n    gc_collect_cycles();\n\n    $startMemory = memory_get_usage(true);\n    $peak_start = memory_get_peak_usage(true);\n\n    $result = $callback();\n\n    $endMemory = memory_get_usage(true);\n    $peak_end = memory_get_peak_usage(true);\n\n    return [\n        'used' =&gt; ($endMemory - $startMemory) \/ 1024 \/ 1024,\n        'peak' =&gt; ($peak_end - $peak_start) \/ 1024 \/ 1024\n    ];\n}\n\n\/\/ \u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u8a08\u6e2c\u4f8b\n$withoutWithMemory = measureMemoryUsage(function() {\n    $products = Product::all();\n    foreach ($products as $product) {\n        $product-&gt;category;\n        $product-&gt;variants;\n    }\n});\n\n$withWithMemory = measureMemoryUsage(function() {\n    $products = Product::with(['category', 'variants'])-&gt;get();\n});<\/pre>\n\n\n\n<p>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u6539\u5584\u52b9\u679c\uff1a<\/p>\n\n\n<div id=\"id-ac83e3e0-fe07-4444-97f2-006c739aafa7\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30c7\u30fc\u30bf\u91cf<\/th><th>\u6700\u9069\u5316\u624b\u6cd5<\/th><th>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf<\/th><th>\u30d4\u30fc\u30af\u30e1\u30e2\u30ea<\/th><\/tr><\/thead><tbody><tr><td>1,000\u4ef6<\/td><td>\u901a\u5e38\u306e\u30ed\u30fc\u30c9<\/td><td>45.2 MB<\/td><td>52.8 MB<\/td><\/tr><tr><td>1,000\u4ef6<\/td><td>with\u4f7f\u7528<\/td><td>28.6 MB<\/td><td>35.1 MB<\/td><\/tr><tr><td>5,000\u4ef6<\/td><td>\u901a\u5e38\u306e\u30ed\u30fc\u30c9<\/td><td>186.4 MB<\/td><td>215.3 MB<\/td><\/tr><tr><td>5,000\u4ef6<\/td><td>with\u4f7f\u7528<\/td><td>112.8 MB<\/td><td>142.7 MB<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-23\">\u6539\u5584\u52b9\u679c\u306e\u53ef\u8996\u5316\u3068\u5206\u6790<\/h3>\n\n\n\n<p>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6539\u5584\u306e\u4e3b\u8981\u306a\u8981\u56e0\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30af\u30a8\u30ea\u6570\u306e\u524a\u6e1b<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>N+1\u554f\u984c\u306e\u89e3\u6d88\u306b\u3088\u308b\u5927\u5e45\u306a\u30af\u30a8\u30ea\u6570\u524a\u6e1b<\/li>\n\n\n\n<li>\u7d50\u679c\u3068\u3057\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u306e\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u524a\u6e1b<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u6700\u9069\u5316<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u306e\u307f\u3092\u9078\u629e\u7684\u306b\u30ed\u30fc\u30c9<\/li>\n\n\n\n<li>\u4e0d\u8981\u306a\u30c7\u30fc\u30bf\u306e\u4fdd\u6301\u3092\u56de\u907f<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30ec\u30b9\u30dd\u30f3\u30b9\u6642\u9593\u306e\u6539\u5584<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5e73\u5747\u30ec\u30b9\u30dd\u30f3\u30b9\u6642\u9593\u304c54-62%\u6539\u5584<\/li>\n\n\n\n<li>\u30e6\u30fc\u30b6\u30fc\u4f53\u9a13\u306e\u5411\u4e0a\u306b\u76f4\u7d50<\/li>\n<\/ul>\n\n\n\n<p>\u6539\u5584\u52b9\u679c\u306e\u7d99\u7d9a\u7684\u306a\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\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=\"\">\/\/ \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\u7528\u306e\u30b5\u30fc\u30d3\u30b9\u30d7\u30ed\u30d0\u30a4\u30c0\u30fc\nclass PerformanceMonitorServiceProvider extends ServiceProvider\n{\n    public function boot()\n    {\n        if (config('app.debug')) {\n            DB::listen(function($query) {\n                $time = $query-&gt;time;\n                $sql = $query-&gt;sql;\n                $bindings = $query-&gt;bindings;\n\n                Log::channel('performance')-&gt;info('Query executed', [\n                    'time' =&gt; $time,\n                    'sql' =&gt; $sql,\n                    'bindings' =&gt; $bindings\n                ]);\n            });\n        }\n    }\n}<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u6e2c\u5b9a\u7d50\u679c\u304b\u3089\u3001<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u306e\u4f7f\u7528\u306b\u3088\u308b\u5177\u4f53\u7684\u306a\u6539\u5584\u52b9\u679c\u304c\u660e\u78ba\u306b\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u7279\u306b\u5927\u898f\u6a21\u306a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u6271\u3046\u5834\u5408\u3001\u305d\u306e\u52b9\u679c\u306f\u9855\u8457\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5b9f\u88c5\u6642\u306e\u63a8\u5968\u4e8b\u9805\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u7d99\u7d9a\u7684\u306a\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5b9a\u671f\u7684\u306a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u8a08\u6e2c\u306e\u5b9f\u65bd<\/li>\n\n\n\n<li>\u554f\u984c\u306e\u65e9\u671f\u767a\u898b\u3068\u5bfe\u5fdc<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u6bb5\u968e\u7684\u306a\u6700\u9069\u5316<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6700\u3082\u52b9\u679c\u306e\u9ad8\u3044\u90e8\u5206\u304b\u3089\u9806\u6b21\u6539\u5584<\/li>\n\n\n\n<li>\u6539\u5584\u52b9\u679c\u306e\u5b9a\u91cf\u7684\u306a\u691c\u8a3c<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u8ca0\u8377\u30c6\u30b9\u30c8\u306e\u5b9f\u65bd<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5b9f\u74b0\u5883\u306b\u8fd1\u3044\u6761\u4ef6\u3067\u306e\u691c\u8a3c<\/li>\n\n\n\n<li>\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u78ba\u8a8d<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-24\">With\u30e1\u30bd\u30c3\u30c9\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u3068\u307e\u3068\u3081<\/h2>\n\n\n\n<p>\u3053\u308c\u307e\u3067\u306e\u5185\u5bb9\u3092\u8e0f\u307e\u3048\u3001\u5b9f\u52d9\u3067<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u3092\u52b9\u679c\u7684\u306b\u6d3b\u7528\u3059\u308b\u305f\u3081\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u3068\u3001\u5b9f\u88c5\u6642\u306e\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u3092\u307e\u3068\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-25\">\u73fe\u5834\u3067\u4f7f\u3048\u308b\u5177\u4f53\u7684\u306a\u5b9f\u88c5\u306e\u8996\u70b9<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-26\">1. \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u8a2d\u8a08\u3068\u5b9f\u88c5<\/h4>\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\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5b9a\u7fa9\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\nclass Post extends Model\n{\n    \/\/ \u57fa\u672c\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n    public function author()\n    {\n        return $this-&gt;belongsTo(User::class);\n    }\n\n    \/\/ \u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3055\u308c\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n    public function activeComments()\n    {\n        return $this-&gt;hasMany(Comment::class)\n            -&gt;where('status', 'active')\n            -&gt;orderBy('created_at', 'desc');\n    }\n\n    \/\/ \u52d5\u7684\u306a\u6761\u4ef6\u3092\u53d7\u3051\u4ed8\u3051\u308b\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n    public function scopeWithFilteredComments($query, array $filters = [])\n    {\n        return $query-&gt;with(['comments' =&gt; function($query) use ($filters) {\n            $query-&gt;when(\n                $filters['status'] ?? false,\n                fn($q, $status) =&gt; $q-&gt;where('status', $status)\n            )-&gt;when(\n                $filters['date'] ?? false,\n                fn($q, $date) =&gt; $q-&gt;whereDate('created_at', $date)\n            );\n        }]);\n    }\n\n    \/\/ \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u8003\u616e\u3057\u305f\u30ab\u30a6\u30f3\u30c8\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n    public function commentsCount()\n    {\n        return $this-&gt;hasMany(Comment::class)\n            -&gt;selectRaw('post_id, count(*) as count')\n            -&gt;groupBy('post_id');\n    }\n}<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-27\">2. \u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u30fc\u3067\u306e\u52b9\u7387\u7684\u306a\u4f7f\u7528<\/h4>\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=\"\">\/\/ \u52b9\u7387\u7684\u306a\u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u30fc\u306e\u4f7f\u7528\u4f8b\nclass PostController extends Controller\n{\n    public function index(Request $request)\n    {\n        return Post::query()\n            \/\/ \u57fa\u672c\u7684\u306aEager Loading\n            -&gt;with(['author:id,name,email', 'category:id,name'])\n\n            \/\/ \u6761\u4ef6\u4ed8\u304d\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30ed\u30fc\u30c9\n            -&gt;when($request-&gt;include_comments, function($query) {\n                $query-&gt;with('activeComments:id,post_id,content,created_at');\n            })\n\n            \/\/ \u5fc5\u8981\u306a\u5834\u5408\u306e\u307f\u30ab\u30a6\u30f3\u30c8\u3092\u53d6\u5f97\n            -&gt;when($request-&gt;with_counts, function($query) {\n                $query-&gt;withCount(['comments', 'likes']);\n            })\n\n            \/\/ \u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u6d3b\u7528\n            -&gt;remember(now()-&gt;addMinutes(15))\n\n            \/\/ \u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\n            -&gt;paginate(20);\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-28\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306e\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-29\">1. \u30af\u30a8\u30ea\u306e\u6700\u9069\u5316<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>[ ] \u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u3092\u9078\u629e\u3057\u3066\u3044\u308b\u304b<\/li>\n\n\n\n<li>[ ] \u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u304b<\/li>\n\n\n\n<li>[ ] \u4e0d\u8981\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u30ed\u30fc\u30c9\u3057\u3066\u3044\u306a\u3044\u304b<\/li>\n\n\n\n<li>[ ] \u30af\u30a8\u30ea\u306e\u5b9f\u884c\u8a08\u753b\u3092\u78ba\u8a8d\u3057\u305f\u304b<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-30\">2. \u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u6700\u9069\u5316<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>[ ] \u5927\u91cf\u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066\u30c1\u30e3\u30f3\u30af\u51e6\u7406\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u304b<\/li>\n\n\n\n<li>[ ] \u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u306e\u307f\u3092\u30e1\u30e2\u30ea\u306b\u4fdd\u6301\u3057\u3066\u3044\u308b\u304b<\/li>\n\n\n\n<li>[ ] \u30ac\u30d9\u30fc\u30b8\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u9069\u5207\u306b\u8003\u616e\u3057\u3066\u3044\u308b\u304b<\/li>\n\n\n\n<li>[ ] \u30e1\u30e2\u30ea\u30ea\u30fc\u30af\u306e\u53ef\u80fd\u6027\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3066\u3044\u308b\u304b<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-31\">3. \u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>[ ] \u9069\u5207\u306a\u30ad\u30e3\u30c3\u30b7\u30e5\u671f\u9593\u3092\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u304b<\/li>\n\n\n\n<li>[ ] \u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u7121\u52b9\u5316\u30bf\u30a4\u30df\u30f3\u30b0\u306f\u9069\u5207\u304b<\/li>\n\n\n\n<li>[ ] \u30ad\u30e3\u30c3\u30b7\u30e5\u30ad\u30fc\u306f\u4e00\u610f\u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u304b<\/li>\n\n\n\n<li>[ ] \u90e8\u5206\u7684\u306a\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u6d3b\u7528\u3057\u3066\u3044\u308b\u304b<\/li>\n<\/ul>\n\n\n\n<p>\u5b9f\u88c5\u6642\u306e\u5177\u4f53\u7684\u306a\u63a8\u5968\u4e8b\u9805\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u8a2d\u8a08\u6bb5\u968e\u3067\u306e\u8003\u616e\u4e8b\u9805<\/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=\"\">   \/\/ \u826f\u3044\u4f8b\uff1a\u5fc5\u8981\u6700\u5c0f\u9650\u306e\u30c7\u30fc\u30bf\u53d6\u5f97\n   Post::select(['id', 'title', 'author_id'])\n       -&gt;with('author:id,name')\n       -&gt;get();\n\n   \/\/ \u907f\u3051\u308b\u3079\u304d\u4f8b\uff1a\u3059\u3079\u3066\u306e\u30ab\u30e9\u30e0\u3092\u53d6\u5f97\n   Post::with('author')-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u4fdd\u5b88\u6027\u3092\u8003\u616e\u3057\u305f\u30b3\u30fc\u30c9\u69cb\u9020<\/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=\"\">   \/\/ \u826f\u3044\u4f8b\uff1a\u518d\u5229\u7528\u53ef\u80fd\u306a\u30b9\u30b3\u30fc\u30d7\u306e\u5b9a\u7fa9\n   class Post extends Model\n   {\n       public function scopeWithBasicRelations($query)\n       {\n           return $query-&gt;with([\n               'author:id,name',\n               'category:id,name',\n               'tags:id,name'\n           ]);\n       }\n   }\n\n   \/\/ \u4f7f\u7528\u4f8b\n   Post::withBasicRelations()-&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u306e\u8003\u616e<\/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=\"\">   try {\n       $posts = Post::with(['author', 'comments'])-&gt;get();\n   } catch (QueryException $e) {\n       Log::error('Posts retrieval failed', [\n           'error' =&gt; $e-&gt;getMessage(),\n           'sql' =&gt; $e-&gt;getSql(),\n           'bindings' =&gt; $e-&gt;getBindings()\n       ]);\n       throw new PostRetrievalException('\u6295\u7a3f\u306e\u53d6\u5f97\u306b\u5931\u6557\u3057\u307e\u3057\u305f');\n   }<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-32\">\u307e\u3068\u3081<\/h3>\n\n\n\n<p><code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u306e\u52b9\u679c\u7684\u306a\u6d3b\u7528\u306f\u3001\u4ee5\u4e0b\u306e\u70b9\u306b\u6ce8\u610f\u3057\u3066\u5b9f\u88c5\u3059\u308b\u3053\u3068\u3067\u6700\u5927\u9650\u306e\u52b9\u679c\u3092\u5f97\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u89b3\u70b9<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5fc5\u8981\u6700\u5c0f\u9650\u306e\u30c7\u30fc\u30bf\u53d6\u5f97<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u306e\u9069\u7528<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30b3\u30fc\u30c9\u306e\u54c1\u8cea\u306e\u89b3\u70b9<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u518d\u5229\u7528\u53ef\u80fd\u306a\u30b3\u30fc\u30c9\u8a2d\u8a08<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0<\/li>\n\n\n\n<li>\u4fdd\u5b88\u6027\u306e\u9ad8\u3044\u5b9f\u88c5<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u904b\u7528\u306e\u89b3\u70b9<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7d99\u7d9a\u7684\u306a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30ed\u30b0\u8a18\u9332<\/li>\n\n\n\n<li>\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u8003\u616e<\/li>\n<\/ul>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u5b9f\u8df5\u7684\u306a\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u3092\u9069\u7528\u3059\u308b\u3053\u3068\u3067\u3001<code>with<\/code>\u30e1\u30bd\u30c3\u30c9\u3092\u6d3b\u7528\u3057\u305f\u52b9\u7387\u7684\u3067\u4fdd\u5b88\u6027\u306e\u9ad8\u3044\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u958b\u767a\u304c\u53ef\u80fd\u3068\u306a\u308a\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-3273","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\/3273","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=3273"}],"version-history":[{"count":2,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/3273\/revisions"}],"predecessor-version":[{"id":3275,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/3273\/revisions\/3275"}],"wp:attachment":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}