GET https://break-dev.com/app/message/host/cancel/15

Query Metrics

3 Database Queries
2 Different statements
1.65 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.73 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.date_insert AS date_insert_4, t0.stripe_account_id AS stripe_account_id_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.phone AS phone_7, t0.fname AS fname_8, t0.lname AS lname_9, t0.date_of_birth AS date_of_birth_10, t0.gender AS gender_11, t0.nationality AS nationality_12, t0.usual_name AS usual_name_13, t0.veriff_status AS veriff_status_14, t0.profile_presentation AS profile_presentation_15, t0.profile_airbnb AS profile_airbnb_16, t0.profile_linkedin AS profile_linkedin_17, t0.profile_facebook AS profile_facebook_18, t0.profile_instagram AS profile_instagram_19, t0.profile_photo AS profile_photo_20, t0.profile_city AS profile_city_21, t0.profile_country AS profile_country_22, t0.profile_airbnb_score AS profile_airbnb_score_23, t0.profile_airbnb_ratings AS profile_airbnb_ratings_24, t0.profile_airbnb_last_crawl AS profile_airbnb_last_crawl_25, t0.seed AS seed_26, t0.email_status AS email_status_27, t0.pending_email AS pending_email_28 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  2
]
2 0.54 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.date_checkin AS date_checkin_3, t0.date_checkout AS date_checkout_4, t0.date_insert AS date_insert_5, t0.pricing AS pricing_6, t0.date_confirmation AS date_confirmation_7, t0.cancellation_policy AS cancellation_policy_8, t0.guest_adults AS guest_adults_9, t0.guest_children AS guest_children_10, t0.date_checkin_mod AS date_checkin_mod_11, t0.date_checkout_mod AS date_checkout_mod_12, t0.guest_adults_mod AS guest_adults_mod_13, t0.guest_children_mod AS guest_children_mod_14, t0.date_mod AS date_mod_15, t0.pricing_mod AS pricing_mod_16, t0.pricing_confirmed AS pricing_confirmed_17, t0.guest_id AS guest_id_18, t0.host_id AS host_id_19, t0.listing_id AS listing_id_20 FROM booking t0 WHERE t0.id = ? AND t0.host_id = ? LIMIT 1
Parameters:
[
  15
  2
]
3 0.38 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.date_insert AS date_insert_4, t0.stripe_account_id AS stripe_account_id_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.phone AS phone_7, t0.fname AS fname_8, t0.lname AS lname_9, t0.date_of_birth AS date_of_birth_10, t0.gender AS gender_11, t0.nationality AS nationality_12, t0.usual_name AS usual_name_13, t0.veriff_status AS veriff_status_14, t0.profile_presentation AS profile_presentation_15, t0.profile_airbnb AS profile_airbnb_16, t0.profile_linkedin AS profile_linkedin_17, t0.profile_facebook AS profile_facebook_18, t0.profile_instagram AS profile_instagram_19, t0.profile_photo AS profile_photo_20, t0.profile_city AS profile_city_21, t0.profile_country AS profile_country_22, t0.profile_airbnb_score AS profile_airbnb_score_23, t0.profile_airbnb_ratings AS profile_airbnb_ratings_24, t0.profile_airbnb_last_crawl AS profile_airbnb_last_crawl_25, t0.seed AS seed_26, t0.email_status AS email_status_27, t0.pending_email AS pending_email_28 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  4
]

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\User No errors.
App\Entity\Booking No errors.
App\Entity\Listing
  • The field App\Entity\Listing#photos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ListingPhoto#listing does not contain the required 'inversedBy="photos"' attribute.
App\Entity\BookingTransaction No errors.