{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.16"
},
"nested_loop": [
{
"table": {
"table_name": "g",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"idx_group_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 2,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.26",
"eval_cost": "0.20",
"prefix_cost": "0.46",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"group_id"
]
}
},
{
"table": {
"table_name": "v",
"access_type": "ref",
"possible_keys": [
"idx_cscart_product_variation_variety"
],
"key": "idx_cscart_product_variation_variety",
"used_key_parts": [
"group_id",
"type"
],
"key_length": "7",
"ref": [
"cscartdb.g.group_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"index_condition": "(`cscartdb`.`v`.`group_id` = `cscartdb`.`g`.`group_id`)",
"cost_info": {
"read_cost": "0.50",
"eval_cost": "0.20",
"prefix_cost": "1.16",
"data_read_per_join": "1K"
},
"used_columns": [
"group_id",
"type",
"data"
]
}
}
]
}
}
data |
---|
{"4692":"160","4693":"160","4694":"160","4695":"175","4696":"175","4697":"190","4698":"190","4699":"90","4700":"90","4701":"90","4702":"105","4703":"105","4704":"120","4705":"120","4706":"240","4707":"240","4708":"240","4709":"265","4710":"265","4711":"285","4712":"285"} |