{
"query_block": {
"select_id": 1,
"table": {
"table_name": "b",
"access_type": "const",
"possible_keys": ["PRIMARY", "p_category_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["category_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "a",
"access_type": "index",
"key": "id_path",
"key_length": "767",
"used_key_parts": ["id_path"],
"rows": 539,
"filtered": 100,
"attached_condition": "a.id_path like <cache>(concat('3','/%'))",
"using_index": true
}
}
}
category_id |
---|
16 |
143 |
144 |
145 |
146 |
147 |
552 |
148 |
149 |
150 |
151 |
152 |
153 |
558 |
154 |
155 |
156 |
157 |
17 |
158 |
159 |
160 |
161 |
162 |
163 |
164 |
18 |
165 |
166 |
167 |
572 |
573 |
168 |
169 |
170 |
171 |
172 |
173 |
174 |
175 |
176 |
177 |
178 |
179 |
180 |
19 |
20 |
181 |
182 |
183 |
184 |
185 |
186 |
187 |
21 |
188 |
189 |
22 |
190 |
191 |
192 |
193 |