GET https://supervisor-1.dev.infinity.kpax.cloud/api/tunnels/3166/request-state

Query Metrics

2 Database Queries
2 Different statements
0.00 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.26 ms
(50.28%)
1
SELECT t0.id AS id_1, t0.user_port_number AS user_port_number_2, t0.user_port_state AS user_port_state_3, t0.destination_ip AS destination_ip_4, t0.destination_port AS destination_port_5, t0.protocol AS protocol_6, t0.secret_token AS secret_token_7, t0.infinity_id AS infinity_id_8, t0.gateway_id AS gateway_id_9 FROM tunnel t0 WHERE t0.id = ?
Parameters:
[
  "3166"
]
0.25 ms
(49.72%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t5.id AS id_6, t5.address AS address_7, t5.last_contact_supervisor AS last_contact_supervisor_8, t5.port_number_min AS port_number_min_9, t5.tunnels_total_max AS tunnels_total_max_10, t5.cpu_load_rate AS cpu_load_rate_11, t5.ram_load_rate AS ram_load_rate_12, t5.infinity_port AS infinity_port_13, t5.name AS name_14, t5.user_id AS user_id_15, t16.id AS id_17, t16.serial_number AS serial_number_18, t16.charge_state AS charge_state_19, t16.application_version AS application_version_20, t16.bootloader_version AS bootloader_version_21, t16.last_contact_supervisor AS last_contact_supervisor_22, t16.status AS status_23, t16.firmware_id AS firmware_id_24, t16.infinity_user_id AS infinity_user_id_25, t16.kpax_user_id AS kpax_user_id_26, t16.messaging_server_id AS messaging_server_id_27 FROM `user` t0 LEFT JOIN gateway t5 ON t5.user_id = t0.id LEFT JOIN infinity t16 ON t16.infinity_user_id = t0.id WHERE t0.id = ?
Parameters:
[
  308
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Tunnel No errors.
App\Entity\Infinity No errors.
App\Entity\Gateway No errors.
App\Entity\User No errors.
App\Entity\Firmware No errors.
App\Entity\MessagingServer No errors.