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

Response
200 OK
IP
141.227.188.207
Profiled on
Token
e44221

Query Metrics

179 Database Queries
37 Different statements
109.58 ms Query time
8 Invalid entities
87 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.98 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: 
[
  "4badb165-6e9b-4ea6-8183-56251102df2e"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.66 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: 
[
  "4badb165-6e9b-4ea6-8183-56251102df2e"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 2.23 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: 
[
  "4badb165-6e9b-4ea6-8183-56251102df2e"
  "2026-07-15"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.15 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.38 ms 
INSERT INTO api_ai_receive (payload, created, processed_date, processed, oficina_id) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "{"oficina_id": "4badb165-6e9b-4ea6-8183-56251102df2e", "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": "10/07/26", "fecha_explicativa": {"es": "Viernes, Prom. 1069", "en": "Report avg. 1069 ppm on Friday."}, "co2_ppm": 1069, "temperatura_celsius": 23.3, "humedad_porcentaje": 56, "indice_bienestar": 72}, "peor_dia_historico": {"fecha": "14/07/26", "fecha_explicativa": {"es": "Martes, Prom. 1270", "en": "Show avg. 1270 ppm on Tuesday."}, "co2_ppm": 1270, "temperatura_celsius": 23.8, "humedad_porcentaje": 57, "indice_bienestar": 59}, "hoy_vs_mejor_dia_historico": {"co2_diferencia_ppm": 401, "co2_diferencia_porcentaje": 37.5, "temperatura_diferencia_celsius": 4.3, "humedad_diferencia_puntos": -8, "bienestar_perdido_puntos": 27.5}, "promedio_bienestar_actual": 45.0, "rango_bienestar_historico": {"mejor": 72, "peor": 59, "amplitud": 13}}, "patrones_semanales_detallados": {"es_confiable": true, "dias": [{"dia": "1", "co2_actual_ppm": 1268, "co2_desviacion_ppm": 268, "temperatura_actual_celsius": 23.8, "temperatura_desviacion_celsius": -0.7, "humedad_actual_porcentaje": 57, "humedad_desviacion_puntos": 4.5, "horas_beneficio_potencial": 0.7, "beneficio_potencial_eur": 12}, {"dia": "2", "co2_actual_ppm": 1346, "co2_desviacion_ppm": 346, "temperatura_actual_celsius": 23.8, "temperatura_desviacion_celsius": -0.7, "humedad_actual_porcentaje": 56, "humedad_desviacion_puntos": 3.5, "horas_beneficio_potencial": 0.7, "beneficio_potencial_eur": 12}, {"dia": "3", "co2_actual_ppm": 1224, "co2_desviacion_ppm": 224, "temperatura_actual_celsius": 23.7, "temperatura_desviacion_celsius": -0.8, "humedad_actual_porcentaje": 52, "humedad_desviacion_puntos": -0.5, "horas_beneficio_potencial": 0.4, "beneficio_potencial_eur": 11}, {"dia": "4", "co2_actual_ppm": 1201, "co2_desviacion_ppm": 201, "temperatura_actual_celsius": 23.9, "temperatura_desviacion_celsius": -0.6, "humedad_actual_porcentaje": 54, "humedad_desviacion_puntos": 1.5, "horas_beneficio_potencial": 0.4, "beneficio_potencial_eur": 11}, {"dia": "5", "co2_actual_ppm": 1076, "co2_desviacion_ppm": 76, "temperatura_actual_celsius": 23.4, "temperatura_desviacion_celsius": -1.1, "humedad_actual_porcentaje": 54, "humedad_desviacion_puntos": 1.5, "horas_beneficio_potencial": 0.4, "beneficio_potencial_eur": 11}], "hoy_vs_historico": {"co2_diferencia_porcentaje": 18.1, "temperatura_diferencia_porcentaje": -2.8, "humedad_diferencia_porcentaje": 7.4, "horas_beneficio_potencial_hoy": 0, "horas_beneficio_potencial_promedio_semanal": 0, "beneficio_potencial_hoy_eur": 47, "beneficio_potencial_promedio_semanal_eur": 234}}}, "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": "17:00", "segunda_peor": "16:00", "tercera_peor": "15:00", "proximo_pico_predicho": {"hora": "15:00", "valor_esperado_ppm": 1787, "tiempo_restante_horas": 9, "clasificacion": "critica"}, "_validation": {"is_valid": true, "completeness_score": 1.0, "missing_fields": [], "reason": null}}, "temperatura_picos_historicos": {"peor_hora": "15:00", "segunda_peor": "16:00", "tercera_peor": "14:00", "proximo_pico_predicho": {"hora": "14:00", "valor_esperado_celsius": 28.6, "tiempo_restante_horas": 8, "clasificacion": "preventiva"}, "_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": 54, "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": 1200, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": true}, "temperature": {"valor": 23.5, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}, "humidity": {"valor": 57, "unidad": "%", "hr_start": 12, "hr_end": 13, "es_critico": false}}}, {"dia": "2", "es_confiable": true, "valores": {"co2": {"valor": 1270, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": true}, "temperature": {"valor": 23.8, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 57, "unidad": "%", "hr_start": 9, "hr_end": 11, "es_critico": false}}}, {"dia": "3", "es_confiable": true, "valores": {"co2": {"valor": 1172, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": true}, "temperature": {"valor": 23.8, "unidad": "\u00b0C", "hr_start": 14, "hr_end": 15, "es_critico": false}, "humidity": {"valor": 57, "unidad": "%", "hr_start": 17, "hr_end": 18, "es_critico": false}}}, {"dia": "4", "es_confiable": true, "valores": {"co2": {"valor": 1181, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": true}, "temperature": {"valor": 23.8, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 57, "unidad": "%", "hr_start": 14, "hr_end": 15, "es_critico": false}}}, {"dia": "5", "es_confiable": true, "valores": {"co2": {"valor": 1069, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": true}, "temperature": {"valor": 23.3, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 56, "unidad": "%", "hr_start": 14, "hr_end": 15, "es_critico": false}}}], "resumen_tendencias": {"co2": {"tendencia_general": "-7.6%", "impacto_negocio": {"es": "Mejora significativa de 10.2% en la calidad del aire. Los niveles de CO\u2082 se mantienen consistentemente por debajo de 800 ppm, proporcionando condiciones ideales para tareas de alta exigencia cognitiva.", "en": "Achieve 10.2% boost in air quality. CO\u2082 stays consistently below 800 ppm. Ideal for high-cognitive tasks."}, "recomendacion_planificacion": {"es": "Aprovechar la mejora del 10.2% general manteniendo ventilaci\u00f3n preventiva en Lunes Tarde temprana (16-17h) (Prom. 1200), donde a\u00fan se observan valores superiores.", "en": "Capitalize on 10.2% air quality boost. Maintain preventive ventilation early Monday afternoon (16-17h). Avg. 1200 ppm still elevated."}}, "temperature": {"tendencia_general": "-0.1%", "impacto_negocio": {"es": "\u00daltimas jornadas muestran variabilidad t\u00e9rmicas de +1.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": "Register +1.4% thermal fluctuations over 5 days. Environment remains fairly stable. System calibration would even out temperature."}, "recomendacion_planificacion": {"es": "Ajustar puntualmente la climatizaci\u00f3n en los d\u00edas con variaciones (+1.4%). El equilibrio t\u00e9rmico el resto de la semana es excelente.", "en": "Fine-tune HVAC on days with +1.4% thermal variation. Thermal balance excellent rest of week."}}, "humidity": {"tendencia_general": "-0.6%", "impacto_negocio": {"es": "Variaciones en humedad de +6.7% detectadas en 5 jornadas. La media permanece en el rango saludable ASHRAE (40-60%), sin riesgos inmediatos.", "en": "Detect +6.7% humidity swings across 5 days. Avg. remains within healthy ASHRAE range (40-60%). No immediate risk."}, "recomendacion_planificacion": {"es": "Niveles de humedad equilibrados (+6.7% de variaci\u00f3n). Mantener la rutina actual de ventilaci\u00f3n sin necesidad de ajustes adicionales.", "en": "Keep humidity balanced despite +6.7% variation. Maintain current ventilation setup. No adjustments needed."}}}}, "predicciones_30_dias": {"semanas_disponibles": 4, "dias_criticos": {"semana_1": [{"dia_mes": 3, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 1200, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": true}, "temperature": {"valor": 23.5, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}, "humidity": {"valor": 57, "unidad": "%", "hr_start": 12, "hr_end": 13, "es_critico": false}}}, {"dia_mes": 4, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 1270, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": true}, "temperature": {"valor": 23.8, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 57, "unidad": "%", "hr_start": 9, "hr_end": 11, "es_critico": false}}}, {"dia_mes": 5, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 1172, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": true}, "temperature": {"valor": 23.8, "unidad": "\u00b0C", "hr_start": 14, "hr_end": 15, "es_critico": false}, "humidity": {"valor": 57, "unidad": "%", "hr_start": 17, "hr_end": 18, "es_critico": false}}}, {"dia_mes": 6, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 1181, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": true}, "temperature": {"valor": 23.8, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 57, "unidad": "%", "hr_start": 14, "hr_end": 15, "es_critico": false}}}, {"dia_mes": 7, "semana_mes": 1, "es_confiable": true, "valores": {"co2": {"valor": 1069, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": true}, "temperature": {"valor": 23.3, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 56, "unidad": "%", "hr_start": 14, "hr_end": 15, "es_critico": false}}}], "semana_2": [{"dia_mes": 10, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 1146, "unidad": "ppm", "hr_start": 17, "hr_end": 18, "es_critico": true}, "temperature": {"valor": 23.6, "unidad": "\u00b0C", "hr_start": 11, "hr_end": 12, "es_critico": false}, "humidity": {"valor": 70, "unidad": "%", "hr_start": 14, "hr_end": 15, "es_critico": true}}}, {"dia_mes": 11, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 1133, "unidad": "ppm", "hr_start": 17, "hr_end": 18, "es_critico": true}, "temperature": {"valor": 24.1, "unidad": "\u00b0C", "hr_start": 10, "hr_end": 12, "es_critico": false}, "humidity": {"valor": 51, "unidad": "%", "hr_start": 9, "hr_end": 11, "es_critico": false}}}, {"dia_mes": 12, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 1250, "unidad": "ppm", "hr_start": 17, "hr_end": 18, "es_critico": true}, "temperature": {"valor": 25.4, "unidad": "\u00b0C", "hr_start": 14, "hr_end": 15, "es_critico": false}, "humidity": {"valor": 72, "unidad": "%", "hr_start": 17, "hr_end": 18, "es_critico": true}}}, {"dia_mes": 13, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 1107, "unidad": "ppm", "hr_start": 17, "hr_end": 18, "es_critico": true}, "temperature": {"valor": 22.8, "unidad": "\u00b0C", "hr_start": 8, "hr_end": 10, "es_critico": false}, "humidity": {"valor": 71, "unidad": "%", "hr_start": 14, "hr_end": 15, "es_critico": true}}}, {"dia_mes": 14, "semana_mes": 2, "es_confiable": true, "valores": {"co2": {"valor": 881, "unidad": "ppm", "hr_start": 14, "hr_end": 15, "es_critico": false}, "temperature": {"valor": 21.9, "unidad": "\u00b0C", "hr_start": 8, "hr_end": 10, "es_critico": false}}}], "semana_3": [{"dia_mes": 17, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 1156, "unidad": "ppm", "hr_start": 14, "hr_end": 15, "es_critico": true}, "temperature": {"valor": 25.0, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}}}, {"dia_mes": 18, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 1062, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": true}, "temperature": {"valor": 25.3, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 58, "unidad": "%", "hr_start": 11, "hr_end": 13, "es_critico": false}}}, {"dia_mes": 19, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 1159, "unidad": "ppm", "hr_start": 15, "hr_end": 16, "es_critico": true}, "temperature": {"valor": 24.5, "unidad": "\u00b0C", "hr_start": 16, "hr_end": 17, "es_critico": false}, "humidity": {"valor": 65, "unidad": "%", "hr_start": 17, "hr_end": 18, "es_critico": false}}}, {"dia_mes": 20, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 992, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": false}, "temperature": {"valor": 23.5, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 72, "unidad": "%", "hr_start": 14, "hr_end": 15, "es_critico": true}}}, {"dia_mes": 21, "semana_mes": 3, "es_confiable": true, "valores": {"co2": {"valor": 1095, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": true}, "temperature": {"valor": 23.1, "unidad": "\u00b0C", "hr_start": 8, "hr_end": 10, "es_critico": false}, "humidity": {"valor": 70, "unidad": "%", "hr_start": 12, "hr_end": 13, "es_critico": true}}}], "semana_4": [{"dia_mes": 24, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 1253, "unidad": "ppm", "hr_start": 17, "hr_end": 18, "es_critico": true}, "temperature": {"valor": 23.3, "unidad": "\u00b0C", "hr_start": 12, "hr_end": 13, "es_critico": false}, "humidity": {"valor": 56, "unidad": "%", "hr_start": 12, "hr_end": 13, "es_critico": false}}}, {"dia_mes": 25, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 1214, "unidad": "ppm", "hr_start": 17, "hr_end": 18, "es_critico": true}, "temperature": {"valor": 22.8, "unidad": "\u00b0C", "hr_start": 9, "hr_end": 11, "es_critico": false}, "humidity": {"valor": 54, "unidad": "%", "hr_start": 9, "hr_end": 11, "es_critico": false}}}, {"dia_mes": 26, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 995, "unidad": "ppm", "hr_start": 15, "hr_end": 16, "es_critico": false}, "temperature": {"valor": 24.4, "unidad": "\u00b0C", "hr_start": 15, "hr_end": 16, "es_critico": false}, "humidity": {"valor": 65, "unidad": "%", "hr_start": 17, "hr_end": 18, "es_critico": false}}}, {"dia_mes": 27, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 994, "unidad": "ppm", "hr_start": 16, "hr_end": 17, "es_critico": false}, "temperature": {"valor": 24.7, "unidad": "\u00b0C", "hr_start": 8, "hr_end": 10, "es_critico": false}, "humidity": {"valor": 69, "unidad": "%", "hr_start": 13, "hr_end": 14, "es_critico": true}}}, {"dia_mes": 28, "semana_mes": 4, "es_confiable": true, "valores": {"co2": {"valor": 954, "unidad": "ppm", "hr_start": 17, "hr_end": 18, "es_critico": false}, "temperature": {"valor": 25.3, "unidad": "\u00b0C", "hr_start": 10, "hr_end": 12, "es_critico": false}, "humidity": {"valor": 47, "unidad": "%", "hr_start": 14, "hr_end": 15, "es_critico": false}}}]}, "resumen_tendencias": {"co2": {"tendencia_general": "-2.3%", "patron_largo_plazo": {"es": "mejora gradual controlada", "en": "Deliver gradual, controlled improvement."}, "impacto_negocio": {"es": "Variaci\u00f3n mensual contenida en -2.3%. La estabilidad observada facilita una planificaci\u00f3n de acciones correctivas sin necesidad de intervenciones urgentes.", "en": "Contain monthly variation at -2.3%. Stability supports planned corrective actions without urgent intervention."}, "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": "Confirm ventilation system suits current occupancy. Uphold annual preventive maintenance to preserve efficiency long-term."}}, "temperature": {"tendencia_general": "+2.5%", "patron_largo_plazo": {"es": "ligero incremento con variaciones", "en": "Note slight increase with fluctuations."}, "impacto_negocio": {"es": "Variaci\u00f3n t\u00e9rmica mensual m\u00ednima de +2.5%. La estabilidad t\u00e9rmica permite mantener un consumo energ\u00e9tico predecible y facilita la planificaci\u00f3n de recursos.", "en": "Report minimal +2.5% monthly thermal variation. Stable thermal conditions enable predictable energy use and resource planning."}, "recomendacion_inversion": {"es": "El comportamiento t\u00e9rmico del espacio es estable y predecible. No se requieren ajustes significativos en el sistema de climatizaci\u00f3n durante este periodo.", "en": "Maintain stable, predictable thermal environment. No major HVAC adjustments required this period."}}, "humidity": {"tendencia_general": "+2.2%", "patron_largo_plazo": {"es": "ligero incremento con variaciones", "en": "Observe slight increase with fluctuations."}, "impacto_negocio": {"es": "Las condiciones de humedad han permanecido equilibradas durante el mes con variaci\u00f3n de +2.2%. Este comportamiento estable dentro del rango ASHRAE favorece el bienestar y la conservaci\u00f3n del espacio.", "en": "Sustain balanced humidity with +2.2% monthly variation. Stability within ASHRAE range supports comfort and asset preservation."}, "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": "Manage humidity well with current systems. Continue regular ventilation and periodic reviews to uphold balance."}}}}}}, "recomendaciones_y_alertas": {"recomendaciones_accionables": [{"prioridad": 1, "accion": {"es": "Prevenci\u00f3n pico CO2", "en": "CO2 Peak Prevention"}, "descripcion": {"es": "Detectamos concentraci\u00f3n cr\u00edtica de CO\u2082 que afectar\u00e1 gravemente el rendimiento. Proyecci\u00f3n: 1787 ppm en 9h (+1038 ppm, +138.6% respecto al valor actual de 749 ppm). Este nivel supera ampliamente el l\u00edmite cr\u00edtico de 1500 ppm. Recomendamos ventilar 30\u201360 minutos antes del horario de mayor ocupaci\u00f3n.", "en": "We have detected a critical concentration of CO\u2082 that will severely impact performance. Projection: 1787 ppm in 9 hours (+1038 ppm, +138.6% compared to the current value of 749 ppm). This level far exceeds the critical limit of 1500 ppm. We recommend ventilating for 30\u201360 minutes before peak occupancy hours."}, "momento_ejecucion": {"es": "Renovar aire antes del mediod\u00eda (hacia las 14:00h\u201315:00h). Establecer ventilaci\u00f3n sistem\u00e1tica si el patr\u00f3n persiste.", "en": "Renew air before midday (around 2:00 PM\u20133:00 PM). Establish systematic ventilation if the pattern persists."}, "parametro_objetivo": "co2", "valor_critico": 1787}, {"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: 28.6\u00b0C en 8h (actual: 28.9\u00b0C, +-0.3\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: 28.6\u00b0C in 8 hours (current: 28.9\u00b0C, \u00b10.3\u00b0C). This will exceed the optimal range of 21\u201324\u00b0C. We recommend adjusting the air conditioning proactively tomorrow morning."}, "momento_ejecucion": {"es": "Intervenir antes del mediod\u00eda, sobre las 13:00h. Monitorear patrones t\u00e9rmicos semanales.", "en": "Intervene before noon, around 1:00 PM. Monitor weekly thermal patterns."}, "parametro_objetivo": "temperature", "valor_critico": 28.6}, {"prioridad": 3, "accion": {"es": "Prevenci\u00f3n pico Humidity", "en": "Peak Humidity Prevention"}, "descripcion": {"es": "Observamos ligera variaci\u00f3n de humedad sin impacto notable. Proyecci\u00f3n: 54% en 2h (-2%). El rango \u00f3ptimo es 40\u201360%. Sugerimos monitoreo preventivo.", "en": "We observed a slight variation in humidity with no significant impact. Projection: 54% in 2 hours (-2%). The optimal range is 40\u201360%. We recommend preventive monitoring."}, "momento_ejecucion": {"es": "Actuar en horario matinal, hacia las 07:00h. Observar evoluci\u00f3n durante los pr\u00f3ximos 3-5 d\u00edas.", "en": "Operate in the morning, around 7:00 AM. Monitor progress over the next 3-5 days."}, "parametro_objetivo": "humidity", "valor_critico": 54}], "alertas_temporales_criticas": [{"tipo": "alerta_critica", "mensaje": {"es": "El aire se volver\u00e1 denso causando fatiga severa y somnolencia (CO\u2082: 1787 ppm, l\u00edmite cr\u00edtico: 1000 ppm). Ventilar el espacio en las pr\u00f3ximas 12 horas.", "en": "The air will become dense, causing severe fatigue and drowsiness (CO\u2082: 1787 ppm, critical limit: 1000 ppm). Ventilate the space within the next 12 hours."}, "parametro": "co2", "tiempo_restante": {"es": "Renovar aire antes del mediod\u00eda (hacia las 14:00h\u201315:00h). Establecer ventilaci\u00f3n sistem\u00e1tica si el patr\u00f3n persiste.", "en": "Renew air before noon (around 2:00\u20133:00 PM). Establish systematic ventilation if the pattern persists."}, "valor_critico": 1787}, {"tipo": "alerta_preventiva", "mensaje": {"es": "Sensaci\u00f3n de calor e incomodidad generalizada (Temperatura: 28.6\u00b0C, umbral: 27\u00b0C). Ajustar climatizaci\u00f3n en las pr\u00f3ximas 12 horas.", "en": "Sensation of heat and general discomfort (Temperature: 28.6\u00b0C, threshold: 27\u00b0C). Adjust air conditioning within the next 12 hours."}, "parametro": "temperature", "tiempo_restante": {"es": "Intervenir antes del mediod\u00eda, sobre las 13:00h. Monitorear patrones t\u00e9rmicos semanales.", "en": "Intervene before midday, around 1:00 PM. Monitor weekly thermal patterns."}, "valor_critico": 28.6}]}, "impacto_economico_y_productividad": {"impacto_economico_solo_laborables": {"metodologia": {"es": "An\u00e1lisis hist\u00f3rico ponderado cient\u00edfico (22 d\u00edas laborables/mes)", "en": "Base analysis on weighted scientific data (22 working days/month)."}, "ocupacion_oficina": 1, "beneficios_diarios": {"es_confiable": true, "beneficio_potencial_diario_eur": 47, "horas_beneficio_potencial_diarias": 3.38}, "beneficios_semanales": {"es_confiable": true, "beneficio_potencial_semanal_eur": 234}, "beneficios_mensuales": {"es_confiable": true, "beneficio_potencial_mensual_eur": 1013, "dias_laborales_mes": 22}, "beneficios_anuales": {"es_confiable": true, "beneficio_potencial_anual_eur": 12159, "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": 83.6, "confianza_temperatura_porcentaje": 94.6, "confianza_humedad_porcentaje": 94.3, "calidad_general_porcentaje": 95.0, "confianza_global_porcentaje": 90.1, "registros_analizados": 3469, "periodo_analizado": "3469 registros (\u00faltimos 313 d\u00edas)", "explicacion": {"es": "Mayor confianza = predicciones m\u00e1s fiables. CO2 variable por ocupaci\u00f3n, temperatura/humedad m\u00e1s estables", "en": "Build greater confidence with reliable predictions. CO\u2082 varies by occupancy; temperature and humidity remain stable."}}}, "sensor_device_team": {"bienestar_7": 41, "bienestar_30": 47, "tendencia_7d": "negativa", "tendencia_30d": "constante"}}"
  "2026-07-15 06:02:02"
  "2026-07-15"
  1
  "4badb165-6e9b-4ea6-8183-56251102df2e"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 4.04 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7 1.45 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: 
