Query Metrics
5
Database Queries
5
Different statements
1.09 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.30 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.icon AS icon_2 FROM property_amenity p0_
Parameters:
[] |
2 | 0.29 ms |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM property p0_ WHERE p0_.is_active = 1 AND p0_.offer_status NOT IN (?, ?)
Parameters:
[ "A" "N" ] |
3 | 0.20 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1 FROM property p0_ WHERE p0_.is_active = 1 AND p0_.offer_status NOT IN (?, ?) ORDER BY p0_.created_at DESC LIMIT 12
Parameters:
[ "A" "N" ] |
4 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.icon AS icon_2 FROM property_category p0_
Parameters:
[] |
5 | 0.13 ms |
SELECT o0_.id AS id_0, o0_.name AS name_1 FROM offer_type o0_
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Property | No errors. |
App\Entity\PropertyCategory | No errors. |
App\Entity\OfferType | No errors. |
App\Entity\PropertyAmenity | No errors. |