Query Metrics
5
Database Queries
5
Different statements
1.09 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.30 ms (27.89%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.icon AS icon_2 FROM property_amenity p0_
Parameters:
[] |
0.29 ms (27.08%) |
1 |
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" ] |
0.20 ms (18.78%) |
1 |
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" ] |
0.15 ms (14.17%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.icon AS icon_2 FROM property_category p0_
Parameters:
[] |
0.13 ms (12.08%) |
1 |
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. |