Symfony Profiler

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.id AS id_3,
  t0.sensor_id AS sensor_id_4,
  t0.phone AS phone_5,
  t0.email AS email_6,
  t0.state AS state_7,
  t0.start_of_monitoring AS start_of_monitoring_8,
  t0.sim_number AS sim_number_9,
  t0.provider AS provider_10,
  t0.lte_valid_until AS lte_valid_until_11,
  t0.last_online AS last_online_12,
  t0.installed AS installed_13,
  t0.serial AS serial_14,
  t0.observer_last_online AS observer_last_online_15,
  t0.name AS name_16,
  t0.observer_version AS observer_version_17,
  t0.observer_state AS observer_state_18,
  t0.port AS port_19,
  t0.tga_hash AS tga_hash_20,
  t0.pending_command AS pending_command_21,
  t0.update_started_at AS update_started_at_22,
  t0.update_status AS update_status_23,
  t0.connection_type AS connection_type_24,
  t0.connection_type_override AS connection_type_override_25,
  t0.router_mac AS router_mac_26,
  t0.connection_checked_at AS connection_checked_at_27,
  t0.trade_id AS trade_id_28,
  t29.created_at AS created_at_30,
  t29.updated_at AS updated_at_31,
  t29.id AS id_32,
  t29.name AS name_33,
  t29.state AS state_34,
  t29.manufacturer_number AS manufacturer_number_35,
  t29.build_year AS build_year_36,
  t29.stops AS stops_37,
  t29.height AS height_38,
  t29.last_zues AS last_zues_39,
  t29.next_zues AS next_zues_40,
  t29.last_inspection AS last_inspection_41,
  t29.last_maintenance AS last_maintenance_42,
  t29.payload AS payload_43,
  t29.drive_type AS drive_type_44,
  t29.two_sided AS two_sided_45,
  t29.speed AS speed_46,
  t29.next_maintenance AS next_maintenance_47,
  t29.awm_state AS awm_state_48,
  t29.tuev_state AS tuev_state_49,
  t29.last_zues_type AS last_zues_type_50,
  t29.pnae_result AS pnae_result_51,
  t29.doors_have_measuring_point AS doors_have_measuring_point_52,
  t29.trip_value AS trip_value_53,
  t29.door_value AS door_value_54,
  t29.cabinlight_value AS cabinlight_value_55,
  t29.flushness_value AS flushness_value_56,
  t29.power_value AS power_value_57,
  t29.sk_front_value AS sk_front_value_58,
  t29.sk_back_value AS sk_back_value_59,
  t29.sk_hoist_value AS sk_hoist_value_60,
  t29.collective_disorder_value AS collective_disorder_value_61,
  t29.sap_nr AS sap_nr_62,
  t29.tuev_nr AS tuev_nr_63,
  t29.type_of_elevator AS type_of_elevator_64,
  t29.door_counter_divider AS door_counter_divider_65,
  t29.tga_hash AS tga_hash_66,
  t29.time_to_escalate_zues AS time_to_escalate_zues_67,
  t29.time_to_escalate_awm AS time_to_escalate_awm_68,
  t29.time_to_escalate_bs AS time_to_escalate_bs_69,
  t29.zues_disposal_until AS zues_disposal_until_70,
  t29.zues_disposal AS zues_disposal_71,
  t29.zues712 AS zues712_72,
  t29.zues_verfification AS zues_verfification_73,
  t29.zues_verfification_date AS zues_verfification_date_74,
  t29.technical_place AS technical_place_75,
  t29.has_warning AS has_warning_76,
  t29.repair_start AS repair_start_77,
  t29.maintenance_start AS maintenance_start_78,
  t29.zues_start AS zues_start_79,
  t29.repair_renewal_minutes AS repair_renewal_minutes_80,
  t29.maintenance_renewal_minutes AS maintenance_renewal_minutes_81,
  t29.zues_renewal_minutes AS zues_renewal_minutes_82,
  t29.power_failure AS power_failure_83,
  t29.sc_front_doors_failure AS sc_front_doors_failure_84,
  t29.collective_disorder_failure AS collective_disorder_failure_85,
  t29.state_lis AS state_lis_86,
  t29.send_to_api AS send_to_api_87,
  t29.intercorp_enabled AS intercorp_enabled_88,
  t29.smoke_extraction_collective_disorder AS smoke_extraction_collective_disorder_89,
  t29.comment AS comment_90,
  t29.control_link AS control_link_91,
  t29.bs_date AS bs_date_92,
  t29.anomaly_count AS anomaly_count_93,
  t29.water_level_warning AS water_level_warning_94,
  t29.has_waterlevel_warning AS has_waterlevel_warning_95,
  t29.awm_compatible AS awm_compatible_96,
  t29.els1_mqtt_host AS els1_mqtt_host_97,
  t29.els1_mqtt_port AS els1_mqtt_port_98,
  t29.els1_mqtt_psk_identity AS els1_mqtt_psk_identity_99,
  t29.els1_mqtt_psk AS els1_mqtt_psk_100,
  t29.awm_connect_id AS awm_connect_id_101,
  t29.has_awm_connect AS has_awm_connect_102,
  t29.check_disabled_security_circuit AS check_disabled_security_circuit_103,
  t29.check_disabled_power AS check_disabled_power_104,
  t29.check_disabled_flushness AS check_disabled_flushness_105,
  t29.check_disabled_collective_disorder AS check_disabled_collective_disorder_106,
  t29.check_disabled_malfunction AS check_disabled_malfunction_107,
  t29.check_disabled_smoke_extraction AS check_disabled_smoke_extraction_108,
  t29.check_disabled_water_level_warning AS check_disabled_water_level_warning_109,
  t29.check_disabled_aco_door_movements AS check_disabled_aco_door_movements_110,
  t29.check_disabled_flapping AS check_disabled_flapping_111,
  t29.has_standby_mode AS has_standby_mode_112,
  t29.in_standby AS in_standby_113,
  t29.standby_since AS standby_since_114,
  t29.standby_detected_at AS standby_detected_at_115,
  t29.check_disabled_aco_anomaly AS check_disabled_aco_anomaly_116,
  t29.aco_anomaly_suspect AS aco_anomaly_suspect_117,
  t29.aco_anomaly_since AS aco_anomaly_since_118,
  t29.aco_anomaly_snoozed_until AS aco_anomaly_snoozed_until_119,
  t29.aco_disconnect_suspect AS aco_disconnect_suspect_120,
  t29.aco_disconnect_since AS aco_disconnect_since_121,
  t29.aco_disconnect_restart_at AS aco_disconnect_restart_at_122,
  t29.deleted_at AS deleted_at_123,
  t29.address_id AS address_id_124,
  t29.trade_id AS trade_id_125,
  t29.manufacturer_id AS manufacturer_id_126,
  t29.maintenance_company_id AS maintenance_company_id_127,
  t29.control_company_id AS control_company_id_128,
  t29.custodian_company_id AS custodian_company_id_129,
  t29.lift_manager_company_id AS lift_manager_company_id_130,
  t29.sensor_id AS sensor_id_131,
  t29.client_id AS client_id_132,
  t29.operator_id AS operator_id_133,
  t29.service_company_id AS service_company_id_134,
  t29.contact_hauswart_id AS contact_hauswart_id_135,
  t29.contact_leitwarte_id AS contact_leitwarte_id_136,
  t29.contact_verwaltung_id AS contact_verwaltung_id_137,
  t29.contact_maintenance_company_id AS contact_maintenance_company_id_138,
  t29.contact_techniker_id AS contact_techniker_id_139,
  t29.install_company_id AS install_company_id_140,
  t29.mb_company_id AS mb_company_id_141,
  t29.client_aco_id AS client_aco_id_142,
  t29.leg_api_max_request_id AS leg_api_max_request_id_143,
  t144.id AS id_145,
  t144.created_at AS created_at_146,
  t144.updated_at AS updated_at_147,
  t144.state AS state_148,
  t144.voltage AS voltage_149,
  t144.has_warning AS has_warning_150,
  t144.tga_hash AS tga_hash_151,
  t144.technical_place AS technical_place_152,
  t144.manufacturer_number AS manufacturer_number_153,
  t144.last_inspection AS last_inspection_154,
  t144.last_maintenance AS last_maintenance_155,
  t144.last_zues AS last_zues_156,
  t144.next_zues AS next_zues_157,
  t144.next_maintenance AS next_maintenance_158,
  t144.manufacturer AS manufacturer_159,
  t144.type_of_pump AS type_of_pump_160,
  t144.build_year AS build_year_161,
  t144.liquid_level AS liquid_level_162,
  t144.threshold_value AS threshold_value_163,
  t144.apower AS apower_164,
  t144.current AS current_165,
  t144.pump_duration AS pump_duration_166,
  t144.last_pumpprocess_start AS last_pumpprocess_start_167,
  t144.last_pumpprocess_end AS last_pumpprocess_end_168,
  t144.address_id AS address_id_169,
  t144.trade_id AS trade_id_170,
  t144.maintenance_company_id AS maintenance_company_id_171,
  t144.sensor_id AS sensor_id_172,
  t144.client_id AS client_id_173,
  t144.operator_id AS operator_id_174,
  t144.install_company_id AS install_company_id_175,
  t176.created_at AS created_at_177,
  t176.updated_at AS updated_at_178,
  t176.id AS id_179,
  t176.name AS name_180,
  t176.state AS state_181,
  t176.fill_level AS fill_level_182,
  t176.manufacturer_number AS manufacturer_number_183,
  t176.build_year AS build_year_184,
  t176.last_zues AS last_zues_185,
  t176.next_zues AS next_zues_186,
  t176.last_inspection AS last_inspection_187,
  t176.last_maintenance AS last_maintenance_188,
  t176.next_maintenance AS next_maintenance_189,
  t176.tuev_state AS tuev_state_190,
  t176.electric_utility AS electric_utility_191,
  t176.type AS type_192,
  t176.tank_capacity AS tank_capacity_193,
  t176.power_generation_general AS power_generation_general_194,
  t176.tank_probe AS tank_probe_195,
  t176.tank_volume AS tank_volume_196,
  t176.number_of_probes AS number_of_probes_197,
  t176.probe1percent AS probe1percent_198,
  t176.probe2percent AS probe2percent_199,
  t176.probe3percent AS probe3percent_200,
  t176.battery_monitoring AS battery_monitoring_201,
  t176.tank_capacity_more_than AS tank_capacity_more_than_202,
  t176.battery_undervoltage AS battery_undervoltage_203,
  t176.ticket_for_tank_volume AS ticket_for_tank_volume_204,
  t176.tank_capacity_less_than AS tank_capacity_less_than_205,
  t176.leckage AS leckage_206,
  t176.value_for_collective_disorder AS value_for_collective_disorder_207,
  t176.value_for_probe AS value_for_probe_208,
  t176.aggregat_running AS aggregat_running_209,
  t176.value_for_ready_for_operation AS value_for_ready_for_operation_210,
  t176.value_for_generator_operation AS value_for_generator_operation_211,
  t176.value_for_mains_operation AS value_for_mains_operation_212,
  t176.value_for_mains_failure AS value_for_mains_failure_213,
  t176.value_for_charging_fault AS value_for_charging_fault_214,
  t176.value_for_transducer_failure AS value_for_transducer_failure_215,
  t176.value_for_deep_discharge_protection AS value_for_deep_discharge_protection_216,
  t176.value_for_leak_message AS value_for_leak_message_217,
  t176.value_for_battery_undervoltage AS value_for_battery_undervoltage_218,
  t176.value_for_aggregate_running AS value_for_aggregate_running_219,
  t176.value_for_function_test AS value_for_function_test_220,
  t176.config AS config_221,
  t176.value_for_net_failure AS value_for_net_failure_222,
  t176.value_for_operational AS value_for_operational_223,
  t176.tank_state AS tank_state_224,
  t176.deep_discharge_protection AS deep_discharge_protection_225,
  t176.charging_fault AS charging_fault_226,
  t176.transducer_failure AS transducer_failure_227,
  t176.collective_disorder AS collective_disorder_228,
  t176.ready_for_operation AS ready_for_operation_229,
  t176.tga_hash AS tga_hash_230,
  t176.time_to_escalate_tanken AS time_to_escalate_tanken_231,
  t176.time_to_escalate_bs AS time_to_escalate_bs_232,
  t176.technical_place AS technical_place_233,
  t176.repair_start AS repair_start_234,
  t176.maintenance_start AS maintenance_start_235,
  t176.zues_start AS zues_start_236,
  t176.repair_renewal_minutes AS repair_renewal_minutes_237,
  t176.address_id AS address_id_238,
  t176.manufacturer_id AS manufacturer_id_239,
  t176.maintenance_company_id AS maintenance_company_id_240,
  t176.control_company_id AS control_company_id_241,
  t176.tank_company_id AS tank_company_id_242,
  t176.service_company_id AS service_company_id_243,
  t176.custodian_company_id AS custodian_company_id_244,
  t176.client_id AS client_id_245,
  t176.sensor_id AS sensor_id_246,
  t176.trade_id AS trade_id_247,
  t176.contact_verwaltung_id AS contact_verwaltung_id_248,
  t176.contact_hauswart_id AS contact_hauswart_id_249,
  t176.contact_wartung_id AS contact_wartung_id_250,
  t176.contact_tank_company_id AS contact_tank_company_id_251,
  t176.contact_leitwarte_id AS contact_leitwarte_id_252,
  t176.operator_id AS operator_id_253,
  t176.contact_techniker_id AS contact_techniker_id_254,
  t176.install_company_id AS install_company_id_255
