Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.email AS email_7,
  t0.mobile AS mobile_8,
  t0.phone AS phone_9,
  t0.profile_picture AS profile_picture_10,
  t0.shiftbase_identification AS shiftbase_identification_11,
  t0.default_office_calendar AS default_office_calendar_12,
  t0.default_office_category AS default_office_category_13,
  t0.counter_display_mode AS counter_display_mode_14,
  t0.create_date AS create_date_15,
  t0.modify_date AS modify_date_16,
  t0.is_deleted AS is_deleted_17,
  t0.enable_call_notifications AS enable_call_notifications_18,
  t0.enable_call_end_notifications AS enable_call_end_notifications_19,
  t0.is_api_user AS is_api_user_20,
  t0.allowed_ip_addresses AS allowed_ip_addresses_21,
  t0.created_by_user_id AS created_by_user_id_22,
  t0.modified_by_user_id AS modified_by_user_id_23
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.mobile AS mobile_8, t0.phone AS phone_9, t0.profile_picture AS profile_picture_10, t0.shiftbase_identification AS shiftbase_identification_11, t0.default_office_calendar AS default_office_calendar_12, t0.default_office_category AS default_office_category_13, t0.counter_display_mode AS counter_display_mode_14, t0.create_date AS create_date_15, t0.modify_date AS modify_date_16, t0.is_deleted AS is_deleted_17, t0.enable_call_notifications AS enable_call_notifications_18, t0.enable_call_end_notifications AS enable_call_end_notifications_19, t0.is_api_user AS is_api_user_20, t0.allowed_ip_addresses AS allowed_ip_addresses_21, t0.created_by_user_id AS created_by_user_id_22, t0.modified_by_user_id AS modified_by_user_id_23 FROM user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = 'module_order_delivery_info' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = 'module_sales_lead' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = 'module_ticket' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = 'module_chatbot' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = 'module_shopify' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = 'module_delivery_capacity' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = 'module_addresscheck' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = 'module_transport_calculation' LIMIT 1;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sales_lead s0_
  LEFT JOIN sales_lead_log s1_ ON s0_.id = s1_.sales_lead_id
  LEFT JOIN sales_lead_log s2_ ON s0_.id = s2_.sales_lead_id
  AND (
    s0_.id = s2_.sales_lead_id
    AND s1_.id < s2_.id
    AND s2_.is_deleted = 0
  )
WHERE
  s2_.id IS NULL
  AND s0_.is_deleted = 0
  AND s0_.lead_responsible_id = ?
  AND (
    (
      s1_.is_deleted = 0
      AND s1_.is_finished = 0
    )
    OR s1_.id IS NULL
  )

SELECT COUNT(s0_.id) AS sclr_0 FROM sales_lead s0_ LEFT JOIN sales_lead_log s1_ ON s0_.id = s1_.sales_lead_id LEFT JOIN sales_lead_log s2_ ON s0_.id = s2_.sales_lead_id AND (s0_.id = s2_.sales_lead_id AND s1_.id < s2_.id AND s2_.is_deleted = 0) WHERE s2_.id IS NULL AND s0_.is_deleted = 0 AND s0_.lead_responsible_id = 1 AND ((s1_.is_deleted = 0 AND s1_.is_finished = 0) OR s1_.id IS NULL);

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'outdoorgigant_dev'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'outdoorgigant_dev'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'outdoorgigant_dev' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'outdoorgigant_dev' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'outdoorgigant_dev' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'outdoorgigant_dev' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  c.COLUMN_NAME AS field,
  c.COLUMN_TYPE AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = 'outdoorgigant_dev' AND t.TABLE_SCHEMA = 'outdoorgigant_dev' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
ORDER BY
  SEQ_IN_INDEX

SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'outdoorgigant_dev' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  task t0_
  INNER JOIN task_log t1_ ON t0_.id = t1_.task_id
  LEFT JOIN task_log t2_ ON t0_.id = t2_.task_id
  AND (
    t0_.id = t2_.task_id
    AND t1_.id < t2_.id
    AND t1_.is_deleted = 0
  )
