3.82 ms
(77.11%)
|
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.ssh_public_key AS ssh_public_key_28, t0.ssh_key_status AS ssh_key_status_29, t0.ssh_key_reported_at AS ssh_key_reported_at_30, t0.trade_id AS trade_id_31, t32.created_at AS created_at_33, t32.updated_at AS updated_at_34, t32.id AS id_35, t32.name AS name_36, t32.state AS state_37, t32.manufacturer_number AS manufacturer_number_38, t32.build_year AS build_year_39, t32.stops AS stops_40, t32.height AS height_41, t32.last_zues AS last_zues_42, t32.next_zues AS next_zues_43, t32.last_inspection AS last_inspection_44, t32.last_maintenance AS last_maintenance_45, t32.payload AS payload_46, t32.drive_type AS drive_type_47, t32.two_sided AS two_sided_48, t32.speed AS speed_49, t32.next_maintenance AS next_maintenance_50, t32.awm_state AS awm_state_51, t32.tuev_state AS tuev_state_52, t32.last_zues_type AS last_zues_type_53, t32.pnae_result AS pnae_result_54, t32.doors_have_measuring_point AS doors_have_measuring_point_55, t32.trip_value AS trip_value_56, t32.door_value AS door_value_57, t32.cabinlight_value AS cabinlight_value_58, t32.flushness_value AS flushness_value_59, t32.power_value AS power_value_60, t32.sk_front_value AS sk_front_value_61, t32.sk_back_value AS sk_back_value_62, t32.sk_hoist_value AS sk_hoist_value_63, t32.collective_disorder_value AS collective_disorder_value_64, t32.sap_nr AS sap_nr_65, t32.tuev_nr AS tuev_nr_66, t32.type_of_elevator AS type_of_elevator_67, t32.door_counter_divider AS door_counter_divider_68, t32.tga_hash AS tga_hash_69, t32.time_to_escalate_zues AS time_to_escalate_zues_70, t32.time_to_escalate_awm AS time_to_escalate_awm_71, t32.time_to_escalate_bs AS time_to_escalate_bs_72, t32.zues_disposal_until AS zues_disposal_until_73, t32.zues_disposal AS zues_disposal_74, t32.zues712 AS zues712_75, t32.zues_verfification AS zues_verfification_76, t32.zues_verfification_date AS zues_verfification_date_77, t32.technical_place AS technical_place_78, t32.has_warning AS has_warning_79, t32.repair_start AS repair_start_80, t32.maintenance_start AS maintenance_start_81, t32.zues_start AS zues_start_82, t32.repair_renewal_minutes AS repair_renewal_minutes_83, t32.maintenance_renewal_minutes AS maintenance_renewal_minutes_84, t32.zues_renewal_minutes AS zues_renewal_minutes_85, t32.power_failure AS power_failure_86, t32.sc_front_doors_failure AS sc_front_doors_failure_87, t32.collective_disorder_failure AS collective_disorder_failure_88, t32.state_lis AS state_lis_89, t32.send_to_api AS send_to_api_90, t32.intercorp_enabled AS intercorp_enabled_91, t32.smoke_extraction_collective_disorder AS smoke_extraction_collective_disorder_92, t32.comment AS comment_93, t32.control_link AS control_link_94, t32.bs_date AS bs_date_95, t32.anomaly_count AS anomaly_count_96, t32.water_level_warning AS water_level_warning_97, t32.has_waterlevel_warning AS has_waterlevel_warning_98, t32.awm_compatible AS awm_compatible_99, t32.els1_mqtt_host AS els1_mqtt_host_100, t32.els1_mqtt_port AS els1_mqtt_port_101, t32.els1_mqtt_psk_identity AS els1_mqtt_psk_identity_102, t32.els1_mqtt_psk AS els1_mqtt_psk_103, t32.awm_connect_id AS awm_connect_id_104, t32.has_awm_connect AS has_awm_connect_105, t32.check_disabled_security_circuit AS check_disabled_security_circuit_106, t32.check_disabled_power AS check_disabled_power_107, t32.check_disabled_flushness AS check_disabled_flushness_108, t32.check_disabled_collective_disorder AS check_disabled_collective_disorder_109, t32.check_disabled_malfunction AS check_disabled_malfunction_110, t32.check_disabled_smoke_extraction AS check_disabled_smoke_extraction_111, t32.check_disabled_water_level_warning AS check_disabled_water_level_warning_112, t32.check_disabled_aco_door_movements AS check_disabled_aco_door_movements_113, t32.check_disabled_flapping AS check_disabled_flapping_114, t32.has_standby_mode AS has_standby_mode_115, t32.in_standby AS in_standby_116, t32.standby_since AS standby_since_117, t32.standby_detected_at AS standby_detected_at_118, t32.check_disabled_aco_anomaly AS check_disabled_aco_anomaly_119, t32.aco_anomaly_suspect AS aco_anomaly_suspect_120, t32.aco_anomaly_since AS aco_anomaly_since_121, t32.aco_anomaly_snoozed_until AS aco_anomaly_snoozed_until_122, t32.aco_disconnect_suspect AS aco_disconnect_suspect_123, t32.aco_disconnect_since AS aco_disconnect_since_124, t32.aco_disconnect_restart_at AS aco_disconnect_restart_at_125, t32.deleted_at AS deleted_at_126, t32.address_id AS address_id_127, t32.trade_id AS trade_id_128, t32.manufacturer_id AS manufacturer_id_129, t32.maintenance_company_id AS maintenance_company_id_130, t32.control_company_id AS control_company_id_131, t32.custodian_company_id AS custodian_company_id_132, t32.lift_manager_company_id AS lift_manager_company_id_133, t32.sensor_id AS sensor_id_134, t32.client_id AS client_id_135, t32.operator_id AS operator_id_136, t32.service_company_id AS service_company_id_137, t32.contact_hauswart_id AS contact_hauswart_id_138, t32.contact_leitwarte_id AS contact_leitwarte_id_139, t32.contact_verwaltung_id AS contact_verwaltung_id_140, t32.contact_maintenance_company_id AS contact_maintenance_company_id_141, t32.contact_techniker_id AS contact_techniker_id_142, t32.install_company_id AS install_company_id_143, t32.mb_company_id AS mb_company_id_144, t32.client_aco_id AS client_aco_id_145, t32.leg_api_max_request_id AS leg_api_max_request_id_146, t147.id AS id_148, t147.created_at AS created_at_149, t147.updated_at AS updated_at_150, t147.state AS state_151, t147.voltage AS voltage_152, t147.has_warning AS has_warning_153, t147.tga_hash AS tga_hash_154, t147.technical_place AS technical_place_155, t147.manufacturer_number AS manufacturer_number_156, t147.last_inspection AS last_inspection_157, t147.last_maintenance AS last_maintenance_158, t147.last_zues AS last_zues_159, t147.next_zues AS next_zues_160, t147.next_maintenance AS next_maintenance_161, t147.manufacturer AS manufacturer_162, t147.type_of_pump AS type_of_pump_163, t147.build_year AS build_year_164, t147.liquid_level AS liquid_level_165, t147.threshold_value AS threshold_value_166, t147.apower AS apower_167, t147.current AS current_168, t147.pump_duration AS pump_duration_169, t147.last_pumpprocess_start AS last_pumpprocess_start_170, t147.last_pumpprocess_end AS last_pumpprocess_end_171, t147.address_id AS address_id_172, t147.trade_id AS trade_id_173, t147.maintenance_company_id AS maintenance_company_id_174, t147.sensor_id AS sensor_id_175, t147.client_id AS client_id_176, t147.operator_id AS operator_id_177, t147.install_company_id AS install_company_id_178, t179.created_at AS created_at_180, t179.updated_at AS updated_at_181, t179.id AS id_182, t179.name AS name_183, t179.state AS state_184, t179.fill_level AS fill_level_185, t179.manufacturer_number AS manufacturer_number_186, t179.build_year AS build_year_187, t179.last_zues AS last_zues_188, t179.next_zues AS next_zues_189, t179.last_inspection AS last_inspection_190, t179.last_maintenance AS last_maintenance_191, t179.next_maintenance AS next_maintenance_192, t179.tuev_state AS tuev_state_193, t179.electric_utility AS electric_utility_194, t179.type AS type_195, t179.tank_capacity AS tank_capacity_196, t179.power_generation_general AS power_generation_general_197, t179.tank_probe AS tank_probe_198, t179.tank_volume AS tank_volume_199, t179.number_of_probes AS number_of_probes_200, t179.probe1percent AS probe1percent_201, t179.probe2percent AS probe2percent_202, t179.probe3percent AS probe3percent_203, t179.battery_monitoring AS battery_monitoring_204, t179.tank_capacity_more_than AS tank_capacity_more_than_205, t179.battery_undervoltage AS battery_undervoltage_206, t179.ticket_for_tank_volume AS ticket_for_tank_volume_207, t179.tank_capacity_less_than AS tank_capacity_less_than_208, t179.leckage AS leckage_209, t179.value_for_collective_disorder AS value_for_collective_disorder_210, t179.value_for_probe AS value_for_probe_211, t179.aggregat_running AS aggregat_running_212, t179.value_for_ready_for_operation AS value_for_ready_for_operation_213, t179.value_for_generator_operation AS value_for_generator_operation_214, t179.value_for_mains_operation AS value_for_mains_operation_215, t179.value_for_mains_failure AS value_for_mains_failure_216, t179.value_for_charging_fault AS value_for_charging_fault_217, t179.value_for_transducer_failure AS value_for_transducer_failure_218, t179.value_for_deep_discharge_protection AS value_for_deep_discharge_protection_219, t179.value_for_leak_message AS value_for_leak_message_220, t179.value_for_battery_undervoltage AS value_for_battery_undervoltage_221, t179.value_for_aggregate_running AS value_for_aggregate_running_222, t179.value_for_function_test AS value_for_function_test_223, t179.config AS config_224, t179.value_for_net_failure AS value_for_net_failure_225, t179.value_for_operational AS value_for_operational_226, t179.tank_state AS tank_state_227, t179.deep_discharge_protection AS deep_discharge_protection_228, t179.charging_fault AS charging_fault_229, t179.transducer_failure AS transducer_failure_230, t179.collective_disorder AS collective_disorder_231, t179.ready_for_operation AS ready_for_operation_232, t179.tga_hash AS tga_hash_233, t179.time_to_escalate_tanken AS time_to_escalate_tanken_234, t179.time_to_escalate_bs AS time_to_escalate_bs_235, t179.technical_place AS technical_place_236, t179.repair_start AS repair_start_237, t179.maintenance_start AS maintenance_start_238, t179.zues_start AS zues_start_239, t179.repair_renewal_minutes AS repair_renewal_minutes_240, t179.address_id AS address_id_241, t179.manufacturer_id AS manufacturer_id_242, t179.maintenance_company_id AS maintenance_company_id_243, t179.control_company_id AS control_company_id_244, t179.tank_company_id AS tank_company_id_245, t179.service_company_id AS service_company_id_246, t179.custodian_company_id AS custodian_company_id_247, t179.client_id AS client_id_248, t179.sensor_id AS sensor_id_249, t179.trade_id AS trade_id_250, t179.contact_verwaltung_id AS contact_verwaltung_id_251, t179.contact_hauswart_id AS contact_hauswart_id_252, t179.contact_wartung_id AS contact_wartung_id_253, t179.contact_tank_company_id AS contact_tank_company_id_254, t179.contact_leitwarte_id AS contact_leitwarte_id_255, t179.operator_id AS operator_id_256, t179.contact_techniker_id AS contact_techniker_id_257, t179.install_company_id AS install_company_id_258 FROM sensor t0 LEFT JOIN elevator t32 ON t32.sensor_id = t0.id AND ((t32.deleted_at IS NULL)) LEFT JOIN pump t147 ON t147.sensor_id = t0.id LEFT JOIN nea t179 ON t179.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.ssh_public_key AS ssh_public_key_28,
t0.ssh_key_status AS ssh_key_status_29,
t0.ssh_key_reported_at AS ssh_key_reported_at_30,
t0.trade_id AS trade_id_31,
t32.created_at AS created_at_33,
t32.updated_at AS updated_at_34,
t32.id AS id_35,
t32.name AS name_36,
t32.state AS state_37,
t32.manufacturer_number AS manufacturer_number_38,
t32.build_year AS build_year_39,
t32.stops AS stops_40,
t32.height AS height_41,
t32.last_zues AS last_zues_42,
t32.next_zues AS next_zues_43,
t32.last_inspection AS last_inspection_44,
t32.last_maintenance AS last_maintenance_45,
t32.payload AS payload_46,
t32.drive_type AS drive_type_47,
t32.two_sided AS two_sided_48,
t32.speed AS speed_49,
t32.next_maintenance AS next_maintenance_50,
t32.awm_state AS awm_state_51,
t32.tuev_state AS tuev_state_52,
t32.last_zues_type AS last_zues_type_53,
t32.pnae_result AS pnae_result_54,
t32.doors_have_measuring_point AS doors_have_measuring_point_55,
t32.trip_value AS trip_value_56,
t32.door_value AS door_value_57,
t32.cabinlight_value AS cabinlight_value_58,
t32.flushness_value AS flushness_value_59,
t32.power_value AS power_value_60,
t32.sk_front_value AS sk_front_value_61,
t32.sk_back_value AS sk_back_value_62,
t32.sk_hoist_value AS sk_hoist_value_63,
t32.collective_disorder_value AS collective_disorder_value_64,
t32.sap_nr AS sap_nr_65,
t32.tuev_nr AS tuev_nr_66,
t32.type_of_elevator AS type_of_elevator_67,
t32.door_counter_divider AS door_counter_divider_68,
t32.tga_hash AS tga_hash_69,
t32.time_to_escalate_zues AS time_to_escalate_zues_70,
t32.time_to_escalate_awm AS time_to_escalate_awm_71,
t32.time_to_escalate_bs AS time_to_escalate_bs_72,
t32.zues_disposal_until AS zues_disposal_until_73,
t32.zues_disposal AS zues_disposal_74,
t32.zues712 AS zues712_75,
t32.zues_verfification AS zues_verfification_76,
t32.zues_verfification_date AS zues_verfification_date_77,
t32.technical_place AS technical_place_78,
t32.has_warning AS has_warning_79,
t32.repair_start AS repair_start_80,
t32.maintenance_start AS maintenance_start_81,
t32.zues_start AS zues_start_82,
t32.repair_renewal_minutes AS repair_renewal_minutes_83,
t32.maintenance_renewal_minutes AS maintenance_renewal_minutes_84,
t32.zues_renewal_minutes AS zues_renewal_minutes_85,
t32.power_failure AS power_failure_86,
t32.sc_front_doors_failure AS sc_front_doors_failure_87,
t32.collective_disorder_failure AS collective_disorder_failure_88,
t32.state_lis AS state_lis_89,
t32.send_to_api AS send_to_api_90,
t32.intercorp_enabled AS intercorp_enabled_91,
t32.smoke_extraction_collective_disorder AS smoke_extraction_collective_disorder_92,
t32.comment AS comment_93,
t32.control_link AS control_link_94,
t32.bs_date AS bs_date_95,
t32.anomaly_count AS anomaly_count_96,
t32.water_level_warning AS water_level_warning_97,
t32.has_waterlevel_warning AS has_waterlevel_warning_98,
t32.awm_compatible AS awm_compatible_99,
t32.els1_mqtt_host AS els1_mqtt_host_100,
t32.els1_mqtt_port AS els1_mqtt_port_101,
t32.els1_mqtt_psk_identity AS els1_mqtt_psk_identity_102,
t32.els1_mqtt_psk AS els1_mqtt_psk_103,
t32.awm_connect_id AS awm_connect_id_104,
t32.has_awm_connect AS has_awm_connect_105,
t32.check_disabled_security_circuit AS check_disabled_security_circuit_106,
t32.check_disabled_power AS check_disabled_power_107,
t32.check_disabled_flushness AS check_disabled_flushness_108,
t32.check_disabled_collective_disorder AS check_disabled_collective_disorder_109,
t32.check_disabled_malfunction AS check_disabled_malfunction_110,
t32.check_disabled_smoke_extraction AS check_disabled_smoke_extraction_111,
t32.check_disabled_water_level_warning AS check_disabled_water_level_warning_112,
t32.check_disabled_aco_door_movements AS check_disabled_aco_door_movements_113,
t32.check_disabled_flapping AS check_disabled_flapping_114,
t32.has_standby_mode AS has_standby_mode_115,
t32.in_standby AS in_standby_116,
t32.standby_since AS standby_since_117,
t32.standby_detected_at AS standby_detected_at_118,
t32.check_disabled_aco_anomaly AS check_disabled_aco_anomaly_119,
t32.aco_anomaly_suspect AS aco_anomaly_suspect_120,
t32.aco_anomaly_since AS aco_anomaly_since_121,
t32.aco_anomaly_snoozed_until AS aco_anomaly_snoozed_until_122,
t32.aco_disconnect_suspect AS aco_disconnect_suspect_123,
t32.aco_disconnect_since AS aco_disconnect_since_124,
t32.aco_disconnect_restart_at AS aco_disconnect_restart_at_125,
t32.deleted_at AS deleted_at_126,
t32.address_id AS address_id_127,
t32.trade_id AS trade_id_128,
t32.manufacturer_id AS manufacturer_id_129,
t32.maintenance_company_id AS maintenance_company_id_130,
t32.control_company_id AS control_company_id_131,
t32.custodian_company_id AS custodian_company_id_132,
t32.lift_manager_company_id AS lift_manager_company_id_133,
t32.sensor_id AS sensor_id_134,
t32.client_id AS client_id_135,
t32.operator_id AS operator_id_136,
t32.service_company_id AS service_company_id_137,
t32.contact_hauswart_id AS contact_hauswart_id_138,
t32.contact_leitwarte_id AS contact_leitwarte_id_139,
t32.contact_verwaltung_id AS contact_verwaltung_id_140,
t32.contact_maintenance_company_id AS contact_maintenance_company_id_141,
t32.contact_techniker_id AS contact_techniker_id_142,
t32.install_company_id AS install_company_id_143,
t32.mb_company_id AS mb_company_id_144,
t32.client_aco_id AS client_aco_id_145,
t32.leg_api_max_request_id AS leg_api_max_request_id_146,
t147.id AS id_148,
t147.created_at AS created_at_149,
t147.updated_at AS updated_at_150,
t147.state AS state_151,
t147.voltage AS voltage_152,
t147.has_warning AS has_warning_153,
t147.tga_hash AS tga_hash_154,
t147.technical_place AS technical_place_155,
t147.manufacturer_number AS manufacturer_number_156,
t147.last_inspection AS last_inspection_157,
t147.last_maintenance AS last_maintenance_158,
t147.last_zues AS last_zues_159,
t147.next_zues AS next_zues_160,
t147.next_maintenance AS next_maintenance_161,
t147.manufacturer AS manufacturer_162,
t147.type_of_pump AS type_of_pump_163,
t147.build_year AS build_year_164,
t147.liquid_level AS liquid_level_165,
t147.threshold_value AS threshold_value_166,
t147.apower AS apower_167,
t147.current AS current_168,
t147.pump_duration AS pump_duration_169,
t147.last_pumpprocess_start AS last_pumpprocess_start_170,
t147.last_pumpprocess_end AS last_pumpprocess_end_171,
t147.address_id AS address_id_172,
t147.trade_id AS trade_id_173,
t147.maintenance_company_id AS maintenance_company_id_174,
t147.sensor_id AS sensor_id_175,
t147.client_id AS client_id_176,
t147.operator_id AS operator_id_177,
t147.install_company_id AS install_company_id_178,
t179.created_at AS created_at_180,
t179.updated_at AS updated_at_181,
t179.id AS id_182,
t179.name AS name_183,
t179.state AS state_184,
t179.fill_level AS fill_level_185,
t179.manufacturer_number AS manufacturer_number_186,
t179.build_year AS build_year_187,
t179.last_zues AS last_zues_188,
t179.next_zues AS next_zues_189,
t179.last_inspection AS last_inspection_190,
t179.last_maintenance AS last_maintenance_191,
t179.next_maintenance AS next_maintenance_192,
t179.tuev_state AS tuev_state_193,
t179.electric_utility AS electric_utility_194,
t179.type AS type_195,
t179.tank_capacity AS tank_capacity_196,
t179.power_generation_general AS power_generation_general_197,
t179.tank_probe AS tank_probe_198,
t179.tank_volume AS tank_volume_199,
t179.number_of_probes AS number_of_probes_200,
t179.probe1percent AS probe1percent_201,
t179.probe2percent AS probe2percent_202,
t179.probe3percent AS probe3percent_203,
t179.battery_monitoring AS battery_monitoring_204,
t179.tank_capacity_more_than AS tank_capacity_more_than_205,
t179.battery_undervoltage AS battery_undervoltage_206,
t179.ticket_for_tank_volume AS ticket_for_tank_volume_207,
t179.tank_capacity_less_than AS tank_capacity_less_than_208,
t179.leckage AS leckage_209,
t179.value_for_collective_disorder AS value_for_collective_disorder_210,
t179.value_for_probe AS value_for_probe_211,
t179.aggregat_running AS aggregat_running_212,
t179.value_for_ready_for_operation AS value_for_ready_for_operation_213,
t179.value_for_generator_operation AS value_for_generator_operation_214,
t179.value_for_mains_operation AS value_for_mains_operation_215,
t179.value_for_mains_failure AS value_for_mains_failure_216,
t179.value_for_charging_fault AS value_for_charging_fault_217,
t179.value_for_transducer_failure AS value_for_transducer_failure_218,
t179.value_for_deep_discharge_protection AS value_for_deep_discharge_protection_219,
t179.value_for_leak_message AS value_for_leak_message_220,
t179.value_for_battery_undervoltage AS value_for_battery_undervoltage_221,
t179.value_for_aggregate_running AS value_for_aggregate_running_222,
t179.value_for_function_test AS value_for_function_test_223,
t179.config AS config_224,
t179.value_for_net_failure AS value_for_net_failure_225,
t179.value_for_operational AS value_for_operational_226,
t179.tank_state AS tank_state_227,
t179.deep_discharge_protection AS deep_discharge_protection_228,
t179.charging_fault AS charging_fault_229,
t179.transducer_failure AS transducer_failure_230,
t179.collective_disorder AS collective_disorder_231,
t179.ready_for_operation AS ready_for_operation_232,
t179.tga_hash AS tga_hash_233,
t179.time_to_escalate_tanken AS time_to_escalate_tanken_234,
t179.time_to_escalate_bs AS time_to_escalate_bs_235,
t179.technical_place AS technical_place_236,
t179.repair_start AS repair_start_237,
t179.maintenance_start AS maintenance_start_238,
t179.zues_start AS zues_start_239,
t179.repair_renewal_minutes AS repair_renewal_minutes_240,
t179.address_id AS address_id_241,
t179.manufacturer_id AS manufacturer_id_242,
t179.maintenance_company_id AS maintenance_company_id_243,
t179.control_company_id AS control_company_id_244,
t179.tank_company_id AS tank_company_id_245,
t179.service_company_id AS service_company_id_246,
t179.custodian_company_id AS custodian_company_id_247,
t179.client_id AS client_id_248,
t179.sensor_id AS sensor_id_249,
t179.trade_id AS trade_id_250,
t179.contact_verwaltung_id AS contact_verwaltung_id_251,
t179.contact_hauswart_id AS contact_hauswart_id_252,
t179.contact_wartung_id AS contact_wartung_id_253,
t179.contact_tank_company_id AS contact_tank_company_id_254,
t179.contact_leitwarte_id AS contact_leitwarte_id_255,
t179.operator_id AS operator_id_256,
t179.contact_techniker_id AS contact_techniker_id_257,
t179.install_company_id AS install_company_id_258
FROM
sensor t0
LEFT JOIN elevator t32 ON t32.sensor_id = t0.id
AND (
(t32.deleted_at IS NULL)
)
LEFT JOIN pump t147 ON t147.sensor_id = t0.id
LEFT JOIN nea t179 ON t179.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.ssh_public_key AS ssh_public_key_28, t0.ssh_key_status AS ssh_key_status_29, t0.ssh_key_reported_at AS ssh_key_reported_at_30, t0.trade_id AS trade_id_31, t32.created_at AS created_at_33, t32.updated_at AS updated_at_34, t32.id AS id_35, t32.name AS name_36, t32.state AS state_37, t32.manufacturer_number AS manufacturer_number_38, t32.build_year AS build_year_39, t32.stops AS stops_40, t32.height AS height_41, t32.last_zues AS last_zues_42, t32.next_zues AS next_zues_43, t32.last_inspection AS last_inspection_44, t32.last_maintenance AS last_maintenance_45, t32.payload AS payload_46, t32.drive_type AS drive_type_47, t32.two_sided AS two_sided_48, t32.speed AS speed_49, t32.next_maintenance AS next_maintenance_50, t32.awm_state AS awm_state_51, t32.tuev_state AS tuev_state_52, t32.last_zues_type AS last_zues_type_53, t32.pnae_result AS pnae_result_54, t32.doors_have_measuring_point AS doors_have_measuring_point_55, t32.trip_value AS trip_value_56, t32.door_value AS door_value_57, t32.cabinlight_value AS cabinlight_value_58, t32.flushness_value AS flushness_value_59, t32.power_value AS power_value_60, t32.sk_front_value AS sk_front_value_61, t32.sk_back_value AS sk_back_value_62, t32.sk_hoist_value AS sk_hoist_value_63, t32.collective_disorder_value AS collective_disorder_value_64, t32.sap_nr AS sap_nr_65, t32.tuev_nr AS tuev_nr_66, t32.type_of_elevator AS type_of_elevator_67, t32.door_counter_divider AS door_counter_divider_68, t32.tga_hash AS tga_hash_69, t32.time_to_escalate_zues AS time_to_escalate_zues_70, t32.time_to_escalate_awm AS time_to_escalate_awm_71, t32.time_to_escalate_bs AS time_to_escalate_bs_72, t32.zues_disposal_until AS zues_disposal_until_73, t32.zues_disposal AS zues_disposal_74, t32.zues712 AS zues712_75, t32.zues_verfification AS zues_verfification_76, t32.zues_verfification_date AS zues_verfification_date_77, t32.technical_place AS technical_place_78, t32.has_warning AS has_warning_79, t32.repair_start AS repair_start_80, t32.maintenance_start AS maintenance_start_81, t32.zues_start AS zues_start_82, t32.repair_renewal_minutes AS repair_renewal_minutes_83, t32.maintenance_renewal_minutes AS maintenance_renewal_minutes_84, t32.zues_renewal_minutes AS zues_renewal_minutes_85, t32.power_failure AS power_failure_86, t32.sc_front_doors_failure AS sc_front_doors_failure_87, t32.collective_disorder_failure AS collective_disorder_failure_88, t32.state_lis AS state_lis_89, t32.send_to_api AS send_to_api_90, t32.intercorp_enabled AS intercorp_enabled_91, t32.smoke_extraction_collective_disorder AS smoke_extraction_collective_disorder_92, t32.comment AS comment_93, t32.control_link AS control_link_94, t32.bs_date AS bs_date_95, t32.anomaly_count AS anomaly_count_96, t32.water_level_warning AS water_level_warning_97, t32.has_waterlevel_warning AS has_waterlevel_warning_98, t32.awm_compatible AS awm_compatible_99, t32.els1_mqtt_host AS els1_mqtt_host_100, t32.els1_mqtt_port AS els1_mqtt_port_101, t32.els1_mqtt_psk_identity AS els1_mqtt_psk_identity_102, t32.els1_mqtt_psk AS els1_mqtt_psk_103, t32.awm_connect_id AS awm_connect_id_104, t32.has_awm_connect AS has_awm_connect_105, t32.check_disabled_security_circuit AS check_disabled_security_circuit_106, t32.check_disabled_power AS check_disabled_power_107, t32.check_disabled_flushness AS check_disabled_flushness_108, t32.check_disabled_collective_disorder AS check_disabled_collective_disorder_109, t32.check_disabled_malfunction AS check_disabled_malfunction_110, t32.check_disabled_smoke_extraction AS check_disabled_smoke_extraction_111, t32.check_disabled_water_level_warning AS check_disabled_water_level_warning_112, t32.check_disabled_aco_door_movements AS check_disabled_aco_door_movements_113, t32.check_disabled_flapping AS check_disabled_flapping_114, t32.has_standby_mode AS has_standby_mode_115, t32.in_standby AS in_standby_116, t32.standby_since AS standby_since_117, t32.standby_detected_at AS standby_detected_at_118, t32.check_disabled_aco_anomaly AS check_disabled_aco_anomaly_119, t32.aco_anomaly_suspect AS aco_anomaly_suspect_120, t32.aco_anomaly_since AS aco_anomaly_since_121, t32.aco_anomaly_snoozed_until AS aco_anomaly_snoozed_until_122, t32.aco_disconnect_suspect AS aco_disconnect_suspect_123, t32.aco_disconnect_since AS aco_disconnect_since_124, t32.aco_disconnect_restart_at AS aco_disconnect_restart_at_125, t32.deleted_at AS deleted_at_126, t32.address_id AS address_id_127, t32.trade_id AS trade_id_128, t32.manufacturer_id AS manufacturer_id_129, t32.maintenance_company_id AS maintenance_company_id_130, t32.control_company_id AS control_company_id_131, t32.custodian_company_id AS custodian_company_id_132, t32.lift_manager_company_id AS lift_manager_company_id_133, t32.sensor_id AS sensor_id_134, t32.client_id AS client_id_135, t32.operator_id AS operator_id_136, t32.service_company_id AS service_company_id_137, t32.contact_hauswart_id AS contact_hauswart_id_138, t32.contact_leitwarte_id AS contact_leitwarte_id_139, t32.contact_verwaltung_id AS contact_verwaltung_id_140, t32.contact_maintenance_company_id AS contact_maintenance_company_id_141, t32.contact_techniker_id AS contact_techniker_id_142, t32.install_company_id AS install_company_id_143, t32.mb_company_id AS mb_company_id_144, t32.client_aco_id AS client_aco_id_145, t32.leg_api_max_request_id AS leg_api_max_request_id_146, t147.id AS id_148, t147.created_at AS created_at_149, t147.updated_at AS updated_at_150, t147.state AS state_151, t147.voltage AS voltage_152, t147.has_warning AS has_warning_153, t147.tga_hash AS tga_hash_154, t147.technical_place AS technical_place_155, t147.manufacturer_number AS manufacturer_number_156, t147.last_inspection AS last_inspection_157, t147.last_maintenance AS last_maintenance_158, t147.last_zues AS last_zues_159, t147.next_zues AS next_zues_160, t147.next_maintenance AS next_maintenance_161, t147.manufacturer AS manufacturer_162, t147.type_of_pump AS type_of_pump_163, t147.build_year AS build_year_164, t147.liquid_level AS liquid_level_165, t147.threshold_value AS threshold_value_166, t147.apower AS apower_167, t147.current AS current_168, t147.pump_duration AS pump_duration_169, t147.last_pumpprocess_start AS last_pumpprocess_start_170, t147.last_pumpprocess_end AS last_pumpprocess_end_171, t147.address_id AS address_id_172, t147.trade_id AS trade_id_173, t147.maintenance_company_id AS maintenance_company_id_174, t147.sensor_id AS sensor_id_175, t147.client_id AS client_id_176, t147.operator_id AS operator_id_177, t147.install_company_id AS install_company_id_178, t179.created_at AS created_at_180, t179.updated_at AS updated_at_181, t179.id AS id_182, t179.name AS name_183, t179.state AS state_184, t179.fill_level AS fill_level_185, t179.manufacturer_number AS manufacturer_number_186, t179.build_year AS build_year_187, t179.last_zues AS last_zues_188, t179.next_zues AS next_zues_189, t179.last_inspection AS last_inspection_190, t179.last_maintenance AS last_maintenance_191, t179.next_maintenance AS next_maintenance_192, t179.tuev_state AS tuev_state_193, t179.electric_utility AS electric_utility_194, t179.type AS type_195, t179.tank_capacity AS tank_capacity_196, t179.power_generation_general AS power_generation_general_197, t179.tank_probe AS tank_probe_198, t179.tank_volume AS tank_volume_199, t179.number_of_probes AS number_of_probes_200, t179.probe1percent AS probe1percent_201, t179.probe2percent AS probe2percent_202, t179.probe3percent AS probe3percent_203, t179.battery_monitoring AS battery_monitoring_204, t179.tank_capacity_more_than AS tank_capacity_more_than_205, t179.battery_undervoltage AS battery_undervoltage_206, t179.ticket_for_tank_volume AS ticket_for_tank_volume_207, t179.tank_capacity_less_than AS tank_capacity_less_than_208, t179.leckage AS leckage_209, t179.value_for_collective_disorder AS value_for_collective_disorder_210, t179.value_for_probe AS value_for_probe_211, t179.aggregat_running AS aggregat_running_212, t179.value_for_ready_for_operation AS value_for_ready_for_operation_213, t179.value_for_generator_operation AS value_for_generator_operation_214, t179.value_for_mains_operation AS value_for_mains_operation_215, t179.value_for_mains_failure AS value_for_mains_failure_216, t179.value_for_charging_fault AS value_for_charging_fault_217, t179.value_for_transducer_failure AS value_for_transducer_failure_218, t179.value_for_deep_discharge_protection AS value_for_deep_discharge_protection_219, t179.value_for_leak_message AS value_for_leak_message_220, t179.value_for_battery_undervoltage AS value_for_battery_undervoltage_221, t179.value_for_aggregate_running AS value_for_aggregate_running_222, t179.value_for_function_test AS value_for_function_test_223, t179.config AS config_224, t179.value_for_net_failure AS value_for_net_failure_225, t179.value_for_operational AS value_for_operational_226, t179.tank_state AS tank_state_227, t179.deep_discharge_protection AS deep_discharge_protection_228, t179.charging_fault AS charging_fault_229, t179.transducer_failure AS transducer_failure_230, t179.collective_disorder AS collective_disorder_231, t179.ready_for_operation AS ready_for_operation_232, t179.tga_hash AS tga_hash_233, t179.time_to_escalate_tanken AS time_to_escalate_tanken_234, t179.time_to_escalate_bs AS time_to_escalate_bs_235, t179.technical_place AS technical_place_236, t179.repair_start AS repair_start_237, t179.maintenance_start AS maintenance_start_238, t179.zues_start AS zues_start_239, t179.repair_renewal_minutes AS repair_renewal_minutes_240, t179.address_id AS address_id_241, t179.manufacturer_id AS manufacturer_id_242, t179.maintenance_company_id AS maintenance_company_id_243, t179.control_company_id AS control_company_id_244, t179.tank_company_id AS tank_company_id_245, t179.service_company_id AS service_company_id_246, t179.custodian_company_id AS custodian_company_id_247, t179.client_id AS client_id_248, t179.sensor_id AS sensor_id_249, t179.trade_id AS trade_id_250, t179.contact_verwaltung_id AS contact_verwaltung_id_251, t179.contact_hauswart_id AS contact_hauswart_id_252, t179.contact_wartung_id AS contact_wartung_id_253, t179.contact_tank_company_id AS contact_tank_company_id_254, t179.contact_leitwarte_id AS contact_leitwarte_id_255, t179.operator_id AS operator_id_256, t179.contact_techniker_id AS contact_techniker_id_257, t179.install_company_id AS install_company_id_258 FROM sensor t0 LEFT JOIN elevator t32 ON t32.sensor_id = t0.id AND ((t32.deleted_at IS NULL)) LEFT JOIN pump t147 ON t147.sensor_id = t0.id LEFT JOIN nea t179 ON t179.sensor_id = t0.id LIMIT 1;
|
0.59 ms
(11.94%)
|
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
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;
|