https://eposmanager.software/scrivania/ticket/lista?city=&client=&datetimeExpiration=&datetimeStart=&filter_tab=assigned&number=&operation=&province=&sortField=&sortOrder=&supplier=&tariff=&technician=terra&termid=&waybill= Return to referer URL

Query Metrics

78 Database Queries
30 Different statements
143.04 ms Query time
0 Invalid entities

Queries

Group similar statements

master connection

# Time Info
1 0.35 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 = ? LIMIT 1
Parameters:
[
  "23"
]
2 2.78 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_ WHERE e0_.name LIKE ? ORDER BY e0_.name ASC LIMIT 10
Parameters:
[
  "%"
]
3 0.16 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 = ? LIMIT 1
Parameters:
[
  "23"
]

slave connection

# Time Info
1 0.20 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.role AS role_4, t0.one_time_code AS one_time_code_5, t0.expiration_one_time_code AS expiration_one_time_code_6, t0.is_active AS is_active_7, t0.is_company_active AS is_company_active_8, t0.is_admin_active AS is_admin_active_9, t0.exclude_auto_assign AS exclude_auto_assign_10, t0.is_economic_visible AS is_economic_visible_11, t12.id AS id_13, t12.name AS name_14, t12.surname AS surname_15, t12.phone AS phone_16, t12.fiscal_code AS fiscal_code_17, t12.vat AS vat_18, t12.phone_personal AS phone_personal_19, t12.email_personal AS email_personal_20, t12.address AS address_21, t12.civic AS civic_22, t12.zip AS zip_23, t12.id_city AS id_city_24, t12.user_id AS user_id_25, t0.account_type_id AS account_type_id_26 FROM eposm_s_user t0 LEFT JOIN eposm_s_user_profile t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  "4"
]
2 0.23 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3, t0.category_id AS category_id_4 FROM eposm_s_account_type t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
3 0.27 ms
SELECT t0.id AS id_1, t0.rw AS rw_2, t0.account_type_id AS account_type_id_3, t0.permission_id AS permission_id_4 FROM eposm_s_join_table_account_type_permission t0 WHERE t0.account_type_id = ?
Parameters:
[
  "3"
]
4 0.22 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
5 0.12 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
6 0.08 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
7 0.08 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
8 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "13"
]
9 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "15"
]
10 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "16"
]
11 0.08 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "17"
]
12 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "18"
]
13 0.05 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
14 0.05 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "11"
]
15 0.05 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM eposm_s_permission t0 WHERE t0.id = ?
Parameters:
[
  "12"
]
16 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_backoffice_manage"
]
17 0.17 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.amount_regenerate AS amount_regenerate_3, e0_.id_supplier AS id_supplier_4, e0_.operation_mapping AS operation_mapping_5, e0_.amount_ticket_extra_hour AS amount_ticket_extra_hour_6 FROM eposm_s_supplier e0_ ORDER BY e0_.name ASC
Parameters:
[]
18 0.17 ms
SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.value AS value_2, e0_.is_maintenance AS is_maintenance_3, e0_.is_uav AS is_uav_4 FROM eposm_s_operation_group e0_ ORDER BY e0_.value ASC
Parameters:
[]
19 0.13 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3 FROM eposm_s_account_category t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
20 1.56 ms
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e0_.system_error = 1
Parameters:
[]
21 1.71 ms
SELECT DISTINCT e0_.id AS id_0, e0_.datetime_expiration AS datetime_expiration_1 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e0_.system_error = 1 ORDER BY e0_.datetime_expiration ASC LIMIT 100
Parameters:
[]
22 1.32 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_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e0_.system_error = 1 ORDER BY e0_.datetime_expiration ASC
Parameters:
[]
23 0.35 ms
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0
Parameters:
[
  "to_assign"
]
24 0.28 ms
SELECT DISTINCT e0_.id AS id_0, e0_.datetime_expiration AS datetime_expiration_1 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 ORDER BY e0_.datetime_expiration ASC LIMIT 100
Parameters:
[
  "to_assign"
]
25 0.51 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_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.datetime_expiration ASC
Parameters:
[
  "to_assign"
  "10381"
  "10271"
  "10309"
  "10319"
  "10320"
  "10392"
  "10321"
  "10393"
  "8256"
  "1628"
  "8368"
  "9507"
  "9665"
  "10347"
  "10284"
  "10325"
  "10365"
  "10376"
  "10368"
  "10190"
  "10373"
  "10372"
  "10382"
  "10383"
  "10384"
  "10385"
  "10386"
  "10387"
]
26 0.42 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_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 ORDER BY e0_.datetime_expiration ASC
Parameters:
[
  "to_assign"
]
27 1.27 ms
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?)
Parameters:
[
  "assigned"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
28 1.27 ms
SELECT DISTINCT e0_.id AS id_0, e0_.datetime_expiration AS datetime_expiration_1 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC LIMIT 100
Parameters:
[
  "assigned"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
29 0.49 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_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.datetime_expiration ASC
Parameters:
[
  "assigned"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
  "10310"
  "10311"
  "10313"
  "8061"
  "8491"
  "9109"
  "9863"
  "9864"
  "7569"
  "8054"
  "9150"
  "9151"
  "9454"
  "10203"
  "9812"
  "10184"
  "10185"
]
30 2.07 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_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC
Parameters:
[
  "assigned"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
31 0.68 ms
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?)
Parameters:
[
  "taken_charge"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
32 0.65 ms
SELECT DISTINCT e0_.id AS id_0, e0_.datetime_expiration AS datetime_expiration_1 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC LIMIT 100
Parameters:
[
  "taken_charge"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
33 0.91 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_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC
Parameters:
[
  "taken_charge"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
34 0.27 ms
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?)
Parameters:
[
  "suspension_request"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
35 0.27 ms
SELECT DISTINCT e0_.id AS id_0, e0_.datetime_expiration AS datetime_expiration_1 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC LIMIT 100
Parameters:
[
  "suspension_request"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
36 0.28 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_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC
Parameters:
[
  "suspension_request"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
37 0.53 ms
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?)
Parameters:
[
  "suspended"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
38 0.55 ms
SELECT DISTINCT e0_.id AS id_0, e0_.datetime_expiration AS datetime_expiration_1 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC LIMIT 100
Parameters:
[
  "suspended"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
39 0.56 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_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC
Parameters:
[
  "suspended"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
40 0.37 ms
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?)
Parameters:
[
  "closed"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
41 0.36 ms
SELECT DISTINCT e0_.id AS id_0, e0_.datetime_expiration AS datetime_expiration_1 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC LIMIT 100
Parameters:
[
  "closed"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
42 0.43 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_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC
Parameters:
[
  "closed"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
43 0.35 ms
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?)
Parameters:
[
  "closed_portal"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
44 0.36 ms
SELECT DISTINCT e0_.id AS id_0, e0_.datetime_expiration AS datetime_expiration_1 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC LIMIT 100
Parameters:
[
  "closed_portal"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
45 0.54 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_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC
Parameters:
[
  "closed_portal"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
46 0.21 ms
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?)
Parameters:
[
  "canceled"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
47 0.22 ms
SELECT DISTINCT e0_.id AS id_0, e0_.datetime_expiration AS datetime_expiration_1 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC LIMIT 100
Parameters:
[
  "canceled"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
48 0.22 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_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC
Parameters:
[
  "canceled"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
49 0.25 ms
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?)
Parameters:
[
  "wrong"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
50 0.24 ms
SELECT DISTINCT e0_.id AS id_0, e0_.datetime_expiration AS datetime_expiration_1 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC LIMIT 100
Parameters:
[
  "wrong"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
51 0.24 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_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_supplier e2_ ON e0_.supplier_id = e2_.id LEFT JOIN eposm_s_client e3_ ON e0_.client_id = e3_.id LEFT JOIN eposm_s_termid e4_ ON e0_.termid_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_operation_group e6_ ON e5_.group_id = e6_.id LEFT JOIN eposm_s_user e7_ ON e0_.technician_id = e7_.id LEFT JOIN eposm_s_user_profile e8_ ON e7_.id = e8_.user_id LEFT JOIN eposm_s_operation_tariff_amount e9_ ON e0_.operation_tariff_amount_id = e9_.id WHERE e1_.slug = ? AND e0_.system_error = 0 AND (e8_.name LIKE ? OR e8_.surname LIKE ? OR CONCAT(e8_.name, ' ', e8_.surname) LIKE ? OR CONCAT(e8_.surname, ' ', e8_.name) LIKE ?) ORDER BY e0_.datetime_expiration ASC
Parameters:
[
  "wrong"
  "%terra%"
  "%terra%"
  "%terra%"
  "%terra%"
]
52 0.18 ms
SELECT e0_.id AS id_0, e0_.nickname AS nickname_1, e0_.address AS address_2, e0_.is_movable AS is_movable_3, e0_.is_headquarter AS is_headquarter_4, e0_.is_active AS is_active_5, e0_.client_id AS client_id_6, e0_.destination_id AS destination_id_7 FROM eposm_s_warehouse e0_ WHERE e0_.is_headquarter = 1 AND e0_.client_id IS NULL AND e0_.destination_id IS NULL
Parameters:
[]
53 0.31 ms
SELECT e0_.id AS id_0, e0_.email AS email_1, e0_.password AS password_2, e0_.role AS role_3, e0_.one_time_code AS one_time_code_4, e0_.expiration_one_time_code AS expiration_one_time_code_5, e0_.is_active AS is_active_6, e0_.is_company_active AS is_company_active_7, e0_.is_admin_active AS is_admin_active_8, e0_.exclude_auto_assign AS exclude_auto_assign_9, e0_.is_economic_visible AS is_economic_visible_10, e0_.account_type_id AS account_type_id_11 FROM eposm_s_user e0_ LEFT JOIN eposm_s_account_type e1_ ON e0_.account_type_id = e1_.id LEFT JOIN eposm_s_user_profile e2_ ON e0_.id = e2_.user_id LEFT JOIN eposm_s_account_category e3_ ON e1_.category_id = e3_.id WHERE e0_.role <> ? AND (e3_.slug = ? OR e3_.slug = ?) AND e0_.is_company_active = 1 AND e0_.id IN (?) ORDER BY e2_.surname ASC, e2_.name ASC
Parameters:
[
  "ROLE_ADMIN"
  "tech-internal"
  "tech-external"
  "22"
]
54 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.phone AS phone_4, t0.fiscal_code AS fiscal_code_5, t0.vat AS vat_6, t0.phone_personal AS phone_personal_7, t0.email_personal AS email_personal_8, t0.address AS address_9, t0.civic AS civic_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.user_id AS user_id_13 FROM eposm_s_user_profile t0 WHERE t0.user_id = ?
Parameters:
[
  "22"
]
55 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:
[
  "assigned"
]
56 0.19 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.datetime_import AS datetime_import_3, t0.datetime_start AS datetime_start_4, t0.datetime_expiration AS datetime_expiration_5, t0.datetime_end AS datetime_end_6, t0.address AS address_7, t0.locality AS locality_8, t0.zip AS zip_9, t0.id_city AS id_city_10, t0.id_province AS id_province_11, t0.other_city AS other_city_12, t0.system_error AS system_error_13, t0.system_error_slug AS system_error_slug_14, t0.system_error_details AS system_error_details_15, t0.json AS json_16, t0.directory_path AS directory_path_17, t0.waybill AS waybill_18, t0.json_report AS json_report_19, t0.billable AS billable_20, t0.closed_on_portal AS closed_on_portal_21, t0.supplier_id AS supplier_id_22, t0.client_id AS client_id_23, t0.operation_id AS operation_id_24, t0.technician_id AS technician_id_25, t0.status_id AS status_id_26, t0.termid_id AS termid_id_27, t0.operation_tariff_amount_id AS operation_tariff_amount_id_28, t0.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_29 FROM eposm_s_ticket t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "7569"
]
57 0.22 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.datetime_billing AS datetime_billing_3, t0.referent AS referent_4, t0.motivation AS motivation_5, t0.phone AS phone_6, t0.photo_path AS photo_path_7, t0.amount AS amount_8, t0.amount_technician AS amount_technician_9, t0.sla_outbound_percentage AS sla_outbound_percentage_10, t0.billable AS billable_11, t12.id AS id_13, t12.datetime_from AS datetime_from_14, t12.datetime_to AS datetime_to_15, t12.is_approved AS is_approved_16, t12.is_managed AS is_managed_17, t12.is_unlocked AS is_unlocked_18, t12.unlock_causal AS unlock_causal_19, t12.refuse_motivation AS refuse_motivation_20, t12.intervention_id AS intervention_id_21, t12.ticket_id AS ticket_id_22, t0.ticket_id AS ticket_id_23, t0.technician_id AS technician_id_24, t0.operator_id AS operator_id_25, t0.outcome_id AS outcome_id_26, t0.outcome_type_id AS outcome_type_id_27, t0.warehouse_id AS warehouse_id_28 FROM eposm_s_intervention t0 LEFT JOIN eposm_s_ticket_suspension t12 ON t12.intervention_id = t0.id WHERE t0.ticket_id = ?
Parameters:
[
  "7569"
]
58 0.12 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.datetime_import AS datetime_import_3, t0.datetime_start AS datetime_start_4, t0.datetime_expiration AS datetime_expiration_5, t0.datetime_end AS datetime_end_6, t0.address AS address_7, t0.locality AS locality_8, t0.zip AS zip_9, t0.id_city AS id_city_10, t0.id_province AS id_province_11, t0.other_city AS other_city_12, t0.system_error AS system_error_13, t0.system_error_slug AS system_error_slug_14, t0.system_error_details AS system_error_details_15, t0.json AS json_16, t0.directory_path AS directory_path_17, t0.waybill AS waybill_18, t0.json_report AS json_report_19, t0.billable AS billable_20, t0.closed_on_portal AS closed_on_portal_21, t0.supplier_id AS supplier_id_22, t0.client_id AS client_id_23, t0.operation_id AS operation_id_24, t0.technician_id AS technician_id_25, t0.status_id AS status_id_26, t0.termid_id AS termid_id_27, t0.operation_tariff_amount_id AS operation_tariff_amount_id_28, t0.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_29 FROM eposm_s_ticket t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "9150"
]
59 0.12 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.datetime_billing AS datetime_billing_3, t0.referent AS referent_4, t0.motivation AS motivation_5, t0.phone AS phone_6, t0.photo_path AS photo_path_7, t0.amount AS amount_8, t0.amount_technician AS amount_technician_9, t0.sla_outbound_percentage AS sla_outbound_percentage_10, t0.billable AS billable_11, t12.id AS id_13, t12.datetime_from AS datetime_from_14, t12.datetime_to AS datetime_to_15, t12.is_approved AS is_approved_16, t12.is_managed AS is_managed_17, t12.is_unlocked AS is_unlocked_18, t12.unlock_causal AS unlock_causal_19, t12.refuse_motivation AS refuse_motivation_20, t12.intervention_id AS intervention_id_21, t12.ticket_id AS ticket_id_22, t0.ticket_id AS ticket_id_23, t0.technician_id AS technician_id_24, t0.operator_id AS operator_id_25, t0.outcome_id AS outcome_id_26, t0.outcome_type_id AS outcome_type_id_27, t0.warehouse_id AS warehouse_id_28 FROM eposm_s_intervention t0 LEFT JOIN eposm_s_ticket_suspension t12 ON t12.intervention_id = t0.id WHERE t0.ticket_id = ?
Parameters:
[
  "9150"
]
60 0.09 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.datetime_import AS datetime_import_3, t0.datetime_start AS datetime_start_4, t0.datetime_expiration AS datetime_expiration_5, t0.datetime_end AS datetime_end_6, t0.address AS address_7, t0.locality AS locality_8, t0.zip AS zip_9, t0.id_city AS id_city_10, t0.id_province AS id_province_11, t0.other_city AS other_city_12, t0.system_error AS system_error_13, t0.system_error_slug AS system_error_slug_14, t0.system_error_details AS system_error_details_15, t0.json AS json_16, t0.directory_path AS directory_path_17, t0.waybill AS waybill_18, t0.json_report AS json_report_19, t0.billable AS billable_20, t0.closed_on_portal AS closed_on_portal_21, t0.supplier_id AS supplier_id_22, t0.client_id AS client_id_23, t0.operation_id AS operation_id_24, t0.technician_id AS technician_id_25, t0.status_id AS status_id_26, t0.termid_id AS termid_id_27, t0.operation_tariff_amount_id AS operation_tariff_amount_id_28, t0.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_29 FROM eposm_s_ticket t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "9151"
]
61 0.10 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.datetime_billing AS datetime_billing_3, t0.referent AS referent_4, t0.motivation AS motivation_5, t0.phone AS phone_6, t0.photo_path AS photo_path_7, t0.amount AS amount_8, t0.amount_technician AS amount_technician_9, t0.sla_outbound_percentage AS sla_outbound_percentage_10, t0.billable AS billable_11, t12.id AS id_13, t12.datetime_from AS datetime_from_14, t12.datetime_to AS datetime_to_15, t12.is_approved AS is_approved_16, t12.is_managed AS is_managed_17, t12.is_unlocked AS is_unlocked_18, t12.unlock_causal AS unlock_causal_19, t12.refuse_motivation AS refuse_motivation_20, t12.intervention_id AS intervention_id_21, t12.ticket_id AS ticket_id_22, t0.ticket_id AS ticket_id_23, t0.technician_id AS technician_id_24, t0.operator_id AS operator_id_25, t0.outcome_id AS outcome_id_26, t0.outcome_type_id AS outcome_type_id_27, t0.warehouse_id AS warehouse_id_28 FROM eposm_s_intervention t0 LEFT JOIN eposm_s_ticket_suspension t12 ON t12.intervention_id = t0.id WHERE t0.ticket_id = ?
Parameters:
[
  "9151"
]
62 0.09 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.datetime_import AS datetime_import_3, t0.datetime_start AS datetime_start_4, t0.datetime_expiration AS datetime_expiration_5, t0.datetime_end AS datetime_end_6, t0.address AS address_7, t0.locality AS locality_8, t0.zip AS zip_9, t0.id_city AS id_city_10, t0.id_province AS id_province_11, t0.other_city AS other_city_12, t0.system_error AS system_error_13, t0.system_error_slug AS system_error_slug_14, t0.system_error_details AS system_error_details_15, t0.json AS json_16, t0.directory_path AS directory_path_17, t0.waybill AS waybill_18, t0.json_report AS json_report_19, t0.billable AS billable_20, t0.closed_on_portal AS closed_on_portal_21, t0.supplier_id AS supplier_id_22, t0.client_id AS client_id_23, t0.operation_id AS operation_id_24, t0.technician_id AS technician_id_25, t0.status_id AS status_id_26, t0.termid_id AS termid_id_27, t0.operation_tariff_amount_id AS operation_tariff_amount_id_28, t0.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_29 FROM eposm_s_ticket t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "9454"
]
63 0.10 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.datetime_billing AS datetime_billing_3, t0.referent AS referent_4, t0.motivation AS motivation_5, t0.phone AS phone_6, t0.photo_path AS photo_path_7, t0.amount AS amount_8, t0.amount_technician AS amount_technician_9, t0.sla_outbound_percentage AS sla_outbound_percentage_10, t0.billable AS billable_11, t12.id AS id_13, t12.datetime_from AS datetime_from_14, t12.datetime_to AS datetime_to_15, t12.is_approved AS is_approved_16, t12.is_managed AS is_managed_17, t12.is_unlocked AS is_unlocked_18, t12.unlock_causal AS unlock_causal_19, t12.refuse_motivation AS refuse_motivation_20, t12.intervention_id AS intervention_id_21, t12.ticket_id AS ticket_id_22, t0.ticket_id AS ticket_id_23, t0.technician_id AS technician_id_24, t0.operator_id AS operator_id_25, t0.outcome_id AS outcome_id_26, t0.outcome_type_id AS outcome_type_id_27, t0.warehouse_id AS warehouse_id_28 FROM eposm_s_intervention t0 LEFT JOIN eposm_s_ticket_suspension t12 ON t12.intervention_id = t0.id WHERE t0.ticket_id = ?
Parameters:
[
  "9454"
]
64 0.09 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.datetime_import AS datetime_import_3, t0.datetime_start AS datetime_start_4, t0.datetime_expiration AS datetime_expiration_5, t0.datetime_end AS datetime_end_6, t0.address AS address_7, t0.locality AS locality_8, t0.zip AS zip_9, t0.id_city AS id_city_10, t0.id_province AS id_province_11, t0.other_city AS other_city_12, t0.system_error AS system_error_13, t0.system_error_slug AS system_error_slug_14, t0.system_error_details AS system_error_details_15, t0.json AS json_16, t0.directory_path AS directory_path_17, t0.waybill AS waybill_18, t0.json_report AS json_report_19, t0.billable AS billable_20, t0.closed_on_portal AS closed_on_portal_21, t0.supplier_id AS supplier_id_22, t0.client_id AS client_id_23, t0.operation_id AS operation_id_24, t0.technician_id AS technician_id_25, t0.status_id AS status_id_26, t0.termid_id AS termid_id_27, t0.operation_tariff_amount_id AS operation_tariff_amount_id_28, t0.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_29 FROM eposm_s_ticket t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "9812"
]
65 0.11 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.datetime_billing AS datetime_billing_3, t0.referent AS referent_4, t0.motivation AS motivation_5, t0.phone AS phone_6, t0.photo_path AS photo_path_7, t0.amount AS amount_8, t0.amount_technician AS amount_technician_9, t0.sla_outbound_percentage AS sla_outbound_percentage_10, t0.billable AS billable_11, t12.id AS id_13, t12.datetime_from AS datetime_from_14, t12.datetime_to AS datetime_to_15, t12.is_approved AS is_approved_16, t12.is_managed AS is_managed_17, t12.is_unlocked AS is_unlocked_18, t12.unlock_causal AS unlock_causal_19, t12.refuse_motivation AS refuse_motivation_20, t12.intervention_id AS intervention_id_21, t12.ticket_id AS ticket_id_22, t0.ticket_id AS ticket_id_23, t0.technician_id AS technician_id_24, t0.operator_id AS operator_id_25, t0.outcome_id AS outcome_id_26, t0.outcome_type_id AS outcome_type_id_27, t0.warehouse_id AS warehouse_id_28 FROM eposm_s_intervention t0 LEFT JOIN eposm_s_ticket_suspension t12 ON t12.intervention_id = t0.id WHERE t0.ticket_id = ?
Parameters:
[
  "9812"
]
66 0.15 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.datetime_import AS datetime_import_3, t0.datetime_start AS datetime_start_4, t0.datetime_expiration AS datetime_expiration_5, t0.datetime_end AS datetime_end_6, t0.address AS address_7, t0.locality AS locality_8, t0.zip AS zip_9, t0.id_city AS id_city_10, t0.id_province AS id_province_11, t0.other_city AS other_city_12, t0.system_error AS system_error_13, t0.system_error_slug AS system_error_slug_14, t0.system_error_details AS system_error_details_15, t0.json AS json_16, t0.directory_path AS directory_path_17, t0.waybill AS waybill_18, t0.json_report AS json_report_19, t0.billable AS billable_20, t0.closed_on_portal AS closed_on_portal_21, t0.supplier_id AS supplier_id_22, t0.client_id AS client_id_23, t0.operation_id AS operation_id_24, t0.technician_id AS technician_id_25, t0.status_id AS status_id_26, t0.termid_id AS termid_id_27, t0.operation_tariff_amount_id AS operation_tariff_amount_id_28, t0.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_29 FROM eposm_s_ticket t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "10184"
]
67 0.16 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.datetime_billing AS datetime_billing_3, t0.referent AS referent_4, t0.motivation AS motivation_5, t0.phone AS phone_6, t0.photo_path AS photo_path_7, t0.amount AS amount_8, t0.amount_technician AS amount_technician_9, t0.sla_outbound_percentage AS sla_outbound_percentage_10, t0.billable AS billable_11, t12.id AS id_13, t12.datetime_from AS datetime_from_14, t12.datetime_to AS datetime_to_15, t12.is_approved AS is_approved_16, t12.is_managed AS is_managed_17, t12.is_unlocked AS is_unlocked_18, t12.unlock_causal AS unlock_causal_19, t12.refuse_motivation AS refuse_motivation_20, t12.intervention_id AS intervention_id_21, t12.ticket_id AS ticket_id_22, t0.ticket_id AS ticket_id_23, t0.technician_id AS technician_id_24, t0.operator_id AS operator_id_25, t0.outcome_id AS outcome_id_26, t0.outcome_type_id AS outcome_type_id_27, t0.warehouse_id AS warehouse_id_28 FROM eposm_s_intervention t0 LEFT JOIN eposm_s_ticket_suspension t12 ON t12.intervention_id = t0.id WHERE t0.ticket_id = ?
Parameters:
[
  "10184"
]
68 0.07 ms
"START TRANSACTION"
Parameters:
[]
69 0.63 ms
UPDATE eposm_s_ticket SET technician_id = ? WHERE id = ?
Parameters:
[
  "22"
  "7569"
]
70 0.07 ms
UPDATE eposm_s_ticket SET technician_id = ? WHERE id = ?
Parameters:
[
  "22"
  "9150"
]
71 0.06 ms
UPDATE eposm_s_ticket SET technician_id = ? WHERE id = ?
Parameters:
[
  "22"
  "9151"
]
72 0.06 ms
UPDATE eposm_s_ticket SET technician_id = ? WHERE id = ?
Parameters:
[
  "22"
  "9454"
]
73 0.06 ms
UPDATE eposm_s_ticket SET technician_id = ? WHERE id = ?
Parameters:
[
  "22"
  "9812"
]
74 0.07 ms
UPDATE eposm_s_ticket SET technician_id = ? WHERE id = ?
Parameters:
[
  "22"
  "10184"
]
75 114.26 ms
"COMMIT"
Parameters:
[]

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\Company No errors.
App\Entity\Master\CompanyMailer 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\City No errors.
App\Entity\Master\Province No errors.
App\Entity\Master\CityAlias No errors.
App\Entity\Master\Zip No errors.

slave entity manager

Class Mapping errors
App\Entity\Slave\User No errors.
App\Entity\Slave\UserProfile No errors.
App\Entity\Slave\AccountType No errors.
App\Entity\Slave\UserDocument No errors.
App\Entity\Slave\UserHoliday No errors.
App\Entity\Slave\JoinTableUserWarehouse No errors.
App\Entity\Slave\TechnicianArea No errors.
App\Entity\Slave\JoinTableUserSupplier No errors.
App\Entity\Slave\ProductTransferLog No errors.
App\Entity\Slave\ProductTransfer No errors.
App\Entity\Slave\Ticket No errors.
App\Entity\Slave\Intervention No errors.
App\Entity\Slave\ProductRequest No errors.
App\Entity\Slave\TicketReminder No errors.
App\Entity\Slave\Supplier No errors.
App\Entity\Slave\AccountCategory No errors.
App\Entity\Slave\JoinTableAccountTypePermission No errors.
App\Entity\Slave\Permission No errors.
App\Entity\Slave\PermissionCategory No errors.
App\Entity\Slave\Setting No errors.
App\Entity\Slave\Operation No errors.
App\Entity\Slave\SupplierTicketEmail No errors.
App\Entity\Slave\JoinTableProductModelSupplier No errors.
App\Entity\Slave\ProductRegenerated No errors.
App\Entity\Slave\TicketColumnValue No errors.
App\Entity\Slave\Product No errors.
App\Entity\Slave\OperationGroup No errors.
App\Entity\Slave\InterventionActivityType No errors.
App\Entity\Slave\TicketStatus No errors.
App\Entity\Slave\Client No errors.
App\Entity\Slave\Termid No errors.
App\Entity\Slave\OperationTariffAmount No errors.
App\Entity\Slave\TicketSuspension No errors.
App\Entity\Slave\Warehouse No errors.
App\Entity\Slave\Destination No errors.
App\Entity\Slave\InterventionOutcome No errors.
App\Entity\Slave\InterventionOutcomeType No errors.