{"request":{"component":"1","scope":"1","station":"1580","date_from":"2026-01-01","date_to":"2026-12-31","time_from":"01:00:00","time_to":"24:00:00","lang":"de","recent":false,"index":"id","datetime_from":"2026-01-01 00:00:00","datetime_to":"2026-12-31 23:00:00"},"indices":{"data":{"station id":{"date start":["component id","scope id","value","date end","index"]}}},"data":{"1580":{"2026-01-01 11:00:00":[1,1,16,"2026-01-01 12:00:00","3"],"2026-01-02 11:00:00":[1,1,4,"2026-01-02 12:00:00","0"],"2026-01-03 11:00:00":[1,1,7,"2026-01-03 12:00:00","1"],"2026-01-04 11:00:00":[1,1,10,"2026-01-04 12:00:00","1"],"2026-01-05 11:00:00":[1,1,15,"2026-01-05 12:00:00","2"],"2026-01-06 11:00:00":[1,1,24,"2026-01-06 12:00:00","4"],"2026-01-07 11:00:00":[1,1,16,"2026-01-07 12:00:00","3"],"2026-01-08 11:00:00":[1,1,18,"2026-01-08 12:00:00","3"],"2026-01-09 11:00:00":[1,1,16,"2026-01-09 12:00:00","3"],"2026-01-10 11:00:00":[1,1,10,"2026-01-10 12:00:00","1"],"2026-01-11 11:00:00":[1,1,14,"2026-01-11 12:00:00","2"],"2026-01-12 11:00:00":[1,1,13,"2026-01-12 12:00:00","2"],"2026-01-13 11:00:00":[1,1,16,"2026-01-13 12:00:00","3"],"2026-01-14 11:00:00":[1,1,12,"2026-01-14 12:00:00","2"],"2026-01-15 11:00:00":[1,1,14,"2026-01-15 12:00:00","2"],"2026-01-16 11:00:00":[1,1,14,"2026-01-16 12:00:00","2"],"2026-01-17 11:00:00":[1,1,20,"2026-01-17 12:00:00","3"],"2026-01-18 11:00:00":[1,1,23,"2026-01-18 12:00:00","4"],"2026-01-19 11:00:00":[1,1,23,"2026-01-19 12:00:00","4"],"2026-01-20 11:00:00":[1,1,29,"2026-01-20 12:00:00","5"],"2026-01-21 11:00:00":[1,1,35,"2026-01-21 12:00:00","6"],"2026-01-22 11:00:00":[1,1,39,"2026-01-22 12:00:00","7"],"2026-01-23 11:00:00":[1,1,75,"2026-01-23 12:00:00","10"],"2026-01-24 11:00:00":[1,1,44,"2026-01-24 12:00:00","8"],"2026-01-25 11:00:00":[1,1,39,"2026-01-25 12:00:00","7"],"2026-01-26 11:00:00":[1,1,11,"2026-01-26 12:00:00","2"],"2026-01-27 11:00:00":[1,1,22,"2026-01-27 12:00:00","4"],"2026-01-28 11:00:00":[1,1,15,"2026-01-28 12:00:00","2"],"2026-01-29 11:00:00":[1,1,11,"2026-01-29 12:00:00","2"],"2026-01-30 11:00:00":[1,1,18,"2026-01-30 12:00:00","3"],"2026-01-31 11:00:00":[1,1,30,"2026-01-31 12:00:00","5"],"2026-02-01 11:00:00":[1,1,22,"2026-02-01 12:00:00","4"],"2026-02-02 11:00:00":[1,1,22,"2026-02-02 12:00:00","4"],"2026-02-03 11:00:00":[1,1,16,"2026-02-03 12:00:00","3"],"2026-02-04 11:00:00":[1,1,32,"2026-02-04 12:00:00","6"],"2026-02-05 11:00:00":[1,1,28,"2026-02-05 12:00:00","5"],"2026-02-06 11:00:00":[1,1,42,"2026-02-06 12:00:00","8"],"2026-02-07 11:00:00":[1,1,43,"2026-02-07 12:00:00","8"],"2026-02-08 11:00:00":[1,1,16,"2026-02-08 12:00:00","3"],"2026-02-09 11:00:00":[1,1,36,"2026-02-09 12:00:00","7"],"2026-02-10 11:00:00":[1,1,35,"2026-02-10 12:00:00","6"],"2026-02-11 11:00:00":[1,1,34,"2026-02-11 12:00:00","6"],"2026-02-12 11:00:00":[1,1,16,"2026-02-12 12:00:00","3"],"2026-02-13 11:00:00":[1,1,7,"2026-02-13 12:00:00","1"],"2026-02-14 11:00:00":[1,1,12,"2026-02-14 12:00:00","2"],"2026-02-15 11:00:00":[1,1,13,"2026-02-15 12:00:00","2"],"2026-02-16 11:00:00":[1,1,15,"2026-02-16 12:00:00","2"],"2026-02-17 11:00:00":[1,1,36,"2026-02-17 12:00:00","7"],"2026-02-18 11:00:00":[1,1,23,"2026-02-18 12:00:00","4"],"2026-02-19 11:00:00":[1,1,14,"2026-02-19 12:00:00","2"],"2026-02-20 11:00:00":[1,1,19,"2026-02-20 12:00:00","3"],"2026-02-21 11:00:00":[1,1,19,"2026-02-21 12:00:00","3"],"2026-02-22 11:00:00":[1,1,9,"2026-02-22 12:00:00","1"],"2026-02-23 11:00:00":[1,1,12,"2026-02-23 12:00:00","2"],"2026-02-24 11:00:00":[1,1,20,"2026-02-24 12:00:00","3"],"2026-02-25 11:00:00":[1,1,17,"2026-02-25 12:00:00","3"],"2026-02-26 11:00:00":[1,1,19,"2026-02-26 12:00:00","3"],"2026-02-27 11:00:00":[1,1,28,"2026-02-27 12:00:00","5"],"2026-02-28 11:00:00":[1,1,15,"2026-02-28 12:00:00","2"],"2026-03-01 11:00:00":[1,1,null,"2026-03-01 12:00:00",null],"2026-03-02 11:00:00":[1,1,23,"2026-03-02 12:00:00","4"],"2026-03-03 11:00:00":[1,1,23,"2026-03-03 12:00:00","4"],"2026-03-04 11:00:00":[1,1,26,"2026-03-04 12:00:00","5"],"2026-03-05 11:00:00":[1,1,24,"2026-03-05 12:00:00","4"],"2026-03-06 11:00:00":[1,1,37,"2026-03-06 12:00:00","7"],"2026-03-07 11:00:00":[1,1,null,"2026-03-07 12:00:00",null],"2026-03-08 11:00:00":[1,1,42,"2026-03-08 12:00:00","8"],"2026-03-09 11:00:00":[1,1,50,"2026-03-09 12:00:00","9"],"2026-03-10 11:00:00":[1,1,50,"2026-03-10 12:00:00","9"],"2026-03-11 11:00:00":[1,1,null,"2026-03-11 12:00:00",null],"2026-03-12 11:00:00":[1,1,16,"2026-03-12 12:00:00","3"],"2026-03-13 11:00:00":[1,1,10,"2026-03-13 12:00:00","1"],"2026-03-14 11:00:00":[1,1,7,"2026-03-14 12:00:00","1"],"2026-03-15 11:00:00":[1,1,14,"2026-03-15 12:00:00","2"],"2026-03-16 11:00:00":[1,1,13,"2026-03-16 12:00:00","2"],"2026-03-17 11:00:00":[1,1,16,"2026-03-17 12:00:00","3"],"2026-03-18 11:00:00":[1,1,12,"2026-03-18 12:00:00","2"],"2026-03-19 11:00:00":[1,1,null,"2026-03-19 12:00:00",null],"2026-03-20 11:00:00":[1,1,15,"2026-03-20 12:00:00","2"],"2026-03-21 11:00:00":[1,1,17,"2026-03-21 12:00:00","3"],"2026-03-22 11:00:00":[1,1,19,"2026-03-22 12:00:00","3"],"2026-03-23 11:00:00":[1,1,37,"2026-03-23 12:00:00","7"],"2026-03-24 11:00:00":[1,1,45,"2026-03-24 12:00:00","8"],"2026-03-25 11:00:00":[1,1,17,"2026-03-25 12:00:00","3"],"2026-03-26 11:00:00":[1,1,13,"2026-03-26 12:00:00","2"],"2026-03-27 11:00:00":[1,1,19,"2026-03-27 12:00:00","3"],"2026-03-28 11:00:00":[1,1,13,"2026-03-28 12:00:00","2"],"2026-03-29 11:00:00":[1,1,14,"2026-03-29 12:00:00","2"],"2026-03-30 11:00:00":[1,1,11,"2026-03-30 12:00:00","2"],"2026-03-31 11:00:00":[1,1,22,"2026-03-31 12:00:00","4"],"2026-04-01 11:00:00":[1,1,15,"2026-04-01 12:00:00","2"],"2026-04-02 11:00:00":[1,1,19,"2026-04-02 12:00:00","3"],"2026-04-03 11:00:00":[1,1,12,"2026-04-03 12:00:00","2"],"2026-04-04 11:00:00":[1,1,15,"2026-04-04 12:00:00","2"],"2026-04-05 11:00:00":[1,1,15,"2026-04-05 12:00:00","2"],"2026-04-06 11:00:00":[1,1,14,"2026-04-06 12:00:00","2"],"2026-04-07 11:00:00":[1,1,13,"2026-04-07 12:00:00","2"],"2026-04-08 11:00:00":[1,1,11,"2026-04-08 12:00:00","2"],"2026-04-09 11:00:00":[1,1,8,"2026-04-09 12:00:00","1"],"2026-04-10 11:00:00":[1,1,12,"2026-04-10 12:00:00","2"],"2026-04-11 11:00:00":[1,1,12,"2026-04-11 12:00:00","2"],"2026-04-12 11:00:00":[1,1,13,"2026-04-12 12:00:00","2"],"2026-04-13 11:00:00":[1,1,26,"2026-04-13 12:00:00","5"],"2026-04-14 11:00:00":[1,1,17,"2026-04-14 12:00:00","3"],"2026-04-15 11:00:00":[1,1,23,"2026-04-15 12:00:00","4"],"2026-04-16 11:00:00":[1,1,19,"2026-04-16 12:00:00","3"],"2026-04-17 11:00:00":[1,1,18,"2026-04-17 12:00:00","3"],"2026-04-18 11:00:00":[1,1,17,"2026-04-18 12:00:00","3"],"2026-04-19 11:00:00":[1,1,10,"2026-04-19 12:00:00","1"],"2026-04-20 11:00:00":[1,1,11,"2026-04-20 12:00:00","2"],"2026-04-21 11:00:00":[1,1,9,"2026-04-21 12:00:00","1"],"2026-04-22 11:00:00":[1,1,14,"2026-04-22 12:00:00","2"],"2026-04-23 11:00:00":[1,1,20,"2026-04-23 12:00:00","3"],"2026-04-24 11:00:00":[1,1,22,"2026-04-24 12:00:00","4"],"2026-04-25 11:00:00":[1,1,17,"2026-04-25 12:00:00","3"],"2026-04-26 11:00:00":[1,1,11,"2026-04-26 12:00:00","2"],"2026-04-27 11:00:00":[1,1,13,"2026-04-27 12:00:00","2"],"2026-04-28 11:00:00":[1,1,8,"2026-04-28 12:00:00","1"],"2026-04-29 11:00:00":[1,1,11,"2026-04-29 12:00:00","2"],"2026-04-30 11:00:00":[1,1,18,"2026-04-30 12:00:00","3"],"2026-05-01 11:00:00":[1,1,17,"2026-05-01 12:00:00","3"],"2026-05-02 11:00:00":[1,1,17,"2026-05-02 12:00:00","3"],"2026-05-03 11:00:00":[1,1,16,"2026-05-03 12:00:00","3"],"2026-05-04 11:00:00":[1,1,12,"2026-05-04 12:00:00","2"],"2026-05-05 11:00:00":[1,1,12,"2026-05-05 12:00:00","2"],"2026-05-06 11:00:00":[1,1,8,"2026-05-06 12:00:00","1"],"2026-05-07 11:00:00":[1,1,7,"2026-05-07 12:00:00","1"],"2026-05-08 11:00:00":[1,1,9,"2026-05-08 12:00:00","1"],"2026-05-09 11:00:00":[1,1,10,"2026-05-09 12:00:00","1"],"2026-05-10 11:00:00":[1,1,11,"2026-05-10 12:00:00","2"],"2026-05-11 11:00:00":[1,1,11,"2026-05-11 12:00:00","2"],"2026-05-12 11:00:00":[1,1,11,"2026-05-12 12:00:00","2"],"2026-05-13 11:00:00":[1,1,10,"2026-05-13 12:00:00","1"],"2026-05-14 11:00:00":[1,1,11,"2026-05-14 12:00:00","2"]}},"debug":{"queries":["SELECT \u0022li\u0022.\u0022li_createdon\u0022 AS \u0022li_createdon\u0022\nFROM\nlast_imports \u0022li\u0022\nWHERE \u0022li_type\u0022 = \u0027sta\u0027","SELECT \u0022sta\u0022.\u0022sta_id\u0022 AS \u0022sta_id\u0022, \u0022sta\u0022.\u0022sta_code\u0022 AS \u0022sta_code\u0022, \u0022sta\u0022.\u0022sta_name\u0022 AS \u0022sta_name\u0022, \u0022sta\u0022.\u0022sta_city\u0022 AS \u0022sta_city\u0022, \u0022sta\u0022.\u0022sta_synonym\u0022 AS \u0022sta_synonym\u0022, \u0022sta\u0022.\u0022sta_active_from\u0022 AS \u0022sta_active_from\u0022, \u0022sta\u0022.\u0022sta_active_to\u0022 AS \u0022sta_active_to\u0022, \u0022sta\u0022.\u0022sta_lng\u0022 AS \u0022sta_lng\u0022, \u0022sta\u0022.\u0022sta_lat\u0022 AS \u0022sta_lat\u0022, \u0022sta\u0022.\u0022sta_network\u0022 AS \u0022sta_network\u0022, \u0022sta\u0022.\u0022sta_setting\u0022 AS \u0022sta_setting\u0022, \u0022sta\u0022.\u0022sta_type\u0022 AS \u0022sta_type\u0022, \u0022net\u0022.\u0022net_code\u0022 AS \u0022net_code\u0022, IF(net_name_de = \u0027\u0027, net_name_de, net_name_de) AS \u0022net_name\u0022, IF(staset_name_de = \u0027\u0027, staset_name_de, staset_name_de) AS \u0022staset_name\u0022, IF(staset_short_de = \u0027\u0027, IF(staset_short_de = \u0027\u0027, staset_name_de, staset_short_de), staset_short_de) AS \u0022staset_short\u0022, IF(statyp_name_de = \u0027\u0027, statyp_name_de, statyp_name_de) AS \u0022statyp_name\u0022, sta.sta_street AS \u0022sta_street\u0022, sta.sta_street_nr AS \u0022sta_street_nr\u0022, sta.sta_zip AS \u0022sta_zip\u0022\nFROM\nstations \u0022sta\u0022\nINNER JOIN networks \u0022net\u0022 ON net.net_id = sta.sta_network\nINNER JOIN station_settings \u0022staset\u0022 ON staset.staset_id = sta.sta_setting\nINNER JOIN station_types \u0022statyp\u0022 ON statyp.statyp_id = sta.sta_type","SELECT \u0022li\u0022.\u0022li_createdon\u0022 AS \u0022li_createdon\u0022\nFROM\nlast_imports \u0022li\u0022\nWHERE \u0022li_type\u0022 = \u0027mea\u0027","SELECT \u0022mea\u0022.\u0022mea_component\u0022 AS \u0022mea_component\u0022, \u0022mea\u0022.\u0022mea_scope\u0022 AS \u0022mea_scope\u0022, \u0022mea\u0022.\u0022mea_station\u0022 AS \u0022mea_station\u0022, \u0022mea\u0022.\u0022mea_value\u0022 AS \u0022mea_value\u0022, \u0022mea\u0022.\u0022mea_date_start\u0022 AS \u0022mea_date_start\u0022, CONCAT(DATE_FORMAT(mea.mea_date_start, \u0027%Y-%m-%d\u0027), \u0027 \u0027, LPAD((DATE_FORMAT(mea.mea_date_start, \u0027%H\u0027) + 1), 2, 0), \u0027:00:00\u0027) AS \u0022mea_date_end\u0022, (\n      SELECT thr.thr_index\n      FROM thresholds thr\n      WHERE\n      thr.thr_type = \u0027me\u0027\n      \u0026\u0026 thr.thr_component = mea.mea_component\n      \u0026\u0026 thr.thr_scope = mea.mea_scope\n      \u0026\u0026 IF(mea.mea_component = 2, mea.mea_value * 1000, mea.mea_value) \u003E= thr.thr_min\n      \u0026\u0026 IF(mea.mea_component = 2, mea.mea_value * 1000, mea.mea_value) \u003C= thr.thr_max\n    ) AS \u0022idx\u0022\nFROM\nmeasurements \u0022mea\u0022\nWHERE (\u0022mea_date_start\u0022 \u003E= \u00272026-01-01 00:00:00\u0027) AND (\u0022mea_date_start\u0022 \u003C= \u00272026-12-31 23:00:00\u0027) AND (\u0022mea\u0022.\u0022mea_station\u0022 = \u00271580\u0027) AND (\u0022mea\u0022.\u0022mea_scope\u0022 = \u00271\u0027) AND (\u0022mea\u0022.\u0022mea_component\u0022 = \u00271\u0027)"],"cache_key_prefix":[{"sta":"2026-05-15 06:01:18"},{"mea":"2026-05-15 06:03:28"}],"GET":{"station":"1580","component":"1","scope":"1","date_from":"2026-01-01","time_from":"1","date_to":"2026-12-31","time_to":"24","lang":"de"},"params":{"component":"1","scope":"1","station":"1580","date_from":"2026-01-01","date_to":"2026-12-31","time_from":"01:00:00","time_to":"24:00:00","lang":"de","recent":false,"index":"id","datetime_from":"2026-01-01 00:00:00","datetime_to":"2026-12-31 23:00:00"},"execution_time":"1.8289179802"}}