Query time 0.00223
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "220.42"
},
"nested_loop": [
{
"table": {
"table_name": "gpf",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"idx_group_id"
],
"key": "idx_group_id",
"used_key_parts": [
"group_id"
],
"key_length": "3",
"rows_examined_per_scan": 15,
"rows_produced_per_join": 15,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "4.03",
"eval_cost": "3.00",
"prefix_cost": "7.03",
"data_read_per_join": "1K"
},
"used_columns": [
"feature_id",
"group_id"
],
"attached_condition": "(`webmarco`.`gpf`.`group_id` in (6692,6689,6472,6387,6384,6237,6687,6236,6235,6233,6234,6694,6688,6690,6693))"
}
},
{
"table": {
"table_name": "gp",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"idx_group_id"
],
"key": "idx_group_id",
"used_key_parts": [
"group_id"
],
"key_length": "3",
"ref": [
"webmarco.gpf.group_id"
],
"rows_examined_per_scan": 9,
"rows_produced_per_join": 141,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "15.14",
"eval_cost": "28.32",
"prefix_cost": "50.49",
"data_read_per_join": "2K"
},
"used_columns": [
"product_id",
"group_id"
]
}
},
{
"table": {
"table_name": "pfv",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"fl",
"lang_code",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "fpl",
"used_key_parts": [
"feature_id",
"product_id",
"lang_code"
],
"key_length": "12",
"ref": [
"webmarco.gpf.feature_id",
"webmarco.gp.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 141,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "141.61",
"eval_cost": "28.32",
"prefix_cost": "220.42",
"data_read_per_join": "109K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id",
"lang_code"
]
}
}
]
}
}
Result
feature_id |
product_id |
variant_id |
group_id |
697 |
225053 |
62213 |
6233 |
697 |
225054 |
62212 |
6233 |
697 |
225055 |
62214 |
6233 |
697 |
225056 |
62215 |
6233 |
697 |
225057 |
62216 |
6233 |
697 |
225058 |
62217 |
6233 |
697 |
225065 |
62218 |
6233 |
697 |
225066 |
62213 |
6234 |
697 |
225067 |
62212 |
6234 |
697 |
225068 |
62214 |
6234 |
697 |
225069 |
62215 |
6234 |
697 |
225070 |
62216 |
6234 |
697 |
225071 |
62217 |
6234 |
697 |
225072 |
62218 |
6234 |
697 |
225074 |
62216 |
6235 |
697 |
225075 |
62212 |
6235 |
697 |
225076 |
62213 |
6235 |
697 |
225077 |
62214 |
6235 |
697 |
225078 |
62215 |
6235 |
697 |
225079 |
62217 |
6235 |
697 |
225080 |
62218 |
6235 |
697 |
225081 |
62213 |
6236 |
697 |
225082 |
62212 |
6236 |
697 |
225083 |
62214 |
6236 |
697 |
225084 |
62215 |
6236 |
697 |
225085 |
62216 |
6236 |
697 |
225086 |
62217 |
6236 |
697 |
225087 |
62218 |
6236 |
697 |
225088 |
62213 |
6237 |
697 |
225089 |
62212 |
6237 |
697 |
225090 |
62214 |
6237 |
697 |
225091 |
62215 |
6237 |
697 |
225092 |
62216 |
6237 |
697 |
225093 |
62217 |
6237 |
697 |
225094 |
62218 |
6237 |
897 |
230173 |
62572 |
6384 |
897 |
233756 |
62576 |
6384 |
897 |
233757 |
62577 |
6384 |
897 |
233758 |
62578 |
6384 |
897 |
233759 |
62579 |
6384 |
897 |
233760 |
62580 |
6384 |
897 |
230172 |
62572 |
6387 |
897 |
233761 |
62576 |
6387 |
897 |
233762 |
62577 |
6387 |
897 |
233763 |
62578 |
6387 |
897 |
233764 |
62579 |
6387 |
897 |
233765 |
62580 |
6387 |
897 |
233766 |
62581 |
6387 |
897 |
233767 |
62582 |
6387 |
897 |
233768 |
62583 |
6387 |
897 |
259698 |
62572 |
6472 |
897 |
259699 |
62576 |
6472 |
897 |
259700 |
62577 |
6472 |
897 |
259701 |
62578 |
6472 |
897 |
259702 |
62579 |
6472 |
897 |
259703 |
62580 |
6472 |
897 |
259704 |
62581 |
6472 |
897 |
259705 |
62582 |
6472 |
897 |
259706 |
62583 |
6472 |
897 |
259707 |
63022 |
6472 |
932 |
262359 |
63589 |
6687 |
932 |
262368 |
63590 |
6687 |
932 |
262367 |
63591 |
6688 |
932 |
262369 |
63592 |
6688 |
932 |
262370 |
63593 |
6689 |
932 |
262371 |
63594 |
6689 |
932 |
262372 |
63595 |
6689 |
932 |
262373 |
63597 |
6689 |
897 |
262376 |
62221 |
6690 |
897 |
262377 |
63598 |
6690 |
897 |
262380 |
62223 |
6692 |
897 |
262381 |
62224 |
6692 |
897 |
262382 |
62225 |
6692 |
897 |
262383 |
62226 |
6692 |
897 |
262384 |
62227 |
6692 |
897 |
262385 |
63600 |
6692 |
897 |
262386 |
63601 |
6692 |
897 |
262387 |
63602 |
6692 |
897 |
262388 |
63603 |
6692 |
897 |
262389 |
63604 |
6692 |
897 |
262390 |
63605 |
6692 |
897 |
262391 |
62228 |
6693 |
897 |
262392 |
63599 |
6693 |
932 |
262394 |
63607 |
6694 |
932 |
262395 |
63608 |
6694 |