Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

93.01 ms Query time

0 Invalid entities

100 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

56.21 ms
(60.43%)

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:49:44"
  "gavray"
]

View formatted query View runnable query Explain query View query backtrace

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) = ?

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 = '2026-01-17 15:49:44' AND LOWER(m0_.zone) = 'gavray';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\MeteoDataRepository->findByDateAndZone (line 23)
7	App\Service\MeteoWidgetService->getMeteoData (line 90)
8	App\Service\MeteoWidgetService->getCurrentWeatherData (line 34)
9	App\Twig\MeteoWidgetExtension->getGlobals (line 22)
10	Twig\ExtensionSet->getGlobals (line 361)
11	Twig\Environment->getGlobals (line 908)
12	Twig\Template->yield (line 398)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	App\Controller\MachineController->index (line 46)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

34.38 ms
(36.97%)

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
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT id FROM meteo_data 
                                WHERE LOWER(zone) = 'gavray' 
                  AND EXTRACT(MONTH FROM date) = 1 
                  AND EXTRACT(DAY FROM date) = 17 
                  AND EXTRACT(HOUR FROM date) = 15 
                ORDER BY date ASC 
                LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 627)
2	App\Repository\MeteoDataRepository->findClosestByDatetimeAndZone (line 52)
3	App\Service\MeteoWidgetService->getMeteoData (line 94)
4	App\Service\MeteoWidgetService->getCurrentWeatherData (line 34)
5	App\Twig\MeteoWidgetExtension->getGlobals (line 22)
6	Twig\ExtensionSet->getGlobals (line 361)
7	Twig\Environment->getGlobals (line 908)
8	Twig\Template->yield (line 398)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
16	App\Controller\MachineController->index (line 46)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

1.71 ms
(1.83%)

SELECT t0.id_machine AS id_machine_1, t0.name AS name_2, t0.type AS type_3, t0.brand AS brand_4, t0.model AS model_5, t0.year_manufactured AS year_manufactured_6, t0.power_hp AS power_hp_7, t0.working_width AS working_width_8, t0.required_power AS required_power_9, t0.can_combine AS can_combine_10, t0.required_building_area AS required_building_area_11, t0.work_time_per_hectare AS work_time_per_hectare_12, t0.preparation_time AS preparation_time_13, t0.operator_required AS operator_required_14, t0.fuel_consumption AS fuel_consumption_15, t0.base_price AS base_price_16, t0.condition_status AS condition_status_17, t0.created_at AS created_at_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.heures_utilisation AS heures_utilisation_21, t0.en_panne AS en_panne_22, t0.immobilisee AS immobilisee_23, t0.type_panne AS type_panne_24, t0.lieu_panne AS lieu_panne_25, t0.cout_reparation AS cout_reparation_26, t0.nombre_pannes AS nombre_pannes_27, t0.dernier_entretien AS dernier_entretien_28, t0.etat AS etat_29, t0.niveau_gnr AS niveau_gnr_30, t0.capacite_gnr AS capacite_gnr_31 FROM machine t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_machine AS id_machine_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.brand AS brand_4,
  t0.model AS model_5,
  t0.year_manufactured AS year_manufactured_6,
  t0.power_hp AS power_hp_7,
  t0.working_width AS working_width_8,
  t0.required_power AS required_power_9,
  t0.can_combine AS can_combine_10,
  t0.required_building_area AS required_building_area_11,
  t0.work_time_per_hectare AS work_time_per_hectare_12,
  t0.preparation_time AS preparation_time_13,
  t0.operator_required AS operator_required_14,
  t0.fuel_consumption AS fuel_consumption_15,
  t0.base_price AS base_price_16,
  t0.condition_status AS condition_status_17,
  t0.created_at AS created_at_18,
  t0.image_name AS image_name_19,
  t0.updated_at AS updated_at_20,
  t0.heures_utilisation AS heures_utilisation_21,
  t0.en_panne AS en_panne_22,
  t0.immobilisee AS immobilisee_23,
  t0.type_panne AS type_panne_24,
  t0.lieu_panne AS lieu_panne_25,
  t0.cout_reparation AS cout_reparation_26,
  t0.nombre_pannes AS nombre_pannes_27,
  t0.dernier_entretien AS dernier_entretien_28,
  t0.etat AS etat_29,
  t0.niveau_gnr AS niveau_gnr_30,
  t0.capacite_gnr AS capacite_gnr_31
FROM
  machine t0

SELECT t0.id_machine AS id_machine_1, t0.name AS name_2, t0.type AS type_3, t0.brand AS brand_4, t0.model AS model_5, t0.year_manufactured AS year_manufactured_6, t0.power_hp AS power_hp_7, t0.working_width AS working_width_8, t0.required_power AS required_power_9, t0.can_combine AS can_combine_10, t0.required_building_area AS required_building_area_11, t0.work_time_per_hectare AS work_time_per_hectare_12, t0.preparation_time AS preparation_time_13, t0.operator_required AS operator_required_14, t0.fuel_consumption AS fuel_consumption_15, t0.base_price AS base_price_16, t0.condition_status AS condition_status_17, t0.created_at AS created_at_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.heures_utilisation AS heures_utilisation_21, t0.en_panne AS en_panne_22, t0.immobilisee AS immobilisee_23, t0.type_panne AS type_panne_24, t0.lieu_panne AS lieu_panne_25, t0.cout_reparation AS cout_reparation_26, t0.nombre_pannes AS nombre_pannes_27, t0.dernier_entretien AS dernier_entretien_28, t0.etat AS etat_29, t0.niveau_gnr AS niveau_gnr_30, t0.capacite_gnr AS capacite_gnr_31 FROM machine t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\MachineController->index (line 27)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.72 ms
(0.77%)

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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 9184;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Repository\MeteoDataRepository->findClosestByDatetimeAndZone (line 63)
7	App\Service\MeteoWidgetService->getMeteoData (line 94)
8	App\Service\MeteoWidgetService->getCurrentWeatherData (line 34)
9	App\Twig\MeteoWidgetExtension->getGlobals (line 22)
10	Twig\ExtensionSet->getGlobals (line 361)
11	Twig\Environment->getGlobals (line 908)
12	Twig\Template->yield (line 398)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	App\Controller\MachineController->index (line 46)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Machine	99
App\Entity\MeteoData	1

Entities Mapping

Class	Mapping errors
App\Entity\Machine	No errors.
App\Entity\MeteoData	No errors.

Symfony Profiler

GET https://agri.seo500france.com/app/machines

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping