synex.uk / 127.0.0.1 / monitor_number / ct_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 (4824 total, Query took 0.0438 seconds.) [remote_id: 4422957... - 4421937...]

SELECT * FROM `ct_accounts` ORDER BY `remote_id` DESC

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

Filter rows:

			id	account_key	remote_id 1	bank_name	account_reference	bank_reference	account_holder_name	customer_name	account_status	created_date	updated_date	updated_by	created_by	email	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 ct_accounts WHERE `ct_accounts`.`id` = 52435	52435	c2b5e79a05487bccda598b32f274b583b7998eb8e7dadb57cb...	4422957	Bkash Personal Payment	01831904472	SMB018	01831904472-SMBKASH	SM69A-*SMB\|SMN ! MA69	1	1781959095642	1781960154143	admin	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 19:48:44	1715	1	{"accountHolderName":"01831904472-SMBKASH","accoun...	2026-06-20 19:40:05	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 52436	52436	a869c0b5d487e8d58c82d7459d57a2b3507241fa962c95df55...	4422955	Nagad Personal Payment	01831904472	SMN018	01831904472-SMNAGAD	SM69A-*SMB\|SMN ! MA69	1	1781959050957	1781966010836	admin	Ctbot034	[email protected]	DV	1	system_known_number	2026-06-20 19:40:05	NULL	1	{"accountHolderName":"01831904472-SMNAGAD","accoun...	2026-06-20 19:40:05	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 51866	51866	b7858ce4c78077c56f1a52cf8f177b9ee4a9d6dabaca35b450...	4422861	Nagad Personal Payment	01341844296	SMN013	01341844296-SMNAGAD	SM02AF-SMN 24/7 V3	1	1781955619974	1781957457382	NivBDT	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 19:48:43	1696	1	{"accountHolderName":"01341844296-SMNAGAD","accoun...	2026-06-20 18:41:13	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 51140	51140	34d03f76132f21e363f4204db5b9e365414e907caa11c2d84b...	4422755	Bkash Payment	01891766323	B018	01891766323-BKASH	CT07L-BKASH ! MA07	0	1781950892935	1781966011235	phaBDT	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 19:48:39	1691	1	{"accountHolderName":"01891766323-BKASH","accountR...	2026-06-20 17:25:48	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 50954	50954	e13fb14ff900b234c3a7b2b8e590a29a3316f163ff082c2953...	4422721	Rocket Personal Payment	017378059354	SMR017	017378059354-SMROCKET	SM13C-SMB\|SMR 24/7 MA13	1	1781949544361	1781962889178	admin	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 17:16:04	1670	1	{"accountHolderName":"017378059354-SMROCKET","acco...	2026-06-20 17:07:54	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 50955	50955	2fc8fb755c8ed753aa38670c2bd9fc9a0a4eb6310ed9674d83...	4422718	Bkash Personal Payment	01737805935	SMB017	01737805935-SMBKASH	SM13C-SMB\|SMR 24/7 MA13	1	1781949505752	1781962883360	admin	Ctbot034	[email protected]	DV	1	system_known_number	2026-06-20 17:07:54	NULL	1	{"accountHolderName":"01737805935-SMBKASH","accoun...	2026-06-20 17:07:54	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 50871	50871	5513d35f4cb491eed2319d4dfcf3b38403599b74932b0e98ae...	4422715	Upay Personal Payment	01737805935	SMU017	01737805935-SMUPAY	SM13C-SMB\|SMR 24/7 MA13	1	1781949434197	1781962877320	admin	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 17:16:03	1669	1	{"accountHolderName":"01737805935-SMUPAY","account...	2026-06-20 16:58:57	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 49801	49801	750a35493fe57a29f36189d5145fb06e0fa7a691beea25d1e1...	4422557	Bkash Merchant Payment	01865278728	MPB018	01865278728-BKASH	MP60A-B-JAHANGIR STORE 24/7 MA60	1	1781942145738	1781963887383	admin	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 19:48:38	1647	1	{"accountHolderName":"01865278728-BKASH","accountR...	2026-06-20 15:05:02	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 49477	49477	d4d63b5933e8f49b9abdb5b380e852b9cd201eddb2c02a6e13...	4422523	Nagad Personal Payment	01315131778	SMN013	01315131778-SMNAGAD	SM139-SMB\|SMN\|SMR\|SMU ! MA139	0	1781940932301	1781965859781	SouvearinBDT	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 14:51:12	1630	1	{"accountHolderName":"01315131778-SMNAGAD","accoun...	2026-06-20 14:36:16	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 49478	49478	a46ba822afd251181b5a3deef20eae1d42e2b65d661ddce2a2...	4422522	Bkash Personal Payment	01315131778	SMB013	01315131778-SMBKASH	SM139-SMB\|SMN\|SMR\|SMU ! MA139	0	1781940909472	1781965908977	SouvearinBDT	Ctbot034	[email protected]	DV	1	system_known_number	2026-06-20 14:36:16	NULL	1	{"accountHolderName":"01315131778-SMBKASH","accoun...	2026-06-20 14:36:16	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 49479	49479	4deca3b41e55f9204a7e48e695a18f92c7a2e93bf6c872ddd0...	4422519	Rocket Personal Payment	013151317786	SMR013	013151317786-SMROCKET	SM139-SMB\|SMN\|SMR\|SMU ! MA139	0	1781940897416	1781965839841	SouvearinBDT	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 14:51:13	1631	1	{"accountHolderName":"013151317786-SMROCKET","acco...	2026-06-20 14:36:16	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 49480	49480	55b977e4f440b5c67e26d27c4be52d50517041e93e0aa2df75...	4422518	Upay Personal Payment	01315131778	SMU013	01315131778-SMUPAY	SM139-SMB\|SMN\|SMR\|SMU ! MA139	0	1781940885405	1781965834584	SouvearinBDT	Ctbot034	[email protected]	DV	1	system_known_number	2026-06-20 14:36:16	NULL	1	{"accountHolderName":"01315131778-SMUPAY","account...	2026-06-20 14:36:16	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 48469	48469	8e76c6d97a6c846c819fb42aa19dca029bff38e185704fb144...	4422300	UPay Payment	01703868161	U017	01703868161-UPAY	CT76C-BKASH\|NAGAD\|UPAY 24/7 MA76	1	1781935003572	1781954529737	phaBDT	Ctbot034	[email protected]	DV	1	system_known_number	2026-06-20 13:03:19	NULL	1	{"accountHolderName":"01703868161-UPAY","accountRe...	2026-06-20 13:03:19	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 48010	48010	ffcefdbb02a942114fa52eca3a136a8220f03cbf9fa57b8806...	4422202	Bkash Personal Payment	01346181916	SMB013	01346181916-SMBKASH	SM77-SMB\|SMN\|SMR\|SMU ! MA77	1	1781932750940	1781963197302	admin	Ctbot034	[email protected]	DV	1	system_known_number	2026-06-20 12:27:04	NULL	1	{"accountHolderName":"01346181916-SMBKASH","accoun...	2026-06-20 12:27:04	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 48011	48011	f423a96d56147c36899c0445d39ca494a5d24b7b549461d8a2...	4422198	Rocket Personal Payment	013461819164	SMR013	013461819164-SMROCKET	SM77-SMB\|SMN\|SMR\|SMU ! MA77	1	1781932739000	1781962957467	admin	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 12:57:39	1578	1	{"accountHolderName":"013461819164-SMROCKET","acco...	2026-06-20 12:27:04	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 47960	47960	7bfda6d0b883d4db18d08e8bbb7c6673c77a0fe0e8ad2fe70e...	4422197	Upay Personal Payment	01346181916	SMU013	01346181916-SMUPAY	SM77-SMB\|SMN\|SMR\|SMU ! MA77	1	1781932727083	1781960423150	admin	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 12:57:40	1569	1	{"accountHolderName":"01346181916-SMUPAY","account...	2026-06-20 12:19:54	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 47961	47961	bd8ce94555eeec5bf27e0d3dbe01092bff0693b51af78cc42b...	4422196	Nagad Personal Payment	01346181916	SMN013	01346181916-SMNAGAD	SM77-SMB\|SMN\|SMR\|SMU ! MA77	1	1781932715164	1781963195585	admin	Ctbot034	[email protected]	DV	1	system_known_number	2026-06-20 12:19:54	NULL	1	{"accountHolderName":"01346181916-SMNAGAD","accoun...	2026-06-20 12:19:54	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 47239	47239	1363be6cf67b2f1a772c627b83dc82f0a3ea670f610034cb01...	4422111	Bkash Payment	01346536986	B013	01346536986-BKASH	CT83-BKASH\|NAGAD ! MA83	1	1781931391181	1781965031336	phaBDT	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 12:57:02	1563	1	{"accountHolderName":"01346536986-BKASH","accountR...	2026-06-20 12:06:53	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 47240	47240	144e6089f18234ffe272877f9a4afcd413aec69f441f1232b1...	4422055	Nagad Merchant Payment	01935568377	MPN019	01935568377-MPNAGAD	MP132A-N-M/S F R TRADERS ! MA132	1	1781930177172	1781961942115	ThonBDT	Ctbot034	[email protected]	DV	1	system_known_number	2026-06-20 12:06:53	NULL	1	{"accountHolderName":"01935568377-MPNAGAD","accoun...	2026-06-20 12:06:53	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 47241	47241	0d4768742d942aed39ce4f32b36061875c181bb89c7e4a22fe...	4422040	Bkash Personal Payment	01605423536	SMB016	01605423536-SMBKASH	SM115A-SMB\|SMN\|SMR\|SMU ! MA115	1	1781929951095	1781964418608	admin	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 19:48:37	1564	1	{"accountHolderName":"01605423536-SMBKASH","accoun...	2026-06-20 12:06:53	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 47074	47074	fb9f5036110e6be354f8096780d0eeadef488b4b5d69e4b8fb...	4421953	Bkash Personal Payment	01767091755	SMB017	01767091755-SMBKASH	SM07i-SMN\|SMB\|SMU\|SMR ! MA07	1	1781927762631	1781939123565	admin	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 12:55:13	1545	1	{"accountHolderName":"01767091755-SMBKASH","accoun...	2026-06-20 10:56:44	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 47075	47075	09d3c34a44a1ddf8a62a6f188b9874baf9af11c54ee2238fdb...	4421950	Rocket Personal Payment	017670917559	SMR017	017670917559-SMROCKET	SM07i-SMN\|SMB\|SMU\|SMR ! MA07	0	1781927748927	1781939121294	admin	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 12:55:18	1546	0	{"accountHolderName":"017670917559-SMROCKET","acco...	2026-06-20 10:56:44	2026-06-20 15:05:01
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 47076	47076	a1323ce81dd3e934718bf598faa28c40ebcec17a2831abfad0...	4421949	Upay Personal Payment	01767091755	SMU017	01767091755-SMUPAY	SM07i-SMN\|SMB\|SMU\|SMR ! MA07	1	1781927736713	1781944478424	admin	Ctbot034	[email protected]	DV	1	system_known_number	2026-06-20 10:56:44	NULL	1	{"accountHolderName":"01767091755-SMUPAY","account...	2026-06-20 10:56:44	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 47077	47077	93cb7fd7bbd95b5d53369394c39ed7407c1641b53d2a666dbd...	4421948	Nagad Personal Payment	01767091755	SMN017	01767091755-SMNAGAD	SM07i-SMN\|SMB\|SMU\|SMR ! MA07	1	1781927724744	1781951133887	admin	Ctbot034	[email protected]	DV	1	system_known_number	2026-06-20 10:56:44	NULL	1	{"accountHolderName":"01767091755-SMNAGAD","accoun...	2026-06-20 10:56:44	2026-06-20 21:37:53
Edit	Copy	Delete DELETE FROM ct_accounts WHERE `ct_accounts`.`id` = 47078	47078	f54864db780510dd6d11b2b5a0299183b61b65fcc1883c42fa...	4421937	Nagad Personal Payment	01789651337	SMN017	01789651337-SMNAGAD	SM07CX-SMB\|SMN\|SMR\|SMU ! MA07	1	1781927498541	1781933691114	admin	Ctbot034	[email protected]	ST	1	superadmin	2026-06-20 12:55:22	1547	1	{"accountHolderName":"01789651337-SMNAGAD","accoun...	2026-06-20 10:56:44	2026-06-20 21:37:53

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view