Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

7.11 ms Query time

0 Invalid entities

743 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.32 ms
(88.94%)

SELECT DISTINCT MIN(t0_.due_date) AS sclr_0, COUNT(n1_.id) AS sclr_1, o2_.creation_timestamp AS creation_timestamp_2, o2_.modification_timestamp AS modification_timestamp_3, o2_.inquiry AS inquiry_4, o2_.id AS id_5, o2_.version AS version_6, o2_.name AS name_7, d3_.code AS code_8, d3_.position AS position_9, d3_.id AS id_10, d3_.version AS version_11, d3_.name AS name_12, d3_.text_color AS text_color_13, d3_.text_background_color AS text_background_color_14, e4_.id AS id_15, e4_.first_name AS first_name_16, e4_.last_name AS last_name_17, c5_.id AS id_18, c5_.first_name AS first_name_19, c5_.last_name AS last_name_20, o6_.name AS name_21, o6_.short_name AS short_name_22, o6_.id AS id_23, f7_.original_name AS original_name_24, f7_.size AS size_25, f7_.hash AS hash_26, f7_.id AS id_27, o8_.type AS type_28, o2_.supervisor_id AS supervisor_id_29, o2_.client_id AS client_id_30, o2_.organization_id AS organization_id_31, o2_.creator_id AS creator_id_32, o2_.modifier_id AS modifier_id_33, o2_.status_id AS status_id_34, o2_.operator_id AS operator_id_35, d3_.discriminator AS discriminator_36, d3_.operator_id AS operator_id_37, e4_.operator_id AS operator_id_38, c5_.organization_id AS organization_id_39, c5_.operator_id AS operator_id_40, o6_.operator_id AS operator_id_41, f7_.discriminator AS discriminator_42, o8_.offer_id AS offer_id_43 FROM offers o2_ INNER JOIN dictionaries d3_ ON o2_.status_id = d3_.id AND d3_.discriminator IN ('offer_status') LEFT JOIN employees e4_ ON o2_.supervisor_id = e4_.id LEFT JOIN clients c5_ ON o2_.client_id = c5_.id LEFT JOIN organizations o6_ ON o2_.organization_id = o6_.id LEFT JOIN tasks t0_ ON (t0_.offer_id = o2_.id AND t0_.action_timestamp IS NULL) AND t0_.discriminator IN ('offer') LEFT JOIN offer_files o8_ ON o2_.id = o8_.offer_id LEFT JOIN files f7_ ON o8_.id = f7_.id LEFT JOIN notes n1_ ON (n1_.offer_id = o2_.id) AND n1_.discriminator IN ('offer') WHERE o2_.operator_id = ? AND (o2_.creation_timestamp >= ? AND o2_.creation_timestamp < ?) GROUP BY o2_.id, e4_.id, c5_.id, d3_.id, o6_.id, f7_.original_name, f7_.content_type, f7_.key, f7_.creation_timestamp, f7_.size, f7_.hash, f7_.encryption_key, f7_.encryption_iv, f7_.id, o8_.name, o8_.type, o8_.version, o8_.offer_id ORDER BY o2_.creation_timestamp DESC

Parameters:

