Performance Profiling

Total processing time: 135 ms; Peak memory: 7.634 MB. Show Profiling Timeline

总计8条数据

Time	Duration	Category	Info

17:29:52.131	5.7 ms	yii\db\Command::query	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	yii\db\Command::query	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.122	2.4 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:29:52.142	2.1 ms	yii\db\Command::query	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)
17:29:52.120	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:29:52.126	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:29:52.140	1.2 ms	yii\db\Command::query	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	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5300, 1001, 5087, 5295, 1004)