Ok, ich hab das debug jetzt an die Datenabfrage angehängt, siehe Textdatei.
Seltsamerweise geht die Abfrage normal schnell?!?
Ah moment, in debug_new.txt ist die URL die das alte frontend erzeugt, wenn man
auf "Jahr" drückt (hatte die URL kopiert und nur den Namen angepasst).
Hier die Version vom aktuellen frontend in debug_fehler.txt
Gruß
Volker
Am 29.04.2015 um 17:49 schrieb Andreas Goetz:
> Hallo Volker,
>
> 2015-04-29 17:39 GMT+02:00 Volker <v.ty at gmx.de <mailto:v.ty at gmx.de>>:
>
> Hallo,
>
> mir ist aufgefallen dass die aktuelle Middleware (mittels git pull
> aktualisiert, composer update durchgeführt) aggregation anscheinend nicht
> mehr nutzt. Im Frontend ein Jahr aufgerufen dauert mehrere Minuten
> (Minutenwerte, 4 Kanäle). SQL und Middleware läuft auf einen BananaPi,
> Webserver apache2.
> Das parallel installierte Produktivsystem (git Version aktualisiert am
> 24.2., gleiche Datenbank) benötigt dafür <2s.
> volkszaehler.conf.php ist identisch mit $config['aggregation'] = true;
>
> Haben sich in den letzten Wochen irgendwelche Einstellungen geändert die ich
> noch nachziehen muss?
>
>
> Kannst Du mal bitte capabilities/database.json auf der Middleware aufrufen und-
> dort wo es nciht funktioniert- ein &debug=1 an die Middlewareabfrage anhängen?
>
> Viele Grüße,
> Andreas
>
>
>
> Viele Grüße
> Volker
>
>
--
Volker Troyke
Homepage: www.troyke.de
E-Mail : v.ty at gmx.de
-------------- next part --------------
http://vs-nas/vz_new/middleware.php/data.json?from=1398788286835&to=1430324286835&tuples=424&uuid[]=eb730440-ecd1-11e0-88ea-4106976315db&group=day&debug=1
{
"version": "0.3",
"data": [
{
"uuid": "eb730440-ecd1-11e0-88ea-4106976315db",
"from": 1398808768000,
"to": 1430324352000,
"min": [
1407189568000,
142.70833333333
],
"max": [
1402351168000,
827.375
],
"average": 354.882,
"consumption": 3106753,
"rows": 366,
"tuples": [
[
1398895168000,
450.667,
1350
],
[
1398981568000,
331.5,
1350
],
[
1399067968000,
540.167,
1350
],
[
1399154368000,
501.583,
1350
],
[
1399240768000,
410.542,
1350
],
[
1399327168000,
227.292,
1346
],
[
1399413568000,
249.75,
1350
],
[
1399499968000,
232.917,
1350
],
[
1399586368000,
213.75,
1350
],
[
1399672768000,
402.042,
1350
],
[
1399759168000,
315.5,
1350
],
[
1399845568000,
197.208,
1350
],
[
1399931968000,
265.292,
1350
],
[
1400018368000,
296.667,
1350
],
[
1400104768000,
463.792,
1350
],
[
1400191168000,
420.667,
1350
],
[
1400277568000,
362.667,
1350
],
[
1400363968000,
734.542,
1350
],
[
1400450368000,
383.625,
1350
],
[
1400536768000,
262.625,
1350
],
[
1400623168000,
762.833,
1350
],
[
1400709568000,
354.875,
1350
],
[
1400795968000,
395.583,
1350
],
[
1400882368000,
408.875,
1350
],
[
1400968768000,
262.917,
1350
],
[
1401055168000,
384,
1350
],
[
1401141568000,
264.208,
1350
],
[
1401227968000,
296.083,
1350
],
[
1401314368000,
312.917,
1350
],
[
1401400768000,
310.25,
1350
],
[
1401487168000,
337.417,
1350
],
[
1401573568000,
260,
1350
],
[
1401659968000,
389.583,
1350
],
[
1401746368000,
505.417,
1350
],
[
1401832768000,
252.208,
1350
],
[
1401919168000,
550.708,
1350
],
[
1402005568000,
512.542,
1350
],
[
1402091968000,
534.042,
1350
],
[
1402178368000,
492.167,
1350
],
[
1402264768000,
422.458,
1350
],
[
1402351168000,
827.375,
1350
],
[
1402437568000,
277.333,
1350
],
[
1402523968000,
223.083,
1350
],
[
1402610368000,
199.625,
1350
],
[
1402696768000,
220.667,
1350
],
[
1402783168000,
195.542,
1350
],
[
1402869568000,
185.833,
1350
],
[
1402955968000,
185,
1350
],
[
1403042368000,
185.958,
1350
],
[
1403128768000,
207.042,
1350
],
[
1403215168000,
237.542,
1350
],
[
1403301568000,
401.875,
1350
],
[
1403387968000,
690.333,
1350
],
[
1403474368000,
545.542,
1350
],
[
1403560768000,
395.292,
1350
],
[
1403647168000,
542.375,
1350
],
[
1403733568000,
362.5,
1350
],
[
1403819968000,
277.417,
1350
],
[
1403906368000,
346.375,
1350
],
[
1403992768000,
371.792,
1350
],
[
1404079168000,
389.5,
1350
],
[
1404165568000,
357.375,
1350
],
[
1404251968000,
315.792,
1350
],
[
1404338368000,
296.583,
1350
],
[
1404424768000,
400.167,
1350
],
[
1404511168000,
374.375,
1350
],
[
1404597568000,
417.958,
1350
],
[
1404683968000,
549.5,
1350
],
[
1404770368000,
404.292,
1350
],
[
1404856768000,
474.542,
1350
],
[
1404943168000,
348.208,
1350
],
[
1405029568000,
278.208,
1350
],
[
1405115968000,
469.292,
1350
],
[
1405202368000,
307.417,
1350
],
[
1405288768000,
450.333,
1350
],
[
1405375168000,
314.083,
1350
],
[
1405461568000,
457.75,
1350
],
[
1405547968000,
600.708,
1350
],
[
1405634368000,
469.75,
1350
],
[
1405720768000,
479.333,
1350
],
[
1405807168000,
588.667,
1350
],
[
1405893568000,
573.542,
1350
],
[
1405979968000,
607.083,
1350
],
[
1406066368000,
483.542,
1350
],
[
1406152768000,
607,
1350
],
[
1406239168000,
369.958,
1350
],
[
1406325568000,
622.417,
1350
],
[
1406411968000,
607.5,
1350
],
[
1406498368000,
520,
1350
],
[
1406584768000,
208.125,
1350
],
[
1406671168000,
143.875,
1350
],
[
1406757568000,
146.292,
1350
],
[
1406843968000,
145.792,
1350
],
[
1406930368000,
156.333,
1350
],
[
1407016768000,
164.083,
1350
],
[
1407103168000,
145.625,
1350
],
[
1407189568000,
142.708,
1350
],
[
1407275968000,
145.208,
1350
],
[
1407362368000,
148.625,
1350
],
[
1407448768000,
147.042,
1350
],
[
1407535168000,
284.375,
1350
],
[
1407621568000,
758.25,
1347
],
[
1407707968000,
557.917,
1350
],
[
1407794368000,
362.417,
1350
],
[
1407880768000,
391.417,
1350
],
[
1407967168000,
441.417,
1350
],
[
1408053568000,
283.75,
1350
],
[
1408139968000,
349.833,
1350
],
[
1408226368000,
306.417,
1350
],
[
1408312768000,
382.625,
1350
],
[
1408399168000,
270.917,
1350
],
[
1408485568000,
241.5,
1350
],
[
1408571968000,
355.583,
1350
],
[
1408658368000,
229.167,
1350
],
[
1408744768000,
327.542,
1350
],
[
1408831168000,
332.042,
1350
],
[
1408917568000,
327.458,
1350
],
[
1409003968000,
314.833,
1350
],
[
1409090368000,
257.25,
1350
],
[
1409176768000,
300.25,
1350
],
[
1409263168000,
245.625,
1350
],
[
1409349568000,
310.792,
1350
],
[
1409435968000,
615.042,
1350
],
[
1409522368000,
364.167,
1350
],
[
1409608768000,
323.083,
1350
],
[
1409695168000,
205.25,
1350
],
[
1409781568000,
289.875,
1350
],
[
1409867968000,
254.208,
1350
],
[
1409954368000,
398.625,
1350
],
[
1410040768000,
391.958,
1350
],
[
1410127168000,
468.667,
1350
],
[
1410213568000,
353.167,
1350
],
[
1410299968000,
333.875,
1350
],
[
1410386368000,
368.042,
1350
],
[
1410472768000,
462.625,
1350
],
[
1410559168000,
311.833,
1350
],
[
1410645568000,
375.208,
1350
],
[
1410731968000,
403.083,
1350
],
[
1410818368000,
314.292,
1350
],
[
1410904768000,
314.667,
1350
],
[
1410991168000,
320.75,
1350
],
[
1411077568000,
325.25,
1350
],
[
1411163968000,
408.333,
1350
],
[
1411250368000,
364.542,
1350
],
[
1411336768000,
381.167,
1350
],
[
1411423168000,
315.542,
1350
],
[
1411509568000,
223.458,
1350
],
[
1411595968000,
404.292,
1350
],
[
1411682368000,
320.75,
1350
],
[
1411768768000,
494.083,
1350
],
[
1411855168000,
373.208,
1350
],
[
1411941568000,
312.375,
1350
],
[
1412027968000,
355.458,
1350
],
[
1412114368000,
312.583,
1350
],
[
1412200768000,
281.708,
1350
],
[
1412287168000,
324.583,
1350
],
[
1412373568000,
255.833,
1350
],
[
1412459968000,
381.833,
1350
],
[
1412546368000,
285.417,
1350
],
[
1412632768000,
234.667,
1350
],
[
1412719168000,
360.917,
1350
],
[
1412805568000,
310.792,
1350
],
[
1412891968000,
428.833,
1350
],
[
1412978368000,
273,
1350
],
[
1413064768000,
324.958,
1350
],
[
1413151168000,
356.583,
1350
],
[
1413237568000,
236.083,
1350
],
[
1413323968000,
316.5,
1350
],
[
1413410368000,
295.875,
1350
],
[
1413496768000,
220.833,
1350
],
[
1413583168000,
411.75,
1350
],
[
1413669568000,
403.583,
1350
],
[
1413755968000,
282.958,
1350
],
[
1413842368000,
295.333,
1350
],
[
1413928768000,
222.042,
1350
],
[
1414015168000,
278.125,
1350
],
[
1414101568000,
399.208,
1350
],
[
1414187968000,
345.417,
1350
],
[
1414274368000,
413.667,
1350
],
[
1414364352000,
369.906,
1406
],
[
1414450752000,
363.042,
1350
],
[
1414537152000,
654.583,
1350
],
[
1414623552000,
373.583,
1350
],
[
1414709952000,
232.417,
1348
],
[
1414796352000,
327.958,
1350
],
[
1414882752000,
318.042,
1350
],
[
1414969152000,
295.542,
1348
],
[
1415055552000,
258.208,
1350
],
[
1415141952000,
292.792,
1350
],
[
1415228352000,
221.833,
1350
],
[
1415314752000,
260.125,
1350
],
[
1415401152000,
345.625,
1350
],
[
1415487552000,
289.417,
1350
],
[
1415573952000,
236.042,
1350
],
[
1415660352000,
411.917,
1350
],
[
1415746752000,
275.083,
1350
],
[
1415833152000,
460.667,
1350
],
[
1415919552000,
235.042,
1350
],
[
1416005952000,
354.167,
1350
],
[
1416092352000,
357.167,
1350
],
[
1416178752000,
356.042,
1350
],
[
1416265152000,
268.333,
1350
],
[
1416351552000,
379.208,
1350
],
[
1416437952000,
341,
1350
],
[
1416524352000,
236.958,
1350
],
[
1416610752000,
354.208,
1350
],
[
1416697152000,
379.25,
1350
],
[
1416783552000,
327.833,
1350
],
[
1416869952000,
270.833,
1350
],
[
1416956352000,
296.292,
1350
],
[
1417042752000,
366.417,
1350
],
[
1417129152000,
344,
1350
],
[
1417215552000,
488.458,
1350
],
[
1417301952000,
457.292,
1350
],
[
1417388352000,
360.708,
1350
],
[
1417474752000,
341.5,
1350
],
[
1417561152000,
646.792,
1350
],
[
1417647552000,
353.667,
1350
],
[
1417733952000,
320.833,
1350
],
[
1417820352000,
384.625,
1350
],
[
1417906752000,
409.917,
1350
],
[
1417993152000,
336.042,
1350
],
[
1418079552000,
416.833,
1350
],
[
1418165952000,
417.625,
1350
],
[
1418252352000,
374.125,
1350
],
[
1418338752000,
324.5,
1350
],
[
1418425152000,
485.875,
1350
],
[
1418511552000,
398.958,
1350
],
[
1418597952000,
355.208,
1350
],
[
1418684352000,
295.833,
1350
],
[
1418770752000,
346.958,
1350
],
[
1418857152000,
289.333,
1350
],
[
1418943552000,
336.292,
1350
],
[
1419029952000,
455.583,
1350
],
[
1419116352000,
532.792,
1350
],
[
1419202752000,
377.042,
1350
],
[
1419289152000,
520.417,
1350
],
[
1419375552000,
447.708,
1350
],
[
1419461952000,
496.542,
1350
],
[
1419548352000,
522.458,
1350
],
[
1419634752000,
404.042,
1350
],
[
1419721152000,
518.292,
1350
],
[
1419807552000,
563.792,
1350
],
[
1419893952000,
335,
1350
],
[
1419980352000,
468.75,
1350
],
[
1420066752000,
738.167,
1350
],
[
1420153152000,
509.958,
1350
],
[
1420239552000,
410.958,
1350
],
[
1420325952000,
440.375,
1350
],
[
1420412352000,
357.917,
1350
],
[
1420498752000,
408.125,
1342
],
[
1420585152000,
331.708,
1350
],
[
1420671552000,
357.5,
1350
],
[
1420757952000,
327.167,
1350
],
[
1420844352000,
365.083,
1350
],
[
1420930752000,
388.208,
1350
],
[
1421017152000,
257.625,
1350
],
[
1421103552000,
498.25,
1350
],
[
1421189952000,
313.875,
1350
],
[
1421276352000,
529.667,
1350
],
[
1421362752000,
272.25,
1350
],
[
1421449152000,
321.458,
1350
],
[
1421535552000,
321.25,
1350
],
[
1421621952000,
308.542,
1350
],
[
1421708352000,
364,
1350
],
[
1421794752000,
293.708,
1350
],
[
1421881152000,
303,
1350
],
[
1421967552000,
313,
1350
],
[
1422053952000,
360.708,
1350
],
[
1422140352000,
253.042,
1350
],
[
1422226752000,
311.25,
1350
],
[
1422313152000,
340.417,
1350
],
[
1422399552000,
335.667,
1350
],
[
1422485952000,
371.583,
1350
],
[
1422572352000,
354.875,
1350
],
[
1422658752000,
391,
1350
],
[
1422745152000,
417.167,
1350
],
[
1422831552000,
350.958,
1350
],
[
1422917952000,
293.458,
1350
],
[
1423004352000,
447.583,
1350
],
[
1423090752000,
216.167,
1350
],
[
1423177152000,
259.583,
1350
],
[
1423263552000,
394.292,
1350
],
[
1423349952000,
369.917,
1350
],
[
1423436352000,
360.792,
1350
],
[
1423522752000,
358.708,
1350
],
[
1423609152000,
297.042,
1350
],
[
1423695552000,
253.708,
1350
],
[
1423781952000,
279.208,
1350
],
[
1423868352000,
302.5,
1350
],
[
1423954752000,
575.417,
1350
],
[
1424041152000,
390,
1350
],
[
1424127552000,
291.917,
1350
],
[
1424213952000,
312.875,
1350
],
[
1424300352000,
281.083,
1350
],
[
1424386752000,
326.667,
1350
],
[
1424473152000,
341.708,
1350
],
[
1424559552000,
285.125,
1350
],
[
1424645952000,
368,
1350
],
[
1424732352000,
390.292,
1350
],
[
1424818752000,
321.542,
1350
],
[
1424905152000,
429.667,
1350
],
[
1424991552000,
228,
1350
],
[
1425077952000,
345.042,
1350
],
[
1425164352000,
312,
1350
],
[
1425250752000,
412.083,
1349
],
[
1425337152000,
245.167,
1350
],
[
1425423552000,
456.25,
1350
],
[
1425509952000,
280.792,
1350
],
[
1425596352000,
234.458,
1350
],
[
1425682752000,
339,
1350
],
[
1425769152000,
274.833,
1350
],
[
1425855552000,
334.292,
1350
],
[
1425941952000,
219.542,
1350
],
[
1426028352000,
372.125,
1350
],
[
1426114752000,
499.917,
1350
],
[
1426201152000,
268.833,
1350
],
[
1426287552000,
314.708,
1350
],
[
1426373952000,
347.708,
1350
],
[
1426460352000,
369.25,
1350
],
[
1426546752000,
250.042,
1350
],
[
1426633152000,
346.042,
1350
],
[
1426719552000,
283.042,
1350
],
[
1426805952000,
282.208,
1350
],
[
1426892352000,
554.583,
1350
],
[
1426978752000,
296.083,
1350
],
[
1427065152000,
321.958,
1350
],
[
1427151552000,
310.75,
1350
],
[
1427237952000,
353.5,
1350
],
[
1427324352000,
291.833,
1350
],
[
1427410752000,
292.792,
1350
],
[
1427497152000,
290.042,
1350
],
[
1427583552000,
356.708,
1350
],
[
1427666368000,
298.116,
1294
],
[
1427752768000,
241.083,
1350
],
[
1427839168000,
284.75,
1350
],
[
1427925568000,
216.833,
1350
],
[
1428011968000,
288.792,
1350
],
[
1428098368000,
273.083,
1350
],
[
1428184768000,
298.875,
1350
],
[
1428271168000,
245.917,
1350
],
[
1428357568000,
369.25,
1350
],
[
1428443968000,
302.208,
1350
],
[
1428530368000,
384.667,
1350
],
[
1428616768000,
254.875,
1350
],
[
1428703168000,
417.583,
1350
],
[
1428789568000,
420.458,
1350
],
[
1428875968000,
321.583,
1350
],
[
1428962368000,
431.958,
1350
],
[
1429048768000,
550.958,
1350
],
[
1429135168000,
420.583,
1350
],
[
1429221568000,
310.833,
1350
],
[
1429307968000,
310.25,
1350
],
[
1429394368000,
279.958,
1350
],
[
1429480768000,
368.083,
1350
],
[
1429567168000,
250.333,
1350
],
[
1429653568000,
327.708,
1350
],
[
1429739968000,
265.75,
1350
],
[
1429826368000,
288,
1350
],
[
1429912768000,
443.042,
1350
],
[
1429999168000,
437.25,
1350
],
[
1430085568000,
266.25,
1350
],
[
1430171968000,
253.625,
1350
],
[
1430258368000,
342.125,
1350
],
[
1430324352000,
240.113,
1030
]
]
}
],
"debug": {
"level": "1",
"database": "pdo_mysql",
"time": 0.37821,
"uptime": 1483179080,
"load": [
0.09,
0.13,
0.13
],
"commit-hash": "8840d90e18a7865e6fca5e9a6ff1b78eb884adb0\n",
"php-version": "5.4.39-0+deb7u2",
"messages": [],
"sqlTotalTime": 0.18340921401978,
"sqlWorstTime": 0.11418414115906,
"queries": [
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC LIMIT 2) t",
"params": [
7,
1398788286835
],
"types": [],
"executionMS": 0.0034699440002441
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC LIMIT 2) t",
"params": [
7,
1430324286835
],
"types": [],
"executionMS": 0.002655029296875
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS count FROM aggregate INNER JOIN entities ON aggregate.channel_id = entities.id WHERE uuid = ? AND aggregate.type <= ? GROUP BY type HAVING count > 0 ORDER BY type DESC",
"params": [
"eb730440-ecd1-11e0-88ea-4106976315db",
3
],
"types": [],
"executionMS": 0.00062108039855957
},
{
"sql": "SELECT UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) * 1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
7,
3,
1398788160000
],
"types": [],
"executionMS": 0.0005800724029541
},
{
"sql": "SELECT UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) \/ 1000, \"%Y-%m-%d\"), INTERVAL 1 day)) * 1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp<?",
"params": [
7,
3,
1430324352000
],
"types": [],
"executionMS": 0.0017549991607666
},
{
"sql": "SELECT COUNT(1) FROM (SELECT DISTINCT YEAR(FROM_UNIXTIME(timestamp\/1000)), DAYOFYEAR(FROM_UNIXTIME(timestamp\/1000)) FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp < ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT DISTINCT YEAR(FROM_UNIXTIME(timestamp\/1000)), DAYOFYEAR(FROM_UNIXTIME(timestamp\/1000)) FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >= ? AND timestamp < ?) AS agg",
"params": [
7,
1398788160000,
"1398722400000",
"1430258400000",
1430324352000,
7,
3,
"1398722400000",
"1430258400000"
],
"types": [],
"executionMS": 0.060143947601318
},
{
"sql": "SELECT MAX(timestamp) AS timestamp, SUM(value) AS value, SUM(count) AS count FROM (SELECT timestamp, value, 1 AS count FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp < ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT timestamp, value, count FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >= ? AND timestamp < ?) AS agg GROUP BY YEAR(FROM_UNIXTIME(timestamp\/1000)), DAYOFYEAR(FROM_UNIXTIME(timestamp\/1000)) ORDER BY timestamp ASC",
"params": [
7,
1398788160000,
"1398722400000",
"1430258400000",
1430324352000,
7,
3,
"1398722400000",
"1430258400000"
],
"types": [],
"executionMS": 0.11418414115906
}
]
}
}
-------------- next part --------------
http://vs-nas/vz_new/middleware.php/data.json?from=1398788846853&to=1430324846853&tuples=424&uuid[]=eb730440-ecd1-11e0-88ea-4106976315db&debug=1
{
"version": "0.3",
"data": [
{
"uuid": "eb730440-ecd1-11e0-88ea-4106976315db",
"from": 1398788736000,
"to": 1430324928000,
"min": [
1407505024000,
141.34987113402
],
"max": [
1402364800000,
878.73711340206
],
"average": 355.144,
"consumption": 3111083,
"rows": 424,
"tuples": [
[
1398863232000,
367.22,
1164
],
[
1398937728000,
470.055,
1164
],
[
1399012224000,
357.313,
1164
],
[
1399086720000,
583.183,
1164
],
[
1399161216000,
557.619,
1164
],
[
1399235712000,
451.401,
1164
],
[
1399310464000,
209.204,
1164
],
[
1399384960000,
207.216,
1164
],
[
1399459456000,
259.504,
1164
],
[
1399533952000,
241.43,
1164
],
[
1399608448000,
208.618,
1164
],
[
1399682944000,
444.346,
1164
],
[
1399757440000,
336.92,
1164
],
[
1399831936000,
189.578,
1164
],
[
1399906432000,
253.657,
1164
],
[
1399980928000,
237.854,
1164
],
[
1400055424000,
300.966,
1164
],
[
1400129920000,
513.209,
1164
],
[
1400204416000,
443.041,
1164
],
[
1400278912000,
399.259,
1164
],
[
1400353408000,
732.216,
1164
],
[
1400427904000,
464.304,
1164
],
[
1400502400000,
273.711,
1164
],
[
1400576896000,
278.157,
1164
],
[
1400651392000,
861.872,
1164
],
[
1400725888000,
368.235,
1164
],
[
1400800384000,
397.519,
1164
],
[
1400874880000,
417.236,
1164
],
[
1400949376000,
295.168,
1164
],
[
1401023872000,
328.512,
1164
],
[
1401098368000,
312.371,
1164
],
[
1401172864000,
275.983,
1164
],
[
1401247360000,
293.911,
1164
],
[
1401321856000,
305.944,
1164
],
[
1401396352000,
335.954,
1164
],
[
1401470848000,
322.423,
1164
],
[
1401545344000,
250.419,
1164
],
[
1401619840000,
256.169,
1164
],
[
1401694336000,
446.617,
1164
],
[
1401768832000,
543.508,
1164
],
[
1401843328000,
252.303,
1164
],
[
1401917824000,
594.878,
1164
],
[
1401992320000,
525.435,
1164
],
[
1402066816000,
474.452,
1164
],
[
1402141312000,
459.665,
1164
],
[
1402215808000,
499.871,
1164
],
[
1402290304000,
475.902,
1164
],
[
1402364800000,
878.737,
1164
],
[
1402439296000,
250.805,
1164
],
[
1402513792000,
232.587,
1164
],
[
1402588288000,
156.669,
1164
],
[
1402662784000,
201.563,
1164
],
[
1402737280000,
233.167,
1164
],
[
1402811776000,
200.644,
1164
],
[
1402886272000,
191.946,
1164
],
[
1402960768000,
191.124,
1164
],
[
1403035264000,
192.864,
1164
],
[
1403109760000,
185.809,
1164
],
[
1403184256000,
189.771,
1164
],
[
1403258752000,
337.983,
1164
],
[
1403333248000,
401.675,
1164
],
[
1403407744000,
751.498,
1164
],
[
1403482240000,
595.844,
1164
],
[
1403556736000,
408.489,
1164
],
[
1403631232000,
582.12,
1164
],
[
1403705728000,
324.259,
1164
],
[
1403780224000,
320.973,
1164
],
[
1403854720000,
284.053,
1164
],
[
1403929216000,
371.376,
1164
],
[
1404003712000,
386.066,
1164
],
[
1404078208000,
399.404,
1164
],
[
1404152704000,
362.87,
1164
],
[
1404227200000,
334.697,
1164
],
[
1404301696000,
275.741,
1164
],
[
1404376192000,
290.238,
1164
],
[
1404450688000,
453.093,
1164
],
[
1404525184000,
390.464,
1164
],
[
1404599680000,
434.439,
1164
],
[
1404674176000,
552.448,
1164
],
[
1404748672000,
349.678,
1164
],
[
1404823168000,
562.597,
1164
],
[
1404897664000,
327.69,
1164
],
[
1404972160000,
343.589,
1164
],
[
1405046656000,
283.038,
1164
],
[
1405121152000,
500.644,
1164
],
[
1405195648000,
307.974,
1164
],
[
1405270144000,
396.118,
1164
],
[
1405344640000,
376.45,
1164
],
[
1405419136000,
437.194,
1164
],
[
1405493632000,
411.582,
1164
],
[
1405568128000,
628.173,
1164
],
[
1405642624000,
488.322,
1164
],
[
1405717120000,
468.363,
1164
],
[
1405791616000,
523.357,
1164
],
[
1405866112000,
575.064,
1164
],
[
1405940608000,
519.201,
1164
],
[
1406015104000,
695.103,
1164
],
[
1406089600000,
484.552,
1164
],
[
1406164096000,
630.058,
1164
],
[
1406238592000,
349.146,
1164
],
[
1406313088000,
623.438,
1164
],
[
1406387584000,
543.17,
1164
],
[
1406462080000,
527.706,
1164
],
[
1406536576000,
489.626,
1164
],
[
1406611072000,
141.447,
1164
],
[
1406685568000,
144.491,
1164
],
[
1406760064000,
147.825,
1164
],
[
1406834560000,
143.331,
1164
],
[
1406909056000,
150.435,
1164
],
[
1406983552000,
172.133,
1164
],
[
1407058048000,
152.078,
1164
],
[
1407132544000,
142.8,
1164
],
[
1407207040000,
141.64,
1164
],
[
1407281536000,
146.762,
1164
],
[
1407356032000,
147.922,
1164
],
[
1407430528000,
148.212,
1164
],
[
1407505024000,
141.35,
1164
],
[
1407579712000,
477.378,
1164
],
[
1407654208000,
805.96,
1164
],
[
1407728704000,
575.693,
1164
],
[
1407803200000,
354.51,
1164
],
[
1407877696000,
391.865,
1164
],
[
1407952192000,
454.059,
1164
],
[
1408026688000,
291.157,
1164
],
[
1408101184000,
343.637,
1164
],
[
1408175680000,
259.021,
1164
],
[
1408250176000,
365.432,
1164
],
[
1408324672000,
391.43,
1164
],
[
1408399168000,
273.518,
1164
],
[
1408473664000,
240.512,
1164
],
[
1408548160000,
344.265,
1164
],
[
1408622656000,
234.713,
1164
],
[
1408697152000,
232.152,
1164
],
[
1408771648000,
340.931,
1164
],
[
1408846144000,
359.391,
1164
],
[
1408920640000,
357.313,
1164
],
[
1408995136000,
340.206,
1164
],
[
1409069632000,
219.346,
1164
],
[
1409144128000,
269.797,
1164
],
[
1409218624000,
266.366,
1164
],
[
1409293120000,
294.974,
1164
],
[
1409367616000,
335.422,
1164
],
[
1409442112000,
657.216,
1164
],
[
1409516608000,
384.037,
1164
],
[
1409591104000,
319.62,
1164
],
[
1409665600000,
197.841,
1164
],
[
1409740096000,
228.866,
1164
],
[
1409814592000,
323.486,
1164
],
[
1409889088000,
272.02,
1164
],
[
1409963584000,
416.028,
1164
],
[
1410038080000,
394.668,
1164
],
[
1410112576000,
504.655,
1164
],
[
1410187072000,
305.267,
1164
],
[
1410261568000,
383.215,
1164
],
[
1410336064000,
308.747,
1164
],
[
1410410560000,
360.648,
1164
],
[
1410485056000,
492.961,
1164
],
[
1410559552000,
338.322,
1164
],
[
1410634048000,
346.392,
1164
],
[
1410708544000,
433.231,
1164
],
[
1410783040000,
337.693,
1164
],
[
1410857536000,
289.997,
1164
],
[
1410932032000,
361.131,
1164
],
[
1411006528000,
293.621,
1164
],
[
1411081024000,
332.813,
1164
],
[
1411155520000,
408.586,
1164
],
[
1411230016000,
369.733,
1164
],
[
1411304512000,
349.63,
1164
],
[
1411379008000,
377.755,
1164
],
[
1411453504000,
261.437,
1164
],
[
1411528000000,
216.591,
1164
],
[
1411602496000,
446.376,
1164
],
[
1411676992000,
348.856,
1164
],
[
1411751488000,
416.221,
1164
],
[
1411825984000,
438.015,
1164
],
[
1411900480000,
277.771,
1164
],
[
1411974976000,
367.413,
1164
],
[
1412049472000,
375.145,
1164
],
[
1412123968000,
317.977,
1164
],
[
1412198464000,
283.908,
1164
],
[
1412272960000,
305.992,
1164
],
[
1412347456000,
250.322,
1164
],
[
1412421952000,
254.575,
1164
],
[
1412496448000,
396.505,
1164
],
[
1412570944000,
312.854,
1164
],
[
1412645440000,
228.431,
1164
],
[
1412719936000,
395.731,
1164
],
[
1412794432000,
279.704,
1164
],
[
1412868928000,
353.109,
1164
],
[
1412943424000,
385.341,
1164
],
[
1413017920000,
247.133,
1164
],
[
1413092416000,
337.21,
1164
],
[
1413166912000,
388.869,
1164
],
[
1413241408000,
253.753,
1164
],
[
1413315904000,
341.511,
1164
],
[
1413390400000,
284.584,
1164
],
[
1413464896000,
218.38,
1164
],
[
1413539392000,
280.912,
1164
],
[
1413613888000,
372.149,
1164
],
[
1413688384000,
460.148,
1164
],
[
1413762880000,
286.131,
1164
],
[
1413837376000,
318.17,
1164
],
[
1413911872000,
199.485,
1164
],
[
1413986368000,
237.661,
1164
],
[
1414060864000,
347.6,
1164
],
[
1414135360000,
340.738,
1164
],
[
1414209856000,
372.342,
1164
],
[
1414284352000,
457.394,
1164
],
[
1414358848000,
416.028,
1164
],
[
1414433344000,
302.416,
1164
],
[
1414507840000,
618.847,
1164
],
[
1414582336000,
471.794,
1164
],
[
1414656832000,
313.676,
1164
],
[
1414731456000,
227.943,
1164
],
[
1414805952000,
357.748,
1164
],
[
1414880448000,
343.492,
1164
],
[
1414955072000,
295.53,
1164
],
[
1415029568000,
237.758,
1164
],
[
1415104064000,
238.289,
1164
],
[
1415178560000,
310.825,
1164
],
[
1415253056000,
231.959,
1164
],
[
1415327552000,
256.749,
1164
],
[
1415402048000,
379.398,
1164
],
[
1415476544000,
275.693,
1164
],
[
1415551040000,
239.304,
1164
],
[
1415625536000,
368.524,
1164
],
[
1415700032000,
310.003,
1164
],
[
1415774528000,
289.852,
1164
],
[
1415849024000,
483.827,
1164
],
[
1415923520000,
250.467,
1164
],
[
1415998016000,
372.922,
1164
],
[
1416072512000,
336.34,
1164
],
[
1416147008000,
323.776,
1164
],
[
1416221504000,
309.472,
1164
],
[
1416296000000,
282.893,
1164
],
[
1416370496000,
391.962,
1164
],
[
1416444992000,
374.468,
1164
],
[
1416519488000,
251.095,
1164
],
[
1416593984000,
276.176,
1164
],
[
1416668480000,
420.329,
1164
],
[
1416742976000,
324.597,
1164
],
[
1416817472000,
319.378,
1164
],
[
1416891968000,
261.389,
1164
],
[
1416966464000,
315.077,
1164
],
[
1417040960000,
401.482,
1164
],
[
1417115456000,
348.131,
1164
],
[
1417189952000,
367.026,
1164
],
[
1417264448000,
476.724,
1164
],
[
1417338944000,
399.742,
1164
],
[
1417413440000,
403.415,
1164
],
[
1417487936000,
344.894,
1164
],
[
1417562432000,
727.867,
1164
],
[
1417636928000,
373.115,
1164
],
[
1417711424000,
283.376,
1164
],
[
1417785920000,
367.268,
1164
],
[
1417860416000,
314.063,
1164
],
[
1417934912000,
421.488,
1164
],
[
1418009408000,
362.194,
1164
],
[
1418083904000,
460.341,
1164
],
[
1418158400000,
459.617,
1164
],
[
1418232896000,
304.494,
1164
],
[
1418307392000,
348.228,
1164
],
[
1418381888000,
385.921,
1164
],
[
1418456384000,
434.439,
1164
],
[
1418530880000,
420.812,
1164
],
[
1418605376000,
385.39,
1164
],
[
1418679872000,
318.798,
1164
],
[
1418754368000,
335.084,
1164
],
[
1418828864000,
238.869,
1164
],
[
1418903360000,
307.249,
1164
],
[
1418977856000,
406.749,
1164
],
[
1419052352000,
425.934,
1164
],
[
1419126848000,
592.22,
1164
],
[
1419201344000,
412.355,
1164
],
[
1419275840000,
419.99,
1164
],
[
1419350336000,
508.183,
1164
],
[
1419424832000,
441.35,
1164
],
[
1419499328000,
429.559,
1164
],
[
1419573824000,
561.244,
1164
],
[
1419648320000,
444.781,
1164
],
[
1419722816000,
576.466,
1164
],
[
1419797312000,
569.652,
1164
],
[
1419871808000,
320.586,
1164
],
[
1419946304000,
343.202,
1164
],
[
1420020800000,
496.827,
1164
],
[
1420095296000,
871.585,
1164
],
[
1420169792000,
459.955,
1164
],
[
1420244288000,
452.513,
1164
],
[
1420318784000,
459.52,
1164
],
[
1420393280000,
335.422,
1164
],
[
1420467776000,
318.122,
1164
],
[
1420542784000,
396.246,
1164
],
[
1420617280000,
340.206,
1164
],
[
1420691776000,
378.141,
1164
],
[
1420766272000,
356.25,
1164
],
[
1420840768000,
392.687,
1164
],
[
1420915264000,
333.151,
1164
],
[
1420989760000,
299.178,
1164
],
[
1421064256000,
362.387,
1164
],
[
1421138752000,
442.606,
1164
],
[
1421213248000,
327.207,
1164
],
[
1421287744000,
575.983,
1164
],
[
1421362240000,
293.669,
1164
],
[
1421436736000,
329.961,
1164
],
[
1421511232000,
288.934,
1164
],
[
1421585728000,
312.226,
1164
],
[
1421660224000,
315.561,
1164
],
[
1421734720000,
354.704,
1164
],
[
1421809216000,
293.573,
1164
],
[
1421883712000,
328.27,
1164
],
[
1421958208000,
336.582,
1164
],
[
1422032704000,
321.601,
1164
],
[
1422107200000,
281.782,
1164
],
[
1422181696000,
235.825,
1164
],
[
1422256192000,
335.422,
1164
],
[
1422330688000,
357.506,
1164
],
[
1422405184000,
360.116,
1164
],
[
1422479680000,
404.913,
1164
],
[
1422554176000,
344.024,
1164
],
[
1422628672000,
277.481,
1164
],
[
1422703168000,
381.669,
1164
],
[
1422777664000,
419.845,
1164
],
[
1422852160000,
383.892,
1164
],
[
1422926656000,
317.349,
1164
],
[
1423001152000,
497.89,
1164
],
[
1423075648000,
206.153,
1164
],
[
1423150144000,
208.473,
1164
],
[
1423224640000,
308.747,
1164
],
[
1423299136000,
372.342,
1164
],
[
1423373632000,
415.883,
1164
],
[
1423448128000,
373.115,
1164
],
[
1423522624000,
393.267,
1164
],
[
1423597120000,
305.896,
1164
],
[
1423671616000,
219.153,
1164
],
[
1423746112000,
244.088,
1164
],
[
1423820608000,
299.372,
1164
],
[
1423895104000,
296.714,
1164
],
[
1423969600000,
644.024,
1164
],
[
1424044096000,
429.752,
1164
],
[
1424118592000,
307.2,
1164
],
[
1424193088000,
280.428,
1164
],
[
1424267584000,
276.176,
1164
],
[
1424342080000,
266.511,
1164
],
[
1424416576000,
352.384,
1164
],
[
1424491072000,
345.764,
1164
],
[
1424565568000,
311.888,
1164
],
[
1424640064000,
400.37,
1164
],
[
1424714560000,
388.434,
1164
],
[
1424789056000,
301.691,
1164
],
[
1424863552000,
325.805,
1164
],
[
1424938048000,
407.957,
1164
],
[
1425012544000,
216.978,
1164
],
[
1425087040000,
377.851,
1164
],
[
1425161536000,
314.836,
1164
],
[
1425236096000,
454.249,
1164
],
[
1425310592000,
217.268,
1164
],
[
1425385088000,
416.511,
1164
],
[
1425459584000,
325.805,
1164
],
[
1425534080000,
299.082,
1164
],
[
1425608576000,
228.238,
1164
],
[
1425683072000,
372.342,
1164
],
[
1425757568000,
258.779,
1164
],
[
1425832064000,
344.12,
1164
],
[
1425906560000,
229.301,
1164
],
[
1425981056000,
225.145,
1164
],
[
1426055552000,
409.262,
1164
],
[
1426130048000,
534.472,
1164
],
[
1426204544000,
289.127,
1164
],
[
1426279040000,
316.817,
1164
],
[
1426353536000,
276.321,
1164
],
[
1426428032000,
424.581,
1164
],
[
1426502528000,
277.287,
1164
],
[
1426577024000,
266.173,
1164
],
[
1426651520000,
354.075,
1164
],
[
1426726016000,
305.799,
1164
],
[
1426800512000,
304.977,
1164
],
[
1426875008000,
516.012,
1164
],
[
1426949504000,
300.87,
1164
],
[
1427024000000,
339.965,
1164
],
[
1427098496000,
298.502,
1164
],
[
1427172992000,
315.126,
1164
],
[
1427247488000,
388.821,
1164
],
[
1427321984000,
315.851,
1164
],
[
1427396480000,
291.736,
1164
],
[
1427470976000,
254.478,
1164
],
[
1427545472000,
322.664,
1164
],
[
1427619968000,
328.028,
1164
],
[
1427694464000,
289.272,
1164
],
[
1427768960000,
248.003,
1164
],
[
1427843456000,
308.505,
1164
],
[
1427917952000,
226.45,
1164
],
[
1427992448000,
205.573,
1164
],
[
1428066944000,
305.026,
1164
],
[
1428141440000,
269.749,
1164
],
[
1428215936000,
294.491,
1164
],
[
1428290432000,
261.195,
1164
],
[
1428364928000,
406.266,
1164
],
[
1428439424000,
327.159,
1164
],
[
1428513920000,
366.978,
1164
],
[
1428588416000,
235.003,
1164
],
[
1428662912000,
278.061,
1164
],
[
1428737408000,
424.098,
1164
],
[
1428811904000,
462.13,
1164
],
[
1428886400000,
350.016,
1164
],
[
1428960896000,
478.125,
1164
],
[
1429035392000,
593.863,
1164
],
[
1429109888000,
338.611,
1164
],
[
1429184384000,
368.621,
1164
],
[
1429258880000,
291.108,
1164
],
[
1429333376000,
308.07,
1164
],
[
1429407872000,
354.607,
1164
],
[
1429482368000,
350.693,
1164
],
[
1429556864000,
257.184,
1164
],
[
1429631360000,
297.052,
1164
],
[
1429705856000,
271.585,
1164
],
[
1429780352000,
255.348,
1164
],
[
1429854848000,
305.896,
1164
],
[
1429929344000,
465.995,
1164
],
[
1430003840000,
485.954,
1164
],
[
1430078336000,
283.086,
1164
],
[
1430152832000,
231.669,
1164
],
[
1430227328000,
262.403,
1164
],
[
1430301824000,
326.289,
1164
],
[
1430324928000,
330.177,
360
]
]
}
],
"debug": {
"level": "1",
"database": "pdo_mysql",
"time": 52.08442,
"uptime": 1483820620,
"load": [
0.85,
0.43,
0.26
],
"commit-hash": "8840d90e18a7865e6fca5e9a6ff1b78eb884adb0\n",
"php-version": "5.4.39-0+deb7u2",
"messages": [],
"sqlTotalTime": 52.016003131866,
"sqlWorstTime": 51.777784109116,
"queries": [
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC LIMIT 2) t",
"params": [
7,
1398788846853
],
"types": [],
"executionMS": 0.069567203521729
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC LIMIT 2) t",
"params": [
7,
1430324846853
],
"types": [],
"executionMS": 0.0026519298553467
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS count FROM aggregate INNER JOIN entities ON aggregate.channel_id = entities.id WHERE uuid = ? GROUP BY type HAVING count > 0 ORDER BY type DESC",
"params": [
"eb730440-ecd1-11e0-88ea-4106976315db"
],
"types": [],
"executionMS": 0.00060296058654785
},
{
"sql": "SELECT UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) * 1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
7,
3,
1398788736000
],
"types": [],
"executionMS": 0.00055813789367676
},
{
"sql": "SELECT UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) \/ 1000, \"%Y-%m-%d\"), INTERVAL 1 day)) * 1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp<?",
"params": [
7,
3,
1430324928000
],
"types": [],
"executionMS": 0.0054559707641602
},
{
"sql": "SELECT SUM(count) FROM (SELECT COUNT(1) AS count FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp < ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT SUM(count) AS count FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >= ? AND timestamp < ?) AS agg",
"params": [
7,
1398788736000,
"1398722400000",
"1430258400000",
1430324928000,
7,
3,
"1398722400000",
"1430258400000"
],
"types": [],
"executionMS": 0.15938282012939
},
{
"sql": "SELECT MAX(agg.timestamp) AS timestamp, SUM(agg.value) AS value, COUNT(agg.value) AS count FROM (SELECT timestamp, value, @row:=@row+1 AS row FROM data CROSS JOIN (SELECT @row := 1162) AS vars WHERE channel_id=? AND timestamp >= ? AND timestamp <= ? ORDER BY timestamp ASC) AS agg GROUP BY row DIV 1164 ORDER BY timestamp ASC",
"params": [
7,
1398788736000,
1430324928000
],
"types": [],
"executionMS": 51.777784109116
}
]
}
}