質問編集履歴
2
explain追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -92,6 +92,6 @@
|
|
|
92
92
|
|
|
93
93
|
id select_type table type possible_keys key key_len ref rows Extra
|
|
94
94
|
|
|
95
|
-
1 SIMPLE main ALL idx_t_main_up_date
|
|
95
|
+
1 SIMPLE main ALL idx_t_main_up_date 399394 Using where
|
|
96
96
|
|
|
97
97
|
1 SIMPLE sub eq_ref PRIMARY PRIMARY 71 _id 1 Using where
|
1
explain追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -85,3 +85,13 @@
|
|
|
85
85
|
欲しい結果
|
|
86
86
|
|
|
87
87
|
111,222
|
|
88
|
+
|
|
89
|
+
|
|
90
|
+
|
|
91
|
+
explain追加
|
|
92
|
+
|
|
93
|
+
id select_type table type possible_keys key key_len ref rows Extra
|
|
94
|
+
|
|
95
|
+
1 SIMPLE main ALL idx_t_main_up_date 189394 Using where
|
|
96
|
+
|
|
97
|
+
1 SIMPLE sub eq_ref PRIMARY PRIMARY 71 _id 1 Using where
|