Symfony Profiler

Query Metrics

707 Database Queries

3 Different statements

108.86 ms Query time

2 Invalid entities

705 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

107.80 ms
(99.03%)

705

SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.alt_names AS alt_names_5, t0.alvin_id AS alvin_id_6, t0.type AS type_7, t0.approximate_location AS approximate_location_8, t0.location_precision AS location_precision_9, t0.description AS description_10, t0.wikidata_id AS wikidata_id_11, t0.mindat_id AS mindat_id_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM places t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC

Parameters:

[
  120
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lat AS lat_3,
  t0.lng AS lng_4,
  t0.alt_names AS alt_names_5,
  t0.alvin_id AS alvin_id_6,
  t0.type AS type_7,
  t0.approximate_location AS approximate_location_8,
  t0.location_precision AS location_precision_9,
  t0.description AS description_10,
  t0.wikidata_id AS wikidata_id_11,
  t0.mindat_id AS mindat_id_12,
  t0.updated_at AS updated_at_13,
  t0.parent_id AS parent_id_14
FROM
  places t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.alt_names AS alt_names_5, t0.alvin_id AS alvin_id_6, t0.type AS type_7, t0.approximate_location AS approximate_location_8, t0.location_precision AS location_precision_9, t0.description AS description_10, t0.wikidata_id AS wikidata_id_11, t0.mindat_id AS mindat_id_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM places t0 WHERE t0.parent_id = 120 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1270)
9	__TwigTemplate_8c304407f68a514a0db6797b9bfec093::{closure} (line 141)
10	Twig\Extension\CoreExtension->captureOutput (line 2108)
11	__TwigTemplate_8c304407f68a514a0db6797b9bfec093::macro_placeHierary (line 68)
12	__TwigTemplate_cd9a2076c15bd2b31965cdbeff8196be->block_body (line 177)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_9c4768b56f68badd0468dedd47eb1a28->doDisplay (line 92)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_cd9a2076c15bd2b31965cdbeff8196be->doDisplay (line 58)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\PlaceController->publicIndex (line 75)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.72 ms
(0.66%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.alt_names AS alt_names_5, t0.alvin_id AS alvin_id_6, t0.type AS type_7, t0.approximate_location AS approximate_location_8, t0.location_precision AS location_precision_9, t0.description AS description_10, t0.wikidata_id AS wikidata_id_11, t0.mindat_id AS mindat_id_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM places 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.lat AS lat_3,
  t0.lng AS lng_4,
  t0.alt_names AS alt_names_5,
  t0.alvin_id AS alvin_id_6,
  t0.type AS type_7,
  t0.approximate_location AS approximate_location_8,
  t0.location_precision AS location_precision_9,
  t0.description AS description_10,
  t0.wikidata_id AS wikidata_id_11,
  t0.mindat_id AS mindat_id_12,
  t0.updated_at AS updated_at_13,
  t0.parent_id AS parent_id_14
FROM
  places t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.alt_names AS alt_names_5, t0.alvin_id AS alvin_id_6, t0.type AS type_7, t0.approximate_location AS approximate_location_8, t0.location_precision AS location_precision_9, t0.description AS description_10, t0.wikidata_id AS wikidata_id_11, t0.mindat_id AS mindat_id_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM places 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\PlaceController->publicIndex (line 42)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.34 ms
(0.31%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.lat AS lat_2, p0_.lng AS lng_3, p0_.alt_names AS alt_names_4, p0_.alvin_id AS alvin_id_5, p0_.type AS type_6, p0_.approximate_location AS approximate_location_7, p0_.location_precision AS location_precision_8, p0_.description AS description_9, p0_.wikidata_id AS wikidata_id_10, p0_.mindat_id AS mindat_id_11, p0_.updated_at AS updated_at_12, p0_.parent_id AS parent_id_13 FROM places p0_ WHERE p0_.parent_id IS NULL ORDER BY p0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.lat AS lat_2,
  p0_.lng AS lng_3,
  p0_.alt_names AS alt_names_4,
  p0_.alvin_id AS alvin_id_5,
  p0_.type AS type_6,
  p0_.approximate_location AS approximate_location_7,
  p0_.location_precision AS location_precision_8,
  p0_.description AS description_9,
  p0_.wikidata_id AS wikidata_id_10,
  p0_.mindat_id AS mindat_id_11,
  p0_.updated_at AS updated_at_12,
  p0_.parent_id AS parent_id_13
FROM
  places p0_
WHERE
  p0_.parent_id IS NULL
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.lat AS lat_2, p0_.lng AS lng_3, p0_.alt_names AS alt_names_4, p0_.alvin_id AS alvin_id_5, p0_.type AS type_6, p0_.approximate_location AS approximate_location_7, p0_.location_precision AS location_precision_8, p0_.description AS description_9, p0_.wikidata_id AS wikidata_id_10, p0_.mindat_id AS mindat_id_11, p0_.updated_at AS updated_at_12, p0_.parent_id AS parent_id_13 FROM places p0_ WHERE p0_.parent_id IS NULL ORDER BY p0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PlaceRepository->findAllRootPlaces (line 28)
7	App\Controller\PlaceController->publicIndex (line 41)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Place	705

Entities Mapping

Class	Mapping errors
App\Entity\Place	No errors.
App\Entity\Institution	No errors.
App\Entity\Actor	The field 'App\Entity\Actor#SBL_id' has the property type 'int' that differs from the metadata field type 'string' returned by the 'text' DBAL type. The mappings App\Entity\Actor#volumes and App\Entity\Volume#author are inconsistent with each other. The mappings App\Entity\Actor#updated_by and App\Entity\User#edited_actors are inconsistent with each other.
App\Entity\Action	No errors.
App\Entity\Archive	No errors.
App\Entity\Mention	The association App\Entity\Mention#startTextLine refers to the inverse side field App\Entity\TextLine#annotations which does not exist. The association App\Entity\Mention#endTextLine refers to the inverse side field App\Entity\TextLine#annotations which does not exist. The association App\Entity\Mention#volume refers to the inverse side field App\Entity\Volume#mentions which does not exist. The association App\Entity\Mention#page refers to the inverse side field App\Entity\Page#mentions which does not exist. The association App\Entity\Mention#secondaryMention refers to the inverse side field App\Entity\Mention#PrimaryMentions which does not exist. The mappings App\Entity\Mention#primaryMentions and App\Entity\Mention#secondaryMention are inconsistent with each other.
App\Entity\ActorPlace	No errors.
App\Entity\MapOverlay	No errors.

Symfony Profiler

GET https://mining.dighist.ddnsfree.com/places

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping