Total processing time: 122 ms; Peak memory: 5.576 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
11:02:38.617 | 16.4 ms | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id"=17699) GROUP BY "object_id" |
11:02:38.634 | 15.1 ms | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=9) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id"=17699) GROUP BY "object_id" |
11:02:38.579 | 8.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3337) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
11:02:38.550 | 8.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_schedule_descriptions' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
11:02:38.546 | 4.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_schedule_descriptions' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
11:02:38.651 | 3.3 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1141, 'v2/schedule/save-new-description', '{"ScheduleDescriptions":{"description":"\u4e0d\u5403\u5a1c\u5a1c\u5403","schedule_id":"17699"},"access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","device_type":"2","posttime":"1751598208","token":"d159f07cef0099efb7f2e7d80174b7e3","version_code":"1141"}', '{"code":200,"data":{"model":{"id":17699,"client_id":3337,"schedule_title":"\u5973\u5973\u5973","description":null,"schedule_week":null,"start_at":"2025-07-04 11:02:00","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":1000,"created_at":"2025-07-04 11:02:22","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2025-07-04 18:00:00","is_public":1,"system_calendar_id":null,"creator":1000,"project_id":3815,"updated_at":"2025-07-04 11:02:31","set_top_at":null,"client":{"id":3337,"key":3337,"name":"\u6d77\u57fa\u4f1a\u57fa\u91d1\u4f1a","sales_rep":5332,"logo":null,"salesRep":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85"}},"project":{"id":3815,"key":3815,"name":"\u4ed8\u6b3e\u53d1\u8d27","project_status":1,"budget":"0","collected":"0","projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"project_status_display":"\u9690\u6027\u9700\u6c42","bgcolor":"#ffc000"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"scheduleCreator":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"headUsers":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}}],"attachmentRelationships":[],"files":[],"scheduleCarbonCopyRels":[{"id":942,"schedule_id":17699,"user_id":1017,"user":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}}},{"id":943,"schedule_id":17699,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}}],"scheduleDescriptions":[{"id":12426,"schedule_id":17699,"description":"\u4e0d\u5403\u5a1c\u5a1c\u5403","created_at":"2025-07-04 11:02:38","created_at_display":"07-04 (\u4eca\u5929) 11:02"}],"commentCount":{"object_id":17699,"comment":2},"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"2025-07-04 18:00:00+08","end_at_display2":"","is_self":true,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":true,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":"2025-07-04 11:02:00+08"},"options":[{"key":"Schedules[headUsers]","name":"Creator","value":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f"},{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de"},{"id":5250,"key":5250,"name":"\u8463\u8363"},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633"},{"id":5329,"key":5329,"name":"\u9ad8\u5ce5"},{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"},{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633"},{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85"},{"id":5420,"key":5420,"name":"\u674e\u6ea6"},{"id":5445,"key":5445,"name":"\u674e\u9896"},{"id":5446,"key":5446,"name":"\u5218\u5a1f"},{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},{"id":5087,"key":5087,"name":"\u5218\u5fae"},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"},{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11"},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99"},{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"},{"id":1015,"key":1015,"name":"\u5434\u660a"},{"id":5404,"key":5404,"name":"\u6b66\u51ef"},{"id":1022,"key":1022,"name":"\u5f90\u7855"},{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e"},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"id":5440,"key":5440,"name":"\u5f20\u6210"},{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3"},{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"},{"id":5296,"key":5296,"name":"\u8d75\u5b87"},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065"}]},{"key":"Schedules[alarm_before]","name":"\u63d0\u9192\u65f6\u95f4","value":[{"key":"","name":"\u4e0d\u63d0\u9192"},{"key":"00:05:00","name":"\u63d0\u524d5\u5206\u949f"},{"key":"00:15:00","name":"\u63d0\u524d15\u5206\u949f"},{"key":"00:30:00","name":"\u63d0\u524d30\u5206\u949f"},{"key":"01:00:00","name":"\u63d0\u524d1\u5c0f\u65f6"},{"key":"02:00:00","name":"\u63d0\u524d2\u5c0f\u65f6"},{"key":"24:00:00","name":"\u63d0\u524d1\u5929"},{"key":"48:00:00","name":"\u63d0\u524d2\u5929"}]}]},"status":1,"msg":[{"name":"success","success":"\u65b0\u603b\u7ed3\u5df2\u521b\u5efa\u6210\u529f","error":""}]}', FALSE, '2025-07-04 11:02:38') RETURNING "id" |
11:02:38.560 | 2.8 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_schedule_descriptions" ("description", "schedule_id", "created_at") VALUES ('不吃娜娜吃', 17699, 'now()') RETURNING "id" |
11:02:38.539 | 2.7 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd' |
11:02:38.537 | 1.7 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
11:02:38.604 | 1.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (2, 'update', 3815, 1, 17699, 9, 1000, '17699', '17699', array[5332], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
11:02:38.598 | 1.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3815) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
11:02:38.612 | 1.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=17699) |
11:02:38.616 | 1.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id"=17699 ORDER BY "created_at" DESC |
11:02:38.577 | 1.2 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=3337 |
11:02:38.564 | 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 ('INSERT', 'app\models\ScheduleDescriptions', 12426, 'a:4:{s:2:"id";i:12426;s:11:"schedule_id";s:5:"17699";s:11:"description";s:15:"不吃娜娜吃";s:10:"created_at";s:19:"1970-01-01 08:00:00";}', '', 1000, '223.104.41.148') |
11:02:38.572 | 1.1 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (17699, '9', 170243, 1017), (17699, '9', 170243, 5250) |
11:02:38.613 | 1.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id"=17699) |
11:02:38.543 | 1.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
11:02:38.588 | 1.0 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3337, 5332, 'now()', NULL) RETURNING "id" |
11:02:38.570 | 1.0 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1000, '9', 17699, '曹永生更新了一条待办事项', TRUE, '女女女') RETURNING "id" |
11:02:38.594 | 1.0 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (2, 'update', 3337, 10, 17699, 9, 1000, '17699', '17699', array[5332], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
11:02:38.565 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'scheduleDescriptions', 17699, 9, 1000, 'now()', '["\u4e0d\u5403\u5a1c\u5a1c\u5403"]', '[[]]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]}') |
11:02:38.610 | 0.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id"=17699 |
11:02:38.597 | 0.9 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3815 |
11:02:38.591 | 0.9 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 3337, 10, 17699, 9, 1000, '17699', '17699', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
11:02:38.601 | 0.8 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 3815, 1, 17699, 9, 1000, '17699', '17699', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
11:02:38.574 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3337 |
11:02:38.589 | 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\ClientAmChangeLogs', 165080, 'a:5:{s:2:"id";i:165080;s:9:"client_id";i:3337;s:9:"sales_rep";i:5332;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.104.41.148') |
11:02:38.595 | 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\UserActionLogs', 136931, 'a:15:{s:2:"id";i:136931;s:9:"object_id";i:3337;s:11:"object_type";i:10;s:9:"target_id";i:17699;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"17699";s:9:"new_value";s:5:"17699";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[5332]";s:6:"params";a:0:{}}s:11:"description";s:95:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1000, '223.104.41.148') |
11:02:38.571 | 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\Comments', 170243, 'a:11:{s:2:"id";i:170243;s:9:"object_id";i:17699;s:11:"object_type";s:1:"9";s:6:"parent";N;s:11:"description";s:36:"曹永生更新了一条待办事项";s:10:"created_by";i:1000;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:9:"女女女";}', '', 1000, '223.104.41.148') |
11:02:38.592 | 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\ObjectChangeLogs', 509961, 'a:13:{s:2:"id";i:509961;s:9:"object_id";i:3337;s:11:"object_type";i:10;s:9:"target_id";i:17699;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"17699";s:9:"new_value";s:5:"17699";s:11:"description";s:95:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.104.41.148') |
11:02:38.590 | 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\Clients', 3337, 'a:0:{}', '', 1000, '223.104.41.148') |
11:02:38.600 | 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', 3815, 'a:0:{}', '', 1000, '223.104.41.148') |
11:02:38.602 | 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\ObjectChangeLogs', 509962, 'a:13:{s:2:"id";i:509962;s:9:"object_id";i:3815;s:11:"object_type";i:1;s:9:"target_id";i:17699;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"17699";s:9:"new_value";s:5:"17699";s:11:"description";s:95:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.104.41.148') |
11:02:38.605 | 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\UserActionLogs', 136932, 'a:15:{s:2:"id";i:136932;s:9:"object_id";i:3815;s:11:"object_type";i:1;s:9:"target_id";i:17699;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"17699";s:9:"new_value";s:5:"17699";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[5332]";s:6:"params";a:0:{}}s:11:"description";s:95:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1000, '223.104.41.148') |
11:02:38.596 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3815 |
11:02:38.559 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='17699' |
11:02:38.650 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("id" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
11:02:38.615 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", CASE WHEN user_status = '-1' THEN name || '(已离职)' ELSE name END AS name, "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1017, 5250) |
11:02:38.573 | 0.3 ms | yii\db\Command::query | SELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id" IN (1017, 5250)) AND ("id" != 1000) AND (channel_id IS NOT NULL) |
11:02:38.576 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3337 |
11:02:38.593 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3337 |
11:02:38.601 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3337 |
11:02:38.608 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
11:02:38.609 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
11:02:38.603 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3337 |
11:02:38.566 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=17699 |
11:02:38.608 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=1 |
11:02:38.649 | 0.3 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id" |
11:02:38.569 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
11:02:38.560 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='17699') |
11:02:38.569 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"=17699 |
11:02:38.609 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
11:02:38.603 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3815 |
11:02:38.574 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"=17699 |
11:02:38.607 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3337 |
11:02:38.606 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='17699' |
11:02:38.607 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5332 |
11:02:38.616 | 0.2 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 1017)) |
11:02:38.607 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3815 |
11:02:38.609 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
11:02:38.612 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
11:02:38.612 | 0.2 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
11:02:38.610 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
11:02:38.610 | 0.2 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
11:02:38.615 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=17699 |
11:02:38.610 | 0.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |