Query Metrics
11
Database Queries
2
Different statements
3.46 ms
Query time
0
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.40 ms |
SELECT d0_.id AS id_0, d0_.query AS query_1, d0_.email AS email_2, d0_.insee AS insee_3, d0_.created_at AS created_at_4, d0_.status AS status_5, d0_.place_uuid AS place_uuid_6, d0_.last_contact_attempt AS last_contact_attempt_7, d0_.osm_object_type AS osm_object_type_8, d0_.osm_id AS osm_id_9, d0_.place_id AS place_id_10 FROM demande d0_ WHERE d0_.status = ? ORDER BY d0_.created_at DESC
Parameters:
[
"email_opened"
]
|
||||||||||||||||||||||||||||
| 2 | 0.32 ms |
SELECT d0_.id AS id_0, d0_.query AS query_1, d0_.email AS email_2, d0_.insee AS insee_3, d0_.created_at AS created_at_4, d0_.status AS status_5, d0_.place_uuid AS place_uuid_6, d0_.last_contact_attempt AS last_contact_attempt_7, d0_.osm_object_type AS osm_object_type_8, d0_.osm_id AS osm_id_9, d0_.place_id AS place_id_10 FROM demande d0_ WHERE d0_.status = ? ORDER BY d0_.created_at DESC
Parameters:
[
"new"
]
|
||||||||||||||||||||||||||||
| 3 | 0.32 ms |
SELECT d0_.id AS id_0, d0_.query AS query_1, d0_.email AS email_2, d0_.insee AS insee_3, d0_.created_at AS created_at_4, d0_.status AS status_5, d0_.place_uuid AS place_uuid_6, d0_.last_contact_attempt AS last_contact_attempt_7, d0_.osm_object_type AS osm_object_type_8, d0_.osm_id AS osm_id_9, d0_.place_id AS place_id_10 FROM demande d0_ WHERE d0_.status = ? ORDER BY d0_.created_at DESC
Parameters:
[
"email_provided"
]
|
||||||||||||||||||||||||||||
| 4 | 0.28 ms |
SELECT d0_.id AS id_0, d0_.query AS query_1, d0_.email AS email_2, d0_.insee AS insee_3, d0_.created_at AS created_at_4, d0_.status AS status_5, d0_.place_uuid AS place_uuid_6, d0_.last_contact_attempt AS last_contact_attempt_7, d0_.osm_object_type AS osm_object_type_8, d0_.osm_id AS osm_id_9, d0_.place_id AS place_id_10 FROM demande d0_ WHERE d0_.status = ? ORDER BY d0_.created_at DESC
Parameters:
[
"ready"
]
|
||||||||||||||||||||||||||||
| 5 | 0.27 ms |
SELECT d0_.id AS id_0, d0_.query AS query_1, d0_.email AS email_2, d0_.insee AS insee_3, d0_.created_at AS created_at_4, d0_.status AS status_5, d0_.place_uuid AS place_uuid_6, d0_.last_contact_attempt AS last_contact_attempt_7, d0_.osm_object_type AS osm_object_type_8, d0_.osm_id AS osm_id_9, d0_.place_id AS place_id_10 FROM demande d0_ WHERE d0_.status = ? ORDER BY d0_.created_at DESC
Parameters:
[
"email_sent"
]
|
||||||||||||||||||||||||||||
| 6 | 0.34 ms |
SELECT d0_.id AS id_0, d0_.query AS query_1, d0_.email AS email_2, d0_.insee AS insee_3, d0_.created_at AS created_at_4, d0_.status AS status_5, d0_.place_uuid AS place_uuid_6, d0_.last_contact_attempt AS last_contact_attempt_7, d0_.osm_object_type AS osm_object_type_8, d0_.osm_id AS osm_id_9, d0_.place_id AS place_id_10 FROM demande d0_ WHERE d0_.status = ? ORDER BY d0_.created_at DESC
Parameters:
[
"email_failed"
]
|
||||||||||||||||||||||||||||
| 7 | 0.32 ms |
SELECT d0_.id AS id_0, d0_.query AS query_1, d0_.email AS email_2, d0_.insee AS insee_3, d0_.created_at AS created_at_4, d0_.status AS status_5, d0_.place_uuid AS place_uuid_6, d0_.last_contact_attempt AS last_contact_attempt_7, d0_.osm_object_type AS osm_object_type_8, d0_.osm_id AS osm_id_9, d0_.place_id AS place_id_10 FROM demande d0_ WHERE d0_.status = ? ORDER BY d0_.created_at DESC
Parameters:
[
"email_opened"
]
|
||||||||||||||||||||||||||||
| 8 | 0.34 ms |
SELECT d0_.id AS id_0, d0_.query AS query_1, d0_.email AS email_2, d0_.insee AS insee_3, d0_.created_at AS created_at_4, d0_.status AS status_5, d0_.place_uuid AS place_uuid_6, d0_.last_contact_attempt AS last_contact_attempt_7, d0_.osm_object_type AS osm_object_type_8, d0_.osm_id AS osm_id_9, d0_.place_id AS place_id_10 FROM demande d0_ WHERE d0_.status = ? ORDER BY d0_.created_at DESC
Parameters:
[
"edit_form_opened"
]
|
||||||||||||||||||||||||||||
| 9 | 0.31 ms |
SELECT d0_.id AS id_0, d0_.query AS query_1, d0_.email AS email_2, d0_.insee AS insee_3, d0_.created_at AS created_at_4, d0_.status AS status_5, d0_.place_uuid AS place_uuid_6, d0_.last_contact_attempt AS last_contact_attempt_7, d0_.osm_object_type AS osm_object_type_8, d0_.osm_id AS osm_id_9, d0_.place_id AS place_id_10 FROM demande d0_ WHERE d0_.status = ? ORDER BY d0_.created_at DESC
Parameters:
[
"place_modified"
]
|
||||||||||||||||||||||||||||
| 10 | 0.30 ms |
SELECT d0_.id AS id_0, d0_.query AS query_1, d0_.email AS email_2, d0_.insee AS insee_3, d0_.created_at AS created_at_4, d0_.status AS status_5, d0_.place_uuid AS place_uuid_6, d0_.last_contact_attempt AS last_contact_attempt_7, d0_.osm_object_type AS osm_object_type_8, d0_.osm_id AS osm_id_9, d0_.place_id AS place_id_10 FROM demande d0_ WHERE d0_.status = ? ORDER BY d0_.created_at DESC
Parameters:
[
"linked_to_place"
]
|
||||||||||||||||||||||||||||
| 11 | 0.26 ms |
SELECT d0_.id AS id_0, d0_.query AS query_1, d0_.email AS email_2, d0_.insee AS insee_3, d0_.created_at AS created_at_4, d0_.status AS status_5, d0_.place_uuid AS place_uuid_6, d0_.last_contact_attempt AS last_contact_attempt_7, d0_.osm_object_type AS osm_object_type_8, d0_.osm_id AS osm_id_9, d0_.place_id AS place_id_10 FROM demande d0_ ORDER BY d0_.created_at DESC
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\Demande | 5 |
| App\Entity\Place | 4 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Demande | No errors. |
| App\Entity\Place | No errors. |