http://yeti-holidays.yarsha.net/login

Query Metrics

6 Database Queries
4 Different statements
4.69 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
2.76 ms
(58.79%)
3
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.frontend_domain AS frontend_domain_3, t0.tenant_id AS tenant_id_4 FROM fn_tenant_domain t0 WHERE t0.domain = ? LIMIT 1
Parameters:
[
  "yeti-holidays.yarsha.net"
]
0.73 ms
(15.58%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.email AS email_6, t0.app_access_code AS app_access_code_7, t0.is_configured AS is_configured_8, t9.id AS id_10, t9.db_name AS db_name_11, t9.host AS host_12, t9.port AS port_13, t9.username AS username_14, t9.password AS password_15, t9.database_created AS database_created_16, t9.tenant_id AS tenant_id_17, t18.id AS id_19, t18.domain AS domain_20, t18.frontend_domain AS frontend_domain_21, t18.tenant_id AS tenant_id_22, t23.id AS id_24, t23.base_currency AS base_currency_25, t23.tax_registration_date AS tax_registration_date_26, t23.tax_office AS tax_office_27, t23.tax_number AS tax_number_28, t23.is_vat_registered AS is_vat_registered_29, t23.has_non_vat_item AS has_non_vat_item_30, t23.vat_registration_date AS vat_registration_date_31, t23.is_ird_registered AS is_ird_registered_32, t23.ird_registration_date AS ird_registration_date_33, t23.is_multi_currency_enabled AS is_multi_currency_enabled_34, t23.operating_currencies AS operating_currencies_35, t23.tenant_id AS tenant_id_36, t0.package_id AS package_id_37 FROM fn_tenant t0 LEFT JOIN fn_tenant_database t9 ON t9.tenant_id = t0.id LEFT JOIN fn_tenant_domain t18 ON t18.tenant_id = t0.id LEFT JOIN fn_tenant_configuration t23 ON t23.tenant_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]

tenant connection

Time Count Info
0.85 ms
(18.22%)
1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.phone AS phone_2, f0_.email AS email_3, f0_.website AS website_4, f0_.logo AS logo_5, f0_.company_registration_date AS company_registration_date_6, f0_.company_registration_office AS company_registration_office_7, f0_.company_registration_number AS company_registration_number_8, f0_.company_registration_file_name AS company_registration_file_name_9, f0_.tax_registration_date AS tax_registration_date_10, f0_.tax_office AS tax_office_11, f0_.tax_number AS tax_number_12, f0_.registration_file_name AS registration_file_name_13, f0_.is_vat_registered AS is_vat_registered_14, f0_.has_non_vat_item AS has_non_vat_item_15, f0_.vat_registration_date AS vat_registration_date_16, f0_.is_ird_registered AS is_ird_registered_17, f0_.ird_registration_date AS ird_registration_date_18, f0_.has_excise_duty AS has_excise_duty_19, f0_.has_import AS has_import_20, f0_.is_producer AS is_producer_21, f0_.is_renter AS is_renter_22, f0_.created_on AS created_on_23, f0_.updated_on AS updated_on_24, f0_.deleted AS deleted_25, f0_.address_id AS address_id_26, f0_.main_branch_id AS main_branch_id_27, f0_.created_by_id AS created_by_id_28 FROM fn_organization_profile f0_ WHERE (f0_.deleted = 0) ORDER BY f0_.created_on DESC LIMIT 1
Parameters:
[]
0.35 ms
(7.40%)
1
SELECT t0.id AS id_1, t0.options_name AS options_name_2, t0.options_value AS options_value_3 FROM fn_options t0
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
tenant doctrine.dbal.tenant_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
tenant doctrine.orm.tenant_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
FintechNepal\MultiTenantBundle\Entity\Tenant\TenantDomain No errors.
FintechNepal\MultiTenantBundle\Entity\Tenant\Tenant No errors.
FintechNepal\MultiTenantBundle\Entity\Tenant\TenantDatabase No errors.
FintechNepal\MultiTenantBundle\Entity\Tenant\TenantConfiguration No errors.
FintechNepal\MultiTenantBundle\Entity\Package\Package No errors.
FintechNepal\MultiTenantBundle\Entity\Tenant\TenantCompany No errors.

tenant entity manager

Class Mapping errors
FintechNepal\CoreBundle\Setup\Entity\Organization No errors.
FintechNepal\CoreBundle\Address\Entity\Address No errors.
FintechNepal\CoreBundle\Setup\Entity\Branch No errors.
FintechNepal\CoreBundle\User\Component\AbstractUser No errors.
FintechNepal\CoreBundle\User\Entity\User No errors.
FintechNepal\CoreBundle\Setup\Entity\Options No errors.