Query time 0.00136
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 (20775,16163,14142,16150,20824,20773,20809,20789,14214,14229,20778,14262,14194,20735,14212,14216,14237,14177,20793,14164,14172,20790,14238,32164,14158,14225,14263,14204,14154,20758,21008,20801,20882,20745,14221,20929,21068,20932,20812,20852,20725,14206,14191,20823,20923,20797,20802,20884,20853,20815))",
"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 |
266 |
group_variation_catalog_item |
14154 |
0 |
346 |
PV-221B78291 |
266 |
group_variation_catalog_item |
14164 |
0 |
350 |
PV-5EAA618EE |
266 |
group_variation_catalog_item |
14172 |
0 |
355 |
PV-D66CFE5DE |
266 |
group_variation_catalog_item |
14177 |
0 |
354 |
PV-4A21A1FD3 |
266 |
group_variation_catalog_item |
14191 |
0 |
358 |
PV-0EA314DD4 |
266 |
group_variation_catalog_item |
14194 |
0 |
359 |
PV-04ABB872A |
266 |
group_variation_catalog_item |
14204 |
0 |
361 |
PV-722C222DE |
266 |
group_variation_catalog_item |
14214 |
0 |
363 |
PV-CDA038A83 |
266 |
group_variation_catalog_item |
14216 |
0 |
364 |
PV-06E106DAA |
266 |
group_variation_catalog_item |
14221 |
0 |
366 |
PV-1D999DFF2 |
266 |
group_variation_catalog_item |
14225 |
0 |
368 |
PV-8CB767263 |
266 |
group_variation_catalog_item |
14262 |
0 |
369 |
PV-A53D6F855 |
266 |
group_variation_catalog_item |
14263 |
0 |
370 |
PV-0D67F9379 |
1482 |
group_variation_catalog_item |
20725 |
0 |
2390 |
PV-603B104E2 |
1482 |
group_variation_catalog_item |
20735 |
0 |
2368 |
PV-A7A183141 |
1482 |
group_variation_catalog_item |
20745 |
0 |
2384 |
PV-A2FF757C7 |
1482 |
group_variation_catalog_item |
20758 |
0 |
2381 |
PV-F09A06622 |
1482 |
group_variation_catalog_item |
20773 |
0 |
2364 |
PV-14196247E |
1482 |
group_variation_catalog_item |
20775 |
0 |
2360 |
PV-4BAD1E53D |
1482 |
group_variation_catalog_item |
20778 |
0 |
2365 |
PV-59F81D61F |
1482 |
group_variation_catalog_item |
20789 |
0 |
2363 |
PV-98AABA8F0 |
1482 |
group_variation_catalog_item |
20790 |
0 |
2375 |
PV-CFED4FDE0 |
1482 |
group_variation_catalog_item |
20793 |
0 |
2371 |
PV-B44203E97 |
1482 |
group_variation_catalog_item |
20797 |
0 |
2396 |
PV-7992F9836 |
1482 |
group_variation_catalog_item |
20801 |
0 |
2383 |
PV-2C270D250 |
1482 |
group_variation_catalog_item |
20802 |
0 |
2400 |
PV-D556A4E6B |
1482 |
group_variation_catalog_item |
20809 |
0 |
2362 |
PV-91354AD68 |
1482 |
group_variation_catalog_item |
20812 |
0 |
2391 |
PV-125103613 |
1482 |
group_variation_catalog_item |
20815 |
0 |
2403 |
PV-8D7EBB867 |
1482 |
group_variation_catalog_item |
20823 |
0 |
2401 |
PV-66CA1EEDA |
1482 |
group_variation_catalog_item |
20824 |
0 |
2361 |
PV-2A767A522 |
1482 |
group_variation_catalog_item |
20852 |
0 |
2392 |
PV-34E2E7C0C |
1482 |
group_variation_catalog_item |
20853 |
0 |
2405 |
PV-EDE175D8A |
1482 |
group_variation_catalog_item |
20882 |
0 |
2387 |
PV-97986AE3A |
1482 |
group_variation_catalog_item |
20884 |
0 |
2407 |
PV-E0A324649 |
1482 |
group_variation_catalog_item |
20923 |
0 |
2398 |
PV-88C594F7E |
1482 |
group_variation_catalog_item |
20929 |
0 |
2386 |
PV-8D57601A4 |
1482 |
group_variation_catalog_item |
20932 |
0 |
2393 |
PV-2DC0440EE |
1482 |
group_variation_catalog_item |
21008 |
0 |
2382 |
PV-DF5606BC9 |
1482 |
group_variation_catalog_item |
21068 |
0 |
2385 |
PV-472F7E7F5 |