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 :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `alzily_menus` ORDER BY `route` ASC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id name slug icon route Ascending Descending 1 url parent_id sort_order is_active is_dropdown permission description created_at updated_at
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 2
2 Pengajuan pengajuan plus NULL NULL NULL 2 1 1 NULL Menu pengajuan cuti dan lembur 2025-09-15 06:49:51 2025-09-15 06:49:51
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 5
5 Approval approval check NULL NULL NULL 3 1 1 NULL Menu approval cuti dan lembur 2025-09-15 06:49:51 2025-09-15 06:49:51
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 8
8 Work Flow workflow workflow NULL NULL NULL 5 1 1 NULL Menu workflow cuti dan lembur 2025-09-15 06:49:51 2025-09-15 06:49:51
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 11
11 Master master settings NULL NULL NULL 5 1 1 NULL Menu master data 2025-09-15 06:49:51 2025-09-15 06:49:51
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 15
15 Dash Management laporan chart NULL NULL NULL 7 1 1 NULL Menu laporan cuti dan lembur 2025-09-15 06:49:51 2025-09-15 06:49:51
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 24
24 Presensi Online presensi-online users NULL # NULL 6 0 1 NULL Menu utama untuk presensi online 2025-09-15 07:40:25 2025-09-15 07:40:25
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 32
32 License license settings NULL # NULL 11 1 1 super_admin Menu untuk manajemen license sistem 2025-09-15 23:44:00 2025-09-16 20:31:39
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 91
91 Presensi presensi-multi clock NULL # NULL 4 1 1 NULL Menu utama untuk presensi multi shift 2025-10-08 12:09:37 2025-10-08 12:09:37
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 101
101 KPI kpi trending-up NULL # NULL 8 1 1 NULL Menu Key Performance Indicators (Indikator Kinerja... 2025-10-09 08:05:53 2025-10-12 22:08:27
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 118
118 Pelayanan pelayanan medical-cross NULL # NULL 9 1 1 NULL Menu Pelayanan Medis 2025-10-25 21:54:16 2025-10-25 21:54:16
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 6
6 Approval Cuti approval-cuti check-circle approval-cuti.index NULL 5 1 1 0 NULL Approval pengajuan cuti 2025-09-15 06:49:51 2025-09-15 06:49:51
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 9
9 WF Cuti approval-workflow workflow approval-workflow.index NULL 8 1 1 0 NULL Workflow approval cuti 2025-09-15 06:49:51 2025-09-15 06:49:51
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 18
18 Ubah Atasan Langsung atasan-langsung users atasan-langsung.index NULL NULL 9 1 0 NULL Ubah atasan langsung pegawai 2025-09-15 06:49:51 2025-09-16 20:31:39
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 47
47 Workflow Invoice invoice-workflow workflow invoice-workflow.index NULL 8 5 1 0 NULL Workflow Invoice menu 2025-09-23 18:50:27 2025-09-23 18:50:27
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 46
46 Approval Invoice invoice-approval check-circle invoice.approval NULL 5 4 1 0 NULL Approval Invoice menu 2025-09-23 14:26:59 2025-09-23 14:26:59
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 45
45 Pengajuan Invoice invoice-list plus invoice.index NULL 2 4 0 0 NULL Daftar Invoice menu 2025-09-23 14:26:59 2025-09-23 14:26:59
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 94
94 Jadwal Kerja jadwal-kerja-multi-presensi clock jadwal-kerja-multi.index NULL 91 3 1 0 NULL Submenu Jadwal Kerja Multi untuk Presensi Multi 2025-10-08 12:11:02 2025-10-08 12:11:02
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 27
27 Jadwal Kerja jadwal-kerja circle jadwal-kerja.index NULL 24 4 0 0 NULL Jadwal Kerja menu 2025-09-15 07:40:25 2025-09-16 19:59:38
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 81
81 Jatah Cuti Tahunan jatah-cuti fas fa-calendar-check jatah-cuti.index jatah-cuti 11 10 1 0 NULL NULL 2025-09-27 18:58:59 2025-09-27 18:58:59
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 42
42 Jenis PO jenis-po workflow jenis-po.index NULL 8 4 1 0 NULL Kelola jenis PO 2025-09-19 23:39:32 2025-09-20 00:13:20
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 107
107 Kalender KPI kalender-kpi calendar kpi.activities.calendar NULL 101 9 0 0 NULL NULL 2025-10-09 13:47:46 2025-10-09 13:47:46
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 108
108 Kalender kalender calendar kpi.activities.calendar NULL 103 4 1 0 NULL NULL 2025-10-09 13:47:46 2025-10-09 13:47:46
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 103
103 Aktivitas KPI kpi-activities activity kpi.activities.index NULL 101 2 1 0 NULL Kelola aktivitas KPI harian 2025-10-09 08:05:53 2025-10-09 08:05:53
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 111
111 Persetujuan KPI kpi-approval check-circle kpi.approval.index /kpi/approval 101 5 1 0 manager Persetujuan dan penilaian aktivitas KPI bawahan 2025-10-12 18:53:37 2025-10-12 22:23:48
Edit Edit Copy Copy Delete Delete
DELETE FROM alzily_menus WHERE `alzily_menus`.`id` = 102
102 Dashboard KPI kpi-dashboard dashboard kpi.dashboard NULL 101 1 1 0 NULL Dashboard untuk melihat statistik KPI 2025-10-09 08:05:53 2025-10-09 08:05:53
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query