質問編集履歴
2
クエリの修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -16,7 +16,6 @@
|
|
|
16
16
|
WHERE a.b_id = X
|
|
17
17
|
AND a.c_id = Y
|
|
18
18
|
AND a.name LIKE '%??%'
|
|
19
|
-
ORDER BY a.id
|
|
20
19
|
|
|
21
20
|
[レコード取得]
|
|
22
21
|
SELECT a.*, b.name, c.name FROM A AS a
|
|
@@ -40,7 +39,6 @@
|
|
|
40
39
|
) AS a
|
|
41
40
|
INNER JOIN B AS b ON a.b_id = b.id
|
|
42
41
|
INNER JOIN C AS c ON a.c_id = c.id
|
|
43
|
-
ORDER BY a.id
|
|
44
42
|
|
|
45
43
|
[レコード取得]
|
|
46
44
|
SELECT a.*, b.name, c.name FROM
|
1
クエリの修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -11,8 +11,8 @@
|
|
|
11
11
|
【①のクエリ(改修前)】
|
|
12
12
|
[レコード件数取得]
|
|
13
13
|
SELECT COUNT(a.id) FROM A AS a
|
|
14
|
-
INNER JOIN b ON a.b_id = b.id
|
|
14
|
+
INNER JOIN B AS b ON a.b_id = b.id
|
|
15
|
-
INNER JOIN c ON a.c_id = c.id
|
|
15
|
+
INNER JOIN C AS c ON a.c_id = c.id
|
|
16
16
|
WHERE a.b_id = X
|
|
17
17
|
AND a.c_id = Y
|
|
18
18
|
AND a.name LIKE '%??%'
|
|
@@ -20,8 +20,8 @@
|
|
|
20
20
|
|
|
21
21
|
[レコード取得]
|
|
22
22
|
SELECT a.*, b.name, c.name FROM A AS a
|
|
23
|
-
INNER JOIN b ON a.b_id = b.id
|
|
23
|
+
INNER JOIN B AS b ON a.b_id = b.id
|
|
24
|
-
INNER JOIN c ON a.c_id = c.id
|
|
24
|
+
INNER JOIN C AS c ON a.c_id = c.id
|
|
25
25
|
WHERE a.b_id = X
|
|
26
26
|
AND a.c_id = Y
|
|
27
27
|
AND a.name LIKE '%??%'
|
|
@@ -38,8 +38,8 @@
|
|
|
38
38
|
AND child.c_id = Y
|
|
39
39
|
AND child.name LIKE '%??%'
|
|
40
40
|
) AS a
|
|
41
|
-
INNER JOIN b ON a.b_id = b.id
|
|
41
|
+
INNER JOIN B AS b ON a.b_id = b.id
|
|
42
|
-
INNER JOIN c ON a.c_id = c.id
|
|
42
|
+
INNER JOIN C AS c ON a.c_id = c.id
|
|
43
43
|
ORDER BY a.id
|
|
44
44
|
|
|
45
45
|
[レコード取得]
|
|
@@ -50,8 +50,8 @@
|
|
|
50
50
|
AND child.c_id = Y
|
|
51
51
|
AND child.name LIKE '%??%'
|
|
52
52
|
) AS a
|
|
53
|
-
INNER JOIN b ON a.b_id = b.id
|
|
53
|
+
INNER JOIN B AS b ON a.b_id = b.id
|
|
54
|
-
INNER JOIN c ON a.c_id = c.id
|
|
54
|
+
INNER JOIN C AS c ON a.c_id = c.id
|
|
55
55
|
ORDER BY a.id LIMIT 10
|
|
56
56
|
```
|
|
57
57
|
※Aのテーブルは20万件程
|