6a1d19bc35817: POST https://beta.jinchangxiao.com/vue/account/save-edit at 2026-06-01 01:33:48 pm by 43.224.72.82
Performance Profiling
Total processing time: 80 ms; Peak memory: 3.460 MB. Show Profiling Timeline
总计84条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 13:33:48.230 | 4.3 ms | yii\db\Command::execute | INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Logins', 5495, 'a:0:{}', '', 5493, '43.224.72.82') |
| 13:33:48.244 | 3.6 ms | yii\db\Command::execute | UPDATE "o6a13e2c574d5a"."tbl_users" SET "id"=5495, "department_id"=4, "department_position_id"=9, "updated_at"='now()' WHERE "id"=5495 |
| 13:33:48.269 | 2.8 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_settings" |
| 13:33:48.263 | 1.5 ms | yii\db\Command::execute | UPDATE "o6a13e2c574d5a"."tbl_user_role_change_logs" SET "end_at"='now()' WHERE "id"=7 |
| 13:33:48.264 | 1.1 ms | yii\db\Command::execute | INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\UserRoleChangeLogs', 7, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 5493, '43.224.72.82') |
| 13:33:48.251 | 1.0 ms | yii\db\Command::execute | DELETE FROM "o6a13e2c574d5a"."tbl_auth_assignments" WHERE ("user_id"='5495') AND ("item_name"='Treasurer') |
| 13:33:48.283 | 0.9 ms | yii\db\Command::execute | UPDATE "o6a13e2c574d5a"."tbl_engineer_group_relationships" SET "engineer_group_id"=1, "engineer_id"=5495 WHERE "id"=1 |
| 13:33:48.274 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "o6a13e2c574d5a"."tbl_user_resource_relationships" WHERE ("user_id"=5493) AND (group_id IS NOT NULL) |
| 13:33:48.296 | 0.8 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, 'o6a13e2c574d5a', 5493, 5, 'vue/account/save-edit', '{"Users":{"id":"5495","name":"\u903b\u8f91\u6d4b\u8bd5","email":"","sex":"F","entry_date":"2026-05-25","department_id":"4","department_position_id":"9","mobile":"17600801168","telephone":"","telephone_area_code":"","telephone_extension_number":"","id_number":"","native_place":"","graduate_school":"","specialty":"","education":"","userRoles":["Engineer"],"engineerGroup":"1","birth_date":"2026-05-25"},"web_access_token":"YwFaPh8a1dbQrFwOp6grZ7RlSTuMSejO"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u7528\u6237\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 13:33:48', 77216000) RETURNING "id" |
| 13:33:48.278 | 0.8 ms | yii\db\Command::execute | UPDATE "o6a13e2c574d5a"."tbl_sales_group_relationships" SET "group_id"=1 WHERE "sales_id"='5495' |
| 13:33:48.277 | 0.8 ms | yii\db\Command::execute | UPDATE "o6a13e2c574d5a"."tbl_clients" SET "sales_rep"=NULL, "is_overdue_remind"=FALSE WHERE "sales_rep"='5495' |
| 13:33:48.248 | 0.8 ms | yii\db\Command::execute | INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Users', 5495, 'a:0:{}', '', 5493, '43.224.72.82') |
| 13:33:48.255 | 0.7 ms | yii\db\Command::execute | INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\UserRoleChangeLogs', 5, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 5493, '43.224.72.82') |
| 13:33:48.257 | 0.7 ms | yii\db\Command::execute | INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\UserRoleChangeLogs', 6, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 5493, '43.224.72.82') |
| 13:33:48.280 | 0.7 ms | yii\db\Command::execute | INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Users', 5495, 'a:0:{}', '', 5493, '43.224.72.82') |
| 13:33:48.261 | 0.7 ms | yii\db\Command::execute | INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\UserRoleChangeLogs', 9, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 5493, '43.224.72.82') |
| 13:33:48.259 | 0.7 ms | yii\db\Command::execute | INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\UserRoleChangeLogs', 8, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 5493, '43.224.72.82') |
| 13:33:48.254 | 0.7 ms | yii\db\Command::execute | UPDATE "o6a13e2c574d5a"."tbl_user_role_change_logs" SET "end_at"='now()' WHERE "id"=5 |
| 13:33:48.261 | 0.7 ms | yii\db\Command::execute | UPDATE "o6a13e2c574d5a"."tbl_user_role_change_logs" SET "end_at"='now()' WHERE "id"=9 |
| 13:33:48.284 | 0.7 ms | yii\db\Command::execute | INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\EngineerGroupRelationships', 1, 'a:0:{}', '', 5493, '43.224.72.82') |
| 13:33:48.252 | 0.7 ms | yii\db\Command::execute | DELETE FROM "o6a13e2c574d5a"."tbl_auth_assignments" WHERE ("user_id"='5495') AND ("item_name"='FinancialAudit') |
| 13:33:48.257 | 0.7 ms | yii\db\Command::execute | UPDATE "o6a13e2c574d5a"."tbl_user_role_change_logs" SET "end_at"='now()' WHERE "id"=6 |
| 13:33:48.259 | 0.7 ms | yii\db\Command::execute | UPDATE "o6a13e2c574d5a"."tbl_user_role_change_logs" SET "end_at"='now()' WHERE "id"=8 |
| 13:33:48.250 | 0.7 ms | yii\db\Command::execute | DELETE FROM "o6a13e2c574d5a"."tbl_auth_assignments" WHERE ("user_id"='5495') AND ("item_name"='Admin') |
| 13:33:48.253 | 0.6 ms | yii\db\Command::execute | DELETE FROM "o6a13e2c574d5a"."tbl_auth_assignments" WHERE ("user_id"='5495') AND ("item_name"='CommercialAttache') |
| 13:33:48.250 | 0.6 ms | yii\db\Command::execute | DELETE FROM "o6a13e2c574d5a"."tbl_auth_assignments" WHERE ("user_id"='5495') AND ("item_name"='AccountManager') |
| 13:33:48.221 | 0.6 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5493 |
| 13:33:48.267 | 0.6 ms | yii\db\Command::query | SELECT "sales_id", "group_id" FROM "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" LEFT JOIN "o6a13e2c574d5a"."tbl_users" "u" ON sgr.sales_id = u.id GROUP BY "sales_id", "group_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 13:33:48.249 | 0.5 ms | yii\db\Command::query | SELECT DISTINCT "u"."id" FROM "o6a13e2c574d5a"."tbl_users" "u" LEFT JOIN "o6a13e2c574d5a"."tbl_auth_assignments" "aa" ON aa.user_id = u.id WHERE ("aa"."item_name"='Admin') AND ("u"."user_status"='1') |
| 13:33:48.286 | 0.4 ms | yii\db\Command::query | SELECT "sales_id", "group_id" FROM "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" LEFT JOIN "o6a13e2c574d5a"."tbl_users" "u" ON sgr.sales_id = u.id GROUP BY "sales_id", "group_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 13:33:48.225 | 0.4 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_auth_items" WHERE ("type"='1') AND ("name" IN ('Engineer', 'Admin', 'AccountManager', 'CommercialAttache', 'Treasurer', 'FinancialAudit')) |
| 13:33:48.266 | 0.4 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_groups" ORDER BY "level", "id" |
| 13:33:48.267 | 0.4 ms | yii\db\Command::query | SELECT "id", "name", "email" FROM "o6a13e2c574d5a"."tbl_users" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 13:33:48.224 | 0.4 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE ("id"='5495') AND ("user_status" IN ('1', '2')) |
| 13:33:48.272 | 0.4 ms | yii\db\Command::query | SELECT "a"."user_id", "b".* FROM "o6a13e2c574d5a"."tbl_auth_assignments" "a", "o6a13e2c574d5a"."tbl_auth_items" "b" WHERE (a.item_name = b.name) AND ("a"."user_id" IN (5493, 5495)) AND ("b"."type"=1) ORDER BY "user_id" |
| 13:33:48.254 | 0.4 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_user_role_change_logs" WHERE ("user_id"='5495') AND ("role_name"='Admin') AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 13:33:48.229 | 0.4 ms | yii\db\Command::query | SELECT "b".* FROM "o6a13e2c574d5a"."tbl_auth_assignments" "a", "o6a13e2c574d5a"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='5495') AND ("b"."type"=1) |
| 13:33:48.286 | 0.4 ms | yii\db\Command::query | SELECT "a"."user_id", "b".* FROM "o6a13e2c574d5a"."tbl_auth_assignments" "a", "o6a13e2c574d5a"."tbl_auth_items" "b" WHERE (a.item_name = b.name) AND ("a"."user_id" IN (5493, 5495)) AND ("b"."type"=1) ORDER BY "user_id" |
| 13:33:48.222 | 0.4 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 13:33:48.272 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" AS "id" FROM "o6a13e2c574d5a"."tbl_users" "u" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 13:33:48.249 | 0.3 ms | yii\db\Command::query | SELECT "b".* FROM "o6a13e2c574d5a"."tbl_auth_assignments" "a", "o6a13e2c574d5a"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='5495') AND ("b"."type"=1) |
| 13:33:48.228 | 0.3 ms | yii\db\Command::query | SELECT * FROM "global"."tbl_logins" WHERE ("mobile"='17600801168') AND ("id" != '5495') |
| 13:33:48.288 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "o6a13e2c574d5a"."tbl_user_resource_relationships" WHERE ("user_id"=5493) AND (group_id IS NOT NULL) |
| 13:33:48.281 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "o6a13e2c574d5a"."tbl_engineer_groups" WHERE "id"='1') |
| 13:33:48.276 | 0.3 ms | yii\db\Command::query | SELECT "b".* FROM "o6a13e2c574d5a"."tbl_auth_assignments" "a", "o6a13e2c574d5a"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='5495') AND ("b"."type"=1) |
| 13:33:48.284 | 0.3 ms | yii\db\Command::query | SELECT "b".* FROM "o6a13e2c574d5a"."tbl_auth_assignments" "a", "o6a13e2c574d5a"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='5495') AND ("b"."type"=1) |
| 13:33:48.281 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_engineer_group_relationships" WHERE "engineer_id"='5495' |
| 13:33:48.276 | 0.2 ms | yii\db\Command::query | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=312 |
| 13:33:48.273 | 0.2 ms | yii\db\Command::query | SELECT "u"."id" FROM "o6a13e2c574d5a"."tbl_users" "u" WHERE "id" IN (5493, 5495) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 13:33:48.275 | 0.2 ms | yii\db\Command::query | SELECT "u"."id" FROM "o6a13e2c574d5a"."tbl_users" "u" WHERE "id" IN (5493, 5495) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 13:33:48.227 | 0.2 ms | yii\db\Command::query | SELECT "id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "mobile"='17600801168' LIMIT 2 |
| 13:33:48.288 | 0.2 ms | yii\db\Command::query | SELECT "u"."id" FROM "o6a13e2c574d5a"."tbl_users" "u" WHERE "id" IN (5493, 5495) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 13:33:48.288 | 0.2 ms | yii\db\Command::query | SELECT "u"."id" FROM "o6a13e2c574d5a"."tbl_users" "u" WHERE "id" IN (5493, 5495) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 13:33:48.289 | 0.2 ms | yii\db\Command::query | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=312 |
| 13:33:48.282 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"='5495') |
| 13:33:48.242 | 0.2 ms | yii\db\Command::query | SELECT * FROM "global"."tbl_logins" WHERE ("mobile"='17600801168') AND ("id" != '5495') |
| 13:33:48.282 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"='5495') |
| 13:33:48.242 | 0.2 ms | yii\db\Command::query | SELECT "id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "mobile"='17600801168' LIMIT 2 |
| 13:33:48.285 | 0.2 ms | yii\db\Command::query | SELECT "id", "name", "email" FROM "o6a13e2c574d5a"."tbl_users" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 13:33:48.230 | 0.2 ms | yii\db\Command::query | SELECT * FROM "global"."tbl_logins" WHERE "id"='5495' |
| 13:33:48.262 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_user_role_change_logs" WHERE ("user_id"='5495') AND ("role_name"='CommercialAttache') AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 13:33:48.265 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_user_role_change_logs" WHERE ("user_id"='5495') AND ("role_name"='Engineer') AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 13:33:48.258 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_user_role_change_logs" WHERE ("user_id"='5495') AND ("role_name"='Treasurer') AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 13:33:48.287 | 0.2 ms | yii\db\Command::query | SELECT "u"."id" AS "id" FROM "o6a13e2c574d5a"."tbl_users" "u" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 13:33:48.228 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "o6a13e2c574d5a"."tbl_department_positions" WHERE "id"='9') |
| 13:33:48.286 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_settings" |
| 13:33:48.220 | 0.2 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 13:33:48.256 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_user_role_change_logs" WHERE ("user_id"='5495') AND ("role_name"='AccountManager') AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 13:33:48.260 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_user_role_change_logs" WHERE ("user_id"='5495') AND ("role_name"='FinancialAudit') AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 13:33:48.224 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_auth_assignments" WHERE "user_id"=5495 |
| 13:33:48.285 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_groups" ORDER BY "level", "id" |
| 13:33:48.273 | 0.2 ms | yii\db\Command::query | SELECT "user_id" FROM "o6a13e2c574d5a"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 13:33:48.229 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"='4') |
| 13:33:48.287 | 0.2 ms | yii\db\Command::query | SELECT "user_id" FROM "o6a13e2c574d5a"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 13:33:48.289 | 0.2 ms | yii\db\Command::query | SELECT "user_id", "sales_id" FROM "o6a13e2c574d5a"."tbl_user_resource_relationships" WHERE sales_id IS NOT NULL ORDER BY "user_id", "sales_id" |
| 13:33:48.278 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "o6a13e2c574d5a"."tbl_sales_group_relationships" WHERE "sales_id"='5495') |
| 13:33:48.243 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "o6a13e2c574d5a"."tbl_department_positions" WHERE "id"='9') |
| 13:33:48.282 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "o6a13e2c574d5a"."tbl_engineer_groups" WHERE "id"='1') |
| 13:33:48.276 | 0.2 ms | yii\db\Command::query | SELECT "user_id", "sales_id" FROM "o6a13e2c574d5a"."tbl_user_resource_relationships" WHERE sales_id IS NOT NULL ORDER BY "user_id", "sales_id" |
| 13:33:48.243 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"='4') |
| 13:33:48.276 | 0.1 ms | yii\db\Command::query | SELECT "group_id" FROM "o6a13e2c574d5a"."tbl_user_resource_relationships" WHERE ("user_id"=5495) AND (group_id IS NOT NULL) |
| 13:33:48.275 | 0.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "o6a13e2c574d5a"."tbl_user_resource_relationships" WHERE ("user_id"=5495) AND (sales_id IS NOT NULL) |
| 13:33:48.289 | 0.1 ms | yii\db\Command::query | SELECT "group_id" FROM "o6a13e2c574d5a"."tbl_user_resource_relationships" WHERE ("user_id"=5495) AND (group_id IS NOT NULL) |
| 13:33:48.288 | 0.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "o6a13e2c574d5a"."tbl_user_resource_relationships" WHERE ("user_id"=5495) AND (sales_id IS NOT NULL) |