Query time 0.00132
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "71.16"
},
"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": 51,
"rows_produced_per_join": 51,
"filtered": "100.00",
"index_condition": "(`cscartdb`.`p`.`product_id` in (16666,16941,16927,16665,16930,16799,16685,16660,26620,16928,16709,16798,16929,17379,16745,19139,16694,19079,16931,19134,16961,16712,19151,16655,16729,19294,16768,16845,26799,19220,16743,19069,18910,16049,18489,19187,19300,19203,18997,18896,17145,16967,16663,19254,16719,18825,19105,16805,19233,16746))",
"cost_info": {
"read_cost": "30.36",
"eval_cost": "5.10",
"prefix_cost": "35.46",
"data_read_per_join": "816"
},
"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": 51,
"filtered": "100.00",
"cost_info": {
"read_cost": "12.75",
"eval_cost": "5.10",
"prefix_cost": "53.31",
"data_read_per_join": "19K"
},
"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": 51,
"filtered": "100.00",
"cost_info": {
"read_cost": "12.75",
"eval_cost": "5.10",
"prefix_cost": "71.16",
"data_read_per_join": "5K"
},
"used_columns": [
"feature_id",
"purpose",
"group_id"
]
}
}
]
}
}
Result
feature_id |
purpose |
product_id |
parent_product_id |
id |
code |
289 |
group_variation_catalog_item |
16049 |
0 |
1147 |
PV-B31096EFF |
306 |
group_variation_catalog_item |
17145 |
0 |
562 |
PV-B5AE6E122 |
1199 |
group_variation_catalog_item |
17379 |
0 |
1445 |
PV-4F9E804D4 |
345 |
group_variation_catalog_item |
18489 |
0 |
1830 |
PV-24904DE1B |
1392 |
group_variation_catalog_item |
18489 |
0 |
1830 |
PV-24904DE1B |
345 |
group_variation_catalog_item |
18825 |
0 |
1967 |
PV-4B5C0CEF8 |
1392 |
group_variation_catalog_item |
18825 |
0 |
1967 |
PV-4B5C0CEF8 |
347 |
group_variation_catalog_item |
18896 |
0 |
1217 |
PV-8E9430BB8 |
345 |
group_variation_catalog_item |
18896 |
0 |
1217 |
PV-8E9430BB8 |
1086 |
group_variation_catalog_item |
18910 |
0 |
1194 |
PV-B8DFBB8F7 |
345 |
group_variation_catalog_item |
18910 |
0 |
1194 |
PV-B8DFBB8F7 |
347 |
group_variation_catalog_item |
18997 |
0 |
1222 |
PV-417378AB9 |
345 |
group_variation_catalog_item |
18997 |
0 |
1222 |
PV-417378AB9 |
347 |
group_variation_catalog_item |
19069 |
0 |
1224 |
PV-1A8C631DD |
345 |
group_variation_catalog_item |
19069 |
0 |
1224 |
PV-1A8C631DD |
345 |
group_variation_catalog_item |
19079 |
0 |
1850 |
PV-E26F2E64F |
1392 |
group_variation_catalog_item |
19079 |
0 |
1850 |
PV-E26F2E64F |
348 |
group_variation_catalog_item |
19105 |
0 |
1190 |
PV-A853B06A7 |
345 |
group_variation_catalog_item |
19105 |
0 |
1190 |
PV-A853B06A7 |
347 |
group_variation_catalog_item |
19134 |
0 |
1226 |
PV-2CDFC00F9 |
345 |
group_variation_catalog_item |
19134 |
0 |
1226 |
PV-2CDFC00F9 |
347 |
group_variation_catalog_item |
19139 |
0 |
1181 |
PV-63DD8733E |
345 |
group_variation_catalog_item |
19139 |
0 |
1181 |
PV-63DD8733E |
347 |
group_variation_catalog_item |
19151 |
0 |
1399 |
PV-C51C100EF |
345 |
group_variation_catalog_item |
19151 |
0 |
1399 |
PV-C51C100EF |
348 |
group_variation_catalog_item |
19187 |
0 |
1417 |
PV-AB749F3DB |
345 |
group_variation_catalog_item |
19187 |
0 |
1417 |
PV-AB749F3DB |
345 |
group_variation_catalog_item |
19203 |
0 |
1855 |
PV-8211E5442 |
1392 |
group_variation_catalog_item |
19203 |
0 |
1855 |
PV-8211E5442 |
1083 |
group_variation_catalog_item |
19220 |
0 |
1200 |
PV-CB2426701 |
345 |
group_variation_catalog_item |
19220 |
0 |
1200 |
PV-CB2426701 |
345 |
group_variation_catalog_item |
19233 |
0 |
1962 |
PV-79C7B150A |
1392 |
group_variation_catalog_item |
19233 |
0 |
1962 |
PV-79C7B150A |
348 |
group_variation_catalog_item |
19254 |
0 |
1270 |
PV-681C6F863 |
345 |
group_variation_catalog_item |
19254 |
0 |
1270 |
PV-681C6F863 |
347 |
group_variation_catalog_item |
19294 |
0 |
1245 |
PV-FC7CC11F2 |
345 |
group_variation_catalog_item |
19294 |
0 |
1245 |
PV-FC7CC11F2 |
347 |
group_variation_catalog_item |
19300 |
0 |
1185 |
PV-87C5AAB41 |
345 |
group_variation_catalog_item |
19300 |
0 |
1185 |
PV-87C5AAB41 |
1071 |
group_variation_catalog_item |
26620 |
0 |
1127 |
PV-EAC17D576 |
1071 |
group_variation_catalog_item |
26799 |
0 |
1132 |
PV-C9E6CC1DF |