Query Metrics
16
Database Queries
4
Different statements
5.71 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.65 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.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:
[] |
| 3 | 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:
[
618905
]
|
| 4 | 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:
[] |
| 5 | 0.15 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:
[
618905
]
|
| 6 | 0.14 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:
[
618905
]
|
| 7 | 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:
[] |
| 8 | 0.43 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:
[] |
| 9 | 0.15 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:
[
618905
]
|
| 10 | 0.49 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
]
|
| 11 | 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:
[] |
| 12 | 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:
[] |
| 13 | 0.43 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.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:
[
618905
]
|
| 15 | 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:
[] |
| 16 | 0.14 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:
[
618905
]
|
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\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. |
nocticalm_orm entity manager
No loaded entities.