Performance Profiling

Total processing time: 13 ms; Peak memory: 2.247 MB. Show Profiling Timeline

总计8条数据

Time	Duration	Category	Info

20:26:00.007	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (324, 323, 1870, 1864, 1865)
20:26:00.004	1.8 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "mobile", "telephone", "telephone_area_code", "telephone_extension_number", "sex", "department", "job_position" FROM "a57be577deb434"."tbl_contacts" WHERE ("client_id"='167') AND ("user_status"='2')
20:26:00.006	1.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (324, 323, 1870, 1864, 1865)
20:26:00.010	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/search/contact-by-client-id', '{"client_id":"167"}', '{"code":2000,"result":[{"id":324,"key":324,"name":"\u4ed8\u6653\u9f99","mobile":"13910127866","telephone":"","telephone_area_code":null,"telephone_extension_number":null,"sex":"M","department":"\u7f51\u7edc\u4e2d\u5fc3","job_position":"\u526f\u4e3b\u4efb","mobiles":[{"id":309,"contact_id":324,"mobile":"13910127866","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"keyRole":"\u6280\u672f\u51b3\u7b56\u4eba"},{"id":323,"key":323,"name":"\u5218\u4e43\u5609","mobile":"13811458706","telephone":"","telephone_area_code":null,"telephone_extension_number":null,"sex":"M","department":"\u7f51\u7edc\u4e2d\u5fc3","job_position":"\u9879\u76ee\u7ec4\u957f","mobiles":[{"id":321,"contact_id":323,"mobile":"13811458706","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"},{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"keyRole":"\u6280\u672f\u51b3\u7b56\u4eba"},{"id":1870,"key":1870,"name":"\u90b9\u8001\u5e08","mobile":"","telephone":"62785821","telephone_area_code":"","telephone_extension_number":"8022","sex":"M","department":"\u56fe\u4e66\u9986","job_position":"\u526f\u4e3b\u4efb","mobiles":[],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"keyRole":"\u91c7\u8d2d\u51b3\u7b56\u4eba"},{"id":1864,"key":1864,"name":"\u8fdc\u6d2a\u4eae","mobile":"13699223076","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","department":"\u56fe\u4e66\u9986","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":1736,"contact_id":1864,"mobile":"13699223076","mp_open_id":null}],"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"keyRole":"\u4f7f\u7528\u51b3\u7b56\u4eba"},{"id":1865,"key":1865,"name":"\u5f20\u6210\u6631","mobile":"","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","department":"\u56fe\u4e66\u9986","job_position":"\u4e3b\u4efb","mobiles":[{"id":1737,"contact_id":1865,"mobile":"","mp_open_id":null}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"},{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"keyRole":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"111.194.208.14","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-04 20:26:00', 9921024) RETURNING "id"
20:26:00.001	0.6 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
20:26:00.003	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
20:26:00.009	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (46, 97, 319, 2100000000, 165, 179, 142, 136, 137, 135, 140, 139, 205, 204, 184, 200, 197, 199, 130, 181, 153, 2, 198, 201, 5, 166, 1, 164, 131, 175, 226, 313, 320, 332, 156, 114, 359, 374, 377, 342)) ORDER BY "sort"
20:26:00.001	0.2 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta