Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

6.70 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.84 ms
(27.51%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 480)
3	Doctrine\ORM\EntityManager->flush (line 414)
4	App\Controller\PropertyController->editLock (line 516)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 208)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.37 ms
(20.45%)

SELECT t0.id AS id_1, t0.revision AS revision_2, t0.public_id AS public_id_3, t0.offer_type AS offer_type_4, t0.sell_price AS sell_price_5, t0.rent_price AS rent_price_6, t0.publishing_status AS publishing_status_7, t0.apartments_count AS apartments_count_8, t0.rooms_count AS rooms_count_9, t0.bathrooms_count AS bathrooms_count_10, t0.floor AS floor_11, t0.floors_count AS floors_count_12, t0.living_area AS living_area_13, t0.land_area AS land_area_14, t0.usable_area AS usable_area_15, t0.ceiling_height AS ceiling_height_16, t0.year_built AS year_built_17, t0.last_renovation AS last_renovation_18, t0.calendly_url AS calendly_url_19, t0.tour_first_date_delay AS tour_first_date_delay_20, t0.tour_week_days AS tour_week_days_21, t0.waiting_list_active AS waiting_list_active_22, t0.favourite_richard AS favourite_richard_23, t0.location_optimiser_active AS location_optimiser_active_24, t0.video AS video_25, t0.video2 AS video2_26, t0.virtual_tour AS virtual_tour_27, t0.title AS title_28, t0.description_results AS description_results_29, t0.description_detail_view AS description_detail_view_30, t0.benefits AS benefits_31, t0.description_external_portals AS description_external_portals_32, t0.property_id AS property_id_33, t0.wordpress_export_active AS wordpress_export_active_34, t0.wordpress_exported_revision AS wordpress_exported_revision_35, t0.wordpress_page_url AS wordpress_page_url_36, t0.wordpress_post_id AS wordpress_post_id_37, t0.main_language AS main_language_38, t0.draft_at AS draft_at_39, t0.paused_at AS paused_at_40, t0.archived_at AS archived_at_41, t0.on_air_at AS on_air_at_42, t0.reserved_at AS reserved_at_43, t0.sold_or_rented_at AS sold_or_rented_at_44, t0.automatic_translation_disabled AS automatic_translation_disabled_45, t0.automatic_translated AS automatic_translated_46, t0.first_published_at AS first_published_at_47, t0.edit_lock_until AS edit_lock_until_48, t0.forced_publishing_phases AS forced_publishing_phases_49, t0.disallowed_publishing_phases AS disallowed_publishing_phases_50, t0.created_at AS created_at_51, t0.updated_at AS updated_at_52, t0.category_id AS category_id_53, t0.object_type_id AS object_type_id_54, t0.agent_id AS agent_id_55, t0.address_id AS address_id_56, t0.cloned_from_id AS cloned_from_id_57, t0.edit_lock_by_user_id AS edit_lock_by_user_id_58, t0.mandate_id AS mandate_id_59 FROM property t0 WHERE t0.id = ?

Parameters:

[
  "678"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.revision AS revision_2,
  t0.public_id AS public_id_3,
  t0.offer_type AS offer_type_4,
  t0.sell_price AS sell_price_5,
  t0.rent_price AS rent_price_6,
  t0.publishing_status AS publishing_status_7,
  t0.apartments_count AS apartments_count_8,
  t0.rooms_count AS rooms_count_9,
  t0.bathrooms_count AS bathrooms_count_10,
  t0.floor AS floor_11,
  t0.floors_count AS floors_count_12,
  t0.living_area AS living_area_13,
  t0.land_area AS land_area_14,
  t0.usable_area AS usable_area_15,
  t0.ceiling_height AS ceiling_height_16,
  t0.year_built AS year_built_17,
  t0.last_renovation AS last_renovation_18,
  t0.calendly_url AS calendly_url_19,
  t0.tour_first_date_delay AS tour_first_date_delay_20,
  t0.tour_week_days AS tour_week_days_21,
  t0.waiting_list_active AS waiting_list_active_22,
  t0.favourite_richard AS favourite_richard_23,
  t0.location_optimiser_active AS location_optimiser_active_24,
  t0.video AS video_25,
  t0.video2 AS video2_26,
  t0.virtual_tour AS virtual_tour_27,
  t0.title AS title_28,
  t0.description_results AS description_results_29,
  t0.description_detail_view AS description_detail_view_30,
  t0.benefits AS benefits_31,
  t0.description_external_portals AS description_external_portals_32,
  t0.property_id AS property_id_33,
  t0.wordpress_export_active AS wordpress_export_active_34,
  t0.wordpress_exported_revision AS wordpress_exported_revision_35,
  t0.wordpress_page_url AS wordpress_page_url_36,
  t0.wordpress_post_id AS wordpress_post_id_37,
  t0.main_language AS main_language_38,
  t0.draft_at AS draft_at_39,
  t0.paused_at AS paused_at_40,
  t0.archived_at AS archived_at_41,
  t0.on_air_at AS on_air_at_42,
  t0.reserved_at AS reserved_at_43,
  t0.sold_or_rented_at AS sold_or_rented_at_44,
  t0.automatic_translation_disabled AS automatic_translation_disabled_45,
  t0.automatic_translated AS automatic_translated_46,
  t0.first_published_at AS first_published_at_47,
  t0.edit_lock_until AS edit_lock_until_48,
  t0.forced_publishing_phases AS forced_publishing_phases_49,
  t0.disallowed_publishing_phases AS disallowed_publishing_phases_50,
  t0.created_at AS created_at_51,
  t0.updated_at AS updated_at_52,
  t0.category_id AS category_id_53,
  t0.object_type_id AS object_type_id_54,
  t0.agent_id AS agent_id_55,
  t0.address_id AS address_id_56,
  t0.cloned_from_id AS cloned_from_id_57,
  t0.edit_lock_by_user_id AS edit_lock_by_user_id_58,
  t0.mandate_id AS mandate_id_59
FROM
  property t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.revision AS revision_2, t0.public_id AS public_id_3, t0.offer_type AS offer_type_4, t0.sell_price AS sell_price_5, t0.rent_price AS rent_price_6, t0.publishing_status AS publishing_status_7, t0.apartments_count AS apartments_count_8, t0.rooms_count AS rooms_count_9, t0.bathrooms_count AS bathrooms_count_10, t0.floor AS floor_11, t0.floors_count AS floors_count_12, t0.living_area AS living_area_13, t0.land_area AS land_area_14, t0.usable_area AS usable_area_15, t0.ceiling_height AS ceiling_height_16, t0.year_built AS year_built_17, t0.last_renovation AS last_renovation_18, t0.calendly_url AS calendly_url_19, t0.tour_first_date_delay AS tour_first_date_delay_20, t0.tour_week_days AS tour_week_days_21, t0.waiting_list_active AS waiting_list_active_22, t0.favourite_richard AS favourite_richard_23, t0.location_optimiser_active AS location_optimiser_active_24, t0.video AS video_25, t0.video2 AS video2_26, t0.virtual_tour AS virtual_tour_27, t0.title AS title_28, t0.description_results AS description_results_29, t0.description_detail_view AS description_detail_view_30, t0.benefits AS benefits_31, t0.description_external_portals AS description_external_portals_32, t0.property_id AS property_id_33, t0.wordpress_export_active AS wordpress_export_active_34, t0.wordpress_exported_revision AS wordpress_exported_revision_35, t0.wordpress_page_url AS wordpress_page_url_36, t0.wordpress_post_id AS wordpress_post_id_37, t0.main_language AS main_language_38, t0.draft_at AS draft_at_39, t0.paused_at AS paused_at_40, t0.archived_at AS archived_at_41, t0.on_air_at AS on_air_at_42, t0.reserved_at AS reserved_at_43, t0.sold_or_rented_at AS sold_or_rented_at_44, t0.automatic_translation_disabled AS automatic_translation_disabled_45, t0.automatic_translated AS automatic_translated_46, t0.first_published_at AS first_published_at_47, t0.edit_lock_until AS edit_lock_until_48, t0.forced_publishing_phases AS forced_publishing_phases_49, t0.disallowed_publishing_phases AS disallowed_publishing_phases_50, t0.created_at AS created_at_51, t0.updated_at AS updated_at_52, t0.category_id AS category_id_53, t0.object_type_id AS object_type_id_54, t0.agent_id AS agent_id_55, t0.address_id AS address_id_56, t0.cloned_from_id AS cloned_from_id_57, t0.edit_lock_by_user_id AS edit_lock_by_user_id_58, t0.mandate_id AS mandate_id_59 FROM property t0 WHERE t0.id = '678';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 119)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 63)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
