GET https://one.bc.dev.ecomz.eu/ru/statistics/tags/search?query=

Query Metrics

2 Database Queries
2 Different statements
4.12 ms Query time
2 Invalid entities
1 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 3.60 ms
SELECT t0.email AS email_1, t0.project_name AS project_name_2, t0.status AS status_3, t0.timezone AS timezone_4, t0.country AS country_5, t0.reg_time AS reg_time_6, t0.api_key AS api_key_7, t0.api_mode AS api_mode_8, t0.return_path AS return_path_9, t0.send_priority AS send_priority_10, t0.private_comment AS private_comment_11, t0.backend_domain_id AS backend_domain_id_12, t0.system_backend_domain_id AS system_backend_domain_id_13, t0.auto_deactivated_backend_domain_id AS auto_deactivated_backend_domain_id_14, t0.trust AS trust_15, t0.flags AS flags_16, t0.staff_role AS staff_role_17, t0.customer_phone AS customer_phone_18, t0.customer_name AS customer_name_19, t0.project_owner_id AS project_owner_id_20, t0.lang_id AS lang_id_21, t0.currency_id AS currency_id_22, t0.is_show_welcome AS is_show_welcome_23, t0.delete_at AS delete_at_24, t0.delete_by_user_id AS delete_by_user_id_25, t0.starting_steps AS starting_steps_26, t0.statistic_storage_current AS statistic_storage_current_27, t0.statistic_storage_new AS statistic_storage_new_28, t0.system_unsubscribe_template_id AS system_unsubscribe_template_id_29, t0.default_unsubscribe_template_id AS default_unsubscribe_template_id_30, t0.id AS id_31 FROM user t0 WHERE t0.id = ?
Parameters:
[
  132
]
2 0.52 ms
SELECT s0_.user_id AS user_id_0, s0_.tag AS tag_1, s0_.id AS id_2 FROM statistics_tags s0_ WHERE s0_.user_id = ?
Parameters:
[
  132
]

Database Connections

Name Service
default doctrine.dbal.default_connection
slave doctrine.dbal.slave_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
slave doctrine.orm.slave_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
User\Entity\User 1

slave entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
Alerting\Entity\AlertingSetupPeriodicTask No errors.
Alerting\Entity\AlertingSetup No errors.
User\Entity\User No errors.
User\Entity\UserAccess No errors.
Billing\Entity\Currency
  • The field 'Billing\Entity\Currency#usdRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'Billing\Entity\Currency#minPayment' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
User\Entity\UserAdditionalData No errors.
User\Entity\UserClassification No errors.
UniSender\UniGridBundle\Entity\Lang No errors.
Billing\Entity\UserSettingsRegularSubscription No errors.
Billing\Entity\UserSettingsContractSubscription No errors.
Billing\Entity\UserSettingsFreeTierSubscription No errors.
Billing\Entity\UserSettings
  • The association Billing\Entity\UserSettings#attachedAdditionalService refers to the owning side field Billing\Entity\AttachedAdditionalService#userId which is not defined as association, but as field.
  • The association Billing\Entity\UserSettings#attachedAdditionalService refers to the owning side field Billing\Entity\AttachedAdditionalService#userId which does not exist.
Billing\Entity\AttachedAdditionalService No errors.
Billing\Entity\AdditionalService No errors.
Billing\Entity\RegularSubscription No errors.
Billing\Entity\ContractTemplate No errors.
UniSender\UniGridBundle\Entity\CheckedDomain No errors.
Billing\Entity\InvoiceVat No errors.
Billing\Entity\Invoice No errors.
Billing\Entity\Discount No errors.
User\Entity\UserLimits No errors.
User\Entity\UserStatistic No errors.
Billing\Entity\SubscriptionHistory No errors.
UniSender\UniGridBundle\Entity\Config No errors.
Billing\Entity\History No errors.
Billing\Entity\UserSettingsProject No errors.
User\Entity\UserIpAccess No errors.
Statistics\Entity\StatisticsTag No errors.
Alerting\Entity\EmailContact No errors.
User\Entity\UserDetails No errors.
Unsubscribe\Entity\UnsubscribeTemplate No errors.
User\Entity\UserConfirmedEmails No errors.
UniSender\UniGridBundle\Entity\UserHook No errors.

slave entity manager

No loaded entities.