FROM
  sensor t0
  LEFT JOIN elevator t29 ON t29.sensor_id = t0.id
  AND (
    (t29.deleted_at IS NULL)
  )
  LEFT JOIN pump t144 ON t144.sensor_id = t0.id
  LEFT JOIN nea t176 ON t176.sensor_id = t0.id
WHERE
  t0.serial = ?
LIMIT
  1

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.sensor_id AS sensor_id_4, t0.phone AS phone_5, t0.email AS email_6, t0.state AS state_7, t0.start_of_monitoring AS start_of_monitoring_8, t0.sim_number AS sim_number_9, t0.provider AS provider_10, t0.lte_valid_until AS lte_valid_until_11, t0.last_online AS last_online_12, t0.installed AS installed_13, t0.serial AS serial_14, t0.observer_last_online AS observer_last_online_15, t0.name AS name_16, t0.observer_version AS observer_version_17, t0.observer_state AS observer_state_18, t0.port AS port_19, t0.tga_hash AS tga_hash_20, t0.pending_command AS pending_command_21, t0.update_started_at AS update_started_at_22, t0.update_status AS update_status_23, t0.connection_type AS connection_type_24, t0.connection_type_override AS connection_type_override_25, t0.router_mac AS router_mac_26, t0.connection_checked_at AS connection_checked_at_27, t0.trade_id AS trade_id_28, t29.created_at AS created_at_30, t29.updated_at AS updated_at_31, t29.id AS id_32, t29.name AS name_33, t29.state AS state_34, t29.manufacturer_number AS manufacturer_number_35, t29.build_year AS build_year_36, t29.stops AS stops_37, t29.height AS height_38, t29.last_zues AS last_zues_39, t29.next_zues AS next_zues_40, t29.last_inspection AS last_inspection_41, t29.last_maintenance AS last_maintenance_42, t29.payload AS payload_43, t29.drive_type AS drive_type_44, t29.two_sided AS two_sided_45, t29.speed AS speed_46, t29.next_maintenance AS next_maintenance_47, t29.awm_state AS awm_state_48, t29.tuev_state AS tuev_state_49, t29.last_zues_type AS last_zues_type_50, t29.pnae_result AS pnae_result_51, t29.doors_have_measuring_point AS doors_have_measuring_point_52, t29.trip_value AS trip_value_53, t29.door_value AS door_value_54, t29.cabinlight_value AS cabinlight_value_55, t29.flushness_value AS flushness_value_56, t29.power_value AS power_value_57, t29.sk_front_value AS sk_front_value_58, t29.sk_back_value AS sk_back_value_59, t29.sk_hoist_value AS sk_hoist_value_60, t29.collective_disorder_value AS collective_disorder_value_61, t29.sap_nr AS sap_nr_62, t29.tuev_nr AS tuev_nr_63, t29.type_of_elevator AS type_of_elevator_64, t29.door_counter_divider AS door_counter_divider_65, t29.tga_hash AS tga_hash_66, t29.time_to_escalate_zues AS time_to_escalate_zues_67, t29.time_to_escalate_awm AS time_to_escalate_awm_68, t29.time_to_escalate_bs AS time_to_escalate_bs_69, t29.zues_disposal_until AS zues_disposal_until_70, t29.zues_disposal AS zues_disposal_71, t29.zues712 AS zues712_72, t29.zues_verfification AS zues_verfification_73, t29.zues_verfification_date AS zues_verfification_date_74, t29.technical_place AS technical_place_75, t29.has_warning AS has_warning_76, t29.repair_start AS repair_start_77, t29.maintenance_start AS maintenance_start_78, t29.zues_start AS zues_start_79, t29.repair_renewal_minutes AS repair_renewal_minutes_80, t29.maintenance_renewal_minutes AS maintenance_renewal_minutes_81, t29.zues_renewal_minutes AS zues_renewal_minutes_82, t29.power_failure AS power_failure_83, t29.sc_front_doors_failure AS sc_front_doors_failure_84, t29.collective_disorder_failure AS collective_disorder_failure_85, t29.state_lis AS state_lis_86, t29.send_to_api AS send_to_api_87, t29.intercorp_enabled AS intercorp_enabled_88, t29.smoke_extraction_collective_disorder AS smoke_extraction_collective_disorder_89, t29.comment AS comment_90, t29.control_link AS control_link_91, t29.bs_date AS bs_date_92, t29.anomaly_count AS anomaly_count_93, t29.water_level_warning AS water_level_warning_94, t29.has_waterlevel_warning AS has_waterlevel_warning_95, t29.awm_compatible AS awm_compatible_96, t29.els1_mqtt_host AS els1_mqtt_host_97, t29.els1_mqtt_port AS els1_mqtt_port_98, t29.els1_mqtt_psk_identity AS els1_mqtt_psk_identity_99, t29.els1_mqtt_psk AS els1_mqtt_psk_100, t29.awm_connect_id AS awm_connect_id_101, t29.has_awm_connect AS has_awm_connect_102, t29.check_disabled_security_circuit AS check_disabled_security_circuit_103, t29.check_disabled_power AS check_disabled_power_104, t29.check_disabled_flushness AS check_disabled_flushness_105, t29.check_disabled_collective_disorder AS check_disabled_collective_disorder_106, t29.check_disabled_malfunction AS check_disabled_malfunction_107, t29.check_disabled_smoke_extraction AS check_disabled_smoke_extraction_108, t29.check_disabled_water_level_warning AS check_disabled_water_level_warning_109, t29.check_disabled_aco_door_movements AS check_disabled_aco_door_movements_110, t29.check_disabled_flapping AS check_disabled_flapping_111, t29.has_standby_mode AS has_standby_mode_112, t29.in_standby AS in_standby_113, t29.standby_since AS standby_since_114, t29.standby_detected_at AS standby_detected_at_115, t29.check_disabled_aco_anomaly AS check_disabled_aco_anomaly_116, t29.aco_anomaly_suspect AS aco_anomaly_suspect_117, t29.aco_anomaly_since AS aco_anomaly_since_118, t29.aco_anomaly_snoozed_until AS aco_anomaly_snoozed_until_119, t29.aco_disconnect_suspect AS aco_disconnect_suspect_120, t29.aco_disconnect_since AS aco_disconnect_since_121, t29.aco_disconnect_restart_at AS aco_disconnect_restart_at_122, t29.deleted_at AS deleted_at_123, t29.address_id AS address_id_124, t29.trade_id AS trade_id_125, t29.manufacturer_id AS manufacturer_id_126, t29.maintenance_company_id AS maintenance_company_id_127, t29.control_company_id AS control_company_id_128, t29.custodian_company_id AS custodian_company_id_129, t29.lift_manager_company_id AS lift_manager_company_id_130, t29.sensor_id AS sensor_id_131, t29.client_id AS client_id_132, t29.operator_id AS operator_id_133, t29.service_company_id AS service_company_id_134, t29.contact_hauswart_id AS contact_hauswart_id_135, t29.contact_leitwarte_id AS contact_leitwarte_id_136, t29.contact_verwaltung_id AS contact_verwaltung_id_137, t29.contact_maintenance_company_id AS contact_maintenance_company_id_138, t29.contact_techniker_id AS contact_techniker_id_139, t29.install_company_id AS install_company_id_140, t29.mb_company_id AS mb_company_id_141, t29.client_aco_id AS client_aco_id_142, t29.leg_api_max_request_id AS leg_api_max_request_id_143, t144.id AS id_145, t144.created_at AS created_at_146, t144.updated_at AS updated_at_147, t144.state AS state_148, t144.voltage AS voltage_149, t144.has_warning AS has_warning_150, t144.tga_hash AS tga_hash_151, t144.technical_place AS technical_place_152, t144.manufacturer_number AS manufacturer_number_153, t144.last_inspection AS last_inspection_154, t144.last_maintenance AS last_maintenance_155, t144.last_zues AS last_zues_156, t144.next_zues AS next_zues_157, t144.next_maintenance AS next_maintenance_158, t144.manufacturer AS manufacturer_159, t144.type_of_pump AS type_of_pump_160, t144.build_year AS build_year_161, t144.liquid_level AS liquid_level_162, t144.threshold_value AS threshold_value_163, t144.apower AS apower_164, t144.current AS current_165, t144.pump_duration AS pump_duration_166, t144.last_pumpprocess_start AS last_pumpprocess_start_167, t144.last_pumpprocess_end AS last_pumpprocess_end_168, t144.address_id AS address_id_169, t144.trade_id AS trade_id_170, t144.maintenance_company_id AS maintenance_company_id_171, t144.sensor_id AS sensor_id_172, t144.client_id AS client_id_173, t144.operator_id AS operator_id_174, t144.install_company_id AS install_company_id_175, t176.created_at AS created_at_177, t176.updated_at AS updated_at_178, t176.id AS id_179, t176.name AS name_180, t176.state AS state_181, t176.fill_level AS fill_level_182, t176.manufacturer_number AS manufacturer_number_183, t176.build_year AS build_year_184, t176.last_zues AS last_zues_185, t176.next_zues AS next_zues_186, t176.last_inspection AS last_inspection_187, t176.last_maintenance AS last_maintenance_188, t176.next_maintenance AS next_maintenance_189, t176.tuev_state AS tuev_state_190, t176.electric_utility AS electric_utility_191, t176.type AS type_192, t176.tank_capacity AS tank_capacity_193, t176.power_generation_general AS power_generation_general_194, t176.tank_probe AS tank_probe_195, t176.tank_volume AS tank_volume_196, t176.number_of_probes AS number_of_probes_197, t176.probe1percent AS probe1percent_198, t176.probe2percent AS probe2percent_199, t176.probe3percent AS probe3percent_200, t176.battery_monitoring AS battery_monitoring_201, t176.tank_capacity_more_than AS tank_capacity_more_than_202, t176.battery_undervoltage AS battery_undervoltage_203, t176.ticket_for_tank_volume AS ticket_for_tank_volume_204, t176.tank_capacity_less_than AS tank_capacity_less_than_205, t176.leckage AS leckage_206, t176.value_for_collective_disorder AS value_for_collective_disorder_207, t176.value_for_probe AS value_for_probe_208, t176.aggregat_running AS aggregat_running_209, t176.value_for_ready_for_operation AS value_for_ready_for_operation_210, t176.value_for_generator_operation AS value_for_generator_operation_211, t176.value_for_mains_operation AS value_for_mains_operation_212, t176.value_for_mains_failure AS value_for_mains_failure_213, t176.value_for_charging_fault AS value_for_charging_fault_214, t176.value_for_transducer_failure AS value_for_transducer_failure_215, t176.value_for_deep_discharge_protection AS value_for_deep_discharge_protection_216, t176.value_for_leak_message AS value_for_leak_message_217, t176.value_for_battery_undervoltage AS value_for_battery_undervoltage_218, t176.value_for_aggregate_running AS value_for_aggregate_running_219, t176.value_for_function_test AS value_for_function_test_220, t176.config AS config_221, t176.value_for_net_failure AS value_for_net_failure_222, t176.value_for_operational AS value_for_operational_223, t176.tank_state AS tank_state_224, t176.deep_discharge_protection AS deep_discharge_protection_225, t176.charging_fault AS charging_fault_226, t176.transducer_failure AS transducer_failure_227, t176.collective_disorder AS collective_disorder_228, t176.ready_for_operation AS ready_for_operation_229, t176.tga_hash AS tga_hash_230, t176.time_to_escalate_tanken AS time_to_escalate_tanken_231, t176.time_to_escalate_bs AS time_to_escalate_bs_232, t176.technical_place AS technical_place_233, t176.repair_start AS repair_start_234, t176.maintenance_start AS maintenance_start_235, t176.zues_start AS zues_start_236, t176.repair_renewal_minutes AS repair_renewal_minutes_237, t176.address_id AS address_id_238, t176.manufacturer_id AS manufacturer_id_239, t176.maintenance_company_id AS maintenance_company_id_240, t176.control_company_id AS control_company_id_241, t176.tank_company_id AS tank_company_id_242, t176.service_company_id AS service_company_id_243, t176.custodian_company_id AS custodian_company_id_244, t176.client_id AS client_id_245, t176.sensor_id AS sensor_id_246, t176.trade_id AS trade_id_247, t176.contact_verwaltung_id AS contact_verwaltung_id_248, t176.contact_hauswart_id AS contact_hauswart_id_249, t176.contact_wartung_id AS contact_wartung_id_250, t176.contact_tank_company_id AS contact_tank_company_id_251, t176.contact_leitwarte_id AS contact_leitwarte_id_252, t176.operator_id AS operator_id_253, t176.contact_techniker_id AS contact_techniker_id_254, t176.install_company_id AS install_company_id_255 FROM sensor t0 LEFT JOIN elevator t29 ON t29.sensor_id = t0.id AND ((t29.deleted_at IS NULL)) LEFT JOIN pump t144 ON t144.sensor_id = t0.id LEFT JOIN nea t176 ON t176.sensor_id = t0.id WHERE t0.serial = '10000000cd01789c' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cabinlight AS cabinlight_2,
  t0.flushness AS flushness_3,
  t0.securitychain AS securitychain_4,
  t0.power AS power_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.elevator_id AS elevator_id_8
