Query time 0.00098
JSON explain
{
"query_block": {
"select_id": 1,
"table": {
"table_name": "gp",
"access_type": "range",
"possible_keys": ["PRIMARY", "idx_group_id"],
"key": "idx_group_id",
"key_length": "3",
"used_key_parts": ["group_id"],
"rows": 24,
"filtered": 100,
"index_condition": "gp.group_id in (447,446,448,449,444,445)"
},
"table": {
"table_name": "gpf",
"access_type": "ref",
"possible_keys": ["PRIMARY", "idx_group_id"],
"key": "idx_group_id",
"key_length": "3",
"used_key_parts": ["group_id"],
"ref": ["ymonline_livedata.gp.group_id"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "pfv",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"fl",
"lang_code",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "idx_product_feature_variant_id",
"key_length": "12",
"used_key_parts": ["product_id", "feature_id", "lang_code"],
"ref": [
"ymonline_livedata.gp.product_id",
"ymonline_livedata.gpf.feature_id",
"const"
],
"rows": 1,
"filtered": 100,
"attached_condition": "pfv.lang_code = 'en'",
"using_index": true
}
}
}
Result
feature_id |
product_id |
variant_id |
group_id |
564 |
4958 |
1716 |
444 |
575 |
4958 |
1718 |
444 |
574 |
4958 |
1461 |
444 |
564 |
4957 |
1716 |
444 |
575 |
4957 |
1717 |
444 |
574 |
4957 |
1461 |
444 |
564 |
4956 |
1716 |
444 |
575 |
4956 |
1715 |
444 |
574 |
4956 |
1461 |
444 |
574 |
4961 |
1464 |
445 |
564 |
4961 |
1720 |
445 |
575 |
4961 |
1722 |
445 |
574 |
4960 |
1464 |
445 |
564 |
4960 |
1720 |
445 |
575 |
4960 |
1721 |
445 |
574 |
4959 |
1461 |
445 |
564 |
4959 |
1720 |
445 |
575 |
4959 |
1719 |
445 |
574 |
4969 |
1464 |
446 |
575 |
4969 |
1724 |
446 |
551 |
4969 |
1470 |
446 |
574 |
4968 |
1464 |
446 |
575 |
4968 |
1724 |
446 |
551 |
4968 |
1469 |
446 |
574 |
4967 |
1464 |
446 |
575 |
4967 |
1724 |
446 |
551 |
4967 |
1468 |
446 |
574 |
4966 |
1461 |
446 |
575 |
4966 |
1724 |
446 |
551 |
4966 |
1470 |
446 |
574 |
4965 |
1461 |
446 |
575 |
4965 |
1724 |
446 |
551 |
4965 |
1469 |
446 |
574 |
4964 |
1461 |
446 |
575 |
4964 |
1724 |
446 |
551 |
4964 |
1468 |
446 |
574 |
4963 |
1466 |
446 |
575 |
4963 |
1723 |
446 |
551 |
4963 |
1470 |
446 |
574 |
4973 |
1464 |
447 |
575 |
4973 |
1728 |
447 |
551 |
4973 |
1470 |
447 |
574 |
4972 |
1464 |
447 |
575 |
4972 |
1727 |
447 |
551 |
4972 |
1469 |
447 |
574 |
4971 |
1456 |
447 |
575 |
4971 |
1726 |
447 |
551 |
4971 |
1470 |
447 |
574 |
4970 |
1456 |
447 |
575 |
4970 |
1725 |
447 |
551 |
4970 |
1469 |
447 |
551 |
4977 |
1470 |
448 |
574 |
4977 |
1464 |
448 |
575 |
4977 |
1724 |
448 |
551 |
4976 |
1469 |
448 |
574 |
4976 |
1464 |
448 |
575 |
4976 |
1724 |
448 |
551 |
4975 |
1470 |
448 |
574 |
4975 |
1461 |
448 |
575 |
4975 |
1724 |
448 |
551 |
4974 |
1469 |
448 |
574 |
4974 |
1461 |
448 |
575 |
4974 |
1724 |
448 |
574 |
4981 |
1464 |
449 |
575 |
4981 |
1730 |
449 |
551 |
4981 |
1470 |
449 |
574 |
4980 |
1464 |
449 |
575 |
4980 |
1730 |
449 |
551 |
4980 |
1469 |
449 |
574 |
4979 |
1456 |
449 |
575 |
4979 |
1729 |
449 |
551 |
4979 |
1470 |
449 |
574 |
4978 |
1456 |
449 |
575 |
4978 |
1729 |
449 |
551 |
4978 |
1469 |
449 |