Performance Profiling

Total processing time: 277 ms; Peak memory: 4.163 MB. Show Profiling Timeline

总计6条数据

Time	Duration	Category	Info

15:32:51.498	170.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_user_action_logs" WHERE ("object_id" IN (SELECT "c"."id" FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_client_classes" "cl" ON cl.id = c.client_class LEFT JOIN "a57be577deb434"."tbl_client_address_rels" "car" ON car.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_addresses" "a" ON car.address_id = a.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "project_status"=3 GROUP BY "client_id") "p" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.client_id = c.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN (SELECT extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days, max(end_at) as last_contact, client_id FROM "a57be577deb434"."tbl_work_logs" WHERE "is_draft"=FALSE GROUP BY "client_id") "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = c.id AND ttr.term_id = 14 LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_contacts" WHERE lower(name) LIKE '%44方式是对方%' GROUP BY "client_id") "cc" ON cc.client_id = c.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE (lower(pn) LIKE '%44方式是对方%') OR (lower(sn) LIKE '%44方式是对方%') OR (lower(description) LIKE '%44方式是对方%') GROUP BY "client_id") "s" ON c.id = s.client_id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE ("pinyin_shortcut" ILIKE '%44方式是对方%') OR ("project_title" ILIKE '%44方式是对方%') OR ("description" ILIKE '%44方式是对方%') OR ("comment" ILIKE '%44方式是对方%') GROUP BY "client_id") "pp" ON c.id = pp.client_id WHERE (("cc"."client_id" IS NOT NULL) OR ("s"."client_id" IS NOT NULL) OR ("pp"."client_id" IS NOT NULL) OR (lower(c.name) LIKE '%44方式是对方%') OR ("c"."pinyin_shortcut" LIKE '%44方式是对方%') OR (lower(c.description) LIKE '%44方式是对方%') OR (lower(c.it_budget) LIKE '%44方式是对方%') OR (lower(c.main_business) LIKE '%44方式是对方%') OR (lower(c.deployment_mode) LIKE '%44方式是对方%') OR (lower(c.it_per_num) LIKE '%44方式是对方%') OR (lower(c.public_relations_difficulty) LIKE '%44方式是对方%') OR (lower(c.it_status) LIKE '%44方式是对方%') OR (lower(c.decision_process) LIKE '%44方式是对方%') OR (lower(c.coach) LIKE '%44方式是对方%') OR (lower(c.competitor) LIKE '%44方式是对方%') OR (lower(c.main_product) LIKE '%44方式是对方%') OR (lower(c.headcount) LIKE '%44方式是对方%') OR (lower(c.peers) LIKE '%44方式是对方%') OR (lower(c.supplier) LIKE '%44方式是对方%')) AND (("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("deleted"=FALSE) GROUP BY "c"."id" ORDER BY "c"."id")) AND ("object_type"='10') ORDER BY "created_at" DESC LIMIT 20
15:32:51.407	90.0 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_user_action_logs" WHERE ("object_id" IN (SELECT "c"."id" FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_client_classes" "cl" ON cl.id = c.client_class LEFT JOIN "a57be577deb434"."tbl_client_address_rels" "car" ON car.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_addresses" "a" ON car.address_id = a.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "project_status"=3 GROUP BY "client_id") "p" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.client_id = c.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN (SELECT extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days, max(end_at) as last_contact, client_id FROM "a57be577deb434"."tbl_work_logs" WHERE "is_draft"=FALSE GROUP BY "client_id") "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = c.id AND ttr.term_id = 14 LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_contacts" WHERE lower(name) LIKE '%44方式是对方%' GROUP BY "client_id") "cc" ON cc.client_id = c.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE (lower(pn) LIKE '%44方式是对方%') OR (lower(sn) LIKE '%44方式是对方%') OR (lower(description) LIKE '%44方式是对方%') GROUP BY "client_id") "s" ON c.id = s.client_id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE ("pinyin_shortcut" ILIKE '%44方式是对方%') OR ("project_title" ILIKE '%44方式是对方%') OR ("description" ILIKE '%44方式是对方%') OR ("comment" ILIKE '%44方式是对方%') GROUP BY "client_id") "pp" ON c.id = pp.client_id WHERE (("cc"."client_id" IS NOT NULL) OR ("s"."client_id" IS NOT NULL) OR ("pp"."client_id" IS NOT NULL) OR (lower(c.name) LIKE '%44方式是对方%') OR ("c"."pinyin_shortcut" LIKE '%44方式是对方%') OR (lower(c.description) LIKE '%44方式是对方%') OR (lower(c.it_budget) LIKE '%44方式是对方%') OR (lower(c.main_business) LIKE '%44方式是对方%') OR (lower(c.deployment_mode) LIKE '%44方式是对方%') OR (lower(c.it_per_num) LIKE '%44方式是对方%') OR (lower(c.public_relations_difficulty) LIKE '%44方式是对方%') OR (lower(c.it_status) LIKE '%44方式是对方%') OR (lower(c.decision_process) LIKE '%44方式是对方%') OR (lower(c.coach) LIKE '%44方式是对方%') OR (lower(c.competitor) LIKE '%44方式是对方%') OR (lower(c.main_product) LIKE '%44方式是对方%') OR (lower(c.headcount) LIKE '%44方式是对方%') OR (lower(c.peers) LIKE '%44方式是对方%') OR (lower(c.supplier) LIKE '%44方式是对方%')) AND (("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("deleted"=FALSE) GROUP BY "c"."id" ORDER BY "c"."id")) AND ("object_type"='10') ORDER BY "created_at" DESC) "c"
15:32:51.669	1.4 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/action-log/list', '{"is_all":"0","other_period":"currentfascalyear","Filter":{"name":"created_at","sort":"DESC"},"ClientSearch":{"group":"1","client_class":"","has_contact":"","cooperated":"","client_type":"","company_nature":"","client_industry":"","from_contact_name":"","from_contact":"","state_id":"","created_period":"","created_by":"","keyword":"44\u65b9\u5f0f\u662f\u5bf9\u65b9"},"page":"1","object_type":"10","attribute":"","web_access_token":"eLSqRe8hqEgPBX_zWO9QINJWKjv2Vvg4"}', '{"code":2000,"result":{"list":[],"pagenation":{"totalcount":0,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 15:32:51', 272530944) RETURNING "id"
15:32:51.398	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:32:51.401	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:32:51.398	0.2 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta