Query Metrics
6
Database Queries
4
Different statements
4.69 ms
Query time
0
Invalid entities
Grouped Statements
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. |