Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

5.46 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.43 ms
(26.16%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.limit_date AS limit_date_3, t0.creation_date AS creation_date_4, t0.client AS client_5, t0.description AS description_6, t0.approved_at AS approved_at_7, t0.mail_sent_at AS mail_sent_at_8, t0.missing_postal_code AS missing_postal_code_9 FROM market t0 WHERE t0.id = ?

Parameters:

[
  845
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.limit_date AS limit_date_3,
  t0.creation_date AS creation_date_4,
  t0.client AS client_5,
  t0.description AS description_6,
  t0.approved_at AS approved_at_7,
  t0.mail_sent_at AS mail_sent_at_8,
  t0.missing_postal_code AS missing_postal_code_9
FROM
  market t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.limit_date AS limit_date_3, t0.creation_date AS creation_date_4, t0.client AS client_5, t0.description AS description_6, t0.approved_at AS approved_at_7, t0.mail_sent_at AS mail_sent_at_8, t0.missing_postal_code AS missing_postal_code_9 FROM market t0 WHERE t0.id = 845;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 118)
7	App\Controller\MarketController->getOne (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.04 ms
(19.11%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM geographic_sector t0 INNER JOIN market_geographic_sector ON t0.id = market_geographic_sector.geographic_sector_id WHERE market_geographic_sector.market_id = ?

Parameters:

[
  845
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  geographic_sector t0
  INNER JOIN market_geographic_sector ON t0.id = market_geographic_sector.geographic_sector_id
WHERE
  market_geographic_sector.market_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM geographic_sector t0 INNER JOIN market_geographic_sector ON t0.id = market_geographic_sector.geographic_sector_id WHERE market_geographic_sector.market_id = 845;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 43)
8	App\Dto\MarketDto->__construct (line 219)
9	App\Controller\MarketController->generateDto (line 124)
10	App\Controller\MarketController->getOne (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.03 ms
(18.89%)

SELECT t0.id AS id_1, t0.link AS link_2, t0.market_id AS market_id_3 FROM market_link t0 WHERE t0.market_id = ?

Parameters:

[
  845
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.link AS link_2,
  t0.market_id AS market_id_3
FROM
  market_link t0
WHERE
  t0.market_id = ?

SELECT t0.id AS id_1, t0.link AS link_2, t0.market_id AS market_id_3 FROM market_link t0 WHERE t0.market_id = 845;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 41)
8	App\Dto\MarketDto->__construct (line 219)
9	App\Controller\MarketController->generateDto (line 124)
10	App\Controller\MarketController->getOne (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.98 ms
(18.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM skill t0 INNER JOIN market_ambiguous_skill ON t0.id = market_ambiguous_skill.skill_id WHERE market_ambiguous_skill.market_id = ?

Parameters:

[
  845
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.parent_id AS parent_id_3
FROM
  skill t0
  INNER JOIN market_ambiguous_skill ON t0.id = market_ambiguous_skill.skill_id
WHERE
  market_ambiguous_skill.market_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM skill t0 INNER JOIN market_ambiguous_skill ON t0.id = market_ambiguous_skill.skill_id WHERE market_ambiguous_skill.market_id = 845;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 45)
8	App\Dto\MarketDto->__construct (line 219)
9	App\Controller\MarketController->generateDto (line 124)
10	App\Controller\MarketController->getOne (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.97 ms
(17.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM skill t0 INNER JOIN market_skill ON t0.id = market_skill.skill_id WHERE market_skill.market_id = ?

Parameters:

[
  845
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.parent_id AS parent_id_3
FROM
  skill t0
  INNER JOIN market_skill ON t0.id = market_skill.skill_id
WHERE
  market_skill.market_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM skill t0 INNER JOIN market_skill ON t0.id = market_skill.skill_id WHERE market_skill.market_id = 845;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 42)
8	App\Dto\MarketDto->__construct (line 219)
9	App\Controller\MarketController->generateDto (line 124)
10	App\Controller\MarketController->getOne (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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.

Entities Mapping

Class	Mapping errors
App\Entity\Market	No errors.
App\Entity\GeographicSector	No errors.
App\Entity\Skill	No errors.
App\Entity\MarketLink	No errors.
App\Entity\LogMarketSent	No errors.
App\Entity\GeographicSectorCity	No errors.
App\Entity\SkillKeyWord	No errors.

Symfony Profiler

GET http://business-in-gard.iasgroup.io/api/markets/845

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping