{"id":2691,"date":"2025-03-24T08:46:47","date_gmt":"2025-03-23T23:46:47","guid":{"rendered":"https:\/\/dexall.co.jp\/articles\/?p=2691"},"modified":"2025-03-24T08:47:16","modified_gmt":"2025-03-23T23:47:16","slug":"laravel-orderby%e3%81%ae%e5%ae%8c%e5%85%a8%e3%82%ac%e3%82%a4%e3%83%89%ef%bc%9a%e5%9f%ba%e6%9c%ac%e3%81%8b%e3%82%89%e5%ae%9f%e8%b7%b5%e7%9a%84%e3%81%aa8%e3%81%a4%e3%81%ae%e5%ae%9f%e8%a3%85%e3%83%91","status":"publish","type":"post","link":"https:\/\/dexall.co.jp\/articles\/?p=2691","title":{"rendered":"Laravel orderBy\u306e\u5b8c\u5168\u30ac\u30a4\u30c9\uff1a\u57fa\u672c\u304b\u3089\u5b9f\u8df5\u7684\u306a8\u3064\u306e\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u307e\u3067"},"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 orderBy\u306e\u57fa\u790e\u77e5\u8b58<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-1\">orderBy\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u672c\u69cb\u6587\u3068\u52d5\u4f5c\u539f\u7406<\/a>      <\/li>      <li>        <a href=\"#i-2\">\u6607\u9806\u30fb\u964d\u9806\u306e\u6307\u5b9a\u65b9\u6cd5\u3068\u305d\u306e\u4f7f\u3044\u5206\u3051<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-3\">\u8907\u6570\u30ab\u30e9\u30e0\u3067\u306e\u4e26\u3073\u66ff\u3048\u30c6\u30af\u30cb\u30c3\u30af<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-4\">\u9ad8\u5ea6\u306a\u4e26\u3073\u66ff\u3048\u30c6\u30af\u30cb\u30c3\u30af<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-5\">where\u3068orderBy\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u3088\u308b\u6761\u4ef6\u4ed8\u304d\u4e26\u3073\u66ff\u3048<\/a>      <\/li>      <li>        <a href=\"#i-6\">\u30b5\u30d6\u30af\u30a8\u30ea\u3092\u4f7f\u7528\u3057\u305f\u52d5\u7684\u306a\u4e26\u3073\u66ff\u3048<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-7\">\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30ab\u30e9\u30e0\u306b\u3088\u308b\u4e26\u3073\u66ff\u3048\u624b\u6cd5<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-8\">\u5b9f\u8df5\u7684\u306a\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u96c6<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-9\">\u30e6\u30fc\u30b6\u30fc\u5165\u529b\u306b\u57fa\u3065\u304f\u52d5\u7684\u306a\u4e26\u3073\u66ff\u3048\u306e\u5b9f\u88c5<\/a>      <\/li>      <li>        <a href=\"#i-10\">\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3068\u7d44\u307f\u5408\u308f\u305b\u305f\u52b9\u7387\u7684\u306a\u5b9f\u88c5<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-11\">\u8907\u6570\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3057\u305f\u9ad8\u5ea6\u306a\u4e26\u3073\u66ff\u3048\u30ed\u30b8\u30c3\u30af<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-12\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-13\">\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u6d3b\u7528\u3057\u305f\u4e26\u3073\u66ff\u3048\u306e\u9ad8\u901f\u5316<\/a>      <\/li>      <li>        <a href=\"#i-14\">\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3067\u306e\u4e26\u3073\u66ff\u3048\u6226\u7565<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-15\">\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u6d3b\u7528\u3057\u305f\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6539\u5584\u624b\u6cd5<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-16\">orderBy\u306e\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-17\">\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u3068\u305d\u306e\u89e3\u6c7a\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-18\">\u30c7\u30d0\u30c3\u30b0\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6e2c\u5b9a\u306e\u624b\u6cd5<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-19\">\u30c6\u30b9\u30c8\u30b3\u30fc\u30c9\u306e\u5b9f\u88c5\u30dd\u30a4\u30f3\u30c8<\/a>      <\/li>    <\/ul>  <\/li>  <li class=\"last\">    <a href=\"#i-20\">\u5b9f\u88c5\u4f8b\u3067\u5b66\u3076\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u5225\u89e3\u6c7a\u65b9\u6cd5<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-21\">EC\u30b5\u30a4\u30c8\u3067\u306e\u5546\u54c1\u4e00\u89a7\u306e\u4e26\u3073\u66ff\u3048\u5b9f\u88c5<\/a>      <\/li>      <li>        <a href=\"#i-22\">\u30d6\u30ed\u30b0\u8a18\u4e8b\u306e\u8907\u5408\u6761\u4ef6\u3067\u306e\u4e26\u3073\u66ff\u3048\u5b9f\u88c5<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-23\">\u7ba1\u7406\u753b\u9762\u3067\u306e\u30c7\u30fc\u30bf\u30c6\u30fc\u30d6\u30eb\u5b9f\u88c5<\/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 orderBy\u306e\u57fa\u790e\u77e5\u8b58<\/h2>\n\n\n\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u306e\u30ec\u30b3\u30fc\u30c9\u53d6\u5f97\u6642\u306b\u3001\u7279\u5b9a\u306e\u9806\u5e8f\u3067\u7d50\u679c\u3092\u4e26\u3073\u66ff\u3048\u308b\u3053\u3068\u306f\u975e\u5e38\u306b\u4e00\u822c\u7684\u306a\u8981\u4ef6\u3067\u3059\u3002Laravel\u3067\u306f\u3001\u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u3084Eloquent\u30e2\u30c7\u30eb\u3092\u901a\u3058\u3066\u3001\u76f4\u611f\u7684\u3067\u67d4\u8edf\u306a\u4e26\u3073\u66ff\u3048\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001orderBy\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u304b\u3089\u3001\u5b9f\u8df5\u7684\u306a\u30c6\u30af\u30cb\u30c3\u30af\u307e\u3067\u3092\u8a73\u3057\u304f\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-1\">orderBy\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u672c\u69cb\u6587\u3068\u52d5\u4f5c\u539f\u7406<\/h3>\n\n\n\n<p>orderBy\u30e1\u30bd\u30c3\u30c9\u306f\u3001SQL\u306e<code>ORDER BY<\/code>\u53e5\u3092Laravel\u3067\u6271\u3044\u3084\u3059\u304f\u62bd\u8c61\u5316\u3057\u305f\u30e1\u30bd\u30c3\u30c9\u3067\u3059\u3002\u57fa\u672c\u7684\u306a\u69cb\u6587\u306f\u4ee5\u4e0b\u306e\u901a\u308a\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=\"\">\/\/ \u57fa\u672c\u7684\u306a\u4f7f\u7528\u65b9\u6cd5\n$users = DB::table('users')\n    -&gt;orderBy('name')\n    -&gt;get();\n\n\/\/ Eloquent\u30e2\u30c7\u30eb\u3067\u306e\u4f7f\u7528\n$users = User::orderBy('created_at')-&gt;get();<\/pre>\n\n\n\n<p>orderBy\u30e1\u30bd\u30c3\u30c9\u306f\u5185\u90e8\u7684\u306b\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u51e6\u7406\u3092\u884c\u3063\u3066\u3044\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u7b2c\u4e00\u5f15\u6570\u306b\u30ab\u30e9\u30e0\u540d\u3092\u53d7\u3051\u53d6\u308b<\/li>\n\n\n\n<li>\u30aa\u30d7\u30b7\u30e7\u30ca\u30eb\u306a\u7b2c\u4e8c\u5f15\u6570\u3067\u4e26\u3073\u9806\uff08asc\/desc\uff09\u3092\u6307\u5b9a<\/li>\n\n\n\n<li>\u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u3067SQL\u306e<code>ORDER BY<\/code>\u53e5\u3092\u69cb\u7bc9<\/li>\n\n\n\n<li>\u5b9f\u884c\u6642\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u3067\u4e26\u3073\u66ff\u3048\u3092\u5b9f\u65bd<\/li>\n<\/ol>\n\n\n\n<p>\u4ee5\u4e0b\u306f\u3001orderBy\u30e1\u30bd\u30c3\u30c9\u306e\u4e3b\u8981\u306a\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\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=\"\">\/\/ \u30ab\u30e9\u30e0\u3068\u4e26\u3073\u9806\u3092\u6307\u5b9a\n$users = User::orderBy('name', 'desc')-&gt;get();\n\n\/\/ \u8907\u6570\u56de\u306eorderBy\u547c\u3073\u51fa\u3057\n$users = User::orderBy('status')\n    -&gt;orderBy('created_at', 'desc')\n    -&gt;get();\n\n\/\/ latest()\u30e1\u30bd\u30c3\u30c9\uff08created_at\u306e\u964d\u9806\uff09\n$users = User::latest()-&gt;get();\n\n\/\/ oldest()\u30e1\u30bd\u30c3\u30c9\uff08created_at\u306e\u6607\u9806\uff09\n$users = User::oldest()-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-2\">\u6607\u9806\u30fb\u964d\u9806\u306e\u6307\u5b9a\u65b9\u6cd5\u3068\u305d\u306e\u4f7f\u3044\u5206\u3051<\/h3>\n\n\n\n<p>Laravel\u3067\u306f\u3001\u4e26\u3073\u9806\u3092\u6307\u5b9a\u3059\u308b\u65b9\u6cd5\u3068\u3057\u3066\u4ee5\u4e0b\u306e\u9078\u629e\u80a2\u304c\u3042\u308a\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u660e\u793a\u7684\u306a\u6307\u5b9a<\/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=\"\">\/\/ \u6607\u9806\uff08ASC\uff09- \u30c7\u30d5\u30a9\u30eb\u30c8\n$users = User::orderBy('points', 'asc')-&gt;get();\n\n\/\/ \u964d\u9806\uff08DESC\uff09\n$users = User::orderBy('points', 'desc')-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u5c02\u7528\u30e1\u30bd\u30c3\u30c9\u306e\u4f7f\u7528<\/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=\"\">\/\/ \u964d\u9806\n$users = User::orderByDesc('points')-&gt;get();\n\n\/\/ created_at\u964d\u9806\uff08latest\uff09\n$posts = Post::latest()-&gt;get();\n\n\/\/ created_at\u6607\u9806\uff08oldest\uff09\n$posts = Post::oldest()-&gt;get();<\/pre>\n\n\n\n<p>\u305d\u308c\u305e\u308c\u306e\u4f7f\u3044\u5206\u3051\u306e\u30dd\u30a4\u30f3\u30c8\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\uff1a<\/p>\n\n\n<div id=\"id-c9b49df6-9f5d-4b59-a922-984fd56057f3\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u624b\u6cd5<\/th><th>\u4f7f\u7528\u30b7\u30fc\u30f3<\/th><th>\u30e1\u30ea\u30c3\u30c8<\/th><\/tr><\/thead><tbody><tr><td>orderBy(\u2018column\u2019, \u2018asc\u2019)<\/td><td>\u660e\u793a\u7684\u306a\u6307\u5b9a\u304c\u5fc5\u8981\u306a\u5834\u5408<\/td><td>\u610f\u56f3\u304c\u660e\u78ba\u3067\u53ef\u8aad\u6027\u304c\u9ad8\u3044<\/td><\/tr><tr><td>orderBy(\u2018column\u2019)<\/td><td>\u30b7\u30f3\u30d7\u30eb\u306a\u6607\u9806\u30bd\u30fc\u30c8\u306e\u5834\u5408<\/td><td>\u30b3\u30fc\u30c9\u304c\u30b7\u30f3\u30d7\u30eb<\/td><\/tr><tr><td>orderByDesc(\u2018column\u2019)<\/td><td>\u964d\u9806\u30bd\u30fc\u30c8\u304c\u660e\u78ba\u306a\u5834\u5408<\/td><td>\u30e1\u30bd\u30c3\u30c9\u540d\u3067\u610f\u56f3\u304c\u660e\u78ba<\/td><\/tr><tr><td>latest()<\/td><td>\u65b0\u7740\u9806\u3067\u306e\u53d6\u5f97<\/td><td>created_at\u306b\u7279\u5316\u3057\u305f\u7c21\u6f54\u306a\u8a18\u8ff0<\/td><\/tr><tr><td>oldest()<\/td><td>\u53e4\u3044\u9806\u3067\u306e\u53d6\u5f97<\/td><td>created_at\u306b\u7279\u5316\u3057\u305f\u7c21\u6f54\u306a\u8a18\u8ff0<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-3\">\u8907\u6570\u30ab\u30e9\u30e0\u3067\u306e\u4e26\u3073\u66ff\u3048\u30c6\u30af\u30cb\u30c3\u30af<\/h3>\n\n\n\n<p>\u5b9f\u969b\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u306f\u3001\u8907\u6570\u306e\u30ab\u30e9\u30e0\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u4e26\u3073\u66ff\u3048\u304c\u5fc5\u8981\u306b\u306a\u308b\u3053\u3068\u304c\u591a\u304f\u3042\u308a\u307e\u3059\u3002Laravel\u3067\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u65b9\u6cd5\u3067\u5b9f\u73fe\u3067\u304d\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u8907\u6570\u306eorderBy\u30e1\u30bd\u30c3\u30c9\u306e\u30c1\u30a7\u30fc\u30f3<\/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=\"\">$users = User::orderBy('status')\n    -&gt;orderBy('name')\n    -&gt;orderBy('created_at', 'desc')\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>orderByRaw\u30e1\u30bd\u30c3\u30c9\u306e\u4f7f\u7528<\/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=\"\">\/\/ \u8907\u96d1\u306a\u4e26\u3073\u66ff\u3048\u6761\u4ef6\n$users = User::orderByRaw('CASE \n    WHEN status = \"premium\" THEN 1 \n    WHEN status = \"active\" THEN 2 \n    ELSE 3 END')\n    -&gt;orderBy('created_at', 'desc')\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u5404\u30ab\u30e9\u30e0\u3067\u7570\u306a\u308b\u4e26\u3073\u9806\u306e\u6307\u5b9a<\/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=\"\">$posts = Post::orderBy('category', 'asc')\n    -&gt;orderBy('published_at', 'desc')\n    -&gt;orderBy('title', 'asc')\n    -&gt;get();<\/pre>\n\n\n\n<p>\u8907\u6570\u30ab\u30e9\u30e0\u3067\u306e\u4e26\u3073\u66ff\u3048\u306b\u304a\u3051\u308b\u91cd\u8981\u306a\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30ab\u30e9\u30e0\u306e\u9806\u5e8f\u306f\u512a\u5148\u9806\u4f4d\u3092\u8868\u3059\uff08\u5de6\u304b\u3089\u9806\u306b\u9069\u7528\uff09<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u8003\u616e\u3057\u305f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u304c\u91cd\u8981<\/li>\n\n\n\n<li>\u5fc5\u8981\u6700\u5c0f\u9650\u306e\u30ab\u30e9\u30e0\u306e\u307f\u3092\u4f7f\u7528\u3059\u308b<\/li>\n\n\n\n<li>\u53ef\u8aad\u6027\u3068\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u6027\u306e\u30d0\u30e9\u30f3\u30b9\u3092\u8003\u616e\u3059\u308b<\/li>\n<\/ul>\n\n\n\n<p>\u5b9f\u88c5\u4f8b\u3068\u3057\u3066\u3001\u30d6\u30ed\u30b0\u8a18\u4e8b\u3092\u8907\u6570\u6761\u4ef6\u3067\u4e26\u3073\u66ff\u3048\u308b\u30b1\u30fc\u30b9\u3092\u898b\u3066\u307f\u307e\u3057\u3087\u3046\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 PostController extends Controller\n{\n    public function index()\n    {\n        \/\/ \u6295\u7a3f\u3092\u30ab\u30c6\u30b4\u30ea\u9806\u3001\u516c\u958b\u65e5\u6642\u306e\u964d\u9806\u3001\u30bf\u30a4\u30c8\u30eb\u9806\u3067\u53d6\u5f97\n        $posts = Post::query()\n            -&gt;when(request('sort_by_category'), function ($query) {\n                $query-&gt;orderBy('category');\n            })\n            -&gt;when(request('sort_by_date'), function ($query) {\n                $query-&gt;orderBy('published_at', 'desc');\n            })\n            -&gt;when(request('sort_by_title'), function ($query) {\n                $query-&gt;orderBy('title');\n            })\n            -&gt;paginate(20);\n\n        return view('posts.index', compact('posts'));\n    }\n}<\/pre>\n\n\n\n<p>\u3053\u306e\u5b9f\u88c5\u3067\u306f\u3001\u4ee5\u4e0b\u306e\u7279\u5fb4\u304c\u3042\u308a\u307e\u3059\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>when\u30e1\u30bd\u30c3\u30c9\u306b\u3088\u308b\u6761\u4ef6\u4ed8\u304d\u306e\u4e26\u3073\u66ff\u3048<\/li>\n\n\n\n<li>\u30af\u30a8\u30ea\u30d1\u30e9\u30e1\u30fc\u30bf\u306b\u57fa\u3065\u304f\u52d5\u7684\u306a\u30bd\u30fc\u30c8<\/li>\n\n\n\n<li>\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3068\u306e\u7d44\u307f\u5408\u308f\u305b<\/li>\n\n\n\n<li>\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u6027\u306e\u9ad8\u3044\u30b3\u30fc\u30c9\u69cb\u9020<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-4\">\u9ad8\u5ea6\u306a\u4e26\u3073\u66ff\u3048\u30c6\u30af\u30cb\u30c3\u30af<\/h2>\n\n\n\n<p>orderBy\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3092\u7406\u89e3\u3057\u305f\u3068\u3053\u308d\u3067\u3001\u3088\u308a\u5b9f\u8df5\u7684\u306a\u5834\u9762\u3067\u5fc5\u8981\u3068\u306a\u308b\u9ad8\u5ea6\u306a\u30c6\u30af\u30cb\u30c3\u30af\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002\u3053\u3053\u3067\u306f\u3001\u5b9f\u52d9\u3067\u3088\u304f\u906d\u9047\u3059\u308b\u8907\u96d1\u306a\u30bd\u30fc\u30c8\u8981\u4ef6\u306b\u5bfe\u3059\u308b\u89e3\u6c7a\u7b56\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-5\">where\u3068orderBy\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u3088\u308b\u6761\u4ef6\u4ed8\u304d\u4e26\u3073\u66ff\u3048<\/h3>\n\n\n\n<p>\u5b9f\u969b\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u306f\u3001\u7279\u5b9a\u306e\u6761\u4ef6\u4e0b\u3067\u306e\u307f\u9069\u7528\u3055\u308c\u308b\u4e26\u3073\u66ff\u3048\u3084\u3001\u6761\u4ef6\u306b\u3088\u3063\u3066\u4e26\u3073\u66ff\u3048\u30ed\u30b8\u30c3\u30af\u3092\u5207\u308a\u66ff\u3048\u308b\u30b1\u30fc\u30b9\u304c\u983b\u7e41\u306b\u767a\u751f\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30b7\u30f3\u30d7\u30eb\u306a\u6761\u4ef6\u4ed8\u304d\u4e26\u3073\u66ff\u3048<\/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\u6761\u4ef6\u4ed8\u304d\u4e26\u3073\u66ff\u3048\n$query = Product::query();\n\nif ($request-&gt;has('category_id')) {\n    $query-&gt;where('category_id', $request-&gt;category_id)\n          -&gt;orderBy('price', 'asc');\n} else {\n    $query-&gt;orderBy('created_at', 'desc');\n}\n\n$products = $query-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>when\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u305f\u30af\u30ea\u30fc\u30f3\u306a\u5b9f\u88c5<\/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=\"\">\/\/ when\u30e1\u30bd\u30c3\u30c9\u306b\u3088\u308b\u6761\u4ef6\u5206\u5c90\n$products = Product::query()\n    -&gt;when($request-&gt;category_id, function ($query, $categoryId) {\n        return $query-&gt;where('category_id', $categoryId)\n                    -&gt;orderBy('price', 'asc');\n    })\n    -&gt;when($request-&gt;search, function ($query, $search) {\n        return $query-&gt;where('name', 'like', \"%{$search}%\")\n                    -&gt;orderBy('relevance', 'desc');\n    })\n    -&gt;orderBy('created_at', 'desc')\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u4f8b\uff1aEC\u30b5\u30a4\u30c8\u306e\u5546\u54c1\u4e00\u89a7<\/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=\"\">class ProductController extends Controller\n{\n    public function index(Request $request)\n    {\n        $query = Product::query();\n\n        \/\/ \u5728\u5eab\u72b6\u6cc1\u306b\u3088\u308b\u512a\u5148\u9806\u4f4d\u4ed8\u3051\n        $query-&gt;when($request-&gt;in_stock_first, function ($query) {\n            return $query-&gt;orderByRaw('\n                CASE \n                    WHEN stock_quantity &gt; 0 THEN 1\n                    WHEN stock_quantity = 0 AND accepts_backorder = 1 THEN 2\n                    ELSE 3 \n                END\n            ');\n        });\n\n        \/\/ \u30bb\u30fc\u30eb\u5546\u54c1\u306e\u512a\u5148\u8868\u793a\n        $query-&gt;when($request-&gt;sale_first, function ($query) {\n            return $query-&gt;orderByRaw('\n                CASE \n                    WHEN discount_rate &gt; 0 THEN discount_rate \n                    ELSE 0 \n                END DESC\n            ');\n        });\n\n        \/\/ \u57fa\u672c\u7684\u306a\u30bd\u30fc\u30c8\u9806\u306e\u9069\u7528\n        $query-&gt;when($request-&gt;sort, function ($query, $sort) {\n            switch ($sort) {\n                case 'price_asc':\n                    return $query-&gt;orderBy('price', 'asc');\n                case 'price_desc':\n                    return $query-&gt;orderBy('price', 'desc');\n                case 'newest':\n                    return $query-&gt;orderBy('created_at', 'desc');\n                default:\n                    return $query-&gt;orderBy('featured', 'desc');\n            }\n        });\n\n        return $query-&gt;paginate(20);\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-6\">\u30b5\u30d6\u30af\u30a8\u30ea\u3092\u4f7f\u7528\u3057\u305f\u52d5\u7684\u306a\u4e26\u3073\u66ff\u3048<\/h3>\n\n\n\n<p>\u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u8907\u96d1\u306a\u4e26\u3073\u66ff\u3048\u3084\u3001\u96c6\u8a08\u7d50\u679c\u306b\u57fa\u3065\u304f\u30bd\u30fc\u30c8\u3092\u5b9f\u73fe\u3059\u308b\u305f\u3081\u306b\u3001\u30b5\u30d6\u30af\u30a8\u30ea\u3092\u6d3b\u7528\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u58f2\u4e0a\u6570\u306b\u3088\u308b\u5546\u54c1\u4e26\u3073\u66ff\u3048<\/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=\"\">$products = Product::query()\n    -&gt;select('products.*')\n    -&gt;selectSub(\n        OrderItem::selectRaw('COUNT(*)')\n            -&gt;whereColumn('product_id', 'products.id')\n            -&gt;whereHas('order', function ($query) {\n                $query-&gt;where('status', 'completed');\n            }),\n        'sales_count'\n    )\n    -&gt;orderBy('sales_count', 'desc')\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u8a55\u4fa1\u5e73\u5747\u306b\u3088\u308b\u30e6\u30fc\u30b6\u30fc\u30e9\u30f3\u30ad\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=\"\">$users = User::query()\n    -&gt;select('users.*')\n    -&gt;selectSub(\n        Review::selectRaw('AVG(rating)')\n            -&gt;whereColumn('reviewed_user_id', 'users.id')\n            -&gt;where('created_at', '&gt;=', now()-&gt;subMonths(3)),\n        'avg_rating'\n    )\n    -&gt;having('avg_rating', '&gt;=', 4.0)\n    -&gt;orderBy('avg_rating', 'desc')\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u8907\u5408\u30b9\u30b3\u30a2\u306b\u3088\u308b\u4e26\u3073\u66ff\u3048<\/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=\"\">\/\/ \u30d6\u30ed\u30b0\u8a18\u4e8b\u3092\u4eba\u6c17\u5ea6\u3067\u30bd\u30fc\u30c8\n$posts = Post::query()\n    -&gt;select('posts.*')\n    -&gt;selectSub(\n        function ($query) {\n            $query-&gt;selectRaw('\n                (COALESCE(view_count, 0) * 0.4) + \n                (COALESCE(like_count, 0) * 0.3) +\n                (COALESCE(comment_count, 0) * 0.3)\n            ')\n            -&gt;from('post_statistics')\n            -&gt;whereColumn('post_id', 'posts.id')\n            -&gt;limit(1);\n        },\n        'popularity_score'\n    )\n    -&gt;orderBy('popularity_score', 'desc')\n    -&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-7\">\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30ab\u30e9\u30e0\u306b\u3088\u308b\u4e26\u3073\u66ff\u3048\u624b\u6cd5<\/h3>\n\n\n\n<p>Laravel\u3067\u306f\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30c7\u30fc\u30bf\u3092\u57fa\u6e96\u306b\u3057\u305f\u4e26\u3073\u66ff\u3048\u3082\u7c21\u5358\u306b\u5b9f\u88c5\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u57fa\u672c\u7684\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30bd\u30fc\u30c8<\/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=\"\">\/\/ \u30ab\u30c6\u30b4\u30ea\u540d\u3067\u30bd\u30fc\u30c8\u3057\u305f\u5546\u54c1\u4e00\u89a7\n$products = Product::query()\n    -&gt;join('categories', 'products.category_id', '=', 'categories.id')\n    -&gt;select('products.*')\n    -&gt;orderBy('categories.name')\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>with\u3092\u4f7f\u7528\u3057\u305f\u52b9\u7387\u7684\u306a\u5b9f\u88c5<\/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=\"\">\/\/ N+1\u554f\u984c\u3092\u56de\u907f\u3057\u306a\u304c\u3089\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u3067\u30bd\u30fc\u30c8\n$posts = Post::with(['user', 'category'])\n    -&gt;select('posts.*')\n    -&gt;join('users', 'posts.user_id', '=', 'users.id')\n    -&gt;orderBy('users.name')\n    -&gt;orderBy('posts.created_at', 'desc')\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u4f8b\uff1a\u7ba1\u7406\u753b\u9762\u306e\u6ce8\u6587\u4e00\u89a7<\/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=\"\">class OrderController extends Controller\n{\n    public function index(Request $request)\n    {\n        $query = Order::query()\n            -&gt;with(['user', 'items.product']);\n\n        \/\/ \u30e6\u30fc\u30b6\u30fc\u540d\u3067\u30bd\u30fc\u30c8\n        if ($request-&gt;sort === 'customer') {\n            $query-&gt;join('users', 'orders.user_id', '=', 'users.id')\n                  -&gt;orderBy('users.name', $request-&gt;direction ?? 'asc');\n        }\n\n        \/\/ \u6ce8\u6587\u5408\u8a08\u91d1\u984d\u3067\u30bd\u30fc\u30c8\n        if ($request-&gt;sort === 'total') {\n            $query-&gt;orderBy('total_amount', $request-&gt;direction ?? 'desc');\n        }\n\n        \/\/ \u30c7\u30d5\u30a9\u30eb\u30c8\u306f\u6ce8\u6587\u65e5\u6642\u306e\u964d\u9806\n        $query-&gt;orderBy('orders.created_at', 'desc');\n\n        return $query-&gt;paginate(50);\n    }\n}<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u9ad8\u5ea6\u306a\u30c6\u30af\u30cb\u30c3\u30af\u3092\u4f7f\u3044\u3053\u306a\u3059\u3053\u3068\u3067\u3001\u8907\u96d1\u306a\u30d3\u30b8\u30cd\u30b9\u8981\u4ef6\u306b\u3082\u67d4\u8edf\u306b\u5bfe\u5fdc\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3078\u306e\u5f71\u97ff\u3082\u8003\u616e\u3057\u306a\u304c\u3089\u3001\u9069\u5207\u306a\u624b\u6cd5\u3092\u9078\u629e\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002\u7279\u306b\u3001\u30b5\u30d6\u30af\u30a8\u30ea\u3084JOIN\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\u306f\u3001\u5b9f\u884c\u8a08\u753b\u3092\u78ba\u8a8d\u3057\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u9069\u5207\u306b\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-8\">\u5b9f\u8df5\u7684\u306a\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u96c6<\/h2>\n\n\n\n<p>\u5b9f\u969b\u306eWeb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u958b\u767a\u3067\u306f\u3001\u5358\u7d14\u306a\u4e26\u3073\u66ff\u3048\u3060\u3051\u3067\u306a\u304f\u3001\u30e6\u30fc\u30b6\u30fc\u306e\u64cd\u4f5c\u3084\u8907\u96d1\u306a\u30d3\u30b8\u30cd\u30b9\u30ed\u30b8\u30c3\u30af\u306b\u5fdc\u3058\u305f\u52d5\u7684\u306a\u4e26\u3073\u66ff\u3048\u304c\u5fc5\u8981\u3068\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u5b9f\u52d9\u3067\u3088\u304f\u906d\u9047\u3059\u308b\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u3068\u305d\u306e\u89e3\u6c7a\u7b56\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-9\">\u30e6\u30fc\u30b6\u30fc\u5165\u529b\u306b\u57fa\u3065\u304f\u52d5\u7684\u306a\u4e26\u3073\u66ff\u3048\u306e\u5b9f\u88c5<\/h3>\n\n\n\n<p>\u30e6\u30fc\u30b6\u30fc\u306e\u5165\u529b\u3084\u9078\u629e\u306b\u57fa\u3065\u3044\u3066\u4e26\u3073\u66ff\u3048\u3092\u884c\u3046\u5b9f\u88c5\u306f\u3001\u591a\u304f\u306eWeb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u5fc5\u8981\u3068\u3055\u308c\u308b\u57fa\u672c\u7684\u306a\u6a5f\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30bd\u30fc\u30c8\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u3068\u51e6\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=\"\">class ProductListController extends Controller\n{\n    \/\/ \u8a31\u53ef\u3059\u308b\u30bd\u30fc\u30c8\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u5b9a\u7fa9\n    private const ALLOWED_SORT_FIELDS = [\n        'name' =&gt; ['column' =&gt; 'name', 'direction' =&gt; 'asc'],\n        'price_low' =&gt; ['column' =&gt; 'price', 'direction' =&gt; 'asc'],\n        'price_high' =&gt; ['column' =&gt; 'price', 'direction' =&gt; 'desc'],\n        'newest' =&gt; ['column' =&gt; 'created_at', 'direction' =&gt; 'desc'],\n        'popular' =&gt; ['column' =&gt; 'view_count', 'direction' =&gt; 'desc'],\n    ];\n\n    public function index(Request $request)\n    {\n        \/\/ \u30ea\u30af\u30a8\u30b9\u30c8\u304b\u3089\u30bd\u30fc\u30c8\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u53d6\u5f97\n        $sortKey = $request-&gt;input('sort', 'newest');\n\n        \/\/ \u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30bd\u30fc\u30c8\u8a2d\u5b9a\n        $sortConfig = self::ALLOWED_SORT_FIELDS[$sortKey] ?? self::ALLOWED_SORT_FIELDS['newest'];\n\n        $products = Product::query()\n            -&gt;when($request-&gt;category_id, function ($query, $categoryId) {\n                return $query-&gt;where('category_id', $categoryId);\n            })\n            -&gt;orderBy($sortConfig['column'], $sortConfig['direction'])\n            -&gt;paginate(20);\n\n        \/\/ \u30d3\u30e5\u30fc\u306b\u30bd\u30fc\u30c8\u60c5\u5831\u3092\u6e21\u3059\n        return view('products.index', [\n            'products' =&gt; $products,\n            'currentSort' =&gt; $sortKey,\n            'sortOptions' =&gt; array_keys(self::ALLOWED_SORT_FIELDS),\n        ]);\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Blade \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3067\u306e\u30bd\u30fc\u30c8UI\u306e\u5b9f\u88c5<\/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=\"\">{{-- products\/index.blade.php --}}\n&lt;div class=\"sort-controls\"&gt;\n    &lt;select name=\"sort\" class=\"form-select\" onchange=\"this.form.submit()\"&gt;\n        @foreach($sortOptions as $key)\n            &lt;option value=\"{{ $key }}\" {{ $currentSort === $key ? 'selected' : '' }}&gt;\n                {{ __(\"sort.{$key}\") }}\n            &lt;\/option&gt;\n        @endforeach\n    &lt;\/select&gt;\n&lt;\/div&gt;<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>JavaScript \u3067\u306e\u975e\u540c\u671f\u30bd\u30fc\u30c8\u5b9f\u88c5<\/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=\"\">\/\/ products.js\nclass ProductSorter {\n    constructor() {\n        this.sortSelect = document.querySelector('.sort-select');\n        this.productGrid = document.querySelector('.product-grid');\n\n        this.bindEvents();\n    }\n\n    bindEvents() {\n        this.sortSelect.addEventListener('change', async (e) =&gt; {\n            const sortValue = e.target.value;\n            await this.updateProducts(sortValue);\n        });\n    }\n\n    async updateProducts(sortValue) {\n        try {\n            const response = await fetch(`\/api\/products?sort=${sortValue}`);\n            const data = await response.json();\n\n            this.renderProducts(data.products);\n        } catch (error) {\n            console.error('Failed to fetch sorted products:', error);\n        }\n    }\n\n    renderProducts(products) {\n        \/\/ \u5546\u54c1\u30ea\u30b9\u30c8\u306e\u66f4\u65b0\u51e6\u7406\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-10\">\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3068\u7d44\u307f\u5408\u308f\u305b\u305f\u52b9\u7387\u7684\u306a\u5b9f\u88c5<\/h3>\n\n\n\n<p>\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u6271\u3046\u5834\u5408\u3001\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3068\u4e26\u3073\u66ff\u3048\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u4ee5\u4e0b\u306f\u3001\u52b9\u7387\u7684\u306a\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u57fa\u672c\u7684\u306a\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3068\u4e26\u3073\u66ff\u3048\u306e\u7d44\u307f\u5408\u308f\u305b<\/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=\"\">class ArticleController extends Controller\n{\n    public function index(Request $request)\n    {\n        $query = Article::query()\n            -&gt;with(['author', 'category']) \/\/ Eager Loading\n            -&gt;where('status', 'published');\n\n        \/\/ \u30bd\u30fc\u30c8\u51e6\u7406\n        $query-&gt;when($request-&gt;sort, function ($query, $sort) {\n            switch ($sort) {\n                case 'title':\n                    return $query-&gt;orderBy('title');\n                case 'views':\n                    return $query-&gt;orderBy('view_count', 'desc');\n                default:\n                    return $query-&gt;latest();\n            }\n        }, function ($query) {\n            \/\/ \u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30bd\u30fc\u30c8\u9806\n            return $query-&gt;latest();\n        });\n\n        \/\/ \u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u306e\u9069\u7528\n        $articles = $query-&gt;paginate(15)\n            -&gt;withQueryString(); \/\/ \u30bd\u30fc\u30c8\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u30ea\u30f3\u30af\u306b\u4fdd\u6301\n\n        return view('articles.index', compact('articles'));\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30ab\u30fc\u30bd\u30eb\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u305f\u52b9\u7387\u7684\u306a\u5b9f\u88c5<\/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=\"\">class TimelineController extends Controller\n{\n    public function index(Request $request)\n    {\n        $query = Post::query()\n            -&gt;with(['user', 'likes'])\n            -&gt;where('status', 'published');\n\n        \/\/ \u3044\u3044\u306d\u6570\u3067\u30bd\u30fc\u30c8\u3059\u308b\u5834\u5408\u306e\u5b9f\u88c5\n        if ($request-&gt;sort === 'popular') {\n            $posts = $query\n                -&gt;orderBy('likes_count', 'desc')\n                -&gt;orderBy('id', 'desc')  \/\/ \u30bb\u30ab\u30f3\u30c0\u30ea\u30bd\u30fc\u30c8\n                -&gt;cursorPaginate(20);\n        } else {\n            \/\/ \u30c7\u30d5\u30a9\u30eb\u30c8\u306f\u6295\u7a3f\u65e5\u6642\u9806\n            $posts = $query\n                -&gt;latest()\n                -&gt;cursorPaginate(20);\n        }\n\n        return view('timeline.index', compact('posts'));\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-11\">\u8907\u6570\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3057\u305f\u9ad8\u5ea6\u306a\u4e26\u3073\u66ff\u3048\u30ed\u30b8\u30c3\u30af<\/h3>\n\n\n\n<p>\u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3057\u3066\u3001\u3088\u308a\u8907\u96d1\u306a\u6761\u4ef6\u3067\u306e\u4e26\u3073\u66ff\u3048\u3092\u5b9f\u73fe\u3059\u308b\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u8ca9\u58f2\u5b9f\u7e3e\u3092\u8003\u616e\u3057\u305f\u5546\u54c1\u4e26\u3073\u66ff\u3048<\/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=\"\">class ShopController extends Controller\n{\n    public function index(Request $request)\n    {\n        $query = Product::query()\n            -&gt;select('products.*')\n            -&gt;leftJoin('order_items', function ($join) {\n                $join-&gt;on('products.id', '=', 'order_items.product_id')\n                    -&gt;whereRaw('order_items.created_at &gt;= ?', [now()-&gt;subDays(30)]);\n            })\n            -&gt;groupBy('products.id');\n\n        \/\/ \u58f2\u4e0a\u5b9f\u7e3e\u3067\u30bd\u30fc\u30c8\n        if ($request-&gt;sort === 'sales') {\n            $query-&gt;selectRaw('COUNT(order_items.id) as sales_count')\n                  -&gt;orderBy('sales_count', 'desc');\n        }\n\n        \/\/ \u58f2\u4e0a\u91d1\u984d\u3067\u30bd\u30fc\u30c8\n        elseif ($request-&gt;sort === 'revenue') {\n            $query-&gt;selectRaw('SUM(order_items.price * order_items.quantity) as revenue')\n                  -&gt;orderBy('revenue', 'desc');\n        }\n\n        \/\/ \u30c7\u30d5\u30a9\u30eb\u30c8\u306f\u65b0\u7740\u9806\n        else {\n            $query-&gt;orderBy('products.created_at', 'desc');\n        }\n\n        $products = $query-&gt;paginate(20);\n\n        return view('shop.index', compact('products'));\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30e6\u30fc\u30b6\u30fc\u30a2\u30af\u30c6\u30a3\u30d3\u30c6\u30a3\u3092\u8003\u616e\u3057\u305f\u30e9\u30f3\u30ad\u30f3\u30b0\u5b9f\u88c5<\/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=\"\">class RankingController extends Controller\n{\n    public function index()\n    {\n        $users = User::query()\n            -&gt;select('users.*')\n            -&gt;leftJoin('posts', 'users.id', '=', 'posts.user_id')\n            -&gt;leftJoin('comments', 'users.id', '=', 'comments.user_id')\n            -&gt;groupBy('users.id')\n            -&gt;selectRaw('\n                COUNT(DISTINCT posts.id) * 10 +\n                COUNT(DISTINCT comments.id) * 2 +\n                COALESCE(users.follower_count, 0) * 5 as activity_score\n            ')\n            -&gt;having('activity_score', '&gt;', 0)\n            -&gt;orderBy('activity_score', 'desc')\n            -&gt;limit(100)\n            -&gt;get();\n\n        return view('rankings.index', compact('users'));\n    }\n}<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u306f\u3001\u57fa\u672c\u7684\u306a\u30d1\u30bf\u30fc\u30f3\u3092\u30d9\u30fc\u30b9\u306b\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u8981\u4ef6\u306b\u5fdc\u3058\u3066\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3057\u3066\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u5b9f\u88c5\u6642\u306f\u4ee5\u4e0b\u306e\u70b9\u306b\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u8003\u616e\u3057\u305f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08<\/li>\n\n\n\n<li>N+1\u554f\u984c\u306e\u56de\u907f<\/li>\n\n\n\n<li>\u30e6\u30fc\u30b6\u30fc\u5165\u529b\u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0<\/li>\n\n\n\n<li>\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u6027\u3092\u8003\u616e\u3057\u305f\u30b3\u30fc\u30c9\u8a2d\u8a08<\/li>\n<\/ul>\n\n\n\n<p>\u307e\u305f\u3001\u3053\u308c\u3089\u306e\u30d1\u30bf\u30fc\u30f3\u3092\u5b9f\u88c5\u3059\u308b\u969b\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u898f\u6a21\u3084\u8981\u4ef6\u306b\u5fdc\u3058\u3066\u3001\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u5c0e\u5165\u3084\u30af\u30a8\u30ea\u306e\u6700\u9069\u5316\u306a\u3069\u3001\u8ffd\u52a0\u306e\u6539\u5584\u3092\u691c\u8a0e\u3059\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-12\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h2>\n\n\n\n<p>orderBy\u3092\u4f7f\u7528\u3057\u305f\u30bd\u30fc\u30c8\u51e6\u7406\u306f\u3001\u30c7\u30fc\u30bf\u91cf\u304c\u5897\u52a0\u3059\u308b\u306b\u3064\u308c\u3066\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u5927\u304d\u306a\u5f71\u97ff\u3092\u4e0e\u3048\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u5b9f\u8df5\u7684\u306a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u624b\u6cd5\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-13\">\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u6d3b\u7528\u3057\u305f\u4e26\u3073\u66ff\u3048\u306e\u9ad8\u901f\u5316<\/h3>\n\n\n\n<p>\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u306f\u3001orderBy\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5927\u304d\u304f\u5411\u4e0a\u3055\u305b\u308b\u91cd\u8981\u306a\u8981\u7d20\u3067\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u57fa\u672c\u7684\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08<\/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=\"\">\/\/ \u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u5b9a\npublic function up()\n{\n    Schema::create('products', function (Blueprint $table) {\n        $table-&gt;id();\n        $table-&gt;string('name');\n        $table-&gt;decimal('price', 10, 2);\n        $table-&gt;integer('stock');\n        $table-&gt;timestamp('created_at');\n\n        \/\/ \u5358\u4e00\u30ab\u30e9\u30e0\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\n        $table-&gt;index('price');\n        $table-&gt;index('created_at');\n\n        \/\/ \u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\n        $table-&gt;index(['category_id', 'price']);\n    });\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u52b9\u679c\u7684\u306a\u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u8a2d\u8a08\u4f8b<\/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=\"\">class CreateOrdersTable extends Migration\n{\n    public function up()\n    {\n        Schema::create('orders', function (Blueprint $table) {\n            $table-&gt;id();\n            $table-&gt;foreignId('user_id')-&gt;constrained();\n            $table-&gt;string('status');\n            $table-&gt;decimal('total_amount', 10, 2);\n            $table-&gt;timestamps();\n\n            \/\/ \u8907\u6570\u306e\u4e26\u3073\u66ff\u3048\u30d1\u30bf\u30fc\u30f3\u306b\u5bfe\u5fdc\u3059\u308b\u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\n            $table-&gt;index(['status', 'created_at']);\n            $table-&gt;index(['user_id', 'created_at']);\n            $table-&gt;index(['status', 'total_amount']);\n        });\n    }\n}<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\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=\"\">-- \u3088\u304f\u4f7f\u7528\u3055\u308c\u308b\u691c\u7d22\u30fb\u30bd\u30fc\u30c8\u30d1\u30bf\u30fc\u30f3\u306e\u5206\u6790\u4f8b\nEXPLAIN SELECT * FROM products \nWHERE category_id = 1 \nORDER BY price DESC \nLIMIT 20;\n\n-- \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u4f7f\u7528\u72b6\u6cc1\u306e\u78ba\u8a8d\nSHOW INDEX FROM products;<\/pre>\n\n\n\n<p>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u306e\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u983b\u7e41\u306b\u4f7f\u7528\u3055\u308c\u308bWHERE\u53e5\u3068ORDER BY\u53e5\u306e\u7d44\u307f\u5408\u308f\u305b\u3092\u5206\u6790<\/li>\n\n\n\n<li>\u30ab\u30fc\u30c7\u30a3\u30ca\u30ea\u30c6\u30a3\uff08\u5024\u306e\u7a2e\u985e\uff09\u3092\u8003\u616e<\/li>\n\n\n\n<li>\u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u5217\u9806\u5e8f\u306e\u6700\u9069\u5316<\/li>\n\n\n\n<li>\u4e0d\u8981\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u524a\u9664\u306b\u3088\u308b\u4fdd\u5b88\u6027\u306e\u5411\u4e0a<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-14\">\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3067\u306e\u4e26\u3073\u66ff\u3048\u6226\u7565<\/h3>\n\n\n\n<p>\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u6271\u3046\u5834\u5408\u3001\u52b9\u7387\u7684\u306a\u30bd\u30fc\u30c8\u6226\u7565\u304c\u91cd\u8981\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u9045\u5ef6\u30ed\u30fc\u30c9\u3068\u65e9\u671f\u30ed\u30fc\u30c9\u306e\u4f7f\u3044\u5206\u3051<\/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=\"\">class ProductController extends Controller\n{\n    public function index()\n    {\n        \/\/ \u57fa\u672c\u30af\u30a8\u30ea\u306e\u69cb\u7bc9\n        $query = Product::query()\n            -&gt;select(['id', 'name', 'price', 'category_id'])  \/\/ \u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u9078\u629e\n            -&gt;with(['category' =&gt; function ($query) {         \/\/ \u5fc5\u8981\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u307f\u8aad\u307f\u8fbc\u307f\n                $query-&gt;select(['id', 'name']);\n            }]);\n\n        \/\/ \u30bd\u30fc\u30c8\u6761\u4ef6\u306e\u9069\u7528\n        $products = $query-&gt;when(request('sort') === 'price', function ($query) {\n            return $query-&gt;orderBy('price', 'desc');\n        }, function ($query) {\n            return $query-&gt;latest();\n        })\n        -&gt;paginate(20);\n\n        \/\/ \u30ec\u30b9\u30dd\u30f3\u30b9\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u6d3b\u7528\n        return cache()-&gt;remember(\n            \"products.page.{$products-&gt;currentPage()}.sort.{request('sort')}\",\n            now()-&gt;addMinutes(30),\n            fn () =&gt; view('products.index', compact('products'))-&gt;render()\n        );\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30c1\u30e3\u30f3\u30af\u51e6\u7406\u306b\u3088\u308b\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u306e\u52b9\u7387\u7684\u306a\u51e6\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=\"\">class ProductExportController extends Controller\n{\n    public function export()\n    {\n        $filename = \"products_export_\" . now()-&gt;format('Y-m-d_His') . \".csv\";\n\n        return response()-&gt;stream(function () {\n            \/\/ CSV\u30d8\u30c3\u30c0\u30fc\u306e\u51fa\u529b\n            $handle = fopen('php:\/\/output', 'w');\n            fputcsv($handle, ['ID', '\u5546\u54c1\u540d', '\u4fa1\u683c', '\u5728\u5eab\u6570']);\n\n            \/\/ \u30c1\u30e3\u30f3\u30af\u51e6\u7406\u306b\u3088\u308b\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u306e\u52b9\u7387\u7684\u306a\u51fa\u529b\n            Product::query()\n                -&gt;orderBy('id')\n                -&gt;chunk(1000, function ($products) use ($handle) {\n                    foreach ($products as $product) {\n                        fputcsv($handle, [\n                            $product-&gt;id,\n                            $product-&gt;name,\n                            $product-&gt;price,\n                            $product-&gt;stock\n                        ]);\n                    }\n                });\n\n            fclose($handle);\n        }, 200, [\n            'Content-Type' =&gt; 'text\/csv',\n            'Content-Disposition' =&gt; \"attachment; filename=\\\"{$filename}\\\"\"\n        ]);\n    }\n}<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30ab\u30fc\u30bd\u30eb\u30d9\u30fc\u30b9\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u306e\u6d3b\u7528<\/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=\"\">class TimelineController extends Controller\n{\n    public function index()\n    {\n        return Post::query()\n            -&gt;select(['id', 'title', 'created_at'])\n            -&gt;orderBy('created_at', 'desc')\n            -&gt;orderBy('id', 'desc')\n            -&gt;cursorPaginate(20)\n            -&gt;through(function ($post) {\n                \/\/ \u5fc5\u8981\u306a\u52a0\u5de5\u51e6\u7406\n                return [\n                    'id' =&gt; $post-&gt;id,\n                    'title' =&gt; $post-&gt;title,\n                    'posted_at' =&gt; $post-&gt;created_at-&gt;diffForHumans()\n                ];\n            });\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-15\">\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u6d3b\u7528\u3057\u305f\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6539\u5584\u624b\u6cd5<\/h3>\n\n\n\n<p>\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u52b9\u679c\u7684\u306b\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u4e26\u3073\u66ff\u3048\u51e6\u7406\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5927\u5e45\u306b\u6539\u5584\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30d3\u30e5\u30fc\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u5b9f\u88c5<\/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=\"\">class CategoryController extends Controller\n{\n    public function show(Category $category)\n    {\n        $sortBy = request('sort', 'newest');\n        $cacheKey = \"category.{$category-&gt;id}.products.{$sortBy}.page.\" . request('page', 1);\n\n        return cache()-&gt;remember($cacheKey, now()-&gt;addMinutes(30), function () use ($category, $sortBy) {\n            $products = $category-&gt;products()\n                -&gt;when($sortBy === 'price_asc', fn($q) =&gt; $q-&gt;orderBy('price'))\n                -&gt;when($sortBy === 'price_desc', fn($q) =&gt; $q-&gt;orderBy('price', 'desc'))\n                -&gt;when($sortBy === 'newest', fn($q) =&gt; $q-&gt;latest())\n                -&gt;paginate(20);\n\n            return view('categories.show', compact('category', 'products'))-&gt;render();\n        });\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30af\u30a8\u30ea\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u52b9\u679c\u7684\u306a\u5229\u7528<\/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=\"\">class RankingService\n{\n    public function getPopularProducts()\n    {\n        $cacheKey = 'popular_products_' . now()-&gt;format('Y-m-d');\n\n        return cache()-&gt;remember($cacheKey, now()-&gt;addHours(1), function () {\n            return Product::query()\n                -&gt;select('products.*')\n                -&gt;leftJoin('order_items', 'products.id', '=', 'order_items.product_id')\n                -&gt;where('order_items.created_at', '&gt;=', now()-&gt;subDays(30))\n                -&gt;groupBy('products.id')\n                -&gt;orderByRaw('COUNT(order_items.id) DESC')\n                -&gt;limit(100)\n                -&gt;get();\n        });\n    }\n}<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30ad\u30e3\u30c3\u30b7\u30e5\u5236\u5fa1\u306e\u5b9f\u88c5\u4f8b<\/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=\"\">class ProductObserver\n{\n    public function saved(Product $product)\n    {\n        \/\/ \u95a2\u9023\u3059\u308b\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u524a\u9664\n        cache()-&gt;tags(['products', \"category.{$product-&gt;category_id}\"])-&gt;flush();\n    }\n\n    public function deleted(Product $product)\n    {\n        \/\/ \u95a2\u9023\u3059\u308b\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u524a\u9664\n        cache()-&gt;tags(['products', \"category.{$product-&gt;category_id}\"])-&gt;flush();\n    }\n}<\/pre>\n\n\n\n<p>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306b\u304a\u3051\u308b\u91cd\u8981\u306a\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\u3068\u30d7\u30ed\u30d5\u30a1\u30a4\u30ea\u30f3\u30b0<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30af\u30a8\u30ea\u30ed\u30b0\u306e\u5206\u6790<\/li>\n\n\n\n<li>\u5b9f\u884c\u8a08\u753b\u306e\u78ba\u8a8d<\/li>\n\n\n\n<li>\u30dc\u30c8\u30eb\u30cd\u30c3\u30af\u306e\u7279\u5b9a<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30b7\u30b9\u30c6\u30e0\u8a2d\u8a08\u3067\u306e\u8003\u616e\u70b9<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u3092\u8003\u616e\u3057\u305f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u306e\u8a08\u753b<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u91cf\u5897\u52a0\u3078\u306e\u5bfe\u5fdc<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u904b\u7528\u9762\u3067\u306e\u6ce8\u610f\u70b9<\/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\u76e3\u8996<\/li>\n\n\n\n<li>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u4fdd\u5b88<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u9069\u5207\u306a\u7ba1\u7406<\/li>\n<\/ul>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u6700\u9069\u5316\u624b\u6cd5\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u898f\u6a21\u3084\u8981\u4ef6\u306b\u5fdc\u3058\u3066\u9069\u5207\u306b\u9078\u629e\u3057\u3001\u7d44\u307f\u5408\u308f\u305b\u3066\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002\u307e\u305f\u3001\u5b9f\u88c5\u524d\u306b\u306f\u5fc5\u305a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c6\u30b9\u30c8\u3092\u884c\u3044\u3001\u52b9\u679c\u3092\u6e2c\u5b9a\u3059\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-16\">orderBy\u306e\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0<\/h2>\n\n\n\n<p>orderBy\u3092\u4f7f\u7528\u3059\u308b\u969b\u306b\u906d\u9047\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u4e00\u822c\u7684\u306a\u554f\u984c\u3068\u305d\u306e\u89e3\u6c7a\u65b9\u6cd5\u3001\u3055\u3089\u306b\u30c7\u30d0\u30c3\u30b0\u306e\u30c6\u30af\u30cb\u30c3\u30af\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-17\">\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u3068\u305d\u306e\u89e3\u6c7a\u65b9\u6cd5<\/h3>\n\n\n\n<p>\u958b\u767a\u4e2d\u306b\u3088\u304f\u906d\u9047\u3059\u308b\u30a8\u30e9\u30fc\u3068\u305d\u306e\u5bfe\u51e6\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Column not found \u30a8\u30e9\u30fc\u306e\u5bfe\u51e6<\/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\u306e\u4f8b\uff1a\n\/\/ SQLSTATE[42S22]: Column not found: 1054 Unknown column 'full_name' in 'order clause'\n\n\/\/ \u274c \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\n$users = User::orderBy('full_name')-&gt;get();\n\n\/\/ \u2705 \u6b63\u3057\u3044\u5b9f\u88c5\u65b9\u6cd5\n\/\/ \u65b9\u6cd51\uff1a\u5b9f\u969b\u306e\u30ab\u30e9\u30e0\u540d\u3092\u4f7f\u7528\n$users = User::orderBy('first_name')-&gt;get();\n\n\/\/ \u65b9\u6cd52\uff1aDB::raw\u3092\u4f7f\u7528\u3057\u3066\u7d50\u5408\u30d5\u30a3\u30fc\u30eb\u30c9\u3067\u30bd\u30fc\u30c8\n$users = User::orderBy(DB::raw(\"CONCAT(first_name, ' ', last_name)\"))-&gt;get();\n\n\/\/ \u65b9\u6cd53\uff1aselect\u3068orderBy\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\n$users = User::select('*')\n    -&gt;selectRaw(\"CONCAT(first_name, ' ', last_name) as full_name\")\n    -&gt;orderBy('full_name')\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30ab\u30e9\u30e0\u3067\u306e\u30bd\u30fc\u30c8\u30a8\u30e9\u30fc<\/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\u306e\u4f8b\uff1a\n\/\/ SQLSTATE[23000]: Integrity constraint violation\n\n\/\/ \u274c \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\n$posts = Post::with('author')-&gt;orderBy('author.name')-&gt;get();\n\n\/\/ \u2705 \u6b63\u3057\u3044\u5b9f\u88c5\u65b9\u6cd5\n\/\/ \u65b9\u6cd51\uff1ajoin\u3092\u4f7f\u7528\n$posts = Post::join('users as authors', 'posts.author_id', '=', 'authors.id')\n    -&gt;select('posts.*')\n    -&gt;orderBy('authors.name')\n    -&gt;get();\n\n\/\/ \u65b9\u6cd52\uff1a\u30b5\u30d6\u30af\u30a8\u30ea\u3092\u4f7f\u7528\n$posts = Post::select('posts.*')\n    -&gt;selectSub(\n        User::select('name')\n            -&gt;whereColumn('users.id', 'posts.author_id')\n            -&gt;limit(1),\n        'author_name'\n    )\n    -&gt;orderBy('author_name')\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>NULL\u5024\u306e\u6271\u3044\u306b\u95a2\u3059\u308b\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=\"\">\/\/ \u274c \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\uff1aNULL\u5024\u304c\u4e88\u671f\u3057\u306a\u3044\u4f4d\u7f6e\u306b\u8868\u793a\u3055\u308c\u308b\n$products = Product::orderBy('sale_ends_at')-&gt;get();\n\n\/\/ \u2705 \u6b63\u3057\u3044\u5b9f\u88c5\u65b9\u6cd5\n\/\/ \u65b9\u6cd51\uff1aCOALESCE\u95a2\u6570\u3092\u4f7f\u7528\n$products = Product::orderByRaw('COALESCE(sale_ends_at, NOW() + INTERVAL 100 YEAR)')-&gt;get();\n\n\/\/ \u65b9\u6cd52\uff1a\u8907\u6570\u6761\u4ef6\u3067\u306e\u4e26\u3073\u66ff\u3048\n$products = Product::orderByRaw('\n    CASE \n        WHEN sale_ends_at IS NULL THEN 1 \n        ELSE 0 \n    END'\n)-&gt;orderBy('sale_ends_at')-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-18\">\u30c7\u30d0\u30c3\u30b0\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6e2c\u5b9a\u306e\u624b\u6cd5<\/h3>\n\n\n\n<p>\u52b9\u679c\u7684\u306a\u30c7\u30d0\u30c3\u30b0\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6e2c\u5b9a\u306e\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30af\u30a8\u30ea\u30ed\u30b0\u306e\u78ba\u8a8d\u3068\u5206\u6790<\/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=\"\">\/\/ \u30af\u30a8\u30ea\u30ed\u30b0\u306e\u53d6\u5f97\nDB::enableQueryLog();\n\n$users = User::orderBy('created_at')-&gt;get();\n\n\/\/ \u30af\u30a8\u30ea\u30ed\u30b0\u306e\u51fa\u529b\nlogger()-&gt;debug('Query Log:', DB::getQueryLog());\n\n\/\/ \u30c7\u30d0\u30c3\u30b0\u30d0\u30fc\u3067\u306e\u78ba\u8a8d\u7528\u30d8\u30eb\u30d1\u30fc\u95a2\u6570\nif (!function_exists('dump_queries')) {\n    function dump_queries() {\n        $logs = DB::getQueryLog();\n        foreach ($logs as $log) {\n            $query = vsprintf(str_replace('?', \"'%s'\", $log['query']), $log['bindings']);\n            dump([\n                'query' =&gt; $query,\n                'time' =&gt; $log['time'].'ms'\n            ]);\n        }\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u5b9f\u884c\u8a08\u753b\u306e\u5206\u6790<\/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=\"\">\/\/ \u30af\u30a8\u30ea\u306e\u5b9f\u884c\u8a08\u753b\u3092\u78ba\u8a8d\u3059\u308b\u30d8\u30eb\u30d1\u30fc\u95a2\u6570\nclass QueryAnalyzer\n{\n    public static function explainQuery($query)\n    {\n        $sql = $query-&gt;toSql();\n        $bindings = $query-&gt;getBindings();\n\n        \/\/ \u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0\u306e\u9069\u7528\n        foreach ($bindings as $binding) {\n            $value = is_numeric($binding) ? $binding : \"'\".$binding.\"'\";\n            $sql = preg_replace('\/\\?\/', $value, $sql, 1);\n        }\n\n        \/\/ \u5b9f\u884c\u8a08\u753b\u306e\u53d6\u5f97\n        $explanation = DB::select('EXPLAIN ' . $sql);\n\n        return $explanation;\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\n$query = Product::orderBy('price')-&gt;where('category_id', 1);\n$explanation = QueryAnalyzer::explainQuery($query);\ndump($explanation);<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u30d9\u30f3\u30c1\u30de\u30fc\u30af<\/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=\"\">class PerformanceAnalyzer\n{\n    public static function measureQueryTime(callable $callback)\n    {\n        $start = microtime(true);\n\n        $result = $callback();\n\n        $end = microtime(true);\n        $executionTime = ($end - $start) * 1000; \/\/ \u30df\u30ea\u79d2\u306b\u5909\u63db\n\n        logger()-&gt;debug('Query Execution Time: ' . $executionTime . 'ms');\n\n        return $result;\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\n$result = PerformanceAnalyzer::measureQueryTime(function () {\n    return Product::orderBy('price')\n        -&gt;where('category_id', 1)\n        -&gt;get();\n});<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-19\">\u30c6\u30b9\u30c8\u30b3\u30fc\u30c9\u306e\u5b9f\u88c5\u30dd\u30a4\u30f3\u30c8<\/h3>\n\n\n\n<p>orderBy\u306e\u52d5\u4f5c\u3092\u78ba\u5b9f\u306b\u3059\u308b\u305f\u3081\u306e\u30c6\u30b9\u30c8\u5b9f\u88c5\u4f8b\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u57fa\u672c\u7684\u306a\u30bd\u30fc\u30c8\u306e\u30c6\u30b9\u30c8<\/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=\"\">class ProductSortTest extends TestCase\n{\n    public function test_products_can_be_sorted_by_price()\n    {\n        \/\/ \u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u306e\u4f5c\u6210\n        Product::factory()-&gt;create(['price' =&gt; 1000]);\n        Product::factory()-&gt;create(['price' =&gt; 500]);\n        Product::factory()-&gt;create(['price' =&gt; 2000]);\n\n        \/\/ \u6607\u9806\u30c6\u30b9\u30c8\n        $ascProducts = Product::orderBy('price')-&gt;pluck('price')-&gt;toArray();\n        $this-&gt;assertEquals([500, 1000, 2000], $ascProducts);\n\n        \/\/ \u964d\u9806\u30c6\u30b9\u30c8\n        $descProducts = Product::orderBy('price', 'desc')-&gt;pluck('price')-&gt;toArray();\n        $this-&gt;assertEquals([2000, 1000, 500], $descProducts);\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u8907\u96d1\u306a\u30bd\u30fc\u30c8\u6761\u4ef6\u306e\u30c6\u30b9\u30c8<\/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=\"\">class OrderSortTest extends TestCase\n{\n    public function test_orders_can_be_sorted_by_total_with_status_priority()\n    {\n        \/\/ \u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u4f5c\u6210\n        $orders = collect([\n            ['status' =&gt; 'pending', 'total' =&gt; 1000],\n            ['status' =&gt; 'completed', 'total' =&gt; 500],\n            ['status' =&gt; 'pending', 'total' =&gt; 2000],\n        ])-&gt;map(function ($data) {\n            return Order::factory()-&gt;create($data);\n        });\n\n        \/\/ \u30b9\u30c6\u30fc\u30bf\u30b9\u3068\u5408\u8a08\u91d1\u984d\u3067\u30bd\u30fc\u30c8\n        $sortedOrders = Order::orderByRaw(\"\n            CASE \n                WHEN status = 'completed' THEN 1\n                WHEN status = 'pending' THEN 2\n                ELSE 3 \n            END\"\n        )-&gt;orderBy('total', 'desc')\n        -&gt;get();\n\n        \/\/ \u30a2\u30b5\u30fc\u30b7\u30e7\u30f3\n        $this-&gt;assertEquals('completed', $sortedOrders[0]-&gt;status);\n        $this-&gt;assertEquals(2000, $sortedOrders[1]-&gt;total);\n    }\n}<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c6\u30b9\u30c8<\/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=\"\">class QueryPerformanceTest extends TestCase\n{\n    public function test_query_performance_within_acceptable_range()\n    {\n        \/\/ \u5927\u91cf\u306e\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u4f5c\u6210\n        Product::factory()-&gt;count(1000)-&gt;create();\n\n        $start = microtime(true);\n\n        \/\/ \u30c6\u30b9\u30c8\u5bfe\u8c61\u306e\u30af\u30a8\u30ea\u5b9f\u884c\n        $products = Product::with('category')\n            -&gt;orderBy('price')\n            -&gt;limit(20)\n            -&gt;get();\n\n        $executionTime = (microtime(true) - $start) * 1000;\n\n        \/\/ \u5b9f\u884c\u6642\u9593\u304c100ms\u4ee5\u5185\u3067\u3042\u308b\u3053\u3068\u3092\u78ba\u8a8d\n        $this-&gt;assertLessThan(\n            100,\n            $executionTime,\n            \"Query took {$executionTime}ms, which is longer than acceptable 100ms\"\n        );\n    }\n}<\/pre>\n\n\n\n<p>\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u306b\u304a\u3051\u308b\u91cd\u8981\u306a\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u6b63\u78ba\u306a\u7406\u89e3<\/li>\n\n\n\n<li>\u5b9f\u884c\u8a08\u753b\u306e\u5b9a\u671f\u7684\u306a\u78ba\u8a8d<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30c6\u30b9\u30c8\u30b1\u30fc\u30b9\u306e\u4f5c\u6210<\/li>\n\n\n\n<li>\u30c7\u30d0\u30c3\u30b0\u30c4\u30fc\u30eb\u306e\u52b9\u679c\u7684\u306a\u6d3b\u7528<\/li>\n<\/ol>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u554f\u984c\u306b\u906d\u9047\u3057\u305f\u969b\u306f\u3001\u307e\u305a\u57fa\u672c\u7684\u306a\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u3092\u78ba\u8a8d\u3057\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u4e0a\u8a18\u306e\u89e3\u6c7a\u7b56\u3092\u9069\u7528\u3059\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002\u307e\u305f\u3001\u958b\u767a\u74b0\u5883\u3067\u306f\u9069\u5207\u306a\u30c7\u30d0\u30c3\u30b0\u30c4\u30fc\u30eb\u3092\u5c0e\u5165\u3057\u3001\u65e9\u671f\u306b\u554f\u984c\u3092\u767a\u898b\u30fb\u89e3\u6c7a\u3067\u304d\u308b\u4f53\u5236\u3092\u6574\u3048\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-20\">\u5b9f\u88c5\u4f8b\u3067\u5b66\u3076\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u5225\u89e3\u6c7a\u65b9\u6cd5<\/h2>\n\n\n\n<p>\u5b9f\u969b\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u906d\u9047\u3059\u308b\u5177\u4f53\u7684\u306a\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u3068\u305d\u306e\u5b9f\u88c5\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002\u305d\u308c\u305e\u308c\u306e\u30b1\u30fc\u30b9\u3067\u3001\u5b9f\u8df5\u7684\u306a\u30b3\u30fc\u30c9\u4f8b\u3068\u5b9f\u88c5\u6642\u306e\u6ce8\u610f\u70b9\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-21\">EC\u30b5\u30a4\u30c8\u3067\u306e\u5546\u54c1\u4e00\u89a7\u306e\u4e26\u3073\u66ff\u3048\u5b9f\u88c5<\/h3>\n\n\n\n<p>EC\u30b5\u30a4\u30c8\u3067\u3088\u304f\u5fc5\u8981\u3068\u306a\u308b\u5546\u54c1\u4e00\u89a7\u306e\u4e26\u3073\u66ff\u3048\u6a5f\u80fd\u306e\u5b9f\u88c5\u4f8b\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u5546\u54c1\u4e00\u89a7\u306e\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u5b9f\u88c5<\/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=\"\">class ProductController extends Controller\n{\n    private const SORT_OPTIONS = [\n        'recommended' =&gt; ['featured', 'desc'],\n        'newest' =&gt; ['created_at', 'desc'],\n        'price_low' =&gt; ['price', 'asc'],\n        'price_high' =&gt; ['price', 'desc'],\n        'popular' =&gt; ['sales_count', 'desc'],\n    ];\n\n    public function index(Request $request)\n    {\n        $query = Product::query()\n            -&gt;with(['category', 'brand'])\n            -&gt;where('status', 'active');\n\n        \/\/ \u30ab\u30c6\u30b4\u30ea\u30fc\u30d5\u30a3\u30eb\u30bf\u30fc\n        if ($request-&gt;category_id) {\n            $query-&gt;where('category_id', $request-&gt;category_id);\n        }\n\n        \/\/ \u4fa1\u683c\u5e2f\u30d5\u30a3\u30eb\u30bf\u30fc\n        if ($request-&gt;price_range) {\n            [$min, $max] = explode('-', $request-&gt;price_range);\n            $query-&gt;whereBetween('price', [$min, $max]);\n        }\n\n        \/\/ \u5728\u5eab\u72b6\u6cc1\u306b\u3088\u308b\u4e26\u3073\u66ff\u3048\u512a\u5148\u5ea6\n        if ($request-&gt;in_stock_first) {\n            $query-&gt;orderByRaw('\n                CASE \n                    WHEN stock_quantity &gt; 0 THEN 1\n                    WHEN stock_quantity = 0 AND backorder_available = 1 THEN 2\n                    ELSE 3 \n                END\n            ');\n        }\n\n        \/\/ \u30e1\u30a4\u30f3\u306e\u4e26\u3073\u66ff\u3048\n        $sortKey = $request-&gt;input('sort', 'recommended');\n        if (isset(self::SORT_OPTIONS[$sortKey])) {\n            [$column, $direction] = self::SORT_OPTIONS[$sortKey];\n\n            if ($sortKey === 'popular') {\n                $query-&gt;withCount('orders')\n                      -&gt;orderBy('orders_count', $direction);\n            } else {\n                $query-&gt;orderBy($column, $direction);\n            }\n        }\n\n        $products = $query-&gt;paginate(24)\n            -&gt;withQueryString();\n\n        return view('products.index', [\n            'products' =&gt; $products,\n            'currentSort' =&gt; $sortKey,\n            'sortOptions' =&gt; array_keys(self::SORT_OPTIONS),\n        ]);\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Vue\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3067\u306e\u5b9f\u88c5<\/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=\"\">\/\/ ProductList.vue\n&lt;template&gt;\n    &lt;div class=\"product-list\"&gt;\n        &lt;div class=\"sort-controls\"&gt;\n            &lt;select v-model=\"sortBy\" @change=\"updateSort\"&gt;\n                &lt;option value=\"recommended\"&gt;\u304a\u3059\u3059\u3081\u9806&lt;\/option&gt;\n                &lt;option value=\"newest\"&gt;\u65b0\u7740\u9806&lt;\/option&gt;\n                &lt;option value=\"price_low\"&gt;\u4fa1\u683c\u304c\u5b89\u3044\u9806&lt;\/option&gt;\n                &lt;option value=\"price_high\"&gt;\u4fa1\u683c\u304c\u9ad8\u3044\u9806&lt;\/option&gt;\n                &lt;option value=\"popular\"&gt;\u4eba\u6c17\u9806&lt;\/option&gt;\n            &lt;\/select&gt;\n        &lt;\/div&gt;\n\n        &lt;div class=\"products-grid\"&gt;\n            &lt;product-card\n                v-for=\"product in products\"\n                :key=\"product.id\"\n                :product=\"product\"\n            \/&gt;\n        &lt;\/div&gt;\n\n        &lt;pagination :links=\"products.links\" \/&gt;\n    &lt;\/div&gt;\n&lt;\/template&gt;\n\n&lt;script&gt;\nexport default {\n    data() {\n        return {\n            products: [],\n            sortBy: 'recommended',\n            currentPage: 1\n        }\n    },\n\n    methods: {\n        async fetchProducts() {\n            const response = await axios.get('\/api\/products', {\n                params: {\n                    sort: this.sortBy,\n                    page: this.currentPage\n                }\n            });\n            this.products = response.data.data;\n        },\n\n        async updateSort(event) {\n            this.sortBy = event.target.value;\n            this.currentPage = 1;\n            await this.fetchProducts();\n\n            \/\/ URL\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u66f4\u65b0\n            const url = new URL(window.location);\n            url.searchParams.set('sort', this.sortBy);\n            window.history.pushState({}, '', url);\n        }\n    }\n}\n&lt;\/script&gt;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-22\">\u30d6\u30ed\u30b0\u8a18\u4e8b\u306e\u8907\u5408\u6761\u4ef6\u3067\u306e\u4e26\u3073\u66ff\u3048\u5b9f\u88c5<\/h3>\n\n\n\n<p>\u30d6\u30ed\u30b0\u30b7\u30b9\u30c6\u30e0\u3067\u306e\u8a18\u4e8b\u4e00\u89a7\u306e\u4e26\u3073\u66ff\u3048\u6a5f\u80fd\u3092\u5b9f\u88c5\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u8a18\u4e8b\u4e00\u89a7\u306e\u30ea\u30dd\u30b8\u30c8\u30ea\u30d1\u30bf\u30fc\u30f3\u5b9f\u88c5<\/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=\"\">class ArticleRepository\n{\n    public function getArticles(array $criteria = [])\n    {\n        $query = Article::query()\n            -&gt;with(['author', 'category', 'tags'])\n            -&gt;where('status', 'published');\n\n        \/\/ \u30ab\u30c6\u30b4\u30ea\u30fc\u30d5\u30a3\u30eb\u30bf\u30fc\n        if (isset($criteria['category_id'])) {\n            $query-&gt;where('category_id', $criteria['category_id']);\n        }\n\n        \/\/ \u30bf\u30b0\u30d5\u30a3\u30eb\u30bf\u30fc\n        if (isset($criteria['tag_id'])) {\n            $query-&gt;whereHas('tags', function ($query) use ($criteria) {\n                $query-&gt;where('tags.id', $criteria['tag_id']);\n            });\n        }\n\n        \/\/ \u4e26\u3073\u66ff\u3048\u6761\u4ef6\u306e\u9069\u7528\n        switch ($criteria['sort'] ?? 'latest') {\n            case 'popular':\n                $query-&gt;withCount('views')\n                      -&gt;orderBy('views_count', 'desc');\n                break;\n\n            case 'comments':\n                $query-&gt;withCount('comments')\n                      -&gt;orderBy('comments_count', 'desc');\n                break;\n\n            case 'trending':\n                \/\/ \u76f4\u8fd11\u9031\u9593\u306e\u30d3\u30e5\u30fc\u6570\u3067\u4e26\u3073\u66ff\u3048\n                $query-&gt;withCount(['views' =&gt; function ($query) {\n                    $query-&gt;where('created_at', '&gt;=', now()-&gt;subWeek());\n                }])\n                -&gt;orderBy('views_count', 'desc');\n                break;\n\n            default:\n                $query-&gt;latest();\n                break;\n        }\n\n        return $query-&gt;paginate(15);\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u3067\u306e\u4f7f\u7528\u4f8b<\/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=\"\">class BlogController extends Controller\n{\n    private $articleRepository;\n\n    public function __construct(ArticleRepository $articleRepository)\n    {\n        $this-&gt;articleRepository = $articleRepository;\n    }\n\n    public function index(Request $request)\n    {\n        $criteria = [\n            'category_id' =&gt; $request-&gt;category_id,\n            'tag_id' =&gt; $request-&gt;tag_id,\n            'sort' =&gt; $request-&gt;sort\n        ];\n\n        $articles = $this-&gt;articleRepository-&gt;getArticles($criteria);\n\n        return view('blog.index', compact('articles'));\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-23\">\u7ba1\u7406\u753b\u9762\u3067\u306e\u30c7\u30fc\u30bf\u30c6\u30fc\u30d6\u30eb\u5b9f\u88c5<\/h3>\n\n\n\n<p>\u7ba1\u7406\u753b\u9762\u3067\u306e\u5927\u91cf\u30c7\u30fc\u30bf\u306e\u8868\u793a\u3068\u4e26\u3073\u66ff\u3048\u6a5f\u80fd\u3092\u5b9f\u88c5\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Livewire\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3067\u306e\u5b9f\u88c5<\/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=\"\">class AdminOrdersTable extends Component\n{\n    public $sortField = 'created_at';\n    public $sortDirection = 'desc';\n    public $searchTerm = '';\n    public $perPage = 25;\n    public $selectedStatus = '';\n\n    protected $queryString = [\n        'sortField' =&gt; ['except' =&gt; 'created_at'],\n        'sortDirection' =&gt; ['except' =&gt; 'desc'],\n        'searchTerm' =&gt; ['except' =&gt; ''],\n        'selectedStatus' =&gt; ['except' =&gt; '']\n    ];\n\n    public function sortBy($field)\n    {\n        if ($this-&gt;sortField === $field) {\n            $this-&gt;sortDirection = $this-&gt;sortDirection === 'asc' ? 'desc' : 'asc';\n        } else {\n            $this-&gt;sortField = $field;\n            $this-&gt;sortDirection = 'asc';\n        }\n    }\n\n    public function render()\n    {\n        $orders = Order::query()\n            -&gt;with(['user', 'items'])\n            -&gt;when($this-&gt;searchTerm, function ($query) {\n                $query-&gt;where(function ($query) {\n                    $query-&gt;where('order_number', 'like', '%'.$this-&gt;searchTerm.'%')\n                          -&gt;orWhereHas('user', function ($query) {\n                              $query-&gt;where('name', 'like', '%'.$this-&gt;searchTerm.'%')\n                                   -&gt;orWhere('email', 'like', '%'.$this-&gt;searchTerm.'%');\n                          });\n                });\n            })\n            -&gt;when($this-&gt;selectedStatus, function ($query) {\n                $query-&gt;where('status', $this-&gt;selectedStatus);\n            })\n            -&gt;orderBy($this-&gt;sortField, $this-&gt;sortDirection)\n            -&gt;paginate($this-&gt;perPage);\n\n        return view('livewire.admin-orders-table', [\n            'orders' =&gt; $orders\n        ]);\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Blade \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u5b9f\u88c5<\/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=\"\">&lt;div&gt;\n    &lt;div class=\"mb-4 flex justify-between\"&gt;\n        &lt;div class=\"flex space-x-4\"&gt;\n            &lt;input type=\"text\" wire:model.debounce.300ms=\"searchTerm\" \n                   placeholder=\"\u691c\u7d22...\" class=\"form-input\"&gt;\n\n            &lt;select wire:model=\"selectedStatus\" class=\"form-select\"&gt;\n                &lt;option value=\"\"&gt;\u5168\u3066\u306e\u30b9\u30c6\u30fc\u30bf\u30b9&lt;\/option&gt;\n                &lt;option value=\"pending\"&gt;\u672a\u51e6\u7406&lt;\/option&gt;\n                &lt;option value=\"processing\"&gt;\u51e6\u7406\u4e2d&lt;\/option&gt;\n                &lt;option value=\"completed\"&gt;\u5b8c\u4e86&lt;\/option&gt;\n                &lt;option value=\"cancelled\"&gt;\u30ad\u30e3\u30f3\u30bb\u30eb&lt;\/option&gt;\n            &lt;\/select&gt;\n\n            &lt;select wire:model=\"perPage\" class=\"form-select\"&gt;\n                &lt;option value=\"25\"&gt;25\u4ef6&lt;\/option&gt;\n                &lt;option value=\"50\"&gt;50\u4ef6&lt;\/option&gt;\n                &lt;option value=\"100\"&gt;100\u4ef6&lt;\/option&gt;\n            &lt;\/select&gt;\n        &lt;\/div&gt;\n    &lt;\/div&gt;\n\n    &lt;table class=\"min-w-full\"&gt;\n        &lt;thead&gt;\n            &lt;tr&gt;\n                &lt;th wire:click=\"sortBy('order_number')\" class=\"cursor-pointer\"&gt;\n                    \u6ce8\u6587\u756a\u53f7\n                    @if ($sortField === 'order_number')\n                        @if ($sortDirection === 'asc')\n                            \u2191\n                        @else\n                            \u2193\n                        @endif\n                    @endif\n                &lt;\/th&gt;\n                &lt;!-- \u4ed6\u306e\u30d8\u30c3\u30c0\u30fc --&gt;\n            &lt;\/tr&gt;\n        &lt;\/thead&gt;\n        &lt;tbody&gt;\n            @foreach ($orders as $order)\n                &lt;tr&gt;\n                    &lt;td&gt;{{ $order-&gt;order_number }}&lt;\/td&gt;\n                    &lt;!-- \u4ed6\u306e\u30ab\u30e9\u30e0 --&gt;\n                &lt;\/tr&gt;\n            @endforeach\n        &lt;\/tbody&gt;\n    &lt;\/table&gt;\n\n    &lt;div class=\"mt-4\"&gt;\n        {{ $orders-&gt;links() }}\n    &lt;\/div&gt;\n&lt;\/div&gt;<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u5b9f\u88c5\u4f8b\u306f\u3001\u57fa\u672c\u7684\u306a\u30d1\u30bf\u30fc\u30f3\u3092\u30d9\u30fc\u30b9\u306b\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u8981\u4ef6\u306b\u5fdc\u3058\u3066\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3057\u3066\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u5b9f\u88c5\u6642\u306f\u4ee5\u4e0b\u306e\u70b9\u306b\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u8003\u616e<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u3092\u53d6\u5f97<\/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<ol class=\"wp-block-list\">\n<li><strong>\u30e6\u30fc\u30b6\u30d3\u30ea\u30c6\u30a3\u306e\u5411\u4e0a<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>URL\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u4fdd\u6301<\/li>\n\n\n\n<li>\u30bd\u30fc\u30c8\u72b6\u614b\u306e\u8996\u899a\u7684\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af<\/li>\n\n\n\n<li>\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\u72b6\u614b\u306e\u8868\u793a<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u4fdd\u5b88\u6027\u306e\u78ba\u4fdd<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5b9a\u6570\u3084\u30d8\u30eb\u30d1\u30fc\u95a2\u6570\u306e\u6d3b\u7528<\/li>\n\n\n\n<li>\u30b3\u30fc\u30c9\u306e\u518d\u5229\u7528\u6027<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30b3\u30e1\u30f3\u30c8\u306e\u8a18\u8ff0<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u8003\u616e<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5165\u529b\u5024\u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3<\/li>\n\n\n\n<li>\u8a8d\u53ef\u306e\u78ba\u8a8d<\/li>\n\n\n\n<li>SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56<\/li>\n<\/ul>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u5225\u306e\u5b9f\u88c5\u4f8b\u3092\u53c2\u8003\u306b\u3001\u5b9f\u969b\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u6700\u9069\u306a\u5b9f\u88c5\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\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-2691","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\/2691","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=2691"}],"version-history":[{"count":2,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/2691\/revisions"}],"predecessor-version":[{"id":2693,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/2691\/revisions\/2693"}],"wp:attachment":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}