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_.tracking_id AS tracking_id_0,
  c0_.o1 AS o1_1,
  c0_.o2 AS o2_2,
  c0_.o3 AS o3_3,
  c0_.o4 AS o4_4,
  c0_.o5 AS o5_5,
  c0_.t AS t_6,
  c0_.rmkg AS rmkg_7,
  c0_.device AS device_8,
  c0_.create_at AS create_at_9,
  c0_.user_agent AS user_agent_10,
  c1_.affiliate_id AS affiliate_id_11,
  c1_.affiliate_name AS affiliate_name_12,
  c1_.affiliate_type AS affiliate_type_13,
  c1_.affiliate_rmkg AS affiliate_rmkg_14,
  c0_.aff AS aff_15,
  c0_.parent_id AS parent_id_16
FROM
  castalis_pls_brulafine_core_tracking c0_
  LEFT JOIN castalis_pls_brulafine_affiliates c1_ ON c0_.aff = c1_.affiliate_id
WHERE
  c0_.tracking_id = ?

SELECT c0_.tracking_id AS tracking_id_0, c0_.o1 AS o1_1, c0_.o2 AS o2_2, c0_.o3 AS o3_3, c0_.o4 AS o4_4, c0_.o5 AS o5_5, c0_.t AS t_6, c0_.rmkg AS rmkg_7, c0_.device AS device_8, c0_.create_at AS create_at_9, c0_.user_agent AS user_agent_10, c1_.affiliate_id AS affiliate_id_11, c1_.affiliate_name AS affiliate_name_12, c1_.affiliate_type AS affiliate_type_13, c1_.affiliate_rmkg AS affiliate_rmkg_14, c0_.aff AS aff_15, c0_.parent_id AS parent_id_16 FROM castalis_pls_brulafine_core_tracking c0_ LEFT JOIN castalis_pls_brulafine_affiliates c1_ ON c0_.aff = c1_.affiliate_id WHERE c0_.tracking_id = 618906;

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;