[
  "4badb165-6e9b-4ea6-8183-56251102df2e"
  "2026-07-15"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.14 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.59 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:02:02"
  "2026-07-10"
  "Viernes, Prom. 1069"
  1069
  23.3
  56
  72
  1
  1
  "2026-07-14"
  "Martes, Prom. 1270"
  1270
  23.8
  57
  59
  401
  37.5
  4.3
  -8
  27.5
  45.0
  72
  59
  13
  null
  null
  null
  null
  null
  null
  null
  "4badb165-6e9b-4ea6-8183-56251102df2e"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.26 ms 
INSERT INTO ai_analisis_temporal_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiAnalisisTemporal"
  "mdhFechaExplicativa"
  1040
  "Viernes, Prom. 1069"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.33 ms 
INSERT INTO ai_analisis_temporal_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiAnalisisTemporal"
  "pdhFechaExplicativa"
  1040
  "Martes, Prom. 1270"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 2.75 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.60 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"
  "1040"
  "App\Entity\AI\AiAnalisisTemporal"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 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_analisis_temporal_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1
Parameters: 
[
  "en"
  "pdhFechaExplicativa"
  "1040"
  "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.39 ms 
UPDATE ai_analisis_temporal_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Report avg. 1069 ppm on Friday."
  1291
]
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: 
[
  "Show avg. 1270 ppm on Tuesday."
  1292
]
View formatted query    View runnable query    Explain query    View query backtrace
18 4.34 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.14 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.43 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"
  1268
  268
  23.8
  -0.7
  57
  4.5
  0.7
  12
  1040
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.26 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"
  1346
  346
  23.8
  -0.7
  56
  3.5
  0.7
  12
  1040
]
View formatted query    View runnable query    Explain query    View query backtrace
22 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: 
[
  "3"
  1224
  224
  23.7
  -0.8
  52
  -0.5
  0.4
  11
  1040
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.38 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"
  1201
  201
  23.9
  -0.6
  54
  1.5
  0.4
  11
  1040
]
View formatted query    View runnable query    Explain query    View query backtrace
24 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: 
[
  "5"
  1076
  76
  23.4
  -1.1
  54
  1.5
  0.4
  11
  1040
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.35 ms 
INSERT INTO ai_device_values (tipo, name, valor, ai_analisis_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "teams"
  "bienestar_7"
  41
  1040
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.32 ms 
INSERT INTO ai_device_values (tipo, name, valor, ai_analisis_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "teams"
  "bienestar_30"
  47
  1040
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.25 ms 
INSERT INTO ai_device_values (tipo, name, valor, ai_analisis_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "teams"
  "tendencia_7d"
  -1
  1040
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.31 ms 
INSERT INTO ai_device_values (tipo, name, valor, ai_analisis_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "teams"
  "tendencia_30d"
  0
  1040
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.44 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: 
[
  18.1
  -2.8
  7.4
  "horas_beneficio_potencial_hoy"
  0
  "beneficio_potencial_hoy_eur"
  234
  1040
]
View formatted query    View runnable query    Explain query    View query backtrace
30 3.91 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
31 1.46 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: 
[
  "4badb165-6e9b-4ea6-8183-56251102df2e"
  "2026-07-15"
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.14 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:02:02"
  "-7.6%"
  "Mejora significativa de 10.2% en la calidad del aire. Los niveles de CO₂ se mantienen consistentemente por debajo de 800 ppm, proporcionando condiciones ideales para tareas de alta exigencia cognitiva."
  "Aprovechar la mejora del 10.2% general manteniendo ventilación preventiva en Lunes Tarde temprana (16-17h) (Prom. 1200), donde aún se observan valores superiores."
  "-0.1%"
  "Últimas jornadas muestran variabilidad térmicas de +1.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 (+1.4%). El equilibrio térmico el resto de la semana es excelente."
  "-0.6%"
  "Variaciones en humedad de +6.7% detectadas en 5 jornadas. La media permanece en el rango saludable ASHRAE (40-60%), sin riesgos inmediatos."
  "Niveles de humedad equilibrados (+6.7% de variación). Mantener la rutina actual de ventilación sin necesidad de ajustes adicionales."
  "-2.3%"
  "mejora gradual controlada"
  "Variación mensual contenida en -2.3%. 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."
  "+2.5%"
  "ligero incremento con variaciones"
  "Variación térmica mensual mínima de +2.5%. 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."
  "+2.2%"
  "ligero incremento con variaciones"
  "Las condiciones de humedad han permanecido equilibradas durante el mes con variación de +2.2%. 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
  "4badb165-6e9b-4ea6-8183-56251102df2e"
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.29 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
  16
  17
  1200
  1
  12
  13
  23.5
  0
  12
  13
  57
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
35 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: 
[
  2
  16
  17
  1270
  1
  9
  11
  23.8
  0
  9
  11
  57
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.31 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
  1172
  1
  14
  15
  23.8
  0
  17
  18
  57
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.38 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
  1181
  1
  9
  11
  23.8
  0
  14
  15
  57
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
38 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: 
[
  5
  16
  17
  1069
  1
  9
  11
  23.3
  0
  14
  15
  56
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
39 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: 
[
  3
  1
  16
  17
  1200
  1
  12
  13
  23.5
  0
  12
  13
  57
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.29 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
  16
  17
  1270
  1
  9
  11
  23.8
  0
  9
  11
  57
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
41 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: 
[
  5
  1
  16
  17
  1172
  1
  14
  15
  23.8
  0
  17
  18
  57
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.40 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
  1181
  1
  9
  11
  23.8
  0
  14
  15
  57
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
43 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: 
[
  7
  1
  16
  17
  1069
  1
  9
  11
  23.3
  0
  14
  15
  56
  0
  1
  1024
]
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
  17
  18
  1146
  1
  11
  12
  23.6
  0
  14
  15
  70
  1
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.36 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
  17
  18
  1133
  1
  10
  12
  24.1
  0
  9
  11
  51
  0
  1
  1024
]
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
  17
  18
  1250
  1
  14
  15
  25.4
  0
  17
  18
  72
  1
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.40 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
  17
  18
  1107
  1
  8
  10
  22.8
  0
  14
  15
  71
  1
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
48 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: 
[
  14
  2
  14
  15
  881
  0
  8
  10
  21.9
  0
  null
  null
  null
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
49 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: 
[
  17
  3
  14
  15
  1156
  1
  12
  13
  25.0
  0
  null
  null
  null
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
50 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: 
[
  18
  3
  16
  17
  1062
  1
  9
  11
  25.3
  0
  11
  13
  58
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
51 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: 
[
  19
  3
  15
  16
  1159
  1
  16
  17
  24.5
  0
  17
  18
  65
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.29 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
  16
  17
  992
  0
  9
  11
  23.5
  0
  14
  15
  72
  1
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
53 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: 
[
  21
  3
  16
  17
  1095
  1
  8
  10
  23.1
  0
  12
  13
  70
  1
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
54 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: 
[
  24
  4
  17
  18
  1253
  1
  12
  13
  23.3
  0
  12
  13
  56
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.36 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
  17
  18
  1214
  1
  9
  11
  22.8
  0
  9
  11
  54
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
56 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: 
[
  26
  4
  15
  16
  995
  0
  15
  16
  24.4
  0
  17
  18
  65
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.36 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
  16
  17
  994
  0
  8
  10
  24.7
  0
  13
  14
  69
  1
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.36 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
  17
  18
  954
  0
  10
  12
  25.3
  0
  14
  15
  47
  0
  1
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.34 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "co2"
  1
  15
  1787
  "critica"
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.35 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "co2"
  2
  16
  null
  null
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.26 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "co2"
  3
  15
  null
  null
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.39 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "temp"
  1
  14
  28.6
  "preventiva"
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.36 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "temp"
  2
  16
  null
  null
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.27 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "temp"
  3
  14
  null
  null
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.28 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "hum"
  1
  8
  54
  "preventiva"
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.32 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "hum"
  2
  9
  null
  null
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.24 ms 
INSERT INTO ai_prediccion_pico (tipo, orden, hora, valor, clasificacion, prediccion_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "hum"
  3
  10
  null
  null
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.28 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7co2Impacto"
  1024
  "Mejora significativa de 10.2% en la calidad del aire. Los niveles de CO₂ se mantienen consistentemente por debajo de 800 ppm, proporcionando condiciones ideales para tareas de alta exigencia cognitiva."
]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.26 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7co2Recomendacion"
  1024
  "Aprovechar la mejora del 10.2% general manteniendo ventilación preventiva en Lunes Tarde temprana (16-17h) (Prom. 1200), donde aún se observan valores superiores."
]
View formatted query    View runnable query    Explain query    View query backtrace
70 0.30 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7TempImpacto"
  1024
  "Últimas jornadas muestran variabilidad térmicas de +1.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.34 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7TempRecomendacion"
  1024
  "Ajustar puntualmente la climatización en los días con variaciones (+1.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.25 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7HumImpacto"
  1024
  "Variaciones en humedad de +6.7% detectadas en 5 jornadas. La media permanece en el rango saludable ASHRAE (40-60%), sin riesgos inmediatos."
]
View formatted query    View runnable query    Explain query    View query backtrace
73 0.29 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred7HumRecomendacion"
  1024
  "Niveles de humedad equilibrados (+6.7% de variación). Mantener la rutina actual de ventilación sin necesidad de ajustes adicionales."
]
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"
  1024
  "mejora gradual controlada"
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.27 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30co2Impacto"
  1024
  "Variación mensual contenida en -2.3%. 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.31 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30co2Recomendacion"
  1024
  "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.34 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30TempImpacto"
  1024
  "Variación térmica mensual mínima de +2.5%. 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.27 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30TempRecomendacion"
  1024
  "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.27 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30HumPatronLargoPlazo"
  1024
  "ligero incremento con variaciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
80 0.36 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30HumImpacto"
  1024
  "Las condiciones de humedad han permanecido equilibradas durante el mes con variación de +2.2%. 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.24 ms 
INSERT INTO ai_predicciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiPredicciones"
  "cvhPred30HumRecomendacion"
  1024
  "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 2.85 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
83 0.46 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"
  "1024"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
84 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"
  "cvhPred7co2Recomendacion"
  "1024"
  "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"
  "1024"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
86 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"
  "cvhPred7TempRecomendacion"
  "1024"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
87 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"
  "cvhPred7HumImpacto"
  "1024"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
88 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"
  "cvhPred7HumRecomendacion"
  "1024"
  "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"
  "1024"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
90 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"
  "cvhPred30co2Impacto"
  "1024"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
91 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"
  "cvhPred30co2Recomendacion"
  "1024"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
92 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"
  "cvhPred30TempImpacto"
  "1024"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
93 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_predicciones_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1
Parameters: 
[
  "en"
  "cvhPred30TempRecomendacion"
  "1024"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
94 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"
  "cvhPred30HumPatronLargoPlazo"
  "1024"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
95 0.54 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"
  "1024"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
96 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"
  "cvhPred30HumRecomendacion"
  "1024"
  "App\Entity\AI\AiPredicciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
97 0.16 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
98 0.96 ms 
UPDATE ai_predicciones SET cvh_pred30_temp_patron_largo_plazo = ? WHERE id = ?
Parameters: 
[
  "Note slight increase with fluctuations."
  1024
]
View formatted query    View runnable query    Explain query    View query backtrace
99 0.32 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Achieve 10.2% boost in air quality. CO₂ stays consistently below 800 ppm. Ideal for high-cognitive tasks."
  8975
]
View formatted query    View runnable query    Explain query    View query backtrace
100 0.38 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Capitalize on 10.2% air quality boost. Maintain preventive ventilation early Monday afternoon (16-17h). Avg. 1200 ppm still elevated."
  8976
]
View formatted query    View runnable query    Explain query    View query backtrace
101 0.32 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Register +1.4% thermal fluctuations over 5 days. Environment remains fairly stable. System calibration would even out temperature."
  8977
]
View formatted query    View runnable query    Explain query    View query backtrace
102 0.44 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Fine-tune HVAC on days with +1.4% thermal variation. Thermal balance excellent rest of week."
  8978
]
View formatted query    View runnable query    Explain query    View query backtrace
103 0.52 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Detect +6.7% humidity swings across 5 days. Avg. remains within healthy ASHRAE range (40-60%). No immediate risk."
  8979
]
View formatted query    View runnable query    Explain query    View query backtrace
104 0.28 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Keep humidity balanced despite +6.7% variation. Maintain current ventilation setup. No adjustments needed."
  8980
]
View formatted query    View runnable query    Explain query    View query backtrace
105 0.67 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Deliver gradual, controlled improvement."
  8981
]
View formatted query    View runnable query    Explain query    View query backtrace
106 0.29 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Contain monthly variation at -2.3%. Stability supports planned corrective actions without urgent intervention."
  8982
]
View formatted query    View runnable query    Explain query    View query backtrace
107 0.37 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Confirm ventilation system suits current occupancy. Uphold annual preventive maintenance to preserve efficiency long-term."
  8983
]
View formatted query    View runnable query    Explain query    View query backtrace
108 0.56 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Report minimal +2.5% monthly thermal variation. Stable thermal conditions enable predictable energy use and resource planning."
  8984
]
View formatted query    View runnable query    Explain query    View query backtrace
109 0.38 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Maintain stable, predictable thermal environment. No major HVAC adjustments required this period."
  8985
]
View formatted query    View runnable query    Explain query    View query backtrace
110 0.43 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Observe slight increase with fluctuations."
  8986
]
View formatted query    View runnable query    Explain query    View query backtrace
111 0.40 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Sustain balanced humidity with +2.2% monthly variation. Stability within ASHRAE range supports comfort and asset preservation."
  8987
]
View formatted query    View runnable query    Explain query    View query backtrace
112 0.37 ms 
UPDATE ai_predicciones_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Manage humidity well with current systems. Continue regular ventilation and periodic reviews to uphold balance."
  8988
]
View formatted query    View runnable query    Explain query    View query backtrace
113 3.28 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
114 1.55 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: 
[
  "4badb165-6e9b-4ea6-8183-56251102df2e"
  "2026-07-15"
]
View formatted query    View runnable query    Explain query    View query backtrace
115 0.15 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
116 0.75 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:02:02"
  47
  234
  1013
  12159
  1
  1
  1
  1
  3.38
  22
  234
  null
  1
  1
  83.6
  94.6
  94.3
  95.0
  90.1
  3469
  "3469 registros (últimos 313 días)"
  null
  "4badb165-6e9b-4ea6-8183-56251102df2e"
]
View formatted query    View runnable query    Explain query    View query backtrace
117 2.92 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
118 0.47 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"
  "1023"
  "App\Entity\AI\AiRecomendaciones"
]
View formatted query    View runnable query    Explain query    View query backtrace
119 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 ai_recomendaciones_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1
Parameters: 
[
  "en"
  "cycdExplicacion"
  "1023"
  "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.31 ms 
INSERT INTO ai_recomendaciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiRecomendaciones"
  "ieypMetodologia"
  1023
  "Base analysis on weighted scientific data (22 working days/month)."
]
View formatted query    View runnable query    Explain query    View query backtrace
122 0.41 ms 
INSERT INTO ai_recomendaciones_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\AiRecomendaciones"
  "cycdExplicacion"
  1023
  "Build greater confidence with reliable predictions. CO₂ varies by occupancy; temperature and humidity remain stable."
]
View formatted query    View runnable query    Explain query    View query backtrace
123 3.96 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
124 0.15 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
125 0.45 ms 
INSERT INTO ai_recomendacion (prio, param, accion, descripcion, momento_ejecucion, valor, ai_rec_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  1
  "co2"
  "Prevención pico CO2"
  "Detectamos concentración crítica de CO₂ que afectará gravemente el rendimiento. Proyección: 1787 ppm en 9h (+1038 ppm, +138.6% respecto al valor actual de 749 ppm). Este nivel supera ampliamente el límite crítico de 1500 ppm. Recomendamos ventilar 30–60 minutos antes del horario de mayor ocupación."
  "Renovar aire antes del mediodía (hacia las 14:00h–15:00h). Establecer ventilación sistemática si el patrón persiste."
  1787
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
126 0.39 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: 28.6°C en 8h (actual: 28.9°C, +-0.3°C). Superará el rango óptimo de 21–24°C. Recomendamos ajustar la climatización de forma preventiva mañana por la mañana."
  "Intervenir antes del mediodía, sobre las 13:00h. Monitorear patrones térmicos semanales."
  28.6
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
127 0.36 ms 
INSERT INTO ai_recomendacion (prio, param, accion, descripcion, momento_ejecucion, valor, ai_rec_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  3
  "humidity"
  "Prevención pico Humidity"
  "Observamos ligera variación de humedad sin impacto notable. Proyección: 54% en 2h (-2%). El rango óptimo es 40–60%. Sugerimos monitoreo preventivo."
  "Actuar en horario matinal, hacia las 07:00h. Observar evolución durante los próximos 3-5 días."
  54
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
128 0.35 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "accion"
  3332
  "Prevención pico CO2"
]
View formatted query    View runnable query    Explain query    View query backtrace
129 0.33 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "descripcion"
  3332
  "Detectamos concentración crítica de CO₂ que afectará gravemente el rendimiento. Proyección: 1787 ppm en 9h (+1038 ppm, +138.6% respecto al valor actual de 749 ppm). Este nivel supera ampliamente el límite crítico de 1500 ppm. Recomendamos ventilar 30–60 minutos antes del horario de mayor ocupación."
]
View formatted query    View runnable query    Explain query    View query backtrace
130 0.26 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "momentoEjecucion"
  3332
  "Renovar aire antes del mediodía (hacia las 14:00h–15:00h). Establecer ventilación sistemática si el patrón persiste."
]
View formatted query    View runnable query    Explain query    View query backtrace
131 0.37 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "accion"
  3333
  "Prevención pico Temperature"
]
View formatted query    View runnable query    Explain query    View query backtrace
132 0.28 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "descripcion"
  3333
  "Prevemos incremento térmico que causará incomodidad generalizada. Proyección: 28.6°C en 8h (actual: 28.9°C, +-0.3°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.31 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "momentoEjecucion"
  3333
  "Intervenir antes del mediodía, sobre las 13:00h. Monitorear patrones térmicos semanales."
]
View formatted query    View runnable query    Explain query    View query backtrace
134 0.24 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "accion"
  3334
  "Prevención pico Humidity"
]
View formatted query    View runnable query    Explain query    View query backtrace
135 0.28 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "descripcion"
  3334
  "Observamos ligera variación de humedad sin impacto notable. Proyección: 54% en 2h (-2%). El rango óptimo es 40–60%. Sugerimos monitoreo preventivo."
]
View formatted query    View runnable query    Explain query    View query backtrace
136 0.34 ms 
INSERT INTO ai_recomendacion_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Recomendacion"
  "momentoEjecucion"
  3334
  "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 3.43 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
