https://www.eposmanager.software/scrivania/ticket/scheda/intervento/attivita-modello-cerca Return to referer URL

Query Metrics

50 Database Queries
13 Different statements
6.88 ms Query time
0 Invalid entities

Queries

Group similar statements

master connection

# Time Info
1 0.34 ms
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:
[
  "19"
]
2 0.16 ms
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:
[
  "19"
]

slave connection

# Time Info
1 0.17 ms
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:
[
  "41"
]
2 0.17 ms
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"
]
3 0.16 ms
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"
]
4 0.10 ms
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"
]
5 0.06 ms
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:
[
  "6"
]
6 0.11 ms
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:
[
  "7"
]
7 0.12 ms
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:
[
  "8"
]
8 0.11 ms
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:
[
  "9"
]
9 0.11 ms
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:
[
  "10"
]
10 0.06 ms
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:
[
  "12"
]
11 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.advice AS advice_4, t0.pos AS pos_5, t0.is_only_backoffice AS is_only_backoffice_6, t0.producer_withdraw_mandatory AS producer_withdraw_mandatory_7, t0.producer_installation_mandatory AS producer_installation_mandatory_8, t0.producer_actual_mandatory AS producer_actual_mandatory_9, t0.supplier_withdraw_mandatory AS supplier_withdraw_mandatory_10, t0.supplier_installation_mandatory AS supplier_installation_mandatory_11, t0.supplier_actual_mandatory AS supplier_actual_mandatory_12, t0.is_visible AS is_visible_13 FROM eposm_s_intervention_activity_type t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "3"
]
12 0.18 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.datetime_billing AS datetime_billing_3, t0.referent AS referent_4, t0.motivation AS motivation_5, t0.phone AS phone_6, t0.photo_path AS photo_path_7, t0.amount AS amount_8, t0.amount_technician AS amount_technician_9, t0.sla_outbound_percentage AS sla_outbound_percentage_10, t0.billable AS billable_11, t12.id AS id_13, t12.datetime_from AS datetime_from_14, t12.datetime_to AS datetime_to_15, t12.is_approved AS is_approved_16, t12.is_managed AS is_managed_17, t12.is_unlocked AS is_unlocked_18, t12.unlock_causal AS unlock_causal_19, t12.refuse_motivation AS refuse_motivation_20, t12.intervention_id AS intervention_id_21, t12.ticket_id AS ticket_id_22, t0.ticket_id AS ticket_id_23, t0.technician_id AS technician_id_24, t0.operator_id AS operator_id_25, t0.outcome_id AS outcome_id_26, t0.outcome_type_id AS outcome_type_id_27, t0.warehouse_id AS warehouse_id_28 FROM eposm_s_intervention t0 LEFT JOIN eposm_s_ticket_suspension t12 ON t12.intervention_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "13542"
]
13 0.18 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.datetime_import AS datetime_import_3, t0.datetime_start AS datetime_start_4, t0.datetime_expiration AS datetime_expiration_5, t0.datetime_end AS datetime_end_6, t0.address AS address_7, t0.locality AS locality_8, t0.zip AS zip_9, t0.id_city AS id_city_10, t0.id_province AS id_province_11, t0.other_city AS other_city_12, t0.system_error AS system_error_13, t0.system_error_slug AS system_error_slug_14, t0.system_error_details AS system_error_details_15, t0.json AS json_16, t0.directory_path AS directory_path_17, t0.waybill AS waybill_18, t0.json_report AS json_report_19, t0.billable AS billable_20, t0.closed_on_portal AS closed_on_portal_21, t0.supplier_id AS supplier_id_22, t0.client_id AS client_id_23, t0.operation_id AS operation_id_24, t0.technician_id AS technician_id_25, t0.status_id AS status_id_26, t0.termid_id AS termid_id_27, t0.operation_tariff_amount_id AS operation_tariff_amount_id_28, t0.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_29 FROM eposm_s_ticket t0 WHERE t0.id = ?
Parameters:
[
  "20997"
]
14 1.11 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.sku AS sku_2, e0_.part_number AS part_number_3, e0_.internal_code AS internal_code_4, e0_.image_path AS image_path_5, e0_.is_with_sim AS is_with_sim_6, e0_.is_with_base AS is_with_base_7, e0_.subcategory_id AS subcategory_id_8, e0_.producer_id AS producer_id_9 FROM eposm_s_product_model e0_ LEFT JOIN eposm_s_product_subcategory e1_ ON e0_.subcategory_id = e1_.id LEFT JOIN eposm_s_product_category e2_ ON e1_.category_id = e2_.id LEFT JOIN eposm_s_producer e3_ ON e0_.producer_id = e3_.id LEFT JOIN eposm_s_join_table_product_model_supplier e4_ ON e0_.id = e4_.product_model_id LEFT JOIN eposm_s_supplier e5_ ON e4_.supplier_id = e5_.id WHERE e2_.is_pos = ? AND e5_.id = ? AND (e0_.name LIKE ? OR e1_.name LIKE ? OR e2_.name LIKE ? OR e3_.name LIKE ?)
Parameters:
[
  "1"
  "17"
  "%%"
  "%%"
  "%%"
  "%%"
]
15 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "31"
]
16 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_pos AS is_pos_3 FROM eposm_s_product_category t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
17 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM eposm_s_producer t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
18 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM eposm_s_producer t0 WHERE t0.id = ?
Parameters:
[
  "10"
]
19 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM eposm_s_producer t0 WHERE t0.id = ?
Parameters:
[
  "11"
]
20 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM eposm_s_producer t0 WHERE t0.id = ?
Parameters:
[
  "16"
]
21 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM eposm_s_producer t0 WHERE t0.id = ?
Parameters:
[
  "12"
]
22 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM eposm_s_producer t0 WHERE t0.id = ?
Parameters:
[
  "13"
]
23 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM eposm_s_producer t0 WHERE t0.id = ?
Parameters:
[
  "14"
]
24 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "32"
]
25 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "33"
]
26 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "34"
]
27 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "35"
]
28 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "36"
]
29 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "37"
]
30 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "40"
]
31 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM eposm_s_producer t0 WHERE t0.id = ?
Parameters:
[
  "9"
]
32 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "41"
]
33 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "43"
]
34 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "44"
]
35 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "38"
]
36 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_pos AS is_pos_3 FROM eposm_s_product_category t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
37 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "39"
]
38 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "47"
]
39 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_pos AS is_pos_3 FROM eposm_s_product_category t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
40 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "48"
]
41 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "60"
]
42 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "61"
]
43 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "62"
]
44 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "63"
]
45 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "64"
]
46 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "65"
]
47 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM eposm_s_product_subcategory t0 WHERE t0.id = ?
Parameters:
[
  "66"
]
48 1.87 ms
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:
[]

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\InterventionActivityType No errors.
App\Entity\Slave\InterventionActivity No errors.
App\Entity\Slave\OperationGroup No errors.
App\Entity\Slave\TicketSuspension No errors.
App\Entity\Slave\InterventionOutcome No errors.
App\Entity\Slave\InterventionOutcomeType No errors.
App\Entity\Slave\Warehouse No errors.
App\Entity\Slave\InterventionExtra No errors.
App\Entity\Slave\ProductLog No errors.
App\Entity\Slave\Client No errors.
App\Entity\Slave\Operation No errors.
App\Entity\Slave\TicketStatus No errors.
App\Entity\Slave\Termid No errors.
App\Entity\Slave\OperationTariffAmount No errors.
App\Entity\Slave\ProductModel No errors.
App\Entity\Slave\ProductSubcategory No errors.
App\Entity\Slave\ProductCategory No errors.
App\Entity\Slave\Producer No errors.
App\Entity\Slave\JoinTableProductModelSupplier No errors.
App\Entity\Slave\Product No errors.
App\Entity\Slave\ProductComponent No errors.
App\Entity\Slave\Destination No errors.