Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.77 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.25 ms

SELECT DISTINCT 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, t3_.position AS position_62, t4_.id AS id_63, t4_.icon AS icon_64, t4_.tag AS tag_65, t0_.fournisseur_id AS fournisseur_id_66, t0_.logo_id AS logo_id_67, t0_.image_principal_id AS image_principal_id_68, i1_.terrain_id AS terrain_id_69, i1_.evenement_id AS evenement_id_70, i2_.terrain_id AS terrain_id_71, i2_.evenement_id AS evenement_id_72, t3_.terrain_id AS terrain_id_73, t3_.tag_id AS tag_id_74 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 terrain_tag t3_ ON t0_.id = t3_.terrain_id LEFT JOIN tag t4_ ON t3_.tag_id = t4_.id WHERE t0_.Denprojet IS NOT NULL AND TRIM(t0_.Denprojet) <> '' AND t0_.public_visibility = ? ORDER BY t0_.Denprojet ASC, t3_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT 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,
  t3_.position AS position_62,
  t4_.id AS id_63,
  t4_.icon AS icon_64,
  t4_.tag AS tag_65,
  t0_.fournisseur_id AS fournisseur_id_66,
  t0_.logo_id AS logo_id_67,
  t0_.image_principal_id AS image_principal_id_68,
  i1_.terrain_id AS terrain_id_69,
  i1_.evenement_id AS evenement_id_70,
  i2_.terrain_id AS terrain_id_71,
  i2_.evenement_id AS evenement_id_72,
  t3_.terrain_id AS terrain_id_73,
  t3_.tag_id AS tag_id_74
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 terrain_tag t3_ ON t0_.id = t3_.terrain_id
  LEFT JOIN tag t4_ ON t3_.tag_id = t4_.id
WHERE
  t0_.Denprojet IS NOT NULL
  AND TRIM(t0_.Denprojet) <> ''
  AND t0_.public_visibility = ?
ORDER BY
  t0_.Denprojet ASC,
  t3_.position ASC

SELECT DISTINCT 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, t3_.position AS position_62, t4_.id AS id_63, t4_.icon AS icon_64, t4_.tag AS tag_65, t0_.fournisseur_id AS fournisseur_id_66, t0_.logo_id AS logo_id_67, t0_.image_principal_id AS image_principal_id_68, i1_.terrain_id AS terrain_id_69, i1_.evenement_id AS evenement_id_70, i2_.terrain_id AS terrain_id_71, i2_.evenement_id AS evenement_id_72, t3_.terrain_id AS terrain_id_73, t3_.tag_id AS tag_id_74 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 terrain_tag t3_ ON t0_.id = t3_.terrain_id LEFT JOIN tag t4_ ON t3_.tag_id = t4_.id WHERE t0_.Denprojet IS NOT NULL AND TRIM(t0_.Denprojet) <> '' AND t0_.public_visibility = 1 ORDER BY t0_.Denprojet ASC, t3_.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 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 82)
7	App\Repository\TerrainRepository->findWithDenprojet (line 34)
8	App\Controller\Api\TerrainController->index (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)

1.52 ms

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:

[
  "299"
  "488"
  "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 ('299', '488', '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 35)
3	App\Controller\Api\TerrainController->index (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.

Symfony Profiler

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

Configuration Settings

Theme