synex.uk / 127.0.0.1 / monitor_number / ap_accounts

There are no favorite tables.

New
agent_dashboard
dv_pro
genie_pg
information_schema
monitor_number
mysql
performance_schema
pg_dashboard
- pg_dashboard
- pg_dashboard_restore_test
phpmyadmin
sms_dashboard
superbrands_dashboard
telegram_dashboard
test

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (562 total, Query took 0.0007 seconds.) [raw_json: [BLOB - 702 B]... - [BLOB - 710 B]...]

SELECT * FROM `ap_accounts` ORDER BY `raw_json` DESC

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

Sort by key:

			id	account_key	account_no	account_name	bank_code	account_type	active	locked	group_name	alias	phone_number	inserted_at	inserted_at_raw	login_status	last_balance	agent_master	checker	checker_confirmed	checker_confirmed_by	checker_confirmed_at	telegram_message_id	is_current	raw_json 1	created_at	updated_at
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 83	83	91ce07b743fa922ddb41cafd733598d9a2015dbe731dc79061...	082123734111	TM-Temp-Balance-Nagad	NAGAD	W	N	No		TM-Temp-Balance-Nagad	082123734111	2025-03-26 15:59:16	2025-03-26 15:59:16	TM-Temp-Balance-Nagad	0.00		DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"082123734111","bankAccName":"TM-Temp...	2026-06-17 01:29:29	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 456	456	27ef932043a1b1008688d48e4a5ca34b50077505ea8ab0b907...	082123734111	TM-Temp-Balance-Bkash	BKASH	W	N	No		TM-Temp-Balance-Bkash	082123734111	2025-03-26 15:56:57	2025-03-26 15:56:57	TM-Temp-Balance-Bkash	0.00		DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"082123734111","bankAccName":"TM-Temp...	2026-06-17 01:29:31	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 193	193	654e9e6584f3cbeeeb384a15443d20cb1d148e8f22538d2435...	01997946055	TM593 - BKASH - 6055	BKASH	A	Y	No	Run By Dev	TM593 - BKASH - 6055	+8801997946055	2025-09-15 05:54:31	2025-09-15 05:54:31	123	44286.60	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01997946055","bankAccName":"TM593 - ...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 462	462	8b9cf27ba1380175b61bcf08f244cd0449f9549548310d2e78...	01997800014	TM600 - BKASH - 0014	BKASH	W	N	No	STOP_N	TM600 - BKASH - 0014	+8801997800014	2026-05-04 07:18:58	2026-05-04 07:18:58	123	18823.90	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01997800014","bankAccName":"TM600 - ...	2026-06-17 01:29:31	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 356	356	4cda24404534ce0715e5479b88faed94eaaebeb99a6bb09a34...	01994059066	TM396 - NAGAD - 9066	NAGAD	A	Y	No	Run By Dev	TM396 - NAGAD - 9066	+8801994059066	2025-01-09 05:51:11	2025-01-09 05:51:11	v_a	42962.40	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01994059066","bankAccName":"TM396 - ...	2026-06-17 01:29:30	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 233	233	fe3e9a2b20c61961eebbe9cb9a51717972cf00c91b906542dc...	01993849300	TM346 - NAGAD - 9300	NAGAD	A	Y	No	Run By Dev	TM346 - NAGAD - 9300	+8801993849300	2024-12-11 08:07:28	2024-12-11 08:07:28	123	10395.80	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01993849300","bankAccName":"TM346 - ...	2026-06-17 01:29:30	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 186	186	9ddcac76166f047727808171e5481ac0d9ae9f65a67461f5ff...	01993527104	TM583A - BKASH - 7104	BKASH	A	Y	No	Run By Dev	TM583A - BKASH - 7104	+8801993527104	2025-12-08 09:48:32	2025-12-08 09:48:32	123	218987.00	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01993527104","bankAccName":"TM583A -...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 388	388	71a0d1efed663bf3eb0cbfaedda3716d608ed9def977251f89...	01991512888	TM318 - NAGAD - 2888	NAGAD	A	Y	No	Run By Dev	TM318 - NAGAD - 2888	+8801991512888	2024-12-04 10:15:54	2024-12-04 10:15:54	123	34971.50	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01991512888","bankAccName":"TM318 - ...	2026-06-17 01:29:30	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 332	332	41056a5dd1125a473f7a2b83cbdce2b31102f84f4dfbb807af...	01991464104	TM591 - BKASH - 4104	BKASH	A	Y	No	Run By Dev	TM591 - BKASH - 4104	+8801991464104	2025-09-15 05:52:35	2025-09-15 05:52:35	123	73452.60	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01991464104","bankAccName":"TM591 - ...	2026-06-17 01:29:30	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 358	358	3cfb32ed4d73ec2f0208333e6a2ab78c13bd3595ee2b65f6a6...	01989071935	TM86H - BKASH - 1935	BKASH	W	N	No	STOP_N	TM86H - BKASH - 1935	+8801989071935	2026-02-27 05:09:44	2026-02-27 05:09:44	123	0.91	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01989071935","bankAccName":"TM86H - ...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 128	128	4d4753596fb7a09693537ddbc30443b8f418c196c2a12d8b76...	01985285881	TM109F - BKASH - 5881	BKASH	A	Y	No	Run By Dev	TM109F - BKASH - 5881	+8801985285881	2025-11-20 04:55:58	2025-11-20 04:55:58	123	221775.00	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01985285881","bankAccName":"TM109F -...	2026-06-17 01:29:30	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 200	200	469f33cd7b1e8845dd07402cc8f4514cc2143b50e6a4816df4...	01984801402	TM352 - NAGAD - 1402	NAGAD	A	Y	No	Run By Dev	TM352 - NAGAD - 1402	+8801984801402	2024-12-11 08:14:20	2024-12-11 08:14:20	123	25531.90	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01984801402","bankAccName":"TM352 - ...	2026-06-17 01:29:30	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 187	187	af43c27abe94e99e497f8085f8d1994761da1d0bf9a0a069d6...	01981674396	TM480B - BKASH - 4396	BKASH	W	Y	No	temporarily closed cash out bkash house issue	TM480B - BKASH - 4396	+8801981674396	2025-10-09 05:30:26	2025-10-09 05:30:26	123	298.01	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01981674396","bankAccName":"TM480B -...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 114	114	53b44401151a596a55b3cf09b3cf5ca85e04f5921b56a7b77f...	01981597248	TM231C - NAGAD - 7248	NAGAD	A	Y	No	Run By Dev	TM231C - NAGAD - 7248	+8801981597248	2026-06-13 07:01:59	2026-06-13 07:01:59	123	52119.40	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01981597248","bankAccName":"TM231C -...	2026-06-17 01:29:29	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 223	223	52b396faaa1446316532541ce276d6225c5452d9de943ed293...	01979712447	TM476D - BKASH - 2447	BKASH	W	N	No	Temporary close (Policce check)	TM476D - BKASH - 2447	+8801979712447	2026-04-04 08:40:05	2026-04-04 08:40:05	123	207672.00	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01979712447","bankAccName":"TM476D -...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 124	124	00b10b6354b6a0f98b68559e378e3d0f1e548a2b8ef7db4437...	01979523671	TM205B - NAGAD - 3671	NAGAD	A	Y	No	Run By Dev	TM205B - NAGAD - 3671	+8801979523671	2025-06-05 06:49:19	2025-06-05 06:49:19	123	20702.10	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01979523671","bankAccName":"TM205B -...	2026-06-17 01:29:30	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 1101	1101	43bcd8f498cb716aec75eaa8f2d9e8bdf65d2df9678e771dee...	01978876336	TM136 - NAGAD - 6336	NAGAD	A	Y	No	Run By Dev	TM136 - NAGAD - 6336	+8801978876336	2024-07-02 07:38:17	2024-07-02 07:38:17	123	6702.04	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01978876336","bankAccName":"TM136 - ...	2026-06-17 01:29:48	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 221	221	bf24f484ffc952c569df967fde716aac938c73d7bdd6094dff...	01978810188	TM305A - NAGAD - 0188	NAGAD	A	Y	No	Run By Dev	TM305A - NAGAD - 0188	+8801978810188	2025-05-15 07:08:42	2025-05-15 07:08:42	123	13459.50	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01978810188","bankAccName":"TM305A -...	2026-06-17 01:29:30	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 329	329	164c95a651281c8bac403cd335b09299b995ea98c5affd9eec...	01977840001	TM335 - NAGAD - 0001	NAGAD	A	Y	No	Run By Dev	TM335 - NAGAD - 0001	+8801977840001	2024-12-11 07:30:18	2024-12-11 07:30:18	123	23019.10	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01977840001","bankAccName":"TM335 - ...	2026-06-17 01:29:30	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 102	102	83478716aff93ccfd17cb0f70f5fe4dfa40e5af357f5dead9d...	01977549173	TM559C - BKASH - 9173	BKASH	A	Y	No	Run By Dev	TM559C - BKASH - 9173	+8801977549173	2026-06-02 13:10:39	2026-06-02 13:10:39	123	33658.00	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01977549173","bankAccName":"TM559C -...	2026-06-17 01:29:29	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 380	380	2997d202e92539679138fb1e2681a87396011b61b1f0590a58...	01976318256	TM277B - BKASH - 8256	BKASH	W	N	No	STOP_N	TM277B - BKASH - 8256	+8801976318256	2025-12-02 09:24:02	2025-12-02 09:24:02	123	3796.57	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01976318256","bankAccName":"TM277B -...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 420	420	651bcc179e14f11a203dbd53076a641efc948124cc97480003...	01976124527	TM566B - BKASH - 4527	BKASH	A	Y	No	Run By Dev	TM566B - BKASH - 4527	+8801976124527	2025-09-23 09:00:35	2025-09-23 09:00:35	123	45598.60	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01976124527","bankAccName":"TM566B -...	2026-06-17 01:29:31	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 519	519	acbcf4d7f8d48947947cb912c1d0a67583bbf3512ac6ee69e2...	01974933103	TM581B - BKASH - 3103	BKASH	A	Y	No	Run By Dev	TM581B - BKASH - 3103	+8801974933103	2025-09-23 09:01:34	2025-09-23 09:01:34	123	65515.20	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01974933103","bankAccName":"TM581B -...	2026-06-17 01:29:31	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 37	37	55e729ea2172af18b2dbe2692d790764215eb6311f754c1ca3...	01974659348	TM84B - NAGAD - 9348	NAGAD	A	Y	No	Run By Dev	TM84B - NAGAD - 9348	+8801974659348	2025-11-05 09:48:39	2025-11-05 09:48:39	123	128565.00	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01974659348","bankAccName":"TM84B - ...	2026-06-17 01:29:29	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 58	58	b19f71e75f9e08754b394f38e3b58b0642a25d5b2541c0cd60...	01974657848	TM363B - NAGAD - 7848	NAGAD	A	Y	No	Run By Dev	TM363B - NAGAD - 7848	+8801974657848	2025-10-22 07:09:27	2025-10-22 07:09:27	123	241566.00	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01974657848","bankAccName":"TM363B -...	2026-06-17 01:29:29	2026-06-20 21:36:20

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view