https://eposmanager.software/scrivania/ticket/prendi-in-carico Return to referer URL

Query Metrics

18 Database Queries
11 Different statements
14.92 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

master connection

Time Count Info
0.64 ms
(4.31%)
2
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.id = ? LIMIT 1
Parameters:
[
  "1"
]

slave connection

Time Count Info
9.32 ms
(62.47%)
1
"COMMIT"
Parameters:
[]
2.28 ms
(15.26%)
1
SELECT e0_.id AS id_0, e0_.nickname AS nickname_1, e0_.address AS address_2, e0_.is_movable AS is_movable_3, e0_.is_headquarter AS is_headquarter_4, e0_.is_active AS is_active_5, e0_.client_id AS client_id_6, e0_.destination_id AS destination_id_7 FROM eposm_s_warehouse e0_ WHERE e0_.is_headquarter = 1 AND e0_.client_id IS NULL AND e0_.destination_id IS NULL
Parameters:
[]
0.76 ms
(5.07%)
1
SELECT e0_.id AS id_0, e0_.number AS number_1, e0_.datetime_import AS datetime_import_2, e0_.datetime_start AS datetime_start_3, e0_.datetime_expiration AS datetime_expiration_4, e0_.datetime_end AS datetime_end_5, e0_.address AS address_6, e0_.locality AS locality_7, e0_.zip AS zip_8, e0_.id_city AS id_city_9, e0_.id_province AS id_province_10, e0_.other_city AS other_city_11, e0_.system_error AS system_error_12, e0_.system_error_slug AS system_error_slug_13, e0_.system_error_details AS system_error_details_14, e0_.json AS json_15, e0_.directory_path AS directory_path_16, e0_.waybill AS waybill_17, e0_.json_report AS json_report_18, e0_.billable AS billable_19, e0_.closed_on_portal AS closed_on_portal_20, e0_.supplier_id AS supplier_id_21, e0_.client_id AS client_id_22, e0_.operation_id AS operation_id_23, e0_.technician_id AS technician_id_24, e0_.status_id AS status_id_25, e0_.termid_id AS termid_id_26, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_27, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_28 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_user e2_ ON e0_.technician_id = e2_.id WHERE e2_.id = ? AND e1_.slug = ? ORDER BY e0_.datetime_expiration ASC
Parameters:
[
  "9"
  "assigned"
]
0.75 ms
(5.01%)
7
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
0.27 ms
(1.82%)
1
SELECT t0.id AS id_1, t0.rw AS rw_2, t0.account_type_id AS account_type_id_3, t0.permission_id AS permission_id_4 FROM eposm_s_join_table_account_type_permission t0 WHERE t0.account_type_id = ?
Parameters:
[
  "10"
]
0.24 ms
(1.61%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.role AS role_4, t0.one_time_code AS one_time_code_5, t0.expiration_one_time_code AS expiration_one_time_code_6, t0.is_active AS is_active_7, t0.is_company_active AS is_company_active_8, t0.is_admin_active AS is_admin_active_9, t0.exclude_auto_assign AS exclude_auto_assign_10, t0.is_economic_visible AS is_economic_visible_11, t12.id AS id_13, t12.name AS name_14, t12.surname AS surname_15, t12.phone AS phone_16, t12.fiscal_code AS fiscal_code_17, t12.vat AS vat_18, t12.phone_personal AS phone_personal_19, t12.email_personal AS email_personal_20, t12.address AS address_21, t12.civic AS civic_22, t12.zip AS zip_23, t12.id_city AS id_city_24, t12.user_id AS user_id_25, t0.account_type_id AS account_type_id_26 FROM eposm_s_user t0 LEFT JOIN eposm_s_user_profile t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  "9"
]
0.23 ms
(1.53%)
1
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3, t0.category_id AS category_id_4 FROM eposm_s_account_type t0 WHERE t0.id = ?
Parameters:
[
  "10"
]
0.20 ms
(1.34%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_ticket_status t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "taken_charge"
]
0.15 ms
(1.03%)
1
UPDATE eposm_s_ticket SET status_id = ? WHERE id = ?
Parameters:
[
  "3"
  "23629"
]
0.08 ms
(0.56%)
1
"START TRANSACTION"
Parameters:
[]

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\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\AccountCategory No errors.
App\Entity\Slave\JoinTableAccountTypePermission No errors.
App\Entity\Slave\Permission No errors.
App\Entity\Slave\PermissionCategory No errors.
App\Entity\Slave\TicketStatus No errors.
App\Entity\Slave\Client No errors.
App\Entity\Slave\Operation No errors.
App\Entity\Slave\Termid No errors.
App\Entity\Slave\OperationTariffAmount No errors.
App\Entity\Slave\TicketSuspension No errors.
App\Entity\Slave\Warehouse No errors.
App\Entity\Slave\Destination No errors.
App\Entity\Slave\Product No errors.