Query Metrics

15 Database Queries
3 Different statements
6.49 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
5.30 ms
(81.69%)
9
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:
[]
1.01 ms
(15.51%)
5
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
]
0.18 ms
(2.80%)
1
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
]

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.