1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
|
table type possible_keys key key_len ref rows Extra
t1 ref a a 5 const 3 where used; Using index
table type possible_keys key key_len ref rows Extra
t1 ref a,b a 9 const,const 1 where used; Using index
table type possible_keys key key_len ref rows Extra
t1 ref a,b a 9 const,const 1 where used; Using index
table type possible_keys key key_len ref rows Extra
t1 const a,b a 9 const,const 1
table type possible_keys key key_len ref rows Extra
t1 index NULL a 9 NULL 12 where used; Using index
table type possible_keys key key_len ref rows Extra
t1 range a,b a 9 NULL 3 where used; Using index
table type possible_keys key key_len ref rows Extra
t1 ref a,b b 4 const 2 where used
table type possible_keys key key_len ref rows Extra
t1 ref a,b a 5 const 3 where used; Using index
table type possible_keys key key_len ref rows Extra
t1 range a,b a 9 NULL 2 where used; Using index
table type possible_keys key key_len ref rows Extra
t1 range a a 5 NULL 1 where used; Using index
table type possible_keys key key_len ref rows Extra
t1 range a a 5 NULL 1 where used; Using index
a b
NULL 7
NULL 9
NULL 9
a b
NULL 7
a b
1 1
2 2
a b
1 1
2 2
a b
NULL 9
NULL 9
a b
NULL 7
7 7
a b
NULL 7
NULL 9
NULL 9
table type possible_keys key key_len ref rows Extra
t1 ref a,b a 5 const 3 where used
table type possible_keys key key_len ref rows Extra
t1 ref a,b a 5 const 3 where used
table type possible_keys key key_len ref rows Extra
t1 ref a,b a 5 const 3 where used
table type possible_keys key key_len ref rows Extra
t1 ref a,b a 5 const 1 where used
table type possible_keys key key_len ref rows Extra
t1 ALL NULL NULL NULL NULL 12 where used
table type possible_keys key key_len ref rows Extra
t1 range a,b a 5 NULL 12 where used
table type possible_keys key key_len ref rows Extra
t1 range a,b a 5 NULL 4 where used
table type possible_keys key key_len ref rows Extra
t1 ref a,b a 5 const 3 where used
table type possible_keys key key_len ref rows Extra
t1 ref a,b a 5 const 3 where used
table type possible_keys key key_len ref rows Extra
t1 range a a 5 NULL 1 where used
table type possible_keys key key_len ref rows Extra
t1 range a,b a 5 NULL 4 where used
table type possible_keys key key_len ref rows Extra
t1 range a a 5 NULL 1 where used
table type possible_keys key key_len ref rows Extra
t1 range b b 12 NULL 1 where used
a b c
NULL 7 0
NULL 9 0
NULL 9 0
a b c
NULL 7 0
a b c
1 1 0
2 2 0
a b c
1 1 0
2 2 0
a b c
NULL 9 0
NULL 9 0
a b c
NULL 7 0
7 7 0
a b c
NULL 7 0
NULL 9 0
NULL 9 0
a b c
6 6 0
table type possible_keys key key_len ref rows Extra
t1 ref idx1 idx1 5 const 1 where used
table type possible_keys key key_len ref rows Extra
t1 const idx1 idx1 5 const 1
id
101
102
105
106
109
110
id
101
102
105
106
109
110
id uniq_id
3 1
4 2
7 3
8 4
id uniq_id
3 1
4 2
7 3
8 4
order_id product_id product_type
order_id product_id product_type
3d7ce39b5d4b3e3d22aaafe9b633de51 1206029 3
3d7ce39b5d4b3e3d22aaafe9b633de51 5880836 3
id id
id id
id id2
NULL 0
1 1
id id2
NULL 0
id id2
NULL 0
1 1
id id2
NULL 0
1 1
id id2
1 1
id id2
1 1
id id2
1 1
|
