| 1 |
4.10 ms |
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 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
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 LIMIT 1;
|
| 3 |
0.66 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.name AS name_4, t0.state AS state_5, t0.manufacturer_number AS manufacturer_number_6, t0.build_year AS build_year_7, t0.stops AS stops_8, t0.height AS height_9, t0.last_zues AS last_zues_10, t0.next_zues AS next_zues_11, t0.last_inspection AS last_inspection_12, t0.last_maintenance AS last_maintenance_13, t0.payload AS payload_14, t0.drive_type AS drive_type_15, t0.two_sided AS two_sided_16, t0.speed AS speed_17, t0.next_maintenance AS next_maintenance_18, t0.awm_state AS awm_state_19, t0.tuev_state AS tuev_state_20, t0.last_zues_type AS last_zues_type_21, t0.pnae_result AS pnae_result_22, t0.doors_have_measuring_point AS doors_have_measuring_point_23, t0.trip_value AS trip_value_24, t0.door_value AS door_value_25, t0.cabinlight_value AS cabinlight_value_26, t0.flushness_value AS flushness_value_27, t0.power_value AS power_value_28, t0.sk_front_value AS sk_front_value_29, t0.sk_back_value AS sk_back_value_30, t0.sk_hoist_value AS sk_hoist_value_31, t0.collective_disorder_value AS collective_disorder_value_32, t0.sap_nr AS sap_nr_33, t0.tuev_nr AS tuev_nr_34, t0.type_of_elevator AS type_of_elevator_35, t0.door_counter_divider AS door_counter_divider_36, t0.tga_hash AS tga_hash_37, t0.time_to_escalate_zues AS time_to_escalate_zues_38, t0.time_to_escalate_awm AS time_to_escalate_awm_39, t0.time_to_escalate_bs AS time_to_escalate_bs_40, t0.zues_disposal_until AS zues_disposal_until_41, t0.zues_disposal AS zues_disposal_42, t0.zues712 AS zues712_43, t0.zues_verfification AS zues_verfification_44, t0.zues_verfification_date AS zues_verfification_date_45, t0.technical_place AS technical_place_46, t0.has_warning AS has_warning_47, t0.repair_start AS repair_start_48, t0.maintenance_start AS maintenance_start_49, t0.zues_start AS zues_start_50, t0.repair_renewal_minutes AS repair_renewal_minutes_51, t0.maintenance_renewal_minutes AS maintenance_renewal_minutes_52, t0.zues_renewal_minutes AS zues_renewal_minutes_53, t0.power_failure AS power_failure_54, t0.sc_front_doors_failure AS sc_front_doors_failure_55, t0.collective_disorder_failure AS collective_disorder_failure_56, t0.state_lis AS state_lis_57, t0.send_to_api AS send_to_api_58, t0.intercorp_enabled AS intercorp_enabled_59, t0.smoke_extraction_collective_disorder AS smoke_extraction_collective_disorder_60, t0.comment AS comment_61, t0.control_link AS control_link_62, t0.bs_date AS bs_date_63, t0.anomaly_count AS anomaly_count_64, t0.water_level_warning AS water_level_warning_65, t0.has_waterlevel_warning AS has_waterlevel_warning_66, t0.awm_compatible AS awm_compatible_67, t0.els1_mqtt_host AS els1_mqtt_host_68, t0.els1_mqtt_port AS els1_mqtt_port_69, t0.els1_mqtt_psk_identity AS els1_mqtt_psk_identity_70, t0.els1_mqtt_psk AS els1_mqtt_psk_71, t0.awm_connect_id AS awm_connect_id_72, t0.has_awm_connect AS has_awm_connect_73, t0.check_disabled_security_circuit AS check_disabled_security_circuit_74, t0.check_disabled_power AS check_disabled_power_75, t0.check_disabled_flushness AS check_disabled_flushness_76, t0.check_disabled_collective_disorder AS check_disabled_collective_disorder_77, t0.check_disabled_malfunction AS check_disabled_malfunction_78, t0.check_disabled_smoke_extraction AS check_disabled_smoke_extraction_79, t0.check_disabled_water_level_warning AS check_disabled_water_level_warning_80, t0.check_disabled_aco_door_movements AS check_disabled_aco_door_movements_81, t0.check_disabled_flapping AS check_disabled_flapping_82, t0.has_standby_mode AS has_standby_mode_83, t0.in_standby AS in_standby_84, t0.standby_since AS standby_since_85, t0.standby_detected_at AS standby_detected_at_86, t0.check_disabled_aco_anomaly AS check_disabled_aco_anomaly_87, t0.aco_anomaly_suspect AS aco_anomaly_suspect_88, t0.aco_anomaly_since AS aco_anomaly_since_89, t0.aco_anomaly_snoozed_until AS aco_anomaly_snoozed_until_90, t0.aco_disconnect_suspect AS aco_disconnect_suspect_91, t0.aco_disconnect_since AS aco_disconnect_since_92, t0.aco_disconnect_restart_at AS aco_disconnect_restart_at_93, t0.deleted_at AS deleted_at_94, t0.address_id AS address_id_95, t0.trade_id AS trade_id_96, t0.manufacturer_id AS manufacturer_id_97, t0.maintenance_company_id AS maintenance_company_id_98, t0.control_company_id AS control_company_id_99, t0.custodian_company_id AS custodian_company_id_100, t0.lift_manager_company_id AS lift_manager_company_id_101, t102.id AS id_103, t102.cabinlight AS cabinlight_104, t102.flushness AS flushness_105, t102.securitychain AS securitychain_106, t102.power AS power_107, t102.created_at AS created_at_108, t102.updated_at AS updated_at_109, t102.elevator_id AS elevator_id_110, t0.sensor_id AS sensor_id_111, t0.client_id AS client_id_112, t0.operator_id AS operator_id_113, t0.service_company_id AS service_company_id_114, t0.contact_hauswart_id AS contact_hauswart_id_115, t0.contact_leitwarte_id AS contact_leitwarte_id_116, t0.contact_verwaltung_id AS contact_verwaltung_id_117, t0.contact_maintenance_company_id AS contact_maintenance_company_id_118, t0.contact_techniker_id AS contact_techniker_id_119, t120.id AS id_121, t120.trips_since_last_malfunction AS trips_since_last_malfunction_122, t120.trips_since_last_zues AS trips_since_last_zues_123, t120.trips_since_last_maintenance AS trips_since_last_maintenance_124, t120.last_trip AS last_trip_125, t120.trips AS trips_126, t120.doors_since_last_malfunction AS doors_since_last_malfunction_127, t120.doors_since_last_zues AS doors_since_last_zues_128, t120.doors_since_last_maintenance AS doors_since_last_maintenance_129, t120.doors AS doors_130, t120.trip_stats AS trip_stats_131, t120.aco_disorder_date AS aco_disorder_date_132, t120.elevator_id AS elevator_id_133, t0.install_company_id AS install_company_id_134, t0.mb_company_id AS mb_company_id_135, t0.client_aco_id AS client_aco_id_136, t0.leg_api_max_request_id AS leg_api_max_request_id_137 FROM elevator t0 LEFT JOIN awm t102 ON t102.elevator_id = t0.id LEFT JOIN stats t120 ON t120.elevator_id = t0.id WHERE ((t0.deleted_at IS NULL)) LIMIT 1
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.id AS id_3,
t0.name AS name_4,
t0.state AS state_5,
t0.manufacturer_number AS manufacturer_number_6,
t0.build_year AS build_year_7,
t0.stops AS stops_8,
t0.height AS height_9,
t0.last_zues AS last_zues_10,
t0.next_zues AS next_zues_11,
t0.last_inspection AS last_inspection_12,
t0.last_maintenance AS last_maintenance_13,
t0.payload AS payload_14,
t0.drive_type AS drive_type_15,
t0.two_sided AS two_sided_16,
t0.speed AS speed_17,
t0.next_maintenance AS next_maintenance_18,
t0.awm_state AS awm_state_19,
t0.tuev_state AS tuev_state_20,
t0.last_zues_type AS last_zues_type_21,
t0.pnae_result AS pnae_result_22,
t0.doors_have_measuring_point AS doors_have_measuring_point_23,
t0.trip_value AS trip_value_24,
t0.door_value AS door_value_25,
t0.cabinlight_value AS cabinlight_value_26,
t0.flushness_value AS flushness_value_27,
t0.power_value AS power_value_28,
t0.sk_front_value AS sk_front_value_29,
t0.sk_back_value AS sk_back_value_30,
t0.sk_hoist_value AS sk_hoist_value_31,
t0.collective_disorder_value AS collective_disorder_value_32,
t0.sap_nr AS sap_nr_33,
t0.tuev_nr AS tuev_nr_34,
t0.type_of_elevator AS type_of_elevator_35,
t0.door_counter_divider AS door_counter_divider_36,
t0.tga_hash AS tga_hash_37,
t0.time_to_escalate_zues AS time_to_escalate_zues_38,
t0.time_to_escalate_awm AS time_to_escalate_awm_39,
t0.time_to_escalate_bs AS time_to_escalate_bs_40,
t0.zues_disposal_until AS zues_disposal_until_41,
t0.zues_disposal AS zues_disposal_42,
t0.zues712 AS zues712_43,
t0.zues_verfification AS zues_verfification_44,
t0.zues_verfification_date AS zues_verfification_date_45,
t0.technical_place AS technical_place_46,
t0.has_warning AS has_warning_47,
t0.repair_start AS repair_start_48,
t0.maintenance_start AS maintenance_start_49,
t0.zues_start AS zues_start_50,
t0.repair_renewal_minutes AS repair_renewal_minutes_51,
t0.maintenance_renewal_minutes AS maintenance_renewal_minutes_52,
t0.zues_renewal_minutes AS zues_renewal_minutes_53,
t0.power_failure AS power_failure_54,
t0.sc_front_doors_failure AS sc_front_doors_failure_55,
t0.collective_disorder_failure AS collective_disorder_failure_56,
t0.state_lis AS state_lis_57,
t0.send_to_api AS send_to_api_58,
t0.intercorp_enabled AS intercorp_enabled_59,
t0.smoke_extraction_collective_disorder AS smoke_extraction_collective_disorder_60,
t0.comment AS comment_61,
t0.control_link AS control_link_62,
t0.bs_date AS bs_date_63,
t0.anomaly_count AS anomaly_count_64,
t0.water_level_warning AS water_level_warning_65,
t0.has_waterlevel_warning AS has_waterlevel_warning_66,
t0.awm_compatible AS awm_compatible_67,
t0.els1_mqtt_host AS els1_mqtt_host_68,
t0.els1_mqtt_port AS els1_mqtt_port_69,
t0.els1_mqtt_psk_identity AS els1_mqtt_psk_identity_70,
t0.els1_mqtt_psk AS els1_mqtt_psk_71,
t0.awm_connect_id AS awm_connect_id_72,
t0.has_awm_connect AS has_awm_connect_73,
t0.check_disabled_security_circuit AS check_disabled_security_circuit_74,
t0.check_disabled_power AS check_disabled_power_75,
t0.check_disabled_flushness AS check_disabled_flushness_76,
t0.check_disabled_collective_disorder AS check_disabled_collective_disorder_77,
t0.check_disabled_malfunction AS check_disabled_malfunction_78,
t0.check_disabled_smoke_extraction AS check_disabled_smoke_extraction_79,
t0.check_disabled_water_level_warning AS check_disabled_water_level_warning_80,
t0.check_disabled_aco_door_movements AS check_disabled_aco_door_movements_81,
t0.check_disabled_flapping AS check_disabled_flapping_82,
t0.has_standby_mode AS has_standby_mode_83,
t0.in_standby AS in_standby_84,
t0.standby_since AS standby_since_85,
t0.standby_detected_at AS standby_detected_at_86,
t0.check_disabled_aco_anomaly AS check_disabled_aco_anomaly_87,
t0.aco_anomaly_suspect AS aco_anomaly_suspect_88,
t0.aco_anomaly_since AS aco_anomaly_since_89,
t0.aco_anomaly_snoozed_until AS aco_anomaly_snoozed_until_90,
t0.aco_disconnect_suspect AS aco_disconnect_suspect_91,
t0.aco_disconnect_since AS aco_disconnect_since_92,
t0.aco_disconnect_restart_at AS aco_disconnect_restart_at_93,
t0.deleted_at AS deleted_at_94,
t0.address_id AS address_id_95,
t0.trade_id AS trade_id_96,
t0.manufacturer_id AS manufacturer_id_97,
t0.maintenance_company_id AS maintenance_company_id_98,
t0.control_company_id AS control_company_id_99,
t0.custodian_company_id AS custodian_company_id_100,
t0.lift_manager_company_id AS lift_manager_company_id_101,
t102.id AS id_103,
t102.cabinlight AS cabinlight_104,
t102.flushness AS flushness_105,
t102.securitychain AS securitychain_106,
t102.power AS power_107,
t102.created_at AS created_at_108,
t102.updated_at AS updated_at_109,
t102.elevator_id AS elevator_id_110,
t0.sensor_id AS sensor_id_111,
t0.client_id AS client_id_112,
t0.operator_id AS operator_id_113,
t0.service_company_id AS service_company_id_114,
t0.contact_hauswart_id AS contact_hauswart_id_115,
t0.contact_leitwarte_id AS contact_leitwarte_id_116,
t0.contact_verwaltung_id AS contact_verwaltung_id_117,
t0.contact_maintenance_company_id AS contact_maintenance_company_id_118,
t0.contact_techniker_id AS contact_techniker_id_119,
t120.id AS id_121,
t120.trips_since_last_malfunction AS trips_since_last_malfunction_122,
t120.trips_since_last_zues AS trips_since_last_zues_123,
t120.trips_since_last_maintenance AS trips_since_last_maintenance_124,
t120.last_trip AS last_trip_125,
t120.trips AS trips_126,
t120.doors_since_last_malfunction AS doors_since_last_malfunction_127,
t120.doors_since_last_zues AS doors_since_last_zues_128,
t120.doors_since_last_maintenance AS doors_since_last_maintenance_129,
t120.doors AS doors_130,
t120.trip_stats AS trip_stats_131,
t120.aco_disorder_date AS aco_disorder_date_132,
t120.elevator_id AS elevator_id_133,
t0.install_company_id AS install_company_id_134,
t0.mb_company_id AS mb_company_id_135,
t0.client_aco_id AS client_aco_id_136,
t0.leg_api_max_request_id AS leg_api_max_request_id_137
FROM
elevator t0
LEFT JOIN awm t102 ON t102.elevator_id = t0.id
LEFT JOIN stats t120 ON t120.elevator_id = t0.id
WHERE
(
(t0.deleted_at IS NULL)
)
LIMIT
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.name AS name_4, t0.state AS state_5, t0.manufacturer_number AS manufacturer_number_6, t0.build_year AS build_year_7, t0.stops AS stops_8, t0.height AS height_9, t0.last_zues AS last_zues_10, t0.next_zues AS next_zues_11, t0.last_inspection AS last_inspection_12, t0.last_maintenance AS last_maintenance_13, t0.payload AS payload_14, t0.drive_type AS drive_type_15, t0.two_sided AS two_sided_16, t0.speed AS speed_17, t0.next_maintenance AS next_maintenance_18, t0.awm_state AS awm_state_19, t0.tuev_state AS tuev_state_20, t0.last_zues_type AS last_zues_type_21, t0.pnae_result AS pnae_result_22, t0.doors_have_measuring_point AS doors_have_measuring_point_23, t0.trip_value AS trip_value_24, t0.door_value AS door_value_25, t0.cabinlight_value AS cabinlight_value_26, t0.flushness_value AS flushness_value_27, t0.power_value AS power_value_28, t0.sk_front_value AS sk_front_value_29, t0.sk_back_value AS sk_back_value_30, t0.sk_hoist_value AS sk_hoist_value_31, t0.collective_disorder_value AS collective_disorder_value_32, t0.sap_nr AS sap_nr_33, t0.tuev_nr AS tuev_nr_34, t0.type_of_elevator AS type_of_elevator_35, t0.door_counter_divider AS door_counter_divider_36, t0.tga_hash AS tga_hash_37, t0.time_to_escalate_zues AS time_to_escalate_zues_38, t0.time_to_escalate_awm AS time_to_escalate_awm_39, t0.time_to_escalate_bs AS time_to_escalate_bs_40, t0.zues_disposal_until AS zues_disposal_until_41, t0.zues_disposal AS zues_disposal_42, t0.zues712 AS zues712_43, t0.zues_verfification AS zues_verfification_44, t0.zues_verfification_date AS zues_verfification_date_45, t0.technical_place AS technical_place_46, t0.has_warning AS has_warning_47, t0.repair_start AS repair_start_48, t0.maintenance_start AS maintenance_start_49, t0.zues_start AS zues_start_50, t0.repair_renewal_minutes AS repair_renewal_minutes_51, t0.maintenance_renewal_minutes AS maintenance_renewal_minutes_52, t0.zues_renewal_minutes AS zues_renewal_minutes_53, t0.power_failure AS power_failure_54, t0.sc_front_doors_failure AS sc_front_doors_failure_55, t0.collective_disorder_failure AS collective_disorder_failure_56, t0.state_lis AS state_lis_57, t0.send_to_api AS send_to_api_58, t0.intercorp_enabled AS intercorp_enabled_59, t0.smoke_extraction_collective_disorder AS smoke_extraction_collective_disorder_60, t0.comment AS comment_61, t0.control_link AS control_link_62, t0.bs_date AS bs_date_63, t0.anomaly_count AS anomaly_count_64, t0.water_level_warning AS water_level_warning_65, t0.has_waterlevel_warning AS has_waterlevel_warning_66, t0.awm_compatible AS awm_compatible_67, t0.els1_mqtt_host AS els1_mqtt_host_68, t0.els1_mqtt_port AS els1_mqtt_port_69, t0.els1_mqtt_psk_identity AS els1_mqtt_psk_identity_70, t0.els1_mqtt_psk AS els1_mqtt_psk_71, t0.awm_connect_id AS awm_connect_id_72, t0.has_awm_connect AS has_awm_connect_73, t0.check_disabled_security_circuit AS check_disabled_security_circuit_74, t0.check_disabled_power AS check_disabled_power_75, t0.check_disabled_flushness AS check_disabled_flushness_76, t0.check_disabled_collective_disorder AS check_disabled_collective_disorder_77, t0.check_disabled_malfunction AS check_disabled_malfunction_78, t0.check_disabled_smoke_extraction AS check_disabled_smoke_extraction_79, t0.check_disabled_water_level_warning AS check_disabled_water_level_warning_80, t0.check_disabled_aco_door_movements AS check_disabled_aco_door_movements_81, t0.check_disabled_flapping AS check_disabled_flapping_82, t0.has_standby_mode AS has_standby_mode_83, t0.in_standby AS in_standby_84, t0.standby_since AS standby_since_85, t0.standby_detected_at AS standby_detected_at_86, t0.check_disabled_aco_anomaly AS check_disabled_aco_anomaly_87, t0.aco_anomaly_suspect AS aco_anomaly_suspect_88, t0.aco_anomaly_since AS aco_anomaly_since_89, t0.aco_anomaly_snoozed_until AS aco_anomaly_snoozed_until_90, t0.aco_disconnect_suspect AS aco_disconnect_suspect_91, t0.aco_disconnect_since AS aco_disconnect_since_92, t0.aco_disconnect_restart_at AS aco_disconnect_restart_at_93, t0.deleted_at AS deleted_at_94, t0.address_id AS address_id_95, t0.trade_id AS trade_id_96, t0.manufacturer_id AS manufacturer_id_97, t0.maintenance_company_id AS maintenance_company_id_98, t0.control_company_id AS control_company_id_99, t0.custodian_company_id AS custodian_company_id_100, t0.lift_manager_company_id AS lift_manager_company_id_101, t102.id AS id_103, t102.cabinlight AS cabinlight_104, t102.flushness AS flushness_105, t102.securitychain AS securitychain_106, t102.power AS power_107, t102.created_at AS created_at_108, t102.updated_at AS updated_at_109, t102.elevator_id AS elevator_id_110, t0.sensor_id AS sensor_id_111, t0.client_id AS client_id_112, t0.operator_id AS operator_id_113, t0.service_company_id AS service_company_id_114, t0.contact_hauswart_id AS contact_hauswart_id_115, t0.contact_leitwarte_id AS contact_leitwarte_id_116, t0.contact_verwaltung_id AS contact_verwaltung_id_117, t0.contact_maintenance_company_id AS contact_maintenance_company_id_118, t0.contact_techniker_id AS contact_techniker_id_119, t120.id AS id_121, t120.trips_since_last_malfunction AS trips_since_last_malfunction_122, t120.trips_since_last_zues AS trips_since_last_zues_123, t120.trips_since_last_maintenance AS trips_since_last_maintenance_124, t120.last_trip AS last_trip_125, t120.trips AS trips_126, t120.doors_since_last_malfunction AS doors_since_last_malfunction_127, t120.doors_since_last_zues AS doors_since_last_zues_128, t120.doors_since_last_maintenance AS doors_since_last_maintenance_129, t120.doors AS doors_130, t120.trip_stats AS trip_stats_131, t120.aco_disorder_date AS aco_disorder_date_132, t120.elevator_id AS elevator_id_133, t0.install_company_id AS install_company_id_134, t0.mb_company_id AS mb_company_id_135, t0.client_aco_id AS client_aco_id_136, t0.leg_api_max_request_id AS leg_api_max_request_id_137 FROM elevator t0 LEFT JOIN awm t102 ON t102.elevator_id = t0.id LEFT JOIN stats t120 ON t120.elevator_id = t0.id WHERE ((t0.deleted_at IS NULL)) LIMIT 1;
|