Performance Profiling

Total processing time: 93 ms; Peak memory: 5.253 MB. Show Profiling Timeline

总计16条数据

Time	Duration	Category	Info

20:27:14.805	19.2 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=12) AND ("object_id" IN (469, 431, 94, 171, 234)) GROUP BY "object_id"
20:27:14.829	17.7 ms	yii\db\Command::query	SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=12) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (469, 431, 94, 171, 234)) GROUP BY "object_id"
20:27:14.783	8.2 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT DISTINCT s. FROM "a57be577deb434"."tbl_suppliers" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" LEFT JOIN "a57be577deb434"."tbl_contacts" "c" ON c.supplier_id = s.id and c.supplier_id is not null WHERE (lower(s.name) LIKE '%北京惠%') OR ("s"."pinyin_shortcut" LIKE '%北京惠%') OR (lower(s.description) LIKE '%北京惠%') OR (lower(s.main_products) LIKE '%北京惠%') OR (lower(c.name) LIKE '%北京惠%') GROUP BY "s"."id" ORDER BY "s"."updated_at" DESC) "c"
20:27:14.792	6.2 ms	yii\db\Command::query	SELECT DISTINCT s.* FROM "a57be577deb434"."tbl_suppliers" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" LEFT JOIN "a57be577deb434"."tbl_contacts" "c" ON c.supplier_id = s.id and c.supplier_id is not null WHERE (lower(s.name) LIKE '%北京惠%') OR ("s"."pinyin_shortcut" LIKE '%北京惠%') OR (lower(s.description) LIKE '%北京惠%') OR (lower(s.main_products) LIKE '%北京惠%') OR (lower(c.name) LIKE '%北京惠%') GROUP BY "s"."id" ORDER BY "s"."updated_at" DESC LIMIT 10
20:27:14.851	4.5 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", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1161, 'v2/supplier/list', '{"Filter":{"name":"","sort":""},"SupplierSearch":{"keyword":"\u5317\u4eac\u60e0","supplier_tag":""},"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"2","posttime":"1784118400","token":"dffbbef2f8a9b78a35bd823e10f58b2c","version_code":"1161"}', '{"code":200,"data":{"list":[{"id":469,"name":"\u5317\u4eac\u60e0\u6cfd\u65b9\u521b\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjhzfckjyxgs","main_products":"\u7fa4\u6656\u4ee3\u7406\u5546\/\u897f\u6570\/\u95ea\u8fea\u5927\u5e08","company_nature":4,"website":"","established_at":"2009-07-23","capital":100,"corp_rep":"\u9a6c\u7acb\u519b","reg_address":null,"telephone":"","fax":"","description":"","main_contact":null,"created_by":1011,"created_at":"2022-06-28 16:15:13","updated_at":"2022-06-28 16:44:00","working_address":2745,"capital_currency":"rmb","payment_cycle":"1","account_number":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"supplierTags":{"id":107,"key":107,"name":"\u4ee3\u7406\u5546"},"commentCount":null,"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"workingAddress":{"id":2745,"key":2745,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e2d\u5173\u6751\u5927\u885718\u53f716\u5c421822-B","zip":""},"unreadComments":null,"is_cooperated":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjhlxtxxjsfwyxgs","main_products":"\u540c\u65b9\u4fe1\u521bPC\u4ea7\u54c1","company_nature":4,"website":"","established_at":"2019-08-26","capital":500,"corp_rep":"\u90ed\u82b3\u541b ","reg_address":null,"telephone":"","fax":"","description":"","main_contact":null,"created_by":1011,"created_at":"2021-09-28 15:22:46","updated_at":"2021-09-28 15:22:46","working_address":2630,"capital_currency":"rmb","payment_cycle":"1","account_number":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"supplierTags":{"id":107,"key":107,"name":"\u4ee3\u7406\u5546"},"commentCount":null,"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"workingAddress":{"id":2630,"key":2630,"name":"\u6ce8\u518c\u5730\u5740\uff1a\u5317\u4eac\u5e02\u987a\u4e49\u533a\u7a7a\u6e2f\u8857\u9053\u4e09\u5c71\u65b0\u65b0\u5bb6\u56ed\u56db\u533a2\u53f7\u697c\u56db\u5c421612\u5ba4","zip":""},"unreadComments":null,"is_cooperated":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":94,"name":"\u5317\u4eac\u60e0\u540c\u666e\u65b9\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjhtpfkjfzyxgs","main_products":"HP \u6253\u5370\u673a\u3001\u626b\u63cf\u4eea","company_nature":4,"website":"","established_at":"2004-03-30","capital":100,"corp_rep":"\u53f2\u4fee\u742a","reg_address":279,"telephone":"010-82872393","fax":"010-82872393","description":"\u666e\u901a\u4ee3\u7406\u5546\uff0c\u8d26\u671f\uff1a15\u5929\uff0c\u7535\u6c47","main_contact":null,"created_by":1011,"created_at":"2017-03-06 14:51:30","updated_at":"2019-03-05 10:24:33","working_address":280,"capital_currency":"rmb","payment_cycle":"15\u5929","account_number":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"supplierTags":{"id":107,"key":107,"name":"\u4ee3\u7406\u5546"},"commentCount":{"object_id":94,"comment":2},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"workingAddress":{"id":280,"key":280,"name":"\u4e2d\u6e7e\u56fd\u9645H\u5ea71217","zip":""},"unreadComments":null,"is_cooperated":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":171,"name":"\u5317\u4eac\u60e0\u901a\u96c5\u4fe1\u8d38\u6613\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjhtyxmyyxgs","main_products":"\u601d\u798f\u8fea\u8fd0\u7ef4\u8f6f\u4ef6\uff08\u5382\u5546\u8fc7\u5355\u7684\u4ee3\u7406\u5546\uff09","company_nature":4,"website":"","established_at":"2003-12-16","capital":50,"corp_rep":"\u5218\u5b50\u5174","reg_address":576,"telephone":"010-82608008","fax":"010-82608008","description":"\u7535\u6c47","main_contact":null,"created_by":1011,"created_at":"2017-06-06 09:15:23","updated_at":"2018-10-31 17:24:07","working_address":577,"capital_currency":"rmb","payment_cycle":"1\u5929","account_number":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"supplierTags":{"id":107,"key":107,"name":"\u4ee3\u7406\u5546"},"commentCount":null,"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"workingAddress":{"id":577,"key":577,"name":"\u82cf\u5dde\u885775\u53f717\u5e62\u5e73\u623f2\u53f7","zip":""},"unreadComments":null,"is_cooperated":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":234,"name":"\u5317\u4eac\u60e0\u53cb\u65f6\u4ee3\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjhysdkjfzyxgs","main_products":"\u601d\u79d1\u7f51\u7edc\u4ea7\u54c1\u548c\u89c6\u9891\u7ec8\u7aef","company_nature":4,"website":"","established_at":"2001-08-07","capital":2000,"corp_rep":"\u9676\u9e9f","reg_address":null,"telephone":"010-51265797","fax":"010-51265797","description":"","main_contact":null,"created_by":1011,"created_at":"2018-04-09 09:45:52","updated_at":"2018-10-29 11:01:40","working_address":1335,"capital_currency":"rmb","payment_cycle":"30","account_number":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"supplierTags":{"id":107,"key":107,"name":"\u4ee3\u7406\u5546"},"commentCount":null,"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"workingAddress":{"id":1335,"key":1335,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e0a\u5730\u4fe1\u606f\u8def11\u53f71\u5e62\u56db\u5c42\u897f409\u5ba4","zip":""},"unreadComments":null,"is_cooperated":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"}],"pagenation":{"totalcount":5,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"111.9.5.127","ua":"jinchangxiao\/2.3.158 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-07-15 20:27:14', 84957952) RETURNING "id"
20:27:14.769	3.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
20:27:14.801	3.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (469, 431, 94, 171, 234)
20:27:14.773	2.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
20:27:14.825	1.9 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "address1" AS "name", "zip" FROM "a57be577deb434"."tbl_addresses" WHERE "id" IN (2745, 2630, 280, 577, 1335)
20:27:14.777	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
20:27:14.827	1.2 ms	yii\db\Command::query	SELECT "id", "supplier_id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE (("is_draft"=FALSE) AND ("is_chargeback"=FALSE) AND ("is_refuse"=FALSE)) AND ("supplier_id" IN (469, 431, 94, 171, 234))
20:27:14.804	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=6) AND ("id" IN (100, 46, 107, 96, 101, 115, 185, 193, 128, 167, 142, 183, 187, 184, 200, 196, 204, 94, 6, 8, 11, 207, 208, 5, 226, 215, 2, 139, 319, 7, 153, 114, 315, 317, 340, 313, 365, 372, 374, 369, 377, 359, 349, 136))
20:27:14.800	0.5 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"=1011)
20:27:14.825	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id"=4
20:27:14.800	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3
20:27:14.799	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011