Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

90 Database Queries

26 Different statements

50.87 ms Query time

0 Invalid entities

Queries

Group similar statements

master connection


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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 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
SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ?
SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ?
SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ?
SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ?
SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ?
SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ?
SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ?
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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1

#▲	Time	Info
1	0.40 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
2	2.91 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: [`"%"`] 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;
3	2.53 ms	SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? Parameters: [`"%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE '%8056%' OR e1_.sign LIKE '%8056%';
4	2.51 ms	SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? Parameters: [`"%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE '%8056%' OR e1_.sign LIKE '%8056%';
5	2.54 ms	SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? Parameters: [`"%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE '%8056%' OR e1_.sign LIKE '%8056%';
6	2.44 ms	SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? Parameters: [`"%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE '%8056%' OR e1_.sign LIKE '%8056%';
7	2.46 ms	SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? Parameters: [`"%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE '%8056%' OR e1_.sign LIKE '%8056%';
8	2.49 ms	SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? Parameters: [`"%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE '%8056%' OR e1_.sign LIKE '%8056%';
9	2.50 ms	SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? Parameters: [`"%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE ? OR e1_.sign LIKE ? SELECT e0_.id AS id_0 FROM eposm_m_city e0_ LEFT JOIN eposm_m_province e1_ ON e0_.province_id = e1_.id WHERE e0_.name LIKE '%8056%' OR e1_.sign LIKE '%8056%';
10	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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
11	0.10 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
12	0.15 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
13	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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
14	0.13 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
15	0.12 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
16	0.12 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
17	0.12 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
18	0.12 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
19	0.11 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
20	0.12 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
21	0.12 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;
22	0.13 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"19"`] 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 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, t0.is_scandit_active AS is_scandit_active_21, t0.is_tag_ticket_active AS is_tag_ticket_active_22, t0.is_extra_premium_active AS is_extra_premium_active_23 FROM eposm_m_company t0 WHERE t0.id = '19' LIMIT 1;

slave connection


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.product_transfer_download_method AS product_transfer_download_method_7, t0.is_active AS is_active_8, t0.is_company_active AS is_company_active_9, t0.is_admin_active AS is_admin_active_10, t0.exclude_auto_assign AS exclude_auto_assign_11, t0.is_economic_visible AS is_economic_visible_12, t0.can_exchange_tickets AS can_exchange_tickets_13, t0.is_assign_email_active AS is_assign_email_active_14, t0.is_send_material_direct AS is_send_material_direct_15, t16.id AS id_17, t16.name AS name_18, t16.surname AS surname_19, t16.phone AS phone_20, t16.fiscal_code AS fiscal_code_21, t16.vat AS vat_22, t16.phone_personal AS phone_personal_23, t16.email_personal AS email_personal_24, t16.address AS address_25, t16.civic AS civic_26, t16.zip AS zip_27, t16.id_city AS id_city_28, t16.user_id AS user_id_29, t0.account_type_id AS account_type_id_30 FROM eposm_s_user t0 LEFT JOIN eposm_s_user_profile t16 ON t16.user_id = t0.id 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 = ?
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.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 = ?
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 = ?
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 = ?
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 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 = ? 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 = ? LIMIT 1
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.mapping_value AS mapping_value_2, e0_.color AS color_3, e0_.datetime_start AS datetime_start_4, e0_.datetime_end AS datetime_end_5, e0_.operation_key_mapping_id AS operation_key_mapping_id_6 FROM eposm_s_ticket_tag e0_ 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, e0_.is_intervetion_active AS is_intervetion_active_9 FROM eposm_s_supplier e0_ WHERE e0_.is_active = 1 ORDER BY e0_.name 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
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.slug AS slug_2, t0.value AS value_3 FROM eposm_s_setting t0 WHERE t0.slug = ? LIMIT 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL))
SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100
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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL))
SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100
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_.is_overridable AS is_overridable_20, e0_.report_printed AS report_printed_21, e0_.processed AS processed_22, e0_.closed_on_portal AS closed_on_portal_23, e0_.notes AS notes_24, e0_.supplier_id AS supplier_id_25, e0_.client_id AS client_id_26, e0_.operation_id AS operation_id_27, e0_.technician_id AS technician_id_28, e0_.status_id AS status_id_29, e0_.termid_id AS termid_id_30, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_31, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_32 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC
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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL))
SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100
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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL))
SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100
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_.is_overridable AS is_overridable_20, e0_.report_printed AS report_printed_21, e0_.processed AS processed_22, e0_.closed_on_portal AS closed_on_portal_23, e0_.notes AS notes_24, e0_.supplier_id AS supplier_id_25, e0_.client_id AS client_id_26, e0_.operation_id AS operation_id_27, e0_.technician_id AS technician_id_28, e0_.status_id AS status_id_29, e0_.termid_id AS termid_id_30, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_31, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_32 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) AND e0_.id IN (?) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC
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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL))
SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100
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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL))
SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100
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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL))
SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100
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 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 = ?
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.is_main AS is_main_2, t0.permission AS permission_3, t0.user_id AS user_id_4, t0.warehouse_id AS warehouse_id_5 FROM eposm_s_join_table_user_warehouse t0 WHERE t0.user_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 = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug_master AS slug_master_3, t0.code_client AS code_client_4, t0.identifier_regex AS identifier_regex_5, t0.is_uav AS is_uav_6, t0.active AS active_7, t0.supplier_id AS supplier_id_8, t0.group_id AS group_id_9 FROM eposm_s_operation t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.ticket_column AS ticket_column_2, t0.mapping_value AS mapping_value_3, t0.mapping_extra AS mapping_extra_4, t0.priority AS priority_5, t0.is_key_required AS is_key_required_6, t0.is_ticket_number AS is_ticket_number_7, t0.is_termid AS is_termid_8, t0.operation_id AS operation_id_9 FROM eposm_s_operation_key_mapping t0 WHERE t0.operation_id = ? ORDER BY t0.priority ASC
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.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 = ?
SELECT t0.id AS id_1, t0.datetime_from AS datetime_from_2, t0.datetime_to AS datetime_to_3, t0.is_approved AS is_approved_4, t0.is_managed AS is_managed_5, t0.is_unlocked AS is_unlocked_6, t0.unlock_causal AS unlock_causal_7, t0.refuse_motivation AS refuse_motivation_8, t0.intervention_id AS intervention_id_9, t0.ticket_id AS ticket_id_10 FROM eposm_s_ticket_suspension t0 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.id = ?
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_intervention_outcome_type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ?

