Query time 0.00110
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "44.81"
},
"nested_loop": [
{
"table": {
"table_name": "p",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"idx_group_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"rows_examined_per_scan": 32,
"rows_produced_per_join": 32,
"filtered": "100.00",
"index_condition": "(`cscartdb`.`p`.`product_id` in (8458,8526,8544,8646,8073,8061,8683,8070,8724,8067,10982,8080,8723,8731,8522,8631,8713,8681,8705,8635,8075,8675,8632,8626,63370,13303,64621,64630,56363,64650,55075,64633))",
"cost_info": {
"read_cost": "19.21",
"eval_cost": "3.20",
"prefix_cost": "22.41",
"data_read_per_join": "512"
},
"used_columns": [
"product_id",
"parent_product_id",
"group_id"
]
}
},
{
"table": {
"table_name": "g",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"id"
],
"key_length": "3",
"ref": [
"cscartdb.p.group_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 32,
"filtered": "100.00",
"cost_info": {
"read_cost": "8.00",
"eval_cost": "3.20",
"prefix_cost": "33.61",
"data_read_per_join": "12K"
},
"used_columns": [
"id",
"code"
]
}
},
{
"table": {
"table_name": "f",
"access_type": "ref",
"possible_keys": [
"idx_group_id"
],
"key": "idx_group_id",
"used_key_parts": [
"group_id"
],
"key_length": "3",
"ref": [
"cscartdb.p.group_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 32,
"filtered": "100.00",
"cost_info": {
"read_cost": "8.00",
"eval_cost": "3.20",
"prefix_cost": "44.81",
"data_read_per_join": "3K"
},
"used_columns": [
"feature_id",
"purpose",
"group_id"
]
}
}
]
}
}
Result
feature_id |
purpose |
product_id |
parent_product_id |
id |
code |
155 |
group_variation_catalog_item |
8061 |
0 |
118 |
PV-AA7A80BDB |
157 |
group_variation_catalog_item |
8067 |
0 |
120 |
PV-E812DF240 |
154 |
group_variation_catalog_item |
8070 |
0 |
117 |
PV-822854C69 |
159 |
group_variation_catalog_item |
8073 |
0 |
122 |
PV-63E04F0E2 |
160 |
group_variation_catalog_item |
8075 |
0 |
123 |
PV-90E8D6E18 |
156 |
group_variation_catalog_item |
8080 |
0 |
119 |
PV-5A387F565 |
235 |
group_variation_catalog_item |
8458 |
0 |
293 |
PV-45CBA93D1 |
245 |
group_variation_catalog_item |
8522 |
0 |
307 |
PV-067193677 |
170 |
group_variation_catalog_item |
8526 |
0 |
138 |
PV-0561D9BCC |
171 |
group_variation_catalog_item |
8544 |
0 |
139 |
PV-DE2B41BC3 |
191 |
group_variation_catalog_item |
8675 |
0 |
158 |
PV-3D7AB2273 |
163 |
group_variation_catalog_item |
8681 |
0 |
126 |
PV-0613B4598 |
165 |
group_variation_catalog_item |
8683 |
0 |
137 |
PV-43A17F0A3 |
162 |
group_variation_catalog_item |
8705 |
0 |
125 |
PV-859798062 |
192 |
group_variation_catalog_item |
8713 |
0 |
160 |
PV-D3B91B03D |
197 |
group_variation_catalog_item |
8723 |
0 |
165 |
PV-5E0EE3A1E |
195 |
group_variation_catalog_item |
8724 |
0 |
163 |
PV-6980880D2 |
193 |
group_variation_catalog_item |
8731 |
0 |
161 |
PV-459AF6B98 |
194 |
group_variation_catalog_item |
10982 |
0 |
162 |
PV-7136450E8 |
236 |
group_variation_catalog_item |
13303 |
0 |
303 |
PV-8FB9FA59F |
1481 |
group_variation_catalog_item |
63370 |
0 |
2330 |
PV-5370321EC |
1490 |
group_variation_catalog_item |
64621 |
0 |
2546 |
PV-9B89CCD4E |
1491 |
group_variation_catalog_item |
64630 |
0 |
2547 |
PV-176909984 |