Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id bigint(20)
session_uuid char(36) ascii_bin
employee_id int(10)
user_id smallint(5)
device_id bigint(20)
device_uuid varchar(80) utf8mb4_unicode_ci
branch_id int(10)
finance_year_id int(10)
company_id int(10)
employee_context varchar(20) utf8mb4_unicode_ci
policy_version int(10)
policy_snapshot_json longtext utf8mb4_unicode_ci
started_at datetime(3)
ended_at datetime(3)
authorized_until datetime(3)
start_latitude decimal(10,7)
start_longitude decimal(10,7)
start_accuracy decimal(10,2)
end_latitude decimal(10,7)
end_longitude decimal(10,7)
end_accuracy decimal(10,2)
status varchar(20) utf8mb4_unicode_ci
active_employee_id int(10)
last_location_at datetime(3)
last_received_at datetime(3)
last_point_id bigint(20)
total_distance_meters decimal(14,2)
total_active_seconds int(10)
total_idle_seconds int(10)
total_visits int(10)
summary_state varchar(20) utf8mb4_unicode_ci
summary_version int(10)
created_at datetime(3)
updated_at datetime(3)