Query Metrics
3
Database Queries
3
Different statements
34.46 ms
Query time
0
Invalid entities
3
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
11.69 ms (33.92%) |
1 |
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.vg_id AS vg_id_3, t0.Extension AS Extension_4, t0.hr_emp_id AS hr_emp_id_5, t0.lastCCC_id AS lastCCC_id_6, t0.department AS department_7, t0.email AS email_8, t0.Password AS Password_9, t0.phone_number AS phone_number_10, t0.active AS active_11, t0.ImprovementNote AS ImprovementNote_12 FROM [SalesMan] t0 WHERE t0.active = ? AND t0.email = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters:
[ 1 "brianf@bulwarkpest.com" ] |
|
11.42 ms (33.15%) |
1 |
SELECT t0.id AS id_1, t0.Email AS Email_2, t0.Password AS Password_3, t0.Role_Id AS Role_Id_4 FROM [User] t0 WHERE t0.Email = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters:
[
"brianf@bulwarkpest.com"
]
|
|
11.35 ms (32.93%) |
1 |
SELECT t0_.Id AS Id_0, t0_.Code AS Code_1, t0_.Methods AS Methods_2, t0_.Validation AS Validation_3, t0_.Type AS Type_4, t0_.CreatedOn AS CreatedOn_5 FROM TempestAPIUserRules t0_ WHERE t0_.Code = ? ORDER BY t0_.Id ASC
Parameters:
[
"3e55a08b-8b2a-401f-8f44-5be422839a0e"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| vanguard | doctrine.dbal.vanguard_connection |
| tempest | doctrine.dbal.tempest_connection |
| sales | doctrine.dbal.sales_connection |
| customerCareApp | doctrine.dbal.customerCareApp_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| v2_default | doctrine.orm.v2_default_entity_manager |
| v2_vanguard | doctrine.orm.v2_vanguard_entity_manager |
| vanguard | doctrine.orm.vanguard_entity_manager |
| tempest | doctrine.orm.tempest_entity_manager |
| sales | doctrine.orm.sales_entity_manager |
| customerCare | doctrine.orm.customerCare_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\CC\User | 1 |
| App\Entity\CC\RuleRequest | 1 |
| App\Entity\CC\SalesMan | 1 |
v2_default entity manager
| Class | Amount of managed objects |
|---|
v2_vanguard entity manager
| Class | Amount of managed objects |
|---|
vanguard entity manager
| Class | Amount of managed objects |
|---|
tempest entity manager
| Class | Amount of managed objects |
|---|
sales entity manager
| Class | Amount of managed objects |
|---|
customerCare entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\CC\User | No errors. |
| App\Entity\CC\RuleRequest | No errors. |
| App\Entity\CC\SalesMan | No errors. |
v2_default entity manager
No loaded entities.
v2_vanguard entity manager
No loaded entities.
vanguard entity manager
No loaded entities.
tempest entity manager
No loaded entities.
sales entity manager
No loaded entities.
customerCare entity manager
No loaded entities.