Symfony Profiler

Query Metrics

15 Database Queries

4 Different statements

36.44 ms Query time

0 Invalid entities

130 Managed entities

Queries

Group similar statements

shared connection


INSERT INTO log (type, message, scope, reference, params, resource_id, record_id, request_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO log (type, message, scope, reference, params, resource_id, record_id, request_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO log (type, message, scope, reference, params, resource_id, record_id, request_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO log (type, message, scope, reference, params, resource_id, record_id, request_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO log (type, message, scope, reference, params, resource_id, record_id, request_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO log (type, message, scope, reference, params, resource_id, record_id, request_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO log (type, message, scope, reference, params, resource_id, record_id, request_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO log (type, message, scope, reference, params, resource_id, record_id, request_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO log (type, message, scope, reference, params, resource_id, record_id, request_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO log (type, message, scope, reference, params, resource_id, record_id, request_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO log (type, message, scope, reference, params, resource_id, record_id, request_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO log (type, message, scope, reference, params, resource_id, record_id, request_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

default connection

#▲

Time

Info

1.39 ms

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.broker AS broker_2, t0_.broker_version AS broker_version_3, t0_.short AS short_4, t0_.description AS description_5, t0_.url AS url_6, t0_.logo AS logo_7, t0_.created_at AS created_at_8, t0_.updated_at AS updated_at_9, t0_.enabled AS enabled_10 FROM tour_operator t0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.broker AS broker_2,
  t0_.broker_version AS broker_version_3,
  t0_.short AS short_4,
  t0_.description AS description_5,
  t0_.url AS url_6,
  t0_.logo AS logo_7,
  t0_.created_at AS created_at_8,
  t0_.updated_at AS updated_at_9,
  t0_.enabled AS enabled_10
FROM
  tour_operator t0_

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.broker AS broker_2, t0_.broker_version AS broker_version_3, t0_.short AS short_4, t0_.description AS description_5, t0_.url AS url_6, t0_.logo AS logo_7, t0_.created_at AS created_at_8, t0_.updated_at AS updated_at_9, t0_.enabled AS enabled_10 FROM tour_operator t0_;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 234)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 105)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
5	Doctrine\ORM\Query->_doExecute (line 296)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
7	Doctrine\ORM\AbstractQuery->execute (line 891)
8	Doctrine\ORM\AbstractQuery->getResult (line 689)
9	App\TourOperator\Repository\TourOperatorRepository->findAll (line 21)
10	App\TourOperator\Provider\TourOperatorProvider->getAll (line 22)
11	App\TourOperator\Provider\TourOperatorProvider->getOperatorName (line 77)
12	App\Merlinx\ApiV4\Offers\Details\Factory\DetailsResultFactory->create (line 69)
13	App\Merlinx\ApiV4\Offers\Details\Details->__invoke (line 41)
14	App\Merlinx\ApiV4\Offers\Offers->details (line 85)
15	App\Offer\Controller\DetailsController->get (line 34)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

10.42 ms

SELECT t0.id AS id_1, t0.x_code AS x_code_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM legacy_object t0 WHERE t0.x_code = ? LIMIT 1

Parameters:

[
  "79552"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.x_code AS x_code_2,
  t0.url AS url_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  legacy_object t0
WHERE
  t0.x_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.x_code AS x_code_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM legacy_object t0 WHERE t0.x_code = '79552' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	App\Merlinx\ApiV4\Offers\Details\Factory\DetailsResultFactory->fetchSvUrl (line 218)
7	App\Merlinx\ApiV4\Offers\Details\Factory\DetailsResultFactory->create (line 153)
8	App\Merlinx\ApiV4\Offers\Details\Details->__invoke (line 41)
9	App\Merlinx\ApiV4\Offers\Offers->details (line 85)
10	App\Offer\Controller\DetailsController->get (line 34)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.34 ms

SELECT t0.id AS id_1, t0.country AS country_2, t0.iso2 AS iso2_3, t0.iso3 AS iso3_4, t0.name AS name_5, t0.broker AS broker_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.enabled AS enabled_9, t0.parent_id AS parent_id_10 FROM region t0 WHERE t0.id = ?

Parameters:

[
  "26"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.country AS country_2,
  t0.iso2 AS iso2_3,
  t0.iso3 AS iso3_4,
  t0.name AS name_5,
  t0.broker AS broker_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.enabled AS enabled_9,
  t0.parent_id AS parent_id_10
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.country AS country_2, t0.iso2 AS iso2_3, t0.iso3 AS iso3_4, t0.name AS name_5, t0.broker AS broker_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.enabled AS enabled_9, t0.parent_id AS parent_id_10 FROM region t0 WHERE t0.id = '26';

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
5	Doctrine\ORM\EntityManager->find (line 366)
6	Doctrine\ORM\EntityRepository->find (line 86)
7	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
8	App\Region\Provider\RegionProvider->getRegion (line 22)
9	App\Region\Provider\RegionProvider->getRegionIso2 (line 41)
10	App\Merlinx\ApiV4\Offers\Details\Factory\DetailsResultFactory->create (line 176)
11	App\Merlinx\ApiV4\Offers\Details\Details->__invoke (line 41)
12	App\Merlinx\ApiV4\Offers\Offers->details (line 85)
13	App\Offer\Controller\DetailsController->get (line 34)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
shared	doctrine.dbal.shared_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
shared	doctrine.orm.shared_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\TourOperator\Entity\TourOperator	128
App\Legacy\Entity\LegacyObject	1
App\Region\Entity\Region	1

shared entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\TourOperator\Entity\TourOperator	No errors.
App\Legacy\Entity\LegacyObject	No errors.
App\Region\Entity\Region	No errors.

shared entity manager

No loaded entities.

Symfony Profiler

POST https://fqs.mprt.pl/api/offers/details

Configuration Settings

Theme

Page Width

Query Metrics

Queries

shared connection

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

shared entity manager

Entities Mapping

default entity manager

shared entity manager