[
  2
  "2026-01-01"
  "2027-01-01"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT MIN(t0_.due_date) AS sclr_0,
  COUNT(n1_.id) AS sclr_1,
  o2_.creation_timestamp AS creation_timestamp_2,
  o2_.modification_timestamp AS modification_timestamp_3,
  o2_.inquiry AS inquiry_4,
  o2_.id AS id_5,
  o2_.version AS version_6,
  o2_.name AS name_7,
  d3_.code AS code_8,
  d3_.position AS position_9,
  d3_.id AS id_10,
  d3_.version AS version_11,
  d3_.name AS name_12,
  d3_.text_color AS text_color_13,
  d3_.text_background_color AS text_background_color_14,
  e4_.id AS id_15,
  e4_.first_name AS first_name_16,
  e4_.last_name AS last_name_17,
  c5_.id AS id_18,
  c5_.first_name AS first_name_19,
  c5_.last_name AS last_name_20,
  o6_.name AS name_21,
  o6_.short_name AS short_name_22,
  o6_.id AS id_23,
  f7_.original_name AS original_name_24,
  f7_.size AS size_25,
  f7_.hash AS hash_26,
  f7_.id AS id_27,
  o8_.type AS type_28,
  o2_.supervisor_id AS supervisor_id_29,
  o2_.client_id AS client_id_30,
  o2_.organization_id AS organization_id_31,
  o2_.creator_id AS creator_id_32,
  o2_.modifier_id AS modifier_id_33,
  o2_.status_id AS status_id_34,
  o2_.operator_id AS operator_id_35,
  d3_.discriminator AS discriminator_36,
  d3_.operator_id AS operator_id_37,
  e4_.operator_id AS operator_id_38,
  c5_.organization_id AS organization_id_39,
  c5_.operator_id AS operator_id_40,
  o6_.operator_id AS operator_id_41,
  f7_.discriminator AS discriminator_42,
  o8_.offer_id AS offer_id_43
FROM
  offers o2_
  INNER JOIN dictionaries d3_ ON o2_.status_id = d3_.id
  AND d3_.discriminator IN ('offer_status')
  LEFT JOIN employees e4_ ON o2_.supervisor_id = e4_.id
  LEFT JOIN clients c5_ ON o2_.client_id = c5_.id
  LEFT JOIN organizations o6_ ON o2_.organization_id = o6_.id
  LEFT JOIN tasks t0_ ON (
    t0_.offer_id = o2_.id
    AND t0_.action_timestamp IS NULL
  )
  AND t0_.discriminator IN ('offer')
  LEFT JOIN offer_files o8_ ON o2_.id = o8_.offer_id
  LEFT JOIN files f7_ ON o8_.id = f7_.id
  LEFT JOIN notes n1_ ON (n1_.offer_id = o2_.id)
  AND n1_.discriminator IN ('offer')
WHERE
  o2_.operator_id = ?
  AND (
    o2_.creation_timestamp >= ?
    AND o2_.creation_timestamp < ?
  )
GROUP BY
  o2_.id,
  e4_.id,
  c5_.id,
  d3_.id,
  o6_.id,
  f7_.original_name,
  f7_.content_type,
  f7_.key,
  f7_.creation_timestamp,
  f7_.size,
  f7_.hash,
  f7_.encryption_key,
  f7_.encryption_iv,
  f7_.id,
  o8_.name,
  o8_.type,
  o8_.version,
  o8_.offer_id
ORDER BY
  o2_.creation_timestamp DESC

SELECT DISTINCT MIN(t0_.due_date) AS sclr_0, COUNT(n1_.id) AS sclr_1, o2_.creation_timestamp AS creation_timestamp_2, o2_.modification_timestamp AS modification_timestamp_3, o2_.inquiry AS inquiry_4, o2_.id AS id_5, o2_.version AS version_6, o2_.name AS name_7, d3_.code AS code_8, d3_.position AS position_9, d3_.id AS id_10, d3_.version AS version_11, d3_.name AS name_12, d3_.text_color AS text_color_13, d3_.text_background_color AS text_background_color_14, e4_.id AS id_15, e4_.first_name AS first_name_16, e4_.last_name AS last_name_17, c5_.id AS id_18, c5_.first_name AS first_name_19, c5_.last_name AS last_name_20, o6_.name AS name_21, o6_.short_name AS short_name_22, o6_.id AS id_23, f7_.original_name AS original_name_24, f7_.size AS size_25, f7_.hash AS hash_26, f7_.id AS id_27, o8_.type AS type_28, o2_.supervisor_id AS supervisor_id_29, o2_.client_id AS client_id_30, o2_.organization_id AS organization_id_31, o2_.creator_id AS creator_id_32, o2_.modifier_id AS modifier_id_33, o2_.status_id AS status_id_34, o2_.operator_id AS operator_id_35, d3_.discriminator AS discriminator_36, d3_.operator_id AS operator_id_37, e4_.operator_id AS operator_id_38, c5_.organization_id AS organization_id_39, c5_.operator_id AS operator_id_40, o6_.operator_id AS operator_id_41, f7_.discriminator AS discriminator_42, o8_.offer_id AS offer_id_43 FROM offers o2_ INNER JOIN dictionaries d3_ ON o2_.status_id = d3_.id AND d3_.discriminator IN ('offer_status') LEFT JOIN employees e4_ ON o2_.supervisor_id = e4_.id LEFT JOIN clients c5_ ON o2_.client_id = c5_.id LEFT JOIN organizations o6_ ON o2_.organization_id = o6_.id LEFT JOIN tasks t0_ ON (t0_.offer_id = o2_.id AND t0_.action_timestamp IS NULL) AND t0_.discriminator IN ('offer') LEFT JOIN offer_files o8_ ON o2_.id = o8_.offer_id LEFT JOIN files f7_ ON o8_.id = f7_.id LEFT JOIN notes n1_ ON (n1_.offer_id = o2_.id) AND n1_.discriminator IN ('offer') WHERE o2_.operator_id = 2 AND (o2_.creation_timestamp >= '2026-01-01' AND o2_.creation_timestamp < '2027-01-01') GROUP BY o2_.id, e4_.id, c5_.id, d3_.id, o6_.id, f7_.original_name, f7_.content_type, f7_.key, f7_.creation_timestamp, f7_.size, f7_.hash, f7_.encryption_key, f7_.encryption_iv, f7_.id, o8_.name, o8_.type, o8_.version, o8_.offer_id ORDER BY o2_.creation_timestamp DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	TravelManager\Core\Service\OfferService->listOffers (line 278)
7	TravelManager\Core\Controller\Api\Front\OfferController->list (line 82)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.79 ms
(11.06%)

SELECT t0.role AS role_1, t0.email AS email_2, t0.phone AS phone_3, t0.password AS password_4, t0.active AS active_5, t0.id AS id_6, t0.version AS version_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.operator_id AS operator_id_10 FROM employees t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "julia.krawczyk@allintravel.pl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.role AS role_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.password AS password_4,
  t0.active AS active_5,
  t0.id AS id_6,
  t0.version AS version_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.operator_id AS operator_id_10
FROM
  employees t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.role AS role_1, t0.email AS email_2, t0.phone AS phone_3, t0.password AS password_4, t0.active AS active_5, t0.id AS id_6, t0.version AS version_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.operator_id AS operator_id_10 FROM employees t0 WHERE t0.email = 'julia.krawczyk@allintravel.pl' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 158)
