68c145101d18e: POST https://beta.jinchangxiao.com/vue/analysis/collect-list-export at 2025-09-10 05:29:52 pm by 114.246.239.150
Database Queries
总计7条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 17:29:52.122 | 2.4 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 17:29:52.126 | 1.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:29:52.131 | 5.7 ms | SELECT | SELECT "scp".* FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "scp" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = scp.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE ("scp"."collected_date" >= '2025-01-01') AND ("scp"."collected_date" <= '2025-12-31') AND (p.id is not null) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420', '5448', '5449')) ORDER BY scp.created_at DESC NULLS LAST, scp.id desc |
| 17:29:52.137 | 2.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (4112, 4131, 4129, 4094, 4083, 4082, 4099, 4086, 4047, 4048, 4016, 4068, 4065, 4064, 4050, 4049, 4043, 3926, 4009, 4027, 4028, 4029, 4054, 3931, 3925, 4024, 4046, 4044, 4005, 4021, 4022, 4036, 3646, 3202, 3960, 3286, 3915, 3854, 4002, 4008, 3924, 2851, 3979, 3980, 3984, 3972, 3421, 3995, 3978, 3998, 3959, 3997, 3664, 3989, 3954, 3943, 3942, 3930, 3935, 3966, 3965, 3861, 3916, 3626, 3953, 3941, 3952, 3958, 3967, 3887, 2927, 2996, 3060, 3905, 3919, 3912, 2991, 3795, 3892, 3895, 3879, 3878, 3910, 3920, 3735, 3705, 3899, 3900, 3736, 3864, 3872, 3886, 3881, 3897, 3871, 3868, 3764, 3865, 3855, 3851, 3849, 3832, 3835, 3831, 3875, 3844, 3679, 3866, 3842, 3797, 3857, 3812, 3342, 3816, 3792, 3005, 3477, 3803, 3805, 3841, 3838, 2925, 3567, 3833, 3822, 3829, 3243, 3418, 3724, 3763, 2961, 2978, 3811, 3629, 3796, 3345, 3745, 3809, 3808, 3758, 3759, 3782, 3778, 3496, 3791, 3790, 3783, 3777, 3703, 3738, 3368, 3787, 3767, 3697, 3770, 3691, 3693, 3694, 3710, 3711, 3734, 3729, 3761, 3502, 3755, 2977, 3771, 3733, 3725, 3381, 3468, 3548, 3656, 3497, 3746, 3737, 3744, 3486, 3487, 3488, 3748, 3749, 3325, 3701) |
| 17:29:52.140 | 1.2 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name", "budget", "bargain_date", "created_by", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3926, 3745, 3149, 3411, 3774, 3785, 3770, 3512, 3845, 3875, 3924, 3928, 3929, 3882, 3352, 3417, 3389, 3578, 3562, 3588, 3566, 3628, 3636, 3637, 3602, 3635, 3642, 3644, 3672, 3609, 3659, 3641, 3710, 3696, 3666, 3700, 3694, 3663, 3732, 3738, 3736, 3741, 3742, 3753, 3735, 3734, 3768, 3723, 3721, 3719, 3749, 3767, 3547, 3757, 3764, 3744, 3756, 3752, 3657, 3720, 3699, 3765, 3763, 3759, 3760, 3766, 3786, 3750, 3783, 3788, 3809, 3772, 3771, 3791, 3776, 3801, 3806, 3773, 3775, 3782, 3777, 3792, 3761, 3762, 3781, 3769, 3805, 3789, 3802, 3794, 3800, 3815, 3811, 3793, 3804, 3808, 3812, 3821, 3825, 3816, 3826, 3828, 3829, 3853, 3851, 3814, 3799, 3850, 3877, 3872, 3823, 3797, 3858, 3859, 3803, 3869, 3824, 3857, 3856, 3865, 3855, 3860, 3847, 3862, 3798, 3863, 3822, 3876, 3879, 3866, 3912, 3873, 3903, 3870, 3852, 3836, 3893, 3892, 3885, 3886, 3890, 3889, 3249, 3831, 3899, 3902, 3916, 3901, 3827, 3894, 3834, 3871, 3898, 3918, 3896, 3913, 3900, 3920, 3925, 3874, 3919, 3322, 3308, 3299, 3355, 3319, 3367, 3294, 3940, 3784, 3941, 3948, 3910, 3883, 3927, 3936, 3849, 3431, 3917, 3810, 3930, 3835, 3950, 3956) |
| 17:29:52.142 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5300, 1001, 5087, 5295, 1004) |
| 17:29:52.142 | 2.1 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (89, 1181, 3389, 918, 57, 2526, 3317, 93, 287, 12, 42, 2616, 2553, 107, 1172, 2021, 79, 2548, 3281, 3340, 3326, 4, 2736, 2094, 2545, 149, 1663, 2146, 1301, 1225, 2205, 2182, 94, 2585, 497, 48, 518, 3327, 3302, 97, 2136, 528, 3373, 3372, 2125, 3280, 189, 3333, 531, 2032, 2546, 3334, 2226, 20, 2007, 3359, 3304, 2729, 2091, 2842, 2727, 2117, 24, 2158, 2202, 3364, 2766, 1492, 2186, 31, 2845, 3366, 3357, 2177, 3367, 3383, 3377, 3376, 2596, 2594, 3363, 2762, 3286) |