Query Metrics
3
Database Queries
3
Different statements
3.61 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.88 ms |
SELECT p0_.id AS id_0, p0_.api_id AS api_id_1, p0_.agency_name AS agency_name_2, p0_.agency_reference AS agency_reference_3, p0_.lastupdate AS lastupdate_4, p0_.status_id AS status_id_5, p0_.reference AS reference_6, p0_.name AS name_7, p0_.adresse AS adresse_8, p0_.price AS price_9, p0_.surface AS surface_10, p0_.rooms AS rooms_11, p0_.bathrooms AS bathrooms_12, p0_.showerrooms AS showerrooms_13, p0_.bedrooms AS bedrooms_14, p0_.floor AS floor_15, p0_.description AS description_16, p0_.promotion_id AS promotion_id_17, p0_.transaction_type AS transaction_type_18, p0_.enabled AS enabled_19, p0_.featured AS featured_20, p0_.type_property AS type_property_21, p0_.longitude AS longitude_22, p0_.latitude AS latitude_23, p0_.zip AS zip_24, p0_.videos_object AS videos_object_25, p0_.visit3ds_object AS visit3ds_object_26, p0_.disponibilite_date AS disponibilite_date_27, p0_.status AS status_28, p0_.country_fr AS country_fr_29, p0_.district_fr AS district_fr_30, p0_.canton_fr AS canton_fr_31, p0_.quarter_fr AS quarter_fr_32, p0_.zone_fr AS zone_fr_33, p0_.city_fr AS city_fr_34, p0_.disponible_fr AS disponible_fr_35, p0_.broker_id AS broker_id_36, p0_.country_id AS country_id_37, p0_.canton_id AS canton_id_38, p0_.district_id AS district_id_39, p0_.quarter_id AS quarter_id_40, p0_.zone_id AS zone_id_41, p0_.city_id AS city_id_42, p0_.type_id AS type_id_43, p0_.disponible_id AS disponible_id_44 FROM property p0_ INNER JOIN type t1_ ON p0_.type_id = t1_.id WHERE p0_.transaction_type = ? ORDER BY p0_.id DESC
Parameters:
[
1
]
|
2 | 0.77 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.periorite AS periorite_4 FROM type t0 WHERE t0.id = ?
Parameters:
[
5
]
|
3 | 0.96 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.ref AS ref_4, t0.ordre AS ordre_5, t0.property_id AS property_id_6, t0.broker_id AS broker_id_7 FROM photo t0 WHERE t0.property_id = ?
Parameters:
[
136
]
|
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 |
---|---|
Sulu\Bundle\SecurityBundle\Entity\Group | No errors. |
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem | No errors. |
Sulu\Bundle\MediaBundle\Entity\Collection | No errors. |
Sulu\Bundle\ContactBundle\Entity\ContactTitle | No errors. |
App\Entity\Type | No errors. |
App\Entity\CantonSearch | No errors. |
App\Entity\DistrictSearch | No errors. |
App\Entity\VilleSearch | No errors. |
App\Entity\ZoneSearch | No errors. |
App\Entity\Property | No errors. |
App\Entity\Broker | No errors. |
App\Entity\Country | No errors. |
App\Entity\Canton | No errors. |
App\Entity\District | No errors. |
App\Entity\Quarter | No errors. |
App\Entity\Zone | No errors. |
App\Entity\City | No errors. |
App\Entity\Choice | No errors. |
App\Entity\Photo | No errors. |
App\Entity\Distance | No errors. |