Query Metrics
33
Database Queries
17
Different statements
11.90 ms
Query time
0
Invalid entities
26
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.41 ms (20.28%) |
9 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.price_minor AS price_minor_4, t0.price_unit AS price_unit_5, t0.price_currency AS price_currency_6, t0.price_vat AS price_vat_7, t0.location AS location_8, t0.date_created AS date_created_9, t0.date_modified AS date_modified_10, t0.public AS public_11, t0.excluded_countries AS excluded_countries_12, t0.bookable AS bookable_13, t0.duration_minutes AS duration_minutes_14, t0.expert_profile_id AS expert_profile_id_15 FROM expert_service t0 WHERE t0.public = ? AND t0.bookable = ? AND t0.locale = ? AND t0.expert_profile_id = ? AND ((t0.locale = 'hu') AND (t0.public = TRUE))
Parameters:
[ 1 1 "hu" 2 ] |
||||||||||||||||||||||||||||||||||||
|
1.60 ms (13.45%) |
6 |
SELECT t0.id AS id_1, t0.ulid AS ulid_2, t0.locale AS locale_3, t0.name AS name_4, t0.number_of_consultations AS number_of_consultations_5, t0.plan_total_amount_minor AS plan_total_amount_minor_6, t0.plan_total_amount_currency AS plan_total_amount_currency_7, t0.offer_expiration_months AS offer_expiration_months_8, t0.is_public AS is_public_9, t0.date_created AS date_created_10, t0.date_modified AS date_modified_11, t0.expert_service_id AS expert_service_id_12 FROM expert_service_plan t0 WHERE t0.expert_service_id = ? AND t0.is_public = ? AND ((t0.locale = 'hu')) ORDER BY t0.number_of_consultations ASC
Parameters:
[ 4 1 ] |
||||||||||||||||||||||||||||||||||||
|
1.26 ms (10.56%) |
1 |
SELECT e0_.id AS id_0, e0_.asset_type AS asset_type_1, e0_.placement AS placement_2, e0_.enabled AS enabled_3, e0_.sort_order AS sort_order_4, e0_.file_path AS file_path_5, e0_.data AS data_6, e0_.date_created AS date_created_7, e0_.date_modified AS date_modified_8, t1_.id AS id_9, t1_.date_created AS date_created_10, t1_.date_modified AS date_modified_11, t1_.locale AS locale_12, t1_.name AS name_13, t1_.slug AS slug_14, t1_.description AS description_15, b2_.id AS id_16, b2_.title AS title_17, b2_.content AS content_18, b2_.published AS published_19, b2_.summary AS summary_20, b2_.slug AS slug_21, b2_.date_created AS date_created_22, b2_.date_modified AS date_modified_23, b2_.date_published AS date_published_24, b2_.thumbnail AS thumbnail_25, b2_.locale AS locale_26, u3_.id AS id_27, u3_.email AS email_28, u3_.roles AS roles_29, u3_.password AS password_30, u3_.name_first AS name_first_31, u3_.name_last AS name_last_32, u3_.name_prefix AS name_prefix_33, u3_.name_suffix AS name_suffix_34, u3_.image AS image_35, u3_.phone_number AS phone_number_36, u3_.date_email_verified AS date_email_verified_37, u3_.date_phone_verified AS date_phone_verified_38, u3_.user_tag AS user_tag_39, u3_.date_created AS date_created_40, u3_.date_modified AS date_modified_41, u3_.date_inactivated AS date_inactivated_42, u3_.date_login AS date_login_43, u3_.calendar_feed_token AS calendar_feed_token_44, u3_.timezone AS timezone_45, u3_.vat_exemption AS vat_exemption_46, u3_.healthcare_provider AS healthcare_provider_47, u3_.default_cancellation_deadline_hours AS default_cancellation_deadline_hours_48, u3_.default_lead_time_hours AS default_lead_time_hours_49, u3_.allow_self_service_cancellation AS allow_self_service_cancellation_50, u3_.payment_timing AS payment_timing_51, u3_.address_country AS address_country_52, u3_.address_zip AS address_zip_53, u3_.address_city AS address_city_54, u3_.address_line1 AS address_line1_55, u3_.company_name AS company_name_56, u3_.company_id AS company_id_57, u3_.company_tax_id AS company_tax_id_58, u3_.company_tax_country AS company_tax_country_59, u3_.company_type AS company_type_60, u3_.company_invoice_prefix AS company_invoice_prefix_61, u3_.company_bank_id AS company_bank_id_62, u3_.company_bank_name AS company_bank_name_63, u3_.company_bank_iban AS company_bank_iban_64, u3_.company_bank_swift AS company_bank_swift_65, u3_.company_bank_address AS company_bank_address_66, u3_.invoice_api_user AS invoice_api_user_67, u3_.invoice_api_password AS invoice_api_password_68, u3_.invoice_api_xml_signature_key AS invoice_api_xml_signature_key_69, u3_.invoice_api_xml_exchange_key AS invoice_api_xml_exchange_key_70, u3_.invoice_api_counter AS invoice_api_counter_71, u3_.stripe_publishable_key AS stripe_publishable_key_72, u3_.stripe_secret_key AS stripe_secret_key_73, u3_.stripe_webhook_secret AS stripe_webhook_secret_74, u3_.stripe_enabled AS stripe_enabled_75, e0_.expert_profile_id AS expert_profile_id_76, e0_.tag_id AS tag_id_77, b2_.author_id AS author_id_78 FROM expert_profile_asset e0_ LEFT JOIN tag t1_ ON e0_.tag_id = t1_.id AND (t1_.locale = 'hu') LEFT JOIN blog_article_tag b4_ ON t1_.id = b4_.tag_id LEFT JOIN blog_article b2_ ON b2_.id = b4_.blog_article_id AND (b2_.date_published < NOW() AND b2_.published = TRUE) AND (b2_.locale = 'hu') LEFT JOIN user_admin u3_ ON b2_.author_id = u3_.id WHERE (e0_.expert_profile_id = ? AND e0_.asset_type = ? AND e0_.enabled = ?) AND (e0_.enabled = TRUE) ORDER BY e0_.sort_order ASC, e0_.date_created DESC
Parameters:
[ 2 "topic" 1 ]
|
||||||||||||||||||||||||||||||||||||
|
1.09 ms (9.18%) |
1 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_modified AS date_modified_3, t0.locale AS locale_4, t0.name AS name_5, t0.slug AS slug_6, t0.description AS description_7 FROM tag t0 INNER JOIN expert_profile_tag ON t0.id = expert_profile_tag.tag_id WHERE expert_profile_tag.expert_profile_id = ? AND ((t0.locale = 'hu'))
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||||||||
|
0.96 ms (8.04%) |
1 |
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/hu/expert/lars-svensson" "Svensson Lars - licensed psychologist" "2026-06-06 00:22:18" null 29764 null null null ] |
||||||||||||||||||||||||||||||||||||
|
0.94 ms (7.93%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.price_minor AS price_minor_4, t0.price_unit AS price_unit_5, t0.price_currency AS price_currency_6, t0.price_vat AS price_vat_7, t0.location AS location_8, t0.date_created AS date_created_9, t0.date_modified AS date_modified_10, t0.public AS public_11, t0.excluded_countries AS excluded_countries_12, t0.bookable AS bookable_13, t0.duration_minutes AS duration_minutes_14, t0.expert_profile_id AS expert_profile_id_15 FROM expert_service t0 WHERE t0.expert_profile_id = ? AND ((t0.locale = 'hu') AND (t0.public = TRUE))
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||||||||
|
0.86 ms (7.23%) |
1 |
SELECT t0.currency_code AS currency_code_1, t0.ratio AS ratio_2, t0.id AS id_3 FROM tbbc_money_doctrine_storage_ratios t0
Parameters:
[] |
||||||||||||||||||||||||||||||||||||
|
0.57 ms (4.79%) |
2 |
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:
[
"08819711dbd57013b1b0439e3ffd6f957b5968dc5ba1638cf2af6c3ab9a3a4a3"
]
|
||||||||||||||||||||||||||||||||||||
|
0.44 ms (3.69%) |
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 = ? LIMIT 1
Parameters:
[
"08819711dbd57013b1b0439e3ffd6f957b5968dc5ba1638cf2af6c3ab9a3a4a3"
]
|
||||||||||||||||||||||||||||||||||||
|
0.36 ms (2.99%) |
1 |
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:
[
"lars-svensson"
]
|
||||||||||||||||||||||||||||||||||||
|
0.30 ms (2.49%) |
1 |
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 = 'hu'))
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||||
|
0.22 ms (1.85%) |
1 |
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:
[
2
]
|
||||||||||||||||||||||||||||||||||||
|
0.19 ms (1.63%) |
2 |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||||||
|
0.19 ms (1.60%) |
1 |
UPDATE campaign_tracking_session SET date_last_activity = ? WHERE id = ?
Parameters:
[ "2026-06-06 00:22:18" 29764 ] |
||||||||||||||||||||||||||||||||||||
|
0.18 ms (1.51%) |
1 |
UPDATE campaign_tracking_session SET date_last_activity = ?, page_views = ? WHERE id = ?
Parameters:
[ "2026-06-06 00:22:18" 1 29764 ] |
||||||||||||||||||||||||||||||||||||
|
0.17 ms (1.44%) |
2 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||||||
|
0.16 ms (1.36%) |
1 |
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:
[
1
]
|
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 |
|---|---|
| Tbbc\MoneyBundle\Entity\DoctrineStorageRatio | 14 |
| App\Entity\ExpertService | 6 |
| App\Entity\ExpertProfile | 3 |
| App\Entity\CampaignTrackingSession | 1 |
| App\Entity\UserAdmin | 1 |
| App\Entity\CampaignTrackingEvent | 1 |