WHERE
  t2_.id IS NULL
  AND t0_.is_deleted = 0
  AND t1_.is_finished = 0
  AND t1_.task_holder_id = ?
ORDER BY
  t1_.due_date ASC

SELECT COUNT(t0_.id) AS sclr_0 FROM task t0_ INNER JOIN task_log t1_ ON t0_.id = t1_.task_id LEFT JOIN task_log t2_ ON t0_.id = t2_.task_id AND (t0_.id = t2_.task_id AND t1_.id < t2_.id AND t1_.is_deleted = 0) WHERE t2_.id IS NULL AND t0_.is_deleted = 0 AND t1_.is_finished = 0 AND t1_.task_holder_id = 1 ORDER BY t1_.due_date ASC;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  task t0_
  INNER JOIN task_log t1_ ON t0_.id = t1_.task_id
  LEFT JOIN task_log t2_ ON t0_.id = t2_.task_id
  AND (
    t0_.id = t2_.task_id
    AND t1_.id < t2_.id
    AND t1_.is_deleted = 0
  )
WHERE
  t2_.id IS NULL
  AND t0_.is_deleted = 0
  AND t1_.is_finished = 0
  AND t1_.due_date IS NOT NULL
  AND t1_.due_date < ?
  AND t1_.task_holder_id = ?

SELECT COUNT(t0_.id) AS sclr_0 FROM task t0_ INNER JOIN task_log t1_ ON t0_.id = t1_.task_id LEFT JOIN task_log t2_ ON t0_.id = t2_.task_id AND (t0_.id = t2_.task_id AND t1_.id < t2_.id AND t1_.is_deleted = 0) WHERE t2_.id IS NULL AND t0_.is_deleted = 0 AND t1_.is_finished = 0 AND t1_.due_date IS NOT NULL AND t1_.due_date < '2026-04-19 00:00:00' AND t1_.task_holder_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.shiftbase_identification AS shiftbase_identification_4,
  t0.create_date AS create_date_5,
  t0.modify_date AS modify_date_6,
  t0.is_deleted AS is_deleted_7,
  t0.permission_user AS permission_user_8,
  t0.permission_user_group AS permission_user_group_9,
  t0.permission_country AS permission_country_10,
  t0.permission_setting AS permission_setting_11,
  t0.permission_customer AS permission_customer_12,
  t0.permission_ledger AS permission_ledger_13,
  t0.permission_product_vat AS permission_product_vat_14,
  t0.permission_product_category AS permission_product_category_15,
  t0.permission_product_tag AS permission_product_tag_16,
  t0.permission_warehouse AS permission_warehouse_17,
  t0.permission_product_property_category AS permission_product_property_category_18,
  t0.permission_product_property AS permission_product_property_19,
  t0.permission_warehouse_location AS permission_warehouse_location_20,
  t0.permission_product_documentation AS permission_product_documentation_21,
  t0.permission_construction_drawing AS permission_construction_drawing_22,
  t0.permission_product AS permission_product_23,
  t0.permission_supplier AS permission_supplier_24,
  t0.permission_dossier AS permission_dossier_25,
  t0.permission_journal AS permission_journal_26,
  t0.permission_pay_method AS permission_pay_method_27,
  t0.permission_proposal AS permission_proposal_28,
  t0.permission_purchase AS permission_purchase_29,
  t0.permission_incoming_good AS permission_incoming_good_30,
  t0.permission_delivery_method AS permission_delivery_method_31,
  t0.permission_order AS permission_order_32,
  t0.permission_invoice AS permission_invoice_33,
  t0.permission_order_pick AS permission_order_pick_34,
  t0.permission_custom AS permission_custom_35,
  t0.permission_delivery_note AS permission_delivery_note_36,
  t0.permission_proposal_checklist AS permission_proposal_checklist_37,
  t0.permission_tailor AS permission_tailor_38,
  t0.permission_email_template AS permission_email_template_39,
  t0.permission_combined_delivery_note AS permission_combined_delivery_note_40,
  t0.permission_notification_rule AS permission_notification_rule_41,
  t0.permission_task_template AS permission_task_template_42,
  t0.permission_task AS permission_task_43,
  t0.permission_task_rule AS permission_task_rule_44,
  t0.permission_returns AS permission_returns_45,
  t0.permission_incoming_return AS permission_incoming_return_46,
  t0.permission_purchase_invoice AS permission_purchase_invoice_47,
  t0.permission_ticket AS permission_ticket_48,
  t0.permission_ticket_template AS permission_ticket_template_49,
  t0.permission_sales_lead AS permission_sales_lead_50,
  t0.permission_sales_lead_template AS permission_sales_lead_template_51,
  t0.permission_ticket_status AS permission_ticket_status_52,
  t0.permission_ticket_field AS permission_ticket_field_53,
  t0.permission_sales_lead_field AS permission_sales_lead_field_54,
  t0.permission_order_template AS permission_order_template_55,
  t0.permission_order_rule AS permission_order_rule_56,
  t0.permission_price_card_template AS permission_price_card_template_57,
  t0.permission_order_action AS permission_order_action_58,
  t0.permission_appointment_template AS permission_appointment_template_59,
  t0.permission_appointment_field AS permission_appointment_field_60,
  t0.permission_appointment AS permission_appointment_61,
  t0.permission_appointment_status AS permission_appointment_status_62,
  t0.permission_proposal_lead AS permission_proposal_lead_63,
  t0.permission_proposal_rejection_reason AS permission_proposal_rejection_reason_64,
  t0.permission_task_status AS permission_task_status_65,
  t0.permission_convert AS permission_convert_66,
  t0.permission_complaint_cause AS permission_complaint_cause_67,
  t0.permission_complaint_category AS permission_complaint_category_68,
  t0.permission_complaint AS permission_complaint_69,
  t0.permission_call_history AS permission_call_history_70,
  t0.permission_call_category AS permission_call_category_71,
  t0.permission_order_zero_price_reason AS permission_order_zero_price_reason_72,
  t0.permission_incoming_good_discrepancy_reason AS permission_incoming_good_discrepancy_reason_73,
  t0.permission_statistics AS permission_statistics_74,
  t0.permission_derived_product_rule AS permission_derived_product_rule_75,
  t0.permission_document_template AS permission_document_template_76,
  t0.permission_customer_note AS permission_customer_note_77,
  t0.permission_delivery_capacity AS permission_delivery_capacity_78,
  t0.permission_delivery_reservation AS permission_delivery_reservation_79,
  t0.permission_transport_calculation AS permission_transport_calculation_80,
  t0.created_by_user_id AS created_by_user_id_81,
  t0.modified_by_user_id AS modified_by_user_id_82
