Performance Profiling

Total processing time: 21 ms; Peak memory: 2.195 MB. Show Profiling Timeline

总计5条数据

Time	Duration	Category	Info

17:39:27.847	3.9 ms	yii\db\Command::query	SELECT "c"."id" AS "key", "c"."name", "u"."name" AS "sales_rep_name" FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON c.sales_rep = u.id WHERE (("c"."name" ILIKE '%yt%') OR ("c"."pinyin_shortcut" ILIKE '%yt%')) AND (1 = 1) AND ("c"."deleted"=FALSE) AND ("c"."sales_rep" IS NOT NULL) LIMIT 20
17:39:27.840	3.5 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u'
17:39:27.838	2.6 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:39:27.852	1.8 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/search/client-by-name-with-sales-rep', '{"access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","device_type":"2","is_self":"1","name":"yt","posttime":"1751103616","token":"d655bab8f774a04de0c0c5faf017ab2e","version_code":"1141"}', '{"code":200,"data":[{"key":2330,"name":"\u8fbd\u5b81\u5e86\u9633\u7279\u79cd\u5316\u5de5\u6709\u9650\u516c\u53f8","sales_rep_name":"\u970d\u536b\u8d85"},{"key":2594,"name":"\u4e2d\u77f3\u6cb9\u4e2d\u4e9a\u5929\u7136\u6c14\u7ba1\u9053\u6709\u9650\u516c\u53f8\/\u4e2d\u6cb9\u56fd\u9645\u7ba1\u9053\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep_name":"\u8d75\u6657\u7131"},{"key":3106,"name":"\u5929\u6d25\u5fd7\u8d3a\u4e91\u5929\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep_name":"\u7fc1\u5bb6\u6210"},{"key":2411,"name":"\u70df\u53f0\u51cc\u4e91\u5409\u6069\u65af\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep_name":"\u970d\u536b\u8d85"},{"key":2120,"name":"\u8fbd\u5b81\u5e86\u9633\u7279\u79cd\u5316\u5de5\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep_name":"\u4f0a\u5cfb\u8fb0"},{"key":2129,"name":"\u5317\u4eac\u4e2d\u5408\u4e91\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep_name":"\u62d3\u5c0f\u6587"},{"key":1175,"name":"\u5317\u4eac\u82f1\u901a\u8d5b\u4e3a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep_name":"\u5218\u4eba\u8bda"},{"key":3084,"name":"\u5317\u4eac\u4e30\u5408\u5b87\u6cf0\u751f\u7269\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep_name":"\u7fc1\u5bb6\u6210"},{"key":3116,"name":"\u4e2d\u56fd\u77f3\u6cb9\u5929\u7136\u6c14\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep_name":"\u7fc1\u5bb6\u6210"},{"key":2480,"name":"\u4e2d\u56fd\u5175\u5668\u5de5\u4e1a\u7b2c\u4e94\u4e8c\u7814\u7a76\u6240\u70df\u53f0\u5206\u6240","sales_rep_name":"\u970d\u536b\u8d85"},{"key":3161,"name":"\u79d1\u5c24\u7279\u8f6f\u4ef6\u516c\u53f8","sales_rep_name":"\u7fc1\u5bb6\u6210"},{"key":3156,"name":"\u6c5f\u82cf\u4e91\u9014\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8","sales_rep_name":"\u7fc1\u5bb6\u6210"},{"key":2329,"name":"\u8fbd\u5b81\u5e86\u9633\u7279\u79cd\u6750\u6599\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep_name":"\u970d\u536b\u8d85"},{"key":3214,"name":"\u4e2d\u56fd\u77f3\u6cb9\u5929\u7136\u6c14\u80a1\u4efd\u6709\u9650\u516c\u53f8\u89c4\u5212\u603b\u9662","sales_rep_name":"\u7fc1\u5bb6\u6210"},{"key":2162,"name":"\u5317\u4eac\u7f8e\u8054\u6613\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\u2014\u4ee3\u7406\u5546","sales_rep_name":"\u62d3\u5c0f\u6587"},{"key":2430,"name":"\u4e2d\u5175\u5317\u6597\u4ea7\u4e1a\u6295\u8d44\u6709\u9650\u516c\u53f8","sales_rep_name":"\u970d\u536b\u8d85"},{"key":287,"name":"\u5317\u4eac\u5954\u9a70\u6c7d\u8f66\u6709\u9650\u516c\u53f8\uff08\u70df\u53f0\u4fca\u9a70\u7535\u6c14\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6d69\u60a6\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09","sales_rep_name":"\u82cf\u6e05\u4e91"}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-28 17:39:27') RETURNING "id"
17:39:27.845	1.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000