Query Metrics
1
Database Queries
1
Different statements
17.44 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 17.44 ms |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.heading AS heading_2, p0_.price AS price_3, p1_.name AS name_4, p0_.area AS area_5, p0_.land AS land_6, p0_.address AS address_7, p0_.city AS city_8, p0_.description AS description_9, p0_.image_primary AS image_primary_10, i2_.image AS image_11, t3_.name AS name_12, r4_.name AS name_13, t5_.name AS name_14, s6_.name AS name_15, s6_.typecolor AS typecolor_16, s6_.typebackground AS typebackground_17, r7_.name AS name_18 FROM property p0_ LEFT JOIN image_property i2_ ON p0_.id = i2_.property_id LEFT JOIN TYPE t3_ ON p0_.type_id = t3_.id LEFT JOIN regions r4_ ON p0_.regions_id = r4_.id LEFT JOIN price_type p1_ ON p0_.price_type_id = p1_.id LEFT JOIN transactions t5_ ON p0_.transactions_id = t5_.id LEFT JOIN STATUS s6_ ON p0_.status_id = s6_.id LEFT JOIN room r7_ ON p0_.room_id = r7_.id WHERE p0_.published = ?
Parameters:
[
1
]
|
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\Property | No errors. |
App\Entity\ImageProperty | No errors. |
App\Entity\Type | No errors. |
App\Entity\Regions | No errors. |
App\Entity\PriceType | No errors. |
App\Entity\Transactions | No errors. |
App\Entity\Status | No errors. |
App\Entity\Room | No errors. |