Query Metrics
26
Database Queries
8
Different statements
10.09 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.66 ms |
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
Parameters:
[] |
| 2 | 0.47 ms |
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
Parameters:
[] |
| 3 | 0.19 ms |
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 = ?
Parameters:
[
618858
]
|
| 4 | 0.49 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.city AS city_2, c0_.country AS country_3, c0_.age AS age_4, c0_.weight_loss AS weight_loss_5, c0_.size_loss AS size_loss_6, c0_.rating AS rating_7, c0_.message AS message_8, c0_.created_date AS created_date_9, c0_.testimony_date AS testimony_date_10, c0_.language AS language_11 FROM castalis_pls_brulafine_core_marketing_testimonies c0_ WHERE c0_.language = ? AND c0_.testimony_date < ? ORDER BY c0_.testimony_date DESC
Parameters:
[ "fr" "2025-12-16 10:42:30" ] |
| 5 | 0.16 ms |
SELECT c0_.post_id AS post_id_0, c0_.post_code AS post_code_1, c0_.is_paused AS is_paused_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4 FROM castalis_pls_brulafine_core_instagram_post c0_ WHERE c0_.is_paused = ?
Parameters:
[
0
]
|
| 6 | 0.46 ms |
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
Parameters:
[] |
| 7 | 0.17 ms |
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 = ?
Parameters:
[
618858
]
|
| 8 | 0.17 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.tracking_id AS tracking_id_3, t0.ab_test_id AS ab_test_id_4 FROM castalis_pls_brulafine_core_tracking_has_ab_test t0 WHERE t0.tracking_id = ?
Parameters:
[
618858
]
|
| 9 | 0.46 ms |
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
Parameters:
[] |
| 10 | 0.45 ms |
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
Parameters:
[] |
| 11 | 0.16 ms |
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 = ?
Parameters:
[
618858
]
|
| 12 | 0.52 ms |
SELECT c0_.site_pack_template_id AS site_pack_template_id_0, c0_.site_pack_template_order AS site_pack_template_order_1, c0_.site_pack_template_default AS site_pack_template_default_2, c0_.active AS active_3, c0_.is_upsell AS is_upsell_4, c0_.is_pre_upsell AS is_pre_upsell_5, c0_.can_be_discounted AS can_be_discounted_6, c0_.ab_test_version AS ab_test_version_7, c1_.pack_template_id AS pack_template_id_8, c1_.pack_template_name AS pack_template_name_9, c1_.pack_template_currency AS pack_template_currency_10, c1_.pack_template_options AS pack_template_options_11, c1_.pack_template_type AS pack_template_type_12, c1_.pack_template_display_name AS pack_template_display_name_13, c1_.conditional AS conditional_14, c1_.conditions AS conditions_15, c1_.coaching_forced AS coaching_forced_16, c1_.without_promo_code AS without_promo_code_17, c1_.should_be_purchased_with_rebillable_payment_only AS should_be_purchased_with_rebillable_payment_only_18, c1_.without_push AS without_push_19, c2_.pack_template_product_id AS pack_template_product_id_20, c2_.product_quantity AS product_quantity_21, c2_.pack_template_product_order AS pack_template_product_order_22, c2_.is_displayed AS is_displayed_23, c3_.product_id AS product_id_24, c3_.product_name AS product_name_25, c3_.product_code AS product_code_26, c3_.product_price AS product_price_27, c3_.product_currency AS product_currency_28, c3_.product_shipping_api AS product_shipping_api_29, c3_.product_options AS product_options_30, c3_.product_type AS product_type_31, c3_.product_purchase_cost AS product_purchase_cost_32, c3_.product_initial_stock AS product_initial_stock_33, c3_.product_billing_priority AS product_billing_priority_34, c4_.product_discount_id AS product_discount_id_35, c4_.product_discount_price_rule AS product_discount_price_rule_36, c5_.pack_discount_id AS pack_discount_id_37, c5_.pack_discount_price_rule AS pack_discount_price_rule_38, c5_.pack_discount_shipping_rule AS pack_discount_shipping_rule_39, c0_.site_id AS site_id_40, c0_.pack_template_id AS pack_template_id_41, c1_.pack_template_discount_id AS pack_template_discount_id_42, c1_.linked_pack_tempalte_id AS linked_pack_tempalte_id_43, c2_.pack_template_id AS pack_template_id_44, c2_.product_id AS product_id_45, c3_.product_discount_id AS product_discount_id_46, c3_.billing_account_id AS billing_account_id_47, c3_.billing_rebill_rule_id AS billing_rebill_rule_id_48, c3_.billing_account_id_3ds AS billing_account_id_3ds_49, c3_.product_vat_rule_id AS product_vat_rule_id_50 FROM castalis_pls_brulafine_site_pack_templates c0_ LEFT JOIN castalis_pls_brulafine_core_pack_templates c1_ ON c0_.pack_template_id = c1_.pack_template_id LEFT JOIN castalis_pls_brulafine_core_pack_template_products c2_ ON c1_.pack_template_id = c2_.pack_template_id LEFT JOIN castalis_pls_brulafine_core_products c3_ ON c2_.product_id = c3_.product_id LEFT JOIN castalis_pls_brulafine_core_product_discounts c4_ ON c3_.product_discount_id = c4_.product_discount_id LEFT JOIN castalis_pls_brulafine_core_pack_discounts c5_ ON c1_.pack_template_discount_id = c5_.pack_discount_id WHERE c0_.site_id = ? AND c0_.active = 1 AND c0_.is_upsell = 0 AND c0_.is_pre_upsell = 0 ORDER BY c0_.site_pack_template_order ASC
Parameters:
[
1
]
|
| 13 | 0.47 ms |
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
Parameters:
[] |
| 14 | 0.48 ms |
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
Parameters:
[] |
| 15 | 0.44 ms |
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
Parameters:
[] |
| 16 | 0.18 ms |
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 = ?
Parameters:
[
618858
]
|
| 17 | 0.47 ms |
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
Parameters:
[] |
| 18 | 0.17 ms |
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 = ?
Parameters:
[
618858
]
|
| 19 | 0.52 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.city AS city_2, c0_.country AS country_3, c0_.age AS age_4, c0_.weight_loss AS weight_loss_5, c0_.size_loss AS size_loss_6, c0_.rating AS rating_7, c0_.message AS message_8, c0_.created_date AS created_date_9, c0_.testimony_date AS testimony_date_10, c0_.language AS language_11 FROM castalis_pls_brulafine_core_marketing_testimonies c0_ WHERE c0_.language = ? ORDER BY c0_.id DESC
Parameters:
[
"fr"
]
|
| 20 | 0.47 ms |
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
Parameters:
[] |
| 21 | 0.46 ms |
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
Parameters:
[] |
| 22 | 0.47 ms |
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
Parameters:
[] |
| 23 | 0.46 ms |
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
Parameters:
[] |
| 24 | 0.46 ms |
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
Parameters:
[] |
| 25 | 0.46 ms |
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
Parameters:
[] |
| 26 | 0.22 ms |
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
Parameters:
[ 1 "all_visits" ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| nocticalm_connection | doctrine.dbal.nocticalm_connection_connection |
Entity Managers
| Name | Service |
|---|---|
| brulafine_orm | doctrine.orm.brulafine_orm_entity_manager |
| nocticalm_orm | doctrine.orm.nocticalm_orm_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
brulafine_orm entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Main\SiteABTest | No errors. |
| App\Entity\Main\Site | No errors. |
| App\Entity\Main\SiteConfig | No errors. |
| App\Entity\Main\Affiliate | No errors. |
| App\Entity\Coaching\Site | No errors. |
| App\Entity\Main\MessageScenario | No errors. |
| App\Entity\Main\User | No errors. |
| App\Entity\Main\RebillManager | No errors. |
| App\Entity\Main\UserSupport | No errors. |
| App\Entity\Main\Tracking | No errors. |
| App\Entity\Main\TrackingFacebookEvent | No errors. |
| App\Entity\Main\TrackingTagEvent | No errors. |
| App\Entity\Main\TrackingHasABTest | No errors. |
| App\Entity\Main\DiscountCode | No errors. |
| App\Entity\Main\Cart | No errors. |
| App\Entity\Main\CartAction | No errors. |
| App\Entity\Main\FailedIpn | No errors. |
| App\Entity\Main\Transaction | No errors. |
| App\Entity\Main\MailingQueue | No errors. |
| App\Entity\Admin\WatchdogConfig | No errors. |
| App\Entity\Main\MarketingTestimony | No errors. |
| App\Entity\Main\InstagramPost | No errors. |
| App\Entity\Main\SitePackTemplate | No errors. |
| App\Entity\Main\PackTemplate | No errors. |
| App\Entity\Main\PackTemplateProduct | No errors. |
| App\Entity\Main\Product | No errors. |
| App\Entity\Main\ProductDiscount | No errors. |
| App\Entity\Main\PackDiscount | No errors. |
| App\Entity\Main\BillingAccount | No errors. |
| App\Entity\Main\BillingRebillRule | No errors. |
| App\Entity\Main\ProductVatRule | No errors. |
| App\Entity\Main\MailingScenario | No errors. |
| App\Entity\Main\ProductPropriety | No errors. |
| App\Entity\Main\AffiliateNotificationConfig | No errors. |
| App\Entity\Main\AffiliateNotificationQueue | No errors. |
| App\Entity\Main\CartHasABTest | No errors. |
| App\Entity\Main\UserHasABTest | No errors. |
| App\Entity\Main\MessageQueue | No errors. |
| App\Entity\Main\UserAddress | No errors. |
| App\Entity\Main\UserPaymentToken | No errors. |
| App\Entity\Coaching\CoachingUser | No errors. |
| App\Entity\Main\UserCallTodo | No errors. |
| App\Entity\Main\UserHasReferrer | No errors. |
| App\Entity\Main\UserFund | No errors. |
| App\Entity\Main\UserCreditNote | No errors. |
| App\Entity\Main\TrackingHasReferrer | No errors. |
| App\Entity\Main\UserEmailStatus | No errors. |
| App\Entity\Main\DiscountCodeGroup | No errors. |
| App\Entity\Main\Pack | No errors. |
| App\Entity\Main\Testimony | No errors. |
| App\Entity\Main\AlternativeBilling | No errors. |
| App\Entity\Main\UpsellCart | No errors. |
| App\Entity\Main\CartAddress | No errors. |
| App\Entity\Main\Shipping | No errors. |
| App\Entity\Main\ElectronicProductShipping | No errors. |
| App\Entity\Main\CartFacebookEvent | No errors. |
| App\Entity\Main\CartTagEvent | No errors. |
| App\Entity\Main\CartCreditNote | No errors. |
| App\Entity\Main\CartSupportRefund | No errors. |
| App\Entity\Main\PaymentToken | No errors. |
nocticalm_orm entity manager
No loaded entities.