Query Metrics
728
Database Queries
5
Different statements
96.67 ms
Query time
0
Invalid entities
406
Managed entities
Grouped Statements
manager connection
| Time▼ | Count | Info |
|---|---|---|
|
63.19 ms (65.37%) |
362 |
SELECT i0_.cust_id AS cust_id_0, i0_.cust_description AS cust_description_1 FROM itm_customer i0_ LEFT JOIN itm_type_customer i1_ ON (i0_.tcust_id = i1_.tcust_id) LEFT JOIN itm_customer i2_ ON (i0_.cust_id_parent = i2_.cust_id) WHERE i0_.cust_id_parent = ? AND i0_.cust_id <> ? ORDER BY i0_.cust_description ASC
Parameters:
[ 914 914 ] |
|
32.74 ms (33.87%) |
363 |
SELECT t0.cust_id AS cust_id_1, t0.cust_description AS cust_description_2, t0.cust_id_parent AS cust_id_parent_3, t0.cust_email_commercial AS cust_email_commercial_4, t0.cust_reseller_number_doc AS cust_reseller_number_doc_5, t0.cust_reseller_number_customers AS cust_reseller_number_customers_6, t0.cust_extra_documents_count AS cust_extra_documents_count_7, t0.ad_id AS ad_id_8, t0.tcust_id AS tcust_id_9, t0.tree_id AS tree_id_10 FROM itm_customer t0 WHERE t0.cust_id = ?
Parameters:
[
1
]
|
|
0.40 ms (0.41%) |
1 |
SELECT i0_.cust_id AS cust_id_0, i0_.cust_description AS cust_description_1 FROM itm_customer i0_ LEFT JOIN itm_type_customer i1_ ON (i0_.tcust_id = i1_.tcust_id) LEFT JOIN itm_customer i2_ ON (i0_.cust_id_parent = i2_.cust_id) WHERE (i0_.cust_id_parent = ? AND i0_.cust_id <> ?) OR i0_.tcust_id = ? ORDER BY i0_.cust_description ASC
Parameters:
[ 1 1 "client" ] |
|
0.20 ms (0.21%) |
1 |
SELECT t0.use_id AS use_id_1, t0.use_login AS use_login_2, t0.use_password AS use_password_3, t0.roles AS roles_4, t0.use_first_name AS use_first_name_5, t0.use_last_name AS use_last_name_6, t0.use_email AS use_email_7, t0.use_id_parent AS use_id_parent_8, t0.last_connection AS last_connection_9, t0.count_connection AS count_connection_10, t0.password_last_changed AS password_last_changed_11, t0.require_password_change AS require_password_change_12, t0.two_factor_secret AS two_factor_secret_13, t0.two_factor_method AS two_factor_method_14, t0.two_factor_enabled AS two_factor_enabled_15, t0.two_factor_email_code AS two_factor_email_code_16, t0.two_factor_email_code_expiry AS two_factor_email_code_expiry_17, t0.failed_login_attempts AS failed_login_attempts_18, t0.locked_until AS locked_until_19, t0.cust_id AS cust_id_20, t0.priv_id AS priv_id_21 FROM itm_user t0 WHERE t0.use_id = ?
Parameters:
[
369
]
|
|
0.14 ms (0.14%) |
1 |
SELECT i0_.cust_id AS cust_id_0, i0_.cust_description AS cust_description_1 FROM itm_customer i0_ WHERE i0_.cust_id = ?
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| manager | doctrine.dbal.manager_connection |
| stats | doctrine.dbal.stats_connection |
Entity Managers
| Name | Service |
|---|---|
| manager | doctrine.orm.manager_entity_manager |
| stats | doctrine.orm.stats_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
manager entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Manager\Customer | 363 |
| App\Entity\Manager\Address | 32 |
| App\Entity\Manager\Tree | 5 |
| App\Entity\Manager\TypeCustomer | 4 |
| App\Entity\Manager\User | 1 |
| App\Entity\Manager\Privilege | 1 |
stats entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
manager entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Manager\SubscriptionPermissions | No errors. |
| App\Entity\Manager\User | No errors. |
| App\Entity\Manager\Customer | No errors. |
| App\Entity\Manager\Privilege | No errors. |
| App\Entity\Manager\Address | No errors. |
| App\Entity\Manager\TypeCustomer | No errors. |
| App\Entity\Manager\Tree | No errors. |
stats entity manager
No loaded entities.