Query Metrics
14
Database Queries
11
Different statements
2.86 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.35 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:
[
"9afeb9b3bcc574e652881824d319d00aee309488cd16bce220cc6d946ce8f887"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.12 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 3 | 0.22 ms |
UPDATE campaign_tracking_session SET date_last_activity = ? WHERE id = ?
Parameters:
[ "2026-06-06 03:36:04" 29785 ] |
||||||||||||||||||||||||||||||||
| 4 | 0.09 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 5 | 0.32 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name_first AS name_first_5, t0.name_last AS name_last_6, t0.name_prefix AS name_prefix_7, t0.name_suffix AS name_suffix_8, t0.image AS image_9, t0.phone_number AS phone_number_10, t0.date_email_verified AS date_email_verified_11, t0.date_phone_verified AS date_phone_verified_12, t0.user_tag AS user_tag_13, t0.date_created AS date_created_14, t0.date_modified AS date_modified_15, t0.date_inactivated AS date_inactivated_16, t0.date_login AS date_login_17, t0.calendar_feed_token AS calendar_feed_token_18, t0.timezone AS timezone_19, t0.vat_exemption AS vat_exemption_20, t0.healthcare_provider AS healthcare_provider_21, t0.default_cancellation_deadline_hours AS default_cancellation_deadline_hours_22, t0.default_lead_time_hours AS default_lead_time_hours_23, t0.allow_self_service_cancellation AS allow_self_service_cancellation_24, t0.payment_timing AS payment_timing_25, t0.address_country AS address_country_26, t0.address_zip AS address_zip_27, t0.address_city AS address_city_28, t0.address_line1 AS address_line1_29, t0.company_name AS company_name_30, t0.company_id AS company_id_31, t0.company_tax_id AS company_tax_id_32, t0.company_tax_country AS company_tax_country_33, t0.company_type AS company_type_34, t0.company_invoice_prefix AS company_invoice_prefix_35, t0.company_bank_id AS company_bank_id_36, t0.company_bank_name AS company_bank_name_37, t0.company_bank_iban AS company_bank_iban_38, t0.company_bank_swift AS company_bank_swift_39, t0.company_bank_address AS company_bank_address_40, t0.invoice_api_user AS invoice_api_user_41, t0.invoice_api_password AS invoice_api_password_42, t0.invoice_api_xml_signature_key AS invoice_api_xml_signature_key_43, t0.invoice_api_xml_exchange_key AS invoice_api_xml_exchange_key_44, t0.invoice_api_counter AS invoice_api_counter_45, t0.stripe_publishable_key AS stripe_publishable_key_46, t0.stripe_secret_key AS stripe_secret_key_47, t0.stripe_webhook_secret AS stripe_webhook_secret_48, t0.stripe_enabled AS stripe_enabled_49 FROM user_admin t0 WHERE t0.user_tag = ? LIMIT 1
Parameters:
[
"oklein"
]
|
||||||||||||||||||||||||||||||||
| 6 | 0.27 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.profession AS profession_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.user_admin_id AS user_admin_id_6 FROM expert_profile t0 WHERE t0.user_admin_id = ? AND ((t0.locale = 'sv'))
Parameters:
[
10
]
|
||||||||||||||||||||||||||||||||
| 7 | 0.17 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.profession AS profession_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.user_admin_id AS user_admin_id_7 FROM expert_profile t0 WHERE t0.user_admin_id = ?
Parameters:
[
10
]
|
||||||||||||||||||||||||||||||||
| 8 | 0.28 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_44 FROM campaign_tracking_session t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
"9afeb9b3bcc574e652881824d319d00aee309488cd16bce220cc6d946ce8f887"
]
|
||||||||||||||||||||||||||||||||
| 9 | 0.24 ms |
SELECT t0.id AS id_1, t0.asset_type AS asset_type_2, t0.placement AS placement_3, t0.enabled AS enabled_4, t0.sort_order AS sort_order_5, t0.file_path AS file_path_6, t0.data AS data_7, t0.date_created AS date_created_8, t0.date_modified AS date_modified_9, t0.expert_profile_id AS expert_profile_id_10, t0.tag_id AS tag_id_11 FROM expert_profile_asset t0 WHERE t0.expert_profile_id = ? AND ((t0.enabled = TRUE)) ORDER BY t0.sort_order ASC
Parameters:
[
24
]
|
||||||||||||||||||||||||||||||||
| 10 | 0.25 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_44 FROM campaign_tracking_session t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
"9afeb9b3bcc574e652881824d319d00aee309488cd16bce220cc6d946ce8f887"
]
|
||||||||||||||||||||||||||||||||
| 11 | 0.09 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 12 | 0.24 ms |
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.com/sv/contact/oklein" "Kontakt - ekho psychology" "2026-06-06 03:36:04" null 29785 null null null ] |
||||||||||||||||||||||||||||||||
| 13 | 0.12 ms |
UPDATE campaign_tracking_session SET date_last_activity = ?, page_views = ? WHERE id = ?
Parameters:
[ "2026-06-06 03:36:04" 2 29785 ] |
||||||||||||||||||||||||||||||||
| 14 | 0.08 ms |
"COMMIT"
Parameters:
[]
|
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\ExpertProfile | 2 |
| App\Entity\CampaignTrackingSession | 1 |
| App\Entity\UserAdmin | 1 |
| App\Entity\CampaignTrackingEvent | 1 |