Symfony Profiler

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

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;

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

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;

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 = ?

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 = '';

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 = ?

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 = 1;

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 = ?

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 = 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO castalis_pls_brulafine_core_tracking (
  o1, o2, o3, o4, o5, t, rmkg, device, create_at,
  user_agent, aff, parent_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO castalis_pls_brulafine_core_tracking (o1, o2, o3, o4, o5, t, rmkg, device, create_at, user_agent, aff, parent_id) VALUES ('deftrack', '', '', '', '', '', 0, 'N/A', '2025-12-16 18:47:30', 'N/A', 1, NULL);

INSERT INTO castalis_pls_brulafine_core_tracking_has_ab_test (version, tracking_id, ab_test_id)
VALUES
  (?, ?, ?)

INSERT INTO castalis_pls_brulafine_core_tracking_has_ab_test (version, tracking_id, ab_test_id) VALUES ('b_ship_page_test_2', 618904, 80);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  castalis_pls_brulafine_core_tracking
SET
  user_agent = ?
WHERE
  tracking_id = ?

UPDATE castalis_pls_brulafine_core_tracking SET user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' WHERE tracking_id = 618904;

"COMMIT"

"COMMIT";

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

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 = 1 AND b0_.type = 'all_visits' AND b0_.active = 1;