Symfony Profiler

[
  "route" => "contact_tag"
  "route_parameters" => [
    "_route" => "contact_tag"
    "_controller" => "App\Controller\PublicContactController::show_contact_tag"
    "_locale" => "hu"
    "tag" => "xmccullough"
  ]
  "request_uri" => "https://dev.ekhopsychology.com/hu/contact/xmccullough"
  "method" => "GET"
]

[
  "ip" => "216.73.217.54"
]

[
  "ip" => "216.73.217.54"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "vujdv_ekhopsychology_dev"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "vujdv_ekhopsychology_dev"
    "serverVersion" => "8.0.41"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "5766775c1d1020a8c4eebbb90708055d2e728085436c1a88a96f7182bbec5b0f"
    2 => "(direct)"
    3 => "(none)"
    4 => null
    5 => null
    6 => null
    7 => null
    8 => null
    9 => null
    10 => null
    11 => null
    12 => null
    13 => null
    14 => null
    15 => "8d8644379bd2ca88832bdb22f20a12f38915bc5ffa2e0f95e30b596b23aae9c5"
    16 => 1
    17 => 0
    18 => null
    19 => null
    20 => null
    21 => null
    22 => "https://dev.ekhopsychology.com/hu/contact/xmccullough"
    23 => ""
    24 => "216.73.217.54"
    25 => "US"
    26 => null
    27 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
    28 => null
    29 => null
    30 => null
    31 => null
    32 => "desktop"
    33 => "hu"
    34 => "2026-06-06 03:43:19"
    35 => "2026-06-06 03:43:19"
    36 => 0
    37 => 0
    38 => 0
    39 => 0
    40 => 0
    41 => 0
    42 => null
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#832
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#832}
    3 => Doctrine\DBAL\ParameterType {#832}
    4 => Doctrine\DBAL\ParameterType {#832}
    5 => Doctrine\DBAL\ParameterType {#832}
    6 => Doctrine\DBAL\ParameterType {#832}
    7 => Doctrine\DBAL\ParameterType {#832}
    8 => Doctrine\DBAL\ParameterType {#832}
    9 => Doctrine\DBAL\ParameterType {#832}
    10 => Doctrine\DBAL\ParameterType {#832}
    11 => Doctrine\DBAL\ParameterType {#832}
    12 => Doctrine\DBAL\ParameterType {#832}
    13 => Doctrine\DBAL\ParameterType {#832}
    14 => Doctrine\DBAL\ParameterType {#832}
    15 => Doctrine\DBAL\ParameterType {#832}
    16 => Doctrine\DBAL\ParameterType {#833
      +name: "BOOLEAN"
    }
    17 => Doctrine\DBAL\ParameterType {#833}
    18 => Doctrine\DBAL\ParameterType {#832}
    19 => Doctrine\DBAL\ParameterType {#832}
    20 => Doctrine\DBAL\ParameterType {#832}
    21 => Doctrine\DBAL\ParameterType {#832}
    22 => Doctrine\DBAL\ParameterType {#832}
    23 => Doctrine\DBAL\ParameterType {#832}
    24 => Doctrine\DBAL\ParameterType {#832}
    25 => Doctrine\DBAL\ParameterType {#832}
    26 => Doctrine\DBAL\ParameterType {#832}
    27 => Doctrine\DBAL\ParameterType {#832}
    28 => Doctrine\DBAL\ParameterType {#832}
    29 => Doctrine\DBAL\ParameterType {#832}
    30 => Doctrine\DBAL\ParameterType {#832}
    31 => Doctrine\DBAL\ParameterType {#832}
    32 => Doctrine\DBAL\ParameterType {#832}
    33 => Doctrine\DBAL\ParameterType {#832}
    34 => Doctrine\DBAL\ParameterType {#832}
    35 => Doctrine\DBAL\ParameterType {#832}
    36 => Doctrine\DBAL\ParameterType {#830
      +name: "INTEGER"
    }
    37 => Doctrine\DBAL\ParameterType {#830}
    38 => Doctrine\DBAL\ParameterType {#833}
    39 => Doctrine\DBAL\ParameterType {#830}
    40 => Doctrine\DBAL\ParameterType {#830}
    41 => Doctrine\DBAL\ParameterType {#830}
    42 => Doctrine\DBAL\ParameterType {#830}
  ]
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "sql" => "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"
  "params" => [
    1 => "xmccullough"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#832
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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'))"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#830
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#830
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "5766775c1d1020a8c4eebbb90708055d2e728085436c1a88a96f7182bbec5b0f"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#832
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#830
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "5766775c1d1020a8c4eebbb90708055d2e728085436c1a88a96f7182bbec5b0f"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#832
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "page_view"
    2 => "https://dev.ekhopsychology.com/hu/contact/xmccullough"
    3 => "Kapcsolat - ekho psychology"
    4 => "2026-06-06 03:43:19"
    5 => null
    6 => 29786
    7 => null
    8 => null
    9 => null
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#832
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#832}
    3 => Doctrine\DBAL\ParameterType {#832}
    4 => Doctrine\DBAL\ParameterType {#832}
    5 => Doctrine\DBAL\ParameterType {#832}
    6 => Doctrine\DBAL\ParameterType {#830
      +name: "INTEGER"
    }
    7 => Doctrine\DBAL\ParameterType {#830}
    8 => Doctrine\DBAL\ParameterType {#830}
    9 => Doctrine\DBAL\ParameterType {#830}
  ]
]

[
  "sql" => "UPDATE campaign_tracking_session SET date_last_activity = ?, page_views = ? WHERE id = ?"
  "params" => [
    1 => "2026-06-06 03:43:19"
    2 => 1
    3 => 29786
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#832
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#830
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#830}
  ]
]