Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

14.01 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.03 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.reset_token AS reset_token_5, t0.is_active AS is_active_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.function AS function_9, t0.type_certiphyto AS type_certiphyto_10, t0.validite_certiphyto AS validite_certiphyto_11, t0.mobile AS mobile_12, t0.phone AS phone_13, t0.num_certiphyto AS num_certiphyto_14, t0.stades_pheno AS stades_pheno_15, t0.p_tordeuses AS p_tordeuses_16, t0.movida AS movida_17, t0.grp_30k AS grp_30k_18, t0.is_admin AS is_admin_19 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.reset_token AS reset_token_5,
  t0.is_active AS is_active_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.function AS function_9,
  t0.type_certiphyto AS type_certiphyto_10,
  t0.validite_certiphyto AS validite_certiphyto_11,
  t0.mobile AS mobile_12,
  t0.phone AS phone_13,
  t0.num_certiphyto AS num_certiphyto_14,
  t0.stades_pheno AS stades_pheno_15,
  t0.p_tordeuses AS p_tordeuses_16,
  t0.movida AS movida_17,
  t0.grp_30k AS grp_30k_18,
  t0.is_admin AS is_admin_19
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.reset_token AS reset_token_5, t0.is_active AS is_active_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.function AS function_9, t0.type_certiphyto AS type_certiphyto_10, t0.validite_certiphyto AS validite_certiphyto_11, t0.mobile AS mobile_12, t0.phone AS phone_13, t0.num_certiphyto AS num_certiphyto_14, t0.stades_pheno AS stades_pheno_15, t0.p_tordeuses AS p_tordeuses_16, t0.movida AS movida_17, t0.grp_30k AS grp_30k_18, t0.is_admin AS is_admin_19 FROM `user` t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 300)
6	App\Controller\Api\ObservationsController->syncObservation (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.69 ms

SELECT t0.id AS id_1, t0.property_name AS property_name_2, t0.commune AS commune_3, t0.surface_totale AS surface_totale_4, t0.contract_name AS contract_name_5, t0.adresse_1 AS adresse_1_6, t0.adresse_2 AS adresse_2_7, t0.code_postal AS code_postal_8, t0.departement_id AS departement_id_9, t0.main_consultant_id AS main_consultant_id_10 FROM property t0 WHERE t0.id = ?

Parameters:

[
  346
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.property_name AS property_name_2,
  t0.commune AS commune_3,
  t0.surface_totale AS surface_totale_4,
  t0.contract_name AS contract_name_5,
  t0.adresse_1 AS adresse_1_6,
  t0.adresse_2 AS adresse_2_7,
  t0.code_postal AS code_postal_8,
  t0.departement_id AS departement_id_9,
  t0.main_consultant_id AS main_consultant_id_10
FROM
  property t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.property_name AS property_name_2, t0.commune AS commune_3, t0.surface_totale AS surface_totale_4, t0.contract_name AS contract_name_5, t0.adresse_1 AS adresse_1_6, t0.adresse_2 AS adresse_2_7, t0.code_postal AS code_postal_8, t0.departement_id AS departement_id_9, t0.main_consultant_id AS main_consultant_id_10 FROM property t0 WHERE t0.id = 346;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 306)
6	App\Controller\Api\ObservationsController->syncObservation (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

11.00 ms

SELECT t0.id AS id_1, t0.date_visite AS date_visite_2, t0.uuid AS uuid_3, t0.client_uuid AS client_uuid_4, t0.commentaire AS commentaire_5, t0.main_consultant AS main_consultant_6, t0.property_id AS property_id_7 FROM visite t0 WHERE t0.client_uuid = ? LIMIT 1

Parameters:

[
  "2be7d7d0-99e3-4c89-9444-d9db96fba557"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_visite AS date_visite_2,
  t0.uuid AS uuid_3,
  t0.client_uuid AS client_uuid_4,
  t0.commentaire AS commentaire_5,
  t0.main_consultant AS main_consultant_6,
  t0.property_id AS property_id_7
FROM
  visite t0
WHERE
  t0.client_uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_visite AS date_visite_2, t0.uuid AS uuid_3, t0.client_uuid AS client_uuid_4, t0.commentaire AS commentaire_5, t0.main_consultant AS main_consultant_6, t0.property_id AS property_id_7 FROM visite t0 WHERE t0.client_uuid = '2be7d7d0-99e3-4c89-9444-d9db96fba557' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 312)
4	App\Controller\Api\ObservationsController->syncObservation (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

1.28 ms

SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.ilot AS ilot_3, t0.parcelle AS parcelle_4, t0.stade_r_1 AS stade_r_1_5, t0.stade_r_2 AS stade_r_2_6, t0.mi_f AS mi_f_7, t0.mi_g AS mi_g_8, t0.br_f AS br_f_9, t0.br_g AS br_g_10, t0.oi_f AS oi_f_11, t0.oi_g AS oi_g_12, t0.pg_f AS pg_f_13, t0.pg_g AS pg_g_14, t0.maladie_bois AS maladie_bois_15, t0.note_mdb AS note_mdb_16, t0.cic_v AS cic_v_17, t0.cic_fd AS cic_fd_18, t0.vdg_glom AS vdg_glom_19, t0.vdg_perfos AS vdg_perfos_20, t0.carences AS carences_21, t0.note_carence AS note_carence_22, t0.commentaire AS commentaire_23, t0.notation AS notation_24, t0.created_by AS created_by_25, t0.last_update AS last_update_26, t0.last_updater AS last_updater_27, t0.vdg_ponte AS vdg_ponte_28, t0.uuid AS uuid_29, t0.client_uuid AS client_uuid_30, t0.property_id AS property_id_31, t0.visite_id AS visite_id_32 FROM observation t0 WHERE t0.client_uuid = ? AND t0.visite_id = ? AND t0.property_id = ? LIMIT 1

Parameters:

[
  "37ad7d19-a0dd-4c43-9df3-cb43b4f0b6b7"
  8300
  346
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.secteur AS secteur_2,
  t0.ilot AS ilot_3,
  t0.parcelle AS parcelle_4,
  t0.stade_r_1 AS stade_r_1_5,
  t0.stade_r_2 AS stade_r_2_6,
  t0.mi_f AS mi_f_7,
  t0.mi_g AS mi_g_8,
  t0.br_f AS br_f_9,
  t0.br_g AS br_g_10,
  t0.oi_f AS oi_f_11,
  t0.oi_g AS oi_g_12,
  t0.pg_f AS pg_f_13,
  t0.pg_g AS pg_g_14,
  t0.maladie_bois AS maladie_bois_15,
  t0.note_mdb AS note_mdb_16,
  t0.cic_v AS cic_v_17,
  t0.cic_fd AS cic_fd_18,
  t0.vdg_glom AS vdg_glom_19,
  t0.vdg_perfos AS vdg_perfos_20,
  t0.carences AS carences_21,
  t0.note_carence AS note_carence_22,
  t0.commentaire AS commentaire_23,
  t0.notation AS notation_24,
  t0.created_by AS created_by_25,
  t0.last_update AS last_update_26,
  t0.last_updater AS last_updater_27,
  t0.vdg_ponte AS vdg_ponte_28,
  t0.uuid AS uuid_29,
  t0.client_uuid AS client_uuid_30,
  t0.property_id AS property_id_31,
  t0.visite_id AS visite_id_32
FROM
  observation t0
WHERE
  t0.client_uuid = ?
  AND t0.visite_id = ?
  AND t0.property_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.ilot AS ilot_3, t0.parcelle AS parcelle_4, t0.stade_r_1 AS stade_r_1_5, t0.stade_r_2 AS stade_r_2_6, t0.mi_f AS mi_f_7, t0.mi_g AS mi_g_8, t0.br_f AS br_f_9, t0.br_g AS br_g_10, t0.oi_f AS oi_f_11, t0.oi_g AS oi_g_12, t0.pg_f AS pg_f_13, t0.pg_g AS pg_g_14, t0.maladie_bois AS maladie_bois_15, t0.note_mdb AS note_mdb_16, t0.cic_v AS cic_v_17, t0.cic_fd AS cic_fd_18, t0.vdg_glom AS vdg_glom_19, t0.vdg_perfos AS vdg_perfos_20, t0.carences AS carences_21, t0.note_carence AS note_carence_22, t0.commentaire AS commentaire_23, t0.notation AS notation_24, t0.created_by AS created_by_25, t0.last_update AS last_update_26, t0.last_updater AS last_updater_27, t0.vdg_ponte AS vdg_ponte_28, t0.uuid AS uuid_29, t0.client_uuid AS client_uuid_30, t0.property_id AS property_id_31, t0.visite_id AS visite_id_32 FROM observation t0 WHERE t0.client_uuid = '37ad7d19-a0dd-4c43-9df3-cb43b4f0b6b7' AND t0.visite_id = 8300 AND t0.property_id = 346 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 326)
4	App\Controller\Api\ObservationsController->syncObservation (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserInfo\TypeInterlocuteur	No errors.
App\Entity\UserInfo\TypeInvitation	No errors.
App\Entity\UserInfo\TypeSpecification	No errors.
App\Entity\Properties\Property	No errors.
App\Entity\PreconisationActualisee\Param\PrecoComplementInformations	No errors.
App\Entity\PreconisationActualisee\Param\PrecoContexteSanitaire	No errors.
App\Entity\PreconisationActualisee\Param\PrecoPreconisationRapide	No errors.
App\Entity\PreconisationActualisee\Param\PrecoRegroupementProprietes	No errors.
App\Entity\PreconisationActualisee\Param\PrecoTypeTraitement	No errors.
App\Entity\PreconisationActualisee\PreconisationSaison	No errors.
App\Entity\PreconisationActualisee\Param\PrecoMail	No errors.
App\Entity\Param\Departement	No errors.
App\Entity\Properties\Secteur	No errors.
App\Entity\Properties\Ilot	No errors.
App\Entity\Properties\Parcelle	No errors.
App\Entity\Calendrier\Calendrier	No errors.
App\Entity\PreconisationActualisee\PreconisationActualisee	No errors.
App\Entity\Observations\Observation	No errors.
App\Entity\Properties\CatSurface	No errors.
App\Entity\Basagri\Ref\BasagriCulture	No errors.
App\Entity\Properties\Cepage	No errors.
App\Entity\Observations\Visite	No errors.

Symfony Profiler

POST https://proviter.fr/api/sync_observation

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping