Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

0.81 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.43 ms

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.utm_source AS utm_source_3, t0.utm_medium AS utm_medium_4, t0.utm_campaign AS utm_campaign_5, t0.utm_content AS utm_content_6, t0.utm_term AS utm_term_7, t0.utm_source_platform AS utm_source_platform_8, t0.utm_id AS utm_id_9, t0.utm_adgroup AS utm_adgroup_10, t0.utm_adgroupid AS utm_adgroupid_11, t0.utm_matchtype AS utm_matchtype_12, t0.utm_targetid AS utm_targetid_13, t0.utm_placement AS utm_placement_14, t0.utm_device AS utm_device_15, t0.persistent_user_id AS persistent_user_id_16, t0.is_direct_traffic AS is_direct_traffic_17, t0.is_bot_traffic AS is_bot_traffic_18, t0.gclid AS gclid_19, t0.fbclid AS fbclid_20, t0.ttclid AS ttclid_21, t0.msclkid AS msclkid_22, t0.landing_page AS landing_page_23, t0.referrer AS referrer_24, t0.client_ip AS client_ip_25, t0.client_country AS client_country_26, t0.client_timezone AS client_timezone_27, t0.client_user_agent AS client_user_agent_28, t0.browser_name AS browser_name_29, t0.browser_version AS browser_version_30, t0.os_name AS os_name_31, t0.os_version AS os_version_32, t0.device_type AS device_type_33, t0.locale AS locale_34, t0.date_created AS date_created_35, t0.date_last_activity AS date_last_activity_36, t0.page_views AS page_views_37, t0.conversions AS conversions_38, t0.has_converted AS has_converted_39, t0.conversion_level AS conversion_level_40, t0.total_engaged_seconds AS total_engaged_seconds_41, t0.max_scroll_depth AS max_scroll_depth_42, t0.user_client_id AS user_client_id_43 FROM campaign_tracking_session t0 WHERE t0.session_id = ? LIMIT 1

Parameters:

[
  "bd7daf0f82c8a0cb6923e26b252f15a972aee49b03c98a3da974d41a1a49e52a"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.utm_source AS utm_source_3,
  t0.utm_medium AS utm_medium_4,
  t0.utm_campaign AS utm_campaign_5,
  t0.utm_content AS utm_content_6,
  t0.utm_term AS utm_term_7,
  t0.utm_source_platform AS utm_source_platform_8,
  t0.utm_id AS utm_id_9,
  t0.utm_adgroup AS utm_adgroup_10,
  t0.utm_adgroupid AS utm_adgroupid_11,
  t0.utm_matchtype AS utm_matchtype_12,
  t0.utm_targetid AS utm_targetid_13,
  t0.utm_placement AS utm_placement_14,
  t0.utm_device AS utm_device_15,
  t0.persistent_user_id AS persistent_user_id_16,
  t0.is_direct_traffic AS is_direct_traffic_17,
  t0.is_bot_traffic AS is_bot_traffic_18,
  t0.gclid AS gclid_19,
  t0.fbclid AS fbclid_20,
  t0.ttclid AS ttclid_21,
  t0.msclkid AS msclkid_22,
  t0.landing_page AS landing_page_23,
  t0.referrer AS referrer_24,
  t0.client_ip AS client_ip_25,
  t0.client_country AS client_country_26,
  t0.client_timezone AS client_timezone_27,
  t0.client_user_agent AS client_user_agent_28,
  t0.browser_name AS browser_name_29,
  t0.browser_version AS browser_version_30,
  t0.os_name AS os_name_31,
  t0.os_version AS os_version_32,
  t0.device_type AS device_type_33,
  t0.locale AS locale_34,
  t0.date_created AS date_created_35,
  t0.date_last_activity AS date_last_activity_36,
  t0.page_views AS page_views_37,
  t0.conversions AS conversions_38,
  t0.has_converted AS has_converted_39,
  t0.conversion_level AS conversion_level_40,
  t0.total_engaged_seconds AS total_engaged_seconds_41,
  t0.max_scroll_depth AS max_scroll_depth_42,
  t0.user_client_id AS user_client_id_43
FROM
  campaign_tracking_session t0
WHERE
  t0.session_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.utm_source AS utm_source_3, t0.utm_medium AS utm_medium_4, t0.utm_campaign AS utm_campaign_5, t0.utm_content AS utm_content_6, t0.utm_term AS utm_term_7, t0.utm_source_platform AS utm_source_platform_8, t0.utm_id AS utm_id_9, t0.utm_adgroup AS utm_adgroup_10, t0.utm_adgroupid AS utm_adgroupid_11, t0.utm_matchtype AS utm_matchtype_12, t0.utm_targetid AS utm_targetid_13, t0.utm_placement AS utm_placement_14, t0.utm_device AS utm_device_15, t0.persistent_user_id AS persistent_user_id_16, t0.is_direct_traffic AS is_direct_traffic_17, t0.is_bot_traffic AS is_bot_traffic_18, t0.gclid AS gclid_19, t0.fbclid AS fbclid_20, t0.ttclid AS ttclid_21, t0.msclkid AS msclkid_22, t0.landing_page AS landing_page_23, t0.referrer AS referrer_24, t0.client_ip AS client_ip_25, t0.client_country AS client_country_26, t0.client_timezone AS client_timezone_27, t0.client_user_agent AS client_user_agent_28, t0.browser_name AS browser_name_29, t0.browser_version AS browser_version_30, t0.os_name AS os_name_31, t0.os_version AS os_version_32, t0.device_type AS device_type_33, t0.locale AS locale_34, t0.date_created AS date_created_35, t0.date_last_activity AS date_last_activity_36, t0.page_views AS page_views_37, t0.conversions AS conversions_38, t0.has_converted AS has_converted_39, t0.conversion_level AS conversion_level_40, t0.total_engaged_seconds AS total_engaged_seconds_41, t0.max_scroll_depth AS max_scroll_depth_42, t0.user_client_id AS user_client_id_43 FROM campaign_tracking_session t0 WHERE t0.session_id = 'bd7daf0f82c8a0cb6923e26b252f15a972aee49b03c98a3da974d41a1a49e52a' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Service\CampaignTrackingService->initializeSession (line 134)
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.11 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->initializeSession (line 155)
4	App\EventListener\CampaignTrackingSubscriber->onKernelRequest (line 43)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.19 ms

UPDATE campaign_tracking_session SET date_last_activity = ? WHERE id = ?

Parameters:

[
  "2026-06-05 22:35:24"
  29745
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  campaign_tracking_session
SET
  date_last_activity = ?
WHERE
  id = ?

UPDATE campaign_tracking_session SET date_last_activity = '2026-06-05 22:35:24' WHERE id = 29745;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\CampaignTrackingService->initializeSession (line 155)
7	App\EventListener\CampaignTrackingSubscriber->onKernelRequest (line 43)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 191)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.08 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->initializeSession (line 155)
4	App\EventListener\CampaignTrackingSubscriber->onKernelRequest (line 43)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	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\Embeddable\Legal	No errors.
App\Entity\UserClient	No errors.
App\Entity\CampaignTrackingEvent	No errors.

Symfony Profiler

GET https://dev.ekhopsychology.com/en

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping