Performance Profiling

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

总计6条数据

Time	Duration	Category	Info

14:14:31.470	3.7 ms	yii\db\Command::query	SELECT COUNT(*) FROM (SELECT p.id, p.client_id, p.start_at, p.description, p.engineer_id, p.created_by, p.created_at, p.updated_at, p.following_work_content, p.project_status, p.end_at, p.location_id, p.is_draft, p.service_id, p.client_concerns, p.pre_sales_assessment, p.case_id, p.location_in_id, p.location_out_id, p.ticket_no, p.client_document_id, p.client_document_file, p.has_following_work, p.end_at - p.start_at AS hours_spent, p.indistance, p.outdistance FROM "a57be577deb434"."tbl_pre_sales" "p" LEFT JOIN "a57be577deb434"."tbl_cases" "ca" ON p.case_id = ca.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = p.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = ca.project_id LEFT JOIN "a57be577deb434"."tbl_pre_sales_product_types" "pt" ON p.id = pt.pre_sales_id LEFT JOIN "a57be577deb434"."tbl_client_types" "clientType" ON "clientType".id = client.client_type LEFT JOIN "a57be577deb434"."tbl_client_classes" "clientClass" ON "clientClass".id = client.client_class LEFT JOIN "a57be577deb434"."tbl_client_industries" "clientIndustry" ON "clientIndustry".id = client.client_industry LEFT JOIN "a57be577deb434"."tbl_users" "salesRep" ON "salesRep".id = client.sales_rep WHERE (("client"."deleted"=FALSE) OR ("ca"."client_id" IS NULL)) AND ("p"."created_by"=1000) AND ("is_draft"=FALSE) AND ("ca"."client_id"='2815') AND ("ca"."project_id"='3811') GROUP BY "p"."id" ORDER BY "is_draft" DESC, "p"."end_at" DESC) "c"
14:14:31.462	2.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd'
14:14:31.474	2.1 ms	yii\db\Command::query	SELECT p.id, p.client_id, p.start_at, p.description, p.engineer_id, p.created_by, p.created_at, p.updated_at, p.following_work_content, p.project_status, p.end_at, p.location_id, p.is_draft, p.service_id, p.client_concerns, p.pre_sales_assessment, p.case_id, p.location_in_id, p.location_out_id, p.ticket_no, p.client_document_id, p.client_document_file, p.has_following_work, p.end_at - p.start_at AS hours_spent, p.indistance, p.outdistance FROM "a57be577deb434"."tbl_pre_sales" "p" LEFT JOIN "a57be577deb434"."tbl_cases" "ca" ON p.case_id = ca.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = p.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = ca.project_id LEFT JOIN "a57be577deb434"."tbl_pre_sales_product_types" "pt" ON p.id = pt.pre_sales_id LEFT JOIN "a57be577deb434"."tbl_client_types" "clientType" ON "clientType".id = client.client_type LEFT JOIN "a57be577deb434"."tbl_client_classes" "clientClass" ON "clientClass".id = client.client_class LEFT JOIN "a57be577deb434"."tbl_client_industries" "clientIndustry" ON "clientIndustry".id = client.client_industry LEFT JOIN "a57be577deb434"."tbl_users" "salesRep" ON "salesRep".id = client.sales_rep WHERE (("client"."deleted"=FALSE) OR ("ca"."client_id" IS NULL)) AND ("p"."created_by"=1000) AND ("is_draft"=FALSE) AND ("ca"."client_id"='2815') AND ("ca"."project_id"='3811') GROUP BY "p"."id" ORDER BY "is_draft" DESC, "p"."end_at" DESC LIMIT 20
14:14:31.460	1.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:14:31.477	1.2 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, 0, 261, 'v2/search/pre-sales-by-self', '{"project_id":"3811","access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","client_id":"2815","device_type":"0","version_code":"261","page":"1","token":"d06d569432a1c40a317f2385d5eef830","case_id":"","posttime":"1751609672"}', '{"code":200,"data":{"list":[],"pagenation":{"totalcount":0,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-04 14:14:31') RETURNING "id"
14:14:31.465	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000