Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.38 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.15 ms

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\CampaignTrackingService->createTrackingSession (line 233)
4	App\Service\CampaignTrackingService->initializeSession (line 164)
5	App\EventListener\CampaignTrackingSubscriber->onKernelRequest (line 43)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

2.32 ms

INSERT INTO campaign_tracking_session (session_id, utm_source, utm_medium, utm_campaign, utm_content, utm_term, utm_source_platform, utm_id, utm_adgroup, utm_adgroupid, utm_matchtype, utm_targetid, utm_placement, utm_device, persistent_user_id, is_direct_traffic, is_bot_traffic, gclid, fbclid, ttclid, msclkid, landing_page, referrer, client_ip, client_country, client_timezone, client_user_agent, browser_name, browser_version, os_name, os_version, device_type, locale, date_created, date_last_activity, page_views, conversions, has_converted, conversion_level, total_engaged_seconds, max_scroll_depth, user_client_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "9e226a4101d40b9584ffe35d4e580cee8650ff44d7cfbf0460fdccfe39e68994"
  "(direct)"
  "(none)"
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  "8d8644379bd2ca88832bdb22f20a12f38915bc5ffa2e0f95e30b596b23aae9c5"
  1
  0
  null
  null
  null
  null
  "https://dev.ekhopsychology.com/hu/terms"
  ""
  "216.73.217.54"
  "US"
  null
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
  null
  null
  null
  null
  "desktop"
  "hu"
  "2026-06-06 00:22:17"
  "2026-06-06 00:22:17"
  0
  0
  0
  0
  0
  0
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO campaign_tracking_session (
  session_id, utm_source, utm_medium,
  utm_campaign, utm_content, utm_term,
  utm_source_platform, utm_id, utm_adgroup,
  utm_adgroupid, utm_matchtype, utm_targetid,
  utm_placement, utm_device, persistent_user_id,
  is_direct_traffic, is_bot_traffic,
  gclid, fbclid, ttclid, msclkid, landing_page,
  referrer, client_ip, client_country,
  client_timezone, client_user_agent,
  browser_name, browser_version, os_name,
  os_version, device_type, locale,
  date_created, date_last_activity,
  page_views, conversions, has_converted,
  conversion_level, total_engaged_seconds,
  max_scroll_depth, user_client_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO campaign_tracking_session (session_id, utm_source, utm_medium, utm_campaign, utm_content, utm_term, utm_source_platform, utm_id, utm_adgroup, utm_adgroupid, utm_matchtype, utm_targetid, utm_placement, utm_device, persistent_user_id, is_direct_traffic, is_bot_traffic, gclid, fbclid, ttclid, msclkid, landing_page, referrer, client_ip, client_country, client_timezone, client_user_agent, browser_name, browser_version, os_name, os_version, device_type, locale, date_created, date_last_activity, page_views, conversions, has_converted, conversion_level, total_engaged_seconds, max_scroll_depth, user_client_id) VALUES ('9e226a4101d40b9584ffe35d4e580cee8650ff44d7cfbf0460fdccfe39e68994', '(direct)', '(none)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8d8644379bd2ca88832bdb22f20a12f38915bc5ffa2e0f95e30b596b23aae9c5', 1, 0, NULL, NULL, NULL, NULL, 'https://dev.ekhopsychology.com/hu/terms', '', '216.73.217.54', 'US', NULL, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])', NULL, NULL, NULL, NULL, 'desktop', 'hu', '2026-06-06 00:22:17', '2026-06-06 00:22:17', 0, 0, 0, 0, 0, 0, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\CampaignTrackingService->createTrackingSession (line 233)
7	App\Service\CampaignTrackingService->initializeSession (line 164)
8	App\EventListener\CampaignTrackingSubscriber->onKernelRequest (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 191)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

0.10 ms

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\CampaignTrackingService->createTrackingSession (line 233)
4	App\Service\CampaignTrackingService->initializeSession (line 164)
5	App\EventListener\CampaignTrackingSubscriber->onKernelRequest (line 43)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.81 ms

SELECT l0_.id AS id_0, l0_.ulid AS ulid_1, l0_.type AS type_2, l0_.locale AS locale_3, l0_.title AS title_4, l0_.version AS version_5, l0_.version_changelog AS version_changelog_6, l0_.content AS content_7, l0_.content_sha256 AS content_sha256_8, l0_.date_effective AS date_effective_9, l0_.date_created AS date_created_10, l0_.date_modified AS date_modified_11, l0_.previous_version_id AS previous_version_id_12 FROM legal_document l0_ WHERE (l0_.type = ? AND l0_.locale = ? AND l0_.date_effective <= ?) AND (l0_.locale = 'hu') ORDER BY l0_.date_created DESC LIMIT 1

Parameters:

[
  "terms"
  "hu"
  "2026-06-06 00:22:17"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.ulid AS ulid_1,
  l0_.type AS type_2,
  l0_.locale AS locale_3,
  l0_.title AS title_4,
  l0_.version AS version_5,
  l0_.version_changelog AS version_changelog_6,
  l0_.content AS content_7,
  l0_.content_sha256 AS content_sha256_8,
  l0_.date_effective AS date_effective_9,
  l0_.date_created AS date_created_10,
  l0_.date_modified AS date_modified_11,
  l0_.previous_version_id AS previous_version_id_12
FROM
  legal_document l0_
WHERE
  (
    l0_.type = ?
    AND l0_.locale = ?
    AND l0_.date_effective <= ?
  )
  AND (l0_.locale = 'hu')
ORDER BY
  l0_.date_created DESC
LIMIT
  1

SELECT l0_.id AS id_0, l0_.ulid AS ulid_1, l0_.type AS type_2, l0_.locale AS locale_3, l0_.title AS title_4, l0_.version AS version_5, l0_.version_changelog AS version_changelog_6, l0_.content AS content_7, l0_.content_sha256 AS content_sha256_8, l0_.date_effective AS date_effective_9, l0_.date_created AS date_created_10, l0_.date_modified AS date_modified_11, l0_.previous_version_id AS previous_version_id_12 FROM legal_document l0_ WHERE (l0_.type = 'terms' AND l0_.locale = 'hu' AND l0_.date_effective <= '2026-06-06 00:22:17') AND (l0_.locale = 'hu') ORDER BY l0_.date_created DESC LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Repository\LegalDocumentRepository->findActiveByType (line 112)
7	App\Controller\PublicLegalDocumentController->terms (line 29)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	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
App\Entity\CampaignTrackingSession	1

Entities Mapping

Class	Mapping errors
App\Entity\CampaignTrackingSession	No errors.
App\Entity\CampaignTrackingEvent	No errors.
App\Embeddable\Legal	No errors.
App\Entity\UserClient	No errors.
App\Entity\LegalDocument	No errors.

Symfony Profiler

GET https://dev.ekhopsychology.com/hu/terms

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping