Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.13 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.39 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.64 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:

[
  "c4e92e48d9cef37f68da8cd3a07a1b81365cd1b5454d5727ff471838e53ded93"
  "(direct)"
  "(none)"
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  "791b9c5ccea3d79cab83654e330133aa95b1f96be2f21fba51c9450912635da7"
  1
  0
  null
  null
  null
  null
  "https://dev.ekhopsychology.com/"
  ""
  "216.73.217.98"
  "US"
  null
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
  null
  null
  null
  null
  "desktop"
  "en"
  "2026-06-13 03:56:35"
  "2026-06-13 03:56:35"
  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 ('c4e92e48d9cef37f68da8cd3a07a1b81365cd1b5454d5727ff471838e53ded93', '(direct)', '(none)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '791b9c5ccea3d79cab83654e330133aa95b1f96be2f21fba51c9450912635da7', 1, 0, NULL, NULL, NULL, NULL, 'https://dev.ekhopsychology.com/', '', '216.73.217.98', 'US', NULL, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])', NULL, NULL, NULL, NULL, 'desktop', 'en', '2026-06-13 03:56:35', '2026-06-13 03:56:35', 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)

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.

Symfony Profiler

GET https://dev.ekhopsychology.com/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping