Query Metrics
5
Database Queries
4
Different statements
65.18 ms
Query time
0
Invalid entities
Queries
master connection
#▲ | Time | Info |
---|---|---|
1 | 12.83 ms |
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"
]
|
2 | 4.90 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 = ?
Parameters:
[
"18"
]
|
3 | 24.51 ms |
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"
]
|
slave connection
#▲ | Time | Info |
---|---|---|
1 | 22.79 ms |
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:
[ "no-reply@supplychaincollaboration.it" "1" "4" "5" "8" "9" "27" ] |
2 | 0.15 ms |
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:
[ "lazio@rtipositalia.it" "1" "4" "5" "8" "9" "27" ] |
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. |
slave entity manager
Class | Mapping errors |
---|---|
App\Entity\Slave\SupplierTicketEmail | No errors. |
App\Entity\Slave\Supplier | No errors. |