Query Metrics
5
Database Queries
5
Different statements
5.06 ms
Query time
0
Invalid entities
3
Managed entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.67 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:
[
1690593
]
|
||||||||||||||||||||||||||||
2 | 0.23 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||
3 | 0.55 ms |
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "admin_show_commerce_form_id" "{"id":1690593,"name":"XEFI Limoges-SUD","code_insee":87000,"uuid":"2179cd53-c94a-471a-96d9-035cb2bdeb08"}" "2025-07-01 19:28:00" null null ]
|
||||||||||||||||||||||||||||
4 | 0.41 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[ "6220435600" 1690593 ]
|
||||||||||||||||||||||||||||
5 | 3.20 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. |