Performance Profiling

Total processing time: 24 ms; Peak memory: 2.308 MB. Show Profiling Timeline

总计8条数据

Time	Duration	Category	Info

16:03:40.732	6.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "telephone", "telephone_area_code", "telephone_extension_number", "sex", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE ("name" ILIKE '%康%') OR ("pinyin_shortcut" ILIKE '%康%') ORDER BY "pinyin_shortcut", "created_at" DESC
16:03:40.744	1.6 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, 0, 273, 'v2/search/all-contact', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"0","version_code":"273","name":"\u5eb7","token":"1c94ad22493dd90e1772a45e77bf638a","posttime":"1781251420"}', '{"code":200,"data":[{"id":6064,"key":6064,"name":"\u5b89\u5eb7","telephone":"57364237","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":3337,"supplier_id":null,"client":{"id":3337,"key":3337,"name":"\u4e2d\u56fd\u822a\u5929\u79d1\u6280\u96c6\u56e2\u516c\u53f8\u7b2c\u4e00\u7814\u7a76\u9662\u4e8c\u4e00\u4e00\u5382"},"supplier":null,"mobiles":[]},{"id":4420,"key":4420,"name":"\u9648\u5eb7","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":2136,"supplier_id":null,"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"supplier":null,"mobiles":[{"id":5232,"contact_id":4420,"mobile":"13693264768","mp_open_id":"oagch6SQycXF7bCUNc2E2T7Wkfjc"}]},{"id":896,"key":896,"name":"\u9648\u5eb7","telephone":"","telephone_area_code":null,"telephone_extension_number":null,"sex":"M","client_id":391,"supplier_id":null,"client":{"id":391,"key":391,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240(8359)-S"},"supplier":null,"mobiles":[{"id":885,"contact_id":896,"mobile":"13693264768","mp_open_id":"oagch6SQycXF7bCUNc2E2T7Wkfjc"}]},{"id":3858,"key":3858,"name":"\u4faf\u5eb7\u9009","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":null,"supplier_id":223,"client":null,"supplier":{"id":223,"key":223,"name":"\u5353\u8c6a(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8"},"mobiles":[{"id":4677,"contact_id":3858,"mobile":"13910086781","mp_open_id":null}]},{"id":2509,"key":2509,"name":"\u5eb7\u4e1c","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":39,"supplier_id":null,"client":{"id":39,"key":39,"name":"(\u7cfb\u7edf\u96c6\u6210\u5546)\u5317\u4eac\u745e\u62d3\u7535\u5b50\u6280\u672f\u53d1\u5c55\u6709\u9650\u516c\u53f8(\u4e2d\u4ea4\u8def\u6865\u5efa\u8bbe\u6709\u9650\u516c\u53f8)"},"supplier":null,"mobiles":[{"id":2575,"contact_id":2509,"mobile":"15213007027","mp_open_id":null}]},{"id":5717,"key":5717,"name":"\u5eb7\u5251","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":3233,"supplier_id":null,"client":{"id":3233,"key":3233,"name":"Shaanxisteppharmaceutical\uff08\u672a\u627e\u5230\u516c\u53f8\uff09"},"supplier":null,"mobiles":[{"id":6497,"contact_id":5717,"mobile":"15330001009","mp_open_id":null}]},{"id":1131,"key":1131,"name":"\u5eb7\u5a1f","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"F","client_id":null,"supplier_id":46,"client":null,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"mobiles":[{"id":3473,"contact_id":1131,"mobile":"18613801130","mp_open_id":null}]},{"id":5183,"key":5183,"name":"\u5eb7\u4f73\u65b0","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":2796,"supplier_id":null,"client":{"id":2796,"key":2796,"name":"PA\u6e20\u9053-\u5317\u4eac\u5b89\u7279\u521b\u65b0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"supplier":null,"mobiles":[{"id":5971,"contact_id":5183,"mobile":"18533246531","mp_open_id":null}]},{"id":3707,"key":3707,"name":"\u5eb7\u5eb7","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":982,"supplier_id":null,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"supplier":null,"mobiles":[{"id":4469,"contact_id":3707,"mobile":"13501082327","mp_open_id":"oagch6YflxLDs77tGxQ4wG__LvyY"}]},{"id":501,"key":501,"name":"\u5eb7\u78ca\u7530","telephone":"8266009","telephone_area_code":"0535","telephone_extension_number":"","sex":"M","client_id":89,"supplier_id":null,"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)"},"supplier":null,"mobiles":[{"id":3875,"contact_id":501,"mobile":"18053580127","mp_open_id":"oagch6WsjX__L0Ozxx8Pegmd6iM4"}]},{"id":3865,"key":3865,"name":"\u5eb7\u660e\u5cf0","telephone":"82637816","telephone_area_code":"010","telephone_extension_number":"810","sex":"M","client_id":null,"supplier_id":223,"client":null,"supplier":{"id":223,"key":223,"name":"\u5353\u8c6a(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8"},"mobiles":[{"id":4684,"contact_id":3865,"mobile":"18500321591","mp_open_id":null}]},{"id":4771,"key":4771,"name":"\u5eb7\u5973\u58eb(\u6d77\u4e8c\u5c45\u59d4\u4f1a)","telephone":"68810037","telephone_area_code":"010","telephone_extension_number":"","sex":"M","client_id":2499,"supplier_id":null,"client":{"id":2499,"key":2499,"name":"\u540c\u65b9\u552e\u540e\u670d\u52a1\u7528\u6237"},"supplier":null,"mobiles":[]},{"id":4981,"key":4981,"name":"\u5eb7\u946b","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":2682,"supplier_id":null,"client":{"id":2682,"key":2682,"name":"PA\u6e20\u9053-\u5317\u4eac\u6770\u521b\u8bda\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"supplier":null,"mobiles":[{"id":5777,"contact_id":4981,"mobile":"13718022979","mp_open_id":null}]},{"id":3670,"key":3670,"name":"\u5eb7\u946b","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":null,"supplier_id":425,"client":null,"supplier":{"id":425,"key":425,"name":"\u5317\u4eac\u6770\u521b\u8bda\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"mobiles":[{"id":4356,"contact_id":3670,"mobile":"13718022979","mp_open_id":null}]},{"id":1263,"key":1263,"name":"\u5eb7\u9662\u957f","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":14,"supplier_id":null,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"supplier":null,"mobiles":[{"id":786,"contact_id":1263,"mobile":"13691329111","mp_open_id":null}]},{"id":2609,"key":2609,"name":"\u5eb7\u9707","telephone":"59293028","telephone_area_code":"010","telephone_extension_number":"","sex":"M","client_id":null,"supplier_id":71,"client":null,"supplier":{"id":71,"key":71,"name":"\u8054\u60f3\u51cc\u62d3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"mobiles":[{"id":4211,"contact_id":2609,"mobile":"13910516194","mp_open_id":null}]},{"id":399,"key":399,"name":"\u90a2\u7acb\u5eb7","telephone":"010-84386187","telephone_area_code":null,"telephone_extension_number":null,"sex":"M","client_id":null,"supplier_id":143,"client":null,"supplier":{"id":143,"key":143,"name":"\u6613\u5b89\u4fe1\u7535\u8111\u7cfb\u7edf\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8"},"mobiles":[{"id":387,"contact_id":399,"mobile":"13910730704","mp_open_id":null}]},{"id":4469,"key":4469,"name":"\u4e8e\u8001\u5e08(\u77f3\u666f\u5c71\u536b\u751f\u5065\u5eb7\u59d4\u5458\u4f1a)","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":2499,"supplier_id":null,"client":{"id":2499,"key":2499,"name":"\u540c\u65b9\u552e\u540e\u670d\u52a1\u7528\u6237"},"supplier":null,"mobiles":[{"id":5288,"contact_id":4469,"mobile":"18611465041","mp_open_id":null}]}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.173 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-06-12 16:03:40', 18134272) RETURNING "id"
16:03:40.741	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (6064, 4420, 896, 3858, 2509, 5717, 1131, 5183, 3707, 501, 3865, 4771, 4981, 3670, 1263, 2609, 399, 4469)
16:03:40.729	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
16:03:40.740	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (223, 46, 425, 71, 143)
16:03:40.731	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:03:40.739	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3337, 2136, 391, 39, 3233, 2796, 982, 89, 2499, 2682, 14)
16:03:40.728	0.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta