Real-time top 10 slow queries (last 10 minutes) - Updated: 10/23/2025 4:04:02 AM
|
| Query |
Last Time (ms) |
Min Time (ms) |
Max Time (ms) |
SELECT tree_id,tnx_id
,order_id FROM tbl_tallybox_sign
_archive_1 ORDER BY tnx_id OFFSE
T 0 ROWS FETCH NEXT 10 ROWS ONLY
|
0.069 |
0.069 |
0.114 |
SELECT TOP 1 tnx_id FR
OM tbl_tallybox_sign_buffer WHER
E archive_id='2' order by tnx_id
|
0.063 |
0.021 |
0.117 |
SELECT TOP 1 tnx_id FR
OM tbl_tallybox_sign_buffer WHER
E archive_id='1' order by tnx_id
|
0.061 |
0.038 |
0.134 |
SELECT the_
sign FROM tbl_order_dispatcher_1
|
0.037 |
0.008 |
8.588 |
SELECT the_
sign FROM tbl_order_dispatcher_0
|
0.030 |
0.008 |
0.586 |
SELECT the_
sign FROM tbl_order_dispatcher_3
|
0.030 |
0.008 |
0.514 |
SELECT the_
sign FROM tbl_order_dispatcher_6
|
0.027 |
0.008 |
0.420 |
SELECT the_
sign FROM tbl_order_dispatcher_4
|
0.027 |
0.008 |
0.445 |
SELECT the_
sign FROM tbl_order_dispatcher_9
|
0.025 |
0.008 |
0.298 |
(@1 varchar(8000))SELECT [row_c
ount] FROM [dbo].[tbl_optimize_r
ow_counts] WHERE [table_name]=@1
|
0.024 |
0.017 |
0.066 |
Real-time top 10 quick queries (last 10 seconds) - Updated: 10/23/2025 4:04:02 AM
|
| Query |
Last Time (ms) |
Min Time (ms) |
Max Time (ms) |
SELECT the_
sign FROM tbl_order_dispatcher_2
|
0.017 |
0.007 |
8.427 |
SELECT the_
sign FROM tbl_order_dispatcher_5
|
0.020 |
0.009 |
0.408 |
SELECT the_
sign FROM tbl_order_dispatcher_8
|
0.020 |
0.008 |
0.347 |
(@1 varchar(8
000))SELECT [tnx_id] FROM [tbl_t
allybox_sign_buffer] WHERE [arch
ive_id]=@1 ORDER BY [tnx_id] ASC
|
0.022 |
0.014 |
10.513 |
SELECT the_
sign FROM tbl_order_dispatcher_7
|
0.023 |
0.008 |
4.629 |
SELECT the_
sign FROM tbl_order_dispatcher_9
|
0.025 |
0.008 |
0.298 |
SELECT the_
sign FROM tbl_order_dispatcher_6
|
0.027 |
0.008 |
0.420 |
SELECT the_
sign FROM tbl_order_dispatcher_4
|
0.027 |
0.008 |
0.445 |
SELECT the_
sign FROM tbl_order_dispatcher_3
|
0.030 |
0.008 |
0.514 |
SELECT the_
sign FROM tbl_order_dispatcher_0
|
0.030 |
0.008 |
0.586 |