Query Metrics
118
Database Queries
36
Different statements
78.20 ms
Query time
0
Invalid entities
Queries
master connection
#▲ | Time | Info |
---|---|---|
1 | 0.30 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 | 0.29 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"
]
|
4 | 0.62 ms |
SELECT t0.id AS id_1, t0.code AS code_2 FROM eposm_m_zip t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"00185"
]
|
5 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.province_id AS province_id_3, t0.region_id AS region_id_4 FROM eposm_m_city t0 INNER JOIN eposm_m_join_table_city_zip ON t0.id = eposm_m_join_table_city_zip.city_id WHERE eposm_m_join_table_city_zip.zip_id = ?
Parameters:
[
"4436"
]
|
6 | 0.28 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.province_id AS province_id_2, e0_.region_id AS region_id_3 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE (e1_.id = ? AND e0_.name = ?)
Parameters:
[ "80" "ROMA" ] |
7 | 0.20 ms |
SELECT t0.id AS id_1, t0.code AS code_2 FROM eposm_m_zip t0 INNER JOIN eposm_m_join_table_city_zip ON t0.id = eposm_m_join_table_city_zip.zip_id WHERE eposm_m_join_table_city_zip.city_id = ?
Parameters:
[
"4725"
]
|
8 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sign AS sign_3, t0.region_id AS region_id_4 FROM eposm_m_province t0 WHERE t0.id = ?
Parameters:
[
"80"
]
|
9 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM eposm_m_region t0 INNER JOIN eposm_m_join_table_company_region ON t0.id = eposm_m_join_table_company_region.region_id WHERE eposm_m_join_table_company_region.company_id = ?
Parameters:
[
"18"
]
|
10 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.province_id AS province_id_3, t0.region_id AS region_id_4 FROM eposm_m_city t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"4725"
]
|
slave connection
#▲ | Time | Info |
---|---|---|
1 | 0.26 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" ] |
2 | 0.12 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 FROM eposm_s_supplier t0 WHERE t0.id = ?
Parameters:
[
"4"
]
|
3 | 0.28 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"
]
|
4 | 0.21 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"
]
|
5 | 0.16 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"
]
|
6 | 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:
[
"9"
]
|
7 | 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"
]
|
8 | 0.31 ms |
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:
[ "4" "Ticket 000535/ROLL Creato per Office NET TELECOMUNICAZIONI SRL dall'utente Silvia Finucci" ] |
9 | 0.18 ms |
SELECT t0.id AS id_1, t0.ticket_column AS ticket_column_2, t0.mapping_value AS mapping_value_3, t0.mapping_extra AS mapping_extra_4, t0.priority AS priority_5, t0.is_key_required AS is_key_required_6, t0.is_ticket_number AS is_ticket_number_7, t0.is_termid AS is_termid_8, t0.operation_id AS operation_id_9 FROM eposm_s_operation_key_mapping t0 WHERE t0.operation_id = ? ORDER BY t0.priority ASC
Parameters:
[
"10"
]
|
10 | 7.75 ms |
SELECT e0_.id AS id_0, e0_.number AS number_1, e0_.datetime_import AS datetime_import_2, e0_.datetime_start AS datetime_start_3, e0_.datetime_expiration AS datetime_expiration_4, e0_.datetime_end AS datetime_end_5, e0_.address AS address_6, e0_.locality AS locality_7, e0_.zip AS zip_8, e0_.id_city AS id_city_9, e0_.id_province AS id_province_10, e0_.other_city AS other_city_11, e0_.system_error AS system_error_12, e0_.system_error_slug AS system_error_slug_13, e0_.system_error_details AS system_error_details_14, e0_.json AS json_15, e0_.directory_path AS directory_path_16, e0_.waybill AS waybill_17, e0_.json_report AS json_report_18, e0_.billable AS billable_19, e0_.closed_on_portal AS closed_on_portal_20, e0_.supplier_id AS supplier_id_21, e0_.client_id AS client_id_22, e0_.operation_id AS operation_id_23, e0_.technician_id AS technician_id_24, e0_.status_id AS status_id_25, e0_.termid_id AS termid_id_26, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_27, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_28 FROM eposm_s_ticket e0_ WHERE e0_.number = ?
Parameters:
[
"000535/ROLL"
]
|
11 | 0.16 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_ticket_status t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"to_assign"
]
|
12 | 0.09 ms |
"START TRANSACTION"
Parameters:
[] |
13 | 0.28 ms |
INSERT INTO eposm_s_ticket (number, datetime_import, datetime_start, datetime_expiration, datetime_end, address, locality, zip, id_city, id_province, other_city, system_error, system_error_slug, system_error_details, json, directory_path, waybill, json_report, billable, closed_on_portal, supplier_id, client_id, operation_id, technician_id, status_id, termid_id, operation_tariff_amount_id, uav_operation_tariff_amount_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "2025-03-17 10:40:02" "2025-03-17 11:39:49" null null null null null null null null 0 null null "[{"Stato":"Aperto"},{"Causale":"AGGIORNAMENTO SOFTWARE"},{"Centro servizi":"Roll Out"},{"ID per il tecnico":"000535\/ROLL"},{"Insegna":"MARCO POLICHENI E C SAS"},{"Indirizzo":"VIA PRINCIPE AMEDEO 76"},{"Localit\u00e0":"ROMA"},{"CAP":"00185"},{"Telefono":"393316503953"},{"Identificativo terminale":"02794886"},{"Matricola POS installata":"183597333071045603699080"},{"Note":""}]" "2025/03/e3d1d37e5cbb08454ade9f6e125a1668" null "[]" 1 0 "4" null "10" null "1" null null null ] |
14 | 9.41 ms |
"COMMIT"
Parameters:
[] |
15 | 0.34 ms |
SELECT e0_.id AS id_0, e0_.ticket_column AS ticket_column_1, e0_.mapping_value AS mapping_value_2, e0_.mapping_extra AS mapping_extra_3, e0_.priority AS priority_4, e0_.is_key_required AS is_key_required_5, e0_.is_ticket_number AS is_ticket_number_6, e0_.is_termid AS is_termid_7, e0_.operation_id AS operation_id_8 FROM eposm_s_operation_key_mapping e0_ LEFT JOIN eposm_s_operation e1_ ON e0_.operation_id = e1_.id WHERE e1_.id = ? AND e0_.is_key_required = ? ORDER BY e0_.priority ASC
Parameters:
[ "10" 1 ] |
16 | 1.79 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"02794886"
]
|
17 | 5.33 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.code = ? LIMIT 1
Parameters:
[
"02794886"
]
|
18 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
19 | 0.16 ms |
INSERT INTO eposm_s_client (code, name, nickname, referent, fiscal_code, vat, sdi, address, locality, zip, id_city, id_province, closures, openings, notes, directory_path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "02794886" null null null null null null null null null null null null null null "2eaa1bdda7248b9ef6e156f4db2e6101" ] |
20 | 0.08 ms |
INSERT INTO eposm_s_warehouse (nickname, address, is_movable, is_headquarter, is_active, client_id, destination_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null null 0 0 1 "19399" null ] |
21 | 6.19 ms |
"COMMIT"
Parameters:
[] |
22 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
23 | 0.14 ms |
UPDATE eposm_s_ticket SET client_id = ? WHERE id = ?
Parameters:
[ "19399" "23958" ] |
24 | 7.89 ms |
"COMMIT"
Parameters:
[] |
25 | 0.36 ms |
SELECT e0_.id AS id_0, e0_.ticket_column AS ticket_column_1, e0_.mapping_value AS mapping_value_2, e0_.mapping_extra AS mapping_extra_3, e0_.priority AS priority_4, e0_.is_key_required AS is_key_required_5, e0_.is_ticket_number AS is_ticket_number_6, e0_.is_termid AS is_termid_7, e0_.operation_id AS operation_id_8 FROM eposm_s_operation_key_mapping e0_ LEFT JOIN eposm_s_operation e1_ ON e0_.operation_id = e1_.id WHERE e1_.id = ? AND e0_.is_key_required = ? ORDER BY e0_.priority ASC
Parameters:
[ "10" 0 ] |
26 | 0.19 ms |
SELECT e0_.id AS id_0, e0_.ticket_column AS ticket_column_1, e0_.mapping_value AS mapping_value_2, e0_.mapping_extra AS mapping_extra_3, e0_.priority AS priority_4, e0_.is_key_required AS is_key_required_5, e0_.is_ticket_number AS is_ticket_number_6, e0_.is_termid AS is_termid_7, e0_.operation_id AS operation_id_8 FROM eposm_s_operation_key_mapping e0_ LEFT JOIN eposm_s_operation e1_ ON e0_.operation_id = e1_.id WHERE e1_.id = ? AND e0_.is_key_required = ? ORDER BY e0_.priority ASC
Parameters:
[ "10" 1 ] |
27 | 1.78 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"02794886"
]
|
28 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
29 | 0.11 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "393316503953" "Telefono 1" "19399" ] |
30 | 0.08 ms |
INSERT INTO eposm_s_termid (code, client_id) VALUES (?, ?)
Parameters:
[ "02794886" "19399" ] |
31 | 0.13 ms |
UPDATE eposm_s_ticket SET number = ?, address = ?, zip = ?, id_city = ?, id_province = ?, json_report = ?, termid_id = ? WHERE id = ?
Parameters:
[ "000535/ROLL" "VIA PRINCIPE AMEDEO 76" "00185" "4725" "80" "[{"Matricole":"183597333071045603699080"},{"Anomalia":""},{"Dettagli operazione":"AGGIORNAMENTO SOFTWARE"}]" "19608" "23958" ] |
32 | 0.08 ms |
UPDATE eposm_s_client SET nickname = ?, address = ?, zip = ?, id_city = ?, id_province = ? WHERE id = ?
Parameters:
[ "MARCO POLICHENI E C SAS" "VIA PRINCIPE AMEDEO 76" "00185" "4725" "80" "19399" ] |
33 | 0.07 ms |
UPDATE eposm_s_warehouse SET nickname = ? WHERE id = ?
Parameters:
[ "Cliente - MARCO POLICHENI E C SAS" "19424" ] |
34 | 7.32 ms |
"COMMIT"
Parameters:
[] |
35 | 0.19 ms |
SELECT t0.id AS id_1, t0.is_all_zip AS is_all_zip_2, t0.id_province AS id_province_3, t0.zips AS zips_4, t0.operation_id AS operation_id_5 FROM eposm_s_operation_tariff t0 WHERE t0.operation_id = ?
Parameters:
[
"10"
]
|
36 | 0.13 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.amount AS amount_3, t0.is_standard AS is_standard_4, t0.operation_tariff_id AS operation_tariff_id_5, t0.operation_algorithm_id AS operation_algorithm_id_6 FROM eposm_s_operation_tariff_amount t0 WHERE t0.operation_tariff_id = ?
Parameters:
[
"400"
]
|
37 | 0.19 ms |
SELECT t0.id AS id_1, t0.is_all_zip AS is_all_zip_2, t0.id_province AS id_province_3, t0.zips AS zips_4, t0.operation_id AS operation_id_5 FROM eposm_s_operation_tariff t0 WHERE t0.operation_id = ?
Parameters:
[
"12"
]
|
38 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.amount AS amount_3, t0.is_standard AS is_standard_4, t0.operation_tariff_id AS operation_tariff_id_5, t0.operation_algorithm_id AS operation_algorithm_id_6 FROM eposm_s_operation_tariff_amount t0 WHERE t0.operation_tariff_id = ?
Parameters:
[
"405"
]
|
39 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
40 | 6.62 ms |
UPDATE eposm_s_ticket SET operation_tariff_amount_id = ?, uav_operation_tariff_amount_id = ? WHERE id = ?
Parameters:
[ "400" "405" "23958" ] |
41 | 7.67 ms |
"COMMIT"
Parameters:
[] |
42 | 0.23 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"ticket_auto_assign"
]
|
43 | 0.29 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" ] |
44 | 0.29 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:
[ "direzione@rtipositalia.it" "1" "4" "5" "8" "9" "27" ] |
45 | 0.20 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:
[ "vnisantilli72@gmail.com" "1" "4" "5" "8" "9" "27" ] |
46 | 0.19 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" ] |
47 | 0.10 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 FROM eposm_s_supplier t0 WHERE t0.id = ?
Parameters:
[
"3"
]
|
48 | 0.17 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"
]
|
49 | 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:
[
"1"
]
|
50 | 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:
[
"2"
]
|
51 | 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:
[
"3"
]
|
52 | 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:
[
"4"
]
|
53 | 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:
[
"5"
]
|
54 | 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:
[
"6"
]
|
55 | 0.22 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" ] |
56 | 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:
[ "noreply@worldlineitalia.it" "1" "4" "5" "8" "9" "27" ] |
57 | 0.32 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" ] |
58 | 0.26 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" ] |
59 | 0.20 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:
[ "direzione@rtipositalia.it" "1" "4" "5" "8" "9" "27" ] |
60 | 0.24 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" ] |
61 | 0.23 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" ] |
62 | 0.25 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" ] |
63 | 0.30 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" ] |
64 | 0.28 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" ] |
65 | 0.27 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" ] |
66 | 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:
[ "noreply@eposmanager.software" "1" "4" "5" "8" "9" "27" ] |
67 | 0.13 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" ] |
68 | 0.12 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"
]
|
69 | 0.16 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"
]
|
70 | 0.13 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 FROM eposm_s_supplier t0 WHERE t0.id = ?
Parameters:
[
"7"
]
|
71 | 0.15 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"
]
|
72 | 0.12 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"
]
|
73 | 0.11 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"
]
|
74 | 0.13 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"
]
|
75 | 0.20 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" ] |
76 | 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:
[ "apps@mobileforcesoftware.com" "1" "4" "5" "8" "9" "27" ] |
77 | 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:
[ "vnisantilli72@gmail.com" "1" "4" "5" "8" "9" "27" ] |
78 | 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:
[ "no-reply@supplychaincollaboration.it" "1" "4" "5" "8" "9" "27" ] |
79 | 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:
[ "Nexi_Informa@nexi.it" "1" "4" "5" "8" "9" "27" ] |
80 | 0.09 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 FROM eposm_s_supplier t0 WHERE t0.id = ?
Parameters:
[
"5"
]
|
81 | 0.11 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"
]
|
82 | 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:
[
"13"
]
|
83 | 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:
[
"14"
]
|
84 | 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:
[
"15"
]
|
85 | 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:
[
"16"
]
|
86 | 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:
[
"17"
]
|
87 | 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:
[
"18"
]
|
88 | 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 FROM eposm_s_supplier t0 WHERE t0.id = ?
Parameters:
[
"6"
]
|
89 | 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:
[
"6"
]
|
90 | 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:
[
"19"
]
|
91 | 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:
[
"20"
]
|
92 | 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:
[
"21"
]
|
93 | 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:
[
"22"
]
|
94 | 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"
]
|
95 | 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:
[
"24"
]
|
96 | 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:
[ "noreply@worldlineitalia.it" "1" "4" "5" "8" "9" "27" ] |
97 | 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:
[ "lazio@rtipositalia.it" "1" "4" "5" "8" "9" "27" ] |
98 | 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:
[ "noreply@worldlineitalia.it" "1" "4" "5" "8" "9" "27" ] |
99 | 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:
[ "for.giuseppetortora@gmail.com" "1" "4" "5" "8" "9" "27" ] |
100 | 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:
[ "noreply@worldlineitalia.it" "1" "4" "5" "8" "9" "27" ] |
101 | 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:
[ "noreply@worldlineitalia.it" "1" "4" "5" "8" "9" "27" ] |
102 | 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:
[ "noreply@worldlineitalia.it" "1" "4" "5" "8" "9" "27" ] |
103 | 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:
[ "noreply@worldlineitalia.it" "1" "4" "5" "8" "9" "27" ] |
104 | 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:
[ "noreply@worldlineitalia.it" "1" "4" "5" "8" "9" "27" ] |
105 | 0.08 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" ] |
106 | 0.08 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" ] |
107 | 0.08 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" ] |
108 | 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:
[ "Nexi_Informa@nexi.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. |
App\Entity\Master\Zip | No errors. |
App\Entity\Master\City | No errors. |
App\Entity\Master\Province | No errors. |
App\Entity\Master\CityAlias | No errors. |