Query time 0.00356
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "55.51"
},
"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": 8,
"rows_produced_per_join": 8,
"filtered": "100.00",
"index_condition": "(`cscartdb`.`gpf`.`group_id` in (41,1441,380,437,1527,2340))",
"cost_info": {
"read_cost": "4.31",
"eval_cost": "0.80",
"prefix_cost": "5.11",
"data_read_per_join": "832"
},
"used_columns": [
"feature_id",
"group_id"
]
}
},
{
"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": [
"cscartdb.gpf.group_id"
],
"rows_examined_per_scan": 9,
"rows_produced_per_join": 72,
"filtered": "100.00",
"cost_info": {
"read_cost": "18.00",
"eval_cost": "7.20",
"prefix_cost": "30.31",
"data_read_per_join": "1K"
},
"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": [
"cscartdb.gpf.feature_id",
"cscartdb.gp.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 72,
"filtered": "100.00",
"cost_info": {
"read_cost": "18.00",
"eval_cost": "7.20",
"prefix_cost": "55.51",
"data_read_per_join": "55K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id",
"lang_code"
]
}
}
]
}
}
Result
feature_id |
product_id |
variant_id |
group_id |
73 |
5632 |
291 |
41 |
73 |
5669 |
290 |
41 |
73 |
5670 |
292 |
41 |
73 |
5671 |
293 |
41 |
73 |
5672 |
294 |
41 |
73 |
5673 |
295 |
41 |
281 |
15789 |
1219 |
380 |
281 |
15938 |
1219 |
380 |
281 |
15939 |
1219 |
380 |
281 |
15940 |
1219 |
380 |
281 |
15941 |
1219 |
380 |
281 |
15942 |
1220 |
380 |
281 |
15943 |
1220 |
380 |
281 |
15944 |
1220 |
380 |
281 |
15945 |
1220 |
380 |
281 |
15946 |
1220 |
380 |
282 |
15789 |
1221 |
380 |
282 |
15938 |
1222 |
380 |
282 |
15939 |
1223 |
380 |
282 |
15940 |
1224 |
380 |
282 |
15941 |
1225 |
380 |
282 |
15942 |
1221 |
380 |
282 |
15943 |
1222 |
380 |
282 |
15944 |
1223 |
380 |
282 |
15945 |
1224 |
380 |
282 |
15946 |
1225 |
380 |
329 |
14292 |
1494 |
437 |
329 |
18475 |
1496 |
437 |
329 |
18474 |
1495 |
437 |
329 |
18481 |
1502 |
437 |
329 |
18480 |
1501 |
437 |
329 |
18479 |
1500 |
437 |
329 |
18478 |
1499 |
437 |
329 |
18477 |
1498 |
437 |
329 |
18476 |
1497 |
437 |
329 |
18482 |
1503 |
437 |
329 |
18483 |
1504 |
437 |
329 |
18484 |
1505 |
437 |
1196 |
35061 |
4577 |
1441 |
1196 |
35060 |
4576 |
1441 |
1196 |
35059 |
4575 |
1441 |
1196 |
35058 |
4574 |
1441 |
1196 |
35057 |
4573 |
1441 |
1196 |
35056 |
4572 |
1441 |
1196 |
35055 |
4571 |
1441 |
1196 |
35054 |
4570 |
1441 |
1196 |
35053 |
4569 |
1441 |
1196 |
35052 |
4568 |
1441 |
1196 |
35051 |
4567 |
1441 |
1196 |
35050 |
4566 |
1441 |
1196 |
35049 |
4565 |
1441 |
1196 |
35048 |
4564 |
1441 |
1196 |
35047 |
4591 |
1441 |
1196 |
35046 |
4590 |
1441 |
1196 |
35045 |
4589 |
1441 |
1196 |
35044 |
4588 |
1441 |
1196 |
35043 |
4587 |
1441 |
1196 |
35042 |
4586 |
1441 |
1196 |
35041 |
4585 |
1441 |
1196 |
35040 |
4584 |
1441 |
1196 |
35039 |
4583 |
1441 |
1196 |
35038 |
4582 |
1441 |
1196 |
35037 |
4581 |
1441 |
1196 |
35036 |
4580 |
1441 |
1196 |
35035 |
4579 |
1441 |
1196 |
35034 |
4578 |
1441 |
1196 |
35033 |
4577 |
1441 |
1196 |
35032 |
4576 |
1441 |
1196 |
35031 |
4575 |
1441 |
1196 |
35030 |
4574 |
1441 |
1196 |
34936 |
4564 |
1441 |
1196 |
35102 |
4590 |
1441 |
1196 |
35103 |
4591 |
1441 |
1196 |
35093 |
4581 |
1441 |
1196 |
35101 |
4589 |
1441 |
1196 |
35100 |
4588 |
1441 |
1196 |
35099 |
4587 |
1441 |
1196 |
35098 |
4586 |
1441 |
1196 |
35097 |
4585 |
1441 |
1196 |
35096 |
4584 |
1441 |
1196 |
35095 |
4583 |
1441 |
1196 |
35094 |
4582 |
1441 |
1196 |
35084 |
4572 |
1441 |
1196 |
35092 |
4580 |
1441 |
1196 |
35091 |
4579 |
1441 |
1196 |
35090 |
4578 |
1441 |
1196 |
35089 |
4577 |
1441 |
1196 |
35088 |
4576 |
1441 |
1196 |
35087 |
4575 |
1441 |
1196 |
35086 |
4574 |
1441 |
1196 |
35085 |
4573 |
1441 |
1196 |
35075 |
4591 |
1441 |
1196 |
35083 |
4571 |
1441 |
1196 |
35082 |
4570 |
1441 |
1196 |
35081 |
4569 |
1441 |
1196 |
35080 |
4568 |
1441 |
1196 |
35079 |
4567 |
1441 |
1196 |
35078 |
4566 |
1441 |
1196 |
35077 |
4565 |
1441 |
1196 |
35076 |
4564 |
1441 |
1196 |
35066 |
4582 |
1441 |
1196 |
35074 |
4590 |
1441 |
1196 |
35073 |
4589 |
1441 |
1196 |
35072 |
4588 |
1441 |
1196 |
35071 |
4587 |
1441 |
1196 |
35070 |
4586 |
1441 |
1196 |
35069 |
4585 |
1441 |
1196 |
35068 |
4584 |
1441 |
1196 |
35067 |
4583 |
1441 |
1196 |
35029 |
4573 |
1441 |
1196 |
35065 |
4581 |
1441 |
1196 |
35064 |
4580 |
1441 |
1196 |
35063 |
4579 |
1441 |
1196 |
35062 |
4578 |
1441 |
1196 |
35028 |
4572 |
1441 |
1196 |
35027 |
4571 |
1441 |
1196 |
35026 |
4570 |
1441 |
1196 |
35025 |
4569 |
1441 |
1196 |
35024 |
4568 |
1441 |
1196 |
35023 |
4567 |
1441 |
1196 |
35022 |
4566 |
1441 |
1196 |
35021 |
4565 |
1441 |
1196 |
35020 |
4564 |
1441 |
1196 |
35019 |
4591 |
1441 |
1196 |
35018 |
4590 |
1441 |
1196 |
35017 |
4589 |
1441 |
1196 |
35016 |
4588 |
1441 |
1196 |
35015 |
4587 |
1441 |
1196 |
35014 |
4586 |
1441 |
1196 |
35013 |
4585 |
1441 |
1196 |
35012 |
4584 |
1441 |
1196 |
35011 |
4583 |
1441 |
1196 |
35010 |
4582 |
1441 |
1196 |
35009 |
4581 |
1441 |
1196 |
35008 |
4580 |
1441 |
1196 |
35007 |
4579 |
1441 |
1196 |
35006 |
4578 |
1441 |
1196 |
35005 |
4577 |
1441 |
1196 |
35004 |
4576 |
1441 |
1196 |
35003 |
4575 |
1441 |
1196 |
35002 |
4574 |
1441 |
1196 |
35001 |
4573 |
1441 |
1196 |
35000 |
4572 |
1441 |
1196 |
34999 |
4571 |
1441 |
1196 |
34998 |
4570 |
1441 |
1196 |
34997 |
4569 |
1441 |
1196 |
34996 |
4568 |
1441 |
1196 |
34995 |
4567 |
1441 |
1196 |
34994 |
4566 |
1441 |
1196 |
34993 |
4565 |
1441 |
1196 |
34992 |
4564 |
1441 |
1196 |
34991 |
4591 |
1441 |
1196 |
34990 |
4590 |
1441 |
1196 |
34989 |
4589 |
1441 |
1196 |
34988 |
4588 |
1441 |
1196 |
34987 |
4587 |
1441 |
1196 |
34986 |
4586 |
1441 |
1196 |
34985 |
4585 |
1441 |
1196 |
34984 |
4584 |
1441 |
1196 |
34983 |
4583 |
1441 |
1196 |
34982 |
4582 |
1441 |
1196 |
34981 |
4581 |
1441 |
1196 |
34980 |
4580 |
1441 |
1196 |
34979 |
4579 |
1441 |
1196 |
34978 |
4578 |
1441 |
1196 |
34977 |
4577 |
1441 |
1196 |
34976 |
4576 |
1441 |
1196 |
34975 |
4575 |
1441 |
1196 |
34974 |
4574 |
1441 |
1196 |
34973 |
4573 |
1441 |
1196 |
34972 |
4572 |
1441 |
1196 |
34971 |
4571 |
1441 |
1196 |
34970 |
4570 |
1441 |
1196 |
34969 |
4569 |
1441 |
1196 |
34968 |
4568 |
1441 |
1196 |
34967 |
4567 |
1441 |
1196 |
34966 |
4566 |
1441 |
1196 |
34965 |
4565 |
1441 |
1196 |
34964 |
4564 |
1441 |
1196 |
34963 |
4591 |
1441 |
1196 |
34962 |
4590 |
1441 |
1196 |
34961 |
4589 |
1441 |
1196 |
34960 |
4588 |
1441 |
1196 |
34959 |
4587 |
1441 |
1196 |
34958 |
4586 |
1441 |
1196 |
34957 |
4585 |
1441 |
1196 |
34956 |
4584 |
1441 |
1196 |
34955 |
4583 |
1441 |
1196 |
34954 |
4582 |
1441 |
1196 |
34953 |
4581 |
1441 |
1196 |
34952 |
4580 |
1441 |
1196 |
34951 |
4579 |
1441 |
1196 |
34950 |
4578 |
1441 |
1196 |
34949 |
4577 |
1441 |
1196 |
34948 |
4576 |
1441 |
1196 |
34947 |
4575 |
1441 |
1196 |
34946 |
4574 |
1441 |
1196 |
34945 |
4573 |
1441 |
1196 |
34944 |
4572 |
1441 |
1196 |
34943 |
4571 |
1441 |
1196 |
34942 |
4570 |
1441 |
1196 |
34941 |
4569 |
1441 |
1196 |
34940 |
4568 |
1441 |
1196 |
34939 |
4567 |
1441 |
1196 |
34938 |
4566 |
1441 |
1196 |
34937 |
4565 |
1441 |
317 |
35061 |
1438 |
1441 |
317 |
35060 |
1438 |
1441 |
317 |
35059 |
1438 |
1441 |
317 |
35058 |
1438 |
1441 |
317 |
35057 |
1438 |
1441 |
317 |
35056 |
1438 |
1441 |
317 |
35055 |
1438 |
1441 |
317 |
35054 |
1438 |
1441 |
317 |
35053 |
1438 |
1441 |
317 |
35052 |
1438 |
1441 |
317 |
35051 |
1438 |
1441 |
317 |
35050 |
1438 |
1441 |
317 |
35049 |
1438 |
1441 |
317 |
35048 |
1438 |
1441 |
317 |
35047 |
1437 |
1441 |
317 |
35046 |
1437 |
1441 |
317 |
35045 |
1437 |
1441 |
317 |
35044 |
1437 |
1441 |
317 |
35043 |
1437 |
1441 |
317 |
35042 |
1437 |
1441 |
317 |
35041 |
1437 |
1441 |
317 |
35040 |
1437 |
1441 |
317 |
35039 |
1437 |
1441 |
317 |
35038 |
1437 |
1441 |
317 |
35037 |
1437 |
1441 |
317 |
35036 |
1437 |
1441 |
317 |
35035 |
1437 |
1441 |
317 |
35034 |
1437 |
1441 |
317 |
35033 |
1437 |
1441 |
317 |
35032 |
1437 |
1441 |
317 |
35031 |
1437 |
1441 |
317 |
35030 |
1437 |
1441 |
317 |
34936 |
1434 |
1441 |
317 |
35102 |
1439 |
1441 |
317 |
35103 |
1439 |
1441 |
317 |
35093 |
1439 |
1441 |
317 |
35101 |
1439 |
1441 |
317 |
35100 |
1439 |
1441 |
317 |
35099 |
1439 |
1441 |
317 |
35098 |
1439 |
1441 |
317 |
35097 |
1439 |
1441 |
317 |
35096 |
1439 |
1441 |
317 |
35095 |
1439 |
1441 |
317 |
35094 |
1439 |
1441 |
317 |
35084 |
1439 |
1441 |
317 |
35092 |
1439 |
1441 |
317 |
35091 |
1439 |
1441 |
317 |
35090 |
1439 |
1441 |
317 |
35089 |
1439 |
1441 |
317 |
35088 |
1439 |
1441 |
317 |
35087 |
1439 |
1441 |
317 |
35086 |
1439 |
1441 |
317 |
35085 |
1439 |
1441 |
317 |
35075 |
1438 |
1441 |
317 |
35083 |
1439 |
1441 |
317 |
35082 |
1439 |
1441 |
317 |
35081 |
1439 |
1441 |
317 |
35080 |
1439 |
1441 |
317 |
35079 |
1439 |
1441 |
317 |
35078 |
1439 |
1441 |
317 |
35077 |
1439 |
1441 |
317 |
35076 |
1439 |
1441 |
317 |
35066 |
1438 |
1441 |
317 |
35074 |
1438 |
1441 |
317 |
35073 |
1438 |
1441 |
317 |
35072 |
1438 |
1441 |
317 |
35071 |
1438 |
1441 |
317 |
35070 |
1438 |
1441 |
317 |
35069 |
1438 |
1441 |
317 |
35068 |
1438 |
1441 |
317 |
35067 |
1438 |
1441 |
317 |
35029 |
1437 |
1441 |
317 |
35065 |
1438 |
1441 |
317 |
35064 |
1438 |
1441 |
317 |
35063 |
1438 |
1441 |
317 |
35062 |
1438 |
1441 |
317 |
35028 |
1437 |
1441 |
317 |
35027 |
1437 |
1441 |
317 |
35026 |
1437 |
1441 |
317 |
35025 |
1437 |
1441 |
317 |
35024 |
1437 |
1441 |
317 |
35023 |
1437 |
1441 |
317 |
35022 |
1437 |
1441 |
317 |
35021 |
1437 |
1441 |
317 |
35020 |
1437 |
1441 |
317 |
35019 |
1436 |
1441 |
317 |
35018 |
1436 |
1441 |
317 |
35017 |
1436 |
1441 |
317 |
35016 |
1436 |
1441 |
317 |
35015 |
1436 |
1441 |
317 |
35014 |
1436 |
1441 |
317 |
35013 |
1436 |
1441 |
317 |
35012 |
1436 |
1441 |
317 |
35011 |
1436 |
1441 |
317 |
35010 |
1436 |
1441 |
317 |
35009 |
1436 |
1441 |
317 |
35008 |
1436 |
1441 |
317 |
35007 |
1436 |
1441 |
317 |
35006 |
1436 |
1441 |
317 |
35005 |
1436 |
1441 |
317 |
35004 |
1436 |
1441 |
317 |
35003 |
1436 |
1441 |
317 |
35002 |
1436 |
1441 |
317 |
35001 |
1436 |
1441 |
317 |
35000 |
1436 |
1441 |
317 |
34999 |
1436 |
1441 |
317 |
34998 |
1436 |
1441 |
317 |
34997 |
1436 |
1441 |
317 |
34996 |
1436 |
1441 |
317 |
34995 |
1436 |
1441 |
317 |
34994 |
1436 |
1441 |
317 |
34993 |
1436 |
1441 |
317 |
34992 |
1436 |
1441 |
317 |
34991 |
1435 |
1441 |
317 |
34990 |
1435 |
1441 |
317 |
34989 |
1435 |
1441 |
317 |
34988 |
1435 |
1441 |
317 |
34987 |
1435 |
1441 |
317 |
34986 |
1435 |
1441 |
317 |
34985 |
1435 |
1441 |
317 |
34984 |
1435 |
1441 |
317 |
34983 |
1435 |
1441 |
317 |
34982 |
1435 |
1441 |
317 |
34981 |
1435 |
1441 |
317 |
34980 |
1435 |
1441 |
317 |
34979 |
1435 |
1441 |
317 |
34978 |
1435 |
1441 |
317 |
34977 |
1435 |
1441 |
317 |
34976 |
1435 |
1441 |
317 |
34975 |
1435 |
1441 |
317 |
34974 |
1435 |
1441 |
317 |
34973 |
1435 |
1441 |
317 |
34972 |
1435 |
1441 |
317 |
34971 |
1435 |
1441 |
317 |
34970 |
1435 |
1441 |
317 |
34969 |
1435 |
1441 |
317 |
34968 |
1435 |
1441 |
317 |
34967 |
1435 |
1441 |
317 |
34966 |
1435 |
1441 |
317 |
34965 |
1435 |
1441 |
317 |
34964 |
1435 |
1441 |
317 |
34963 |
1434 |
1441 |
317 |
34962 |
1434 |
1441 |
317 |
34961 |
1434 |
1441 |
317 |
34960 |
1434 |
1441 |
317 |
34959 |
1434 |
1441 |
317 |
34958 |
1434 |
1441 |
317 |
34957 |
1434 |
1441 |
317 |
34956 |
1434 |
1441 |
317 |
34955 |
1434 |
1441 |
317 |
34954 |
1434 |
1441 |
317 |
34953 |
1434 |
1441 |
317 |
34952 |
1434 |
1441 |
317 |
34951 |
1434 |
1441 |
317 |
34950 |
1434 |
1441 |
317 |
34949 |
1434 |
1441 |
317 |
34948 |
1434 |
1441 |
317 |
34947 |
1434 |
1441 |
317 |
34946 |
1434 |
1441 |
317 |
34945 |
1434 |
1441 |
317 |
34944 |
1434 |
1441 |
317 |
34943 |
1434 |
1441 |
317 |
34942 |
1434 |
1441 |
317 |
34941 |
1434 |
1441 |
317 |
34940 |
1434 |
1441 |
317 |
34939 |
1434 |
1441 |
317 |
34938 |
1434 |
1441 |
317 |
34937 |
1434 |
1441 |
336 |
36845 |
1640 |
1527 |
336 |
36844 |
1639 |
1527 |
336 |
36843 |
1637 |
1527 |
336 |
36842 |
1636 |
1527 |
336 |
36841 |
1635 |
1527 |
336 |
14294 |
1632 |
1527 |
336 |
36854 |
1649 |
1527 |
336 |
36853 |
1650 |
1527 |
336 |
36852 |
1646 |
1527 |
336 |
36851 |
4819 |
1527 |
336 |
36850 |
1648 |
1527 |
336 |
36849 |
1644 |
1527 |
336 |
36848 |
1643 |
1527 |
336 |
36847 |
1642 |
1527 |
336 |
36846 |
1641 |
1527 |
336 |
36856 |
1652 |
1527 |
336 |
36863 |
1659 |
1527 |
336 |
36862 |
1658 |
1527 |
336 |
36861 |
1638 |
1527 |
336 |
36860 |
1656 |
1527 |
336 |
36859 |
1655 |
1527 |
336 |
36858 |
1654 |
1527 |
336 |
36857 |
1653 |
1527 |
336 |
36855 |
1651 |
1527 |
336 |
36865 |
1645 |
1527 |
336 |
36871 |
1634 |
1527 |
336 |
36870 |
1633 |
1527 |
336 |
36869 |
1631 |
1527 |
336 |
36868 |
1647 |
1527 |
336 |
36867 |
1661 |
1527 |
336 |
36866 |
1657 |
1527 |
336 |
36864 |
1660 |
1527 |
1461 |
62676 |
5867 |
2340 |
1461 |
63480 |
5868 |
2340 |
1461 |
63479 |
5867 |
2340 |
1461 |
63478 |
5868 |
2340 |
1461 |
63477 |
5867 |
2340 |
1461 |
63476 |
5868 |
2340 |
1461 |
63475 |
5867 |
2340 |
1461 |
63474 |
5868 |
2340 |
1461 |
63473 |
5867 |
2340 |
1461 |
63472 |
5868 |
2340 |
1461 |
63471 |
5867 |
2340 |
1461 |
63470 |
5868 |
2340 |
1466 |
62676 |
5884 |
2340 |
1466 |
63480 |
5889 |
2340 |
1466 |
63479 |
5889 |
2340 |
1466 |
63478 |
5888 |
2340 |
1466 |
63477 |
5888 |
2340 |
1466 |
63476 |
5887 |
2340 |
1466 |
63475 |
5887 |
2340 |
1466 |
63474 |
5886 |
2340 |
1466 |
63473 |
5886 |
2340 |
1466 |
63472 |
5885 |
2340 |
1466 |
63471 |
5885 |
2340 |
1466 |
63470 |
5884 |
2340 |