GET https://agri.seo500france.com/parcelle

Query Metrics

3 Database Queries
3 Different statements
106.64 ms Query time
0 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

Time Count Info
55.43 ms
(51.98%)
1
SELECT m0_.id AS id_0, m0_.date AS date_1, m0_.temperature AS temperature_2, m0_.feels_like AS feels_like_3, m0_.humidity AS humidity_4, m0_.wind_speed AS wind_speed_5, m0_.wind_direction AS wind_direction_6, m0_.pressure AS pressure_7, m0_.precipitation_type AS precipitation_type_8, m0_.weather AS weather_9, m0_.summary AS summary_10, m0_.cloud_cover AS cloud_cover_11, m0_.zone AS zone_12 FROM meteo_data m0_ WHERE m0_.date = ? AND LOWER(m0_.zone) = ?
Parameters:
[
  "2026-01-17 15:48:33"
  "gavray"
]
50.63 ms
(47.48%)
1
SELECT id FROM meteo_data 
                                WHERE LOWER(zone) = ? 
                  AND EXTRACT(MONTH FROM date) = ? 
                  AND EXTRACT(DAY FROM date) = ? 
                  AND EXTRACT(HOUR FROM date) = ? 
                ORDER BY date ASC 
                LIMIT 1
Parameters:
[
  "gavray"
  1
  17
  15
]
0.57 ms
(0.54%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.temperature AS temperature_3, t0.feels_like AS feels_like_4, t0.humidity AS humidity_5, t0.wind_speed AS wind_speed_6, t0.wind_direction AS wind_direction_7, t0.pressure AS pressure_8, t0.precipitation_type AS precipitation_type_9, t0.weather AS weather_10, t0.summary AS summary_11, t0.cloud_cover AS cloud_cover_12, t0.zone AS zone_13 FROM meteo_data t0 WHERE t0.id = ?
Parameters:
[
  9184
]

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\MeteoData 1

Entities Mapping

Class Mapping errors
App\Entity\MeteoData No errors.