Query Metrics
3
Database Queries
3
Different statements
3.76 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2.37 ms (62.97%) |
1 |
SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.description AS description_2, p0_.area AS area_3, p0_.price AS price_4, p0_.image_primary AS image_primary_5, p0_.longitude AS longitude_6, p0_.latitude AS latitude_7, p0_.city AS city_8, i1_.image AS image_9, r2_.name AS name_10, t3_.name AS name_11 FROM property p0_ LEFT JOIN image_property i1_ ON p0_.id = i1_.property_id LEFT JOIN regions r2_ ON p0_.regions_id = r2_.id LEFT JOIN transactions t3_ ON p0_.transactions_id = t3_.id WHERE p0_.published = ? AND p0_.special_offer = ?
Parameters:
[ 1 1 ]
|
||||||||||||||||||||||||||||
0.89 ms (23.69%) |
1 |
SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.price AS price_2, p0_.area AS area_3, p0_.city AS city_4, p0_.image_primary AS image_primary_5, t1_.name AS name_6, r2_.name AS name_7, t3_.name AS name_8, p4_.name AS name_9, s5_.name AS name_10, s5_.typecolor AS typecolor_11, s5_.typebackground AS typebackground_12 FROM property p0_ LEFT JOIN TYPE t1_ ON p0_.type_id = t1_.id LEFT JOIN room r2_ ON p0_.room_id = r2_.id LEFT JOIN transactions t3_ ON p0_.transactions_id = t3_.id LEFT JOIN price_type p4_ ON p0_.price_type_id = p4_.id LEFT JOIN STATUS s5_ ON p0_.status_id = s5_.id WHERE p0_.published = ? ORDER BY p0_.id DESC LIMIT 4
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
0.50 ms (13.34%) |
1 |
SELECT n0_.id AS id_0, n0_.title AS title_1 FROM news n0_ WHERE n0_.published = ? ORDER BY n0_.id DESC LIMIT 5
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\Regions | No errors. |
App\Entity\Transactions | No errors. |
App\Entity\Type | No errors. |
App\Entity\Room | No errors. |
App\Entity\PriceType | No errors. |
App\Entity\Status | No errors. |
App\Entity\News | No errors. |