Query Metrics
15
Database Queries
3
Different statements
6.49 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.72 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.58 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.22 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:
[
618907
]
|
| 4 | 0.60 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.53 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:
[] |
| 6 | 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:
[
618907
]
|
| 7 | 0.52 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.21 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:
[
618907
]
|
| 9 | 0.18 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:
[
618907
]
|
| 10 | 0.58 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.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:
[] |
| 12 | 0.56 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.20 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:
[
618907
]
|
| 14 | 0.54 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.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:
[
618907
]
|
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\AffiliateNotificationConfig | No errors. |
| App\Entity\Main\AffiliateNotificationQueue | No errors. |
nocticalm_orm entity manager
No loaded entities.