Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.mac_address AS mac_address_2,
  t0.name AS name_3,
  t0.ip_address AS ip_address_4,
  t0.ip_vpn AS ip_vpn_5,
  t0.disable_upgrades AS disable_upgrades_6,
  t0.update_to_version AS update_to_version_7,
  t0.need_config_update AS need_config_update_8,
  t0.software_version AS software_version_9,
  t0.hardware_id AS hardware_id_10,
  t0.software_id AS software_id_11,
  t0.token AS token_12,
  t0.last_consumption_reset AS last_consumption_reset_13,
  t0.last_screenshot_name AS last_screenshot_name_14,
  t0.last_screenshot_updated_at AS last_screenshot_updated_at_15,
  t0.last_known_status AS last_known_status_16,
  t0.last_status_update AS last_status_update_17,
  t0.last_unreachable_alert AS last_unreachable_alert_18,
  t0.data_consumption AS data_consumption_19,
  t0.network_quality AS network_quality_20,
  t0.router AS router_21,
  t0.imsi AS imsi_22,
  t0.update_tokens AS update_tokens_23,
  t0.registration AS registration_24,
  t0.environment_server AS environment_server_25,
  t0.entrance_id AS entrance_id_26
FROM
  thin_client t0
WHERE
  t0.software_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.mac_address AS mac_address_2, t0.name AS name_3, t0.ip_address AS ip_address_4, t0.ip_vpn AS ip_vpn_5, t0.disable_upgrades AS disable_upgrades_6, t0.update_to_version AS update_to_version_7, t0.need_config_update AS need_config_update_8, t0.software_version AS software_version_9, t0.hardware_id AS hardware_id_10, t0.software_id AS software_id_11, t0.token AS token_12, t0.last_consumption_reset AS last_consumption_reset_13, t0.last_screenshot_name AS last_screenshot_name_14, t0.last_screenshot_updated_at AS last_screenshot_updated_at_15, t0.last_known_status AS last_known_status_16, t0.last_status_update AS last_status_update_17, t0.last_unreachable_alert AS last_unreachable_alert_18, t0.data_consumption AS data_consumption_19, t0.network_quality AS network_quality_20, t0.router AS router_21, t0.imsi AS imsi_22, t0.update_tokens AS update_tokens_23, t0.registration AS registration_24, t0.environment_server AS environment_server_25, t0.entrance_id AS entrance_id_26 FROM thin_client t0 WHERE t0.software_id = 'nuc-7760d05b-358c-455d-b69a-13676ef53756' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  thin_client
SET
  ip_vpn = ?,
  last_status_update = ?
WHERE
  id = ?

UPDATE thin_client SET ip_vpn = '{\"timestamp\":1770242400,\"value\":2}', last_status_update = '2026-02-04 03:30:30' WHERE id = 3875;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  thin_client
SET
  update_tokens = ?
WHERE
  id = ?

UPDATE thin_client SET update_tokens = '\"{\\\"technical_data\\\":{\\\"token\\\":1766499152},\\\"launcher_grid\\\":{\\\"token\\\":1767110378},\\\"screen_background\\\":{\\\"token\\\":1766504521},\\\"screen_logo\\\":{\\\"token\\\":1766499151},\\\"messages\\\":{\\\"token\\\":1767110378},\\\"pages\\\":{\\\"token\\\":1769699006},\\\"useful_contacts\\\":{\\\"token\\\":1766504937},\\\"signage\\\":{\\\"token\\\":1766504937},\\\"weather\\\":{\\\"token\\\":1770242400},\\\"transport\\\":{\\\"token\\\":1770239580},\\\"energy\\\":{\\\"token\\\":1770172230},\\\"survey\\\":{\\\"token\\\":1766499152},\\\"epices\\\":{\\\"token\\\":1770159612}}\"' WHERE id = 3875;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.polling_frequency AS polling_frequency_3,
  t0.grid_rows AS grid_rows_4,
  t0.grid_columns AS grid_columns_5,
  t0.grid_modules_list AS grid_modules_list_6,
  t0.specific_modules_config AS specific_modules_config_7,
  t0.exchange_host AS exchange_host_8,
  t0.exchange_login AS exchange_login_9,
  t0.exchange_pass AS exchange_pass_10,
  t0.exchange_calendar_content AS exchange_calendar_content_11,
  t0.update_token AS update_token_12,
  t0.wifi_enabled AS wifi_enabled_13,
  t0.enable_exchange_calendar AS enable_exchange_calendar_14,
  t0.wifi_ssid AS wifi_ssid_15,
  t0.wifi_passphrase AS wifi_passphrase_16,
  t0.customer_data AS customer_data_17,
  t0.placement_feature_activated AS placement_feature_activated_18,
  t0.residence_id AS residence_id_19,
  t20.id AS id_21,
  t20.mac_address AS mac_address_22,
  t20.name AS name_23,
  t20.ip_address AS ip_address_24,
  t20.ip_vpn AS ip_vpn_25,
  t20.disable_upgrades AS disable_upgrades_26,
  t20.update_to_version AS update_to_version_27,
  t20.need_config_update AS need_config_update_28,
  t20.software_version AS software_version_29,
  t20.hardware_id AS hardware_id_30,
  t20.software_id AS software_id_31,
  t20.token AS token_32,
  t20.last_consumption_reset AS last_consumption_reset_33,
  t20.last_screenshot_name AS last_screenshot_name_34,
  t20.last_screenshot_updated_at AS last_screenshot_updated_at_35,
  t20.last_known_status AS last_known_status_36,
  t20.last_status_update AS last_status_update_37,
  t20.last_unreachable_alert AS last_unreachable_alert_38,
  t20.data_consumption AS data_consumption_39,
  t20.network_quality AS network_quality_40,
  t20.router AS router_41,
  t20.imsi AS imsi_42,
  t20.update_tokens AS update_tokens_43,
  t20.registration AS registration_44,
  t20.environment_server AS environment_server_45,
  t20.entrance_id AS entrance_id_46,
  t47.id AS id_48,
  t47.night_mode AS night_mode_49,
  t47.home_page_display AS home_page_display_50,
  t47.suspend_time AS suspend_time_51,
  t47.restore_time AS restore_time_52,
  t47.organization_id AS organization_id_53,
  t47.residence_id AS residence_id_54,
  t47.entrance_id AS entrance_id_55,
  t47.organization_id AS organization_id_56,
  t47.residence_id AS residence_id_57,
  t47.entrance_id AS entrance_id_58
