Redirect 302 redirect from GET @index (52c71c)

GET https://dev.ekhopsychology.com/en/expert/lars-svensson

Response
200 OK
Browse referrer URL
IP
216.73.217.54
Profiled on
Token
90b74e

Query Metrics

69 Database Queries
20 Different statements
30.72 ms Query time
0 Invalid entities
34 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.34 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
2 0.10 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.17 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
4 0.07 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.50 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: 
[
  "lars-svensson"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.21 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 = 'en'))
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.42 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: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
8 2.79 ms 
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 = 'en'))
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
9 2.43 ms 
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 = 'en') 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 = 'en') 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: 
[
  1
  "topic"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.23 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: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.33 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: 
[
  "bd7daf0f82c8a0cb6923e26b252f15a972aee49b03c98a3da974d41a1a49e52a"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 1.31 ms 
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 = 'en') AND (t0.public = TRUE))
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
13 1.67 ms 
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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
14 2.11 ms 
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 = 'en')) ORDER BY t0.number_of_consultations ASC
Parameters: 
[
  1
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.19 ms 
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 = 'en')) ORDER BY t0.number_of_consultations ASC
Parameters: 
[
  2
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.23 ms 
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 = 'en')) ORDER BY t0.number_of_consultations ASC
Parameters: 
[
  69
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.38 ms 
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 = 'en') AND (t0.public = TRUE))
Parameters: 
[
  1
  1
  "en"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
18 3.06 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.15 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 1.41 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-06-08 08:59:59"
  "2026-06-01 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.62 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-06-01 09:00:00"
  "2026-06-08 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.15 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.20 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-06-15 08:59:59"
  "2026-06-08 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.22 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-06-08 09:00:00"
  "2026-06-15 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.15 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.17 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-06-22 08:59:59"
  "2026-06-15 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.21 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-06-15 09:00:00"
  "2026-06-22 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.16 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.17 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-06-29 08:59:59"
  "2026-06-22 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.17 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-06-22 09:00:00"
  "2026-06-29 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.15 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.15 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-07-06 08:59:59"
  "2026-06-29 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.19 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-06-29 09:00:00"
  "2026-07-06 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.15 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.16 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-07-13 08:59:59"
  "2026-07-06 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.20 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-07-06 09:00:00"
  "2026-07-13 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.18 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.25 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-07-20 08:59:59"
  "2026-07-13 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.15 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-07-13 09:00:00"
  "2026-07-20 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.18 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.19 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-07-27 08:59:59"
  "2026-07-20 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.17 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-07-20 09:00:00"
  "2026-07-27 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.15 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.17 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-08-03 08:59:59"
  "2026-07-27 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.15 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-07-27 09:00:00"
  "2026-08-03 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.12 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.15 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-08-10 08:59:59"
  "2026-08-03 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.15 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-08-03 09:00:00"
  "2026-08-10 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.17 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.16 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-08-17 08:59:59"
  "2026-08-10 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.19 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-08-10 09:00:00"
  "2026-08-17 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.12 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.15 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-08-24 08:59:59"
  "2026-08-17 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.14 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-08-17 09:00:00"
  "2026-08-24 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.27 ms 
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 = 'en') AND (t0.public = TRUE))
Parameters: 
[
  1
  1
  "en"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.19 ms 
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 = 'en') AND (t0.public = TRUE))
Parameters: 
[
  1
  1
  "en"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.19 ms 
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 = 'en') AND (t0.public = TRUE))
Parameters: 
[
  1
  1
  "en"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.18 ms 
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 = 'en') AND (t0.public = TRUE))
Parameters: 
[
  1
  1
  "en"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.18 ms 
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 = 'en') AND (t0.public = TRUE))
Parameters: 
[
  1
  1
  "en"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.18 ms 
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 = 'en') AND (t0.public = TRUE))
Parameters: 
[
  1
  1
  "en"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.19 ms 
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 = 'en') AND (t0.public = TRUE))
Parameters: 
[
  1
  1
  "en"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.24 ms 
DELETE FROM appointment WHERE status = ? AND user_client_id IS NULL AND ((date_modified < ? OR date_created < ?))
Parameters: 
[
  "booking_in_progress"
  "2026-06-05 22:32:24"
  "2026-06-04 22:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.20 ms 
SELECT e0_.id AS id_0, e0_.date_start_utc AS date_start_utc_1, e0_.date_end_utc AS date_end_utc_2, e0_.date_created AS date_created_3, e0_.date_modified AS date_modified_4, e0_.user_admin_id AS user_admin_id_5 FROM expert_availability e0_ WHERE e0_.user_admin_id = ? AND e0_.date_start_utc < ? AND e0_.date_end_utc >= ? AND e0_.date_start_utc >= ?
Parameters: 
[
  1
  "2026-06-08 08:59:59"
  "2026-06-01 09:00:00"
  "2026-06-06 01:35:24"
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.24 ms 
SELECT a0_.id AS id_0, a0_.date_start_utc AS date_start_utc_1, a0_.date_end_utc AS date_end_utc_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.date_cancelled AS date_cancelled_5, a0_.comment AS comment_6, a0_.status AS status_7, a0_.booking_token AS booking_token_8, a0_.cancellation_token AS cancellation_token_9, a0_.created_by_admin AS created_by_admin_10, a0_.ical_sequence AS ical_sequence_11, a0_.client_ip AS client_ip_12, a0_.client_country AS client_country_13, a0_.client_timezone AS client_timezone_14, a0_.client_user_agent AS client_user_agent_15, a0_.user_admin_id AS user_admin_id_16, a0_.expert_service_id AS expert_service_id_17, a0_.user_client_id AS user_client_id_18, a0_.campaign_tracking_session_id AS campaign_tracking_session_id_19 FROM appointment a0_ WHERE a0_.user_admin_id = ? AND a0_.date_start_utc >= ? AND a0_.date_start_utc <= ? AND a0_.status <> ?
Parameters: 
[
  1
  "2026-06-01 09:00:00"
  "2026-06-08 08:59:59"
  "cancelled"
]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.26 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: 
[
  "bd7daf0f82c8a0cb6923e26b252f15a972aee49b03c98a3da974d41a1a49e52a"
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.11 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
67 3.77 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/en/expert/lars-svensson"
  "Lars Svensson - licensed psychologist"
  "2026-06-05 22:35:24"
  null
  29745
  null
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.16 ms 
UPDATE campaign_tracking_session SET date_last_activity = ?, page_views = ? WHERE id = ?
Parameters: 
[
  "2026-06-05 22:35:24"
  1
  29745
]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.07 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\ExpertProfileAsset 11
App\Entity\ExpertProfile 3
App\Entity\ExpertService 3
App\Entity\CampaignTrackingSession 1
App\Entity\UserAdmin 1
App\Entity\CampaignTrackingEvent 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.
App\ValueObject\Address No errors.
App\ValueObject\CompanyDetails No errors.
App\ValueObject\InvoiceApiDetails No errors.
App\ValueObject\StripeApiDetails No errors.
App\Entity\UserAdmin No errors.
App\Entity\BlogArticle No errors.
App\ValueObject\Contract\IdentitySnapshot No errors.
App\ValueObject\Contract\ClientSnapshot No errors.
App\ValueObject\Contract\ExpertSnapshot No errors.
App\ValueObject\Contract\PricingSnapshot No errors.
App\ValueObject\Contract\AllowanceSnapshot No errors.
App\ValueObject\Contract\PaymentSnapshot No errors.
App\ValueObject\Contract\PolicySnapshot No errors.
App\ValueObject\Contract\TermsSnapshot No errors.
App\Entity\Contract No errors.
App\Entity\ExpertProfile No errors.
App\Entity\ContactForm No errors.
App\Entity\ExpertAvailability No errors.
App\Entity\Appointment No errors.
App\Entity\ExpertService No errors.
App\Entity\ExpertProfileAsset No errors.
App\Entity\Tag No errors.
Tbbc\MoneyBundle\Entity\DoctrineStorageRatio No errors.
App\Entity\ExpertServicePlan No errors.
App\Entity\GoogleLeadFormEntry No errors.