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 r0_.uuid AS uuid_0, r0_.operation_id AS operation_id_1, r0_.slug AS slug_2, r0_.priority AS priority_3, r0_.server_url AS server_url_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.acknowledged_at AS acknowledged_at_7, r0_.finished_at AS finished_at_8, r0_.executed_at AS executed_at_9, r0_.status AS status_10, r0_.error_code AS error_code_11, r0_.context_info AS context_info_12, r0_.created_by AS created_by_13, r0_.status_details AS status_details_14, r0_.infinity_id AS infinity_id_15 FROM remote_operation r0_ WHERE r0_.infinity_id = ? AND r0_.status = ? ORDER BY r0_.priority ASC, r0_.created_at ASC LIMIT 1

[
  154
  "not_started"
]

SELECT
  r0_.uuid AS uuid_0,
  r0_.operation_id AS operation_id_1,
  r0_.slug AS slug_2,
  r0_.priority AS priority_3,
  r0_.server_url AS server_url_4,
  r0_.created_at AS created_at_5,
  r0_.updated_at AS updated_at_6,
  r0_.acknowledged_at AS acknowledged_at_7,
  r0_.finished_at AS finished_at_8,
  r0_.executed_at AS executed_at_9,
  r0_.status AS status_10,
  r0_.error_code AS error_code_11,
  r0_.context_info AS context_info_12,
  r0_.created_by AS created_by_13,
  r0_.status_details AS status_details_14,
  r0_.infinity_id AS infinity_id_15
FROM
  remote_operation r0_
WHERE
  r0_.infinity_id = ?
  AND r0_.status = ?
ORDER BY
  r0_.priority ASC,
  r0_.created_at ASC
LIMIT
  1

SELECT r0_.uuid AS uuid_0, r0_.operation_id AS operation_id_1, r0_.slug AS slug_2, r0_.priority AS priority_3, r0_.server_url AS server_url_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.acknowledged_at AS acknowledged_at_7, r0_.finished_at AS finished_at_8, r0_.executed_at AS executed_at_9, r0_.status AS status_10, r0_.error_code AS error_code_11, r0_.context_info AS context_info_12, r0_.created_by AS created_by_13, r0_.status_details AS status_details_14, r0_.infinity_id AS infinity_id_15 FROM remote_operation r0_ WHERE r0_.infinity_id = 154 AND r0_.status = 'not_started' ORDER BY r0_.priority ASC, r0_.created_at ASC 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 = ? 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;