Performance Profiling

Total processing time: 128 ms; Peak memory: 5.161 MB. Show Profiling Timeline

总计13条数据

Time	Duration	Category	Info

21:01:13.847	21.8 ms	yii\db\Command::query	SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=14) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (4148, 2991, 55, 1826, 1368, 57, 56, 478)) GROUP BY "object_id"
21:01:13.827	19.8 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (4148, 2991, 55, 1826, 1368, 57, 56, 478)) GROUP BY "object_id"
21:01:13.876	2.5 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, 2, 1161, 'v2/contact/of-supplier', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"2","id":"45","posttime":"1784120448","token":"e5b161d675d17e5936ffb857b4293563","version_code":"1161"}', '{"code":200,"data":{"list":[{"id":4148,"name":"\u4f55\u666f\u4f1a","email":"","pinyin_shortcut":"hjh","sex":"F","birth_date":null,"department":"\u6df1\u4fe1\u670d","job_position":"\u9500\u552e","mobile":"","telephone":"","client_id":null,"supplier_id":45,"created_by":1011,"created_at":"2022-09-28 16:31:04","updated_at":"2022-09-28 16:31:04","user_status":2,"description":"","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"he","pinyin2":"jing","pinyin3":"hui","pinyin4":null,"namecut1":"\u4f55","namecut2":"\u666f","namecut3":"\u4f1a","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":4975,"contact_id":4148,"mobile":"13935180719","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":2991,"name":"\u5218\u6ca3\u53f6","email":"fengye_liu@cn.synnex-grp.com","pinyin_shortcut":"lfy","sex":"F","birth_date":null,"department":"EMC\u5b58\u50a8","job_position":"\u5ba2\u6237\u7ecf\u7406","mobile":"","telephone":"50855600","client_id":null,"supplier_id":45,"created_by":1011,"created_at":"2019-11-19 11:05:37","updated_at":"2019-11-19 11:05:37","user_status":2,"description":"","contact_type":"2","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"2715","mp_open_id":null,"pinyin1":"liu","pinyin2":"feng","pinyin3":"ye","pinyin4":null,"namecut1":"\u5218","namecut2":"\u6ca3","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":3173,"contact_id":2991,"mobile":"18519207707","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":55,"name":"\u6ee1\u5f00\u4eae","email":"kailiang_man@cn.synnex-grp.com","pinyin_shortcut":"mkl","sex":"M","birth_date":null,"department":"EMC\u5b58\u50a8\u9500\u552e\u90e8","job_position":"\u9500\u552e\u7ecf\u7406","mobile":"","telephone":"82025050","client_id":null,"supplier_id":45,"created_by":1011,"created_at":"2017-02-13 11:15:58","updated_at":"2019-11-19 11:03:01","user_status":2,"description":"QQ:5705462","contact_type":"2","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"2205","mp_open_id":null,"pinyin1":"man","pinyin2":"kai","pinyin3":"liang","pinyin4":null,"namecut1":"\u6ee1","namecut2":"\u5f00","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":3172,"contact_id":55,"mobile":"13601257141","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":1826,"name":"\u674e\u660e","email":"","pinyin_shortcut":"lm","sex":"M","birth_date":null,"department":"\u9510\u6377","job_position":"\u9500\u552e\u7ecf\u7406","mobile":null,"telephone":"","client_id":null,"supplier_id":45,"created_by":1011,"created_at":"2018-03-14 09:23:25","updated_at":"2018-03-14 09:23:25","user_status":2,"description":"","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"ming","pinyin3":null,"pinyin4":null,"namecut1":"\u674e","namecut2":"\u660e","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":1320,"contact_id":1826,"mobile":"15901008280","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":1368,"name":"\u5468\u8273\u83ca","email":"","pinyin_shortcut":"zyj","sex":"M","birth_date":null,"department":"\u4ea7\u54c1\u90e8","job_position":"\u4ea7\u54c1\u7ecf\u7406","mobile":null,"telephone":"","client_id":null,"supplier_id":45,"created_by":5023,"created_at":"2017-12-05 15:10:51","updated_at":"2017-12-05 15:10:51","user_status":2,"description":"","contact_type":"2","contact_attitude":null,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"zhou","pinyin2":"yan","pinyin3":"ju","pinyin4":null,"namecut1":"\u5468","namecut2":"\u8273","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":5023,"email":"60c33652136bd_xujingnan@toast.com.cn","name":"\u5f90\u4eac\u5357","user_status":"-1","pinyin_shortcut":"xjn","sex":"F","birth_date":"1987-05-18","entry_date":"2017-09-04","department_id":3,"department_position_id":18,"mobile":"60c3365213702_13466320295","telephone":"88864628","created_at":"2017-09-06 11:34:45","updated_at":"2021-06-11 18:09:22","id_number":"110109198705180027","native_place":"\u5317\u4eac","graduate_school":"\u5317\u4eac\u7535\u5b50\u79d1\u6280\u804c\u4e1a\u5b66\u9662","specialty":"\u56fd\u9645\u5546\u52a1\uff08\u7269\u6d41\uff09","education":"\u4e13\u79d1","telephone_area_code":"","telephone_extension_number":"819","leave_date":"2021-06-11","pinyin1":"xu","pinyin2":"jing","pinyin3":"nan","pinyin4":null,"namecut1":"\u5f90","namecut2":"\u4eac","namecut3":"\u5357","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":false,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":989,"contact_id":1368,"mobile":"\u202d136 0119 9333\u202c","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":57,"name":"\u5f8b\u5fae","email":"","pinyin_shortcut":"lw","sex":"F","birth_date":null,"department":"Netapp\u9500\u552e\u90e8","job_position":"\u52a9\u7406","mobile":null,"telephone":"010-82025050-2363","client_id":null,"supplier_id":45,"created_by":1011,"created_at":"2017-02-13 11:19:56","updated_at":"2017-02-13 11:19:56","user_status":2,"description":"","contact_type":"2","contact_attitude":null,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"lyu","pinyin2":"wei","pinyin3":null,"pinyin4":null,"namecut1":"\u5f8b","namecut2":"\u5fae","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":52,"contact_id":57,"mobile":"","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":56,"name":"\u5b5f\u9759\u6587","email":"jingwen_meng@cn.synnex-grp.com","pinyin_shortcut":"mjw","sex":"F","birth_date":null,"department":"\u534e\u4e3a\u9500\u552e\u90e8","job_position":"\u9500\u552e\u7ecf\u7406","mobile":null,"telephone":"010-82025050-2362","client_id":null,"supplier_id":45,"created_by":1011,"created_at":"2017-02-13 11:17:01","updated_at":"2017-02-13 11:17:01","user_status":2,"description":"","contact_type":"2","contact_attitude":null,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"meng","pinyin2":"jing","pinyin3":"wen","pinyin4":null,"namecut1":"\u5b5f","namecut2":"\u9759","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":51,"contact_id":56,"mobile":"13911189310","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":478,"name":"\u674e\u68a6\u9f99","email":"","pinyin_shortcut":"lml","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8\uff0dcitrix","job_position":"\u5de5\u7a0b\u5e08\uff0d\u4e2d\u7ea7","mobile":null,"telephone":"","client_id":null,"supplier_id":45,"created_by":1011,"created_at":"2017-04-07 14:24:43","updated_at":"2018-12-12 14:35:14","user_status":1,"description":"","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"meng","pinyin3":"long","pinyin4":null,"namecut1":"\u674e","namecut2":"\u68a6","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":1,"status":"\u79bb\u804c","description":"","created_by":1000,"created_at":"2016-10-31 21:28:29","updated_at":"2016-10-31 21:28:29"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":2451,"contact_id":478,"mobile":"15810231121","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0}],"pagenation":{"totalcount":8,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"111.9.5.127","ua":"jinchangxiao\/2.3.158 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-07-15 21:01:13', 120764160) RETURNING "id"
21:01:13.819	1.8 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT c. FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id WHERE "supplier"."id"='45' GROUP BY "c"."id" ORDER BY (case c.user_status when 3 then 1 when 1 then 0 else c.user_status end) DESC, c.updated_at DESC) "c"
21:01:13.821	1.6 ms	yii\db\Command::query	SELECT c.* FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id WHERE "supplier"."id"='45' GROUP BY "c"."id" ORDER BY (case c.user_status when 3 then 1 when 1 then 0 else c.user_status end) DESC, c.updated_at DESC LIMIT 10
21:01:13.825	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (4148, 2991, 55, 1826, 1368, 57, 56, 478)
21:01:13.812	0.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
21:01:13.823	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id" IN (2, 1)
21:01:13.825	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_contact_key_roles" WHERE "contact_id" IN (4148, 2991, 55, 1826, 1368, 57, 56, 478) ORDER BY "key_role"
21:01:13.814	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
21:01:13.824	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5023)
21:01:13.817	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='45'
21:01:13.812	0.3 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta