Query Metrics
3
Database Queries
3
Different statements
8.16 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 7.64 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.type AS type_4, t0.type_location AS type_location_5, t0.adress AS adress_6, t0.city AS city_7, t0.province AS province_8, t0.country AS country_9, t0.status AS status_10, t0.image AS image_11, t0.bedroom AS bedroom_12, t0.bathroom AS bathroom_13, t0.price AS price_14, t0.currency AS currency_15, t0.publish AS publish_16, t0.uuid AS uuid_17, t0.registration_step AS registration_step_18, t0.guests AS guests_19, t0.livingroom AS livingroom_20, t0.periodicity AS periodicity_21, t0.postal_code AS postal_code_22, t0.appartement_number AS appartement_number_23, t0.uuid_property AS uuid_property_24, t0.publish_at AS publish_at_25, t0.address_view AS address_view_26, t0.furniture AS furniture_27, t0.air_condition AS air_condition_28, t0.pool AS pool_29, t0.openspaceroof AS openspaceroof_30, t0.exteriortoilet AS exteriortoilet_31, t0.securityguard AS securityguard_32, t0.garden AS garden_33, t0.wifi AS wifi_34, t0.parking AS parking_35, t0.unpublish_at AS unpublish_at_36, t0.header AS header_37, t0.pourcerntage_of_booking AS pourcerntage_of_booking_38, t0.price_of_visit AS price_of_visit_39, t0.surface_area AS surface_area_40, t0.relationship_to_property AS relationship_to_property_41, t0.views AS views_42, t0.for_agency AS for_agency_43, t0.cloudpano_tour_url AS cloudpano_tour_url_44, t0.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.user_id AS user_id_47, t0.property_province_id AS property_province_id_48, t0.property_country_id AS property_country_id_49, t0.commune_id AS commune_id_50, t0.property_status_id AS property_status_id_51, t0.category_id AS category_id_52, t0.agency_id AS agency_id_53 FROM property t0 WHERE t0.uuid_property = ? LIMIT 1
Parameters:
[
"019c0a8a-e134-753e-8833-0b1708aaa194"
]
|
||||||||||||||||||||||
| 2 | 0.37 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.check_in AS check_in_3, t0.check_out AS check_out_4, t0.total_amount AS total_amount_5, t0.status AS status_6, t0.duration AS duration_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.phone AS phone_10, t0.comments AS comments_11, t0.email AS email_12, t0.amount_to_pay AS amount_to_pay_13, t0.payement_type AS payement_type_14, t0.confirmed AS confirmed_15, t0.date_in AS date_in_16, t0.date_out AS date_out_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.property_id AS property_id_20, t0.user_id AS user_id_21 FROM reservation t0 WHERE t0.property_id IS NULL AND t0.confirmed = ?
Parameters:
[
1
]
|
||||||||||||||||||||||
| 3 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_url AS image_url_3, t0.status AS status_4, t0.property_id AS property_id_5 FROM images t0 WHERE t0.property_id IS NULL ORDER BY t0.id ASC
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\User |
|
| App\Entity\Province | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\PropertyStatus | No errors. |
| App\Entity\CategoryForProperty | No errors. |
| App\Entity\Agency | No errors. |
| App\Entity\Reservation |
|
| App\Entity\Images | No errors. |