Symfony Profiler

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "brulafine"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "8"
    "defaultTableOptions" => []
    "dbname" => "brulafine"
  ]
]

[
  "sql" => "SELECT c0_.site_id AS site_id_0, c0_.site_name AS site_name_1, c0_.site_display_name AS site_display_name_2, c0_.site_cookie_exp AS site_cookie_exp_3, c0_.site_default_currency AS site_default_currency_4, c0_.site_default_support_email AS site_default_support_email_5, c0_.site_default_coaching_support_email AS site_default_coaching_support_email_6, c0_.site_default_billing_apikey AS site_default_billing_apikey_7, c0_.site_default_billing_apihost AS site_default_billing_apihost_8, c0_.site_default_billing_callback AS site_default_billing_callback_9, c0_.is_default AS is_default_10, c0_.aliases AS aliases_11, c0_.coaching_site AS coaching_site_12, c0_.has_upsells AS has_upsells_13, c0_.has_pre_upsells AS has_pre_upsells_14, c0_.properties AS properties_15, c1_.id AS id_16, c1_.name AS name_17, c1_.value AS value_18, c1_.field_type AS field_type_19, c0_.site_default_affiliate_id AS site_default_affiliate_id_20, c0_.coaching_site_id AS coaching_site_id_21, c0_.linked_main_website_id AS linked_main_website_id_22, c1_.site_id AS site_id_23 FROM castalis_pls_brulafine_sites c0_ LEFT JOIN castalis_pls_brulafine_sites_config c1_ ON c0_.site_id = c1_.site_id"
]

[
  "sql" => "SELECT c0_.site_id AS site_id_0, c0_.site_name AS site_name_1, c0_.site_display_name AS site_display_name_2, c0_.site_cookie_exp AS site_cookie_exp_3, c0_.site_default_currency AS site_default_currency_4, c0_.site_default_support_email AS site_default_support_email_5, c0_.site_default_coaching_support_email AS site_default_coaching_support_email_6, c0_.site_default_billing_apikey AS site_default_billing_apikey_7, c0_.site_default_billing_apihost AS site_default_billing_apihost_8, c0_.site_default_billing_callback AS site_default_billing_callback_9, c0_.is_default AS is_default_10, c0_.aliases AS aliases_11, c0_.coaching_site AS coaching_site_12, c0_.has_upsells AS has_upsells_13, c0_.has_pre_upsells AS has_pre_upsells_14, c0_.properties AS properties_15, c1_.id AS id_16, c1_.name AS name_17, c1_.value AS value_18, c1_.field_type AS field_type_19, c0_.site_default_affiliate_id AS site_default_affiliate_id_20, c0_.coaching_site_id AS coaching_site_id_21, c0_.linked_main_website_id AS linked_main_website_id_22, c1_.site_id AS site_id_23 FROM castalis_pls_brulafine_sites c0_ LEFT JOIN castalis_pls_brulafine_sites_config c1_ ON c0_.site_id = c1_.site_id"
]

[
  "sql" => "SELECT c0_.affiliate_id AS affiliate_id_0, c0_.affiliate_name AS affiliate_name_1, c0_.affiliate_type AS affiliate_type_2, c0_.affiliate_rmkg AS affiliate_rmkg_3 FROM castalis_pls_brulafine_affiliates c0_ WHERE c0_.affiliate_id = ?"
  "params" => [
    1 => ""
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.affiliate_id AS affiliate_id_1, t0.affiliate_name AS affiliate_name_2, t0.affiliate_type AS affiliate_type_3, t0.affiliate_rmkg AS affiliate_rmkg_4 FROM castalis_pls_brulafine_affiliates t0 WHERE t0.affiliate_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.alias AS alias_2, t0.config AS config_3, t0.stats AS stats_4, t0.active AS active_5, t0.marked_for_deletion AS marked_for_deletion_6, t0.date_started AS date_started_7, t0.date_ended AS date_ended_8, t0.site_id AS site_id_9 FROM castalis_pls_brulafine_sites_ab_test t0 WHERE t0.site_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "INSERT INTO castalis_pls_brulafine_core_tracking (o1, o2, o3, o4, o5, t, rmkg, device, create_at, user_agent, aff, parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "deftrack"
    2 => ""
    3 => ""
    4 => ""
    5 => ""
    6 => ""
    7 => 0
    8 => "N/A"
    9 => "2025-12-18 10:45:01"
    10 => "N/A"
    11 => 1
    12 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
    8 => 2
    9 => 2
    10 => 2
    11 => 1
    12 => 1
  ]
]

[
  "sql" => "INSERT INTO castalis_pls_brulafine_core_tracking_has_ab_test (version, tracking_id, ab_test_id) VALUES (?, ?, ?)"
  "params" => [
    1 => "b_ship_page_test_1"
    2 => 619206
    3 => 80
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "UPDATE castalis_pls_brulafine_core_tracking SET user_agent = ? WHERE tracking_id = ?"
  "params" => [
    1 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
    2 => 619206
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.url AS url_2, b0_.additional_options AS additional_options_3, b0_.type AS type_4, b0_.is_unique AS is_unique_5, b0_.unique_property AS unique_property_6, b0_.not_empty AS not_empty_7, b0_.not_empty_properties AS not_empty_properties_8, b0_.setup_session AS setup_session_9, b0_.setup_session_name AS setup_session_name_10, b0_.setup_cookie AS setup_cookie_11, b0_.setup_cookie_name AS setup_cookie_name_12, b0_.setup_cookie_seconds AS setup_cookie_seconds_13, b0_.require_additional_data AS require_additional_data_14, b0_.active AS active_15 FROM brulafine_affiliate_notification_config b0_ INNER JOIN brulafine_affiliate_notification_config_has_affiliate b2_ ON b0_.id = b2_.config_id INNER JOIN castalis_pls_brulafine_affiliates c1_ ON c1_.affiliate_id = b2_.affiliate_id WHERE c1_.affiliate_id = ? AND b0_.type = ? AND b0_.active = 1"
  "params" => [
    1 => 1
    2 => "all_visits"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]