Query Metrics
1
Database Queries
1
Different statements
14.74 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 14.74 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:\/\/lemmy.dbzer0.com\/activities\/create\/c1d0ceda-ab67-4b44-bf86-ec3dad3b216e\",\"actor\":\"https:\/\/lemmy.dbzer0.com\/u\/ThisIsAManWhoKnowsHowToGling\",\"@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:\/\/lemmy.dbzer0.com\/comment\/16798309\",\"attributedTo\":\"https:\/\/lemmy.dbzer0.com\/u\/ThisIsAManWhoKnowsHowToGling\",\"to\":[\"https:\/\/www.w3.org\/ns\/activitystreams#Public\"],\"cc\":[\"https:\/\/lemmy.world\/c\/asklemmy\",\"https:\/\/lemmy.world\/u\/ivanafterall\"],\"content\":\"<p>My understanding is that Briar is ethically the best, but no one uses it. Signal is the best if you actually want to use it to communicate. Telegram is where the pirates and drugs are.<\/p>\\n<p>Here\u2019s the long version: when a dev is making a messaging app, they eventually have to make a choice: do I integrate SMS\/MMS? If they want to make this app a daily driver messaging platform to help you ungoogle your android phone, they have to integrate SMS\/MMS, which has security vulnerabilities and limits how secure they can make their app. More importantly, people do not tolerate ads on their messaging app, so they flat-out cannot monetize it without losing their entire userbase. If they don\u2019t integrate SMS\/MMS, they are creating a closed ecosystem, and a closed ecosystem can be profitable. If leadership changes, the new leaders might decide to turn their users into either cutomers or products. The only way I can think to make an app resistant to leadership changes is to make an app that decentralizes the message storage by having each phone keep a log of each conversation and group chat and synchronize it whenever both people have the app open, and I\u2019m pretty sure something like that would just slowly eat up all your phone space and be really slow to run group chats.<\/p>\\n\",\"inReplyTo\":\"https:\/\/lemmy.world\/post\/25788887\",\"mediaType\":\"text\/html\",\"source\":{\"content\":\"My understanding is that Briar is ethically the best, but no one uses it. Signal is the best if you actually want to use it to communicate. Telegram is where the pirates and drugs are.\\n\\nHere's the long version: when a dev is making a messaging app, they eventually have to make a choice: do I integrate SMS\/MMS? If they want to make this app a daily driver messaging platform to help you ungoogle your android phone, they have to integrate SMS\/MMS, which has security vulnerabilities and limits how secure they can make their app. More importantly, people do not tolerate ads on their messaging app, so they flat-out cannot monetize it without losing their entire userbase. If they don't integrate SMS\/MMS, they are creating a closed ecosystem, and a closed ecosystem can be profitable. If leadership changes, the new leaders might decide to turn their users into either cutomers or products. The only way I can think to make an app resistant to leadership changes is to make an app that decentralizes the message storage by having each phone keep a log of each conversation and group chat and synchronize it whenever both people have the app open, and I'm pretty sure something like that would just slowly eat up all your phone space and be really slow to run group chats.\",\"mediaType\":\"text\/markdown\"},\"published\":\"2025-02-19T15:44:56.988107Z\",\"tag\":[{\"href\":\"https:\/\/lemmy.world\/u\/ivanafterall\",\"name\":\"@ivanafterall@lemmy.world\",\"type\":\"Mention\"}],\"distinguished\":false,\"language\":{\"identifier\":\"en\",\"name\":\"English\"},\"audience\":\"https:\/\/lemmy.world\/c\/asklemmy\"},\"cc\":[\"https:\/\/lemmy.world\/c\/asklemmy\",\"https:\/\/lemmy.world\/u\/ivanafterall\"],\"tag\":[{\"href\":\"https:\/\/lemmy.world\/u\/ivanafterall\",\"name\":\"@ivanafterall@lemmy.world\",\"type\":\"Mention\"}],\"type\":\"Create\",\"audience\":\"https:\/\/lemmy.world\/c\/asklemmy\"},\"cc\":[\"https:\/\/lemmy.world\/c\/asklemmy\/followers\"],\"type\":\"Announce\",\"id\":\"https:\/\/lemmy.world\/activities\/announce\/create\/ea278dc8-e8ae-4807-842e-2cfcc43a086a\"}","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":["Wed, 19 Feb 2025 15:45:43 GMT"],"digest":["SHA-256=Qx\/vWVgUVqKAdUm7ZulqRjLy7JnElTkpzEmHGHHSWeM="],"signature":["keyId=\"https:\/\/lemmy.world\/c\/asklemmy#main-key\",algorithm=\"hs2019\",headers=\"(request-target) content-type date digest host\",signature=\"qW8ELhu07zKzw6GnhBNt8uikgoe3sX4DzJIZ0urXzIjfaum\/Rj2FddBjg8soU4Z8U1uWVogdRer7Yayzb8yOqocmtiNA0pOkTxHweWxBu8p\/3rgpIgV7Tw9Ivq7QovLkyD9MFDMi8Gc6TId4cN5\/zwzCpQqg5hrjJk+RjdQP73Tua2l9UQuZzsmECUmlHfioW3es7KZ6QUjzkes\/9l7CThT\/6ntsbDd8Os1opjCEcVuPdUVq+am49GjNldvJVGRYM6wrEpc5HZykE+LjgYUfIMABrbOksdzMQ1Z3OAIxcwiEFOmLxavDF2ccP84E\/jVhJS0AhOiE3O\/6oUhsb9cfqg==\""],"accept":["*\/*"],"user-agent":["Lemmy\/0.19.3-4-gc98049af6; +https:\/\/lemmy.world"],"accept-encoding":["gzip"],"content-length":["4145"],"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-02-19 15:45:43" "2025-02-19 15:45:43" ] |
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.