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.0036 seconds.) [inserted_at_raw: 2026-06-18 08:12:06... - 2026-05-04 07:16:27...]

SELECT * FROM `ap_accounts` ORDER BY `inserted_at_raw` 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 1	login_status	last_balance	agent_master	checker	checker_confirmed	checker_confirmed_by	checker_confirmed_at	telegram_message_id	is_current	raw_json	created_at	updated_at
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 229520	229520	29b73c80f6b2c75a77d933e7222e8416c003eba80f94af795e...	01846923531	TM386C - BKASH - 3531	BKASH	A	Y	No		TM386C - BKASH - 3531	+8801846923531	2026-06-18 08:12:06	2026-06-18 08:12:06	123	0.00		DV	1	system_known_number	2026-06-18 15:31:24	868	1	{"bankAccNo":"01846923531","bankAccName":"TM386C -...	2026-06-18 15:15:43	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 148	148	ca065fdd46e0fa78d9a7b0c7674a32427abd90a3f4a1dd2629...	01347383246	TM224C - BKASH - 3246	BKASH	A	Y	No	Run BY Dev	TM224C - BKASH - 3246	+8801347383246	2026-06-15 07:34:19	2026-06-15 07:34:19	123	71258.10	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01347383246","bankAccName":"TM224C -...	2026-06-17 01:29:30	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 38	38	1adf4080b1f72b109c3985e5afb773fc7b863c88f29b014bda...	01625479849	TM289D - NAGAD - 9849	NAGAD	A	Y	No	Run By Dev	TM289D - NAGAD - 9849	+8801625479849	2026-06-15 07:33:12	2026-06-15 07:33:12	123	178460.00	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01625479849","bankAccName":"TM289D -...	2026-06-17 01:29:29	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` = 409	409	c1605f11643d8d5efb9017bd1b7482ef0b741794379cd4e3b2...	01938679824	TM509E - BKASH - 9824	BKASH	A	Y	No	Run by Dev	TM509E - BKASH - 9824	+8801938679824	2026-06-13 07:00:49	2026-06-13 07:00:49	123	132146.00	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01938679824","bankAccName":"TM509E -...	2026-06-17 01:29:31	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 178	178	b57bb57b771d8c5f3c7bab264bd87c1eb7649674cf1b1d4703...	01755691768	TM181E - BKASH - 1768	BKASH	A	Y	No	Run By dev	TM181E - BKASH - 1768	+8801755691768	2026-06-13 06:59:33	2026-06-13 06:59:33	123	62577.20	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01755691768","bankAccName":"TM181E -...	2026-06-17 01:29:30	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 72	72	5ad8f00b8b72547f8d239e151113e82819967d9dc3e97cb969...	01622123264	TM57B - NAGAD - 3264	NAGAD	A	Y	No	Run By Dev	TM57B - NAGAD - 3264	+8801622123264	2026-06-13 06:58:28	2026-06-13 06:58:28	123	211236.00	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01622123264","bankAccName":"TM57B - ...	2026-06-17 01:29:29	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 445	445	ffe1519f559215e0fdff98a9a3517c5115a03074b035ae9939...	01968067262	TM112J - BKASH - 7262	BKASH	A	Y	No	Run By Dev	TM112J - BKASH - 7262	+8801968067262	2026-06-03 10:23:43	2026-06-03 10:23:43	123	63467.50	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01968067262","bankAccName":"TM112J -...	2026-06-17 01:29:31	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` = 277	277	852fb470146839707c2a2feec6c34ae818e18ca1fd4b0afa4f...	01345913366	TM588A - BKASH - 3366	BKASH	A	Y	No	Run By dev	TM588A - BKASH - 3366	+8801345913366	2026-06-02 13:09:39	2026-06-02 13:09:39	123	189007.00	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01345913366","bankAccName":"TM588A -...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 211	211	cc7427d3b9d5fdc148ca07a5d7dfe8e903c682a004690703d8...	01403810046	TM364A - NAGAD - 0046	NAGAD	A	Y	No	Run By Dev	TM364A - NAGAD - 0046	+8801403810046	2026-06-02 09:00:50	2026-06-02 09:00:50	123	124550.00	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01403810046","bankAccName":"TM364A -...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 508	508	711659997a1a154bc48c12c23853f05bce87b08eb4a465f02b...	01405986707	TM419A - NAGAD - 6707	NAGAD	A	Y	No	Run By Dev	TM419A - NAGAD - 6707	+8801405986707	2026-06-02 08:59:36	2026-06-02 08:59:36	123	59612.50	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01405986707","bankAccName":"TM419A -...	2026-06-17 01:29:31	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 135	135	299003f0f9b58bafdc5a4b9a4ac95effa29fe18625a0edc70e...	01341747629	TM402C - NAGAD - 7629	NAGAD	A	Y	No	Run By Dev	TM402C - NAGAD - 7629	+8801341747629	2026-06-02 08:58:19	2026-06-02 08:58:19	123	170233.00	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01341747629","bankAccName":"TM402C -...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 475	475	5f4ad132fdcfcc7201385936c0df05c450482699b94cfc1b05...	01341747627	TM330A - NAGAD - 7627	NAGAD	A	Y	No	Run By Dev	TM330A - NAGAD - 7627	+8801341747627	2026-06-02 08:56:04	2026-06-02 08:56:04	123	114785.00	Amirul	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01341747627","bankAccName":"TM330A -...	2026-06-17 01:29:31	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 312	312	09ed1d902e0300ff3d7a85776e41679d3a9b5a4895112e92c4...	01920135399	TM111H - BKASH - 5399	BKASH	A	Y	No	Run By Dev	TM111H - BKASH - 5399	+8801920135399	2026-06-02 08:09:19	2026-06-02 08:09:19	123	19514.20	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01920135399","bankAccName":"TM111H -...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 167	167	b4ba206981cbb88b77ea3898bf265043681ce1bb2d4d40b630...	01401282280	TM274F - BKASH - 2280	BKASH	A	Y	No	Run By Dev	TM274F - BKASH - 2280	+8801401282280	2026-05-19 03:53:54	2026-05-19 03:53:54	123	33745.40	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01401282280","bankAccName":"TM274F -...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 531	531	f7428054f4cd1c654d4cd62e9410ce604a65037d73def1b626...	01813442257	TM450D - BKASH - 2257	BKASH	W	N	No	STOP_N	TM450D - BKASH - 2257	+8801813442257	2026-05-18 08:43:00	2026-05-18 08:43:00	123	159.64	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01813442257","bankAccName":"TM450D -...	2026-06-17 01:29:31	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 340	340	929bce16f45b652a6cf91345ca2b6488fc80efde6402928314...	01305789436	TM178i - BKASH - 9436	BKASH	A	Y	No	Run By Dev	TM178i - BKASH - 9436	+8801305789436	2026-05-16 12:16:00	2026-05-16 12:16:00	123	222562.00	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01305789436","bankAccName":"TM178i -...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 11	11	88db09ebc40ba930fff7bd32bf2ab0f058f72cb62ef5121d53...	01342379634	TM503G - BKASH - 9634	BKASH	W	N	No	STOP_N	TM503G - BKASH - 9634	+8801342379634	2026-05-12 06:04:33	2026-05-12 06:04:33	123	0.00	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01342379634","bankAccName":"TM503G -...	2026-06-17 01:29:29	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 400	400	41a2a123fe88837faf6bb9c3d4a31da374143b0f0fd67f5d0a...	01707740575	TM599A - BKASH - 0575	BKASH	W	N	No	STOP_N	TM599A - BKASH - 0575	+8801707740575	2026-05-06 08:53:16	2026-05-06 08:53:16	123	219823.00	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01707740575","bankAccName":"TM599A -...	2026-06-17 01:29:30	2026-06-20 21:36:21
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 294	294	72defa3a9070ada9d356d42625c1981cda436fe1a05a68d2f4...	01805416729	TM517D - BKASH - 6729	BKASH	W	N	No	STOP_N	TM517D - BKASH - 6729	+8801805416729	2026-05-06 08:51:52	2026-05-06 08:51:52	123	456.37	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01805416729","bankAccName":"TM517D -...	2026-06-17 01:29:30	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 55	55	720071d48265382e5e6b9ee48777f4d6cd0a2797cbed9102f5...	01843036352	TM385E - BKASH - 6352	BKASH	A	Y	No	Run By Dev	TM385E - BKASH - 6352	+8801843036352	2026-05-04 09:16:34	2026-05-04 09:16:34	123	25682.10	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01843036352","bankAccName":"TM385E -...	2026-06-17 01:29:29	2026-06-20 21:36:20
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` = 89	89	3121b5445edce368168dcf1547dce007c8c2d274d4dcbc4de1...	01338569069	TM297D - NAGAD - 9069	NAGAD	A	Y	No	Run By Dev	TM297D - NAGAD - 9069	+8801338569069	2026-05-04 07:17:51	2026-05-04 07:17:51	123	93950.20	Jason	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01338569069","bankAccName":"TM297D -...	2026-06-17 01:29:29	2026-06-20 21:36:20
Edit	Copy	Delete DELETE FROM ap_accounts WHERE `ap_accounts`.`id` = 434	434	3215fe85f764c96064d22406376ed869186be2342143238ace...	01825970881	TM513G - BKASH - 0881	BKASH	A	N	No	Otp issue	TM513G - BKASH - 0881	+8801825970881	2026-05-04 07:16:27	2026-05-04 07:16:27	123	92606.00	Eddie	DV	1	system_known_number	2026-06-17 01:29:48	NULL	1	{"bankAccNo":"01825970881","bankAccName":"TM513G -...	2026-06-17 01:29:31	2026-06-20 21:36:21

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view