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

Response
200 OK
IP
141.227.188.207
Profiled on
Token
b296b2

Query Metrics

172 Database Queries
37 Different statements
102.28 ms Query time
8 Invalid entities
86 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.94 ms 
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: 
[
  "064c9a47-2611-4fe4-8662-1534be6a3fa3"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.67 ms 
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: 
[
  "064c9a47-2611-4fe4-8662-1534be6a3fa3"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 1.76 ms 
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: 
[
  "064c9a47-2611-4fe4-8662-1534be6a3fa3"
  "2026-07-15"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.14 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.40 ms 
INSERT INTO api_ai_receive (payload, created, processed_date, processed, oficina_id) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "{"oficina_id": "064c9a47-2611-4fe4-8662-1534be6a3fa3", "timestamp": "15/07/26 06:01", "sensor_status": {"estado": "FUERA_DE_HORARIO", "ultima_lectura": "15/07/26 07:31", "tiempo_sin_datos_horas": -1.5, "nivel_alerta": "NORMAL"}, "analisis_temporal": {"indices_bienestar_comparativos": {"es_confiable": true, "mejor_dia_historico": {"fecha": "08/07/26", "fecha_explicativa": {"es": "Mi\u00e9rcoles, Prom. 592", "en": "Report avg. 592 ppm on Wednesday."}, "co2_ppm": 592, "temperatura_celsius": 20.9, "humedad_porcentaje": 60, "indice_bienestar": 100}, "peor_dia_historico": {"fecha": "10/07/26", "fecha_explicativa": {"es": "Viernes, Prom. 633", "en": "Report avg. 633 ppm on Friday."}, "co2_ppm": 633, "temperatura_celsius": 21.9, "humedad_porcentaje": 62, "indice_bienestar": 100}, "hoy_vs_mejor_dia_historico": {"co2_diferencia_ppm": -173, "co2_diferencia_porcentaje": -29.2, "temperatura_diferencia_celsius": 8.8, "humedad_diferencia_puntos": -9, "bienestar_perdido_puntos": 7.6}, "promedio_bienestar_actual": 92.4, "rango_bienestar_historico": {"mejor": 100, "peor": 100, "amplitud": 0}}, "patrones_semanales_detallados": {"es_confiable": true, "dias": [{"dia": "1", "co2_actual_ppm": 622, "co2_desviacion_ppm": -378, "temperatura_actual_celsius": 21.7, "temperatura_desviacion_celsius": -2.8, "humedad_actual_porcentaje": 59, "humedad_desviacion_puntos": 6.5, "horas_beneficio_potencial": 1.3, "beneficio_potencial_eur": 5}, {"dia": "2", "co2_actual_ppm": 599, "co2_desviacion_ppm": -401, "temperatura_actual_celsius": 22.0, "temperatura_desviacion_celsius": -2.5, "humedad_actual_porcentaje": 58, "humedad_desviacion_puntos": 5.5, "horas_beneficio_potencial": 1.2, "beneficio_potencial_eur": 5}, {"dia": "3", "co2_actual_ppm": 586, "co2_desviacion_ppm": -414, "temperatura_actual_celsius": 21.6, "temperatura_desviacion_celsius": -2.9, "humedad_actual_porcentaje": 61, "humedad_desviacion_puntos": 8.5, "horas_beneficio_potencial": 1.5, "beneficio_potencial_eur": 5}, {"dia": "4", "co2_actual_ppm": 620, "co2_desviacion_ppm": -380, "temperatura_actual_celsius": 21.2, "temperatura_desviacion_celsius": -3.3, "humedad_actual_porcentaje": 62, "humedad_desviacion_puntos": 9.5, "horas_beneficio_potencial": 1.6, "beneficio_potencial_eur": 5}, {"dia": "5", "co2_actual_ppm": 627, "co2_desviacion_ppm": -373, "temperatura_actual_celsius": 21.0, "temperatura_desviacion_celsius": -3.5, "humedad_actual_porcentaje": 56, "humedad_desviacion_puntos": 3.5, "horas_beneficio_potencial": 1.2, "beneficio_potencial_eur": 5}], "hoy_vs_historico": {"co2_diferencia_porcentaje": -39.1, "temperatura_diferencia_porcentaje": -12.0, "humedad_diferencia_porcentaje": 15.3, "horas_beneficio_potencial_hoy": 0, "horas_beneficio_potencial_promedio_semanal": 0, "beneficio_potencial_hoy_eur": 16, "beneficio_potencial_promedio_semanal_eur": 96}}}, "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": "8:00", "segunda_peor": "9:00", "tercera_peor": "10:00", "proximo_pico_predicho": {"hora": "8:00", "valor_esperado_ppm": 623, "tiempo_restante_horas": 2, "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": 33.4, "tiempo_restante_horas": 11, "clasificacion": "critica"}, "_validation": {"is_valid": true, "completeness_score": 1.0, "missing_fields": [], "reason": null}}, "humedad_picos_historicos": {"peor_hora": "8:00", "segunda_peor": "9:00", "tercera_peor": "10:00", "proximo_pico_predicho": {"hora": "8:00", "valor_esperado_porcentaje": 68, "tiempo_restante_horas": 2, "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": 616, "unidad": "ppm", "hr_start": 18, "hr_end": 19, "es_critico": false}, "temperature": {"valor": 21.8, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 61, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": false}}}, {"dia": "2", "es_confiable": true, "valores": {"co2": {"valor": 605, "unidad": "ppm", "hr_start": 12, "hr_end": 13, "es_critico": false}, "temperature": {"valor": 21.9, "unidad": "\u00b0C", "hr_start": 16, "hr_end": 17, "es_critico": false}, "humidity": {"valor": 62, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": false}}}, {"dia": "3", "es_confiable": true, "valores": {"co2": {"valor": 592, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": false}, "temperature": {"valor": 21.5, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}, "humidity": {"valor": 61, "unidad": "%", "hr_start": 14, "hr_end": 15, "es_critico": false}}}, {"dia": "4", "es_confiable": true, "valores": {"co2": {"valor": 627, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": false}, "temperature": {"valor": 21.5, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}, "humidity": {"valor": 60, "unidad": "%", "hr_start": 16, "hr_end": 17, "es_critico": false}}}, {"dia": "5", "es_confiable": true, "valores": {"co2": {"valor": 633, "unidad": "ppm", "hr_start": 14, "hr_end": 15, "es_critico": false}, "temperature": {"valor": 20.9, "unidad": "\u00b0C", "hr_start": 14, "hr_end": 15, "es_critico": false}, "humidity": {"valor": 60, "unidad": "%", "hr_start": 16, "hr_end": 17, "es_critico": false}}}], "resumen_tendencias": {"co2": {"tendencia_general": "+1.1%", "impacto_negocio": {"es": "El an\u00e1lisis revela variabilidad moderada en CO (+1.9%), 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.9%) with 5 days showing slightly elevated readings. Step up systematic ventilation to even out readings."}, "recomendacion_planificacion": {"es": "Establecer un patr\u00f3n de ventilaci\u00f3n m\u00e1s regular (+1.9% var.), especialmente en Lunes Tarde tard\u00eda (18-19h) (Prom. 616), Martes Mediod\u00eda temprano (12-13h) (Prom. 605). Esto ayudar\u00e1 a homogeneizar los niveles semanales.", "en": "Implement a more regular ventilation pattern (+1.9% var.), especially Monday late afternoon (18-19h) avg. 616 ppm and Tuesday early noon (12-13h) avg. 605 ppm. This will even out weekly readings."}}, "temperature": {"tendencia_general": "-2.5%", "impacto_negocio": {"es": "\u00daltimas jornadas muestran variabilidad t\u00e9rmicas de +0.4%, 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": "Show recent thermal fluctuations of +0.4% across 5 days. Environment remains fairly stable; fine-tune system calibration to improve thermal uniformity."}, "recomendacion_planificacion": {"es": "Ajustar puntualmente la climatizaci\u00f3n en los d\u00edas con variaciones (+0.4%). El equilibrio t\u00e9rmico el resto de la semana es excelente.", "en": "Adjust HVAC settings on days with +0.4% variation. Thermal balance is excellent for the rest of the week."}}, "humidity": {"tendencia_general": "-1.9%", "impacto_negocio": {"es": "Los niveles de humedad han aumentado 33.6% durante la semana. Por encima del rango \u00f3ptimo ASHRAE (40-60%), puede aparecer sensaci\u00f3n de bochorno ambiental.", "en": "Signal humidity increase of 33.6% this week. Levels exceed ASHRAE\u2019s optimal 40-60% range, risking stuffy conditions."}, "recomendacion_planificacion": {"es": "Activar deshumidificaci\u00f3n prioritaria ante el alza del 33.6%. Aumentar la renovaci\u00f3n de aire para reducir la carga de humedad acumulada.", "en": "Activate priority dehumidification amid 33.6% rise. Boost air exchange to lower accumulated moisture load."}}}}, "predicciones_30_dias": {"semanas_disponibles": 4, "dias_criticos": {"semana_1": [{"dia_mes": 3, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 616, "unidad": "ppm", "hr_start": 18, "hr_end": 19, "es_critico": false}, "temperature": {"valor": 21.8, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 61, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": false}}}, {"dia_mes": 4, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 605, "unidad": "ppm", "hr_start": 12, "hr_end": 13, "es_critico": false}, "temperature": {"valor": 21.9, "unidad": "\u00b0C", "hr_start": 16, "hr_end": 17, "es_critico": false}, "humidity": {"valor": 62, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": false}}}, {"dia_mes": 5, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 592, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": false}, "temperature": {"valor": 21.5, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}, "humidity": {"valor": 61, "unidad": "%", "hr_start": 14, "hr_end": 15, "es_critico": false}}}, {"dia_mes": 6, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 627, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": false}, "temperature": {"valor": 21.5, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}, "humidity": {"valor": 60, "unidad": "%", "hr_start": 16, "hr_end": 17, "es_critico": false}}}, {"dia_mes": 7, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 633, "unidad": "ppm", "hr_start": 14, "hr_end": 15, "es_critico": false}, "temperature": {"valor": 20.9, "unidad": "\u00b0C", "hr_start": 14, "hr_end": 15, "es_critico": false}, "humidity": {"valor": 60, "unidad": "%", "hr_start": 16, "hr_end": 17, "es_critico": false}}}], "semana_2": [{"dia_mes": 10, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 665, "unidad": "ppm", "hr_start": 18, "hr_end": 19, "es_critico": false}, "temperature": {"valor": 20.5, "unidad": "\u00b0C", "hr_start": 8, "hr_end": 10, "es_critico": false}, "humidity": {"valor": 63, "unidad": "%", "hr_start": 17, "hr_end": 18, "es_critico": false}}}, {"dia_mes": 11, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 734, "unidad": "ppm", "hr_start": 13, "hr_end": 14, "es_critico": false}, "temperature": {"valor": 23.5, "unidad": "\u00b0C", "hr_start": 15, "hr_end": 16, "es_critico": false}, "humidity": {"valor": 52, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": false}}}, {"dia_mes": 12, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 596, "unidad": "ppm", "hr_start": 18, "hr_end": 19, "es_critico": false}, "temperature": {"valor": 21.4, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}}}, {"dia_mes": 13, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 659, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": false}, "temperature": {"valor": 21.3, "unidad": "\u00b0C", "hr_start": 11, "hr_end": 12, "es_critico": false}, "humidity": {"valor": 68, "unidad": "%", "hr_start": 17, "hr_end": 18, "es_critico": true}}}, {"dia_mes": 14, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 721, "unidad": "ppm", "hr_start": 14, "hr_end": 15, "es_critico": false}, "temperature": {"valor": 22.6, "unidad": "\u00b0C", "hr_start": 15, "hr_end": 16, "es_critico": false}, "humidity": {"valor": 70, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": true}}}], "semana_3": [{"dia_mes": 17, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 651, "unidad": "ppm", "hr_start": 18, "hr_end": 19, "es_critico": false}, "temperature": {"valor": 23.7, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 74, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": true}}}, {"dia_mes": 18, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 560, "unidad": "ppm", "hr_start": 10, "hr_end": 11, "es_critico": false}, "temperature": {"valor": 20.5, "unidad": "\u00b0C", "hr_start": 16, "hr_end": 17, "es_critico": false}, "humidity": {"valor": 75, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": true}}}, {"dia_mes": 19, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 526, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": false}, "temperature": {"valor": 21.5, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}, "humidity": {"valor": 62, "unidad": "%", "hr_start": 16, "hr_end": 17, "es_critico": false}}}, {"dia_mes": 20, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 556, "unidad": "ppm", "hr_start": 17, "hr_end": 18, "es_critico": false}, "temperature": {"valor": 22.8, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}}}, {"dia_mes": 21, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 585, "unidad": "ppm", "hr_start": 14, "hr_end": 15, "es_critico": false}, "temperature": {"valor": 22.3, "unidad": "\u00b0C", "hr_start": 14, "hr_end": 15, "es_critico": false}, "humidity": {"valor": 56, "unidad": "%", "hr_start": 16, "hr_end": 17, "es_critico": false}}}], "semana_4": [{"dia_mes": 24, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 734, "unidad": "ppm", "hr_start": 18, "hr_end": 19, "es_critico": false}, "temperature": {"valor": 22.9, "unidad": "\u00b0C", "hr_start": 8, "hr_end": 10, "es_critico": false}}}, {"dia_mes": 25, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 629, "unidad": "ppm", "hr_start": 12, "hr_end": 13, "es_critico": false}, "temperature": {"valor": 22.8, "unidad": "\u00b0C", "hr_start": 17, "hr_end": 18, "es_critico": false}, "humidity": {"valor": 53, "unidad": "%", "hr_start": 18, "hr_end": 19, "es_critico": false}}}, {"dia_mes": 26, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 690, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": false}, "temperature": {"valor": 21.3, "unidad": "\u00b0C", "hr_start": 14, "hr_end": 15, "es_critico": false}, "humidity": {"valor": 70, "unidad": "%", "hr_start": 12, "hr_end": 13, "es_critico": true}}}, {"dia_mes": 27, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 726, "unidad": "ppm", "hr_start": 17, "hr_end": 18, "es_critico": false}, "temperature": {"valor": 21.8, "unidad": "\u00b0C", "hr_start": 11, "hr_end": 12, "es_critico": false}, "humidity": {"valor": 50, "unidad": "%", "hr_start": 16, "hr_end": 17, "es_critico": false}}}, {"dia_mes": 28, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 752, "unidad": "ppm", "hr_start": 15, "hr_end": 16, "es_critico": false}, "temperature": {"valor": 22.7, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}, "humidity": {"valor": 72, "unidad": "%", "hr_start": 16, "hr_end": 17, "es_critico": true}}}]}, "resumen_tendencias": {"co2": {"tendencia_general": "-1.4%", "patron_largo_plazo": {"es": "estabilidad con fluctuaciones menores", "en": "Confirm stability with minor fluctuations throughout the period."}, "impacto_negocio": {"es": "Variaci\u00f3n mensual contenida en -1.4%. La estabilidad observada facilita una planificaci\u00f3n de acciones correctivas sin necesidad de intervenciones urgentes.", "en": "Register contained monthly variation at -1.4%. Stability supports corrective planning without urgent interventions."}, "recomendacion_inversion": {"es": "El sistema de ventilaci\u00f3n actual se muestra adecuado para el nivel de ocupaci\u00f3n presente. Mantener el mantenimiento anual preventivo ayudar\u00e1 a preservar esta eficiencia a largo plazo.", "en": "Validate current ventilation system as suitable for present occupancy. Uphold annual preventive maintenance to sustain long-term efficiency."}}, "temperature": {"tendencia_general": "+1.8%", "patron_largo_plazo": {"es": "estabilidad con fluctuaciones menores", "en": "Report minimal monthly thermal variation of +1.8%. Stable thermal conditions enable predictable energy use and resource planning."}, "impacto_negocio": {"es": "Variaci\u00f3n t\u00e9rmica mensual m\u00ednima de +1.8%. La estabilidad t\u00e9rmica permite mantener un consumo energ\u00e9tico predecible y facilita la planificaci\u00f3n de recursos.", "en": "Affirm stable, predictable thermal behaviour. No major HVAC adjustments needed during this period."}, "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": "Note slight increase accompanied by variations."}}, "humidity": {"tendencia_general": "+3.8%", "patron_largo_plazo": {"es": "ligero incremento con variaciones", "en": "Confirm humidity conditions balanced over the month with +3.8% variation. Stability within ASHRAE range supports comfort and space preservation."}, "impacto_negocio": {"es": "Las condiciones de humedad han permanecido equilibradas durante el mes con variaci\u00f3n de +3.8%. Este comportamiento estable dentro del rango ASHRAE favorece el bienestar y la conservaci\u00f3n del espacio.", "en": "Verify humidity levels well managed by current systems. Continue usual ventilation and schedule periodic checks to maintain balance."}, "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": 1, "accion": {"es": "Prevenci\u00f3n pico CO2", "en": "CO2 Peak Prevention"}, "descripcion": {"es": "Observamos una ligera alza de CO\u2082 sin impacto significativo esperado. Proyecci\u00f3n: 623 ppm en 2h (+170 ppm). Se mantiene por debajo del umbral moderado de 1000 ppm. Sugerimos ventilaci\u00f3n preventiva antes del horario habitual de trabajo.", "en": "We observe a slight rise in CO\u2082 with no significant impact expected. Projection: 623 ppm in 2 hours (+170 ppm). Levels remain below the moderate threshold of 1000 ppm. We recommend preventive ventilation before the usual working hours."}, "momento_ejecucion": {"es": "Ventilar ma\u00f1ana temprano, entre las 07:00h y las 08:00h. De repetirse, incorporar a la rutina diaria.", "en": "Ventilate early tomorrow morning, between 7:00 AM and 8:00 AM. If repeated, incorporate into the daily routine."}, "parametro_objetivo": "co2", "valor_critico": 623}, {"prioridad": 2, "accion": {"es": "Prevenci\u00f3n pico Temperature", "en": "Peak Temperature Prevention"}, "descripcion": {"es": "Prevemos incremento t\u00e9rmico que causar\u00e1 incomodidad generalizada. Proyecci\u00f3n: 33.4\u00b0C en 11h (actual: 26.3\u00b0C, +7.1\u00b0C). Superar\u00e1 el rango \u00f3ptimo de 21\u201324\u00b0C. Recomendamos ajustar la climatizaci\u00f3n de forma preventiva ma\u00f1ana por la ma\u00f1ana.", "en": "We anticipate a thermal increase that will cause widespread discomfort. Projection: 33.4\u00b0C at 11 am (current: 26.3\u00b0C, +7.1\u00b0C). This will exceed the optimal range of 21\u201324\u00b0C. We recommend adjusting the air conditioning preventively tomorrow morning."}, "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": 33.4}, {"prioridad": 3, "accion": {"es": "Prevenci\u00f3n pico Humidity", "en": "Peak Humidity Prevention"}, "descripcion": {"es": "Detectamos incremento de humedad que causar\u00e1 sensaci\u00f3n de pesadez. Proyecci\u00f3n: 68% en 2h (+-9%). Supera el l\u00edmite superior de 65%. Recomendamos activar control de humedad antes del mediod\u00eda.", "en": "We have detected an increase in humidity that will cause a feeling of heaviness. Projection: 68% in 2 hours (\u00b19%). This exceeds the upper limit of 65%. We recommend activating humidity control before midday."}, "momento_ejecucion": {"es": "Actuar en horario matinal, hacia las 07:00h. Observar evoluci\u00f3n durante los pr\u00f3ximos 3-5 d\u00edas.", "en": "Take action in the morning, around 7:00 AM. Monitor progress over the next 3-5 days."}, "parametro_objetivo": "humidity", "valor_critico": 68}], "alertas_temporales_criticas": [{"tipo": "alerta_critica", "mensaje": {"es": "Sensaci\u00f3n de calor e incomodidad generalizada (Temperatura: 33.4\u00b0C, umbral: 27\u00b0C). Ajustar climatizaci\u00f3n en las pr\u00f3ximas 12 horas.", "en": "Tackle heat discomfort. Temp. 33.4\u00b0C exceeds 27\u00b0C threshold. Adjust HVAC within 12 hours."}, "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). Plan permanent tweaks if issue persists."}, "valor_critico": 33.4}]}, "impacto_economico_y_productividad": {"impacto_economico_solo_laborables": {"metodologia": {"es": "An\u00e1lisis hist\u00f3rico ponderado cient\u00edfico (22 d\u00edas laborables/mes)", "en": "Emphasize higher confidence yields more reliable predictions. CO\u2082 varies with occupancy; temperature and humidity remain more stable."}, "ocupacion_oficina": 1, "beneficios_diarios": {"es_confiable": true, "beneficio_potencial_diario_eur": 16, "horas_beneficio_potencial_diarias": 2.28}, "beneficios_semanales": {"es_confiable": true, "beneficio_potencial_semanal_eur": 96}, "beneficios_mensuales": {"es_confiable": true, "beneficio_potencial_mensual_eur": 414, "dias_laborales_mes": 22}, "beneficios_anuales": {"es_confiable": true, "beneficio_potencial_anual_eur": 4972, "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": 82.7, "confianza_temperatura_porcentaje": 85.0, "confianza_humedad_porcentaje": 85.3, "calidad_general_porcentaje": 95.0, "confianza_global_porcentaje": 84.2, "registros_analizados": 3670, "periodo_analizado": "3670 registros (\u00faltimos 292 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": 78, "bienestar_30": 87, "tendencia_7d": "negativa", "tendencia_30d": "negativa"}}"
  "2026-07-15 06:01:33"
  "2026-07-15"
  1
  "064c9a47-2611-4fe4-8662-1534be6a3fa3"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 4.19 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7 1.36 ms 
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: 
[
  "064c9a47-2611-4fe4-8662-1534be6a3fa3"
  "2026-07-15"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.13 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.44 ms 
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:01:33"
  "2026-07-08"
  "Miércoles, Prom. 592"
  592
  20.9
  60
  100
  1
  1
  "2026-07-10"
  "Viernes, Prom. 633"
  633
  21.9
  62
  100
  -173
  -29.2
  8.8
  -9
  7.6
  92.4
  100
  100
  0
  null
  null
  null
  null
  null
  null
  null
  "064c9a47-2611-4fe4-8662-1534be6a3fa3"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.25 ms 
INSERT INTO ai_analisis_temporal_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiAnalisisTemporal"
  "mdhFechaExplicativa"
  1039
  "Miércoles, Prom. 592"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.24 ms 
INSERT INTO ai_analisis_temporal_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiAnalisisTemporal"
  "pdhFechaExplicativa"
  1039
  "Viernes, Prom. 633"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 3.58 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.39 ms 
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"
  "1039"
  "App\Entity\AI\AiAnalisisTemporal"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.36 ms 
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"
  "pdhFechaExplicativa"
  "1039"
  "App\Entity\AI\AiAnalisisTemporal"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.13 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.33 ms 
UPDATE ai_analisis_temporal_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Report avg. 592 ppm on Wednesday."
  1289
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.27 ms 
UPDATE ai_analisis_temporal_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Report avg. 633 ppm on Friday."
  1290
]
View formatted query    View runnable query    Explain query    View query backtrace
18 3.80 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.13 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.30 ms 
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: 
[
  "1"
  622
  -378
  21.7
  -2.8
  59
  6.5
  1.3
  5
  1039
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.33 ms 
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: 
[
  "2"
  599
  -401
  22.0
  -2.5
  58
  5.5
  1.2
  5
  1039
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.27 ms 
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: 
[
  "3"
  586
  -414
  21.6
  -2.9
  61
  8.5
  1.5
  5
  1039
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.25 ms 
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: 
[
  "4"
  620
  -380
  21.2
  -3.3
  62
  9.5
  1.6
  5
  1039
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.40 ms 
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: 
[
  "5"
  627
  -373
  21.0
  -3.5
  56
  3.5
  1.2
  5
  1039
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.27 ms 
INSERT INTO ai_device_values (tipo, name, valor, ai_analisis_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "teams"
  "bienestar_7"
  78
  1039
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.35 ms 
INSERT INTO ai_device_values (tipo, name, valor, ai_analisis_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "teams"
  "bienestar_30"
  87
  1039
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.24 ms 
INSERT INTO ai_device_values (tipo, name, valor, ai_analisis_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "teams"
  "tendencia_7d"
  -1
  1039
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.24 ms 
INSERT INTO ai_device_values (tipo, name, valor, ai_analisis_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "teams"
  "tendencia_30d"
  -1
  1039
]
View formatted query    View runnable query    Explain query    View query backtrace
29 1.11 ms 
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: 
[
  -39.1
  -12.0
  15.3
  "horas_beneficio_potencial_hoy"
  0
  "beneficio_potencial_hoy_eur"
  96
  1039
]
View formatted query    View runnable query    Explain query    View query backtrace
30 3.24 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
31 1.48 ms 
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: 
[
  "064c9a47-2611-4fe4-8662-1534be6a3fa3"
  "2026-07-15"
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.17 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.53 ms 
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:01:33"
  "+1.1%"
  "El análisis revela variabilidad moderada en CO (+1.9%), 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.9% var.), especialmente en Lunes Tarde tardía (18-19h) (Prom. 616), Martes Mediodía temprano (12-13h) (Prom. 605). Esto ayudará a homogeneizar los niveles semanales."
  "-2.5%"
  "Últimas jornadas muestran variabilidad térmicas de +0.4%, 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.4%). El equilibrio térmico el resto de la semana es excelente."
  "-1.9%"
  "Los niveles de humedad han aumentado 33.6% durante la semana. Por encima del rango óptimo ASHRAE (40-60%), puede aparecer sensación de bochorno ambiental."
  "Activar deshumidificación prioritaria ante el alza del 33.6%. Aumentar la renovación de aire para reducir la carga de humedad acumulada."
  "-1.4%"
  "estabilidad con fluctuaciones menores"
  "Variación mensual contenida en -1.4%. La estabilidad observada facilita una planificación de acciones correctivas sin necesidad de intervenciones urgentes."
  "El sistema de ventilación actual se muestra adecuado para el nivel de ocupación presente. Mantener el mantenimiento anual preventivo ayudará a preservar esta eficiencia a largo plazo."
  "+1.8%"
  "estabilidad con fluctuaciones menores"
  "Variación térmica mensual mínima de +1.8%. 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."
  "+3.8%"
  "ligero incremento con variaciones"
  "Las condiciones de humedad han permanecido equilibradas durante el mes con variación de +3.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
  "064c9a47-2611-4fe4-8662-1534be6a3fa3"
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.33 ms 
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: 
[
  1
  18
  19
  616
  0
  9
  11
  21.8
  0
  18
  19
  61
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.26 ms 
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: 
[
  2
  12
  13
  605
  0
  16
  17
  21.9
  0
  18
  19
  62
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.41 ms 
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: 
[
  3
  16
  17
  592
  0
  12
  13
  21.5
  0
  14
  15
  61
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.27 ms 
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: 
[
  4
  16
  17
  627
  0
  12
  13
  21.5
  0
  16
  17
  60
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.36 ms 
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: 
[
  5
  14
  15
  633
  0
  14
  15
  20.9
  0
  16
  17
  60
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.35 ms 
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: 
[
  3
  1
  18
  19
  616
  0
  9
  11
  21.8
  0
  18
  19
  61
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.39 ms 
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: 
[
  4
  1
  12
  13
  605
  0
  16
  17
  21.9
  0
  18
  19
  62
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.31 ms 
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: 
[
  5
  1
  16
  17
  592
  0
  12
  13
  21.5
  0
  14
  15
  61
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.31 ms 
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: 
[
  6
  1
  16
  17
  627
  0
  12
  13
  21.5
  0
  16
  17
  60
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.37 ms 
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: 
[
  7
  1
  14
  15
  633
  0
  14
  15
  20.9
  0
  16
  17
  60
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.30 ms 
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: 
[
  10
  2
  18
  19
  665
  0
  8
  10
  20.5
  0
  17
  18
  63
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.27 ms 
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: 
[
  11
  2
  13
  14
  734
  0
  15
  16
  23.5
  0
  18
  19
  52
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.30 ms 
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: 
[
  12
  2
  18
  19
  596
  0
  12
  13
  21.4
  0
  null
  null
  null
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.32 ms 
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: 
[
  13
  2
  16
  17
  659
  0
  11
  12
  21.3
  0
  17
  18
  68
  1
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.34 ms 
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: 
[
  14
  2
  14
  15
  721
  0
  15
  16
  22.6
  0
  18
  19
  70
  1
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.31 ms 
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: 
[
  17
  3
  18
  19
  651
  0
  9
  11
  23.7
  0
  18
  19
  74
  1
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.30 ms 
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: 
[
  18
  3
  10
  11
  560
  0
  16
  17
  20.5
  0
  18
  19
  75
  1
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.42 ms 
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: 
[
  19
  3
  16
  17
  526
  0
  12
  13
  21.5
  0
  16
  17
  62
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.26 ms 
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: 
[
  20
  3
  17
  18
  556
  0
  12
  13
  22.8
  0
  null
  null
  null
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.41 ms 
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: 
[
  21
  3
  14
  15
  585
  0
  14
  15
  22.3
  0
  16
  17
  56
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.34 ms 
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: 
[
  24
  4
  18
  19
  734
  0
  8
  10
  22.9
  0
  null
  null
  null
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.31 ms 
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: 
[
  25
  4
  12
  13
  629
  0
  17
  18
  22.8
  0
  18
  19
  53
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.35 ms 
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: 
[
  26
  4
  16
  17
  690
  0
  14
  15
  21.3
  0
  12
  13
  70
  1
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.28 ms 
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: 
[
  27
  4
  17
  18
  726
  0
  11
  12
  21.8
  0
  16
  17
  50
  0
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.42 ms 
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: 
[
  28
  4
  15
  16
  752
  0
  12
  13
  22.7
  0
  16
  17
  72
  1
  1
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.37 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "co2"
  1
  8
  623
  "preventiva"
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.25 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "co2"
  2
  9
  null
  null
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.24 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "co2"
  3
  10
  null
  null
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.33 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "temp"
  1
  17
  33.4
  "critica"
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.24 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "temp"
  2
  19
  null
  null
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.28 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "temp"
  3
  17
  null
  null
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.34 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "hum"
  1
  8
  68
  "preventiva"
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.25 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "hum"
  2
  9
  null
  null
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.32 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "hum"
  3
  10
  null
  null
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.37 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7co2Impacto"
  1023
  "El análisis revela variabilidad moderada en CO (+1.9%), 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
69 0.29 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7co2Recomendacion"
  1023
  "Establecer un patrón de ventilación más regular (+1.9% var.), especialmente en Lunes Tarde tardía (18-19h) (Prom. 616), Martes Mediodía temprano (12-13h) (Prom. 605). Esto ayudará a homogeneizar los niveles semanales."
]
View formatted query    View runnable query    Explain query    View query backtrace
70 0.33 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7TempImpacto"
  1023
  "Últimas jornadas muestran variabilidad térmicas de +0.4%, 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."
]
View formatted query    View runnable query    Explain query    View query backtrace
71 0.25 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7TempRecomendacion"
  1023
  "Ajustar puntualmente la climatización en los días con variaciones (+0.4%). El equilibrio térmico el resto de la semana es excelente."
]
View formatted query    View runnable query    Explain query    View query backtrace
72 0.35 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7HumImpacto"
  1023
  "Los niveles de humedad han aumentado 33.6% durante la semana. Por encima del rango óptimo ASHRAE (40-60%), puede aparecer sensación de bochorno ambiental."
]
View formatted query    View runnable query    Explain query    View query backtrace
73 0.34 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7HumRecomendacion"
  1023
  "Activar deshumidificación prioritaria ante el alza del 33.6%. Aumentar la renovación de aire para reducir la carga de humedad acumulada."
]
View formatted query    View runnable query    Explain query    View query backtrace
74 0.24 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30co2PatronLargoPlazo"
  1023
  "estabilidad con fluctuaciones menores"
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.28 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30co2Impacto"
  1023
  "Variación mensual contenida en -1.4%. La estabilidad observada facilita una planificación de acciones correctivas sin necesidad de intervenciones urgentes."
]
View formatted query    View runnable query    Explain query    View query backtrace
76 0.38 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30co2Recomendacion"
  1023
  "El sistema de ventilación actual se muestra adecuado para el nivel de ocupación presente. Mantener el mantenimiento anual preventivo ayudará a preservar esta eficiencia a largo plazo."
]
View formatted query    View runnable query    Explain query    View query backtrace
77 0.25 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30TempImpacto"
  1023
  "Variación térmica mensual mínima de +1.8%. La estabilidad térmica permite mantener un consumo energético predecible y facilita la planificación de recursos."
]
View formatted query    View runnable query    Explain query    View query backtrace
78 0.29 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30TempRecomendacion"
  1023
  "El comportamiento térmico del espacio es estable y predecible. No se requieren ajustes significativos en el sistema de climatización durante este periodo."
]
View formatted query    View runnable query    Explain query    View query backtrace
79 0.37 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30HumPatronLargoPlazo"
  1023
  "ligero incremento con variaciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
80 0.26 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30HumImpacto"
  1023
  "Las condiciones de humedad han permanecido equilibradas durante el mes con variación de +3.8%. Este comportamiento estable dentro del rango ASHRAE favorece el bienestar y la conservación del espacio."
]
View formatted query    View runnable query    Explain query    View query backtrace
81 0.27 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30HumRecomendacion"
  1023
  "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."
]
View formatted query    View runnable query    Explain query    View query backtrace
82 3.75 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
83 0.49 ms 
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"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
84 0.38 ms 
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"
  "cvhPred7co2Recomendacion"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
85 0.33 ms 
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"
  "cvhPred7TempImpacto"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
86 0.34 ms 
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"
  "cvhPred7TempRecomendacion"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
87 0.32 ms 
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"
  "cvhPred7HumImpacto"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
88 0.32 ms 
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"
  "cvhPred7HumRecomendacion"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
89 0.33 ms 
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"
  "cvhPred30co2PatronLargoPlazo"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
90 0.34 ms 
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"
  "cvhPred30co2Impacto"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
91 0.32 ms 
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"
  "cvhPred30co2Recomendacion"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
92 0.35 ms 
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"
  "cvhPred30TempImpacto"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
93 0.34 ms 
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"
  "cvhPred30TempRecomendacion"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
94 0.37 ms 
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"
  "cvhPred30HumPatronLargoPlazo"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
95 0.36 ms 
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"
  "cvhPred30HumImpacto"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
96 0.32 ms 
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"
  "cvhPred30HumRecomendacion"
  "1023"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
97 0.13 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
98 1.16 ms 
UPDATE ai_predicciones SET cvh_pred30_temp_patron_largo_plazo = ? WHERE id = ?
Parameters: 
[
  "Report minimal monthly thermal variation of +1.8%. Stable thermal conditions enable predictable energy use and resource planning."
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
99 0.33 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Highlight moderate CO fluctuations (+1.9%) with 5 days showing slightly elevated readings. Step up systematic ventilation to even out readings."
  8961
]
View formatted query    View runnable query    Explain query    View query backtrace
100 0.27 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Implement a more regular ventilation pattern (+1.9% var.), especially Monday late afternoon (18-19h) avg. 616 ppm and Tuesday early noon (12-13h) avg. 605 ppm. This will even out weekly readings."
  8962
]
View formatted query    View runnable query    Explain query    View query backtrace
101 0.26 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Show recent thermal fluctuations of +0.4% across 5 days. Environment remains fairly stable; fine-tune system calibration to improve thermal uniformity."
  8963
]
View formatted query    View runnable query    Explain query    View query backtrace
102 0.26 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Adjust HVAC settings on days with +0.4% variation. Thermal balance is excellent for the rest of the week."
  8964
]
View formatted query    View runnable query    Explain query    View query backtrace
103 0.44 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Signal humidity increase of 33.6% this week. Levels exceed ASHRAE’s optimal 40-60% range, risking stuffy conditions."
  8965
]
View formatted query    View runnable query    Explain query    View query backtrace
104 0.38 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Activate priority dehumidification amid 33.6% rise. Boost air exchange to lower accumulated moisture load."
  8966
]
View formatted query    View runnable query    Explain query    View query backtrace
105 0.32 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Confirm stability with minor fluctuations throughout the period."
  8967
]
View formatted query    View runnable query    Explain query    View query backtrace
106 0.57 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Register contained monthly variation at -1.4%. Stability supports corrective planning without urgent interventions."
  8968
]
View formatted query    View runnable query    Explain query    View query backtrace
107 0.29 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Validate current ventilation system as suitable for present occupancy. Uphold annual preventive maintenance to sustain long-term efficiency."
  8969
]
View formatted query    View runnable query    Explain query    View query backtrace
108 0.28 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Affirm stable, predictable thermal behaviour. No major HVAC adjustments needed during this period."
  8970
]
View formatted query    View runnable query    Explain query    View query backtrace
109 0.33 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Note slight increase accompanied by variations."
  8971
]
View formatted query    View runnable query    Explain query    View query backtrace
110 0.36 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Confirm humidity conditions balanced over the month with +3.8% variation. Stability within ASHRAE range supports comfort and space preservation."
  8972
]
View formatted query    View runnable query    Explain query    View query backtrace
111 0.27 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Verify humidity levels well managed by current systems. Continue usual ventilation and schedule periodic checks to maintain balance."
  8973
]
View formatted query    View runnable query    Explain query    View query backtrace
112 0.33 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Base analysis on weighted scientific data from 22 working days per month."
  8974
]
View formatted query    View runnable query    Explain query    View query backtrace
113 2.79 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
114 1.32 ms 
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: 
[
  "064c9a47-2611-4fe4-8662-1534be6a3fa3"
  "2026-07-15"
]
View formatted query    View runnable query    Explain query    View query backtrace
115 0.14 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
116 0.40 ms 
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:01:33"
  16
  96
  414
  4972
  1
  1
  1
  1
  2.28
  22
  234
  null
  1
  1
  82.7
  85.0
  85.3
  95.0
  84.2
  3670
  "3670 registros (últimos 292 días)"
  null
  "064c9a47-2611-4fe4-8662-1534be6a3fa3"
]
View formatted query    View runnable query    Explain query    View query backtrace
117 3.02 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
118 0.38 ms 
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"
  "1022"
  "App\Entity\AI\AiRecomendaciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
119 0.34 ms 
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"
  "cycdExplicacion"
  "1022"
  "App\Entity\AI\AiRecomendaciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
120 0.13 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
121 0.30 ms 
INSERT INTO ai_recomendaciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiRecomendaciones"
  "ieypMetodologia"
  1022
  "Emphasize higher confidence yields more reliable predictions. CO₂ varies with occupancy; temperature and humidity remain more stable."
]
View formatted query    View runnable query    Explain query    View query backtrace
122 0.32 ms 
INSERT INTO ai_recomendaciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiRecomendaciones"
  "cycdExplicacion"
  1022
  "Greater confidence = more reliable predictions. CO2 varies with occupancy, temperature/humidity more stable."
]
View formatted query    View runnable query    Explain query    View query backtrace
123 4.15 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
124 0.13 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
125 0.38 ms 
INSERT INTO ai_recomendacion (prio, param, accion, descripcion, momento_ejecucion, valor, ai_rec_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  1
  "co2"
  "Prevención pico CO2"
  "Observamos una ligera alza de CO₂ sin impacto significativo esperado. Proyección: 623 ppm en 2h (+170 ppm). Se mantiene por debajo del umbral moderado de 1000 ppm. Sugerimos ventilación preventiva antes del horario habitual de trabajo."
  "Ventilar mañana temprano, entre las 07:00h y las 08:00h. De repetirse, incorporar a la rutina diaria."
  623
  1022
]
View formatted query    View runnable query    Explain query    View query backtrace
126 0.37 ms 
INSERT INTO ai_recomendacion (prio, param, accion, descripcion, momento_ejecucion, valor, ai_rec_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  2
  "temperature"
  "Prevención pico Temperature"
  "Prevemos incremento térmico que causará incomodidad generalizada. Proyección: 33.4°C en 11h (actual: 26.3°C, +7.1°C). Superará el rango óptimo de 21–24°C. Recomendamos ajustar la climatización de forma preventiva mañana por la mañana."
  "Preparar climatización a media tarde (entre 16:00h–17:00h). Evaluar ajustes permanentes si continúa."
  33.4
  1022
]
View formatted query    View runnable query    Explain query    View query backtrace
127 0.31 ms 
INSERT INTO ai_recomendacion (prio, param, accion, descripcion, momento_ejecucion, valor, ai_rec_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  3
  "humidity"
  "Prevención pico Humidity"
  "Detectamos incremento de humedad que causará sensación de pesadez. Proyección: 68% en 2h (+-9%). Supera el límite superior de 65%. Recomendamos activar control de humedad antes del mediodía."
  "Actuar en horario matinal, hacia las 07:00h. Observar evolución durante los próximos 3-5 días."
  68
  1022
]
View formatted query    View runnable query    Explain query    View query backtrace
128 0.44 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "accion"
  3329
  "Prevención pico CO2"
]
View formatted query    View runnable query    Explain query    View query backtrace
129 0.27 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "descripcion"
  3329
  "Observamos una ligera alza de CO₂ sin impacto significativo esperado. Proyección: 623 ppm en 2h (+170 ppm). Se mantiene por debajo del umbral moderado de 1000 ppm. Sugerimos ventilación preventiva antes del horario habitual de trabajo."
]
View formatted query    View runnable query    Explain query    View query backtrace
130 0.24 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "momentoEjecucion"
  3329
  "Ventilar mañana temprano, entre las 07:00h y las 08:00h. De repetirse, incorporar a la rutina diaria."
]
View formatted query    View runnable query    Explain query    View query backtrace
131 0.33 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "accion"
  3330
  "Prevención pico Temperature"
]
View formatted query    View runnable query    Explain query    View query backtrace
132 0.40 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "descripcion"
  3330
  "Prevemos incremento térmico que causará incomodidad generalizada. Proyección: 33.4°C en 11h (actual: 26.3°C, +7.1°C). Superará el rango óptimo de 21–24°C. Recomendamos ajustar la climatización de forma preventiva mañana por la mañana."
]
View formatted query    View runnable query    Explain query    View query backtrace
133 0.23 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "momentoEjecucion"
  3330
  "Preparar climatización a media tarde (entre 16:00h–17:00h). Evaluar ajustes permanentes si continúa."
]
View formatted query    View runnable query    Explain query    View query backtrace
134 0.27 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "accion"
  3331
  "Prevención pico Humidity"
]
View formatted query    View runnable query    Explain query    View query backtrace
135 0.35 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "descripcion"
  3331
  "Detectamos incremento de humedad que causará sensación de pesadez. Proyección: 68% en 2h (+-9%). Supera el límite superior de 65%. Recomendamos activar control de humedad antes del mediodía."
]
View formatted query    View runnable query    Explain query    View query backtrace
136 0.23 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "momentoEjecucion"
  3331
  "Actuar en horario matinal, hacia las 07:00h. Observar evolución durante los próximos 3-5 días."
]
View formatted query    View runnable query    Explain query    View query backtrace
137 2.60 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
138 0.34 ms 
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"
  "3329"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
