Symfony Profiler

Query Metrics

11 Database Queries

2 Different statements

52.27 ms Query time

0 Invalid entities

34 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 (?, ?, ?, ?, ?, ?, ?, ?, ?)

default connection

#▲

Time

Info

0.72 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_ 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

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