Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.12 ms Query time

3 Invalid entities

1171 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.78 ms
(54.31%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.type AS type_5, t0.is_paid AS is_paid_6, t0.all_year_open AS all_year_open_7, t0.waste_disposal AS waste_disposal_8, t0.user_id AS user_id_9, t0.country_id AS country_id_10 FROM place t0

Parameters:

[]

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.type AS type_5,
  t0.is_paid AS is_paid_6,
  t0.all_year_open AS all_year_open_7,
  t0.waste_disposal AS waste_disposal_8,
  t0.user_id AS user_id_9,
  t0.country_id AS country_id_10
FROM
  place t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.type AS type_5, t0.is_paid AS is_paid_6, t0.all_year_open AS all_year_open_7, t0.waste_disposal AS waste_disposal_8, t0.user_id AS user_id_9, t0.country_id AS country_id_10 FROM place t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\Place\PlaceController->index (line 32)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

2.34 ms
(45.69%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso3 AS iso3_3, t0.numeric_code AS numeric_code_4, t0.iso2 AS iso2_5, t0.phonecode AS phonecode_6, t0.capital AS capital_7, t0.currency AS currency_8, t0.currency_name AS currency_name_9, t0.currency_symbol AS currency_symbol_10, t0.tld AS tld_11, t0.native AS native_12, t0.region AS region_13, t0.region_id AS region_id_14, t0.subregion AS subregion_15, t0.subregion_id AS subregion_id_16, t0.nationality AS nationality_17, t0.timezones AS timezones_18, t0.translations AS translations_19, t0.latitude AS latitude_20, t0.longitude AS longitude_21, t0.emoji AS emoji_22, t0.emojiU AS emojiU_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.flag AS flag_26, t0.wikiDataId AS wikiDataId_27 FROM country t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso3 AS iso3_3,
  t0.numeric_code AS numeric_code_4,
  t0.iso2 AS iso2_5,
  t0.phonecode AS phonecode_6,
  t0.capital AS capital_7,
  t0.currency AS currency_8,
  t0.currency_name AS currency_name_9,
  t0.currency_symbol AS currency_symbol_10,
  t0.tld AS tld_11,
  t0.native AS native_12,
  t0.region AS region_13,
  t0.region_id AS region_id_14,
  t0.subregion AS subregion_15,
  t0.subregion_id AS subregion_id_16,
  t0.nationality AS nationality_17,
  t0.timezones AS timezones_18,
  t0.translations AS translations_19,
  t0.latitude AS latitude_20,
  t0.longitude AS longitude_21,
  t0.emoji AS emoji_22,
  t0.emojiU AS emojiU_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.flag AS flag_26,
  t0.wikiDataId AS wikiDataId_27
FROM
  country t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso3 AS iso3_3, t0.numeric_code AS numeric_code_4, t0.iso2 AS iso2_5, t0.phonecode AS phonecode_6, t0.capital AS capital_7, t0.currency AS currency_8, t0.currency_name AS currency_name_9, t0.currency_symbol AS currency_symbol_10, t0.tld AS tld_11, t0.native AS native_12, t0.region AS region_13, t0.region_id AS region_id_14, t0.subregion AS subregion_15, t0.subregion_id AS subregion_id_16, t0.nationality AS nationality_17, t0.timezones AS timezones_18, t0.translations AS translations_19, t0.latitude AS latitude_20, t0.longitude AS longitude_21, t0.emoji AS emoji_22, t0.emojiU AS emojiU_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.flag AS flag_26, t0.wikiDataId AS wikiDataId_27 FROM country t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\Place\PlaceController->index (line 41)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	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\Place	916
App\Entity\Country	250
App\Entity\User	5

Entities Mapping

Class	Mapping errors
App\Entity\Place	No errors.
App\Entity\User	The association App\Entity\User#placeVisits refers to the owning side field App\Entity\PlaceVisit#User which does not exist.
App\Entity\Country	The field 'App\Entity\Country#latitude' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type. The field 'App\Entity\Country#longitude' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
App\Entity\PlaceVisit	The mappings App\Entity\PlaceVisit#user and App\Entity\User#placeVisits are inconsistent with each other.

Symfony Profiler

GET https://www.kampervoz.eu/place

Configuration Settings

Theme

Page Width