FROM
  user_group t0
  INNER JOIN user_group_user ON t0.id = user_group_user.user_group_id
WHERE
  user_group_user.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.shiftbase_identification AS shiftbase_identification_4, t0.create_date AS create_date_5, t0.modify_date AS modify_date_6, t0.is_deleted AS is_deleted_7, t0.permission_user AS permission_user_8, t0.permission_user_group AS permission_user_group_9, t0.permission_country AS permission_country_10, t0.permission_setting AS permission_setting_11, t0.permission_customer AS permission_customer_12, t0.permission_ledger AS permission_ledger_13, t0.permission_product_vat AS permission_product_vat_14, t0.permission_product_category AS permission_product_category_15, t0.permission_product_tag AS permission_product_tag_16, t0.permission_warehouse AS permission_warehouse_17, t0.permission_product_property_category AS permission_product_property_category_18, t0.permission_product_property AS permission_product_property_19, t0.permission_warehouse_location AS permission_warehouse_location_20, t0.permission_product_documentation AS permission_product_documentation_21, t0.permission_construction_drawing AS permission_construction_drawing_22, t0.permission_product AS permission_product_23, t0.permission_supplier AS permission_supplier_24, t0.permission_dossier AS permission_dossier_25, t0.permission_journal AS permission_journal_26, t0.permission_pay_method AS permission_pay_method_27, t0.permission_proposal AS permission_proposal_28, t0.permission_purchase AS permission_purchase_29, t0.permission_incoming_good AS permission_incoming_good_30, t0.permission_delivery_method AS permission_delivery_method_31, t0.permission_order AS permission_order_32, t0.permission_invoice AS permission_invoice_33, t0.permission_order_pick AS permission_order_pick_34, t0.permission_custom AS permission_custom_35, t0.permission_delivery_note AS permission_delivery_note_36, t0.permission_proposal_checklist AS permission_proposal_checklist_37, t0.permission_tailor AS permission_tailor_38, t0.permission_email_template AS permission_email_template_39, t0.permission_combined_delivery_note AS permission_combined_delivery_note_40, t0.permission_notification_rule AS permission_notification_rule_41, t0.permission_task_template AS permission_task_template_42, t0.permission_task AS permission_task_43, t0.permission_task_rule AS permission_task_rule_44, t0.permission_returns AS permission_returns_45, t0.permission_incoming_return AS permission_incoming_return_46, t0.permission_purchase_invoice AS permission_purchase_invoice_47, t0.permission_ticket AS permission_ticket_48, t0.permission_ticket_template AS permission_ticket_template_49, t0.permission_sales_lead AS permission_sales_lead_50, t0.permission_sales_lead_template AS permission_sales_lead_template_51, t0.permission_ticket_status AS permission_ticket_status_52, t0.permission_ticket_field AS permission_ticket_field_53, t0.permission_sales_lead_field AS permission_sales_lead_field_54, t0.permission_order_template AS permission_order_template_55, t0.permission_order_rule AS permission_order_rule_56, t0.permission_price_card_template AS permission_price_card_template_57, t0.permission_order_action AS permission_order_action_58, t0.permission_appointment_template AS permission_appointment_template_59, t0.permission_appointment_field AS permission_appointment_field_60, t0.permission_appointment AS permission_appointment_61, t0.permission_appointment_status AS permission_appointment_status_62, t0.permission_proposal_lead AS permission_proposal_lead_63, t0.permission_proposal_rejection_reason AS permission_proposal_rejection_reason_64, t0.permission_task_status AS permission_task_status_65, t0.permission_convert AS permission_convert_66, t0.permission_complaint_cause AS permission_complaint_cause_67, t0.permission_complaint_category AS permission_complaint_category_68, t0.permission_complaint AS permission_complaint_69, t0.permission_call_history AS permission_call_history_70, t0.permission_call_category AS permission_call_category_71, t0.permission_order_zero_price_reason AS permission_order_zero_price_reason_72, t0.permission_incoming_good_discrepancy_reason AS permission_incoming_good_discrepancy_reason_73, t0.permission_statistics AS permission_statistics_74, t0.permission_derived_product_rule AS permission_derived_product_rule_75, t0.permission_document_template AS permission_document_template_76, t0.permission_customer_note AS permission_customer_note_77, t0.permission_delivery_capacity AS permission_delivery_capacity_78, t0.permission_delivery_reservation AS permission_delivery_reservation_79, t0.permission_transport_calculation AS permission_transport_calculation_80, t0.created_by_user_id AS created_by_user_id_81, t0.modified_by_user_id AS modified_by_user_id_82 FROM user_group t0 INNER JOIN user_group_user ON t0.id = user_group_user.user_group_id WHERE user_group_user.user_id = 1;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  ticket t0_
  INNER JOIN ticket_log t1_ ON t0_.id = t1_.ticket_id
  LEFT JOIN ticket_log t2_ ON t0_.id = t2_.ticket_id
  AND (
    t0_.id = t2_.ticket_id
    AND t1_.id < t2_.id
    AND t1_.is_deleted = 0
  )
