Smarthome App | Smarthome Blogger

In dieser Kategorie findest du alles, was du wissen musst, um dir deine eigene Android App für dein Smarthome System programmieren zu können.

Smarthome App #14: Verlauf der Tageswerte anzeigen

Smarthome App #13: Sensorwerteverlauf anzeigen

Smarthome App #12: Ereignisse im Smarthome anzeigen

Smarthome App #11: Übersicht der Sensoren

Smarthome App #10: Modularisierung der App

Smarthome App #9: Anpassung an Systemänderungen & Login-Daten speichern

Smarthome App #8: Raumsteuerung (2/2)

Smarthome App #7: Raumsteuerung (1/2)

Smarthome App #6: Einstellungs-Bildschirm (2/2)

Smarthome App #5: Einstellungs-Bildschirm (1/2)

Smarthome App #4: Menüpunkte auswählen

Smarthome App #3: Hauptmenü

Smarthome App #2: Login-Bildschirm

Smarthome App #1: Projekt erstellen & erste Schritte

38 Anfragen; Gesamtdauer: 30.38215637207 Millisekunden

Query	Dauer (ms)
SELECT * FROM user__session where (session_key = "d5fc62080e00ed42b31d6e5c34492eca" and session_expires > CURRENT_TIMESTAMP())	0.74505805969238
SELECT * FROM user__session where (session_key = "d5fc62080e00ed42b31d6e5c34492eca" and session_expires > CURRENT_TIMESTAMP())	0.22602081298828
SELECT *, (page_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(page_date, "%d.%m.%Y") as formatted_date FROM page where permalink = "app" LIMIT 1	0.50806999206543
SELECT *, (post_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(post_date, "%d.%m.%Y") as formatted_date FROM post where permalink = "app" LIMIT 1	0.95701217651367
SELECT post__taxonomy.* FROM post__taxonomy where permalink = "app";	0.80704689025879
SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1	0.24604797363281
SELECT * FROM post__taxonomy where (status = "publish") order by title ASC	0.35810470581055
SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1	0.21886825561523
SELECT post.*, (post_date <= NOW() AND status = "publish") as is_already_published FROM post JOIN post__taxonomy_mapping ON post.post_id = post__taxonomy_mapping.post_id where (post_date <= NOW() AND status = "publish") and post__taxonomy_mapping.taxonomy_id = 11 ORDER BY post.post_date DESC	4.8379898071289
SELECT * FROM post__meta where post_id IN (71, 70, 69, 68, 67, 65, 60, 58, 57, 56, 55, 53, 51, 50)	5.3069591522217
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 71	0.57506561279297
SELECT file_path FROM attachment where attachment_id = 221	0.44989585876465
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 70	0.88405609130859
SELECT file_path FROM attachment where attachment_id = 217	0.24700164794922
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 69	0.76794624328613
SELECT file_path FROM attachment where attachment_id = 205	0.5500316619873
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 68	0.6098747253418
SELECT file_path FROM attachment where attachment_id = 197	0.60296058654785
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 67	0.61583518981934
SELECT file_path FROM attachment where attachment_id = 196	0.25105476379395
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 65	0.90885162353516
SELECT file_path FROM attachment where attachment_id = 190	0.3199577331543
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 60	0.79798698425293
SELECT file_path FROM attachment where attachment_id = 163	0.31590461730957
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 58	0.6868839263916
SELECT file_path FROM attachment where attachment_id = 162	0.579833984375
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 57	1.4309883117676
SELECT file_path FROM attachment where attachment_id = 152	0.59103965759277
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 56	0.75006484985352
SELECT file_path FROM attachment where attachment_id = 151	0.2288818359375
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 55	0.82302093505859
SELECT file_path FROM attachment where attachment_id = 150	0.30994415283203
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 53	0.62394142150879
SELECT file_path FROM attachment where attachment_id = 127	0.35691261291504
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 51	0.59604644775391
SELECT file_path FROM attachment where attachment_id = 124	0.24509429931641
SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 50	0.51498413085938
SELECT file_path FROM attachment where attachment_id = 122	0.53691864013672