Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

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 = ?

[
  375
]

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 = ?

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 = 375;

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3 FROM `user` u0_ LEFT JOIN infinity i1_ ON (i1_.infinity_user_id = u0_.id) WHERE i1_.serial_number = ? LIMIT 1

[
  "8C147DA04926"
]

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3
FROM
  `user` u0_
  LEFT JOIN infinity i1_ ON (i1_.infinity_user_id = u0_.id)
WHERE
  i1_.serial_number = ?
LIMIT
  1

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3 FROM `user` u0_ LEFT JOIN infinity i1_ ON (i1_.infinity_user_id = u0_.id) WHERE i1_.serial_number = '8C147DA04926' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.version AS version_3, t0.size_in_byte AS size_in_byte_4, t0.file AS file_5, t0.filename AS filename_6, t0.category_id AS category_id_7 FROM firmware t0 WHERE t0.id = ?

[
  20
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.version AS version_3,
  t0.size_in_byte AS size_in_byte_4,
  t0.file AS file_5,
  t0.filename AS filename_6,
  t0.category_id AS category_id_7
FROM
  firmware t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.version AS version_3, t0.size_in_byte AS size_in_byte_4, t0.file AS file_5, t0.filename AS filename_6, t0.category_id AS category_id_7 FROM firmware t0 WHERE t0.id = 20;

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.infinity_id = ?

[
  154
]

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.infinity_id = ?

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.infinity_id = 154;

SELECT t0.id AS id_1, t0.name AS name_2 FROM tag t0 INNER JOIN infinity_tag ON t0.id = infinity_tag.tag_id WHERE infinity_tag.infinity_id = ?

[
  154
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  tag t0
  INNER JOIN infinity_tag ON t0.id = infinity_tag.tag_id
WHERE
  infinity_tag.infinity_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM tag t0 INNER JOIN infinity_tag ON t0.id = infinity_tag.tag_id WHERE infinity_tag.infinity_id = 154;

SELECT t0.id AS id_1, t0.address AS address_2, t0.last_contact_supervisor AS last_contact_supervisor_3, t0.port_number_min AS port_number_min_4, t0.tunnels_total_max AS tunnels_total_max_5, t0.cpu_load_rate AS cpu_load_rate_6, t0.ram_load_rate AS ram_load_rate_7, t0.infinity_port AS infinity_port_8, t0.name AS name_9, t0.user_id AS user_id_10 FROM gateway t0 WHERE t0.id = ?

[
  44
]

SELECT
  t0.id AS id_1,
  t0.address AS address_2,
  t0.last_contact_supervisor AS last_contact_supervisor_3,
  t0.port_number_min AS port_number_min_4,
  t0.tunnels_total_max AS tunnels_total_max_5,
  t0.cpu_load_rate AS cpu_load_rate_6,
  t0.ram_load_rate AS ram_load_rate_7,
  t0.infinity_port AS infinity_port_8,
  t0.name AS name_9,
  t0.user_id AS user_id_10
FROM
  gateway t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.address AS address_2, t0.last_contact_supervisor AS last_contact_supervisor_3, t0.port_number_min AS port_number_min_4, t0.tunnels_total_max AS tunnels_total_max_5, t0.cpu_load_rate AS cpu_load_rate_6, t0.ram_load_rate AS ram_load_rate_7, t0.infinity_port AS infinity_port_8, t0.name AS name_9, t0.user_id AS user_id_10 FROM gateway t0 WHERE t0.id = 44;

SELECT i0_.id AS id_0, i0_.serial_number AS serial_number_1, i0_.charge_state AS charge_state_2, i0_.application_version AS application_version_3, i0_.bootloader_version AS bootloader_version_4, i0_.last_contact_supervisor AS last_contact_supervisor_5, i0_.status AS status_6, i0_.firmware_id AS firmware_id_7, i0_.infinity_user_id AS infinity_user_id_8, i0_.kpax_user_id AS kpax_user_id_9, i0_.messaging_server_id AS messaging_server_id_10 FROM infinity i0_ WHERE i0_.id = ?

[
  154
]

SELECT
  i0_.id AS id_0,
  i0_.serial_number AS serial_number_1,
  i0_.charge_state AS charge_state_2,
  i0_.application_version AS application_version_3,
  i0_.bootloader_version AS bootloader_version_4,
  i0_.last_contact_supervisor AS last_contact_supervisor_5,
  i0_.status AS status_6,
  i0_.firmware_id AS firmware_id_7,
  i0_.infinity_user_id AS infinity_user_id_8,
  i0_.kpax_user_id AS kpax_user_id_9,
  i0_.messaging_server_id AS messaging_server_id_10
FROM
  infinity i0_
WHERE
  i0_.id = ?

SELECT i0_.id AS id_0, i0_.serial_number AS serial_number_1, i0_.charge_state AS charge_state_2, i0_.application_version AS application_version_3, i0_.bootloader_version AS bootloader_version_4, i0_.last_contact_supervisor AS last_contact_supervisor_5, i0_.status AS status_6, i0_.firmware_id AS firmware_id_7, i0_.infinity_user_id AS infinity_user_id_8, i0_.kpax_user_id AS kpax_user_id_9, i0_.messaging_server_id AS messaging_server_id_10 FROM infinity i0_ WHERE i0_.id = 154;