FROM
  entrance t0
  LEFT JOIN thin_client t20 ON t20.entrance_id = t0.id
  LEFT JOIN screen_config t47 ON t47.entrance_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.polling_frequency AS polling_frequency_3, t0.grid_rows AS grid_rows_4, t0.grid_columns AS grid_columns_5, t0.grid_modules_list AS grid_modules_list_6, t0.specific_modules_config AS specific_modules_config_7, t0.exchange_host AS exchange_host_8, t0.exchange_login AS exchange_login_9, t0.exchange_pass AS exchange_pass_10, t0.exchange_calendar_content AS exchange_calendar_content_11, t0.update_token AS update_token_12, t0.wifi_enabled AS wifi_enabled_13, t0.enable_exchange_calendar AS enable_exchange_calendar_14, t0.wifi_ssid AS wifi_ssid_15, t0.wifi_passphrase AS wifi_passphrase_16, t0.customer_data AS customer_data_17, t0.placement_feature_activated AS placement_feature_activated_18, t0.residence_id AS residence_id_19, t20.id AS id_21, t20.mac_address AS mac_address_22, t20.name AS name_23, t20.ip_address AS ip_address_24, t20.ip_vpn AS ip_vpn_25, t20.disable_upgrades AS disable_upgrades_26, t20.update_to_version AS update_to_version_27, t20.need_config_update AS need_config_update_28, t20.software_version AS software_version_29, t20.hardware_id AS hardware_id_30, t20.software_id AS software_id_31, t20.token AS token_32, t20.last_consumption_reset AS last_consumption_reset_33, t20.last_screenshot_name AS last_screenshot_name_34, t20.last_screenshot_updated_at AS last_screenshot_updated_at_35, t20.last_known_status AS last_known_status_36, t20.last_status_update AS last_status_update_37, t20.last_unreachable_alert AS last_unreachable_alert_38, t20.data_consumption AS data_consumption_39, t20.network_quality AS network_quality_40, t20.router AS router_41, t20.imsi AS imsi_42, t20.update_tokens AS update_tokens_43, t20.registration AS registration_44, t20.environment_server AS environment_server_45, t20.entrance_id AS entrance_id_46, t47.id AS id_48, t47.night_mode AS night_mode_49, t47.home_page_display AS home_page_display_50, t47.suspend_time AS suspend_time_51, t47.restore_time AS restore_time_52, t47.organization_id AS organization_id_53, t47.residence_id AS residence_id_54, t47.entrance_id AS entrance_id_55, t47.organization_id AS organization_id_56, t47.residence_id AS residence_id_57, t47.entrance_id AS entrance_id_58 FROM entrance t0 LEFT JOIN thin_client t20 ON t20.entrance_id = t0.id LEFT JOIN screen_config t47 ON t47.entrance_id = t0.id WHERE t0.id = 4038;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_to_display AS name_to_display_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.zipcode AS zipcode_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.has_socialad AS has_socialad_9,
  t0.has_incident AS has_incident_10,
  t0.has_private_message AS has_private_message_11,
  t0.electric_service_email AS electric_service_email_12,
  t0.plumbing_service_email AS plumbing_service_email_13,
  t0.gaz_service_email AS gaz_service_email_14,
  t0.heating_service_email AS heating_service_email_15,
  t0.intercom_service_email AS intercom_service_email_16,
  t0.tv_service_email AS tv_service_email_17,
  t0.customer_data AS customer_data_18,
  t0.default_grid_rows AS default_grid_rows_19,
  t0.default_grid_columns AS default_grid_columns_20,
  t0.default_grid_modules_list AS default_grid_modules_list_21,
  t0.specific_modules_config AS specific_modules_config_22,
  t0.epices_token_api AS epices_token_api_23,
  t0.epices_residence_id AS epices_residence_id_24,
  t0.idealys_residence_id AS idealys_residence_id_25,
  t0.organization_id AS organization_id_26,
  t27.id AS id_28,
  t27.night_mode AS night_mode_29,
  t27.home_page_display AS home_page_display_30,
  t27.suspend_time AS suspend_time_31,
  t27.restore_time AS restore_time_32,
  t27.organization_id AS organization_id_33,
  t27.residence_id AS residence_id_34,
  t27.entrance_id AS entrance_id_35,
  t27.organization_id AS organization_id_36,
  t27.residence_id AS residence_id_37,
  t27.entrance_id AS entrance_id_38
