Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

37.08 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲	Time	Info
1	37.08 ms	INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) Parameters: ["{"payload":"{\"@context\":[\"https:\/\/join-lemmy.org\/context.json\",\"https:\/\/www.w3.org\/ns\/activitystreams\"],\"actor\":\"https:\/\/lemmy.world\/c\/asklemmy\",\"to\":[\"https:\/\/www.w3.org\/ns\/activitystreams#Public\"],\"object\":{\"id\":\"https:\/\/midwest.social\/activities\/update\/13d7a00d-d3e2-42ad-ab8b-9db72104d9f3\",\"actor\":\"https:\/\/midwest.social\/u\/JakenVeina\",\"@context\":[\"https:\/\/join-lemmy.org\/context.json\",\"https:\/\/www.w3.org\/ns\/activitystreams\"],\"to\":[\"https:\/\/www.w3.org\/ns\/activitystreams#Public\"],\"object\":{\"type\":\"Note\",\"id\":\"https:\/\/midwest.social\/comment\/20632051\",\"attributedTo\":\"https:\/\/midwest.social\/u\/JakenVeina\",\"to\":[\"https:\/\/www.w3.org\/ns\/activitystreams#Public\"],\"cc\":[\"https:\/\/lemmy.world\/c\/asklemmy\",\"https:\/\/sh.itjust.works\/u\/bridgeenjoyer\"],\"content\":\"<p>I work with a 7-person (6 devs and a lead) on a 20-year-old financial reporting application. We either pull or receive data from about 7 different systems where folks record contracts, funding documents, purchase requests, purchase orders, invoices, bills, etc. and pull them all together to build reports and UIs where users can search across all the data, and have it unified in one place. That\u2019s about 90% of our workload, anyway. More recently, we\u2019ve adopted workload from a couple big legacy systems that got sunsetted, where we\u2019re actually the data-entry point, feeding data out to the main billing system.<\/p>\\n<p>Day to day, I work on everything from PL\/SQL (Oracle\u2019s SQL variant for compiled stored procedures) where the majority of our business logic lives, to VB.NET where two different HTTP Web servers live, as well as a large automated testing suite for that database business layer, to TypeScript where most of our UI logic lives. Occasionally, I might dip into plain JavaScript\/jQuery or ASPX to work on older features.<\/p>\\n<p>There\u2019s plenty of time spent writing code, but there\u2019s also a LOT of time spent just discussing things among team. Probably about half of the time, overall. Part of why the project has lasted 20 years is that we\u2019ve gotten very good at being able to interpret what non-technical finance and acquisitions folks want. Like, they might come to us and say \u201chey, can you add inter-departmental purchase requests to report X\u201d, but they can\u2019t always tell us what an \u201cinter-departmental purchase request\u201d is, or where that data lives in the external systems (and that\u2019s not like a criticism, that\u2019s just the reality of the fact that these people are accountants, not engineers). So, we\u2019ll have to probe for specific requirements and\/or reverse-engineer it out of an external database.<\/p>\\n<p>I also do open-source work in some of my hobby time, which is pretty much all C#.<\/p>\\n\",\"inReplyTo\":\"https:\/\/sh.itjust.works\/post\/48048469\",\"mediaType\":\"text\/html\",\"source\":{\"content\":\"I work with a 7-person (6 devs and a lead) on a 20-year-old financial reporting application. We either pull or receive data from about 7 different systems where folks record contracts, funding documents, purchase requests, purchase orders, invoices, bills, etc. and pull them all together to build reports and UIs where users can search across all the data, and have it unified in one place. That's about 90% of our workload, anyway. More recently, we've adopted workload from a couple big legacy systems that got sunsetted, where we're actually the data-entry point, feeding data out to the main billing system.\\n\\nDay to day, I work on everything from PL\/SQL (Oracle's SQL variant for compiled stored procedures) where the majority of our business logic lives, to VB.NET where two different HTTP Web servers live, as well as a large automated testing suite for that database business layer, to TypeScript where most of our UI logic lives. Occasionally, I might dip into plain JavaScript\/jQuery or ASPX to work on older features.\\n\\nThere's plenty of time spent writing code, but there's also a LOT of time spent just discussing things among team. Probably about half of the time, overall. Part of why the project has lasted 20 years is that we've gotten very good at being able to interpret what non-technical finance and acquisitions folks want. Like, they might come to us and say \\\"hey, can you add inter-departmental purchase requests to report X\\\", but they can't always tell us what an \\\"inter-departmental purchase request\\\" is, or where that data lives in the external systems (and that's not like a criticism, that's just the reality of the fact that these people are accountants, not engineers). So, we'll have to probe for specific requirements and\/or reverse-engineer it out of an external database.\\n\\nI also do open-source work in some of my hobby time, which is pretty much all C#.\",\"mediaType\":\"text\/markdown\"},\"published\":\"2025-10-18T03:03:14.884577Z\",\"updated\":\"2025-10-18T03:17:30.921451Z\",\"tag\":[{\"href\":\"https:\/\/sh.itjust.works\/u\/bridgeenjoyer\",\"name\":\"@bridgeenjoyer@sh.itjust.works\",\"type\":\"Mention\"}],\"distinguished\":false,\"audience\":\"https:\/\/lemmy.world\/c\/asklemmy\",\"attachment\":[]},\"cc\":[\"https:\/\/lemmy.world\/c\/asklemmy\",\"https:\/\/sh.itjust.works\/u\/bridgeenjoyer\"],\"tag\":[{\"href\":\"https:\/\/sh.itjust.works\/u\/bridgeenjoyer\",\"name\":\"@bridgeenjoyer@sh.itjust.works\",\"type\":\"Mention\"}],\"type\":\"Update\",\"audience\":\"https:\/\/lemmy.world\/c\/asklemmy\"},\"cc\":[\"https:\/\/lemmy.world\/c\/asklemmy\/followers\"],\"type\":\"Announce\",\"id\":\"https:\/\/lemmy.world\/activities\/announce\/update\/6ba575af-5694-4ff0-972a-b5427e848766\"}","request":{"host":"kbin.spritesserver.nl","method":"POST","uri":"\/f\/inbox","client_ip":"135.181.143.221"},"headers":{"content-type":["application\/activity+json"],"host":["kbin.spritesserver.nl"],"date":["Sat, 18 Oct 2025 03:17:39 GMT"],"digest":["SHA-256=eHAdL+RBRuUFQykEHm4TMyAx1OgxpuF08RCfJ3r02ZI="],"signature":["keyId=\"https:\/\/lemmy.world\/c\/asklemmy#main-key\",algorithm=\"hs2019\",headers=\"(request-target) content-type date digest host\",signature=\"5tJZQZRGa1RE+\/h04P1LzkC7FAM\/1djSdkIqpRI3rIBQMPNcPVDC+yvfLwhQtt\/UnlMvcQ5tNgZN6QL2szEAkX3taocab7GjIk4E4OyvyT5zkIVqqZUZCoUanxlKZzSUTuSfF\/gCb23inuZvu6rRJDBVN3XE2YBTIZ2l2J99Ond0AUIJJPwn9ge8VNXLR73dg3FLLvZiCt3YMxzqcvW9kk6rix6ZBdxMa8nJ9NDQ9gbKFhSXo+zg3uNvv9mbQgWZZogeSnEDeHv+GIGUfe7xjZvQ81drWN\/ycef3mTMylFwWINltTo197qrDFly4Nucblg3mCgbQ9iQgj842Rso8CA==\""],"traceparent":["00-f30bf5f9a3fe569e8bf11b2d24797798-1a45435ab9420d53-01"],"tracestate":[""],"accept":["\/"],"user-agent":["Lemmy\/0.19.12-4-gd8445881a; +https:\/\/lemmy.world"],"accept-encoding":["gzip"],"content-length":["5419"],"x-php-ob-level":["1"]}}" "{"type":"App\\Message\\ActivityPub\\Inbox\\ActivityMessage","X-Message-Stamp-Symfony\\Component\\Messenger\\Stamp\\BusNameStamp":"[{\"busName\":\"messenger.bus.default\"}]","Content-Type":"application\/json"}" "default" "2025-10-18 03:17:40" "2025-10-18 03:17:40"] View formatted query View runnable query Explain query INSERT INTO messenger_messages ( body, headers, queue_name, created_at, available_at ) VALUES (?, ?, ?, ?, ?) INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('{\"payload\":\"{\\\"@context\\\":[\\\"https:\\/\\/join-lemmy.org\\/context.json\\\",\\\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\\\"],\\\"actor\\\":\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy\\\",\\\"to\\\":[\\\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\\\"],\\\"object\\\":{\\\"id\\\":\\\"https:\\/\\/midwest.social\\/activities\\/update\\/13d7a00d-d3e2-42ad-ab8b-9db72104d9f3\\\",\\\"actor\\\":\\\"https:\\/\\/midwest.social\\/u\\/JakenVeina\\\",\\\"@context\\\":[\\\"https:\\/\\/join-lemmy.org\\/context.json\\\",\\\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\\\"],\\\"to\\\":[\\\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\\\"],\\\"object\\\":{\\\"type\\\":\\\"Note\\\",\\\"id\\\":\\\"https:\\/\\/midwest.social\\/comment\\/20632051\\\",\\\"attributedTo\\\":\\\"https:\\/\\/midwest.social\\/u\\/JakenVeina\\\",\\\"to\\\":[\\\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\\\"],\\\"cc\\\":[\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy\\\",\\\"https:\\/\\/sh.itjust.works\\/u\\/bridgeenjoyer\\\"],\\\"content\\\":\\\"<p>I work with a 7-person (6 devs and a lead) on a 20-year-old financial reporting application. We either pull or receive data from about 7 different systems where folks record contracts, funding documents, purchase requests, purchase orders, invoices, bills, etc. and pull them all together to build reports and UIs where users can search across all the data, and have it unified in one place. That\\u2019s about 90% of our workload, anyway. More recently, we\\u2019ve adopted workload from a couple big legacy systems that got sunsetted, where we\\u2019re actually the data-entry point, feeding data out to the main billing system.<\\/p>\\\\n<p>Day to day, I work on everything from PL\\/SQL (Oracle\\u2019s SQL variant for compiled stored procedures) where the majority of our business logic lives, to VB.NET where two different HTTP Web servers live, as well as a large automated testing suite for that database business layer, to TypeScript where most of our UI logic lives. Occasionally, I might dip into plain JavaScript\\/jQuery or ASPX to work on older features.<\\/p>\\\\n<p>There\\u2019s plenty of time spent writing code, but there\\u2019s also a LOT of time spent just discussing things among team. Probably about half of the time, overall. Part of why the project has lasted 20 years is that we\\u2019ve gotten very good at being able to interpret what non-technical finance and acquisitions folks want. Like, they might come to us and say \\u201chey, can you add inter-departmental purchase requests to report X\\u201d, but they can\\u2019t always tell us what an \\u201cinter-departmental purchase request\\u201d is, or where that data lives in the external systems (and that\\u2019s not like a criticism, that\\u2019s just the reality of the fact that these people are accountants, not engineers). So, we\\u2019ll have to probe for specific requirements and\\/or reverse-engineer it out of an external database.<\\/p>\\\\n<p>I also do open-source work in some of my hobby time, which is pretty much all C#.<\\/p>\\\\n\\\",\\\"inReplyTo\\\":\\\"https:\\/\\/sh.itjust.works\\/post\\/48048469\\\",\\\"mediaType\\\":\\\"text\\/html\\\",\\\"source\\\":{\\\"content\\\":\\\"I work with a 7-person (6 devs and a lead) on a 20-year-old financial reporting application. We either pull or receive data from about 7 different systems where folks record contracts, funding documents, purchase requests, purchase orders, invoices, bills, etc. and pull them all together to build reports and UIs where users can search across all the data, and have it unified in one place. That\'s about 90% of our workload, anyway. More recently, we\'ve adopted workload from a couple big legacy systems that got sunsetted, where we\'re actually the data-entry point, feeding data out to the main billing system.\\\\n\\\\nDay to day, I work on everything from PL\\/SQL (Oracle\'s SQL variant for compiled stored procedures) where the majority of our business logic lives, to VB.NET where two different HTTP Web servers live, as well as a large automated testing suite for that database business layer, to TypeScript where most of our UI logic lives. Occasionally, I might dip into plain JavaScript\\/jQuery or ASPX to work on older features.\\\\n\\\\nThere\'s plenty of time spent writing code, but there\'s also a LOT of time spent just discussing things among team. Probably about half of the time, overall. Part of why the project has lasted 20 years is that we\'ve gotten very good at being able to interpret what non-technical finance and acquisitions folks want. Like, they might come to us and say \\\\\\\"hey, can you add inter-departmental purchase requests to report X\\\\\\\", but they can\'t always tell us what an \\\\\\\"inter-departmental purchase request\\\\\\\" is, or where that data lives in the external systems (and that\'s not like a criticism, that\'s just the reality of the fact that these people are accountants, not engineers). So, we\'ll have to probe for specific requirements and\\/or reverse-engineer it out of an external database.\\\\n\\\\nI also do open-source work in some of my hobby time, which is pretty much all C#.\\\",\\\"mediaType\\\":\\\"text\\/markdown\\\"},\\\"published\\\":\\\"2025-10-18T03:03:14.884577Z\\\",\\\"updated\\\":\\\"2025-10-18T03:17:30.921451Z\\\",\\\"tag\\\":[{\\\"href\\\":\\\"https:\\/\\/sh.itjust.works\\/u\\/bridgeenjoyer\\\",\\\"name\\\":\\\"@bridgeenjoyer@sh.itjust.works\\\",\\\"type\\\":\\\"Mention\\\"}],\\\"distinguished\\\":false,\\\"audience\\\":\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy\\\",\\\"attachment\\\":[]},\\\"cc\\\":[\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy\\\",\\\"https:\\/\\/sh.itjust.works\\/u\\/bridgeenjoyer\\\"],\\\"tag\\\":[{\\\"href\\\":\\\"https:\\/\\/sh.itjust.works\\/u\\/bridgeenjoyer\\\",\\\"name\\\":\\\"@bridgeenjoyer@sh.itjust.works\\\",\\\"type\\\":\\\"Mention\\\"}],\\\"type\\\":\\\"Update\\\",\\\"audience\\\":\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy\\\"},\\\"cc\\\":[\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy\\/followers\\\"],\\\"type\\\":\\\"Announce\\\",\\\"id\\\":\\\"https:\\/\\/lemmy.world\\/activities\\/announce\\/update\\/6ba575af-5694-4ff0-972a-b5427e848766\\\"}\",\"request\":{\"host\":\"kbin.spritesserver.nl\",\"method\":\"POST\",\"uri\":\"\\/f\\/inbox\",\"client_ip\":\"135.181.143.221\"},\"headers\":{\"content-type\":[\"application\\/activity+json\"],\"host\":[\"kbin.spritesserver.nl\"],\"date\":[\"Sat, 18 Oct 2025 03:17:39 GMT\"],\"digest\":[\"SHA-256=eHAdL+RBRuUFQykEHm4TMyAx1OgxpuF08RCfJ3r02ZI=\"],\"signature\":[\"keyId=\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy#main-key\\\",algorithm=\\\"hs2019\\\",headers=\\\"(request-target) content-type date digest host\\\",signature=\\\"5tJZQZRGa1RE+\\/h04P1LzkC7FAM\\/1djSdkIqpRI3rIBQMPNcPVDC+yvfLwhQtt\\/UnlMvcQ5tNgZN6QL2szEAkX3taocab7GjIk4E4OyvyT5zkIVqqZUZCoUanxlKZzSUTuSfF\\/gCb23inuZvu6rRJDBVN3XE2YBTIZ2l2J99Ond0AUIJJPwn9ge8VNXLR73dg3FLLvZiCt3YMxzqcvW9kk6rix6ZBdxMa8nJ9NDQ9gbKFhSXo+zg3uNvv9mbQgWZZogeSnEDeHv+GIGUfe7xjZvQ81drWN\\/ycef3mTMylFwWINltTo197qrDFly4Nucblg3mCgbQ9iQgj842Rso8CA==\\\"\"],\"traceparent\":[\"00-f30bf5f9a3fe569e8bf11b2d24797798-1a45435ab9420d53-01\"],\"tracestate\":[\"\"],\"accept\":[\"\\/\"],\"user-agent\":[\"Lemmy\\/0.19.12-4-gd8445881a; +https:\\/\\/lemmy.world\"],\"accept-encoding\":[\"gzip\"],\"content-length\":[\"5419\"],\"x-php-ob-level\":[\"1\"]}}', '{\"type\":\"App\\\\Message\\\\ActivityPub\\\\Inbox\\\\ActivityMessage\",\"X-Message-Stamp-Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\":\"[{\\\"busName\\\":\\\"messenger.bus.default\\\"}]\",\"Content-Type\":\"application\\/json\"}', 'default', '2025-10-18 03:17:40', '2025-10-18 03:17:40');

#▲

Time

Info

37.08 ms

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)

