Query time 0.00157
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "170.81"
},
"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": "4",
"rows_examined_per_scan": 12,
"rows_produced_per_join": 12,
"filtered": "100.00",
"index_condition": "(`portal`.`gpf`.`group_id` in (11,12,13,14,15,16,17,3,4,76))",
"cost_info": {
"read_cost": "24.41",
"eval_cost": "2.40",
"prefix_cost": "26.81",
"data_read_per_join": "1K"
},
"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": "4",
"ref": [
"portal.gpf.group_id"
],
"rows_examined_per_scan": 5,
"rows_produced_per_join": 60,
"filtered": "100.00",
"cost_info": {
"read_cost": "60.00",
"eval_cost": "12.00",
"prefix_cost": "98.81",
"data_read_per_join": "960"
},
"used_columns": [
"product_id",
"group_id"
]
}
},
{
"table": {
"table_name": "pfv",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"fl",
"lang_code",
"product_id",
"fpl"
],
"key": "fpl",
"used_key_parts": [
"feature_id",
"product_id",
"lang_code"
],
"key_length": "12",
"ref": [
"portal.gpf.feature_id",
"portal.gp.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 60,
"filtered": "100.00",
"index_condition": "((`portal`.`gpf`.`feature_id` = `portal`.`pfv`.`feature_id`) and (`portal`.`pfv`.`product_id` = `portal`.`gp`.`product_id`))",
"cost_info": {
"read_cost": "60.00",
"eval_cost": "12.00",
"prefix_cost": "170.81",
"data_read_per_join": "46K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id",
"lang_code"
]
}
}
]
}
}
Result
feature_id |
product_id |
variant_id |
group_id |
73 |
1737 |
9801 |
3 |
73 |
1747 |
9802 |
3 |
73 |
1748 |
9803 |
3 |
73 |
1749 |
9804 |
3 |
73 |
1745 |
9801 |
4 |
73 |
1751 |
9802 |
4 |
73 |
1752 |
9803 |
4 |
73 |
1753 |
9804 |
4 |
73 |
1754 |
9805 |
4 |
74 |
1931 |
9865 |
11 |
74 |
2167 |
9865 |
11 |
74 |
2169 |
9865 |
11 |
74 |
2170 |
9865 |
11 |
74 |
2171 |
9865 |
11 |
74 |
2172 |
9864 |
11 |
74 |
2173 |
9864 |
11 |
74 |
2174 |
9864 |
11 |
74 |
2175 |
9864 |
11 |
74 |
2176 |
9864 |
11 |
73 |
1931 |
9802 |
11 |
73 |
2167 |
9801 |
11 |
73 |
2169 |
9803 |
11 |
73 |
2170 |
9804 |
11 |
73 |
2171 |
9805 |
11 |
73 |
2172 |
9801 |
11 |
73 |
2173 |
9802 |
11 |
73 |
2174 |
9803 |
11 |
73 |
2175 |
9804 |
11 |
73 |
2176 |
9805 |
11 |
74 |
1941 |
9865 |
12 |
74 |
2178 |
9865 |
12 |
74 |
2179 |
9865 |
12 |
74 |
2180 |
9865 |
12 |
74 |
2181 |
9865 |
12 |
74 |
2182 |
9864 |
12 |
74 |
2183 |
9864 |
12 |
74 |
2184 |
9864 |
12 |
74 |
2185 |
9864 |
12 |
74 |
2186 |
9864 |
12 |
73 |
1941 |
9801 |
12 |
73 |
2178 |
9802 |
12 |
73 |
2179 |
9803 |
12 |
73 |
2180 |
9804 |
12 |
73 |
2181 |
9805 |
12 |
73 |
2182 |
9801 |
12 |
73 |
2183 |
9802 |
12 |
73 |
2184 |
9803 |
12 |
73 |
2185 |
9804 |
12 |
73 |
2186 |
9805 |
12 |
73 |
1951 |
9802 |
13 |
73 |
2187 |
9801 |
13 |
73 |
2189 |
9803 |
13 |
73 |
2190 |
9804 |
13 |
74 |
1955 |
9900 |
14 |
74 |
2191 |
9864 |
14 |
74 |
2192 |
9864 |
14 |
74 |
2193 |
9864 |
14 |
74 |
2194 |
9864 |
14 |
74 |
2195 |
9864 |
14 |
74 |
2196 |
9863 |
14 |
74 |
2197 |
9863 |
14 |
74 |
2198 |
9863 |
14 |
74 |
2199 |
9863 |
14 |
74 |
2200 |
9863 |
14 |
74 |
2201 |
9900 |
14 |
74 |
2203 |
9900 |
14 |
74 |
2204 |
9900 |
14 |
74 |
2205 |
9900 |
14 |
73 |
1955 |
9802 |
14 |
73 |
2191 |
9801 |
14 |
73 |
2192 |
9802 |
14 |
73 |
2193 |
9803 |
14 |
73 |
2194 |
9804 |
14 |
73 |
2195 |
9805 |
14 |
73 |
2196 |
9801 |
14 |
73 |
2197 |
9802 |
14 |
73 |
2198 |
9803 |
14 |
73 |
2199 |
9804 |
14 |
73 |
2200 |
9805 |
14 |
73 |
2201 |
9801 |
14 |
73 |
2203 |
9803 |
14 |
73 |
2204 |
9804 |
14 |
73 |
2205 |
9805 |
14 |
74 |
1970 |
9865 |
15 |
74 |
2206 |
9865 |
15 |
74 |
2208 |
9865 |
15 |
74 |
2209 |
9865 |
15 |
74 |
2210 |
9865 |
15 |
74 |
2211 |
9864 |
15 |
74 |
2212 |
9864 |
15 |
74 |
2213 |
9864 |
15 |
74 |
2214 |
9864 |
15 |
74 |
2215 |
9864 |
15 |
74 |
2216 |
9902 |
15 |
74 |
2217 |
9902 |
15 |
74 |
2218 |
9902 |
15 |
74 |
2219 |
9902 |
15 |
74 |
2220 |
9902 |
15 |
73 |
1970 |
9802 |
15 |
73 |
2206 |
9801 |
15 |
73 |
2208 |
9803 |
15 |
73 |
2209 |
9804 |
15 |
73 |
2210 |
9805 |
15 |
73 |
2211 |
9801 |
15 |
73 |
2212 |
9802 |
15 |
73 |
2213 |
9803 |
15 |
73 |
2214 |
9804 |
15 |
73 |
2215 |
9805 |
15 |
73 |
2216 |
9801 |
15 |
73 |
2217 |
9802 |
15 |
73 |
2218 |
9803 |
15 |
73 |
2219 |
9804 |
15 |
73 |
2220 |
9805 |
15 |
74 |
1985 |
9865 |
16 |
74 |
2223 |
9865 |
16 |
74 |
2224 |
9865 |
16 |
74 |
2225 |
9865 |
16 |
74 |
2226 |
9865 |
16 |
74 |
2227 |
9864 |
16 |
74 |
2228 |
9864 |
16 |
74 |
2229 |
9864 |
16 |
74 |
2230 |
9864 |
16 |
74 |
2231 |
9864 |
16 |
74 |
2232 |
9900 |
16 |
74 |
2233 |
9900 |
16 |
74 |
2234 |
9900 |
16 |
74 |
2235 |
9900 |
16 |
74 |
2236 |
9900 |
16 |
73 |
1985 |
9801 |
16 |
73 |
2223 |
9802 |
16 |
73 |
2224 |
9803 |
16 |
73 |
2225 |
9804 |
16 |
73 |
2226 |
9805 |
16 |
73 |
2227 |
9801 |
16 |
73 |
2228 |
9802 |
16 |
73 |
2229 |
9803 |
16 |
73 |
2230 |
9804 |
16 |
73 |
2231 |
9805 |
16 |
73 |
2232 |
9801 |
16 |
73 |
2233 |
9802 |
16 |
73 |
2234 |
9803 |
16 |
73 |
2235 |
9804 |
16 |
73 |
2236 |
9805 |
16 |
73 |
2000 |
9801 |
17 |
73 |
2238 |
9802 |
17 |
73 |
2239 |
9803 |
17 |
73 |
2240 |
9804 |
17 |
74 |
1388 |
9865 |
76 |
74 |
8679 |
9866 |
76 |
74 |
8680 |
9902 |
76 |