mysql> select * from floatingips where floating_ip_address='10.2.5.124'\G
*************************** 1. row ***************************
           tenant_id: 7743a957d1f442c8ac9733920d99746d
                  id: c2ff9103-8c53-402d-8c71-58979fc12806
 floating_ip_address: 10.2.5.124
 floating_network_id: 01a50629-53bf-4bfb-b411-3fdb2aa1a17f
    floating_port_id: ce5a163b-b56a-41e1-98e0-6ecec00e21c7
       fixed_port_id: fe1322f5-f586-4a59-bbed-9791e23ede56
    fixed_ip_address: 192.168.144.41
           router_id: e61bbbab-4c3f-4594-a23c-7e503d56567e
last_known_router_id: NULL
              status: ACTIVE
1 row in set (0.01 sec)

mysql> select * from ml2_port_bindings where port_id='fe1322f5-f586-4a59-bbed-9791e23ede56'\G
*************************** 1. row ***************************
    port_id: fe1322f5-f586-4a59-bbed-9791e23ede56
       host: bxcloudcompute03
   vif_type: ovs
     driver: openvswitch
    segment: 155ddd3f-b406-4513-9bc5-fa3e25d4835e
  vnic_type: normal
vif_details:
    profile:
1 row in set (0.00 sec)