Parameters:

[
  "{"payload":"{\"@context\":[\"https:\/\/join-lemmy.org\/context.json\",\"https:\/\/www.w3.org\/ns\/activitystreams\"],\"actor\":\"https:\/\/lemmy.world\/c\/asklemmy\",\"to\":[\"https:\/\/www.w3.org\/ns\/activitystreams#Public\"],\"object\":{\"id\":\"https:\/\/midwest.social\/activities\/update\/13d7a00d-d3e2-42ad-ab8b-9db72104d9f3\",\"actor\":\"https:\/\/midwest.social\/u\/JakenVeina\",\"@context\":[\"https:\/\/join-lemmy.org\/context.json\",\"https:\/\/www.w3.org\/ns\/activitystreams\"],\"to\":[\"https:\/\/www.w3.org\/ns\/activitystreams#Public\"],\"object\":{\"type\":\"Note\",\"id\":\"https:\/\/midwest.social\/comment\/20632051\",\"attributedTo\":\"https:\/\/midwest.social\/u\/JakenVeina\",\"to\":[\"https:\/\/www.w3.org\/ns\/activitystreams#Public\"],\"cc\":[\"https:\/\/lemmy.world\/c\/asklemmy\",\"https:\/\/sh.itjust.works\/u\/bridgeenjoyer\"],\"content\":\"<p>I work with a 7-person (6 devs and a lead) on a 20-year-old financial reporting application. We either pull or receive data from about 7 different systems where folks record contracts, funding documents, purchase requests, purchase orders, invoices, bills, etc. and pull them all together to build reports and UIs where users can search across all the data, and have it unified in one place. That\u2019s about 90% of our workload, anyway. More recently, we\u2019ve adopted workload from a couple big legacy systems that got sunsetted, where we\u2019re actually the data-entry point, feeding data out to the main billing system.<\/p>\\n<p>Day to day, I work on everything from PL\/SQL (Oracle\u2019s SQL variant for compiled stored procedures) where the majority of our business logic lives, to VB.NET where two different HTTP Web servers live, as well as a large automated testing suite for that database business layer, to TypeScript where most of our UI logic lives. Occasionally, I might dip into plain JavaScript\/jQuery or ASPX to work on older features.<\/p>\\n<p>There\u2019s plenty of time spent writing code, but there\u2019s also a LOT of time spent just discussing things among team. Probably about half of the time, overall. Part of why the project has lasted 20 years is that we\u2019ve gotten very good at being able to interpret what non-technical finance and acquisitions folks want. Like, they might come to us and say \u201chey, can you add inter-departmental purchase requests to report X\u201d, but they can\u2019t always tell us what an \u201cinter-departmental purchase request\u201d is, or where that data lives in the external systems (and that\u2019s not like a criticism, that\u2019s just the reality of the fact that these people are accountants, not engineers). So, we\u2019ll have to probe for specific requirements and\/or reverse-engineer it out of an external database.<\/p>\\n<p>I also do open-source work in some of my hobby time, which is pretty much all C#.<\/p>\\n\",\"inReplyTo\":\"https:\/\/sh.itjust.works\/post\/48048469\",\"mediaType\":\"text\/html\",\"source\":{\"content\":\"I work with a 7-person (6 devs and a lead) on a 20-year-old financial reporting application. We either pull or receive data from about 7 different systems where folks record contracts, funding documents, purchase requests, purchase orders, invoices, bills, etc. and pull them all together to build reports and UIs where users can search across all the data, and have it unified in one place. That's about 90% of our workload, anyway. More recently, we've adopted workload from a couple big legacy systems that got sunsetted, where we're actually the data-entry point, feeding data out to the main billing system.\\n\\nDay to day, I work on everything from PL\/SQL (Oracle's SQL variant for compiled stored procedures) where the majority of our business logic lives, to VB.NET where two different HTTP Web servers live, as well as a large automated testing suite for that database business layer, to TypeScript where most of our UI logic lives. Occasionally, I might dip into plain JavaScript\/jQuery or ASPX to work on older features.\\n\\nThere's plenty of time spent writing code, but there's also a LOT of time spent just discussing things among team. Probably about half of the time, overall. Part of why the project has lasted 20 years is that we've gotten very good at being able to interpret what non-technical finance and acquisitions folks want. Like, they might come to us and say \\\"hey, can you add inter-departmental purchase requests to report X\\\", but they can't always tell us what an \\\"inter-departmental purchase request\\\" is, or where that data lives in the external systems (and that's not like a criticism, that's just the reality of the fact that these people are accountants, not engineers). So, we'll have to probe for specific requirements and\/or reverse-engineer it out of an external database.\\n\\nI also do open-source work in some of my hobby time, which is pretty much all C#.\",\"mediaType\":\"text\/markdown\"},\"published\":\"2025-10-18T03:03:14.884577Z\",\"updated\":\"2025-10-18T03:17:30.921451Z\",\"tag\":[{\"href\":\"https:\/\/sh.itjust.works\/u\/bridgeenjoyer\",\"name\":\"@bridgeenjoyer@sh.itjust.works\",\"type\":\"Mention\"}],\"distinguished\":false,\"audience\":\"https:\/\/lemmy.world\/c\/asklemmy\",\"attachment\":[]},\"cc\":[\"https:\/\/lemmy.world\/c\/asklemmy\",\"https:\/\/sh.itjust.works\/u\/bridgeenjoyer\"],\"tag\":[{\"href\":\"https:\/\/sh.itjust.works\/u\/bridgeenjoyer\",\"name\":\"@bridgeenjoyer@sh.itjust.works\",\"type\":\"Mention\"}],\"type\":\"Update\",\"audience\":\"https:\/\/lemmy.world\/c\/asklemmy\"},\"cc\":[\"https:\/\/lemmy.world\/c\/asklemmy\/followers\"],\"type\":\"Announce\",\"id\":\"https:\/\/lemmy.world\/activities\/announce\/update\/6ba575af-5694-4ff0-972a-b5427e848766\"}","request":{"host":"kbin.spritesserver.nl","method":"POST","uri":"\/f\/inbox","client_ip":"135.181.143.221"},"headers":{"content-type":["application\/activity+json"],"host":["kbin.spritesserver.nl"],"date":["Sat, 18 Oct 2025 03:17:39 GMT"],"digest":["SHA-256=eHAdL+RBRuUFQykEHm4TMyAx1OgxpuF08RCfJ3r02ZI="],"signature":["keyId=\"https:\/\/lemmy.world\/c\/asklemmy#main-key\",algorithm=\"hs2019\",headers=\"(request-target) content-type date digest host\",signature=\"5tJZQZRGa1RE+\/h04P1LzkC7FAM\/1djSdkIqpRI3rIBQMPNcPVDC+yvfLwhQtt\/UnlMvcQ5tNgZN6QL2szEAkX3taocab7GjIk4E4OyvyT5zkIVqqZUZCoUanxlKZzSUTuSfF\/gCb23inuZvu6rRJDBVN3XE2YBTIZ2l2J99Ond0AUIJJPwn9ge8VNXLR73dg3FLLvZiCt3YMxzqcvW9kk6rix6ZBdxMa8nJ9NDQ9gbKFhSXo+zg3uNvv9mbQgWZZogeSnEDeHv+GIGUfe7xjZvQ81drWN\/ycef3mTMylFwWINltTo197qrDFly4Nucblg3mCgbQ9iQgj842Rso8CA==\""],"traceparent":["00-f30bf5f9a3fe569e8bf11b2d24797798-1a45435ab9420d53-01"],"tracestate":[""],"accept":["*\/*"],"user-agent":["Lemmy\/0.19.12-4-gd8445881a; +https:\/\/lemmy.world"],"accept-encoding":["gzip"],"content-length":["5419"],"x-php-ob-level":["1"]}}"
  "{"type":"App\\Message\\ActivityPub\\Inbox\\ActivityMessage","X-Message-Stamp-Symfony\\Component\\Messenger\\Stamp\\BusNameStamp":"[{\"busName\":\"messenger.bus.default\"}]","Content-Type":"application\/json"}"
  "default"
  "2025-10-18 03:17:40"
  "2025-10-18 03:17:40"
]

View formatted query View runnable query Explain query

INSERT INTO messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('{\"payload\":\"{\\\"@context\\\":[\\\"https:\\/\\/join-lemmy.org\\/context.json\\\",\\\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\\\"],\\\"actor\\\":\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy\\\",\\\"to\\\":[\\\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\\\"],\\\"object\\\":{\\\"id\\\":\\\"https:\\/\\/midwest.social\\/activities\\/update\\/13d7a00d-d3e2-42ad-ab8b-9db72104d9f3\\\",\\\"actor\\\":\\\"https:\\/\\/midwest.social\\/u\\/JakenVeina\\\",\\\"@context\\\":[\\\"https:\\/\\/join-lemmy.org\\/context.json\\\",\\\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\\\"],\\\"to\\\":[\\\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\\\"],\\\"object\\\":{\\\"type\\\":\\\"Note\\\",\\\"id\\\":\\\"https:\\/\\/midwest.social\\/comment\\/20632051\\\",\\\"attributedTo\\\":\\\"https:\\/\\/midwest.social\\/u\\/JakenVeina\\\",\\\"to\\\":[\\\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\\\"],\\\"cc\\\":[\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy\\\",\\\"https:\\/\\/sh.itjust.works\\/u\\/bridgeenjoyer\\\"],\\\"content\\\":\\\"<p>I work with a 7-person (6 devs and a lead) on a 20-year-old financial reporting application. We either pull or receive data from about 7 different systems where folks record contracts, funding documents, purchase requests, purchase orders, invoices, bills, etc. and pull them all together to build reports and UIs where users can search across all the data, and have it unified in one place. That\\u2019s about 90% of our workload, anyway. More recently, we\\u2019ve adopted workload from a couple big legacy systems that got sunsetted, where we\\u2019re actually the data-entry point, feeding data out to the main billing system.<\\/p>\\\\n<p>Day to day, I work on everything from PL\\/SQL (Oracle\\u2019s SQL variant for compiled stored procedures) where the majority of our business logic lives, to VB.NET where two different HTTP Web servers live, as well as a large automated testing suite for that database business layer, to TypeScript where most of our UI logic lives. Occasionally, I might dip into plain JavaScript\\/jQuery or ASPX to work on older features.<\\/p>\\\\n<p>There\\u2019s plenty of time spent writing code, but there\\u2019s also a LOT of time spent just discussing things among team. Probably about half of the time, overall. Part of why the project has lasted 20 years is that we\\u2019ve gotten very good at being able to interpret what non-technical finance and acquisitions folks want. Like, they might come to us and say \\u201chey, can you add inter-departmental purchase requests to report X\\u201d, but they can\\u2019t always tell us what an \\u201cinter-departmental purchase request\\u201d is, or where that data lives in the external systems (and that\\u2019s not like a criticism, that\\u2019s just the reality of the fact that these people are accountants, not engineers). So, we\\u2019ll have to probe for specific requirements and\\/or reverse-engineer it out of an external database.<\\/p>\\\\n<p>I also do open-source work in some of my hobby time, which is pretty much all C#.<\\/p>\\\\n\\\",\\\"inReplyTo\\\":\\\"https:\\/\\/sh.itjust.works\\/post\\/48048469\\\",\\\"mediaType\\\":\\\"text\\/html\\\",\\\"source\\\":{\\\"content\\\":\\\"I work with a 7-person (6 devs and a lead) on a 20-year-old financial reporting application. We either pull or receive data from about 7 different systems where folks record contracts, funding documents, purchase requests, purchase orders, invoices, bills, etc. and pull them all together to build reports and UIs where users can search across all the data, and have it unified in one place. That\'s about 90% of our workload, anyway. More recently, we\'ve adopted workload from a couple big legacy systems that got sunsetted, where we\'re actually the data-entry point, feeding data out to the main billing system.\\\\n\\\\nDay to day, I work on everything from PL\\/SQL (Oracle\'s SQL variant for compiled stored procedures) where the majority of our business logic lives, to VB.NET where two different HTTP Web servers live, as well as a large automated testing suite for that database business layer, to TypeScript where most of our UI logic lives. Occasionally, I might dip into plain JavaScript\\/jQuery or ASPX to work on older features.\\\\n\\\\nThere\'s plenty of time spent writing code, but there\'s also a LOT of time spent just discussing things among team. Probably about half of the time, overall. Part of why the project has lasted 20 years is that we\'ve gotten very good at being able to interpret what non-technical finance and acquisitions folks want. Like, they might come to us and say \\\\\\\"hey, can you add inter-departmental purchase requests to report X\\\\\\\", but they can\'t always tell us what an \\\\\\\"inter-departmental purchase request\\\\\\\" is, or where that data lives in the external systems (and that\'s not like a criticism, that\'s just the reality of the fact that these people are accountants, not engineers). So, we\'ll have to probe for specific requirements and\\/or reverse-engineer it out of an external database.\\\\n\\\\nI also do open-source work in some of my hobby time, which is pretty much all C#.\\\",\\\"mediaType\\\":\\\"text\\/markdown\\\"},\\\"published\\\":\\\"2025-10-18T03:03:14.884577Z\\\",\\\"updated\\\":\\\"2025-10-18T03:17:30.921451Z\\\",\\\"tag\\\":[{\\\"href\\\":\\\"https:\\/\\/sh.itjust.works\\/u\\/bridgeenjoyer\\\",\\\"name\\\":\\\"@bridgeenjoyer@sh.itjust.works\\\",\\\"type\\\":\\\"Mention\\\"}],\\\"distinguished\\\":false,\\\"audience\\\":\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy\\\",\\\"attachment\\\":[]},\\\"cc\\\":[\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy\\\",\\\"https:\\/\\/sh.itjust.works\\/u\\/bridgeenjoyer\\\"],\\\"tag\\\":[{\\\"href\\\":\\\"https:\\/\\/sh.itjust.works\\/u\\/bridgeenjoyer\\\",\\\"name\\\":\\\"@bridgeenjoyer@sh.itjust.works\\\",\\\"type\\\":\\\"Mention\\\"}],\\\"type\\\":\\\"Update\\\",\\\"audience\\\":\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy\\\"},\\\"cc\\\":[\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy\\/followers\\\"],\\\"type\\\":\\\"Announce\\\",\\\"id\\\":\\\"https:\\/\\/lemmy.world\\/activities\\/announce\\/update\\/6ba575af-5694-4ff0-972a-b5427e848766\\\"}\",\"request\":{\"host\":\"kbin.spritesserver.nl\",\"method\":\"POST\",\"uri\":\"\\/f\\/inbox\",\"client_ip\":\"135.181.143.221\"},\"headers\":{\"content-type\":[\"application\\/activity+json\"],\"host\":[\"kbin.spritesserver.nl\"],\"date\":[\"Sat, 18 Oct 2025 03:17:39 GMT\"],\"digest\":[\"SHA-256=eHAdL+RBRuUFQykEHm4TMyAx1OgxpuF08RCfJ3r02ZI=\"],\"signature\":[\"keyId=\\\"https:\\/\\/lemmy.world\\/c\\/asklemmy#main-key\\\",algorithm=\\\"hs2019\\\",headers=\\\"(request-target) content-type date digest host\\\",signature=\\\"5tJZQZRGa1RE+\\/h04P1LzkC7FAM\\/1djSdkIqpRI3rIBQMPNcPVDC+yvfLwhQtt\\/UnlMvcQ5tNgZN6QL2szEAkX3taocab7GjIk4E4OyvyT5zkIVqqZUZCoUanxlKZzSUTuSfF\\/gCb23inuZvu6rRJDBVN3XE2YBTIZ2l2J99Ond0AUIJJPwn9ge8VNXLR73dg3FLLvZiCt3YMxzqcvW9kk6rix6ZBdxMa8nJ9NDQ9gbKFhSXo+zg3uNvv9mbQgWZZogeSnEDeHv+GIGUfe7xjZvQ81drWN\\/ycef3mTMylFwWINltTo197qrDFly4Nucblg3mCgbQ9iQgj842Rso8CA==\\\"\"],\"traceparent\":[\"00-f30bf5f9a3fe569e8bf11b2d24797798-1a45435ab9420d53-01\"],\"tracestate\":[\"\"],\"accept\":[\"*\\/*\"],\"user-agent\":[\"Lemmy\\/0.19.12-4-gd8445881a; +https:\\/\\/lemmy.world\"],\"accept-encoding\":[\"gzip\"],\"content-length\":[\"5419\"],\"x-php-ob-level\":[\"1\"]}}', '{\"type\":\"App\\\\Message\\\\ActivityPub\\\\Inbox\\\\ActivityMessage\",\"X-Message-Stamp-Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\":\"[{\\\"busName\\\":\\\"messenger.bus.default\\\"}]\",\"Content-Type\":\"application\\/json\"}', 'default', '2025-10-18 03:17:40', '2025-10-18 03:17:40');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Entities Mapping

No loaded entities.

Symfony Profiler

POST https://kbin.spritesserver.nl/f/inbox

Configuration Settings

Theme