Query Metrics
359
Database Queries
36
Different statements
1429.71 ms
Query time
0
Invalid entities
Queries
master connection
#▲ | Time | Info |
---|---|---|
1 | 0.35 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:
[
"sipossas"
]
|
2 | 0.24 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:
[
"1"
]
|
3 | 0.21 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:
[
"3"
]
|
4 | 0.24 ms |
SELECT t0.id AS id_1, t0.code AS code_2 FROM eposm_m_zip t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"12100"
]
|
5 | 0.22 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:
[
"192"
]
|
6 | 0.36 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:
[ "25" "Cuneo" ] |
7 | 0.13 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:
[
"557"
]
|
8 | 0.08 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:
[
"25"
]
|
9 | 0.10 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:
[
"1"
]
|
10 | 0.20 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:
[
"557"
]
|
11 | 0.16 ms |
SELECT t0.id AS id_1, t0.code AS code_2 FROM eposm_m_zip t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"12100"
]
|
12 | 0.32 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:
[ "25" "Cuneo" ] |
13 | 0.25 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:
[
"557"
]
|
14 | 0.10 ms |
SELECT t0.id AS id_1, t0.code AS code_2 FROM eposm_m_zip t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"12100"
]
|
15 | 0.26 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:
[ "25" "Cuneo" ] |
16 | 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:
[
"557"
]
|
17 | 0.18 ms |
SELECT t0.id AS id_1, t0.code AS code_2 FROM eposm_m_zip t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"11016"
]
|
18 | 0.13 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:
[
"364"
]
|
19 | 0.22 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:
[ "4" "La Thuile" ] |
20 | 0.12 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:
[
"1073"
]
|
21 | 0.08 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:
[
"4"
]
|
22 | 0.20 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:
[
"1073"
]
|
23 | 0.22 ms |
SELECT t0.id AS id_1, t0.code AS code_2 FROM eposm_m_zip t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"11010"
]
|
24 | 0.16 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:
[
"352"
]
|
25 | 0.22 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:
[ "4" "Roisan" ] |
26 | 0.14 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:
[
"1089"
]
|
27 | 0.21 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:
[
"1089"
]
|
28 | 0.57 ms |
SELECT t0.id AS id_1, t0.code AS code_2 FROM eposm_m_zip t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"10126"
]
|
29 | 0.12 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:
[
"4027"
]
|
30 | 0.41 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:
[ "94" "Torino" ] |
31 | 0.18 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:
[
"268"
]
|
32 | 0.17 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:
[
"94"
]
|
33 | 0.17 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:
[
"268"
]
|
34 | 0.22 ms |
SELECT t0.id AS id_1, t0.code AS code_2 FROM eposm_m_zip t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"11100"
]
|
35 | 0.17 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:
[
"354"
]
|
36 | 0.17 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:
[ "4" "Aosta" ] |
37 | 0.11 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:
[
"1035"
]
|
38 | 0.15 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:
[
"1035"
]
|
39 | 0.09 ms |
SELECT t0.id AS id_1, t0.code AS code_2 FROM eposm_m_zip t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"10024"
]
|
40 | 0.15 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:
[
"45"
]
|
41 | 0.30 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:
[ "94" "Moncalieri" ] |
42 | 0.09 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:
[
"153"
]
|
43 | 0.18 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:
[
"153"
]
|
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:
[ "noreply@worldlineitalia.it" "1" "4" "5" "6" "7" "8" ] |
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, t0.is_active AS is_active_8 FROM eposm_s_supplier t0 WHERE t0.id = ?
Parameters:
[
"6"
]
|
3 | 0.25 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"
]
|
4 | 0.19 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"
]
|
5 | 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"
]
|
6 | 0.21 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.slug = ? LIMIT 1
Parameters:
[
"worldline-italia"
]
|
7 | 0.08 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.slug = ? LIMIT 1
Parameters:
[
"worldline-ccb"
]
|
8 | 0.10 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:
[
"8"
]
|
9 | 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:
[
"46"
]
|
10 | 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:
[
"47"
]
|
11 | 0.17 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:
[
"47"
]
|
12 | 19.64 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:
[
"I25011596"
]
|
13 | 0.23 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"
]
|
14 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
15 | 0.55 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-18 19:35:02" "2025-03-18 18:32:32" null null null null null null null null 0 null null "[{"Cliente":"Worldline"},{"Intervento":"I25011596"},{"Tipo di intervento":"Installazione on site"},{"Codice tipo intervento":"INO"},{"Societ\u00e0 che esegue l'intervento":"SIPOS Piemonte"},{"Tecnico assegnato all'intervento":"non disp."},{"Soluzione":"OMNIPOS PORTABLE PLUS"},{"Opzioni Attive":"Microcircuito + CUP"},{"Canale":"08439 - BANCA DI CARAGLIO, DEL CUNEESE E DELLA RIVIERA DEI FIORI C.C. SCRL"},{"Canale Brand":"WL-CCB"},{"Connessione 1":"151"},{"Connessione 2":"109Punto Vendita"},{"Tid":"07147289"},{"Mid":"039689831"},{"Insegna":"Mcs Marlboro"},{"Citt\u00e0":"Cuneo"},{"CAP":"12100"},{"Provincia":"CN"},{"Indirizzo":"Piazza Galimberti,14"},{"Telefono 1":"347\/6010477"},{"Telefono 2":"non disp."},{"Telefono Aggiuntivo":"non disp."},{"Codice Esercente":"3815104"},{"Codice Stabilimento":"00016"},{"Note Intervento":"N1: ,N2:"},{"Data Apertura":"18\/03\/25-19:32"},{"Data Scadenza Presa In Carico":"19\/03\/25-09:32"},{"Data Presa In Carico":"non disp."},{"Data Scadenza Sla":"non disp."},{"Data Chiusura":"non disp."}]" "2025/03/3a0c93bb2ddb7dc81c4dca66a16de166" null "[]" 1 0 "8" null "47" null "1" null null null ] |
16 | 27.21 ms |
"COMMIT"
Parameters:
[] |
17 | 0.31 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:
[ "47" 1 ] |
18 | 2.51 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:
[
"07147289"
]
|
19 | 9.70 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:
[
"07147289"
]
|
20 | 0.06 ms |
"START TRANSACTION"
Parameters:
[] |
21 | 0.12 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:
[ "07147289" null null null null null null null null null null null null null null "cd9545e3f141c0b55db8b96fb646dd4e" ] |
22 | 0.09 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 "19853" null ] |
23 | 12.16 ms |
"COMMIT"
Parameters:
[] |
24 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
25 | 0.25 ms |
UPDATE eposm_s_ticket SET client_id = ? WHERE id = ?
Parameters:
[ "19853" "23657" ] |
26 | 32.60 ms |
"COMMIT"
Parameters:
[] |
27 | 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:
[ "47" 0 ] |
28 | 0.18 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:
[ "47" 1 ] |
29 | 2.35 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:
[
"07147289"
]
|
30 | 0.06 ms |
"START TRANSACTION"
Parameters:
[] |
31 | 0.16 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "347/6010477" "Telefono 1" "19853" ] |
32 | 0.09 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "non disp." "Telefono 2" "19853" ] |
33 | 0.09 ms |
INSERT INTO eposm_s_termid (code, client_id) VALUES (?, ?)
Parameters:
[ "07147289" "19853" ] |
34 | 0.15 ms |
UPDATE eposm_s_ticket SET number = ?, address = ?, zip = ?, id_city = ?, id_province = ?, json_report = ?, termid_id = ? WHERE id = ?
Parameters:
[ "I25011596" "Piazza Galimberti,14" "12100" "557" "25" "[{"ABI":"08439 - BANCA DI CARAGLIO, DEL CUNEESE E DELLA RIVIERA DEI FIORI C.C. SCRL"},{"Anomalia":"N1: ,N2:"},{"Dettagli operazione":"Installazione on site"},{"Dettagli intervento":"Installazione on site"},{"Risorsa upgrade":"OMNIPOS PORTABLE PLUS"}]" "20141" "23657" ] |
35 | 0.09 ms |
UPDATE eposm_s_client SET nickname = ?, address = ?, zip = ?, id_city = ?, id_province = ? WHERE id = ?
Parameters:
[ "Mcs Marlboro" "Piazza Galimberti,14" "12100" "557" "25" "19853" ] |
36 | 0.08 ms |
UPDATE eposm_s_warehouse SET nickname = ? WHERE id = ?
Parameters:
[ "Cliente - Mcs Marlboro" "21591" ] |
37 | 12.85 ms |
"COMMIT"
Parameters:
[] |
38 | 0.17 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:
[
"47"
]
|
39 | 0.14 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:
[
"581"
]
|
40 | 0.14 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:
[
"51"
]
|
41 | 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:
[
"564"
]
|
42 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
43 | 0.15 ms |
UPDATE eposm_s_ticket SET operation_tariff_amount_id = ?, uav_operation_tariff_amount_id = ? WHERE id = ?
Parameters:
[ "1009" "970" "23657" ] |
44 | 67.49 ms |
"COMMIT"
Parameters:
[] |
45 | 0.24 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"
]
|
46 | 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" "6" "7" "8" ] |
47 | 0.26 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.slug = ? LIMIT 1
Parameters:
[
"worldline-italia"
]
|
48 | 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, t0.is_active AS is_active_8 FROM eposm_s_supplier t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"worldline-ccb"
]
|
49 | 15.11 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:
[
"I25011595"
]
|
50 | 0.17 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"
]
|
51 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
52 | 0.23 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-18 19:35:02" "2025-03-18 18:32:32" null null null null null null null null 0 null null "[{"Cliente":"Worldline"},{"Intervento":"I25011595"},{"Tipo di intervento":"Installazione on site"},{"Codice tipo intervento":"INO"},{"Societ\u00e0 che esegue l'intervento":"SIPOS Piemonte"},{"Tecnico assegnato all'intervento":"non disp."},{"Soluzione":"OMNIPOS PORTABLE PLUS"},{"Opzioni Attive":"Microcircuito + CUP"},{"Canale":"08439 - BANCA DI CARAGLIO, DEL CUNEESE E DELLA RIVIERA DEI FIORI C.C. SCRL"},{"Canale Brand":"WL-CCB"},{"Connessione 1":"151"},{"Connessione 2":"109Punto Vendita"},{"Tid":"07147288"},{"Mid":"039689823"},{"Insegna":"Wildfree"},{"Citt\u00e0":"Cuneo"},{"CAP":"12100"},{"Provincia":"CN"},{"Indirizzo":"Corso Nizza,35\/37"},{"Telefono 1":"347\/6010477"},{"Telefono 2":"non disp."},{"Telefono Aggiuntivo":"non disp."},{"Codice Esercente":"3815104"},{"Codice Stabilimento":"00015"},{"Note Intervento":"N1: ,N2:"},{"Data Apertura":"18\/03\/25-19:32"},{"Data Scadenza Presa In Carico":"19\/03\/25-09:32"},{"Data Presa In Carico":"non disp."},{"Data Scadenza Sla":"non disp."},{"Data Chiusura":"non disp."}]" "2025/03/c3f6e9024c5fdd50e096cbabf63280d9" null "[]" 1 0 "8" null "47" null "1" null null null ] |
53 | 7.27 ms |
"COMMIT"
Parameters:
[] |
54 | 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:
[ "47" 1 ] |
55 | 2.39 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:
[
"07147288"
]
|
56 | 8.60 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:
[
"07147288"
]
|
57 | 0.09 ms |
"START TRANSACTION"
Parameters:
[] |
58 | 0.15 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:
[ "07147288" null null null null null null null null null null null null null null "f96f0d361e21368e08116d4c6f683eec" ] |
59 | 0.12 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 "19854" null ] |
60 | 13.13 ms |
"COMMIT"
Parameters:
[] |
61 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
62 | 0.22 ms |
UPDATE eposm_s_ticket SET client_id = ? WHERE id = ?
Parameters:
[ "19854" "23658" ] |
63 | 15.80 ms |
"COMMIT"
Parameters:
[] |
64 | 0.33 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:
[ "47" 0 ] |
65 | 0.22 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:
[ "47" 1 ] |
66 | 2.33 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:
[
"07147288"
]
|
67 | 0.09 ms |
"START TRANSACTION"
Parameters:
[] |
68 | 0.15 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "347/6010477" "Telefono 1" "19854" ] |
69 | 0.06 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "non disp." "Telefono 2" "19854" ] |
70 | 0.05 ms |
INSERT INTO eposm_s_termid (code, client_id) VALUES (?, ?)
Parameters:
[ "07147288" "19854" ] |
71 | 0.13 ms |
UPDATE eposm_s_ticket SET number = ?, address = ?, zip = ?, id_city = ?, id_province = ?, json_report = ?, termid_id = ? WHERE id = ?
Parameters:
[ "I25011595" "Corso Nizza,35/37" "12100" "557" "25" "[{"ABI":"08439 - BANCA DI CARAGLIO, DEL CUNEESE E DELLA RIVIERA DEI FIORI C.C. SCRL"},{"Anomalia":"N1: ,N2:"},{"Dettagli operazione":"Installazione on site"},{"Dettagli intervento":"Installazione on site"},{"Risorsa upgrade":"OMNIPOS PORTABLE PLUS"}]" "20142" "23658" ] |
72 | 0.08 ms |
UPDATE eposm_s_client SET nickname = ?, address = ?, zip = ?, id_city = ?, id_province = ? WHERE id = ?
Parameters:
[ "Wildfree" "Corso Nizza,35/37" "12100" "557" "25" "19854" ] |
73 | 0.07 ms |
UPDATE eposm_s_warehouse SET nickname = ? WHERE id = ?
Parameters:
[ "Cliente - Wildfree" "21592" ] |
74 | 19.54 ms |
"COMMIT"
Parameters:
[] |
75 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
76 | 0.21 ms |
UPDATE eposm_s_ticket SET operation_tariff_amount_id = ?, uav_operation_tariff_amount_id = ? WHERE id = ?
Parameters:
[ "1009" "970" "23658" ] |
77 | 15.50 ms |
"COMMIT"
Parameters:
[] |
78 | 0.11 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"
]
|
79 | 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@worldlineitalia.it" "1" "4" "5" "6" "7" "8" ] |
80 | 0.19 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.slug = ? LIMIT 1
Parameters:
[
"worldline-italia"
]
|
81 | 0.15 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.slug = ? LIMIT 1
Parameters:
[
"worldline-ccb"
]
|
82 | 14.64 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:
[
"I25011594"
]
|
83 | 0.20 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"
]
|
84 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
85 | 0.27 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-18 19:35:02" "2025-03-18 18:32:32" null null null null null null null null 0 null null "[{"Cliente":"Worldline"},{"Intervento":"I25011594"},{"Tipo di intervento":"Installazione on site"},{"Codice tipo intervento":"INO"},{"Societ\u00e0 che esegue l'intervento":"SIPOS Piemonte"},{"Tecnico assegnato all'intervento":"non disp."},{"Soluzione":"OMNIPOS PORTABLE PLUS"},{"Opzioni Attive":"Microcircuito + CUP"},{"Canale":"08439 - BANCA DI CARAGLIO, DEL CUNEESE E DELLA RIVIERA DEI FIORI C.C. SCRL"},{"Canale Brand":"WL-CCB"},{"Connessione 1":"151"},{"Connessione 2":"109Punto Vendita"},{"Tid":"07147293"},{"Mid":"058280108"},{"Insegna":"The North Face Store Cuneo"},{"Citt\u00e0":"Cuneo"},{"CAP":"12100"},{"Provincia":"CN"},{"Indirizzo":"Corso Nizza,31"},{"Telefono 1":"340\/5034228"},{"Telefono 2":"non disp."},{"Telefono Aggiuntivo":"non disp."},{"Codice Esercente":"4573727"},{"Codice Stabilimento":"00003"},{"Note Intervento":"N1: ,N2:"},{"Data Apertura":"18\/03\/25-19:32"},{"Data Scadenza Presa In Carico":"19\/03\/25-09:32"},{"Data Presa In Carico":"non disp."},{"Data Scadenza Sla":"non disp."},{"Data Chiusura":"non disp."}]" "2025/03/2bb43e26b4d2524c7c7d47ba8b55a2d7" null "[]" 1 0 "8" null "47" null "1" null null null ] |
86 | 33.48 ms |
"COMMIT"
Parameters:
[] |
87 | 0.39 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:
[ "47" 1 ] |
88 | 2.36 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:
[
"07147293"
]
|
89 | 8.65 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:
[
"07147293"
]
|
90 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
91 | 0.15 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:
[ "07147293" null null null null null null null null null null null null null null "95c83ee5019d0ec26175bf10e66477f5" ] |
92 | 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 "19855" null ] |
93 | 69.98 ms |
"COMMIT"
Parameters:
[] |
94 | 0.14 ms |
"START TRANSACTION"
Parameters:
[] |
95 | 0.26 ms |
UPDATE eposm_s_ticket SET client_id = ? WHERE id = ?
Parameters:
[ "19855" "23659" ] |
96 | 57.31 ms |
"COMMIT"
Parameters:
[] |
97 | 0.32 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:
[ "47" 0 ] |
98 | 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:
[ "47" 1 ] |
99 | 2.31 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:
[
"07147293"
]
|
100 | 0.09 ms |
"START TRANSACTION"
Parameters:
[] |
101 | 0.13 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "340/5034228" "Telefono 1" "19855" ] |
102 | 0.09 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "non disp." "Telefono 2" "19855" ] |
103 | 0.09 ms |
INSERT INTO eposm_s_termid (code, client_id) VALUES (?, ?)
Parameters:
[ "07147293" "19855" ] |
104 | 0.20 ms |
UPDATE eposm_s_ticket SET number = ?, address = ?, zip = ?, id_city = ?, id_province = ?, json_report = ?, termid_id = ? WHERE id = ?
Parameters:
[ "I25011594" "Corso Nizza,31" "12100" "557" "25" "[{"ABI":"08439 - BANCA DI CARAGLIO, DEL CUNEESE E DELLA RIVIERA DEI FIORI C.C. SCRL"},{"Anomalia":"N1: ,N2:"},{"Dettagli operazione":"Installazione on site"},{"Dettagli intervento":"Installazione on site"},{"Risorsa upgrade":"OMNIPOS PORTABLE PLUS"}]" "20143" "23659" ] |
105 | 0.10 ms |
UPDATE eposm_s_client SET nickname = ?, address = ?, zip = ?, id_city = ?, id_province = ? WHERE id = ?
Parameters:
[ "The North Face Store Cuneo" "Corso Nizza,31" "12100" "557" "25" "19855" ] |
106 | 0.07 ms |
UPDATE eposm_s_warehouse SET nickname = ? WHERE id = ?
Parameters:
[ "Cliente - The North Face Store Cuneo" "21593" ] |
107 | 5.77 ms |
"COMMIT"
Parameters:
[] |
108 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
109 | 0.21 ms |
UPDATE eposm_s_ticket SET operation_tariff_amount_id = ?, uav_operation_tariff_amount_id = ? WHERE id = ?
Parameters:
[ "1009" "970" "23659" ] |
110 | 7.19 ms |
"COMMIT"
Parameters:
[] |
111 | 0.18 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"
]
|
112 | 0.17 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" "6" "7" "8" ] |
113 | 0.18 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"
]
|
114 | 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:
[
"20"
]
|
115 | 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:
[
"27"
]
|
116 | 0.19 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.slug = ? LIMIT 1
Parameters:
[
"worldline-italia"
]
|
117 | 0.08 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.slug = ? LIMIT 1
Parameters:
[
"worldline-ccb"
]
|
118 | 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:
[
"48"
]
|
119 | 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:
[
"49"
]
|
120 | 0.21 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:
[
"49"
]
|
121 | 14.83 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:
[
"C25011592"
]
|
122 | 0.22 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"
]
|
123 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
124 | 0.26 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-18 19:35:02" "2025-03-18 18:32:31" null null null null null null null null 0 null null "[{"Cliente":"Worldline"},{"Intervento":"C25011592"},{"Tipo di intervento":"Migrazione CCB"},{"Codice tipo intervento":"M03"},{"Societ\u00e0 che esegue l'intervento":"SIPOS Piemonte"},{"Tecnico assegnato all'intervento":"non disp."},{"Soluzione":"OMNIPOS PORTABLE PLUS"},{"Opzioni Attive":"Microcircuito + CUP"},{"Prodotto Presente":"non disp."},{"Canale":"08587 - B.C.C. VALDOSTANA COOPERATIVE DE CREDIT VALDOTAINE S.C.R.L."},{"Canale Brand":"WL-CCB"},{"Cluster":"2A"},{"Connessione 1":"151"},{"Connessione 2":"109Punto Vendita"},{"Tid":"07147277"},{"Mid":"058066556"},{"Insegna":"La Clotze S.a.s"},{"Citt\u00e0":"La Thuile"},{"CAP":"11016"},{"Provincia":"AO"},{"Indirizzo":"Frazione Les Suches,snc"},{"Telefono 1":"349\/5219200"},{"Telefono 2":"non disp."},{"Telefono Aggiuntivo":"non disp."},{"Codice Esercente":"6104008"},{"Codice Stabilimento":"00003"},{"Note Intervento":"N1: ,N2:"},{"Data Apertura":"18\/03\/25-19:32"},{"Data Scadenza Presa In Carico":"19\/03\/25-09:32"},{"Data Presa In Carico":"non disp."},{"Data Scadenza Sla":"non disp."},{"Data Chiusura":"non disp."},{"Pos Old":"non disp."},{"Sim Old":"non disp."},{"Pin Pad Old":"non disp."},{"Base Old":"non disp."}]" "2025/03/0ad6f56307ff61db4f4866ad5cd04ffb" null "[]" 1 0 "8" null "49" null "1" null null null ] |
125 | 13.26 ms |
"COMMIT"
Parameters:
[] |
126 | 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:
[ "49" 1 ] |
127 | 2.36 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:
[
"07147277"
]
|
128 | 8.73 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:
[
"07147277"
]
|
129 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
130 | 0.12 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:
[ "07147277" null null null null null null null null null null null null null null "c0072229df229352389be61553148c4f" ] |
131 | 0.07 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 "19856" null ] |
132 | 461.01 ms |
"COMMIT"
Parameters:
[] |
133 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
134 | 0.26 ms |
UPDATE eposm_s_ticket SET client_id = ? WHERE id = ?
Parameters:
[ "19856" "23660" ] |
135 | 57.15 ms |
"COMMIT"
Parameters:
[] |
136 | 0.65 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:
[ "49" 0 ] |
137 | 0.33 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:
[ "49" 1 ] |
138 | 2.54 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:
[
"07147277"
]
|
139 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
140 | 0.10 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "349/5219200" "Telefono 1" "19856" ] |
141 | 0.05 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "non disp." "Telefono 2" "19856" ] |
142 | 0.05 ms |
INSERT INTO eposm_s_termid (code, client_id) VALUES (?, ?)
Parameters:
[ "07147277" "19856" ] |
143 | 0.13 ms |
UPDATE eposm_s_ticket SET number = ?, address = ?, zip = ?, id_city = ?, id_province = ?, json_report = ?, termid_id = ? WHERE id = ?
Parameters:
[ "C25011592" "Frazione Les Suches,snc" "11016" "1073" "4" "[{"ABI":"08587 - B.C.C. VALDOSTANA COOPERATIVE DE CREDIT VALDOTAINE S.C.R.L."},{"Risorsa":"non disp."},{"Accessori":"non disp."},{"Matricole":"non disp."},{"Anomalia":"N1: ,N2:"},{"Dettagli operazione":"Migrazione CCB"},{"Dettagli intervento":"Migrazione CCB"},{"Risorsa upgrade":"OMNIPOS PORTABLE PLUS"}]" "20144" "23660" ] |
144 | 0.08 ms |
UPDATE eposm_s_client SET nickname = ?, address = ?, zip = ?, id_city = ?, id_province = ? WHERE id = ?
Parameters:
[ "La Clotze S.a.s" "Frazione Les Suches,snc" "11016" "1073" "4" "19856" ] |
145 | 0.06 ms |
UPDATE eposm_s_warehouse SET nickname = ? WHERE id = ?
Parameters:
[ "Cliente - La Clotze S.a.s" "21594" ] |
146 | 12.71 ms |
"COMMIT"
Parameters:
[] |
147 | 0.25 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:
[
"49"
]
|
148 | 0.20 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:
[
"551"
]
|
149 | 0.14 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:
[
"560"
]
|
150 | 0.06 ms |
"START TRANSACTION"
Parameters:
[] |
151 | 0.18 ms |
UPDATE eposm_s_ticket SET operation_tariff_amount_id = ?, uav_operation_tariff_amount_id = ? WHERE id = ?
Parameters:
[ "957" "966" "23660" ] |
152 | 11.56 ms |
"COMMIT"
Parameters:
[] |
153 | 0.17 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"
]
|
154 | 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:
[ "noreply@worldlineitalia.it" "1" "4" "5" "6" "7" "8" ] |
155 | 0.27 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.slug = ? LIMIT 1
Parameters:
[
"worldline-italia"
]
|
156 | 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.slug = ? LIMIT 1
Parameters:
[
"worldline-ccb"
]
|
157 | 15.11 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:
[
"I25011592"
]
|
158 | 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"
]
|
159 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
160 | 0.27 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-18 19:35:03" "2025-03-18 18:32:30" null null null null null null null null 0 null null "[{"Cliente":"Worldline"},{"Intervento":"I25011592"},{"Tipo di intervento":"Installazione on site"},{"Codice tipo intervento":"INO"},{"Societ\u00e0 che esegue l'intervento":"SIPOS Piemonte"},{"Tecnico assegnato all'intervento":"non disp."},{"Soluzione":"CORDLESS ETH CLESS"},{"Opzioni Attive":"Microcircuito + CUP"},{"Canale":"08587 - B.C.C. VALDOSTANA COOPERATIVE DE CREDIT VALDOTAINE S.C.R.L."},{"Canale Brand":"WL-CCB"},{"Connessione 1":"150"},{"Connessione 2":"151Punto Vendita"},{"Tid":"07147281"},{"Mid":"058065079"},{"Insegna":"Bouteucca Da Manu"},{"Citt\u00e0":"Roisan"},{"CAP":"11010"},{"Provincia":"AO"},{"Indirizzo":"Frazione Le Martinet,2"},{"Telefono 1":"349\/8751298"},{"Telefono 2":"non disp."},{"Telefono Aggiuntivo":"non disp."},{"Codice Esercente":"4441751"},{"Codice Stabilimento":"00003"},{"Note Intervento":"N1: ,N2:"},{"Data Apertura":"18\/03\/25-19:32"},{"Data Scadenza Presa In Carico":"19\/03\/25-09:32"},{"Data Presa In Carico":"non disp."},{"Data Scadenza Sla":"non disp."},{"Data Chiusura":"non disp."}]" "2025/03/15f475cc3b3b5aec77f4c3fa7d7a5f50" null "[]" 1 0 "8" null "47" null "1" null null null ] |
161 | 31.49 ms |
"COMMIT"
Parameters:
[] |
162 | 0.37 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:
[ "47" 1 ] |
163 | 2.32 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:
[
"07147281"
]
|
164 | 8.16 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:
[
"07147281"
]
|
165 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
166 | 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:
[ "07147281" null null null null null null null null null null null null null null "6b09a459d6d795ce9829a2204a47b11a" ] |
167 | 0.07 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 "19857" null ] |
168 | 8.03 ms |
"COMMIT"
Parameters:
[] |
169 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
170 | 0.18 ms |
UPDATE eposm_s_ticket SET client_id = ? WHERE id = ?
Parameters:
[ "19857" "23661" ] |
171 | 9.98 ms |
"COMMIT"
Parameters:
[] |
172 | 0.35 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:
[ "47" 0 ] |
173 | 0.25 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:
[ "47" 1 ] |
174 | 2.35 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:
[
"07147281"
]
|
175 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
176 | 0.12 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "349/8751298" "Telefono 1" "19857" ] |
177 | 0.10 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "non disp." "Telefono 2" "19857" ] |
178 | 0.10 ms |
INSERT INTO eposm_s_termid (code, client_id) VALUES (?, ?)
Parameters:
[ "07147281" "19857" ] |
179 | 0.12 ms |
UPDATE eposm_s_ticket SET number = ?, address = ?, zip = ?, id_city = ?, id_province = ?, json_report = ?, termid_id = ? WHERE id = ?
Parameters:
[ "I25011592" "Frazione Le Martinet,2" "11010" "1089" "4" "[{"ABI":"08587 - B.C.C. VALDOSTANA COOPERATIVE DE CREDIT VALDOTAINE S.C.R.L."},{"Anomalia":"N1: ,N2:"},{"Dettagli operazione":"Installazione on site"},{"Dettagli intervento":"Installazione on site"},{"Risorsa upgrade":"CORDLESS ETH CLESS"}]" "20145" "23661" ] |
180 | 0.08 ms |
UPDATE eposm_s_client SET nickname = ?, address = ?, zip = ?, id_city = ?, id_province = ? WHERE id = ?
Parameters:
[ "Bouteucca Da Manu" "Frazione Le Martinet,2" "11010" "1089" "4" "19857" ] |
181 | 0.13 ms |
UPDATE eposm_s_warehouse SET nickname = ? WHERE id = ?
Parameters:
[ "Cliente - Bouteucca Da Manu" "21595" ] |
182 | 10.26 ms |
"COMMIT"
Parameters:
[] |
183 | 0.21 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:
[
"586"
]
|
184 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
185 | 0.22 ms |
UPDATE eposm_s_ticket SET operation_tariff_amount_id = ?, uav_operation_tariff_amount_id = ? WHERE id = ?
Parameters:
[ "1024" "966" "23661" ] |
186 | 6.49 ms |
"COMMIT"
Parameters:
[] |
187 | 0.19 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"
]
|
188 | 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" "6" "7" "8" ] |
189 | 0.19 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.slug = ? LIMIT 1
Parameters:
[
"worldline-italia"
]
|
190 | 0.19 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.slug = ? LIMIT 1
Parameters:
[
"worldline-ccb"
]
|
191 | 14.57 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:
[
"C25011579"
]
|
192 | 0.20 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"
]
|
193 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
194 | 0.22 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-18 19:35:03" "2025-03-18 18:32:23" null null null null null null null null 0 null null "[{"Cliente":"Worldline"},{"Intervento":"C25011579"},{"Tipo di intervento":"Migrazione CCB"},{"Codice tipo intervento":"M03"},{"Societ\u00e0 che esegue l'intervento":"SIPOS Piemonte"},{"Tecnico assegnato all'intervento":"non disp."},{"Soluzione":"OMNIPOS PORTABLE PLUS"},{"Opzioni Attive":"Microcircuito + CUP"},{"Prodotto Presente":"non disp."},{"Canale":"08439 - BANCA DI CARAGLIO, DEL CUNEESE E DELLA RIVIERA DEI FIORI C.C. SCRL"},{"Canale Brand":"WL-CCB"},{"Cluster":"5"},{"Connessione 1":"151"},{"Connessione 2":"109Punto Vendita"},{"Tid":"07147310"},{"Mid":"058282740"},{"Insegna":"Orologi E Non Solo"},{"Citt\u00e0":"Torino"},{"CAP":"10126"},{"Provincia":"TO"},{"Indirizzo":"Via Nizza,104"},{"Telefono 1":"335\/7105090"},{"Telefono 2":"non disp."},{"Telefono Aggiuntivo":"non disp."},{"Codice Esercente":"3655865"},{"Codice Stabilimento":"00004"},{"Note Intervento":"N1: ,N2:"},{"Data Apertura":"18\/03\/25-19:32"},{"Data Scadenza Presa In Carico":"19\/03\/25-09:32"},{"Data Presa In Carico":"non disp."},{"Data Scadenza Sla":"non disp."},{"Data Chiusura":"non disp."},{"Pos Old":"non disp."},{"Sim Old":"non disp."},{"Pin Pad Old":"non disp."},{"Base Old":"non disp."}]" "2025/03/37a15a7e995fba22286331201bd4f0c7" null "[]" 1 0 "8" null "49" null "1" null null null ] |
195 | 8.53 ms |
"COMMIT"
Parameters:
[] |
196 | 0.32 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:
[ "49" 1 ] |
197 | 2.30 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:
[
"07147310"
]
|
198 | 8.09 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:
[
"07147310"
]
|
199 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
200 | 0.21 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:
[ "07147310" null null null null null null null null null null null null null null "775bccdbcf4ae976d131306435a79a88" ] |
201 | 0.20 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 "19858" null ] |
202 | 15.80 ms |
"COMMIT"
Parameters:
[] |
203 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
204 | 0.17 ms |
UPDATE eposm_s_ticket SET client_id = ? WHERE id = ?
Parameters:
[ "19858" "23662" ] |
205 | 7.20 ms |
"COMMIT"
Parameters:
[] |
206 | 0.26 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:
[ "49" 0 ] |
207 | 0.24 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:
[ "49" 1 ] |
208 | 2.24 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:
[
"07147310"
]
|
209 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
210 | 0.13 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "335/7105090" "Telefono 1" "19858" ] |
211 | 0.06 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "non disp." "Telefono 2" "19858" ] |
212 | 0.05 ms |
INSERT INTO eposm_s_termid (code, client_id) VALUES (?, ?)
Parameters:
[ "07147310" "19858" ] |
213 | 0.12 ms |
UPDATE eposm_s_ticket SET number = ?, address = ?, zip = ?, id_city = ?, id_province = ?, json_report = ?, termid_id = ? WHERE id = ?
Parameters:
[ "C25011579" "Via Nizza,104" "10126" "268" "94" "[{"ABI":"08439 - BANCA DI CARAGLIO, DEL CUNEESE E DELLA RIVIERA DEI FIORI C.C. SCRL"},{"Risorsa":"non disp."},{"Accessori":"non disp."},{"Matricole":"non disp."},{"Anomalia":"N1: ,N2:"},{"Dettagli operazione":"Migrazione CCB"},{"Dettagli intervento":"Migrazione CCB"},{"Risorsa upgrade":"OMNIPOS PORTABLE PLUS"}]" "20146" "23662" ] |
214 | 0.08 ms |
UPDATE eposm_s_client SET nickname = ?, address = ?, zip = ?, id_city = ?, id_province = ? WHERE id = ?
Parameters:
[ "Orologi E Non Solo" "Via Nizza,104" "10126" "268" "94" "19858" ] |
215 | 0.06 ms |
UPDATE eposm_s_warehouse SET nickname = ? WHERE id = ?
Parameters:
[ "Cliente - Orologi E Non Solo" "21596" ] |
216 | 9.81 ms |
"COMMIT"
Parameters:
[] |
217 | 0.19 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:
[
"559"
]
|
218 | 0.20 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:
[
"569"
]
|
219 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
220 | 0.21 ms |
UPDATE eposm_s_ticket SET operation_tariff_amount_id = ?, uav_operation_tariff_amount_id = ? WHERE id = ?
Parameters:
[ "965" "975" "23662" ] |
221 | 6.26 ms |
"COMMIT"
Parameters:
[] |
222 | 0.21 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"
]
|
223 | 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" "6" "7" "8" ] |
224 | 0.19 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.slug = ? LIMIT 1
Parameters:
[
"worldline-italia"
]
|
225 | 0.15 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.slug = ? LIMIT 1
Parameters:
[
"worldline-ccb"
]
|
226 | 14.84 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:
[
"I25011577"
]
|
227 | 0.15 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"
]
|
228 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
229 | 0.29 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-18 19:35:03" "2025-03-18 18:32:23" null null null null null null null null 0 null null "[{"Cliente":"Worldline"},{"Intervento":"I25011577"},{"Tipo di intervento":"Installazione on site"},{"Codice tipo intervento":"INO"},{"Societ\u00e0 che esegue l'intervento":"SIPOS Piemonte"},{"Tecnico assegnato all'intervento":"non disp."},{"Soluzione":"DESKTOP ETH CLESS"},{"Opzioni Attive":"Microcircuito + CUP"},{"Canale":"08587 - B.C.C. VALDOSTANA COOPERATIVE DE CREDIT VALDOTAINE S.C.R.L."},{"Canale Brand":"WL-CCB"},{"Connessione 1":"150"},{"Connessione 2":"151Punto Vendita"},{"Tid":"07147309"},{"Mid":"058850389"},{"Insegna":"Equipe Testamatta Snc"},{"Citt\u00e0":"Aosta"},{"CAP":"11100"},{"Provincia":"AO"},{"Indirizzo":"Via Monte Emilius,22"},{"Telefono 1":"329\/6397933"},{"Telefono 2":"non disp."},{"Telefono Aggiuntivo":"non disp."},{"Codice Esercente":"3414578"},{"Codice Stabilimento":"00001"},{"Note Intervento":"N1: ,N2:"},{"Data Apertura":"18\/03\/25-19:32"},{"Data Scadenza Presa In Carico":"19\/03\/25-09:32"},{"Data Presa In Carico":"non disp."},{"Data Scadenza Sla":"non disp."},{"Data Chiusura":"non disp."}]" "2025/03/19d0b1638d56ddf1be918cacc8db5eb5" null "[]" 1 0 "8" null "47" null "1" null null null ] |
230 | 5.90 ms |
"COMMIT"
Parameters:
[] |
231 | 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:
[ "47" 1 ] |
232 | 2.33 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:
[
"07147309"
]
|
233 | 8.06 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:
[
"07147309"
]
|
234 | 0.09 ms |
"START TRANSACTION"
Parameters:
[] |
235 | 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:
[ "07147309" null null null null null null null null null null null null null null "34a5f53fc5be73358d45c59869365266" ] |
236 | 0.12 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 "19859" null ] |
237 | 8.98 ms |
"COMMIT"
Parameters:
[] |
238 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
239 | 0.18 ms |
UPDATE eposm_s_ticket SET client_id = ? WHERE id = ?
Parameters:
[ "19859" "23663" ] |
240 | 7.03 ms |
"COMMIT"
Parameters:
[] |
241 | 0.25 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:
[ "47" 0 ] |
242 | 0.16 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:
[ "47" 1 ] |
243 | 2.28 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:
[
"07147309"
]
|
244 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
245 | 0.15 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "329/6397933" "Telefono 1" "19859" ] |
246 | 0.10 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "non disp." "Telefono 2" "19859" ] |
247 | 0.10 ms |
INSERT INTO eposm_s_termid (code, client_id) VALUES (?, ?)
Parameters:
[ "07147309" "19859" ] |
248 | 0.12 ms |
UPDATE eposm_s_ticket SET number = ?, address = ?, zip = ?, id_city = ?, id_province = ?, json_report = ?, termid_id = ? WHERE id = ?
Parameters:
[ "I25011577" "Via Monte Emilius,22" "11100" "1035" "4" "[{"ABI":"08587 - B.C.C. VALDOSTANA COOPERATIVE DE CREDIT VALDOTAINE S.C.R.L."},{"Anomalia":"N1: ,N2:"},{"Dettagli operazione":"Installazione on site"},{"Dettagli intervento":"Installazione on site"},{"Risorsa upgrade":"DESKTOP ETH CLESS"}]" "20147" "23663" ] |
249 | 0.08 ms |
UPDATE eposm_s_client SET nickname = ?, address = ?, zip = ?, id_city = ?, id_province = ? WHERE id = ?
Parameters:
[ "Equipe Testamatta Snc" "Via Monte Emilius,22" "11100" "1035" "4" "19859" ] |
250 | 0.06 ms |
UPDATE eposm_s_warehouse SET nickname = ? WHERE id = ?
Parameters:
[ "Cliente - Equipe Testamatta Snc" "21597" ] |
251 | 7.93 ms |
"COMMIT"
Parameters:
[] |
252 | 0.09 ms |
"START TRANSACTION"
Parameters:
[] |
253 | 0.20 ms |
UPDATE eposm_s_ticket SET operation_tariff_amount_id = ?, uav_operation_tariff_amount_id = ? WHERE id = ?
Parameters:
[ "1024" "966" "23663" ] |
254 | 9.56 ms |
"COMMIT"
Parameters:
[] |
255 | 0.18 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"
]
|
256 | 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" "6" "7" "8" ] |
257 | 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, t0.is_active AS is_active_8 FROM eposm_s_supplier t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"worldline-italia"
]
|
258 | 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.slug = ? LIMIT 1
Parameters:
[
"worldline-ccb"
]
|
259 | 14.47 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:
[
"I25011575"
]
|
260 | 0.19 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"
]
|
261 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
262 | 0.27 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-18 19:35:03" "2025-03-18 18:32:23" null null null null null null null null 0 null null "[{"Cliente":"Worldline"},{"Intervento":"I25011575"},{"Tipo di intervento":"Installazione on site"},{"Codice tipo intervento":"INO"},{"Societ\u00e0 che esegue l'intervento":"SIPOS Piemonte"},{"Tecnico assegnato all'intervento":"non disp."},{"Soluzione":"PAX A920C"},{"Opzioni Attive":"Microcircuito + CUP"},{"Canale":"08487 - BANCA DI CREDITO COOPERATIVO DI CHERASCO SCRL"},{"Canale Brand":"WL-CCB"},{"OTP":"43d7a15a8e34d5fc6eb5d4a74e6b8c78"},{"MarketPlace ID":"WOL07147240"},{"User":"vincenzo.parizia@gmail.com"},{"Connessione 1":"109"},{"Connessione 2":"151Punto Vendita"},{"Tid":"07147240"},{"Mid":"058234857"},{"Insegna":"Farmacia Parizia"},{"Citt\u00e0":"Moncalieri"},{"CAP":"10024"},{"Provincia":"TO"},{"Indirizzo":"Piazza Failla,6c"},{"Telefono 1":"338\/4008294"},{"Telefono 2":"non disp."},{"Telefono Aggiuntivo":"non disp."},{"Codice Esercente":"5695948"},{"Codice Stabilimento":"00003"},{"Note Intervento":"N1: ,N2:"},{"Data Apertura":"18\/03\/25-19:32"},{"Data Scadenza Presa In Carico":"19\/03\/25-09:32"},{"Data Presa In Carico":"non disp."},{"Data Scadenza Sla":"non disp."},{"Data Chiusura":"non disp."}]" "2025/03/cf928503c1dc97d02d71c10da24c5fc4" null "[]" 1 0 "8" null "47" null "1" null null null ] |
263 | 9.80 ms |
"COMMIT"
Parameters:
[] |
264 | 0.37 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:
[ "47" 1 ] |
265 | 2.38 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:
[
"07147240"
]
|
266 | 8.20 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:
[
"07147240"
]
|
267 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
268 | 0.22 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:
[ "07147240" null null null null null null null null null null null null null null "403151da6f7ac1559a2fb6e9c50a55a0" ] |
269 | 0.18 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 "19860" null ] |
270 | 14.51 ms |
"COMMIT"
Parameters:
[] |
271 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
272 | 0.22 ms |
UPDATE eposm_s_ticket SET client_id = ? WHERE id = ?
Parameters:
[ "19860" "23664" ] |
273 | 6.97 ms |
"COMMIT"
Parameters:
[] |
274 | 0.32 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:
[ "47" 0 ] |
275 | 0.24 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:
[ "47" 1 ] |
276 | 2.33 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:
[
"07147240"
]
|
277 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
278 | 0.13 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "338/4008294" "Telefono 1" "19860" ] |
279 | 0.10 ms |
INSERT INTO eposm_s_client_phone (number, name, client_id) VALUES (?, ?, ?)
Parameters:
[ "non disp." "Telefono 2" "19860" ] |
280 | 0.11 ms |
INSERT INTO eposm_s_termid (code, client_id) VALUES (?, ?)
Parameters:
[ "07147240" "19860" ] |
281 | 0.13 ms |
UPDATE eposm_s_ticket SET number = ?, address = ?, zip = ?, id_city = ?, id_province = ?, json_report = ?, termid_id = ? WHERE id = ?
Parameters:
[ "I25011575" "Piazza Failla,6c" "10024" "153" "94" "[{"ABI":"08487 - BANCA DI CREDITO COOPERATIVO DI CHERASCO SCRL"},{"Anomalia":"N1: ,N2:"},{"Dettagli operazione":"Installazione on site"},{"Dettagli intervento":"Installazione on site"},{"Risorsa upgrade":"PAX A920C"}]" "20148" "23664" ] |
282 | 0.13 ms |
UPDATE eposm_s_client SET nickname = ?, address = ?, zip = ?, id_city = ?, id_province = ? WHERE id = ?
Parameters:
[ "Farmacia Parizia" "Piazza Failla,6c" "10024" "153" "94" "19860" ] |
283 | 0.08 ms |
UPDATE eposm_s_warehouse SET nickname = ? WHERE id = ?
Parameters:
[ "Cliente - Farmacia Parizia" "21598" ] |
284 | 10.30 ms |
"COMMIT"
Parameters:
[] |
285 | 0.20 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:
[
"583"
]
|
286 | 0.14 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:
[
"566"
]
|
287 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
288 | 0.11 ms |
UPDATE eposm_s_ticket SET operation_tariff_amount_id = ?, uav_operation_tariff_amount_id = ? WHERE id = ?
Parameters:
[ "1015" "972" "23664" ] |
289 | 6.34 ms |
"COMMIT"
Parameters:
[] |
290 | 0.17 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"
]
|
291 | 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:
[ "noreply@worldlineitalia.it" "1" "4" "5" "6" "7" "8" ] |
292 | 0.20 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:
[
"36"
]
|
293 | 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" "6" "7" "8" ] |
294 | 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" "6" "7" "8" ] |
295 | 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" "6" "7" "8" ] |
296 | 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" "6" "7" "8" ] |
297 | 0.14 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" "6" "7" "8" ] |
298 | 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" "6" "7" "8" ] |
299 | 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@worldlineitalia.it" "1" "4" "5" "6" "7" "8" ] |
300 | 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" "6" "7" "8" ] |
301 | 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:
[
"3"
]
|
302 | 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:
[
"3"
]
|
303 | 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"
]
|
304 | 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"
]
|
305 | 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:
[
"7"
]
|
306 | 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"
]
|
307 | 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:
[
"25"
]
|
308 | 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:
[
"33"
]
|
309 | 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:
[
"1"
]
|
310 | 0.08 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:
[
"1"
]
|
311 | 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:
[
"1"
]
|
312 | 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:
[
"2"
]
|
313 | 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"
]
|
314 | 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:
[
"4"
]
|
315 | 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"
]
|
316 | 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:
[
"34"
]
|
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. |