https://eposmanager.software/scrivania/magazzini/349/scheda/trasferimento/invia-cerca Return to referer URL

Query Metrics

24 Database Queries
13 Different statements
8.02 ms Query time
0 Invalid entities

Queries

Group similar statements

master connection

# Time Info
1 0.36 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:
[
  "23"
]
2 0.22 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:
[
  "23"
]

slave connection

# Time Info
1 0.22 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:
[
  "5"
]
2 0.19 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:
[
  "3"
]
3 0.20 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:
[
  "3"
]
4 0.14 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:
[
  "1"
]
5 0.08 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"
]
6 0.07 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:
[
  "5"
]
7 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"
]
8 0.05 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:
[
  "13"
]
9 0.05 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:
[
  "15"
]
10 0.05 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:
[
  "16"
]
11 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:
[
  "17"
]
12 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:
[
  "18"
]
13 0.05 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:
[
  "2"
]
14 0.05 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:
[
  "11"
]
15 0.24 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.phase AS phase_3, t0.phase_ddt AS phase_ddt_4, t0.datetime_creation AS datetime_creation_5, t0.datetime_send AS datetime_send_6, t0.datetime_completion AS datetime_completion_7, t0.stock_order AS stock_order_8, t0.ddt AS ddt_9, t0.ddt_path AS ddt_path_10, t0.signed_ddt_path AS signed_ddt_path_11, t0.type AS type_12, t0.is_ddt_mandatory AS is_ddt_mandatory_13, t0.is_divestment AS is_divestment_14, t0.warehouse_from_id AS warehouse_from_id_15, t0.warehouse_to_id AS warehouse_to_id_16, t0.user_from_id AS user_from_id_17, t0.user_to_id AS user_to_id_18, t0.supplier_id AS supplier_id_19, t0.ddt_header_id AS ddt_header_id_20 FROM eposm_s_product_transfer t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "404"
]
16 0.22 ms
SELECT t0.id AS id_1, t0.nickname AS nickname_2, t0.address AS address_3, t0.is_movable AS is_movable_4, t0.is_headquarter AS is_headquarter_5, t0.is_active AS is_active_6, t0.client_id AS client_id_7, t0.destination_id AS destination_id_8 FROM eposm_s_warehouse t0 WHERE t0.id = ?
Parameters:
[
  "349"
]
17 4.68 ms
SELECT t0.id AS id_1, t0.code_producer AS code_producer_2, t0.code_supplier AS code_supplier_3, t0.date_creation AS date_creation_4, t0.date_last_transfer AS date_last_transfer_5, t0.is_active AS is_active_6, t0.to_manage AS to_manage_7, t0.to_manage_priority AS to_manage_priority_8, t0.model_id AS model_id_9, t0.actual_warehouse_id AS actual_warehouse_id_10, t0.status_id AS status_id_11, t0.condition_id AS condition_id_12, t0.termid_id AS termid_id_13, t0.parent_product_id AS parent_product_id_14 FROM eposm_s_product t0 WHERE t0.actual_warehouse_id = ?
Parameters:
[
  "349"
]
18 0.29 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_product_status t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
19 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sku AS sku_3, t0.part_number AS part_number_4, t0.internal_code AS internal_code_5, t0.image_path AS image_path_6, t0.is_with_sim AS is_with_sim_7, t0.is_with_base AS is_with_base_8, t0.subcategory_id AS subcategory_id_9, t0.producer_id AS producer_id_10 FROM eposm_s_product_model t0 WHERE t0.id = ?
Parameters:
[
  "70"
]
20 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM eposm_s_producer t0 WHERE t0.id = ?
Parameters:
[
  "10"
]
21 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_product_condition t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
22 0.25 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\Warehouse No errors.
App\Entity\Slave\DdtHeader No errors.
App\Entity\Slave\JoinTableProductProductTransfer No errors.
App\Entity\Slave\Client No errors.
App\Entity\Slave\Destination No errors.
App\Entity\Slave\Product No errors.
App\Entity\Slave\ProductModel No errors.
App\Entity\Slave\ProductStatus No errors.
App\Entity\Slave\ProductCondition No errors.
App\Entity\Slave\Termid No errors.
App\Entity\Slave\ProductLog No errors.
App\Entity\Slave\ProductRegenerated No errors.
App\Entity\Slave\InterventionActivity No errors.
App\Entity\Slave\ProductSubcategory No errors.
App\Entity\Slave\Producer No errors.
App\Entity\Slave\JoinTableProductModelSupplier No errors.
App\Entity\Slave\ProductComponent No errors.