FROM
  residence t0
  LEFT JOIN screen_config t27 ON t27.residence_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_to_display AS name_to_display_3, t0.address AS address_4, t0.city AS city_5, t0.zipcode AS zipcode_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.has_socialad AS has_socialad_9, t0.has_incident AS has_incident_10, t0.has_private_message AS has_private_message_11, t0.electric_service_email AS electric_service_email_12, t0.plumbing_service_email AS plumbing_service_email_13, t0.gaz_service_email AS gaz_service_email_14, t0.heating_service_email AS heating_service_email_15, t0.intercom_service_email AS intercom_service_email_16, t0.tv_service_email AS tv_service_email_17, t0.customer_data AS customer_data_18, t0.default_grid_rows AS default_grid_rows_19, t0.default_grid_columns AS default_grid_columns_20, t0.default_grid_modules_list AS default_grid_modules_list_21, t0.specific_modules_config AS specific_modules_config_22, t0.epices_token_api AS epices_token_api_23, t0.epices_residence_id AS epices_residence_id_24, t0.idealys_residence_id AS idealys_residence_id_25, t0.organization_id AS organization_id_26, t27.id AS id_28, t27.night_mode AS night_mode_29, t27.home_page_display AS home_page_display_30, t27.suspend_time AS suspend_time_31, t27.restore_time AS restore_time_32, t27.organization_id AS organization_id_33, t27.residence_id AS residence_id_34, t27.entrance_id AS entrance_id_35, t27.organization_id AS organization_id_36, t27.residence_id AS residence_id_37, t27.entrance_id AS entrance_id_38 FROM residence t0 LEFT JOIN screen_config t27 ON t27.residence_id = t0.id WHERE t0.id = 2070;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  thin_client
SET
  update_tokens = ?
WHERE
  id = ?

UPDATE thin_client SET update_tokens = '\"{\\\"technical_data\\\":{\\\"token\\\":1766499152},\\\"launcher_grid\\\":{\\\"token\\\":1767110378},\\\"screen_background\\\":{\\\"token\\\":1766504521},\\\"screen_logo\\\":{\\\"token\\\":1766499151},\\\"messages\\\":{\\\"token\\\":1767110378},\\\"pages\\\":{\\\"token\\\":1769699006},\\\"useful_contacts\\\":{\\\"token\\\":1766504937},\\\"signage\\\":{\\\"token\\\":1766504937},\\\"weather\\\":{\\\"token\\\":1770242400},\\\"transport\\\":{\\\"token\\\":1770239580},\\\"energy\\\":{\\\"token\\\":1770172230},\\\"survey\\\":{\\\"token\\\":1766499152},\\\"epices\\\":{\\\"token\\\":1770172230}}\"' WHERE id = 3875;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.operation AS operation_2,
  t0.args AS args_3,
  t0.date_asked AS date_asked_4,
  t0.date_success AS date_success_5,
  t0.status AS status_6,
  t0.thinclient_id AS thinclient_id_7
FROM
  thinclient_command t0
WHERE
  t0.thinclient_id = ?

SELECT t0.id AS id_1, t0.operation AS operation_2, t0.args AS args_3, t0.date_asked AS date_asked_4, t0.date_success AS date_success_5, t0.status AS status_6, t0.thinclient_id AS thinclient_id_7 FROM thinclient_command t0 WHERE t0.thinclient_id = 3875;