Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.09 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.09 ms	SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.sequence AS sequence_2, h0_.panorama_v2_id AS panorama_v2_id_3, h0_.night_panorama_v2_id AS night_panorama_v2_id_4, h0_.house_id AS house_id_5 FROM house_panorama_v2_view h0_ WHERE h0_.house_id = ? ORDER BY h0_.id ASC Parameters: [`"108"`] View formatted query View runnable query Explain query SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.sequence AS sequence_2, h0_.panorama_v2_id AS panorama_v2_id_3, h0_.night_panorama_v2_id AS night_panorama_v2_id_4, h0_.house_id AS house_id_5 FROM house_panorama_v2_view h0_ WHERE h0_.house_id = ? ORDER BY h0_.id ASC SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.sequence AS sequence_2, h0_.panorama_v2_id AS panorama_v2_id_3, h0_.night_panorama_v2_id AS night_panorama_v2_id_4, h0_.house_id AS house_id_5 FROM house_panorama_v2_view h0_ WHERE h0_.house_id = '108' ORDER BY h0_.id ASC;

#▲

Time

Info

0.09 ms

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.sequence AS sequence_2, h0_.panorama_v2_id AS panorama_v2_id_3, h0_.night_panorama_v2_id AS night_panorama_v2_id_4, h0_.house_id AS house_id_5 FROM house_panorama_v2_view h0_ WHERE h0_.house_id = ? ORDER BY h0_.id ASC

Parameters:

[
  "108"
]

View formatted query View runnable query Explain query

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.sequence AS sequence_2,
  h0_.panorama_v2_id AS panorama_v2_id_3,
  h0_.night_panorama_v2_id AS night_panorama_v2_id_4,
  h0_.house_id AS house_id_5
FROM
  house_panorama_v2_view h0_
WHERE
  h0_.house_id = ?
ORDER BY
  h0_.id ASC

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.sequence AS sequence_2, h0_.panorama_v2_id AS panorama_v2_id_3, h0_.night_panorama_v2_id AS night_panorama_v2_id_4, h0_.house_id AS house_id_5 FROM house_panorama_v2_view h0_ WHERE h0_.house_id = '108' ORDER BY h0_.id ASC;

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\HousePanoramaV2View	No errors.
App\Entity\House	No errors.
App\Entity\PanoramaV2	No errors.
App\Entity\Complex	The mappings App\Entity\Complex#placementProperties and App\Entity\PlacementProperty#complex are inconsistent with each other.
App\Entity\UriManager	No errors.
App\Entity\Developer	No errors.
App\Entity\BitrixProject	No errors.
App\Entity\BitrixCategory	No errors.
App\Entity\BitrixStage	No errors.
App\Entity\BitrixDeal	No errors.
App\Entity\BitrixDealClient	No errors.
App\Entity\User	No errors.
App\Entity\UserRoles	No errors.
App\Entity\ApiToken	No errors.
App\Entity\NetHunt\NetHuntFunnelOpportunity	No errors.
App\Entity\NetHunt\NetHuntFunnel	No errors.
App\Entity\NetHunt\NetHuntIntegration	No errors.
App\Entity\NetHunt\NetHuntFunnelStage	No errors.
App\Entity\PlacementStatus	No errors.
App\Entity\NetHunt\NetHuntOnEmptyOpportunitiesPlacementStatus	No errors.
App\Entity\NetHunt\NetHuntOpportunityPlacementMapping	No errors.
App\Entity\Placement	No errors.
App\Entity\HouseSpinnerV2View	No errors.
App\Entity\SpinnerV2	No errors.
App\Entity\HouseExcelImportHistory	No errors.
App\Entity\Section	No errors.
App\Entity\Floor	No errors.
App\Entity\SectionPanoramaV2View	No errors.
App\Entity\SectionSpinnerV2View	No errors.
App\Entity\PlacementType	No errors.
App\Entity\ViewType	No errors.
App\Entity\PlacementPageSetup	No errors.
App\Entity\PpsHeaderSection	No errors.
App\Entity\PpsCallToAction	No errors.
App\Entity\PpsUnitPageRedirect	No errors.
App\Entity\PlacementProperty	The association App\Entity\PlacementProperty#complex refers to the inverse side field App\Entity\Complex#placementPropertiesApplyFilterSection which does not exist.
App\Entity\Placement\Pdf\PaymentPlan\UnitInfo\UnitInfo	No errors.
App\Entity\Placement\Pdf\PaymentPlan\UnitInfo\SystemValueInfo	No errors.
App\Entity\Placement\Pdf\PaymentPlan\PaymentPlan	No errors.
App\Entity\Placement\Pdf\PaymentPlan\Note\Note	No errors.
App\Entity\Placement\Pdf\PaymentPlan\Config\Config	No errors.
App\Entity\Placement\Pdf\PaymentPlan\Config\Group\Group	No errors.
App\Entity\Placement\Pdf\PaymentPlan\Config\Group\Payment\Payment	No errors.
App\Entity\PpsPropertySetting	No errors.
App\Entity\PpsPropertySettingsGroup	No errors.
App\Entity\PpsDescriptionSectionPropertySettingsGroup	No errors.
App\Entity\PpsDescriptionSection	No errors.
App\Entity\FileUri	No errors.
App\Entity\ApplicationProperty	No errors.
App\Entity\PpsUtilityButton	No errors.
App\Entity\PlacementType\FrontConfig	No errors.
App\Entity\PlacementType\FrontConfig\FrontType	No errors.
App\Entity\PlacementType\FrontConfig\FrontType\View	No errors.
App\Entity\CreatioOpportunity	No errors.
App\Entity\CreatioProject	No errors.
App\Entity\CreatioStage	No errors.
App\Entity\CreatioFormConfiguration	No errors.
App\Entity\CreatioFormConfigurationMessage	No errors.
App\Entity\CreatioRequestLog	No errors.
App\Entity\CreatioOpportunityPlacementFieldsMatch	No errors.
App\Entity\PlacementExplication	No errors.
App\Entity\PlacementExplicationName	No errors.
App\Entity\PlacementAdditionalAdvantage	No errors.
App\Entity\BitrixCategoryPlacementStatusOnZeroDeals	No errors.
App\Entity\BitrixDealPlacementFieldsLinking	No errors.
App\Entity\BitrixFormConfiguration	No errors.
App\Entity\BitrixFormConfigurationTimeline	No errors.
App\Entity\Bitrix\FrontConfig	No errors.
App\Entity\Bitrix\FrontConfig\DealConfig	No errors.
App\Entity\ComplexPanoramaV2View	No errors.
App\Entity\ComplexSpinnerV2View	No errors.
App\Entity\TranslateAttribute	No errors.
App\Entity\ClientModuleConfig	No errors.
App\Entity\ClientModuleAccessUrl	No errors.
App\Entity\ClientModuleEmail	No errors.
App\Entity\ClientModuleEmbeddedContactForm	No errors.
App\Entity\ClientModuleGoogleTagManager	No errors.
App\Entity\ClientModuleLogos	No errors.
App\Entity\ClientModuleMenu	No errors.
App\Entity\PanoramaGroup	No errors.
App\Entity\Panorama	No errors.
App\Entity\PlacementPdfConfig	No errors.
App\Entity\PlacementPdfConfigNote	No errors.
App\Entity\PlacementPdfConfigPhone	No errors.
App\Entity\PlacementPdfConfigPlacementData	No errors.
App\Entity\PolygonGlobalConfig	No errors.
App\Entity\CrosstableDisplayPlacementDataConfig	No errors.
App\Entity\ClientModulePhones	No errors.
App\Entity\InfrastructureFilterSingleElement	No errors.
App\Entity\InfrastructureGroup	No errors.
App\Entity\InfrastructureGroupsSetsMtm	No errors.
App\Entity\InfrastructureSet	No errors.
App\Entity\InfrastructureLink	No errors.
App\Entity\Infrastructure	No errors.
App\Entity\ClientModuleByAttributesContactForm	No errors.
App\Entity\ClientModuleOuterEmbeddedJs	No errors.
App\Entity\ClientModulePanoramaConfig	No errors.
App\Entity\ClientModuleStandardContactForm	No errors.
App\Entity\Complex\FrontConfig	No errors.
App\Entity\Complex\FrontConfig\FrontType	No errors.
App\Entity\Complex\FrontConfig\Pdf\Ordering\Ordering	No errors.
App\Entity\ClosestWindowsOverviews	No errors.

Symfony Profiler

https://pro-api-dev.flat.show/api/house_panorama_v2_views?house=108&pagination=false

Configuration Settings

Theme