Total processing time: 726 ms; Peak memory: 6.698 MB. Show Profiling Timeline
| Time | Duration | Category | Info |
|---|---|---|---|
| 18:10:22.561 | 7.0 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_users" SET "email"='6a1eac0e88c65_zhoulifei@toast.com.cn', "user_status"='-1', "mobile"='6a1eac0e88ca6_18622478636', "updated_at"='now()' WHERE "id"=5449 |
| 18:10:23.197 | 6.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sources" SET "project_status"=5 WHERE "project_id"=4176 |
| 18:10:23.181 | 6.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4176) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 18:10:22.572 | 5.5 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:3:{s:5:"email";s:36:"6a1eac0e88c65_zhoulifei@toast.com.cn";s:6:"mobile";s:25:"6a1eac0e88ca6_18622478636";s:11:"user_status";s:2:"-1";}', '', 5064, '221.216.117.119') |
| 18:10:23.205 | 5.2 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_status_logs" ("project_id", "old_status", "new_status", "created_by", "created_at") VALUES (4176, 1, 5, 5449, 'now()') RETURNING "id" |
| 18:10:23.171 | 4.7 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:10:22.517 | 4.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:23.190 | 4.4 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 (4176, 5, '0', '0', '0', 'now()', NULL) RETURNING "id" |
| 18:10:23.133 | 4.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_documents" WHERE "accessible_user"='5449' |
| 18:10:22.513 | 4.0 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_approves" WHERE ("created_by"=5449) AND ("status"=1)) |
| 18:10:22.525 | 3.8 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:23.145 | 3.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_order_item_remind_receivers" WHERE "user_id"='5449' |
| 18:10:23.155 | 3.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "user_id"='5449' |
| 18:10:23.037 | 3.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_calendars" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:10:23.079 | 3.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_disassemble_visibles" WHERE "user_id"='5449' |
| 18:10:23.164 | 3.1 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:10:22.522 | 3.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:22.554 | 3.1 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:10:23.138 | 2.8 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "user_id"='5449' |
| 18:10:22.529 | 2.8 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:23.141 | 2.8 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_order_remind_receivers" WHERE "user_id"='5449' |
| 18:10:22.498 | 2.8 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5064 |
| 18:10:22.532 | 2.8 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:23.151 | 2.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "user_id"='5449' |
| 18:10:22.510 | 2.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE ("created_by"=5449) AND ("status" IN (1, 2))) |
| 18:10:23.102 | 2.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_other_payment_ticket_visibles" WHERE "user_id"='5449' |
| 18:10:23.178 | 2.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "project_status"=5, "updated_at"='now()' WHERE "id"=4176 |
| 18:10:23.099 | 2.4 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_visibles" WHERE "user_id"='5449' |
| 18:10:23.070 | 2.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_lost_visibles" WHERE "user_id"='5449' |
| 18:10:23.093 | 2.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_payment_ticket_visibles" WHERE "user_id"='5449' |
| 18:10:23.073 | 2.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_overflow_visibles" WHERE "user_id"='5449' |
| 18:10:23.032 | 2.1 ms | yii\db\Command::execute | UPDATE "global"."tbl_logins" SET "email"='6a1eac0e88c65_zhoulifei@toast.com.cn', "password"='$2y$13$gnRGmta5vk8BidKFlsYR1.sAnJTUEf9bKTpshK7530lFxe0OqrCpW', "auth_key"='nGUvE_rwG8vwTycFdK5tlLGy3_9DDveq', "access_token"='Bx69Rh4CGXOUfqBCQpqO_cNwKgMz4HmT', "user_status"='-1', "mobile"='6a1eac0e88ca6_18622478636', "web_access_token"='CHm6uqFpg4RHrdccBkWMl_2a-egZfSm_' WHERE "id"=5449 |
| 18:10:23.041 | 2.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_schedules" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:10:23.049 | 2.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_reimbursements" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:10:23.047 | 2.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_work_logs" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:10:23.044 | 2.0 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_work_calendars" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:10:23.052 | 2.0 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_approves" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:10:23.123 | 2.0 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_personal_tax_visibles" WHERE "user_id"='5449' |
| 18:10:23.055 | 2.0 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visible_punch_approves" WHERE ("user_id"='5449') OR ("accessible_user"='5449') |
| 18:10:23.090 | 2.0 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_gift_visibles" WHERE "user_id"='5449' |
| 18:10:23.159 | 1.9 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_operation_contacts" WHERE "user_id"='5449' |
| 18:10:23.063 | 1.9 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_return_visibles" WHERE "user_id"='5449' |
| 18:10:23.083 | 1.8 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_visibles" WHERE "user_id"='5449' |
| 18:10:23.088 | 1.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_return_visibles" WHERE "user_id"='5449' |
| 18:10:23.085 | 1.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_outbound_visibles" WHERE "user_id"='5449' |
| 18:10:23.105 | 1.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_other_collect_ticket_visibles" WHERE "user_id"='5449' |
| 18:10:23.076 | 1.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_build_visibles" WHERE "user_id"='5449' |
| 18:10:23.065 | 1.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_gift_visibles" WHERE "user_id"='5449' |
| 18:10:23.068 | 1.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_cost_visibles" WHERE "user_id"='5449' |
| 18:10:23.060 | 1.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_inbound_visibles" WHERE "user_id"='5449' |
| 18:10:23.058 | 1.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_order_visibles" WHERE "user_id"='5449' |
| 18:10:23.096 | 1.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_collect_ticket_visibles" WHERE "user_id"='5449' |
| 18:10:23.108 | 1.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_visibles" WHERE "user_id"='5449' |
| 18:10:23.110 | 1.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_cost_ticket_visibles" WHERE "user_id"='5449' |
| 18:10:23.119 | 1.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_wage_ticket_visibles" WHERE "user_id"='5449' |
| 18:10:23.117 | 1.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_visibles" WHERE "user_id"='5449' |
| 18:10:23.162 | 1.5 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:10:23.213 | 1.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE verify_user is not null |
| 18:10:22.578 | 1.5 ms | yii\db\Command::query | SELECT * FROM "global"."tbl_logins" WHERE "id"='5449' |
| 18:10:23.115 | 1.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_visibles" WHERE "user_id"='5449' |
| 18:10:23.112 | 1.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_other_income_ticket_visibles" WHERE "user_id"='5449' |
| 18:10:23.121 | 1.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_wage_prize_visibles" WHERE "user_id"='5449' |
| 18:10:23.126 | 1.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_provident_fund_visibles" WHERE "user_id"='5449' |
| 18:10:23.128 | 1.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_social_insurance_visibles" WHERE "user_id"='5449' |
| 18:10:22.497 | 1.4 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 18:10:23.130 | 1.4 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_profit_distribute_visibles" WHERE "user_id"='5449' |
| 18:10:23.176 | 1.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("created_by"='5449') AND ("project_status" IN (1, 2)) |
| 18:10:23.149 | 1.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "user_id"='5449' |
| 18:10:23.188 | 1.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=17844 |
| 18:10:22.504 | 1.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 |
| 18:10:22.535 | 1.2 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:10:22.546 | 1.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:22.547 | 1.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:22.542 | 1.1 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:10:23.169 | 1.0 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_group_relationships" SET "group_id"=999999 WHERE "sales_id"='5449' |
| 18:10:22.549 | 1.0 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:10:23.215 | 0.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE approve_verify_user is not null |
| 18:10:23.035 | 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\Logins', 5449, 'a:7:{s:5:"email";s:36:"6a1eac0e88c65_zhoulifei@toast.com.cn";s:8:"password";s:60:"$2y$13$gnRGmta5vk8BidKFlsYR1.sAnJTUEf9bKTpshK7530lFxe0OqrCpW";s:8:"auth_key";s:32:"nGUvE_rwG8vwTycFdK5tlLGy3_9DDveq";s:12:"access_token";s:32:"Bx69Rh4CGXOUfqBCQpqO_cNwKgMz4HmT";s:6:"mobile";s:25:"6a1eac0e88ca6_18622478636";s:16:"web_access_token";s:32:"CHm6uqFpg4RHrdccBkWMl_2a-egZfSm_";s:11:"user_status";s:2:"-1";}', '', 5064, '221.216.117.119') |
| 18:10:22.508 | 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:10:23.219 | 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', 5064, 5, 'vue/account/delete', '{"id":"5449","web_access_token":"66P66ib-3t6D-JRCTEPzE250hI-J5OEu"}', '{"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_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-02 18:10:23', 722905344) RETURNING "id" |
| 18:10:23.168 | 0.8 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:10:22.559 | 0.8 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:10:22.558 | 0.8 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_profit_distributes" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:23.189 | 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\ProjectChangeLogs', 17844, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 5064, '221.216.117.119') |
| 18:10:23.210 | 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', 4351, 'a:6:{s:2:"id";i:4351;s:10:"project_id";i:4176;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";}', '', 5064, '221.216.117.119') |
| 18:10:23.195 | 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', 17847, 'a:8:{s:2:"id";i:17847;s:10:"project_id";i:4176;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;}', '', 5064, '221.216.117.119') |
| 18:10:23.195 | 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\Projects', 4176, 'a:1:{s:14:"project_status";i:5;}', '', 5064, '221.216.117.119') |
| 18:10:22.541 | 0.7 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassembles" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:22.545 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_gifts" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:22.543 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:22.550 | 0.6 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:10:22.537 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:22.551 | 0.6 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:10:22.552 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_cost_tickets" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:22.553 | 0.5 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:10:22.539 | 0.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:10:23.163 | 0.5 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:10:22.538 | 0.5 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gifts" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:22.557 | 0.5 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:10:22.551 | 0.5 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:10:22.544 | 0.5 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_returns" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:22.537 | 0.5 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_purchase_returns" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:22.509 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5449' |
| 18:10:22.540 | 0.5 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_inventory_builds" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:22.540 | 0.5 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_inventory_losts" WHERE ("created_by"=5449) AND ("status" IN (1, 5))) |
| 18:10:23.036 | 0.4 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_punch_strategy_resource_rels" WHERE "user_id"='5449' |
| 18:10:23.204 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3464 |
| 18:10:23.154 | 0.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_case_remind_receivers" WHERE "user_id"='5449' |
| 18:10:23.161 | 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" |
| 18:10:23.161 | 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:10:23.217 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE approve_carbon_copy_user is not null |
| 18:10:23.170 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_engineer_group_relationships" SET "engineer_group_id"=999999 WHERE "engineer_id"='5449' |