WHERE
  t2_.id IS NULL
  AND t0_.is_deleted = 0
  AND t1_.is_finished = 0
ORDER BY
  t1_.due_date ASC

SELECT COUNT(t0_.id) AS sclr_0 FROM ticket t0_ INNER JOIN ticket_log t1_ ON t0_.id = t1_.ticket_id LEFT JOIN ticket_log t2_ ON t0_.id = t2_.ticket_id AND (t0_.id = t2_.ticket_id AND t1_.id < t2_.id AND t1_.is_deleted = 0) WHERE t2_.id IS NULL AND t0_.is_deleted = 0 AND t1_.is_finished = 0 ORDER BY t1_.due_date ASC;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  ticket t0_
  INNER JOIN ticket_log t1_ ON t0_.id = t1_.ticket_id
  LEFT JOIN ticket_log t2_ ON t0_.id = t2_.ticket_id
  AND (
    t0_.id = t2_.ticket_id
    AND t1_.id < t2_.id
    AND t1_.is_deleted = 0
  )
WHERE
  t2_.id IS NULL
  AND t0_.is_deleted = 0
  AND t1_.is_finished = 0
  AND t1_.due_date IS NOT NULL
  AND t1_.due_date < ?

SELECT COUNT(t0_.id) AS sclr_0 FROM ticket t0_ INNER JOIN ticket_log t1_ ON t0_.id = t1_.ticket_id LEFT JOIN ticket_log t2_ ON t0_.id = t2_.ticket_id AND (t0_.id = t2_.ticket_id AND t1_.id < t2_.id AND t1_.is_deleted = 0) WHERE t2_.id IS NULL AND t0_.is_deleted = 0 AND t1_.is_finished = 0 AND t1_.due_date IS NOT NULL AND t1_.due_date < '2026-04-19 00:00:00';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  appointment a0_
  INNER JOIN appointment_log a1_ ON a0_.id = a1_.appointment_id
  LEFT JOIN appointment_log a2_ ON a0_.id = a2_.appointment_id
  AND (
    a0_.id = a2_.appointment_id
    AND a1_.id < a2_.id
    AND a1_.is_deleted = 0
  )
