ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a3a1947ec2b5: POST https://beta.jinchangxiao.com/vue/case/get-new-callback at 2026-06-23 01:27:35 pm by 221.216.117.25

Performance Profiling

Total processing time: 235 ms; Peak memory: 4.015 MB. Show Profiling Timeline

总计42条数据
TimeDurationCategoryInfo
  
13:27:36.08766.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2851, 672, 673, 2587, 6, 427, 3710, 2834, 4907)
13:27:36.00338.0 msyii\db\Command::querySELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=18) AND ("object_id"=9232) GROUP BY "object_id"
13:27:36.05531.1 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (2851, 672, 673, 2587, 6, 427, 3710, 2834, 4907)) GROUP BY "object_id"
13:27:36.17515.3 msyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_callback_questionnaires' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
13:27:36.1676.7 msyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_callback_questionnaires' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
13:27:36.1625.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_callback_questionnaires" WHERE "is_delete"=FALSE ORDER BY "order"
13:27:35.9893.7 msyii\db\Command::querySELECT i.*, i.left_at - i.arrived_at AS hours_spent FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = i.client_id WHERE "i"."case_id"=9232 GROUP BY "i"."id", "client"."id" ORDER BY "i"."left_at" DESC
13:27:36.1953.1 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/case/get-new-callback', '{"id":"9232","web_access_token":"s1xKbg9e3rlah-dvFsDEWCxiJPk9VpSm"}', '{"code":2000,"result":{"case":{"id":9232,"client_id":5,"contact_id":4907,"project_id":3150,"last_engineer":1023,"case_type":2,"case_status":4,"start_at":"2026-03-20 10:00:00","closed_at":"","points":25,"deduct_points_from":1004,"created_by":5360,"created_at":"2026-03-20 10:25:50","updated_at":"2026-03-22 20:29:54","case_no":"IM260320003","description":"\u4e00\u5b63\u5ea6\u5de1\u68c0","spent_time":"1 hour","alarm_before":null,"suspend_at":"","completed_at":"2026-03-22 20:29:54","mp_submit_contact_id":null,"attachment_id":null,"need_push":true,"task_group_id":null,"project":{"id":3150,"key":3150,"name":"2023\u5e74\u786c\u4ef6\u7eed\u4fdd-C"},"preSales":[],"implementRecords":[{"id":7524,"client_id":5,"contact_id":4907,"implement_type":2,"implement_method":3,"arrived_at":"2026-03-20 10:55:00","left_at":"2026-03-20 11:24:00","address":null,"has_following_work":false,"description":"\u5b9e\u65bd\u76ee\u6807\uff1a\u4e2d\u7535\u79d1\u592a\u529bCisco UCS\u53caNetApp\u5b58\u50a82026\u5e74\u7b2c\u4e00\u5b63\u5ea6\u5de1\u68c0\n\u5b8c\u6210\u60c5\u51b5\uff1a\u5b8c\u6210\u5de1\u68c0\u6570\u636e\u6536\u96c6\uff0c\u5f85\u7f16\u5199\u62a5\u544a\u540e\u4ea4\u4ed8\n\u95ee\u9898\u63cf\u8ff0\uff1a\u65e0\n\u8d39\u7528\uff1a\u5f80\u8fd4\u4ea4\u901a\u8d3970.17\u5143","created_by":1023,"created_at":"2026-03-20 10:55:14","updated_at":"2026-03-22 20:29:39","satisfaction_id":null,"implement_address":null,"following_work_content":null,"location_id":null,"client_address":null,"is_draft":false,"service_id":233,"case_id":9232,"location_in_id":21225,"location_out_id":21227,"ticket_no":"IM260320003001","client_document_id":null,"client_document_file":null,"indistance":70,"outdistance":41,"hours_spent":"00:29:00","location":null,"locationIn":{"id":21225,"key":21225,"lng":"116.309261067708","lat":"39.9846500651042","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e2d\u5173\u6751\u5927\u8857\u9760\u8fd1\u4e2d\u56fd\u5316\u5de5\u5927\u53a6(\u6d77\u6dc0\u897f\u8857)","time":"2026-03-20 10:55:00"},"locationOut":{"id":21227,"key":21227,"lng":"116.309806586371","lat":"39.9848158094618","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u56db\u73af\u897f\u8def\u9760\u8fd1\u7406\u60f3\u56fd\u9645\u5927\u53a6","time":"2026-03-20 11:24:00"},"service":{"id":233,"key":233,"name":"\u7efc\u5408\u670d\u52a1\u534a\u5929","brand_id":33,"type_id":1,"points_holiday":25,"points":25,"points_off_time":25},"hours_spent_display":"29\u5206\u949f","point_display":25}],"services":[{"id":233,"key":233,"name":"\u7efc\u5408\u670d\u52a1\u534a\u5929","serial_no":"ZH01","points":25,"points_off_time":25,"points_holiday":25}],"caseServices":[{"id":15504,"case_id":9232,"service_id":233,"quantity":1,"service":{"id":233,"serial_no":"ZH01","title":"\u7efc\u5408\u670d\u52a1\u534a\u5929","brand_id":33,"type_id":1,"description":"\u7efc\u5408\u670d\u52a1","points":25,"points_off_time":25,"points_holiday":25,"brand":{"id":33,"key":33,"name":"Toast"},"type":{"id":1,"key":1,"name":"\u5b89\u88c5\u670d\u52a1"}}}],"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":47,"logo":null,"sales_rep":1004},"commentCount":{"object_id":9232,"comment":4},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"lastEngineer":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065"},"uncompleteTickets":[],"callback":null},"contact":[{"id":2851,"name":"\u738b\u632f\u5b87","email":"","pinyin_shortcut":"wzy","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":5,"supplier_id":null,"created_by":1023,"created_at":"2019-08-13 14:30:55","updated_at":"2019-08-13 14:30:55","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"oagch6XiDXliwVQhD9zm2PSdzG_8","pinyin1":"wang","pinyin2":"zhen","pinyin3":"yu","pinyin4":null,"namecut1":"\u738b","namecut2":"\u632f","namecut3":"\u5b87","namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[{"id":2977,"contact_id":2851,"mobile":"15901038793","mp_open_id":"oagch6XiDXliwVQhD9zm2PSdzG_8"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null},{"id":672,"name":"\u8d75\u794e\u6960","email":"zhaoyinan@cetctaili.com","pinyin_shortcut":"zyn","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":5,"supplier_id":null,"created_by":1019,"created_at":"2017-05-22 01:34:22","updated_at":"2025-09-24 11:10:02","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhao","pinyin2":"yi","pinyin3":"nan","pinyin4":null,"namecut1":"\u8d75","namecut2":"\u794e","namecut3":"\u6960","namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1019,"key":1019,"name":"\u90dd\u5c06\u4f1f","sex":"M","user_status":"-1"},"mobiles":[{"id":690,"contact_id":672,"mobile":"15210521910","mp_open_id":"oagch6QM_GC393B6bNpMMKb4hWN0"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null},{"id":673,"name":"\u5f20\u6653\u5b87","email":"zhangxiaoyu@cetctaili.com","pinyin_shortcut":"zxy","sex":"M","birth_date":null,"department":"","job_position":"IT\u7f51\u7edc\u7ba1\u7406","mobile":"","telephone":"","client_id":5,"supplier_id":null,"created_by":1019,"created_at":"2017-05-22 01:35:39","updated_at":"2025-09-24 11:10:17","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhang","pinyin2":"xiao","pinyin3":"yu","pinyin4":null,"namecut1":"\u5f20","namecut2":"\u6653","namecut3":"\u5b87","namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1019,"key":1019,"name":"\u90dd\u5c06\u4f1f","sex":"M","user_status":"-1"},"mobiles":[{"id":1682,"contact_id":673,"mobile":"13811791019","mp_open_id":"oagch6Rsm2duOWpv8jfQ5YlqO_iA"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null},{"id":2587,"name":"\u6b66\u7693","email":"","pinyin_shortcut":"wh","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u90e8","job_position":"\u7f51\u7edc\u7ba1\u7406VPN\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":5,"supplier_id":null,"created_by":5082,"created_at":"2019-05-07 14:59:58","updated_at":"2019-05-07 15:56:15","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wu","pinyin2":"hao","pinyin3":null,"pinyin4":null,"namecut1":"\u6b66","namecut2":"\u7693","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5082,"key":5082,"name":"\u674e\u5fd7\u535a","sex":"M","user_status":"-1"},"mobiles":[{"id":2664,"contact_id":2587,"mobile":"13811556460","mp_open_id":null}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null},{"id":6,"name":"\u9ec4\u57d4\u6da6\u4e19","email":"huangfurunbing@cetctaili.com","pinyin_shortcut":"hprb","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u4e2d\u5fc3","job_position":"CIO","mobile":"","telephone":"62683370","client_id":5,"supplier_id":null,"created_by":1004,"created_at":"2017-02-08 16:34:57","updated_at":"2025-09-24 11:10:42","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"huang","pinyin2":"pu","pinyin3":"run","pinyin4":"bing","namecut1":"\u9ec4","namecut2":"\u57d4","namecut3":"\u6da6","namecut4":"\u4e19","is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","user_status":"1"},"mobiles":[{"id":706,"contact_id":6,"mobile":"13621133645","mp_open_id":null}],"commentCount":{"object_id":6,"comment":5},"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"},{"id":134,"key":134,"name":"\u8d22\u52a1\u51b3\u7b56\u4eba"},{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"},{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"},{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":427,"name":"\u5f20\u5e86\u6960","email":"zhangqingnan@cetctaili.com","pinyin_shortcut":"zqn","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":5,"supplier_id":null,"created_by":1016,"created_at":"2017-03-24 14:15:18","updated_at":"2025-09-24 11:10:30","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhang","pinyin2":"qing","pinyin3":"nan","pinyin4":null,"namecut1":"\u5f20","namecut2":"\u5e86","namecut3":"\u6960","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1016,"key":1016,"name":"\u8346\u626c","sex":"M","user_status":"-1"},"mobiles":[{"id":1305,"contact_id":427,"mobile":"13681154900","mp_open_id":null}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null},{"id":3710,"name":"\u4f0a","email":"","pinyin_shortcut":"y","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":5,"supplier_id":null,"created_by":1004,"created_at":"2021-08-30 13:16:14","updated_at":"2021-08-30 13:16:14","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"oagch6Qgh0hLshxjotnJB_u4tdbk","pinyin1":"yi","pinyin2":null,"pinyin3":null,"pinyin4":null,"namecut1":"\u4f0a","namecut2":null,"namecut3":null,"namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","user_status":"1"},"mobiles":[{"id":4479,"contact_id":3710,"mobile":"13911627225","mp_open_id":"oagch6Qgh0hLshxjotnJB_u4tdbk"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null},{"id":2834,"name":"\u6c6a\u6d77\u6d0b","email":"","pinyin_shortcut":"why","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":5,"supplier_id":null,"created_by":1023,"created_at":"2019-08-07 13:02:04","updated_at":"2019-08-07 13:02:04","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"oagch6ZnoQKpKn4-B9Jjs39B-Sto","pinyin1":"wang","pinyin2":"hai","pinyin3":"yang","pinyin4":null,"namecut1":"\u6c6a","namecut2":"\u6d77","namecut3":"\u6d0b","namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[{"id":2956,"contact_id":2834,"mobile":"18510329196","mp_open_id":"oagch6ZnoQKpKn4-B9Jjs39B-Sto"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null},{"id":4907,"name":"\u6881\u6d69","email":"","pinyin_shortcut":"lh","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":5,"supplier_id":null,"created_by":1023,"created_at":"2023-10-25 14:55:22","updated_at":"2023-10-25 14:55:22","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"liang","pinyin2":"hao","pinyin3":null,"pinyin4":null,"namecut1":"\u6881","namecut2":"\u6d69","namecut3":null,"namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[{"id":5703,"contact_id":4907,"mobile":"15531218979","mp_open_id":"oagch6QazT4G9l1_pPsUbT2YPKv0"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null}],"satisfaction_score_option":[{"key":4,"name":"\u4e0d\u6ee1\u610f"},{"key":6,"name":"\u4e00\u822c"},{"key":8,"name":"\u6ee1\u610f"},{"key":10,"name":"\u975e\u5e38\u6ee1\u610f"}],"skill_score_option":[{"key":4,"name":"\u4e0d\u6ee1\u610f"},{"key":6,"name":"\u4e00\u822c"},{"key":8,"name":"\u6ee1\u610f"},{"key":10,"name":"\u975e\u5e38\u6ee1\u610f"}],"satisfaction_score":["1","2","3","4","5","6","7","8","9","10"],"skill_score":["1","2","3","4","5","6","7","8","9","10"],"callbackQnas":[{"keyword":"","from":"","to":"","period":"","unread":0}],"pointDivision":[{"id":9284,"engineer_id":1023,"engineer":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065"}}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-06-23 13:27:36', 226313984) RETURNING "id"
13:27:35.9862.6 msyii\db\Command::querySELECT p.*, p.end_at - p.start_at AS hours_spent FROM "a57be577deb434"."tbl_pre_sales" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = p.client_id WHERE "p"."case_id"=9232 GROUP BY "p"."id", "client"."id" ORDER BY "p"."end_at" DESC
13:27:36.0442.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_implement_records" WHERE (("has_following_work"=TRUE) OR ("is_draft"=TRUE)) AND ("case_id"=9232)
13:27:36.0492.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "client_id"=5
13:27:35.9732.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:27:36.0471.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_callback_records" WHERE "case_id"=9232
13:27:36.1541.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (100, 96, 101, 102, 165, 179, 142, 184, 327, 305, 198, 201, 200, 8, 204, 5, 153, 2, 1, 229, 6, 7, 208, 107, 226, 94, 183, 188, 190, 105, 231, 207, 224, 223, 214, 219, 9, 210, 211, 227, 216, 93, 228, 11, 209, 217, 230, 218, 10, 213, 221, 225, 215, 222, 212, 164, 181, 313, 197, 199, 167, 172, 304, 189, 265, 174, 156, 332, 315, 319, 323, 114, 349, 353, 374, 377, 369, 373, 356, 433, 400, 340, 133, 134, 135, 136, 137, 139, 438, 439, 316)) ORDER BY "sort"
13:27:35.9781.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:27:36.1911.4 msyii\db\Command::querySELECT "id", "engineer_id" FROM "a57be577deb434"."tbl_case_assignments" WHERE "case_id"=9232
13:27:36.0541.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (2851, 672, 673, 2587, 6, 427, 3710, 2834, 4907)
13:27:35.9961.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_case_services" WHERE "case_id"=9232
13:27:36.0421.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=5
13:27:36.0010.9 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5360)
13:27:36.1560.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2851, 672, 673, 2587, 6, 427, 3710, 2834, 4907)
13:27:35.9830.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_cases" WHERE "id"='9232'
13:27:35.9970.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_case_services" WHERE "case_id"=9232
13:27:35.9860.7 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3150
13:27:35.9760.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:27:36.1570.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (100, 96, 101, 102, 165, 179, 142, 184, 327, 305, 198, 201, 200, 8, 204, 5, 153, 2, 1, 229, 6, 7, 208, 107, 226, 94, 183, 188, 190, 105, 231, 207, 224, 223, 214, 219, 9, 210, 211, 227, 216, 93, 228, 11, 209, 217, 230, 218, 10, 213, 221, 225, 215, 222, 212, 164, 181, 313, 197, 199, 167, 172, 304, 189, 265, 174, 156, 332, 315, 319, 323, 114, 349, 353, 374, 377, 369, 373, 356, 433, 400, 340, 133, 134, 135, 136, 137, 139, 438, 439, 316)) ORDER BY "sort"
13:27:35.9940.6 msyii\db\Command::querySELECT id, id as key, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id"=21225
13:27:35.9950.5 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name", "brand_id", "type_id", "points_holiday", "points", "points_off_time" FROM "a57be577deb434"."tbl_services" WHERE "id"=233
13:27:36.0020.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3
13:27:36.0530.4 msyii\db\Command::querySELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"=2
13:27:35.9990.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=33
13:27:36.0000.4 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_service_type" WHERE "id"=1
13:27:36.0530.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1023, 1019, 5082, 1004, 1016)
13:27:35.9720.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:27:36.0030.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_class", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=5
13:27:36.0430.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004
13:27:35.9980.3 msyii\db\Command::querySELECT "id", "serial_no", "title", "brand_id", "type_id", "description", "points", "points_off_time", "points_holiday" FROM "a57be577deb434"."tbl_services" WHERE "id"=233
13:27:36.1930.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1023
13:27:35.9950.3 msyii\db\Command::querySELECT id, id as key, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id"=21227
13:27:36.0000.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5360
13:27:36.0440.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1023
13:27:35.9970.3 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name", "serial_no", "points", "points_off_time", "points_holiday" FROM "a57be577deb434"."tbl_services" WHERE "id"=233