5	TravelManager\Admin\Service\EmployeeService->loadUserByIdentifier (line 153)
6	TravelManager\Common\Component\ApiClient\Manager->resolveContext (line 259)
7	TravelManager\Common\Component\ApiClient\Base\AbstractAuthenticator->{closure:TravelManager\Common\Component\ApiClient\Base\AbstractAuthenticator::createContextUserBadge():142} (line 143)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 101)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	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.

Managed Entities

default entity manager

Class	Amount of managed objects
TravelManager\Core\Model\Entity\OfferEntity	235
TravelManager\Core\Model\Entity\ClientEntity	196
TravelManager\Core\Model\Entity\OrganizationEntity	183
TravelManager\Core\Model\Entity\Base\FileEntity	111
TravelManager\Admin\Model\Entity\EmployeeEntity	11
TravelManager\Core\Model\Entity\Base\DictionaryEntryEntity	6
TravelManager\Admin\Model\Entity\TourOperatorEntity	1

Entities Mapping

Class	Mapping errors
TravelManager\Admin\Model\Entity\EmployeeEntity	No errors.
TravelManager\Admin\Model\Entity\TourOperatorEntity	No errors.
TravelManager\Core\Model\Entity\OfferEntity	No errors.
TravelManager\Core\Model\Entity\Base\DictionaryEntryEntity	No errors.
TravelManager\Core\Model\Entity\DictionaryEntry\OfferStatusEntity	No errors.
TravelManager\Core\Model\Entity\ClientEntity	No errors.
TravelManager\Core\Model\Entity\Base\AddressEmbeddable	No errors.
TravelManager\Core\Model\Entity\OrganizationEntity	No errors.
TravelManager\Core\Model\Entity\Base\TaskEntity	No errors.
TravelManager\Core\Model\Entity\OfferTaskEntity	No errors.
TravelManager\Core\Model\Entity\Base\FileEntity	No errors.
TravelManager\Core\Model\Entity\OfferFileEntity	No errors.
TravelManager\Core\Model\Entity\Base\NoteEntity	No errors.
TravelManager\Core\Model\Entity\OfferNoteEntity	No errors.

Symfony Profiler

GET https://travelmanager.online/api/front/offers

Configuration Settings

Theme

Page Width