WHERE
  a2_.id IS NULL
  AND a0_.is_deleted = 0
  AND a1_.end > ?
  AND EXISTS (
    SELECT
      1
    FROM
      appointment_log_user a3_
    WHERE
      a3_.appointment_log_id = a1_.id
      AND a3_.user_id IN (?)
  )

SELECT COUNT(a0_.id) AS sclr_0 FROM appointment a0_ INNER JOIN appointment_log a1_ ON a0_.id = a1_.appointment_id LEFT JOIN appointment_log a2_ ON a0_.id = a2_.appointment_id AND (a0_.id = a2_.appointment_id AND a1_.id < a2_.id AND a1_.is_deleted = 0) WHERE a2_.id IS NULL AND a0_.is_deleted = 0 AND a1_.end > '2026-04-19 17:16:18' AND EXISTS (SELECT 1 FROM appointment_log_user a3_ WHERE a3_.appointment_log_id = a1_.id AND a3_.user_id IN (1));

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  appointment a0_
  INNER JOIN appointment_log a1_ ON a0_.id = a1_.appointment_id
  LEFT JOIN appointment_log a2_ ON a0_.id = a2_.appointment_id
  AND (
    a0_.id = a2_.appointment_id
    AND a1_.id < a2_.id
    AND a1_.is_deleted = 0
  )
WHERE
  a2_.id IS NULL
  AND a0_.is_deleted = 0
  AND a1_.end > ?
  AND a1_.start < ?
  AND EXISTS (
    SELECT
      1
    FROM
      appointment_log_user a3_
    WHERE
      a3_.appointment_log_id = a1_.id
      AND a3_.user_id IN (?)
  )

SELECT COUNT(a0_.id) AS sclr_0 FROM appointment a0_ INNER JOIN appointment_log a1_ ON a0_.id = a1_.appointment_id LEFT JOIN appointment_log a2_ ON a0_.id = a2_.appointment_id AND (a0_.id = a2_.appointment_id AND a1_.id < a2_.id AND a1_.is_deleted = 0) WHERE a2_.id IS NULL AND a0_.is_deleted = 0 AND a1_.end > '2026-04-19 17:16:18' AND a1_.start < '2026-04-19 00:00:00' AND EXISTS (SELECT 1 FROM appointment_log_user a3_ WHERE a3_.appointment_log_id = a1_.id AND a3_.user_id IN (1));