{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "383.42"
},
"nested_loop": [
{
"table": {
"table_name": "p",
"access_type": "ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 268,
"rows_produced_per_join": 268,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "8.22",
"eval_cost": "53.60",
"prefix_cost": "61.82",
"data_read_per_join": "4K"
},
"used_columns": [
"company_id",
"category_id"
]
}
},
{
"table": {
"table_name": "c",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"portal.p.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 268,
"filtered": "100.00",
"cost_info": {
"read_cost": "268.00",
"eval_cost": "53.60",
"prefix_cost": "383.42",
"data_read_per_join": "707K"
},
"used_columns": [
"category_id",
"id_path"
]
}
}
]
}
}
id_path |
---|
6 |
12/13/14 |
12/13/15/35 |
12/13/38 |
12/13/38/42 |
12/13/44/46 |
12/13/44/47 |
12/13/44/48 |
12/50/51 |
12/50/51/60 |
6/7/61/63 |
6/7/61/64 |
12/50/68 |
12/50/77/79 |
12/50/77/82 |
12/13/38/83 |
12/50/84/88 |
12/50/84/89 |
12/604/91 |
12/95 |
12/95/96 |
12/95/97 |
12/95/98 |
12/604/91/99 |
2/144/100 |
2/144/100/113/116 |
2/144/100/117 |
2/10/136 |
2/144 |
2/144/145 |
6/7/147 |
6/7/147/148 |
6/7/147/151 |
6/7/147/153 |
6/7/147/154 |
6/159 |
6/159/160 |
6/159/164 |
6/159/166 |
6/159/167 |
6/168/179 |
6/168/180 |
6/168/183 |
6/184 |
6/184/185 |
6/184/186 |
6/184/187 |
6/184/189 |
190 |
190/191 |
190/192 |
190/193 |
190/194 |
190/195 |
190/196 |
190/197 |
190/199 |
190/200 |
190/201 |
190/202 |
190/204 |
190/206 |
207 |
207/217 |
207/221 |
207/224 |
207/225 |
207/241 |
207/242 |
2/245 |
248/249 |
248/249/250 |
248/249/251 |
248/249/252 |
248/249/253 |
248/249/254 |
248/249/255 |
248/249/256 |
248/257 |
248/257/258/260 |
248/257/258/263 |
248/257/264 |
248/273 |
248/273/274 |
248/273/277 |
248/278/289 |
248/278/290 |
12/13/44/46/294 |
12/13/44/46/296 |
12/13/44/46/298 |
299 |
300 |
301 |
248/302 |
248/302/303 |
248/302/303/315 |
248/302/330 |
6/360 |
248/361 |
248/361/362 |
248/361/364 |
6/367 |
6/367/368 |
6/367/369 |
6/367/370 |
6/367/371 |
300/375 |
300/376 |
300/377 |
207/379 |
299/382 |
299/383 |
299/383/384 |
299/385 |
190/386 |
299/389 |
248/393 |
248/395 |
2/144/400 |
299/401 |
299/383/402 |
6/406 |
300/410 |
299/412 |
299/412/413 |
190/191/418 |
190/191/419 |
190/420 |
299/421 |
299/422 |
190/424 |
6/425/426 |
190/428 |
190/429 |
299/431 |
248/249/433 |
248/249/434 |
248/249/434/435 |
248/249/255/436 |
6/438 |
6/438/439/442 |
6/438/443 |
6/438/443/444 |
6/445 |
6/445/446 |
6/445/446/450 |
6/438/454 |
6/438/454/455 |
248/249/459 |
6/438/460 |
6/184/465 |
6/184/465/467 |
6/184/465/468 |
207/469 |
207/469/470 |
207/469/470/473 |
248/249/484 |
248/249/253/489 |
299/422/493 |
6/159/495 |
248/249/250/496 |
248/249/250/497 |
248/249/250/498 |
248/249/250/499 |
248/249/254/508 |
248/249/254/509 |
299/383/512 |
207/513 |
207/513/514 |
207/513/515 |
207/513/516 |
2/11/523 |
6/168/529 |
6/519/530 |
6/168/531 |
248/249/253/532 |
248/249/533 |
248/249/535 |
6/184/536/539 |
190/543 |
248/544 |
248/544/545 |
248/544/546 |
248/544/548 |
299/550 |
190/551 |
299/552 |
299/554 |
12/555 |
190/556 |
299/557 |
6/184/558 |
299/559 |
299/383/560 |
299/383/561 |
299/383/562 |
6/159/563 |
12/555/564 |
299/412/565 |
248/566 |
248/569 |
6/159/570 |
6/406/571 |
300/572 |
300/573 |
299/401/576 |
2/578/577 |
2/578 |
248/249/579 |
207/580 |
300/581 |
12/582 |
2/144/100/583 |
6/7/147/584 |
2/144/585 |
2/10/135/586 |
6/438/587 |
2/589/592 |
2/589/593 |
6/596 |
12/95/597 |
248/598 |
300/375/602 |
300/606 |