Symfony Profiler

Query Metrics

23 Database Queries

4 Different statements

20.73 ms Query time

0 Invalid entities

28 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.15 ms
(53.77%)

SELECT count(*) AS sclr_0 FROM job j0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  job j0_

SELECT count(*) AS sclr_0 FROM job j0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 72)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 136)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

5.50 ms
(26.53%)

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = ?

Parameters:

[
  174932
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 174932;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
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	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\ArrayConfigurator->configure (line 34)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 111)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 43)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 49)
12	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 147)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

3.21 ms
(15.49%)

SELECT j0_.id AS id_0, j0_.company AS company_1, j0_.company_phone AS company_phone_2, j0_.website AS website_3, j0_.contact_person AS contact_person_4, j0_.contact_email AS contact_email_5, j0_.contact_phone AS contact_phone_6, j0_.position AS position_7, j0_.position_id AS position_id_8, j0_.ad_id AS ad_id_9, j0_.location AS location_10, j0_.description AS description_11, j0_.imported_at AS imported_at_12, j0_.created_at AS created_at_13, j0_.updated_at AS updated_at_14 FROM job j0_ WHERE j0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.id AS id_0,
  j0_.company AS company_1,
  j0_.company_phone AS company_phone_2,
  j0_.website AS website_3,
  j0_.contact_person AS contact_person_4,
  j0_.contact_email AS contact_email_5,
  j0_.contact_phone AS contact_phone_6,
  j0_.position AS position_7,
  j0_.position_id AS position_id_8,
  j0_.ad_id AS ad_id_9,
  j0_.location AS location_10,
  j0_.description AS description_11,
  j0_.imported_at AS imported_at_12,
  j0_.created_at AS created_at_13,
  j0_.updated_at AS updated_at_14
FROM
  job j0_
WHERE
  j0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT j0_.id AS id_0, j0_.company AS company_1, j0_.company_phone AS company_phone_2, j0_.website AS website_3, j0_.contact_person AS contact_person_4, j0_.contact_email AS contact_email_5, j0_.contact_phone AS contact_phone_6, j0_.position AS position_7, j0_.position_id AS position_id_8, j0_.ad_id AS ad_id_9, j0_.location AS location_10, j0_.description AS description_11, j0_.imported_at AS imported_at_12, j0_.created_at AS created_at_13, j0_.updated_at AS updated_at_14 FROM job j0_ WHERE j0_.id IN (187216, 187212, 187215, 178641, 178638, 178639, 178640, 178643, 178644, 178642, 178645, 178646, 189266, 189265, 189269, 189267, 189268, 174932, 194553, 176726);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 136)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.87 ms
(4.20%)

SELECT DISTINCT j0_.id AS id_0 FROM job j0_ LIMIT 20 OFFSET 140

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT j0_.id AS id_0
FROM
  job j0_
LIMIT
  20
OFFSET
  140

SELECT DISTINCT j0_.id AS id_0 FROM job j0_ LIMIT 20 OFFSET 140;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 136)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	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\Job	20
App\Entity\GeoCity	8

Entities Mapping

Class	Mapping errors
App\Entity\Job	No errors.
App\Entity\GeoCity	No errors.

Symfony Profiler

GET https://job-matching.bullheads.de/job?page=8

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping