Query Metrics
49
Database Queries
7
Different statements
5.58 ms
Query time
0
Invalid entities
Queries
master connection
#▲ | Time | Info |
---|---|---|
1 | 0.36 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 | 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 = ?
Parameters:
[
"18"
]
|
3 | 1.03 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 | 0.21 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:
[ "giacomomaltese@gmail.com" "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:
[ "ana_maria.timofte@selir.com" "1" "4" "5" "8" "9" "27" ] |
3 | 0.16 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:
[ "assistenza@nettlc.it" "1" "4" "5" "8" "9" "27" ] |
4 | 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:
[ "noreply@worldlineitalia.it" "1" "4" "5" "8" "9" "27" ] |
5 | 0.14 ms |
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.is_active AS is_active_8 FROM eposm_s_supplier t0 WHERE t0.id = ?
Parameters:
[
"3"
]
|
6 | 0.27 ms |
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"
]
|
7 | 0.15 ms |
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"
]
|
8 | 0.10 ms |
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:
[
"2"
]
|
9 | 0.09 ms |
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:
[
"3"
]
|
10 | 0.10 ms |
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:
[
"4"
]
|
11 | 0.07 ms |
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:
[
"5"
]
|
12 | 0.07 ms |
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:
[
"6"
]
|
13 | 0.12 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:
[ "noreply@eposmanager.software" "1" "4" "5" "8" "9" "27" ] |
14 | 0.10 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:
[ "Nexi_Informa@nexi.it" "1" "4" "5" "8" "9" "27" ] |
15 | 0.07 ms |
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.is_active AS is_active_8 FROM eposm_s_supplier t0 WHERE t0.id = ?
Parameters:
[
"5"
]
|
16 | 0.09 ms |
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:
[
"5"
]
|
17 | 0.06 ms |
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:
[
"13"
]
|
18 | 0.06 ms |
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:
[
"14"
]
|
19 | 0.06 ms |
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:
[
"15"
]
|
20 | 0.06 ms |
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:
[
"16"
]
|
21 | 0.06 ms |
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:
[
"17"
]
|
22 | 0.06 ms |
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:
[
"18"
]
|
23 | 0.06 ms |
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.is_active AS is_active_8 FROM eposm_s_supplier t0 WHERE t0.id = ?
Parameters:
[
"6"
]
|
24 | 0.07 ms |
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:
[
"6"
]
|
25 | 0.06 ms |
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:
[
"19"
]
|
26 | 0.06 ms |
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:
[
"20"
]
|
27 | 0.06 ms |
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:
[
"21"
]
|
28 | 0.05 ms |
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:
[
"22"
]
|
29 | 0.06 ms |
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:
[
"23"
]
|
30 | 0.05 ms |
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:
[
"24"
]
|
31 | 0.11 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:
[ "apps@mobileforcesoftware.com" "1" "4" "5" "8" "9" "27" ] |
32 | 0.06 ms |
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.is_active AS is_active_8 FROM eposm_s_supplier t0 WHERE t0.id = ?
Parameters:
[
"4"
]
|
33 | 0.07 ms |
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:
[
"4"
]
|
34 | 0.07 ms |
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:
[
"7"
]
|
35 | 0.06 ms |
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:
[
"8"
]
|
36 | 0.06 ms |
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:
[
"9"
]
|
37 | 0.06 ms |
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:
[
"10"
]
|
38 | 0.06 ms |
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:
[
"11"
]
|
39 | 0.06 ms |
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:
[
"12"
]
|
40 | 0.06 ms |
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.is_active AS is_active_8 FROM eposm_s_supplier t0 WHERE t0.id = ?
Parameters:
[
"7"
]
|
41 | 0.07 ms |
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:
[
"7"
]
|
42 | 0.07 ms |
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:
[
"26"
]
|
43 | 0.08 ms |
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:
[
"27"
]
|
44 | 0.06 ms |
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:
[
"28"
]
|
45 | 0.09 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:
[ "infopoint.roma@visura.it" "1" "4" "5" "8" "9" "27" ] |
46 | 0.09 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. |
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. |