ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6944c9c693a8d: POST https://beta.jinchangxiao.com/vue/sales-order-item/of-project at 2025-12-19 11:43:02 am by 223.72.15.22

Database Queries

总计21条数据
TimeDurationTypeQuery
  
11:43:02.6183.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
11:43:02.6231.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
11:43:02.6252.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:43:02.6291.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4048'

[+] Explain
11:43:02.63513.5 msSELECTSELECT COUNT(*) FROM (SELECT DISTINCT s.* FROM "a57be577deb434"."tbl_sales_order_items" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_users" "salesRep" ON "salesRep"."id" = "client"."sales_rep" LEFT JOIN "a57be577deb434"."tbl_products" "product" ON "product"."id" = "product_id" LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON "project"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON "supplier"."id" = "supplier_id" LEFT JOIN "a57be577deb434"."tbl_sales_order_item_renew_logs" "log" ON log.sales_order_item_id = s.id WHERE ("client"."deleted"=FALSE) AND (("client"."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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND (("s"."project_id"=4048) OR ("log"."project_id"=4048)) GROUP BY "s"."id" ORDER BY "s"."sales_date" DESC, "s"."created_at" DESC) "c"

[+] Explain
11:43:02.6498.2 msSELECTSELECT DISTINCT s.* FROM "a57be577deb434"."tbl_sales_order_items" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_users" "salesRep" ON "salesRep"."id" = "client"."sales_rep" LEFT JOIN "a57be577deb434"."tbl_products" "product" ON "product"."id" = "product_id" LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON "project"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON "supplier"."id" = "supplier_id" LEFT JOIN "a57be577deb434"."tbl_sales_order_item_renew_logs" "log" ON log.sales_order_item_id = s.id WHERE ("client"."deleted"=FALSE) AND (("client"."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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND (("s"."project_id"=4048) OR ("log"."project_id"=4048)) GROUP BY "s"."id" ORDER BY "s"."sales_date" DESC, "s"."created_at" DESC LIMIT 20

[+] Explain
11:43:02.6570.4 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661

[+] Explain
11:43:02.6580.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:43:02.6590.8 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
11:43:02.6600.3 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=4048

[+] Explain
11:43:02.6600.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1774, 2166)

[+] Explain
11:43:02.6610.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 721)

[+] Explain
11:43:02.6610.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:43:02.6620.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
11:43:02.6620.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4

[+] Explain
11:43:02.6633.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_order_item_remind_receivers" WHERE "sales_order_item_id" IN (13657, 13656, 13482)

[+] Explain
11:43:02.6670.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:43:02.6670.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
11:43:02.6680.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_order_item_renew_logs" WHERE "sales_order_item_id" IN (13657, 13656, 13482) ORDER BY "sales_date", "created_at"

[+] Explain
11:43:02.6684.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=27) AND ("object_id" IN (13657, 13656, 13482))

[+] Explain
11:43:02.6751.7 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/sales-order-item/of-project', '{"page":"1","id":"4048","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"id":13657,"sales_order_id":"","product_id":1774,"parent":"","sn":"","supplier_id":431,"order":0,"created_by":1001,"created_at":"2025-12-19 11:42:57","updated_at":"2025-12-19 11:42:57","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"","new_maintenance_deadline":"","client_id":1661,"project_id":4048,"sales_rep":1001,"sales_date":"2025-12-19","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"5345","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":76,"erp_sales_gift_id":"","client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":4048,"key":4048,"name":"\u6d4b\u8bd5\u5220\u9664\u5546\u673a\u540e\uff0c\u9500\u552e\u8ba2\u5355\u662f\u5426\u540c\u6b65\u5220\u9664"},"product":{"id":1774,"key":1774,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248"},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"salesOrderItemRemindReceivers":[{"id":12386,"sales_order_item_id":13657,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":13656,"sales_order_id":"","product_id":2166,"parent":"","sn":"","supplier_id":721,"order":0,"created_by":1001,"created_at":"2025-12-19 11:42:56","updated_at":"2025-12-19 11:42:56","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"","new_maintenance_deadline":"","client_id":1661,"project_id":4048,"sales_rep":1001,"sales_date":"2025-12-19","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"4554","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":76,"erp_sales_gift_id":"","client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":4048,"key":4048,"name":"\u6d4b\u8bd5\u5220\u9664\u5546\u673a\u540e\uff0c\u9500\u552e\u8ba2\u5355\u662f\u5426\u540c\u6b65\u5220\u9664"},"product":{"id":2166,"key":2166,"name":"Q28-100G-A5H"},"supplier":{"id":721,"key":721,"name":"\u5317\u4eac\u7b97\u529b\u4e4b\u5149\u901a\u4fe1\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"salesOrderItemRemindReceivers":[{"id":12385,"sales_order_item_id":13656,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":13482,"sales_order_id":"","product_id":1774,"parent":"","sn":"","supplier_id":431,"order":0,"created_by":1001,"created_at":"2025-12-18 10:04:09","updated_at":"2025-12-18 10:04:09","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"","new_maintenance_deadline":"","client_id":1661,"project_id":4048,"sales_rep":1001,"sales_date":"2025-12-18","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"3333","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":71,"erp_sales_gift_id":"","client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":4048,"key":4048,"name":"\u6d4b\u8bd5\u5220\u9664\u5546\u673a\u540e\uff0c\u9500\u552e\u8ba2\u5355\u662f\u5426\u540c\u6b65\u5220\u9664"},"product":{"id":1774,"key":1774,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248"},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"salesOrderItemRemindReceivers":[{"id":12211,"sales_order_item_id":13482,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":3,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-19 11:43:02') RETURNING "id"

[+] Explain