9	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.99 ms
(14.76%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.name AS name_6, t0.locale AS locale_7, t0.picture AS picture_8 FROM user t0 WHERE t0.id = ?

Parameters:

[
  15
]

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.is_verified AS is_verified_5,
  t0.name AS name_6,
  t0.locale AS locale_7,
  t0.picture AS picture_8
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.is_verified AS is_verified_5, t0.name AS name_6, t0.locale AS locale_7, t0.picture AS picture_8 FROM user t0 WHERE t0.id = 15;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 214)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.90 ms
(13.45%)

UPDATE property SET edit_lock_until = ?, updated_at = ? WHERE id = ?

Parameters:

[
  "2026-04-20 17:26:33"
  "2026-04-20 17:25:33"
  678
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  property
SET
  edit_lock_until = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE property SET edit_lock_until = '2026-04-20 17:26:33', updated_at = '2026-04-20 17:25:33' WHERE id = 678;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 536)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 422)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1283)
4	Doctrine\ORM\UnitOfWork->commit (line 456)
5	Doctrine\ORM\EntityManager->flush (line 414)
6	App\Controller\PropertyController->editLock (line 516)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.82 ms
(12.17%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 430)
2	Doctrine\ORM\EntityManager->flush (line 414)
3	App\Controller\PropertyController->editLock (line 516)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.78 ms
(11.66%)

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?

Parameters:

[
  "678"
  "de"
  "App\Entity\Property"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '678' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\Property';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 918)
6	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 105)
7	Gedmo\Translatable\TranslatableListener->postLoad (line 529)
8	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 63)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 98)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 66)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 4000)
12	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 55)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 278)
14	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 787)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
16	Doctrine\ORM\EntityManager->find (line 530)
17	Doctrine\ORM\EntityRepository->find (line 196)
18	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 119)
19	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 63)
20	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 60)
21	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
22	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 40)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 173)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	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\User	1
App\Entity\Property	1
App\Entity\Property\PropertyCategory	1
App\Entity\Property\PropertyObject	1
App\Entity\Location\Address	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Draft	No errors.
App\Entity\Mandate	No errors.
App\Entity\Property	No errors.
App\Entity\Property\PropertyCategory	No errors.
App\Entity\Property\PropertyObject	No errors.
App\Entity\Agent	No errors.
App\Entity\Location\Address	No errors.
App\Entity\Location\ZipCodeCity	No errors.
App\Entity\Image	No errors.
App\Entity\Upload	No errors.
App\Entity\Property\PropertyFeature	No errors.
App\Entity\Property\PropertyIdx	No errors.
App\Entity\Contact	No errors.
App\Entity\Property\PublishingStatusChange	No errors.
App\Entity\Property\PropertySwissRets	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.

Symfony Profiler

POST https://liberate-gvs.ch/eigenschaften/678/edit_lock

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping