Query Metrics
29
Database Queries
4
Different statements
22.37 ms
Query time
0
Invalid entities
Grouped Statements
master connection
Time▼ | Count | Info |
---|---|---|
0.28 ms (1.26%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.email AS email_4, t0.fiscal_code AS fiscal_code_5, t0.vat AS vat_6, t0.vat_country AS vat_country_7, t0.phone_administration AS phone_administration_8, t0.phone_support_customer AS phone_support_customer_9, t0.phone_support_technician AS phone_support_technician_10, t0.phone_logistic AS phone_logistic_11, t0.email_administration AS email_administration_12, t0.email_support_customer AS email_support_customer_13, t0.email_support_technician AS email_support_technician_14, t0.email_logistic AS email_logistic_15, t0.directory_path AS directory_path_16, t0.logo_path AS logo_path_17, t0.db_name AS db_name_18, t0.admin_access AS admin_access_19, t0.admin_active AS admin_active_20 FROM eposm_m_company t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"K836H2"
]
|
slave connection
Time▼ | Count | Info |
---|---|---|
21.55 ms (96.32%) |
25 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.phone AS phone_4, t0.fiscal_code AS fiscal_code_5, t0.vat AS vat_6, t0.phone_personal AS phone_personal_7, t0.email_personal AS email_personal_8, t0.address AS address_9, t0.civic AS civic_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.user_id AS user_id_13 FROM eposm_s_user_profile t0 WHERE t0.user_id = ?
Parameters:
[
"18"
]
|
0.32 ms (1.41%) |
1 |
SELECT e0_.id AS id_0, e0_.email AS email_1, e0_.password AS password_2, e0_.role AS role_3, e0_.one_time_code AS one_time_code_4, e0_.expiration_one_time_code AS expiration_one_time_code_5, e0_.is_active AS is_active_6, e0_.is_company_active AS is_company_active_7, e0_.is_admin_active AS is_admin_active_8, e0_.exclude_auto_assign AS exclude_auto_assign_9, e0_.is_economic_visible AS is_economic_visible_10, e0_.account_type_id AS account_type_id_11 FROM eposm_s_user e0_ LEFT JOIN eposm_s_user_profile e1_ ON e0_.id = e1_.user_id LEFT JOIN eposm_s_account_type e2_ ON e0_.account_type_id = e2_.id LEFT JOIN eposm_s_account_category e3_ ON e2_.category_id = e3_.id WHERE e0_.role <> ? AND (e3_.slug = ? OR e3_.slug = ?) AND e0_.is_company_active = 1
Parameters:
[ "ROLE_ADMIN" "tech-internal" "tech-external" ] |
0.22 ms (1.01%) |
2 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"ticket_technician_minutes_take_charge"
]
|
Database Connections
Name | Service |
---|---|
master | doctrine.dbal.master_connection |
slave | doctrine.dbal.slave_connection |
Entity Managers
Name | Service |
---|---|
master | doctrine.orm.master_entity_manager |
slave | doctrine.orm.slave_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
master entity manager
Class | Mapping errors |
---|---|
App\Entity\Master\Company | No errors. |
App\Entity\Master\CompanyMailer | No errors. |
App\Entity\Master\JoinTableCompanySupplier | No errors. |
App\Entity\Master\Address | No errors. |
App\Entity\Master\Contact | No errors. |
App\Entity\Master\License | No errors. |
App\Entity\Master\Order | No errors. |
App\Entity\Master\JoinTableCompanyFeature | No errors. |
App\Entity\Master\Region | No errors. |
slave entity manager
Class | Mapping errors |
---|---|
App\Entity\Slave\User | No errors. |
App\Entity\Slave\UserProfile | No errors. |
App\Entity\Slave\AccountType | No errors. |
App\Entity\Slave\AccountCategory | No errors. |
App\Entity\Slave\UserDocument | No errors. |
App\Entity\Slave\UserHoliday | No errors. |
App\Entity\Slave\JoinTableUserWarehouse | No errors. |
App\Entity\Slave\TechnicianArea | No errors. |
App\Entity\Slave\JoinTableUserSupplier | No errors. |
App\Entity\Slave\ProductTransferLog | No errors. |
App\Entity\Slave\ProductTransfer | No errors. |
App\Entity\Slave\Ticket | No errors. |
App\Entity\Slave\Intervention | No errors. |
App\Entity\Slave\ProductRequest | No errors. |
App\Entity\Slave\TicketReminder | No errors. |
App\Entity\Slave\Supplier | No errors. |
App\Entity\Slave\Setting | No errors. |