#▲	Time	Info
1	0.22 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.product_transfer_download_method AS product_transfer_download_method_7, t0.is_active AS is_active_8, t0.is_company_active AS is_company_active_9, t0.is_admin_active AS is_admin_active_10, t0.exclude_auto_assign AS exclude_auto_assign_11, t0.is_economic_visible AS is_economic_visible_12, t0.can_exchange_tickets AS can_exchange_tickets_13, t0.is_assign_email_active AS is_assign_email_active_14, t0.is_send_material_direct AS is_send_material_direct_15, t16.id AS id_17, t16.name AS name_18, t16.surname AS surname_19, t16.phone AS phone_20, t16.fiscal_code AS fiscal_code_21, t16.vat AS vat_22, t16.phone_personal AS phone_personal_23, t16.email_personal AS email_personal_24, t16.address AS address_25, t16.civic AS civic_26, t16.zip AS zip_27, t16.id_city AS id_city_28, t16.user_id AS user_id_29, t0.account_type_id AS account_type_id_30 FROM eposm_s_user t0 LEFT JOIN eposm_s_user_profile t16 ON t16.user_id = t0.id WHERE t0.id = ? Parameters: [`"63"`] 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.product_transfer_download_method AS product_transfer_download_method_7, t0.is_active AS is_active_8, t0.is_company_active AS is_company_active_9, t0.is_admin_active AS is_admin_active_10, t0.exclude_auto_assign AS exclude_auto_assign_11, t0.is_economic_visible AS is_economic_visible_12, t0.can_exchange_tickets AS can_exchange_tickets_13, t0.is_assign_email_active AS is_assign_email_active_14, t0.is_send_material_direct AS is_send_material_direct_15, t16.id AS id_17, t16.name AS name_18, t16.surname AS surname_19, t16.phone AS phone_20, t16.fiscal_code AS fiscal_code_21, t16.vat AS vat_22, t16.phone_personal AS phone_personal_23, t16.email_personal AS email_personal_24, t16.address AS address_25, t16.civic AS civic_26, t16.zip AS zip_27, t16.id_city AS id_city_28, t16.user_id AS user_id_29, t0.account_type_id AS account_type_id_30 FROM eposm_s_user t0 LEFT JOIN eposm_s_user_profile t16 ON t16.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.product_transfer_download_method AS product_transfer_download_method_7, t0.is_active AS is_active_8, t0.is_company_active AS is_company_active_9, t0.is_admin_active AS is_admin_active_10, t0.exclude_auto_assign AS exclude_auto_assign_11, t0.is_economic_visible AS is_economic_visible_12, t0.can_exchange_tickets AS can_exchange_tickets_13, t0.is_assign_email_active AS is_assign_email_active_14, t0.is_send_material_direct AS is_send_material_direct_15, t16.id AS id_17, t16.name AS name_18, t16.surname AS surname_19, t16.phone AS phone_20, t16.fiscal_code AS fiscal_code_21, t16.vat AS vat_22, t16.phone_personal AS phone_personal_23, t16.email_personal AS email_personal_24, t16.address AS address_25, t16.civic AS civic_26, t16.zip AS zip_27, t16.id_city AS id_city_28, t16.user_id AS user_id_29, t0.account_type_id AS account_type_id_30 FROM eposm_s_user t0 LEFT JOIN eposm_s_user_profile t16 ON t16.user_id = t0.id WHERE t0.id = '63';
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: [`"9"`] 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 = '9';
3	0.18 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: [`"9"`] 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 = '9';
4	0.13 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"`] 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 = '3';
5	0.07 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"`] 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 = '6';
6	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: [`"7"`] 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 = '7';
7	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: [`"8"`] 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 = '8';
8	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: [`"9"`] 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 = '9';
9	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: [`"10"`] 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 = '10';
10	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: [`"12"`] 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 = '12';
11	0.25 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"`] 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;
12	0.08 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_processed_active"`] 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_processed_active' LIMIT 1;
13	0.06 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_technician_send_assign_email"`] 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_technician_send_assign_email' LIMIT 1;
14	0.23 ms	SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.mapping_value AS mapping_value_2, e0_.color AS color_3, e0_.datetime_start AS datetime_start_4, e0_.datetime_end AS datetime_end_5, e0_.operation_key_mapping_id AS operation_key_mapping_id_6 FROM eposm_s_ticket_tag e0_ 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_.mapping_value AS mapping_value_2, e0_.color AS color_3, e0_.datetime_start AS datetime_start_4, e0_.datetime_end AS datetime_end_5, e0_.operation_key_mapping_id AS operation_key_mapping_id_6 FROM eposm_s_ticket_tag e0_ ORDER BY e0_.name ASC SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.mapping_value AS mapping_value_2, e0_.color AS color_3, e0_.datetime_start AS datetime_start_4, e0_.datetime_end AS datetime_end_5, e0_.operation_key_mapping_id AS operation_key_mapping_id_6 FROM eposm_s_ticket_tag e0_ ORDER BY e0_.name ASC;
15	0.21 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, e0_.operation_not_billable_codes AS operation_not_billable_codes_7, e0_.is_active AS is_active_8, e0_.is_intervetion_active AS is_intervetion_active_9 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, e0_.is_intervetion_active AS is_intervetion_active_9 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, e0_.is_intervetion_active AS is_intervetion_active_9 FROM eposm_s_supplier e0_ WHERE e0_.is_active = 1 ORDER BY e0_.name ASC;
16	0.22 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: [] 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;
17	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: [`"5"`] 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 = '5';
18	0.07 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_suspension_unlock_by_technician"`] 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_suspension_unlock_by_technician' LIMIT 1;
19	0.48 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) Parameters: [`"63" "assigned" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'assigned' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL));
20	0.32 ms	SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 Parameters: [`"63" "assigned" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'assigned' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100;
21	2.00 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) Parameters: [`"63" "taken_charge" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'taken_charge' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL));
22	2.02 ms	SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 Parameters: [`"63" "taken_charge" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'taken_charge' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100;
23	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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.is_overridable AS is_overridable_20, e0_.report_printed AS report_printed_21, e0_.processed AS processed_22, e0_.closed_on_portal AS closed_on_portal_23, e0_.notes AS notes_24, e0_.supplier_id AS supplier_id_25, e0_.client_id AS client_id_26, e0_.operation_id AS operation_id_27, e0_.technician_id AS technician_id_28, e0_.status_id AS status_id_29, e0_.termid_id AS termid_id_30, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_31, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_32 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC Parameters: [`"63" "taken_charge" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%" "42560" "42630" "42648" "42656" "42660" "42666" "42689" "42693" "42695" "42559"`] 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_.is_overridable AS is_overridable_20, e0_.report_printed AS report_printed_21, e0_.processed AS processed_22, e0_.closed_on_portal AS closed_on_portal_23, e0_.notes AS notes_24, e0_.supplier_id AS supplier_id_25, e0_.client_id AS client_id_26, e0_.operation_id AS operation_id_27, e0_.technician_id AS technician_id_28, e0_.status_id AS status_id_29, e0_.termid_id AS termid_id_30, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_31, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_32 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.processed ASC, 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_.is_overridable AS is_overridable_20, e0_.report_printed AS report_printed_21, e0_.processed AS processed_22, e0_.closed_on_portal AS closed_on_portal_23, e0_.notes AS notes_24, e0_.supplier_id AS supplier_id_25, e0_.client_id AS client_id_26, e0_.operation_id AS operation_id_27, e0_.technician_id AS technician_id_28, e0_.status_id AS status_id_29, e0_.termid_id AS termid_id_30, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_31, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_32 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'taken_charge' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL)) AND e0_.id IN ('42560', '42630', '42648', '42656', '42660', '42666', '42689', '42693', '42695', '42559') ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC;
24	0.36 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) Parameters: [`"63" "suspension_request" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'suspension_request' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL));
25	0.30 ms	SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 Parameters: [`"63" "suspension_request" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'suspension_request' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100;
26	0.42 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) Parameters: [`"63" "suspended" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'suspended' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL));
27	0.42 ms	SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 Parameters: [`"63" "suspended" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'suspended' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100;
28	0.25 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_.billable AS billable_18, e0_.json_report AS json_report_19, e0_.is_overridable AS is_overridable_20, e0_.report_printed AS report_printed_21, e0_.processed AS processed_22, e0_.closed_on_portal AS closed_on_portal_23, e0_.notes AS notes_24, e0_.supplier_id AS supplier_id_25, e0_.client_id AS client_id_26, e0_.operation_id AS operation_id_27, e0_.technician_id AS technician_id_28, e0_.status_id AS status_id_29, e0_.termid_id AS termid_id_30, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_31, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_32 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) AND e0_.id IN (?) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC Parameters: [`"63" "suspended" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%" "42616"`] 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_.is_overridable AS is_overridable_20, e0_.report_printed AS report_printed_21, e0_.processed AS processed_22, e0_.closed_on_portal AS closed_on_portal_23, e0_.notes AS notes_24, e0_.supplier_id AS supplier_id_25, e0_.client_id AS client_id_26, e0_.operation_id AS operation_id_27, e0_.technician_id AS technician_id_28, e0_.status_id AS status_id_29, e0_.termid_id AS termid_id_30, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_31, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_32 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) AND e0_.id IN (?) ORDER BY e0_.processed ASC, 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_.is_overridable AS is_overridable_20, e0_.report_printed AS report_printed_21, e0_.processed AS processed_22, e0_.closed_on_portal AS closed_on_portal_23, e0_.notes AS notes_24, e0_.supplier_id AS supplier_id_25, e0_.client_id AS client_id_26, e0_.operation_id AS operation_id_27, e0_.technician_id AS technician_id_28, e0_.status_id AS status_id_29, e0_.termid_id AS termid_id_30, e0_.operation_tariff_amount_id AS operation_tariff_amount_id_31, e0_.uav_operation_tariff_amount_id AS uav_operation_tariff_amount_id_32 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'suspended' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL)) AND e0_.id IN ('42616') ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC;
29	0.28 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) Parameters: [`"63" "closed" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'closed' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL));
30	0.25 ms	SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 Parameters: [`"63" "closed" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'closed' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100;
31	4.42 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) Parameters: [`"63" "closed_portal" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'closed_portal' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL));
32	4.40 ms	SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 Parameters: [`"63" "closed_portal" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'closed_portal' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100;
33	0.95 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) Parameters: [`"63" "canceled" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) 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_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'canceled' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL));
34	0.92 ms	SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND (e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 Parameters: [`"63" "canceled" "%8056%" "%8056%" "%8056%" "%8056%" "8056%" "%8056%" "%8056%" "%8056%" "%8056%" "%8056%"`] View formatted query View runnable query Explain query SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = ? AND e1_.slug = ? AND e0_.system_error = 0 AND ( e0_.number LIKE ? OR e2_.code LIKE ? OR e4_.name LIKE ? OR e4_.nickname LIKE ? OR e5_.value LIKE ? OR e3_.name LIKE ? OR e0_.address LIKE ? OR e0_.zip LIKE ? OR e0_.id_city IN (NULL) OR e4_.address LIKE ? OR e4_.zip LIKE ? OR e0_.id_city IN (NULL) ) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100 SELECT DISTINCT e0_.id AS id_0, e0_.processed AS processed_1, e0_.datetime_expiration AS datetime_expiration_2 FROM eposm_s_ticket e0_ LEFT JOIN eposm_s_ticket_status e1_ ON e0_.status_id = e1_.id LEFT JOIN eposm_s_termid e2_ ON e0_.termid_id = e2_.id LEFT JOIN eposm_s_supplier e3_ ON e0_.supplier_id = e3_.id LEFT JOIN eposm_s_client e4_ ON e0_.client_id = e4_.id LEFT JOIN eposm_s_operation e5_ ON e0_.operation_id = e5_.id LEFT JOIN eposm_s_user e6_ ON e0_.technician_id = e6_.id WHERE e6_.id = '63' AND e1_.slug = 'canceled' AND e0_.system_error = 0 AND (e0_.number LIKE '%8056%' OR e2_.code LIKE '%8056%' OR e4_.name LIKE '%8056%' OR e4_.nickname LIKE '%8056%' OR e5_.value LIKE '8056%' OR e3_.name LIKE '%8056%' OR e0_.address LIKE '%8056%' OR e0_.zip LIKE '%8056%' OR e0_.id_city IN (NULL) OR e4_.address LIKE '%8056%' OR e4_.zip LIKE '%8056%' OR e0_.id_city IN (NULL)) ORDER BY e0_.processed ASC, e0_.datetime_expiration ASC LIMIT 100;
35	4.39 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: [] 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;
36	0.14 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"`] 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 = '11';
37	0.11 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: [`"20"`] 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 = '20';
38	0.11 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: [`"26"`] 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 = '26';
39	0.13 ms	SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.permission AS permission_3, t0.user_id AS user_id_4, t0.warehouse_id AS warehouse_id_5 FROM eposm_s_join_table_user_warehouse t0 WHERE t0.user_id = ? Parameters: [`"63"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.permission AS permission_3, t0.user_id AS user_id_4, t0.warehouse_id AS warehouse_id_5 FROM eposm_s_join_table_user_warehouse t0 WHERE t0.user_id = ? SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.permission AS permission_3, t0.user_id AS user_id_4, t0.warehouse_id AS warehouse_id_5 FROM eposm_s_join_table_user_warehouse t0 WHERE t0.user_id = '63';
40	0.12 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.id = ? Parameters: [`"3"`] 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 = '3';
41	0.11 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? Parameters: [`"36060"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = '36060';
42	0.12 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? Parameters: [`"35260"`] 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.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = '35260';
43	0.09 ms	SELECT t0.id AS id_1, t0.value AS value_2, t0.slug_master AS slug_master_3, t0.code_client AS code_client_4, t0.identifier_regex AS identifier_regex_5, t0.is_uav AS is_uav_6, t0.active AS active_7, t0.supplier_id AS supplier_id_8, t0.group_id AS group_id_9 FROM eposm_s_operation t0 WHERE t0.id = ? Parameters: [`"101"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.value AS value_2, t0.slug_master AS slug_master_3, t0.code_client AS code_client_4, t0.identifier_regex AS identifier_regex_5, t0.is_uav AS is_uav_6, t0.active AS active_7, t0.supplier_id AS supplier_id_8, t0.group_id AS group_id_9 FROM eposm_s_operation t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.value AS value_2, t0.slug_master AS slug_master_3, t0.code_client AS code_client_4, t0.identifier_regex AS identifier_regex_5, t0.is_uav AS is_uav_6, t0.active AS active_7, t0.supplier_id AS supplier_id_8, t0.group_id AS group_id_9 FROM eposm_s_operation t0 WHERE t0.id = '101';
44	0.19 ms	SELECT t0.id AS id_1, t0.ticket_column AS ticket_column_2, t0.mapping_value AS mapping_value_3, t0.mapping_extra AS mapping_extra_4, t0.priority AS priority_5, t0.is_key_required AS is_key_required_6, t0.is_ticket_number AS is_ticket_number_7, t0.is_termid AS is_termid_8, t0.operation_id AS operation_id_9 FROM eposm_s_operation_key_mapping t0 WHERE t0.operation_id = ? ORDER BY t0.priority ASC Parameters: [`"101"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.ticket_column AS ticket_column_2, t0.mapping_value AS mapping_value_3, t0.mapping_extra AS mapping_extra_4, t0.priority AS priority_5, t0.is_key_required AS is_key_required_6, t0.is_ticket_number AS is_ticket_number_7, t0.is_termid AS is_termid_8, t0.operation_id AS operation_id_9 FROM eposm_s_operation_key_mapping t0 WHERE t0.operation_id = ? ORDER BY t0.priority ASC SELECT t0.id AS id_1, t0.ticket_column AS ticket_column_2, t0.mapping_value AS mapping_value_3, t0.mapping_extra AS mapping_extra_4, t0.priority AS priority_5, t0.is_key_required AS is_key_required_6, t0.is_ticket_number AS is_ticket_number_7, t0.is_termid AS is_termid_8, t0.operation_id AS operation_id_9 FROM eposm_s_operation_key_mapping t0 WHERE t0.operation_id = '101' ORDER BY t0.priority ASC;
45	0.07 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? Parameters: [`"36061"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = '36061';
46	0.11 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? Parameters: [`"35261"`] 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.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = '35261';
47	0.07 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? Parameters: [`"28700"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = '28700';
48	0.11 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? Parameters: [`"28004"`] 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.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = '28004';
49	0.07 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? Parameters: [`"36134"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = '36134';
50	0.14 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? Parameters: [`"35334"`] 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.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = '35334';
51	0.07 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? Parameters: [`"36142"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = '36142';
52	0.12 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? Parameters: [`"35342"`] 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.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = '35342';
53	0.09 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? Parameters: [`"36145"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = '36145';
54	0.10 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? Parameters: [`"35345"`] 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.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = '35345';
55	0.06 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? Parameters: [`"36150"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = '36150';
56	0.12 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? Parameters: [`"35350"`] 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.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = '35350';
57	0.09 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? Parameters: [`"36172"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = '36172';
58	0.10 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? Parameters: [`"35372"`] 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.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = '35372';
59	0.06 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? Parameters: [`"35446"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = '35446';
60	0.10 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? Parameters: [`"34657"`] 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.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = '34657';
61	0.06 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? Parameters: [`"11123"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = '11123';
62	0.10 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? Parameters: [`"10738"`] 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.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = '10738';
63	0.10 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.id = ? Parameters: [`"6"`] 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 = '6';
64	0.10 ms	SELECT t0.id AS id_1, t0.datetime_from AS datetime_from_2, t0.datetime_to AS datetime_to_3, t0.is_approved AS is_approved_4, t0.is_managed AS is_managed_5, t0.is_unlocked AS is_unlocked_6, t0.unlock_causal AS unlock_causal_7, t0.refuse_motivation AS refuse_motivation_8, t0.intervention_id AS intervention_id_9, t0.ticket_id AS ticket_id_10 FROM eposm_s_ticket_suspension t0 WHERE t0.ticket_id = ? Parameters: [`"42616"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.datetime_from AS datetime_from_2, t0.datetime_to AS datetime_to_3, t0.is_approved AS is_approved_4, t0.is_managed AS is_managed_5, t0.is_unlocked AS is_unlocked_6, t0.unlock_causal AS unlock_causal_7, t0.refuse_motivation AS refuse_motivation_8, t0.intervention_id AS intervention_id_9, t0.ticket_id AS ticket_id_10 FROM eposm_s_ticket_suspension t0 WHERE t0.ticket_id = ? SELECT t0.id AS id_1, t0.datetime_from AS datetime_from_2, t0.datetime_to AS datetime_to_3, t0.is_approved AS is_approved_4, t0.is_managed AS is_managed_5, t0.is_unlocked AS is_unlocked_6, t0.unlock_causal AS unlock_causal_7, t0.refuse_motivation AS refuse_motivation_8, t0.intervention_id AS intervention_id_9, t0.ticket_id AS ticket_id_10 FROM eposm_s_ticket_suspension t0 WHERE t0.ticket_id = '42616';
65	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.id = ? Parameters: [`"43701"`] 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.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.id = '43701';
66	0.10 ms	SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_intervention_outcome_type t0 WHERE t0.id = ? Parameters: [`"2"`] 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_intervention_outcome_type t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM eposm_s_intervention_outcome_type t0 WHERE t0.id = '2';
67	0.06 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? Parameters: [`"36109"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3 FROM eposm_s_termid t0 WHERE t0.id = '36109';
68	0.14 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? Parameters: [`"35309"`] 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.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.nickname AS nickname_4, t0.referent AS referent_5, t0.fiscal_code AS fiscal_code_6, t0.vat AS vat_7, t0.sdi AS sdi_8, t0.address AS address_9, t0.locality AS locality_10, t0.zip AS zip_11, t0.id_city AS id_city_12, t0.id_province AS id_province_13, t0.closures AS closures_14, t0.openings AS openings_15, t0.notes AS notes_16, t0.directory_path AS directory_path_17, t18.id AS id_19, t18.nickname AS nickname_20, t18.address AS address_21, t18.is_movable AS is_movable_22, t18.is_headquarter AS is_headquarter_23, t18.is_active AS is_active_24, t18.client_id AS client_id_25, t18.destination_id AS destination_id_26 FROM eposm_s_client t0 LEFT JOIN eposm_s_warehouse t18 ON t18.client_id = t0.id WHERE t0.id = '35309';

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\TicketTag	No errors.
App\Entity\Slave\OperationKeyMapping	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\Termid	No errors.
App\Entity\Slave\Client	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\ClientPhone	No errors.
App\Entity\Slave\ClientFile	No errors.
App\Entity\Slave\OperationTariff	No errors.
App\Entity\Slave\OperationSubjectMapping	No errors.
App\Entity\Slave\OperationAlgorithm	No errors.
App\Entity\Slave\InterventionOutcome	No errors.
App\Entity\Slave\InterventionOutcomeType	No errors.
App\Entity\Slave\InterventionActivity	No errors.
App\Entity\Slave\InterventionExtra	No errors.

Symfony Profiler

https://eposmanager.software/scrivania/ticket/lista?_=1777655840290&all=8056&filter_tab=taken_charge

Configuration Settings

Theme

Page Width

Query Metrics

Queries

master connection

slave connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

master entity manager

slave entity manager