Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

13.98 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

13.98 ms

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.heading AS heading_2, p0_.description AS description_3, p0_.area AS area_4, p0_.land AS land_5, p0_.price AS price_6, p0_.address AS address_7, p0_.city AS city_8, p0_.zip_code AS zip_code_9, p0_.image_primary AS image_primary_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, t1_.name AS name_13, t2_.name AS name_14, o3_.name AS name_15, s4_.name AS name_16, c5_.name AS name_17, e6_.name AS name_18, r7_.name AS name_19, m8_.name AS name_20, i9_.image AS image_21, a10_.name AS name_22, n11_.name AS name_23, u12_.name AS name_24, r13_.name AS name_25, s14_.name AS name_26, s14_.typecolor AS typecolor_27, s14_.typebackground AS typebackground_28, p15_.name AS name_29 FROM property p0_ LEFT JOIN TYPE t1_ ON p0_.type_id = t1_.id LEFT JOIN transactions t2_ ON p0_.transactions_id = t2_.id LEFT JOIN ovnership o3_ ON p0_.ovnership_id = o3_.id LEFT JOIN STATUS s4_ ON p0_.status_id = s4_.id LEFT JOIN `condition` c5_ ON p0_.condition_property_id = c5_.id LEFT JOIN energy e6_ ON p0_.energy_id = e6_.id LEFT JOIN regions r7_ ON p0_.regions_id = r7_.id LEFT JOIN material m8_ ON p0_.material_id = m8_.id LEFT JOIN image_property i9_ ON p0_.id = i9_.property_id LEFT JOIN attribute_property a16_ ON p0_.id = a16_.property_id LEFT JOIN attributes a10_ ON a16_.attributes_id = a10_.id LEFT JOIN nearby_property n17_ ON p0_.id = n17_.property_id LEFT JOIN nearby n11_ ON n17_.nearby_id = n11_.id LEFT JOIN utility_property u18_ ON p0_.id = u18_.property_id LEFT JOIN utility u12_ ON u18_.utility_id = u12_.id LEFT JOIN room r13_ ON p0_.room_id = r13_.id LEFT JOIN STATUS s14_ ON p0_.status_id = s14_.id LEFT JOIN price_type p15_ ON p0_.price_type_id = p15_.id WHERE p0_.id = ?

Parameters:

