| 1 |
0.83 ms |
SELECT t0.id AS id_1, t0.reply_to AS reply_to_2, t0.ticket_marker_hash AS ticket_marker_hash_3, t0.title AS title_4, t0.email AS email_5, t0.attachments AS attachments_6, t0.phone AS phone_7, t0.name AS name_8, t0.ticket_body AS ticket_body_9, t0.preferred_contact_method AS preferred_contact_method_10, t0.ticket_reply_data AS ticket_reply_data_11, t0.ticket_assigned_date AS ticket_assigned_date_12, t0.ticket_expiry_date AS ticket_expiry_date_13, t0.assigned_to_user_id AS assigned_to_user_id_14, t0.assigned_by_user_id AS assigned_by_user_id_15, t0.assigned_by_client_id AS assigned_by_client_id_16, t0.assigned_by_supplier_id AS assigned_by_supplier_id_17, t0.user_id AS user_id_18, t0.tagged_user_ids AS tagged_user_ids_19, t0.app_id AS app_id_20, t0.company_id AS company_id_21, t0.entity AS entity_22, t0.entity_id AS entity_id_23, t0.meeting_id AS meeting_id_24, t0.applicant_id AS applicant_id_25, t0.type AS type_26, t0.flag AS flag_27, t0.status AS status_28, t0.expired AS expired_29, t0.urgency AS urgency_30, t0.document_hash AS document_hash_31, t0.note AS note_32, t0.deadline_date AS deadline_date_33, t0.expected_start_ts AS expected_start_ts_34, t0.expected_end_ts AS expected_end_ts_35, t0.expected_duration_min AS expected_duration_min_36, t0.actual_start_ts AS actual_start_ts_37, t0.actual_end_ts AS actual_end_ts_38, t0.location_type AS location_type_39, t0.lat AS lat_40, t0.lng AS lng_41, t0.branch_id AS branch_id_42, t0.working_status AS working_status_43, t0.approved AS approved_44, t0.expire_ts AS expire_ts_45, t0.reason_type AS reason_type_46, t0.feedback AS feedback_47, t0.is_recurring AS is_recurring_48, t0.is_recurring_parent AS is_recurring_parent_49, t0.recurring_parent_id AS recurring_parent_id_50, t0.is_recurring_perpetual AS is_recurring_perpetual_51, t0.recurring_type AS recurring_type_52, t0.recurring_values AS recurring_values_53, t0.recurring_ends_ts AS recurring_ends_ts_54, t0.recurring_condition AS recurring_condition_55, t0.achievable_target_value AS achievable_target_value_56, t0.achievable_target_type AS achievable_target_type_57, t0.target_increase_value AS target_increase_value_58, t0.target_increase_type AS target_increase_type_59, t0.created_at AS created_at_60, t0.updated_at AS updated_at_61, t0.doc_booked_flag AS doc_booked_flag_62, t0.time_stamp_of_form AS time_stamp_of_form_63, t0.ticket_number AS ticket_number_64, t0.source AS source_65, t0.system_created AS system_created_66, t0.problem_hash AS problem_hash_67, t0.report_count AS report_count_68, t0.first_reported_at AS first_reported_at_69, t0.last_reported_at AS last_reported_at_70, t0.last_payload_json AS last_payload_json_71, t0.server_identifier AS server_identifier_72, t0.resolved_at AS resolved_at_73, t0.closed_at AS closed_at_74 FROM entity_ticket t0 WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.reply_to AS reply_to_2,
t0.ticket_marker_hash AS ticket_marker_hash_3,
t0.title AS title_4,
t0.email AS email_5,
t0.attachments AS attachments_6,
t0.phone AS phone_7,
t0.name AS name_8,
t0.ticket_body AS ticket_body_9,
t0.preferred_contact_method AS preferred_contact_method_10,
t0.ticket_reply_data AS ticket_reply_data_11,
t0.ticket_assigned_date AS ticket_assigned_date_12,
t0.ticket_expiry_date AS ticket_expiry_date_13,
t0.assigned_to_user_id AS assigned_to_user_id_14,
t0.assigned_by_user_id AS assigned_by_user_id_15,
t0.assigned_by_client_id AS assigned_by_client_id_16,
t0.assigned_by_supplier_id AS assigned_by_supplier_id_17,
t0.user_id AS user_id_18,
t0.tagged_user_ids AS tagged_user_ids_19,
t0.app_id AS app_id_20,
t0.company_id AS company_id_21,
t0.entity AS entity_22,
t0.entity_id AS entity_id_23,
t0.meeting_id AS meeting_id_24,
t0.applicant_id AS applicant_id_25,
t0.type AS type_26,
t0.flag AS flag_27,
t0.status AS status_28,
t0.expired AS expired_29,
t0.urgency AS urgency_30,
t0.document_hash AS document_hash_31,
t0.note AS note_32,
t0.deadline_date AS deadline_date_33,
t0.expected_start_ts AS expected_start_ts_34,
t0.expected_end_ts AS expected_end_ts_35,
t0.expected_duration_min AS expected_duration_min_36,
t0.actual_start_ts AS actual_start_ts_37,
t0.actual_end_ts AS actual_end_ts_38,
t0.location_type AS location_type_39,
t0.lat AS lat_40,
t0.lng AS lng_41,
t0.branch_id AS branch_id_42,
t0.working_status AS working_status_43,
t0.approved AS approved_44,
t0.expire_ts AS expire_ts_45,
t0.reason_type AS reason_type_46,
t0.feedback AS feedback_47,
t0.is_recurring AS is_recurring_48,
t0.is_recurring_parent AS is_recurring_parent_49,
t0.recurring_parent_id AS recurring_parent_id_50,
t0.is_recurring_perpetual AS is_recurring_perpetual_51,
t0.recurring_type AS recurring_type_52,
t0.recurring_values AS recurring_values_53,
t0.recurring_ends_ts AS recurring_ends_ts_54,
t0.recurring_condition AS recurring_condition_55,
t0.achievable_target_value AS achievable_target_value_56,
t0.achievable_target_type AS achievable_target_type_57,
t0.target_increase_value AS target_increase_value_58,
t0.target_increase_type AS target_increase_type_59,
t0.created_at AS created_at_60,
t0.updated_at AS updated_at_61,
t0.doc_booked_flag AS doc_booked_flag_62,
t0.time_stamp_of_form AS time_stamp_of_form_63,
t0.ticket_number AS ticket_number_64,
t0.source AS source_65,
t0.system_created AS system_created_66,
t0.problem_hash AS problem_hash_67,
t0.report_count AS report_count_68,
t0.first_reported_at AS first_reported_at_69,
t0.last_reported_at AS last_reported_at_70,
t0.last_payload_json AS last_payload_json_71,
t0.server_identifier AS server_identifier_72,
t0.resolved_at AS resolved_at_73,
t0.closed_at AS closed_at_74
FROM
entity_ticket t0
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.reply_to AS reply_to_2, t0.ticket_marker_hash AS ticket_marker_hash_3, t0.title AS title_4, t0.email AS email_5, t0.attachments AS attachments_6, t0.phone AS phone_7, t0.name AS name_8, t0.ticket_body AS ticket_body_9, t0.preferred_contact_method AS preferred_contact_method_10, t0.ticket_reply_data AS ticket_reply_data_11, t0.ticket_assigned_date AS ticket_assigned_date_12, t0.ticket_expiry_date AS ticket_expiry_date_13, t0.assigned_to_user_id AS assigned_to_user_id_14, t0.assigned_by_user_id AS assigned_by_user_id_15, t0.assigned_by_client_id AS assigned_by_client_id_16, t0.assigned_by_supplier_id AS assigned_by_supplier_id_17, t0.user_id AS user_id_18, t0.tagged_user_ids AS tagged_user_ids_19, t0.app_id AS app_id_20, t0.company_id AS company_id_21, t0.entity AS entity_22, t0.entity_id AS entity_id_23, t0.meeting_id AS meeting_id_24, t0.applicant_id AS applicant_id_25, t0.type AS type_26, t0.flag AS flag_27, t0.status AS status_28, t0.expired AS expired_29, t0.urgency AS urgency_30, t0.document_hash AS document_hash_31, t0.note AS note_32, t0.deadline_date AS deadline_date_33, t0.expected_start_ts AS expected_start_ts_34, t0.expected_end_ts AS expected_end_ts_35, t0.expected_duration_min AS expected_duration_min_36, t0.actual_start_ts AS actual_start_ts_37, t0.actual_end_ts AS actual_end_ts_38, t0.location_type AS location_type_39, t0.lat AS lat_40, t0.lng AS lng_41, t0.branch_id AS branch_id_42, t0.working_status AS working_status_43, t0.approved AS approved_44, t0.expire_ts AS expire_ts_45, t0.reason_type AS reason_type_46, t0.feedback AS feedback_47, t0.is_recurring AS is_recurring_48, t0.is_recurring_parent AS is_recurring_parent_49, t0.recurring_parent_id AS recurring_parent_id_50, t0.is_recurring_perpetual AS is_recurring_perpetual_51, t0.recurring_type AS recurring_type_52, t0.recurring_values AS recurring_values_53, t0.recurring_ends_ts AS recurring_ends_ts_54, t0.recurring_condition AS recurring_condition_55, t0.achievable_target_value AS achievable_target_value_56, t0.achievable_target_type AS achievable_target_type_57, t0.target_increase_value AS target_increase_value_58, t0.target_increase_type AS target_increase_type_59, t0.created_at AS created_at_60, t0.updated_at AS updated_at_61, t0.doc_booked_flag AS doc_booked_flag_62, t0.time_stamp_of_form AS time_stamp_of_form_63, t0.ticket_number AS ticket_number_64, t0.source AS source_65, t0.system_created AS system_created_66, t0.problem_hash AS problem_hash_67, t0.report_count AS report_count_68, t0.first_reported_at AS first_reported_at_69, t0.last_reported_at AS last_reported_at_70, t0.last_payload_json AS last_payload_json_71, t0.server_identifier AS server_identifier_72, t0.resolved_at AS resolved_at_73, t0.closed_at AS closed_at_74 FROM entity_ticket t0 WHERE t0.id = '362';
|