FROM
  awm t0
WHERE
  t0.elevator_id = ?

SELECT t0.id AS id_1, t0.cabinlight AS cabinlight_2, t0.flushness AS flushness_3, t0.securitychain AS securitychain_4, t0.power AS power_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.elevator_id AS elevator_id_8 FROM awm t0 WHERE t0.elevator_id = 827;

SELECT
  t0.id AS id_1,
  t0.trips_since_last_malfunction AS trips_since_last_malfunction_2,
  t0.trips_since_last_zues AS trips_since_last_zues_3,
  t0.trips_since_last_maintenance AS trips_since_last_maintenance_4,
  t0.last_trip AS last_trip_5,
  t0.trips AS trips_6,
  t0.doors_since_last_malfunction AS doors_since_last_malfunction_7,
  t0.doors_since_last_zues AS doors_since_last_zues_8,
  t0.doors_since_last_maintenance AS doors_since_last_maintenance_9,
  t0.doors AS doors_10,
  t0.trip_stats AS trip_stats_11,
  t0.aco_disorder_date AS aco_disorder_date_12,
  t0.elevator_id AS elevator_id_13
FROM
  stats t0
WHERE
  t0.elevator_id = ?

SELECT t0.id AS id_1, t0.trips_since_last_malfunction AS trips_since_last_malfunction_2, t0.trips_since_last_zues AS trips_since_last_zues_3, t0.trips_since_last_maintenance AS trips_since_last_maintenance_4, t0.last_trip AS last_trip_5, t0.trips AS trips_6, t0.doors_since_last_malfunction AS doors_since_last_malfunction_7, t0.doors_since_last_zues AS doors_since_last_zues_8, t0.doors_since_last_maintenance AS doors_since_last_maintenance_9, t0.doors AS doors_10, t0.trip_stats AS trip_stats_11, t0.aco_disorder_date AS aco_disorder_date_12, t0.elevator_id AS elevator_id_13 FROM stats t0 WHERE t0.elevator_id = 827;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  sensor
SET
  state = ?,
  last_online = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE sensor SET state = 1, last_online = '2026-08-20 17:18:27', updated_at = '2026-08-20 17:18:27' WHERE id = 409;

"COMMIT"

"COMMIT";