Redirect 302 redirect from GET @app_admin_send_email_to_place (0cd1ed)

GET https://osm-labo.cipherbliss.com/admin/send_email_to_place/801683

Query Metrics

11 Database Queries
7 Different statements
12.83 ms Query time
0 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 0.36 ms
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.id = ?
Parameters:
[
  "801683"
]
2 0.15 ms
"START TRANSACTION"
Parameters:
[]
3 0.26 ms
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "send_email_to_place"
  "{"place_id":801683}"
  "2026-02-01 07:02:19"
  null
  null
]
4 0.22 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8532453715"
  801683
]
5 3.62 ms
"COMMIT"
Parameters:
[]
6 0.15 ms
"START TRANSACTION"
Parameters:
[]
7 0.46 ms
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[
  """
    O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:51:\"Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\":2:{s:60:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0message\";O:28:\"Symfony\\Component\\Mime\\Email\":6:{i:0;N;i:1;N;i:2;s:1853:\"<div class=\"content\">\n
    <i class=\"bi bi-shop-window\"></i>\n
    <p>Bonjour, votre établissement \"Association des services de santé au travail du bâtiment et des travaux publics\" est présent dans la base de données mondiale OpenStreetMap (OSM) avec 650 000 autres en France.\n
    <br>\n
    Ces informations sont utilisées dans des milliers de sites web et annuaires, par Île de France mobilités, TomTom, Geovelo, Cartes IGN, Facebook, Instagram, Apple Plans et bien d\'autres. \n
    \n
    <br>\n
        Plus les informations seront à jour et plus vous aurez de chances d\'avoir des clients satisfaits.</p>\n
     \n
    <p> Vous pouvez le modifier en cliquant sur le bouton ci-dessous, c\'est gratuit et sans engagement.</p>\n
    \n
        <a href=\"/edit/13103/Association%2520des%2520services%2520de%2520sant%25C3%25A9%2520au%2520travail%2520du%2520b%25C3%25A2timent%2520et%2520des%2520travaux%2520publics/4d904798-6f86-4fc8-bd0b-71d9f933ac1a\" class=\"btn btn-primary\">\n
            <i class=\"bi bi-pencil-square\"></i>\n
           Compléter les informations de mon commerce\n
        </a>\n
     \n
    <br>\n
    <br>\n
        Les bénévoles de l\'association OpenStreetMap France ont mis en place cet outil pour faciliter la mise à jour des informations de vos commerces et améliorer la souveraineté numérique. Si vous avez besoin d\'aide, n\'hésitez pas à nous contacter à l\'adresse <a href=\"mailto:contact@openstreetmap.fr\">contact@openstreetmap.fr</a>.\n
    <br>\n
    <br>\n
        Pour des besoins de prestation de services concernant l\'intégration ou l\'exportation de données depuis OSM, vous pouvez contacter la fédération des pros d\'OpenStreetMap France sur <a href=\"https://fposm.fr\">https://fposm.fr</a>.\n
    <br>\n
    <br>\n
    En vous souhaitant une bonne journée.\n
    <br>\n
    - Les bénévoles de l\'association OpenStreetMap France.\n
    <br>\n
        <hr>\n
    \n
        <a href=\"/admin/commerce/801683\">Ne plus être sollicité pour mettre à jour mon commerce</a>\n
    </div>\";i:3;s:5:\"utf-8\";i:4;a:0:{}i:5;a:2:{i:0;O:37:\"Symfony\\Component\\Mime\\Header\\Headers\":2:{s:46:\"\0Symfony\\Component\\Mime\\Header\\Headers\0headers\";a:3:{s:4:\"from\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:4:\"From\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:24:\"contact@openstreetmap.fr\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}s:2:\"to\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:2:\"To\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:34:\"contact+send_email@cipherbliss.com\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}s:7:\"subject\";a:1:{i:0;O:48:\"Symfony\\Component\\Mime\\Header\\UnstructuredHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:7:\"Subject\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:55:\"\0Symfony\\Component\\Mime\\Header\\UnstructuredHeader\0value\";s:72:\"Mise à jour des informations de votre établissement dans OpenStreetMap\";}}}s:49:\"\0Symfony\\Component\\Mime\\Header\\Headers\0lineLength\";i:76;}i:1;N;}}s:61:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0envelope\";N;}}
    """
  "[]"
  "default"
  "2026-02-01 07:02:19"
  "2026-02-01 07:02:19"
]
8 3.79 ms
"COMMIT"
Parameters:
[]
9 0.14 ms
"START TRANSACTION"
Parameters:
[]
10 0.26 ms
UPDATE place SET last_contact_attempt_date = ? WHERE id = ?
Parameters:
[
  "2026-02-01 07:02:19"
  801683
]
11 3.40 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Place 1
App\Entity\Stats 1
App\Entity\ActionLog 1

Entities Mapping

Class Mapping errors
App\Entity\Place No errors.
App\Entity\Stats No errors.
App\Entity\History No errors.
App\Entity\ActionLog No errors.