Query Metrics
1
Database Queries
1
Different statements
27.92 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 27.92 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.ml\/c\/opensource\",\"to\":[\"https:\/\/www.w3.org\/ns\/activitystreams#Public\"],\"object\":{\"id\":\"https:\/\/lemm.ee\/activities\/create\/3a21bb71-b9a3-4d43-b47e-85c71d4a0431\",\"actor\":\"https:\/\/lemm.ee\/u\/idriss\",\"@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:\/\/lemm.ee\/comment\/19370162\",\"attributedTo\":\"https:\/\/lemm.ee\/u\/idriss\",\"to\":[\"https:\/\/www.w3.org\/ns\/activitystreams#Public\"],\"cc\":[\"https:\/\/lemmy.ml\/c\/opensource\",\"https:\/\/lemmy.ca\/u\/skankhunt42\"],\"content\":\"<p>Thanks for having a look!<\/p>\\n<blockquote>\\n<p>Monitor my email and when I get one that matches the regex it\u2019ll make an API call?<\/p>\\n<\/blockquote>\\n<p>It\u2019s this first one with a slight twist. It generates a random email for you rather than asking you to give your username & password (I don\u2019t want to handle securing people\u2019s usernames and emails at this stage). It makes an API call when the <code>From Email<\/code> matches the regex.<\/p>\\n<p>Example from demo:<\/p>\\n<pre style=\\\"background-color:#ffffff;\\\">\\n<span style=\\\"color:#323232;\\\">URL: https:\/\/api.github.com\/repos\/idrissbellil\/cryptomonitor\/issues\\n<\/span><span style=\\\"color:#323232;\\\">Method: POST (The HTTP Method: POST, GET, PUT, ..)\\n<\/span><span style=\\\"color:#323232;\\\">From Regex: .* (only trigger the call given certain `From` emails so you it doesn't create a thousand tickets if somebody floods you with emails)\\n<\/span><span style=\\\"color:#323232;\\\">Payload: {"title":"{{ .Subject }}","body":"{{ .Body }}","assignees":["idrissbellil"]} (the data part of the POST\/PUT\/even GET query - here you can re-use parts of the email you received like Subject, Body, To, From\\n<\/span><span style=\\\"color:#323232;\\\">Headers: {"Accept":"application\/vnd.github+json","Authorization":"Bearer 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","X-GitHub-Api-Version":"2022-11-28"}\\n<\/span><\/pre>\\n\",\"inReplyTo\":\"https:\/\/lemmy.ca\/comment\/15614610\",\"mediaType\":\"text\/html\",\"source\":{\"content\":\"Thanks for having a look!\\n\\n> Monitor my email and when I get one that matches the regex it\u2019ll make an API call?\\n\\nIt's this first one with a slight twist. It generates a random email for you rather than asking you to give your username & password (I don't want to handle securing people's usernames and emails at this stage). It makes an API call when the `From Email` matches the regex.\\n\\nExample from demo:\\n\\n```\\nURL: https:\/\/api.github.com\/repos\/idrissbellil\/cryptomonitor\/issues\\nMethod: POST (The HTTP Method: POST, GET, PUT, ..)\\nFrom Regex: .* (only trigger the call given certain `From` emails so you it doesn't create a thousand tickets if somebody floods you with emails)\\nPayload: {\\\"title\\\":\\\"{{ .Subject }}\\\",\\\"body\\\":\\\"{{ .Body }}\\\",\\\"assignees\\\":[\\\"idrissbellil\\\"]} (the data part of the POST\/PUT\/even GET query - here you can re-use parts of the email you received like Subject, Body, To, From\\nHeaders: {\\\"Accept\\\":\\\"application\/vnd.github+json\\\",\\\"Authorization\\\":\\\"Bearer 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\\\",\\\"X-GitHub-Api-Version\\\":\\\"2022-11-28\\\"}\\n```\",\"mediaType\":\"text\/markdown\"},\"published\":\"2025-04-02T06:35:45.957246Z\",\"tag\":[{\"href\":\"https:\/\/lemmy.ca\/u\/skankhunt42\",\"name\":\"@skankhunt42@lemmy.ca\",\"type\":\"Mention\"}],\"distinguished\":false,\"audience\":\"https:\/\/lemmy.ml\/c\/opensource\",\"attachment\":[]},\"cc\":[\"https:\/\/lemmy.ml\/c\/opensource\",\"https:\/\/lemmy.ca\/u\/skankhunt42\"],\"tag\":[{\"href\":\"https:\/\/lemmy.ca\/u\/skankhunt42\",\"name\":\"@skankhunt42@lemmy.ca\",\"type\":\"Mention\"}],\"type\":\"Create\",\"audience\":\"https:\/\/lemmy.ml\/c\/opensource\"},\"cc\":[\"https:\/\/lemmy.ml\/c\/opensource\/followers\"],\"type\":\"Announce\",\"id\":\"https:\/\/lemmy.ml\/activities\/announce\/create\/7d772b61-9019-49ce-bd19-af8981646c6f\"}","request":{"host":"kbin.spritesserver.nl","method":"POST","uri":"\/f\/inbox","client_ip":"54.36.178.108"},"headers":{"content-type":["application\/activity+json"],"host":["kbin.spritesserver.nl"],"date":["Wed, 02 Apr 2025 06:36:22 GMT"],"digest":["SHA-256=+lOo7N0HkKEe28OSurngf4LCKaXGb08Ila1ZSAGjD7U="],"signature":["keyId=\"https:\/\/lemmy.ml\/c\/opensource#main-key\",algorithm=\"hs2019\",headers=\"(request-target) content-type date digest host\",signature=\"aKpyakiS5t7\/X0kwL9KPRl8pBWT8wC3qYa3UVMKIp6dDaG00vAVj\/JozEPxxHRm1hXkNosQuCD3LGVqUTd5GonqVJWtjs7\/31vFSkrpVJuoCGnB3lTuQWNVjjqxBgpJ8K9jLbCRHOfu4EImB8nD+tqK4x8n0s5j9SpbbjkFdu8ZWsAV1PEn\/HElraINfpJ67A5TCjOYiwVFo15TV1y\/N\/L40i15VoXWne5DyNbT4IF9pB8CkcfBPiggoenx7FtAa\/OpMhIApytqHo7oFJzuk1a5Kv2bIg\/gmxxNJLkT2wDfBIJHnq9hAKs+pzsCdrxkjcb8q5itT1bKsMXhAyM+ZeQ==\""],"accept":["*\/*"],"user-agent":["Lemmy\/0.19.10; +https:\/\/lemmy.ml"],"accept-encoding":["gzip"],"content-length":["4119"],"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-04-02 06:36:22" "2025-04-02 06:36:22" ] |
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.