Performance Profiling

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

总计11条数据
TimeDurationCategoryInfo
  
14:32:37.5864.6 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/product/list-product-serie', '{"page":"1","ProductSeries":{"product_type":"2"}}', '{"code":2000,"result":{"list":[{"id":344,"name":"DDR4","product_component":4,"product_brand":9,"order":5,"description":"","created_by":1013,"created_at":"2019-01-04 15:53:32","updated_at":"2019-01-04 15:53:32","pinyin_shortcut":"DDR4","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":4,"key":4,"name":"\u670d\u52a1\u5668\u5185\u5b58"},"productBrand":{"id":9,"key":9,"name":"\u6234\u5c14\uff08DELL\uff09"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":343,"name":"PowerEdge R330 \u673a\u67b6\u5f0f\u670d\u52a1\u5668","product_component":2,"product_brand":9,"order":6,"description":"","created_by":1013,"created_at":"2019-01-04 15:12:24","updated_at":"2024-02-20 11:35:34","pinyin_shortcut":"PowerEdgeR330jjsfwq","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":9,"key":9,"name":"\u6234\u5c14\uff08DELL\uff09"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":318,"name":"\u8054\u60f3 SR650","product_component":6,"product_brand":4,"order":29,"description":"","created_by":1013,"created_at":"2018-11-30 14:41:02","updated_at":"2018-11-30 14:41:02","pinyin_shortcut":"lxSR650","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":6,"key":6,"name":"\u670d\u52a1\u5668\u7535\u6e90"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":316,"name":"XEON \u94f6\u724c","product_component":3,"product_brand":4,"order":30,"description":"","created_by":1013,"created_at":"2018-11-30 14:18:49","updated_at":"2018-11-30 14:18:49","pinyin_shortcut":"XEONyp","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":3,"key":3,"name":"\u670d\u52a1\u5668CPU"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":315,"name":"\u8054\u60f3 SR650 \u670d\u52a1\u5668","product_component":2,"product_brand":4,"order":31,"description":"","created_by":1013,"created_at":"2018-11-30 13:57:01","updated_at":"2024-01-08 14:45:35","pinyin_shortcut":"lxSR650fwq","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":305,"name":"PowerEdge R740 \u673a\u67b6\u5f0f\u670d\u52a1\u5668","product_component":2,"product_brand":9,"order":36,"description":"","created_by":1013,"created_at":"2018-11-22 17:17:24","updated_at":"2024-02-20 11:37:53","pinyin_shortcut":"PowerEdgeR740jjsfwq","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":9,"key":9,"name":"\u6234\u5c14\uff08DELL\uff09"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":298,"name":"GEN8 460W\u7535\u6e90","product_component":6,"product_brand":2,"order":43,"description":"","created_by":1013,"created_at":"2018-11-08 10:44:09","updated_at":"2024-01-19 15:43:58","pinyin_shortcut":"GEN8460Wdy","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":6,"key":6,"name":"\u670d\u52a1\u5668\u7535\u6e90"},"productBrand":{"id":2,"key":2,"name":"HP"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":290,"name":"\u601d\u79d1 C240M5 8\u76d8\u4f4d\u670d\u52a1\u5668","product_component":2,"product_brand":3,"order":49,"description":"","created_by":1013,"created_at":"2018-10-25 16:22:26","updated_at":"2024-01-12 10:30:28","pinyin_shortcut":"skC240M58pwfwq","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":278,"name":"DL20G9\u670d\u52a1\u5668","product_component":2,"product_brand":2,"order":58,"description":"","created_by":1013,"created_at":"2018-09-28 13:46:35","updated_at":"2024-01-16 17:00:35","pinyin_shortcut":"DL20G9fwq","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":2,"key":2,"name":"HP"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":276,"name":"\u8054\u60f3 EMULEX 16Gb \u5355\u53e3HBA\u5361","product_component":10,"product_brand":4,"order":59,"description":"","created_by":1013,"created_at":"2018-09-05 10:10:34","updated_at":"2024-02-19 13:20:29","pinyin_shortcut":"lxEMULEX16GbdkHBAk","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":10,"key":10,"name":"\u670d\u52a1\u5668HBA\u5361"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":270,"name":"\u601d\u79d1 FI6248\u7eed\u4fdd\u670d\u52a1","product_component":13,"product_brand":3,"order":64,"description":"","created_by":1013,"created_at":"2018-08-21 11:57:19","updated_at":"2024-01-12 13:33:35","pinyin_shortcut":"skFI6248xbfw","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":13,"key":13,"name":"\u670d\u52a1\u5668\u91d1\u724c\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":258,"name":"DL360G9\u670d\u52a1\u5668","product_component":2,"product_brand":2,"order":73,"description":"","created_by":1013,"created_at":"2018-06-21 16:54:15","updated_at":"2024-01-16 17:01:45","pinyin_shortcut":"DL360G9fwq","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":2,"key":2,"name":"HP"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":253,"name":"PowerEdge R940 \u673a\u67b6\u5f0f\u670d\u52a1\u5668","product_component":2,"product_brand":9,"order":78,"description":"","created_by":1013,"created_at":"2018-05-31 10:09:09","updated_at":"2024-02-20 11:38:06","pinyin_shortcut":"PowerEdgeR940jjsfwq","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":9,"key":9,"name":"\u6234\u5c14\uff08DELL\uff09"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":246,"name":"HPE QMH2672 2x 16GB Fibre Channel Mezzanine HBA","product_component":10,"product_brand":2,"order":84,"description":"","created_by":1013,"created_at":"2018-03-28 15:25:13","updated_at":"2024-01-22 10:38:27","pinyin_shortcut":"HPEQMH26722x16GBFibreChannelMezzanineHBA","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":10,"key":10,"name":"\u670d\u52a1\u5668HBA\u5361"},"productBrand":{"id":2,"key":2,"name":"HP"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":245,"name":"HP Ethernet 1Gb 4P 366M \u4e07\u5146\u7f51\u5361","product_component":9,"product_brand":2,"order":85,"description":"","created_by":1013,"created_at":"2018-03-28 15:20:34","updated_at":"2024-01-22 10:26:03","pinyin_shortcut":"HPEthernet1Gb4P366Mwzwk","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":9,"key":9,"name":"\u670d\u52a1\u5668\u7f51\u5361"},"productBrand":{"id":2,"key":2,"name":"HP"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":243,"name":"DDR2","product_component":4,"product_brand":2,"order":87,"description":"","created_by":1013,"created_at":"2018-01-25 16:44:40","updated_at":"2018-01-25 16:44:40","pinyin_shortcut":"DDR2","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":4,"key":4,"name":"\u670d\u52a1\u5668\u5185\u5b58"},"productBrand":{"id":2,"key":2,"name":"HP"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":238,"name":"\u8d85\u805a\u53d8FusionServer RH2288 V5\u670d\u52a1\u5668","product_component":2,"product_brand":7,"order":92,"description":"","created_by":1013,"created_at":"2018-01-10 11:31:59","updated_at":"2024-01-11 14:45:36","pinyin_shortcut":"cjbFusionServerRH2288V5fwq","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":237,"name":"\u8d85\u805a\u53d8FusionServer 5885H V5\u670d\u52a1\u5668","product_component":2,"product_brand":7,"order":93,"description":"","created_by":1013,"created_at":"2018-01-10 11:28:52","updated_at":"2024-01-11 14:45:29","pinyin_shortcut":"cjbFusionServer5885HV5fwq","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":223,"name":"NF8460M4\u670d\u52a1\u5668","product_component":2,"product_brand":24,"order":107,"description":"","created_by":1013,"created_at":"2017-12-15 14:32:55","updated_at":"2024-01-15 11:04:31","pinyin_shortcut":"NF8460M4fwq","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":24,"key":24,"name":"\u6d6a\u6f6e"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":220,"name":"SA5212M4\u670d\u52a1\u5668","product_component":2,"product_brand":24,"order":110,"description":"","created_by":1013,"created_at":"2017-12-04 11:12:10","updated_at":"2024-01-15 11:06:00","pinyin_shortcut":"SA5212M4fwq","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":24,"key":24,"name":"\u6d6a\u6f6e"},"can_update":true,"can_delete":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":278,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-06-30 14:32:37', 23123968) RETURNING "id"
14:32:37.5661.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:32:37.5771.1 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "product_component" IN (49, 42, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 141, 211, 215, 226) ORDER BY "order", "updated_at" DESC) "c"
14:32:37.5790.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "product_component" IN (49, 42, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 141, 211, 215, 226) ORDER BY "order", "updated_at" DESC LIMIT 20
14:32:37.5690.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:32:37.5740.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "product_type"='2' ORDER BY "order", "updated_at" DESC
14:32:37.5650.5 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:32:37.5800.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (4, 2, 6, 3, 10, 13, 9)
14:32:37.5810.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (9, 4, 2, 3, 7, 24)
14:32:37.5810.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (4, 2, 6, 3, 10, 13, 9)
14:32:37.5800.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=2