139 0.33 ms 
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"
  "descripcion"
  "3329"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
140 0.37 ms 
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"
  "momentoEjecucion"
  "3329"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
141 0.38 ms 
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"
  "3330"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
142 0.33 ms 
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"
  "descripcion"
  "3330"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
143 0.32 ms 
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"
  "momentoEjecucion"
  "3330"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
144 0.33 ms 
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"
  "3331"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
145 0.37 ms 
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"
  "descripcion"
  "3331"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
146 0.33 ms 
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"
  "momentoEjecucion"
  "3331"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
147 0.13 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
148 0.29 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "CO2 Peak Prevention"
  6688
]
View formatted query    View runnable query    Explain query    View query backtrace
149 0.27 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "We observe a slight rise in CO₂ with no significant impact expected. Projection: 623 ppm in 2 hours (+170 ppm). Levels remain below the moderate threshold of 1000 ppm. We recommend preventive ventilation before the usual working hours."
  6689
]
View formatted query    View runnable query    Explain query    View query backtrace
150 0.40 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Ventilate early tomorrow morning, between 7:00 AM and 8:00 AM. If repeated, incorporate into the daily routine."
  6690
]
View formatted query    View runnable query    Explain query    View query backtrace
151 0.27 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Peak Temperature Prevention"
  6691
]
View formatted query    View runnable query    Explain query    View query backtrace
152 0.26 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "We anticipate a thermal increase that will cause widespread discomfort. Projection: 33.4°C at 11 am (current: 26.3°C, +7.1°C). This will exceed the optimal range of 21–24°C. We recommend adjusting the air conditioning preventively tomorrow morning."
  6692
]
View formatted query    View runnable query    Explain query    View query backtrace
153 0.27 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Prepare air conditioning in the mid-afternoon (between 4:00 PM and 5:00 PM). Assess permanent adjustments if it continues."
  6693
]
View formatted query    View runnable query    Explain query    View query backtrace
154 0.26 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Peak Humidity Prevention"
  6694
]
View formatted query    View runnable query    Explain query    View query backtrace
155 0.41 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "We have detected an increase in humidity that will cause a feeling of heaviness. Projection: 68% in 2 hours (±9%). This exceeds the upper limit of 65%. We recommend activating humidity control before midday."
  6695
]
View formatted query    View runnable query    Explain query    View query backtrace
156 0.33 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Take action in the morning, around 7:00 AM. Monitor progress over the next 3-5 days."
  6696
]
View formatted query    View runnable query    Explain query    View query backtrace
157 3.32 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
158 0.17 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
159 0.32 ms 
INSERT INTO ai_alertas (param, tipo, mensaje, tiempo_restante, valor_critico, ai_rec_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "temperature"
  "alerta_critica"
  "Sensación de calor e incomodidad generalizada (Temperatura: 33.4°C, umbral: 27°C). Ajustar climatización en las próximas 12 horas."
  "Preparar climatización a media tarde (entre 16:00h–17:00h). Evaluar ajustes permanentes si continúa."
  33.4
  1022
]
View formatted query    View runnable query    Explain query    View query backtrace
160 0.26 ms 
INSERT INTO alertas_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Alertas"
  "mensaje"
  1899
  "Sensación de calor e incomodidad generalizada (Temperatura: 33.4°C, umbral: 27°C). Ajustar climatización en las próximas 12 horas."
]
View formatted query    View runnable query    Explain query    View query backtrace
161 0.29 ms 
INSERT INTO alertas_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Alertas"
  "tiempoRestante"
  1899
  "Preparar climatización a media tarde (entre 16:00h–17:00h). Evaluar ajustes permanentes si continúa."
]
View formatted query    View runnable query    Explain query    View query backtrace
162 3.50 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
163 0.37 ms 
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"
  "1899"
  "App\Entity\AI\Alertas"
]
View formatted query    View runnable query    Explain query    View query backtrace
164 0.41 ms 
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"
  "tiempoRestante"
  "1899"
  "App\Entity\AI\Alertas"
]
View formatted query    View runnable query    Explain query    View query backtrace
165 0.13 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
166 0.46 ms 
UPDATE alertas_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Tackle heat discomfort. Temp. 33.4°C exceeds 27°C threshold. Adjust HVAC within 12 hours."
  2407
]
View formatted query    View runnable query    Explain query    View query backtrace
167 0.28 ms 
UPDATE alertas_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Schedule HVAC boost mid-afternoon (16:00–17:00). Plan permanent tweaks if issue persists."
  2408
]
View formatted query    View runnable query    Explain query    View query backtrace
168 2.79 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
169 0.28 ms 
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: 
[
  "064c9a47-2611-4fe4-8662-1534be6a3fa3"
  "2026-07-15"
]
View formatted query    View runnable query    Explain query    View query backtrace
170 0.16 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
171 0.47 ms 
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":"15\/07\/26 07:31","nivel_alerta":"NORMAL"}"
  "064c9a47-2611-4fe4-8662-1534be6a3fa3"
  1039
  1023
  1022
]
View formatted query    View runnable query    Explain query    View query backtrace
172 3.68 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\Sensor 3
App\Entity\AI\Recomendacion 3
App\Entity\AI\Translation\AiAnalisisTemporalTranslation 2
App\Entity\AI\Translation\AiRecomendacionesTranslation 2
App\Entity\AI\Translation\AlertasTranslation 2
App\Entity\Oficina 1
App\Entity\User 1
App\Entity\ApiAiReceive 1
App\Entity\AI\AiAnalisisTemporal 1
App\Entity\AI\AiPredicciones 1
App\Entity\AI\AiRecomendaciones 1
App\Entity\AI\Alertas 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.