Query time 0.00243
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "199.61"
},
"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": 14,
"rows_produced_per_join": 14,
"filtered": "100.00",
"index_condition": "(`portal`.`gpf`.`group_id` in (25,24,23,7,18,20,19,5,6,8,9,10))",
"cost_info": {
"read_cost": "28.81",
"eval_cost": "2.80",
"prefix_cost": "31.61",
"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": 70,
"filtered": "100.00",
"cost_info": {
"read_cost": "70.00",
"eval_cost": "14.00",
"prefix_cost": "115.61",
"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"
],
"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": 70,
"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": "70.00",
"eval_cost": "14.00",
"prefix_cost": "199.61",
"data_read_per_join": "54K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id",
"lang_code"
]
}
}
]
}
}
Result
feature_id |
product_id |
variant_id |
group_id |
74 |
1848 |
9866 |
5 |
74 |
2004 |
9866 |
5 |
74 |
2006 |
9866 |
5 |
74 |
2007 |
9866 |
5 |
74 |
2008 |
9865 |
5 |
74 |
2009 |
9865 |
5 |
74 |
2010 |
9865 |
5 |
74 |
2011 |
9865 |
5 |
74 |
2012 |
9864 |
5 |
74 |
2013 |
9864 |
5 |
74 |
2014 |
9864 |
5 |
74 |
2015 |
9864 |
5 |
74 |
2016 |
9863 |
5 |
74 |
2017 |
9863 |
5 |
74 |
2018 |
9863 |
5 |
74 |
2019 |
9863 |
5 |
73 |
1848 |
9802 |
5 |
73 |
2004 |
9801 |
5 |
73 |
2006 |
9803 |
5 |
73 |
2007 |
9804 |
5 |
73 |
2008 |
9801 |
5 |
73 |
2009 |
9802 |
5 |
73 |
2010 |
9803 |
5 |
73 |
2011 |
9804 |
5 |
73 |
2012 |
9801 |
5 |
73 |
2013 |
9802 |
5 |
73 |
2014 |
9803 |
5 |
73 |
2015 |
9804 |
5 |
73 |
2016 |
9801 |
5 |
73 |
2017 |
9802 |
5 |
73 |
2018 |
9803 |
5 |
73 |
2019 |
9804 |
5 |
74 |
1856 |
9864 |
6 |
74 |
2079 |
9864 |
6 |
74 |
2081 |
9864 |
6 |
74 |
2082 |
9864 |
6 |
74 |
2083 |
9900 |
6 |
74 |
2084 |
9900 |
6 |
74 |
2085 |
9900 |
6 |
74 |
2086 |
9900 |
6 |
74 |
2087 |
9902 |
6 |
74 |
2088 |
9902 |
6 |
74 |
2089 |
9902 |
6 |
74 |
2090 |
9902 |
6 |
73 |
1856 |
9802 |
6 |
73 |
2079 |
9801 |
6 |
73 |
2081 |
9803 |
6 |
73 |
2082 |
9804 |
6 |
73 |
2083 |
9801 |
6 |
73 |
2084 |
9802 |
6 |
73 |
2085 |
9803 |
6 |
73 |
2086 |
9804 |
6 |
73 |
2087 |
9801 |
6 |
73 |
2088 |
9802 |
6 |
73 |
2089 |
9803 |
6 |
73 |
2090 |
9804 |
6 |
74 |
2020 |
9866 |
7 |
74 |
2091 |
9866 |
7 |
74 |
2093 |
9866 |
7 |
74 |
2094 |
9863 |
7 |
74 |
2095 |
9863 |
7 |
74 |
2096 |
9863 |
7 |
74 |
2097 |
9902 |
7 |
74 |
2098 |
9902 |
7 |
74 |
2099 |
9902 |
7 |
74 |
2100 |
9903 |
7 |
74 |
2101 |
9903 |
7 |
74 |
2102 |
9903 |
7 |
73 |
2020 |
9802 |
7 |
73 |
2091 |
9801 |
7 |
73 |
2093 |
9803 |
7 |
73 |
2094 |
9801 |
7 |
73 |
2095 |
9802 |
7 |
73 |
2096 |
9803 |
7 |
73 |
2097 |
9801 |
7 |
73 |
2098 |
9802 |
7 |
73 |
2099 |
9803 |
7 |
73 |
2100 |
9801 |
7 |
73 |
2101 |
9802 |
7 |
73 |
2102 |
9803 |
7 |
74 |
1868 |
9865 |
8 |
74 |
2105 |
9865 |
8 |
74 |
2106 |
9865 |
8 |
74 |
2107 |
9865 |
8 |
74 |
2108 |
9865 |
8 |
74 |
2109 |
9864 |
8 |
74 |
2110 |
9864 |
8 |
74 |
2111 |
9864 |
8 |
74 |
2112 |
9864 |
8 |
74 |
2113 |
9864 |
8 |
73 |
1868 |
9801 |
8 |
73 |
2105 |
9802 |
8 |
73 |
2106 |
9803 |
8 |
73 |
2107 |
9804 |
8 |
73 |
2108 |
9805 |
8 |
73 |
2109 |
9801 |
8 |
73 |
2110 |
9802 |
8 |
73 |
2111 |
9803 |
8 |
73 |
2112 |
9804 |
8 |
73 |
2113 |
9805 |
8 |
74 |
1878 |
9866 |
9 |
74 |
2115 |
9866 |
9 |
74 |
2116 |
9866 |
9 |
74 |
2117 |
9866 |
9 |
74 |
2118 |
9902 |
9 |
74 |
2119 |
9902 |
9 |
74 |
2120 |
9902 |
9 |
74 |
2121 |
9902 |
9 |
73 |
1878 |
9801 |
9 |
73 |
2115 |
9802 |
9 |
73 |
2116 |
9803 |
9 |
73 |
2117 |
9804 |
9 |
73 |
2118 |
9801 |
9 |
73 |
2119 |
9802 |
9 |
73 |
2120 |
9803 |
9 |
73 |
2121 |
9804 |
9 |
74 |
1886 |
9864 |
10 |
74 |
2122 |
9865 |
10 |
74 |
2123 |
9865 |
10 |
74 |
2124 |
9865 |
10 |
74 |
2125 |
9865 |
10 |
74 |
2126 |
9865 |
10 |
74 |
2127 |
9866 |
10 |
74 |
2128 |
9866 |
10 |
74 |
2129 |
9866 |
10 |
74 |
2130 |
9866 |
10 |
74 |
2131 |
9866 |
10 |
74 |
2132 |
9863 |
10 |
74 |
2133 |
9863 |
10 |
74 |
2134 |
9863 |
10 |
74 |
2135 |
9863 |
10 |
74 |
2136 |
9863 |
10 |
74 |
2137 |
9899 |
10 |
74 |
2138 |
9899 |
10 |
74 |
2139 |
9899 |
10 |
74 |
2140 |
9899 |
10 |
74 |
2141 |
9899 |
10 |
74 |
2142 |
9900 |
10 |
74 |
2143 |
9900 |
10 |
74 |
2144 |
9900 |
10 |
74 |
2145 |
9900 |
10 |
74 |
2146 |
9900 |
10 |
74 |
2147 |
9902 |
10 |
74 |
2148 |
9902 |
10 |
74 |
2149 |
9902 |
10 |
74 |
2150 |
9902 |
10 |
74 |
2151 |
9902 |
10 |
74 |
2152 |
9904 |
10 |
74 |
2153 |
9904 |
10 |
74 |
2154 |
9904 |
10 |
74 |
2155 |
9904 |
10 |
74 |
2156 |
9905 |
10 |
74 |
2157 |
9905 |
10 |
74 |
2158 |
9905 |
10 |
74 |
2159 |
9905 |
10 |
74 |
2160 |
9905 |
10 |
74 |
2161 |
9904 |
10 |
74 |
2162 |
9864 |
10 |
74 |
2164 |
9864 |
10 |
74 |
2165 |
9864 |
10 |
74 |
2166 |
9864 |
10 |
73 |
1886 |
9802 |
10 |
73 |
2122 |
9801 |
10 |
73 |
2123 |
9802 |
10 |
73 |
2124 |
9803 |
10 |
73 |
2125 |
9804 |
10 |
73 |
2126 |
9805 |
10 |
73 |
2127 |
9801 |
10 |
73 |
2128 |
9802 |
10 |
73 |
2129 |
9803 |
10 |
73 |
2130 |
9804 |
10 |
73 |
2131 |
9805 |
10 |
73 |
2132 |
9801 |
10 |
73 |
2133 |
9802 |
10 |
73 |
2134 |
9803 |
10 |
73 |
2135 |
9804 |
10 |
73 |
2136 |
9805 |
10 |
73 |
2137 |
9801 |
10 |
73 |
2138 |
9802 |
10 |
73 |
2139 |
9803 |
10 |
73 |
2140 |
9804 |
10 |
73 |
2141 |
9805 |
10 |
73 |
2142 |
9801 |
10 |
73 |
2143 |
9802 |
10 |
73 |
2144 |
9803 |
10 |
73 |
2145 |
9804 |
10 |
73 |
2146 |
9805 |
10 |
73 |
2147 |
9801 |
10 |
73 |
2148 |
9802 |
10 |
73 |
2149 |
9803 |
10 |
73 |
2150 |
9804 |
10 |
73 |
2151 |
9805 |
10 |
73 |
2152 |
9801 |
10 |
73 |
2153 |
9802 |
10 |
73 |
2154 |
9803 |
10 |
73 |
2155 |
9804 |
10 |
73 |
2156 |
9801 |
10 |
73 |
2157 |
9802 |
10 |
73 |
2158 |
9803 |
10 |
73 |
2159 |
9804 |
10 |
73 |
2160 |
9805 |
10 |
73 |
2161 |
9805 |
10 |
73 |
2162 |
9801 |
10 |
73 |
2164 |
9803 |
10 |
73 |
2165 |
9804 |
10 |
73 |
2166 |
9805 |
10 |
74 |
2032 |
9899 |
18 |
74 |
2241 |
9899 |
18 |
74 |
2243 |
9899 |
18 |
74 |
2244 |
9899 |
18 |
74 |
2245 |
9899 |
18 |
74 |
2246 |
9900 |
18 |
74 |
2247 |
9900 |
18 |
74 |
2248 |
9900 |
18 |
74 |
2249 |
9900 |
18 |
74 |
2250 |
9900 |
18 |
73 |
2032 |
9802 |
18 |
73 |
2241 |
9801 |
18 |
73 |
2243 |
9803 |
18 |
73 |
2244 |
9804 |
18 |
73 |
2245 |
9805 |
18 |
73 |
2246 |
9801 |
18 |
73 |
2247 |
9802 |
18 |
73 |
2248 |
9803 |
18 |
73 |
2249 |
9804 |
18 |
73 |
2250 |
9805 |
18 |
73 |
2058 |
9801 |
19 |
73 |
2263 |
9802 |
19 |
73 |
2264 |
9803 |
19 |
73 |
2265 |
9804 |
19 |
73 |
2266 |
9805 |
19 |
74 |
2042 |
9899 |
20 |
74 |
2267 |
9866 |
20 |
74 |
2268 |
9866 |
20 |
74 |
2269 |
9866 |
20 |
74 |
2270 |
9866 |
20 |
74 |
2271 |
9863 |
20 |
74 |
2272 |
9863 |
20 |
74 |
2273 |
9863 |
20 |
74 |
2274 |
9863 |
20 |
74 |
2275 |
9899 |
20 |
74 |
2277 |
9899 |
20 |
74 |
2278 |
9899 |
20 |
74 |
2279 |
9900 |
20 |
74 |
2280 |
9900 |
20 |
74 |
2281 |
9900 |
20 |
74 |
2282 |
9900 |
20 |
73 |
2042 |
9802 |
20 |
73 |
2267 |
9801 |
20 |
73 |
2268 |
9802 |
20 |
73 |
2269 |
9803 |
20 |
73 |
2270 |
9804 |
20 |
73 |
2271 |
9801 |
20 |
73 |
2272 |
9802 |
20 |
73 |
2273 |
9803 |
20 |
73 |
2274 |
9804 |
20 |
73 |
2275 |
9801 |
20 |
73 |
2277 |
9803 |
20 |
73 |
2278 |
9804 |
20 |
73 |
2279 |
9801 |
20 |
73 |
2280 |
9802 |
20 |
73 |
2281 |
9803 |
20 |
73 |
2282 |
9804 |
20 |
73 |
2403 |
9801 |
23 |
73 |
2509 |
9802 |
23 |
73 |
2510 |
9803 |
23 |
73 |
2511 |
9804 |
23 |
73 |
2512 |
9805 |
23 |
73 |
2399 |
9802 |
24 |
73 |
2514 |
9803 |
24 |
73 |
2515 |
9804 |
24 |
73 |
2516 |
9805 |
24 |
73 |
2394 |
9804 |
25 |
73 |
2518 |
9805 |
25 |