Symfony Profiler

Query Metrics

15 Database Queries

4 Different statements

36.44 ms Query time

0 Invalid entities

130 Managed entities

Grouped Statements

Show all queries

shared connection

Time▼

Count

Info

24.29 ms
(66.66%)

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

Parameters:

[
  "WARNING"
  "A possible infinite logging loop was detected and aborted. It appears some of your handler code is triggering logging, see th..."
  "doctrine"
  "bootstrap"
  null
  null
  null
  "b12fa56b-0be1-49de-b165-d392a349aa81"
  null
]

View formatted query View runnable query Explain query View query backtrace

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 ('WARNING', 'A possible infinite logging loop was detected and aborted. It appears some of your handler code is triggering logging, see th...', 'doctrine', 'bootstrap', NULL, NULL, NULL, 'b12fa56b-0be1-49de-b165-d392a349aa81', NULL);

#	File/Call
1	Doctrine\DBAL\Connection->insert (line 514)
2	App\Common\Logger\DatabaseHandler->handle (line 42)
3	Monolog\Logger->addRecord (line 391)
4	Monolog\Logger->warning (line 633)
5	Monolog\Logger->addRecord (line 349)
6	Monolog\Logger->info (line 607)
7	Doctrine\DBAL\Logging\Driver->connect (line 27)
8	Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect (line 27)
9	Symfony\Bridge\Doctrine\Middleware\Debug\Driver->connect (line 37)
10	Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect (line 27)
11	Symfony\Bridge\Doctrine\Middleware\IdleConnection\Driver->connect (line 35)
12	Doctrine\DBAL\Connection->connect (line 222)
13	Doctrine\DBAL\Connection->executeStatement (line 895)
14	Doctrine\DBAL\Connection->insert (line 514)
15	App\Common\Logger\DatabaseHandler->handle (line 42)
16	Monolog\Logger->addRecord (line 391)
17	Monolog\Logger->info (line 607)
18	Doctrine\DBAL\Logging\Driver->connect (line 27)
19	Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect (line 27)
20	Symfony\Bridge\Doctrine\Middleware\Debug\Driver->connect (line 37)
21	Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect (line 27)
22	Symfony\Bridge\Doctrine\Middleware\IdleConnection\Driver->connect (line 35)
23	Doctrine\DBAL\Connection->connect (line 222)
24	Doctrine\DBAL\Connection->executeStatement (line 895)
25	Doctrine\DBAL\Connection->insert (line 514)
26	App\Common\Logger\DatabaseHandler->handle (line 42)
27	Monolog\Logger->addRecord (line 391)
28	Monolog\Logger->info (line 607)
29	Doctrine\DBAL\Logging\Driver->connect (line 27)
30	Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect (line 27)
31	Symfony\Bridge\Doctrine\Middleware\Debug\Driver->connect (line 37)
32	Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect (line 27)
33	Symfony\Bridge\Doctrine\Middleware\IdleConnection\Driver->connect (line 35)
34	Doctrine\DBAL\Connection->connect (line 222)
35	Doctrine\DBAL\Connection->executeStatement (line 895)
36	Doctrine\DBAL\Connection->insert (line 514)
37	App\Common\Logger\DatabaseHandler->handle (line 42)
38	Monolog\Logger->addRecord (line 391)
39	Monolog\Logger->info (line 607)
40	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 106)
41	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
42	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
43	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
44	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
45	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
46	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
47	Symfony\Component\HttpKernel\Kernel->handle (line 182)
48	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
49	require_once (line 29)
50	require_once (line 5)

default connection

Time▼

Count

Info

10.42 ms
(28.60%)

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)

1.39 ms
(3.82%)

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)

0.34 ms
(0.92%)

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

Grouped Statements

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