Symfony Profiler

Query Metrics

11 Database Queries

2 Different statements

77.53 ms Query time

0 Invalid entities

34 Managed entities

Grouped Statements

Show all queries

shared connection

Time▼

Count

Info

76.35 ms
(98.48%)

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
  "ac4c1f7a-86de-4490-983e-15845a99f2a0"
  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, 'ac4c1f7a-86de-4490-983e-15845a99f2a0', 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

1.18 ms
(1.52%)

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_ WHERE t0_.enabled = 1

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_
WHERE
  t0_.enabled = 1

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_ WHERE t0_.enabled = 1;

#	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->findActive (line 33)
10	App\TourOperator\Provider\TourOperatorProvider->getActive (line 50)
11	App\Merlinx\ApiV4\Offers\Filters\Factory\FiltersResultFactory->create (line 60)
12	App\Merlinx\ApiV4\Offers\Filters\Filters->__invoke (line 41)
13	App\Merlinx\ApiV4\Offers\Offers->filters (line 105)
14	App\Offer\Controller\FiltersController->get (line 31)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	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	34

shared entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\TourOperator\Entity\TourOperator	No errors.

shared entity manager

No loaded entities.

Symfony Profiler

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

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