Query Metrics
12
Database Queries
5
Different statements
6.59 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.94 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM type t0_
Parameters:
[] |
| 2 | 0.37 ms |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM property p0_
Parameters:
[] |
| 3 | 0.30 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.title AS title_1 FROM property p0_ ORDER BY p0_.title ASC LIMIT 8
Parameters:
[] |
| 4 | 0.47 ms |
SELECT p0_.id AS id_0, p0_.updated_at AS updated_at_1, p0_.title AS title_2, p0_.description AS description_3, p0_.surface AS surface_4, p0_.rooms AS rooms_5, p0_.bedrooms AS bedrooms_6, p0_.floor AS floor_7, p0_.price AS price_8, p0_.heating AS heating_9, p0_.city AS city_10, p0_.address AS address_11, p0_.postal_code AS postal_code_12, p0_.sold AS sold_13, p0_.created_at AS created_at_14, p0_.lat AS lat_15, p0_.lng AS lng_16, p0_.bathrooms AS bathrooms_17, p0_.terrace_garden AS terrace_garden_18, p0_.terrace_surface AS terrace_surface_19, p0_.garden_surface AS garden_surface_20, p0_.energy_label AS energy_label_21, p0_.parcel_score AS parcel_score_22, p0_.building_score AS building_score_23, p0_.zone AS zone_24, p0_.pdf_filename AS pdf_filename_25, p0_.pdf_size AS pdf_size_26 FROM property p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.title ASC
Parameters:
[ 28 29 2 3 30 4 5 6 ] |
| 5 | 1.21 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.property_id AS property_id_3 FROM picture t0 WHERE t0.property_id = ?
Parameters:
[
28
]
|
| 6 | 0.76 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.property_id AS property_id_3 FROM picture t0 WHERE t0.property_id = ?
Parameters:
[
29
]
|
| 7 | 0.38 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.property_id AS property_id_3 FROM picture t0 WHERE t0.property_id = ?
Parameters:
[
2
]
|
| 8 | 0.35 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.property_id AS property_id_3 FROM picture t0 WHERE t0.property_id = ?
Parameters:
[
3
]
|
| 9 | 0.36 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.property_id AS property_id_3 FROM picture t0 WHERE t0.property_id = ?
Parameters:
[
30
]
|
| 10 | 0.32 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.property_id AS property_id_3 FROM picture t0 WHERE t0.property_id = ?
Parameters:
[
4
]
|
| 11 | 0.49 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.property_id AS property_id_3 FROM picture t0 WHERE t0.property_id = ?
Parameters:
[
5
]
|
| 12 | 0.65 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.property_id AS property_id_3 FROM picture t0 WHERE t0.property_id = ?
Parameters:
[
6
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Type | No errors. |
| App\Entity\Property | No errors. |
| App\Entity\Option | No errors. |
| App\Entity\Picture | No errors. |