{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "374.85"
},
"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": 262,
"rows_produced_per_join": 262,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "8.05",
"eval_cost": "52.40",
"prefix_cost": "60.45",
"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": 262,
"filtered": "100.00",
"cost_info": {
"read_cost": "262.00",
"eval_cost": "52.40",
"prefix_cost": "374.85",
"data_read_per_join": "691K"
},
"used_columns": [
"category_id",
"id_path"
]
}
}
]
}
}
id_path |
---|
2 |
6 |
12/13/14 |
12/13/14/16 |
12/13/14/17 |
12/13/14/18 |
12/13/14/23 |
12/13/14/25 |
12/13/14/27 |
12/13/15/37 |
12/13/38 |
12/13/38/40 |
12/13/38/41 |
12/13/38/42 |
12/13/44 |
12/13/44/46 |
12/13/44/49 |
12/50/51/58 |
6/7/61/63 |
6/7/61/64 |
12/50/68 |
12/50/68/71 |
12/50/68/74 |
12/50/68/76 |
12/50/77 |
12/50/77/79 |
12/50/77/82 |
12/50/84 |
12/50/84/87 |
12/50/84/88 |
12/50/84/90 |
12/604/91 |
12/604/91/92 |
12/604/91/93 |
12/604/91/94 |
12/95 |
12/95/96 |
12/95/97 |
2/144/100/106/111 |
2/144/100/113 |
2/144/100/113/115 |
2/144/100/124 |
2/10/134 |
2/10/136 |
2/138/139 |
2/138/141 |
6/7/147/148 |
6/7/147/150 |
6/7/147/151 |
6/7/147/152 |
6/7/147/153 |
6/7/147/154 |
6/159 |
6/159/160 |
6/159/163 |
6/159/166 |
6/159/167 |
6/168 |
6/168/169 |
6/168/172 |
6/168/176 |
6/168/177 |
6/168/179 |
6/168/180 |
6/168/183 |
6/184 |
6/184/185 |
6/184/186 |
6/184/187 |
6/168/188 |
6/184/189 |
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/220 |
207/221 |
207/233 |
207/234 |
207/241 |
207/243 |
6/168/244 |
248/249 |
248/249/250 |
248/249/251 |
248/249/252 |
248/249/254 |
248/249/255 |
248/249/256 |
248/257/258/261 |
248/257/264/266 |
248/257/264/269 |
248/249/271 |
248/273/274 |
248/273/275 |
248/273/276 |
248/273/277 |
248/278/290 |
12/13/44/46/293 |
12/13/44/46/294 |
12/13/44/46/296 |
12/13/44/46/297 |
12/13/44/46/298 |
299 |
301 |
248/302/303/308/313 |
248/302/303/323/329 |
248/302/330/352/356 |
6/360 |
248/361/362 |
248/361/364 |
6/367 |
6/367/368 |
6/367/369 |
6/367/370 |
6/367/371 |
300/375 |
6/184/378 |
207/379 |
299/383 |
299/383/384 |
299/385 |
190/386 |
299/388 |
299/389 |
248/361/391 |
299/401 |
299/383/402 |
300/410 |
299/412 |
299/412/413 |
299/412/414 |
299/412/417 |
190/191/418 |
190/191/419 |
190/420 |
299/422 |
190/424 |
6/425 |
6/425/426 |
190/428 |
190/429 |
300/430 |
299/431 |
2/432 |
248/249/434/435 |
248/249/255/436 |
299/412/437 |
6/438 |
6/438/439/442 |
6/438/443 |
6/445 |
6/445/446 |
6/445/446/448 |
6/445/446/450 |
6/438/454 |
6/438/454/455 |
248/249/459 |
6/438/460/462 |
6/184/465 |
6/184/465/466 |
207/469 |
207/469/470/471 |
207/469/470/473 |
207/469/470/475 |
6/438/476/477 |
6/438/476/478 |
6/168/481 |
248/249/253/489 |
299/422/493 |
6/159/495 |
248/249/250/498 |
248/249/250/499 |
248/249/254/507 |
248/249/254/509 |
299/383/512 |
207/513 |
207/513/516 |
6/168/518 |
6/519 |
6/519/520 |
2/11/523 |
2/11/523/526 |
2/11/523/527 |
6/168/529 |
248/249/253/532 |
248/249/533 |
248/249/535 |
6/184/536/537 |
6/184/536/539 |
6/184/536/540 |
248/544 |
248/544/545 |
248/544/546 |
248/544/547 |
2/144/549 |
299/550 |
190/551 |
12/555 |
190/556 |
299/557 |
6/184/558 |
299/559 |
299/383/560 |
299/383/561 |
6/159/563 |
12/555/564 |
299/412/565 |
248/566 |
6/406/567 |
6/406/568 |
6/159/570 |
300/572 |
299/401/576 |
2/578/577 |
248/249/579 |
300/581 |
12/582 |
6/7/147/584 |
2/144/585 |
2/10/135/586 |
6/438/587 |
6/596 |
12/95/597 |
248/598 |
12/50/84/601 |
300/375/602 |
603 |
300/606 |