Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

5.66 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.29 ms
(40.35%)

SELECT t0_.id AS id_0, t0_.Denprojet AS Denprojet_1, t0_.restap AS restap_2, t0_.idanal AS idanal_3, t0_.codeprojet AS codeprojet_4, t0_.sitjuridique AS sitjuridique_5, t0_.Numtitrs AS Numtitrs_6, t0_.Numregistre AS Numregistre_7, t0_.Numfolio AS Numfolio_8, t0_.sisea AS sisea_9, t0_.fokotany AS fokotany_10, t0_.Commune AS Commune_11, t0_.District AS District_12, t0_.Region AS Region_13, t0_.Nompropriete AS Nompropriete_14, t0_.contenance AS contenance_15, t0_.proprietaire AS proprietaire_16, t0_.Signataire AS Signataire_17, t0_.PersonaPPV AS PersonaPPV_18, t0_.PAterrain AS PAterrain_19, t0_.contrat AS contrat_20, t0_.categorie AS categorie_21, t0_.refarch AS refarch_22, t0_.coordong AS coordong_23, t0_.aventage AS aventage_24, t0_.inconv AS inconv_25, t0_.contenance_av AS contenance_av_26, t0_.piecejoint AS piecejoint_27, t0_.suivie AS suivie_28, t0_.description AS description_29, t0_.coordinates AS coordinates_30, t0_.date AS date_31, t0_.axe AS axe_32, t0_.type AS type_33, t0_.min AS min_34, t0_.max AS max_35, t0_.supmin AS supmin_36, t0_.supmax AS supmax_37, t0_.noted AS noted_38, t0_.budget AS budget_39, t0_.budgets AS budgets_40, t0_.public_visibility AS public_visibility_41, t0_.nextcloud_path AS nextcloud_path_42, t0_.nextcloud_share_url AS nextcloud_share_url_43, i1_.id AS id_44, i1_.original_name AS original_name_45, i1_.source_path AS source_path_46, i1_.path_high AS path_high_47, i1_.path_medium AS path_medium_48, i1_.path_low AS path_low_49, i1_.path_thumbnail AS path_thumbnail_50, i1_.mime_type AS mime_type_51, i1_.created_at AS created_at_52, i2_.id AS id_53, i2_.original_name AS original_name_54, i2_.source_path AS source_path_55, i2_.path_high AS path_high_56, i2_.path_medium AS path_medium_57, i2_.path_low AS path_low_58, i2_.path_thumbnail AS path_thumbnail_59, i2_.mime_type AS mime_type_60, i2_.created_at AS created_at_61, i3_.id AS id_62, i3_.original_name AS original_name_63, i3_.source_path AS source_path_64, i3_.path_high AS path_high_65, i3_.path_medium AS path_medium_66, i3_.path_low AS path_low_67, i3_.path_thumbnail AS path_thumbnail_68, i3_.mime_type AS mime_type_69, i3_.created_at AS created_at_70, t4_.position AS position_71, t5_.id AS id_72, t5_.icon AS icon_73, t5_.tag AS tag_74, t0_.fournisseur_id AS fournisseur_id_75, t0_.logo_id AS logo_id_76, t0_.image_principal_id AS image_principal_id_77, i1_.terrain_id AS terrain_id_78, i1_.evenement_id AS evenement_id_79, i2_.terrain_id AS terrain_id_80, i2_.evenement_id AS evenement_id_81, i3_.terrain_id AS terrain_id_82, i3_.evenement_id AS evenement_id_83, t4_.terrain_id AS terrain_id_84, t4_.tag_id AS tag_id_85 FROM terrain t0_ LEFT JOIN images i1_ ON t0_.image_principal_id = i1_.id LEFT JOIN images i2_ ON t0_.logo_id = i2_.id LEFT JOIN images i3_ ON t0_.id = i3_.terrain_id LEFT JOIN terrain_tag t4_ ON t0_.id = t4_.terrain_id LEFT JOIN tag t5_ ON t4_.tag_id = t5_.id WHERE t0_.id = ? AND t0_.public_visibility = ? ORDER BY t4_.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.Denprojet AS Denprojet_1,
  t0_.restap AS restap_2,
  t0_.idanal AS idanal_3,
  t0_.codeprojet AS codeprojet_4,
  t0_.sitjuridique AS sitjuridique_5,
  t0_.Numtitrs AS Numtitrs_6,
  t0_.Numregistre AS Numregistre_7,
  t0_.Numfolio AS Numfolio_8,
  t0_.sisea AS sisea_9,
  t0_.fokotany AS fokotany_10,
  t0_.Commune AS Commune_11,
  t0_.District AS District_12,
  t0_.Region AS Region_13,
  t0_.Nompropriete AS Nompropriete_14,
  t0_.contenance AS contenance_15,
  t0_.proprietaire AS proprietaire_16,
  t0_.Signataire AS Signataire_17,
  t0_.PersonaPPV AS PersonaPPV_18,
  t0_.PAterrain AS PAterrain_19,
  t0_.contrat AS contrat_20,
  t0_.categorie AS categorie_21,
  t0_.refarch AS refarch_22,
  t0_.coordong AS coordong_23,
  t0_.aventage AS aventage_24,
  t0_.inconv AS inconv_25,
  t0_.contenance_av AS contenance_av_26,
  t0_.piecejoint AS piecejoint_27,
  t0_.suivie AS suivie_28,
  t0_.description AS description_29,
  t0_.coordinates AS coordinates_30,
  t0_.date AS date_31,
  t0_.axe AS axe_32,
  t0_.type AS type_33,
  t0_.min AS min_34,
  t0_.max AS max_35,
  t0_.supmin AS supmin_36,
  t0_.supmax AS supmax_37,
  t0_.noted AS noted_38,
  t0_.budget AS budget_39,
  t0_.budgets AS budgets_40,
  t0_.public_visibility AS public_visibility_41,
  t0_.nextcloud_path AS nextcloud_path_42,
  t0_.nextcloud_share_url AS nextcloud_share_url_43,
  i1_.id AS id_44,
  i1_.original_name AS original_name_45,
  i1_.source_path AS source_path_46,
  i1_.path_high AS path_high_47,
  i1_.path_medium AS path_medium_48,
  i1_.path_low AS path_low_49,
  i1_.path_thumbnail AS path_thumbnail_50,
  i1_.mime_type AS mime_type_51,
  i1_.created_at AS created_at_52,
  i2_.id AS id_53,
  i2_.original_name AS original_name_54,
  i2_.source_path AS source_path_55,
  i2_.path_high AS path_high_56,
  i2_.path_medium AS path_medium_57,
  i2_.path_low AS path_low_58,
  i2_.path_thumbnail AS path_thumbnail_59,
  i2_.mime_type AS mime_type_60,
  i2_.created_at AS created_at_61,
  i3_.id AS id_62,
  i3_.original_name AS original_name_63,
  i3_.source_path AS source_path_64,
  i3_.path_high AS path_high_65,
  i3_.path_medium AS path_medium_66,
  i3_.path_low AS path_low_67,
  i3_.path_thumbnail AS path_thumbnail_68,
  i3_.mime_type AS mime_type_69,
  i3_.created_at AS created_at_70,
  t4_.position AS position_71,
  t5_.id AS id_72,
  t5_.icon AS icon_73,
  t5_.tag AS tag_74,
  t0_.fournisseur_id AS fournisseur_id_75,
  t0_.logo_id AS logo_id_76,
  t0_.image_principal_id AS image_principal_id_77,
  i1_.terrain_id AS terrain_id_78,
  i1_.evenement_id AS evenement_id_79,
  i2_.terrain_id AS terrain_id_80,
  i2_.evenement_id AS evenement_id_81,
  i3_.terrain_id AS terrain_id_82,
  i3_.evenement_id AS evenement_id_83,
  t4_.terrain_id AS terrain_id_84,
  t4_.tag_id AS tag_id_85
FROM
  terrain t0_
  LEFT JOIN images i1_ ON t0_.image_principal_id = i1_.id
  LEFT JOIN images i2_ ON t0_.logo_id = i2_.id
  LEFT JOIN images i3_ ON t0_.id = i3_.terrain_id
  LEFT JOIN terrain_tag t4_ ON t0_.id = t4_.terrain_id
  LEFT JOIN tag t5_ ON t4_.tag_id = t5_.id
WHERE
  t0_.id = ?
  AND t0_.public_visibility = ?
ORDER BY
  t4_.position ASC

SELECT t0_.id AS id_0, t0_.Denprojet AS Denprojet_1, t0_.restap AS restap_2, t0_.idanal AS idanal_3, t0_.codeprojet AS codeprojet_4, t0_.sitjuridique AS sitjuridique_5, t0_.Numtitrs AS Numtitrs_6, t0_.Numregistre AS Numregistre_7, t0_.Numfolio AS Numfolio_8, t0_.sisea AS sisea_9, t0_.fokotany AS fokotany_10, t0_.Commune AS Commune_11, t0_.District AS District_12, t0_.Region AS Region_13, t0_.Nompropriete AS Nompropriete_14, t0_.contenance AS contenance_15, t0_.proprietaire AS proprietaire_16, t0_.Signataire AS Signataire_17, t0_.PersonaPPV AS PersonaPPV_18, t0_.PAterrain AS PAterrain_19, t0_.contrat AS contrat_20, t0_.categorie AS categorie_21, t0_.refarch AS refarch_22, t0_.coordong AS coordong_23, t0_.aventage AS aventage_24, t0_.inconv AS inconv_25, t0_.contenance_av AS contenance_av_26, t0_.piecejoint AS piecejoint_27, t0_.suivie AS suivie_28, t0_.description AS description_29, t0_.coordinates AS coordinates_30, t0_.date AS date_31, t0_.axe AS axe_32, t0_.type AS type_33, t0_.min AS min_34, t0_.max AS max_35, t0_.supmin AS supmin_36, t0_.supmax AS supmax_37, t0_.noted AS noted_38, t0_.budget AS budget_39, t0_.budgets AS budgets_40, t0_.public_visibility AS public_visibility_41, t0_.nextcloud_path AS nextcloud_path_42, t0_.nextcloud_share_url AS nextcloud_share_url_43, i1_.id AS id_44, i1_.original_name AS original_name_45, i1_.source_path AS source_path_46, i1_.path_high AS path_high_47, i1_.path_medium AS path_medium_48, i1_.path_low AS path_low_49, i1_.path_thumbnail AS path_thumbnail_50, i1_.mime_type AS mime_type_51, i1_.created_at AS created_at_52, i2_.id AS id_53, i2_.original_name AS original_name_54, i2_.source_path AS source_path_55, i2_.path_high AS path_high_56, i2_.path_medium AS path_medium_57, i2_.path_low AS path_low_58, i2_.path_thumbnail AS path_thumbnail_59, i2_.mime_type AS mime_type_60, i2_.created_at AS created_at_61, i3_.id AS id_62, i3_.original_name AS original_name_63, i3_.source_path AS source_path_64, i3_.path_high AS path_high_65, i3_.path_medium AS path_medium_66, i3_.path_low AS path_low_67, i3_.path_thumbnail AS path_thumbnail_68, i3_.mime_type AS mime_type_69, i3_.created_at AS created_at_70, t4_.position AS position_71, t5_.id AS id_72, t5_.icon AS icon_73, t5_.tag AS tag_74, t0_.fournisseur_id AS fournisseur_id_75, t0_.logo_id AS logo_id_76, t0_.image_principal_id AS image_principal_id_77, i1_.terrain_id AS terrain_id_78, i1_.evenement_id AS evenement_id_79, i2_.terrain_id AS terrain_id_80, i2_.evenement_id AS evenement_id_81, i3_.terrain_id AS terrain_id_82, i3_.evenement_id AS evenement_id_83, t4_.terrain_id AS terrain_id_84, t4_.tag_id AS tag_id_85 FROM terrain t0_ LEFT JOIN images i1_ ON t0_.image_principal_id = i1_.id LEFT JOIN images i2_ ON t0_.logo_id = i2_.id LEFT JOIN images i3_ ON t0_.id = i3_.terrain_id LEFT JOIN terrain_tag t4_ ON t0_.id = t4_.terrain_id LEFT JOIN tag t5_ ON t4_.tag_id = t5_.id WHERE t0_.id = 358 AND t0_.public_visibility = 1 ORDER BY t4_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 102)
7	App\Repository\TerrainRepository->findOneForCmsDetail (line 48)
8	App\Controller\Api\TerrainController->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.15 ms
(37.93%)

SELECT t0.id AS id_1, t0.idTerrain AS idTerrain_2, t0.NomenVente AS NomenVente_3, t0.ContenanceP AS ContenanceP_4, t0.Pvmin AS Pvmin_5, t0.PVoff AS PVoff_6, t0.Echeanmax AS Echeanmax_7, t0.prixm AS prixm_8, t0.StatutP AS StatutP_9, t0.idClient AS idClient_10, t0.enable AS enable_11, t0.pjt AS pjt_12, t0.mutation_id AS mutation_id_13 FROM partiel t0 WHERE t0.idTerrain = ?

Parameters:

[
  "358"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idTerrain AS idTerrain_2,
  t0.NomenVente AS NomenVente_3,
  t0.ContenanceP AS ContenanceP_4,
  t0.Pvmin AS Pvmin_5,
  t0.PVoff AS PVoff_6,
  t0.Echeanmax AS Echeanmax_7,
  t0.prixm AS prixm_8,
  t0.StatutP AS StatutP_9,
  t0.idClient AS idClient_10,
  t0.enable AS enable_11,
  t0.pjt AS pjt_12,
  t0.mutation_id AS mutation_id_13
FROM
  partiel t0
WHERE
  t0.idTerrain = ?

SELECT t0.id AS id_1, t0.idTerrain AS idTerrain_2, t0.NomenVente AS NomenVente_3, t0.ContenanceP AS ContenanceP_4, t0.Pvmin AS Pvmin_5, t0.PVoff AS PVoff_6, t0.Echeanmax AS Echeanmax_7, t0.prixm AS prixm_8, t0.StatutP AS StatutP_9, t0.idClient AS idClient_10, t0.enable AS enable_11, t0.pjt AS pjt_12, t0.mutation_id AS mutation_id_13 FROM partiel t0 WHERE t0.idTerrain = '358';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 103)
4	App\Service\TerrainPlanService->getLotsForTerrain (line 54)
5	App\Service\TerrainPlanService->getPlanPayloadForTerrain (line 87)
6	App\Controller\Api\TerrainController->serializeTerrainDetail (line 55)
7	App\Controller\Api\TerrainController->show (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.23 ms
(21.71%)

SELECT p.idTerrain AS terrain_id, p.StatutP AS statut, COUNT(*) AS cnt
FROM partiel p
WHERE p.idTerrain IN (?)
  AND p.enable = 1
GROUP BY p.idTerrain, p.StatutP

Parameters:

[
  "358"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.idTerrain AS terrain_id,
  p.StatutP AS statut,
  COUNT(*) AS cnt
FROM
  partiel p
WHERE
  p.idTerrain IN (?)
  AND p.enable = 1
GROUP BY
  p.idTerrain,
  p.StatutP

SELECT p.idTerrain AS terrain_id, p.StatutP AS statut, COUNT(*) AS cnt
FROM partiel p
WHERE p.idTerrain IN ('358')
  AND p.enable = 1
GROUP BY p.idTerrain, p.StatutP;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 75)
2	App\Repository\PartielRepository->getParcelleStatusCountsForTerrains (line 53)
3	App\Controller\Api\TerrainController->show (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	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\Terrain	The association App\Entity\Terrain#fournisseur refers to the inverse side field App\Entity\Fournisseur#terrains which does not exist.
App\Entity\Image	No errors.
App\Entity\TerrainTag	No errors.
App\Entity\Tag	No errors.
App\Entity\Fournisseur	No errors.
App\Entity\Evenement	No errors.
App\Entity\ImageTerrain	No errors.
App\Entity\PropositionOffre	No errors.
App\Entity\SourceTerrain	No errors.
App\Entity\Contract	The field 'App\Entity\Contract#amount' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Promesse	The field App\Entity\Promesse#negociations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Negociation#compromis does not contain the required 'inversedBy="negociations"' attribute.
App\Entity\Reservation	No errors.
App\Entity\Decaissement	No errors.
App\Entity\Terrassement	No errors.
App\Entity\CaisseCompte	No errors.
App\Entity\Mutation	No errors.
App\Entity\Partiel	No errors.
App\Entity\BudgetTechnique	No errors.
App\Entity\Listlot	No errors.

Symfony Profiler

GET https://app.master-immo.net/api/terrains/358

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping