Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

69 Database Queries

32 Different statements

90.21 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

master connection

Time▼	Count	Info
2.71 ms (3.00%)	1	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: [`"%"`] View formatted query View runnable query Explain query 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 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;
0.51 ms (0.56%)	2	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: [`"1"`] View formatted query View runnable query Explain query 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 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 = '1' LIMIT 1;

Time▼

Count

Info

2.71 ms
(3.00%)

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:

[
  "%"
]

View formatted query View runnable query Explain query

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

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;

0.51 ms
(0.56%)

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:

[
  "1"
]

View formatted query View runnable query Explain query

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

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 = '1' LIMIT 1;

slave connection

Time▼	Count	Info
25.91 ms (28.72%)	3	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
19.44 ms (21.55%)	9	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 e2_.id IN (?) Parameters: [`"to_assign" "4"`] View formatted query View runnable query Explain query 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 e2_.id IN (?) 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 = 'to_assign' AND e0_.system_error = 0 AND e2_.id IN ('4');
19.10 ms (21.17%)	9	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 e2_.id IN (?) ORDER BY e0_.datetime_expiration ASC LIMIT 100 Parameters: [`"to_assign" "4"`] View formatted query View runnable query Explain query 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 e2_.id IN (?) ORDER BY e0_.datetime_expiration ASC LIMIT 100 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 = 'to_assign' AND e0_.system_error = 0 AND e2_.id IN ('4') ORDER BY e0_.datetime_expiration ASC LIMIT 100;
4.56 ms (5.06%)	3	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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.datetime_expiration ASC Parameters: ["suspended" "4" "1724" "1725" "1733" "1738" "1748" "1757" "1758" "1765" "1778" "1781" "1791" "1805" "1815" "1816" "1820" "1827" "1828" "1829" "1378" "1387" "1388" "1389" "1392" "1835" "1837" "1838" "1847" "1848" "1849" "1427" "1853" "1855" "1856" "1858" "1860" "1861" "1431" "1473" "1492" "1884" "1497" "1498" "1888" "1893" "1522" "1523" "1524" "1904" "1535" "1556" "1557" "1589" "1591" "1911" "1915" "1599" "1614" "1920" "1921" "1627" "1635" "1637" "1638" "1639" "1646" "1930" "1934" "1938" "1939" "1942" "1653" "1945" "1948" "1950" "1951" "1952" "1955" "1661" "1964" "1681" "1968" "1971" "1974" "1975" "1976" "1977" "1702" "1978" "2061" "2422" "2423" "3720" "3878" "3914" "4054" "4176" "4658" "4544" "5445" "5516"] View formatted query View runnable query Explain query 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY e0_.datetime_expiration ASC 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 = 'suspended' AND e0_.system_error = 0 AND e2_.id IN ('4') AND e0_.id IN ('1724', '1725', '1733', '1738', '1748', '1757', '1758', '1765', '1778', '1781', '1791', '1805', '1815', '1816', '1820', '1827', '1828', '1829', '1378', '1387', '1388', '1389', '1392', '1835', '1837', '1838', '1847', '1848', '1849', '1427', '1853', '1855', '1856', '1858', '1860', '1861', '1431', '1473', '1492', '1884', '1497', '1498', '1888', '1893', '1522', '1523', '1524', '1904', '1535', '1556', '1557', '1589', '1591', '1911', '1915', '1599', '1614', '1920', '1921', '1627', '1635', '1637', '1638', '1639', '1646', '1930', '1934', '1938', '1939', '1942', '1653', '1945', '1948', '1950', '1951', '1952', '1955', '1661', '1964', '1681', '1968', '1971', '1974', '1975', '1976', '1977', '1702', '1978', '2061', '2422', '2423', '3720', '3878', '3914', '4054', '4176', '4658', '4544', '5445', '5516') ORDER BY e0_.datetime_expiration ASC;
4.14 ms (4.59%)	1	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 AND e2_.id IN (?) Parameters: [`"4"`] View formatted query View runnable query Explain query 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 AND e2_.id IN (?) 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 AND e2_.id IN ('4');
3.90 ms (4.32%)	1	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 AND e2_.id IN (?) ORDER BY e0_.datetime_expiration ASC LIMIT 100 Parameters: [`"4"`] View formatted query View runnable query Explain query 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 AND e2_.id IN (?) ORDER BY e0_.datetime_expiration ASC LIMIT 100 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 AND e2_.id IN ('4') ORDER BY e0_.datetime_expiration ASC LIMIT 100;
3.51 ms (3.89%)	1	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: [] View formatted query View runnable query Explain query 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 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;
0.79 ms (0.88%)	12	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"`] View formatted query View runnable query Explain query 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 = ? 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 = '1';
0.76 ms (0.85%)	1	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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.datetime_expiration ASC Parameters: [`"taken_charge" "4" "37626" "39637" "39683" "40885" "40895" "40898" "40965" "41059" "41126" "41239" "41276" "41240" "41287" "41241" "41242" "41245" "41246" "41248" "41249" "41251" "41252" "41253" "41255" "41256" "41235" "41258" "41237" "41269" "41238" "41270" "41373" "41374" "41375" "41376" "41377" "41379" "41380" "41383" "41387" "41408" "41409" "41431"`] View formatted query View runnable query Explain query 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY e0_.datetime_expiration ASC 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 = 'taken_charge' AND e0_.system_error = 0 AND e2_.id IN ('4') AND e0_.id IN ('37626', '39637', '39683', '40885', '40895', '40898', '40965', '41059', '41126', '41239', '41276', '41240', '41287', '41241', '41242', '41245', '41246', '41248', '41249', '41251', '41252', '41253', '41255', '41256', '41235', '41258', '41237', '41269', '41238', '41270', '41373', '41374', '41375', '41376', '41377', '41379', '41380', '41383', '41387', '41408', '41409', '41431') ORDER BY e0_.datetime_expiration ASC;
0.41 ms (0.45%)	1	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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.datetime_expiration ASC Parameters: [`"assigned" "4" "41481" "41159" "41492" "41493" "41494" "41495" "41496" "41482" "41483" "41484" "41485" "41486" "41487" "41488" "41489" "41490" "41491"`] View formatted query View runnable query Explain query 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY e0_.datetime_expiration ASC 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 = 'assigned' AND e0_.system_error = 0 AND e2_.id IN ('4') AND e0_.id IN ('41481', '41159', '41492', '41493', '41494', '41495', '41496', '41482', '41483', '41484', '41485', '41486', '41487', '41488', '41489', '41490', '41491') ORDER BY e0_.datetime_expiration ASC;
0.39 ms (0.44%)	1	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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.datetime_expiration ASC Parameters: [`"to_assign" "4" "41057" "41497" "41498" "41499" "41500" "41501" "41502" "41503" "41504" "41505"`] View formatted query View runnable query Explain query 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.datetime_expiration ASC 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 = 'to_assign' AND e0_.system_error = 0 AND e2_.id IN ('4') AND e0_.id IN ('41057', '41497', '41498', '41499', '41500', '41501', '41502', '41503', '41504', '41505') ORDER BY e0_.datetime_expiration ASC;
0.38 ms (0.42%)	3	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"`] View formatted query View runnable query Explain query 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 SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_setting t0 WHERE t0.slug = 'ticket_backoffice_manage' LIMIT 1;
0.37 ms (0.41%)	1	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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY e0_.datetime_expiration ASC Parameters: [`"closed_portal" "4" "4343" "6195" "18543" "19846" "22188" "23207"`] View formatted query View runnable query Explain query 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY e0_.datetime_expiration ASC 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 = 'closed_portal' AND e0_.system_error = 0 AND e2_.id IN ('4') AND e0_.id IN ('4343', '6195', '18543', '19846', '22188', '23207') ORDER BY e0_.datetime_expiration ASC;
0.30 ms (0.33%)	1	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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN (?, ?, ?) ORDER BY e0_.datetime_expiration ASC Parameters: [`"wrong" "4" "3876" "3900" "3902"`] View formatted query View runnable query Explain query 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN (?, ?, ?) ORDER BY e0_.datetime_expiration ASC 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 = 'wrong' AND e0_.system_error = 0 AND e2_.id IN ('4') AND e0_.id IN ('3876', '3900', '3902') ORDER BY e0_.datetime_expiration ASC;
0.26 ms (0.28%)	1	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_.can_exchange_tickets AS can_exchange_tickets_11, e0_.is_assign_email_active AS is_assign_email_active_12, e0_.account_type_id AS account_type_id_13 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" "14"`] View formatted query View runnable query Explain query 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_.can_exchange_tickets AS can_exchange_tickets_11, e0_.is_assign_email_active AS is_assign_email_active_12, e0_.account_type_id AS account_type_id_13 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 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_.can_exchange_tickets AS can_exchange_tickets_11, e0_.is_assign_email_active AS is_assign_email_active_12, e0_.account_type_id AS account_type_id_13 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 <> 'ROLE_ADMIN' AND (e3_.slug = 'tech-internal' OR e3_.slug = 'tech-external') AND e0_.is_company_active = 1 AND e0_.id IN ('14') ORDER BY e2_.surname ASC, e2_.name ASC;
0.25 ms (0.28%)	1	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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN (?, ?, ?, ?) ORDER BY e0_.datetime_expiration ASC Parameters: [`"suspension_request" "4" "41207" "41259" "41260" "41261"`] View formatted query View runnable query Explain query 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 e2_.id IN (?) AND e0_.id IN (?, ?, ?, ?) ORDER BY e0_.datetime_expiration ASC 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.report_printed AS report_printed_20, e0_.processed AS processed_21, e0_.closed_on_portal AS closed_on_portal_22, e0_.supplier_id AS supplier_id_23, e0_.client_id AS client_id_24, e0_.operation_id AS operation_id_25, e0_.technician_id AS technician_id_26, e0_.status_id AS status_id_27, e0_.termid_id AS termid_id_28, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_29, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_30 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 = 'suspension_request' AND e0_.system_error = 0 AND e2_.id IN ('4') AND e0_.id IN ('41207', '41259', '41260', '41261') ORDER BY e0_.datetime_expiration ASC;
0.25 ms (0.27%)	1	UPDATE eposm_s_ticket SET technician_id = ?, status_id = ? WHERE id = ? Parameters: [`"14" "2" "41497"`] View formatted query View runnable query Explain query UPDATE eposm_s_ticket SET technician_id = ?, status_id = ? WHERE id = ? UPDATE eposm_s_ticket SET technician_id = '14', status_id = '2' WHERE id = '41497';
0.24 ms (0.26%)	2	INSERT INTO eposm_s_ticket_log (datetime, ACTION, operator, old_value, new_value, ticket_id) VALUES (?, ?, ?, ?, ?, ?) Parameters: [`"2025-10-10 12:08:39" "ct" "MARCUCCI EMANUELA" "Nessuno" "Toto Marco" "41497"`] View formatted query View runnable query Explain query INSERT INTO eposm_s_ticket_log ( datetime, ACTION, operator, old_value, new_value, ticket_id ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO eposm_s_ticket_log (datetime, ACTION, operator, old_value, new_value, ticket_id) VALUES ('2025-10-10 12:08:39', 'ct', 'MARCUCCI EMANUELA', 'Nessuno', 'Toto Marco', '41497');
0.22 ms (0.24%)	1	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: [`"41497"`] View formatted query View runnable query Explain query 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 = ? 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 = '41497';
0.22 ms (0.24%)	3	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
0.22 ms (0.24%)	1	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"`] View formatted query View runnable query Explain query 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 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 = 'assigned' LIMIT 1;
0.20 ms (0.22%)	1	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, t0.can_exchange_tickets AS can_exchange_tickets_12, t0.is_assign_email_active AS is_assign_email_active_13, t14.id AS id_15, t14.name AS name_16, t14.surname AS surname_17, t14.phone AS phone_18, t14.fiscal_code AS fiscal_code_19, t14.vat AS vat_20, t14.phone_personal AS phone_personal_21, t14.email_personal AS email_personal_22, t14.address AS address_23, t14.civic AS civic_24, t14.zip AS zip_25, t14.id_city AS id_city_26, t14.user_id AS user_id_27, t0.account_type_id AS account_type_id_28 FROM eposm_s_user t0 LEFT JOIN eposm_s_user_profile t14 ON t14.user_id = t0.id WHERE t0.id = ? Parameters: [`"26"`] View formatted query View runnable query Explain query 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, t0.can_exchange_tickets AS can_exchange_tickets_12, t0.is_assign_email_active AS is_assign_email_active_13, t14.id AS id_15, t14.name AS name_16, t14.surname AS surname_17, t14.phone AS phone_18, t14.fiscal_code AS fiscal_code_19, t14.vat AS vat_20, t14.phone_personal AS phone_personal_21, t14.email_personal AS email_personal_22, t14.address AS address_23, t14.civic AS civic_24, t14.zip AS zip_25, t14.id_city AS id_city_26, t14.user_id AS user_id_27, t0.account_type_id AS account_type_id_28 FROM eposm_s_user t0 LEFT JOIN eposm_s_user_profile t14 ON t14.user_id = t0.id WHERE t0.id = ? 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, t0.can_exchange_tickets AS can_exchange_tickets_12, t0.is_assign_email_active AS is_assign_email_active_13, t14.id AS id_15, t14.name AS name_16, t14.surname AS surname_17, t14.phone AS phone_18, t14.fiscal_code AS fiscal_code_19, t14.vat AS vat_20, t14.phone_personal AS phone_personal_21, t14.email_personal AS email_personal_22, t14.address AS address_23, t14.civic AS civic_24, t14.zip AS zip_25, t14.id_city AS id_city_26, t14.user_id AS user_id_27, t0.account_type_id AS account_type_id_28 FROM eposm_s_user t0 LEFT JOIN eposm_s_user_profile t14 ON t14.user_id = t0.id WHERE t0.id = '26';
0.19 ms (0.22%)	1	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.billable AS billable_19, t0.json_report AS json_report_20, t0.report_printed AS report_printed_21, t0.processed AS processed_22, t0.closed_on_portal AS closed_on_portal_23, t0.supplier_id AS supplier_id_24, t0.client_id AS client_id_25, t0.operation_id AS operation_id_26, t0.technician_id AS technician_id_27, t0.status_id AS status_id_28, t0.termid_id AS termid_id_29, t0.operation_tariff_amount_id AS operation_tariff_amount_id_30, t0.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_31 FROM eposm_s_ticket t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"41497"`] View formatted query View runnable query Explain query 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.billable AS billable_19, t0.json_report AS json_report_20, t0.report_printed AS report_printed_21, t0.processed AS processed_22, t0.closed_on_portal AS closed_on_portal_23, t0.supplier_id AS supplier_id_24, t0.client_id AS client_id_25, t0.operation_id AS operation_id_26, t0.technician_id AS technician_id_27, t0.status_id AS status_id_28, t0.termid_id AS termid_id_29, t0.operation_tariff_amount_id AS operation_tariff_amount_id_30, t0.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_31 FROM eposm_s_ticket t0 WHERE t0.id = ? LIMIT 1 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.billable AS billable_19, t0.json_report AS json_report_20, t0.report_printed AS report_printed_21, t0.processed AS processed_22, t0.closed_on_portal AS closed_on_portal_23, t0.supplier_id AS supplier_id_24, t0.client_id AS client_id_25, t0.operation_id AS operation_id_26, t0.technician_id AS technician_id_27, t0.status_id AS status_id_28, t0.termid_id AS termid_id_29, t0.operation_tariff_amount_id AS operation_tariff_amount_id_30, t0.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_31 FROM eposm_s_ticket t0 WHERE t0.id = '41497' LIMIT 1;
0.19 ms (0.21%)	1	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: [`"8"`] View formatted query View runnable query Explain query 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 = ? 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 = '8';
0.17 ms (0.19%)	1	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: [`"8"`] View formatted query View runnable query Explain query 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 = ? 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 = '8';
0.14 ms (0.16%)	1	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: [`"14"`] View formatted query View runnable query Explain query 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 = ? 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 = '14';
0.14 ms (0.16%)	1	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: [] View formatted query View runnable query Explain query 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 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;
0.13 ms (0.15%)	1	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, e0_.operation_not_billable_codes AS operation_not_billable_codes_7, e0_.is_active AS is_active_8 FROM eposm_s_supplier e0_ WHERE e0_.is_active = 1 ORDER BY e0_.name ASC Parameters: [] View formatted query View runnable query Explain query 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, e0_.operation_not_billable_codes AS operation_not_billable_codes_7, e0_.is_active AS is_active_8 FROM eposm_s_supplier e0_ WHERE e0_.is_active = 1 ORDER BY e0_.name ASC 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, e0_.operation_not_billable_codes AS operation_not_billable_codes_7, e0_.is_active AS is_active_8 FROM eposm_s_supplier e0_ WHERE e0_.is_active = 1 ORDER BY e0_.name ASC;
0.12 ms (0.14%)	1	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"`] View formatted query View runnable query Explain query 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 = ? 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 = '1';
0.09 ms (0.10%)	1	SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_ticket_status t0 WHERE t0.id = ? Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_ticket_status t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_ticket_status t0 WHERE t0.id = '1';

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\ProductLog	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\TicketLog	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.