Query Metrics
10
Database Queries
4
Different statements
8.21 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.56 ms |
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"
]
|
| 2 | 0.68 ms |
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"
]
|
| 3 | 0.38 ms |
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"
]
|
| 4 | 0.69 ms |
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
]
|
| 5 | 0.62 ms |
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"
]
|
| 6 | 0.26 ms |
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"
]
|
| 7 | 0.21 ms |
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"
]
|
| 8 | 0.43 ms |
SELECT DATABASE()
Parameters:
[] |
| 9 | 2.05 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"db_yeti_holidays_admin"
]
|
| 10 | 0.32 ms |
SELECT DATABASE()
Parameters:
[] |
tenant connection
No database queries were performed.
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
No loaded entities.