Symfony Profiler

Query Metrics

179 Database Queries

37 Different statements

124.94 ms Query time

8 Invalid entities

87 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

54.21 ms
(43.39%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 433)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Controller\ApiLogController->aiReceive (line 658)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

6.70 ms
(5.37%)

INSERT INTO ai_prediccion_30 (dia, semana, co2_hr_start, co2_hr_end, co2, is_critico, temp_hr_start, temp_hr_end, temperatura, temp_critico, hum_hr_start, hum_hr_end, humedad, hum_critico, es_confiable, prediccion_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_prediccion_30 (
  dia, semana, co2_hr_start, co2_hr_end,
  co2, is_critico, temp_hr_start, temp_hr_end,
  temperatura, temp_critico, hum_hr_start,
  hum_hr_end, humedad, hum_critico,
  es_confiable, prediccion_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO ai_prediccion_30 (dia, semana, co2_hr_start, co2_hr_end, co2, is_critico, temp_hr_start, temp_hr_end, temperatura, temp_critico, hum_hr_start, hum_hr_end, humedad, hum_critico, es_confiable, prediccion_id) VALUES (3, 1, 20, 21, 654, 0, 21, 22, 23.3, 0, 12, 13, 35, 0, 1, 1025);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 482)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

5.08 ms
(4.07%)

INSERT INTO ai_recomendaciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "en"
  "App\Entity\AI\AiRecomendaciones"
  "ieypMetodologia"
  1024
  "Increase confidence in predictions. CO₂ varies with occupancy; temperature and humidity remain more stable."
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_recomendaciones_translation (
  locale, object_class, field, foreign_key,
  content
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO ai_recomendaciones_translation (locale, object_class, field, foreign_key, content) VALUES ('en', 'App\\Entity\\AI\\AiRecomendaciones', 'ieypMetodologia', 1024, 'Increase confidence in predictions. CO₂ varies with occupancy; temperature and humidity remain more stable.');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 576)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

5.04 ms
(4.03%)

SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.object_class AS object_class_2, a0_.field AS field_3, a0_.foreign_key AS foreign_key_4, a0_.content AS content_5 FROM ai_predicciones_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1

Parameters:

[
  "en"
  "cvhPred7co2Impacto"
  "1025"
  "App\Entity\AI\AiPredicciones"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.locale AS locale_1,
  a0_.object_class AS object_class_2,
  a0_.field AS field_3,
  a0_.foreign_key AS foreign_key_4,
  a0_.content AS content_5
FROM
  ai_predicciones_translation a0_
WHERE
  a0_.locale = ?
  AND a0_.field = ?
  AND a0_.foreign_key = ?
  AND a0_.object_class = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.object_class AS object_class_2, a0_.field AS field_3, a0_.foreign_key AS foreign_key_4, a0_.content AS content_5 FROM ai_predicciones_translation a0_ WHERE a0_.locale = 'en' AND a0_.field = 'cvhPred7co2Impacto' AND a0_.foreign_key = '1025' AND a0_.object_class = 'App\\Entity\\AI\\AiPredicciones' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Gedmo\Translatable\Mapping\Event\Adapter\ORM->findTranslation (line 166)
7	Gedmo\Translatable\TranslatableListener->handleTranslatableObjectUpdate (line 699)
8	Gedmo\Translatable\TranslatableListener->onFlush (line 440)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
10	Doctrine\ORM\UnitOfWork->dispatchOnFlushEvent (line 3153)
11	Doctrine\ORM\UnitOfWork->commit (line 379)
12	Doctrine\ORM\EntityManager->flush (line 268)
13	App\Event\AiPersistEvent->persistPayload (line 504)
14	App\Event\AiPersistEvent->__construct (line 40)
15	App\Controller\ApiLogController->aiReceive (line 663)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

4.45 ms
(3.56%)

UPDATE ai_predicciones_translation SET content = ? WHERE id = ?

Parameters:

[
  "Highlight moderate CO fluctuations (+1.4%) with 5 days showing slightly elevated readings. Systematic ventilation would even out readings."
  8989
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  ai_predicciones_translation
SET
  content = ?
WHERE
  id = ?

UPDATE ai_predicciones_translation SET content = 'Highlight moderate CO fluctuations (+1.4%) with 5 days showing slightly elevated readings. Systematic ventilation would even out readings.' WHERE id = 8989;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 504)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

4.33 ms
(3.46%)

INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7co2Impacto"
  1025
  "El análisis revela variabilidad moderada en CO (+1.4%), con 5 jornadas presentando valores ligeramente elevados. Este comportamiento indica fluctuaciones perceptibles asociadas a la ocupación."
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_predicciones_translation (
  locale, object_class, field, foreign_key,
  content
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES ('en', 'App\\Entity\\AI\\AiPredicciones', 'cvhPred7co2Impacto', 1025, 'El análisis revela variabilidad moderada en CO (+1.4%), con 5 jornadas presentando valores ligeramente elevados. Este comportamiento indica fluctuaciones perceptibles asociadas a la ocupación.');

#	File/Call
1	Doctrine\DBAL\Connection->insert (line 814)
2	Gedmo\Translatable\Mapping\Event\Adapter\ORM->insertTranslationRecord (line 204)
3	Gedmo\Translatable\TranslatableListener->postPersist (line 486)
4	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
5	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
6	Doctrine\ORM\UnitOfWork->executeInserts (line 1080)
7	Doctrine\ORM\UnitOfWork->commit (line 403)
8	Doctrine\ORM\EntityManager->flush (line 268)
9	App\Event\AiPersistEvent->persistPayload (line 482)
10	App\Event\AiPersistEvent->__construct (line 40)
11	App\Controller\ApiLogController->aiReceive (line 663)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

4.13 ms
(3.31%)

INSERT INTO ai_alertas (param, tipo, mensaje, tiempo_restante, valor_critico, ai_rec_id) VALUES (?, ?, ?, ?, ?, ?)

Parameters:

[
  "temperature"
  "alerta_preventiva"
  "Ligera variación térmica que puede afectar el confort (Temperatura: 23.4°C, rango óptimo: 17-27°C). Revisión preventiva recomendada."
  "Preparar climatización a media tarde (entre 16:00h–17:00h). Evaluar ajustes permanentes si continúa."
  23.4
  1024
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_alertas (
  param, tipo, mensaje, tiempo_restante,
  valor_critico, ai_rec_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO ai_alertas (param, tipo, mensaje, tiempo_restante, valor_critico, ai_rec_id) VALUES ('temperature', 'alerta_preventiva', 'Ligera variación térmica que puede afectar el confort (Temperatura: 23.4°C, rango óptimo: 17-27°C). Revisión preventiva recomendada.', 'Preparar climatización a media tarde (entre 16:00h–17:00h). Evaluar ajustes permanentes si continúa.', 23.4, 1024);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 665)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

3.56 ms
(2.85%)

SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.object_class AS object_class_2, a0_.field AS field_3, a0_.foreign_key AS foreign_key_4, a0_.content AS content_5 FROM ai_recomendacion_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1

Parameters:

[
  "en"
  "accion"
  "3335"
  "App\Entity\AI\Recomendacion"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.locale AS locale_1,
  a0_.object_class AS object_class_2,
  a0_.field AS field_3,
  a0_.foreign_key AS foreign_key_4,
  a0_.content AS content_5
FROM
  ai_recomendacion_translation a0_
WHERE
  a0_.locale = ?
  AND a0_.field = ?
  AND a0_.foreign_key = ?
  AND a0_.object_class = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.object_class AS object_class_2, a0_.field AS field_3, a0_.foreign_key AS foreign_key_4, a0_.content AS content_5 FROM ai_recomendacion_translation a0_ WHERE a0_.locale = 'en' AND a0_.field = 'accion' AND a0_.foreign_key = '3335' AND a0_.object_class = 'App\\Entity\\AI\\Recomendacion' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Gedmo\Translatable\Mapping\Event\Adapter\ORM->findTranslation (line 166)
7	Gedmo\Translatable\TranslatableListener->handleTranslatableObjectUpdate (line 699)
8	Gedmo\Translatable\TranslatableListener->onFlush (line 440)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
10	Doctrine\ORM\UnitOfWork->dispatchOnFlushEvent (line 3153)
11	Doctrine\ORM\UnitOfWork->commit (line 379)
12	Doctrine\ORM\EntityManager->flush (line 268)
13	App\Event\AiPersistEvent->persistPayload (line 638)
14	App\Event\AiPersistEvent->__construct (line 40)
15	App\Controller\ApiLogController->aiReceive (line 663)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

3.45 ms
(2.76%)

INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)

Parameters:

[
  "co2"
  1
  20
  771
  "preventiva"
  1025
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_prediccion_pico (
  tipo, orden, hora, valor, clasificacion,
  prediccion_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES ('co2', 1, 20, 771, 'preventiva', 1025);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 482)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

3.36 ms
(2.69%)

INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "en"
  "App\Entity\AI\Recomendacion"
  "accion"
  3335
  "Prevención pico Temperature"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_recomendacion_translation (
  locale, object_class, field, foreign_key,
  content
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES ('en', 'App\\Entity\\AI\\Recomendacion', 'accion', 3335, 'Prevención pico Temperature');

#	File/Call
1	Doctrine\DBAL\Connection->insert (line 814)
2	Gedmo\Translatable\Mapping\Event\Adapter\ORM->insertTranslationRecord (line 204)
3	Gedmo\Translatable\TranslatableListener->postPersist (line 486)
4	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
5	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
6	Doctrine\ORM\UnitOfWork->executeInserts (line 1080)
7	Doctrine\ORM\UnitOfWork->commit (line 403)
8	Doctrine\ORM\EntityManager->flush (line 268)
9	App\Event\AiPersistEvent->persistPayload (line 610)
10	App\Event\AiPersistEvent->__construct (line 40)
11	App\Controller\ApiLogController->aiReceive (line 663)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

2.74 ms
(2.19%)

UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?

Parameters:

[
  "Peak Temperature Prevention"
  6706
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  ai_recomendacion_translation
SET
  content = ?
WHERE
  id = ?

UPDATE ai_recomendacion_translation SET content = 'Peak Temperature Prevention' WHERE id = 6706;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 638)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.92 ms
(1.53%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\ApiLogController->aiReceive (line 658)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

1.87 ms
(1.50%)

INSERT INTO ai_prediccion_7 (dia, co2_hr_start, co2_hr_end, co2, is_critico, temp_hr_start, temp_hr_end, temperatura, temp_critico, hum_hr_start, hum_hr_end, humedad, hum_critico, es_confiable, prediccion_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_prediccion_7 (
  dia, co2_hr_start, co2_hr_end, co2,
  is_critico, temp_hr_start, temp_hr_end,
  temperatura, temp_critico, hum_hr_start,
  hum_hr_end, humedad, hum_critico,
  es_confiable, prediccion_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO ai_prediccion_7 (dia, co2_hr_start, co2_hr_end, co2, is_critico, temp_hr_start, temp_hr_end, temperatura, temp_critico, hum_hr_start, hum_hr_end, humedad, hum_critico, es_confiable, prediccion_id) VALUES (1, 20, 21, 654, 0, 21, 22, 23.3, 0, 12, 13, 35, 0, 1, 1025);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 482)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.79 ms
(1.43%)

SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.object_class AS object_class_2, a0_.field AS field_3, a0_.foreign_key AS foreign_key_4, a0_.content AS content_5 FROM alertas_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1

Parameters:

[
  "en"
  "mensaje"
  "1902"
  "App\Entity\AI\Alertas"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.locale AS locale_1,
  a0_.object_class AS object_class_2,
  a0_.field AS field_3,
  a0_.foreign_key AS foreign_key_4,
  a0_.content AS content_5
FROM
  alertas_translation a0_
WHERE
  a0_.locale = ?
  AND a0_.field = ?
  AND a0_.foreign_key = ?
  AND a0_.object_class = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.object_class AS object_class_2, a0_.field AS field_3, a0_.foreign_key AS foreign_key_4, a0_.content AS content_5 FROM alertas_translation a0_ WHERE a0_.locale = 'en' AND a0_.field = 'mensaje' AND a0_.foreign_key = '1902' AND a0_.object_class = 'App\\Entity\\AI\\Alertas' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Gedmo\Translatable\Mapping\Event\Adapter\ORM->findTranslation (line 166)
7	Gedmo\Translatable\TranslatableListener->handleTranslatableObjectUpdate (line 699)
8	Gedmo\Translatable\TranslatableListener->onFlush (line 440)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
10	Doctrine\ORM\UnitOfWork->dispatchOnFlushEvent (line 3153)
11	Doctrine\ORM\UnitOfWork->commit (line 379)
12	Doctrine\ORM\EntityManager->flush (line 268)
13	App\Event\AiPersistEvent->persistPayload (line 687)
14	App\Event\AiPersistEvent->__construct (line 40)
15	App\Controller\ApiLogController->aiReceive (line 663)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.66 ms
(1.32%)

SELECT t0.id AS id_1, t0.payload AS payload_2, t0.created AS created_3, t0.processed_date AS processed_date_4, t0.processed AS processed_5, t0.oficina_id AS oficina_id_6 FROM api_ai_receive t0 WHERE t0.oficina_id = ? AND t0.processed_date = ? LIMIT 1

Parameters:

[
  "0add8c1c-2235-4944-9e3e-02a9044dd6d3"
  "2026-07-14"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.payload AS payload_2,
  t0.created AS created_3,
  t0.processed_date AS processed_date_4,
  t0.processed AS processed_5,
  t0.oficina_id AS oficina_id_6
FROM
  api_ai_receive t0
WHERE
  t0.oficina_id = ?
  AND t0.processed_date = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.payload AS payload_2, t0.created AS created_3, t0.processed_date AS processed_date_4, t0.processed AS processed_5, t0.oficina_id AS oficina_id_6 FROM api_ai_receive t0 WHERE t0.oficina_id = '0add8c1c-2235-4944-9e3e-02a9044dd6d3' AND t0.processed_date = '2026-07-14' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\ApiLogController->aiReceive (line 642)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.65 ms
(1.32%)

INSERT INTO ai_recomendacion (prio, param, accion, descripcion, momento_ejecucion, valor, ai_rec_id) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  2
  "temperature"
  "Prevención pico Temperature"
  "Observamos ligera variación térmica sin impacto significativo. Proyección: 23.4°C en 11h (+0.5°C). El rango óptimo es 21–24°C. Recomendamos revisión preventiva de climatización."
  "Preparar climatización a media tarde (entre 16:00h–17:00h). Evaluar ajustes permanentes si continúa."
  23.4
  1024
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_recomendacion (
  prio, param, accion, descripcion, momento_ejecucion,
  valor, ai_rec_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO ai_recomendacion (prio, param, accion, descripcion, momento_ejecucion, valor, ai_rec_id) VALUES (2, 'temperature', 'Prevención pico Temperature', 'Observamos ligera variación térmica sin impacto significativo. Proyección: 23.4°C en 11h (+0.5°C). El rango óptimo es 21–24°C. Recomendamos revisión preventiva de climatización.', 'Preparar climatización a media tarde (entre 16:00h–17:00h). Evaluar ajustes permanentes si continúa.', 23.4, 1024);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 610)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.61 ms
(1.29%)

INSERT INTO ai_patrones_semanales (dia, co2_actual, co2_desviacion, temperatura_actual, temperatura_desviacion, humedad_actual, humedad_desviacion, horas_beneficio_potencial, beneficio_potencial, ai_analisis_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_patrones_semanales (
  dia, co2_actual, co2_desviacion, temperatura_actual,
  temperatura_desviacion, humedad_actual,
  humedad_desviacion, horas_beneficio_potencial,
  beneficio_potencial, ai_analisis_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO ai_patrones_semanales (dia, co2_actual, co2_desviacion, temperatura_actual, temperatura_desviacion, humedad_actual, humedad_desviacion, horas_beneficio_potencial, beneficio_potencial, ai_analisis_id) VALUES ('1', 661, -339, 23, -1.5, 31, -21.5, 2.3, 1, 1041);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 258)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.43 ms
(1.14%)

INSERT INTO api_ai_receive (payload, created, processed_date, processed, oficina_id) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "{"oficina_id": "0add8c1c-2235-4944-9e3e-02a9044dd6d3", "timestamp": "15/07/26 06:01", "sensor_status": {"estado": "FUERA_DE_HORARIO", "ultima_lectura": "14/07/26 23:00", "tiempo_sin_datos_horas": 7.0, "nivel_alerta": "NORMAL"}, "analisis_temporal": {"indices_bienestar_comparativos": {"es_confiable": true, "mejor_dia_historico": {"fecha": "08/07/26", "fecha_explicativa": {"es": "Mi\u00e9rcoles, Prom. 640", "en": "Report avg. 640 ppm on Wednesday."}, "co2_ppm": 640, "temperatura_celsius": 23.3, "humedad_porcentaje": 33, "indice_bienestar": 99}, "peor_dia_historico": {"fecha": "14/07/26", "fecha_explicativa": {"es": "Martes, Prom. 660", "en": "Register avg. 660 ppm on Tuesday."}, "co2_ppm": 660, "temperatura_celsius": 23.6, "humedad_porcentaje": 35, "indice_bienestar": 100}, "hoy_vs_mejor_dia_historico": {"co2_diferencia_ppm": 66, "co2_diferencia_porcentaje": 10.2, "temperatura_diferencia_celsius": 0.5, "humedad_diferencia_puntos": 14, "bienestar_perdido_puntos": 0.6}, "promedio_bienestar_actual": 98.2, "rango_bienestar_historico": {"mejor": 99, "peor": 100, "amplitud": -1}}, "patrones_semanales_detallados": {"es_confiable": true, "dias": [{"dia": "1", "co2_actual_ppm": 661, "co2_desviacion_ppm": -339, "temperatura_actual_celsius": 23.0, "temperatura_desviacion_celsius": -1.5, "humedad_actual_porcentaje": 31, "humedad_desviacion_puntos": -21.5, "horas_beneficio_potencial": 2.3, "beneficio_potencial_eur": 1}, {"dia": "2", "co2_actual_ppm": 687, "co2_desviacion_ppm": -313, "temperatura_actual_celsius": 23.6, "temperatura_desviacion_celsius": -0.9, "humedad_actual_porcentaje": 34, "humedad_desviacion_puntos": -18.5, "horas_beneficio_potencial": 1.9, "beneficio_potencial_eur": 1}, {"dia": "3", "co2_actual_ppm": 614, "co2_desviacion_ppm": -386, "temperatura_actual_celsius": 23.4, "temperatura_desviacion_celsius": -1.1, "humedad_actual_porcentaje": 34, "humedad_desviacion_puntos": -18.5, "horas_beneficio_potencial": 2.0, "beneficio_potencial_eur": 1}, {"dia": "4", "co2_actual_ppm": 676, "co2_desviacion_ppm": -324, "temperatura_actual_celsius": 23.8, "temperatura_desviacion_celsius": -0.7, "humedad_actual_porcentaje": 30, "humedad_desviacion_puntos": -22.5, "horas_beneficio_potencial": 2.2, "beneficio_potencial_eur": 1}, {"dia": "5", "co2_actual_ppm": 639, "co2_desviacion_ppm": -361, "temperatura_actual_celsius": 23.8, "temperatura_desviacion_celsius": -0.7, "humedad_actual_porcentaje": 32, "humedad_desviacion_puntos": -20.5, "horas_beneficio_potencial": 2.1, "beneficio_potencial_eur": 1}], "hoy_vs_historico": {"co2_diferencia_porcentaje": -36.0, "temperatura_diferencia_porcentaje": -4.0, "humedad_diferencia_porcentaje": -35.9, "horas_beneficio_potencial_hoy": 0, "horas_beneficio_potencial_promedio_semanal": 0, "beneficio_potencial_hoy_eur": 4, "beneficio_potencial_promedio_semanal_eur": 28}}}, "predicciones_y_horarios": {"horarios_criticos_especificos": {"es_confiable": true, "_validation": {"is_valid": true, "valid_parameters": ["co2", "temperatura", "humedad"], "invalid_parameters": [], "reason": null}, "co2_picos_historicos": {"peor_hora": "21:00", "segunda_peor": "22:00", "tercera_peor": "20:00", "proximo_pico_predicho": {"hora": "20:00", "valor_esperado_ppm": 771, "tiempo_restante_horas": 14, "clasificacion": "preventiva"}, "_validation": {"is_valid": true, "completeness_score": 1.0, "missing_fields": [], "reason": null}}, "temperatura_picos_historicos": {"peor_hora": "18:00", "segunda_peor": "19:00", "tercera_peor": "17:00", "proximo_pico_predicho": {"hora": "17:00", "valor_esperado_celsius": 23.4, "tiempo_restante_horas": 11, "clasificacion": "preventiva"}, "_validation": {"is_valid": true, "completeness_score": 1.0, "missing_fields": [], "reason": null}}, "humedad_picos_historicos": {"peor_hora": "11:00", "segunda_peor": "10:00", "tercera_peor": "12:00", "proximo_pico_predicho": {"hora": "10:00", "valor_esperado_porcentaje": 48, "tiempo_restante_horas": 4, "clasificacion": "preventiva"}, "_validation": {"is_valid": true, "completeness_score": 1.0, "missing_fields": [], "reason": null}}}, "predicciones_negocio_7_30_dias": {"predicciones_7_dias": {"dias_criticos": [{"dia": "1", "es_confiable": true, "valores": {"co2": {"valor": 654, "unidad": "ppm", "hr_start": 20, "hr_end": 21, "es_critico": false}, "temperature": {"valor": 23.3, "unidad": "\u00b0C", "hr_start": 21, "hr_end": 22, "es_critico": false}, "humidity": {"valor": 35, "unidad": "%", "hr_start": 12, "hr_end": 13, "es_critico": false}}}, {"dia": "2", "es_confiable": true, "valores": {"co2": {"valor": 660, "unidad": "ppm", "hr_start": 9, "hr_end": 11, "es_critico": false}, "temperature": {"valor": 23.6, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}, "humidity": {"valor": 35, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": false}}}, {"dia": "3", "es_confiable": true, "valores": {"co2": {"valor": 640, "unidad": "ppm", "hr_start": 12, "hr_end": 13, "es_critico": false}, "temperature": {"valor": 23.6, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 33, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": true}}}, {"dia": "4", "es_confiable": true, "valores": {"co2": {"valor": 650, "unidad": "ppm", "hr_start": 9, "hr_end": 11, "es_critico": false}, "temperature": {"valor": 23.6, "unidad": "\u00b0C", "hr_start": 16, "hr_end": 17, "es_critico": false}, "humidity": {"valor": 33, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": true}}}, {"dia": "5", "es_confiable": true, "valores": {"co2": {"valor": 652, "unidad": "ppm", "hr_start": 12, "hr_end": 13, "es_critico": false}, "temperature": {"valor": 23.6, "unidad": "\u00b0C", "hr_start": 16, "hr_end": 17, "es_critico": false}, "humidity": {"valor": 33, "unidad": "%", "hr_start": 9, "hr_end": 11, "es_critico": true}}}], "resumen_tendencias": {"co2": {"tendencia_general": "-1.5%", "impacto_negocio": {"es": "El an\u00e1lisis revela variabilidad moderada en CO (+1.4%), con 5 jornadas presentando valores ligeramente elevados. Este comportamiento indica fluctuaciones perceptibles asociadas a la ocupaci\u00f3n. Establecer una ventilaci\u00f3n sistem\u00e1tica ayudar\u00eda a homogeneizar los niveles.", "en": "Highlight moderate CO fluctuations (+1.4%) with 5 days showing slightly elevated readings. Systematic ventilation would even out readings."}, "recomendacion_planificacion": {"es": "Establecer un patr\u00f3n de ventilaci\u00f3n m\u00e1s regular (+1.4% var.), especialmente en Lunes (20-21h) (Prom. 654), Martes Ma\u00f1ana (9-11h) (Prom. 660). Esto ayudar\u00e1 a homogeneizar los niveles semanales.", "en": "Implement a more regular ventilation pattern (+1.4% fluctuation), especially Monday 20-21h (Avg. 654) and Tuesday morning 9-11h (Avg. 660). This will even out weekly readings."}}, "temperature": {"tendencia_general": "+0.6%", "impacto_negocio": {"es": "\u00daltimas jornadas muestran variabilidad t\u00e9rmicas de +0.6%, con fluctuaciones perceptibles en 5 d\u00edas. El entorno se mantiene relativamente estable, aunque una calibraci\u00f3n del sistema mejorar\u00eda la uniformidad t\u00e9rmica.", "en": "Detect thermal fluctuations of +0.6% over 5 days. Environment remains fairly stable; system calibration would improve thermal uniformity."}, "recomendacion_planificacion": {"es": "Ajustar puntualmente la climatizaci\u00f3n en los d\u00edas con variaciones (+0.6%). El equilibrio t\u00e9rmico el resto de la semana es excelente.", "en": "Fine-tune HVAC on days with +0.6% variation. Thermal balance is excellent the rest of the week."}}, "humidity": {"tendencia_general": "-5.7%", "impacto_negocio": {"es": "Variaciones en humedad de -0.3% detectadas en 5 jornadas. La media permanece en el rango saludable ASHRAE (40-60%), sin riesgos inmediatos.", "en": "Identify humidity variations of -0.3% across 5 days. Average stays within healthy ASHRAE range (40-60%), posing no immediate risk."}, "recomendacion_planificacion": {"es": "Niveles de humedad equilibrados (-0.3% de variaci\u00f3n). Mantener la rutina actual de ventilaci\u00f3n sin necesidad de ajustes adicionales.", "en": "Maintain current ventilation routine. Humidity balanced with -0.3% variation. No further adjustments needed."}}}}, "predicciones_30_dias": {"semanas_disponibles": 4, "dias_criticos": {"semana_1": [{"dia_mes": 3, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 654, "unidad": "ppm", "hr_start": 20, "hr_end": 21, "es_critico": false}, "temperature": {"valor": 23.3, "unidad": "\u00b0C", "hr_start": 21, "hr_end": 22, "es_critico": false}, "humidity": {"valor": 35, "unidad": "%", "hr_start": 12, "hr_end": 13, "es_critico": false}}}, {"dia_mes": 4, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 660, "unidad": "ppm", "hr_start": 9, "hr_end": 11, "es_critico": false}, "temperature": {"valor": 23.6, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}, "humidity": {"valor": 35, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": false}}}, {"dia_mes": 5, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 640, "unidad": "ppm", "hr_start": 12, "hr_end": 13, "es_critico": false}, "temperature": {"valor": 23.6, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 33, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": true}}}, {"dia_mes": 6, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 650, "unidad": "ppm", "hr_start": 9, "hr_end": 11, "es_critico": false}, "temperature": {"valor": 23.6, "unidad": "\u00b0C", "hr_start": 16, "hr_end": 17, "es_critico": false}, "humidity": {"valor": 33, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": true}}}, {"dia_mes": 7, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 652, "unidad": "ppm", "hr_start": 12, "hr_end": 13, "es_critico": false}, "temperature": {"valor": 23.6, "unidad": "\u00b0C", "hr_start": 16, "hr_end": 17, "es_critico": false}, "humidity": {"valor": 33, "unidad": "%", "hr_start": 9, "hr_end": 11, "es_critico": true}}}], "semana_2": [{"dia_mes": 10, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 733, "unidad": "ppm", "hr_start": 20, "hr_end": 21, "es_critico": false}, "temperature": {"valor": 24.8, "unidad": "\u00b0C", "hr_start": 21, "hr_end": 22, "es_critico": false}, "humidity": {"valor": 41, "unidad": "%", "hr_start": 10, "hr_end": 11, "es_critico": false}}}, {"dia_mes": 11, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 681, "unidad": "ppm", "hr_start": 10, "hr_end": 12, "es_critico": false}, "temperature": {"valor": 25.2, "unidad": "\u00b0C", "hr_start": 10, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 50, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": false}}}, {"dia_mes": 12, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 685, "unidad": "ppm", "hr_start": 12, "hr_end": 13, "es_critico": false}, "temperature": {"valor": 24.0, "unidad": "\u00b0C", "hr_start": 10, "hr_end": 12, "es_critico": false}, "humidity": {"valor": 30, "unidad": "%", "hr_start": 20, "hr_end": 21, "es_critico": true}}}, {"dia_mes": 13, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 665, "unidad": "ppm", "hr_start": 8, "hr_end": 10, "es_critico": false}, "temperature": {"valor": 22.5, "unidad": "\u00b0C", "hr_start": 16, "hr_end": 17, "es_critico": false}, "humidity": {"valor": 48, "unidad": "%", "hr_start": 19, "hr_end": 20, "es_critico": false}}}, {"dia_mes": 14, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 739, "unidad": "ppm", "hr_start": 13, "hr_end": 14, "es_critico": false}, "temperature": {"valor": 24.3, "unidad": "\u00b0C", "hr_start": 15, "hr_end": 16, "es_critico": false}, "humidity": {"valor": 30, "unidad": "%", "hr_start": 9, "hr_end": 11, "es_critico": true}}}], "semana_3": [{"dia_mes": 17, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 764, "unidad": "ppm", "hr_start": 20, "hr_end": 21, "es_critico": false}, "temperature": {"valor": 24.1, "unidad": "\u00b0C", "hr_start": 21, "hr_end": 22, "es_critico": false}, "humidity": {"valor": 30, "unidad": "%", "hr_start": 13, "hr_end": 14, "es_critico": true}}}, {"dia_mes": 18, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 814, "unidad": "ppm", "hr_start": 11, "hr_end": 13, "es_critico": false}, "temperature": {"valor": 22.3, "unidad": "\u00b0C", "hr_start": 10, "hr_end": 11, "es_critico": false}}}, {"dia_mes": 19, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 697, "unidad": "ppm", "hr_start": 10, "hr_end": 11, "es_critico": false}, "temperature": {"valor": 23.1, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 37, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": false}}}, {"dia_mes": 20, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 669, "unidad": "ppm", "hr_start": 9, "hr_end": 11, "es_critico": false}, "temperature": {"valor": 23.1, "unidad": "\u00b0C", "hr_start": 16, "hr_end": 17, "es_critico": false}, "humidity": {"valor": 44, "unidad": "%", "hr_start": 16, "hr_end": 17, "es_critico": false}}}, {"dia_mes": 21, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 762, "unidad": "ppm", "hr_start": 13, "hr_end": 14, "es_critico": false}, "temperature": {"valor": 22.7, "unidad": "\u00b0C", "hr_start": 16, "hr_end": 17, "es_critico": false}, "humidity": {"valor": 43, "unidad": "%", "hr_start": 9, "hr_end": 11, "es_critico": false}}}], "semana_4": [{"dia_mes": 24, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 623, "unidad": "ppm", "hr_start": 20, "hr_end": 21, "es_critico": false}, "temperature": {"valor": 24.8, "unidad": "\u00b0C", "hr_start": 21, "hr_end": 22, "es_critico": false}, "humidity": {"valor": 44, "unidad": "%", "hr_start": 12, "hr_end": 13, "es_critico": false}}}, {"dia_mes": 25, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 653, "unidad": "ppm", "hr_start": 10, "hr_end": 12, "es_critico": false}, "temperature": {"valor": 24.9, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}, "humidity": {"valor": 34, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": true}}}, {"dia_mes": 26, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 676, "unidad": "ppm", "hr_start": 13, "hr_end": 14, "es_critico": false}, "temperature": {"valor": 23.6, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 34, "unidad": "%", "hr_start": 19, "hr_end": 20, "es_critico": true}}}, {"dia_mes": 27, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 664, "unidad": "ppm", "hr_start": 10, "hr_end": 12, "es_critico": false}, "temperature": {"valor": 23.9, "unidad": "\u00b0C", "hr_start": 16, "hr_end": 17, "es_critico": false}, "humidity": {"valor": 32, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": true}}}, {"dia_mes": 28, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 822, "unidad": "ppm", "hr_start": 10, "hr_end": 11, "es_critico": false}, "temperature": {"valor": 22.9, "unidad": "\u00b0C", "hr_start": 18, "hr_end": 19, "es_critico": false}, "humidity": {"valor": 40, "unidad": "%", "hr_start": 10, "hr_end": 12, "es_critico": false}}}]}, "resumen_tendencias": {"co2": {"tendencia_general": "+7.4%", "patron_largo_plazo": {"es": "incremento gradual sostenido", "en": "Show sustained gradual increase."}, "impacto_negocio": {"es": "El an\u00e1lisis mensual refleja una evoluci\u00f3n al alza de +7.4% en los valores de CO\u2082. Si esta progresi\u00f3n se mantiene, comenzar\u00e1n a aparecer s\u00edntomas de concentraci\u00f3n disminuida y fatiga mental.", "en": "Reveal monthly CO\u2082 rise of +7.4%. Continued growth will trigger concentration loss and mental fatigue symptoms."}, "recomendacion_inversion": {"es": "Con una tendencia al alza de +7.4%, conviene reforzar la capacidad de renovaci\u00f3n del aire. Considerar la instalaci\u00f3n de extractores adicionales o una revisi\u00f3n t\u00e9cnica del sistema actual de ventilaci\u00f3n.", "en": "Boost air renewal capacity due to +7.4% upward trend. Recommend adding extractors or technical review of ventilation system."}}, "temperature": {"tendencia_general": "-1.0%", "patron_largo_plazo": {"es": "estabilidad con fluctuaciones menores", "en": "Confirm stability with minor fluctuations."}, "impacto_negocio": {"es": "Variaci\u00f3n t\u00e9rmica mensual m\u00ednima de -1.0%. La estabilidad t\u00e9rmica permite mantener un consumo energ\u00e9tico predecible y facilita la planificaci\u00f3n de recursos.", "en": "Register minimal monthly thermal variation of -1.0%. Stable thermal conditions support predictable energy consumption and resource planning."}, "recomendacion_inversion": {"es": "El comportamiento t\u00e9rmico del espacio es estable y predecible. No se requieren ajustes significativos en el sistema de climatizaci\u00f3n durante este periodo.", "en": "Affirm stable, predictable thermal behavior. No major HVAC adjustments required this period."}}, "humidity": {"tendencia_general": "+0.8%", "patron_largo_plazo": {"es": "estabilidad con fluctuaciones menores", "en": "Show balanced humidity conditions with +0.8% monthly variation. Stability within ASHRAE range supports occupant comfort and space preservation."}, "impacto_negocio": {"es": "Las condiciones de humedad han permanecido equilibradas durante el mes con variaci\u00f3n de +0.8%. Este comportamiento estable dentro del rango ASHRAE favorece el bienestar y la conservaci\u00f3n del espacio.", "en": "Sustain well-managed humidity levels with current systems. Continue usual ventilation and schedule periodic reviews."}, "recomendacion_inversion": {"es": "Los niveles de humedad est\u00e1n bien gestionados con los sistemas actuales. Continuar con la ventilaci\u00f3n habitual y realizar revisiones peri\u00f3dicas para mantener este equilibrio.", "en": "Base analysis on weighted scientific data from 22 working days per month."}}}}}}, "recomendaciones_y_alertas": {"recomendaciones_accionables": [{"prioridad": 2, "accion": {"es": "Prevenci\u00f3n pico Temperature", "en": "Peak Temperature Prevention"}, "descripcion": {"es": "Observamos ligera variaci\u00f3n t\u00e9rmica sin impacto significativo. Proyecci\u00f3n: 23.4\u00b0C en 11h (+0.5\u00b0C). El rango \u00f3ptimo es 21\u201324\u00b0C. Recomendamos revisi\u00f3n preventiva de climatizaci\u00f3n.", "en": "We observed a slight temperature variation with no significant impact. Projection: 23.4\u00b0C at 11:00 (+0.5\u00b0C). The optimal range is 21\u201324\u00b0C. We recommend preventive air conditioning maintenance."}, "momento_ejecucion": {"es": "Preparar climatizaci\u00f3n a media tarde (entre 16:00h\u201317:00h). Evaluar ajustes permanentes si contin\u00faa.", "en": "Prepare air conditioning in the mid-afternoon (between 4:00 PM and 5:00 PM). Assess permanent adjustments if it continues."}, "parametro_objetivo": "temperature", "valor_critico": 23.4}, {"prioridad": 3, "accion": {"es": "Prevenci\u00f3n pico Humidity", "en": "Peak Humidity Prevention"}, "descripcion": {"es": "Observamos ligera variaci\u00f3n de humedad sin impacto notable. Proyecci\u00f3n: 48% en 4h (+2%). El rango \u00f3ptimo es 40\u201360%. Sugerimos monitoreo preventivo.", "en": "We observed a slight variation in humidity with no significant impact. Projection: 48% in 4 hours (+2%). The optimal range is 40\u201360%. We recommend preventive monitoring."}, "momento_ejecucion": {"es": "Actuar en horario matinal, hacia las 09:00h. Observar evoluci\u00f3n durante los pr\u00f3ximos 3-5 d\u00edas.", "en": "Act in the morning, around 9:00 AM. Monitor progress over the next 3-5 days."}, "parametro_objetivo": "humidity", "valor_critico": 48}, {"prioridad": 2, "accion": {"es": "Optimizaci\u00f3n multi-par\u00e1metro", "en": "Multi-parameter optimization"}, "descripcion": {"es": "Coordinar sincronizar intervenciones de ventilaci\u00f3n, climatizaci\u00f3n y control de humedad para picos simult\u00e1neos de CO2 (20:00h), Temperature (17:00h) y Humidity (10:00h). Efecto conjunto amplifica impacto individual - requiere estrategia unificada", "en": "Coordinate and synchronize ventilation, air conditioning, and humidity control interventions for simultaneous peaks of CO2 (8:00 PM), temperature (5:00 PM), and humidity (10:00 AM). The combined effect amplifies the individual impact \u2013 a unified strategy is required."}, "momento_ejecucion": {"es": "Patr\u00f3n multi-par\u00e1metro detectado: pico HUMIDITY a las 10:00h. Coordinar sistemas preventivamente en futuros an\u00e1lisis", "en": "Multi-parameter pattern detected: HUMIDITY peak at 10:00 AM. Coordinate systems preventively in future analyses."}, "parametro_objetivo": "humidity", "valor_critico": 0}], "alertas_temporales_criticas": [{"tipo": "alerta_preventiva", "mensaje": {"es": "Ligera variaci\u00f3n t\u00e9rmica que puede afectar el confort (Temperatura: 23.4\u00b0C, rango \u00f3ptimo: 17-27\u00b0C). Revisi\u00f3n preventiva recomendada.", "en": "Flag slight thermal fluctuations. Temp. 23.4\u00b0C, optimal range 17-27\u00b0C. Preventive check recommended."}, "parametro": "temperature", "tiempo_restante": {"es": "Preparar climatizaci\u00f3n a media tarde (entre 16:00h\u201317:00h). Evaluar ajustes permanentes si contin\u00faa.", "en": "Schedule HVAC boost mid-afternoon (16:00\u201317:00). Assess permanent tweaks if trend persists."}, "valor_critico": 23.4}, {"tipo": "alerta_critica", "mensaje": {"es": "Sequedad ambiental que afectar\u00e1 las v\u00edas respiratorias (Humedad: 0%, m\u00ednimo: 30%). Considerar humidificaci\u00f3n.", "en": "Highlight extreme dryness. Humidity 0%, minimum 30%. Implement humidification measures."}, "parametro": "humidity", "tiempo_restante": {"es": "Patr\u00f3n multi-par\u00e1metro detectado: pico HUMIDITY a las 10:00h. Coordinar sistemas preventivamente en futuros an\u00e1lisis", "en": "Detect multi-parameter pattern: humidity peak at 10:00. Coordinate systems proactively for future analyses."}, "valor_critico": 0}]}, "impacto_economico_y_productividad": {"impacto_economico_solo_laborables": {"metodologia": {"es": "An\u00e1lisis hist\u00f3rico ponderado cient\u00edfico (22 d\u00edas laborables/mes)", "en": "Increase confidence in predictions. CO\u2082 varies with occupancy; temperature and humidity remain more stable."}, "ocupacion_oficina": 1, "beneficios_diarios": {"es_confiable": true, "beneficio_potencial_diario_eur": 4, "horas_beneficio_potencial_diarias": 0.42}, "beneficios_semanales": {"es_confiable": true, "beneficio_potencial_semanal_eur": 28}, "beneficios_mensuales": {"es_confiable": true, "beneficio_potencial_mensual_eur": 120, "dias_laborales_mes": 22}, "beneficios_anuales": {"es_confiable": true, "beneficio_potencial_anual_eur": 1441, "dias_laborales_anyo": 234}, "metadatos": {"metodologia": "An\u00e1lisis hist\u00f3rico ponderado cient\u00edfico (22 d\u00edas laborables/mes)", "ocupacion_oficina": 1}}}, "calidad_y_confianza_datos": {"calidad_predicciones": {"es_confiable": true, "confianza_co2_porcentaje": 86.2, "confianza_temperatura_porcentaje": 95.0, "confianza_humedad_porcentaje": 85.6, "calidad_general_porcentaje": 95.0, "confianza_global_porcentaje": 88.7, "registros_analizados": 4186, "periodo_analizado": "4186 registros (\u00faltimos 173 d\u00edas)", "explicacion": {"es": "Mayor confianza = predicciones m\u00e1s fiables. CO2 variable por ocupaci\u00f3n, temperatura/humedad m\u00e1s estables", "en": "Greater confidence = more reliable predictions. CO2 varies with occupancy, temperature/humidity more stable."}}}, "sensor_device_team": {"bienestar_7": 81, "bienestar_30": 90, "tendencia_7d": "negativa", "tendencia_30d": "negativa"}}"
  "2026-07-15 06:02:30"
  "2026-07-14"
  1
  "0add8c1c-2235-4944-9e3e-02a9044dd6d3"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO api_ai_receive (
  payload, created, processed_date,
  processed, oficina_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO api_ai_receive (payload, created, processed_date, processed, oficina_id) VALUES ('{\"oficina_id\": \"0add8c1c-2235-4944-9e3e-02a9044dd6d3\", \"timestamp\": \"15/07/26 06:01\", \"sensor_status\": {\"estado\": \"FUERA_DE_HORARIO\", \"ultima_lectura\": \"14/07/26 23:00\", \"tiempo_sin_datos_horas\": 7.0, \"nivel_alerta\": \"NORMAL\"}, \"analisis_temporal\": {\"indices_bienestar_comparativos\": {\"es_confiable\": true, \"mejor_dia_historico\": {\"fecha\": \"08/07/26\", \"fecha_explicativa\": {\"es\": \"Mi\\u00e9rcoles, Prom. 640\", \"en\": \"Report avg. 640 ppm on Wednesday.\"}, \"co2_ppm\": 640, \"temperatura_celsius\": 23.3, \"humedad_porcentaje\": 33, \"indice_bienestar\": 99}, \"peor_dia_historico\": {\"fecha\": \"14/07/26\", \"fecha_explicativa\": {\"es\": \"Martes, Prom. 660\", \"en\": \"Register avg. 660 ppm on Tuesday.\"}, \"co2_ppm\": 660, \"temperatura_celsius\": 23.6, \"humedad_porcentaje\": 35, \"indice_bienestar\": 100}, \"hoy_vs_mejor_dia_historico\": {\"co2_diferencia_ppm\": 66, \"co2_diferencia_porcentaje\": 10.2, \"temperatura_diferencia_celsius\": 0.5, \"humedad_diferencia_puntos\": 14, \"bienestar_perdido_puntos\": 0.6}, \"promedio_bienestar_actual\": 98.2, \"rango_bienestar_historico\": {\"mejor\": 99, \"peor\": 100, \"amplitud\": -1}}, \"patrones_semanales_detallados\": {\"es_confiable\": true, \"dias\": [{\"dia\": \"1\", \"co2_actual_ppm\": 661, \"co2_desviacion_ppm\": -339, \"temperatura_actual_celsius\": 23.0, \"temperatura_desviacion_celsius\": -1.5, \"humedad_actual_porcentaje\": 31, \"humedad_desviacion_puntos\": -21.5, \"horas_beneficio_potencial\": 2.3, \"beneficio_potencial_eur\": 1}, {\"dia\": \"2\", \"co2_actual_ppm\": 687, \"co2_desviacion_ppm\": -313, \"temperatura_actual_celsius\": 23.6, \"temperatura_desviacion_celsius\": -0.9, \"humedad_actual_porcentaje\": 34, \"humedad_desviacion_puntos\": -18.5, \"horas_beneficio_potencial\": 1.9, \"beneficio_potencial_eur\": 1}, {\"dia\": \"3\", \"co2_actual_ppm\": 614, \"co2_desviacion_ppm\": -386, \"temperatura_actual_celsius\": 23.4, \"temperatura_desviacion_celsius\": -1.1, \"humedad_actual_porcentaje\": 34, \"humedad_desviacion_puntos\": -18.5, \"horas_beneficio_potencial\": 2.0, \"beneficio_potencial_eur\": 1}, {\"dia\": \"4\", \"co2_actual_ppm\": 676, \"co2_desviacion_ppm\": -324, \"temperatura_actual_celsius\": 23.8, \"temperatura_desviacion_celsius\": -0.7, \"humedad_actual_porcentaje\": 30, \"humedad_desviacion_puntos\": -22.5, \"horas_beneficio_potencial\": 2.2, \"beneficio_potencial_eur\": 1}, {\"dia\": \"5\", \"co2_actual_ppm\": 639, \"co2_desviacion_ppm\": -361, \"temperatura_actual_celsius\": 23.8, \"temperatura_desviacion_celsius\": -0.7, \"humedad_actual_porcentaje\": 32, \"humedad_desviacion_puntos\": -20.5, \"horas_beneficio_potencial\": 2.1, \"beneficio_potencial_eur\": 1}], \"hoy_vs_historico\": {\"co2_diferencia_porcentaje\": -36.0, \"temperatura_diferencia_porcentaje\": -4.0, \"humedad_diferencia_porcentaje\": -35.9, \"horas_beneficio_potencial_hoy\": 0, \"horas_beneficio_potencial_promedio_semanal\": 0, \"beneficio_potencial_hoy_eur\": 4, \"beneficio_potencial_promedio_semanal_eur\": 28}}}, \"predicciones_y_horarios\": {\"horarios_criticos_especificos\": {\"es_confiable\": true, \"_validation\": {\"is_valid\": true, \"valid_parameters\": [\"co2\", \"temperatura\", \"humedad\"], \"invalid_parameters\": [], \"reason\": null}, \"co2_picos_historicos\": {\"peor_hora\": \"21:00\", \"segunda_peor\": \"22:00\", \"tercera_peor\": \"20:00\", \"proximo_pico_predicho\": {\"hora\": \"20:00\", \"valor_esperado_ppm\": 771, \"tiempo_restante_horas\": 14, \"clasificacion\": \"preventiva\"}, \"_validation\": {\"is_valid\": true, \"completeness_score\": 1.0, \"missing_fields\": [], \"reason\": null}}, \"temperatura_picos_historicos\": {\"peor_hora\": \"18:00\", \"segunda_peor\": \"19:00\", \"tercera_peor\": \"17:00\", \"proximo_pico_predicho\": {\"hora\": \"17:00\", \"valor_esperado_celsius\": 23.4, \"tiempo_restante_horas\": 11, \"clasificacion\": \"preventiva\"}, \"_validation\": {\"is_valid\": true, \"completeness_score\": 1.0, \"missing_fields\": [], \"reason\": null}}, \"humedad_picos_historicos\": {\"peor_hora\": \"11:00\", \"segunda_peor\": \"10:00\", \"tercera_peor\": \"12:00\", \"proximo_pico_predicho\": {\"hora\": \"10:00\", \"valor_esperado_porcentaje\": 48, \"tiempo_restante_horas\": 4, \"clasificacion\": \"preventiva\"}, \"_validation\": {\"is_valid\": true, \"completeness_score\": 1.0, \"missing_fields\": [], \"reason\": null}}}, \"predicciones_negocio_7_30_dias\": {\"predicciones_7_dias\": {\"dias_criticos\": [{\"dia\": \"1\", \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 654, \"unidad\": \"ppm\", \"hr_start\": 20, \"hr_end\": 21, \"es_critico\": false}, \"temperature\": {\"valor\": 23.3, \"unidad\": \"\\u00b0C\", \"hr_start\": 21, \"hr_end\": 22, \"es_critico\": false}, \"humidity\": {\"valor\": 35, \"unidad\": \"%\", \"hr_start\": 12, \"hr_end\": 13, \"es_critico\": false}}}, {\"dia\": \"2\", \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 660, \"unidad\": \"ppm\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": false}, \"temperature\": {\"valor\": 23.6, \"unidad\": \"\\u00b0C\", \"hr_start\": 12, \"hr_end\": 13, \"es_critico\": false}, \"humidity\": {\"valor\": 35, \"unidad\": \"%\", \"hr_start\": 18, \"hr_end\": 19, \"es_critico\": false}}}, {\"dia\": \"3\", \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 640, \"unidad\": \"ppm\", \"hr_start\": 12, \"hr_end\": 13, \"es_critico\": false}, \"temperature\": {\"valor\": 23.6, \"unidad\": \"\\u00b0C\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": false}, \"humidity\": {\"valor\": 33, \"unidad\": \"%\", \"hr_start\": 18, \"hr_end\": 19, \"es_critico\": true}}}, {\"dia\": \"4\", \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 650, \"unidad\": \"ppm\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": false}, \"temperature\": {\"valor\": 23.6, \"unidad\": \"\\u00b0C\", \"hr_start\": 16, \"hr_end\": 17, \"es_critico\": false}, \"humidity\": {\"valor\": 33, \"unidad\": \"%\", \"hr_start\": 18, \"hr_end\": 19, \"es_critico\": true}}}, {\"dia\": \"5\", \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 652, \"unidad\": \"ppm\", \"hr_start\": 12, \"hr_end\": 13, \"es_critico\": false}, \"temperature\": {\"valor\": 23.6, \"unidad\": \"\\u00b0C\", \"hr_start\": 16, \"hr_end\": 17, \"es_critico\": false}, \"humidity\": {\"valor\": 33, \"unidad\": \"%\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": true}}}], \"resumen_tendencias\": {\"co2\": {\"tendencia_general\": \"-1.5%\", \"impacto_negocio\": {\"es\": \"El an\\u00e1lisis revela variabilidad moderada en CO (+1.4%), con 5 jornadas presentando valores ligeramente elevados. Este comportamiento indica fluctuaciones perceptibles asociadas a la ocupaci\\u00f3n. Establecer una ventilaci\\u00f3n sistem\\u00e1tica ayudar\\u00eda a homogeneizar los niveles.\", \"en\": \"Highlight moderate CO fluctuations (+1.4%) with 5 days showing slightly elevated readings. Systematic ventilation would even out readings.\"}, \"recomendacion_planificacion\": {\"es\": \"Establecer un patr\\u00f3n de ventilaci\\u00f3n m\\u00e1s regular (+1.4% var.), especialmente en Lunes (20-21h) (Prom. 654), Martes Ma\\u00f1ana (9-11h) (Prom. 660). Esto ayudar\\u00e1 a homogeneizar los niveles semanales.\", \"en\": \"Implement a more regular ventilation pattern (+1.4% fluctuation), especially Monday 20-21h (Avg. 654) and Tuesday morning 9-11h (Avg. 660). This will even out weekly readings.\"}}, \"temperature\": {\"tendencia_general\": \"+0.6%\", \"impacto_negocio\": {\"es\": \"\\u00daltimas jornadas muestran variabilidad t\\u00e9rmicas de +0.6%, con fluctuaciones perceptibles en 5 d\\u00edas. El entorno se mantiene relativamente estable, aunque una calibraci\\u00f3n del sistema mejorar\\u00eda la uniformidad t\\u00e9rmica.\", \"en\": \"Detect thermal fluctuations of +0.6% over 5 days. Environment remains fairly stable; system calibration would improve thermal uniformity.\"}, \"recomendacion_planificacion\": {\"es\": \"Ajustar puntualmente la climatizaci\\u00f3n en los d\\u00edas con variaciones (+0.6%). El equilibrio t\\u00e9rmico el resto de la semana es excelente.\", \"en\": \"Fine-tune HVAC on days with +0.6% variation. Thermal balance is excellent the rest of the week.\"}}, \"humidity\": {\"tendencia_general\": \"-5.7%\", \"impacto_negocio\": {\"es\": \"Variaciones en humedad de -0.3% detectadas en 5 jornadas. La media permanece en el rango saludable ASHRAE (40-60%), sin riesgos inmediatos.\", \"en\": \"Identify humidity variations of -0.3% across 5 days. Average stays within healthy ASHRAE range (40-60%), posing no immediate risk.\"}, \"recomendacion_planificacion\": {\"es\": \"Niveles de humedad equilibrados (-0.3% de variaci\\u00f3n). Mantener la rutina actual de ventilaci\\u00f3n sin necesidad de ajustes adicionales.\", \"en\": \"Maintain current ventilation routine. Humidity balanced with -0.3% variation. No further adjustments needed.\"}}}}, \"predicciones_30_dias\": {\"semanas_disponibles\": 4, \"dias_criticos\": {\"semana_1\": [{\"dia_mes\": 3, \"semana_mes\": 1, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 654, \"unidad\": \"ppm\", \"hr_start\": 20, \"hr_end\": 21, \"es_critico\": false}, \"temperature\": {\"valor\": 23.3, \"unidad\": \"\\u00b0C\", \"hr_start\": 21, \"hr_end\": 22, \"es_critico\": false}, \"humidity\": {\"valor\": 35, \"unidad\": \"%\", \"hr_start\": 12, \"hr_end\": 13, \"es_critico\": false}}}, {\"dia_mes\": 4, \"semana_mes\": 1, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 660, \"unidad\": \"ppm\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": false}, \"temperature\": {\"valor\": 23.6, \"unidad\": \"\\u00b0C\", \"hr_start\": 12, \"hr_end\": 13, \"es_critico\": false}, \"humidity\": {\"valor\": 35, \"unidad\": \"%\", \"hr_start\": 18, \"hr_end\": 19, \"es_critico\": false}}}, {\"dia_mes\": 5, \"semana_mes\": 1, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 640, \"unidad\": \"ppm\", \"hr_start\": 12, \"hr_end\": 13, \"es_critico\": false}, \"temperature\": {\"valor\": 23.6, \"unidad\": \"\\u00b0C\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": false}, \"humidity\": {\"valor\": 33, \"unidad\": \"%\", \"hr_start\": 18, \"hr_end\": 19, \"es_critico\": true}}}, {\"dia_mes\": 6, \"semana_mes\": 1, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 650, \"unidad\": \"ppm\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": false}, \"temperature\": {\"valor\": 23.6, \"unidad\": \"\\u00b0C\", \"hr_start\": 16, \"hr_end\": 17, \"es_critico\": false}, \"humidity\": {\"valor\": 33, \"unidad\": \"%\", \"hr_start\": 18, \"hr_end\": 19, \"es_critico\": true}}}, {\"dia_mes\": 7, \"semana_mes\": 1, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 652, \"unidad\": \"ppm\", \"hr_start\": 12, \"hr_end\": 13, \"es_critico\": false}, \"temperature\": {\"valor\": 23.6, \"unidad\": \"\\u00b0C\", \"hr_start\": 16, \"hr_end\": 17, \"es_critico\": false}, \"humidity\": {\"valor\": 33, \"unidad\": \"%\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": true}}}], \"semana_2\": [{\"dia_mes\": 10, \"semana_mes\": 2, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 733, \"unidad\": \"ppm\", \"hr_start\": 20, \"hr_end\": 21, \"es_critico\": false}, \"temperature\": {\"valor\": 24.8, \"unidad\": \"\\u00b0C\", \"hr_start\": 21, \"hr_end\": 22, \"es_critico\": false}, \"humidity\": {\"valor\": 41, \"unidad\": \"%\", \"hr_start\": 10, \"hr_end\": 11, \"es_critico\": false}}}, {\"dia_mes\": 11, \"semana_mes\": 2, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 681, \"unidad\": \"ppm\", \"hr_start\": 10, \"hr_end\": 12, \"es_critico\": false}, \"temperature\": {\"valor\": 25.2, \"unidad\": \"\\u00b0C\", \"hr_start\": 10, \"hr_end\": 11, \"es_critico\": false}, \"humidity\": {\"valor\": 50, \"unidad\": \"%\", \"hr_start\": 18, \"hr_end\": 19, \"es_critico\": false}}}, {\"dia_mes\": 12, \"semana_mes\": 2, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 685, \"unidad\": \"ppm\", \"hr_start\": 12, \"hr_end\": 13, \"es_critico\": false}, \"temperature\": {\"valor\": 24.0, \"unidad\": \"\\u00b0C\", \"hr_start\": 10, \"hr_end\": 12, \"es_critico\": false}, \"humidity\": {\"valor\": 30, \"unidad\": \"%\", \"hr_start\": 20, \"hr_end\": 21, \"es_critico\": true}}}, {\"dia_mes\": 13, \"semana_mes\": 2, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 665, \"unidad\": \"ppm\", \"hr_start\": 8, \"hr_end\": 10, \"es_critico\": false}, \"temperature\": {\"valor\": 22.5, \"unidad\": \"\\u00b0C\", \"hr_start\": 16, \"hr_end\": 17, \"es_critico\": false}, \"humidity\": {\"valor\": 48, \"unidad\": \"%\", \"hr_start\": 19, \"hr_end\": 20, \"es_critico\": false}}}, {\"dia_mes\": 14, \"semana_mes\": 2, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 739, \"unidad\": \"ppm\", \"hr_start\": 13, \"hr_end\": 14, \"es_critico\": false}, \"temperature\": {\"valor\": 24.3, \"unidad\": \"\\u00b0C\", \"hr_start\": 15, \"hr_end\": 16, \"es_critico\": false}, \"humidity\": {\"valor\": 30, \"unidad\": \"%\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": true}}}], \"semana_3\": [{\"dia_mes\": 17, \"semana_mes\": 3, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 764, \"unidad\": \"ppm\", \"hr_start\": 20, \"hr_end\": 21, \"es_critico\": false}, \"temperature\": {\"valor\": 24.1, \"unidad\": \"\\u00b0C\", \"hr_start\": 21, \"hr_end\": 22, \"es_critico\": false}, \"humidity\": {\"valor\": 30, \"unidad\": \"%\", \"hr_start\": 13, \"hr_end\": 14, \"es_critico\": true}}}, {\"dia_mes\": 18, \"semana_mes\": 3, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 814, \"unidad\": \"ppm\", \"hr_start\": 11, \"hr_end\": 13, \"es_critico\": false}, \"temperature\": {\"valor\": 22.3, \"unidad\": \"\\u00b0C\", \"hr_start\": 10, \"hr_end\": 11, \"es_critico\": false}}}, {\"dia_mes\": 19, \"semana_mes\": 3, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 697, \"unidad\": \"ppm\", \"hr_start\": 10, \"hr_end\": 11, \"es_critico\": false}, \"temperature\": {\"valor\": 23.1, \"unidad\": \"\\u00b0C\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": false}, \"humidity\": {\"valor\": 37, \"unidad\": \"%\", \"hr_start\": 18, \"hr_end\": 19, \"es_critico\": false}}}, {\"dia_mes\": 20, \"semana_mes\": 3, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 669, \"unidad\": \"ppm\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": false}, \"temperature\": {\"valor\": 23.1, \"unidad\": \"\\u00b0C\", \"hr_start\": 16, \"hr_end\": 17, \"es_critico\": false}, \"humidity\": {\"valor\": 44, \"unidad\": \"%\", \"hr_start\": 16, \"hr_end\": 17, \"es_critico\": false}}}, {\"dia_mes\": 21, \"semana_mes\": 3, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 762, \"unidad\": \"ppm\", \"hr_start\": 13, \"hr_end\": 14, \"es_critico\": false}, \"temperature\": {\"valor\": 22.7, \"unidad\": \"\\u00b0C\", \"hr_start\": 16, \"hr_end\": 17, \"es_critico\": false}, \"humidity\": {\"valor\": 43, \"unidad\": \"%\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": false}}}], \"semana_4\": [{\"dia_mes\": 24, \"semana_mes\": 4, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 623, \"unidad\": \"ppm\", \"hr_start\": 20, \"hr_end\": 21, \"es_critico\": false}, \"temperature\": {\"valor\": 24.8, \"unidad\": \"\\u00b0C\", \"hr_start\": 21, \"hr_end\": 22, \"es_critico\": false}, \"humidity\": {\"valor\": 44, \"unidad\": \"%\", \"hr_start\": 12, \"hr_end\": 13, \"es_critico\": false}}}, {\"dia_mes\": 25, \"semana_mes\": 4, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 653, \"unidad\": \"ppm\", \"hr_start\": 10, \"hr_end\": 12, \"es_critico\": false}, \"temperature\": {\"valor\": 24.9, \"unidad\": \"\\u00b0C\", \"hr_start\": 12, \"hr_end\": 13, \"es_critico\": false}, \"humidity\": {\"valor\": 34, \"unidad\": \"%\", \"hr_start\": 18, \"hr_end\": 19, \"es_critico\": true}}}, {\"dia_mes\": 26, \"semana_mes\": 4, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 676, \"unidad\": \"ppm\", \"hr_start\": 13, \"hr_end\": 14, \"es_critico\": false}, \"temperature\": {\"valor\": 23.6, \"unidad\": \"\\u00b0C\", \"hr_start\": 9, \"hr_end\": 11, \"es_critico\": false}, \"humidity\": {\"valor\": 34, \"unidad\": \"%\", \"hr_start\": 19, \"hr_end\": 20, \"es_critico\": true}}}, {\"dia_mes\": 27, \"semana_mes\": 4, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 664, \"unidad\": \"ppm\", \"hr_start\": 10, \"hr_end\": 12, \"es_critico\": false}, \"temperature\": {\"valor\": 23.9, \"unidad\": \"\\u00b0C\", \"hr_start\": 16, \"hr_end\": 17, \"es_critico\": false}, \"humidity\": {\"valor\": 32, \"unidad\": \"%\", \"hr_start\": 18, \"hr_end\": 19, \"es_critico\": true}}}, {\"dia_mes\": 28, \"semana_mes\": 4, \"es_confiable\": true, \"valores\": {\"co2\": {\"valor\": 822, \"unidad\": \"ppm\", \"hr_start\": 10, \"hr_end\": 11, \"es_critico\": false}, \"temperature\": {\"valor\": 22.9, \"unidad\": \"\\u00b0C\", \"hr_start\": 18, \"hr_end\": 19, \"es_critico\": false}, \"humidity\": {\"valor\": 40, \"unidad\": \"%\", \"hr_start\": 10, \"hr_end\": 12, \"es_critico\": false}}}]}, \"resumen_tendencias\": {\"co2\": {\"tendencia_general\": \"+7.4%\", \"patron_largo_plazo\": {\"es\": \"incremento gradual sostenido\", \"en\": \"Show sustained gradual increase.\"}, \"impacto_negocio\": {\"es\": \"El an\\u00e1lisis mensual refleja una evoluci\\u00f3n al alza de +7.4% en los valores de CO\\u2082. Si esta progresi\\u00f3n se mantiene, comenzar\\u00e1n a aparecer s\\u00edntomas de concentraci\\u00f3n disminuida y fatiga mental.\", \"en\": \"Reveal monthly CO\\u2082 rise of +7.4%. Continued growth will trigger concentration loss and mental fatigue symptoms.\"}, \"recomendacion_inversion\": {\"es\": \"Con una tendencia al alza de +7.4%, conviene reforzar la capacidad de renovaci\\u00f3n del aire. Considerar la instalaci\\u00f3n de extractores adicionales o una revisi\\u00f3n t\\u00e9cnica del sistema actual de ventilaci\\u00f3n.\", \"en\": \"Boost air renewal capacity due to +7.4% upward trend. Recommend adding extractors or technical review of ventilation system.\"}}, \"temperature\": {\"tendencia_general\": \"-1.0%\", \"patron_largo_plazo\": {\"es\": \"estabilidad con fluctuaciones menores\", \"en\": \"Confirm stability with minor fluctuations.\"}, \"impacto_negocio\": {\"es\": \"Variaci\\u00f3n t\\u00e9rmica mensual m\\u00ednima de -1.0%. La estabilidad t\\u00e9rmica permite mantener un consumo energ\\u00e9tico predecible y facilita la planificaci\\u00f3n de recursos.\", \"en\": \"Register minimal monthly thermal variation of -1.0%. Stable thermal conditions support predictable energy consumption and resource planning.\"}, \"recomendacion_inversion\": {\"es\": \"El comportamiento t\\u00e9rmico del espacio es estable y predecible. No se requieren ajustes significativos en el sistema de climatizaci\\u00f3n durante este periodo.\", \"en\": \"Affirm stable, predictable thermal behavior. No major HVAC adjustments required this period.\"}}, \"humidity\": {\"tendencia_general\": \"+0.8%\", \"patron_largo_plazo\": {\"es\": \"estabilidad con fluctuaciones menores\", \"en\": \"Show balanced humidity conditions with +0.8% monthly variation. Stability within ASHRAE range supports occupant comfort and space preservation.\"}, \"impacto_negocio\": {\"es\": \"Las condiciones de humedad han permanecido equilibradas durante el mes con variaci\\u00f3n de +0.8%. Este comportamiento estable dentro del rango ASHRAE favorece el bienestar y la conservaci\\u00f3n del espacio.\", \"en\": \"Sustain well-managed humidity levels with current systems. Continue usual ventilation and schedule periodic reviews.\"}, \"recomendacion_inversion\": {\"es\": \"Los niveles de humedad est\\u00e1n bien gestionados con los sistemas actuales. Continuar con la ventilaci\\u00f3n habitual y realizar revisiones peri\\u00f3dicas para mantener este equilibrio.\", \"en\": \"Base analysis on weighted scientific data from 22 working days per month.\"}}}}}}, \"recomendaciones_y_alertas\": {\"recomendaciones_accionables\": [{\"prioridad\": 2, \"accion\": {\"es\": \"Prevenci\\u00f3n pico Temperature\", \"en\": \"Peak Temperature Prevention\"}, \"descripcion\": {\"es\": \"Observamos ligera variaci\\u00f3n t\\u00e9rmica sin impacto significativo. Proyecci\\u00f3n: 23.4\\u00b0C en 11h (+0.5\\u00b0C). El rango \\u00f3ptimo es 21\\u201324\\u00b0C. Recomendamos revisi\\u00f3n preventiva de climatizaci\\u00f3n.\", \"en\": \"We observed a slight temperature variation with no significant impact. Projection: 23.4\\u00b0C at 11:00 (+0.5\\u00b0C). The optimal range is 21\\u201324\\u00b0C. We recommend preventive air conditioning maintenance.\"}, \"momento_ejecucion\": {\"es\": \"Preparar climatizaci\\u00f3n a media tarde (entre 16:00h\\u201317:00h). Evaluar ajustes permanentes si contin\\u00faa.\", \"en\": \"Prepare air conditioning in the mid-afternoon (between 4:00 PM and 5:00 PM). Assess permanent adjustments if it continues.\"}, \"parametro_objetivo\": \"temperature\", \"valor_critico\": 23.4}, {\"prioridad\": 3, \"accion\": {\"es\": \"Prevenci\\u00f3n pico Humidity\", \"en\": \"Peak Humidity Prevention\"}, \"descripcion\": {\"es\": \"Observamos ligera variaci\\u00f3n de humedad sin impacto notable. Proyecci\\u00f3n: 48% en 4h (+2%). El rango \\u00f3ptimo es 40\\u201360%. Sugerimos monitoreo preventivo.\", \"en\": \"We observed a slight variation in humidity with no significant impact. Projection: 48% in 4 hours (+2%). The optimal range is 40\\u201360%. We recommend preventive monitoring.\"}, \"momento_ejecucion\": {\"es\": \"Actuar en horario matinal, hacia las 09:00h. Observar evoluci\\u00f3n durante los pr\\u00f3ximos 3-5 d\\u00edas.\", \"en\": \"Act in the morning, around 9:00 AM. Monitor progress over the next 3-5 days.\"}, \"parametro_objetivo\": \"humidity\", \"valor_critico\": 48}, {\"prioridad\": 2, \"accion\": {\"es\": \"Optimizaci\\u00f3n multi-par\\u00e1metro\", \"en\": \"Multi-parameter optimization\"}, \"descripcion\": {\"es\": \"Coordinar sincronizar intervenciones de ventilaci\\u00f3n, climatizaci\\u00f3n y control de humedad para picos simult\\u00e1neos de CO2 (20:00h), Temperature (17:00h) y Humidity (10:00h). Efecto conjunto amplifica impacto individual - requiere estrategia unificada\", \"en\": \"Coordinate and synchronize ventilation, air conditioning, and humidity control interventions for simultaneous peaks of CO2 (8:00 PM), temperature (5:00 PM), and humidity (10:00 AM). The combined effect amplifies the individual impact \\u2013 a unified strategy is required.\"}, \"momento_ejecucion\": {\"es\": \"Patr\\u00f3n multi-par\\u00e1metro detectado: pico HUMIDITY a las 10:00h. Coordinar sistemas preventivamente en futuros an\\u00e1lisis\", \"en\": \"Multi-parameter pattern detected: HUMIDITY peak at 10:00 AM. Coordinate systems preventively in future analyses.\"}, \"parametro_objetivo\": \"humidity\", \"valor_critico\": 0}], \"alertas_temporales_criticas\": [{\"tipo\": \"alerta_preventiva\", \"mensaje\": {\"es\": \"Ligera variaci\\u00f3n t\\u00e9rmica que puede afectar el confort (Temperatura: 23.4\\u00b0C, rango \\u00f3ptimo: 17-27\\u00b0C). Revisi\\u00f3n preventiva recomendada.\", \"en\": \"Flag slight thermal fluctuations. Temp. 23.4\\u00b0C, optimal range 17-27\\u00b0C. Preventive check recommended.\"}, \"parametro\": \"temperature\", \"tiempo_restante\": {\"es\": \"Preparar climatizaci\\u00f3n a media tarde (entre 16:00h\\u201317:00h). Evaluar ajustes permanentes si contin\\u00faa.\", \"en\": \"Schedule HVAC boost mid-afternoon (16:00\\u201317:00). Assess permanent tweaks if trend persists.\"}, \"valor_critico\": 23.4}, {\"tipo\": \"alerta_critica\", \"mensaje\": {\"es\": \"Sequedad ambiental que afectar\\u00e1 las v\\u00edas respiratorias (Humedad: 0%, m\\u00ednimo: 30%). Considerar humidificaci\\u00f3n.\", \"en\": \"Highlight extreme dryness. Humidity 0%, minimum 30%. Implement humidification measures.\"}, \"parametro\": \"humidity\", \"tiempo_restante\": {\"es\": \"Patr\\u00f3n multi-par\\u00e1metro detectado: pico HUMIDITY a las 10:00h. Coordinar sistemas preventivamente en futuros an\\u00e1lisis\", \"en\": \"Detect multi-parameter pattern: humidity peak at 10:00. Coordinate systems proactively for future analyses.\"}, \"valor_critico\": 0}]}, \"impacto_economico_y_productividad\": {\"impacto_economico_solo_laborables\": {\"metodologia\": {\"es\": \"An\\u00e1lisis hist\\u00f3rico ponderado cient\\u00edfico (22 d\\u00edas laborables/mes)\", \"en\": \"Increase confidence in predictions. CO\\u2082 varies with occupancy; temperature and humidity remain more stable.\"}, \"ocupacion_oficina\": 1, \"beneficios_diarios\": {\"es_confiable\": true, \"beneficio_potencial_diario_eur\": 4, \"horas_beneficio_potencial_diarias\": 0.42}, \"beneficios_semanales\": {\"es_confiable\": true, \"beneficio_potencial_semanal_eur\": 28}, \"beneficios_mensuales\": {\"es_confiable\": true, \"beneficio_potencial_mensual_eur\": 120, \"dias_laborales_mes\": 22}, \"beneficios_anuales\": {\"es_confiable\": true, \"beneficio_potencial_anual_eur\": 1441, \"dias_laborales_anyo\": 234}, \"metadatos\": {\"metodologia\": \"An\\u00e1lisis hist\\u00f3rico ponderado cient\\u00edfico (22 d\\u00edas laborables/mes)\", \"ocupacion_oficina\": 1}}}, \"calidad_y_confianza_datos\": {\"calidad_predicciones\": {\"es_confiable\": true, \"confianza_co2_porcentaje\": 86.2, \"confianza_temperatura_porcentaje\": 95.0, \"confianza_humedad_porcentaje\": 85.6, \"calidad_general_porcentaje\": 95.0, \"confianza_global_porcentaje\": 88.7, \"registros_analizados\": 4186, \"periodo_analizado\": \"4186 registros (\\u00faltimos 173 d\\u00edas)\", \"explicacion\": {\"es\": \"Mayor confianza = predicciones m\\u00e1s fiables. CO2 variable por ocupaci\\u00f3n, temperatura/humedad m\\u00e1s estables\", \"en\": \"Greater confidence = more reliable predictions. CO2 varies with occupancy, temperature/humidity more stable.\"}}}, \"sensor_device_team\": {\"bienestar_7\": 81, \"bienestar_30\": 90, \"tendencia_7d\": \"negativa\", \"tendencia_30d\": \"negativa\"}}', '2026-07-15 06:02:30', '2026-07-14', 1, '0add8c1c-2235-4944-9e3e-02a9044dd6d3');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\ApiLogController->aiReceive (line 658)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.34 ms
(1.07%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.created AS created_3, t0.cvh_pred7co2_tendencia_general AS cvh_pred7co2_tendencia_general_4, t0.cvh_pred7co2_impacto AS cvh_pred7co2_impacto_5, t0.cvh_pred7co2_recomendacion AS cvh_pred7co2_recomendacion_6, t0.cvh_pred7_temp_tendencia_general AS cvh_pred7_temp_tendencia_general_7, t0.cvh_pred7_temp_impacto AS cvh_pred7_temp_impacto_8, t0.cvh_pred7_temp_recomendacion AS cvh_pred7_temp_recomendacion_9, t0.cvh_pred7_hum_tendencia_general AS cvh_pred7_hum_tendencia_general_10, t0.cvh_pred7_hum_impacto AS cvh_pred7_hum_impacto_11, t0.cvh_pred7_hum_recomendacion AS cvh_pred7_hum_recomendacion_12, t0.cvh_pred30co2_tendencia_general AS cvh_pred30co2_tendencia_general_13, t0.cvh_pred30co2_patron_largo_plazo AS cvh_pred30co2_patron_largo_plazo_14, t0.cvh_pred30co2_impacto AS cvh_pred30co2_impacto_15, t0.cvh_pred30co2_recomendacion AS cvh_pred30co2_recomendacion_16, t0.cvh_pred30_temp_tendencia_general AS cvh_pred30_temp_tendencia_general_17, t0.cvh_pred30_temp_patron_largo_plazo AS cvh_pred30_temp_patron_largo_plazo_18, t0.cvh_pred30_temp_impacto AS cvh_pred30_temp_impacto_19, t0.cvh_pred30_temp_recomendacion AS cvh_pred30_temp_recomendacion_20, t0.cvh_pred30_hum_tendencia_general AS cvh_pred30_hum_tendencia_general_21, t0.cvh_pred30_hum_patron_largo_plazo AS cvh_pred30_hum_patron_largo_plazo_22, t0.cvh_pred30_hum_impacto AS cvh_pred30_hum_impacto_23, t0.cvh_pred30_hum_recomendacion AS cvh_pred30_hum_recomendacion_24, t0.es_confiable AS es_confiable_25, t0.oficina_id AS oficina_id_26 FROM ai_predicciones t0 WHERE t0.oficina_id = ? AND t0.date = ? LIMIT 1

Parameters:

[
  "0add8c1c-2235-4944-9e3e-02a9044dd6d3"
  "2026-07-15"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.created AS created_3,
  t0.cvh_pred7co2_tendencia_general AS cvh_pred7co2_tendencia_general_4,
  t0.cvh_pred7co2_impacto AS cvh_pred7co2_impacto_5,
  t0.cvh_pred7co2_recomendacion AS cvh_pred7co2_recomendacion_6,
  t0.cvh_pred7_temp_tendencia_general AS cvh_pred7_temp_tendencia_general_7,
  t0.cvh_pred7_temp_impacto AS cvh_pred7_temp_impacto_8,
  t0.cvh_pred7_temp_recomendacion AS cvh_pred7_temp_recomendacion_9,
  t0.cvh_pred7_hum_tendencia_general AS cvh_pred7_hum_tendencia_general_10,
  t0.cvh_pred7_hum_impacto AS cvh_pred7_hum_impacto_11,
  t0.cvh_pred7_hum_recomendacion AS cvh_pred7_hum_recomendacion_12,
  t0.cvh_pred30co2_tendencia_general AS cvh_pred30co2_tendencia_general_13,
  t0.cvh_pred30co2_patron_largo_plazo AS cvh_pred30co2_patron_largo_plazo_14,
  t0.cvh_pred30co2_impacto AS cvh_pred30co2_impacto_15,
  t0.cvh_pred30co2_recomendacion AS cvh_pred30co2_recomendacion_16,
  t0.cvh_pred30_temp_tendencia_general AS cvh_pred30_temp_tendencia_general_17,
  t0.cvh_pred30_temp_patron_largo_plazo AS cvh_pred30_temp_patron_largo_plazo_18,
  t0.cvh_pred30_temp_impacto AS cvh_pred30_temp_impacto_19,
  t0.cvh_pred30_temp_recomendacion AS cvh_pred30_temp_recomendacion_20,
  t0.cvh_pred30_hum_tendencia_general AS cvh_pred30_hum_tendencia_general_21,
  t0.cvh_pred30_hum_patron_largo_plazo AS cvh_pred30_hum_patron_largo_plazo_22,
  t0.cvh_pred30_hum_impacto AS cvh_pred30_hum_impacto_23,
  t0.cvh_pred30_hum_recomendacion AS cvh_pred30_hum_recomendacion_24,
  t0.es_confiable AS es_confiable_25,
  t0.oficina_id AS oficina_id_26
FROM
  ai_predicciones t0
WHERE
  t0.oficina_id = ?
  AND t0.date = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date AS date_2, t0.created AS created_3, t0.cvh_pred7co2_tendencia_general AS cvh_pred7co2_tendencia_general_4, t0.cvh_pred7co2_impacto AS cvh_pred7co2_impacto_5, t0.cvh_pred7co2_recomendacion AS cvh_pred7co2_recomendacion_6, t0.cvh_pred7_temp_tendencia_general AS cvh_pred7_temp_tendencia_general_7, t0.cvh_pred7_temp_impacto AS cvh_pred7_temp_impacto_8, t0.cvh_pred7_temp_recomendacion AS cvh_pred7_temp_recomendacion_9, t0.cvh_pred7_hum_tendencia_general AS cvh_pred7_hum_tendencia_general_10, t0.cvh_pred7_hum_impacto AS cvh_pred7_hum_impacto_11, t0.cvh_pred7_hum_recomendacion AS cvh_pred7_hum_recomendacion_12, t0.cvh_pred30co2_tendencia_general AS cvh_pred30co2_tendencia_general_13, t0.cvh_pred30co2_patron_largo_plazo AS cvh_pred30co2_patron_largo_plazo_14, t0.cvh_pred30co2_impacto AS cvh_pred30co2_impacto_15, t0.cvh_pred30co2_recomendacion AS cvh_pred30co2_recomendacion_16, t0.cvh_pred30_temp_tendencia_general AS cvh_pred30_temp_tendencia_general_17, t0.cvh_pred30_temp_patron_largo_plazo AS cvh_pred30_temp_patron_largo_plazo_18, t0.cvh_pred30_temp_impacto AS cvh_pred30_temp_impacto_19, t0.cvh_pred30_temp_recomendacion AS cvh_pred30_temp_recomendacion_20, t0.cvh_pred30_hum_tendencia_general AS cvh_pred30_hum_tendencia_general_21, t0.cvh_pred30_hum_patron_largo_plazo AS cvh_pred30_hum_patron_largo_plazo_22, t0.cvh_pred30_hum_impacto AS cvh_pred30_hum_impacto_23, t0.cvh_pred30_hum_recomendacion AS cvh_pred30_hum_recomendacion_24, t0.es_confiable AS es_confiable_25, t0.oficina_id AS oficina_id_26 FROM ai_predicciones t0 WHERE t0.oficina_id = '0add8c1c-2235-4944-9e3e-02a9044dd6d3' AND t0.date = '2026-07-15' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Event\AiPersistEvent->persistPayload (line 263)
5	App\Event\AiPersistEvent->__construct (line 40)
6	App\Controller\ApiLogController->aiReceive (line 663)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.31 ms
(1.05%)

UPDATE alertas_translation SET content = ? WHERE id = ?

Parameters:

[
  "Flag slight thermal fluctuations. Temp. 23.4°C, optimal range 17-27°C. Preventive check recommended."
  2413
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  alertas_translation
SET
  content = ?
WHERE
  id = ?

UPDATE alertas_translation SET content = 'Flag slight thermal fluctuations. Temp. 23.4°C, optimal range 17-27°C. Preventive check recommended.' WHERE id = 2413;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 687)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.31 ms
(1.05%)

INSERT INTO alertas_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "en"
  "App\Entity\AI\Alertas"
  "mensaje"
  1902
  "Ligera variación térmica que puede afectar el confort (Temperatura: 23.4°C, rango óptimo: 17-27°C). Revisión preventiva recomendada."
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO alertas_translation (
  locale, object_class, field, foreign_key,
  content
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO alertas_translation (locale, object_class, field, foreign_key, content) VALUES ('en', 'App\\Entity\\AI\\Alertas', 'mensaje', 1902, 'Ligera variación térmica que puede afectar el confort (Temperatura: 23.4°C, rango óptimo: 17-27°C). Revisión preventiva recomendada.');

#	File/Call
1	Doctrine\DBAL\Connection->insert (line 814)
2	Gedmo\Translatable\Mapping\Event\Adapter\ORM->insertTranslationRecord (line 204)
3	Gedmo\Translatable\TranslatableListener->postPersist (line 486)
4	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
5	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
6	Doctrine\ORM\UnitOfWork->executeInserts (line 1080)
7	Doctrine\ORM\UnitOfWork->commit (line 403)
8	Doctrine\ORM\EntityManager->flush (line 268)
9	App\Event\AiPersistEvent->persistPayload (line 665)
10	App\Event\AiPersistEvent->__construct (line 40)
11	App\Controller\ApiLogController->aiReceive (line 663)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

1.26 ms
(1.01%)

INSERT INTO ai_device_values (tipo, name, valor, ai_analisis_id) VALUES (?, ?, ?, ?)

Parameters:

[
  "teams"
  "bienestar_7"
  81
  1041
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_device_values (tipo, name, valor, ai_analisis_id)
VALUES
  (?, ?, ?, ?)

INSERT INTO ai_device_values (tipo, name, valor, ai_analisis_id) VALUES ('teams', 'bienestar_7', 81, 1041);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 258)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.12 ms
(0.90%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.created AS created_3, t0.mdh_fecha AS mdh_fecha_4, t0.mdh_fecha_explicativa AS mdh_fecha_explicativa_5, t0.mdh_co2 AS mdh_co2_6, t0.mdh_temp AS mdh_temp_7, t0.mdh_hum AS mdh_hum_8, t0.mdh_indice_b AS mdh_indice_b_9, t0.es_confiable_ibc AS es_confiable_ibc_10, t0.es_confiable_psd AS es_confiable_psd_11, t0.pdh_fecha AS pdh_fecha_12, t0.pdh_fecha_explicativa AS pdh_fecha_explicativa_13, t0.pdh_co2 AS pdh_co2_14, t0.pdh_temp AS pdh_temp_15, t0.pdh_hum AS pdh_hum_16, t0.pdh_indice_b AS pdh_indice_b_17, t0.hmdh_co2 AS hmdh_co2_18, t0.hmdh_co2_diff AS hmdh_co2_diff_19, t0.hmdh_temp_diff AS hmdh_temp_diff_20, t0.hmdh_hum_diff AS hmdh_hum_diff_21, t0.hmdh_bperdido AS hmdh_bperdido_22, t0.prom_bactual AS prom_bactual_23, t0.rbh_mejor AS rbh_mejor_24, t0.rbh_peor AS rbh_peor_25, t0.rbh_amplitud AS rbh_amplitud_26, t0.hvh_co2_diff AS hvh_co2_diff_27, t0.hvh_temp_diff AS hvh_temp_diff_28, t0.hvh_hum_diff AS hvh_hum_diff_29, t0.hvh_horas_bpotencial AS hvh_horas_bpotencial_30, t0.hvh_horas_bpotencial_promedio_semanal AS hvh_horas_bpotencial_promedio_semanal_31, t0.hvh_bpotencial_eur AS hvh_bpotencial_eur_32, t0.hvh_bpotencial_promedio_semanal_eur AS hvh_bpotencial_promedio_semanal_eur_33, t0.oficina_id AS oficina_id_34 FROM ai_analisis_temporal t0 WHERE t0.oficina_id = ? AND t0.date = ? LIMIT 1

Parameters:

[
  "0add8c1c-2235-4944-9e3e-02a9044dd6d3"
  "2026-07-15"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.created AS created_3,
  t0.mdh_fecha AS mdh_fecha_4,
  t0.mdh_fecha_explicativa AS mdh_fecha_explicativa_5,
  t0.mdh_co2 AS mdh_co2_6,
  t0.mdh_temp AS mdh_temp_7,
  t0.mdh_hum AS mdh_hum_8,
  t0.mdh_indice_b AS mdh_indice_b_9,
  t0.es_confiable_ibc AS es_confiable_ibc_10,
  t0.es_confiable_psd AS es_confiable_psd_11,
  t0.pdh_fecha AS pdh_fecha_12,
  t0.pdh_fecha_explicativa AS pdh_fecha_explicativa_13,
  t0.pdh_co2 AS pdh_co2_14,
  t0.pdh_temp AS pdh_temp_15,
  t0.pdh_hum AS pdh_hum_16,
  t0.pdh_indice_b AS pdh_indice_b_17,
  t0.hmdh_co2 AS hmdh_co2_18,
  t0.hmdh_co2_diff AS hmdh_co2_diff_19,
  t0.hmdh_temp_diff AS hmdh_temp_diff_20,
  t0.hmdh_hum_diff AS hmdh_hum_diff_21,
  t0.hmdh_bperdido AS hmdh_bperdido_22,
  t0.prom_bactual AS prom_bactual_23,
  t0.rbh_mejor AS rbh_mejor_24,
  t0.rbh_peor AS rbh_peor_25,
  t0.rbh_amplitud AS rbh_amplitud_26,
  t0.hvh_co2_diff AS hvh_co2_diff_27,
  t0.hvh_temp_diff AS hvh_temp_diff_28,
  t0.hvh_hum_diff AS hvh_hum_diff_29,
  t0.hvh_horas_bpotencial AS hvh_horas_bpotencial_30,
  t0.hvh_horas_bpotencial_promedio_semanal AS hvh_horas_bpotencial_promedio_semanal_31,
  t0.hvh_bpotencial_eur AS hvh_bpotencial_eur_32,
  t0.hvh_bpotencial_promedio_semanal_eur AS hvh_bpotencial_promedio_semanal_eur_33,
  t0.oficina_id AS oficina_id_34
FROM
  ai_analisis_temporal t0
WHERE
  t0.oficina_id = ?
  AND t0.date = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date AS date_2, t0.created AS created_3, t0.mdh_fecha AS mdh_fecha_4, t0.mdh_fecha_explicativa AS mdh_fecha_explicativa_5, t0.mdh_co2 AS mdh_co2_6, t0.mdh_temp AS mdh_temp_7, t0.mdh_hum AS mdh_hum_8, t0.mdh_indice_b AS mdh_indice_b_9, t0.es_confiable_ibc AS es_confiable_ibc_10, t0.es_confiable_psd AS es_confiable_psd_11, t0.pdh_fecha AS pdh_fecha_12, t0.pdh_fecha_explicativa AS pdh_fecha_explicativa_13, t0.pdh_co2 AS pdh_co2_14, t0.pdh_temp AS pdh_temp_15, t0.pdh_hum AS pdh_hum_16, t0.pdh_indice_b AS pdh_indice_b_17, t0.hmdh_co2 AS hmdh_co2_18, t0.hmdh_co2_diff AS hmdh_co2_diff_19, t0.hmdh_temp_diff AS hmdh_temp_diff_20, t0.hmdh_hum_diff AS hmdh_hum_diff_21, t0.hmdh_bperdido AS hmdh_bperdido_22, t0.prom_bactual AS prom_bactual_23, t0.rbh_mejor AS rbh_mejor_24, t0.rbh_peor AS rbh_peor_25, t0.rbh_amplitud AS rbh_amplitud_26, t0.hvh_co2_diff AS hvh_co2_diff_27, t0.hvh_temp_diff AS hvh_temp_diff_28, t0.hvh_hum_diff AS hvh_hum_diff_29, t0.hvh_horas_bpotencial AS hvh_horas_bpotencial_30, t0.hvh_horas_bpotencial_promedio_semanal AS hvh_horas_bpotencial_promedio_semanal_31, t0.hvh_bpotencial_eur AS hvh_bpotencial_eur_32, t0.hvh_bpotencial_promedio_semanal_eur AS hvh_bpotencial_promedio_semanal_eur_33, t0.oficina_id AS oficina_id_34 FROM ai_analisis_temporal t0 WHERE t0.oficina_id = '0add8c1c-2235-4944-9e3e-02a9044dd6d3' AND t0.date = '2026-07-15' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Event\AiPersistEvent->persistPayload (line 127)
5	App\Event\AiPersistEvent->__construct (line 40)
6	App\Controller\ApiLogController->aiReceive (line 663)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.10 ms
(0.88%)

INSERT INTO ai_analisis_temporal_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "en"
  "App\Entity\AI\AiAnalisisTemporal"
  "mdhFechaExplicativa"
  1041
  "Miércoles, Prom. 640"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_analisis_temporal_translation (
  locale, object_class, field, foreign_key,
  content
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO ai_analisis_temporal_translation (locale, object_class, field, foreign_key, content) VALUES ('en', 'App\\Entity\\AI\\AiAnalisisTemporal', 'mdhFechaExplicativa', 1041, 'Miércoles, Prom. 640');

#	File/Call
1	Doctrine\DBAL\Connection->insert (line 814)
2	Gedmo\Translatable\Mapping\Event\Adapter\ORM->insertTranslationRecord (line 204)
3	Gedmo\Translatable\TranslatableListener->postPersist (line 486)
4	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
5	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
6	Doctrine\ORM\UnitOfWork->executeInserts (line 1080)
7	Doctrine\ORM\UnitOfWork->commit (line 403)
8	Doctrine\ORM\EntityManager->flush (line 268)
9	App\Event\AiPersistEvent->persistPayload (line 194)
10	App\Event\AiPersistEvent->__construct (line 40)
11	App\Controller\ApiLogController->aiReceive (line 663)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

1.05 ms
(0.84%)

SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.object_class AS object_class_2, a0_.field AS field_3, a0_.foreign_key AS foreign_key_4, a0_.content AS content_5 FROM ai_analisis_temporal_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1

Parameters:

[
  "en"
  "mdhFechaExplicativa"
  "1041"
  "App\Entity\AI\AiAnalisisTemporal"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.locale AS locale_1,
  a0_.object_class AS object_class_2,
  a0_.field AS field_3,
  a0_.foreign_key AS foreign_key_4,
  a0_.content AS content_5
FROM
  ai_analisis_temporal_translation a0_
WHERE
  a0_.locale = ?
  AND a0_.field = ?
  AND a0_.foreign_key = ?
  AND a0_.object_class = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.object_class AS object_class_2, a0_.field AS field_3, a0_.foreign_key AS foreign_key_4, a0_.content AS content_5 FROM ai_analisis_temporal_translation a0_ WHERE a0_.locale = 'en' AND a0_.field = 'mdhFechaExplicativa' AND a0_.foreign_key = '1041' AND a0_.object_class = 'App\\Entity\\AI\\AiAnalisisTemporal' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Gedmo\Translatable\Mapping\Event\Adapter\ORM->findTranslation (line 166)
7	Gedmo\Translatable\TranslatableListener->handleTranslatableObjectUpdate (line 699)
8	Gedmo\Translatable\TranslatableListener->onFlush (line 440)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
10	Doctrine\ORM\UnitOfWork->dispatchOnFlushEvent (line 3153)
11	Doctrine\ORM\UnitOfWork->commit (line 379)
12	Doctrine\ORM\EntityManager->flush (line 268)
13	App\Event\AiPersistEvent->persistPayload (line 200)
14	App\Event\AiPersistEvent->__construct (line 40)
15	App\Controller\ApiLogController->aiReceive (line 663)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.05 ms
(0.84%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.created AS created_3, t0.ieyp_beneficio_pot_diario AS ieyp_beneficio_pot_diario_4, t0.ieyp_beneficio_pot_semanal AS ieyp_beneficio_pot_semanal_5, t0.ieyp_beneficio_pot_mensual AS ieyp_beneficio_pot_mensual_6, t0.ieyp_beneficio_pot_anual AS ieyp_beneficio_pot_anual_7, t0.es_confiable_bp_diario AS es_confiable_bp_diario_8, t0.es_confiable_bp_semanal AS es_confiable_bp_semanal_9, t0.es_confiable_bp_mensual AS es_confiable_bp_mensual_10, t0.es_confiable_bp_anual AS es_confiable_bp_anual_11, t0.ieyp_beneficio_horas_diarias AS ieyp_beneficio_horas_diarias_12, t0.ieyp_dias_lab_mes AS ieyp_dias_lab_mes_13, t0.ieyp_dias_lab_year AS ieyp_dias_lab_year_14, t0.ieyp_metodologia AS ieyp_metodologia_15, t0.ieyp_ocupacion_oficina AS ieyp_ocupacion_oficina_16, t0.es_confiable_calidad AS es_confiable_calidad_17, t0.cycd_co2 AS cycd_co2_18, t0.cycd_temp AS cycd_temp_19, t0.cycd_hum AS cycd_hum_20, t0.cycd_general AS cycd_general_21, t0.cycd_global AS cycd_global_22, t0.cycd_registros_analizados AS cycd_registros_analizados_23, t0.cycd_periodo_analizado AS cycd_periodo_analizado_24, t0.cycd_explicacion AS cycd_explicacion_25, t0.oficina_id AS oficina_id_26 FROM ai_recomendaciones t0 WHERE t0.oficina_id = ? AND t0.date = ? LIMIT 1

Parameters:

[
  "0add8c1c-2235-4944-9e3e-02a9044dd6d3"
  "2026-07-15"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.created AS created_3,
  t0.ieyp_beneficio_pot_diario AS ieyp_beneficio_pot_diario_4,
  t0.ieyp_beneficio_pot_semanal AS ieyp_beneficio_pot_semanal_5,
  t0.ieyp_beneficio_pot_mensual AS ieyp_beneficio_pot_mensual_6,
  t0.ieyp_beneficio_pot_anual AS ieyp_beneficio_pot_anual_7,
  t0.es_confiable_bp_diario AS es_confiable_bp_diario_8,
  t0.es_confiable_bp_semanal AS es_confiable_bp_semanal_9,
  t0.es_confiable_bp_mensual AS es_confiable_bp_mensual_10,
  t0.es_confiable_bp_anual AS es_confiable_bp_anual_11,
  t0.ieyp_beneficio_horas_diarias AS ieyp_beneficio_horas_diarias_12,
  t0.ieyp_dias_lab_mes AS ieyp_dias_lab_mes_13,
  t0.ieyp_dias_lab_year AS ieyp_dias_lab_year_14,
  t0.ieyp_metodologia AS ieyp_metodologia_15,
  t0.ieyp_ocupacion_oficina AS ieyp_ocupacion_oficina_16,
  t0.es_confiable_calidad AS es_confiable_calidad_17,
  t0.cycd_co2 AS cycd_co2_18,
  t0.cycd_temp AS cycd_temp_19,
  t0.cycd_hum AS cycd_hum_20,
  t0.cycd_general AS cycd_general_21,
  t0.cycd_global AS cycd_global_22,
  t0.cycd_registros_analizados AS cycd_registros_analizados_23,
  t0.cycd_periodo_analizado AS cycd_periodo_analizado_24,
  t0.cycd_explicacion AS cycd_explicacion_25,
  t0.oficina_id AS oficina_id_26
FROM
  ai_recomendaciones t0
WHERE
  t0.oficina_id = ?
  AND t0.date = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date AS date_2, t0.created AS created_3, t0.ieyp_beneficio_pot_diario AS ieyp_beneficio_pot_diario_4, t0.ieyp_beneficio_pot_semanal AS ieyp_beneficio_pot_semanal_5, t0.ieyp_beneficio_pot_mensual AS ieyp_beneficio_pot_mensual_6, t0.ieyp_beneficio_pot_anual AS ieyp_beneficio_pot_anual_7, t0.es_confiable_bp_diario AS es_confiable_bp_diario_8, t0.es_confiable_bp_semanal AS es_confiable_bp_semanal_9, t0.es_confiable_bp_mensual AS es_confiable_bp_mensual_10, t0.es_confiable_bp_anual AS es_confiable_bp_anual_11, t0.ieyp_beneficio_horas_diarias AS ieyp_beneficio_horas_diarias_12, t0.ieyp_dias_lab_mes AS ieyp_dias_lab_mes_13, t0.ieyp_dias_lab_year AS ieyp_dias_lab_year_14, t0.ieyp_metodologia AS ieyp_metodologia_15, t0.ieyp_ocupacion_oficina AS ieyp_ocupacion_oficina_16, t0.es_confiable_calidad AS es_confiable_calidad_17, t0.cycd_co2 AS cycd_co2_18, t0.cycd_temp AS cycd_temp_19, t0.cycd_hum AS cycd_hum_20, t0.cycd_general AS cycd_general_21, t0.cycd_global AS cycd_global_22, t0.cycd_registros_analizados AS cycd_registros_analizados_23, t0.cycd_periodo_analizado AS cycd_periodo_analizado_24, t0.cycd_explicacion AS cycd_explicacion_25, t0.oficina_id AS oficina_id_26 FROM ai_recomendaciones t0 WHERE t0.oficina_id = '0add8c1c-2235-4944-9e3e-02a9044dd6d3' AND t0.date = '2026-07-15' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Event\AiPersistEvent->persistPayload (line 514)
5	App\Event\AiPersistEvent->__construct (line 40)
6	App\Controller\ApiLogController->aiReceive (line 663)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.97 ms
(0.78%)

SELECT t0.uuid AS uuid_1, t0.nombre AS nombre_2, t0.access_token AS access_token_3, t0.timezone AS timezone_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.cantidad_empleados AS cantidad_empleados_7, t0.sueldo_promedio AS sueldo_promedio_8, t0.hourly_productivity_value AS hourly_productivity_value_9, t0.energy_cost_kwh AS energy_cost_kwh_10, t0.industry_type AS industry_type_11, t0.work_type AS work_type_12, t0.default_space_type AS default_space_type_13, t0.space_area_sqm AS space_area_sqm_14, t0.space_volume_cubic_mtr AS space_volume_cubic_mtr_15, t0.window_area_sqm AS window_area_sqm_16, t0.hvac_type AS hvac_type_17, t0.building_orientation AS building_orientation_18, t0.floor_level AS floor_level_19, t0.working_hours_start AS working_hours_start_20, t0.working_hours_end AS working_hours_end_21, t0.working_days AS working_days_22, t0.heating_efficiency AS heating_efficiency_23, t0.cooling_efficiency AS cooling_efficiency_24, t0.alert_thresholds AS alert_thresholds_25, t0.historical_data_retention_days AS historical_data_retention_days_26, t0.optimization_goals AS optimization_goals_27, t0.country AS country_28, t0.address AS address_29, t0.postal_code AS postal_code_30, t0.city AS city_31, t0.google_place_id AS google_place_id_32, t0.is_configured AS is_configured_33, t0.configured_step AS configured_step_34, t0.configured_at AS configured_at_35, t0.created AS created_36, t0.updated AS updated_37, t0.sensor_logging_interval AS sensor_logging_interval_38, t0.sensor_logging_interval_out_work_time AS sensor_logging_interval_out_work_time_39, t0.report_frequency AS report_frequency_40, t0.user_id AS user_id_41 FROM oficina t0 WHERE t0.uuid = ?

Parameters:

[
  "0add8c1c-2235-4944-9e3e-02a9044dd6d3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.uuid AS uuid_1,
  t0.nombre AS nombre_2,
  t0.access_token AS access_token_3,
  t0.timezone AS timezone_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.cantidad_empleados AS cantidad_empleados_7,
  t0.sueldo_promedio AS sueldo_promedio_8,
  t0.hourly_productivity_value AS hourly_productivity_value_9,
  t0.energy_cost_kwh AS energy_cost_kwh_10,
  t0.industry_type AS industry_type_11,
  t0.work_type AS work_type_12,
  t0.default_space_type AS default_space_type_13,
  t0.space_area_sqm AS space_area_sqm_14,
  t0.space_volume_cubic_mtr AS space_volume_cubic_mtr_15,
  t0.window_area_sqm AS window_area_sqm_16,
  t0.hvac_type AS hvac_type_17,
  t0.building_orientation AS building_orientation_18,
  t0.floor_level AS floor_level_19,
  t0.working_hours_start AS working_hours_start_20,
  t0.working_hours_end AS working_hours_end_21,
  t0.working_days AS working_days_22,
  t0.heating_efficiency AS heating_efficiency_23,
  t0.cooling_efficiency AS cooling_efficiency_24,
  t0.alert_thresholds AS alert_thresholds_25,
  t0.historical_data_retention_days AS historical_data_retention_days_26,
  t0.optimization_goals AS optimization_goals_27,
  t0.country AS country_28,
  t0.address AS address_29,
  t0.postal_code AS postal_code_30,
  t0.city AS city_31,
  t0.google_place_id AS google_place_id_32,
  t0.is_configured AS is_configured_33,
  t0.configured_step AS configured_step_34,
  t0.configured_at AS configured_at_35,
  t0.created AS created_36,
  t0.updated AS updated_37,
  t0.sensor_logging_interval AS sensor_logging_interval_38,
  t0.sensor_logging_interval_out_work_time AS sensor_logging_interval_out_work_time_39,
  t0.report_frequency AS report_frequency_40,
  t0.user_id AS user_id_41
FROM
  oficina t0
WHERE
  t0.uuid = ?

SELECT t0.uuid AS uuid_1, t0.nombre AS nombre_2, t0.access_token AS access_token_3, t0.timezone AS timezone_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.cantidad_empleados AS cantidad_empleados_7, t0.sueldo_promedio AS sueldo_promedio_8, t0.hourly_productivity_value AS hourly_productivity_value_9, t0.energy_cost_kwh AS energy_cost_kwh_10, t0.industry_type AS industry_type_11, t0.work_type AS work_type_12, t0.default_space_type AS default_space_type_13, t0.space_area_sqm AS space_area_sqm_14, t0.space_volume_cubic_mtr AS space_volume_cubic_mtr_15, t0.window_area_sqm AS window_area_sqm_16, t0.hvac_type AS hvac_type_17, t0.building_orientation AS building_orientation_18, t0.floor_level AS floor_level_19, t0.working_hours_start AS working_hours_start_20, t0.working_hours_end AS working_hours_end_21, t0.working_days AS working_days_22, t0.heating_efficiency AS heating_efficiency_23, t0.cooling_efficiency AS cooling_efficiency_24, t0.alert_thresholds AS alert_thresholds_25, t0.historical_data_retention_days AS historical_data_retention_days_26, t0.optimization_goals AS optimization_goals_27, t0.country AS country_28, t0.address AS address_29, t0.postal_code AS postal_code_30, t0.city AS city_31, t0.google_place_id AS google_place_id_32, t0.is_configured AS is_configured_33, t0.configured_step AS configured_step_34, t0.configured_at AS configured_at_35, t0.created AS created_36, t0.updated AS updated_37, t0.sensor_logging_interval AS sensor_logging_interval_38, t0.sensor_logging_interval_out_work_time AS sensor_logging_interval_out_work_time_39, t0.report_frequency AS report_frequency_40, t0.user_id AS user_id_41 FROM oficina t0 WHERE t0.uuid = '0add8c1c-2235-4944-9e3e-02a9044dd6d3';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\ApiLogController->aiReceive (line 632)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.85 ms
(0.68%)

SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.object_class AS object_class_2, a0_.field AS field_3, a0_.foreign_key AS foreign_key_4, a0_.content AS content_5 FROM ai_recomendaciones_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1

Parameters:

[
  "en"
  "ieypMetodologia"
  "1024"
  "App\Entity\AI\AiRecomendaciones"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.locale AS locale_1,
  a0_.object_class AS object_class_2,
  a0_.field AS field_3,
  a0_.foreign_key AS foreign_key_4,
  a0_.content AS content_5
FROM
  ai_recomendaciones_translation a0_
WHERE
  a0_.locale = ?
  AND a0_.field = ?
  AND a0_.foreign_key = ?
  AND a0_.object_class = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.object_class AS object_class_2, a0_.field AS field_3, a0_.foreign_key AS foreign_key_4, a0_.content AS content_5 FROM ai_recomendaciones_translation a0_ WHERE a0_.locale = 'en' AND a0_.field = 'ieypMetodologia' AND a0_.foreign_key = '1024' AND a0_.object_class = 'App\\Entity\\AI\\AiRecomendaciones' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Gedmo\Translatable\Mapping\Event\Adapter\ORM->findTranslation (line 166)
7	Gedmo\Translatable\TranslatableListener->handleTranslatableObjectUpdate (line 699)
8	Gedmo\Translatable\TranslatableListener->onFlush (line 440)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
10	Doctrine\ORM\UnitOfWork->dispatchOnFlushEvent (line 3153)
11	Doctrine\ORM\UnitOfWork->commit (line 379)
12	Doctrine\ORM\EntityManager->flush (line 268)
13	App\Event\AiPersistEvent->persistPayload (line 576)
14	App\Event\AiPersistEvent->__construct (line 40)
15	App\Controller\ApiLogController->aiReceive (line 663)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.68 ms
(0.55%)

SELECT t0.uuid AS uuid_1, t0.nordic_api AS nordic_api_2, t0.nordic_id AS nordic_id_3, t0.nordic_api_date AS nordic_api_date_4, t0.tipo AS tipo_5, t0.clase AS clase_6, t0.created AS created_7, t0.updated AS updated_8, t0.firm_version AS firm_version_9, t0.mac AS mac_10, t0.enabled AS enabled_11, t0.first_connected_at AS first_connected_at_12, t0.oficina_id AS oficina_id_13, t14.id AS id_15, t14.status AS status_16, t14.track_id AS track_id_17, t14.status_updated AS status_updated_18, t14.shipped_at AS shipped_at_19, t14.received_at AS received_at_20, t14.connected_at AS connected_at_21, t14.ship_company AS ship_company_22, t14.ship_last_message AS ship_last_message_23, t14.invoice_base AS invoice_base_24, t14.invoice_iva AS invoice_iva_25, t14.user_id AS user_id_26, t14.sensor_uuid AS sensor_uuid_27 FROM sensor t0 LEFT JOIN sensor_shipping t14 ON t14.sensor_uuid = t0.uuid WHERE t0.oficina_id IN (?)

Parameters:

[
  "0add8c1c-2235-4944-9e3e-02a9044dd6d3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.uuid AS uuid_1,
  t0.nordic_api AS nordic_api_2,
  t0.nordic_id AS nordic_id_3,
  t0.nordic_api_date AS nordic_api_date_4,
  t0.tipo AS tipo_5,
  t0.clase AS clase_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t0.firm_version AS firm_version_9,
  t0.mac AS mac_10,
  t0.enabled AS enabled_11,
  t0.first_connected_at AS first_connected_at_12,
  t0.oficina_id AS oficina_id_13,
  t14.id AS id_15,
  t14.status AS status_16,
  t14.track_id AS track_id_17,
  t14.status_updated AS status_updated_18,
  t14.shipped_at AS shipped_at_19,
  t14.received_at AS received_at_20,
  t14.connected_at AS connected_at_21,
  t14.ship_company AS ship_company_22,
  t14.ship_last_message AS ship_last_message_23,
  t14.invoice_base AS invoice_base_24,
  t14.invoice_iva AS invoice_iva_25,
  t14.user_id AS user_id_26,
  t14.sensor_uuid AS sensor_uuid_27
FROM
  sensor t0
  LEFT JOIN sensor_shipping t14 ON t14.sensor_uuid = t0.uuid
WHERE
  t0.oficina_id IN (?)

SELECT t0.uuid AS uuid_1, t0.nordic_api AS nordic_api_2, t0.nordic_id AS nordic_id_3, t0.nordic_api_date AS nordic_api_date_4, t0.tipo AS tipo_5, t0.clase AS clase_6, t0.created AS created_7, t0.updated AS updated_8, t0.firm_version AS firm_version_9, t0.mac AS mac_10, t0.enabled AS enabled_11, t0.first_connected_at AS first_connected_at_12, t0.oficina_id AS oficina_id_13, t14.id AS id_15, t14.status AS status_16, t14.track_id AS track_id_17, t14.status_updated AS status_updated_18, t14.shipped_at AS shipped_at_19, t14.received_at AS received_at_20, t14.connected_at AS connected_at_21, t14.ship_company AS ship_company_22, t14.ship_last_message AS ship_last_message_23, t14.invoice_base AS invoice_base_24, t14.invoice_iva AS invoice_iva_25, t14.user_id AS user_id_26, t14.sensor_uuid AS sensor_uuid_27 FROM sensor t0 LEFT JOIN sensor_shipping t14 ON t14.sensor_uuid = t0.uuid WHERE t0.oficina_id IN ('0add8c1c-2235-4944-9e3e-02a9044dd6d3');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 63)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
8	Doctrine\ORM\EntityManager->find (line 366)
9	Doctrine\ORM\EntityRepository->find (line 86)
10	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
11	App\Controller\ApiLogController->aiReceive (line 632)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.68 ms
(0.54%)

UPDATE ai_analisis_temporal_translation SET content = ? WHERE id = ?

Parameters:

[
  "Report avg. 640 ppm on Wednesday."
  1293
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  ai_analisis_temporal_translation
SET
  content = ?
WHERE
  id = ?

UPDATE ai_analisis_temporal_translation SET content = 'Report avg. 640 ppm on Wednesday.' WHERE id = 1293;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 200)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.61 ms
(0.49%)

INSERT INTO ai_predicciones (date, created, cvh_pred7co2_tendencia_general, cvh_pred7co2_impacto, cvh_pred7co2_recomendacion, cvh_pred7_temp_tendencia_general, cvh_pred7_temp_impacto, cvh_pred7_temp_recomendacion, cvh_pred7_hum_tendencia_general, cvh_pred7_hum_impacto, cvh_pred7_hum_recomendacion, cvh_pred30co2_tendencia_general, cvh_pred30co2_patron_largo_plazo, cvh_pred30co2_impacto, cvh_pred30co2_recomendacion, cvh_pred30_temp_tendencia_general, cvh_pred30_temp_patron_largo_plazo, cvh_pred30_temp_impacto, cvh_pred30_temp_recomendacion, cvh_pred30_hum_tendencia_general, cvh_pred30_hum_patron_largo_plazo, cvh_pred30_hum_impacto, cvh_pred30_hum_recomendacion, es_confiable, oficina_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "2026-07-15"
  "2026-07-15 06:02:30"
  "-1.5%"
  "El análisis revela variabilidad moderada en CO (+1.4%), con 5 jornadas presentando valores ligeramente elevados. Este comportamiento indica fluctuaciones perceptibles asociadas a la ocupación."
  "Establecer un patrón de ventilación más regular (+1.4% var.), especialmente en Lunes (20-21h) (Prom. 654), Martes Mañana (9-11h) (Prom. 660). Esto ayudará a homogeneizar los niveles semanales."
  "+0.6%"
  "Últimas jornadas muestran variabilidad térmicas de +0.6%, con fluctuaciones perceptibles en 5 días. El entorno se mantiene relativamente estable, aunque una calibración del sistema mejoraría la uniformidad térmica."
  "Ajustar puntualmente la climatización en los días con variaciones (+0.6%). El equilibrio térmico el resto de la semana es excelente."
  "-5.7%"
  "Variaciones en humedad de -0.3% detectadas en 5 jornadas. La media permanece en el rango saludable ASHRAE (40-60%), sin riesgos inmediatos."
  "Niveles de humedad equilibrados (-0.3% de variación). Mantener la rutina actual de ventilación sin necesidad de ajustes adicionales."
  "+7.4%"
  "incremento gradual sostenido"
  "El análisis mensual refleja una evolución al alza de +7.4% en los valores de CO₂. Si esta progresión se mantiene, comenzarán a aparecer síntomas de concentración disminuida y fatiga mental."
  "Con una tendencia al alza de +7.4%, conviene reforzar la capacidad de renovación del aire. Considerar la instalación de extractores adicionales o una revisión técnica del sistema actual de ventilación."
  "-1.0%"
  "estabilidad con fluctuaciones menores"
  "Variación térmica mensual mínima de -1.0%. La estabilidad térmica permite mantener un consumo energético predecible y facilita la planificación de recursos."
  "El comportamiento térmico del espacio es estable y predecible. No se requieren ajustes significativos en el sistema de climatización durante este periodo."
  "+0.8%"
  "estabilidad con fluctuaciones menores"
  "Las condiciones de humedad han permanecido equilibradas durante el mes con variación de +0.8%. Este comportamiento estable dentro del rango ASHRAE favorece el bienestar y la conservación del espacio."
  "Los niveles de humedad están bien gestionados con los sistemas actuales. Continuar con la ventilación habitual y realizar revisiones periódicas para mantener este equilibrio."
  1
  "0add8c1c-2235-4944-9e3e-02a9044dd6d3"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_predicciones (
  date, created, cvh_pred7co2_tendencia_general,
  cvh_pred7co2_impacto, cvh_pred7co2_recomendacion,
  cvh_pred7_temp_tendencia_general,
  cvh_pred7_temp_impacto, cvh_pred7_temp_recomendacion,
  cvh_pred7_hum_tendencia_general,
  cvh_pred7_hum_impacto, cvh_pred7_hum_recomendacion,
  cvh_pred30co2_tendencia_general,
  cvh_pred30co2_patron_largo_plazo,
  cvh_pred30co2_impacto, cvh_pred30co2_recomendacion,
  cvh_pred30_temp_tendencia_general,
  cvh_pred30_temp_patron_largo_plazo,
  cvh_pred30_temp_impacto, cvh_pred30_temp_recomendacion,
  cvh_pred30_hum_tendencia_general,
  cvh_pred30_hum_patron_largo_plazo,
  cvh_pred30_hum_impacto, cvh_pred30_hum_recomendacion,
  es_confiable, oficina_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO ai_predicciones (date, created, cvh_pred7co2_tendencia_general, cvh_pred7co2_impacto, cvh_pred7co2_recomendacion, cvh_pred7_temp_tendencia_general, cvh_pred7_temp_impacto, cvh_pred7_temp_recomendacion, cvh_pred7_hum_tendencia_general, cvh_pred7_hum_impacto, cvh_pred7_hum_recomendacion, cvh_pred30co2_tendencia_general, cvh_pred30co2_patron_largo_plazo, cvh_pred30co2_impacto, cvh_pred30co2_recomendacion, cvh_pred30_temp_tendencia_general, cvh_pred30_temp_patron_largo_plazo, cvh_pred30_temp_impacto, cvh_pred30_temp_recomendacion, cvh_pred30_hum_tendencia_general, cvh_pred30_hum_patron_largo_plazo, cvh_pred30_hum_impacto, cvh_pred30_hum_recomendacion, es_confiable, oficina_id) VALUES ('2026-07-15', '2026-07-15 06:02:30', '-1.5%', 'El análisis revela variabilidad moderada en CO (+1.4%), con 5 jornadas presentando valores ligeramente elevados. Este comportamiento indica fluctuaciones perceptibles asociadas a la ocupación.', 'Establecer un patrón de ventilación más regular (+1.4% var.), especialmente en Lunes (20-21h) (Prom. 654), Martes Mañana (9-11h) (Prom. 660). Esto ayudará a homogeneizar los niveles semanales.', '+0.6%', 'Últimas jornadas muestran variabilidad térmicas de +0.6%, con fluctuaciones perceptibles en 5 días. El entorno se mantiene relativamente estable, aunque una calibración del sistema mejoraría la uniformidad térmica.', 'Ajustar puntualmente la climatización en los días con variaciones (+0.6%). El equilibrio térmico el resto de la semana es excelente.', '-5.7%', 'Variaciones en humedad de -0.3% detectadas en 5 jornadas. La media permanece en el rango saludable ASHRAE (40-60%), sin riesgos inmediatos.', 'Niveles de humedad equilibrados (-0.3% de variación). Mantener la rutina actual de ventilación sin necesidad de ajustes adicionales.', '+7.4%', 'incremento gradual sostenido', 'El análisis mensual refleja una evolución al alza de +7.4% en los valores de CO₂. Si esta progresión se mantiene, comenzarán a aparecer síntomas de concentración disminuida y fatiga mental.', 'Con una tendencia al alza de +7.4%, conviene reforzar la capacidad de renovación del aire. Considerar la instalación de extractores adicionales o una revisión técnica del sistema actual de ventilación.', '-1.0%', 'estabilidad con fluctuaciones menores', 'Variación térmica mensual mínima de -1.0%. La estabilidad térmica permite mantener un consumo energético predecible y facilita la planificación de recursos.', 'El comportamiento térmico del espacio es estable y predecible. No se requieren ajustes significativos en el sistema de climatización durante este periodo.', '+0.8%', 'estabilidad con fluctuaciones menores', 'Las condiciones de humedad han permanecido equilibradas durante el mes con variación de +0.8%. Este comportamiento estable dentro del rango ASHRAE favorece el bienestar y la conservación del espacio.', 'Los niveles de humedad están bien gestionados con los sistemas actuales. Continuar con la ventilación habitual y realizar revisiones periódicas para mantener este equilibrio.', 1, '0add8c1c-2235-4944-9e3e-02a9044dd6d3');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 482)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.46 ms
(0.37%)

UPDATE ai_analisis_temporal SET hvh_co2_diff = ?, hvh_temp_diff = ?, hvh_hum_diff = ?, hvh_horas_bpotencial = ?, hvh_horas_bpotencial_promedio_semanal = ?, hvh_bpotencial_eur = ?, hvh_bpotencial_promedio_semanal_eur = ? WHERE id = ?

Parameters:

[
  -36.0
  -4.0
  -35.9
  "horas_beneficio_potencial_hoy"
  0
  "beneficio_potencial_hoy_eur"
  28
  1041
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  ai_analisis_temporal
SET
  hvh_co2_diff = ?,
  hvh_temp_diff = ?,
  hvh_hum_diff = ?,
  hvh_horas_bpotencial = ?,
  hvh_horas_bpotencial_promedio_semanal = ?,
  hvh_bpotencial_eur = ?,
  hvh_bpotencial_promedio_semanal_eur = ?
WHERE
  id = ?

UPDATE ai_analisis_temporal SET hvh_co2_diff = -36, hvh_temp_diff = -4, hvh_hum_diff = -35.9, hvh_horas_bpotencial = 'horas_beneficio_potencial_hoy', hvh_horas_bpotencial_promedio_semanal = 0, hvh_bpotencial_eur = 'beneficio_potencial_hoy_eur', hvh_bpotencial_promedio_semanal_eur = 28 WHERE id = 1041;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 258)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.46 ms
(0.37%)

INSERT INTO ai_recomendaciones (date, created, ieyp_beneficio_pot_diario, ieyp_beneficio_pot_semanal, ieyp_beneficio_pot_mensual, ieyp_beneficio_pot_anual, es_confiable_bp_diario, es_confiable_bp_semanal, es_confiable_bp_mensual, es_confiable_bp_anual, ieyp_beneficio_horas_diarias, ieyp_dias_lab_mes, ieyp_dias_lab_year, ieyp_metodologia, ieyp_ocupacion_oficina, es_confiable_calidad, cycd_co2, cycd_temp, cycd_hum, cycd_general, cycd_global, cycd_registros_analizados, cycd_periodo_analizado, cycd_explicacion, oficina_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "2026-07-15"
  "2026-07-15 06:02:30"
  4
  28
  120
  1441
  1
  1
  1
  1
  0.42
  22
  234
  null
  1
  1
  86.2
  95.0
  85.6
  95.0
  88.7
  4186
  "4186 registros (últimos 173 días)"
  null
  "0add8c1c-2235-4944-9e3e-02a9044dd6d3"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_recomendaciones (
  date, created, ieyp_beneficio_pot_diario,
  ieyp_beneficio_pot_semanal, ieyp_beneficio_pot_mensual,
  ieyp_beneficio_pot_anual, es_confiable_bp_diario,
  es_confiable_bp_semanal, es_confiable_bp_mensual,
  es_confiable_bp_anual, ieyp_beneficio_horas_diarias,
  ieyp_dias_lab_mes, ieyp_dias_lab_year,
  ieyp_metodologia, ieyp_ocupacion_oficina,
  es_confiable_calidad, cycd_co2,
  cycd_temp, cycd_hum, cycd_general,
  cycd_global, cycd_registros_analizados,
  cycd_periodo_analizado, cycd_explicacion,
  oficina_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO ai_recomendaciones (date, created, ieyp_beneficio_pot_diario, ieyp_beneficio_pot_semanal, ieyp_beneficio_pot_mensual, ieyp_beneficio_pot_anual, es_confiable_bp_diario, es_confiable_bp_semanal, es_confiable_bp_mensual, es_confiable_bp_anual, ieyp_beneficio_horas_diarias, ieyp_dias_lab_mes, ieyp_dias_lab_year, ieyp_metodologia, ieyp_ocupacion_oficina, es_confiable_calidad, cycd_co2, cycd_temp, cycd_hum, cycd_general, cycd_global, cycd_registros_analizados, cycd_periodo_analizado, cycd_explicacion, oficina_id) VALUES ('2026-07-15', '2026-07-15 06:02:30', 4, 28, 120, 1441, 1, 1, 1, 1, 0.42, 22, 234, NULL, 1, 1, 86.2, 95, 85.6, 95, 88.7, 4186, '4186 registros (últimos 173 días)', NULL, '0add8c1c-2235-4944-9e3e-02a9044dd6d3');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 570)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.45 ms
(0.36%)

INSERT INTO ai_report_index (date, sensor_info, oficina_id, analisis_temp_id, predicciones_id, recomendaciones_id) VALUES (?, ?, ?, ?, ?, ?)

Parameters:

[
  "2026-07-15"
  "{"estado":"FUERA_DE_HORARIO","ultima_lectura":"14\/07\/26 23:00","nivel_alerta":"NORMAL"}"
  "0add8c1c-2235-4944-9e3e-02a9044dd6d3"
  1041
  1025
  1024
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_report_index (
  date, sensor_info, oficina_id, analisis_temp_id,
  predicciones_id, recomendaciones_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO ai_report_index (date, sensor_info, oficina_id, analisis_temp_id, predicciones_id, recomendaciones_id) VALUES ('2026-07-15', '{\"estado\":\"FUERA_DE_HORARIO\",\"ultima_lectura\":\"14\\/07\\/26 23:00\",\"nivel_alerta\":\"NORMAL\"}', '0add8c1c-2235-4944-9e3e-02a9044dd6d3', 1041, 1025, 1024);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 711)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.44 ms
(0.36%)

INSERT INTO ai_analisis_temporal (date, created, mdh_fecha, mdh_fecha_explicativa, mdh_co2, mdh_temp, mdh_hum, mdh_indice_b, es_confiable_ibc, es_confiable_psd, pdh_fecha, pdh_fecha_explicativa, pdh_co2, pdh_temp, pdh_hum, pdh_indice_b, hmdh_co2, hmdh_co2_diff, hmdh_temp_diff, hmdh_hum_diff, hmdh_bperdido, prom_bactual, rbh_mejor, rbh_peor, rbh_amplitud, hvh_co2_diff, hvh_temp_diff, hvh_hum_diff, hvh_horas_bpotencial, hvh_horas_bpotencial_promedio_semanal, hvh_bpotencial_eur, hvh_bpotencial_promedio_semanal_eur, oficina_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "2026-07-15"
  "2026-07-15 06:02:30"
  "2026-07-08"
  "Miércoles, Prom. 640"
  640
  23.3
  33
  99
  1
  1
  "2026-07-14"
  "Martes, Prom. 660"
  660
  23.6
  35
  100
  66
  10.2
  0.5
  14
  0.6
  98.2
  99
  100
  -1
  null
  null
  null
  null
  null
  null
  null
  "0add8c1c-2235-4944-9e3e-02a9044dd6d3"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ai_analisis_temporal (
  date, created, mdh_fecha, mdh_fecha_explicativa,
  mdh_co2, mdh_temp, mdh_hum, mdh_indice_b,
  es_confiable_ibc, es_confiable_psd,
  pdh_fecha, pdh_fecha_explicativa,
  pdh_co2, pdh_temp, pdh_hum, pdh_indice_b,
  hmdh_co2, hmdh_co2_diff, hmdh_temp_diff,
  hmdh_hum_diff, hmdh_bperdido, prom_bactual,
  rbh_mejor, rbh_peor, rbh_amplitud,
  hvh_co2_diff, hvh_temp_diff, hvh_hum_diff,
  hvh_horas_bpotencial, hvh_horas_bpotencial_promedio_semanal,
  hvh_bpotencial_eur, hvh_bpotencial_promedio_semanal_eur,
  oficina_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO ai_analisis_temporal (date, created, mdh_fecha, mdh_fecha_explicativa, mdh_co2, mdh_temp, mdh_hum, mdh_indice_b, es_confiable_ibc, es_confiable_psd, pdh_fecha, pdh_fecha_explicativa, pdh_co2, pdh_temp, pdh_hum, pdh_indice_b, hmdh_co2, hmdh_co2_diff, hmdh_temp_diff, hmdh_hum_diff, hmdh_bperdido, prom_bactual, rbh_mejor, rbh_peor, rbh_amplitud, hvh_co2_diff, hvh_temp_diff, hvh_hum_diff, hvh_horas_bpotencial, hvh_horas_bpotencial_promedio_semanal, hvh_bpotencial_eur, hvh_bpotencial_promedio_semanal_eur, oficina_id) VALUES ('2026-07-15', '2026-07-15 06:02:30', '2026-07-08', 'Miércoles, Prom. 640', 640, 23.3, 33, 99, 1, 1, '2026-07-14', 'Martes, Prom. 660', 660, 23.6, 35, 100, 66, 10.2, 0.5, 14, 0.6, 98.2, 99, 100, -1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0add8c1c-2235-4944-9e3e-02a9044dd6d3');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 194)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.42 ms
(0.34%)

SELECT t0.date AS date_1, t0.sensor_info AS sensor_info_2, t0.oficina_id AS oficina_id_3, t0.analisis_temp_id AS analisis_temp_id_4, t0.predicciones_id AS predicciones_id_5, t0.recomendaciones_id AS recomendaciones_id_6 FROM ai_report_index t0 WHERE t0.oficina_id = ? AND t0.date = ? LIMIT 1

Parameters:

[
  "0add8c1c-2235-4944-9e3e-02a9044dd6d3"
  "2026-07-15"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.date AS date_1,
  t0.sensor_info AS sensor_info_2,
  t0.oficina_id AS oficina_id_3,
  t0.analisis_temp_id AS analisis_temp_id_4,
  t0.predicciones_id AS predicciones_id_5,
  t0.recomendaciones_id AS recomendaciones_id_6
FROM
  ai_report_index t0
WHERE
  t0.oficina_id = ?
  AND t0.date = ?
LIMIT
  1

SELECT t0.date AS date_1, t0.sensor_info AS sensor_info_2, t0.oficina_id AS oficina_id_3, t0.analisis_temp_id AS analisis_temp_id_4, t0.predicciones_id AS predicciones_id_5, t0.recomendaciones_id AS recomendaciones_id_6 FROM ai_report_index t0 WHERE t0.oficina_id = '0add8c1c-2235-4944-9e3e-02a9044dd6d3' AND t0.date = '2026-07-15' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Event\AiPersistEvent->persistPayload (line 690)
5	App\Event\AiPersistEvent->__construct (line 40)
6	App\Controller\ApiLogController->aiReceive (line 663)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.42 ms
(0.33%)

UPDATE ai_predicciones SET cvh_pred30_temp_patron_largo_plazo = ? WHERE id = ?

Parameters:

[
  "Confirm stability with minor fluctuations."
  1025
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  ai_predicciones
SET
  cvh_pred30_temp_patron_largo_plazo = ?
WHERE
  id = ?

UPDATE ai_predicciones SET cvh_pred30_temp_patron_largo_plazo = 'Confirm stability with minor fluctuations.' WHERE id = 1025;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Event\AiPersistEvent->persistPayload (line 504)
7	App\Event\AiPersistEvent->__construct (line 40)
8	App\Controller\ApiLogController->aiReceive (line 663)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\AI\Prediccion30	20
App\Entity\AI\Translation\AiPrediccionesTranslation	14
App\Entity\AI\PrediccionPico	9
App\Entity\AI\Translation\RecomendacionTranslation	9
App\Entity\AI\PatronesSemanales	5
App\Entity\AI\Prediccion7	5
App\Entity\AI\DeviceValues	4
App\Entity\AI\Translation\AlertasTranslation	4
App\Entity\AI\Recomendacion	3
App\Entity\AI\Translation\AiAnalisisTemporalTranslation	2
App\Entity\AI\Translation\AiRecomendacionesTranslation	2
App\Entity\AI\Alertas	2
App\Entity\Oficina	1
App\Entity\User	1
App\Entity\Sensor	1
App\Entity\ApiAiReceive	1
App\Entity\AI\AiAnalisisTemporal	1
App\Entity\AI\AiPredicciones	1
App\Entity\AI\AiRecomendaciones	1
App\Entity\AI\AiReportIndex	1

Entities Mapping

Class	Mapping errors
App\Entity\Oficina	No errors.
App\Entity\User	The field App\Entity\User#sensorShippings is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SensorShipping#user does not contain the required 'inversedBy: "sensorShippings"' attribute.
App\Entity\Sensor	No errors.
App\Entity\SensorShipping	No errors.
App\Entity\ApiLog	The association App\Entity\ApiLog#user refers to the inverse side field App\Entity\User#sensorLogs which does not exist.
App\Entity\ApiAiReceive	No errors.
App\Entity\AI\AiAnalisisTemporal	The mappings App\Entity\AI\AiAnalisisTemporal#deviceValues and App\Entity\AI\DeviceValues#aiAnalisis are inconsistent with each other.
App\Entity\AI\PatronesSemanales	No errors.
App\Entity\AI\DeviceValues	The association App\Entity\AI\DeviceValues#aiAnalisis refers to the inverse side field App\Entity\AI\AiAnalisisTemporal#analisisDevices which does not exist.
App\Entity\AI\Translation\AiAnalisisTemporalTranslation	No errors.
App\Entity\AI\AiPredicciones	The mappings App\Entity\AI\AiPredicciones#predicciones7 and App\Entity\AI\Prediccion7#aiPrediccion are inconsistent with each other. The mappings App\Entity\AI\AiPredicciones#predicciones30 and App\Entity\AI\Prediccion30#aiPrediccion are inconsistent with each other. The mappings App\Entity\AI\AiPredicciones#prediccionesPico and App\Entity\AI\PrediccionPico#aiPrediccion are inconsistent with each other.
App\Entity\AI\Prediccion7	The association App\Entity\AI\Prediccion7#aiPrediccion refers to the inverse side field App\Entity\AI\AiPredicciones#prediccion7 which does not exist.
App\Entity\AI\Prediccion30	The association App\Entity\AI\Prediccion30#aiPrediccion refers to the inverse side field App\Entity\AI\AiPredicciones#prediccion30 which does not exist.
App\Entity\AI\PrediccionPico	The association App\Entity\AI\PrediccionPico#aiPrediccion refers to the inverse side field App\Entity\AI\AiPredicciones#prediccionPico which does not exist.
App\Entity\AI\Translation\AiPrediccionesTranslation	No errors.
App\Entity\AI\AiRecomendaciones	No errors.
App\Entity\AI\Recomendacion	No errors.
App\Entity\AI\Alertas	No errors.
App\Entity\AI\Translation\AiRecomendacionesTranslation	No errors.
App\Entity\AI\Translation\RecomendacionTranslation	No errors.
App\Entity\AI\Translation\AlertasTranslation	No errors.
App\Entity\AI\AiReportIndex	No errors.

Symfony Profiler

POST https://dev.sensoria.cat/api/ai/receive

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping