Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.24 ms Query time

3 Invalid entities

42 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.77 ms

SELECT a0_.advertisement_id AS sclr_0 FROM advertisement_premium a0_ INNER JOIN advertisement a1_ ON a0_.advertisement_id = a1_.id LEFT JOIN package p2_ ON a1_.id = p2_.advertisement_id LEFT JOIN transaction t3_ ON p2_.transaction_id = t3_.id WHERE a0_.expiration > ? AND ((a1_.is_admin = 1 AND a1_.is_visible = 1) OR ((t3_.payment_status_id = 2 OR t3_.payment_status_id = 3) AND a1_.date_of_expiration > ? AND a1_.is_visible = 1))

Parameters:

[
  "2025-05-16 03:43:04"
  "2025-05-16 03:43:04"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.advertisement_id AS sclr_0
FROM
  advertisement_premium a0_
  INNER JOIN advertisement a1_ ON a0_.advertisement_id = a1_.id
  LEFT JOIN package p2_ ON a1_.id = p2_.advertisement_id
  LEFT JOIN transaction t3_ ON p2_.transaction_id = t3_.id
WHERE
  a0_.expiration > ?
  AND (
    (
      a1_.is_admin = 1
      AND a1_.is_visible = 1
    )
    OR (
      (
        t3_.payment_status_id = 2
        OR t3_.payment_status_id = 3
      )
      AND a1_.date_of_expiration > ?
      AND a1_.is_visible = 1
    )
  )

SELECT a0_.advertisement_id AS sclr_0 FROM advertisement_premium a0_ INNER JOIN advertisement a1_ ON a0_.advertisement_id = a1_.id LEFT JOIN package p2_ ON a1_.id = p2_.advertisement_id LEFT JOIN transaction t3_ ON p2_.transaction_id = t3_.id WHERE a0_.expiration > '2025-05-16 03:43:04' AND ((a1_.is_admin = 1 AND a1_.is_visible = 1) OR ((t3_.payment_status_id = 2 OR t3_.payment_status_id = 3) AND a1_.date_of_expiration > '2025-05-16 03:43:04' AND a1_.is_visible = 1));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 713)
6	Doctrine\ORM\AbstractQuery->getSingleColumnResult (line 32)
7	App\Repository\AdvertisementPremiumRepository->getActivePremiumAdvertisements (line 169)
8	App\Controller\PageController->cities (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.55 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.price AS price_4, t0.charge AS charge_5, t0.deposit AS deposit_6, t0.address AS address_7, t0.floor_area AS floor_area_8, t0.floor AS floor_9, t0.floors_of_property AS floors_of_property_10, t0.energy_class AS energy_class_11, t0.activities_nearby AS activities_nearby_12, t0.date_of_expiration AS date_of_expiration_13, t0.contact AS contact_14, t0.page_type AS page_type_15, t0.keywords AS keywords_16, t0.description AS description_17, t0.latitude AS latitude_18, t0.longitude AS longitude_19, t0.seo_title AS seo_title_20, t0.seo_description AS seo_description_21, t0.land_size AS land_size_22, t0.balcony_area AS balcony_area_23, t0.video AS video_24, t0.vrtour AS vrtour_25, t0.is_admin AS is_admin_26, t0.is_visible AS is_visible_27, t0.uniqid AS uniqid_28, t0.ip_address AS ip_address_29, t0.date_created AS date_created_30, t0.external_url AS external_url_31, t0.approved AS approved_32, t0.deleted_by_user AS deleted_by_user_33, t0.draft AS draft_34, t0.deleted_from_external AS deleted_from_external_35, t0.last_check AS last_check_36, t0.contact_disabled AS contact_disabled_37, t0.property_type_id AS property_type_id_38, t0.advertisement_type_id AS advertisement_type_id_39, t0.user_id AS user_id_40, t0.advertisement_status_id AS advertisement_status_id_41, t0.offering_type_id AS offering_type_id_42, t0.building_type_id AS building_type_id_43, t0.building_materials_id AS building_materials_id_44, t0.property_equipment_description_id AS property_equipment_description_id_45, t0.property_time_of_rent_id AS property_time_of_rent_id_46, t0.heating_id AS heating_id_47, t0.land_type_id AS land_type_id_48, t0.type_of_ownership_id AS type_of_ownership_id_49, t0.floor_in_house_id AS floor_in_house_id_50, t0.world_orientation_id AS world_orientation_id_51, t0.property_condition_id AS property_condition_id_52, t0.property_age_id AS property_age_id_53, t0.visibility_id AS visibility_id_54, t0.city_id AS city_id_55, t0.category_id AS category_id_56 FROM advertisement t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.price AS price_4,
  t0.charge AS charge_5,
  t0.deposit AS deposit_6,
  t0.address AS address_7,
  t0.floor_area AS floor_area_8,
  t0.floor AS floor_9,
  t0.floors_of_property AS floors_of_property_10,
  t0.energy_class AS energy_class_11,
  t0.activities_nearby AS activities_nearby_12,
  t0.date_of_expiration AS date_of_expiration_13,
  t0.contact AS contact_14,
  t0.page_type AS page_type_15,
  t0.keywords AS keywords_16,
  t0.description AS description_17,
  t0.latitude AS latitude_18,
  t0.longitude AS longitude_19,
  t0.seo_title AS seo_title_20,
  t0.seo_description AS seo_description_21,
  t0.land_size AS land_size_22,
  t0.balcony_area AS balcony_area_23,
  t0.video AS video_24,
  t0.vrtour AS vrtour_25,
  t0.is_admin AS is_admin_26,
  t0.is_visible AS is_visible_27,
  t0.uniqid AS uniqid_28,
  t0.ip_address AS ip_address_29,
  t0.date_created AS date_created_30,
  t0.external_url AS external_url_31,
  t0.approved AS approved_32,
  t0.deleted_by_user AS deleted_by_user_33,
  t0.draft AS draft_34,
  t0.deleted_from_external AS deleted_from_external_35,
  t0.last_check AS last_check_36,
  t0.contact_disabled AS contact_disabled_37,
  t0.property_type_id AS property_type_id_38,
  t0.advertisement_type_id AS advertisement_type_id_39,
  t0.user_id AS user_id_40,
  t0.advertisement_status_id AS advertisement_status_id_41,
  t0.offering_type_id AS offering_type_id_42,
  t0.building_type_id AS building_type_id_43,
  t0.building_materials_id AS building_materials_id_44,
  t0.property_equipment_description_id AS property_equipment_description_id_45,
  t0.property_time_of_rent_id AS property_time_of_rent_id_46,
  t0.heating_id AS heating_id_47,
  t0.land_type_id AS land_type_id_48,
  t0.type_of_ownership_id AS type_of_ownership_id_49,
  t0.floor_in_house_id AS floor_in_house_id_50,
  t0.world_orientation_id AS world_orientation_id_51,
  t0.property_condition_id AS property_condition_id_52,
  t0.property_age_id AS property_age_id_53,
  t0.visibility_id AS visibility_id_54,
  t0.city_id AS city_id_55,
  t0.category_id AS category_id_56
FROM
  advertisement t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.price AS price_4, t0.charge AS charge_5, t0.deposit AS deposit_6, t0.address AS address_7, t0.floor_area AS floor_area_8, t0.floor AS floor_9, t0.floors_of_property AS floors_of_property_10, t0.energy_class AS energy_class_11, t0.activities_nearby AS activities_nearby_12, t0.date_of_expiration AS date_of_expiration_13, t0.contact AS contact_14, t0.page_type AS page_type_15, t0.keywords AS keywords_16, t0.description AS description_17, t0.latitude AS latitude_18, t0.longitude AS longitude_19, t0.seo_title AS seo_title_20, t0.seo_description AS seo_description_21, t0.land_size AS land_size_22, t0.balcony_area AS balcony_area_23, t0.video AS video_24, t0.vrtour AS vrtour_25, t0.is_admin AS is_admin_26, t0.is_visible AS is_visible_27, t0.uniqid AS uniqid_28, t0.ip_address AS ip_address_29, t0.date_created AS date_created_30, t0.external_url AS external_url_31, t0.approved AS approved_32, t0.deleted_by_user AS deleted_by_user_33, t0.draft AS draft_34, t0.deleted_from_external AS deleted_from_external_35, t0.last_check AS last_check_36, t0.contact_disabled AS contact_disabled_37, t0.property_type_id AS property_type_id_38, t0.advertisement_type_id AS advertisement_type_id_39, t0.user_id AS user_id_40, t0.advertisement_status_id AS advertisement_status_id_41, t0.offering_type_id AS offering_type_id_42, t0.building_type_id AS building_type_id_43, t0.building_materials_id AS building_materials_id_44, t0.property_equipment_description_id AS property_equipment_description_id_45, t0.property_time_of_rent_id AS property_time_of_rent_id_46, t0.heating_id AS heating_id_47, t0.land_type_id AS land_type_id_48, t0.type_of_ownership_id AS type_of_ownership_id_49, t0.floor_in_house_id AS floor_in_house_id_50, t0.world_orientation_id AS world_orientation_id_51, t0.property_condition_id AS property_condition_id_52, t0.property_age_id AS property_age_id_53, t0.visibility_id AS visibility_id_54, t0.city_id AS city_id_55, t0.category_id AS category_id_56 FROM advertisement t0 WHERE t0.id IN (24536, 25139, 106384, 131767, 151354, 154877);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 170)
