Query time 0.00305
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "265.09"
},
"nested_loop": [
{
"table": {
"table_name": "gp",
"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": 78,
"rows_produced_per_join": 78,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "16.69",
"eval_cost": "15.60",
"prefix_cost": "32.29",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"group_id"
],
"attached_condition": "(`webmarco`.`gp`.`group_id` in (6941,7017,7641,8356,7642,7632,8359,7639,8358,7612,8360,8361,8357,7630,8363,8362,7640,8364))"
}
},
{
"table": {
"table_name": "gpf",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"idx_group_id"
],
"key": "idx_group_id",
"used_key_parts": [
"group_id"
],
"key_length": "3",
"ref": [
"webmarco.gp.group_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 110,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "78.04",
"eval_cost": "22.11",
"prefix_cost": "132.44",
"data_read_per_join": "11K"
},
"used_columns": [
"feature_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": 110,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "110.54",
"eval_cost": "22.11",
"prefix_cost": "265.09",
"data_read_per_join": "85K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id",
"lang_code"
]
}
}
]
}
}
Result
feature_id |
product_id |
variant_id |
group_id |
649 |
263981 |
62608 |
6941 |
649 |
264764 |
62609 |
6941 |
649 |
264765 |
62610 |
6941 |
649 |
264766 |
62611 |
6941 |
649 |
264767 |
62612 |
6941 |
649 |
264102 |
62612 |
7017 |
882 |
264102 |
60392 |
7017 |
649 |
264969 |
62608 |
7017 |
882 |
264969 |
60392 |
7017 |
649 |
264970 |
62609 |
7017 |
882 |
264970 |
60392 |
7017 |
649 |
264971 |
62610 |
7017 |
882 |
264971 |
60392 |
7017 |
649 |
264972 |
62611 |
7017 |
882 |
264972 |
60392 |
7017 |
649 |
264973 |
62608 |
7017 |
882 |
264973 |
60412 |
7017 |
649 |
264974 |
62609 |
7017 |
882 |
264974 |
60412 |
7017 |
649 |
264975 |
62610 |
7017 |
882 |
264975 |
60412 |
7017 |
649 |
264976 |
62611 |
7017 |
882 |
264976 |
60412 |
7017 |
649 |
264977 |
62612 |
7017 |
882 |
264977 |
60412 |
7017 |
649 |
366690 |
65025 |
7612 |
649 |
366691 |
62608 |
7612 |
649 |
366692 |
62609 |
7612 |
649 |
366693 |
62610 |
7612 |
649 |
366760 |
62608 |
7630 |
649 |
366761 |
62609 |
7630 |
649 |
366762 |
62610 |
7630 |
649 |
366771 |
65025 |
7632 |
649 |
366772 |
62608 |
7632 |
649 |
366773 |
62609 |
7632 |
649 |
366774 |
62610 |
7632 |
649 |
366775 |
62611 |
7632 |
649 |
366776 |
62612 |
7632 |
649 |
366815 |
65025 |
7639 |
649 |
366816 |
62608 |
7639 |
649 |
366817 |
62609 |
7639 |
649 |
366818 |
62610 |
7639 |
649 |
366819 |
62611 |
7639 |
649 |
366820 |
62612 |
7639 |
649 |
366821 |
65025 |
7640 |
649 |
366827 |
65025 |
7641 |
649 |
366828 |
62608 |
7641 |
649 |
366829 |
62609 |
7641 |
649 |
366830 |
62610 |
7641 |
649 |
366831 |
62611 |
7641 |
649 |
366832 |
62612 |
7641 |
649 |
366833 |
65025 |
7642 |
649 |
366834 |
62608 |
7642 |
649 |
366835 |
62609 |
7642 |
649 |
366836 |
62610 |
7642 |
649 |
366837 |
62611 |
7642 |
649 |
366838 |
62612 |
7642 |
939 |
371861 |
63941 |
8356 |
939 |
377772 |
65309 |
8356 |
939 |
377773 |
65310 |
8356 |
939 |
377774 |
65311 |
8356 |
939 |
377775 |
65312 |
8356 |
939 |
371868 |
65309 |
8357 |
939 |
377776 |
65311 |
8357 |
939 |
371873 |
65309 |
8358 |
939 |
377777 |
65310 |
8358 |
939 |
377778 |
65311 |
8358 |
939 |
377779 |
65312 |
8358 |
939 |
371878 |
63941 |
8359 |
939 |
377780 |
65309 |
8359 |
939 |
377781 |
65310 |
8359 |
939 |
377782 |
65311 |
8359 |
939 |
377783 |
65312 |
8359 |
939 |
371884 |
65309 |
8360 |
939 |
377784 |
65310 |
8360 |
939 |
377785 |
65311 |
8360 |
939 |
377786 |
65312 |
8360 |
939 |
371890 |
65310 |
8361 |
939 |
377787 |
65311 |
8361 |
939 |
377788 |
65312 |
8361 |
939 |
371895 |
63941 |
8362 |
939 |
377789 |
65312 |
8362 |
939 |
371898 |
63941 |
8363 |
939 |
377790 |
65309 |
8363 |
939 |
377791 |
65311 |
8363 |
939 |
371902 |
65310 |
8364 |
939 |
377792 |
65311 |
8364 |
939 |
377793 |
65312 |
8364 |