POST https://iplocator.yeebill.net/api/ip/get-info

Query Metrics

5 Database Queries
5 Different statements
3.81 ms Query time
0 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 0.27 ms
SELECT t0.id AS id_1, t0.uname AS uname_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_stamp AS created_stamp_6, t0.deleted_stamp AS deleted_stamp_7, t0.lastlogin_stamp AS lastlogin_stamp_8, t0.lastlogin_agent AS lastlogin_agent_9 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "as@iplocator.yeebill.net"
]
2 0.15 ms
"START TRANSACTION"
Parameters:
[]
3 0.24 ms
UPDATE `user` SET lastlogin_stamp = ? WHERE id = ?
Parameters:
[
  1784642408
  2
]
4 0.36 ms
"COMMIT"
Parameters:
[]
5 2.79 ms
SELECT r0_.id AS id_0, r0_.created_stamp AS created_stamp_1, r0_.ip_address AS ip_address_2, r0_.as_number AS as_number_3, r0_.as_country AS as_country_4, r0_.as_description AS as_description_5, r0_.vpn AS vpn_6, r0_.consumer AS consumer_7, r0_.caller_id AS caller_id_8, r0_.config_id AS config_id_9 FROM request r0_ WHERE r0_.ip_address = ? AND r0_.config_id IS NOT NULL ORDER BY r0_.created_stamp DESC LIMIT 1
Parameters:
[
  "71.229.43.123"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 1
App\Entity\Request 1
App\Entity\Config 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Request No errors.
App\Entity\Config No errors.