138 0.53 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"
  "3332"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
139 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"
  "descripcion"
  "3332"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
140 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_recomendacion_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1
Parameters: 
[
  "en"
  "momentoEjecucion"
  "3332"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
141 0.42 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"
  "3333"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
142 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"
  "descripcion"
  "3333"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
143 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_recomendacion_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1
Parameters: 
[
  "en"
  "momentoEjecucion"
  "3333"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
144 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_recomendacion_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1
Parameters: 
[
  "en"
  "accion"
  "3334"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
145 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"
  "descripcion"
  "3334"
  "App\Entity\AI\Recomendacion"
]
View formatted query    View runnable query    Explain query    View query backtrace
146 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"
  "3334"
  "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.38 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "CO2 Peak Prevention"
  6697
]
View formatted query    View runnable query    Explain query    View query backtrace
149 0.29 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "We have detected a critical concentration of CO₂ that will severely impact performance. Projection: 1787 ppm in 9 hours (+1038 ppm, +138.6% compared to the current value of 749 ppm). This level far exceeds the critical limit of 1500 ppm. We recommend ventilating for 30–60 minutes before peak occupancy hours."
  6698
]
View formatted query    View runnable query    Explain query    View query backtrace
150 0.27 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Renew air before midday (around 2:00 PM–3:00 PM). Establish systematic ventilation if the pattern persists."
  6699
]
View formatted query    View runnable query    Explain query    View query backtrace
151 0.26 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Peak Temperature Prevention"
  6700
]
View formatted query    View runnable query    Explain query    View query backtrace
152 0.28 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "We anticipate a thermal increase that will cause widespread discomfort. Projection: 28.6°C in 8 hours (current: 28.9°C, ±0.3°C). This will exceed the optimal range of 21–24°C. We recommend adjusting the air conditioning proactively tomorrow morning."
  6701
]
View formatted query    View runnable query    Explain query    View query backtrace
153 0.26 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Intervene before noon, around 1:00 PM. Monitor weekly thermal patterns."
  6702
]
View formatted query    View runnable query    Explain query    View query backtrace
154 0.42 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Peak Humidity Prevention"
  6703
]
View formatted query    View runnable query    Explain query    View query backtrace
155 0.27 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "We observed a slight variation in humidity with no significant impact. Projection: 54% in 2 hours (-2%). The optimal range is 40–60%. We recommend preventive monitoring."
  6704
]
View formatted query    View runnable query    Explain query    View query backtrace
156 0.38 ms 
UPDATE ai_recomendacion_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Operate in the morning, around 7:00 AM. Monitor progress over the next 3-5 days."
  6705
]
View formatted query    View runnable query    Explain query    View query backtrace
157 3.21 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
158 0.14 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
159 0.47 ms 
INSERT INTO ai_alertas (param, tipo, mensaje, tiempo_restante, valor_critico, ai_rec_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "co2"
  "alerta_critica"
  "El aire se volverá denso causando fatiga severa y somnolencia (CO₂: 1787 ppm, límite crítico: 1000 ppm). Ventilar el espacio en las próximas 12 horas."
  "Renovar aire antes del mediodía (hacia las 14:00h–15:00h). Establecer ventilación sistemática si el patrón persiste."
  1787
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
160 0.30 ms 
INSERT INTO ai_alertas (param, tipo, mensaje, tiempo_restante, valor_critico, ai_rec_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "temperature"
  "alerta_preventiva"
  "Sensación de calor e incomodidad generalizada (Temperatura: 28.6°C, umbral: 27°C). Ajustar climatización en las próximas 12 horas."
  "Intervenir antes del mediodía, sobre las 13:00h. Monitorear patrones térmicos semanales."
  28.6
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
161 0.34 ms 
INSERT INTO alertas_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Alertas"
  "mensaje"
  1900
  "El aire se volverá denso causando fatiga severa y somnolencia (CO₂: 1787 ppm, límite crítico: 1000 ppm). Ventilar el espacio en las próximas 12 horas."
]
View formatted query    View runnable query    Explain query    View query backtrace
162 0.26 ms 
INSERT INTO alertas_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Alertas"
  "tiempoRestante"
  1900
  "Renovar aire antes del mediodía (hacia las 14:00h–15:00h). Establecer ventilación sistemática si el patrón persiste."
]
View formatted query    View runnable query    Explain query    View query backtrace
163 0.25 ms 
INSERT INTO alertas_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Alertas"
  "mensaje"
  1901
  "Sensación de calor e incomodidad generalizada (Temperatura: 28.6°C, umbral: 27°C). Ajustar climatización en las próximas 12 horas."
]
View formatted query    View runnable query    Explain query    View query backtrace
164 0.38 ms 
INSERT INTO alertas_translation (locale, object_class, field, foreign_key, content) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "en"
  "App\Entity\AI\Alertas"
  "tiempoRestante"
  1901
  "Intervenir antes del mediodía, sobre las 13:00h. Monitorear patrones térmicos semanales."
]
View formatted query    View runnable query    Explain query    View query backtrace
165 3.64 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
166 0.51 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"
  "1900"
  "App\Entity\AI\Alertas"
]
View formatted query    View runnable query    Explain query    View query backtrace
167 0.43 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"
  "1900"
  "App\Entity\AI\Alertas"
]
View formatted query    View runnable query    Explain query    View query backtrace
168 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 alertas_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1
Parameters: 
[
  "en"
  "mensaje"
  "1901"
  "App\Entity\AI\Alertas"
]
View formatted query    View runnable query    Explain query    View query backtrace
169 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 alertas_translation a0_ WHERE a0_.locale = ? AND a0_.field = ? AND a0_.foreign_key = ? AND a0_.object_class = ? LIMIT 1
Parameters: 
[
  "en"
  "tiempoRestante"
  "1901"
  "App\Entity\AI\Alertas"
]
View formatted query    View runnable query    Explain query    View query backtrace
170 0.13 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
171 0.43 ms 
UPDATE alertas_translation SET content = ? WHERE id = ?
Parameters: 
[
  "The air will become dense, causing severe fatigue and drowsiness (CO₂: 1787 ppm, critical limit: 1000 ppm). Ventilate the space within the next 12 hours."
  2409
]
View formatted query    View runnable query    Explain query    View query backtrace
172 0.31 ms 
UPDATE alertas_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Renew air before noon (around 2:00–3:00 PM). Establish systematic ventilation if the pattern persists."
  2410
]
View formatted query    View runnable query    Explain query    View query backtrace
173 0.31 ms 
UPDATE alertas_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Sensation of heat and general discomfort (Temperature: 28.6°C, threshold: 27°C). Adjust air conditioning within the next 12 hours."
  2411
]
View formatted query    View runnable query    Explain query    View query backtrace
174 0.30 ms 
UPDATE alertas_translation SET content = ? WHERE id = ?
Parameters: 
[
  "Intervene before midday, around 1:00 PM. Monitor weekly thermal patterns."
  2412
]
View formatted query    View runnable query    Explain query    View query backtrace
175 2.94 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
176 0.33 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: 
[
  "4badb165-6e9b-4ea6-8183-56251102df2e"
  "2026-07-15"
]
View formatted query    View runnable query    Explain query    View query backtrace
177 0.14 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
178 3.05 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"}"
  "4badb165-6e9b-4ea6-8183-56251102df2e"
  1040
  1024
  1023
]
View formatted query    View runnable query    Explain query    View query backtrace
179 2.42 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\AI\Translation\AlertasTranslation 4
App\Entity\AI\Recomendacion 3
App\Entity\AI\Translation\AiAnalisisTemporalTranslation 2
App\Entity\AI\Translation\AiRecomendacionesTranslation 2
App\Entity\AI\Alertas 2
App\Entity\Oficina 1
App\Entity\User 1
App\Entity\Sensor 1
App\Entity\ApiAiReceive 1
App\Entity\AI\AiAnalisisTemporal 1
App\Entity\AI\AiPredicciones 1
App\Entity\AI\AiRecomendaciones 1
App\Entity\AI\AiReportIndex 1

Entities Mapping

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