{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "45.50"
},
"nested_loop": [
{
"table": {
"table_name": "gp",
"access_type": "ref",
"possible_keys": [
"idx_group_id"
],
"key": "idx_group_id",
"used_key_parts": [
"group_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 65,
"rows_produced_per_join": 65,
"filtered": "100.00",
"cost_info": {
"read_cost": "16.25",
"eval_cost": "6.50",
"prefix_cost": "22.75",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"parent_product_id",
"group_id"
]
}
},
{
"table": {
"table_name": "p",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"cscartdb.gp.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 65,
"filtered": "100.00",
"cost_info": {
"read_cost": "16.25",
"eval_cost": "6.50",
"prefix_cost": "45.50",
"data_read_per_join": "348K"
},
"used_columns": [
"product_id",
"company_id"
]
}
}
]
}
}
product_id | parent_product_id | group_id | company_id |
---|---|---|---|
18638 | 0 | 1965 | 179 |
57377 | 18638 | 1965 | 179 |
57378 | 18638 | 1965 | 179 |
57379 | 18638 | 1965 | 179 |
57380 | 18638 | 1965 | 179 |
57381 | 18638 | 1965 | 179 |
57382 | 18638 | 1965 | 179 |
57383 | 18638 | 1965 | 179 |
57384 | 18638 | 1965 | 179 |
57385 | 18638 | 1965 | 179 |
57386 | 18638 | 1965 | 179 |
57387 | 18638 | 1965 | 179 |
57388 | 18638 | 1965 | 179 |
57389 | 18638 | 1965 | 179 |
57390 | 18638 | 1965 | 179 |
57391 | 18638 | 1965 | 179 |
57392 | 18638 | 1965 | 179 |
57393 | 18638 | 1965 | 179 |
57394 | 18638 | 1965 | 179 |
57395 | 18638 | 1965 | 179 |
57396 | 18638 | 1965 | 179 |
57397 | 18638 | 1965 | 179 |
57398 | 18638 | 1965 | 179 |
57399 | 18638 | 1965 | 179 |
57400 | 18638 | 1965 | 179 |
57401 | 18638 | 1965 | 179 |
57402 | 18638 | 1965 | 179 |
57403 | 18638 | 1965 | 179 |
57404 | 18638 | 1965 | 179 |
57405 | 18638 | 1965 | 179 |
57406 | 18638 | 1965 | 179 |
57407 | 18638 | 1965 | 179 |
57408 | 18638 | 1965 | 179 |
57409 | 18638 | 1965 | 179 |
57410 | 18638 | 1965 | 179 |
57411 | 18638 | 1965 | 179 |
57412 | 18638 | 1965 | 179 |
57413 | 18638 | 1965 | 179 |
57414 | 18638 | 1965 | 179 |
57415 | 18638 | 1965 | 179 |
57416 | 18638 | 1965 | 179 |
57417 | 18638 | 1965 | 179 |
57418 | 18638 | 1965 | 179 |
57419 | 18638 | 1965 | 179 |
57420 | 18638 | 1965 | 179 |
57421 | 18638 | 1965 | 179 |
57422 | 18638 | 1965 | 179 |
57423 | 18638 | 1965 | 179 |
57424 | 18638 | 1965 | 179 |
57425 | 18638 | 1965 | 179 |
57426 | 18638 | 1965 | 179 |
57427 | 18638 | 1965 | 179 |
57428 | 18638 | 1965 | 179 |
57429 | 18638 | 1965 | 179 |
57430 | 18638 | 1965 | 179 |
57431 | 18638 | 1965 | 179 |
57432 | 18638 | 1965 | 179 |
57433 | 18638 | 1965 | 179 |
57434 | 18638 | 1965 | 179 |
57435 | 18638 | 1965 | 179 |
57436 | 18638 | 1965 | 179 |
57437 | 18638 | 1965 | 179 |
57438 | 18638 | 1965 | 179 |
57439 | 18638 | 1965 | 179 |
57440 | 18638 | 1965 | 179 |
57441 | 18638 | 1965 | 179 |
57442 | 18638 | 1965 | 179 |
57443 | 18638 | 1965 | 179 |
57444 | 18638 | 1965 | 179 |
57445 | 18638 | 1965 | 179 |
57446 | 18638 | 1965 | 179 |
57447 | 18638 | 1965 | 179 |
57448 | 18638 | 1965 | 179 |
57449 | 18638 | 1965 | 179 |
57450 | 18638 | 1965 | 179 |