Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.33 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.33 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.street AS street_3, t0.zip AS zip_4, t0.city AS city_5, t0.description AS description_6, t0.livable_area AS livable_area_7, t0.land_area AS land_area_8, t0.number_of_floors AS number_of_floors_9, t0.number_of_garages AS number_of_garages_10, t0.living_room_area AS living_room_area_11, t0.price AS price_12, t0.type_of_heating AS type_of_heating_13, t0.gas_connection AS gas_connection_14, t0.water_connection AS water_connection_15, t0.equipped_kitchen AS equipped_kitchen_16, t0.type_of_glazing AS type_of_glazing_17, t0.active AS active_18, t0.public_slider_title AS public_slider_title_19, t0.public_slider_description AS public_slider_description_20, t0.public_slider_active AS public_slider_active_21, t0.number_of_bedroom AS number_of_bedroom_22, t0.country_id AS country_id_23, t0.peb_id AS peb_id_24, t0.locality_id AS locality_id_25, t0.building_type_id AS building_type_id_26, t0.banner_id AS banner_id_27 FROM building t0 WHERE t0.id = ?

Parameters:

[
  "index.html"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.street AS street_3,
  t0.zip AS zip_4,
  t0.city AS city_5,
  t0.description AS description_6,
  t0.livable_area AS livable_area_7,
  t0.land_area AS land_area_8,
  t0.number_of_floors AS number_of_floors_9,
  t0.number_of_garages AS number_of_garages_10,
  t0.living_room_area AS living_room_area_11,
  t0.price AS price_12,
  t0.type_of_heating AS type_of_heating_13,
  t0.gas_connection AS gas_connection_14,
  t0.water_connection AS water_connection_15,
  t0.equipped_kitchen AS equipped_kitchen_16,
  t0.type_of_glazing AS type_of_glazing_17,
  t0.active AS active_18,
  t0.public_slider_title AS public_slider_title_19,
  t0.public_slider_description AS public_slider_description_20,
  t0.public_slider_active AS public_slider_active_21,
  t0.number_of_bedroom AS number_of_bedroom_22,
  t0.country_id AS country_id_23,
  t0.peb_id AS peb_id_24,
  t0.locality_id AS locality_id_25,
  t0.building_type_id AS building_type_id_26,
  t0.banner_id AS banner_id_27
FROM
  building t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.street AS street_3, t0.zip AS zip_4, t0.city AS city_5, t0.description AS description_6, t0.livable_area AS livable_area_7, t0.land_area AS land_area_8, t0.number_of_floors AS number_of_floors_9, t0.number_of_garages AS number_of_garages_10, t0.living_room_area AS living_room_area_11, t0.price AS price_12, t0.type_of_heating AS type_of_heating_13, t0.gas_connection AS gas_connection_14, t0.water_connection AS water_connection_15, t0.equipped_kitchen AS equipped_kitchen_16, t0.type_of_glazing AS type_of_glazing_17, t0.active AS active_18, t0.public_slider_title AS public_slider_title_19, t0.public_slider_description AS public_slider_description_20, t0.public_slider_active AS public_slider_active_21, t0.number_of_bedroom AS number_of_bedroom_22, t0.country_id AS country_id_23, t0.peb_id AS peb_id_24, t0.locality_id AS locality_id_25, t0.building_type_id AS building_type_id_26, t0.banner_id AS banner_id_27 FROM building t0 WHERE t0.id = 'index.html';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	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

Entities Mapping

Class	Mapping errors
App\Entity\Building	No errors.
App\Entity\Country	No errors.
App\Entity\Peb	No errors.
App\Entity\Locality	No errors.
App\Entity\BuildingType	No errors.
App\Entity\Banner	No errors.
App\Entity\BuildingPicture	No errors.

Symfony Profiler

GET https://jptradi.bluelinesoft.be/project/index.html

Configuration Settings

Theme

Page Width