Query Metrics
1
Database Queries
1
Different statements
5.73 ms
Query time
3
Invalid entities
7
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 5.73 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.price AS price_4, t0.charge AS charge_5, t0.deposit AS deposit_6, t0.address AS address_7, t0.floor_area AS floor_area_8, t0.floor AS floor_9, t0.floors_of_property AS floors_of_property_10, t0.energy_class AS energy_class_11, t0.activities_nearby AS activities_nearby_12, t0.date_of_expiration AS date_of_expiration_13, t0.contact AS contact_14, t0.page_type AS page_type_15, t0.keywords AS keywords_16, t0.description AS description_17, t0.latitude AS latitude_18, t0.longitude AS longitude_19, t0.seo_title AS seo_title_20, t0.seo_description AS seo_description_21, t0.land_size AS land_size_22, t0.balcony_area AS balcony_area_23, t0.video AS video_24, t0.vrtour AS vrtour_25, t0.is_admin AS is_admin_26, t0.is_visible AS is_visible_27, t0.uniqid AS uniqid_28, t0.ip_address AS ip_address_29, t0.date_created AS date_created_30, t0.external_url AS external_url_31, t0.approved AS approved_32, t0.deleted_by_user AS deleted_by_user_33, t0.draft AS draft_34, t0.deleted_from_external AS deleted_from_external_35, t0.last_check AS last_check_36, t0.contact_disabled AS contact_disabled_37, t0.property_type_id AS property_type_id_38, t0.advertisement_type_id AS advertisement_type_id_39, t0.user_id AS user_id_40, t0.advertisement_status_id AS advertisement_status_id_41, t0.offering_type_id AS offering_type_id_42, t0.building_type_id AS building_type_id_43, t0.building_materials_id AS building_materials_id_44, t0.property_equipment_description_id AS property_equipment_description_id_45, t0.property_time_of_rent_id AS property_time_of_rent_id_46, t0.heating_id AS heating_id_47, t0.land_type_id AS land_type_id_48, t0.type_of_ownership_id AS type_of_ownership_id_49, t0.floor_in_house_id AS floor_in_house_id_50, t0.world_orientation_id AS world_orientation_id_51, t0.property_condition_id AS property_condition_id_52, t0.property_age_id AS property_age_id_53, t0.visibility_id AS visibility_id_54, t0.city_id AS city_id_55, t0.category_id AS category_id_56 FROM advertisement t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"sale-cottage-cottage-undefined-pardubice"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Advertisement | 1 |
| App\Entity\PropertyType | 1 |
| App\Entity\AdvertisementType | 1 |
| App\Entity\User | 1 |
| App\Entity\AdvertisementStatus | 1 |
| App\Entity\TypeOfOwnership | 1 |
| App\Entity\City | 1 |