[
  "33"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.heading AS heading_2,
  p0_.description AS description_3,
  p0_.area AS area_4,
  p0_.land AS land_5,
  p0_.price AS price_6,
  p0_.address AS address_7,
  p0_.city AS city_8,
  p0_.zip_code AS zip_code_9,
  p0_.image_primary AS image_primary_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  t1_.name AS name_13,
  t2_.name AS name_14,
  o3_.name AS name_15,
  s4_.name AS name_16,
  c5_.name AS name_17,
  e6_.name AS name_18,
  r7_.name AS name_19,
  m8_.name AS name_20,
  i9_.image AS image_21,
  a10_.name AS name_22,
  n11_.name AS name_23,
  u12_.name AS name_24,
  r13_.name AS name_25,
  s14_.name AS name_26,
  s14_.typecolor AS typecolor_27,
  s14_.typebackground AS typebackground_28,
  p15_.name AS name_29
FROM
  property p0_
  LEFT JOIN TYPE t1_ ON p0_.type_id = t1_.id
  LEFT JOIN transactions t2_ ON p0_.transactions_id = t2_.id
  LEFT JOIN ovnership o3_ ON p0_.ovnership_id = o3_.id
  LEFT JOIN STATUS s4_ ON p0_.status_id = s4_.id
  LEFT JOIN `condition` c5_ ON p0_.condition_property_id = c5_.id
  LEFT JOIN energy e6_ ON p0_.energy_id = e6_.id
  LEFT JOIN regions r7_ ON p0_.regions_id = r7_.id
  LEFT JOIN material m8_ ON p0_.material_id = m8_.id
  LEFT JOIN image_property i9_ ON p0_.id = i9_.property_id
  LEFT JOIN attribute_property a16_ ON p0_.id = a16_.property_id
  LEFT JOIN attributes a10_ ON a16_.attributes_id = a10_.id
  LEFT JOIN nearby_property n17_ ON p0_.id = n17_.property_id
  LEFT JOIN nearby n11_ ON n17_.nearby_id = n11_.id
  LEFT JOIN utility_property u18_ ON p0_.id = u18_.property_id
  LEFT JOIN utility u12_ ON u18_.utility_id = u12_.id
  LEFT JOIN room r13_ ON p0_.room_id = r13_.id
  LEFT JOIN STATUS s14_ ON p0_.status_id = s14_.id
  LEFT JOIN price_type p15_ ON p0_.price_type_id = p15_.id
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.heading AS heading_2, p0_.description AS description_3, p0_.area AS area_4, p0_.land AS land_5, p0_.price AS price_6, p0_.address AS address_7, p0_.city AS city_8, p0_.zip_code AS zip_code_9, p0_.image_primary AS image_primary_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, t1_.name AS name_13, t2_.name AS name_14, o3_.name AS name_15, s4_.name AS name_16, c5_.name AS name_17, e6_.name AS name_18, r7_.name AS name_19, m8_.name AS name_20, i9_.image AS image_21, a10_.name AS name_22, n11_.name AS name_23, u12_.name AS name_24, r13_.name AS name_25, s14_.name AS name_26, s14_.typecolor AS typecolor_27, s14_.typebackground AS typebackground_28, p15_.name AS name_29 FROM property p0_ LEFT JOIN TYPE t1_ ON p0_.type_id = t1_.id LEFT JOIN transactions t2_ ON p0_.transactions_id = t2_.id LEFT JOIN ovnership o3_ ON p0_.ovnership_id = o3_.id LEFT JOIN STATUS s4_ ON p0_.status_id = s4_.id LEFT JOIN `condition` c5_ ON p0_.condition_property_id = c5_.id LEFT JOIN energy e6_ ON p0_.energy_id = e6_.id LEFT JOIN regions r7_ ON p0_.regions_id = r7_.id LEFT JOIN material m8_ ON p0_.material_id = m8_.id LEFT JOIN image_property i9_ ON p0_.id = i9_.property_id LEFT JOIN attribute_property a16_ ON p0_.id = a16_.property_id LEFT JOIN attributes a10_ ON a16_.attributes_id = a10_.id LEFT JOIN nearby_property n17_ ON p0_.id = n17_.property_id LEFT JOIN nearby n11_ ON n17_.nearby_id = n11_.id LEFT JOIN utility_property u18_ ON p0_.id = u18_.property_id LEFT JOIN utility u12_ ON u18_.utility_id = u12_.id LEFT JOIN room r13_ ON p0_.room_id = r13_.id LEFT JOIN STATUS s14_ ON p0_.status_id = s14_.id LEFT JOIN price_type p15_ ON p0_.price_type_id = p15_.id WHERE p0_.id = '33';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 142)
7	App\Repository\PropertyRepository->findDetailProperty (line 34)
8	App\Controller\PropertyController->detail (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)

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\Property	No errors.
App\Entity\Type	No errors.
App\Entity\Transactions	No errors.
App\Entity\Ovnership	No errors.
App\Entity\Status	No errors.
App\Entity\Condition	No errors.
App\Entity\Energy	No errors.
App\Entity\Regions	No errors.
App\Entity\Material	No errors.
App\Entity\ImageProperty	No errors.
App\Entity\AttributeProperty	No errors.
App\Entity\Attributes	No errors.
App\Entity\NearbyProperty	No errors.
App\Entity\Nearby	No errors.
App\Entity\UtilityProperty	No errors.
App\Entity\Utility	No errors.
App\Entity\Room	No errors.
App\Entity\PriceType	No errors.

Symfony Profiler

GET https://testcode.website/detail/33

Configuration Settings

Theme