| 1.0180 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT weather_data.id AS weather_data_id, weather_data.created_at AS weather_data_created_at, weather_data."temp" AS weather_data_temp, weather_data.pressure AS weather_data_pressure, weather_data.temp_min AS weather_data_temp_min, weather_data.temp_max AS weather_data_temp_max, weather_data.humidity AS weather_data_humidity, weather_data.wind_speed AS weather_data_wind_speed, weather_data.wind_gust AS weather_data_wind_gust, weather_data.wind_deg AS weather_data_wind_deg, weather_data.clouds AS weather_data_clouds, weather_data.rain AS weather_data_rain, weather_data.snow AS weather_data_snow, weather_data.weather_id AS weather_data_weather_id, weather_data.sunrise AS weather_data_sunrise, weather_data.sunset AS weather_data_sunset
FROM weather_data ORDER BY weather_data.id DESC
LIMIT ? OFFSET ?
|
| 0.2079 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT weather_data.id AS weather_data_id, weather_data.created_at AS weather_data_created_at, weather_data."temp" AS weather_data_temp, weather_data.pressure AS weather_data_pressure, weather_data.temp_min AS weather_data_temp_min, weather_data.temp_max AS weather_data_temp_max, weather_data.humidity AS weather_data_humidity, weather_data.wind_speed AS weather_data_wind_speed, weather_data.wind_gust AS weather_data_wind_gust, weather_data.wind_deg AS weather_data_wind_deg, weather_data.clouds AS weather_data_clouds, weather_data.rain AS weather_data_rain, weather_data.snow AS weather_data_snow, weather_data.weather_id AS weather_data_weather_id, weather_data.sunrise AS weather_data_sunrise, weather_data.sunset AS weather_data_sunset
FROM weather_data ORDER BY weather_data.id DESC
LIMIT ? OFFSET ?
|
| 0.3381 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT weather_data."temp" AS weather_data_temp, weather_data.weather_id AS weather_data_weather_id
FROM weather_data
WHERE weather_data.created_at >= ? ORDER BY weather_data.id DESC
LIMIT ? OFFSET ?
|
| 0.4890 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT pvdata.id AS pvdata_id, pvdata.created_at AS pvdata_created_at, pvdata.dc_1_u AS pvdata_dc_1_u, pvdata.dc_1_i AS pvdata_dc_1_i, pvdata.ac_1_u AS pvdata_ac_1_u, pvdata.ac_1_p AS pvdata_ac_1_p, pvdata.dc_2_u AS pvdata_dc_2_u, pvdata.dc_2_i AS pvdata_dc_2_i, pvdata.ac_2_u AS pvdata_ac_2_u, pvdata.ac_2_p AS pvdata_ac_2_p, pvdata.dc_3_u AS pvdata_dc_3_u, pvdata.dc_3_i AS pvdata_dc_3_i, pvdata.ac_3_u AS pvdata_ac_3_u, pvdata.ac_3_p AS pvdata_ac_3_p, pvdata.current_power AS pvdata_current_power, pvdata.daily_energy AS pvdata_daily_energy, pvdata.total_energy AS pvdata_total_energy, pvdata.status_id AS pvdata_status_id, pvdata.dc_p_1 AS pvdata_dc_p_1, pvdata.dc_p_2 AS pvdata_dc_p_2, pvdata.dc_p_3 AS pvdata_dc_p_3
FROM pvdata ORDER BY pvdata.id DESC
LIMIT ? OFFSET ?
|
| 0.3500 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT zaehler."1_8_0" AS zaehler_1_8_0, zaehler."2_8_0" AS zaehler_2_8_0, zaehler.id AS zaehler_id, zaehler.created_at AS zaehler_created_at, zaehler.total_energy AS zaehler_total_energy
FROM zaehler ORDER BY zaehler.id DESC
LIMIT ? OFFSET ?
|
| 135.1020 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT max(pvdata.current_power) AS todays_max_power
FROM pvdata
WHERE pvdata.created_at >= ?
LIMIT ? OFFSET ?
|
| 121.6121 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT max(pvdata.daily_energy) AS max_daily_energy
FROM pvdata
WHERE pvdata.created_at >= ?
LIMIT ? OFFSET ?
|
| 0.0989 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT electricity_data.id AS electricity_data_id, electricity_data.created_at AS electricity_data_created_at, electricity_data.meter_180 AS electricity_data_meter_180, electricity_data.meter_280 AS electricity_data_meter_280, electricity_data.active_power AS electricity_data_active_power
FROM electricity_data ORDER BY electricity_data.id DESC
LIMIT ? OFFSET ?
|
| 0.0679 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT electricity_data.meter_280 AS electricity_data_meter_280
FROM electricity_data
WHERE strftime(?, electricity_data.created_at) = ? ORDER BY electricity_data.id DESC
LIMIT ? OFFSET ?
|
| 0.0839 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT max(electricity_data.meter_280) - min(electricity_data.meter_280) AS todays_export, max(electricity_data.meter_180) - min(electricity_data.meter_180) AS todays_import
FROM electricity_data
WHERE strftime(?, electricity_data.created_at) = ? GROUP BY strftime(?, electricity_data.created_at)
LIMIT ? OFFSET ?
|
| 31.8081 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT pvdata.total_energy AS pvdata_total_energy
FROM pvdata
WHERE strftime(?, pvdata.created_at) = ? ORDER BY pvdata.id DESC
LIMIT ? OFFSET ?
|
| 502.5070 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT
month,
avg(monthly_yield),
min(monthly_yield),
max(monthly_yield)
FROM (
SELECT
strftime('%m', created_at) AS month,
max(total_energy) - min(total_energy) AS monthly_yield
FROM pvdata
WHERE strftime('%Y', created_at) < ?
GROUP BY strftime('%Y-%m', created_at)
) subq
WHERE monthly_yield > 0
GROUP BY month
ORDER BY month;
|
| 247.7651 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT max(pvdata.total_energy) - min(pvdata.total_energy) AS total_energy
FROM pvdata
WHERE strftime(?, pvdata.created_at) = ? GROUP BY strftime(?, pvdata.created_at)
|
| 10.4699 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT max(zaehler.total_energy) AS max_total, min(zaehler.total_energy) AS min_total, max(zaehler."1_8_0") AS max_import, min(zaehler."1_8_0") AS min_import, max(zaehler."2_8_0") AS max_export, min(zaehler."2_8_0") AS min_export
FROM zaehler
WHERE date(zaehler.created_at) = ?
LIMIT ? OFFSET ?
|
| 10.2739 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT max(zaehler."1_8_0") AS max_import, min(zaehler."1_8_0") AS min_import
FROM zaehler
WHERE date(zaehler.created_at) = ?
LIMIT ? OFFSET ?
|
| 10.0808 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT max(zaehler.total_energy) AS max_total, min(zaehler.total_energy) AS min_total, max(zaehler."1_8_0") AS max_import, min(zaehler."1_8_0") AS min_import, max(zaehler."2_8_0") AS max_export, min(zaehler."2_8_0") AS min_export
FROM zaehler
WHERE date(zaehler.created_at) = ?
LIMIT ? OFFSET ?
|
| 10.2768 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT max(zaehler."1_8_0") AS max_import, min(zaehler."1_8_0") AS min_import
FROM zaehler
WHERE date(zaehler.created_at) = ?
LIMIT ? OFFSET ?
|
| 10.2341 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT max(zaehler.total_energy) AS max_total, min(zaehler.total_energy) AS min_total, max(zaehler."1_8_0") AS max_import, min(zaehler."1_8_0") AS min_import, max(zaehler."2_8_0") AS max_export, min(zaehler."2_8_0") AS min_export
FROM zaehler
WHERE date(zaehler.created_at) = ?
LIMIT ? OFFSET ?
|
| 10.1981 |
SELECT
EXPLAIN
|
<unknown>
|
SELECT max(zaehler.total_energy) AS max_total, min(zaehler.total_energy) AS min_total, max(zaehler."1_8_0") AS max_import, min(zaehler."1_8_0") AS min_import, max(zaehler."2_8_0") AS max_export, min(zaehler."2_8_0") AS min_export
FROM zaehler
WHERE date(zaehler.created_at) = ?
LIMIT ? OFFSET ?
|