https://eposmanager.software/script/ticket/scarica-da-email-per-mailer/nettlcsrls

Query Metrics

43 Database Queries
8 Different statements
8.43 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

master connection

Time Count Info
0.32 ms
(3.85%)
1
SELECT t0.id AS id_1, t0.nickname AS nickname_2, t0.user AS user_3, t0.password AS password_4, t0.company_id AS company_id_5 FROM eposm_m_company_mailer t0 WHERE t0.nickname = ? LIMIT 1
Parameters:
[
  "nettlcsrls"
]
0.27 ms
(3.22%)
1
SELECT t0.id AS id_1, t0.nickname AS nickname_2, t0.name AS name_3, t0.phone AS phone_4 FROM eposm_m_supplier t0 INNER JOIN eposm_m_join_table_company_mailer_supplier ON t0.id = eposm_m_join_table_company_mailer_supplier.supplier_id WHERE eposm_m_join_table_company_mailer_supplier.companymailer_id = ?
Parameters:
[
  "4"
]
0.21 ms
(2.53%)
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.id = ?
Parameters:
[
  "18"
]

slave connection

Time Count Info
4.97 ms
(58.99%)
17
SELECT e0_.id AS id_0, e0_.value AS value_1, e0_.is_html AS is_html_2, e0_.supplier_id AS supplier_id_3 FROM eposm_s_supplier_ticket_email e0_ LEFT JOIN eposm_s_supplier e1_ ON e0_.supplier_id = e1_.id WHERE e0_.value = ? AND e1_.id_supplier IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  "corradocattaneo@hotmail.com"
  "1"
  "4"
  "5"
  "8"
  "9"
  "27"
]
1.61 ms
(19.12%)
16
SELECT t0.id AS id_1, t0.value AS value_2, t0.operation_id AS operation_id_3 FROM eposm_s_operation_subject_mapping t0 WHERE t0.operation_id = ?
Parameters:
[
  "1"
]
0.41 ms
(4.87%)
3
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug_master AS slug_master_3, t0.code_client AS code_client_4, t0.identifier_regex AS identifier_regex_5, t0.is_uav AS is_uav_6, t0.active AS active_7, t0.supplier_id AS supplier_id_8, t0.group_id AS group_id_9 FROM eposm_s_operation t0 WHERE t0.supplier_id = ?
Parameters:
[
  "3"
]
0.33 ms
(3.96%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.amount_regenerate AS amount_regenerate_4, t0.id_supplier AS id_supplier_5, t0.operation_mapping AS operation_mapping_6, t0.amount_ticket_extra_hour AS amount_ticket_extra_hour_7, t0.operation_not_billable_codes AS operation_not_billable_codes_8, t0.is_active AS is_active_9 FROM eposm_s_supplier t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
0.29 ms
(3.46%)
1
SELECT e0_.id AS id_0, e0_.value AS value_1, e0_.operation_id AS operation_id_2 FROM eposm_s_operation_subject_mapping e0_ LEFT JOIN eposm_s_operation e1_ ON e0_.operation_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e1_.supplier_id = e2_.id WHERE e2_.id = ? AND ? LIKE CONCAT('%', e0_.value, '%') AND e1_.is_uav <> 1
Parameters:
[
  "7"
  "Ticket 026859/FX Creato per Office P2P SYSTEM SRL dall'utente ADINA GEORGIANA PIRONEA"
]

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\CompanyMailer No errors.
App\Entity\Master\Company No errors.
App\Entity\Master\Supplier 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.
App\Entity\Master\SupplierOperation No errors.
App\Entity\Master\City No errors.
App\Entity\Master\JoinTableLicenseFeature No errors.
App\Entity\Master\OrderItem No errors.
App\Entity\Master\Feature No errors.
App\Entity\Master\Province No errors.
App\Entity\Master\SupplierOperationAlgorithm No errors.

slave entity manager

Class Mapping errors
App\Entity\Slave\SupplierTicketEmail No errors.
App\Entity\Slave\Supplier No errors.
App\Entity\Slave\Ticket No errors.
App\Entity\Slave\Operation No errors.
App\Entity\Slave\JoinTableUserSupplier No errors.
App\Entity\Slave\ProductTransfer No errors.
App\Entity\Slave\JoinTableProductModelSupplier No errors.
App\Entity\Slave\ProductRegenerated No errors.
App\Entity\Slave\TicketColumnValue No errors.
App\Entity\Slave\Product No errors.
App\Entity\Slave\User No errors.
App\Entity\Slave\OperationGroup No errors.
App\Entity\Slave\OperationTariff No errors.
App\Entity\Slave\OperationKeyMapping No errors.
App\Entity\Slave\OperationSubjectMapping No errors.
App\Entity\Slave\OperationAlgorithm No errors.
App\Entity\Slave\Client No errors.
App\Entity\Slave\TicketStatus No errors.
App\Entity\Slave\Termid No errors.
App\Entity\Slave\OperationTariffAmount No errors.
App\Entity\Slave\TicketSuspension No errors.
App\Entity\Slave\Intervention No errors.
App\Entity\Slave\TicketReminder No errors.
App\Entity\Slave\TicketLog No errors.
App\Entity\Slave\Warehouse No errors.
App\Entity\Slave\DdtHeader No errors.
App\Entity\Slave\JoinTableProductProductTransfer No errors.
App\Entity\Slave\ProductTransferLog No errors.
App\Entity\Slave\ProductModel No errors.
App\Entity\Slave\ProductStatus No errors.
App\Entity\Slave\ProductCondition No errors.
App\Entity\Slave\ProductLog No errors.
App\Entity\Slave\InterventionActivity 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\ProductRequest No errors.
App\Entity\Slave\InterventionActivityType No errors.