5	App\Controller\PageController->cities (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.92 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.description AS description_5, t0.img AS img_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.slug AS slug_9 FROM city t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "doplnkove-sluzby"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.description AS description_5,
  t0.img AS img_6,
  t0.seo_title AS seo_title_7,
  t0.seo_description AS seo_description_8,
  t0.slug AS slug_9
FROM
  city t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.description AS description_5, t0.img AS img_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.slug AS slug_9 FROM city t0 WHERE t0.slug = 'doplnkove-sluzby' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 171)
5	App\Controller\PageController->cities (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\Advertisement	6
App\Entity\User	5
App\Entity\PropertyType	4
App\Entity\Heating	4
App\Entity\PropertyEquipmentDescription	3
App\Entity\PropertyCondition	3
App\Entity\City	3
App\Entity\AdvertisementType	2
App\Entity\BuildingType	2
App\Entity\PropertyTimeOfRent	2
App\Entity\WorldOrientation	2
App\Entity\BuildingMaterials	2
App\Entity\OfferingType	1
App\Entity\TypeOfOwnership	1
App\Entity\AdvertisementStatus	1
App\Entity\AdvertisementVisibility	1

Entities Mapping

Class	Mapping errors
App\Entity\AdvertisementPremium	No errors.
App\Entity\Advertisement	No errors.
App\Entity\Package	No errors.
App\Entity\Transaction	No errors.
App\Entity\PropertyType	The association App\Entity\PropertyType#watchDogs refers to the owning side field App\Entity\WatchDog#propertyType which does not exist.
App\Entity\AdvertisementType	The association App\Entity\AdvertisementType#watchDogs refers to the owning side field App\Entity\WatchDog#advertisementType which does not exist.
App\Entity\User	No errors.
App\Entity\AdvertisementStatus	No errors.
App\Entity\OfferingType	No errors.
App\Entity\BuildingType	No errors.
App\Entity\BuildingMaterials	No errors.
App\Entity\PropertyEquipmentDescription	No errors.
App\Entity\PropertyTimeOfRent	No errors.
App\Entity\Heating	No errors.
App\Entity\LandType	No errors.
App\Entity\TypeOfOwnership	No errors.
App\Entity\FloorInHouse	No errors.
App\Entity\WorldOrientation	No errors.
App\Entity\PropertyCondition	No errors.
App\Entity\PropertyAge	No errors.
App\Entity\AdvertisementVisibility	No errors.
App\Entity\City	No errors.
App\Entity\AdvertisementCategory	No errors.
App\Entity\AdvertisementImage	No errors.
App\Entity\PropertyEquipment	No errors.
App\Entity\FavoriteAdvertisement	No errors.
App\Entity\Reconstruction	No errors.
App\Entity\AdvertisementDisposition	The association App\Entity\AdvertisementDisposition#watchDogs refers to the owning side field App\Entity\WatchDog#advertisementDisposition which does not exist.
App\Entity\Features	No errors.
App\Entity\MessageThread	No errors.
App\Entity\AdvertisementGroup	No errors.
App\Entity\AdvertisementDisplay	No errors.
App\Entity\ContactStats	No errors.
App\Entity\Product	No errors.
App\Entity\Contract	No errors.
App\Entity\PaymentMethod	No errors.
App\Entity\PaymentStatus	No errors.
App\Entity\WatchDog	No errors.
App\Entity\SocialLogin	No errors.
App\Entity\UserLog	No errors.
App\Entity\Message	No errors.
App\Entity\BlackList	No errors.
App\Entity\UserGroup	No errors.
App\Entity\WorkTime	No errors.

Symfony Profiler

GET https://realitysvepomocne.weby-betechnik.cz/mesto/doplnkove-sluzby

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping