Total processing time: 1,112 ms; Peak memory: 6.994 MB. Show Profiling Timeline
| Time | Duration | Category | Info |
|---|---|---|---|
| 18:06:15.986 | 33.5 ms | yii\db\Command::query | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_sources' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 18:06:16.033 | 22.1 ms | yii\db\Command::query | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_project_status_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 18:06:16.102 | 17.6 ms | yii\db\Command::query | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_erp_verify_processes' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 18:06:15.174 | 16.2 ms | yii\db\Command::query | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_action_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 18:06:15.749 | 14.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_return_visibles" WHERE "user_id"='5449' |
| 18:06:15.162 | 11.3 ms | yii\db\Command::query | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_action_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 18:06:15.900 | 11.1 ms | yii\db\Command::query | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_sales_group_relationships' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 18:06:15.917 | 11.0 ms | yii\db\Command::query | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_engineer_group_relationships' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 18:06:15.956 | 10.9 ms | yii\db\Command::query | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_project_change_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 18:06:15.191 | 10.8 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Users', 5449, 'a:4:{s:5:"email";s:36:"6a1eab171efa9_zhoulifei@toast.com.cn";s:6:"mobile";s:25:"6a1eab171efe6_18622478636";s:11:"user_status";s:2:"-1";s:10:"leave_date";s:10:"2026-06-02";}', '', 1001, '221.216.117.119') |
| 18:06:15.151 | 9.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_users" SET "email"='6a1eab171efa9_zhoulifei@toast.com.cn', "user_status"='-1', "mobile"='6a1eab171efe6_18622478636', "updated_at"='now()', "leave_date"='2026-06-02' WHERE "id"=5449 |
| 18:06:15.884 | 9.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "sales_rep"=NULL, "client_class"=NULL, "is_overdue_remind"=FALSE WHERE "sales_rep"='5449' |
| 18:06:15.036 | 8.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE ("created_by"=5449) AND ("status" IN (1, 2))) |
| 18:06:15.932 | 7.0 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_schedules" SET "end_at"='now()', "is_complete"=TRUE, "is_closed"=TRUE WHERE ("created_by"='5449') AND ("is_complete"=FALSE) |
| 18:06:15.980 | 6.1 ms | yii\db\Command::query | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_sources' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 18:06:16.056 | 6.0 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_status_logs" ("project_id", "old_status", "new_status", "created_by", "created_at") VALUES (3878, 1, 5, 5449, 'now()') RETURNING "id" |
| 18:06:15.947 | 5.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3878) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 18:06:16.021 | 5.9 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sources" SET "project_status"=5 WHERE "project_id"=3878 |
| 18:06:15.070 | 5.7 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.735 | 5.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_disassemble_visibles" WHERE "user_id"='5449' |
| 18:06:15.841 | 5.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_documents" WHERE "accessible_user"='5449' |
| 18:06:15.673 | 5.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_calendars" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:06:15.822 | 5.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_wage_prize_visibles" WHERE "user_id"='5449' |
| 18:06:15.057 | 5.0 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.050 | 5.0 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.816 | 4.9 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_wage_ticket_visibles" WHERE "user_id"='5449' |
| 18:06:15.857 | 4.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_order_item_remind_receivers" WHERE "user_id"='5449' |
| 18:06:15.696 | 4.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_punch_approves" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:06:15.725 | 4.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_overflow_visibles" WHERE "user_id"='5449' |
| 18:06:15.780 | 4.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_visibles" WHERE "user_id"='5449' |
| 18:06:15.971 | 4.5 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (3878, 5, '0', '0', '0', 'now()', NULL) RETURNING "id" |
| 18:06:15.851 | 4.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_order_remind_receivers" WHERE "user_id"='5449' |
| 18:06:15.710 | 4.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_return_visibles" WHERE "user_id"='5449' |
| 18:06:16.098 | 4.0 ms | yii\db\Command::query | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_erp_verify_processes' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 18:06:15.942 | 4.0 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "project_status"=5, "updated_at"='now()' WHERE "id"=3878 |
| 18:06:16.029 | 3.8 ms | yii\db\Command::query | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_project_status_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 18:06:15.745 | 3.8 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_outbound_visibles" WHERE "user_id"='5449' |
| 18:06:15.701 | 3.8 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_order_visibles" WHERE "user_id"='5449' |
| 18:06:15.721 | 3.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_lost_visibles" WHERE "user_id"='5449' |
| 18:06:15.044 | 3.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_approves" WHERE ("created_by"=5449) AND ("status"=1)) |
| 18:06:15.785 | 3.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_other_payment_ticket_visibles" WHERE "user_id"='5449' |
| 18:06:15.872 | 3.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "user_id"='5449' |
| 18:06:15.811 | 3.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_visibles" WHERE "user_id"='5449' |
| 18:06:16.122 | 3.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE approve_verify_user is not null |
| 18:06:15.877 | 3.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_operation_contacts" WHERE "user_id"='5449' |
| 18:06:15.731 | 3.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_build_visibles" WHERE "user_id"='5449' |
| 18:06:15.706 | 3.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_inbound_visibles" WHERE "user_id"='5449' |
| 18:06:16.094 | 3.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE verify_user is not null |
| 18:06:15.792 | 3.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_other_collect_ticket_visibles" WHERE "user_id"='5449' |
| 18:06:15.804 | 3.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_other_income_ticket_visibles" WHERE "user_id"='5449' |
| 18:06:15.808 | 3.0 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_visibles" WHERE "user_id"='5449' |
| 18:06:15.865 | 2.9 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "user_id"='5449' |
| 18:06:15.828 | 2.9 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_personal_tax_visibles" WHERE "user_id"='5449' |
| 18:06:15.772 | 2.9 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_payment_ticket_visibles" WHERE "user_id"='5449' |
| 18:06:15.847 | 2.9 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "user_id"='5449' |
| 18:06:15.797 | 2.8 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_visibles" WHERE "user_id"='5449' |
| 18:06:15.768 | 2.8 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_gift_visibles" WHERE "user_id"='5449' |
| 18:06:15.775 | 2.8 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_collect_ticket_visibles" WHERE "user_id"='5449' |
| 18:06:15.085 | 2.8 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE ("created_by"=5449) AND ("status" IN (1, 5, 7))) |
| 18:06:15.683 | 2.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_work_calendars" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:06:15.832 | 2.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_provident_fund_visibles" WHERE "user_id"='5449' |
| 18:06:15.718 | 2.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_cost_visibles" WHERE "user_id"='5449' |
| 18:06:15.953 | 2.6 ms | yii\db\Command::query | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_project_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 18:06:15.869 | 2.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_case_remind_receivers" WHERE "user_id"='5449' |
| 18:06:15.741 | 2.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_visibles" WHERE "user_id"='5449' |
| 18:06:15.894 | 2.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_user_role_change_logs" SET "end_at"='now()' WHERE ("user_id"='5449') AND (end_at is null) |
| 18:06:15.679 | 2.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_schedules" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:06:15.898 | 2.5 ms | yii\db\Command::query | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_sales_group_relationships' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 18:06:15.862 | 2.4 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "user_id"='5449' |
| 18:06:15.077 | 2.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.939 | 2.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("created_by"='5449') AND ("project_status" IN (1, 2)) |
| 18:06:15.914 | 2.3 ms | yii\db\Command::query | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_engineer_group_relationships' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 18:06:15.667 | 2.3 ms | yii\db\Command::execute | UPDATE "global"."tbl_logins" SET "email"='6a1eab171efa9_zhoulifei@toast.com.cn', "password"='$2y$13$.r5t2tgSaT8fvSjCOIdt2e1TTrUTARnFCfQnn0HoyBUXz1gxb8F8a', "auth_key"='coz2eQ4V34f4zUyKEGj2KhD__en7xBu8', "access_token"='Lkq9S-BrCVjJ4h-_TzI9vcwLrZbPb9IO', "user_status"='-1', "mobile"='6a1eab171efe6_18622478636', "web_access_token"='BSeqT6zStFPOmpKHiOUF8w-j6R8HfEzo' WHERE "id"=5449 |
| 18:06:15.082 | 2.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.800 | 2.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_cost_ticket_visibles" WHERE "user_id"='5449' |
| 18:06:16.065 | 2.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3880) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 18:06:15.967 | 2.2 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=16365 |
| 18:06:15.715 | 2.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_gift_visibles" WHERE "user_id"='5449' |
| 18:06:15.115 | 2.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_other_payment_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.692 | 2.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_approves" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:06:15.836 | 2.0 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_social_insurance_visibles" WHERE "user_id"='5449' |
| 18:06:15.687 | 2.0 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_work_logs" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:06:15.689 | 2.0 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_reimbursements" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:06:15.838 | 2.0 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_profit_distribute_visibles" WHERE "user_id"='5449' |
| 18:06:15.121 | 2.0 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:16.075 | 1.7 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_status_logs" ("project_id", "old_status", "new_status", "created_by", "created_at") VALUES (3880, 1, 5, 5449, 'now()') RETURNING "id" |
| 18:06:15.098 | 1.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_inventory_losts" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.103 | 1.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassembles" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.095 | 1.5 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE ("created_by"=5449) AND ("status" IN (1, 5, 7))) |
| 18:06:15.912 | 1.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_group_relationships" SET "group_id"=999999 WHERE "sales_id"='5449' |
| 18:06:15.881 | 1.4 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE ("contract_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "client_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE "sales_rep"='5449'))) AND ("user_id"='5449') |
| 18:06:16.071 | 1.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectChangeLogs', 17846, 'a:8:{s:2:"id";i:17846;s:10:"project_id";i:3880;s:14:"project_status";i:5;s:6:"budget";s:1:"0";s:10:"profit_pct";s:1:"0";s:9:"collected";s:1:"0";s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119') |
| 18:06:15.671 | 1.4 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_punch_strategy_resource_rels" WHERE "user_id"='5449' |
| 18:06:15.112 | 1.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.110 | 1.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.108 | 1.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_returns" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.101 | 1.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_inventory_builds" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:16.067 | 1.1 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=16371 |
| 18:06:16.072 | 1.1 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3880, 'a:1:{s:14:"project_status";i:5;}', '', 1001, '221.216.117.119') |
| 18:06:15.125 | 1.1 ms | yii\db\Command::query | SELECT "b".* FROM "a57be577deb434"."tbl_auth_assignments" "a", "a57be577deb434"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='5449') AND ("b"."type"=1) |
| 18:06:15.089 | 1.0 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.118 | 1.0 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:16.064 | 1.0 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "project_status"=5, "updated_at"='now()' WHERE "id"=3880 |
| 18:06:16.069 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectChangeLogs', 16371, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119') |
| 18:06:15.106 | 0.9 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.093 | 0.9 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gifts" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.091 | 0.9 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_purchase_returns" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:16.062 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectStatusLogs', 4349, 'a:6:{s:2:"id";i:4349;s:10:"project_id";i:3878;s:10:"new_status";i:5;s:10:"old_status";i:1;s:10:"created_by";s:4:"5449";s:10:"created_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119') |
| 18:06:16.070 | 0.9 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (3880, 5, '0', '0', '0', 'now()', NULL) RETURNING "id" |
| 18:06:15.124 | 0.9 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_bank_transfer_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:16.129 | 0.9 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/account/delete', '{"id":"5449","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"infos":[{"status":1,"msg":"\u8d39\u7528\u62a5\u9500\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u5ba1\u6279\u7ba1\u7406\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u5916\u52e4\u7533\u8bf7\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u8865\u5361\u7533\u8bf7\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u8bf7\u5047\u7533\u8bf7\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u51fa\u5dee\u7533\u8bf7\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u52a0\u73ed\u7533\u8bf7\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u91c7\u8d2d\u8ba2\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u91c7\u8d2d\u5165\u5e93\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u91c7\u8d2d\u9000\u8d27\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u83b7\u8d60\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u8d39\u7528\u8ba2\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u62a5\u635f\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u7ec4\u88c5\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u62c6\u5378\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u9500\u552e\u8ba2\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u9500\u552e\u51fa\u5e93\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u9500\u552e\u9000\u8d27\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u8d60\u9001\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u4ed8\u6b3e\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u6536\u6b3e\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u9884\u4ed8\u6b3e\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u5176\u4ed6\u5e94\u4ed8\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u5176\u4ed6\u5e94\u6536\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u5229\u6da6\u5212\u62e8\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u8d39\u7528\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u5176\u4ed6\u6536\u5165\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u73b0\u91d1\u8d39\u7528\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u8f6c\u6b3e\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\u68c0\u67e5\u6210\u529f"},{"status":1,"msg":"CASE\u68c0\u67e5\u6210\u529f"}]},"status":1,"msg":[{"name":"success","success":"\u7528\u6237\u5df2\u88ab\u6210\u529f\u5220\u9664","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 18:06:16', 1108202752) RETURNING "id" |
| 18:06:15.977 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3878, 'a:1:{s:14:"project_status";i:5;}', '', 1001, '221.216.117.119') |
| 18:06:15.029 | 0.9 ms | yii\db\Command::query | SELECT DISTINCT "u"."id" FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON aa.user_id = u.id WHERE ("aa"."item_name"='Admin') AND ("u"."user_status"='1') |
| 18:06:15.202 | 0.8 ms | yii\db\Command::query | SELECT * FROM "global"."tbl_logins" WHERE "id"='5449' |
| 18:06:15.023 | 0.8 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 18:06:16.077 | 0.8 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectStatusLogs', 4350, 'a:6:{s:2:"id";i:4350;s:10:"project_id";i:3880;s:10:"new_status";i:5;s:10:"old_status";i:1;s:10:"created_by";s:4:"5449";s:10:"created_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119') |
| 18:06:15.928 | 0.8 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_engineer_group_relationships" SET "engineer_group_id"=999999 WHERE "engineer_id"='5449' |
| 18:06:15.669 | 0.8 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Logins', 5449, 'a:7:{s:5:"email";s:36:"6a1eab171efa9_zhoulifei@toast.com.cn";s:8:"password";s:60:"$2y$13$.r5t2tgSaT8fvSjCOIdt2e1TTrUTARnFCfQnn0HoyBUXz1gxb8F8a";s:8:"auth_key";s:32:"coz2eQ4V34f4zUyKEGj2KhD__en7xBu8";s:12:"access_token";s:32:"Lkq9S-BrCVjJ4h-_TzI9vcwLrZbPb9IO";s:6:"mobile";s:25:"6a1eab171efe6_18622478636";s:16:"web_access_token";s:32:"BSeqT6zStFPOmpKHiOUF8w-j6R8HfEzo";s:11:"user_status";s:2:"-1";}', '', 1001, '221.216.117.119') |
| 18:06:15.970 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectChangeLogs', 16365, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119') |
| 18:06:15.975 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectChangeLogs', 17845, 'a:8:{s:2:"id";i:17845;s:10:"project_id";i:3878;s:14:"project_status";i:5;s:6:"budget";s:1:"0";s:10:"profit_pct";s:1:"0";s:9:"collected";s:1:"0";s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119') |
| 18:06:15.883 | 0.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE ("contract_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "client_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE "sales_rep"='5449'))) AND ("user_id"='5449') |
| 18:06:15.105 | 0.7 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("created_by"=5449) AND ("status" IN (1, 5, 7))) |
| 18:06:16.027 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3369 |
| 18:06:15.025 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 18:06:16.074 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747 |
| 18:06:15.030 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5449' |
| 18:06:15.114 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.125 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_profit_distributes" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.109 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_gifts" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:16.074 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sources" SET "project_status"=5 WHERE "project_id"=3880 |
| 18:06:15.120 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_cost_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.120 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_other_income_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.119 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:06:15.880 | 0.3 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("id" != '5449') AND ("department_id"=1) |
| 18:06:16.128 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE approve_carbon_copy_user is not null |
| 18:06:15.022 | 0.3 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 18:06:15.881 | 0.3 ms | yii\db\Command::query | SELECT count(id) as count, "punch_strategy_id" FROM "a57be577deb434"."tbl_punch_strategy_resource_rels" WHERE "user_id" IN (5295, 5087, 1004, 1005, 5476, 5332, 5300) GROUP BY "punch_strategy_id" |