Symfony Profiler

Query Metrics

9 Database Queries

6 Different statements

3.92 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.94 ms
(49.42%)

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:

[
  "d507958b4d122eafad551f07c406abd63203263b4d04b763ea5ae781d91ef1f6"
  "(direct)"
  "(none)"
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  "192724a4316adb1c91bc9a9a29b3ab152bbb19fd2036146aa26ad178d057add7"
  1
  0
  null
  null
  null
  null
  "https://dev.ekhopsychology.se/en/faq"
  ""
  "216.73.217.140"
  "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-15 03:20:26"
  "2026-06-15 03:20:26"
  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 ('d507958b4d122eafad551f07c406abd63203263b4d04b763ea5ae781d91ef1f6', '(direct)', '(none)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '192724a4316adb1c91bc9a9a29b3ab152bbb19fd2036146aa26ad178d057add7', 1, 0, NULL, NULL, NULL, NULL, 'https://dev.ekhopsychology.se/en/faq', '', '216.73.217.140', '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-15 03:20:26', '2026-06-15 03:20:26', 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.64 ms
(16.37%)

INSERT INTO campaign_tracking_event (event_type, page_url, page_title, date_created, metadata, campaign_tracking_session_id, appointment_id, contact_form_id, google_lead_form_entry_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "page_view"
  "https://dev.ekhopsychology.se/en/faq"
  " FAQ "
  "2026-06-15 03:20:26"
  null
  29852
  null
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO campaign_tracking_event (
  event_type, page_url, page_title,
  date_created, metadata, campaign_tracking_session_id,
  appointment_id, contact_form_id,
  google_lead_form_entry_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO campaign_tracking_event (event_type, page_url, page_title, date_created, metadata, campaign_tracking_session_id, appointment_id, contact_form_id, google_lead_form_entry_id) VALUES ('page_view', 'https://dev.ekhopsychology.se/en/faq', ' FAQ ', '2026-06-15 03:20:26', NULL, 29852, NULL, NULL, 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->trackPageView (line 474)
7	App\EventListener\CampaignTrackingSubscriber->onKernelResponse (line 75)
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->filterResponse (line 216)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
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.60 ms
(15.44%)

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:

[
  "d507958b4d122eafad551f07c406abd63203263b4d04b763ea5ae781d91ef1f6"
]

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 = 'd507958b4d122eafad551f07c406abd63203263b4d04b763ea5ae781d91ef1f6' 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->getCurrentSession (line 601)
5	App\Service\CampaignTrackingService->getCurrentSessionId (line 609)
6	App\Service\CampaignTrackingService->getOrCreateSessionId (line 633)
7	App\Twig\CampaignTrackingExtension->getSessionId (line 30)
8	__TwigTemplate_d3f1b93f0708e886e27a2e5fc8ba65d2->doDisplay (line 150)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_4c43e7f51a60df51aac1719d428295d1->doDisplay (line 57)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
19	App\Controller\PublicSiteController->show_faq (line 235)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 191)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

0.36 ms
(9.27%)

"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.20 ms
(5.11%)

"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)

0.17 ms
(4.39%)

UPDATE campaign_tracking_session SET date_last_activity = ?, page_views = ? WHERE id = ?

Parameters:

[
  "2026-06-15 03:20:26"
  1
  29852
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  campaign_tracking_session
SET
  date_last_activity = ?,
  page_views = ?
WHERE
  id = ?

UPDATE campaign_tracking_session SET date_last_activity = '2026-06-15 03:20:26', page_views = 1 WHERE id = 29852;

#	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->trackPageView (line 474)
7	App\EventListener\CampaignTrackingSubscriber->onKernelResponse (line 75)
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->filterResponse (line 216)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
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)

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
App\Entity\CampaignTrackingEvent	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\Appointment	No errors.
App\Entity\ContactForm	No errors.
App\Entity\GoogleLeadFormEntry	No errors.

Symfony Profiler

GET https://dev.ekhopsychology.se/en/faq

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping