{"id":3270,"date":"2025-03-24T08:46:33","date_gmt":"2025-03-23T23:46:33","guid":{"rendered":"https:\/\/dexall.co.jp\/articles\/?p=3270"},"modified":"2025-03-24T08:47:04","modified_gmt":"2025-03-23T23:47:04","slug":"%e3%80%90laravel%e3%80%91wherein%e3%83%a1%e3%82%bd%e3%83%83%e3%83%89%e3%81%ae%e5%ae%9f%e8%b7%b5%e7%9a%84%e3%81%aa%e4%bd%bf%e3%81%84%e6%96%b9%e3%81%a85%e3%81%a4%e3%81%ae%e6%9c%80%e9%81%a9%e5%8c%96","status":"publish","type":"post","link":"https:\/\/dexall.co.jp\/articles\/?p=3270","title":{"rendered":"\u3010Laravel\u3011whereIn\u30e1\u30bd\u30c3\u30c9\u306e\u5b9f\u8df5\u7684\u306a\u4f7f\u3044\u65b9\u30685\u3064\u306e\u6700\u9069\u5316\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\">whereIn\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u672c\u6982\u5ff5<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-1\">whereIn\u30e1\u30bd\u30c3\u30c9\u3068\u306f\u4f55\u304b\uff1f\u5177\u4f53\u4f8b\u3067\u7406\u89e3\u3057\u307e\u3059<\/a>      <\/li>      <li>        <a href=\"#i-2\">whereIn\u3068where\u306e\u9055\u3044\u3092\u7406\u89e3\u3057\u3088\u3046<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-3\">whereIn\u304c\u7279\u306b\u52b9\u679c\u3092\u767a\u63ee\u3059\u308b\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-4\">whereIn\u30e1\u30bd\u30c3\u30c9\u306e\u5b9f\u8df5\u7684\u306a\u4f7f\u3044\u65b9<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-5\">\u914d\u5217\u3092\u4f7f\u3063\u305f\u57fa\u672c\u7684\u306a\u5b9f\u88c5\u306e\u4f5c\u6210<\/a>      <\/li>      <li>        <a href=\"#i-6\">\u30b5\u30d6\u30af\u30a8\u30ea\u3067whereIn\u3092\u6d3b\u7528\u3059\u308b\u65b9\u6cd5<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-7\">\u8907\u6570\u30ab\u30e9\u30e0\u306b\u5bfe\u3059\u308bwhereIn\u306e\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-8\">whereIn\u30e1\u30bd\u30c3\u30c9\u3067\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-9\">\u5927\u91cf\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306e\u30c1\u30e3\u30f3\u30af\u5206\u5272\u30c6\u30af\u30cb\u30c3\u30af<\/a>      <\/li>      <li>        <a href=\"#i-10\">\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u6d3b\u7528\u3057\u305f\u691c\u7d22\u901f\u5ea6\u306e\u5411\u4e0a<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-11\">N+1\u554f\u984c\u306e\u89e3\u6c7a\u306bwhereIn\u3092\u6d3b\u7528\u3059\u308b<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-12\">whereIn\u306e\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-13\">whereIn\u3068whereNotIn\u306e\u7d44\u307f\u5408\u308f\u305b\u6d3b\u7528\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-14\">Eloquent\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306ewhereIn\u6d3b\u7528\u4f8b<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-15\">\u8907\u96d1\u306a\u6761\u4ef6\u5206\u5c90\u3067\u306ewhereIn\u6d3b\u7528\u8853<\/a>      <\/li>    <\/ul>  <\/li>  <li class=\"last\">    <a href=\"#i-16\">whereIn\u30e1\u30bd\u30c3\u30c9\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\u5b9f\u88c5\u30df\u30b9\u3068\u89e3\u6c7a\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-18\">\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u51e6\u7406\u6642\u306e\u6ce8\u610f\u70b9<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-19\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u4f4e\u4e0b\u6642\u306e\u30c7\u30d0\u30c3\u30b0\u624b\u9806<\/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\">whereIn\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u672c\u6982\u5ff5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-1\">whereIn\u30e1\u30bd\u30c3\u30c9\u3068\u306f\u4f55\u304b\uff1f\u5177\u4f53\u4f8b\u3067\u7406\u89e3\u3057\u307e\u3059<\/h3>\n\n\n\n<p>whereIn\u30e1\u30bd\u30c3\u30c9\u306f\u3001Laravel\u306e\u958b\u767a\u8005\u306b\u3068\u3063\u3066\u5fc5\u8981\u4e0d\u53ef\u6b20\u306a\u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u306e\u30e1\u30bd\u30c3\u30c9\u3067\u3059\u3002\u3053\u306e\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u6307\u5b9a\u3057\u305f\u30ab\u30e9\u30e0\u306e\u5024\u304c\u914d\u5217\u5185\u306e\u5024\u306e\u3044\u305a\u308c\u304b\u306b\u4e00\u81f4\u3059\u308b\u30ec\u30b3\u30fc\u30c9\u3092\u52b9\u7387\u7684\u306b\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u57fa\u672c\u7684\u306a\u69cb\u6587\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\n$users = DB::table('users')\n    -&gt;whereIn('id', [1, 2, 3, 4, 5])\n    -&gt;get();\n\n\/\/ Eloquent\u30e2\u30c7\u30eb\u3067\u306e\u4f7f\u7528\u4f8b\n$posts = Post::whereIn('status', ['published', 'draft'])\n    -&gt;get();<\/pre>\n\n\n\n<p>\u3053\u306e\u30e1\u30bd\u30c3\u30c9\u304c\u7279\u306b\u5a01\u529b\u3092\u767a\u63ee\u3059\u308b\u306e\u306f\u3001\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u304b\u3089\u7279\u5b9a\u306e\u6761\u4ef6\u306b\u5408\u81f4\u3059\u308b\u30ec\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3059\u308b\u5834\u5408\u3067\u3059\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5074\u3067\u6700\u9069\u5316\u3055\u308c\u305f\u5b9f\u884c\u8a08\u753b\u304c\u7acb\u3066\u3089\u308c\u308b\u305f\u3081\u3001\u500b\u5225\u306ewhere\u30af\u30a8\u30ea\u3092\u9023\u7d50\u3059\u308b\u3088\u308a\u3082\u52b9\u7387\u7684\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-2\">whereIn\u3068where\u306e\u9055\u3044\u3092\u7406\u89e3\u3057\u3088\u3046<\/h3>\n\n\n\n<p>whereIn\u3068where\u30e1\u30bd\u30c3\u30c9\u306e\u4e3b\u306a\u9055\u3044\u306f\u3001\u4ee5\u4e0b\u306e\u8868\u3067\u660e\u78ba\u306b\u793a\u3055\u308c\u307e\u3059\uff1a<\/p>\n\n\n<div id=\"id-d842ba9a-5eb3-47ff-bcc6-5b14fd113db6\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u6a5f\u80fd<\/th><th>whereIn<\/th><th>where<\/th><\/tr><\/thead><tbody><tr><td>\u8907\u6570\u5024\u306e\u6bd4\u8f03<\/td><td>\u5358\u4e00\u306e\u30af\u30a8\u30ea\u3067\u5b9f\u884c\u53ef\u80fd<\/td><td>OR\u6761\u4ef6\u306e\u9023\u7d50\u304c\u5fc5\u8981<\/td><\/tr><tr><td>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9<\/td><td>\u5927\u91cf\u30c7\u30fc\u30bf\u306b\u52b9\u679c\u7684<\/td><td>\u5c11\u91cf\u30c7\u30fc\u30bf\u306a\u3089\u554f\u984c\u306a\u3057<\/td><\/tr><tr><td>SQL\u751f\u6210<\/td><td>IN\u53e5\u3092\u4f7f\u7528<\/td><td>=\u6f14\u7b97\u5b50\u3092\u4f7f\u7528<\/td><\/tr><tr><td>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf<\/td><td>\u914d\u5217\u306e\u30b5\u30a4\u30ba\u306b\u4f9d\u5b58<\/td><td>\u6bd4\u8f03\u7684\u5c11\u306a\u3044<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<p>\u4ee5\u4e0b\u306f\u3001\u540c\u3058\u7d50\u679c\u3092\u5f97\u308b\u305f\u3081\u306e\u4e21\u30e1\u30bd\u30c3\u30c9\u306e\u5b9f\u88c5\u4f8b\u3067\u3059\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ whereIn\u3092\u4f7f\u7528\u3057\u305f\u5834\u5408\n$users = User::whereIn('id', [1, 2, 3])\n    -&gt;get();\n\n\/\/ where\u3092\u4f7f\u7528\u3057\u305f\u5834\u5408\n$users = User::where('id', '=', 1)\n    -&gt;orWhere('id', '=', 2)\n    -&gt;orWhere('id', '=', 3)\n    -&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-3\">whereIn\u304c\u7279\u306b\u52b9\u679c\u3092\u767a\u63ee\u3059\u308b\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/h3>\n\n\n\n<p>whereIn\u30e1\u30bd\u30c3\u30c9\u304c\u7279\u306b\u52b9\u679c\u3092\u767a\u63ee\u3059\u308b\u4ee3\u8868\u7684\u306a\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u8907\u6570\u306eID\u306b\u3088\u308b\u30ec\u30b3\u30fc\u30c9\u53d6\u5f97<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u7279\u5b9a\u306e\u90e8\u9580\u306b\u6240\u5c5e\u3059\u308b\u30e6\u30fc\u30b6\u30fc\u3092\u4e00\u62ec\u53d6\u5f97\n$users = User::whereIn('department_id', $departmentIds)\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30b9\u30c6\u30fc\u30bf\u30b9\u30d9\u30fc\u30b9\u306e\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8907\u6570\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u306b\u8a72\u5f53\u3059\u308b\u6ce8\u6587\u3092\u53d6\u5f97\n$orders = Order::whereIn('status', ['pending', 'processing', 'shipped'])\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u95a2\u9023\u30c7\u30fc\u30bf\u306e\u52b9\u7387\u7684\u306a\u53d6\u5f97<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u7279\u5b9a\u306e\u30ab\u30c6\u30b4\u30ea\u30fc\u306b\u5c5e\u3059\u308b\u5546\u54c1\u3092\u53d6\u5f97\n$products = Product::whereIn('category_id', $selectedCategories)\n    -&gt;with('category')  \/\/ Eager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\n    -&gt;get();<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u3067\u306f\u3001whereIn\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30b3\u30fc\u30c9\u306e\u53ef\u8aad\u6027\u304c\u5411\u4e0a\u3057\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3082\u6700\u9069\u5316\u3055\u308c\u307e\u3059\u3002\u7279\u306b\u3001\u5927\u898f\u6a21\u306a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u6271\u3046\u5834\u5408\u3084\u3001\u8907\u6570\u306e\u6761\u4ef6\u3067\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3092\u884c\u3046\u5834\u5408\u306b\u3001\u305d\u306e\u771f\u4fa1\u3092\u767a\u63ee\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-4\">whereIn\u30e1\u30bd\u30c3\u30c9\u306e\u5b9f\u8df5\u7684\u306a\u4f7f\u3044\u65b9<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-5\">\u914d\u5217\u3092\u4f7f\u3063\u305f\u57fa\u672c\u7684\u306a\u5b9f\u88c5\u306e\u4f5c\u6210<\/h3>\n\n\n\n<p>whereIn\u30e1\u30bd\u30c3\u30c9\u3092\u52b9\u679c\u7684\u306b\u6d3b\u7528\u3059\u308b\u306b\u306f\u3001\u5165\u529b\u30c7\u30fc\u30bf\u306e\u9069\u5207\u306a\u6e96\u5099\u3068\u51e6\u7406\u304c\u91cd\u8981\u3067\u3059\u3002\u4ee5\u4e0b\u306b\u3001\u5b9f\u8df5\u7684\u306a\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u3092\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u914d\u5217\u306e\u6e96\u5099\u3068\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=\"\">class ProductController extends Controller\n{\n    public function filterByCategories(Request $request)\n    {\n        \/\/ \u5165\u529b\u5024\u306e\u691c\u8a3c\n        $validated = $request-&gt;validate([\n            'categories' =&gt; 'required|array',\n            'categories.*' =&gt; 'exists:categories,id'\n        ]);\n\n        \/\/ whereIn\u3092\u4f7f\u7528\u3057\u305f\u5b9f\u88c5\n        $products = Product::whereIn('category_id', $validated['categories'])\n            -&gt;with('category')  \/\/ Eager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\n            -&gt;paginate(20);\n\n        return response()-&gt;json($products);\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3068whereIn\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=\"\">\/\/ \u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u304b\u3089ID\u3092\u62bd\u51fa\u3057\u3066 whereIn \u3067\u4f7f\u7528\n$activeUsers = User::query()\n    -&gt;whereIn('id', collect($usersList)-&gt;pluck('id'))\n    -&gt;where('status', 'active')\n    -&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-6\">\u30b5\u30d6\u30af\u30a8\u30ea\u3067whereIn\u3092\u6d3b\u7528\u3059\u308b\u65b9\u6cd5<\/h3>\n\n\n\n<p>\u30b5\u30d6\u30af\u30a8\u30ea\u3068whereIn\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u8907\u96d1\u306a\u6761\u4ef6\u3067\u306e\u691c\u7d22\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30b5\u30d6\u30af\u30a8\u30ea\u3092\u4f7f\u7528\u3057\u305f\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=\"\">\/\/ \u6700\u8fd1\u8cfc\u5165\u304c\u3042\u3063\u305f\u9867\u5ba2\u3092\u53d6\u5f97\n$recentCustomers = Customer::whereIn('id', function($query) {\n    $query-&gt;select('customer_id')\n        -&gt;from('orders')\n        -&gt;where('created_at', '&gt;=', now()-&gt;subDays(30))\n        -&gt;distinct();\n})-&gt;get();\n\n\/\/ \u7279\u5b9a\u306e\u6761\u4ef6\u306b\u57fa\u3065\u304f\u30b5\u30d6\u30af\u30a8\u30ea\n$highValueProducts = Product::whereIn('category_id', function($query) {\n    $query-&gt;select('id')\n        -&gt;from('categories')\n        -&gt;where('average_price', '&gt;', 10000)\n        -&gt;whereNull('deleted_at');\n})-&gt;with('category')-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30af\u30ed\u30fc\u30b8\u30e3\u3092\u4f7f\u7528\u3057\u305f\u52d5\u7684\u306a\u30b5\u30d6\u30af\u30a8\u30ea<\/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=\"\">public function getActiveProjectMembers($projectId)\n{\n    return User::whereIn('id', function($query) use ($projectId) {\n        $query-&gt;select('user_id')\n            -&gt;from('project_members')\n            -&gt;where('project_id', $projectId)\n            -&gt;where('status', 'active');\n    })-&gt;get();\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-7\">\u8907\u6570\u30ab\u30e9\u30e0\u306b\u5bfe\u3059\u308bwhereIn\u306e\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af<\/h3>\n\n\n\n<p>\u8907\u6570\u306e\u30ab\u30e9\u30e0\u3092\u7d44\u307f\u5408\u308f\u305b\u305fwhereIn\u691c\u7d22\u3082\u53ef\u80fd\u3067\u3059\u3002\u4ee5\u4e0b\u306b\u3001\u3044\u304f\u3064\u304b\u306e\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u3092\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u8907\u5408\u6761\u4ef6\u3067\u306ewhereIn\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\u6570\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3068\u90e8\u9580\u306e\u7d44\u307f\u5408\u308f\u305b\n$employees = Employee::whereIn('department_id', $departments)\n    -&gt;whereIn('status', ['active', 'on_leave'])\n    -&gt;get();\n\n\/\/ whereIn\u3068where\u6761\u4ef6\u306e\u7d44\u307f\u5408\u308f\u305b\n$products = Product::whereIn('category_id', $categories)\n    -&gt;whereIn('brand_id', $brands)\n    -&gt;where('price', '&gt;', 1000)\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>whereIn\u3068Has\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=\"\">\/\/ \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30c7\u30fc\u30bf\u3082\u542b\u3081\u305f\u691c\u7d22\n$posts = Post::whereIn('category_id', $categoryIds)\n    -&gt;whereHas('tags', function($query) use ($tagIds) {\n        $query-&gt;whereIn('tags.id', $tagIds);\n    })\n    -&gt;with(['category', 'tags'])\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u52d5\u7684\u306a\u6761\u4ef6\u69cb\u7bc9<\/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 ProductRepository\n{\n    public function findByFilters(array $filters)\n    {\n        $query = Product::query();\n\n        \/\/ \u30ab\u30c6\u30b4\u30ea\u30fc\u30d5\u30a3\u30eb\u30bf\u30fc\n        if (!empty($filters['categories'])) {\n            $query-&gt;whereIn('category_id', $filters['categories']);\n        }\n\n        \/\/ \u30d6\u30e9\u30f3\u30c9\u30d5\u30a3\u30eb\u30bf\u30fc\n        if (!empty($filters['brands'])) {\n            $query-&gt;whereIn('brand_id', $filters['brands']);\n        }\n\n        \/\/ \u30b9\u30c6\u30fc\u30bf\u30b9\u30d5\u30a3\u30eb\u30bf\u30fc\n        if (!empty($filters['statuses'])) {\n            $query-&gt;whereIn('status', $filters['statuses']);\n        }\n\n        return $query-&gt;with(['category', 'brand'])\n            -&gt;orderBy('created_at', 'desc')\n            -&gt;paginate(20);\n    }\n}<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u306f\u3001\u5b9f\u969b\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u3088\u304f\u906d\u9047\u3059\u308b\u8981\u4ef6\u306b\u5bfe\u5fdc\u3067\u304d\u308b\u3088\u3046\u8a2d\u8a08\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u307e\u305f\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u4fdd\u5b88\u6027\u3092\u8003\u616e\u3057\u305f\u5b9f\u88c5\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u5b9f\u52d9\u3067\u306e\u6d3b\u7528\u306b\u9069\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-8\">whereIn\u30e1\u30bd\u30c3\u30c9\u3067\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-9\">\u5927\u91cf\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306e\u30c1\u30e3\u30f3\u30af\u5206\u5272\u30c6\u30af\u30cb\u30c3\u30af<\/h3>\n\n\n\n<p>\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u51e6\u7406\u3059\u308b\u969b\u3001\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3068\u5b9f\u884c\u6642\u9593\u3092\u6700\u9069\u5316\u3059\u308b\u305f\u3081\u306b\u30c1\u30e3\u30f3\u30af\u5206\u5272\u304c\u52b9\u679c\u7684\u3067\u3059\u3002\u4ee5\u4e0b\u306b\u3001\u5b9f\u8df5\u7684\u306a\u5b9f\u88c5\u65b9\u6cd5\u3092\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u57fa\u672c\u7684\u306a\u30c1\u30e3\u30f3\u30af\u51e6\u7406\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 UserDataProcessor\n{\n    const CHUNK_SIZE = 1000;\n\n    public function processLargeUserList(array $userIds)\n    {\n        \/\/ \u914d\u5217\u3092\u30c1\u30e3\u30f3\u30af\u306b\u5206\u5272\n        $userIdChunks = array_chunk($userIds, self::CHUNK_SIZE);\n\n        foreach ($userIdChunks as $chunk) {\n            \/\/ \u30c1\u30e3\u30f3\u30af\u3054\u3068\u306bwhereIn\u51e6\u7406\n            $users = User::whereIn('id', $chunk)\n                -&gt;with('profile')  \/\/ \u5fc5\u8981\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u307fEager\u30ed\u30fc\u30c9\n                -&gt;get();\n\n            \/\/ \u30c1\u30e3\u30f3\u30af\u3054\u3068\u306e\u51e6\u7406\n            $this-&gt;processUserChunk($users);\n        }\n    }\n\n    private function processUserChunk(Collection $users)\n    {\n        \/\/ \u30e1\u30e2\u30ea\u52b9\u7387\u3092\u8003\u616e\u3057\u305f\u51e6\u7406\n        foreach ($users as $user) {\n            \/\/ \u5404\u30e6\u30fc\u30b6\u30fc\u306e\u51e6\u7406\n            event(new UserProcessed($user));\n        }\n\n        \/\/ \u30e1\u30e2\u30ea\u89e3\u653e\n        unset($users);\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u975e\u540c\u671f\u51e6\u7406\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u6700\u9069\u5316<\/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 LargeDataProcessor\n{\n    public function processInBackground(array $ids)\n    {\n        $chunks = array_chunk($ids, 500);\n\n        foreach ($chunks as $index =&gt; $chunk) {\n            \/\/ \u30b8\u30e7\u30d6\u3092\u30ad\u30e5\u30fc\u306b\u6295\u5165\n            ProcessDataChunk::dispatch($chunk)\n                -&gt;delay(now()-&gt;addSeconds($index * 5));  \/\/ \u5b9f\u884c\u9593\u9694\u3092\u8a2d\u5b9a\n        }\n    }\n}\n\nclass ProcessDataChunk implements ShouldQueue\n{\n    public function handle()\n    {\n        $results = Product::whereIn('id', $this-&gt;chunk)\n            -&gt;select(['id', 'name', 'price'])  \/\/ \u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u9078\u629e\n            -&gt;get();\n\n        \/\/ \u30c1\u30e3\u30f3\u30af\u30c7\u30fc\u30bf\u306e\u51e6\u7406\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-10\">\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u6d3b\u7528\u3057\u305f\u691c\u7d22\u901f\u5ea6\u306e\u5411\u4e0a<\/h3>\n\n\n\n<p>whereIn\u30e1\u30bd\u30c3\u30c9\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306f\u3001\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08\u306b\u5927\u304d\u304f\u4f9d\u5b58\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u52b9\u679c\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\nclass CreateProductsTable extends Migration\n{\n    public function up()\n    {\n        Schema::create('products', function (Blueprint $table) {\n            $table-&gt;id();\n            $table-&gt;foreignId('category_id');\n            $table-&gt;foreignId('brand_id');\n            $table-&gt;string('status');\n\n            \/\/ \u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u4f5c\u6210\n            $table-&gt;index(['category_id', 'brand_id', 'status']);\n            \/\/ \u983b\u7e41\u306b\u4f7f\u7528\u3055\u308c\u308b\u5358\u4e00\u30ab\u30e9\u30e0\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\n            $table-&gt;index('status');\n        });\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30af\u30a8\u30ea\u30a2\u30ca\u30e9\u30a4\u30b6\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=\"\">\/\/ \u30af\u30a8\u30ea\u306e\u5b9f\u884c\u8a08\u753b\u3092\u78ba\u8a8d\nDB::enableQueryLog();\n\n$products = Product::whereIn('category_id', $categories)\n    -&gt;whereIn('status', ['active', 'draft'])\n    -&gt;get();\n\n\/\/ \u30af\u30a8\u30ea\u30ed\u30b0\u306e\u5206\u6790\n$queries = DB::getQueryLog();\ndump($queries);  \/\/ \u958b\u767a\u74b0\u5883\u3067\u306e\u307f\u4f7f\u7528<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-11\">N+1\u554f\u984c\u306e\u89e3\u6c7a\u306bwhereIn\u3092\u6d3b\u7528\u3059\u308b<\/h3>\n\n\n\n<p>N+1\u554f\u984c\u306f\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u5927\u304d\u306a\u5f71\u97ff\u3092\u4e0e\u3048\u308b\u4e00\u822c\u7684\u306a\u554f\u984c\u3067\u3059\u3002whereIn\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u52b9\u679c\u7684\u306b\u89e3\u6c7a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>N+1\u554f\u984c\u306e\u691c\u51fa\u3068\u89e3\u6c7a<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\n$orders = Order::all();\nforeach ($orders as $order) {\n    $customer = $order-&gt;customer;  \/\/ \u8ffd\u52a0\u30af\u30a8\u30ea\u304c\u767a\u751f\n}\n\n\/\/ whereIn\u3092\u4f7f\u7528\u3057\u305f\u89e3\u6c7a\u7b56\n$orders = Order::with('customer')-&gt;get();  \/\/ Eager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\n\n\/\/ \u3055\u3089\u306b\u6761\u4ef6\u3092\u8ffd\u52a0\u3059\u308b\u5834\u5408\n$orders = Order::with(['customer' =&gt; function($query) {\n    $query-&gt;whereIn('status', ['active', 'vip']);\n}])-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>has\/whereHas\u3068\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=\"\">\/\/ \u7279\u5b9a\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3059\u95a2\u9023\u30c7\u30fc\u30bf\u3092\u6301\u3064\u30ec\u30b3\u30fc\u30c9\u306e\u53d6\u5f97\n$posts = Post::whereHas('comments', function($query) {\n    $query-&gt;whereIn('status', ['approved', 'featured']);\n})\n-&gt;with(['comments' =&gt; function($query) {\n    $query-&gt;whereIn('status', ['approved', 'featured']);\n}])\n-&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class QueryMonitoringMiddleware\n{\n    public function handle($request, Closure $next)\n    {\n        \/\/ \u30af\u30a8\u30ea\u306e\u76e3\u8996\u958b\u59cb\n        DB::enableQueryLog();\n\n        $response = $next($request);\n\n        \/\/ \u5b9f\u884c\u3055\u308c\u305f\u30af\u30a8\u30ea\u306e\u5206\u6790\n        $queries = DB::getQueryLog();\n\n        if (count($queries) &gt; 10) {  \/\/ \u30af\u30a8\u30ea\u6570\u306e\u95be\u5024\n            Log::warning('\u591a\u6570\u306e\u30af\u30a8\u30ea\u304c\u5b9f\u884c\u3055\u308c\u3066\u3044\u307e\u3059', [\n                'query_count' =&gt; count($queries),\n                'route' =&gt; $request-&gt;route()-&gt;getName()\n            ]);\n        }\n\n        return $response;\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\u3001whereIn\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u305f\u51e6\u7406\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\u7279\u306b\u5927\u898f\u6a21\u306a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u6271\u3046\u5834\u5408\u306f\u3001\u3053\u308c\u3089\u306e\u6700\u9069\u5316\u304c\u91cd\u8981\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-12\">whereIn\u306e\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-13\">whereIn\u3068whereNotIn\u306e\u7d44\u307f\u5408\u308f\u305b\u6d3b\u7528\u6cd5<\/h3>\n\n\n\n<p>whereIn\u3068whereNotIn\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u67d4\u8edf\u306a\u30c7\u30fc\u30bf\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u76f8\u4e92\u6392\u4ed6\u7684\u306a\u30c7\u30fc\u30bf\u306e\u53d6\u5f97<\/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 ProductService\n{\n    public function getAvailableProducts(array $excludedCategories)\n    {\n        return Product::whereIn('status', ['active', 'pre_order'])\n            -&gt;whereNotIn('category_id', $excludedCategories)\n            -&gt;where('stock', '&gt;', 0)\n            -&gt;get();\n    }\n\n    public function getFilteredUsers(array $includeDepartments, array $excludeRoles)\n    {\n        return User::whereIn('department_id', $includeDepartments)\n            -&gt;whereNotIn('role', $excludeRoles)\n            -&gt;where('status', 'active')\n            -&gt;get();\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30b5\u30d6\u30af\u30a8\u30ea\u3092\u4f7f\u7528\u3057\u305f\u9ad8\u5ea6\u306a\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class OrderAnalytics\n{\n    public function getUnusualOrders()\n    {\n        \/\/ \u901a\u5e38\u306e\u6ce8\u6587\u91d1\u984d\u7bc4\u56f2\u3092\u53d6\u5f97\n        $normalPriceRanges = OrderStatistics::select('price_range_id')\n            -&gt;where('is_common', true)\n            -&gt;pluck('price_range_id');\n\n        \/\/ \u901a\u5e38\u7bc4\u56f2\u5916\u306e\u6ce8\u6587\u3092\u53d6\u5f97\n        return Order::whereNotIn('price_range_id', $normalPriceRanges)\n            -&gt;whereIn('status', ['completed', 'processing'])\n            -&gt;with(['customer', 'items'])\n            -&gt;get();\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-14\">Eloquent\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306ewhereIn\u6d3b\u7528\u4f8b<\/h3>\n\n\n\n<p>Eloquent\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3068\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u8907\u96d1\u306a\u30c7\u30fc\u30bf\u69cb\u9020\u3082\u52b9\u7387\u7684\u306b\u6271\u3048\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>HasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\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 Category extends Model\n{\n    public function getActiveProductsInPriceRanges($priceRanges)\n    {\n        return $this-&gt;hasMany(Product::class)\n            -&gt;whereIn('price_range', $priceRanges)\n            -&gt;where('status', 'active')\n            -&gt;with(['tags', 'reviews' =&gt; function($query) {\n                $query-&gt;whereIn('rating', [4, 5]);\n            }]);\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>BelongsToMany\u3067\u306e\u9ad8\u5ea6\u306a\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 Project extends Model\n{\n    public function getActiveTeamMembers($skillsets)\n    {\n        return $this-&gt;belongsToMany(User::class, 'project_members')\n            -&gt;whereIn('skill_level', ['senior', 'expert'])\n            -&gt;whereHas('skills', function($query) use ($skillsets) {\n                $query-&gt;whereIn('name', $skillsets);\n            })\n            -&gt;withPivot(['role', 'joined_at'])\n            -&gt;orderBy('project_members.joined_at', 'desc');\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-15\">\u8907\u96d1\u306a\u6761\u4ef6\u5206\u5c90\u3067\u306ewhereIn\u6d3b\u7528\u8853<\/h3>\n\n\n\n<p>\u8907\u96d1\u306a\u696d\u52d9\u30ed\u30b8\u30c3\u30af\u3092\u30af\u30ea\u30fc\u30f3\u306b\u5b9f\u88c5\u3059\u308b\u305f\u3081\u306e\u30d1\u30bf\u30fc\u30f3\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u30fc\u30d1\u30bf\u30fc\u30f3\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 UserQueryBuilder\n{\n    protected $query;\n\n    public function __construct()\n    {\n        $this-&gt;query = User::query();\n    }\n\n    public function withDepartments(array $departments)\n    {\n        if (!empty($departments)) {\n            $this-&gt;query-&gt;whereIn('department_id', $departments);\n        }\n        return $this;\n    }\n\n    public function withRoles(array $roles)\n    {\n        if (!empty($roles)) {\n            $this-&gt;query-&gt;whereIn('role', $roles);\n        }\n        return $this;\n    }\n\n    public function excludeStatuses(array $statuses)\n    {\n        if (!empty($statuses)) {\n            $this-&gt;query-&gt;whereNotIn('status', $statuses);\n        }\n        return $this;\n    }\n\n    public function build()\n    {\n        return $this-&gt;query;\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\nclass UserController extends Controller\n{\n    public function index(Request $request)\n    {\n        $queryBuilder = new UserQueryBuilder();\n\n        $users = $queryBuilder\n            -&gt;withDepartments($request-&gt;input('departments', []))\n            -&gt;withRoles($request-&gt;input('roles', []))\n            -&gt;excludeStatuses(['inactive', 'blocked'])\n            -&gt;build()\n            -&gt;paginate(20);\n\n        return response()-&gt;json($users);\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30b5\u30fc\u30d3\u30b9\u30ec\u30a4\u30e4\u30fc\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 ProductFilterService\n{\n    private function applyBusinessRules(Builder $query, array $filters)\n    {\n        \/\/ \u30ab\u30c6\u30b4\u30ea\u30fc\u30d5\u30a3\u30eb\u30bf\u30fc\n        if (!empty($filters['categories'])) {\n            $query-&gt;whereIn('category_id', $this-&gt;validateCategories($filters['categories']));\n        }\n\n        \/\/ \u5728\u5eab\u72b6\u614b\u30d5\u30a3\u30eb\u30bf\u30fc\n        if (!empty($filters['stock_status'])) {\n            $this-&gt;applyStockFilter($query, $filters['stock_status']);\n        }\n\n        \/\/ \u4fa1\u683c\u5e2f\u30d5\u30a3\u30eb\u30bf\u30fc\n        if (!empty($filters['price_ranges'])) {\n            $this-&gt;applyPriceRangeFilter($query, $filters['price_ranges']);\n        }\n\n        return $query;\n    }\n\n    private function applyStockFilter(Builder $query, array $stockStatus)\n    {\n        $statusMap = [\n            'in_stock' =&gt; function($q) {\n                $q-&gt;where('stock', '&gt;', 0);\n            },\n            'low_stock' =&gt; function($q) {\n                $q-&gt;whereBetween('stock', [1, 5]);\n            },\n            'out_of_stock' =&gt; function($q) {\n                $q-&gt;where('stock', 0);\n            }\n        ];\n\n        $query-&gt;where(function($q) use ($stockStatus, $statusMap) {\n            foreach ($stockStatus as $status) {\n                if (isset($statusMap[$status])) {\n                    $q-&gt;orWhere(function($subQ) use ($status, $statusMap) {\n                        $statusMap[$status]($subQ);\n                    });\n                }\n            }\n        });\n    }\n}<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af\u306f\u3001\u5b9f\u969b\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u906d\u9047\u3059\u308b\u8907\u96d1\u306a\u8981\u4ef6\u306b\u5bfe\u5fdc\u3059\u308b\u305f\u3081\u306e\u5b9f\u8df5\u7684\u306a\u30d1\u30bf\u30fc\u30f3\u3067\u3059\u3002\u30b3\u30fc\u30c9\u306e\u4fdd\u5b88\u6027\u3068\u518d\u5229\u7528\u6027\u3092\u8003\u616e\u3057\u305f\u8a2d\u8a08\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-16\">whereIn\u30e1\u30bd\u30c3\u30c9\u306e\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-17\">\u3088\u304f\u3042\u308b\u5b9f\u88c5\u30df\u30b9\u3068\u89e3\u6c7a\u65b9\u6cd5<\/h3>\n\n\n\n<p>whereIn\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3059\u308b\u969b\u306b\u3088\u304f\u906d\u9047\u3059\u308b\u554f\u984c\u3068\u305d\u306e\u89e3\u6c7a\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u7a7a\u914d\u5217\u306b\u3088\u308b\u610f\u56f3\u3057\u306a\u3044\u7d50\u679c<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\npublic function getProducts(array $categoryIds = [])\n{\n    \/\/ \u7a7a\u914d\u5217\u306e\u5834\u5408\u3001\u5168\u3066\u306e\u30ec\u30b3\u30fc\u30c9\u304c\u8fd4\u3055\u308c\u308b\n    return Product::whereIn('category_id', $categoryIds)-&gt;get();\n}\n\n\/\/ \u6539\u5584\u3055\u308c\u305f\u30b3\u30fc\u30c9\npublic function getProducts(array $categoryIds = [])\n{\n    if (empty($categoryIds)) {\n        return collect([]);  \/\/ \u7a7a\u306e\u7d50\u679c\u3092\u8fd4\u3059\n    }\n\n    return Product::whereIn('category_id', $categoryIds)-&gt;get();\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u578b\u306e\u4e0d\u4e00\u81f4\u306b\u3088\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=\"\">\/\/ \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\uff1a\u6587\u5b57\u5217\u3068\u6570\u5024\u306e\u6df7\u5728\n$ids = ['1', 2, '3', 4];  \/\/ \u6df7\u5728\u3057\u305f\u578b\n\n\/\/ \u6539\u5584\u3055\u308c\u305f\u30b3\u30fc\u30c9\nclass ProductRepository\n{\n    public function findByIds(array $ids)\n    {\n        \/\/ \u578b\u306e\u7d71\u4e00\n        $normalizedIds = array_map('intval', $ids);\n\n        return Product::whereIn('id', $normalizedIds)\n            -&gt;get();\n    }\n}<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>NULL\u5024\u306e\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=\"\">\/\/ \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\n$statuses = collect($request-&gt;input('statuses'))\n    -&gt;filter()  \/\/ null\u304c\u9664\u5916\u3055\u308c\u306a\u3044\n    -&gt;toArray();\n\n\/\/ \u6539\u5584\u3055\u308c\u305f\u30b3\u30fc\u30c9\n$statuses = collect($request-&gt;input('statuses'))\n    -&gt;filter(function ($value) {\n        return $value !== null &amp;&amp; $value !== '';\n    })\n    -&gt;toArray();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-18\">\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u51e6\u7406\u6642\u306e\u6ce8\u610f\u70b9<\/h3>\n\n\n\n<p>\u5927\u898f\u6a21\u306a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u51e6\u7406\u3059\u308b\u969b\u306e\u91cd\u8981\u306a\u6ce8\u610f\u70b9\u3068\u5bfe\u7b56\u3092\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u76e3\u8996\u3068\u5236\u5fa1<\/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 LargeDataProcessor\n{\n    private const CHUNK_SIZE = 1000;\n    private const MEMORY_LIMIT = 128 * 1024 * 1024; \/\/ 128MB\n\n    public function processLargeDataset(array $ids)\n    {\n        \/\/ \u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u76e3\u8996\n        $initialMemory = memory_get_usage();\n\n        foreach (array_chunk($ids, self::CHUNK_SIZE) as $chunk) {\n            $currentMemory = memory_get_usage();\n\n            if (($currentMemory - $initialMemory) &gt; self::MEMORY_LIMIT) {\n                Log::warning('\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u304c\u95be\u5024\u3092\u8d85\u3048\u3066\u3044\u307e\u3059', [\n                    'memory_usage' =&gt; $currentMemory,\n                    'chunk_size' =&gt; self::CHUNK_SIZE\n                ]);\n\n                \/\/ \u30ac\u30d9\u30fc\u30b8\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u5f37\u5236\u5b9f\u884c\n                gc_collect_cycles();\n            }\n\n            $this-&gt;processChunk($chunk);\n        }\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\u5bfe\u7b56<\/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 BatchProcessor\n{\n    public function processBatch(array $ids)\n    {\n        \/\/ \u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c\u6642\u9593\u3092\u8a2d\u5b9a\n        set_time_limit(300);  \/\/ 5\u5206\n\n        try {\n            DB::transaction(function () use ($ids) {\n                foreach (array_chunk($ids, 500) as $chunk) {\n                    \/\/ \u975e\u540c\u671f\u30b8\u30e7\u30d6\u3068\u3057\u3066\u5b9f\u884c\n                    ProcessChunkJob::dispatch($chunk)\n                        -&gt;onQueue('batch-processing');\n                }\n            });\n        } catch (\\Exception $e) {\n            Log::error('\u30d0\u30c3\u30c1\u51e6\u7406\u3067\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f', [\n                'error' =&gt; $e-&gt;getMessage(),\n                'ids_count' =&gt; count($ids)\n            ]);\n            throw $e;\n        }\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-19\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u4f4e\u4e0b\u6642\u306e\u30c7\u30d0\u30c3\u30b0\u624b\u9806<\/h3>\n\n\n\n<p>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u554f\u984c\u304c\u767a\u751f\u3057\u305f\u969b\u306e\u4f53\u7cfb\u7684\u306a\u30c7\u30d0\u30c3\u30b0\u624b\u9806\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30af\u30a8\u30ea\u30ed\u30b0\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=\"\">class QueryDebugger\n{\n    public static function analyzeQuery(Closure $callback)\n    {\n        DB::enableQueryLog();\n\n        $startTime = microtime(true);\n        $result = $callback();\n        $endTime = microtime(true);\n\n        $queries = DB::getQueryLog();\n        $executionTime = ($endTime - $startTime) * 1000;\n\n        self::logQueryAnalysis($queries, $executionTime);\n\n        return $result;\n    }\n\n    private static function logQueryAnalysis(array $queries, float $executionTime)\n    {\n        foreach ($queries as $query) {\n            Log::debug('\u30af\u30a8\u30ea\u5206\u6790', [\n                'sql' =&gt; $query['query'],\n                'bindings' =&gt; $query['bindings'],\n                'time' =&gt; $query['time']\n            ]);\n        }\n\n        Log::debug('\u5b9f\u884c\u6642\u9593\u5206\u6790', [\n            'total_queries' =&gt; count($queries),\n            'total_time' =&gt; $executionTime . 'ms'\n        ]);\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\nQueryDebugger::analyzeQuery(function () use ($categoryIds) {\n    return Product::whereIn('category_id', $categoryIds)\n        -&gt;with('category')\n        -&gt;get();\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=\"\">class QueryOptimizer\n{\n    public static function analyzeQueryPlan($query)\n    {\n        $explainResults = DB::select('EXPLAIN ' . $query-&gt;toSql(), $query-&gt;getBindings());\n\n        return collect($explainResults)-&gt;map(function ($result) {\n            return [\n                'id' =&gt; $result-&gt;id,\n                'select_type' =&gt; $result-&gt;select_type,\n                'table' =&gt; $result-&gt;table,\n                'type' =&gt; $result-&gt;type,\n                'possible_keys' =&gt; $result-&gt;possible_keys,\n                'key' =&gt; $result-&gt;key,\n                'rows' =&gt; $result-&gt;rows,\n                'filtered' =&gt; $result-&gt;filtered,\n                'Extra' =&gt; $result-&gt;Extra,\n            ];\n        });\n    }\n}<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u624b\u6cd5\u3092\u9069\u5207\u306b\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001whereIn\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3059\u308b\u969b\u306e\u554f\u984c\u3092\u52b9\u679c\u7684\u306b\u7279\u5b9a\u3057\u3001\u89e3\u6c7a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u7279\u306b\u5927\u898f\u6a21\u306a\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u306f\u3001\u3053\u308c\u3089\u306e\u30c7\u30d0\u30c3\u30b0\u624b\u6cd5\u304c\u91cd\u8981\u306b\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-3270","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\/3270","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=3270"}],"version-history":[{"count":2,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/3270\/revisions"}],"predecessor-version":[{"id":3272,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/3270\/revisions\/3272"}],"wp:attachment":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}