{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "27.30"
},
"table": {
"table_name": "cscart_product_variation_group_products",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"idx_group_id"
],
"key": "idx_group_id",
"used_key_parts": [
"group_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 78,
"rows_produced_per_join": 78,
"filtered": "100.00",
"cost_info": {
"read_cost": "19.50",
"eval_cost": "7.80",
"prefix_cost": "27.30",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"group_id"
]
}
}
}
product_id |
---|
18825 |
57470 |
57471 |
57472 |
57473 |
57474 |
57475 |
57476 |
57477 |
57478 |
57479 |
57480 |
57481 |
57482 |
57483 |
57484 |
57485 |
57486 |
57487 |
57488 |
57489 |
57490 |
57491 |
57492 |
57493 |
57494 |
57495 |
57496 |
57497 |
57498 |
57499 |
57500 |
57501 |
57502 |
57503 |
57504 |
57505 |
57506 |
57507 |
57508 |
57509 |
57510 |
57511 |
57512 |
57513 |
57514 |
57515 |
57516 |
57517 |
57518 |
57519 |
57520 |
57521 |
57522 |
57523 |
57524 |
57525 |
57526 |
57527 |
57528 |
57529 |
57530 |
57531 |
57532 |
57533 |
57534 |
57535 |
57536 |
57537 |
57538 |
57539 |
57540 |
57541 |
57542 |
57543 |
57544 |
57545 |
57546 |
57547 |
57548 |
57549 |
57550 |
57551 |
57552 |
57553 |
57554 |
57555 |
57556 |
57557 |
57558 |