Query Metrics
6
Database Queries
3
Different statements
7.95 ms
Query time
11
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.94 ms |
SELECT d0_.id AS id_0, d0_.domain AS domain_1, d0_.low_value AS low_value_2, d0_.high_value AS high_value_3, d0_.comment AS comment_4, d0_.ui_editable AS ui_editable_5, d0_.ui_label AS ui_label_6, d0_.ui_description AS ui_description_7, d0_.created_at AS created_at_8, d0_.updated_at AS updated_at_9 FROM domain_values d0_ WHERE d0_.domain = ? AND d0_.low_value = ?
Parameters:
[ "BANK" "output_timezone" ] |
2 | 1.15 ms |
SELECT d0_.id AS id_0, d0_.domain AS domain_1, d0_.low_value AS low_value_2, d0_.high_value AS high_value_3, d0_.comment AS comment_4, d0_.ui_editable AS ui_editable_5, d0_.ui_label AS ui_label_6, d0_.ui_description AS ui_description_7, d0_.created_at AS created_at_8, d0_.updated_at AS updated_at_9 FROM domain_values d0_ WHERE d0_.domain = ? AND d0_.low_value = ?
Parameters:
[ "CHILD_ACCOUNT" "age_range" ] |
3 | 1.25 ms |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.low_value AS low_value_3, t0.high_value AS high_value_4, t0.comment AS comment_5, t0.ui_editable AS ui_editable_6, t0.ui_label AS ui_label_7, t0.ui_description AS ui_description_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM domain_values t0 WHERE t0.low_value = ? AND t0.domain = ? LIMIT 1
Parameters:
[ "bank_api_key" "PEP_and_sanctions_service" ] |
4 | 0.93 ms |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.low_value AS low_value_3, t0.high_value AS high_value_4, t0.comment AS comment_5, t0.ui_editable AS ui_editable_6, t0.ui_label AS ui_label_7, t0.ui_description AS ui_description_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM domain_values t0 WHERE t0.low_value = ? AND t0.domain = ? LIMIT 1
Parameters:
[ "pep_sanctions_url" "PEP_and_sanctions_service" ] |
5 | 1.10 ms |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.low_value AS low_value_3, t0.high_value AS high_value_4, t0.comment AS comment_5, t0.ui_editable AS ui_editable_6, t0.ui_label AS ui_label_7, t0.ui_description AS ui_description_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM domain_values t0 WHERE t0.low_value = ? LIMIT 1
Parameters:
[
"business_hours_start"
]
|
6 | 0.58 ms |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.low_value AS low_value_3, t0.high_value AS high_value_4, t0.comment AS comment_5, t0.ui_editable AS ui_editable_6, t0.ui_label AS ui_label_7, t0.ui_description AS ui_description_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM domain_values t0 WHERE t0.low_value = ? LIMIT 1
Parameters:
[
"business_hours_end"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\DomainValue | No errors. |
App\Entity\Currency | No errors. |
App\Entity\BankPermission |
|
App\Entity\Permissions\AccountPermissionSetting | No errors. |
App\Entity\Permissions\ClientAccountPermission | No errors. |
App\Entity\Client |
|
App\Entity\ClientAccount |
|
App\Entity\CompanyPerson | No errors. |
App\Entity\IdVerificationDocument | No errors. |
App\Entity\ClientDocument |
|
App\Entity\DocumentRequested |
|
App\Entity\Shareholder\ShareholderStatus |
|
App\Entity\KycLevel | No errors. |
App\Entity\ClientKycLevel |
|
App\Entity\Account |
|
App\Entity\AccountStatus | No errors. |
App\Entity\TransactionMethod | No errors. |
App\Entity\AccountType | No errors. |
App\Entity\AccountAddressType | No errors. |
App\Entity\SignatureType | No errors. |
App\Entity\AccountSecurityLimit | No errors. |
App\Entity\Person |
|
App\Entity\AccountAddress | No errors. |
App\Entity\AccountCurrencyBalance | No errors. |
App\Entity\Product |
|
App\Entity\ProductAction |
|
App\Entity\ClientSystemState | No errors. |
App\Entity\TransactionStatus | No errors. |
App\Entity\OA2User | No errors. |
App\Entity\TransactionProcessingInfo | No errors. |
App\Entity\TransactionMethodRoute | No errors. |
App\Entity\SystemCalendar | No errors. |
App\Entity\Bank | No errors. |
App\Entity\PersonInvitation | No errors. |
FOS\OAuthServerBundle\Entity\Client | No errors. |
App\Entity\OA2Client | No errors. |
FOS\OAuthServerBundle\Entity\AccessToken | No errors. |
App\Entity\OA2AccessToken | No errors. |
FOS\OAuthServerBundle\Entity\RefreshToken | No errors. |
App\Entity\OA2RefreshToken | No errors. |
App\Entity\FactorTwoAuth | No errors. |
App\Entity\TempPassword | No errors. |