By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
8.0.27 |
some_id | is_deleted | price |
---|---|---|
0 | 0 | 0 |
1 | 1 | 1 |
2 | 0 | 2 |
3 | 1 | 3 |
4 | 0 | 4 |
5 | 1 | 5 |
6 | 0 | 6 |
7 | 1 | 7 |
8 | 0 | 8 |
9 | 1 | 9 |
10 | 0 | 10 |
11 | 1 | 11 |
12 | 0 | 12 |
13 | 1 | 13 |
14 | 0 | 14 |
15 | 1 | 15 |
16 | 0 | 16 |
17 | 1 | 17 |
18 | 0 | 18 |
19 | 1 | 19 |
20 | 0 | 20 |
21 | 1 | 21 |
22 | 0 | 22 |
23 | 1 | 23 |
24 | 0 | 24 |
25 | 1 | 25 |
26 | 0 | 26 |
27 | 1 | 27 |
28 | 0 | 28 |
29 | 1 | 29 |
30 | 0 | 30 |
31 | 1 | 31 |
32 | 0 | 32 |
33 | 1 | 33 |
34 | 0 | 34 |
35 | 1 | 35 |
36 | 0 | 36 |
37 | 1 | 37 |
38 | 0 | 38 |
39 | 1 | 39 |
40 | 0 | 40 |
41 | 1 | 41 |
42 | 0 | 42 |
43 | 1 | 43 |
44 | 0 | 44 |
45 | 1 | 45 |
46 | 0 | 46 |
47 | 1 | 47 |
48 | 0 | 48 |
49 | 1 | 49 |
50 | 0 | 50 |
51 | 1 | 51 |
52 | 0 | 52 |
53 | 1 | 53 |
54 | 0 | 54 |
55 | 1 | 55 |
56 | 0 | 56 |
57 | 1 | 57 |
58 | 0 | 58 |
59 | 1 | 59 |
60 | 0 | 60 |
61 | 1 | 61 |
62 | 0 | 62 |
63 | 1 | 63 |
64 | 0 | 64 |
65 | 1 | 65 |
66 | 0 | 66 |
67 | 1 | 67 |
68 | 0 | 68 |
69 | 1 | 69 |
70 | 0 | 70 |
71 | 1 | 71 |
72 | 0 | 72 |
73 | 1 | 73 |
74 | 0 | 74 |
75 | 1 | 75 |
76 | 0 | 76 |
77 | 1 | 77 |
78 | 0 | 78 |
79 | 1 | 79 |
80 | 0 | 80 |
81 | 1 | 81 |
82 | 0 | 82 |
83 | 1 | 83 |
84 | 0 | 84 |
85 | 1 | 85 |
86 | 0 | 86 |
87 | 1 | 87 |
88 | 0 | 88 |
89 | 1 | 89 |
90 | 0 | 90 |
91 | 1 | 91 |
92 | 0 | 92 |
93 | 1 | 93 |
94 | 0 | 94 |
95 | 1 | 95 |
96 | 0 | 96 |
97 | 1 | 97 |
98 | 0 | 98 |
99 | 1 | 99 |
100 | 0 | 100 |
101 | 1 | 101 |
102 | 0 | 102 |
103 | 1 | 103 |
104 | 0 | 104 |
105 | 1 | 105 |
106 | 0 | 106 |
107 | 1 | 107 |
108 | 0 | 108 |
109 | 1 | 109 |
110 | 0 | 110 |
111 | 1 | 111 |
112 | 0 | 112 |
113 | 1 | 113 |
114 | 0 | 114 |
115 | 1 | 115 |
116 | 0 | 116 |
117 | 1 | 117 |
118 | 0 | 118 |
119 | 1 | 119 |
120 | 0 | 120 |
121 | 1 | 121 |
122 | 0 | 122 |
123 | 1 | 123 |
124 | 0 | 124 |
125 | 1 | 125 |
126 | 0 | 126 |
127 | 1 | 127 |
128 | 0 | 128 |
129 | 1 | 129 |
130 | 0 | 130 |
131 | 1 | 131 |
132 | 0 | 132 |
133 | 1 | 133 |
134 | 0 | 134 |
135 | 1 | 135 |
136 | 0 | 136 |
137 | 1 | 137 |
138 | 0 | 138 |
139 | 1 | 139 |
140 | 0 | 140 |
141 | 1 | 141 |
142 | 0 | 142 |
143 | 1 | 143 |
144 | 0 | 144 |
145 | 1 | 145 |
146 | 0 | 146 |
147 | 1 | 147 |
148 | 0 | 148 |
149 | 1 | 149 |
150 | 0 | 150 |
151 | 1 | 151 |
152 | 0 | 152 |
153 | 1 | 153 |
154 | 0 | 154 |
155 | 1 | 155 |
156 | 0 | 156 |
157 | 1 | 157 |
158 | 0 | 158 |
159 | 1 | 159 |
160 | 0 | 160 |
161 | 1 | 161 |
162 | 0 | 162 |
163 | 1 | 163 |
164 | 0 | 164 |
165 | 1 | 165 |
166 | 0 | 166 |
167 | 1 | 167 |
168 | 0 | 168 |
169 | 1 | 169 |
170 | 0 | 170 |
171 | 1 | 171 |
172 | 0 | 172 |
173 | 1 | 173 |
174 | 0 | 174 |
175 | 1 | 175 |
176 | 0 | 176 |
177 | 1 | 177 |
178 | 0 | 178 |
179 | 1 | 179 |
180 | 0 | 180 |
181 | 1 | 181 |
182 | 0 | 182 |
183 | 1 | 183 |
184 | 0 | 184 |
185 | 1 | 185 |
186 | 0 | 186 |
187 | 1 | 187 |
188 | 0 | 188 |
189 | 1 | 189 |
190 | 0 | 190 |
191 | 1 | 191 |
192 | 0 | 192 |
193 | 1 | 193 |
194 | 0 | 194 |
195 | 1 | 195 |
196 | 0 | 196 |
197 | 1 | 197 |
198 | 0 | 198 |
199 | 1 | 199 |
200 | 0 | 200 |
201 | 1 | 201 |
202 | 0 | 202 |
203 | 1 | 203 |
204 | 0 | 204 |
205 | 1 | 205 |
206 | 0 | 206 |
207 | 1 | 207 |
208 | 0 | 208 |
209 | 1 | 209 |
210 | 0 | 210 |
211 | 1 | 211 |
212 | 0 | 212 |
213 | 1 | 213 |
214 | 0 | 214 |
215 | 1 | 215 |
216 | 0 | 216 |
217 | 1 | 217 |
218 | 0 | 218 |
219 | 1 | 219 |
220 | 0 | 220 |
221 | 1 | 221 |
222 | 0 | 222 |
223 | 1 | 223 |
224 | 0 | 224 |
225 | 1 | 225 |
226 | 0 | 226 |
227 | 1 | 227 |
228 | 0 | 228 |
229 | 1 | 229 |
230 | 0 | 230 |
231 | 1 | 231 |
232 | 0 | 232 |
233 | 1 | 233 |
234 | 0 | 234 |
235 | 1 | 235 |
236 | 0 | 236 |
237 | 1 | 237 |
238 | 0 | 238 |
239 | 1 | 239 |
240 | 0 | 240 |
241 | 1 | 241 |
242 | 0 | 242 |
243 | 1 | 243 |
244 | 0 | 244 |
245 | 1 | 245 |
246 | 0 | 246 |
247 | 1 | 247 |
248 | 0 | 248 |
249 | 1 | 249 |
250 | 0 | 250 |
251 | 1 | 251 |
252 | 0 | 252 |
253 | 1 | 253 |
254 | 0 | 254 |
255 | 1 | 255 |
256 | 0 | 256 |
257 | 1 | 257 |
258 | 0 | 258 |
259 | 1 | 259 |
260 | 0 | 260 |
261 | 1 | 261 |
262 | 0 | 262 |
263 | 1 | 263 |
264 | 0 | 264 |
265 | 1 | 265 |
266 | 0 | 266 |
267 | 1 | 267 |
268 | 0 | 268 |
269 | 1 | 269 |
270 | 0 | 270 |
271 | 1 | 271 |
272 | 0 | 272 |
273 | 1 | 273 |
274 | 0 | 274 |
275 | 1 | 275 |
276 | 0 | 276 |
277 | 1 | 277 |
278 | 0 | 278 |
279 | 1 | 279 |
280 | 0 | 280 |
281 | 1 | 281 |
282 | 0 | 282 |
283 | 1 | 283 |
284 | 0 | 284 |
285 | 1 | 285 |
286 | 0 | 286 |
287 | 1 | 287 |
288 | 0 | 288 |
289 | 1 | 289 |
290 | 0 | 290 |
291 | 1 | 291 |
292 | 0 | 292 |
293 | 1 | 293 |
294 | 0 | 294 |
295 | 1 | 295 |
296 | 0 | 296 |
297 | 1 | 297 |
298 | 0 | 298 |
299 | 1 | 299 |
300 | 0 | 300 |
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | test | null | ALL | null | null | null | null | 301 | 33.33 | Using where |
EXPLAIN |
---|
-> Filter: (test.price < 10) (cost=30.35 rows=100) (actual time=0.014..0.386 rows=10 loops=1) -> Table scan on test (cost=30.35 rows=301) (actual time=0.013..0.323 rows=301 loops=1) |
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | test | null | range | one | one | 7 | null | 10 | 100.00 | Using index condition |
EXPLAIN |
---|
-> Index range scan on test using one, with index condition: ((test.is_deleted in (0,1)) and (test.price < 10)) (cost=5.01 rows=10) (actual time=0.030..0.067 rows=10 loops=1) |