Query time 0.00278
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "145.16"
},
"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": 121,
"rows_produced_per_join": 121,
"filtered": "100.00",
"index_condition": "(`cscartdb`.`gp`.`group_id` in (2366,2367,2369,2372,2373,2374,2376,2377,2378,2380,2379,2402,2416,2408,2410,2417,2435,2442,2430,2444,2431,1808,2461,1877))",
"cost_info": {
"read_cost": "48.36",
"eval_cost": "12.10",
"prefix_cost": "60.46",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"group_id"
]
}
},
{
"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": [
"cscartdb.gp.group_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 121,
"filtered": "100.00",
"cost_info": {
"read_cost": "30.25",
"eval_cost": "12.10",
"prefix_cost": "102.81",
"data_read_per_join": "12K"
},
"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": [
"cscartdb.gpf.feature_id",
"cscartdb.gp.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 121,
"filtered": "100.00",
"cost_info": {
"read_cost": "30.25",
"eval_cost": "12.10",
"prefix_cost": "145.16",
"data_read_per_join": "93K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id",
"lang_code"
]
}
}
]
}
}
Result
feature_id |
product_id |
variant_id |
group_id |
1374 |
55235 |
5510 |
1808 |
1375 |
55235 |
5515 |
1808 |
1377 |
55235 |
5517 |
1808 |
1374 |
55234 |
5510 |
1808 |
1375 |
55234 |
5514 |
1808 |
1377 |
55234 |
5517 |
1808 |
1374 |
55233 |
5511 |
1808 |
1375 |
55233 |
5515 |
1808 |
1377 |
55233 |
5517 |
1808 |
1374 |
55129 |
5511 |
1808 |
1375 |
55129 |
5514 |
1808 |
1377 |
55129 |
5517 |
1808 |
1374 |
55113 |
5511 |
1877 |
1409 |
55113 |
5663 |
1877 |
1374 |
56597 |
5511 |
1877 |
1409 |
56597 |
5664 |
1877 |
1374 |
56598 |
5510 |
1877 |
1409 |
56598 |
5663 |
1877 |
1374 |
56599 |
5510 |
1877 |
1409 |
56599 |
5664 |
1877 |
1482 |
20840 |
5985 |
2366 |
1482 |
63716 |
5986 |
2366 |
1482 |
63717 |
5987 |
2366 |
1482 |
63718 |
5988 |
2366 |
1482 |
63719 |
5989 |
2366 |
1482 |
63720 |
5990 |
2366 |
1482 |
20730 |
5985 |
2367 |
1482 |
63721 |
5986 |
2367 |
1482 |
63722 |
5987 |
2367 |
1482 |
63723 |
5988 |
2367 |
1482 |
63724 |
5989 |
2367 |
1482 |
63725 |
5990 |
2367 |
1482 |
20720 |
5985 |
2369 |
1482 |
63731 |
5986 |
2369 |
1482 |
63732 |
5987 |
2369 |
1482 |
63733 |
5988 |
2369 |
1482 |
63734 |
5989 |
2369 |
1482 |
63735 |
5990 |
2369 |
1482 |
20748 |
5985 |
2372 |
1482 |
63746 |
5986 |
2372 |
1482 |
63747 |
5987 |
2372 |
1482 |
63748 |
5988 |
2372 |
1482 |
63749 |
5989 |
2372 |
1482 |
63750 |
5990 |
2372 |
1482 |
20970 |
5985 |
2373 |
1482 |
63751 |
5986 |
2373 |
1482 |
63752 |
5987 |
2373 |
1482 |
63753 |
5988 |
2373 |
1482 |
63754 |
5989 |
2373 |
1482 |
63755 |
5990 |
2373 |
1482 |
20760 |
5985 |
2374 |
1482 |
63756 |
5986 |
2374 |
1482 |
63757 |
5987 |
2374 |
1482 |
63758 |
5988 |
2374 |
1482 |
63759 |
5989 |
2374 |
1482 |
63760 |
5990 |
2374 |
1482 |
20712 |
5985 |
2376 |
1482 |
63766 |
5986 |
2376 |
1482 |
63767 |
5987 |
2376 |
1482 |
63768 |
5988 |
2376 |
1482 |
63769 |
5989 |
2376 |
1482 |
63770 |
5990 |
2376 |
1482 |
20713 |
5985 |
2377 |
1482 |
63771 |
5986 |
2377 |
1482 |
63772 |
5987 |
2377 |
1482 |
63773 |
5988 |
2377 |
1482 |
63774 |
5989 |
2377 |
1482 |
63775 |
5990 |
2377 |
1482 |
20954 |
5985 |
2378 |
1482 |
63776 |
5986 |
2378 |
1482 |
63777 |
5987 |
2378 |
1482 |
63778 |
5988 |
2378 |
1482 |
63779 |
5989 |
2378 |
1482 |
63780 |
5990 |
2378 |
1482 |
20765 |
5985 |
2379 |
1482 |
63781 |
5986 |
2379 |
1482 |
63782 |
5987 |
2379 |
1482 |
63783 |
5988 |
2379 |
1482 |
63784 |
5989 |
2379 |
1482 |
63785 |
5990 |
2379 |
1482 |
20743 |
5985 |
2380 |
1482 |
63786 |
5986 |
2380 |
1482 |
63787 |
5987 |
2380 |
1482 |
63788 |
5988 |
2380 |
1482 |
63789 |
5989 |
2380 |
1482 |
63790 |
5990 |
2380 |
1482 |
20826 |
5985 |
2402 |
1482 |
63896 |
5986 |
2402 |
1482 |
63897 |
5987 |
2402 |
1482 |
63898 |
5988 |
2402 |
1482 |
63899 |
5989 |
2402 |
1482 |
63900 |
5990 |
2402 |
1482 |
20718 |
5985 |
2408 |
1482 |
63927 |
5986 |
2408 |
1482 |
63928 |
5987 |
2408 |
1482 |
63929 |
5988 |
2408 |
1482 |
63930 |
5989 |
2408 |
1482 |
63931 |
5990 |
2408 |
1482 |
20766 |
5985 |
2410 |
1482 |
63937 |
5986 |
2410 |
1482 |
63938 |
5987 |
2410 |
1482 |
63939 |
5988 |
2410 |
1482 |
63940 |
5989 |
2410 |
1482 |
63941 |
5990 |
2410 |
1482 |
20832 |
5985 |
2416 |
1482 |
63968 |
5986 |
2416 |
1482 |
63969 |
5987 |
2416 |
1482 |
63970 |
5988 |
2416 |
1482 |
63971 |
5989 |
2416 |
1482 |
63972 |
5990 |
2416 |
1482 |
21066 |
5985 |
2417 |
1482 |
63973 |
5986 |
2417 |
1482 |
63974 |
5987 |
2417 |
1482 |
63975 |
5988 |
2417 |
1482 |
63976 |
5989 |
2417 |
1482 |
63977 |
5990 |
2417 |
1482 |
20977 |
5985 |
2430 |
1482 |
64039 |
5986 |
2430 |
1482 |
64040 |
5987 |
2430 |
1482 |
64041 |
5988 |
2430 |
1482 |
64042 |
5989 |
2430 |
1482 |
64043 |
5990 |
2430 |
1482 |
20950 |
5985 |
2431 |
1482 |
64044 |
5986 |
2431 |
1482 |
64045 |
5987 |
2431 |
1482 |
64046 |
5988 |
2431 |
1482 |
64047 |
5989 |
2431 |
1482 |
64048 |
5990 |
2431 |
1482 |
20862 |
5985 |
2435 |
1482 |
64064 |
5986 |
2435 |
1482 |
64065 |
5987 |
2435 |
1482 |
64066 |
5988 |
2435 |
1482 |
64067 |
5989 |
2435 |
1482 |
64068 |
5990 |
2435 |
1482 |
20781 |
5985 |
2442 |
1482 |
64099 |
5986 |
2442 |
1482 |
64100 |
5987 |
2442 |
1482 |
64101 |
5988 |
2442 |
1482 |
64102 |
5989 |
2442 |
1482 |
64103 |
5990 |
2442 |
1482 |
20761 |
5985 |
2444 |
1482 |
64109 |
5986 |
2444 |
1482 |
64110 |
5987 |
2444 |
1482 |
64111 |
5988 |
2444 |
1482 |
64112 |
5989 |
2444 |
1482 |
64113 |
5990 |
2444 |
1482 |
20742 |
5985 |
2461 |
1482 |
64192 |
5986 |
2461 |
1482 |
64193 |
5987 |
2461 |
1482 |
64194 |
5988 |
2461 |
1482 |
64195 |
5989 |
2461 |
1482 |
64196 |
5990 |
2461 |